Re: UPDATE on a MS Access Database
UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy='#InSol.Name#' WHERE FileID = #URL.FileID# -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 > > > > UPDATE JobInfoUpload > SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# > Where '#URL.FileID#' = JobInfoUpload.FileID > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
well, you do have your where clause reversed, and with apostrophes. is it a numeric field? if so, take out the 's, reverese it, and you should be good. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -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 UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
I think you need single quotes around the second value you are setting, and your where clause looks backwards: Change: CheckedOutBy=#InSol.Name# To: CheckedOutBy='#InSol.Name#' Change: Where '#URL.FileID#' = JobInfoUpload.FileID To: Where JobInfoUpload.FileID = '#URL.FileID#' (You may need to lose the single quotes on this one - is it a numeric field?) Also, try replacing 'Yes' with True (no quotes) Bob -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: 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 UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE on a MS Access Database
Actually the problem is with your s You don't need them within Try this: UPDATE JobInfoUpload SET CheckedOut = 'Yes', CheckedOutBy = #InSol.Name# Where JobInfoUpload.FileID = '#URL.FileID#' - - - Jeanne - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 30, 2000 11:51 AM Subject: UPDATE on a MS Access Database > Im trying a UPDATE on a Access database, and im getting an error > > > > UPDATE JobInfoUpload > SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# > Where '#URL.FileID#' = JobInfoUpload.FileID > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE on a MS Access Database
Notice the quotes I added around #insol.name#. Try it. Although I don't think it should make a difference, I'd swap the where condition too. As below: UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy='#InSol.Name#' Where JobInfoUpload.FileID = '#URL.FileID#' Chad Gray wrote: > > Im trying a UPDATE on a Access database, and im getting an error > > > UPDATE JobInfoUpload > SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# > Where '#URL.FileID#' = JobInfoUpload.FileID > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
Switch the where statement to UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where JobInfoUpload.FileID = '#URL.FileID#' -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 UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
or maybe this (use field = value): UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where JobInfoUpload.FileID = '#URL.FileID#' > -Message d'origine- > De: Chad Gray [SMTP:[EMAIL PROTECTED]] > Date: Thursday, November 30, 2000 11:52 AM > À:CF-Talk > Objet:UPDATE on a MS Access Database > > Im trying a UPDATE on a Access database, and im getting an error > > > > UPDATE JobInfoUpload > SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# > Where '#URL.FileID#' = JobInfoUpload.FileID > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
try this: UPDATE JobInfoUpload SET CheckedOut=1, CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID > -Message d'origine- > De: Chad Gray [SMTP:[EMAIL PROTECTED]] > Date: Thursday, November 30, 2000 11:52 AM > À:CF-Talk > Objet:UPDATE on a MS Access Database > > Im trying a UPDATE on a Access database, and im getting an error > > > > UPDATE JobInfoUpload > SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# > Where '#URL.FileID#' = JobInfoUpload.FileID > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE on a MS Access Database
Do you have your clause flip-flopped? Where '#URL.FileID#' = JobInfoUpload.FileID Should be: Where JobInfoUpload.FileID='#URL.FileID#' - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 30, 2000 10:51 AM Subject: UPDATE on a MS Access Database > Im trying a UPDATE on a Access database, and im getting an error > > > > UPDATE JobInfoUpload > SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# > Where '#URL.FileID#' = JobInfoUpload.FileID > > > 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/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE on a MS Access Database
Chad, are you sure, you have the right datasourcename ? It looks more like the raw DB-name you used. Uwe Mail: [EMAIL PROTECTED] WWW: www.sdsolutions.de - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 30, 2000 5:51 PM Subject: UPDATE on a MS Access Database Im trying a UPDATE on a Access database, and im getting an error UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
you don't need the cfoutputs in the query, just the # signs will do, and you probably need single quotes around #insol.name#. Also, if JobInfoUpload.FileID is a numeric field then you need to remove the single quotes from #URL.FileID#. Also, I'd reverse the where clause parameters to make it more readable. Try: UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy='#InSol.Name#' Where JobInfoUpload.FileID = '#URL.FileID#' ~Simon > Simon Horwith > Certified ColdFusion Developer > Fig Leaf Software > 1400 16th St NW, # 220 > Washington DC 20036 > 202.797.6570 (direct line) > www.figleaf.com > -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 UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
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 (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 UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE on a MS Access Database
You don't need the s inside of a . Also, you need single quotes around #InSol.name#, or else the database thinks "chad" is a field name and will compain when it can't find it. Todd Ashworth - Original Message - From: "Chad Gray" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 30, 2000 11:51 AM Subject: UPDATE on a MS Access Database | Im trying a UPDATE on a Access database, and im getting an error | | | | UPDATE JobInfoUpload | SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# | Where '#URL.FileID#' = JobInfoUpload.FileID | | | 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/cf-talk@houseoffusion.com/ | Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UPDATE on a MS Access Database
Chad, Is your last line of code switched around? Should it read Where JobInfoUpload.FileID = '#URL.FileID#' instead? Mark Mark Wimer, Bird Point Count Database American Bird Conservancy, c/o USGS-Patuxent Wildlife Research Center 12100 Beech Forest Road, Laurel, MD 20708-4038 Ph: 301-497-5596 Email: [EMAIL PROTECTED] Im trying a UPDATE on a Access database, and im getting an error UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UPDATE on a MS Access Database
Here are a couple of things. When you get too few parameters, you have messed up your SQL statement: here is where you messed up: Checkedoutby needs single quotes around it like checked out. I don't know if this is mandatory or not, but you might want to switch JobInfoUpload.FileID and #URLFileID# around. Field names come first. HTH Brandon Brandon Behrens Developer Momentum Software http://www.momentumsoftware.com 512.236.1517 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 30, 2000 10: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 UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=#InSol.Name# Where '#URL.FileID#' = JobInfoUpload.FileID 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
