[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