dynamic if then 2

[sharedworld]

I need to generate on my asp page a dynamic if then, which means, that i have some updatables values on my database, i wan't open my database take the values and make something like this:

do while not rs.eof then
if vIf="" then
vIf="if instr(rs(""criteria"&quot,rs("brand&quot)"
else
vIf=vIf & " and instr(rs(""criteria"&quot,rs("brand&quot)"
end if
loop

if vIf<>&quot;&quot; then
vIf=vIf & vbcrlf & &quot; then&quot;
vIf=vIf & &quot;response.write &quot;&quot;blabla&quot;&quot;&quot;
vIf=vIf & vbCrlf & &quot;End if&quot;
execute vIf
end if

something like this, is this possible?...

 

[foxbox]

mmmmm, to me this looks like setting a flag/ semaphore:


dim lCriteriaMet
lCriteriaMet = false
do while not rs.eof then
if instr(rs(&quot;&quot;criteria&quot;&quot,rs(&quot;brand&quot) <> 0 then
lCriteriaMet = true
end if
rs.movenext
loop

if lCriteriaMet then
response.write &quot;&quot;blabla&quot;&quot;
end if






br
Gerard

 

[Tarwn]

Well, you could make a boolean variable to hold the result from all the records, something like:

Dim bIf
bIf = True   'default it to true so as not to negate effect of later And's
Do While Not rs.eof then
   bIf = bIf And (InStr(rs("criteria"),rs("brand")) > 0)
   rs.MoveNext
Loop

If bIf = True Then
   Response.Write "whatever"
End If

I think this may be closer to what you were looking for, ie, an And check for each record all combined into a single boolean If Then.

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[sharedworld]

thank you guys, I gonna check it... but looks good...