set $param to be an array of values
On Wed, Nov 6, 2013 at 10:04 PM, Ismael L. Donis Garcia <
ismael@xxxxxxxxxxxxxx> wrote:
> I already discovered the problem, now I am going to think as solving .
>
> $sql = "insert into scele (codigo, nombre) values (?, ?)";
>
> $tr = ibase_trans(IBASE_WRITE,$this->cn);
> $qr = ibase_prepare($this->cn,$tr,$sql);
>
> //Not working
> $param = "1, Test1";
> $this->rs = ibase_execute($qr,$param);
>
> //Yes Working
> $param1 = "1";
> $param2 = "test1";
> $this->rs = ibase_execute($qr,$param1,$param2);
>
> But as it is a class not himself as dividing the variable in so many
> variables according to parameters that come.
>
> public function actualizar($sql,$param){
>
> Best Regards
> ========
> | ISMAEL |
> ========
>
> ----- Original Message -----
> From: Tsvetan Nikolov
> To: Ismael L. Donis Garcia
> Cc: PHP-General
> Sent: Tuesday, November 05, 2013 2:57 PM
> Subject: Re: Error to insert in firebird
>
>
> Oh yeah and you may want to try declaring your $param as array. $param =
> array('1', 'Test1');
>
>
>
>
> On Tue, Nov 5, 2013 at 8:55 PM, Tsvetan Nikolov <live.webscore@xxxxxxxxx>
> wrote:
>
> Sorry I have no experience with firebird commands.
>
>
> Just read through the official documentation. If I am to take a blind
> guess I would point to ibase_prepare($tr,$param); and would say that the
> variable $param does not belong there but rather in ibase_execute. What I
> would try is something like this:
>
>
> $sql = "insert into scele (codigo, nombre) values (?, ?)";
> $param = "1, Test1";
>
> $tr = ibase_trans(IBASE_WRITE,$this->cn);
>
> $qr = ibase_prepare($this->cn, $tr, $sql);
> $this->rs = ibase_execute($qr,$param);
> .......
>
>
> If this doesn't work remove the parameters and put static values and
> see if that works...etc... you have to really debug line by line.
>
>
> Good luck!
>
>
>
>
>
>
>
> On Tue, Nov 5, 2013 at 8:30 PM, Ismael L. Donis Garcia <
> ismael@xxxxxxxxxxxxxx> wrote:
>
> $sql = "insert into scele (codigo, nombre) values (?, ?)";
> $param = "1, Test1";
>
> $tr = ibase_trans(IBASE_WRITE,$this->cn);
> $qr = ibase_prepare($tr,$param);
>
> echo ibase_errmsg() ."<br>";
> Dynamic SQL Error SQL error code = -104 Token unknown - line 1,
> column 1 2
>
> But I do not understand as it can be the error.
>
>
> Best Regards
> ========
> | ISMAEL |
> ========
>
>
> ----- Original Message -----
> From: Tsvetan Nikolov
> To: Ismael L. Donis Garcia
> Cc: PHP-General
>
> Sent: Tuesday, November 05, 2013 1:53 PM
> Subject: Re: Error to insert in firebird
>
>
> Well,
>
> in the documentation it says that if the query raises an error,
> returns FALSE. You should start calling ibase_errmsg to track where the
> error is.
>
>
>
>
> On Tue, Nov 5, 2013 at 7:34 PM, Ismael L. Donis Garcia <
> ismael@xxxxxxxxxxxxxx> wrote:
>
> ----- Original Message ----- From: Tsvetan Nikolov
> To: Ismael L. Donis Garcia
> Cc: PHP-General
> Sent: Tuesday, November 05, 2013 12:45 PM
> Subject: Re: Error to insert in firebird
>
>
> Do you commit your transaction?
>
>
> Yes
>
> The complete function is:
>
> public function actualizar($sql,$param){
> if ($this->cn){
>
> //for example:
>
> $sql = "insert into scele (codigo, nombre) values (?, ?)";
> $param = "1, Test1";
>
> $tr = ibase_trans(IBASE_WRITE,$this->cn);
> $qr = ibase_prepare($tr,$param);
> $this->rs = ibase_execute($sql,$param);
> if ($this->rs){
>
> //Evaluate this condition, but he does not enter here
>
>
> ibase_commit($tr);
> } else {
> ibase_rollback($tr);
> return array('tipo'=>false,'texto'=>'Error de
> ejecusión: ' .ibase_errmsg());
> }
> ibase_free_query($qr);
> return array('tipo'=>true,'texto'=>'');
> } else {
> return array('tipo'=>false,'texto'=>'Error de
> conexión: ' .ibase_errmsg());
>
> }
> }
>
> Best Regards
> ========
> | ISMAEL |
> ========
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
>
>
