Re: Invoices working?

[Gary P. <ga...@es...>]

Hello,

I got an error that looks similiar to yours (but it could be different I
Can't remember exactly).  The problem turned out to be with the database
name.  I named my database Test, but the actual table was stored as test.
I resolved the problem by creating a new database with only lower case
letetrs in it.  I don't know if this will help you.

	-Gary



On Thu, 15 Nov 2001, Ilkka ... wrote:

> Hi,
> 
> Does the create (customer) invoice work?
> 
> When I create a customer invoice, it complains like this:
> 
> Error!
> You have an error in your SQL syntax near '' at line 1 SELECT onhand FROM 
> parts WHERE id =
> 
> And I checked the code, and in IS->post_invoice, the variable $form->id_1 is 
> empty, which is why it complains like that.
> 
> And, I checked the is.pl: display_form and display_row functions, and the 
> id_1 variable in the form is of type "hidden" but nothing is set to this 
> variable at any time, so no wonder it is empty!
> 
> So, what's wrong here? Am I the only one getting this error?
> 
> Thanks,
> Ilkka
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> 
>