Subject | Re: php/stored procedure error |
---|---|
Author | ArnoldGamboa.com |
Post date | 2004-12-10T02:49:03Z |
> Ac> ... then, whenever I run this sql command in PHP:Thanks. This worked.
>
> Ac> SELECT * FROM DELETE_PROPERTY WHERE the_property_id = 12
> ^^^
> |||not right
> right is:
> execute procedure DELETE_PROPERTY(12)
>
> --
> Best regards,
> Dmitry Kalugin
> Ukraine, Donetsk
When I did a PHP/Firebird program some 2 years ago (yeah, long time
ago), I remember executing stored procedures as typical select
statements (just like the one I mentioned above). This approach that
you gave is new to me.
My question is, when do we use the typical select statement and when
do we use the "execute procedure" approach in calling the procedure
from PHP?
Thanks again.
Arnold