October 10, 2008 at 9:58 am
Hello to everybody,
These are my field in SQL Server 2000-
1)autoid - PRIMART KEY
2)ordName - need to update my database in uppercase
and other fields.. please check my which is build in Cold Fusion.
pagehttp://www.standardautowreckers.com/toronto/posting_page.cfm
the user enters the data and it saves on the server.
what I need is
1)when the user enters the data on this form in any format(upper/lower case) it should be stored or accept in upper case only.
2) the Amount field should be entered only in integers( should accept only numeric value) no dollar sign etc.
please advice
thanks
October 10, 2008 at 10:34 am
1) This can be done via a trigger so when the data is saved it is converted to upper case. But - this should be done in the application level to ensure what is entered is displayed in upper case and stored that way.
2) If the column in the database is configured to be one of the number datatypes then no other characters will be able to be stored. This protects you from bad data being inserted. Again, the application should be configured to only allow numbers to be entered.
October 10, 2008 at 11:36 am
Thanks fro your help.
the second issue has been solved, which is accepting only numeric value. I made the changes as per your suggestion and tested its working fine.
still need help with the first issue(trigger).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply