RE: [KCFusion] Dynamic ORDER BY
I am at ATT wireless in SFO. Is there anything you can add to your report? Or other useful info? All will be appreciated. Thanks Stephen WIlliamson A l l a i r e http://www.allaire.com email: [EMAIL PROTECTED] cell:+1-913-226-4395 | fax:+1-253-484-8437 -Original Message- From: Daryl Banttari [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 7:48 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Dynamic ORDER BY Actually, the tick quotes there should be unnecessary. What does the query look like in the debug output? Daryl - Original Message - From: "Ryan Hartwich" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:54 PM Subject: RE: [KCFusion] Dynamic ORDER BY Keith, Check to make sure if you are passing column names via variable, the column names have a tick mark around them: Order By '#VarName#', Column2 Likewise, check that your cfif statement uses a tickmark if necessary around the variable values. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Monday, December 04, 2000 3:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Dynamic ORDER BY I have an odd SQL problem in CFQUERY. I'm trying to make an ORDER BY section dynamic. I don't get error messages, but the second ORDER BY parameter is ignored. Here's a chart of the results. Is there a workaround? (We're on CF4.0, NT4, SP5.) ORDER BY Column1, Column2- this works very well ORDER BY #VarName#, Column2 - ignores Column2 - CFIF statement here - ORDER BY Column1, Column2- ignores Column2 - /CFIF - Keith Purtell, Web Designer VantageMed Corporation __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Dynamic ORDER BY
My appologies to the list. Bad e-mail fingers... Stephen WIlliamson A l l a i r e http://www.allaire.com email: [EMAIL PROTECTED] cell:+1-913-226-4395 | fax:+1-253-484-8437 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Dynamic ORDER BY
Minor corrections. The parameter is ignored in the FIRST two examples. And in the "real" code; no, I did not put the table name where the query name is supposed to go. Keith Purtell, Web Designer VantageMed Corporation -Original Message- Got several requests for more code. As I said before, the second parameter is ignored in the second two examples. In the third example (non-dynamic), the output table is ordered first by doc_history, then those results are ordered by doc_recordid, as expected. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Dynamic ORDER BY
Keith, If your debug settings is on, can you see exactly what the sql that is being sent to the server looks like ? Have you cfoutputed your variable "VarName" to see exactly what's it contains? I know these are such basic suggestions and you've probably done these already, but I just can't see anything wrong. BTW, in your variable definition, are you sure you are setting that variable (VarName) to exactly the column name as it is in the database ? 'Cos it could be that both columns 1 2 are actually being ignored but because of the way the data is stored in the database, it appears that column1 is actually used in the sorting. My 2 cents. -Betty -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 3:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Dynamic ORDER BY I have an odd SQL problem in CFQUERY. I'm trying to make an ORDER BY section dynamic. I don't get error messages, but the second ORDER BY parameter is ignored. Here's a chart of the results. Is there a workaround? (We're on CF4.0, NT4, SP5.) ORDER BY Column1, Column2- this works very well ORDER BY #VarName#, Column2 - ignores Column2 - CFIF statement here - ORDER BY Column1, Column2- ignores Column2 - /CFIF - Keith Purtell, Web Designer VantageMed Corporation __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] ** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Dynamic ORDER BY
Actually, the tick quotes there should be unnecessary. What does the query look like in the debug output? Daryl - Original Message - From: "Ryan Hartwich" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:54 PM Subject: RE: [KCFusion] Dynamic ORDER BY Keith, Check to make sure if you are passing column names via variable, the column names have a tick mark around them: Order By '#VarName#', Column2 Likewise, check that your cfif statement uses a tickmark if necessary around the variable values. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Monday, December 04, 2000 3:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Dynamic ORDER BY I have an odd SQL problem in CFQUERY. I'm trying to make an ORDER BY section dynamic. I don't get error messages, but the second ORDER BY parameter is ignored. Here's a chart of the results. Is there a workaround? (We're on CF4.0, NT4, SP5.) ORDER BY Column1, Column2- this works very well ORDER BY #VarName#, Column2 - ignores Column2 - CFIF statement here - ORDER BY Column1, Column2- ignores Column2 - /CFIF - Keith Purtell, Web Designer VantageMed Corporation __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
