|
| |
ASP UPDATE. need help---error '800a01c2' Wrong number of arguments or invalid property assignment
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
watle
Posts: 6
Joined: 6/29/2009
Status: offline
 |
ASP UPDATE. need help---error '800a01c2' Wrong number... - 7/4/2009 10:05:16
my asp data don´t work, when i tried to update.
Thx
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment
/rboggs/wu/wu006/assignment/asp_update.asp, line 239
//Update Statement
sql = "UPDATE registration SET Firstname = '" & firstname & "', Lastname = '" & lastname & "', City = '" & city & "', Street = '" & street & "', PLZ ='" & plz & "', State ='" & state & "', Homephone='"& homephone & "', Cellphone='" & cellphone & "', Age='" & birthdate & "', Gender='" & gender & "', Interested_Prayer='" & prayer & "', Interested_Worship='" & worship_together & "', Interested_Download='" & download & "', Interested_Donation='" & donation & "', Interested_Request='" & request & "', Additional='" & questions & "', Appreciation='" & appreciation & "', Email='" & emailadresse1 & "', WHERE ID = '" & id & "';"
set lrs = conn.Execute(sql)
%>
<h3>Your data was updated sucessfully</h3>
<a href="asp_read.asp" style="color:#FBIFBI;">[<] Back</a>
|
|
|
|
Spooky
Posts: 26681
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: ASP UPDATE. need help---error '800a01c2' Wrong nu... - 7/4/2009 18:21:44
sql = "UPDATE registration SET Firstname = '" & firstname & "', Lastname = '" & lastname & "', City = '" & city & "', Street = '" & street & "', PLZ ='" & plz & "', State ='" & state & "', Homephone='"& homephone & "', Cellphone='" & cellphone & "', Age='" & birthdate & "', Gender='" & gender & "', Interested_Prayer='" & prayer & "', Interested_Worship='" & worship_together & "', Interested_Download='" & download & "', Interested_Donation='" & donation & "', Interested_Request='" & request & "', Additional='" & questions & "', Appreciation='" & appreciation & "', Email='" & emailadresse1 & "', WHERE ID = '" & id & "';"
response.write sql
response.end
What is the SQL string when you view the page?
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
Sp ky
| |
|
|
|
watle
Posts: 6
Joined: 6/29/2009
Status: offline
|
RE: ASP UPDATE. need help---error '800a01c2' Wrong nu... - 7/4/2009 20:05:48
Hi,
i've filled the form-table and i add the code
with <%response.write sql
response.end%>
Result:
UPDATE registration SET Firstname='Patrick', Lastname='Fabolous', City='Frankfurt', Street='Josefschneider', PLZ='98475', State='Bayern', Homephone='0931234857', Cellphone='0171239485904', Age='30', Gender='male', Interested_Prayer='True', Interested_Worship='False', Interested_Download='True', Interested_Donation='True', Interested_Request='True', Additional='test', Appreciation='great', Email='email@address.de', WHERE ID='47';
with <%response.write sql%>
UPDATE registration SET Firstname='Patrick', Lastname='Fabolous', City='Frankfurt', Street='Josefschneider', PLZ='98475', State='Bayern', Homephone='0931234857', Cellphone='0171239485904', Age='30', Gender='male', Interested_Prayer='True', Interested_Worship='False', Interested_Download='True', Interested_Donation='True', Interested_Request='True', Additional='test', Appreciation='great', Email='email@address.de', WHERE ID='47';
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
/rboggs/wu/wu006/assignment/asp_update.asp, line 243
< Message edited by watle -- 7/4/2009 20:16:03 >
| |
|
|
|
watle
Posts: 6
Joined: 6/29/2009
Status: offline
|
RE: ASP UPDATE. need help---error '800a01c2' Wrong nu... - 7/5/2009 15:02:28
Thanks so much,
i move the quotes for numeric columns and the last comma and it works perfectly.
Thanks
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 