[thelist] Dreamweaver Tutorial? List?
Anthony Baratta
Anthony at Baratta.com
Mon Oct 23 13:05:08 CDT 2000
At 10:49 AM 10/23/2000, you wrote:
suggestions? I like a mature list like this one that doesn't waste time
talking about the bake sale last week...know what I mean?
Why not here??? ;-)
<TIP AUTHOR="Anthony Baratta" TYPE="ASP">
Its been said before and bears repeating: Trim your data when you pull from
forms and from Databases!!
e.g.
Trim(Request.Form("FormFieldName"))
Trim(obj_RecordSet("DatabaseColumnName"))
Especially when you are stuffing the data into the key of a dictionary object.
dictArray(Trim(obj_RecordSet("DatabaseColumnName1"))) =
Trim(obj_RecordSet("DatabaseColumnName2"))
You will eliminate many nasty unprovoked errors using this method. Its
almost magical!! LOL Please don't ask my why this works or why trimming
white space from either end cleans up data from forms or databases so that
ASP can use it, or even why data from forms and databases is not clean to
begin with - I'm tired of ranting.
</TIP>
----
Anthony Baratta
President
Keyboard Jockeys
More information about the thelist
mailing list