delimited lists such as "Bob,Carol,Ted,Alice". My query contains a line to
find all records that contain, for example, "Ted":
SELECT * FROM Emps
WHERE ',' + EmpName + ',' LIKE <cfqueryparam cfsqltype="CF_SQL_VARCHAR"
value="%,#form.EmpName#,%">
(thanks to Pascal for the sql)
This query works perfectly when form.EmpName is passed as a <select
name="EmpName"> but fails when passed as an <input type="text"
name="EmpName">.
I've verified that the passed variable is identical, the only difference is
the form element passing it.
What the heck is up? Any clues?
Thanks in advance,
Les
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
