Re: strange extra quote mark appearing in mysql query


I have a form where registered users on my site can edit their login
details. For some reason, the script is inserting an extraneous quote
mark in the mysql update query that is preventing it from running
successfully, but I am at a complete loss to understand why.

This is the error message:
Error updating details: You have an error in your SQL syntax near
'xxxx@xxxxxxxx' WHERE userid = '15'' at line 4


I dont think that the problem is an extra quote, I think the extra quote you
see is the error message within quotes.

'error message' it just so happens that the part of the error it reports
also contains quotes. eg 'the error is '15'' I have had this myself and the
problem has been a field name that was spelt incorrectly.

Check your field names !!

MS


.

Relevant Pages

  • Re: IE 6.0 - Browser Freezes - Any Ideas?
    ... which then makes the error message about a "hungapp". ... Hi Maurice. ... </end quote> ... MVP Windows - Shell / User ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Microsoft Excel and Word Help
    ... When you click OK in the error message, ... You do not have access to the folder 'drive:\'. ... Locate the files through My Computer or Windows Explorer. ...
    (microsoft.public.windowsxp.newusers)
  • Re: Reduce double space after a comma and quote [,"] to a single space
    ... the Word help. ... Also finding instances of full stop and quote. ... field range is the error message from memory ... google this group for wildcard search replace and my name - this url is ...
    (microsoft.public.mac.office.word)
  • Re: IE 6.0 - Browser Freezes - Any Ideas?
    ... task manager b/c IE doesn't respond, which then makes the error message ... Hi Maurice. ... </end quote> ... MVP Windows - Shell / User ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: How do format a SQL Insert Statement
    ... > The following Insert statement gives me an error message when the last ... Public Function QuoteTextAs String ... ' this is single quote character for ADO/ SQL Server ... Dim strTemp As String ...
    (microsoft.public.access.modulesdaovba)