Not completely sure what you database structure is, but try
SELECT *
FROM log <!--table name-->
WHERE LOCATE(arclog, '200102107') > 0
Todd
----- Original Message -----
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 09, 2001 6: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
