RE: Can't use UNION
What database platform and what version of cf? -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 5:55 PM To: CF-Talk Subject: OT: Can't use UNION I am putting together an application and I canot use UNION, here is my query that I have used in the past, does anyone have a solution that would not use UNION? SELECT state, state_abv FROM #request.taxStateTable# UNION ALL SELECT province AS state, province_abv AS state_abv FROM #request.taxCanadaTable# ORDER BY 1 Thank you Paul Giesenhagen QuillDesign __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can't use UNION
remove "order by". -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 2:55 PM To: CF-Talk Subject: OT: Can't use UNION I am putting together an application and I canot use UNION, here is my query that I have used in the past, does anyone have a solution that would not use UNION? SELECT state, state_abv FROM #request.taxStateTable# UNION ALL SELECT province AS state, province_abv AS state_abv FROM #request.taxCanadaTable# ORDER BY 1 Thank you Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can't use UNION
Need the order by in there ... UNION is not supported in MySQL and I need a query that works in both MySQL and MS SQL 2000 Thank you Paul Giesenhagen QuillDesign - Original Message - From: "Thanh Nguyen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 5:02 PM Subject: RE: Can't use UNION > remove "order by". > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 24, 2002 2:55 PM > To: CF-Talk > Subject: OT: Can't use UNION > > > I am putting together an application and I canot use UNION, here is my query > that I have used in the past, does anyone have a solution that would not use > UNION? > > SELECT state, state_abv > FROM #request.taxStateTable# > UNION ALL > SELECT province AS state, province_abv AS state_abv > FROM #request.taxCanadaTable# > ORDER BY 1 > > > Thank you > Paul Giesenhagen > QuillDesign > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can't use UNION
This query was orignially written for MS SQL 2000 and needs to work in both MS SQL 2000 and MySQL :) So I am looking for another way around putting two tables together to get results named the same. Thanks! Paul Giesenhagen QuillDesign - Original Message - From: "Joshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 5:20 PM Subject: RE: Can't use UNION > What database platform and what version of cf? > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 24, 2002 5:55 PM > To: CF-Talk > Subject: OT: Can't use UNION > > > I am putting together an application and I canot use UNION, here is my query > that I have used in the past, does anyone have a solution that would not use > UNION? > > SELECT state, state_abv > FROM #request.taxStateTable# > UNION ALL > SELECT province AS state, province_abv AS state_abv > FROM #request.taxCanadaTable# > ORDER BY 1 > > > Thank you > Paul Giesenhagen > QuillDesign > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Can't use UNION
>I need a query that works in both MySQL and MS SQL 2000 Why? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can't use UNION
It is a distributed app .. Paul Giesenhagen QuillDesign - Original Message - From: "Ken Wilson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 7:50 PM Subject: RE: Can't use UNION > >I need a query that works in both MySQL and MS SQL 2000 > > > > Why? > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can't use UNION
Use Q of Q. It provides support for UNIONS. HTH, Sam - Original Message - From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 8:50 PM Subject: Re: Can't use UNION > It is a distributed app .. > > Paul Giesenhagen > QuillDesign > > - Original Message - > From: "Ken Wilson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, September 24, 2002 7:50 PM > Subject: RE: Can't use UNION > > > > >I need a query that works in both MySQL and MS SQL 2000 > > > > > > > > Why? > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists