Instead of createodbcdate(), try using Oracle's TO_DATE() function on your
dates like this:
STSERVICE.DATE_BEGIN BETWEEN TO_DATE('07/01/00','mm/dd/yy') AND
TO_DATE('06/30/01','mm/dd/yy')
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
> -----Original Message-----
> From: Kris Pilles [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 15, 2002 3:54 PM
> To: CF-Talk
> Subject: Oracle query help
>
>
> Heres the query:
>
> SELECT ALL STUDENT.STUDENT_NUM,
> STUDENT.LASTNAME, STUDENT.FIRSTNAME, STUDENT.BIRTHDATE, STUDENT.SEX,
> STUDENT.SSNUM,
> STSERVICE.DATE_BEGIN, STSERVICE.DATE_END, STSERVICE.LOCATION,
> STSERVICE.HANDICAP,
> STSERVICE.CSIZE_RATIO, STSERVICE.ST_CLASS, STSERVICE.FUND,
> STSERVICE.SERVICE, CUST1.CODE, CUST2.CODE, ST_CONTACTS.ID,
> ST_ADDRESSES.ADDRESS1_TX, ST_ADDRESSES.ADDRESS2_TX,
> ST_ADDRESSES.CITY_TX, ST_ADDRESSES.STATE_CD, ST_ADDRESSES.ZIP_NR
> FROM STUDENT, STSERVICE, ST_CONVERT_CUSTOMER CUST1,
> ST_CONVERT_CUSTOMER
> CUST2, ST_CONTACTS, ST_ADDRESSES
> WHERE ((STSERVICE.STUDENT_NUM = STUDENT.STUDENT_NUM)
> AND (ST_CONTACTS.STUDENT_NUM(+) = STUDENT.STUDENT_NUM)
> AND (ST_ADDRESSES.ST_CONTACT_ID(+) = ST_CONTACTS.ID)
> AND (STSERVICE.CUSTOMER = CUST1.CUSTOMER(+))
> AND (STSERVICE.HOME_DISTRICT = CUST2.CUSTOMER(+))
> AND (STSERVICE.DATE_BEGIN BETWEEN #createodbcdate('07/01/00')# AND
> #createodbcdate('06/30/01')#
> OR STSERVICE.DATE_END BETWEEN #createodbcdate('07/01/00')# AND
> #createodbcdate('06/30/01')#
> OR XSTART BETWEEN STSERVICE.DATE_BEGIN AND STSERVICE.DATE_END))
> </cfquery>
>
> The error:
>
> **All column/table names are correct
>
> [Oracle][ODBC][Ora]ORA-00904: invalid column name
>
> Any ideas??? Any help would be appreicated.
>
> THanks
>
>
>
> Kris Pilles
> Website Manager
> Western Suffolk BOCES
> 507 Deer Park Rd., Building C
> Phone: 631-549-4900 x 267
> E-mail: [EMAIL PROTECTED]
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
