Here is how I use the tag:
..............
<CFFILE ACTION="UPLOAD"
FILEFIELD="ufile"
DESTINATION="q:\www\uploads\"
NAMECONFLICT="MAKEUNIQUE"
ACCEPT="*/*">
........
<cfset fname=file.serverdirectory & "\" & file.ServerFile>
........
.....
<cfif form.delim contains "TAB"> <cfset delim=chr(9)><cfelse><cfset
delim=","></cfif>
.....
<CFX_CSVToQuery
FILE="#fname#"
NAME="load" DELIMITER="#delim#"
ONBADROW="useanyway" >
</cfoutput>
</cfif>
<cfloop query="load">
yada yada yada
</cfloop>
HTH,
Steve
At 10:23 AM 5/10/2000 -0400, Joel Firestone wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_00AF_01BFBA69.C6743460
>Content-Type: text/plain;
> charset="Windows-1252"
>Content-Transfer-Encoding: quoted-printable
>
>"Stephen Garrett" <[EMAIL PROTECTED]> wrote in message =
>news:<[EMAIL PROTECTED]>...
>>=20
>> I actually gave up on the builtin query aspect of CFHTTP due to buggy
>> problems and used one of the gallery tags instead:
>>=20
>> Take a look at=20
>> CFX_CSVToQuery
>
>Steve:
>
>I used this before, and it would print everything for me, but I could =
>never use=20
>any of the results to write to another db. It would always say "Query =
>not found".=20
>And I did use all of the correct attributes. How did you get around it.
>
>Thanks.
>
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>Joel Firestone - Developer
>Delmarva Online
>http://www.dmv.com/
>
>------=_NextPart_000_00AF_01BFBA69.C6743460
>Content-Type: text/html;
> charset="Windows-1252"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content=3D"text/html; charset=3Dwindows-1252" =
>http-equiv=3DContent-Type>
><META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV>"Stephen Garrett" <<A=20
>href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>> wrote in =
>message <A=20
>href=3D"news:<">news:<</A><A=20
>href=3D"[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]">3.0.3.3=
>[EMAIL PROTECTED]</A>>...<BR>>=20
><BR>> I actually gave up on the builtin query aspect of CFHTTP due to =
>
>buggy<BR>> problems and used one of the gallery tags instead:<BR>> =
>
><BR>> Take a look at=20
><BR>>  =
>; =
>=20
>CFX_CSVToQuery<BR></DIV>
><DIV>Steve:</DIV>
><DIV> </DIV>
><DIV>I used this before, and it would print everything for me, but I =
>could never=20
>use </DIV>
><DIV>any of the results to write to another db. It would always say =
>"Query not=20
>found". </DIV>
><DIV>And I did use all of the correct attributes. How did you get around =
>
>it.</DIV>
><DIV> </DIV>
><DIV><FONT face=3DVerdana size=3D2>Thanks.</FONT></DIV>
><DIV> </DIV>
><DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>Joel =
>Firestone - Developer<BR>Delmarva Online<BR><A=20
>href=3D"http://www.dmv.com/">http://www.dmv.com/</A></DIV></BODY></HTML>
>
>------=_NextPart_000_00AF_01BFBA69.C6743460--
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
