Return NULL result set

Hi,
Just use the right variables names and it will work.
You just name your variables :
@IntPaidToMontht
@IntPaidToMont <--- This is NULL

Mathias

> --------------------------------------------
> This is not an official Mysql support answer
> --------------------------------------------


> Greetings,
>
> Query
> =====
> SET @MonthlyInterest := 1000;
> SET @IntPaidToMontht := 900;
> SET @UP_ActualWDBI := 500;
>
> UPDATE
> table1
> SET
> Interest = IF(@MonthlyInterest - @IntPaidToMonth >=
> @UP_ActualWDBI,
> @UP_ActualWDBI,
> @MonthlyInterest - @IntPaidToMont),
>
> Capital = IF(@MonthlyInterest - @IntPaidToMonth >=
> @UP_ActualWDBI,
> 0,
> @UP_ActualWDBI - (@MonthlyInterest -
> @IntPaidToMont));
>
>
> RESULT SET
> ==========
> Interest := NULL
> Capital := NULL
>
>
> What wrong with my query?
>
> I thought I should get 100 for Integer and 400 for
> Capital!
>
> Meanwhile, I'm using MySQL 4.1.10 and defined Integer
> and Capital as BIGINT UNSIGNED in table1.
>
> Thanks in advance.
>
>
>
> __________________________________
> Yahoo! Messenger
> Show us what our next emoticon should look like. Join the fun.
> http://www.advision.webevents.yahoo.com/emoticontest
>
> Thread
>
> * Return NULL result set - ascll, April 3 2005 5:00pm
>
>
>
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org