Re: Interbase: how can I insert null values with placeholders?

I found this bug and fixed it but my patch has not been included in the cvs source yet. (Note, someone should give me cvs access to the interbase source.) The problem is that the interbase extension has been pretty much untouched since php3 and I don't think that the null value was added until php4. I have attached the patch, it also changes blobs so that no special processing is necessary to use them. -- Jeremy Bettis jeremy+phpnews@deadbeef.com "Kiss Marton" <martin@eaglesoft.hu> wrote in message news:20010706172706.23920.qmail@pb1.pair.com... > Hi! > > I like to insert null values with placeholders in ibase_query. But it > doesn't work. > > $stmt = "insert into category_prop \n". > "(id, category_id, category_prop_type_id, asinteger, asfloat, > ascurrency, asstring) \n". > "values (gen_id(gen_category_prop_id,1),1097,109,?,?,?,?)"; > > $asinteger = null; > $asfloat = 2.5; > $ascurrency = 3; > $asstring = "apple"; > > $sth = ibase_query($dbh, $stmt, > $asinteger, > $asfloat, > $ascurrency, > $asstring); > > This statement insert '0' instead null. Why? > > Best Regards, > Kiss Marton > martin@eaglesoft.hu > > > begin 666 php.diff.txt M26YD97@Z(&5X="]I;G1E<F)A<V4O:6YT97)B87-E+F,-"CT]/3T]/3T]/3T] M/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T] M/3T]/3T]/3T]/3T-"E)#4R!F:6QE.B O<F5P;W-I=&]R>2]P:' T+V5X="]I M;G1E<F)A<V4O:6YT97)B87-E+F,L=@T*<F5T<FEE=FEN9R!R979I<VEO;B Q M+C4X#0ID:69F("UU("UR,2XU."!I;G1E<F)A<V4N8PT*+2TM(&5X="]I;G1E M<F)A<V4O:6YT97)B87-E+F,),C P,2\P-B\P.2 P.3HS,#HT,@DQ+C4X#0HK M*RL@97AT+VEN=&5R8F%S92]I;G1E<F)A<V4N8PDR,# Q+S W+S V(#$T.C4Y M.C Q#0I 0" M,C4L-B K,C4L,34@0$ -"B -"B O*@T*( E#:&%N9V5S.@T* M*PD@(" @,C P,2TP-BTQ,SH@2F5R96UY($)E='1I<R \:F5R96UY0&1E861B M965F+F-O;3X-"BL)(" @(" @(" M(%)E='5R;B!T:&4@=&5X="!O9B!B;&]B M<R!I;B!?<&AP7VEB87-E7V9E=&-H7VAA<V@L(&YO="!T:&4@8FQO8@T**PD@ M(" @(" @(" @:&%N9&QE<RP@979E;B!I9B!T:&4@0DQ/0B!I<R!N;W0@;V8@ M5$585"!T>7!E#0HK"0DR,# Q+3 U+3,Q.B!*97)E;7D@0F5T=&ES(#QJ97)E M;7E 9&5A9&)E968N8V]M/@T**PD)"2T@268@82!B;&]B(&AA;F1L92!W87,@ M97AP96-T960@86YD('-O;65T:&EN9R!E;'-E('=A<PT**PD)"2 @<F5C96EV M960@8W)E871E(&$@8FQO8B!A;F0@861D('1H92!V86QU92!T;R!I="X-"BL) M"0DM($EF('1H92!I;F-O;6EN9R!A<F=U;65N="!T;R!A(&)I;F0@<&%R86UE M=&5R(&ES($Y53$P-"BL)"0D@('1H96X@<W1O<F4@82!.54Q,(&EN('1H92!D M871A8F%S92X-"BL)"0DM($UO<F4@=F5R8F]S92!D871E(&5R<F]R<RX-"B ) M"3$Y.3DM,#DM,C$Z"4EV;R!086YA8V5K(#QI=F]P0')E9VEO;F5T+F-Z/@T* M( D)"2T@861D960@0T]-4$E,15]$3"!S96-T:6]N#0H@"0D)+2!M;W)E('9E M<F)O<V4@<&AP7VEN9F]?:6)A<V4@9G5N8W1I;VX-"D! ("TQ,3,P+#<@*S$Q M,SDL-R! 0 T*( T*("\J('M[>R!?<&AP7VEB87-E7V)I;F0H*0T*(" @($)I M;F0@<&%R86UE=&5R('!L86-E:&]L9&5R<R!I;B!A('!R979I;W5S;'D@<')E M<&%R960@<75E<GD@*B\-"BUS=&%T:6,@:6YT(%]P:'!?:6)A<V5?8FEN9"A8 M4U%,1$$@*G-Q;&1A+"!P=F%L("HJ8E]V87)S+"!"24Y$7T)51B J8G5F*0T* M*W-T871I8R!I;G0@7W!H<%]I8F%S95]B:6YD*%A344Q$02 J<W%L9&$L('!V M86P@*BIB7W9A<G,L($))3D1?0E5&("IB=68L(&EB87-E7W%U97)Y("II8E]Q M=65R>2D-"B![#0H@"5A344Q605(@*G9A<CL-"B )<'9A;" J8E]V87([#0I M0" M,3$T,RPV("LQ,34R+#$U($! #0H@"0EV87(M/G-Q;&EN9 D@/2 F8G5F M6VE=+G-Q;&EN9#L-"B )"6)?=F%R(#T@8E]V87)S6VE=.PT*( D)#0HK"0EI M9B H8E]V87(M/G1Y<&4@/3T@25-?3E5,3"D@>PT**PD)"7-T871I8R!C:&%R M(&YO=&AI;F=;-C1=.PT**PD)"7-T871I8R!S:&]R="!N=6QL7V9L86<@/2 M M,3L-"BL)"0EV87(M/G-Q;&1A=&$@/2!N;W1H:6YG.PT**PD)"79A<BT^<W%L M='EP92!\/2 Q.PT**PD)"79A<BT^<W%L:6YD(#T@)FYU;&Q?9FQA9SL-"BL) M"0EI9B H=F%R+3YS<6QL96X@/B V-"D-"BL)"0D)=F%R+3YS<6QL96X@/2 V M-#L-"BL)"7T@96QS90T*( D)<W=I=&-H*'9A<BT^<W%L='EP92 F('XQ*2![ M#0H@"0D)8V%S92!344Q?5$585#H)"0D@(" O*B!D:7)E8W0@=&\@=F%R:6%B M;&4@*B\-"B )"0EC87-E(%-13%]605)924Y'.@T*0$ @+3$R,C L-R K,3(S M."PW($! #0H@"0D)"0EN(#T@<W-C86YF*&)?=F%R+3YV86QU92YS='(N=F%L M+"(E9"4J6R]=)60E*ELO725D("5D)2I;.ETE9"4J6SI=)60B+ T*( D)"0D) M"2 @("9T+G1M7VUO;BP@)G0N=&U?;61A>2P@)G0N=&U?>65A<BP@("9T+G1M M7VAO=7(L("9T+G1M7VUI;BP@)G0N=&U?<V5C*3L-"B )"0D)"6EF*&X@(3T@ M,R F)B!N("$](#8I>PT*+0D)"0D)"5]P:'!?:6)A<V5?;6]D=6QE7V5R<F]R M*")I;G9A;&ED(&1A=&4O=&EM92!F;W)M870B*3L-"BL)"0D)"0E?<&AP7VEB M87-E7VUO9'5L95]E<G)O<B@B:6YV86QI9"!D871E+W1I;64@9F]R;6%T.B!% M>'!E8W1E9" S(&]R(#8@9FEE;&1S+"!G;W0@)60N(%5S92!F;W)M870@;2]D M+UD@2#II.G,N(%EO=2!G879E("<E<R<B+"!N+"!B7W9A<BT^=F%L=64N<W1R M+G9A;"D[#0H@"0D)"0D)<F5T=7)N($9!24Q54D4[#0H@"0D)"0E]#0H@"0D) M"0ET+G1M7WEE87(@+3T@,3DP,#L-"D! ("TQ,C<X+#$R("LQ,CDV+#,V($! M#0H@"0D)"0EI9B H8E]V87(M/G1Y<&4@(3T@25-?4U1224Y'#0H@"0D)"0D) M?'P@8E]V87(M/G9A;'5E+G-T<BYL96X@(3T@<VEZ96]F*&EB87-E7V)L;V)? M:&%N9&QE*0T*( D)"0D)"7Q\("@H:6)A<V5?8FQO8E]H86YD;&4@*BDH8E]V M87(M/G9A;'5E+G-T<BYV86PI*2T^8FQ?:&%N9&QE("$](# I('L-"BL)"0D) M"0E)0DQ37T9%5$-(*"D[#0HK"0D)"0D):6)A<V5?8FQO8E]H86YD;&4@*FEB M7V)L;V([#0HK"0D)"0D):6)?8FQO8B ]("AI8F%S95]B;&]B7VAA;F1L92 J M*2!E;6%L;&]C*'-I>F5O9BAI8F%S95]B;&]B7VAA;F1L92DI.PT**PD)"0D) M"6EB7V)L;V(M/G1R86YS7VAA;F1L92 ](&EB7W%U97)Y+3YT<F%N<SL-"BL) M"0D)"0EI8E]B;&]B+3YL:6YK(#T@:6)?<75E<GDM/FQI;FL[#0HK"0D)"0D) M:6)?8FQO8BT^8FQ?:&%N9&QE(#T@3E5,3#L-"BL)"0D)"0EI9B H:7-C7V-R M96%T95]B;&]B*$E"7U-405154RP@)FEB7V)L;V(M/FQI;FLL("9I8E]B;&]B M+3YT<F%N<U]H86YD;&4L("9I8E]B;&]B+3YB;%]H86YD;&4L("9I8E]B;&]B M+3YB;%]Q9"DI('L-"BL)"0D)"0D)969R964H:6)?8FQO8BD[#0HK"0D)"0D) M"5]P:'!?:6)A<V5?97)R;W(H*3L-"BL)"0D)"0D)<F5T=7)N($9!24Q54D4[ M#0HK"0D)"0D)?0T**PD)"0D)"6-O;G9E<G1?=&]?<W1R:6YG*&)?=F%R*3L- M"BL)"0D)"0EI9B H:7-C7W!U=%]S96=M96YT*$E"7U-405154RP@)FEB7V)L M;V(M/F)L7VAA;F1L92P@*'5N<VEG;F5D('-H;W)T*2!B7W9A<BT^=F%L=64N M<W1R+FQE;BP@8E]V87(M/G9A;'5E+G-T<BYV86PI*2![#0HK"0D)"0D)"5]P M:'!?:6)A<V5?97)R;W(H*3L-"BL)"0D)"0D)<F5T=7)N($9!24Q54D4[#0HK M"0D)"0D)?0T**PD)"0D)"6EF("AI<V-?8VQO<V5?8FQO8BA)0E]35$%455,L M("9I8E]B;&]B+3YB;%]H86YD;&4I*2![#0HK"0D)"0D)"5]P:'!?:6)A<V5? M97)R;W(H*3L-"BL)"0D)"0D)<F5T=7)N($9!24Q54D4[#0HK"0D)"0D)?0T* M*PD)"0D)"6EB7V)L;V)?:60@/2!I8E]B;&]B.PT**PD)"0D)"79A<BT^<W%L M9&%T82 ]("AV;VED($E30U]&05(@*BDF:6)?8FQO8E]I9"T^8FQ?<60[#0HK M+RH-"B )"0D)"0E?<&AP7VEB87-E7VUO9'5L95]E<G)O<B@B:6YV86QI9"!B M;&]B(&ED('-T<FEN9R(I.PT*( D)"0D)"7)E='5R;B!&04E,55)%.PT**RHO M#0HK"0D)"0E](&5L<V4@>PT**PD)"0D)"6EB7V)L;V)?:60@/2 H:6)A<V5? M8FQO8E]H86YD;&4@*BEB7W9A<BT^=F%L=64N<W1R+G9A;#L-"BL)"0D)"0EV M87(M/G-Q;&1A=&$@/2 H=F]I9"!)4T-?1D%2("HI)FEB7V)L;V)?:60M/F)L M7W%D.PT*( D)"0D)?0T*+0D)"0D):6)?8FQO8E]I9" ]("AI8F%S95]B;&]B M7VAA;F1L92 J*6)?=F%R+3YV86QU92YS='(N=F%L.PT*+0D)"0D)#0HM"0D) M"0EV87(M/G-Q;&1A=&$@/2 H=F]I9"!)4T-?1D%2("HI)FEB7V)L;V)?:60M M/F)L7W%D.PT*( D)"0E]#0H@"0D)8G)E86L[#0H@"0D)8V%S92!344Q?05)2 M05DZ#0I 0" M,3,Y-2PW("LQ-#,W+#<@0$ -"B )"6EN7W-Q;&1A(#T@96UA M;&QO8RA84U%,1$%?3$5.1U1(*&EB7W%U97)Y+3YI;E]S<6QD82T^<W%L9"DI M.PT*( D);65M8W!Y*&EN7W-Q;&1A+"!I8E]Q=65R>2T^:6Y?<W%L9&$L(%A3 M44Q$05],14Y'5$@H:6)?<75E<GDM/FEN7W-Q;&1A+3YS<6QD*2D[#0H@"0EB M:6YD7V)U9B ](&5M86QL;V,H<VEZ96]F*$))3D1?0E5&*2 J(&EB7W%U97)Y M+3YI;E]S<6QD82T^<W%L9"D[#0HM"0EI9B H7W!H<%]I8F%S95]B:6YD*&EN M7W-Q;&1A+"!A<F=S+"!B:6YD7V)U9BD@/3T@1D%)3%5212D@>PT**PD):68@ M*%]P:'!?:6)A<V5?8FEN9"AI;E]S<6QD82P@87)G<RP@8FEN9%]B=68L(&EB M7W%U97)Y*2 ]/2!&04E,55)%*2![#0H@"0D)24)$14)51R@B0V]U;&0@;F]T M(&)I;F0@:6YP=70@6%-13$1!+BXN("A?<&AP7VEB87-E7V5X96,I(BD[#0H@ M"0D)9V]T;R!?<&AP7VEB87-E7V5X96-?97)R;W([#0H@"0E]#0I 0" M,3DV M,2PW("LR,# S+#<@0$ -"B )"0D)"5]P:'!?:6)A<V5?=F%R7W!V86PH=&UP M+"!V87(M/G-Q;&1A=&$L('9A<BT^<W%L='EP92P@=F%R+3YS<6QL96XL('9A M<BT^<W%L<V-A;&4L(&9L86<I.PT*( D)"0D)8G)E86L[#0H@"0D)"6-A<V4@ M4U%,7T),3T(Z#0HM"0D)"0EI9B H9FQA9R F(%!(4%])0D%315]415A4*2![ M("\J('1E>'0@/R J+PT**PD)"0D):68@*#$@+RIF;&%G("8@4$A07TE"05-% M7U1%6%0J+RD@>R O*B!T97AT(#\@*B\-"B )"0D)"0EI;G0@<W1A=#L-"B ) M"0D)"0EI<V-?8FQO8E]H86YD;&4@8FQ?:&%N9&QE(#T@3E5,3#L-"B )"0D) F"0E)4T-?3$].1R!M87A?;&5N(#T@,"P@8W5R7VQE;B ](# [#0H` ` end