logo       

cvs: pecl /sdo/DAS Relational.php /sdo/DAS/Relational Action.php DeleteAct: msg#00255

php.pecl.cvs

Subject: cvs: pecl /sdo/DAS Relational.php /sdo/DAS/Relational Action.php DeleteAction.php InsertAction.php ObjectModel.php UpdateAction.php UpdateNonContainmentReferenceAction.php /sdo/DAS/Relational/Scenarios 1c-C.php 1c-CRU.php 1c-CRUD.php 1c-DCsamePK.php 1c-RA.php 1c-RD.php 1c-RUnull.php 1c-RUunsetPrimitive.php 1cd-CRUD.php 1cde-CRU.php 1cde-CRUD.php 1cde-CRUDdetach.php 1e-CRUD.php company_metadata.inc.php companydb.sql companydb_db2.sql companydb_mysql.sql mc-C.php

mfp Fri Jul 29 12:46:19 2005 EDT

Added files:
/pecl/sdo/DAS/Relational/Scenarios companydb_db2.sql
companydb_mysql.sql

Removed files:
/pecl/sdo/DAS/Relational/Scenarios companydb.sql

Modified files:
/pecl/sdo/DAS/Relational/Scenarios 1cde-CRUD.php 1c-CRUD.php
1c-RA.php 1c-CRU.php
1c-DCsamePK.php
company_metadata.inc.php
1c-RUnull.php mc-C.php
1cde-CRUDdetach.php 1c-C.php
1cd-CRUD.php 1e-CRUD.php
1c-RD.php
1c-RUunsetPrimitive.php
1cde-CRU.php
/pecl/sdo/DAS/Relational ObjectModel.php InsertAction.php
DeleteAction.php UpdateAction.php
UpdateNonContainmentReferenceAction.php
Action.php
/pecl/sdo/DAS Relational.php
Log:
Now works with DB2 8.2 Personal Edition on Windows. As a side effect, added
support for prepared statements with placeholders.
Changes include:
1. Use 'values identity_val_local()' to retrieve generated PK if DB2.
2. Use prepared statements and placeholders, both in statements generated by
applyChanges and in statements passed
to the new executePreparedQuery() call. Placeholders were primarily
introduced because literal SQL with the values inline
raises the problem that strings must be quoted and integers not. However,
using placeholders has the pleasant side effect
of avoiding variable interpolation and consequent danger that evil SQL
might be injected into the statement. The existing
executeQuery remains but should be used only for literal SQL that is
trusted.

Attachment: mfp-20050729124619.txt
Description: Text document



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise