Hi Guys - I know that this is NOT a PHP forum, but I feel that some of
you use AMFPHP extensively, so I thought I'd give it a try.
I have just started to use AMFPHP as a backend for Flex2 projects.
When I connect to MySQL databases it is just perfect and fast - great.
Now I need to connect to a MS SQL Server 2000, it is a sql server used
by a MS Dynamics Navision installation.
The data stored are stored in a non UTF-8 charset and database names
include stupid names like [DK idé-nyt as$Insertion] where the sql
driver stumbles on the ´
When I use ADODB in PHP and json_encode the result, it works fine.
When I try to use the following code in AMFPHP, the service browser
fails with a Flex error.
What can I do, to make this work ?
I'm quite new to PHP also, so please be gentle if you can :-)
Thanks for any help you might provide.
Thanks and sorry for this semi non-flex question
Mark
/**** Begin PHP snippet ***/
include_once('adodb5/adodb.inc.php');
$db =& ADONewConnection('odbc_mssql');
$DB->charSet = 'utf-8';
$dsn = "Driver={SQL Server};Server=10.45.2.33;Database=BRM;";
$db->Connect($dsn,'pfs','youbet');
$db->SetFetchMode(ADODB_FETCH_ASSOC);
class ars {
function ars () {
/**
Constructor function
*/
}
/**
* Function getCustomer returnsinfo about cutomer
* select top 100 * from [DK idé-nyt as$Customer];
* @access remote
**/
function getCustomer ()
{
global $db;
$arr = array();
$sql = "select top 100 * from [DK idé-nyt as$Customer];";
$rs = &$db->Execute($sql);
return $rs;
}
}
