database write error

[Mike Bonner]

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
>