PHP 4.0 Bug #6065 Updated: Returns a "The document contained no data" error while accessing MS-SQL 7.0

ID: 6065 User Update by: jms18@guinness.som.cwru.edu Status: Open Bug Type: MSSQL related Description: Returns a "The document contained no data" error while accessing MS-SQL 7.0 Here is a shorter script that produces the same results: <? print("<HTML>\n<HEAD>\n<TITLE>\nPHP Helpdesk v0.0.1 Alpha\n</TITLE></HEAD>\n<BODY>\n"); $MSsqlLink = mssql_connect("Server","User","password") or DIE("SERVER FAILED TO RESPOND."); mssql_select_db("Database") or DIE("Database unavailable"); $Result = mssql_query("select tbl_WO_Entry.WO_nos,tbl_WO_Entry.UserName,tbl_WO_Entry.Status,tbl_WO_Entry.Priority,tbl_WO_Description.Problem_description from tbl_WO_Entry, tbl_WO_Description where ((tbl_WO_Entry.WO_nos = tbl_WO_Description.WO_nos) and (not (tbl_WO_Entry.status = 3 and tbl_WO_Entry.status = 4 and tbl_WO_Entry.status = 5))) order by tbl_WO_Entry.Priority,tbl_WO_Entry.WO_nos",$MSsqlLink); print("<TABLE ALIGN=CENTER COLS=5 CELLSPACING=0 BORDER=1 CELLPADDING=0 WIDTH=\"100%\">\n"); print("<TR>\n<TH WIDTH=\"5%\">WO#</TH>\n<TH WIDTH=\"10%\">User</TH>\n<TH WIDTH=\"5%\">Priority</TH>\n"); print("<TH WIDTH=\"60%\" ABBR>Description</TH>\n<TH WIDTH=\"10%\">Status</TH>\n</TR>\n"); $WORS = mssql_fetch_row($Result); print("<TR>\n<TD>$WORS[0]</TD>\n<TD>$WORS[1]</TD>\n<TD>$WORS[3]</TD>\n"); print("<TD>$WORS[4]</TD>\n<TD>$WORS[2]</TD>\n</TR>\n"); $WORS = mssql_fetch_row($Result); print("<TR>\n<TD>$WORS[0]</TD>\n<TD>$WORS[1]</TD>\n<TD>$WORS[3]</TD>\n"); print("<TD>$WORS[4]</TD>\n<TD>$WORS[2]</TD>\n</TR>\n"); $WORS = mssql_fetch_row($Result); print("<TR>\n<TD>$WORS[0]</TD>\n<TD>$WORS[1]</TD>\n<TD>$WORS[3]</TD>\n"); print("<TD>$WORS[4]</TD>\n<TD>$WORS[2]</TD>\n</TR>\n"); $WORS = mssql_fetch_row($Result); print("<TR>\n<TD>$WORS[0]</TD>\n<TD>$WORS[1]</TD>\n<TD>$WORS[3]</TD>\n"); print("<TD>$WORS[4]</TD>\n<TD>$WORS[2]</TD>\n</TR>\n"); print("</TABLE>\n"); mssql_close(); print("\n</BODY>\n</HTML>"); ?> Full Bug description available at: http://bugs.php.net/?id=6065