Check the links below, similar problem to yours. I hope this would help. http://www.dbforums.com/t921636.html http://www.talkaboutdatabases.com/group/comp.databases.xbase.fox/message s/111510.html
Ahmed El-Rasheedy, MBA Senior Programmer Information Services Office: 972-807-1206 Unitrin Specialty - Insurance for U -----Original Message----- From: Ron Mast [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 10:05 AM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: [DFW CFUG] query group by question Hi All, I have a query and I'm grouping by 2 fields and the query dumps no problem with those 2 fields in the SELECT statement, but when I try and add a field to the SELECT statement I get the following error: Error Diagnostic Information ODBC Error Code = S1000 (General error) [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0122 - Column CPARTW or expression in SELECT list not valid. Can anyone point me in the right direction? Any help is greatly appreciated. Thanks, Ron _______________________ This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual to whom they are addressed. If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/ CONFIDENTIALITY NOTICE: The information contained in this e-mail and attached document(s) may contain confidential information that is intended only for the addressee(s). If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action in reliance upon the information is prohibited. If you have received this e-mail in error, please immediately notify the sender and delete it from your system. _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
