Author: junparagas
Short Link:http://www.houseoffusion.com/groups/cf-ot/thread.cfm/threadid:15#27
I'm inserting the filename and directory path into my
sql database when a link is clicked based on the user
which I get from login. The update being done just
appends everything into one field in the database.
How can I get each file and directory inserted into
individual fields and be able to extract that
information basxed on the user account?
I'm not that familar with sql. Do I have to create a
relational database?
Now
---
field1 field2
bob c:\temp,c:\windows,c:\windows32
Want
----
field1 field2
bob c:\temp
bob c:\windows
bob c:\windows32
