Re: Query of Query problem: Merging and sorting two query results

> On 1/29/2013 4:16 PM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote: > Just create empty columns when they are missing, ie: > '' AS off1_name, Ahhh - that works! Didn't know you could do that! Thanks ~| Order the Adobe

Re: Query of Query problem: Merging and sorting two query results

>>Is there a way around this? Just create empty columns when they are missing, ie: *SELECT* first_name, last_name, off1_name, off2_name, off3_name, atty_id, email FROM newstuff UNION SELECT first_name, last_name

Re: Query of Query problem: Merging and sorting two query results

You need to alias the columns in the original queries to they both match, and you must have same number of colums, so exclude the ones that don't exist in both tables. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search en

Query of Query problem: Merging and sorting two query results

I have two separate queries, basically a table of NEW stuff, and then a table of OLD stuff that's not been converted to new yet. Not all fields in the two tables match. So, first query finds all the matching NEW things Second query finds all the OLD things that aren't present in the NEW things

RE: query of query problem (again) -- SOLVED???

No... but it MAY ignor the Location_code column name if IT is not capitilized (as in LOCATION_CODE). -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 9:21 AM To: CF-Talk Subject: RE: query of query problem (again) -- SOLVED??? Okay all, I

RE: query of query problem (again) -- SOLVED???

uot;, resulting in 5 records. Now notice that Nominations2 in attempt2 uses "AND", resulting in 0 records. Is this a bug? Does a query of query ignore the "and" clause if it's not capitalized? Ryan -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PRO

RE: query of query problem (again)

8:47 AM To: CF-Talk Subject: query of query problem (again) Hello all, I posted something similar yesterday, but I have an easier situation this time. Has anybody had any trouble with query of query in CF5? I'm not doing anything complicated, but my query of a query seems to pull too man

RE: query of query problem (again)

Where Company = 'myComp' And Location = 'myLoc' Any ideas? -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 9:47 AM To: CF-Talk Subject: query of query problem (again) Hello all, I posted something similar yesterday,

Re: query of query problem (again)

oi Ryan!! i've never had a problem with it...we use it quite a bit here. but without seeing any codefraid tis not much we'z can assist with -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - Thursday, June 6, 2002, 9:46:44 AM, you wrot

query of query problem (again)

Hello all, I posted something similar yesterday, but I have an easier situation this time. Has anybody had any trouble with query of query in CF5? I'm not doing anything complicated, but my query of a query seems to pull too many records. Thanks for any insight. Ryan J. Pieszak Applications Engi

RE: Query of Query problem

Here's a tip - uppercase all the column names in your second query (as in FRWMAX > #WEIGHT#). There IS a case sensitivity problem. Mark -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:51 PM To: CF-Talk Subject: Query of Query

RE: Query of Query problem

27;s a bug. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 6:51 PM To: CF-Talk Subject: Query of Query problem Anybody know if this is a known bug in CF ?

Query of Query problem

Anybody know if this is a known bug in CF ? This query SELECT * FROM Q_Table WHERE FrWMin <= #Weight# AND ((FrWMax > #Weight#) OR (FrWMax = '')) produces a single row with value of 15.0 in the FrZWPrice field but this query SELECT Max(FrZWPrice) AS Pri