Issue
The SELECT statement returns an empty string. Actualy I can count the records but can't see the values.
The INSERT statement works just fine
Information
» Linux RedHat 7.3
» Php 4.12
» MsSql server 7.0 on Win 2k
Php library contains sybase_ct.so, odbc.so and other libraries
PHP Code
<?php
require("./adodb/adodb.inc.php");
require("./Connections/sphinx1conn.php");
?><?php
$Recordset1=$sphinx1conn->Execute("SELECT * FROM dbo.trainer") or DIE($sphinx1conn->ErrorMsg());
$Recordset1_numRows=0;
$Recordset1__totalRows=$Recordset1->RecordCount();
?>
In the body I have:
<?php echo $Recordset1->Fields("trainer")?>
Coclusion:
Microsoft SQL server sucks, even working with clasic .asp on win platform. Especially with text field.
But when you are migrating from one platform to another you need to find an intermediate solution in the migration period
10x
