Hey - I am looking at this error and spinning my wheels trying to figure out
WHY I'm getting it. If I add a WHERE statement to the query below it works
fine, so why not a simple "select * from table" ??
Any ideas? I can't find any information online.
Server:
CFMX6.1
ACCESS DB
Thanks
JV
======error=====
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Record is deleted.
1 : <cfquery name='get_vtwo' datasource='#dsn#'>
2 : select *
3 : from RETURN_AUTHORIZATION
SQL select * from RETURN_AUTHORIZATION
DATASOURCE returns_version1
VENDORERRORCODE -1017
SQLSTATE HY109
=====end_error====
THROWS ERROR
<cfquery name='get_vtwo' datasource='#dsn#'>
select *
from RETURN_AUTHORIZATION
</cfquery>
WORKS FINE
<cfquery name='get_vtwo' datasource='#dsn#'>
select *
from RETURN_AUTHORIZATION
WHERE id = #id#
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241181
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
