Possibly better code to use would be.
> Select *
> from log <!--table name-->
> where arclog Like '200102107%' this will return all rows that start with
your date range
----- Original Message -----
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 10:36 AM
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
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
