I have the following task to do:
I have a list that is like
111111111, abc,
747466464, jdj,
484848848, utd,
... and so on.
What I have to do is write a script that looks like:
update table customer
set receiptNo = '1111111111'
where Cust_Code='abc'
update table customer
set receiptNo='747466464'
where Cust_Code='utd'
... and so on.
The list is a text file. Is there a way to parse this
list by saying that whenever it encounters ','(comma)
sign, goto where clause, then for the second ',' sign
goto the set clause.
What is the best way of parsing the file if there was
no comma. Supposing the list was like:
1111111111 abc
7474664564 xyz
etc.
Is there a built in function in ColdFusion to parse
the list in this way.
Appreciate it.
A Bajaria
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
