Here's my code for that tag. The temporary.csv is a file written by
CFFILE The template imports a file, strips out some stuff, formats CFLF
how the tag likes it, then writes out to this file. The template loops
over about 20 files doing this with each.
<.CFX_CSVToQuery
FILE="#temppath#\temporary.csv"
NAME="csv"
LONGROWS="GOOD"
ONBADROW="USEANYWAY"
COLUMNS="#columns#"
STARTROW="3">
<.CFDUMP Var="#csv#">
The result is the CFDUMP shows just the column headings and no content
rows. A CFDUMP of the earlier variable that's the input to this tag,
gives all the records ok.
There doesn't appear to be any change in the format of the files I'm
getting. Although it's difficult to check because the content changes
from time to time. The files seem to be the same. I'm going to do a
line-by-line check though. I think that's a good suggestion.
Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of James
Silva
Sent: Friday, 28 February 2003 10:41 AM
To: CFAussie Mailing List
Subject: [cfaussie] RE: CFX_CSVToQuery tag just stopped working ... huh?
Hmmm...
What have you got the "ONBADROW" and "LONGROWSARE" parameters set to?
Also (long
shot) but there could have been a slight change in the CSV's you're
recieving.
Have you done a manual comparison?
_______________________
James Silva
Web Production
Gruden Pty Ltd
Tel: +61 02 9956 6388
Fax: +61 02 9956 8433
Email: [EMAIL PROTECTED]
Web: www.gruden.com
_______________________
> The weird bit about this, James, is that there is no error message.
> That's how come it went unnoticed for so long. The entire template
runs
> as designed, except that this tag doesn't work. (The next part of the
> job is to compare the results of the tag with records in a SQL table
and
> update if they're different. Since there was no difference, no
updating
> went on and the old values were retained.
>
> I can't think why there was no error message.
>
> I wrote another template to CFDUMP the results of the query, and the
it
> contained only the column headings.
>
> (Yes, I know I know - there's a logic error in the rest of the
template,
> but I can fix that ok. It's finding out how come this doesn't work)
>
> I can CFDUMP the CSV file after it's read in using CFFILE, so there
are
> definitely files for the tag to read.
>
> Puzzling huh.
>
>
>
> Cheers,
> Michael Kear
> Windsor, NSW, Australia
> AFP Webworks.
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
