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 -

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 of Query Syntax I am asking

RE: Query of Query Syntax

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