cf file

[Guest]

hi just a small issue i have, i am using cffile to upload a csv file, the csv file has a id column which i use to add a id for each row

ie

<input type="hidden" name="ID_#getHTTP.CurrentRow#" value="#getHTTP.ID#">

can i have csv files without the id column and somehow use currentrow for the form element ID above?

[Guest]

I would think so. It shouldn't be difficult to try it out in your particular environment.

[Guest]

ok but how would i get the value of the form element ID from the currentrow?

[SafariTECH]

CSV reads in as "column1", "column2", etc etc

Therefore you would need to read the row from the CSV file and treat it as an array of values separated by a delimiter -- obviously a comma in this case. Therefore you would need to know what column the ID value is always in and call it that way.

i.e. ListGetAt(mylist,2) ... if ID was in position #2

[Guest]

ok think i get it, so if i have the csv with 3 columns

Fname, Sname, Phone

how would i get the id for each row?

[Newsgroup_User · Accepted solution]

craiglaw98 wrote:
> ok think i get it, so if i have the csv with 3 columns
>
> Fname, Sname, Phone
>
> how would i get the id for each row?

if you do not have an ID column in your csv, or a column which can be
used as ID, then you have to create it at parsing. you can use the
currentrow of csv file as id, for example...

--
Azadi Saryev
Sabai-dee.com
Vientiane, Laos
http://www.sabai-dee.com