Well you could leave it as is and use the List****() functions in CF.

Ade
  -----Original Message-----
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
  Sent: 06 October 2004 19:34
  To: CF-Newbie
  Subject: CF and SQL

  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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to