RE: Query of Query Syntax

2004-12-10 Thread Dawson, Michael
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

RE: Query of Query Syntax

2004-12-10 Thread 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 o

Re: Query of Query Syntax

2004-12-10 Thread 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 -

Query of Query Syntax

2004-12-10 Thread 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 recor