Search page

I've a database with four fileds Txt1, Txt2, Pdate1 & pdate2. The two first fields are text and the others are date. I am using a search page that send Query.string to look for specific entry of Txt1 and Txt2. My question is how to show just the results dependent to appropriate pdate1 and pdate2.e.g.:I wrote the line below but no results as i needed. I want this algoritm: If( Txt1 is valid and date1 is greater than today ) OR (Txt2 is valid and date2 is greater than today )  write something. 

<% if (rs.Fields.Item("Txt1").Value) = Request.QueryString( "QueryString" ) and (rs.Fields.Item("pdate1").Value) > date()
Or  if (rs.Fields.Item("Txt2").Value) = Request.QueryString( "QueryString" ) and (rs.Fields.Item("pdate2").Value) > date() Then
Response.Write " something"
End If
rs.MoveNext
Loop
%>

Thanks in advanced.
Henry

Hi hnikou,

There is a syntax error in your statement:

  ... date() Or  if (rs.Field ...

Putting brackets around a simple term like

  ... (rs.Fields.Item("Txt1").Value)

doesn't make much sense; it would be better to bracket the subexpressions to
avoid surprises by operator precendence:

  If ( b1 And b2 ) Or ( b3 And b4 ) Then

You could use temporary variables to make the If expression more lucid:

  sExpectedText = Request.QueryString( "QueryString" )
  bFirstCase = rs.Fields.Item("Txt1").Value = sExpectedText 
  bFirstCase = bFirstCase And ( rs.Fields.Item("pdate1").Value > date() )
  ...
  If bFirstCase Or bSecondCase Then
  ...

Good luck!

ehvbs

Hi ehvbs,
Thanks alot for your comment. My problem has been solved by your comments.
Wishes
hnikou