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 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

Re: confused on error

2006-05-22 Thread Joe Velez
? - 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

Re: confused on error

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

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 : cfquery name='get_vtwo' datasource='#dsn#' 2 : select * 3 : from RETURN_AUTHORIZATION SQLselect * from RETURN_AUTHORIZATION

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