Connect('127.0.0.1','adodb','natsoft','northwind') or die('Fail'); $conn->debug =1; $query = 'select * from products'; $conn->SetFetchMode(ADODB_FETCH_ASSOC); $rs = $conn->Execute($query); echo "
";
while( !$rs->EOF ) {
	$output[] = $rs->fields;
	var_dump($rs->fields);
	$rs->MoveNext();
	print "

"; } die(); $p = $conn->Prepare('insert into products (productname,unitprice,dcreated) values (?,?,?)'); echo "

";
print_r($p);

$conn->debug=1;
$conn->Execute($p,array('John'.rand(),33.3,$conn->DBDate(time())));

$p = $conn->Prepare('select * from products where productname like ?');
$arr = $conn->getarray($p,array('V%'));
print_r($arr);
die();

//$conn = ADONewConnection("mssql");
//$conn->Connect('mangrove','sa','natsoft','ai');

//$conn->Connect('mangrove','sa','natsoft','ai');
$conn->debug=1;
$conn->Execute('delete from blobtest');

$conn->Execute('insert into blobtest (id) values(1)');
$conn->UpdateBlobFile('blobtest','b1','../cute_icons_for_site/adodb.gif','id=1');
$rs = $conn->Execute('select b1 from blobtest where id=1');

$output = "c:\\temp\\test_out-".date('H-i-s').".gif";
print "Saving file $output, size=".strlen($rs->fields[0])."

"; $fd = fopen($output, "wb"); fwrite($fd, $rs->fields[0]); fclose($fd); print " View Image"; //$rs = $conn->Execute('SELECT id,SUBSTRING(b1, 1, 10) FROM blobtest'); //rs2html($rs);