<div>
Currency values usually get inserted as decimal values. Make sure that your request field only contains digits (a valid decimal number). You then don't need any special characters around it. If you do not make sure that your form field has a valid number in it and you do not use quotes, your insert may fail depending on what the user entered. With quotes around it it will still fail if the user's input cannot be parsed into a decimal. Form field validation is key before it goes into the DB.
</div>


Currency values usually get inserted as decimal values. Make sure that your request field only contains digits (a valid decimal number). You then don't need any special characters around it. If you do not make sure that your form field has a valid number in it and you do not use quotes, your insert may fail depending on what the user entered. With quotes around it it will still fail if the user's input cannot be parsed into a decimal. Form field validation is key before it goes into the DB.

<div>
<div class="content wysiwyg-content">
When inserting a record that is formatted as currency, do you need to handle it in a similar fashion as you do a date as far as surrounding it with a special character (date would be '#&quot; &amp;&nbsp;Request.Form(&quot;Date&quot;) &amp;&quot;#')?<br />
<br />
Thanks!
</div>
</div>


When inserting a record that is formatted as currency, do you need to handle it in a similar fashion as you do a date as far as surrounding it with a special character (date would be '#" & Request.Form("Date") &"#')?

Thanks!

Inserting currency into a database...

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.