> If I run this query (and nothing else) in a page:
> <CFQUERY NAME="get_email" DATASOURCE="test">
> SELECT email
> FROM addresses
> </CFQUERY>
> It works fine. If I run:
>
> <CFQUERY NAME="get_email" DATASOURCE="test">
> SELECT email
> FROM addresses
> </CFQUERY>
> <CFOUTPUT>
> #get_email.recordcount#
> </CFOUTPUT>
> IE tells me it can't connect to my server. Recordcount from the
> debug shows 44,000+ records.
Can you try a few things;
What happens if you do "SELECT top 100 email" instead of just "SELECT
email"?
Maybe the database is corrupt, can you open it via the database? (Whatever
database it is)
How many actual records are in the table? If it's over 44,000 then DON'T
select them all!
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
