Thread: [Sqlrelay-discussion] bind pear php module
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion
|
From: david f. <df...@vi...> - 2005-05-20 14:12:31
|
Hello
so Here is the request
$db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
this build the several request (inside PEAR DB)
INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
But it seems that when it reach the execute fonction, it's not able to
fill the ?, with the right data.
Analysing the function I discover this :
function &execute(&$sqlrcursor, $data = false)
{
sqlrcur_clearBinds($sqlrcursor->cursor);
if ($data) {
while ($element = current($data)) {
$index = key($data);
sqlrcur_inputBind($sqlrcursor->cursor, $index,
$data["$index"]);
next($data);
}
}
..........
I try to modify it like :
function &execute(&$sqlrcursor, $data = false)
{
sqlrcur_clearBinds($sqlrcursor->cursor);
if ($data) {
while ($element = current($data)) {
$index = key($data);
if(is_numeric($index)) $index = "?";
sqlrcur_inputBind($sqlrcursor->cursor, $index,
$data["$index"]);
next($data);
}
}
..........
without success.
Please thanks for your help
livingdead
|
|
From: david f. <df...@vi...> - 2005-05-20 14:19:17
|
Oups the modification was idiot, I was to fast, I finaly did that :
if ($data) {
while ($element = current($data)) {
$index = key($data);
$mark = (is_numeric($index))?"?":$index;
sqlrcur_inputBind($sqlrcursor->cursor, $mark,
$data["$index"]);
next($data);
}
}
.........
Without much success
livingdead
Le Fri, 20 May 2005 16:12:24 +0200, david forums <df...@vi...> a
écrit:
> Hello
>
> so Here is the request
>
> $db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
>
> this build the several request (inside PEAR DB)
> INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
>
> But it seems that when it reach the execute fonction, it's not able to
> fill the ?, with the right data.
> Analysing the function I discover this :
>
> function &execute(&$sqlrcursor, $data = false)
> {
> sqlrcur_clearBinds($sqlrcursor->cursor);
> if ($data) {
> while ($element = current($data)) {
> $index = key($data);
> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> $data["$index"]);
> next($data);
> }
> }
> ..........
>
> I try to modify it like :
> function &execute(&$sqlrcursor, $data = false)
> {
> sqlrcur_clearBinds($sqlrcursor->cursor);
> if ($data) {
> while ($element = current($data)) {
> $index = key($data);
> if(is_numeric($index)) $index = "?";
> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> $data["$index"]);
> next($data);
> }
> }
> ..........
>
> without success.
>
> Please thanks for your help
>
> livingdead
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: Firstworks/4access <dav...@fi...> - 2005-05-20 14:57:07
|
SQL Relay uses Oracle-style bind variables, so try using:
INSERT INTO myTable (col1,col2,col3) VALUES (:1,:2,:3)
and see if that doesn't work better (using the original code for the
execute function).
Supporting ?'s is on the TODO list, but I haven't implemented it yet.
Dave
dav...@fi...
On Fri, 2005-05-20 at 16:12 +0200, david forums wrote:
> Hello
>
> so Here is the request
>
> $db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
>
> this build the several request (inside PEAR DB)
> INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
>
> But it seems that when it reach the execute fonction, it's not able to
> fill the ?, with the right data.
> Analysing the function I discover this :
>
> function &execute(&$sqlrcursor, $data = false)
> {
> sqlrcur_clearBinds($sqlrcursor->cursor);
> if ($data) {
> while ($element = current($data)) {
> $index = key($data);
> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> $data["$index"]);
> next($data);
> }
> }
> ..........
>
> I try to modify it like :
> function &execute(&$sqlrcursor, $data = false)
> {
> sqlrcur_clearBinds($sqlrcursor->cursor);
> if ($data) {
> while ($element = current($data)) {
> $index = key($data);
> if(is_numeric($index)) $index = "?";
> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> $data["$index"]);
> next($data);
> }
> }
> ..........
>
> without success.
>
> Please thanks for your help
>
> livingdead
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: david f. <df...@vi...> - 2005-05-20 15:15:21
|
Sorry but I'm not the manager of those question mark, it's PEAR DB who set
those question mark automatically, when we are using autoExecute functions.
So I do not know how to change it in PEAR DB, and How it will not break
the portability of PEAR DB
regards
livingdead
Le Fri, 20 May 2005 10:57:29 -0400, Firstworks/4access
<dav...@fi...> a écrit:
> SQL Relay uses Oracle-style bind variables, so try using:
>
> INSERT INTO myTable (col1,col2,col3) VALUES (:1,:2,:3)
>
> and see if that doesn't work better (using the original code for the
> execute function).
>
> Supporting ?'s is on the TODO list, but I haven't implemented it yet.
>
> Dave
> dav...@fi...
>
> On Fri, 2005-05-20 at 16:12 +0200, david forums wrote:
>> Hello
>>
>> so Here is the request
>>
>> $db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
>>
>> this build the several request (inside PEAR DB)
>> INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
>>
>> But it seems that when it reach the execute fonction, it's not able to
>> fill the ?, with the right data.
>> Analysing the function I discover this :
>>
>> function &execute(&$sqlrcursor, $data = false)
>> {
>> sqlrcur_clearBinds($sqlrcursor->cursor);
>> if ($data) {
>> while ($element = current($data)) {
>> $index = key($data);
>> sqlrcur_inputBind($sqlrcursor->cursor, $index,
>> $data["$index"]);
>> next($data);
>> }
>> }
>> ..........
>>
>> I try to modify it like :
>> function &execute(&$sqlrcursor, $data = false)
>> {
>> sqlrcur_clearBinds($sqlrcursor->cursor);
>> if ($data) {
>> while ($element = current($data)) {
>> $index = key($data);
>> if(is_numeric($index)) $index = "?";
>> sqlrcur_inputBind($sqlrcursor->cursor, $index,
>> $data["$index"]);
>> next($data);
>> }
>> }
>> ..........
>>
>> without success.
>>
>> Please thanks for your help
>>
>> livingdead
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by Oracle Space Sweepstakes
>> Want to be the first software developer in space?
>> Enter now for the Oracle Space Sweepstakes!
>> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: Firstworks/4access <dav...@fi...> - 2005-05-20 15:40:26
|
Ahh, I see.
I'll have to look into this a bit further. Maybe I can get SQL Relay to
support ?'s in short order.
Dave
On Fri, 2005-05-20 at 17:15 +0200, david forums wrote:
> Sorry but I'm not the manager of those question mark, it's PEAR DB who =
set =20
> those question mark automatically, when we are using autoExecute functi=
ons.
>=20
> So I do not know how to change it in PEAR DB, and How it will not break=
=20
> the portability of PEAR DB
>=20
> regards
>=20
> livingdead
>=20
>=20
>=20
>=20
>=20
> Le Fri, 20 May 2005 10:57:29 -0400, Firstworks/4access =20
> <dav...@fi...> a =C3=A9crit:
>=20
> > SQL Relay uses Oracle-style bind variables, so try using:
> >
> > INSERT INTO myTable (col1,col2,col3) VALUES (:1,:2,:3)
> >
> > and see if that doesn't work better (using the original code for the
> > execute function).
> >
> > Supporting ?'s is on the TODO list, but I haven't implemented it yet.
> >
> > Dave
> > dav...@fi...
> >
> > On Fri, 2005-05-20 at 16:12 +0200, david forums wrote:
> >> Hello
> >>
> >> so Here is the request
> >>
> >> $db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
> >>
> >> this build the several request (inside PEAR DB)
> >> INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
> >>
> >> But it seems that when it reach the execute fonction, it's not able =
to
> >> fill the ?, with the right data.
> >> Analysing the function I discover this :
> >>
> >> function &execute(&$sqlrcursor, $data =3D false)
> >> {
> >> sqlrcur_clearBinds($sqlrcursor->cursor);
> >> if ($data) {
> >> while ($element =3D current($data)) {
> >> $index =3D key($data);
> >> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> >> $data["$index"]);
> >> next($data);
> >> }
> >> }
> >> ..........
> >>
> >> I try to modify it like :
> >> function &execute(&$sqlrcursor, $data =3D false)
> >> {
> >> sqlrcur_clearBinds($sqlrcursor->cursor);
> >> if ($data) {
> >> while ($element =3D current($data)) {
> >> $index =3D key($data);
> >> if(is_numeric($index)) $index =3D "?";
> >> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> >> $data["$index"]);
> >> next($data);
> >> }
> >> }
> >> ..........
> >>
> >> without success.
> >>
> >> Please thanks for your help
> >>
> >> livingdead
> >>
> >>
> >> -------------------------------------------------------
> >> This SF.Net email is sponsored by Oracle Space Sweepstakes
> >> Want to be the first software developer in space?
> >> Enter now for the Oracle Space Sweepstakes!
> >> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> >> _______________________________________________
> >> Sqlrelay-discussion mailing list
> >> Sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >>
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > Want to be the first software developer in space?
> > Enter now for the Oracle Space Sweepstakes!
> > http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7412&alloc_id=3D16344&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20
|
|
From: david f. <df...@vi...> - 2005-06-10 11:37:51
|
I got the following message after upgrading to the new 0.36.3 version, with your FC3 rpm. Warning: dl() [function.dl]: K4+���*�: Unable to initialize module Module compiled with module API=20020429, debug=0, thread-safety=0 PHP compiled with module API=20041030, debug=0, thread-safety=0 These options need to match in /mnt/echange1/home/affiliation/www/test/testSqlrelay2.php5 on line 3 Fatal error: Call to undefined function sqlrcon_alloc() in /mnt/echange1/home/affiliation/www/test/testSqlrelay2.php5 on line 6 Regards david |
|
From: david f. <df...@vi...> - 2005-06-10 14:35:36
Attachments:
sqlrelay.php
|
Please I let you find here by a new version of "sqlrelay.php" Pear Module. I debug some line, and remove some useless information like (sqlrcon_debugOn()). Regards david |
|
From: david f. <df...@vi...> - 2005-05-20 15:56:16
|
That would be very nice.
Thanks for your work
livingdead
Le Fri, 20 May 2005 11:40:42 -0400, Firstworks/4access
<dav...@fi...> a écrit:
> Ahh, I see.
>
> I'll have to look into this a bit further. Maybe I can get SQL Relay to
> support ?'s in short order.
>
> Dave
>
> On Fri, 2005-05-20 at 17:15 +0200, david forums wrote:
>> Sorry but I'm not the manager of those question mark, it's PEAR DB who
>> set
>> those question mark automatically, when we are using autoExecute
>> functions.
>>
>> So I do not know how to change it in PEAR DB, and How it will not break
>> the portability of PEAR DB
>>
>> regards
>>
>> livingdead
>>
>>
>>
>>
>>
>> Le Fri, 20 May 2005 10:57:29 -0400, Firstworks/4access
>> <dav...@fi...> a écrit:
>>
>> > SQL Relay uses Oracle-style bind variables, so try using:
>> >
>> > INSERT INTO myTable (col1,col2,col3) VALUES (:1,:2,:3)
>> >
>> > and see if that doesn't work better (using the original code for the
>> > execute function).
>> >
>> > Supporting ?'s is on the TODO list, but I haven't implemented it yet.
>> >
>> > Dave
>> > dav...@fi...
>> >
>> > On Fri, 2005-05-20 at 16:12 +0200, david forums wrote:
>> >> Hello
>> >>
>> >> so Here is the request
>> >>
>> >> $db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
>> >>
>> >> this build the several request (inside PEAR DB)
>> >> INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
>> >>
>> >> But it seems that when it reach the execute fonction, it's not able
>> to
>> >> fill the ?, with the right data.
>> >> Analysing the function I discover this :
>> >>
>> >> function &execute(&$sqlrcursor, $data = false)
>> >> {
>> >> sqlrcur_clearBinds($sqlrcursor->cursor);
>> >> if ($data) {
>> >> while ($element = current($data)) {
>> >> $index = key($data);
>> >> sqlrcur_inputBind($sqlrcursor->cursor, $index,
>> >> $data["$index"]);
>> >> next($data);
>> >> }
>> >> }
>> >> ..........
>> >>
>> >> I try to modify it like :
>> >> function &execute(&$sqlrcursor, $data = false)
>> >> {
>> >> sqlrcur_clearBinds($sqlrcursor->cursor);
>> >> if ($data) {
>> >> while ($element = current($data)) {
>> >> $index = key($data);
>> >> if(is_numeric($index)) $index = "?";
>> >> sqlrcur_inputBind($sqlrcursor->cursor, $index,
>> >> $data["$index"]);
>> >> next($data);
>> >> }
>> >> }
>> >> ..........
>> >>
>> >> without success.
>> >>
>> >> Please thanks for your help
>> >>
>> >> livingdead
>> >>
>> >>
>> >> -------------------------------------------------------
>> >> This SF.Net email is sponsored by Oracle Space Sweepstakes
>> >> Want to be the first software developer in space?
>> >> Enter now for the Oracle Space Sweepstakes!
>> >> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
>> >> _______________________________________________
>> >> Sqlrelay-discussion mailing list
>> >> Sql...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>> >>
>> >
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.Net email is sponsored by Oracle Space Sweepstakes
>> > Want to be the first software developer in space?
>> > Enter now for the Oracle Space Sweepstakes!
>> > http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
>> > _______________________________________________
>> > Sqlrelay-discussion mailing list
>> > Sql...@li...
>> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>> >
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by Oracle Space Sweepstakes
>> Want to be the first software developer in space?
>> Enter now for the Oracle Space Sweepstakes!
>> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_idt12&alloc_id344&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: David M. <dav...@fi...> - 2005-06-02 03:54:00
|
I just made a maintenance release which should address these errors,
give it a try and let me know how it goes.
Dave
dav...@fi...
On Fri, 2005-05-20 at 17:56 +0200, david forums wrote:
> That would be very nice.
>
> Thanks for your work
>
> livingdead
>
> Le Fri, 20 May 2005 11:40:42 -0400, Firstworks/4access
> <dav...@fi...> a écrit:
>
> > Ahh, I see.
> >
> > I'll have to look into this a bit further. Maybe I can get SQL Relay to
> > support ?'s in short order.
> >
> > Dave
> >
> > On Fri, 2005-05-20 at 17:15 +0200, david forums wrote:
> >> Sorry but I'm not the manager of those question mark, it's PEAR DB who
> >> set
> >> those question mark automatically, when we are using autoExecute
> >> functions.
> >>
> >> So I do not know how to change it in PEAR DB, and How it will not break
> >> the portability of PEAR DB
> >>
> >> regards
> >>
> >> livingdead
> >>
> >>
> >>
> >>
> >>
> >> Le Fri, 20 May 2005 10:57:29 -0400, Firstworks/4access
> >> <dav...@fi...> a écrit:
> >>
> >> > SQL Relay uses Oracle-style bind variables, so try using:
> >> >
> >> > INSERT INTO myTable (col1,col2,col3) VALUES (:1,:2,:3)
> >> >
> >> > and see if that doesn't work better (using the original code for the
> >> > execute function).
> >> >
> >> > Supporting ?'s is on the TODO list, but I haven't implemented it yet.
> >> >
> >> > Dave
> >> > dav...@fi...
> >> >
> >> > On Fri, 2005-05-20 at 16:12 +0200, david forums wrote:
> >> >> Hello
> >> >>
> >> >> so Here is the request
> >> >>
> >> >> $db->autoExecute("myTable", $lstField, DB_AUTOQUERY_INSERT);
> >> >>
> >> >> this build the several request (inside PEAR DB)
> >> >> INSERT INTO myTable (col1,col2,col3) VALUES (?,?,?)
> >> >>
> >> >> But it seems that when it reach the execute fonction, it's not able
> >> to
> >> >> fill the ?, with the right data.
> >> >> Analysing the function I discover this :
> >> >>
> >> >> function &execute(&$sqlrcursor, $data = false)
> >> >> {
> >> >> sqlrcur_clearBinds($sqlrcursor->cursor);
> >> >> if ($data) {
> >> >> while ($element = current($data)) {
> >> >> $index = key($data);
> >> >> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> >> >> $data["$index"]);
> >> >> next($data);
> >> >> }
> >> >> }
> >> >> ..........
> >> >>
> >> >> I try to modify it like :
> >> >> function &execute(&$sqlrcursor, $data = false)
> >> >> {
> >> >> sqlrcur_clearBinds($sqlrcursor->cursor);
> >> >> if ($data) {
> >> >> while ($element = current($data)) {
> >> >> $index = key($data);
> >> >> if(is_numeric($index)) $index = "?";
> >> >> sqlrcur_inputBind($sqlrcursor->cursor, $index,
> >> >> $data["$index"]);
> >> >> next($data);
> >> >> }
> >> >> }
> >> >> ..........
> >> >>
> >> >> without success.
> >> >>
> >> >> Please thanks for your help
> >> >>
> >> >> livingdead
> >> >>
> >> >>
> >> >> -------------------------------------------------------
> >> >> This SF.Net email is sponsored by Oracle Space Sweepstakes
> >> >> Want to be the first software developer in space?
> >> >> Enter now for the Oracle Space Sweepstakes!
> >> >> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> >> >> _______________________________________________
> >> >> Sqlrelay-discussion mailing list
> >> >> Sql...@li...
> >> >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >> >>
> >> >
> >> >
> >> >
> >> > -------------------------------------------------------
> >> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> >> > Want to be the first software developer in space?
> >> > Enter now for the Oracle Space Sweepstakes!
> >> > http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> >> > _______________________________________________
> >> > Sqlrelay-discussion mailing list
> >> > Sql...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >> >
> >>
> >>
> >>
> >>
> >> -------------------------------------------------------
> >> This SF.Net email is sponsored by Oracle Space Sweepstakes
> >> Want to be the first software developer in space?
> >> Enter now for the Oracle Space Sweepstakes!
> >> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> >> _______________________________________________
> >> Sqlrelay-discussion mailing list
> >> Sql...@li...
> >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >>
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > Want to be the first software developer in space?
> > Enter now for the Oracle Space Sweepstakes!
> > http://ads.osdn.com/?ad_idt12&alloc_id344&op=click
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> >
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: david f. <df...@vi...> - 2005-06-10 12:43:11
|
Hello
After my last email, I recompile the rpm myself, even if I meet some
difficulties, I could get a new "sql_relay.so", with works fine.
But using "sqlrelay.php" pear module, I get the following output :
Result Set Buffer Size: 100 Connecting to listener... Unix socket:
/tmp/MyPostgres.socket Authenticating with listener : pgTest:test No
authentication error. Must Not Reconnect. Authenticating with connection :
pgTest:test No authentication error. Sending Query: select
nextval('public.mySequence') Length: 35 Requesting a new cursor. Sending 0
Input Bind Variables: Sending Output Bind Variables: Send Column Info: yes
Skipping and Fetching row to get: 99 Skipping 0 rows Fetching 100 rows
Checking For An Error... none. Getting Cursor ID... Cursor ID: 0 Previous
result set was not suspended. Parsing Column Info Actual row count: 1
Affected row count: 0 Column count: 1 "nextval","20", 8 (0,0) NOT NULL
Receiving Output Bind Values: Parsing Data "4", Got end of result set.
Warning: Missing argument 2 for DB_sqlrelay_cursor::DB_sqlrelay_cursor()
in /usr/share/pear/DB/sqlrelay.php on line 36
Aborting Result Set For Cursor: 0 Deallocated cursor
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 278
Identifying... postgresql
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 297
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 297
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 297
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 297
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 297
Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
line 297
Result Set Buffer Size: 100
Notice: Undefined variable: connection in /usr/share/pear/DB/sqlrelay.php
on line 204
Sending Query: INSERT INTO myTable (id,libelle,lid) VALUES
(:id,:libelle,:lid) Length: 74 Requesting a new cursor. Sending 3 Input
Bind Variables: id(4:STRING)=1(1) libelle(9:STRING)=Monsieur(8)
lid(4:STRING)=4(1) Sending Output Bind Variables: Send Column Info: yes
Skipping and Fetching row to get: 99 Skipping 0 rows Fetching 100 rows
Checking For An Error...
Aborting Result Set For Cursor: 0 Deallocated cursor
Fatal error: Uncaught exception 'Exception' with message 'DB Error:
unknown error' in my.class.php5:251 Stack trace: #0 my.class.php5(251):
my::save() #1 other.php5(23): other->save() #2 {main} thrown in
my.class.php5 on line 251
Ending Session Deallocated connection
Is it normal ???
Could you help please
david
|
|
From: David M. <dav...@fi...> - 2005-06-22 03:01:03
|
Looks like there's a stray debug command left over from testing.
Edit sqlrelay.php, look for sqlrcon_debugOn() and remove the line.
I think also I put the identity variable in the wrong class. Remove it
from the DB_sqlrelay_cursor class (around line 33) and add it to the
DB_sqlrelay class (around line 52) and see if that doesn't fix it.
Dave
dav...@fi...
On Fri, 2005-06-10 at 14:42 +0200, david forums wrote:
> Hello
>
> After my last email, I recompile the rpm myself, even if I meet some
> difficulties, I could get a new "sql_relay.so", with works fine.
>
> But using "sqlrelay.php" pear module, I get the following output :
> Result Set Buffer Size: 100 Connecting to listener... Unix socket:
> /tmp/MyPostgres.socket Authenticating with listener : pgTest:test No
> authentication error. Must Not Reconnect. Authenticating with connection :
> pgTest:test No authentication error. Sending Query: select
> nextval('public.mySequence') Length: 35 Requesting a new cursor. Sending 0
> Input Bind Variables: Sending Output Bind Variables: Send Column Info: yes
> Skipping and Fetching row to get: 99 Skipping 0 rows Fetching 100 rows
> Checking For An Error... none. Getting Cursor ID... Cursor ID: 0 Previous
> result set was not suspended. Parsing Column Info Actual row count: 1
> Affected row count: 0 Column count: 1 "nextval","20", 8 (0,0) NOT NULL
> Receiving Output Bind Values: Parsing Data "4", Got end of result set.
> Warning: Missing argument 2 for DB_sqlrelay_cursor::DB_sqlrelay_cursor()
> in /usr/share/pear/DB/sqlrelay.php on line 36
> Aborting Result Set For Cursor: 0 Deallocated cursor
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 278
> Identifying... postgresql
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 297
>
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 297
>
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 297
>
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 297
>
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 297
>
> Notice: Undefined variable: identity in /usr/share/pear/DB/sqlrelay.php on
> line 297
> Result Set Buffer Size: 100
> Notice: Undefined variable: connection in /usr/share/pear/DB/sqlrelay.php
> on line 204
> Sending Query: INSERT INTO myTable (id,libelle,lid) VALUES
> (:id,:libelle,:lid) Length: 74 Requesting a new cursor. Sending 3 Input
> Bind Variables: id(4:STRING)=1(1) libelle(9:STRING)=Monsieur(8)
> lid(4:STRING)=4(1) Sending Output Bind Variables: Send Column Info: yes
> Skipping and Fetching row to get: 99 Skipping 0 rows Fetching 100 rows
> Checking For An Error...
> Aborting Result Set For Cursor: 0 Deallocated cursor
> Fatal error: Uncaught exception 'Exception' with message 'DB Error:
> unknown error' in my.class.php5:251 Stack trace: #0 my.class.php5(251):
> my::save() #1 other.php5(23): other->save() #2 {main} thrown in
> my.class.php5 on line 251
>
> Ending Session Deallocated connection
>
>
>
>
> Is it normal ???
>
> Could you help please
>
> david
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput
> a projector? How fast can you ride your desk chair down the office luge track?
> If you want to score the big prize, get to know the little guy.
> Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: david f. <df...@vi...> - 2005-06-14 14:17:29
|
Hi Concerning the last update you made in the version 0.36.3. I detecte the following error concerning php pear module. When I try to use autoExecute and I send NULL value, it is replying : syntax error on or close to «:» I try the same sentence using straight database access and it works well. Could you help to solve it, please. Regards David |
|
From: David M. <dav...@fi...> - 2005-06-22 02:54:15
|
I think I know what's causing that. I need to fix that and another bug and make a 0.36.4 release. I should be able to get that done this week. Dave dav...@fi... On Tue, 2005-06-14 at 15:46 +0200, david forums wrote: > Hi > > Concerning the last update you made in the version 0.36.3. > > I detecte the following error concerning php pear module. > > When I try to use autoExecute and I send NULL value, it is replying : > syntax error on or close to «:» > > I try the same sentence using straight database access and it works well. > > Could you help to solve it, please. > > Regards > > David > > > ------------------------------------------------------- > This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput > a projector? How fast can you ride your desk chair down the office luge track? > If you want to score the big prize, get to know the little guy. > Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X