propel-adapter
[ class tree: propel-adapter ] [ index: propel-adapter ] [ all elements ]

Class: DBMSSQL

Source Location: /adapter/DBMSSQL.php

Class Overview

DBAdapter
   |
   --DBSybase
      |
      --DBMSSQL

This is used to connect to a MSSQL database. For now, this class simply extends the adaptor for Sybase.


Author(s):

Version:

  • $Revision: 805 $

Methods


Inherited Constants

Inherited Methods

Class: DBSybase

DBSybase::concatString()
Returns SQL which concatenates the second string to the first.
DBSybase::ignoreCase()
This method is used to ignore case.
DBSybase::quoteIdentifier()
DBSybase::random()
DBSybase::strLength()
Returns SQL which calculates the length (in chars) of a string.
DBSybase::subString()
Returns SQL which extracts a substring.
DBSybase::toUpperCase()
This method is used to ignore case.

Class: DBAdapter

DBAdapter::applyLimit()
Modifies the passed-in SQL to add LIMIT and/or OFFSET.
DBAdapter::concatString()
Returns SQL which concatenates the second string to the first.
DBAdapter::factory()
Creates a new instance of the database adapter associated with the specified Creole driver.
DBAdapter::getDateFormatter()
Returns date formatter string for use in date() function.
DBAdapter::getId()
Gets the generated ID (either last ID for autoincrement or next sequence ID).
DBAdapter::getIdMethod()
Returns the native ID method for this RDBMS.
DBAdapter::getStringDelimiter()
Returns the character used to indicate the beginning and end of a piece of text used in a SQL statement (generally a single quote).
DBAdapter::getTimeFormatter()
Returns time formatter string for use in date() function.
DBAdapter::getTimestampFormatter()
Returns timestamp formatter string for use in date() function.
DBAdapter::ignoreCase()
This method is used to ignore case.
DBAdapter::ignoreCaseInOrderBy()
This method is used to ignore case in an ORDER BY clause.
DBAdapter::initConnection()
This method is called after a connection was created to run necessary post-initialization queries or code.
DBAdapter::isGetIdAfterInsert()
Whether this adapter uses an ID generation system that requires getting ID _before_ performing INSERT.
DBAdapter::isGetIdBeforeInsert()
Whether this adapter uses an ID generation system that requires getting ID _before_ performing INSERT.
DBAdapter::quoteIdentifier()
Quotes database objec identifiers (table names, col names, sequences, etc.).
DBAdapter::random()
DBAdapter::strLength()
Returns SQL which calculates the length (in chars) of a string.
DBAdapter::subString()
Returns SQL which extracts a substring.
DBAdapter::toUpperCase()
This method is used to ignore case.
DBAdapter::useQuoteIdentifier()
Should Column-Names get identifiers for inserts or updates.

Class Details

[line 31]
This is used to connect to a MSSQL database. For now, this class simply extends the adaptor for Sybase.



Tags:

author:  Hans Lellelid <hans@xmpl.org> (Propel)
version:  $Revision: 805 $


[ Top ]


Class Methods


method applyLimit [line 39]

void applyLimit( &$sql, $offset, $limit)

Simulated Limit/Offset This rewrites the $sql query to apply the offset and limit.



Tags:

author:  Justin Carlson <justin.carlson@gmail.com>
see:  DBAdapter::applyLimit()
access:  public


Overrides DBAdapter::applyLimit() (Modifies the passed-in SQL to add LIMIT and/or OFFSET.)

Parameters:

   &$sql  
   $offset  
   $limit  

[ Top ]

method random [line 133]

void random( [ $seed = NULL])



Tags:

access:  public


Overrides DBSybase::random() (parent method not documented)

Parameters:

   $seed  

[ Top ]


Documentation generated on Thu, 22 Nov 2007 03:33:40 +0000 by phpDocumentor 1.4.0