hi all
Does anyone have any experience with ODBC Data Source [Merant dBase/FoxPro
Driver] in CF admin?
I haven't used it before and cant seem to find any examples.
I have tried the simple queries:
<cfquery name="Qtransferrequests" datasource="temp1610" dbtype="ODBC">
SELECT STATION, ORG_ELMT
FROM t16101;
</cfquery>
<cfquery name="Qtransferrequests" datasource="temp1610" dbtype="ODBC">
DELETE t16101.*
FROM t16101;
</cfquery>
for the select I get:
unknown exception condition
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
for the delete I get the error:
ODBC Error Code = 37000 (Syntax error or access violation)
[MERANT][ODBC dBase driver]Missing FROM keyword in DELETE statement
SQL = "Delete t16101.* FROM t16101;"
I can verify the connection in CF Admin and it says its OK
any examples would be a great help
Thanks
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
