How to write table data in uppercase only

Home | Site map

HowTo: Write table data in uppercase only

This document describes the steps you need to follow to add records to your database in uppercase only.

The simplest method is to make changes in Events tab on eleventh step of your ASPRunner/PHPRunner project. For that you need to go through a couple of steps.

Steps:

Click on Before Record Updated Event

Modify sample event code putting to appropriate place following code snippets

ASPRunner Example

values("Make") = UCase(values("Make"))
values("Model") = UCase(values("Model"))

PHPRunner Example

$values["Make"]=strtoupper($values["Make"]);
$values["Model"]=strtoupper($values["Model"]);

Make the same for Before Record Added Event

These changes will apply to Make and Model fields. Now, these fields will be written to database in upper case.

Note: Changes in SQL Query maybe different according to database used. For example, for MSSQL, MySQL, Oracle and Postgre SQL databases you should use Upper operator instead of Ucase.

Applies to:
ASPRunner Pro
PHPRunner

Home | Products | Downloads | Support | Contacts

All comments send to webmaster@xlinesoft.com