| 1 |
Content-type: text/html
|
| 2 |
X-Powered-By: PHP/4.3.8
|
| 3 |
|
| 4 |
<html>
|
| 5 |
<title>ADODB Testing</title>
|
| 6 |
<body bgcolor=white>
|
| 7 |
<H1>ADODB Test</H1>
|
| 8 |
|
| 9 |
This script tests the following databases: Interbase, Oracle, Visual FoxPro, Microsoft Access (ODBC and ADO), MySQL, MSSQL (ODBC, native, ADO).
|
| 10 |
There is also support for Sybase, PostgreSQL.</p>
|
| 11 |
For the latest version of ADODB, visit <a href=http://adodb.sourceforge.net/>adodb.sourceforge.net</a>.</p>
|
| 12 |
|
| 13 |
Test <a href=test4.php>GetInsertSQL/GetUpdateSQL</a>
|
| 14 |
<a href=testsessions.php>Sessions</a>
|
| 15 |
<a href=testpaging.php>Paging</a>
|
| 16 |
<a href=test-perf.php>Perf Monitor</a><p>
|
| 17 |
|
| 18 |
<table><tr valign=top><td>
|
| 19 |
<form method=get>
|
| 20 |
<input type=checkbox name="testaccess" value=1 > <b>Access</b><br>
|
| 21 |
<input type=checkbox name="testibase" value=1 > <b>Interbase</b><br>
|
| 22 |
<input type=checkbox name="testmssql" value=1 > <b>MSSQL</b><br>
|
| 23 |
<input type=checkbox name="testmysql" value=1 > <b>MySQL</b><br>
|
| 24 |
<input type=checkbox name="testmysqlodbc" value=1 > <b>MySQL ODBC</b><br>
|
| 25 |
<input type=checkbox name="testmysqli" value=1 > <b>MySQLi</b>
|
| 26 |
<br>
|
| 27 |
<td><input type=checkbox name="testsqlite" value=1 > <b>SQLite</b><br>
|
| 28 |
<input type=checkbox name="testproxy" value=1 > <b>MySQL Proxy</b><br>
|
| 29 |
<input type=checkbox name="testoracle" value=1 checked> <b>Oracle (oci8)</b> <br>
|
| 30 |
<input type=checkbox name="testpostgres" value=1 > <b>PostgreSQL</b><br>
|
| 31 |
<input type=checkbox name="testpgodbc" value=1 > <b>PostgreSQL ODBC</b><br>
|
| 32 |
<td>
|
| 33 |
<input type=checkbox name="testpdopgsql" value=1 > <b>PgSQL PDO</b><br>
|
| 34 |
<input type=checkbox name="testpdomysql" value=1 > <b>MySQL PDO</b><br>
|
| 35 |
<input type=checkbox name="testpdosqlite" value=1 > <b>SQLite PDO</b><br>
|
| 36 |
<input type=checkbox name="testpdoaccess" value=1 > <b>Access PDO</b><br>
|
| 37 |
|
| 38 |
<td><input type=checkbox name="testdb2" value=1 > DB2<br>
|
| 39 |
<input type=checkbox name="testvfp" value=1 > VFP+ODBTP<br>
|
| 40 |
<input type=checkbox name="testado" value=1 > ADO (for mssql and access)<br>
|
| 41 |
<input type=checkbox name="nocountrecs" value=1 > $ADODB_COUNTRECS=false<br>
|
| 42 |
<input type=checkbox name="nolog" value=1 > No SQL Logging<br>
|
| 43 |
<input type=checkbox name="time" value=1 > ADOdb time test
|
| 44 |
</table>
|
| 45 |
<input type=submit>
|
| 46 |
</form>
|
| 47 |
|
| 48 |
<h1>Connecting oci8po...</h1> <form method=GET>
|
| 49 |
</p>
|
| 50 |
<table width=100% ><tr><td bgcolor=beige> </td></tr></table>
|
| 51 |
</p>
|
| 52 |
<h3>SQL Logging enabled</h3><h3>ADODB Version: V4.81 3 May 2006 (c) 2000-2006 John Lim (jlim#natsoft.com.my). All rights reserved. Released BSD & LGPL. Host: <i>sherkhan</i> Database: <i></i> PHP: 4.3.8 </h3>Array
|
| 53 |
(
|
| 54 |
[compat] => 9.2.0.0.0
|
| 55 |
[description] => Oracle9i Release 9.2.0.1.0 - Production
|
| 56 |
JServer Release 9.2.0.1.0 - Production
|
| 57 |
[version] => 9.2.0.1.0
|
| 58 |
)
|
| 59 |
<br><br>db->Time: 19-05-2005 11:44:42<br>Date=2002-04-07<br><i>date1</i> (1969-02-20) = TO_DATE('1969-02-20','YYYY-MM-DD')<br><i>date1</i> (1999-02-20) = TO_DATE('1999-02-20','YYYY-MM-DD')<br><i>date1.1</i> 1999 = TO_DATE('2005-05-19','YYYY-MM-DD')<br><i>date2</i> (1970-1-2) = TO_DATE('1970-01-02','YYYY-MM-DD')<p><i>ts1</i> (1999-02-20 13:40:50) = TO_DATE('1999-02-20, 01:40:50 AM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts1.1</i> (1999-02-20 13:40:00) = TO_DATE('1999-02-20, 01:04:00 PM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts2</i> (1999-02-20) = TO_DATE('1999-02-20, 12:00:00 AM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts3</i> (1970-1-2 +/- timezone) = TO_DATE('1970-01-02, 08:00:00 AM','RRRR-MM-DD, HH:MI:SS AM')<br> Fractional TS (1999-2-20 13:40:50.91): TO_DATE('1999-02-20, 01:40:50 PM','RRRR-MM-DD, HH:MI:SS AM')<br>unixdate</i> 1999-02-20 = 1999-02-20<p><br><i>ts4</i> =61<br><i>ts5</i> =TO_DATE('2004-01-10, 09:21:23 AM','RRRR-MM-DD, HH:MI:SS AM')<br><i>ts6</i> =2004-01-10 09:21:23<br><i>ts7</i> =TO_DATE('2004-01-10, 09:21:23 AM','RRRR-MM-DD, HH:MI:SS AM')<p>Test select on empty table, FetchField when EOF, and GetInsertSQL</p><p>Testing Commit: OK</p><p>Testing Rollback: OK</p><p>Testing MetaDatabases()</p>AAArray
|
| 60 |
(
|
| 61 |
[0] => ANONYMOUS
|
| 62 |
[1] => CTXSYS
|
| 63 |
[2] => DEV
|
| 64 |
[3] => HR
|
| 65 |
[4] => IOU
|
| 66 |
[5] => JURIS10
|
| 67 |
[6] => JURIS9
|
| 68 |
[7] => MDSYS
|
| 69 |
[8] => ODB
|
| 70 |
[9] => ODB2
|
| 71 |
[10] => ODM
|
| 72 |
[11] => ODM_MTR
|
| 73 |
[12] => OE
|
| 74 |
[13] => OLAPSYS
|
| 75 |
[14] => ORDPLUGINS
|
| 76 |
[15] => ORDSYS
|
| 77 |
[16] => PM
|
| 78 |
[17] => QS
|
| 79 |
[18] => QS_ADM
|
| 80 |
[19] => QS_CB
|
| 81 |
[20] => QS_CBADM
|
| 82 |
[21] => QS_CS
|
| 83 |
[22] => QS_ES
|
| 84 |
[23] => QS_OS
|
| 85 |
[24] => QS_WS
|
| 86 |
[25] => RMAN
|
| 87 |
[26] => SCOTT
|
| 88 |
[27] => SH
|
| 89 |
[28] => SONY
|
| 90 |
[29] => TOAD
|
| 91 |
[30] => WKPROXY
|
| 92 |
[31] => WKSYS
|
| 93 |
[32] => WMSYS
|
| 94 |
[33] => XDB
|
| 95 |
)
|
| 96 |
<p>Testing MetaTables() and MetaColumns()</p>AAArray of tables and views: (abalone2) (abalone2_tree_jl1) (abalone_tree) (address) (adodb_logsql) (adoxyz) (alertrx) (atest) (billdet) (billhdr) (binlist) (cache_jorg_121) (cache_jorg_127) (contact) (create$java$lob$table) (diary) (diary2) (dlagent) (dlagentactivity) (dlagentcampaign) (dlagentcampaignvw) (dlagentcurrentstatus) (dlagenthistory) (dlagentshift) (dlagentstats) (dlagent_collection) (dlcallhistory) (dlcampaign) (dlcampaignactivity) (dlcampaignset) (dlcampaignshift) (dlcampaign_collection) (dlkbagentstatus) (dlkbarea) (dlkbgroup) (dlkbliststatus) (dlkbmedia) (dlkboutcome) (dlkbshift) (dlkbskill) (dlkbstagevw) (dlkbstatus) (dlkbtype) (dlkbvw) (dllist) (dllisterror) (dllistsource) (dllisttemp) (dlmessage) (dlteam) (dltimedcampaignactivity) (dltrafficreport) (employee) (emp_pay_hist) (emp_perf_hist) (emp_perf_plan) (endorser) (exchange) (fclsdatextra) (fclsfacreln) (fclskb) (fclskbcatvals) (fclskbexpiry) (fclskbfacreln) (fclskbprop) (fclskbstage) (fclskbstep) (fclskbstgroup) (fclssec) (fclssecrole) (fclsstepdate) (germall) (germall_cluster) (germall_range) (germall_rules) (germall_tree) (glass) (glass_tree) (ivr) (ivrcall) (ivrcca) (ivrevents) (ivrservice) (ivr_by_hour) (ivr_by_hours) (ivr_cat) (ivr_defaults) (ivr_demo) (ivr_dim) (ivr_map) (ivr_map_hours) (ivr_rp) (ivr_tmp_demo) (java$class$md5$table) (java$options) (jcampaign) (jcasemast) (jclnt) (jclntbrch) (jclntdept) (jclntdiv) (jcontact) (jcustomer) (jdefaults) (jdiary) (jfacility) (jfirm) (jfirmbrch) (jfirmdiv) (jmail) (jmail_x) (job_market_data) (jopportunity) (jorg) (jstate) (jstepprint) (jsurvey) (jtask) (jtaskitem) (kb) (kbactivity) (kbarea) (kbcatvals) (kbcountry) (kbcurrency) (kbdomain_juris10) (kbdomain_tiger2) (kbjob) (kbjobrating) (kblang) (kbmedia) (kbproductivity) (kbq) (kbqset) (kbqstatus) (kbregion) (kbrole) (kbskill) (kbstage) (kbstatus) (kbstep) (kbsteptype) (kbsubdomain) (kbworkarea) (kbworknode) (kutu_testtable) (lens_columns) (lens_groups) (lens_log) (lens_logurl) (lens_perms) (lens_rank) (lens_users) (lens_users_collection) (lens_users_x) (mcc) (myarn) (mycard) (oldkbstage) (oldkbstep) (old_ivr_by_hour) (pay_budget_hist) (pay_budget_plan) (photos) (phplens) (phplens_lock) (plan_table) (products) (qhist) (qlog) (qsetreport) (qtest) (qtest_len) (q_1005) (q_1006) (q_1008) (q_1010) (q_1011) (q_1016) (q_1017) (q_1018) (q_1019) (q_1020) (q_1021) (q_1022) (q_1023) (q_1024) (reseller) (review_period) (role) (ruledet) (splist) (tempname) (tennis) (tennis_tree) (toad_plan_table) (transact) (transact_040321) (transalert) (transalert_22) (transrule) (vt) (vwaddress) (vwcasecontact) (vwcaserolefacreln) (vwdiary_diary2) (vwfclsfacreln_contact) (vwfclssec_fclssecrole) (vwreview_search) (vwstepdatextra) (vwtransact) (vwtransalert) (xaddress) (xcase) (xcasevvv) (xcontact) (xcurstep) (xdiary) (xfirm) (xmonitor) (xrole) (xsummstatustmp) (xx) </p>AAArray of views: (address) (contact) (dlagentcampaignvw) (dlkbstagevw) (dlkbvw) (ivr) (ivr_by_hours) (ivr_map_hours) (products) (role) (vt) (vwaddress) (vwcasecontact) (vwcaserolefacreln) (vwdiary_diary2) (vwfclsfacreln_contact) (vwfclssec_fclssecrole) (vwreview_search) (vwstepdatextra) (vwtransact) (vwtransalert) (xcasevvv) (xdiary) (xfirm) </p>AAArray of ado%: (adoxyz) </p>AAArray of tables: (abalone2) (abalone2_tree_jl1) (abalone_tree) (adodb_logsql) (adoxyz) (alertrx) (atest) (billdet) (billhdr) (binlist) (cache_jorg_121) (cache_jorg_127) (create$java$lob$table) (diary) (diary2) (dlagent) (dlagentactivity) (dlagentcampaign) (dlagentcurrentstatus) (dlagenthistory) (dlagentshift) (dlagentstats) (dlagent_collection) (dlcallhistory) (dlcampaign) (dlcampaignactivity) (dlcampaignset) (dlcampaignshift) (dlcampaign_collection) (dlkbagentstatus) (dlkbarea) (dlkbgroup) (dlkbliststatus) (dlkbmedia) (dlkboutcome) (dlkbshift) (dlkbskill) (dlkbstatus) (dlkbtype) (dllist) (dllisterror) (dllistsource) (dllisttemp) (dlmessage) (dlteam) (dltimedcampaignactivity) (dltrafficreport) (employee) (emp_pay_hist) (emp_perf_hist) (emp_perf_plan) (endorser) (exchange) (fclsdatextra) (fclsfacreln) (fclskb) (fclskbcatvals) (fclskbexpiry) (fclskbfacreln) (fclskbprop) (fclskbstage) (fclskbstep) (fclskbstgroup) (fclssec) (fclssecrole) (fclsstepdate) (germall) (germall_cluster) (germall_range) (germall_rules) (germall_tree) (glass) (glass_tree) (ivrcall) (ivrcca) (ivrevents) (ivrservice) (ivr_by_hour) (ivr_cat) (ivr_defaults) (ivr_demo) (ivr_dim) (ivr_map) (ivr_rp) (ivr_tmp_demo) (java$class$md5$table) (java$options) (jcampaign) (jcasemast) (jclnt) (jclntbrch) (jclntdept) (jclntdiv) (jcontact) (jcustomer) (jdefaults) (jdiary) (jfacility) (jfirm) (jfirmbrch) (jfirmdiv) (jmail) (jmail_x) (job_market_data) (jopportunity) (jorg) (jstate) (jstepprint) (jsurvey) (jtask) (jtaskitem) (kb) (kbactivity) (kbarea) (kbcatvals) (kbcountry) (kbcurrency) (kbdomain_juris10) (kbdomain_tiger2) (kbjob) (kbjobrating) (kblang) (kbmedia) (kbproductivity) (kbq) (kbqset) (kbqstatus) (kbregion) (kbrole) (kbskill) (kbstage) (kbstatus) (kbstep) (kbsteptype) (kbsubdomain) (kbworkarea) (kbworknode) (kutu_testtable) (lens_columns) (lens_groups) (lens_log) (lens_logurl) (lens_perms) (lens_rank) (lens_users) (lens_users_collection) (lens_users_x) (mcc) (myarn) (mycard) (oldkbstage) (oldkbstep) (old_ivr_by_hour) (pay_budget_hist) (pay_budget_plan) (photos) (phplens) (phplens_lock) (plan_table) (qhist) (qlog) (qsetreport) (qtest) (qtest_len) (q_1005) (q_1006) (q_1008) (q_1010) (q_1011) (q_1016) (q_1017) (q_1018) (q_1019) (q_1020) (q_1021) (q_1022) (q_1023) (q_1024) (reseller) (review_period) (ruledet) (splist) (tempname) (tennis) (tennis_tree) (toad_plan_table) (transact) (transact_040321) (transalert) (transalert_22) (transrule) (xaddress) (xcase) (xcontact) (xcurstep) (xmonitor) (xrole) (xsummstatustmp) (xx) </p>-----
|
| 97 |
(oci8po): select lower(cname), coltype, width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='ADOXYZ' order by colno
|
| 98 |
-----
|
| 99 |
AA<p>Columns of ADOXYZ: <font size=1><br>adofieldobject Object
|
| 100 |
(
|
| 101 |
[name] => firstname
|
| 102 |
[max_length] => 24
|
| 103 |
[type] => VARCHAR2
|
| 104 |
[scale] =>
|
| 105 |
[not_null] =>
|
| 106 |
[binary] =>
|
| 107 |
[default_value] =>
|
| 108 |
)
|
| 109 |
<br>adofieldobject Object
|
| 110 |
(
|
| 111 |
[name] => lastname
|
| 112 |
[max_length] => 24
|
| 113 |
[type] => VARCHAR2
|
| 114 |
[scale] =>
|
| 115 |
[not_null] =>
|
| 116 |
[binary] =>
|
| 117 |
[default_value] =>
|
| 118 |
)
|
| 119 |
<br>adofieldobject Object
|
| 120 |
(
|
| 121 |
[name] => created
|
| 122 |
[max_length] => 7
|
| 123 |
[type] => DATE
|
| 124 |
[scale] =>
|
| 125 |
[not_null] =>
|
| 126 |
[binary] =>
|
| 127 |
[default_value] =>
|
| 128 |
)
|
| 129 |
<br></font><p>Testing MetaIndexes</p>-----
|
| 130 |
(oci8po): SELECT * FROM ALL_CONSTRAINTS WHERE UPPER(TABLE_NAME)='ADOXYZ' AND CONSTRAINT_TYPE='P'
|
| 131 |
-----
|
| 132 |
AA<b>MetaIndexes not supported</b></p><p>Testing MetaPrimaryKeys</p>-----
|
| 133 |
(oci8po):
|
| 134 |
SELECT /*+ RULE */ distinct b.column_name
|
| 135 |
FROM USER_CONSTRAINTS a
|
| 136 |
, USER_CONS_COLUMNS b
|
| 137 |
WHERE ( UPPER(b.table_name) = ('ADOXYZ'))
|
| 138 |
AND (UPPER(a.table_name) = ('ADOXYZ') and a.constraint_type = 'P')
|
| 139 |
|
| 140 |
AND (a.constraint_name = b.constraint_name)
|
| 141 |
-----
|
| 142 |
bool(false)
|
| 143 |
-----
|
| 144 |
(oci8po): delete from ADOXYZ
|
| 145 |
-----
|
| 146 |
InParameter($stmt, $php_var='99', $name='id', $maxLen=4000, $type=false);
|
| 147 |
Bind: name = id
|
| 148 |
InParameter($stmt, $php_var='123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890', $name='xx', $maxLen=-1, $type=113);
|
| 149 |
Bind: name = xx
|
| 150 |
Bind: descriptor has been allocated, var (xx) binded
|
| 151 |
Bind: LOB has been written to temp
|
| 152 |
-----
|
| 153 |
(oci8po): INSERT INTO photos ( ID, photo) VALUES ( :id, empty_blob() ) RETURNING photo INTO :xx
|
| 154 |
-----
|
| 155 |
IN LOB: LOB has been saved.
|
| 156 |
Smart Commit occurred
|
| 157 |
-----
|
| 158 |
(oci8po): select photo from photos where id=99
|
| 159 |
-----
|
| 160 |
<br>---123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890<h4>Testing Blob: size=5010</h4>-----
|
| 161 |
(oci8po): UPDATE photos set photo=EMPTY_BLOB() WHERE id=1 RETURNING photo INTO ?
|
| 162 |
-----
|
| 163 |
name=:blob var=Object len=-1 type=113<br>-----
|
| 164 |
(oci8po): select photo from photos where id=1
|
| 165 |
-----
|
| 166 |
<h4>Testing Clob: size=5010</h4>-----
|
| 167 |
(oci8po): UPDATE photos set descclob=EMPTY_CLOB() WHERE id=1 RETURNING descclob INTO ?
|
| 168 |
-----
|
| 169 |
name=:blob var=Object len=-1 type=112<br>-----
|
| 170 |
(oci8po): select descclob from photos where id=1
|
| 171 |
-----
|
| 172 |
<h4>Testing Foreign Keys</h4>-----
|
| 173 |
(oci8po): select constraint_name, r_owner, r_constraint_name
|
| 174 |
from user_constraints
|
| 175 |
where constraint_type = 'R' and table_name = 'EMP' and owner='JURIS10'
|
| 176 |
-----
|
| 177 |
AA<b>Bad MetaForeignKeys</b><br><h4>Testing Cursor Variables</h4>InParameter($stmt, $php_var='', $name='zz', $maxLen=-1, $type=116);
|
| 178 |
-----
|
| 179 |
(oci8po): BEGIN adodb.open_tab(:zz, 'A%'); END;
|
| 180 |
-----
|
| 181 |
-----
|
| 182 |
(oci8po): SELECT count(*) FROM tab where tname like 'A%'
|
| 183 |
-----
|
| 184 |
Test 1 RowCount: OK<p><h4>Testing Stored Procedures for oci8</h4>InParameter($stmt, $php_var='Malaysia', $name='a1', $maxLen=4000, $type=false);
|
| 185 |
Bind: name = a1
|
| 186 |
OutParameter($stmt, $php_var='', $name='a2', $maxLen=4000, $type=false);
|
| 187 |
Bind: name = a2
|
| 188 |
-----
|
| 189 |
(oci8po): BEGIN adodb.data_out(:a1, :a2); END;
|
| 190 |
-----
|
| 191 |
OK: a2=Cinta Hati Malaysia<p>InParameter($stmt, $php_var='A%', $name='tablename', $maxLen=4000, $type=false);
|
| 192 |
Bind: name = tablename
|
| 193 |
-----
|
| 194 |
(oci8po): select * from tab where tname like :tablename
|
| 195 |
-----
|
| 196 |
<TABLE COLS=3 BORDER='1' WIDTH='98%'><tr>
|
| 197 |
|
| 198 |
<TH>tname</TH><TH>tabtype</TH><TH>clusterid</TH>
|
| 199 |
</tr>
|
| 200 |
|
| 201 |
<TR valign=top>
|
| 202 |
<TD>ABALONE</TD>
|
| 203 |
<TD>TABLE</TD>
|
| 204 |
<TD align=right> </TD>
|
| 205 |
</TR>
|
| 206 |
|
| 207 |
<TR valign=top>
|
| 208 |
<TD>ABALONE2</TD>
|
| 209 |
<TD>TABLE</TD>
|
| 210 |
<TD align=right> </TD>
|
| 211 |
</TR>
|
| 212 |
|
| 213 |
<TR valign=top>
|
| 214 |
<TD>ABALONE2_TREE_JL1</TD>
|
| 215 |
<TD>TABLE</TD>
|
| 216 |
<TD align=right> </TD>
|
| 217 |
</TR>
|
| 218 |
|
| 219 |
<TR valign=top>
|
| 220 |
<TD>ABALONE_TREE</TD>
|
| 221 |
<TD>TABLE</TD>
|
| 222 |
<TD align=right> </TD>
|
| 223 |
</TR>
|
| 224 |
|
| 225 |
<TR valign=top>
|
| 226 |
<TD>ADDRESS</TD>
|
| 227 |
<TD>VIEW</TD>
|
| 228 |
<TD align=right> </TD>
|
| 229 |
</TR>
|
| 230 |
|
| 231 |
<TR valign=top>
|
| 232 |
<TD>ADODB_LOGSQL</TD>
|
| 233 |
<TD>TABLE</TD>
|
| 234 |
<TD align=right> </TD>
|
| 235 |
</TR>
|
| 236 |
|
| 237 |
<TR valign=top>
|
| 238 |
<TD>ADOXYZ</TD>
|
| 239 |
<TD>TABLE</TD>
|
| 240 |
<TD align=right> </TD>
|
| 241 |
</TR>
|
| 242 |
|
| 243 |
<TR valign=top>
|
| 244 |
<TD>ALERTRX</TD>
|
| 245 |
<TD>TABLE</TD>
|
| 246 |
<TD align=right> </TD>
|
| 247 |
</TR>
|
| 248 |
|
| 249 |
<TR valign=top>
|
| 250 |
<TD>ATEST</TD>
|
| 251 |
<TD>TABLE</TD>
|
| 252 |
<TD align=right> </TD>
|
| 253 |
</TR>
|
| 254 |
|
| 255 |
</TABLE>
|
| 256 |
|
| 257 |
InParameter($stmt, $php_var='Malaysia', $name='a1', $maxLen=4000, $type=false);
|
| 258 |
Bind: name = a1
|
| 259 |
-----
|
| 260 |
(oci8po): begin adodb.data_in(:a1); end;
|
| 261 |
-----
|
| 262 |
<p>Testing Bulk Insert of 3 rows</p>-----
|
| 263 |
(oci8po): insert into ADOXYZ (id, firstname, lastname) values (:0, :1, :2)
|
| 264 |
-----
|
| 265 |
-----
|
| 266 |
(oci8po): insert into ADOXYZ (id, firstname, lastname) values (:0, :1, :2)
|
| 267 |
-----
|
| 268 |
-----
|
| 269 |
(oci8po): insert into ADOXYZ (id, firstname, lastname) values (:0, :1, :2)
|
| 270 |
-----
|
| 271 |
Smart Commit occurred
|
| 272 |
-----
|
| 273 |
(oci8po): select * from ADOXYZ order by id
|
| 274 |
-----
|
| 275 |
<TABLE COLS=4 BORDER='1' WIDTH='98%'><tr>
|
| 276 |
|
| 277 |
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH>
|
| 278 |
</tr>
|
| 279 |
|
| 280 |
<TR valign=top>
|
| 281 |
<TD align=right>1 </TD>
|
| 282 |
<TD>Caroline</TD>
|
| 283 |
<TD>Miranda</TD>
|
| 284 |
<TD> </TD>
|
| 285 |
<TD> </TD>
|
| 286 |
</TR>
|
| 287 |
|
| 288 |
<TR valign=top>
|
| 289 |
<TD align=right>2 </TD>
|
| 290 |
<TD>John</TD>
|
| 291 |
<TD>Lim</TD>
|
| 292 |
<TD> </TD>
|
| 293 |
<TD> </TD>
|
| 294 |
</TR>
|
| 295 |
|
| 296 |
<TR valign=top>
|
| 297 |
<TD align=right>3 </TD>
|
| 298 |
<TD>Wai Hun</TD>
|
| 299 |
<TD>See</TD>
|
| 300 |
<TD> </TD>
|
| 301 |
<TD> </TD>
|
| 302 |
</TR>
|
| 303 |
|
| 304 |
</TABLE>
|
| 305 |
|
| 306 |
-----
|
| 307 |
(oci8po): delete from ADOXYZ
|
| 308 |
-----
|
| 309 |
<p>Inserting 50 rows</p>-----
|
| 310 |
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (0*10+0, ?, ?, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
|
| 311 |
-----
|
| 312 |
-----
|
| 313 |
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (1*10+0, :0, :1, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
|
| 314 |
-----
|
| 315 |
-----
|
| 316 |
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (2*10+0, ?, ?, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
|
| 317 |
-----
|
| 318 |
-----
|
| 319 |
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (3*10+0, :0, :1, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
|
| 320 |
-----
|
| 321 |
-----
|
| 322 |
(oci8po): insert into ADOXYZ (id, firstname, lastname, created) values (4*10+0, ?, ?, TO_DATE('2005-05-19', 'YYYY-MM-DD'))
|
| 323 |
-----
|
| 324 |
-----
|
| 325 |
(oci8po): select count(*) from ADOXYZ
|
| 326 |
-----
|
| 327 |
-----
|
| 328 |
(oci8po): update ADOXYZ set id=id+1
|
| 329 |
-----
|
| 330 |
<p>Affected_Rows() passed</p>-----
|
| 331 |
(oci8po): select id from ADOXYZ
|
| 332 |
where id=? and created>=?
|
| 333 |
-----
|
| 334 |
<br>Bind date/integer passedBB<p><b>RecordCount returns 49</b></p><p><b>PO_RecordCount returns wrong value: 49</b></p><b><p>The fields columns <i>cannot</i> be indexed by column name.</p></b><br>Array
|
| 335 |
(
|
| 336 |
[ID] => 2
|
| 337 |
[FIRSTNAME] => John
|
| 338 |
[LASTNAME] => Lim
|
| 339 |
[CREATED] => 2005-05-19
|
| 340 |
[ABS(MOD(DBMS_RANDOM.RANDOM,10000001)/10000000)] => .0233416
|
| 341 |
)
|
| 342 |
<TABLE COLS=5 BORDER='1' WIDTH='98%'><tr>
|
| 343 |
|
| 344 |
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH><TH>abs(mod(dbms_random.random,10000001)/10000000)</TH>
|
| 345 |
</tr>
|
| 346 |
|
| 347 |
<TR valign=top>
|
| 348 |
<TD align=right>2 </TD>
|
| 349 |
<TD>John</TD>
|
| 350 |
<TD>Lim</TD>
|
| 351 |
<TD>Thu 19, May 2005 </TD>
|
| 352 |
<TD align=right>.0233416 </TD>
|
| 353 |
</TR>
|
| 354 |
|
| 355 |
<TR valign=top>
|
| 356 |
<TD align=right>3 </TD>
|
| 357 |
<TD>Mary</TD>
|
| 358 |
<TD>Lamb</TD>
|
| 359 |
<TD>Thu 19, May 2005 </TD>
|
| 360 |
<TD align=right>.1240054 </TD>
|
| 361 |
</TR>
|
| 362 |
|
| 363 |
<TR valign=top>
|
| 364 |
<TD align=right>4 </TD>
|
| 365 |
<TD>George</TD>
|
| 366 |
<TD>Washington</TD>
|
| 367 |
<TD>Thu 19, May 2005 </TD>
|
| 368 |
<TD align=right>.590735 </TD>
|
| 369 |
</TR>
|
| 370 |
|
| 371 |
<TR valign=top>
|
| 372 |
<TD align=right>5 </TD>
|
| 373 |
<TD>Mr. Alan</TD>
|
| 374 |
<TD>Tam</TD>
|
| 375 |
<TD>Thu 19, May 2005 </TD>
|
| 376 |
<TD align=right>.6431706 </TD>
|
| 377 |
</TR>
|
| 378 |
|
| 379 |
<TR valign=top>
|
| 380 |
<TD align=right>6 </TD>
|
| 381 |
<TD>Alan</TD>
|
| 382 |
<TD>Turing'ton</TD>
|
| 383 |
<TD>Thu 19, May 2005 </TD>
|
| 384 |
<TD align=right>.1579551 </TD>
|
| 385 |
</TR>
|
| 386 |
|
| 387 |
<TR valign=top>
|
| 388 |
<TD align=right>7 </TD>
|
| 389 |
<TD>Serena</TD>
|
| 390 |
<TD>Williams</TD>
|
| 391 |
<TD>Thu 19, May 2005 </TD>
|
| 392 |
<TD align=right>.5652993 </TD>
|
| 393 |
</TR>
|
| 394 |
|
| 395 |
<TR valign=top>
|
| 396 |
<TD align=right>8 </TD>
|
| 397 |
<TD>Yat Sun</TD>
|
| 398 |
<TD>Sun</TD>
|
| 399 |
<TD>Thu 19, May 2005 </TD>
|
| 400 |
<TD align=right>.8400974 </TD>
|
| 401 |
</TR>
|
| 402 |
|
| 403 |
<TR valign=top>
|
| 404 |
<TD align=right>9 </TD>
|
| 405 |
<TD>Wai Hun</TD>
|
| 406 |
<TD>See</TD>
|
| 407 |
<TD>Thu 19, May 2005 </TD>
|
| 408 |
<TD align=right>.8073812 </TD>
|
| 409 |
</TR>
|
| 410 |
|
| 411 |
<TR valign=top>
|
| 412 |
<TD align=right>10 </TD>
|
| 413 |
<TD>Steven</TD>
|
| 414 |
<TD>Oey</TD>
|
| 415 |
<TD>Thu 19, May 2005 </TD>
|
| 416 |
<TD align=right>.1340615 </TD>
|
| 417 |
</TR>
|
| 418 |
|
| 419 |
<TR valign=top>
|
| 420 |
<TD align=right>11 </TD>
|
| 421 |
<TD>Caroline</TD>
|
| 422 |
<TD>Miranda</TD>
|
| 423 |
<TD>Thu 19, May 2005 </TD>
|
| 424 |
<TD align=right>.9993386 </TD>
|
| 425 |
</TR>
|
| 426 |
|
| 427 |
<TR valign=top>
|
| 428 |
<TD align=right>12 </TD>
|
| 429 |
<TD>John</TD>
|
| 430 |
<TD>Lim</TD>
|
| 431 |
<TD>Thu 19, May 2005 </TD>
|
| 432 |
<TD align=right>.7807507 </TD>
|
| 433 |
</TR>
|
| 434 |
|
| 435 |
<TR valign=top>
|
| 436 |
<TD align=right>13 </TD>
|
| 437 |
<TD>Mary</TD>
|
| 438 |
<TD>Lamb</TD>
|
| 439 |
<TD>Thu 19, May 2005 </TD>
|
| 440 |
<TD align=right>.1983442 </TD>
|
| 441 |
</TR>
|
| 442 |
|
| 443 |
<TR valign=top>
|
| 444 |
<TD align=right>14 </TD>
|
| 445 |
<TD>George</TD>
|
| 446 |
<TD>Washington</TD>
|
| 447 |
<TD>Thu 19, May 2005 </TD>
|
| 448 |
<TD align=right>.9449505 </TD>
|
| 449 |
</TR>
|
| 450 |
|
| 451 |
<TR valign=top>
|
| 452 |
<TD align=right>15 </TD>
|
| 453 |
<TD>Mr. Alan</TD>
|
| 454 |
<TD>Tam</TD>
|
| 455 |
<TD>Thu 19, May 2005 </TD>
|
| 456 |
<TD align=right>.5663581 </TD>
|
| 457 |
</TR>
|
| 458 |
|
| 459 |
<TR valign=top>
|
| 460 |
<TD align=right>16 </TD>
|
| 461 |
<TD>Alan</TD>
|
| 462 |
<TD>Turing'ton</TD>
|
| 463 |
<TD>Thu 19, May 2005 </TD>
|
| 464 |
<TD align=right>.4669657 </TD>
|
| 465 |
</TR>
|
| 466 |
|
| 467 |
<TR valign=top>
|
| 468 |
<TD align=right>17 </TD>
|
| 469 |
<TD>Serena</TD>
|
| 470 |
<TD>Williams</TD>
|
| 471 |
<TD>Thu 19, May 2005 </TD>
|
| 472 |
<TD align=right>.6451908 </TD>
|
| 473 |
</TR>
|
| 474 |
|
| 475 |
<TR valign=top>
|
| 476 |
<TD align=right>18 </TD>
|
| 477 |
<TD>Yat Sun</TD>
|
| 478 |
<TD>Sun</TD>
|
| 479 |
<TD>Thu 19, May 2005 </TD>
|
| 480 |
<TD align=right>.4639599 </TD>
|
| 481 |
</TR>
|
| 482 |
|
| 483 |
<TR valign=top>
|
| 484 |
<TD align=right>19 </TD>
|
| 485 |
<TD>Wai Hun</TD>
|
| 486 |
<TD>See</TD>
|
| 487 |
<TD>Thu 19, May 2005 </TD>
|
| 488 |
<TD align=right>.4443077 </TD>
|
| 489 |
</TR>
|
| 490 |
|
| 491 |
<TR valign=top>
|
| 492 |
<TD align=right>20 </TD>
|
| 493 |
<TD>Steven</TD>
|
| 494 |
<TD>Oey</TD>
|
| 495 |
<TD>Thu 19, May 2005 </TD>
|
| 496 |
<TD align=right>.3388362 </TD>
|
| 497 |
</TR>
|
| 498 |
|
| 499 |
<TR valign=top>
|
| 500 |
<TD align=right>21 </TD>
|
| 501 |
<TD>Caroline</TD>
|
| 502 |
<TD>Miranda</TD>
|
| 503 |
<TD>Thu 19, May 2005 </TD>
|
| 504 |
<TD align=right>.8143343 </TD>
|
| 505 |
</TR>
|
| 506 |
|
| 507 |
</TABLE>
|
| 508 |
|
| 509 |
<TABLE COLS=5 BORDER='1' WIDTH='98%'><tr>
|
| 510 |
|
| 511 |
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH><TH>abs(mod(dbms_random.random,10000001)/10000000)</TH>
|
| 512 |
</tr><TR valign=top>
|
| 513 |
<TD align=right>22 </TD>
|
| 514 |
<TD>John</TD>
|
| 515 |
<TD>Lim</TD>
|
| 516 |
<TD>Thu 19, May 2005 </TD>
|
| 517 |
<TD align=right>.972867 </TD>
|
| 518 |
</TR>
|
| 519 |
|
| 520 |
<TR valign=top>
|
| 521 |
<TD align=right>23 </TD>
|
| 522 |
<TD>Mary</TD>
|
| 523 |
<TD>Lamb</TD>
|
| 524 |
<TD>Thu 19, May 2005 </TD>
|
| 525 |
<TD align=right>.5805857 </TD>
|
| 526 |
</TR>
|
| 527 |
|
| 528 |
<TR valign=top>
|
| 529 |
<TD align=right>24 </TD>
|
| 530 |
<TD>George</TD>
|
| 531 |
<TD>Washington</TD>
|
| 532 |
<TD>Thu 19, May 2005 </TD>
|
| 533 |
<TD align=right>.0551489 </TD>
|
| 534 |
</TR>
|
| 535 |
|
| 536 |
<TR valign=top>
|
| 537 |
<TD align=right>25 </TD>
|
| 538 |
<TD>Mr. Alan</TD>
|
| 539 |
<TD>Tam</TD>
|
| 540 |
<TD>Thu 19, May 2005 </TD>
|
| 541 |
<TD align=right>.0705427 </TD>
|
| 542 |
</TR>
|
| 543 |
|
| 544 |
<TR valign=top>
|
| 545 |
<TD align=right>26 </TD>
|
| 546 |
<TD>Alan</TD>
|
| 547 |
<TD>Turing'ton</TD>
|
| 548 |
<TD>Thu 19, May 2005 </TD>
|
| 549 |
<TD align=right>.4666325 </TD>
|
| 550 |
</TR>
|
| 551 |
|
| 552 |
<TR valign=top>
|
| 553 |
<TD align=right>27 </TD>
|
| 554 |
<TD>Serena</TD>
|
| 555 |
<TD>Williams</TD>
|
| 556 |
<TD>Thu 19, May 2005 </TD>
|
| 557 |
<TD align=right>.7516632 </TD>
|
| 558 |
</TR>
|
| 559 |
|
| 560 |
<TR valign=top>
|
| 561 |
<TD align=right>28 </TD>
|
| 562 |
<TD>Yat Sun</TD>
|
| 563 |
<TD>Sun</TD>
|
| 564 |
<TD>Thu 19, May 2005 </TD>
|
| 565 |
<TD align=right>.3328669 </TD>
|
| 566 |
</TR>
|
| 567 |
|
| 568 |
<TR valign=top>
|
| 569 |
<TD align=right>29 </TD>
|
| 570 |
<TD>Wai Hun</TD>
|
| 571 |
<TD>See</TD>
|
| 572 |
<TD>Thu 19, May 2005 </TD>
|
| 573 |
<TD align=right>.8351005 </TD>
|
| 574 |
</TR>
|
| 575 |
|
| 576 |
<TR valign=top>
|
| 577 |
<TD align=right>30 </TD>
|
| 578 |
<TD>Steven</TD>
|
| 579 |
<TD>Oey</TD>
|
| 580 |
<TD>Thu 19, May 2005 </TD>
|
| 581 |
<TD align=right>.2147344 </TD>
|
| 582 |
</TR>
|
| 583 |
|
| 584 |
<TR valign=top>
|
| 585 |
<TD align=right>31 </TD>
|
| 586 |
<TD>Caroline</TD>
|
| 587 |
<TD>Miranda</TD>
|
| 588 |
<TD>Thu 19, May 2005 </TD>
|
| 589 |
<TD align=right>.8954723 </TD>
|
| 590 |
</TR>
|
| 591 |
|
| 592 |
<TR valign=top>
|
| 593 |
<TD align=right>32 </TD>
|
| 594 |
<TD>John</TD>
|
| 595 |
<TD>Lim</TD>
|
| 596 |
<TD>Thu 19, May 2005 </TD>
|
| 597 |
<TD align=right>.3072688 </TD>
|
| 598 |
</TR>
|
| 599 |
|
| 600 |
<TR valign=top>
|
| 601 |
<TD align=right>33 </TD>
|
| 602 |
<TD>Mary</TD>
|
| 603 |
<TD>Lamb</TD>
|
| 604 |
<TD>Thu 19, May 2005 </TD>
|
| 605 |
<TD align=right>.2168223 </TD>
|
| 606 |
</TR>
|
| 607 |
|
| 608 |
<TR valign=top>
|
| 609 |
<TD align=right>34 </TD>
|
| 610 |
<TD>George</TD>
|
| 611 |
<TD>Washington</TD>
|
| 612 |
<TD>Thu 19, May 2005 </TD>
|
| 613 |
<TD align=right>.2349472 </TD>
|
| 614 |
</TR>
|
| 615 |
|
| 616 |
<TR valign=top>
|
| 617 |
<TD align=right>35 </TD>
|
| 618 |
<TD>Mr. Alan</TD>
|
| 619 |
<TD>Tam</TD>
|
| 620 |
<TD>Thu 19, May 2005 </TD>
|
| 621 |
<TD align=right>.5354307 </TD>
|
| 622 |
</TR>
|
| 623 |
|
| 624 |
<TR valign=top>
|
| 625 |
<TD align=right>36 </TD>
|
| 626 |
<TD>Alan</TD>
|
| 627 |
<TD>Turing'ton</TD>
|
| 628 |
<TD>Thu 19, May 2005 </TD>
|
| 629 |
<TD align=right>.4541119 </TD>
|
| 630 |
</TR>
|
| 631 |
|
| 632 |
<TR valign=top>
|
| 633 |
<TD align=right>37 </TD>
|
| 634 |
<TD>Serena</TD>
|
| 635 |
<TD>Williams</TD>
|
| 636 |
<TD>Thu 19, May 2005 </TD>
|
| 637 |
<TD align=right>.6528771 </TD>
|
| 638 |
</TR>
|
| 639 |
|
| 640 |
<TR valign=top>
|
| 641 |
<TD align=right>38 </TD>
|
| 642 |
<TD>Yat Sun</TD>
|
| 643 |
<TD>Sun</TD>
|
| 644 |
<TD>Thu 19, May 2005 </TD>
|
| 645 |
<TD align=right>.5078207 </TD>
|
| 646 |
</TR>
|
| 647 |
|
| 648 |
<TR valign=top>
|
| 649 |
<TD align=right>39 </TD>
|
| 650 |
<TD>Wai Hun</TD>
|
| 651 |
<TD>See</TD>
|
| 652 |
<TD>Thu 19, May 2005 </TD>
|
| 653 |
<TD align=right>.2280108 </TD>
|
| 654 |
</TR>
|
| 655 |
|
| 656 |
<TR valign=top>
|
| 657 |
<TD align=right>40 </TD>
|
| 658 |
<TD>Steven</TD>
|
| 659 |
<TD>Oey</TD>
|
| 660 |
<TD>Thu 19, May 2005 </TD>
|
| 661 |
<TD align=right>.0865263 </TD>
|
| 662 |
</TR>
|
| 663 |
|
| 664 |
<TR valign=top>
|
| 665 |
<TD align=right>41 </TD>
|
| 666 |
<TD>Caroline</TD>
|
| 667 |
<TD>Miranda</TD>
|
| 668 |
<TD>Thu 19, May 2005 </TD>
|
| 669 |
<TD align=right>.866602 </TD>
|
| 670 |
</TR>
|
| 671 |
|
| 672 |
</TABLE>
|
| 673 |
|
| 674 |
<TABLE COLS=5 BORDER='1' WIDTH='98%'><tr>
|
| 675 |
|
| 676 |
<TH>id</TH><TH>firstname</TH><TH>lastname</TH><TH>created</TH><TH>abs(mod(dbms_random.random,10000001)/10000000)</TH>
|
| 677 |
</tr><TR valign=top>
|
| 678 |
<TD align=right>42 </TD>
|
| 679 |
<TD>John</TD>
|
| 680 |
<TD>Lim</TD>
|
| 681 |
<TD>Thu 19, May 2005 </TD>
|
| 682 |
<TD align=right>.6110876 </TD>
|
| 683 |
</TR>
|
| 684 |
|
| 685 |
<TR valign=top>
|
| 686 |
<TD align=right>43 </TD>
|
| 687 |
<TD>Mary</TD>
|
| 688 |
<TD>Lamb</TD>
|
| 689 |
<TD>Thu 19, May 2005 </TD>
|
| 690 |
<TD align=right>.0870814 </TD>
|
| 691 |
</TR>
|
| 692 |
|
| 693 |
<TR valign=top>
|
| 694 |
<TD align=right>44 </TD>
|
| 695 |
<TD>George</TD>
|
| 696 |
<TD>Washington</TD>
|
| 697 |
<TD>Thu 19, May 2005 </TD>
|
| 698 |
<TD align=right>.8348281 </TD>
|
| 699 |
</TR>
|
| 700 |
|
| 701 |
<TR valign=top>
|
| 702 |
<TD align=right>45 </TD>
|
| 703 |
<TD>Mr. Alan</TD>
|
| 704 |
<TD>Tam</TD>
|
| 705 |
<TD>Thu 19, May 2005 </TD>
|
| 706 |
<TD align=right>.2111793 </TD>
|
| 707 |
</TR>
|
| 708 |
|
| 709 |
<TR valign=top>
|
| 710 |
<TD align=right>46 </TD>
|
| 711 |
<TD>Alan</TD>
|
| 712 |
<TD>Turing'ton</TD>
|
| 713 |
<TD>Thu 19, May 2005 </TD>
|
| 714 |
<TD align=right>.2265778 </TD>
|
| 715 |
</TR>
|
| 716 |
|
| 717 |
<TR valign=top>
|
| 718 |
<TD align=right>47 </TD>
|
| 719 |
<TD>Serena</TD>
|
| 720 |
<TD>Williams</TD>
|
| 721 |
<TD>Thu 19, May 2005 </TD>
|
| 722 |
<TD align=right>.6451763 </TD>
|
| 723 |
</TR>
|
| 724 |
|
| 725 |
<TR valign=top>
|
| 726 |
<TD align=right>48 </TD>
|
| 727 |
<TD>Yat Sun</TD>
|
| 728 |
<TD>Sun</TD>
|
| 729 |
<TD>Thu 19, May 2005 </TD>
|
| 730 |
<TD align=right>.6077789 </TD>
|
| 731 |
</TR>
|
| 732 |
|
| 733 |
<TR valign=top>
|
| 734 |
<TD align=right>49 </TD>
|
| 735 |
<TD>Wai Hun</TD>
|
| 736 |
<TD>See</TD>
|
| 737 |
<TD>Thu 19, May 2005 </TD>
|
| 738 |
<TD align=right>.1526813 </TD>
|
| 739 |
</TR>
|
| 740 |
|
| 741 |
<TR valign=top>
|
| 742 |
<TD align=right>50 </TD>
|
| 743 |
<TD>Steven</TD>
|
| 744 |
<TD>Oey</TD>
|
| 745 |
<TD>Thu 19, May 2005 </TD>
|
| 746 |
<TD align=right>.2569144 </TD>
|
| 747 |
</TR>
|
| 748 |
|
| 749 |
</TABLE>
|
| 750 |
|
| 751 |
<p>GetOne returns ok</p><p>GetRow returns ok</p><p>FetchObject/FetchNextObject Test</p>AA<p>FetchObject/FetchNextObject Test 2</p>BBArray
|
| 752 |
(
|
| 753 |
[ID] => 4
|
| 754 |
[FIRSTNAME] => George
|
| 755 |
[LASTNAME] => Washington
|
| 756 |
[CREATED] => 2005-05-19
|
| 757 |
)
|
| 758 |
<br />
|
| 759 |
<b>Notice</b>: Undefined index: id in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
|
| 760 |
<br />
|
| 761 |
<b>Notice</b>: Undefined index: firstname in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
|
| 762 |
<br />
|
| 763 |
<b>Notice</b>: Undefined index: lastname in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
|
| 764 |
<br />
|
| 765 |
<b>Notice</b>: Undefined index: created in <b>D:\inetpub\wwwroot\php\phplens\adodb\adodb.inc.php</b> on line <b>3496</b><br />
|
| 766 |
adofetchobj Object
|
| 767 |
(
|
| 768 |
[ID] =>
|
| 769 |
[FIRSTNAME] =>
|
| 770 |
[LASTNAME] =>
|
| 771 |
[CREATED] =>
|
| 772 |
)
|
| 773 |
<p><b>Firstname is not string</b></p><p>CacheSelectLimit Test</p> /tmp/0d/adodb_0d16f79a74ee76ccabfb86ca1945f9ad.cache reloaded, ttl=2913 [ select * from (SELECT /*+FIRST_ROWS*/ id, firstname from ADOXYZ order by id) where rownum |
