The id is being passed yet I am reciving the error below. Can anyone tell
me why. My database id is set to auto number.
Joshua Tipton
a href="delete.cfm?id=#id#"Delete/a
cfquery name="" datasource="gunlist" dbtype="ODBC"
UPDATE guns
setsold = '1'
WHERE (id = '#id#')/cfquery
1 Feb 2001 18:45:38 -0500
To: CF-Talk [EMAIL PROTECTED]
Subject: Not letting me update
The id is being passed yet I am reciving the error below. Can anyone tell
me why. My database id is set to auto number.
Joshua Tipton
a href="delete.cfm?id=#id#"Delete/a
cfquer
Joshua:
Try removing the single quotes around the 1. I am assuming that the sold
column is either set to a number or bit value in your database. If so that
would explain your error.
Sebastian
on 2/11/01 5:45 PM, Joshua Tipton at [EMAIL PROTECTED] wrote:
The id is being passed yet I am
Off the top of my head...
Is 'sold' a numerical field or a text? Is ID a numerical field or a text field?
You are referencing them both
as text fields. Off the top of my head, I'd say remove the quotes from both of them,
like this:
cfquery name="" datasource="gunlist" dbtype="ODBC"
Joshua Tipton wrote:
a href="delete.cfm?id=#id#"Delete/a
cfquery name="" datasource="gunlist" dbtype="ODBC"
UPDATE guns
setsold = '1'
WHERE (id = '#id#')/cfquery
Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
expression.
I am assuming that the
Take away '' from #ID# when it is a number you cant surround it in quotes.
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 11, 2001 6:46 PM
To: CF-Talk
Subject: Not letting me update
The id is being passed yet I am reciving the error below. Can
RE (id = '#id#')/cfquery
jon
- Original Message -
From: "Joshua Tipton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, February 11, 2001 6:45 PM
Subject: Not letting me update
The id is being passed yet I am reciving the error below. Can anyone t
7 matches
Mail list logo