how can I check a recordset is null or not?

[pam]

sorry for my poor english first.

$notation=$rs->fields["notation"];
if(!empty($nota tion))
echo $notation;

the notation field in database is a text type, when the value is null,
it will cause a mistake;
i used empty function to check it, but it seems don't take effect.

In mysql you can use ISNULL(field_na me) to see if it's null or not... might
help ya.

-Mike

--
Melt away the Cellulite with Cellulean!
http://www.MeltAwayCellulite.com/
"pam" <pe******@gmail .com> wrote in message
news:11******** *************@l 41g2000cwc.goog legroups.com...

sorry for my poor english first.

$notation=$rs->fields["notation"];
if(!empty($nota tion))
echo $notation;

the notation field in database is a text type, when the value is null,
it will cause a mistake;
i used empty function to check it, but it seems don't take effect.

[Alvaro G Vicario]

*** pam wrote/escribió (25 Apr 2005 19:31:52 -0700):

$notation=$rs->fields["notation"];
if(!empty($nota tion))
echo $notation;

the notation field in database is a text type, when the value is null,
it will cause a mistake;
i used empty function to check it, but it seems don't take effect.

You don't give much info. Let's suppose you get your recordset through
mysql_fetch_ass oc(). Manual says:

"mysql_fetch_as soc [...] Returns an associative array that corresponds to
the fetched row, or FALSE if there are no more rows."

"This function sets NULL fields to PHP NULL value."

So:

How to check if a recordset is null or not? Test if $rs is FALSE:

if($rs){ ... }

How to check if a field is null or not? Test if $rs['field'] is NULL:

if(!is_null($rs['field'])){ ... }
--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--

[pam]

sorry, I don't know what it is mysql_fetch_ass oc(), I'm using a access
database now,

i can't express it clearly in english, so I paste more code.

<table bgcolor="#FFFFF F" cellspacing="1" width="100%" align="center">
<tr>
<th class="tables" width="10%">id</th>
<th class="tables" width="20%">bra nd</th>
<th class="tables" width="10%">typ e</th>
<th class="tables" width="10%">col or</th>
<th class="tables" width="10%">siz e</th>
<th class="tables" width="50%">not ation</th>
</tr>
<?php
for($i=1;$i<=$r s->pagesize;$i++) {
?>
<tr bgcolor="#DEE7E F" align="center">
<td class="tables"> <?php echo $rs->fields["id"]?></td>
<td class="tables"> <?php echo $rs->fields["brand"]?></td>
<td class="tables"> <?php echo $rs->fields["type"]?></td>
<td class="tables"> <?php echo $rs->fields["color"]?></td>
<td class="tables"> <?php echo $rs->fields["size"]?></td>
<td class="tables"> <?php if(!is_null($rs->fields["notation"])) echo
$rs->fields["notation"];?></td>
</tr>
<?php
$rs->movenext;
if($rs->eof) break;
}

i used a is_null function in it, but it still has mistake,
when I delete this line:echo $rs->fields["notation"];
It will work no problem, and i set a value in notation fields, it can
work also, only when the value is null, it will cause a mistake,I don't
know how to check the recordset is null.

[Alvaro G Vicario]

*** pam wrote/escribió (26 Apr 2005 03:33:53 -0700):

sorry, I don't know what it is mysql_fetch_ass oc(), I'm using a access
database now, [...] for($i=1;$i<=$r s->pagesize;$i++) {

I insist: find out where $rs comes from and read its manual page.
--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--

[pam]

i copyed the code about where $rs comes from.

global $conn;
$connstr = "DRIVER={Micros oft Access Driver (*.mdb)};
DBQ=D:/pam/web/php/clothes/clothes.mdb";
$conn = new com("ADODB.Conn ection");
$conn->Open($connstr) ;
$rs = new com("ADODB.Reco rdset");
$sqltext = "SELECT clothes.id, brand.brand, type.type,
clothes_type.co lor, clothes_type.si ze, clothes.notatio n FROM type INNER
JOIN ((brand INNER JOIN clothes_type ON brand.id = clothes_type.br and)
INNER JOIN clothes ON clothes_type.mo del = clothes.typeid) ON type.id =
clothes_type.ty pe";

$rs->open($sqltext, $conn,1,1);

It will works no problem when I the value is not null, so I think it
won't be the recordset is null.

[Alvaro G Vicario]

*** pam wrote/escribió (26 Apr 2005 04:08:11 -0700):

$rs = new com("ADODB.Reco rdset");

Right, we're getting closer. You're instantiating an OLE compatible COM
object. That means that you should read the object's API documentation
since PHP has nothing to do with it :(

Now you need to make sure you understand some database concepts:

* A recordset is a matrix that contains the complete result of a query
* A row (or record) is one line of the recordset
* A column (or field) if one item of the row

So, what's your problem with? Recordsets, rows or columns?

Given that your problem comes with NULL columns, I suggest you investigate
the following functions and operators:

gettype()
print_r()
is_null()
===
--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--