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] Sent: Thursday, November 07, 2002 9:11 AM To: ActiveServerPages Subject: Parameters (data type) Question 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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
