Re: [Citrusdb-users] Billing Module Query Failure

2008-05-01 Thread Paul Yasi
[EMAIL PROTECTED] Subject: Re: [Citrusdb-users] Billing Module Query Failure To: For users of CitrusDB discussion citrusdb-users@lists.sourceforge.net Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1 That's odd, the schema should allow

Re: [Citrusdb-users] Billing Module Query Failure

2008-04-30 Thread Paul Yasi
That's odd, the schema should allow the creditcard_number, creditcard_expire, and rerun_date to be inserted as null values and mysql puts in zeroes for you. Did you happen to use any particular windows gui tool to import the default citrus database schema? It looks like there may be some kind of

[Citrusdb-users] Billing Module Query Failure

2008-04-29 Thread Rich Cloutier
[EMAIL PROTECTED] wrote: Can you show me the query it prints? Maybe with fake data if necessary. Paul No, because I fixed it. It was definitely data-related. We are still fleshing out our data and many fields are blank still. The initialization of many empty numeric and date fields to is