2. PHPRunner General questions
  3. How to change lookup entry to uppercase
This topic is locked

How to change lookup entry to uppercase

 		10/26/2007 12:45:30 PM
PHPRunner General questions
L
 Lisa2006 author

I've created a lookup table as follows:
Table: courierdatabase

Fields: town, postcode, etc...
Table: journey

Fields: starttown, startpostcode, etc...
Link Criteria: journey, town --- linked to courierdatabase, starttown
I've checked values: allow to add new values on the fly & Lookup Wizard as Edit box with AJAX popup
When project executed, the user selects from a previously populated town or enters a new town via the Add new link.
This is what i need to do:

1] need to change the Add new wording

2] When adding a new town, i need to make the town value uppercase before saving to table
Thanks in advance
Lisa
F
 		frocco 10/26/2007

You can check the generated code in the output directory for a file called.
yourfile_addnewitem.php or something like this.
In this file, change
$field=postvalue("field");
to

$field=strtoupper(postvalue("field"));
HTH
Frank
Sergey Kornilov admin 10/26/2007

Use "View as" type "Custom" for this field and the following code:

$value = strtoupper($value);