From: [EMAIL PROTECTED]
Operating system: Windows 98
PHP version: 4.0.6
PHP Bug Type: ODBC related
Bug description: Pb with odbc_columns(); the 12th result(description)has a incorrect
format
The problem is that after these 2 lines:
$resCol=odbc_columns($odbc_connect);
$des=odbc_result($resCol,12);
the print function works(the same for echo), and show the description as
asked, but when I have to use it
in an SQLreq., I have an error:
####
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error
in string in query expression ''(ex: media).'.,
SQL state 37000 in SQLExecDirect in
C:\Inetpub\wwwroot\cgi-bin\database\configok.php on line 95
####
As you can see I use an Access Database(2000)
I tried to cut the string in logical way or static way but I don't find
one working
for all. However, often, if I cut the last 30 c. with $des=substr ($des,
0,strlen($des)-30);, it works for several fields, but not all...I tried to
cut 3, to keep all until "." that I had added to all my fields.
So here is a part of my code:(it's to make a table containing all fields
with their description all fields have a different name) and I can say that
there is not any problem with para 3(name of table),4(name of field):
$resCol=odbc_columns($odbc_connect);
$tablen=odbc_result($resTable,3);
while(odbc_fetch_row($resCol))
{
if (odbc_result($resCol,3)==$tablen)//if the table of
the column
{ //is
the table called
$i++ ;
$col=odbc_result($resCol,4); //set col to the name
of the field
//############################description doesn't
work###################
$des=odbc_result($resCol,12);
//echo "<br>";
//print strlen($des);
// echo "<br>";
// $des=substr ($des, 0,strrpos ($des, ".")-1);
$des=substr ($des, 0,strlen($des)-30);
// print strlen($des);
echo "<br>";
if (empty($des))
{
$des="a definir";
}
echo "description: $des" ;
//#######################################################################
if (!empty($HTTP_POST_VARS['fillFields']))
{
$sql="INSERT INTO [FieldsUsed] (field,tablen,
descript) VALUES ('$col', '$tablen','$des')";
odbc_exec($odbc_connect,$sql);
}
--
Edit bug report at: http://bugs.php.net/?id=11974&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
