Are you
1. importing the CSV to SQL Server via ColdFusion? or
2. generating the CSV with ColdFusion then using DTS tools to import
the CSV to SQL Server?
If 2, then perhaps the problem is with the DTS tools. Apparently when
importing excel or csv, it uses the first 8 rows of your file to
I get the same error as you.
I noticed that outputting #structKeyList(arguments)# within
cfdocumentitem reveals a single key called attributes which
appears to be a blank struct. Seems whatever code is behind
cfdocumentitem is operating in a whole other scope.
Seems fine for output in the
You can put the directory name as part of the remotefile attribute of
the cfftp tag.
eg. remotefile=/pages/#building_name#_#unit#_gallery.txt
The directory attribute is for other cfftp actions
On Jan 28, 12:49 pm, SAMARIS Software rai...@ozemail.com.au wrote:
I am using the following code to
Hey Felix,
* Faster execution is definitely a benefit of stored procs for
intensive or repetitive tasks
* Centralised place for logic is definitely a good thing, but I would
suggest that it's better to have in ColdFusion not stored procs. In
some cases, not all business logic can be represented
I think the CAST to DATE in query of queries gives a timestamp which
still has the time part, so here's another suggestion:
It's not the most efficient way, but you could try pre-processing the
query data like this so that your startdate value only contains the
date part:
cfset