RE: Query of Query Syntax

[Dawson, Michael]

Oops. I read your message again.

You can't do anything except a SELECT statement.  However, if you want
to delete something from a QoQ, you need to SELECT everything _except_
what you want to keep.  Kind of funky, but it works. 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 10, 2004 2:42 PM
To: CF-Talk
Subject: Query of Query Syntax

I am asking here, before I go searching and digging in the documentation
and web resources, because you all often provide a better answer faster
then I can on my own.
 
Anyway, what SQL syntax, if any, is in a CF query of a query to
manipulate and modify string content of fields?  I have a record set of
e-mails that have been generated by a tool that validated them.  I would
like to create a report of how many we have from various domains.  I can
see how I could do this manually by looping through the query
manipulating each record one at a time and counting up each domain.
But, I was wondering if I can do this in a query of a query using syntax
you can usually find in more robust RDMS's.
 
So, is this possible?
--
Ian Skinner
Web Programmer
BloodSource
 www.BloodSource.org
<http://www.BloodSource.orgSacramento>
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning
 

Confidentiality Notice:  This message including any attachments is for
the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender and
delete any copies of this message. 






~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187155
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Query of Query Syntax

[Dawson, Michael]

You can use a normal SQL SELECT, however, there are limitations.  I
can't think of anything that isn't "standard", however.

M!ke 

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 10, 2004 2:42 PM
To: CF-Talk
Subject: Query of Query Syntax

I am asking here, before I go searching and digging in the documentation
and web resources, because you all often provide a better answer faster
then I can on my own.
 
Anyway, what SQL syntax, if any, is in a CF query of a query to
manipulate and modify string content of fields?  I have a record set of
e-mails that have been generated by a tool that validated them.  I would
like to create a report of how many we have from various domains.  I can
see how I could do this manually by looping through the query
manipulating each record one at a time and counting up each domain.
But, I was wondering if I can do this in a query of a query using syntax
you can usually find in more robust RDMS's.
 
So, is this possible?
--
Ian Skinner
Web Programmer
BloodSource
 www.BloodSource.org
<http://www.BloodSource.orgSacramento>
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning
 

Confidentiality Notice:  This message including any attachments is for
the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender and
delete any copies of this message. 






~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187153
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Query Syntax

[Jochem van Dieten]

Ian Skinner wrote:
>  
> Anyway, what SQL syntax, if any, is in a CF query of a query to manipulate 
> and modify string content of fields?

Upper() and Lower().

Jochem

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187127
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Query of Query Syntax

[Ian Skinner]

I am asking here, before I go searching and digging in the documentation and 
web resources, because you all often provide a better answer faster then I can 
on my own.
 
Anyway, what SQL syntax, if any, is in a CF query of a query to manipulate and 
modify string content of fields?  I have a record set of e-mails that have been 
generated by a tool that validated them.  I would like to create a report of 
how many we have from various domains.  I can see how I could do this manually 
by looping through the query manipulating each record one at a time and 
counting up each domain.  But, I was wondering if I can do this in a query of a 
query using syntax you can usually find in more robust RDMS's.
 
So, is this possible?
--
Ian Skinner
Web Programmer
BloodSource

 www.BloodSource.org  
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning
 

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187096
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54