On Thu, 3 Jul 2003, anthony wrote:
++ Hi,
++
++ i have many text like this
++ column1="great,null,nothing"
++ etc....
++ how would I insert text with commas as above in columns.
++
++ Should i do.
++ Insert into table values($text1,$text2,$text3)
++ ##where text1,text2, text3 has the same format as ###"great,null,nothing"
++
Hi,
Well one easy way of doing it is replacing "," with "\,". So that u can do an
insert with out any issues. But u should be taking care of these xtra char ("/")
while reading and updates. If u r using Perl, u could do it thru a s// while
reading and inserting.
Anil Menon
MIS Team.
To invent, you need a good imagination and a pile of junk. We have both.
- MIS @ Rhythm & Hues Studios.
