UPDATE JobInfoUpload
SET CheckedOut='Yes', <cfoutput>CheckedOutBy='#InSol.Name#'
WHERE FileID = #URL.FileID#</cfoutput>
-David
On Thu, 30 Nov 2000 11:51:48 -0500 Chad Gray <[EMAIL PROTECTED]> writes:
> 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
