|
williamj
VP-CART New User
Canada
77 Posts |
 Posted - September 14 2008 : 11:00:33
|
If I get a returning customer with an apostrophe in their last name they get an error when they press continue. This only happens with returning customers. New customers can have an apostrophe in their name and it works fine. It's only a problem when they return and login.
The error they're are getting is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'day'.
/shopping/shopdbsubs.asp, line 166
I know you can use the replace function to change apostrophes to double quotes but I can't find where I would have to insert it to fix this problem. Can anyone please help me with this?
|
|
All Forums
Returning customers error
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
