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
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
