|
| |
|
|
rikki
Posts: 388
Joined: 4/4/2004
Status: offline
 |
Update leaving space in front of text - 4/23/2008 11:26:37
This update is leaving a space in front of the field. Any ideas why?
Thanks
mySQL = "UPDATE WETASKIWIN1 SET FIRSTNAME = ' " & Request.Form("FIRSTNAME") & " ' , LASTNAME = ' " & Request.Form("LASTNAME") & " ' , [PASSWORD] = ' " & Request.Form("PASSWORD") & " ' WHERE BOOKINGNUMBER = "&Request.Form("BOOKINGNUMBER")&""
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Update leaving space in front of text - 4/23/2008 11:28:58
quote:
...FIRSTNAME = ' " & Request.Form("FIRSTNAME") & " ' , LASTNAME ...
Look closely and you have a space between your apostrophes and quotes. See it? It needs to be 'tighter':
...FIRSTNAME = '" & Request.Form("FIRSTNAME") & "' , LASTNAME ...
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 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 
