Hi everyone,
I have a jsp page where I am calling a stored procedure in a SQL Server 2005 database. I am calling the parameters from a html web form. The code runs successfully except when I put a '.' in one of the nvarchar fields. Then I get the error: Incorrect syntax near '.'
However, when I execute the stored procedure from within SQL Server it executes successfully even with the '.'
I need to include the '.' for email addresses.

Any suggestions would be appreciated.
Regards,
Jim

Wow, that is a strange one. I don't understand why calling the stored procedure differently would effect how the procedure executes. Do things work OK with the .jsp page if you have an email address? Have you ever been able to execute that SQL statement correctly? Just because it says the problem is near the '.', doesn't mean that's the problem and in a few cases, it's not close to indicated location at all.

__________________
-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.