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
