Thanxs, that was it. -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:57 AM To: CF-Talk Subject: RE: CF5: Query A Query migration trouble
When doing a QofQ, you do not pass datasource="...". Remove that part from your cfquery tag. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:54 AM > To: CF-Talk > Subject: CF5: Query A Query migration trouble > > > I'm trying to migrate over to CFMX and I'm having some trouble. > > I'm using this Query Statement: > > <CFQUERY name="GetUsers" datasource="GetAllUsers" dbtype="query"> > SELECT EmpID, FirstName, LastName, OfficeAbrv, SubOfficeAbrv, > ArchiveStatus > FROM GetAllUsers > <CFIF #URL.SearchValue# EQ "USER"> > WHERE <cfif localOfficeID NEQ "ALL"> OfficeFilterID = > #ListLast(localOfficeID)# AND </cfif>( LowFirst LIKE '#LCase > (localFirstName)#') OR (LowLast LIKE '#LCase(localLastName)#')</CFIF> > <cfif localOfficeID NEQ "All"> > WHERE OfficeFilterID = #ListLast(localOfficeID)# > </cfif> > </CFQUERY> > > This is generating the Error: > Data source GetAllUsers could not be found. > > GetAllUsers is a query that is performed just previous to the > above query. > > All worked just fine in CF5 > > > Thanks in advance > > > Doug Kronenberger > > OI National Training and Education Office > > Department of Veterans Affairs > > > > 440-526-3030 x7776 > [EMAIL PROTECTED] > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
