Using ColdFusion 10
Lexical error: :/MMLData/D01/MML/000000/layouts/test.csv
The error occurred in C:/inetpub/wwwroot/edit.cfm: line 1
1 :
2 : SELECT * from D:/MMLData/D01/MML/000000/layouts/test.csv
3 :
JDBC URL: jdbc:csv:///?_CSV_Header=true;
Driver Name: com.hxtt.sql.text.TextDriver
|
|
Try "SELECT * from "D:/MMLData/D01/MML/000000/layouts/".test
|
Ok that worked sort of. I have a file that has no header record. Here is the error I receive:
Error Executing Database Query.
The table structure of Text Table D:/MMLData/D01/MML/000000/layouts/test.dmt is unknown. Please use CREATE TABLE to define a table structure once.
The error occurred in C:/inetpub/wwwroot/edit.cfm: line 1
1 :
2 : SELECT * from "D:/MMLData/D01/MML/000000/layouts/test.dmt"
3 :
Here is a sample of file:
FNAME,30,c,First Name
MI,1,c,Middle Initial
LNAME,30,c,Last Name
ADD1,50,c,Address 1
Here is the URL string:
jdbc:text:///?_CSV_Header=false;maxScanRows=5
Thanks.
Chad
|
>jdbc:text:///?_CSV_Header=false;maxScanRows=5
>2 : SELECT * from "D:/MMLData/D01/MML/000000/layouts/test.dmt"
You should use
jdbc:text:///?_CSV_Header=false;maxScanRows=5;csvfileExtension=dmt
|
If you use jdbc:csv:... , not jdbc:text:
For instance,
jdbc:csv:///?_CSV_Header=false;maxScanRows=5
Then your
SELECT * from "D:/MMLData/D01/MML/000000/layouts/test.dmt"
can work normal too.
|
Main
webmaster@hxtt.com