Zugg Software :: View topic

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

Ok here is my problem I have a #LOOPDB that I need every other line colored Alternativly but I can't figure out how to do it. and %i doesn't work in a loopdb

Unaltered
#loopdb test {%key}

So I tried %case hopeing it would work like #CASE ie if you have two values and you ask for the third it will return the first (or something along those lines) but %case only returns if the value exists.

Exp with %case(%iskey(var,%key)) //returns key number
#loopdb test {%case(%iskey(test,%key),Do,Dont) This}
returns this in a 4 record var
Do This
Don't This
This
This

Are there any other things I can try to do to make it output like this

Do this
Don't this
do this
don't this

SubAdmin Joined: 18 Nov 2001 Posts: 5182

Simply use %mod.
#LOOPDB @test {#ECHO %if(%mod(%iskey(@test,%key),2),Do,Dont) %key}

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

*WHAP* I swear I looked right at thank Thanks Vijilante.