(RADIATOR) help required ...

[Muhammad Mushtaque]

Hi All,

I m using Radiator-2.17 with Platypus and SQL Database. I am trying to 
do currency calculation with time calculation ( example: if any of our 
user used 1 hr (say) then the charges of 1 hr will be detected through 
the amount he paid us and if he has no amount in his amount field so he 
wont be able to connect. the charges will be different for different 
durations of day.)
thats our whole scenario, I m trying to do this through SQL. Ultimately 
through AcctSQLStatement i m updating the field of amount in SQL.
The error i m getting is when i m executing this query ...


AcctSQLStatement update customer set amount=amount-('%{Acct-Session-
Time}'/3600.00)*price from  priceCalculation,customer,timerate where 
customer.username ='%n' and customer.accttype='TimePackages'

I m attaching trace 4 detail file.

waiting for replies.

regards
 
Mushtaque.  

_______
This email and any files transmitted with it are confidential and are 
intended solely for the use of the individual or entity to which they 
are addressed. This communication represents the originator's personal 
views and opinions, which do not necessarily reflect those of eWorld 
(Pvt) Ltd. If you are not the original  / intended recipient or the 
person responsible for delivering the email to the intended recipient, 
be advised that you have received this email in error, and that any 
use, dissemination, forwarding, printing, or copying of this email is 
strictly prohibited. If you have received this email in error, we 
regret the inconvenience and request you to please immediately notify 
at info at eworld.net.pk 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: detail.txt
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020806/60ebad89/attachment.txt>