CTlib & ct_dyn_prepare

Date view Thread view Subject view Author view Attachment view

From: Marian Reynov (mreynova@socrates.berkeley.edu)
Date: Thu Mar 13 2003 - 14:03:15 PST

Hello,

Has anyone dealt with this? - I was using ct_execute with the same SQL statement and everything worked fine, but using ct_dyn_prepare and ct_dyn_execute is more appropriate in my code. After adding these statements, the script aborts on trying to call ct_dyn_prepare. Are there some good tips on this?

    $insStr = "insert into PROJECTIONS_TRANSACTIONS VALUES (";
    $insStr = $insStr . qq~2003, 1, "1", "$currBUDSUM", "$main::selectedFund", "$main::selectedOrg", "$main::selectedPrg", "$currBUDSUM", "Description to come", getdate(), ?, 0, 0, ?~;
    $insStr = $insStr . ")";
    $status = $data_source->ct_dyn_prepare("$insStr");
    $status = $data_source->ct_dyn_execute($actvalue, $fundvalue);

Thanks in advance,
~Marian

==================================================================
Marian Reynov
UAS Systems Group Supervisor
Information Systems and Technology
University of California at Berkeley
mreynova@socrates.berkeley.edu
(510) 642-0514
==================================================================

-----------------------------------------------------------------------
The following was automatically added to this message by the list server:

Webnet information is available at <URL:http://webnet.berkeley.edu/>.

Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.5 : Thu Mar 13 2003 - 13:57:14 PST