I'm trying to creat a registration page. It says I have a Syntax error in INSERT INTO statement and highlights Adapter.Update(CscapeDS, "cscape"). I've tried everything I can think of to fix it. I hope someone here can help.
Printable View
I'm trying to creat a registration page. It says I have a Syntax error in INSERT INTO statement and highlights Adapter.Update(CscapeDS, "cscape"). I've tried everything I can think of to fix it. I hope someone here can help.
I use c#, thats why i didn't understand everything, but i think that the problem is here (only if the "registration_date" is set as DateTime):
Row.Item("registration_date") = Today & " at " & Format(Now, "t")
No it's only a basic text. I didn't want to have to deal with correct formating of the date.
change your Select statement from
SelectStatement = "Select * From cscape Where id=" & IDNumSent
to simply
SelectStatement = "Select * From cscape"
you can debug your application and see what happens when you use first statement and when you use second statement.