If your set on it being in one column you can use LIKE
example:
Select *
from log <!--table name-->
where arclog LIKE '%200102107%'
But i would probably import this data using TAB files and use the BCP
command utility. Search for BCP in the help doc's. If this is what your text
doc looks like you can build a table and them push the data into it using
BCP.
Once it is in a better format it will be alot easier to maintain.
thanks,
Curt
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 6:36 PM
To: CF-Server
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
