I am trying to create a user administration section and I want to use a subroutine that connects to a database, runs a query, returns a result and then closes the database connection. Then I would like to be able to access this result e.g a COUNT of fields in a table, in other pages.
Is this possible using Subroutines, if so how, and what other ways do you guys use code reuse in ASP?
In global.asa I have some code outside all the Subs.
I have some confirmation that it is being executed OnStart.
Yet I can's see if it is executed OnEnd.
The literature I have says that OnEnd the Sub Application_OnEnd is executed,
but is does not say that anything else is executed
Actually I even can't understand if global.asa is permited to have any code
outside the Subs Could someone comment on this?
So, when my search returns the result I need one of the fields to be clickable and show the customer's info for the clicked customer.So, lets say we make the ID clickable.
So, my HTML has to look like:Code:
<input type = "submit" value="sqlrs("ID")">
How do I construct that in ASP since, using " in strings ends it and same with Response.write methods.
I am creating student website and wants to create some featuer like if user come on my side and type his/her student id in provided SEARCH FIELD [TEXT BOX] that page will display perticular information of that user but before that it will ask for login name and password as well. I am making my website in XHTML [front end], JAVA SCRIPT[validation], ASP [server coding], IIS server.
View Replies View RelatedI have two tables, Advertisers and Ads. There is a one to many relationship from Advertisers to Ads.
I want a listing of Advertisers that haven't placed any Ads. I'm having a mental block on writing the SQL to pull that data. Any ideas.
response.write "<td style='background-color:#FFFFFF;'><% if objRs('ThumbImageURL') <> '' then %>"
View Replies View RelatedHow do I write the code for a button that will call a function/procedure in ASP and delete all records in an array? Should I use a function or procedure? Anyone who would like to finish this code? Code:
View Replies View RelatedI am trying to get a page that loads up a different include file depending on which input form button was clicked.
I can get it to work with just one if statement but once I put a second if statement in I get the following error
Quote: Error Type:
Microsoft VBScript compilation (0x800A03F6)
Expected 'End'
/ordersearch/ordersearchresults.asp, line 27
Now no matter where I have though of putting my end if the page now doesn�t work. Does anyone know of the solution??? Code:
I want to have a list of links on my ASP page that call specific info from different subs on the page into a <div>. So I'd have a menu-like list on the left, say:
LINK 1
LINK 2
LINK 3
so LINK 1 would call and display the info from the sub called, say, "link1", and LINK 2 would call and display info from the sub "link2", etc.
then on the right would be the <div> to contain the requested info from the sub.
Any suggestions? I've trawled the net for answers but when you don't really get the terminoligy, etc, its very hard to know what you're looking for!
I have created several functions and subs in both VB and Java. How can I put
these into a file to be called by different pages.
is it possible to call ASP subs, files, functions, etc. from Javascript commands? I want to have a setup of various buttons where clicking on a button would call an ASP sub to grab info from a db.
I'm looking for sample code that will require a use to enter a code from a scued image format.
I'm sure you've seen them before where the image is barely readable by a human and the user has to enter the code correctly to submit the form.
I'm looking for ASP code and NOT ASP.NET code as I am supporting a legacy site.
I have 2 MS Access databases DB1.mdb and DB2.mdb.
In DB1.mdb there is a table named table1 and in DB2.mdb there is a table named table2.
How do I write query in ASP to write the records from table1 in DB1.mdb to table2 in DB2.mdb.
i am having a problem with ASP not doing the requestion action of Response.Write based on conditions of a code entered on a first page. The codes are below. I made the second page from template of another that yall helped me with and it aint working.. Code:
View Replies View RelatedWas curious if someone could help me out. I'm setting up a website and using Server side includes to make it easier for maintaining. I've got a contact form that will be included on several pages and I need to know from what page the forms is getting posted from. If I can figure out how to pass one value to a hidden field I can use the form as an include instead of hard coding the whole form into each page.
Ideally the value to be passed could be coded into each page then asp could pick it up and insert it into the hidden field. Any one point me in the right direction for accomplishing this. I don't have a clue about asp other than the basic include statement.
I select 'name' from the customer table.
Is it possible to write it into a cookie?
<%
Response.Cookies("customer")("firstname") = '" & objRecordset(NAME) & "'
%>
when I try to write the above using
<%
Response.Write (Request.Cookies("customer")("firstname"))
%>
i get the following ....
May i know isit can use asp to send an automail when customer fill up the registration form. i need to send a automail to his email verify the customer details. is it any free source code to write?
View Replies View RelatedI writing code that will create asp pages using the file system object.
<%
..
..
'other code here
Response.Write "<%sName=" & Var & "%>"
%>
How can I do this?
If my recordset is empty I want to write "Not Complete" and if there is
a value, I want to write the value. Can someone tell me what I am
doing wrong?
<%
If IsEmpty(rsa.Fields.Item("reclaima")) Then
Response.Write("Not Complete")
Else
Response.Write(rsa.Fields.Item("reclaima"))
End If
%>
Also tried....
<%
If rsa.Fields.Item("reclaima") = "" Then
Response.Write("Not Complete")
Else
Response.Write(rsa.Fields.Item("reclaima"))
End If
%>
Since ASP server scripts use VBScript by default, does it mean it is
redundant to put the following in ASP page? Then when do we need to use
this? In client-side VBScript?
I have a script in ASP:
If strReport = "OrderDetail" then
strReport1 = strReport & ".rpt"
End If
If strReport1 <> "" Then
strReport1 = strReport & Year(strPeriod) & ".rpt"
End If
Now based on the kind of value in strReport1, I would like to do 2 different set of work.... Like for instance,
If strReport = "OrderDetail" then
call SubReportDB
End If
If strReport1 <> "" Then
Call SubOrderDetail
End If
Is that the right syntax?
While doing a response.Write,
I would like to display the text as array item wrapped in quotes. How can I do that?
I write the code as:
'Now get all the sub-reports names to pass the log-on information
For i = 0 to UBound(aSubRpt,2)
Response.Write "webSource0.AddParameter " & u0 & " & " & aSubRpt(c_SRName,i) & ", " & dbd & "<br>"
Response.Write "webSource0.AddParameter " & p0 & " & " & aSubRpt(c_SRName,i) & ", " & dbc & "<br>"
'Response.Write aSubRpt(c_SRName,i) & "<br>"
Next
While seeing the results in the browser, I would like to see
"aSubRpt(c_SRName,i)"
which is primarily
"reportname"
How can I wrap the text in double quotes within a response.Write?
I want to be able to write a gif in my ASP app. Not even sure if it is possible with response.write. I want to replace the 'Member Log In' text with XXX.gif, and still have it linked to login.asp....
View Replies View RelatedI am trying to retrieve info from database and display it in the form. The problem I having is when I try to change the info in the form, it is not changing and I don't know why.
table.fieldname = payroll
Code:
payroll = rs("payroll")
If payroll = "something" Then
payroll = "Some Payroll"
End If
In the form table:
<input type="text" name="payroll" value=<%response.write(payroll)%>>
I want "Some Payroll" to be displayed in the form instead of "Something".
I need to put this whole line into a response.write statement:
field delimiter = """
Code:
<%
username = Session("username")
if ("" = username) Then
Response.redirect "login.asp"
response.Write("Sorry, you are not logged in.")
response.End
End if
%>
How do i write that Sorry, you are not logged in ... to the login.asp?
I've tried using a FSO to write to it directly. I've even managed to write a script for windows scripting host and invoke it from ASP, using standard output redirection (">") to redirect output to a file with no problems.
However, I can't seem to send writes to LPT2: from ASP, even through the other script.
It works perfectly fine if I invoke the WSH script at a command prompt using precisely the same command line, but when I do it from inside an ASP page, I get nothing.
Are there some permissions for the port I have to set or some such? I honestly have no idea how to get it to work.
If it is relevant, LPT2: is a mapped port for a network printer.
Yes, this is related to my previous thread, but I'm down to a much, much more specific problem.
Why do I get an error on executong the following code:
<body>
<%
Response.Write" <script language = ""vbscript""> "
Response.Write" res = MsgBox (""Do you want to edit appliance?"",4,""Edit Appliance"") "
Response.Write" if res=7 then"
Response.Write" window.location.href= ""Appliance.asp"" "
Response.Write" else"
Response.Write" window.location.href = ""Scenario.asp"" "
Response.Write" end if"
Response.Write" </script>"
%>
What is the right syntax, to make that a hyperlink?
Response.Write("<TD>"<a href=""rst("Kotisivu") & ">" & "</a"> & "</TD>")
I am trying to check for the final sql statement before passing it to a
database. I want to build the statement using user input in three text boxes.
However, the sql statement does not give me the right statement. Instead it
gives the following message:
Error Type:
Request object, ASP 0102 (0x80004005)
The function expects a string as input.
/sailors/loginverification1.asp, line 14
CODE:
<%
strSQL = "select PeopleNameFirst, PeopleNameLast, PeopleClubCode from People
where " & _
"PeopleNameFirst ='" & Request.Form(txtFirstName) & "' AND " & _
"PeopleNameLat ='" & Request.Form(txtLastName) & "' AND " & _
"PeopleClubCode ='" & Request.Form(txtPassword) & "'"
Response.Write strSQL
%>
Does any one know how I can position the output at certain point? Such as If I want to print "hello" starting at position 50 from the left in the file.
View Replies View RelatedHow to use Response.write to Output the following Code:
Type id="1"
I tried this one but not working Code:
Response.Write( "Type id="" & "0" &"")
I am creating html string in a component that transforms xml into html.
Works o.k. with small html strings, but takes forever to response.write
big html strings. Is it possible to speed it up?