[thelist] ASP Problems
Pearson, John
JOHN.PEARSON at eia.doe.gov
Mon Apr 19 13:56:54 CDT 2004
1) I would try the query in access to check what works on an actual record.
Since you have "and and and etc" it only needs one error to give you a "no
records" response.
2) I dont see why you need the server.htmlencode calls to fill in the default
entries in the form. Is it possible that the html.encode is giving you a
conversion that fails the sql "and" logic in the select statement? HTH
More information about the thelist
mailing list