ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:dictionary:adofieldobject

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
v5:dictionary:adofieldobject [2016/01/17 03:11] – ↷ Page moved from v5:reference:adofieldobject to v5:dictionary:adofieldobject mnewnhamv5:dictionary:adofieldobject [2023/05/20 17:50] (current) – Fix code sample blocks dregad
Line 18: Line 18:
 ===== Sample Of Program To Retrieve ADOFieldObjects ===== ===== Sample Of Program To Retrieve ADOFieldObjects =====
 <code php> <code php>
- 
 $SQL = "SELECT * FROM some_table"; $SQL = "SELECT * FROM some_table";
 $f = $db->Execute($SQL); $f = $db->Execute($SQL);
Line 27: Line 26:
 } }
 </code> </code>
 +
 ===== Examples ===== ===== Examples =====
  
 ==== SQL Server ==== ==== SQL Server ====
-  ADOFieldObject Object + 
-  (+<code> 
 +ADOFieldObject Object 
 +(
     [name] => Freight     [name] => Freight
     [max_length] =>      [max_length] => 
     [column_source] => Freight     [column_source] => Freight
     [type] => decimal     [type] => decimal
-  )+)
  
-  ADOFieldObject Object +ADOFieldObject Object 
-  (+(
     [name] => ShipName     [name] => ShipName
     [max_length] => 40     [max_length] => 40
     [column_source] => ShipName     [column_source] => ShipName
     [type] => nvarchar     [type] => nvarchar
-  + 
 +</code>
  
 ==== IBM DB2 ==== ==== IBM DB2 ====
-  ADOFieldObject Object + 
-  (+<code> 
 +ADOFieldObject Object 
 +(
     [name] => ACTNO     [name] => ACTNO
     [max_length] => 6     [max_length] => 6
     [type] => int     [type] => int
-  )+)
  
-  ADOFieldObject Object +ADOFieldObject Object 
-  (+(
     [name] => ACTKWD     [name] => ACTKWD
     [max_length] => 6     [max_length] => 6
     [type] => string     [type] => string
-  )+) 
 +</code>
  
 ==== MySQL ==== ==== MySQL ====
-Note that currentlyMySql does not return an ADOfieldObject object.+Note that before ADOdb Version 5.21MySQL did not return an ADOfieldObject object.
  
-  stdClass Object +<code> 
-  (+stdClass Object 
 +(
     [name] => Code     [name] => Code
     [orgname] => Code     [orgname] => Code
Line 84: Line 91:
     [binary] => 0     [binary] => 0
     [unsigned] => 0     [unsigned] => 0
-  +
-  +</code> 
 ===== Sqlite ===== ===== Sqlite =====
  
-  ADOFieldObject Object +<code> 
-  (+ADOFieldObject Object 
 +(
     [name] => COL1     [name] => COL1
     [max_length] => 32     [max_length] => 32
Line 98: Line 107:
    )    )
  
-  ADOFieldObject Object +ADOFieldObject Object 
-  (+(
      [name] => COL2      [name] => COL2
      [max_length] => 10      [max_length] => 10
Line 106: Line 115:
      [default_value] => 0      [default_value] => 0
      [scale] => 0      [scale] => 0
-  )+)
  
-  ADOFieldObject Object +ADOFieldObject Object 
-  (+(
      [name] => COL3      [name] => COL3
      [max_length] => 12,2      [max_length] => 12,2
Line 116: Line 125:
      [default_value] =>      [default_value] =>
      [scale] => 0      [scale] => 0
-  + 
 +</code> 
v5/dictionary/adofieldobject.txt · Last modified: 2023/05/20 17:50 by dregad