Need To Create An All Caps Trigger

[merefolk]

Can someone help me create a trigger for a database?

 

The front end GUI where the person will be sending data can not be set to send in all caps, so I am trying to do it on the back end.

 

Is this possible with MYSQL?

 

Thanks,

Adam

[TCH-Bruce]

Take a look at the strtoupper PHP command.

[merefolk]

The incoming data may not always be coming from a web page. Is there any way to add the trigger?

[TCH-Bruce]

You can always write a query after the fact to use the strtoupper on any fields in the database.

[merefolk]

That would work, but I am sort of a newbie on this.

 

Where would I write the query to run after the table is updated?

[TCH-Bruce]

All you need to do is write an update query (PHP) and add it as a cron job. I'm sure you can Google for some samples on how to do it.

[OJB]

You say the data could be coming from anywhere, but surely you have a query at some point to add the data into the db?

 

So in your insert query do something like this:

 

>$query = ' INSERT INTO tbl_name (fld_name) VALUES(\''.strtoupper($the_value).'\')';

 

i.e. convert the string to uppercase as you insert it into the db

 

 

or is this not what you want?

 

 

if you want to write an update query it will be something like:

 

>UPDATE tbl_name SET fld_name = UPPER(fld_name) WHERE fld_name = 'blahblah'

Edited October 4, 2008 by OJB