/* **********************************************************************************
CREATED BY: Nadya Nosonovsky
CREATED ON: 02/28/2003
PURPOSE: This procedure Create a Shopping Cart Info for the given user
It creates new CartID in Cart table, if it doesn't exist yet
Otherwise updates ModiDate field with current time
Inserts info to CartContent and CartDetail tables
INPUTS: @tcUserID varchar(20) - UserID
@tnNumOfRecords int - Number of selected child records
@tcDescription text - "Bundle" description
@tcCreditCategory char(1) - B/F/L (Bankruptcy/Foreclosure/Liens)
@tcSelectionCriteria text - User-defined criteria from the Search page
@tcListOfCodes varchar(500) - comma-delimited list of CredIDs
OUTPUTS:
( RETURN CODES )
0 - Successful
1 - UserID is NULL
2 - Tables do not exist
Actual error code for updates/insert
@tnCartID int - CartID for this User
USAGE EXAMPLE:
declare @tnCartID int, @RetStat int
EXECUTE @RetStat = USP_Insert_ShoppingCartInfo
'241111111111' ,
5 ,
'Some descr' ,
'B' ,
'some crit' ,
'1,2,3' ,
@tnCartID OUTPUT
print 'Cart ID =' + RTRIM(CONVERT(varchar(30), @tnCartID)) + ' Error code = ' + RTRIM(CONVERT(varchar(30), @RetStat))
GO
UPDATES (date,name,details):
********************************************************************************** */
It gives me an error