Actually you don't have to set the precision and scale...they are fixed for the money and smallmoney datatypes.
David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: [EMAIL PROTECTED] [mailto:psayers@;kentcountyarc.org] For a money data type you have to create the parameters differently... And indicate the precision and scale since it's a decimal number -----Original Message----- From: msavoy [mailto:savoym@;hcin.net] Just a quick question, please. I have setup a field within a SQL Server DB table that is defined as a "money" type field. In my ASP code I am passing the value of this field in the following code: strParmName = "transaction_amt" Set prmADOParameter = cmdADOCommand.CreateParameter(strParmName, adCurrency, adParamInput) cmdADOCommand.Parameters.Append prmADOParameter cmdADOCommand.Parameters(strParmName).Value = Request("totaldonation_amt") The error code I am getting is the following: Error Type: Microsoft VBScript runtime(0x800A01F4) Varible is undefined: 'adCurrency' /resources/xlmconfirmpage.asp, line 34 Why would I get an error that states that the type parameter "adCurrency" would be seen as a variable? I know I must be overlooking something I just do not know what? Any help or direction would be appreciated. Thank you. --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
