July 11, 2008 at 4:33 am
hi
i get this error Invalid syntax near 'se
can anyone help how this error is occuring
kumar
July 11, 2008 at 6:51 am
You will have to post the query. It could be a number of things.
July 11, 2008 at 7:27 am
hi
thx for your reply.
I cannot get the query as i have only application with me and database. can you tell me the where the error will occure or on what condition will this happen.
July 11, 2008 at 7:56 am
All it means is that the statement in question is not valid SQL. It could be anything
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2008 at 12:58 pm
Most probably an input using a single quote was used.
And the programmer of the query didn't assume that possibility and hence didn't use QUOTENAME() function to remedy.
N 56°04'39.16"
E 12°55'05.25"
July 11, 2008 at 1:21 pm
It's a syntax error, you need to see the query to figure out what's wrong.
July 14, 2008 at 8:59 am
can you not run a sql trace to find the sql statement?
as posted previously, most likely you've got something like
update tablename
Set field1 = 'yourstring'shere' <--- see the extra ' mark? this would throw your sql off
where field2 = '2'
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
July 15, 2008 at 11:09 pm
what is the application you are using? suppose you dont have access to the database?
incorrect synatax means the query you are trying to execute through the application is wrong. You will have to look at the query to see where exactly the error is.
July 21, 2008 at 3:26 am
it looks like syntax error. check it.
Cheers!
Sandy.
--
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply