NO PROBLEM!
This kinda thing is just fun... :)
The only gotcha here is that it's dependent on comma-space to set the
double-pipe delimiter... and I didn't see it until I looked at the
string in a fixed-width font. ;)
If your format is really consistent, where "', A" is a reliable
delimiter, you'
Thank you very much!
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 16, 2005 11:11 AM
To: CF-Talk
Subject: Re: Need Help Parsing Text
OOPS, correction below... I got the AUTHOR column named incorrectly...
sorry.
If you want, you
OOPS, correction below... I got the AUTHOR column named incorrectly... sorry.
If you want, you can view it here, too:
http://w2ksrv1.neo.servequake.com/tmp/ath.cfm
I'll leave it up for a few days...
Laterz,
J
select *
from tbl_whatever
where author in (#listOneEnd#)
and
abstract in (#
Athelene,
Copy/paste this into a CFM page and hit it with a browser...
You may like what you see. :)
J
select *
from tbl_whatever
where lastname in (#listOneEnd#)
and
abstract in (#listtwoend#)
On 4/15/05, Gieseman, Athelene <[EMAIL PROTECTED]> wrote:
> I have a text field that cont
no problem...but I should mention I didn't test thatbut you can probably
see what I was doing ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electr
-Original Message-
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]
Sent: Friday, April 15, 2005 4:29 PM
To: CF-Talk
Subject: Need Help Parsing Text
I have a text field that contains saved search criteria. The field is
called CRITERIA. I need to take the criteria in the field and make a vali
Thank you SO much!!
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 15, 2005 3:49 PM
To: CF-Talk
Subject: Re: Need Help Parsing Text
here goes ;-)
AuhtorList should now be GEISEMAN,SMITH
AbstractList should now be CAT,DOG,FISH
Then
here goes ;-)
AuhtorList should now be GEISEMAN,SMITH
AbstractList should now be CAT,DOG,FISH
Then just loop over each list and create your SQL ;-)
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.
Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 15, 2005 3:33 PM
To: CF-Talk
Subject: Re: Need Help Parsing Text
I think the bigger question if you're using "CONTAINS" then have you setup
full-text indexes on the appropriate columns?? or are you going to use the
inefficient
I think the bigger question if you're using "CONTAINS" then have you setup
full-text indexes on the appropriate columns?? or are you going to use the
inefficient LIKE '%string%' approach?
Something to think aboutand the answer (combined with what database you
use) will determine the final
I have a text field that contains saved search criteria. The field is
called CRITERIA. I need to take the criteria in the field and make a valid
SQL query out of it. For example, I have a record in the table that has the
following in the CRITERIA field:
My string is: AUTHOR='GIESEMAN','SMIT
11 matches
Mail list logo
