| dprulhiere 2004-04-30, 10:29 pm |
| I have a field in my database that is called file_closed. in the web site is is
chosen by a dropdown box with the default value being NO and the other choice
being YES. I would like to filter my recorset based on this value. In my
recordset wizzard I have the following...
[i]filter: file_closed = URL Parameter YES[/i]
I would have thought that this would only pull up the files that are closed,
but it doesnt retrieve any.
below is the line of code...
[i]rsStatus.Source = "SELECT * FROM status WHERE file_closed = '" +
Replace(rsStatus__MMColParam, "'", "''") + "' ORDER BY lastname ASC"[/i]
Can anyone shed somelight on this for me. Why is it not filtering the way
that i want it to?
Thank you
David
|