asp updating to database

krappleby · Aug 16, 2001

the following script i am using to update records to a Access database,

********************************************

<HTML>

<Head>

<Title>K.R.App web design</Title>

</Head>

<%
set conn = Server.CreateObject("Adodb.connection&quot

conn.Open "customeraccounts.mdb"

query = "UPDATE IPdetails SET Address=" & Request.QueryString("Address&quot

& " WHERE Autonumber= " & Request.QueryString("Autonumber&quot

"

conn.Execute(query)

Response.write "Data updated"
%>

<Body>

</Body>

</HTML>

*****************************************************

the parameters are sent from the previous page, to this one, however, whenever i try to run this script it comes up with, error on page......

any ideas

thanks

FengShui1998 · Aug 16, 2001

krappleby,

In your sql statement, if your variables for querystring have spaces in them, you need to enclose them in quotes.

query = "UPDATE IPdetails SET Address='" & Request.QueryString("Address&quot

& "'"
& " WHERE Autonumber='" & Request.QueryString("Autonumber&quot

& "'"

bassguy · Aug 16, 2001

Yes spaces are evil....

bassguy

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

asp updating to database

krappleby

Programmer

FengShui1998

MIS

bassguy

Programmer

Similar threads

Part and Inventory Search

Sponsor