I am about to embark on doing alittle functionality to a site where
people will be able to upload CSV files. There will be different CSV
types for different data and I wondered if
a) there are some good CSV functions out there for parsing into db or
query (different delimiters, text qualifiers etc)
b) if anyone has done a "template" to check a CSV against? What I mean
is "this CSV should have x number of columns" and they are "x, y, z"
etc
Regards
Mark Drew
On Mon, 06 Sep 2004 13:47:39 +0200, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> Brant Winter wrote:
>
> > Just for testing I made a simple access db and made all the fields text
> > fields. I tried putting single quotes around all of the #qData.xxx# and all
> > I ended up with was qData.xxx in the resulting error message.
>
> If you choose to go the way of the single quotes, you should only
> add them around text fields, not around numbers and dates.
> However, it is *highly* recommended to use cfqueryparam.
>
> Jochem
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
