How about if the columnname is the AA'AA string? Wouldn't the still generate a syntax error?
-----Original Message----- From: Christopher Petrilli [mailto:[EMAIL PROTECTED] Sent: Monday, March 28, 2005 12:04 PM To: [email protected] Subject: Re: [sqlite] quote() function On Mon, 28 Mar 2005 11:57:10 -0500, Iulian Popescu <[EMAIL PROTECTED]> wrote: > That doesn't work either - I get the same error. > From the documentation: > > This routine returns a string which is the value of its argument > suitable for inclusion into another SQL statement. Strings are > surrounded by single-quotes with escapes on interior quotes as needed. > BLOBs are encoded as hexadecimal literals. The current implementation > of VACUUM uses this function. The function is also useful when writing > triggers to implement undo/redo functionality. > > Therefore I was expecting that something like: > > SELECT quote(AA'AA) > > would work in the sense that the actual SQL statement executed will be: > > SELECT 'AA''AA' > > but it doesn't seem to. I suspect it was intended to be used like this: select quote(columname) from table; Chris -- | Christopher Petrilli | [EMAIL PROTECTED]
