adNumeric cutoff

Hi!

  The following is a snippet of code that I am having problems w/:

   set CMD = server.CreateObject("ADODB.Command")

   CMD.ActiveConnection = Con
   CMD.CommandType = adCmdStoredProc
   CMD.CommandText = "INSERT_WEB_ORDER_LINES"	
		

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_ORDER_NUMBER", adNumeric, adParamInput, 0, OrderNum)

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_ORDER" , adNumeric, adParamInput, 0, LineNum)

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_ITEM" , adVarChar, adParamInput, 10, item)

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_SIZE" , adNumeric, adParamInput, 0, weight)

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_CERT_NUM" , adVarChar, adParamInput, 12, stone_code)

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_CERT_TYPE" , adVarChar, adParamInput, 2, BRString)

   CMD.Parameters.Append CMD.CreateParameter("C_CERT_TYPE" , adVarChar, adParamInput, 10, BRString)

   CMD.Parameters.Append CMD.CreateParameter("C_LINES_WEIGHT" , adNumeric, adParamInput, 0, weight)

   CMD.Parameters.Append CMD.CreateParameter("C_DESCRIPTION" , adVarChar, adParamInput, 30, description)

   CMD.Parameters.Append CMD.CreateParameter("C_DEDICATE" , adVarChar, adParamInput, 20, dedicate)

What's happening is that the string fields in btwn C_LINES_SIZE and C_LINES_WEIGHT are being passed as NULL. In the database, C_LINES_SIZE is defined as NUMBER(4,2) and C_LINES_WEIGHT is defined as NUMBER(6,3), and decimal numbers are being passed in. I tried setting the precision and numeric fields on those numerics, but the same thing keeps happening. Anyone have any idea why?

Our work around was to call the stored procedure directly, but theoretically, this way should work under all circumstances. Thanx.

Zev Received on Sun Mar 23 2003 - 09:20:51 CST