Forums

This topic is locked

Server Formatting Help!

Posted 07 Mar 2003 18:03:26
1
has voted
07 Mar 2003 18:03:26 Pedro Saenz posted:
Does anybody know how can I get the information that is being from an
online form to my Access database to come out in ALL CAPS.

I received the following answer, but I do not know how do apply on my
page in Dreamweaver MX.

---------------------------------------
When ur updating or inserting into the database via ASP you can
convert the data from the form to uppercase then use the ucase()
function:

Dim sName
sName = request.form("name"
rs("name" = UCase(sName)
rs.update

so no matter what the user enters in the textfield 'name' it will be
inserted into your database as ALL CAPS.
---------------------------------------

Where do I put this in my document or how do I do this? Also, is there
an easier way of doing this without doing it manually within the code?

Thank you.

Reply to this topic