GenesisTech
asked on
SQL Server keywords
I have not seen this before and am not sure what is causing it or where to look.
When a customer enters an address on my website that includes the word "union", for example "1922 Union St", the text that winds up in the SQL Server field includes a question mark (ascii 63) after "union".
Anybody know what might be causing this and how to stop it?
Thanks - David
When a customer enters an address on my website that includes the word "union", for example "1922 Union St", the text that winds up in the SQL Server field includes a question mark (ascii 63) after "union".
Anybody know what might be causing this and how to stop it?
Thanks - David
You'll have to cough up the code that INSERTs the data from your UI into SQL Server, as there appears to be not enough info here to provide an answer.
ASKER
Jim,
So you are at least saying that you do not believe this is being caused by SQL Server, but is more likely the ASP Code?
In other words you have not encountered this in SQL Server before?
So you are at least saying that you do not believe this is being caused by SQL Server, but is more likely the ASP Code?
In other words you have not encountered this in SQL Server before?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Jim.
Looks like there is a procedure checking for special sensitive characters and replacing thme to avoid a SQL Server injection. I found the routine and can now deal with it appropriately.
Thanks again!
Looks like there is a procedure checking for special sensitive characters and replacing thme to avoid a SQL Server injection. I found the routine and can now deal with it appropriately.
Thanks again!