Microsoft OLE DB Provider for SQL Server error '80040e14'

Microsoft OLE DB Provider for SQL Server error '80040e14'

Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.

/ezservices/onlinebonds/dataprocessing.asp, line 96


Have above problems from the following asp code, and I do to know how to fix it. any idea?:

 set objCmd = Server.CreateObject("Adodb.Command")
                         with objCmd
                              .ActiveConnection = con
                              .CommandText = "Insert_tblQuotes"
                              .CommandType = adCmdStoredProc
                              .Parameters.Append .CreateParameter("@BondNo"          ,adInteger,adParamInput,1,bondno)
                            .Parameters.Append .CreateParameter("@Suffix"          ,adVarChar,adParamInput,5,suffix)
                              .Parameters.Append .CreateParameter("@PowerNo"         ,adVarChar,adParamInput,1,powerno)
                              .Parameters.Append .CreateParameter("@FromDate"        ,adDBTimeStamp,adParamInput,10,cdate(fromdate))
                              .Parameters.Append .CreateParameter("@ToDate"          ,adDBTimeStamp,adParamInput,10,cdate(todate))
                              .Parameters.Append .CreateParameter("@ExeDate"         ,adDBTimeStamp,adParamInput,10,cdate(exedate))
                            .Parameters.Append .CreateParameter("@SuretyLine"      ,adInteger,adParamInput,2,suretyline)
                              .Parameters.Append .CreateParameter("@Premium"         ,adCurrency,adParamInput,10,premium)
                              .Parameters.Append .CreateParameter("@CommissionRate"  ,adCurrency,adParamInput,10,commissionrate)
                              .Parameters.Append .CreateParameter("@Commission"      ,adCurrency,adParamInput,10,commission)
                              .Parameters.Append .CreateParameter("@Surcharge"       ,adCurrency,adParamInput,10,surcharge)
                              .Parameters.Append .CreateParameter("@NetPremium"      ,adCurrency,adParamInput,10,netpremium)
                              .Parameters.Append .CreateParameter("@BondAmount"      ,adCurrency,adParamInput,10,bondamount)
                              .Parameters.Append .CreateParameter("@StateCode"         ,adInteger,adParamInput,2,statecode)
                              .Parameters.Append .CreateParameter("@BondType"        ,adVarChar,adParamInput,10,bondcode)
                              .Parameters.Append .CreateParameter("@PrincipalID"     ,adInteger,adParamInput,4,pid)
                              .Parameters.Append .CreateParameter("@ObligeeID"       ,adInteger,adParamInput,4,oid)
                              .Parameters.Append .CreateParameter("@AgentID"         ,adInteger,adParamInput,4,aid)
                              .Parameters.Append .CreateParameter("@CreditTranID1"   ,adInteger,adParamInput,2,creditTranID1)
                              .Parameters.Append .CreateParameter("@CreditTranID2"   ,adInteger,adParamInput,2,creditTranID2)
                              .Parameters.Append .CreateParameter("@AttyInFactID"    ,adInteger,adParamInput,10,attyinfactid)
                              .Parameters.Append .CreateParameter("@UserID"             ,adInteger,adParamInput,10,userID)
                              .Parameters.Append .CreateParameter("@SubmittedDate"   ,adDBTimeStamp,adParamInput,10,cdate(submittedDate))
                              .Parameters.Append .CreateParameter("@StatusID"             ,adInteger,adParamInput,5,statusID)
                              .Parameters.Append .CreateParameter("@suretyCompanyID" ,adInteger,adParamInput,4,suretycoID)
                              .Parameters.Append .CreateParameter("@MisRefid"        ,adInteger,adParamInput,2,MisRefid)
                              'output parameter
                              .Parameters.Append .CreateParameter("@quoteid",adInteger,adParamOutput,,0)
                              .Execute,,adExecuteNoRecords
                               quoteID = .Parameters("@quoteid")
                               session("quoteid") = quoteID
                     end with
'*****************************************************************************************************************
'here is the  stored procedures:

CREATE PROCEDURE [dbo].[Insert_tblQuotes]
      @QuoteID int output,
      @BondNo int,
      @Suffix text,
      @PowerNo int,
      @FromDate datetime,
      @ToDate datetime,
      @ExeDate datetime,
      @SuretyLine int,
      @Premium money,
      @CommissionRate decimal(18, 0),
      @Commission money,
      @Surcharge money,
      @NetPremium money,
      @BondAmount money,
      @StateCode int,
      @BondType text,
      @PrincipalID int,
      @ObligeeID int,
      @AgentID int,
      @CreditTranID1 int,
      @CreditTranID2 int,
      @AttyInFactID int,
      @UserID int,
      @SubmittedDate datetime,
      @StatusID int,
      @SuretyCompanyID int,
      @MISrefid int
AS
SET NOCOUNT ON

INSERT INTO  [tblQuotes]
(
                  [BondNo],
                  [Suffix],
                  [PowerNo],
                  [FromDate],
                  [ToDate],
                  [ExeDate],
                  [SuretyLine],
                  [Premium],
                  [CommissionRate],
                  [Commission],
                  [Surcharge],
                  [NetPremium],
                  [BondAmount],
                  [StateCode],
                  [BondType],
                  [PrincipalID],
                  [ObligeeID],
                  [AgentID],
                  [CreditTranID1],
                  [CreditTranID2],
                  [AttyInFactID],
                  [UserID],
                  [SubmittedDate],
                  [StatusID],
                  [SuretyCompanyID],
                  [MISrefid]
)
VALUES
(
                  @BondNo,
                  @Suffix,
                  @PowerNo,
                  @FromDate,
                  @ToDate,
                  @ExeDate,
                  @SuretyLine,
                  @Premium,
                  @CommissionRate,
                  @Commission,
                  @Surcharge,
                  @NetPremium,
                  @BondAmount,
                  @StateCode,
                  @BondType,
                  @PrincipalID,
                  @ObligeeID,
                  @AgentID,
                  @CreditTranID1,
                  @CreditTranID2,
                  @AttyInFactID,
                  @UserID,
                  @SubmittedDate,
                  @StatusID,
                  @SuretyCompanyID,
                  @MISrefid
)

SET @QuoteID = @@IDENTITY
GO
riskyricky1972Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Duane LawrenceCommented:
I can tell you it is one of the 4 datetimes below that is being inserted into and integer field.  I would have to see a script of the table.

     @FromDate datetime,
     @ToDate datetime,
     @ExeDate datetime,
     @SubmittedDate datetime,

Use a cast or a convert

convert( int, @FromDate)

This will allow you to experiment a little if you want
SELECT CONVERT(INT, GETDATE())
SELECT CONVERT(INT, '01-01-2000')


Duane

0
sukumar_diyaCommented:
hi,
The problem may be in the date format. Try to send the date values as string and convert it as datetime in the stored procedure using the convert statement like convert(datetime,@fromdate,120).

Try this...
Hope it will help you,
Suku
0
riskyricky1972Author Commented:
how to add convert funtion into my existing stored procedures?

Thank you
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Duane LawrenceCommented:
CREATE PROCEDURE [dbo].[Insert_tblQuotes]
     @QuoteID int output,
     @BondNo int,
     @Suffix text,
     @PowerNo int,
     @FromDate datetime,
     @ToDate datetime,
     @ExeDate datetime,
     @SuretyLine int,
     @Premium money,
     @CommissionRate decimal(18, 0),
     @Commission money,
     @Surcharge money,
     @NetPremium money,
     @BondAmount money,
     @StateCode int,
     @BondType text,
     @PrincipalID int,
     @ObligeeID int,
     @AgentID int,
     @CreditTranID1 int,
     @CreditTranID2 int,
     @AttyInFactID int,
     @UserID int,
     @SubmittedDate datetime,
     @StatusID int,
     @SuretyCompanyID int,
     @MISrefid int
AS
SET NOCOUNT ON

INSERT INTO  [tblQuotes]
(
               [BondNo],
               [Suffix],
               [PowerNo],
               [FromDate],
               [ToDate],
               [ExeDate],
               [SuretyLine],
               [Premium],
               [CommissionRate],
               [Commission],
               [Surcharge],
               [NetPremium],
               [BondAmount],
               [StateCode],
               [BondType],
               [PrincipalID],
               [ObligeeID],
               [AgentID],
               [CreditTranID1],
               [CreditTranID2],
               [AttyInFactID],
               [UserID],
               [SubmittedDate],
               [StatusID],
               [SuretyCompanyID],
               [MISrefid]
)
VALUES
(
    @BondNo,
    @Suffix,
    @PowerNo,
    CONVERT(INT, @FromDate),
    CONVERT(INT, @ToDate),
    CONVERT(INT, @ExeDate),
    @SuretyLine,
    @Premium,
    @CommissionRate,
    @Commission,
    @Surcharge,
    @NetPremium,
    @BondAmount,
    @StateCode,
    @BondType,
    @PrincipalID,
    @ObligeeID,
    @AgentID,
    @CreditTranID1,
    @CreditTranID2,
    @AttyInFactID,
    @UserID,
    CONVERT(INT, @SubmittedDate),
    @StatusID,
    @SuretyCompanyID,
    @MISrefid
)

SET @QuoteID = @@IDENTITY
GO
0
riskyricky1972Author Commented:
I edited the stored procedure as same as the one above. it should show me same error....
0
sukumar_diyaCommented:
Hi,
Please tell me in which format you are sending the date.
Like 2004-11-10 (yyyy-mm-dd) or 11-30-2004(MM-dd-yyyy)

if ur date format from the front end is the first one ie.(yyyy-mm-dd) then try the following ....
if your date format style is different then please refer the CONVERT in Sql Books Online and change the style ..
example for mm-dd-yyyy format use convert(datetime,@format,101)....

Try this ..
Suku


CREATE PROCEDURE [dbo].[Insert_tblQuotes]
     @QuoteID int output,
     @BondNo int,
     @Suffix text,
     @PowerNo int,
     @FromDate datetime,
     @ToDate datetime,
     @ExeDate datetime,
     @SuretyLine int,
     @Premium money,
     @CommissionRate decimal(18, 0),
     @Commission money,
     @Surcharge money,
     @NetPremium money,
     @BondAmount money,
     @StateCode int,
     @BondType text,
     @PrincipalID int,
     @ObligeeID int,
     @AgentID int,
     @CreditTranID1 int,
     @CreditTranID2 int,
     @AttyInFactID int,
     @UserID int,
     @SubmittedDate datetime,
     @StatusID int,
     @SuretyCompanyID int,
     @MISrefid int
AS
SET NOCOUNT ON

INSERT INTO  [tblQuotes]
(
               [BondNo],
               [Suffix],
               [PowerNo],
               [FromDate],
               [ToDate],
               [ExeDate],
               [SuretyLine],
               [Premium],
               [CommissionRate],
               [Commission],
               [Surcharge],
               [NetPremium],
               [BondAmount],
               [StateCode],
               [BondType],
               [PrincipalID],
               [ObligeeID],
               [AgentID],
               [CreditTranID1],
               [CreditTranID2],
               [AttyInFactID],
               [UserID],
               [SubmittedDate],
               [StatusID],
               [SuretyCompanyID],
               [MISrefid]
)
VALUES
(
    @BondNo,
    @Suffix,
    @PowerNo,
    CONVERT(datetime, @FromDate,120),
    CONVERT(datetime, @ToDate,120),
    CONVERT(datetime, @ExeDate,120),
    @SuretyLine,
    @Premium,
    @CommissionRate,
    @Commission,
    @Surcharge,
    @NetPremium,
    @BondAmount,
    @StateCode,
    @BondType,
    @PrincipalID,
    @ObligeeID,
    @AgentID,
    @CreditTranID1,
    @CreditTranID2,
    @AttyInFactID,
    @UserID,
    CONVERT(datetime, @SubmittedDate,120),
    @StatusID,
    @SuretyCompanyID,
    @MISrefid
)

SET @QuoteID = @@IDENTITY
GO

0
riskyricky1972Author Commented:
the date format is 11/15/04

which number i should use?
0
sukumar_diyaCommented:
use 1 as date style

Ex:
convert(datetime,'11/15/04',1)

sukumar
0
riskyricky1972Author Commented:
I have the following stored procedure for testing. but it still does not work.

CREATE PROCEDURE [dbo].[Insert_tblQuotes]
      @QuoteID int output,
      @BondNo int,
      @Suffix text,
      @PowerNo int,
      @FromDate datetime,
      @ToDate  datetime,
      @ExeDate datetime,
      @SuretyLine int,
      @Premium money,
      @CommissionRate decimal(18, 0),
      @Commission money,
      @Surcharge money,
      @NetPremium money,
      @BondAmount money,
      @StateCode int,
      @BondType text,
      @PrincipalID int,
      @ObligeeID int,
      @AgentID int,
      @CreditTranID1 int,
      @CreditTranID2 int,
      @AttyInFactID int,
      @UserID int,
      @SubmittedDate datetime,
      @StatusID int,
      @SuretyCompanyID int,
      @MISrefid int



 
AS

 
SET NOCOUNT ON

 
INSERT INTO  [tblQuotes]
(


                  [BondNo],
                  [Suffix],
                  [PowerNo],
                  [FromDate],
                  [ToDate],
                  [ExeDate],
                  [SuretyLine],
                  [Premium],
                  [CommissionRate],
                  [Commission],
                  [Surcharge],
                  [NetPremium],
                  [BondAmount],
                  [StateCode],
                  [BondType],
                  [PrincipalID],
                  [ObligeeID],
                  [AgentID],
                  [CreditTranID1],
                  [CreditTranID2],
                  [AttyInFactID],
                  [UserID],
                  [SubmittedDate],
                  [StatusID],
                  [SuretyCompanyID],
                  [MISrefid]
)
VALUES
(
                  @BondNo,
                  @Suffix,
                  @PowerNo,
                  convert(datetime , '01/01/04',1),
                  convert(datetime , '01/01/04',1),
                  convert(datetime , '01/01/04',1),
                  @SuretyLine,
                  @Premium,
                  @CommissionRate,
                  @Commission,
                  @Surcharge,
                  @NetPremium,
                  @BondAmount,
                  @StateCode,
                  @BondType,
                  @PrincipalID,
                  @ObligeeID,
                  @AgentID,
                  @CreditTranID1,
                  @CreditTranID2,
                  @AttyInFactID,
                  @UserID,
                  convert(datetime,'01/01/04',1),
                  @StatusID,
                  @SuretyCompanyID,
                  @MISrefid
)

SET @QuoteID = @@IDENTITY
GO
0
sukumar_diyaCommented:
Friend if u have no problem please give me your table structure.
so that i can test...
Sukumar
0
riskyricky1972Author Commented:
              [QuoteID] - int primary key
               [BondNo], int
               [Suffix],    text
               [PowerNo] int
               [FromDate], datetime
               [ToDate],    datetime
               [ExeDate],   datetime
               [SuretyLine], int
               [Premium], money
               [CommissionRate], decimal
               [Commission],   money
               [Surcharge],  money
               [NetPremium], money
               [BondAmount], money
               [StateCode], int
               [BondType], text
               [PrincipalID], int
               [ObligeeID], int
               [AgentID], int
               [CreditTranID1], int
               [CreditTranID2], int
               [AttyInFactID], int
               [UserID], int
               [SubmittedDate], datetime
               [StatusID], int
               [SuretyCompanyID], int
               [MISrefid] int
0
sukumar_diyaCommented:
Hi ricky,
Your stored procedure is working fine. There is no problme with that. I hope the problem is in the asp code or value..
in the asp code i have seen the powerno datatype is advarchar i have changed it to adinteger... I have changed the parameter datatype datetime to varchar in the SP .. test this..

sukumar

Sp
+++++++++++

CREATE PROCEDURE [dbo].[Insert_tblQuotes]
     @QuoteID int output,
     @BondNo int,
     @Suffix text,
     @PowerNo int,
     @FromDate varchar(8),
     @ToDate  varchar(8),
     @ExeDate varchar(8),
     @SuretyLine int,
     @Premium money,
     @CommissionRate decimal(18, 0),
     @Commission money,
     @Surcharge money,
     @NetPremium money,
     @BondAmount money,
     @StateCode int,
     @BondType text,
     @PrincipalID int,
     @ObligeeID int,
     @AgentID int,
     @CreditTranID1 int,
     @CreditTranID2 int,
     @AttyInFactID int,
     @UserID int,
     @SubmittedDate varchar(8),
     @StatusID int,
     @SuretyCompanyID int,
     @MISrefid int



 
AS

 
SET NOCOUNT ON

 
INSERT INTO  [tblQuotes]
(


               [BondNo],
               [Suffix],
               [PowerNo],
               [FromDate],
               [ToDate],
               [ExeDate],
               [SuretyLine],
               [Premium],
               [CommissionRate],
               [Commission],
               [Surcharge],
               [NetPremium],
               [BondAmount],
               [StateCode],
               [BondType],
               [PrincipalID],
               [ObligeeID],
               [AgentID],
               [CreditTranID1],
               [CreditTranID2],
               [AttyInFactID],
               [UserID],
               [SubmittedDate],
               [StatusID],
               [SuretyCompanyID],
               [MISrefid]
)
VALUES
(
               @BondNo,
               @Suffix,
               @PowerNo,
               convert(datetime , '01/01/04',1),
               convert(datetime , '01/01/04',1),
               convert(datetime , '01/01/04',1),
               @SuretyLine,
               @Premium,
               @CommissionRate,
               @Commission,
               @Surcharge,
               @NetPremium,
               @BondAmount,
               @StateCode,
               @BondType,
               @PrincipalID,
               @ObligeeID,
               @AgentID,
               @CreditTranID1,
               @CreditTranID2,
               @AttyInFactID,
               @UserID,
               convert(datetime,'01/01/04',1),
               @StatusID,
               @SuretyCompanyID,
               @MISrefid
)

SET @QuoteID = @@IDENTITY
GO


asp.code
++++++++++++++++


 set objCmd = Server.CreateObject("Adodb.Command")
                     with objCmd
                         .ActiveConnection = con
                         .CommandText = "Insert_tblQuotes"
                         .CommandType = adCmdStoredProc
                         .Parameters.Append .CreateParameter("@BondNo"          ,adInteger,adParamInput,1,bondno)
                        .Parameters.Append .CreateParameter("@Suffix"          ,adVarWChar ,adParamInput,5,suffix)
                         .Parameters.Append .CreateParameter("@PowerNo"         ,adInteger,adParamInput,1,powerno)
                         .Parameters.Append .CreateParameter("@FromDate"        ,adVarWChar ,adParamInput,8,cdate(fromdate))
                         .Parameters.Append .CreateParameter("@ToDate"          ,adVarWChar ,adParamInput,8,cdate(todate))
                         .Parameters.Append .CreateParameter("@ExeDate"         ,adVarWChar ,adParamInput,8,cdate(exedate))
                        .Parameters.Append .CreateParameter("@SuretyLine"      ,adInteger,adParamInput,2,suretyline)
                         .Parameters.Append .CreateParameter("@Premium"         ,adCurrency,adParamInput,10,premium)
                         .Parameters.Append .CreateParameter("@CommissionRate"  ,adCurrency,adParamInput,10,commissionrate)
                         .Parameters.Append .CreateParameter("@Commission"      ,adCurrency,adParamInput,10,commission)
                         .Parameters.Append .CreateParameter("@Surcharge"       ,adCurrency,adParamInput,10,surcharge)
                         .Parameters.Append .CreateParameter("@NetPremium"      ,adCurrency,adParamInput,10,netpremium)
                         .Parameters.Append .CreateParameter("@BondAmount"      ,adCurrency,adParamInput,10,bondamount)
                         .Parameters.Append .CreateParameter("@StateCode"        ,adInteger,adParamInput,2,statecode)
                         .Parameters.Append .CreateParameter("@BondType"        ,adVarWChar ,adParamInput,10,bondcode)
                         .Parameters.Append .CreateParameter("@PrincipalID"     ,adInteger,adParamInput,4,pid)
                         .Parameters.Append .CreateParameter("@ObligeeID"       ,adInteger,adParamInput,4,oid)
                         .Parameters.Append .CreateParameter("@AgentID"         ,adInteger,adParamInput,4,aid)
                         .Parameters.Append .CreateParameter("@CreditTranID1"   ,adInteger,adParamInput,2,creditTranID1)
                         .Parameters.Append .CreateParameter("@CreditTranID2"   ,adInteger,adParamInput,2,creditTranID2)
                         .Parameters.Append .CreateParameter("@AttyInFactID"    ,adInteger,adParamInput,10,attyinfactid)
                         .Parameters.Append .CreateParameter("@UserID"            ,adInteger,adParamInput,10,userID)
                         .Parameters.Append .CreateParameter("@SubmittedDate"   ,adVarWChar ,adParamInput,8,cdate(submittedDate))
                         .Parameters.Append .CreateParameter("@StatusID"            ,adInteger,adParamInput,5,statusID)
                         .Parameters.Append .CreateParameter("@suretyCompanyID" ,adInteger,adParamInput,4,suretycoID)
                         .Parameters.Append .CreateParameter("@MisRefid"        ,adInteger,adParamInput,2,MisRefid)
                         'output parameter
                         .Parameters.Append .CreateParameter("@quoteid",adInteger,adParamOutput,,0)
                         .Execute,,adExecuteNoRecords
                          quoteID = .Parameters("@quoteid")
                          session("quoteid") = quoteID
                  end with
0
riskyricky1972Author Commented:
now i have the following error:
Operand type clash: int is incompatible with text
0
riskyricky1972Author Commented:
I actually took out some of the unused field. and now the code look as following:
I tried to use static data to test, but still have the following error...

Microsoft OLE DB Provider for SQL Server error '80040e07'
Error converting data type nvarchar to int.

What data type should I use for test?




 set objCmd = Server.CreateObject("Adodb.Command")
                         with objCmd
                              .ActiveConnection = con
                              .CommandText = "Insert_tblQuotes1"
                                   .CommandType = adCmdStoredProc
                                   .Parameters.Append .CreateParameter("@SuretyLine"      ,adInteger,adParamInput,4,1000)
                         .Parameters.Append .CreateParameter("@Premium"         ,adCurrency,adParamInput,9,1)
                         .Parameters.Append .CreateParameter("@CommissionRate"  ,adDouble,adParamInput,9,0.1)
                         .Parameters.Append .CreateParameter("@Commission"      ,adCurrency,adParamInput,8,1)
                         .Parameters.Append .CreateParameter("@Surcharge"       ,adCurrency,adParamInput,8,1)
                         .Parameters.Append .CreateParameter("@NetPremium"      ,adCurrency,adParamInput,8,1)
                         .Parameters.Append .CreateParameter("@BondAmount"      ,adCurrency,adParamInput,8,1)
                         .Parameters.Append .CreateParameter("@StateCode"       ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@BondType"        ,adVarWChar ,adParamInput,16,"908A")
                         .Parameters.Append .CreateParameter("@PrincipalID"     ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@ObligeeID"       ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@AgentID"         ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@CreditTranID1"   ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@CreditTranID2"   ,adInteger,adParamInput,2,100)
                         .Parameters.Append .CreateParameter("@AttyInFactID"    ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@UserID"          ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@SubmittedDate"   ,adDBTimeStamp ,adParamInput,8,date())
                         .Parameters.Append .CreateParameter("@StatusID"        ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@suretyCompanyID" ,adInteger,adParamInput,4,100)
                         .Parameters.Append .CreateParameter("@MisRefid"        ,adInteger,adParamInput,4,100)

                              'output parameter
                              .Parameters.Append .CreateParameter("@quoteid",adInteger,adParamOutput,,0)
                              .Execute,,adExecuteNoRecords
                               quoteID = .Parameters("@quoteid")
                               session("quoteid") = quoteID
                     end with
0
sukumar_diyaCommented:
yes Ricky just now i checked it with asp code. I got the error hope we will correct it soon

suku
0
riskyricky1972Author Commented:
the asp codes look right..actaully, it is nothing mor than using command object, it creates error message because of data we provide into parameters...

Agree?
0
sukumar_diyaCommented:
yes i agree. the problem is in data
0
riskyricky1972Author Commented:
can you guide or teach me how to handle this/...
0
sukumar_diyaCommented:
hi Ricky,
Hope we solved the problem,
try the following

 'output parameter
  .Parameters.Append .CreateParameter("@quoteid",adInteger,adParamOutput,,0)

Cut this line and paste it the position below


 .CommandType = adCmdStoredProc
-------------------------------------------- Inser here--------------------------------------------
.Parameters.Append .CreateParameter("@SuretyLine"      ,adInteger,adParamInput,4,1000)


sukumar
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sukumar_diyaCommented:
I hope the problem occured by the change of parameter order. Please test it and tell me result.

Sukumar
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.