On Thu, 20 Sep 2007 00:53:01 -0400, you wrote: > >Greetings! > >I have this db containing this table: > >CREATE TABLE LSOpenJobs > ( > id integer primary key, ProjID integer, subProjID integer, parent, >children, login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm, >pmuk, lang, vendor, vEmail, invoice, ProjFund, PMTime, A_No, wDir, BiliDir, >TMDir, DeliveryDir, paid, paidDate, notes, status, pages, ta > ); > >I am trying to make a report and I am calling this select statement, > > select ProjID, cust, proj, bdate, ddate, edate, sum(invoice), sum(ProjFund) > from LSOpenJobs where ProjID = 423 AND PClass!='Quote' group by ProjID; > >There are more than one record where ProjID = 423 and PClass != "Quote". >But when I run the program, I get, > >DBIException: The name 'invoice' is not a valid index.
[...] >Any help would be greatly appreciated. Does it work when you use those queries in the sqlite3 command line utility? My guess is that there's something wrong with the quoting of the query string you offer to your wrapper. Another guess is that try to sum strings, bcz the colums aren't defined as numeric in the table definition. >thanks, > >josé Hope this helps, -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
