<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1515" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=710011117-21092005>I have a recordset
that I would like to be able to filter based on the MetaType value of the
current field, so that I can display information that is only stored in "bit"
fields instead of all the other info that I pulled into my recordset for
purposes elsewhere in the code. Does anyone know of a way to do
this? Here is what I have tried so far...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=710011117-21092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=710011117-21092005>ADOLoadCode('mssql');<BR>$db =
ADONewConnection('mssql');<BR>$db->debug =
false; <BR>$db->connect(dbserver,userid,password,dbname);</SPAN></FONT></DIV>
<DIV><FONT face=Arial
size=2>$db->SetFetchMode(ADODB_FETCH_ASSOC);</FONT></DIV>
<DIV><FONT face=Arial size=2>$sql = "<SPAN class=710011117-21092005>
</SPAN>select * from <SPAN class=710011117-21092005>table
</SPAN>where <SPAN class=710011117-21092005>column</SPAN> = <SPAN
class=710011117-21092005>'someval' ";</SPAN><BR>$rs =
$db->Execute($sql);<BR>while (!$rs->EOF) {</FONT><FONT><BR><FONT
face=Arial><FONT size=2><SPAN class=710011117-21092005>
</SPAN>foreach ($rs->fields as $k => $v) {<BR><SPAN
class=710011117-21092005> </SPAN>if
($db->MetaType($rs->fields[$k]<SPAN class=710011117-21092005>)</SPAN> ==
"L") {<SPAN class=710011117-21092005> //failure on this
line: Call to undefined method ADODB_mssql::MetaType()</SPAN><BR><SPAN
class=710011117-21092005>
</SPAN>echo $v . "<hr />\n";<BR><SPAN
class=710011117-21092005></SPAN><SPAN
class=710011117-21092005> </SPAN>}<BR><SPAN
class=710011117-21092005>
</SPAN>}<BR>}</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV align=left><STRONG><EM><FONT face=sylfaen>Mark
Mikkelson</FONT></EM></STRONG></DIV>
<DIV align=left><FONT face=sylfaen size=2>MCSA Messaging, CIW
Professional</FONT></DIV>
<DIV align=left><FONT face=sylfaen size=2>Web Specialist</FONT></DIV>
<DIV align=left><STRONG><EM><FONT face=sylfaen size=2><A
href="mailto:mikkelson_mt@msn.com">mikkelson_mt@msn.com</A></FONT></EM></STRONG></DIV></DIV></BODY></HTML>