Bernard Design - ASP Utilities for VB Script 2.0

Whether you're a beginning developer or code goddess, custom functions can ease your journey to coding nirvana in two easy steps. Simply give the util file your connection object's name and include the file on pages where you need to call the functions and you're all set. Only $30 via PayPal and you can download ASP Utilities 2.0 immediately!

It doesn't matter if you're on Windows or Mac, or you're using Dreamweaver MX or Visual Studio, ASP Utilties 2.0 is a simple ASP file written in VB Script that is 100% compatible with any server capable of processing .asp pages. Instructions and examples are provided in comments under each function, so you're never at a loss as to how a function can be implemented.

$30 Gets you all of these functions!

BestLong	BestDouble	BestBool
Convert string integers into long integers.	Force double-precision arithmetic.	Make sure a value is boolean.
NullToSpace	CoerceString	CoerceNumber
Convert a zero or null value to a	Allow for special characters in text input fields.	Ensure a number is not null, equal to zero or is not numeric.
CoerceBit	CompareString	CompareNumber
Handle boolean values with ease. Excellent for handling boolean values from checkboxes.	Make sure a string is not null or it's length is > 0.	Same as CompareString, but with integers.
IIf	HEncode	UEncode
Perform a comparison to return a boolean. Excellent for pre-populating checkboxes and radio groups.	HTML encodes the value you pass to it.	URL encodes the value you pass to it.
SplitLine	RevSplitLine	DLookup
Accepts a line and a marker, returns the character before the marker, otherwise returns the entire string.	Same as SplitLine, but returns the character after the marker.	Retrieve a value from your DB without opening another connection.
DMin	DMax	DCount
Retrieves the smallest integer in a column.	Retrieves the highest integer in a column. Excellent to use after inserting a record to get the ID of the record you just inserted.	Counts the number of records based on your argument.
DSum	DAvg	DAggregate
Adds the integers in a column according to your argument.	Averages the integers in a column according to your argument.	Creates the connection object for the Util file and provides support for the functions in ASP Utilties 2.0
SQLDate	AccessDate	ShortenText
Date formtting for SQL Server.	Date formatting for Access.	Shortens a string to the length you desire and adds an ellipses to the end.
ShortenHTML	ScaleHeight	ScaleWidth
Strips HTML tags from a string and shortens it to the length you desire, adding an ellipses to the end.	Scales the height of an image proportionally to the width. Great for lists where you always need an image to be a certain width.	Scales the width of an image proportionally to the height. Great for lists where you always need an image to be a certain height.
RegID	TrimRightUntil	GetRightUntil
Used to assign a numeric ID based on the first character of someone's last name. Example: Aaaa to Bbbb = 1. Very useful for creating lists of people and organizing them by last name.	Trims characters from the right of a string until it finds the character you're looking for, then trims the character from the string.	Returns a string from the right until it finds the character you're looking for.
TrimLeftUntil	GetLeftUntil	...more coming soon!
Same as TrimRightUntil, starting from the left.	Same as GetRightUntil, starting from the left.

Need support? Click here.

Ok, so what's the big deal anyway...aren't these just a part of VB Script? Yes, they are, but they're not always easy to implement or understand.

ASP Utilities 2.0 is a collection of highly efficient functions that are so easy to use throught your pages, you'll wonder why you didn't think of this sooner!

But I'm using Dreamweaver on Mac OS X…are these functions going to work? Absolutely. They'll work with any server capable of processing ASP pages. They're written in VB Script, a subset of Visual Basic. It doesn't matter what OS or software you're using, as long as the server can process ASP, you're good to go.

I'm still not convinced these are going to do anything for me. Can you show me why I'd want to use these? Absolutely! Example: Passing numeric values through the querystring will cause a data type mismatch error if you try to filter a recordset with the value you've passed. You have to convert the string integer back into a long integer.

BestLong() will convert the value by wrapping the function around the variable you're requesting from the QueryString. If it's a number, it will convert it, if not it returns null.

Example:
id = BestLong(Request.Querystring("id"))

Yep, it's that simple. See wasn't that a whole lot faster and easier than writing seven lines of code over and over and over - for each numeric value you're calling from the Request collection? That's a lot of code. Less code = faster development time = faster processing = happier customer = mo' money. That makes good sense to me!

Plus you can implement them across as many pages as you'd like. How? Simple - use the util file as an SSI after your connection object on your page and call the functions as many times as you need.

BestLong() is yours free by visiting our site. Just copy the code from the text field below. If you like it, buy ASP Utilities 2.0 for only $30 and see how much time (and money) you save. Don't wait, buy today!

Find out what services and expertise Bernard Design offers.

Solutions we have provided for clients, past and present.

Find out a little about Bernard Design and our mission.