|
| |
|
|
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
|
|
|