-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> The BULK INSERT is not carried out if I CFINCLUDE the
> following into a
> template:
>
One idea occurs to me. Try making the CR/LF in ROWTERMINATOR
explicit instead of relying on CF to stick one in there.
Like so:
<!--- Read raw data from file --->
<cfquery name="bulkin" datasource="golfdata" username="" password="">
BULK INSERT MarketUpdate
FROM 'D:\website\htdocs\stockgolf\htdocs\data\eod.txt'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='#Chr(13)##Chr(10)#'
)
</cfquery>
> But THE SAME Bulk Insert as above works if I do it from Query
> Analyzer.
>
> Any suggestions would be appreciated.
Not tested, but I have a hunch that should do the trick.
The only other thing I can think of is a permissions thing on the
eod.txt file, but I think the CF/LF is the more likely culprit.
Best regards,
Zac Bedell
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBOhFenqvhLS1aWPxeEQJ0mACgi72VBz1QBebNASilHluMyOouwFEAn1Nq
mnJcp+qQ7KzSgXUlwqkGD12X
=kEXw
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
