What is the value of #FORM.search#
It must be at least 1 number, or a comma dleimited list of numbers.
Contains requires full-text search and is for text fields.
Snake
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 21:34
To: CF-Talk
Subject:
Paul,
I am not sure if you want to get the subset to match in the DB or in the CF
variable???
You could always loop over the WHERE items.
SELECT
*
FROM
[table]
WHERE
1 = 0
cfloop index=i list=#FORM.search#
OR
CAST( ClientID AS VARCHAR(12)) LIKE
the search field could be a first name, id date, whatever.
i am doing the 0=0 to return all records if nothing is passed.
then will check to see if it numeric, if it is they will be looking up an
ID.
if there is a similar id, return that set..
say our ids have 123456789 charecters.
i just want to
thanks Ben
will try those examples in the mornning.
On 8/21/06, Ben Nadel [EMAIL PROTECTED] wrote:
Paul,
I am not sure if you want to get the subset to match in the DB or in the
CF
variable???
You could always loop over the WHERE items.
SELECT
*
FROM
[table]
WHERE
4 matches
Mail list logo