ah sorry, my bad. i read your examples backwards. SQLSTATE HY109 refers to an invalid cursor. Is this just a straightforward select statement from a basic database table or is there more going on behind the scenes (like a cursor)?
On 5/22/06, Joe Velez <[EMAIL PROTECTED]> wrote: > 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" <[email protected]> > 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:241185 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
