Link to home
Start Free TrialLog in
Avatar of GenesisTech
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
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

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.
Avatar of GenesisTech
GenesisTech

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?
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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!