
March 12th, 2008, 11:38 PM
|
|
Registered User
|
|
Join Date: Mar 2008
Posts: 5
Time spent in forums: 33 m 38 sec
Reputation Power: 0
|
|
Quote: | Originally Posted by dceera Hi all, on my CF page I am currently using the following statement to
run an append query in my Access database:
<cfstoredproc procedure = "Web_2006_Step_1" datasource="customer">
The problem is that I get an error message from CF saying the query
cannot be run because it would create duplicate values in the primary
key.
In Access, I usually just say ok, and it inserts the non-duplicate
records. Is there a way for this to happen when calling the query from
the CF page?
Thanks in advance !! |
If you are using MX version of CF, then you need to be using Components and cfscript to connect to your stored procedure. Then, add the parameters to your component and query except for the id . do the same with your stored procedure (take out any reference to your primary key.) It sounds as if you have the table set to auto generate and doing so won't allow you to explicity define a value for the field.
|