to answer your q, ID is a # (auto inc) ... but I'm using Access database. (yea lets not get into WHY)
anyways .. the error is not occuring because of the WHERE portion. that actually works perfect! however, a simple "select * from TABLE" statement is causing an error. Strange, huh? ----- Original Message ----- From: "Charlie Griefer" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Monday, May 22, 2006 5:04 PM Subject: Re: confused on error > 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:241183 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