Hello,
I'm trying to do a plp create, here's my code:
<CFSCRIPT>
stDDO = StructNew();
stDDO.numberofpaths = "";
stDDO.variablename = "";
stDDO.variablevalue = "";
</cfscript>
<cfoutput>here</cfoutput>
<cfa_PLPCREATE
name="testplp_tmp"
stDDO="#stDDO#"
handlerRoot="/plps/myobplp/"
handlerRelativePath="/plps/"
iTimeout="15"
bCreateStructure="False"
dataSource="#request.cfa.objectstore.dsn#"
r_bStructureWasCreated="bcreated"
r_objectID="plpid"
r_stOutput="stoutput" plpid="#CreateUUID()#"/>
And here's the error I get returned:
Error Diagnostic Information
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'pk_plp'. Cannot insert duplicate key in object 'plpprototypes'.
SQL = "insert into plpprototypes ( label,plpid,wddxid ) values ( ? , ? , ?
)"
Query Parameter Value(s) -
Parameter #1 = testplp_tmp
Parameter #2 = 16FB6E13-23EB-11D5-97F50080C8F5FAE5
Parameter #3 = 16FB6E17-23EB-11D5-97F50080C8F5FAE5
Data Source = "PLPDB"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (87:1) to (87:67) in the template
file D:\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDINSERT.CFM.
***
anyone have any ideas? I'd be most grateful.
Thanks to all,
Karling.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
