Hello,
Due to time difference, I am a bit late in this thread but I would
like to consider this problem from another point of view :-)
Instead of having to search for all forms ('smith', 'Smith' or
'SMITH') I would rather prefer to reformat user entries as soon as
they are done to match a 'style' sheet that will make all data
display consistent.
To achieve such a goal, you might be interested in my "How to master
user's data entries" tutorial:
This stack shows you how to allow the user to type the data you
expect according to a format in an entry box field.
Five examples are provided from a simple ZIP code to custom
sophisticated formats.
You will access this tutorial through "Tutorials Picker" a free
plugin that interfaces with the So Smart Software website in order to
display all available tutorials stacks directly from the web.
You will find it by going to http://www.sosmartsoftware.com/.
Revolution/Plugins or Tutorials section.
Best regards from Paris,
Eric Chatonet.
Le 29 févr. 08 à 00:08, dcpbarrington a écrit :
This has to be very simple, but I cannot find anything in the DOCs
or an
example.
I have a database that I want to allow the user to querry a record
by the
persons last name. So I have a simple entry box with a button to
querry the
database.
Works great as long as the user enters the text string in the same
case as
has been entered in the database. "Smith" = "Smith", but if the
user enters
"smith" in the select box, the record is not found.
I want to do the database select with different text formats to
make sure
that the record is found.
SELECT on "Smith", "smith", "SMITH"
I found the toupper() and tolower() functions, but how do you get the
function to change only the first letter toupper in a string?
Thanks in advance for the help. This cannot be that hard.
----------------------------------------------------------------
Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/
Email: [EMAIL PROTECTED]/
----------------------------------------------------------------
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
