Up Prev Next
From: "Wechsler, Steven" <Steven dot Wechsler at mtvstaff dot com>
Subject: Converting text inserts to DBI calls
Date: Sep 29 2009 2:59PM
I'm involved in a project where I need to replicate MySQL DML to Sybase
What's the easiest method I can use when inserting or updating text
columns? Since placeholders aren't supported, it seems like I will need
to parse the schema for each table, insert the non-text data and then do
a ct_send_data() for each text column. I see that I can do direct
inserts, but that can become a quoting nightmare if both single and
double quotes appear in a single field.
Suggestions are welcomed.