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/
