GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
Goo::LiteDatabase(3) User Contributed Perl Documentation Goo::LiteDatabase(3)

Goo::LiteDatabase - Drive an SQLite database

use Goo::LiteDatabase;

Interface to an SQLite database.

get_connection
open a connection to the default database
do_sql
execute some SQL
do_query
execute SQL and return the result all in one
generate_numeric_sqlin_clause
return an SQL 'in' clause with numeric values
generate_string_sqlin_clause
return an SQL 'in' clause with string values
get_number_of_rows
return the number of rows for this statement handle
get_next_row
alias for get_result_hash
get_result_hash
return a hash for this result
bind_param
bind a parameter to a value
show_sql
display SQL statement useful for debugging
execute_sql
take a string and execute the SQL return a hash of column headings and values
prepare_sql
take a string and prepare the SQL for later execution
execute
execute prepared statement
get_max
return the maximum value of a database column
get_last_max
return the latest increment for this database handle
count_rows_in_table
check if a value exists in a given column and table
exists_in_table
check if a value exists in a given column and table
get_row
return a row based on a key
get_count
return a simple row in the table
delete_row
delete a row based on a key
quote
quote a value for insertion into the database
handle_error
handle any error thrown by the dbi subsystem
get_primary_key
return the primary key for a table
get_table_columns
return a list of column names for the table

Nigel Hamilton <nigel@trexy.com>

2005-11-30 perl v5.32.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.