Home > Archive > MySQL ODBC Connector > September 2005 > Calculations on user variables









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Calculations on user variables
Dan Rossi

2005-09-28, 8:24 pm

Hi there I am experiencing a wierd bug in mysql 4.1 which is working in
Mysql5 beta where i am trying to run calculations on user variables. I
use these to pass values to sub queries.


FORMAT((IF(c.bandwidth_limit=0,
((c.monthly_price/@count)*f. percentage_paid)*@fe
ed_count,
((@month_totals*@per
centage)*f.percentage_paid)
)),4) AS providers_cut

this is strangely showing up as null or zero. So whats the go , any
ideas ? If you want the full sql lemme know.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com