I have had to add some if..elseif statements in the recordset query so that it runs the right query based on user input, the problem I am having is when the results are shown, the recordset repeat region is lost... I think it is becuase the recordset query isnt' recognized by dreamweaver after I put in the if.else statements in the query..

I have tested this by removing the repeat region to only show one (row) result (and this works)...but the strange thing is that even though the recordset is lost (in the bindings panel), it will still display the results when using <%=(Recordset1.Fields.Item("data".Value)%>, but only showing one rows result...and I tested the results total by using <%=(Recordset1_total)%> and it shows that there are more than one row, just when I go ahead and copy paste the repeat region code from another page I created where the repeat region works (this page is an exact duplicate but without the if..else statements in the query), I don't get a display of the repeat region...

I'm figure the problem is has probably to do with my if..else statement... but the if..else statement is working fine, because the right query is being ran based on user input... and I am able to disiplay the correct results total ( <%=(Recordset1_total)%> )... I am just not able to get a repeat region to work?

I hooe I have explained the problem sufficiently...

Any clue or help?

I have discovered the problem.... When copying the the code for the while...wend loop... I neglected to copy the dim statements that allow the function to work...

Yes I am a Noob... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>