Application uses a value of the wrong type for the current operation.

Hello Everyone, I am working on an EXTREMLY complex application where the update is done by one UPDATE statement.  This is possible by having the name of each element on the page match the name in the database.  The database also determies how to treat an element based on its datatype"

I'm getting the following ERROR:


ADODB.Command error '800a0d5d'

Application uses a value of the wrong type for the current operation.

/OPICForms/115v1/save_sv.asp, line 48


It comes from this code:  It's actually a stored procedure:

Can you help me with this, or send me on the right track of what I need to look for in order to fix this error...

CODE:

      sTable  = "form115part" & iFormPart
      
      ' Get the table properties
      dim rsTable
      set rsTable = Server.CreateObject("ADODB.Recordset")
      with objCommand
            .CommandText = "TableProperties"
            .Parameters.Append .CreateParameter("@TableName", adChar, adParamInput,12, sTable)
            set rsTable = .Execute
      end with


This is line 48:   .Parameters.Append .CreateParameter("@TableName", adChar, adParamInput,12, sTable)

The parameters of the Stored Procedure, and this is the Stored Procedure: TableProperties:

CREATE PROCEDURE TableProperties @TableName char(12)
AS
SELECT table_name=sysobjects.name,
         column_name=syscolumns.name,
         datatype=systypes.name,
         length=syscolumns.length
    FROM sysobjects
    JOIN syscolumns ON sysobjects.id = syscolumns.id
    JOIN systypes ON syscolumns.xtype=systypes.xtype
   WHERE sysobjects.xtype='U' AND sysobjects.name=@TableName
ORDER BY sysobjects.name,syscolumns.colid

GO

I can include more code if you need it... The page is relatively shot, however, it has a lot of include files in it, there is a lot of client and server side code behind the scenes...

Still any help with this would be extremly appreciated!  I know that this error can be fixed because I am modeling this application on another application which was created by someone else without documentation or comments, however, if he could make it work, I can make this work also... As always I am so greatful for your help!  Angie

If I knew how to select help for stored procedures I would, instead I added the SQL SERVER database, I'm using SQL SERVER 2000 for the database...

Start Free Trial