Paul Yasi wrote:
> Try adding this ADODB debug line at the top of the function:
> $DB->debug = true;
> It should give you some verbose output about what it's doing.
> Paul
>
Hooray. It does:
1146: Table 'citrus_db.tax_exempt' doesn't exist
Thank You.
> On 10/23/06, Michael Rulison <[EMAIL PROTECTED]> wrote:
>
>> I have checked the file include/billing.inc.php with PHPDesigner2007 as
>> debugging editor; it reports no errors. But from Citrus menu, ...print
>> invoices...
>> Here is the block of code, ending with "die" and a modified error message.
>>
>> function add_taxdetails($DB, $billingdate, $bybillingid, $billingmethod,
>> $batchid) {
>>
>> /*--------------------------------------------------------------------*/
>> // Add taxes to the bill
>> // database connector, billing date, billing method (invoice, prepay ,
>>
++++++++++++++++++++snipped++++++++++++++++++++++++++
>> LEFT JOIN billing b ON us.billing_id = b.id
>> LEFT JOIN billing_types t ON b.billing_type = t.id
>> WHERE b.id = '$bybillingid' AND us.removed <> 'y'";
>> }
>> $DB->SetFetchMode(ADODB_FETCH_ASSOC);
>> $taxresult = $DB->Execute($query) or die ("Taxes Query Failed; Citrus
>> 103") ;
>>
>> $taxresult produces the die side of the ''or' statement
>> Could it be a problem with the $DB variable?
>> How can I check it, please?
>>
>> -----------------------------------------------------------------------------
>> Michael Rulison | 919/782-9576
>> Raleigh NC 27607-6723
>> -----------------------------------------------------------------------------
>>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
