SPOPS 0.60 released

://prdownloads.sourceforge.net/openinteract/SPOPS-0.60.tar.gz Detailed changes: http://sourceforge.net/project/shownotes.php?release_id=88236 Thanks! Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

[ANNOUNCE] SPOPS 0.57 released

?release_id=76557 Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

[ANNOUNCE] SPOPS 0.56 released

your object configuration, which makes it easier to write one-off data munging scripts. URLs: Download (or use CPAN): http://prdownloads.sourceforge.net/openinteract/SPOPS-0.56.tar.gz Detailed changes: http://sourceforge.net/project/shownotes.php?release_id=70030 Chris -- Chris Winters ([

[ANNOUNCE] SPOPS 0.53 released

much more detailed than above): http://sourceforge.net/project/shownotes.php?release_id=62730 Sourceforge home (mailing lists, CVS, bugs, to-do list, etc.): http://sourceforge.net/projects/openinteract/ Thanks, Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable s

[ANNOUNCE] SPOPS 0.52 released

initial support for setting default values in newly-created objects. Full changelog: http://sourceforge.net/project/shownotes.php?release_id=58753 Source: http://sourceforge.net/project/showfiles.php?group_id=16810 Have fun, Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable

SPOPS 0.51 released

.net/projects/openinteract/ Other home: http://www.openinteract.org/SPOPS/ Thanks! Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

SPOPS 0.41 released

bugs, etc.): http://sourceforge.net/projects/openinteract/ Other home: http://www.openinteract.org/SPOPS/ Thanks! Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: Object Oriented Databases with MySQL

rested, SPOPS is on CPAN, and you can join the openinteract-help or -dev mailing lists (which provide support and discussion for SPOPS) at: http://sourceforge.net/mail/?group_id=16810 Hope this helps! Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

SPOPS 0.40 released

peninteract.org/SPOPS/ Finally, I'll be at YAPC North America talking about OpenInteract on Friday (June 15) morning, and SPOPS will surely be involved. Stop by! Thanks! Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: connecting to postgresql

shows all possible parameters: $dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$host;port=$port;options=$options;tty=$tty", "$username", "$password"); So you'd want to modify $dsn: my( $d

Re: Can't locate object method "prepare" via package "dbh" - Error

ent: " . $sth->errstr; > $dbh->disconnect; > > When I executed the above piece of code I got the following error: > > Can't locate object method "prepare" via package "dbh" at ./fpgm2db line 9. Try using '$dbh->prepare' instead of 'dbh->prepare' -- once you create your database handle ($dbh) you might as well use it :-) Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: performance question.

; > also looked in 'Programming the Perl DBI' book but no luck.. This is a frequent topic in the mod_perl arena. See: http://perl.apache.org/guide/strategy.html#When_One_Machine_is_not_Enough_f Summary (IIRC): unless you're communicating using LocalTalk, it's usually a g

Re: Using perl to access an LDAP server

o :-) The pure-Perl module Net::LDAP is, IIRC, available via PPM on ActiveState Perl installations. Tangentially we're (http://sourceforge.net/projects/openinteract/) hoping to get LDAP functionality into the object serialization module SPOPS so you can use it as another data store. Chris -

Re: Extract data from MS Excel Spreadsheets. Can it be done?

've never tried it on Solaris, but I've mounted 95/98/NT/2000 shares just fine with it from Linux. Not that this will necessarily solve your problem :-) Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: Last fetch takes forever to undef under XBase

the machine that it's on? I am > getting the data off of a Novell mounted server drive... I have yet > to dig down into the guts of the modules to see how it pulls data > from the DBF file, but I'm hoping to avoid this. Just curious: what happens when you copy the file to a loca

Re: last id with DBI and MySQL OT?

;do( "insert into..." ); my $id = $dbh->{mysql_insertid}; HTH Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: documentation suggestion: explain strings, numbers, and binding "gotcha".

hich bind the values to the placeholders using specific datatypes. This is a cue to the DBD to do the proper type of quoting. You can find this in the DBI documention under 'Data Types for Placeholders'. Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: $STH->{NAME}->[$Value] problem

NAME}->[$Value] ."',\n"; > } $STH->{NAME} is an arrayref and $Value above is the value retrieved from the row, which is incorrect. Try something like this: $STH->execute() || die $DBI::errstr; my @student_info = $STH->fetchrow_array(); my @values = map { "

Re: How do I get multiple rows?

out: $sth->execute( $content_page, $content_type ); while ( my $row = $sth->fetchrow_arrayref ) { ... do stuff with @{ $row }... } Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: (trouble) INSERT/SELECT

) }; die "I'm a failure! $@" if ( $@ ); print "My ID was: $dbh->{mysql_insertid}\n"; Hope this helps. Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.

Re: DBI insert

I have searched using several engines and they all come up short. I have slides from a presentation at YAPC 1999 and a decent intro at: http://www.cwinters.com/programming/ (look toward the bottom of the page) Hope you find it useful. Chris -- Chris Winters ([EMAIL PROTECTED]) Building ent

ANNOUNCE: SPOPS 0.39

ourceforge: http://sourceforge.net/project/showfiles.php?group_id=16810&release_id=25292 SPOPS is supported by the openinteract-(help|dev) mailing lists: http://sourceforge.net/mail/?group_id=16810 Thanks! Chris -- Chris Winters ([EMAIL PROTECTED]) Building enterprise-capable snack solutions since 1988.