quick question:
if you dropped the where clause, do you still get no data?
<cfquery name="test" dbtype="query">
SELECT * FROM INTERNAL
</cfquery>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Tom
> MacKean
> Sent: Tuesday, 7 June 2005 4:06 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] QoQ woes
>
>
> 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/
>
---
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/
