Hi,
Is there a guide on how to setup the above driver in coldfusion MX 7 running on linux? Actually I have managed to load and query using the drive but there is this one query giving me some problem. Below is the sample query in cfml.
select * from "#ZipDest#/".#fnames#
It gives me parsing error when running the page
|
You can find "3. How to set up HXTT DBF with Coldfusion MX 6.1 Application Server?" at http://www.hxtt.net/dbf/faq.html#interoperability . For unix, you should use "jdbc:dbf:///yourDatabaseDir" as embedded jdbc url.
I guess that your issue should be resulted by your sql:
>select * from "#ZipDest#/".#fnames#
If #ZipDest# is your tableName, you should use: select * from "#ZipDest#/"
|
|
"#ZipDest#/" is actually the path to the dbf
|
>select * from "#ZipDest#/".#fnames#
>"#ZipDest#/" is actually the path to the dbf
You should use: "select * from "#ZipDest#".#fnames# . The last "/" character should be removed.
You can read "4. Can I setup only one datasource to access four servers for my Cold Fusion?" of http://www.hxtt.net/dbf/faq.html#remote if you wish to use full UNC path names in SQL.
|
JDBC URL : jdbc:DBF:/
Driver Class : com.hxtt.sql.dbf.DBFDriver
OS : Linux
When I issue the following query;
select * from /var/ww/html/main/ihq/1109clin
I got an error "Failed to parse: Stopped parse at /"
I am currently using a demo driver. This is the last hurdle before I can decide to buy one. Please help me. Thanks
|
/var/ww/html/main/ihq/1109clin isn't a UNC path.
You should use:
JDBC URL : jdbc:DBF:////var/ww/html/main/ihq/
select * from 1109clin
Or
JDBC URL : jdbc:DBF:////var/ww/html/main/
select * from ihq.1109clin
Or
JDBC URL : jdbc:DBF:////var/
select * from "ww/html/main/ihq".1109clin
Or
JDBC URL : jdbc:DBF:////
select * from "var/ww/html/main/ihq".1109clin
|
Followed your url setup and below are the results
JDBC URL : jdbc:DBF:////var/ww/html/main/ihq/
select * from 1109clin
OK
JDBC URL : jdbc:DBF:////var/ww/html/main/
select * from ihq.1109clin
Failed to parse: Can't continue parse
JDBC URL : jdbc:DBF:////var/
select * from "ww/html/main/ihq".1109clin
Error : Failed to parse: Can't continue parse
JDBC URL : jdbc:DBF:////
select * from "var/ww/html/main/ihq".1109clin
Error : Failed to parse: Can't continue parse
|
Main
webmaster@hxtt.com