Mssql and Mysql patches

Hi, I don't know who applies patches, or who wants to? But I added transaction support in the mysql & the mssql classes. (Almost copy & paste from pgsql) and I added the affectedRows function to mssql. I have a question/remark related to the tableinfo function: Would it be possible to have a generic format types for all databases like : (CHAR,BLOB,DATE... etc...) ? Most PEAR supported databases support an sql statement to fetch tableinfo from the db. For example. (mssql): select syscolumns.name,systypes.name,syscolumns.length from syscolumns join systypes on systypes.xusertype=syscolumns.xusertype join sysobjects on sysobjects.id=syscolumns.id where sysobjects.name='$table' In that way we could have tableinfo for most databases. Sander begin 666 mssql.diff M+2TM(&US<W%L+G!H<"YO;&0)5'5E($IU;" Q," Q-SHP,3HS,B R,# Q"BLK M*R!M<W-Q;"YP:' )5'5E($IU;" S,2 Q,3HU-CHS,R R,# Q"D! ("TS,"PV M("LS,"PX($! "B @(" @=F%R("1P:'!T>7!E+" D9&)S>6YT87@[#0H@(" @ M('9A<B D<')E<&%R95]T;VME;G,@/2!A<G)A>2@I.PT*(" @("!V87(@)'!R M97!A<F5?='EP97,@/2!A<G)A>2@I.PT**R @("!V87(@)'1R86YS86-T:6]N M7V]P8V]U;G0@/2 P.PT**R @("!V87(@)&%U=&]C;VUM:70@/2!T<G5E.PT* M( T*(" @("!F=6YC=&EO;B!$0E]M<W-Q;"@I#0H@(" @('L-"D! ("TS.2PW M("LT,2PW($! "B @(" @(" @("1T:&ES+3YF96%T=7)E<R ](&%R<F%Y* T* M(" @(" @(" @(" @("=P<F5P87)E)R ]/B!F86QS92P-"B @(" @(" @(" @ M(" G<&-O;FYE8W0G(#T^('1R=64L#0HM(" @(" @(" @(" @)W1R86YS86-T M:6]N<R<@/3X@9F%L<V4-"BL@(" @(" @(" @(" G=')A;G-A8W1I;VYS)R ] M/B!T<G5E#0H@(" @(" @(" I.PT*(" @("!]#0H@#0I 0" M-S,L,34@*S<U M+#(U($! "B -"B @(" @9G5N8W1I;VX@<VEM<&QE475E<GDH)'%U97)Y*0T* M(" @("![#0HK(" @(" @(" D:7-M86YI<" ]($1".CII<TUA;FEP*"1Q=65R M>2D[#0H@(" @(" @(" D=&AI<RT^;&%S=%]Q=65R>2 M>]("1Q=65R>3L-"B @ M(" @(" @("1Q=65R>2 ]("1T:&ES+3YM;V1I9GE1=65R>2@D<75E<GDI.PT* M*R @(" @(" @:68@*"$D=&AI<RT^875T;V-O;6UI=" F)B D:7-M86YI<"D@ M>PT**R @(" @(" @(" @(&EF("@D=&AI<RT^=')A;G-A8W1I;VY?;W!C;W5N M=" ]/2 P*2![#0HK(" @(" @(" @(" @(" @("1R97-U;'0@/2! ;7-S<6Q? M<75E<GDH)T)%1TE.(%1204XG+" D=&AI<RT^8V]N;F5C=&EO;BD[#0HK(" @ M(" @(" @(" @(" @(&EF("@A)')E<W5L="D@>PT**R @(" @(" @(" @(" @ M(" @(" @<F5T=7)N("1T:&ES+3YR86ES945R<F]R*&US<W%L7V=E=%]L87-T M7VUE<W-A9V4H*2D[#0HK(" @(" @(" @(" @(" @('T-"BL@(" @(" @(" @ M("!]#0HK(" @(" @(" @(" @)'1H:7,M/G1R86YS86-T:6]N7V]P8V]U;G0K M*SL-"BL@(" @(" @('T-"B @(" @(" @("1R97-U;'0@/2! ;7-S<6Q?<75E M<GDH)'%U97)Y+" D=&AI<RT^8V]N;F5C=&EO;BD[#0H@(" @(" @("!I9B H M(21R97-U;'0I('L-"B @(" @(" @(" @("!R971U<FX@)'1H:7,M/G)A:7-E M17)R;W(H;7-S<6Q?9V5T7VQA<W1?;65S<V%G92@I*3L-"B @(" @(" @('T- M"B @(" @(" @("\O($1E=&5R;6EN92!W:&EC:"!Q=65R:65S('1H870@<VAO M=6QD(')E='5R;B!D871A+"!A;F0@=VAI8V@-"B @(" @(" @("\O('-H;W5L M9"!R971U<FX@86X@97)R;W(@8V]D92!O;FQY+@T*+2 @(" @(" @<F5T=7)N M($1".CII<TUA;FEP*"1Q=65R>2D@/R!$0E]/2R Z("1R97-U;'0[#0HK(" @ M(" @("!R971U<FX@)&ES;6%N:7 @/R!$0E]/2R Z("1R97-U;'0[#0H@(" @ M('T-"B -"B @(" @9G5N8W1I;VX@)F9E=&-H4F]W*"1R97-U;'0L("1F971C M:&UO9&4@/2!$0E]&151#2$U/1$5?1$5&055,5"P@)')O=VYU;3UN=6QL*0T* M0$ @+3$T."PV("LQ-C L.#,@0$ *(" @(" @(" @?0T*(" @(" @(" @<F5T M=7)N("1R;W=S.PT*(" @("!]#0HK#0HK(" @("\J*@T**R @(" @*B!%;F%B M;&4O9&ES86)L92!A=71O;6%T:6,@8V]M;6ET<PT**R @(" @*B\-"BL@(" @ M9G5N8W1I;VX@875T;T-O;6UI="@D;VYO9F8@/2!F86QS92D-"BL@(" @>PT* M*R @(" @(" @+R\@6%A8(&EF("1T:&ES+3YT<F%N<V%C=&EO;E]O<&-O=6YT M(#X@,"P@=V4@<VAO=6QD('!R;V)A8FQY#0HK(" @(" @(" O+R!I<W-U92!A M('=A<FYI;F<@:&5R92X-"BL@(" @(" @("1T:&ES+3YA=71O8V]M;6ET(#T@ M)&]N;V9F(#\@=')U92 Z(&9A;'-E.PT**R @(" @(" @<F5T=7)N($1"7T]+ M.PT**R @("!]#0HK#0HK(" @("\O('U]?0T**R @(" O+R![>WL@8V]M;6ET M*"D-"BL-"BL@(" @+RHJ#0HK(" @(" J($-O;6UI="!T:&4@8W5R<F5N="!T M<F%N<V%C=&EO;BX-"BL@(" @("HO#0HK(" @(&9U;F-T:6]N(&-O;6UI="@I M#0HK(" @('L-"BL@(" @(" @(&EF("@D=&AI<RT^=')A;G-A8W1I;VY?;W!C M;W5N=" ^(# I('L-"BL@(" @(" @(" @(" D<F5S=6QT(#T@0&US<W%L7W%U M97)Y*"=#3TU-250@5%)!3B<L("1T:&ES+3YC;VYN96-T:6]N*3L-"BL@(" @ M(" @(" @(" D=&AI<RT^=')A;G-A8W1I;VY?;W!C;W5N=" ](# [#0HK(" @ M(" @(" @(" @:68@*"$D<F5S=6QT*2![#0HK(" @(" @(" @(" @(" @(')E M='5R;B D=&AI<RT^<F%I<V5%<G)O<BAM<W-Q;%]G971?;&%S=%]M97-S86=E M*"DI.PT**R @(" @(" @(" @('T-"BL@(" @(" @('T-"BL@(" @(" @(')E M='5R;B!$0E]/2SL-"BL@(" @?0T**PT**R @(" O+R!]?7T-"BL@(" @+R\@ M>WM[(')O;&QB86-K*"D-"BL-"BL@(" @+RHJ#0HK(" @(" M>J(%)O;&P@8F%C M:R H=6YD;RD@=&AE(&-U<G)E;G0@=')A;G-A8W1I;VXN#0HK(" @(" J+PT* M*R @("!F=6YC=&EO;B!R;VQL8F%C:R@I#0HK(" @('L-"BL@(" @(" @(&EF M("@D=&AI<RT^=')A;G-A8W1I;VY?;W!C;W5N=" ^(# I('L-"BL@(" @(" @ M(" @(" D<F5S=6QT(#T@0&US<W%L7W%U97)Y*"=23TQ,0D%#2R!44D%.)RP@ M)'1H:7,M/F-O;FYE8W1I;VXI.PT**R @(" @(" @(" @("1T:&ES+3YT<F%N M<V%C=&EO;E]O<&-O=6YT(#T@,#L-"BL@(" @(" @(" @("!I9B H(21R97-U M;'0I('L-"BL@(" @(" @(" @(" @(" @<F5T=7)N("1T:&ES+3YR86ES945R M<F]R*&US<W%L7V=E=%]L87-T7VUE<W-A9V4H*2D[#0HK(" @(" @(" @(" @ M?0T**R @(" @(" @?0T**R @(" @(" @<F5T=7)N($1"7T]+.PT**R @("!] M#0HK#0HK(" @("\O('U]?0T**R @(" O+R![>WL@869F96-T9612;W=S*"D- M"BL-"BL@(" @+RHJ#0HK(" @(" J($=E=',@=&AE(&YU;6)E<B!O9B!R;W=S M(&%F9F5C=&5D(&)Y('1H92!L87-T('%U97)Y+@T**R @(" @*B!I9B!T:&4@ M;&%S="!Q=65R>2!W87,@82!S96QE8W0L(')E='5R;G,@,"X-"BL@(" @("H- M"BL@(" @("H@0')E='5R;B!N=6UB97(@;V8@<F]W<R!A9F9E8W1E9"!B>2!T M:&4@;&%S="!Q=65R>2!O<B!$0E]%4E)/4@T**R @(" @*B\-"BL@(" @9G5N M8W1I;VX@869F96-T9612;W=S*"D-"BL@(" @>PT**R @(" @(" @:68@*$1" M.CII<TUA;FEP*"1T:&ES+3YL87-T7W%U97)Y*2D@>PT**R @(" @(" @(" @ M("1R97,@/2! ;7-S<6Q?<75E<GDH)W-E;&5C="! 0')O=V-O=6YT)RP@)'1H M:7,M/F-O;FYE8W1I;VXI.PT**R @(" @(" @(" @(&EF("@A)')E<RD@>PT* M*R @(" @(" @(" @(" @("!R971U<FX@)'1H:7,M/G)A:7-E17)R;W(H;7-S M<6Q?9V5T7VQA<W1?;65S<V%G92@I*3L-"BL@(" @(" @(" @("!]#0HK(" @ M(" @(" @(" @)&%R(#T@0&US<W%L7V9E=&-H7W)O=R@D<F5S*3L-"BL@(" @ M(" @(" @("!I9B H(21A<BD@>PT**R @(" @(" @(" @(" @(" D<F5S=6QT M(#T@,#L-"BL@(" @(" @(" @("!](&5L<V4@>PT**R @(" @(" @(" @(" @ M("! ;7-S<6Q?9G)E95]R97-U;'0H)')E<RD[#0HK(" @(" @(" @(" @(" @ M("1R97-U;'0@/2 D87);,%T[#0HK(" @(" @(" @(" @?2 @(" @(" @#0HK M(" @(" @("!](&5L<V4@>PT**R @(" @(" @(" @("1R97-U;'0@/2 P.PT* M*R @(" @(" @?0T**R @(" @(" @<F5T=7)N("1R97-U;'0[#0HK(" @('T- 0"BL-"B!]#0H@#0H@/SX-"@`` ` end begin 666 mysql.diff M+2TM(&UY<W%L+G!H<"YO;&0)5&AU($IU;" R-B P,CHP.3HQ." R,# Q"BLK M*R!M>7-Q;"YP:' )5'5E($IU;" S,2 Q,CHS-SHR-" R,# Q"D! ("TS.2PV M("LS.2PX($! "B @(" @=F%R("1P<F5P87)E7W1O:V5N<R ](&%R<F%Y*"D[ M#0H@(" @('9A<B D<')E<&%R95]T>7!E<R ](&%R<F%Y*"D[#0H@(" @('9A M<B D;G5M7W)O=W,@/2!A<G)A>2@I.PT**R @("!V87(@)'1R86YS86-T:6]N M7V]P8V]U;G0@/2 P.PT**R @("!V87(@)&%U=&]C;VUM:70@/2!F86QS93L- M"B @(" @=F%R("1F971C:&UO9&4@/2!$0E]&151#2$U/1$5?3U)$15)%1#L@ M+RH@1&5F875L="!F971C:"!M;V1E("HO#0H@#0H@(" @("\O('U]?0T*0$ @ M+34X+#<@*S8P+#<@0$ *(" @(" @(" @)'1H:7,M/F9E871U<F5S(#T@87)R M87DH#0H@(" @(" @(" @(" @)W!R97!A<F4G(#T^(&9A;'-E+ T*(" @(" @ M(" @(" @("=P8V]N;F5C="<@/3X@=')U92P-"BT@(" @(" @(" @(" G=')A M;G-A8W1I;VYS)R ]/B!F86QS90T**R @(" @(" @(" @("=T<F%N<V%C=&EO M;G,G(#T^('1R=64-"B @(" @(" @("D[#0H@(" @(" @(" D=&AI<RT^97)R M;W)C;V1E7VUA<" ](&%R<F%Y* T*(" @(" @(" @(" @(#$P,#0@/3X@1$)? M15)23U)?0T%.3D]47T-214%412P-"D! ("TQ-C@L." K,3<P+#$Y($! "B @ M(" @("HO#0H@(" @(&9U;F-T:6]N('-I;7!L95%U97)Y*"1Q=65R>2D-"B @ M(" @>PT**R @(" @(" @)&ES;6%N:7 @/2!$0CHZ:7--86YI<"@D<75E<GDI M.PT*(" @(" @(" @)'1H:7,M/FQA<W1?<75E<GD@/2 D<75E<GD[#0H@(" @ M(" @(" D<75E<GD@/2 D=&AI<RT^;6]D:69Y475E<GDH)'%U97)Y*3L-"BL@ M(" @(" @(&EF("@A)'1H:7,M/F%U=&]C;VUM:70@)B8@)&ES;6%N:7 I('L- M"BL@(" @(" @(" @("!I9B H)'1H:7,M/G1R86YS86-T:6]N7V]P8V]U;G0@ M/3T@,"D@>PT**R @(" @(" @(" @(" @(" D<F5S=6QT(#T@0&UY<W%L7W%U M97)Y*"=3150@05543T-/34U)5#TP)RP@)'1H:7,M/F-O;FYE8W1I;VXI.PT* M*R @(" @(" @(" @(" @(" D<F5S=6QT(#T@0&UY<W%L7W%U97)Y*"="14=) M3B<L("1T:&ES+3YC;VYN96-T:6]N*3L-"BL@(" @(" @(" @(" @(" @:68@ M*"$D<F5S=6QT*2![#0HK(" @(" @(" @(" @(" @(" @("!R971U<FX@)'1H M:7,M/FUY<W%L4F%I<V5%<G)O<B@I.PT**R @(" @(" @(" @(" @("!]#0HK M(" @(" @(" @(" @?0T**R @(" @(" @(" @("1T:&ES+3YT<F%N<V%C=&EO M;E]O<&-O=6YT*RL[#0HK(" @(" @("!]#0H@(" @(" @(" D<F5S=6QT(#T@ M0&UY<W%L7W%U97)Y*"1Q=65R>2P@)'1H:7,M/F-O;FYE8W1I;VXI.PT*(" @ M(" @(" @:68@*"$D<F5S=6QT*2![#0H@(" @(" @(" @(" @<F5T=7)N("1T M:&ES+3YM>7-Q;%)A:7-E17)R;W(H*3L-"D! ("TS,30L-B K,S(W+#4X($! M"B @(" @(" @(" @("!R971U<FX@)'1H:7,M/FUY<W%L4F%I<V5%<G)O<B@I M.PT*(" @(" @(" @?0T*(" @(" @(" @<F5T=7)N("1R;W=S.PT**R @("!] M#0HK#0HK(" @("\O('U]?0T**R @(" O+R![>WL@875T;T-O;6UI="@I#0HK M#0HK(" @("\J*@T**R @(" @*B!%;F%B;&4O9&ES86)L92!A=71O;6%T:6,@ M8V]M;6ET<PT**R @(" @*B\-"BL@(" @9G5N8W1I;VX@875T;T-O;6UI="@D M;VYO9F8@/2!F86QS92D-"BL@(" @>PT**R @(" @(" @+R\@6%A8(&EF("1T M:&ES+3YT<F%N<V%C=&EO;E]O<&-O=6YT(#X@,"P@=V4@<VAO=6QD('!R;V)A M8FQY#0HK(" @(" @(" O+R!I<W-U92!A('=A<FYI;F<@:&5R92X-"BL@(" @ M(" @("1T:&ES+3YA=71O8V]M;6ET(#T@)&]N;V9F(#\@=')U92 Z(&9A;'-E M.PT**R @(" @(" @<F5T=7)N($1"7T]+.PT**R @("!]#0HK#0HK(" @("\O M('U]?0T**R @(" O+R![>WL@8V]M;6ET*"D-"BL-"BL@(" @+RHJ#0HK(" @ M(" J($-O;6UI="!T:&4@8W5R<F5N="!T<F%N<V%C=&EO;BX-"BL@(" @("HO M#0HK(" @(&9U;F-T:6]N(&-O;6UI="@I#0HK(" @('L-"BL@(" @(" @(&EF M("@D=&AI<RT^=')A;G-A8W1I;VY?;W!C;W5N=" ^(# I('L-"BL@(" @(" @ M(" @(" D<F5S=6QT(#T@0&UY<W%L7W%U97)Y*"=#3TU-250G+" D=&AI<RT^ M8V]N;F5C=&EO;BD[#0HK(" @(" @(" @(" @)')E<W5L=" ]($!M>7-Q;%]Q M=65R>2@G4T54($%55$]#3TU-250],2<L("1T:&ES+3YC;VYN96-T:6]N*3L- M"BL@(" @(" @(" @(" D=&AI<RT^=')A;G-A8W1I;VY?;W!C;W5N=" ](# [ M#0HK(" @(" @(" @(" @:68@*"$D<F5S=6QT*2![#0HK(" @(" @(" @(" @ M(" @(')E='5R;B D=&AI<RT^;7ES<6Q286ES945R<F]R*"D[#0HK(" @(" @ M(" @(" @?0T**R @(" @(" @?0T**R @(" @(" @<F5T=7)N($1"7T]+.PT* M*R @("!]#0HK#0HK(" @("\O('U]?0T**R @(" O+R![>WL@<F]L;&)A8VLH M*0T**PT**R @(" O*BH-"BL@(" @("H@4F]L;"!B86-K("AU;F1O*2!T:&4@ M8W5R<F5N="!T<F%N<V%C=&EO;BX-"BL@(" @("HO#0HK(" @(&9U;F-T:6]N M(')O;&QB86-K*"D-"BL@(" @>PT**R @(" @(" @:68@*"1T:&ES+3YT<F%N M<V%C=&EO;E]O<&-O=6YT(#X@,"D@>PT**R @(" @(" @(" @("1R97-U;'0@ M/2! ;7ES<6Q?<75E<GDH)U)/3$Q"04-+)RP@)'1H:7,M/F-O;FYE8W1I;VXI M.PT**R @(" @(" @(" @("1R97-U;'0@/2! ;7ES<6Q?<75E<GDH)U-%5"!! M551/0T]-34E4/3$G+" D=&AI<RT^8V]N;F5C=&EO;BD[#0HK(" @(" @(" @ M(" @)'1H:7,M/G1R86YS86-T:6]N7V]P8V]U;G0@/2 P.PT**R @(" @(" @ M(" @(&EF("@A)')E<W5L="D@>PT**R @(" @(" @(" @(" @("!R971U<FX@ M)'1H:7,M/FUY<W%L4F%I<V5%<G)O<B@I.PT**R @(" @(" @(" @('T-"BL@ M(" @(" @('T-"BL@(" @(" @(')E='5R;B!$0E]/2SL-"B @(" @?0T*( T* -(" @(" O+R!]?7T-"@`` ` end