Re: confused on error

2006-05-22 Thread Jim Wright
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 ~

RE: confused on error

2006-05-22 Thread Dave Watts
> 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 >

Re: confused on error

2006-05-22 Thread Charlie Griefer
ment 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

Re: confused on error

2006-05-22 Thread Joe Velez
. 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 &#x

Re: confused on error

2006-05-22 Thread Charlie Griefer
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 t