List:General Discussion« Previous MessageNext Message »
From:Jann Linder Date:May 1 1999 5:41pm
Subject:SOLUTION: Re: [CGI] ERROR IN SQL -- FIXED
View as plain text  
SELECT SUM(((rate * hours) * ((100-discount) * .01)))
FROM billable WHERE company = 'whatever';

was the query you sent me.

I inadvertantly added a space...looking like this:

SELECT SUM (((rate * hours) * ((100-discount) * .01)) ) FROM billable WHERE
company = 'whatever'

so..the space was the problem.

Thanks...it works now.

Jann



--
Jann Linder
Web Developer
Perl Programmer

Personal Site: http://www.jann.com/
CalendarPlus Site: http://www.calendarplus.com/


----------
>From: Jim Faucette <jimf@stripped>
>To: Jann Linder <jann@stripped>
>Subject: Re: [CGI] ERROR IN SQL
>Date: Sat, May 1, 1999, 10:37 AM
>

> Jann Linder wrote:
>>
>> How come i get this error when running this query?
>>
>> ERROR 1064: parse error near '(((rate * hours) * ((100-discount) * .01)) )
>> FROM
>> billable WHERE company = 'abc'
>>
>
> What does the full query look like? Did you preceed this with SUM?
>
>   jim...
> 
Thread
SOLUTION: Re: [CGI] ERROR IN SQL -- FIXEDJann Linder1 May