Re: confused on error
That "Record is Deleted" message can be an indication that you have a corrupt database. I would close all connections to the db, make a backup copy, then do a compact and repair. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241190 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
RE: confused on error
> Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver] Record is deleted. > > 1 : > 2 : select * > 3 : from RETURN_AUTHORIZATION > > SQLselect * from RETURN_AUTHORIZATION > DATASOURCE returns_version1 > VENDORERRORCODE -1017 > SQLSTATE HY109 My guess is that this is some sort of Access concurrency error. I would recommend that you stop the SequeLink services, see what happens when you open the Access database in Access, and restart the SequeLink services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241187 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
Re: confused on error
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" > 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 ) > > > > 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 : > > > 2 : select * > > > 3 : from RETURN_AUTHORIZATION > > > > > > SQLselect * from RETURN_AUTHORIZATION > > > DATASOURCE returns_version1 > > > VENDORERRORCODE -1017 > > > SQLSTATE HY109 > > > > > > =end_error > > > > > > > > > THROWS ERROR > > > > > > select * > > > from RETURN_AUTHORIZATION > > > > > > > > > WORKS FINE > > > > > > select * > > > from RETURN_AUTHORIZATION > > > WHERE id = #id# > > > > > > > > > > > > > > > ~| 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
Re: confused on error
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" 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 ) > > 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 : > > 2 : select * > > 3 : from RETURN_AUTHORIZATION > > > > SQLselect * from RETURN_AUTHORIZATION > > DATASOURCE returns_version1 > > VENDORERRORCODE -1017 > > SQLSTATE HY109 > > > > =end_error > > > > > > THROWS ERROR > > > > select * > > from RETURN_AUTHORIZATION > > > > > > WORKS FINE > > > > select * > > from RETURN_AUTHORIZATION > > WHERE id = #id# > > > > > > > > ~| 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
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 ) 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 : > 2 : select * > 3 : from RETURN_AUTHORIZATION > > SQLselect * from RETURN_AUTHORIZATION > DATASOURCE returns_version1 > VENDORERRORCODE -1017 > SQLSTATE HY109 > > =end_error > > > THROWS ERROR > > select * > from RETURN_AUTHORIZATION > > > WORKS FINE > > select * > from RETURN_AUTHORIZATION > WHERE id = #id# > > > ~| 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