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
?
- 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
-
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
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
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
5 matches
Mail list logo