PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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
15.

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.

Thanks,

Steve