yes you can
<cfquery name="q1" datasource="twdjdbc">
select surname from parent
where cmpy_code = "10"
</cfquery>
<cfdump var="#q1#">
<cfquery name="q2" dbtype="query">
select surname from q1
where upper(surname) = upper('addams')
</cfquery>
<cfdump var="#q2#">
returns "Addams"
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Chad
> Renando
> Sent: Tuesday, 7 June 2005 4:17 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] RE: QoQ woes
>
>
> I think I've run into it myself. Not sure that you can.
>
> Chad
> who can be insensitive
>
> On 6/7/05, Tom MacKean <[EMAIL PROTECTED]> wrote:
> > Found it. The search is case sensitive.
> >
> > How do I make it case insensitive?
> >
> > Tom
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On 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/
> >
>
> ---
> 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/
