I couldn't find any citations to confirm it. Anyone care to contradict me?
J
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 11:28 AM
To: CF-Talk
Subject: QofQ with Like returns nullnull error
Hey all,
So, I have a big nasty query, and I need to do some "like" searches on it.
So, I wanted to cache it and then do query of query. However, I can't get
the like clause to work. I just keep getting a
java.lang.NullPointerException error. Anyone else encountered this?
Here's the QofQ:
<cfquery name="trysearch" dbtype="query">
SELECT *
FROM searchstaff
WHERE lastname LIKE '%Hen%'
</cfquery>
If I do "WHERE lastname = 'Henert'" it works just fine, so I know it's not
that lastname isn't a correct column name.
Yes, I've tried it with queryparams. Yes, I've tried selecting specific
columns. But, for brevity of code, I eliminated that for posting.
This is 6.1, but we're using the 3.1 drivers, because the 3.3 drivers
bring
our whole system to a crashing halt.
Thoughts?
--
Deanna Schneider
UWEX-Cooperative Extension
Interactive Media Developer
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
