database write error

[Mike Bonner]

Hmm can't try it now but if you use the substitution form for the insert
(revExecuteSQL myID, "insert into mytable values(:1,:2,:1)",
"valueX","valueY")
does it work that way?

On Tue, Jan 31, 2012 at 12:55 AM, Mike Bonner <bonnmike at gmail.com> wrote:

> urlencode the data before putting it into the db, decode it when you pull
> it back out.  At least I think thats the easiest answer. t
>
>
> On Tue, Jan 31, 2012 at 12:50 AM, Mark Smith <Mark_Smith at cpe.umanitoba.ca>wrote:
>
>> Hi, I have some code that works fine until I put an apostrophe into a
>> field
>> and then it errors out on storing the data. Any suggestions on dealing
>> with
>> this problem?
>>
>> The code I am using looks like this:
>>
>> put "INSERT INTO master (delivery_date, mothers_name, mothers_phin,
>> mothers_mhsc, mothers_dob, care_provider, note)" & \
>> merge("VALUES ('[[globaldate]]', '[[tmaternalname]]', '[[tmaternalphin]]',
>> '[[tmaternalmhsc]]', " & \
>>           "'[[tmaternaldob]]', [[tcareprovider]]', '[[tnote]]')") into
>> tCmd
>> revExecuteSQL gConnectID, tCmd
>>
>> Thanks
>> -- Mark
>>
>>
>> --
>> View this message in context:
>> http://runtime-revolution.278305.n4.nabble.com/database-write-error-tp4343759p4343759.html
>> Sent from the Revolution - User mailing list archive at Nabble.com.
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
>