Answered
Update Query
I have a table that contains 230 unique records and another
with 20000. I want to update the second table using a comparison
between a common fields in both tables. My query is shown below.
However, when I run this query I get the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
The error occurred in C:\ColdFusion8\wwwroot\electrack\cfTest.cfm: line 10
8 : <body>
9 :
10 : <cfquery name="ConvertCNameToCNumber" datasource="#request.datasource#">
11 :
12 : Update PollingZtation p
How do I fix this. I am running windows vista.
Query:
However, when I run this query I get the following error:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
The error occurred in C:\ColdFusion8\wwwroot\electrack\cfTest.cfm: line 10
8 : <body>
9 :
10 : <cfquery name="ConvertCNameToCNumber" datasource="#request.datasource#">
11 :
12 : Update PollingZtation p
How do I fix this. I am running windows vista.
Query:
AdChoices