Periodically returning no records

[melancthon]

Using Coldfusion MX 6.1, SQL Server 2000:

Periodically, a query will return no records, even though it's supposed to
return something (verified using SQL Query Analyzer). There are a series of
queries on the page, and sometimes, part way through, the records returned for
the remaining queries return no records.

I tried switching all queries to stored procedures, and it periodically gave
an error that stated it could not find the stored procedure.

This problem is only appearing on one particular website. It's a
particularilty high traffic site.

[kyle969]

Is it possible the search criteria is periodically being padded with spaces?
try trimming.

As far as not finding the stored procedure, could there be a conflict with the
datasource name?

Do you have a more than one development datasource with different data sets
named in cold fusion administrator that could be getting used?

[melancthon]

Aha.
It wasn't the datasource that was in conflict, but the application name. We
have a french and an english site, and both of them had the same cfapplication
name. Hopefully renaming one of them solves the problem. So far so good...
Thanks for the insight.

[kyle969]

YVW :-)