Database Update Query

M

Mettá

Can someone tell me what's wrong with the following...

<%
myConnString = Application("DBNAME_ConnectionString")
Set myConnection = Server.CreateObject("ADODB.Connection")
myConnection.Open myConnString
mySQL= "Update Table1 Set
spname='::spname::',ton='::ton::',mess1='::mess1::',valsent='::valsent::'
WHERE ID1='::ID1::' "
myConnection.Execute mySQL
myConnection.Close
Set myConnection = Nothing
%>


It's in a FP2003 site, was working in a DRW but now fails so I thought I
would create a manual update but am not getting very far
Thanks
M
 
R

Ronx

Is ID1 a numeric field?
If so, then

mySQL= "Update Table1 Set
spname='" & request("spname") & "',ton='" & request("ton") &
"',mess1='" & request("mess1") & "',valsent='" & request("valsent") &
"'
WHERE ID1=" & request("ID1")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to update db without using drw beyond access db import 8
SQL update statement in excel vba 4
Insert into SQl table 1
ODBC Connection to Oracle using ASP and ASPX 0
MySQL: UPDATE not working 5
Unable to insert record to Access via SQL from an ASP page 2
Inset into SQL 1
What is wrong with this SQL Update Code? 3

Top