How Can I Write This SQL Statement?
I have a table called products, which has the fields productid, productname, description, unitprice, and etc.
I have a list of product ids like productid1, productid2, ..., how can I use sql to build another table called featured products which only holds the productids from the list?
View Replies
ADVERTISEMENT
Trying to do a dynamic list box. I have to use response.write to create it since the number of option values changes. Im trying to make it so when you select something the onchange submits the form to retotal all the values on the page.
Problem Im running into is the if statement to keep the selected value and have it selected after the form submits and reloads. Not going to another page just a general submit.
I have this working on other pages just not with the response.write that is created the list box. Code is below. Im getting a Syntax error on the line with the if then on the option value. Any ideas ? Code:
View Replies
View Related
i have this code that join 2 tables, Reservation and Customer. Next, i wanted to add another table, Staf to get the name of staf that responsibled on a particular reservation. there is a field name staffCode (FK at Reservation table, PK at Staf table) at the Reservation table. Code:
View Replies
View Related
If getting an End of statement error. I know it's something I'm missing and my lack of ASP isn't helping.
Response.Write "<option value='Admin_Game_List.asp?TS=League&LeagueID=" & objRsLeague("ID") & "'>" & objRsLeague("LeagueName") & "</option>"
View Replies
View Related
I need to write a reponse.write statement of the following:
<A HREF="default.htm">Click Here to try again</A>
However, I am not clear about the syntax to handle this.
View Replies
View Related
i want to increase my session time so that it does not expire till the user closes the site.
i have written in global.asa file the following code:
<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
Sub Session_OnStart
Session.Timeout = -1
End Sub
</script>
but it doesnt work and my sesion still expires.
View Replies
View Related
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.
View Replies
View Related
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 Related
Was 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.
View Replies
View Related
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 ....
View Replies
View Related
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 Related
I writing code that will create asp pages using the file system object.
<%
..
..
'other code here
Response.Write "<%sName=" & Var & "%>"
%>
How can I do this?
View Replies
View Related
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
%>
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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 Related
I 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".
View Replies
View Related
I need to put this whole line into a response.write statement:
field delimiter = """
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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>"
%>
View Replies
View Related
What is the right syntax, to make that a hyperlink?
Response.Write("<TD>"<a href=""rst("Kotisivu") & ">" & "</a"> & "</TD>")
View Replies
View Related
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
%>
View Replies
View Related
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 Related
How 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" &"")
View Replies
View Related
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?
View Replies
View Related
I am having trouble trying to output an image using Binary.Write. I have a page which displays a record. One of the fields is an image and I want to display this on the page.
My question is this: Is it possible to use the Binary write command i.e. Binary.Write("MyDatabaseField") on the same page that I want the image displayed on?
If not Is there a way to nest it inside an image tag as follows:
Response.Write("<img src=" & binaryWrite("mydatabasefield" & ">")
View Replies
View Related
I have an asp page created in Dreamweaver with a form that is supposed to write to an Access database. It redirects to a formmail.asp that sends the info to my email. Everything works except the fact that no new info is written/inserted into the database.
I can connect, read, etc, it just doesn't write anything new. I get the email just like I'm supposed to only it has old entries and nothing new. There's nothing new added to the database when I check it. I've tried about everything I can think of. I've checked and double checked that the file can be written to, added all the default users, etc. Moved the file around, recreated the database, etc. I'm using DW 8, Access 2003 and Windows Server 2003. Code:
View Replies
View Related
Now i have this part of the code . below in the code i should not call Sp_Getattachment if the Id = 0
but sme how I am gettin an error if I insert the If statemnt.
This is the part of the code:
View Replies
View Related
I have a specific access db field that holds visitor website url's and I am currently displaying it onto a page as text but instead I need it to be displayed a clickable hyperlink.
The field datatype within access is set to url but when the entry is written to an asp page it doesn't bring the hyperlink properties with it.
I think I should be enclosing the RS within an <a href=''></a> type tag but can't seem to get it right.
Current code: Response.Write RS ("website") & "<BR><BR>"
View Replies
View Related
Example 1 don't work:
title = rs.("title")
response.Write title
' this will show title= "the 100 Club"
SQL2 = "select * from events where (venue = '"&title&"');"
rs2.Open SQl2, Conn
' Either BOF or EOF is True, or the current record has been deleted.
Example 2 it work fine
title = "the 100 Club"
SQL2 = "select * from events where (venue = '"&title&"');"
rs2.Open SQl2, Conn
it work fine, so what I hove done wrong with the first one it seam strait forward..
View Replies
View Related
I'm just getting started in ASP and would like to better understand how to write cookies with ASP.
Most of the examples I've worked through involve collecting user info from a form and then using response.cookies (cookiename)=" some value"
What is the best way to write a cookie to the client if you're not collecting user data from a form?
What information is possible and most useful to obtain from the client if they haven't filled out a form?
View Replies
View Related