On 18/12/2009, at 2:26, John DeSoi wrote: > > On Dec 17, 2009, at 11:13 AM, Raimon Fernandez wrote: > >> I'm trying to integrate the extended query protocol with my libraries. >> >> I'm sending a simple SELECT to validate the method, but I'm getting an >> Invalid Message Format. > > I did not add up your byte count, but maybe this will help: > > > (write-byte p stream) > (write-int32 (+ int32-length (length name) 1 (length sql-string) 1 > int16-length (* int32-length param-count)) stream) > (write-cstring name stream) > (write-cstring sql-string stream) > (write-int16 param-count stream)
I'm doing as you say: mystatement => 11 select * from mytable; => 22 > (write-byte p stream) 50 => P > (write-int32 (+ int32-length (length name) 1 (length sql-string) 1 > int16-length (* int32-length param-count)) stream) 4 + 11 + 1 + 22 + 1 + 2 + 0 (param count=0) => 41 00 00 00 29 => length > (write-cstring name stream) 6D7973746174656D656E74 00 => mystatement + null > (write-cstring sql-string stream) 73656C656374202A2066726F6D206D797461626C653B 00 => select * from mytable; + null > (write-int16 param-count stream) 00 00 => number of parameters, zero any idea ??????? thanks, regards, r. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
