Chad, you probably just need single quotes around
'#InSol.Name#' Single quotes let the database know
that you are inserting a string, for instance into a
TEXT field. They're easy to forget by mistake.
(and you may also be missing a </CFOUTPUT> (but that's
not likely the cause of your problem here))
Eron
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database
Im trying a UPDATE on a Access database, and im
getting an error
<cfquery name="addtoCJM" datasource="CJM.mdb"
dbtype="ODBC">
UPDATE JobInfoUpload
SET CheckedOut='Yes',
<cfoutput>CheckedOutBy=#InSol.Name#
Where '#URL.FileID#' =
JobInfoUpload.FileID</cfoutput>
</cfquery>
Everything is spelled correct, but i get an error
below. I have a feeling
it has something to do with my Yes/No Column in the
database.
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Hint: The cause of this error is usually that your
query contains a
reference to a field which does not exist. You should
verify that the
fields included in your query exist and that you have
specified their names
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes',
CheckedOutBy=chad Where
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a
general identifier of
(CFQUERY), occupying document position (25:1) to
(25:60) in the template
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows
98)
Query String: JobId=11&LoginID=1&FileID=48
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the
official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
