At 4:53 PM -0500 9/24/99, adhir@stripped wrote:
>Not an answer, but a datapoint: this works great in perl using the DBI
>driver for Mysql...
That's because the DBD::mysql module does placeholder emulation, not
because the MySQL C API actually supports it.
Still, who cares as long as it works, eh? :-)
>> -----Original Message-----
>> From: mysql-return-14208-adhir=forumone.com@stripped
>> On Behalf
>> Of Ramesh Theivendran
>> Sent: Friday, September 24, 1999 5:04 PM
>> To: mysql@stripped
>> Subject: Is there a SQLPrepare in MYSQL
>> After reading the C Api for MYSQL I could not see any reference to
>> preparing a SQL query and binding parameter at run time.
>> For example, in most databases I can do a Prepare on a SQL like INSERT
>> INTO TAB ( COL1,COL2) VALUES (?,?) once and
>> then in a loop bind parameter and execute. Looks like the only way in
>> MYSQL is to generate a diff. query evertime I need to execute
>> with diff.
>> data like INSERT INT TAB (COL1,COL2) VALUES ('data1','data2'). Please
>> correct me if iam wrong.
Paul DuBois, paul@stripped