I copied your code and it works for me. Is that all that's in your page? http://www.halestorm.co.uk/test.cfm on CF7
Ade -----Original Message----- From: Scott Sedam [mailto:[EMAIL PROTECTED] Sent: 01 June 2005 16:49 To: CF-Newbie Subject: Query of query won't work AT ALL OK, PLEASE someone find the simple thing I'm overlooking to get a simple QofQ to work. I've tried CFMX 6.1 and 7 and keep getting the same error: Error Executing Database Query. Here's what I've cut my code down to (to eliminate any actual database issues): <cfset users = QueryNew("userID, slID, managerID")> <cfset newRow = QueryAddRow(users,1)> <cfset temp = QuerySetCell(users,"userID","scott",1)> <cfset temp = QuerySetCell(users,"slID","123abc",1)> <cfset temp = QuerySetCell(users,"managerID","brian",1)> <cfdump var="#users#"> <cfquery dbtype="query" name="test"> SELECT * FROM users </cfquery> <cfdump var="#test#"> THANKS in advance! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1064 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
