Hi Anyone knows the function to start a transaction in the context of php ODBC functions ?
Do u mean something like this? PHP Code: <? $strDSN = "DSN=dsnsourcename;"; $strSQL = "SELECT * FROM yourtable"; $rs = new com("ADODB.RecordSet"); $rs->open($strSQL,$strDSN,2,1); while(!$rs->EOF){ print $rs->fields["Value"]->value."<br>"; $rs->movenext; } $rs->close ?>
<? $strDSN = "DSN=dsnsourcename;"; $strSQL = "SELECT * FROM yourtable"; $rs = new com("ADODB.RecordSet"); $rs->open($strSQL,$strDSN,2,1); while(!$rs->EOF){ print $rs->fields["Value"]->value."<br>"; $rs->movenext; } $rs->close ?>
[MindlessAnt.co.uk] [MSDN] [Paging Records With MS SQL] [Virtual CD-ROM Drive From Images] [WorldOverRide.co.uk] [Create PDF's using pure PHP] [PHP.net Search Bars] [PHP: Check Password Strength][PHP: BB Code] [PHP: Date Select] If you Question has been answered please mark the thread as [RESOLVED] Mediocre post? Please Rate it.
The subject is 'Unified ODBC functions', exists a function 'commit' and other named 'rollback', but nothing like 'begin' or 'begintrans' !?!?
Forum Rules