Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sun, Jun 6 2010 12:49 PM	Permanent Link
Rita Tipton	I want to update a table with an If statement. Sorta like this if ( i wish ) update latest if winners >= 1 then set total = jackpot * winners else set total = jackpot // gets the 0's I can do it no problem with 2 querys but cant figure out the else bit ;-( Rita
Sun, Jun 6 2010 1:20 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Rita set total = if(winners>1 then jackpot * winners else jackpot) Roy Lambert "Rita" <nospam@nospam.com> wrote on Sun, 6 Jun 2010 17:48:57 +0100 >I want to update a table with an If statement. >Sorta like this if ( i wish ) > >update latest >if winners >= 1 then >set total = jackpot * winners >else >set total = jackpot // gets the 0's > >I can do it no problem with 2 querys but cant figure out >the else bit ;-( >Rita > > >
Mon, Jun 7 2010 10:11 AM	Permanent Link
Rita Tipton	set total = if(winners >=1 then jackpot * winners else jackpot) Thanks Roy easy when you see how Rita