#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Breckenridge, Colorado
    Posts
    2
    Rep Power
    0

    Question CF Host - MySQL and Text Files


    I was wondering if anyone knew of a host who'd let you upload a text file to populate a MySQL database? Or if anyone knows how to do this without having admin rights?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2001
    Location
    Washington DC, USA
    Posts
    156
    Rep Power
    14
    If the server happens to have PHP on it as well, check out phpMyAdmin - it's a web-based tool for managing a MySQL DB and a lot of web hosts have it installed.

    If not, how about uploading the text file to the server, and then writing a ColdFusion script to read it (CFFILE action="read"), CFLOOP (using newline, either #Chr(13)# or #Chr(10)# as a delimiter) to move through the file line-by-line and then CFINSERT to populate your table?

IMN logo majestic logo threadwatch logo seochat tools logo