Gadfly: single-quote in varchar?

[Sam Penrose]

Bill was right. Sigh. Thanks, Bill.

MySQL-never-had-this-problem-ly,
s

On Wednesday, May 22, 2002, at 10:59 AM, Scherer, Bill wrote:

>
>
> On Wed, 22 May 2002, Sam Penrose wrote:
>
>> I cannot get Gadfly to INSERT a string containing a single-quote (')
>> into a VARCHAR field. Gadfly appears to insist that strings passed to
>> its parsing framework be delimited with single quotes:
>
> In Oracle anyway, one proper way of doing this is to double the
> single quote, eg:
> cursor.execute("INSERT INTO t (Description) VALUES ('alpha''s
> before beta')")
>
> I don't know how Gadfly will react to that, but it wasn't in your
> list of tried-out-things, so give it a go.
>
>
>>
>>>>> cursor.execute("INSERT INTO t (Description) VALUES ('alpha')")
>> NOT
>>>>> cursor.execute('INSERT INTO t (Description) VALUES ("alpha")')
>>
>> which may or may not be connected, (and rules out the obvious 'INSERT
>> INTO t (Description) VALUES ("alpha's before beta")') but at any rate 
>> no
>> variation on
>>
>>>>> cursor.execute("INSERT INTO t (Description) VALUES ('alpha\'s before
>> beta')")
>>>>> cursor.execute("INSERT INTO t (Description) VALUES ('alpha\\'s
>> before beta')")
>>>>> cursor.execute("INSERT INTO t (Description) VALUES ('alpha\\\'s
>> before beta')")
>>
>> seems to work, although some fail silently, neither raising an error or
>> inserting the row. Description has been defined as a VARCHAR field and
>> happily accepts strings with other punctuation, including 
>> double-quotes.
>> Anyone know if this is a Gadfly constraint, or notice some dunderheaded
>> mistake I'm making?
>>
>> Gadfly 1.0.0rc1, Unix python 2.2 on Mac OS X.
>>
>> TIA,
>> Sam
>>
>>
>>
>>
>
> --
> Bill.Scherer at Verizon Wireless
> RHCE 807101044903581
>
>