Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
murpg #1
Problem with an Update on a table.
I have been using this query for sometime now. For some reason it doesn't want
to work anymore. I have gone through to check my fields in the 2 access table
to make sure that they are the same. This is the error message that I get.
Error Occurred While Processing Request
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
Driver] Too few parameters. Expected 1.
Here is my code.
<!--- This query Updates all of the information once you have set the query
above --->
<cfquery name="qryupdate" datasource="ACAOLdir">
UPDATE OnlineDir INNER JOIN
Online_Update_050205 ON OnlineDir.CnBio_ID = Online_Update_050205.CnBio_ID
SET OnlineDir.CnBio_First_Name = Online_Update_050205.CnBio_First_Name,
OnlineDir.CnBio_Middle_Name = Online_Update_050205.CnBio_Middle_Name,
OnlineDir.CnBio_Last_Name = Online_Update_050205.CnBio_Last_Name,
OnlineDir.CnBio_Suffix_1 = Online_Update_050205.CnBio_Suffix_1,
OnlineDir.CnBio_Suffix_2 = Online_Update_050205.CnBio_Suffix_2,
OnlineDir.CnAdrSal_Addressee = Online_Update_050205.CnAdrSal_Addressee,
OnlineDir.CnAdrPrf_Addrline1 = Online_Update_050205.CnAdrPrf_Addrline1,
OnlineDir.CnAdrPrf_Addrline2 = Online_Update_050205.CnAdrPrf_Addrline2,
OnlineDir.CnAdrPrf_City = Online_Update_050205.CnAdrPrf_City,
OnlineDir.CnAdrPrf_State = Online_Update_050205.CnAdrPrf_State,
OnlineDir.CnAdrPrf_ZIP = Online_Update_050205.CnAdrPrf_ZIP,
OnlineDir.CnAdrPrf_CountryLongDscription =
Online_Update_050205.CnAdrPrf_CountryLongDscriptio n,
OnlineDir.Email = Online_Update_050205.Email,
OnlineDir.Fax = Online_Update_050205.Fax,
OnlineDir.Phone = Online_Update_050205.Phone,
OnlineDir.WebSite = Online_Update_050205.WebSite,
OnlineDir.CnMem_1_01_Cur_Category_description =
Online_Update_050205.CnMem_1_01_Cur_Category_descr iption,
OnlineDir.DACBR = Online_Update_050205.DACBR,
OnlineDir.CCSP = Online_Update_050205.CCSP,
OnlineDir.DABCO = Online_Update_050205.DABCO,
OnlineDir.DACAN = Online_Update_050205.DACAN,
OnlineDir.CACBT = Online_Update_050205.CACBT,
OnlineDir.DABCN = Online_Update_050205.DABCN,
OnlineDir.DACBSP = Online_Update_050205.DACBSP,
OnlineDir.DACBOH = Online_Update_050205.DACBOH,
OnlineDir.DACNB = Online_Update_050205.DACNB,
OnlineDir.DACRB = Online_Update_050205.DACRB,
OnlineDir.DACBN = Online_Update_050205.DACBN,
OnlineDir.DABCI = Online_Update_050205.DABCI,
OnlineDir.DABFP = Online_Update_050205.DABFP,
OnlineDir.DISPLAY = Online_Update_050205.DISPLAY,
OnlineDir.phonedisplay = Online_Update_050205.phonedisplay,
OnlineDir.faxdisplay = Online_Update_050205.faxdisplay,
OnlineDir.emaildisplay = Online_Update_050205.emaildisplay,
OnlineDir.websitedisplay = Online_Update_050205.websitedisplay,
OnlineDir.Password = Online_Update_050205.Password,
OnlineDir.Doctor_Display = Online_Update_050205.Doctor_Display,
OnlineDir.Doctor_Emaildisplay = Online_Update_050205.Doctor_Emaildisplay,
OnlineDir.Doctor_Faxdisplay = Online_Update_050205.Doctor_Faxdisplay,
OnlineDir.Doctor_Phone = Online_Update_050205.Doctor_Phone,
OnlineDir.Doctor_Website = Online_Update_050205.Doctor_Website
;
</cfquery>
murpg Guest
-
Update table from other table
Hi Experts, This topic is not relate to cf but I need your solution who have an idea about it I'm using sql server2000 for my database. I... -
Update two table in one datagrid
Dear all, I have created a dataset which gets the data from two table and show them in one datagrid. However, when I add the Edit column to the... -
update table with row locking
Hi, Is it possible to lock row(s) when updating a table, so another call for update( from different session) will be rejected and to be on hold... -
How do you update corresponding rows on the same table after a row on the table has been updated?
This is my goal: When specific columns in a row, in a table, are updated, corresponding columns in other rows in the same table need to be updated... -
UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE
UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE I need to update a table with distinct sums from another table. I will... -
Maneesh Tikkiwal #2 Re: Problem with an Update on a table.
What is this semicolen ';' doing just before closing the query? I know I may sound stupid, but remove it and try!!!
Maneesh Tikkiwal Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
