success with firebird from CLI only

[mariuz]

I have downloaded the latest adodb from sf.net

http://dfn.dl.sourceforge.net/sourceforge/adodb/adodb509a.tgz

and did an overwrite for the version imported in svn
in config.php added an firebird db


c['db-config1'] = array
(
'host' => 'localhost',
'type' => 'firebird',
'username' => 'sysdba',
'password' => 'masterkey',
'database' => '/var/lib/firebird/2.1/data/employee.fdb'
);


in ajax.query.inc.php i have adde two variables to test it from
command line
$_POST['sql'] = "SELECT * FROM EMPLOYEE ";
$_POST['c']="db-config1";
also added debug mode after connection is made

$db = ADONewConnection($dsn);
$db->debug = true;

php ajax.query.inc.php
-----<hr>
(firebird): SELECT a.EMP_NO, a.FIRST_NAME, a.LAST_NAME, a.PHONE_EXT,
a.HIRE_DATE, a.DEPT_NO, a.JOB_CODE, a.JOB_GRADE, a.JOB_COUNTRY,
a.SALARY, a.FULL_NAME FROM EMPLOYEE a

-----<hr>
<TABLE COLS=11 BORDER='1' WIDTH='98%'><tr>

<TH>EMP_NO</TH><TH>FIRST_NAME</TH><TH>LAST_NAME</TH><TH>PHONE_EXT</
TH><TH>HIRE_DATE</TH><TH>DEPT_NO</TH><TH>JOB_CODE</TH><TH>JOB_GRADE</
TH><TH>JOB_COUNTRY</TH><TH>SALARY</TH><TH>FULL_NAME</TH>
</tr>

<TR valign=top>
<TD align=right>2</TD>
<TD>Robert</TD>
<TD>Nelson</TD>
<TD>250</TD>
<TD>Wed 28, Dec 1988, 00:00:00</TD>
<TD>600</TD>
<TD>VP</TD>
<TD align=right>2</TD>
<TD>USA</TD>
<TD align=right>105900</TD>
<TD>Nelson, Robert</TD>
</TR>

[feketegy]

I will update the script, thanks for the help...

[mimmo]

To have success on AJAX, you need to configure also assets/js/qt.js
In the very first few lines baseUrl need to be configured to match
your installation directory.

[marius adrian popa]

Ok thanks man :) , we can make an small article with it
And i guess we can join the project

>
> >
>

[feketegy]

You are more than welcome to join this project, because I don't really
have the necessary time to work on the script and I sure need some
help!

On Jul 22, 2:17 pm, marius adrian popa <map...@gmail.com> wrote:

[marius adrian popa]

ok add please mapopa user if you want
>>
>>
> >
>