Search Result

Wiinie · Apr 21 '11, 03:41 PM

Hi,
I have this error when i try to insert some values into the database via perl script.

there is my code

Code:

sub addWords {
	my $self = shift;
	my $wordsRef = shift;
	my @words = \$wordsRef;
	my $language = Language->new();
	my $classId = undef;
	my $wordId = undef;
	if (!@words || !$language){
		die "addWords invalid arguments.";
	}

...

Wiinie · Apr 12 '11, 05:19 PM

Code:

sub languages{
	my $self = shift;
	
	if (!$self->{LANGUAGE})
	{
		my @language = ();
		my $statement = $db1->prepare("select Id, Name, syllableData from language");
		$statement->execute();

		while(my @array = $statement->fetchrow_array()){
			my ($id , $name, $syllableData) = @array;
			push (@language, $object);				
		}	
		$statement->finish();

...

Alex Levinson · Jul 13 '10, 01:28 AM

Hello -

I am a Perl programmer who's developing a Cocoa application with a development team. Our Cocoa-based application is going to execute some Perl scripts to take care of some systems administration tasks at various times.

I've programmed my Perl script using the DBI:: and DBD::SQLite Perl CPAN packages, but I'm concerned that these packages aren't in a standard Perl installation on OS X 10.6.

What...

dlite922 · Jul 6 '09, 06:34 PM

I'm trying to convert an SQLITE database to MySQL syntax and it seems every resource I find on google is only half complete.

I want to create this thread to sum them all up in one central location; Finally a bulleted list of all the rules you have to apply to your script to completely and fully transfer /any/ sqlite schema dump to a MySQL one.

For this I need your help; I'll start with the popular few, anyone notice...

leonluis · Jan 20 '09, 07:52 PM

Hi, I'm currently in design of my first mobile aplication that has to run in 3 diferent plataforms (Blackberry, Symbian and Windows Mobile), I've checking my options and I'm inclined to chose Perst Lite, in order to get a better performance working in a OR DBMS and unify the architecture of the aplication, but there are some past aplications that are suposed to keep using SQLite (windows mobile ones) and one of my bosses wants to keep that intact....

bigturtle · Dec 18 '08, 04:23 PM

I'm trying to do some database stuff in Python 2.6 with sqlite3, and am having trouble understanding the basics of the interface between the two. I am able to create database files and retrieve records, but some other commands are mysterious.

Here's a snippet where I'm trying to retrieve the number of records in file "thefile", located in database "mydata" in sister folder "data":

Code:

...

Search Result

Error of DBD::SQLite::db do failed: near ",": syntax error at C:\

how to fix error attempt to prepare on inactive database handle in SQLite

How to include CPAN packages inside my application

SQLITE -> MySQL syntax differences complete list

Multi-plataform Database selection

sqlite3/python dumb question