MySQL syntax

Posted by Les Toeplitz on October 19, 2010 at 09:44:08:

Here's a basic inquery with different delimiters:

data$ = 'SQLEXECUTE UPDATE ds@5F@orders SET cText="'+wctxt$+'" WHERE oID="'+oid$+'"'

data$ = "SQLEXECUTE UPDATE ds@5F@orders SET cText='"+wctxt$+"' WHERE oID='"+oid$+"'"

In the first case, let wctxt$ equal o'reilly books. The inquery will fail because the single quote embedded in the field terminates the field incorrectly.

In the second case, let wctxt$ equal 10". In this case the double quote will cause the same error. Anybody have a workaround for this?

Follow Ups:

• Re: MySQL syntax Justin Reynolds 09:49:06 10/19/10 (2)
  • Re: MySQL syntax Les Toeplitz 13:07:10 10/20/10 (1)
    • Re: MySQL syntax Justin Reynolds 06:10:00 10/21/10 (0)

Post a Followup

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.