I'm using Oracle and CF7, doing a Query of Query. I'm attempting to research a
query to find any that the title doesn't have "affiliate Faculty" in it.
The query of query is giving me an error:
"The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values."
Here's the first query:
<CFQUERY NAME="people_search" DATASOURCE="dpch">
SELECT
id,fname,mname,lname,type,title,dept,phone,location,email,email_alternate,summary
FROM PEOPLE
WHERE upper(dept) Like upper('%epidemiology%')
ORDER BY upper(lname) ASC, upper(fname) ASC
</CFQUERY>
Here's the second query that gives the error:
<cfquery dbtype="query" name="faculty">
select *
FROM people_search
WHERE upper(people_search.title) not like upper('%Affiliate Faculty,
Epidemiology Biostatistics%')
</cfquery>
Oddly if I change out "title" for "lname" it works fine. Here's the
information on those two fields:
TITLE VARCHAR2 200
LNAME VARCHAR2 100
So they're largely similar, but daggummit, I need it to be "title" I use.
thank you.
daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323387
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
