Re: Simple Validation using PHP

Good idea Paul, and one I'll implement. Still unclear on how to do
validation against information that's dynamic.

I want to be able to use an SQL UDF from PHP, Seems like I need to use the
same method as using an SQL Stored Procedure. If that's the case, the value
of a function seems to be less than expected.


On Tue, Feb 5, 2013 at 5:03 PM, Paul Holm <pholm@xxxxxxxxxxxxxxxxx> wrote:

Michael,

If you are validating against data on the i, couldn't you have a drop
down list of possible values? So if you are validating invoice type or
store, then you just allow drop down lists with the valid entries that
way the user can only select valid values?

If you list is large, you could use a type ahead approach as well.

THanks, Paul

On 2/5/2013 10:17 AM, Michael Ryan wrote:

What's a good way to do simple validation against data contained on the i
from a PHP program? I'd rather not invest in having to prepare, param,

and

execute a stored procedure when all I need is a simple true or false. I
have functions (implemented as procedures in a service program) that
returns what I want, but I'm having trouble executing that function from
PHP. I don't have a problem with a stored procedure that returns values

or

a stored procedure that returns a result set.

Is there something special/different about functions?

Thanks!

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.