ASP - Active Server Pages
Sanitize or clean price / cost field for database insertion or display

If you need to deal with price/cost fields, you may need to server-side check the validity of the form input for the field, or manipulate the numeric string. Place numbers or text into the box to see a demonstration.


I asked Benj Clews (who does Four Word Film Review) to critique this code and he wrote a leaner, more efficient function. View it.


The sanitized Price is: $.00
 

Here is how I set up my PRICE field in the database.
Here is this page's html and ASP code:
<%

dim strOurValue
strOurValue = request.form("PRICE")

'Let's sanitize our Price field

'OK let's first make sure the price string is numeric
if NOT isNumeric(strOurValue) then

response.write "Not a number." ' you could put in code to remove nonnumeric characters
strOurValue = null 'if not numeric let's set the value to null or use 0 if you want

else


strDec = strOurValue 'let's see if there is a decimal in the string and what place it is in
strDec = inStr(strDec,".")

if strDec >0 then

NumArray = Split(strOurValue, ".") 'if numeric let's split the price string where the decimals are

str1 = NumArray(0) 'this is the numbers to the left of the decimal
str2 = NumArray(1) 'this is the numbers on the other side of the decimal

str2 = Left(str2,2) 'let's take only the left two numbers of the second set in the array

strOurValue = str1 & "." & str2 'let's put the sets back together to make a clean price string. That is the value that I would insert into the database field.

'I would use the code below to display the value.
strOurValue = formatnumber(strOurValue)'let's format as currency
end if
end if
if strDec < 1 then
strOurValue = strOurValue & ".00"
end if
if strDec <>"" then
response.write "<br>The sanitized Price is: $" &strOurValue ' and write it out
end if
%>
 

<form method="POST" action="decimaltest.asp">

<p><input type="text" name="PRICE" size="20"><input type="submit" value="Submit" name="B1"></p>
</form>

Classic ASP Active Server Pages Examples, code, tutorials, scriptsASP Examples Menu (below*)



Active Server Pages | ASP | Scripts | Tutorials | Code | Web Programming | Examples
 Active Server Pages ASP code examples, tutorials, and snippets for use in Programming interactive websites.

NOTE: Recently changed hosting and url so some demos aren't working now because I haven't updated pathing; if you find omissions or errors let me know.
 

*

Multiple records per row with paging

Display multiple records per row

Get ID of newly inserted record, Classic ASP, Access Database

Javascript timer with ASP to keep track of time expired until login expires / timeout session is up

Multiple Javascript event functions triggered from single form onsubmit

Get Querystring key names along with querystring variables

ASP Youtube Downloader  Version FOUR
All ASP code. Allows user client side downloads of Youtube videos. You have the option to allow files to be saved directly to your site also.

ASP/PHP video downloader (Works better than ASP for large files)

Use ASP to dynamically parse a Youtube XML playlist to render to html.

Zip up an archive file of your site for backup if you need to restore website with ASP and free Zip Component.

Zip all files in a folder into an archive or backup file dynamically by specific file extension.

Sanitize or clean price cost field for database insertion or display.

Javascript image dimensions and image file size preview.

Put recordset into array, assign keys to the records then use record associated with specific array key as a variable elsewhere.

Access Database Interface Generator Wizard to read your table and field names and to create a table display.

Combining dropdown selection box menu with dynamic ASP database page.

How to redirect user to original page they tried to view before logging, after they are logged in.

Previous/Current/Next Records, or Buddy Ring Script

Custom ASP 404 page not found error script sends visitors to virtual folders

ASP Example: Combine ASP with Javascript for popup windows
dynamically sized to image dimensions.

ASP Example: How to use ASPJPEG to create thumbnails
Click for free Highly recommended thumbnailer for which you don't need Server access

ASPjpeg: How to re-scale aspect ratio of thumbnails by height instead of width.

ASP Example: What if your host has an older version of ASPJPEG that doesn't support gifs?

Using inline frames as "dynamic includes" (offline for updating)

Select Count Distinct Records for Access Database

Upload Image to folder and insert filename into database

Get date in such a way that it can be made part of a file name

Isolate a file name away from its path or extension or strip a path from a file name or strip characters from database field

User-customized on-the-fly stylesheet css files

Enhanced Page Hits Counter (also counts downloads and menu link hits)

Loop through array and compare to string with select case

Aphabetical Paging for your ASP scripts

Web Wiz Guide's Site Searcher Script modified as a file content indexer

Let Users Select How Many Records to View

Access Database for your PayPal IPN scripts

Miscellaneous collected code

You don't have to be a genius, just persistent, to write original Active Server Pages scripts

Software Recommendation: bare_bones_no_bells_and_whistles_asp_code_generator_database_interface_maker

--Lil at gmail.com