Re: Dont Quote Me

From: Davide Bianchi <davidebianchi_at_davidebianchi.net>
Date: Mon, 3 Sep 2001 16:27:16 +0200
Message-ID: <9n040k$4i68e$1@ID-18487.news.dfncis.de>

"Raymond Sebuwufu" <sleepinglion40_at_hotmail.com> wrote in message news:999526219.455620_at_ernani.logica.co.uk...
> varchar(255) field. Normally this would not be a problem
> but the data has single quotes in it which confuses the
> SQL interpreter.

Use double-single-quotes:

'this is a single quote: '' '

Davide Received on Mon Sep 03 2001 - 09:27:16 CDT

This message: [ Message body ]
Next message: cf: "Winner"
Previous message: cf: "Re: Challenge ! Find a query doing..."
In reply to: Raymond Sebuwufu: "Dont Quote Me"
Next in thread: Jingkai Yu: "Re: Dont Quote Me"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US