Below is an error Im getting from a transaction that I didn't write...
and the developer is long since gone...he sort of documentmented
his code...but not really. This is the result from a form input.
Below the result...is the transaction statement.
Below the transaction statement is a function the developer used to
increment a new record in the table nxstar_e...am I wrong ? Its used
as an includes BEFORE the transaction statement gets called and thats
where the problem exists. Hence the error message below. Would
someone like clue me into what in the hell is going on here...I think
Im outta my depth. Ive pulled this thing apart six ways from sunday
and it still doesn't work...perhaps it never worked...I dont know.
Help
++++++++++++++++++++++++++++++
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'PK__nxstar_e__076C2375': Attempt to insert duplicate key
in object 'nxstar_e'.
SQL = "insert into nxstar_e ( tar_num, type, tar_status, synopsis, description,
prod_id, symptom_code, cust_code, bus_name, address1, address2,
address3, address4, contact, phone, entered_by, entered_date,
entered_time, opened_date, opened_time, priority, assigned_to,
assigned_by, assigned_date, assigned_time ) values
( 5456, 'CASE', 'NEW', 'sdsdfsdfsdf', 'sdfsdfsdfsdfsdfsdfsdfsdf', ----etc...)
Data Source = "CCare Web"
The error occurred while processing an element with a general
identifier of (CFQUERY), occupying document position (23:1) to (23:52).
+++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++++++
<cftransaction>
<cfset lsTableName = "nxstar_e">
<cfset lsColumnName = "tar_num">
<cfinclude template = "../common/cc_get_nextid.cfm">
<cfset lsODBCDate = '#CreateODBCDate("#Now()#")#'>
<cfset lsTime = '#TimeFormat("#Now()#", "HH:MM:SS")#'>
<cfset llTarNum = #llNextID#>
<cfquery name="qInsertCase" datasource="#DSNCCare#">
insert into nxstar_e (
tar_num, type,
tar_status, synopsis, description,
prod_id,
symptom_code,
cust_code, bus_name, address1,
address2, address3, address4,
contact, phone,
entered_by, entered_date, entered_time,
opened_date, opened_time,
priority,
assigned_to, assigned_by, assigned_date, assigned_time
)
values
(
#llTarNum#, 'CASE',
'NEW', '#synopsis#', '#description#',
<cfif '#prod_id_other#' is not ''>
'#prod_id_other#',
<cfelse>
'#prod_id#',
</cfif>
'#symptom_code#',
#cust_code#, '#qCustomer.bus_name#', '#qCustomer.address1#',
'#qCustomer.address2#', '#qCustomer.address3#', '#qCustomer.address4#',
'#Contact_Name#', '#phone#',
'WEB', #lsODBCDate#, '#lsTime#',
#lsODBCDate#, '#lsTime#',
2, 'WEB', 'WEB', #lsODBCDate#, '#lsTime#'
)
</cfquery>
<cfset lsTableName = "nxsnotes">
<cfset lsColumnName = "note_id">
<cfinclude template = "../common/cc_get_nextid.cfm">
<cfset lsODBCDate = '#CreateODBCDate("#Now()#")#'>
<cfset lsTime = '#TimeFormat("#Now()#", "HH:MM:SS")#'>
<cfquery name="qInsertActivity" datasource="#DSNCCare#">
insert into nxsnotes (
note_id, id, topic, type,
synopsis,
entered_by, entered_date, entered_time,
opened_date, opened_time,
completed, completed_by, completed_date, completed_time,
minutes_spent, billable
)
values
(
#llNextID#, #llTarNum#, 'CASE', 'CCARE',
'Time spent adding New Case',
'WEB', #lsODBCDate#, '#lsTime#',
#lsODBCDate#, '#lsTime#',
'CCARE', 'WEB', #lsODBCDate#, '#lsTime#',
1, 'N'
)
</cfquery>
</cftransaction>
++++++++++++++++++++++++++++++++
<cfquery name="qGetLastUsed" datasource="#DSNCCare#">
select last_used
from nxsprimr
where table_name = '#lsTableName#'
and column_name = '#lsColumnName#'
</cfquery>
<cfif IsNumeric(qGetLastUsed.last_used)>
<!-- A row was found in the primary key table -->
<!-- Increment the value and update the table -->
<cfset llNextID = qGetLastUsed.last_used + 1>
<cfquery name="qUpdatePrimary" datasource="#DSNCCare#">
update nxsprimr
set last_used = #llNextID#
where table_name = '#lsTableName#'
and column_name = '#lsColumnName#'
</cfquery>
<cfelse>
<!-- A row was not found in the primary key table -->
<!-- We need to create the row -->
<cfquery name="qGetMax" datasource="#DSNCCare#">
select max(#lsColumnName#) mymax
from #lsTableName#
</cfquery>
<cfset llNextID = qGetMax.mymax + 1>
<cfquery name="qInsertPrimary" datasource="#DSNCCare#">
insert into nxsprimr (table_name, column_name, last_used)
values ('#lsTableName#', '#lsColumnName#', #llNextID#)
</cfquery>
</cfif>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
