this is the error I get. MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01791: not a SELECTed expression
SQL = "SELECT DISTINCT ll_location.location_id, ll_location.location FROM ll_location, ll_lesson, ll_lessonstage WHERE ll_location.location_id = ll_lesson.location_id AND ll_lesson.lessonstage_id = ll_lessonstage.lessonstage_id AND ll_lessonstage.lessonstage = 'released' ORDER BY seq_no, upper(location)" Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] -----Original Message----- From: LANCASTER, STEVEN M. (JSC-OL) (BAR) Sent: Thursday, March 14, 2002 2:20 PM To: CF-Talk Subject: Trimming Duplicates I have this query and it is returning records with the same name. I want to use a function like DISTINCT in my select statement, but I can't because I am pulling 2 field any suggestions. Basically when I put #location# it will come up with a city and right now it is coming up with it 20 times. <CFQUERY NAME="getLocationQuery" DATASOURCE="#application.lldbDatasource#"> SELECT ll_location.location_id, ll_location.location FROM ll_location, ll_lesson, ll_lessonstage WHERE ll_location.location_id = ll_lesson.location_id AND ll_lesson.lessonstage_id = ll_lessonstage.lessonstage_id AND ll_lessonstage.lessonstage = '#application.migratedStr#' ORDER BY seq_no, upper(location) Steven Lancaster Barrios Technology NASA/JSC 281-244-2444 (voice) [EMAIL PROTECTED] ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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