Thanks much for the help. The problem was that I did not have the adovbs.asp page in the meta tag. Got that in and it seems to be working like a champ.
Thanks again!! > 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]
