is ID a numeric datatype or a string? if it's a string you'll need single quotes around '#id#' (or better yet, a <cfqueryparam>)
On 5/22/06, joe velez <[EMAIL PROTECTED]> wrote: > 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:241182 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54