Advertisement
Advertisement
| 05.13.2008 at 11:43AM PDT, ID: 23398952 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: |
TSQL
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[usp_InsertOrUpdateDocumentsLibrary]
@AbstractKey uniqueidentifier = NULL,
@CreateDate datetime = NULL,
@ModifyDate datetime = NULL,
@Creator varchar(100) = NULL,
@Title varchar(200) = NULL,
@Keywords varchar(200) = NULL,
@xapMMDocumentID uniqueidentifier = NULL,
@format varchar(100) = NULL,
@ContentMain varchar(MAX) = NULL,
@FilePath varchar(200) = NULL,
@FileName varchar(100) = NULL,
@FileLocationURL varchar(200) = NULL,
@DateAdded datetime = NULL,
@Size int,
@Processed bit
AS
If Exists (Select * From tblDocumentsLibrary WHERE Abstract_Key = @AbstractKey
or (FilePath = @FilePath and FileName=@FileName))
UPDATE tblDocumentsLibrary
SET Abstract_Key = @AbstractKey,CreateDate = @CreateDate,ModifyDate = @ModifyDate,Creator = @Creator,Title = @Title,Keywords = @Keywords,xapMMDocumentID = @xapMMDocumentID,format = @format,ContentMain = @ContentMain,FilePath = @FilePath,FileName = @FileName,FileLocationURL = @FileLocationURL,DateAdded = @DateAdded,Size = @Size,Processed = @Processed
WHERE Abstract_Key = @AbstractKey
ELSE
INSERT INTO dbo.tblDocumentsLibrary
( Abstract_Key,CreateDate,ModifyDate,Creator,Title,Keywords,xapMMDocumentID,format,ContentMain,FilePath,FileName,FileLocationURL,DateAdded,Size,Processed
)
VALUES ( @AbstractKey,@CreateDate,@ModifyDate,@Creator,@Title,@Keywords,@xapMMDocumentID,@format,@ContentMain,@FilePath,@FileName,@FileLocationURL,@DateAdded,@Size,@Processed
)
coldfusion calling:
<cfloop query="abstractfiles">
<cfstoredproc procedure="usp_InsertOrUpdateDocumentsLibrary" datasource="svc" debug="yes">
<cfprocparam type="in" dbvarname="@AbstractKey" value="" null="yes" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="@FilePath" value="#abstractfiles.directory#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="@FileName" value="#abstractfiles.name#" cfsqltype="cf_sql_varchar">
<cfprocparam type="in" dbvarname="@Size" value="#abstractfiles.Size#" cfsqltype="cf_sql_numeric">
</cfstoredproc>
</cfloop>
|