You have two good opportunities to fix your text before it hits the database. Your first chance is on the submitting form. Use JavaScript to modify the submitted data.
Your second opportunity is server-side and is in the script on the page that handles your form's submission. That's also the page that performs the insert into the database, right? You can modify what the user sent you from the previous page as it is being combined with the other information and before it goes into the database. Just use whatever function your scripting language supports. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Chris Ripley <[EMAIL PROTECTED]> wrote on 09/24/2004 01:33:24 PM: > I've been searching long and hard and have come across > a few techniques for changing text entries with lower > case (entered by web user) and changing them to have > first letter capitalized. > > in php..... ucfirst > in java .... capitalize > > But I'm not having success on the database side. > Everything they enter from the web form hits the > database as entered, or raw, or lower cased. > > Is there a way to have the text fixed before it hits > the database? > > -chris > > ===== > Chris Ripley > [EMAIL PROTECTED] > KOZE Radio > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out! > http://promotions.yahoo.com/new_mail > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
