Subject | Re: Procedures/Firebird |
---|---|
Author | Ruslan |
Post date | 2005-03-12T13:20:43Z |
ß ïîïðîáîâàë ñäåëàòü òàê:
$stmt = "execute procedure procedurename('$user', '$passwd')";
$result = ibase_query($dbh, $stmt);
è âîò ÷òî âûäàåò:
Warning: ibase_query(): message length error (encountered 0, expected
20)
÷òî áû ýòî çíà÷èëî ?
Ñïàñèáî, åùå ÿ áû õîòåë îñòàâèòü âàì ñâîé ICQ íîìåð, íà âñÿêèé
ñëó÷àé :)
333724385
--- In firebird-php@yahoogroups.com, Dmitry Kalugin <dskalugin@r...>
wrote:
$stmt = "execute procedure procedurename('$user', '$passwd')";
$result = ibase_query($dbh, $stmt);
è âîò ÷òî âûäàåò:
Warning: ibase_query(): message length error (encountered 0, expected
20)
÷òî áû ýòî çíà÷èëî ?
Ñïàñèáî, åùå ÿ áû õîòåë îñòàâèòü âàì ñâîé ICQ íîìåð, íà âñÿêèé
ñëó÷àé :)
333724385
--- In firebird-php@yahoogroups.com, Dmitry Kalugin <dskalugin@r...>
wrote:
> Hello, Ruslan!
>
> R>So I want to execute from php a statement like this:
> R> execute procedurename('in_param','in_param').
> R> Can somebody tell me how to do this ?
>
> Åñëè ïðîöåäóðà ñîçäàíà íà îñíîâå
> "FOR SELECT ... DO SUSPEND...",
> òî âûçûâàòü åå íàäî êàê "Select * from proc(p1,p2)"
>
> À åñëè íà îñíîâå DELETE, INSERT, UPDATE,
> òî ñîîòâåòñòâåííî "execute proc(p1,p2)"
> ñ ïîñëåäóþùèì ÷òåíèåì ïàðàìåòðîâ
>
> If procedure is created on the basis of "FOR SELECT ...
> DO SUSPEND...", to cause it it is necessary as "Select
> * from proc(p1,p2)"
>
> And if on the basis of DELETE, INSERT, UPDATE,
> according to "execute proc(p1,p2)"
> with the subsequent reading of parameters
>
>
>
> --
> Best regards,
> Dmitry Kalugin
> Ukraine, Donetsk