Dbi To Access Snippets


The pyperl dist provide an interface to the Perl DBI (dbi.py). This allow direct access to all the perl supported databases from python. Full documentation of the API from 'perldoc DBI' or the ORA "Programming the Perl DBI" book, by A. Descartes and T. Bunce.

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

05 November, 2013   

Apache code example to limit access by IP address

Example Apache .htaccess file to add access control header

28 November, 2013   

Edit database using vb + access

07 March, 2011   

Shows how to upload a single file to a FTP server.

21 January, 2013   

VB code to add data using access

15 March, 2015   

How to automize versioning by modifying a line in the AssemblyInfo file.

29 June, 2011   

There are times when you need to access the stage property before onCreationComplete. Here are two ways to do it.

07 August, 2014   

All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.

14 January, 2012   

How to Setting AccessText properties

05 August, 2015   

Shows how to access the HTTP headers from a given web adress.

18 December, 2014   

Example code for locking table. when a user modifies data through a transaction, that data is locked by that transaction until the transaction is committed or rolled back.

Makes it extremely easy to integrate code igniter and smarty as well as provide layout capabilites.

An example code how to define and use asp:AccessDataSource

24 May, 2015   

Shows how to access the navigator.* variables.

Below example showing how to define and use asp:AccessDataSource

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

The IsFileInUse Delphi function will return true if the file is locked for exclusive access. False is returned if the file does not exist. Code "flow": Two things need to be checked here: A) Is the file a READ-ONLY file? and B) Is the file in use? The main point of the excercise is to check the files attributes for the READ-ONLY...

The IsFileInUse Delphi function will return true if the file is locked for exclusive access. False is returned if the file does not exist. Code "flow": Two things need to be checked here: A) Is the file a READ-ONLY file? and B) Is the file in use? The main point of the excercise is to check the files attributes for the READ-ONLY flag...