error -229 with php
Hi,
I'm using Informix 9.40.UC2 on Redhat Fedora, apache 1.3.29 and php 4.2.1
Everythink works fine, but then I tried the following:
$conn=@ifx_connect("database@server","user","passwd");
define("DB",$conn);
$sql="select * from myview ";
$sql.=" where rna_text = \\"blabla\\" ";
$sql.=" order by gruppe,hhdm,rest,gebaeude,ebene_sort,raum_nr_sort";
$res=@ifx_prepare($sql,DB);
if (! $res){ echo"error 1"; };
if (! ifx_do($res)){ echo"error 2"; };
$row=ifx_fetch_row($res,"NEXT");
// ifx_free_result($res);
while (is_array($row)
{
$on=$row["on"];
$sql1="select flart from myview ";
$sql1.=" where on = ".$on;
$sql1.=" and rna_text =\\"blabla\\" ";
$res1=ifx_prepare($sql1,DB);
if (! $res1){ echo"error 3"; };
if (! ifx_do($res1))
{
echo ifx_error();
echo ifx_errormsg();
};
$row=ifx_fetch_row($res,"NEXT");
};
?>
There are two nested queries. After the first sql-block i have to use the
ifx_free_result, otherwise I get an informix-error -229. But I cant use it
because in my real program I want to use nested queries.
After getting this error I created a TEMPDBSPACE, its used when I create
temp tables (I checked that with the onstat -d), I tried to set the
DBTEMP-Variable in my apache-environment, but nothing works.
Any idea?
Hans-Dieter
begin 666 Hans-Dieter Tewes.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E1E=V5S.TAA;G,M1&EE=&5R
M#0I&3CI(86YS+41I971E<B!497=E<PT*3U)'.E)U:'(M56YI=F5R<VETY'0@
M0F]C:'5M#0I414P[5T]22SM&05@Z*S0Y+3(S-"TS,BTP.# Y. T*0412.U=/
M4DL[14Y#3T1)3D<]455/5$5$+5!224Y404),13H[*S0Y+3(S-"TS,BTR.# Y
M.#M$97IE<FYA=" V/3!$/3!!1V5B+B!.02 P,R\\W-#M";V-H=6T[3E)7.S0T
M-SDY.T1E=71S8VAL86YD#0I,04)%3#M73U)+.T5.0T]$24Y'/5%53U1%1"U0
M4DE.5$%"3$4Z*S0Y+3(S-"TS,BTR.# Y.#TP1#TP041E>F5R;F%T(#8],$0]
M,$%'96(N($Y!(# S+S<T/3!$/3!!0F]C:'5M+"!.4E<@-#0W.3D]#0H],$0]
M,$%$975T<V-H;&%N9 T*55),.U=/4DLZ:'1T<#HO+W=W=RYR=6AR+75N:2UB
M;V-H=6TN9&4-"D5-04E,.U!2148[24Y415).150Z2&%N<RU$:65T97(N5&5W
M97- 4G5H<BU5;FDM0F]C:'5M+F1E#0I2158Z,C P-# U,CA4,#8Q-S4V6@T*
+14Y$.E9#05)$#0H`
`
end