I left the query open because I needed to select all the records in the table.  
Will not having a WHERE statement in the query cause this kind of problem?

-JH


> On Friday 23 Feb 2007, Jim H wrote:
> > cachedWithin="#CreateTimeSpan(0,0,30,0)#"> SELECT CID, CompanyURL 
> FROM
> > WebCompanies
> > </cfquery>
...
> 
> >     <cfloop query="getCompanyURLs" >
> >
> >             <cfif #cgi.HTTP_HOST# EQ #getCompanyURLs.CompanyURL#>
> 
> Why don't you just add a suitable WHERE clause to the query ?
> 
> -- 
> Tom Chiverton
> Helping to efficiently facilitate end-to-end solutions
> at http://thefalken.livejournal.com
> 
> ****************************************************
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in 
> England and Wales under registered number OC307980 whose registered 
> office address is at St James's Court Brown Street Manchester M2 2JF.  
> A list of members is available for inspection at the registered office. 
> Any reference to a partner in relation to Halliwells LLP means a 
> member of Halliwells LLP. Regulated by the Law Society.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above 
> and may be confidential or legally privileged.  If you are not the 
> addressee you must not read it and must not use any information 
> contained in nor copy it nor inform any person other than Halliwells 
> LLP or the addressee of its existence or contents.  If you have 
> received this email in error please delete it and notify Halliwells 
> LLP IT Department on 0870 365 8008.
> 
> For more information about Halliwells LLP visit www.halliwells.com.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270569
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to