>>09085000 2004-07-23 12:30 800 59.9
>>which i cant seem to break into individual pieces to send to an array
Ok, but now that you have the string, you can break it easily by treating it as a space delimited list, ie:
<CFQUERY...
INSERT INTO myTable...
rivercode = '#listGetAt(theString, 1, " ")#'
date = '#listGetAt(theString, 2, " ")#'
time = '#listGetAt(theString, 3, " ")#'
riverFlow = '#listGetAt(theString, 4, " ")#'
waterTemp = '#listGetAt(theString, 5, " ")#'
(check for the type of columns, and do not use quotes for numerical types)
..............
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
