Select * from textfile.txt

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Select * from textfile.txt

    Hi,

    I want to use a .txt as DB. The querying works with SELECT * FROM textfile.txt
    and returns me the number of rows. The only problem i have is that I cant
    figure out how to get multiple columns.

    The textfile is ; delimited and the first row are the columnnames.
    (FIELD1;FIELD2;FIELD3). But when I ask a queryname.columnlist it returns me
    "FIELD1;FIELD2;FIELD3" as one field.

    Using an RDBMS is not an option:(

    Does some1 have a tip?

    TIA!

    -Jonathan

    h3m3r0id Guest

  2. Similar Questions and Discussions

    1. Can a .swf file moniter for textfile changes?
      I have a .swf file that loads data from a txt file...can that same file watch to see if that txt file is updated on the hard drive? Thanks, Trint
    2. ASP RecordSet output to a .CSV textfile
      After I've performed a query and held the data in a RecordSet (rsQuery), can I dump the recordset into a comma separated text file? How? --...
    3. create textfile using asp
      i want to create atext file using asp(filesystemobject) but my explorer hangs on Why? ...
    4. Read textfile
      Hi, I am using DreamWeaver MX for building a weblink page. I would like to read the links out of a textfile because a textfile can be updated...
    5. ^M...........................How do I get rid of it in my textfile???
      RoadKill wrote: ^M = ASCII 13 = CTRL+M = <CR> ^J = ASCII 10 = CTRL+J = <LF> DOS and thus Windows usually uses <CR><LF> pairs as record...
  3. #2

    Default Re: Select * from textfile.txt

    After a lot of reading and google-ing I found the answer.

    [url]http://cfdj.sys-con.com/read/41847.htm[/url]

    Seems you have to use the comma as delimiter


    h3m3r0id Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139