Anyone know how to set custom delimiters using a DSNless connection in CF?
I have the following which does work... except for the fact that it's
delimiting based on the commas(,), not the pipes (|).
<cfset connectstring =
"Driver={Microsoft Text Driver (*.txt;
*.csv)};Format=Delimited(|);Dbq=c:\inetpub\wwwroot\textfiles;
Extensions=asc,csv,tab,txt;Persist Security Info=False;">
<CFQUERY NAME="qry_text_monkey" DBTYPE="dynamic"
CONNECTSTRING="#connectstring#">
SELECT * from Equip99a.txt
</CFQUERY>
I've also created a Schema.ini file in the same directory to no avail:
[Equip99a.txt]
ColNameHeader = False
Format=Delimited(|)
CharacterSet = ANSI
Any ideas?
Thanks,
Orlando
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
