if else on type of interger

Hi there

I know I should be able to do this, but I'm stuck!

I am trying to build a table that forms from cats being pulled from a DB.

The table will be 3 cols by x rows.

I have been doing an if else based on if int(Ident/3)= 1, 2, 3, 4 etc etc ,
but this is sloppy! :-(

What I need to get working is

<%

Code Snipped

if int(Ident/3)= [a whole number] then

%>
formatting A is done
<% else %>
formatting b is done
<%
end if

Code Snipped

%>

Thanks in advance

Si

Perhaps you are looking for the mod[ulus] operator, although it wouldn't be
much different from what you're doing now.  What exactly isn't working for
you in the way you want it to?

If Ident Mod 3 Then
'formatting a
Else
'formatting b
End If

http://msdn.microsoft.com/library/e...ml/vsoprmod.asp

Ray at work





"Simon" <simon.cornforth@blueyonder.co.uk> wrote in message
news:rs6ed.133939$BI5.19749@fe2.news.blueyonder.co.uk...
> Hi there
>
> I know I should be able to do this, but I'm stuck!
>
> I am trying to build a table that forms from cats being pulled from a DB.
>
> The table will be 3 cols by x rows.
>
> I have been doing an if else based on if int(Ident/3)= 1, 2, 3, 4 etc etc
> ,
> but this is sloppy! :-(
>
> What I need to get working is
>
> <%
>
> Code Snipped
>
> if int(Ident/3)= [a whole number] then
>
> %>
>          formatting A is done
> <% else %>
>          formatting b is done
> <%
> end if
>
> Code Snipped
>
> %>
>
> Thanks in advance
>
> Si
>
>

Ray Costanzo [MVP] wrote:
> If Ident Mod 3 Then
>     'formatting a
> Else
>     'formatting b
> End If

That ought to be:

If Ident Mod 3 = 0 Then
^^^^^


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

Oh yeah.  Thanks.  :]

Ray at work

"Dave Anderson" <GTSPXOESSGOQ@spammotel.com> wrote in message
news:uXWC0BEuEHA.948@tk2msftngp13.phx.gbl...
> Ray Costanzo [MVP] wrote: 
>
> That ought to be:
>
>    If Ident Mod 3 = 0 Then
>                  ^^^^^
>
>
> --
> Dave Anderson
>
> Unsolicited commercial email will be read at a cost of $500 per message.
> Use
> of this email address implies consent to these terms. Please do not
> contact
> me directly or ask me to contact you directly for assistance. If your
> question is worth asking, it's worth posting.
>
>

Excellent, Thanks for that.

I worked around it by doing

if int(Ident/cellCount) - Ident/cellCount = 0 then

which worked, but .... now

RowBreak = Ident Mod cellCount

if RowBreak = 0 then

Works and is a lot cleaner

Thanks again.

Si