What error do you get? Darryl
[EMAIL PROTECTED] wrote on 07/06/2005 04:06:24 PM: > Hi, > > Why doesn't this work? > > If I dump the first query I get a big table of data - including a record > where the firstname is julian. But I can't get a query of that query to > work. Can anyone spot where I've gone wrong? > > Thanks, > > Tom > > > <cfquery name="internal" datasource="#request.dsn#" > cachedwithin="#createtimespan(0,1,0,0)#"> > SELECT > extension.firstname as firstname, > extension.lastname as lastname, > extension.position as position, > extension.email as email, > department.description as department > > FROM extension, department > WHERE extension.department = department.id > AND extension.id BETWEEN 400 AND 599 > </cfquery> > > <cfquery name="test" dbtype="query"> > SELECT * FROM INTERNAL > where firstname = 'julian' > </cfquery> > > <cfdump var="#test#"> > > > ________________________________________ > > Tom MacKean > > > NOTICE: Medical and scientific information provided in print and > electronically by Sydney IVF might not be relevant to your own > circumstances and should always be discussed with your own doctor > before you act on it. This communication is confidential and may > contain copyright or otherwise protected information of Sydney IVF > Limited or a third party. If you are not the intended recipient of > this communication please immediately let us know by reply email or > telephone us on +61 2 9221 5964, delete the communication and > destroy all copies. > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. Unauthorised use, copying or distribution of any part of this email including attachments is prohibited. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. To the extent permitted by law we exclude (and where the law does not permit an exclusion, limit to the extent permitted by law) all liability for any direct, indirect and consequential costs, losses, damages and expenses incurred in any way (including but not limited to that arising from negligence), connected with any use or access to this email or any reliance on information contained in this email or any attachments. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group A Principal Member of the Financial Planning Association --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
