You saying
"20010107 132319 MSG Message Engine is Started."
and each line thereafter is in one big field? If that's the case, and the
field is "arclog",
then
WHERE arclog LIKE '%200102107%'
will pull it out... make sure you put the % on each end of the string in
question. With a CF var it'd be
WHERE arclog LIKE '%#variable#%'
--Scott
----- Original Message -----
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 09, 2001 4:03 PM
Subject: Searching
> I have a text file that I imported into SQL. here is a sample of it:
>
> 20010107 132319 MSG Message Engine is Started.
> 20010107 134037 JOB Job Engine is Started.
> 20010107 134038 MSG Message Engine is Started.
> 20010107 134041 DB Database Engine is Started.
> 20010107 134042 TAPE NEW DEVICE 1, [DEC DLT2000 15/30 GB840B]
> 20010107 134042 TAPE Device added to group
> 20010107 134042 TAPE Tape Engine is Started.
> 20010107 134853 DB Database Engine is Stopped.
> 20010107 135214 JOB Job Engine is Started.
> 20010107 135215 MSG Message Engine is Started.
> 20010107 135219 DB Database Engine is Started.
> 20010107 135220 TAPE Tape Engine is Started.
> 20010107 140022 JOB Job Engine is Started.
> 20010107 140023 MSG Message Engine is Started.
> 20010107 140026 DB Database Engine is Started.
> 20010107 140027 TAPE Tape Engine is Started.
> 20010107 140918 JOB Job Engine is Started.
> 20010107 140918 MSG Message Engine is Started.
> 20010107 140920 DB Database Engine is Started.
> 20010107 140922 TAPE Tape Engine is Started.
>
>
> When it is put into the database it is all in one column. I want to know
> how can I search that column using cf and only return info that i want
from
> a certain date.
>
> I tried
> Select *
> from log <!--table name-->
> where arclog = '200102107'
>
>
> It returns nothing. Would I be better off to use cffile and make it just
> read the file where it is on the server?
>
>
> Joshua Tipton
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
