* My 0.25a release of Recordset contained a number of patches. One of
the most prominent was the ability to provide pure SQL to Recordset
via the !Query flag and to retrieve it via the $makesql flag. None
of this is in 0.26
All changes are logged here:
http://www2.ecos.de/~mailarc/embper
Robert Bruccoleri wrote:
Dear Terrence,
I'm trying to get DBIx-Recordset-0.25a to build and test on an
SGI ALTIX. It's failing right after the "Select with sub table..." test.
Diagnostic output follows. If you need more information to suggest a solution,
please let me know. Thanks. --Bob
--
mathematics: the science of quantity, shape, and arrangement
computersci: the science of information description and transformation
liberalarts: essential study for adequate education and civic participation.
--- Begin Message ---
Dear Terrence,
I'm trying to get DBIx-Recordset-0.25a t
Matthew Simon Ryan Cavalletto wrote:
On Tuesday, May 11, 2004, at 08:22 AM, Terrence Brannon wrote:
Kaare Rasmussen wrote:
I've met a problem with DBIx::Recordset (reported to this list March
12, 2004). Since then, Terrence Brannon has declared that he doesn't
have time to ma
Angus Lees wrote:
Whatever came of the "Can't upgrade that kind of scalar" errors with
DBIx::Recordset and perl 5.8?
Here is the URL to the root of the thread you are talking about:
http://www.ecos.de/~mailarc/embperl/2004-01/msg00064.html
Did you ask the perl core guys what they wanted to
I am transitioning out of computer consulting and into teaching high
school mathematics.
I do not have time to maintain Recordset.
Whoever takes it over should be ready to use SVN, Postgres, MySQL,
SQLite, and of course Perl.
--
Hi Darin, thanks for the bug report. I am guessing that the DBD::CSV
driver is limited in functionality and cannot parse certain complex SQL
queries. I am very busy at the moment. Unless you need DBD::CSV you
might want to skip the tests for this driver by typing ".".
I know the test suite work
Kaare Rasmussen wrote:
This happens with DBIx::Recordset 0.25.
I'm sorry I didn't respond to your earlier version of this post.
I have a version 0.25a in my svn repository. Perhaps I did not upload it.
Excerpt from run with debug:
DB: do 'UPDATE transactions SET archived=?,status=? WHERE ar
via Arrays/Hashs
CPAN_USERID TBONE (Terrence Brannon <[EMAIL PROTECTED]>)
CPAN_VERSION 0.24
CPAN_FILEG/GR/GRICHTER/DBIx-Recordset-0.24.tar.gz
DSLI_STATUS bmpO (beta,mailing-list,perl,object-oriented)
MANPAGE DBIx::Recordset - Perl extension for DBI r
Gerald, to turn the module over to me, goto https://pause.perl.org
and set the CPAN userid of the owner of DBIx::Recordset to
TBONE
since that is my userid.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
Kaare Rasmussen wrote:
Just tried this:
cpan> reload index
cpan> i DBIx::Recordset
Strange distribution name [DBIx::Recordset]
Module id = DBIx::Recordset
DESCRIPTION DB-Abtractionlayer / Access via Arrays/Hashs
CPAN_USERID GRICHTER (Gerald Richter <[EMAIL PROTECTED]>)
CPAN_V
NEW FUNCTIONALITY (Cameron Prince, Terrence Brannon)
* Full SQL Query input via the !Query option to Search()
* added the '$makesql' flag to Search() so that generated SQL can
be returned instead of executed. It will remain undocumented until
it is supported for Update(), Delete(),
Kaare Rasmussen wrote:
I think the big problem with doing something like this is that updates
to multiple tables should be wrapped in a transaction.
Well, I'd leave that for the user to decide.
And I certainly don't think Recordset can do this at the moment.
Kaare Rasmussen wrote:
do you mean will recordset update across multiple tables? I can't remember.
Also this. Would be something of a dream, though I'm not sure its doable.
I think the big problem with doing something like this is that updates
to multiple tables
Kaare Rasmussen wrote:
I've run into an error with DBIx::Recordset and !LongNames. My query involves
several tables:
so_invoicebatch LEFT JOIN so_invoice USING (batchnr)
LEFT JOIN so_orderhead ON (so_invoice.ordernr=so_orderhead.ordernr)
LEFT JOIN co_custaddr_v USING (contact_id)
It looks like we are in some sort of (painful?) symbiotic relationship
here. As I update my drivers to make sure that Recordset works before
release, I keep having problems.
This time, I tried to do the following code which is part of Recordset:
my @bind_param = ($i+1, $bind_values -> [$i], (de
Rudy Lippan wrote:
On Sun, 28 Dec 2003, Terrence Brannon wrote:
DBD::mysql does not do the quoting itself. The quoting is a feature of the
DBI; Quoting the DBI docs:
oh, I see. thank you for the reference.
Versions of DBD::mysql < 2.9002 did not implement get_info(), so when DBI
w
running the below program show that table names are quoted automatically
under MySQL-4.016 and DBD::mysql 2.9003.
This wasn't happening about 2 weeks ago when I ran the entire test suite
and it passed.
needless to say, this is causing some problems with the MySQL part of
the test suite, when ch
Joshua Gerrish wrote:
I'm not sure if this is the right place to ask about DBIx::Recordset,
my apologies if it isn't.
The original author of DBIx::Recordset hangs out on his HTML::Embperl
list and answers questions there:
http://perl.apache.org/embperl/pod/doc/Embperl.-page-12-.htm
The err
/DBIx-Recordset-0.25.tar.gz
It was tested on MySQL, Postgres and SQLite only.
I am taking a 4-day train trip tonight so I will not be able to
respond to email
until 5 or so days from now.
It is checked into svn, so patches can be applied.
NEW FUNCTIONALITY (Kee Hinckley, Cameron Prince, Terrence Br
Daniel Brooks wrote:
I've been using DBIx::Recordset for a while now, and it's been great.
Yes, Recordset is great :)
However, just the other day I started adding some new functionality to
my program, and I've started getting this error message:
[Fri Dec 12 09:06:29 2003] [error] [client 4.63.
patches can be applied.
NEW FUNCTIONALITY (Kee Hinckley, Cameron Prince, Terrence Brannon)
* Full SQL Query input via the !Query option to Search()
* added the '$makesql' flag to Search() so that generated SQL can
be returned instead of executed. It will remain undocumented until
it is
So far, postgres and sqlite pass the test suite. mysql is failing with
this error:
Clear (Delete all) disabled for table : (! && !(7 & wmCLEAR)) at
blib/lib/DBIx/\
Database.pm line 57
DBIx::Database::Base::savecroak('DBIx::Recordset=HASH(0x86248dc)','Clea\
r (Delete all) disabled for tab
I posted this as a bug against DBD::SQLite. The test suite now passes
for DBD::Pg. DBD::SQLite is failing because the bind types are not useable.
This program shows that DBD::SQLite returns unuseable type info. I would
appreciate any pointers on where to go to fix this. It looks like one
just n
Kee Hinckley wrote:
Has anyone made that work?
http://princepawn.perlmonk.org/cgi-bin/se.com/wiki.cgi?RecordsetUpgradePath
Patch #4 by Angus Lees:
.#4 fully-qualifying column names and column alias patch (angus lees) .
+ http://www.ecos.de/~mailarc/embperl/2002-01/msg6.html
I tried
*** I plan to fix this my using the created $dbh in DoTest() throughout
test.pl instead of passing $DSN to each independent Search() call, but
thought I would report this. I am further down in the test suite,
getting it to truly pass for DBD::Pg, and have run across this error:
Select dbixrs2.n
Before applying any of the patches that have been emailed to the embperl
list,
I thought I would first make sure that the test suite passed.
I could not use Angus Lees' "patches" for the test suite because most of
them
simply skipped the test when $Driver eg 'Pg'.
This is a rather difficult thi
Actually, I used the excellent htDig email archives of this list
http://www.ecos.de/~mailarc/embperl/
and came up with a ream of DBIx::Recordset patches to apply:
http://www.ecos.de/~mailarc/embperl/2002-06/msg00052.html
http://www.ecos.de/~mailarc/embperl/2003-10/msg00025.html
http://www.ec
Tomorrow morning, I will begin applying my patches to the
DBIx::Recordset SVN repository in preparation for a new CPAN release. I
got svn compiled and running on my Cygwin box, so I am a happy man.
If you have any that you want applied, email them to me with subject header:
[PATCH] DBIx::Record
Michael Gray wrote:
source databases available, or I would do some testing and patching
myself. There's no free version of Oracle for Windows is there? I run
Cygwin.
Hmm, I wonder what could be causing this to happen. I have only open
Jeff's pointed out the free version.
Michael Gray wrote:
Hs anyone had any luck getting DBIx::Recordset to pass its tests using
recent versions of perl, DBI and DBD::Oracle?
Angus Lees and myself have several patches for Recordset, most are
archived in the embperl mailing list.
Gerald was supposed to have a subversion repositor
Welcome back Gerald,
Should we have a different mailing list for DBIx::Recordset?
Also, I am ready to start patching Recordset set as soon as you can
setup a repository.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additio
Nelson Ferraz wrote:
Dear
Mr. Terrence Brannon,
Hi Nelson,
I've read your article about DBIx::Recordset at Perl.com (Feb. 27,
2001), and I thought that this module could be very useful in an open
source project I'm currently developing: a web based CRM, which can be
used
The original code for this routine had a logic error:
sub PreFetchIfExpires
{
my ($self, $rs) = @_ ;
return if (!defined ($self -> {'*ExpiresTime'}) && $self ->
{'*ExpiresTime'} < time) ;
return if (ref ($self -> {'*Expires'}) ne 'CODE' || ! (&{$self ->
{'*Expires'}}($self))) ;
I setup a public repository with the module name "dbix-recordset" at
http://www.freepository.com
the password for the repository will be mailed on request.
I am about to apply all the patches I have emailed to this list and hope
to have Gerald's permission to upload a new version to CPAN wit
Kee Hinckley wrote:
Urgh. We really need a DBIX::Recordset (and Embperl) quickref manual.
your patches to DBIx::Recordset::Playground (on CPAN) are welcome :)
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands
SQLite does not have grant tables and so any part of the schema with
grant syntax causes CreateTables() to die
~/hacks/DBIx-Recordset-0.24 $ diff -u Compat.pm~ Compat.pm
--- Compat.pm~2003-10-12 18:40:18.68750 -0700
+++ Compat.pm2003-10-13 06:11:26.453125000 -0700
@@ -230,7 +230,8 @@
Most people who look at DBIx::Recordset are immediately suprised/offended by it's use of typeglobs. For one, you have to predeclare with a separatoe use vars statement whereas scalars can be created on the fly with my. For another, under mod_perl you have to make sure to clean up typeglobs as they
I have some serious things to do with DBIx::Recordset and as you can see
I am already submitting patches. We need a repository fast.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTE
DBIx::Compat did not properly convert the pseudo-type "counter" to
"SERIAL" when DBD::Pg was in use. The following patch fixes this...
~/hacks/DBIx-Recordset-0.24 $ diff -u Compat.pm~ Compat.pm
--- Compat.pm~2001-07-09 20:58:58.0 -0700
+++ Compat.pm2003-10-12 18:40:18.6
Kee Hinckley wrote:
One thing that would be helpful in that context is to have the inverse
case automatically generated, eg.
$set = $$set2->{-otherrecords}
Although for language reasons, automatically doing plurals probably
isn't a good idea, maybe something like:
$set = $$set2->{'+other
From
http://search.cpan.org/~grichter/DBIx-Recordset-0.24/Recordset.pm#Automatic_detection_of_links
We have::
DBIx::Recordset and DBIx::Database will try to automatically detect
links between tables based on the field and table names. For this
feature to work, the field which points to another
I am ready to start patching Recordset.
We can get CVS service or subversion if you prefer.
die "Fehler beim Erstellen des Feldes
$tabname.$field:\n$cmd\n" . DBIx::Database->LastError if
(DBIx::Database->LastError) ;
die "Fehler beim Setup von Tabelle $tabname:\n$cmd\n
Under Cygwin, Perl-5.8.0 and DBD::Pg, The following test fails:
printlogf "Select multiply fields 2";
print LOG "\n\n" ;
$set1 -> Select ({'+name&value1' => "Third Name",
'$operator' => '='}) or die "not ok
($DBI::errstr)" ;
The Record
- Original Message -
From: "Gerald Richter" <[EMAIL PROTECTED]>
To: "Angus Lees" <[EMAIL PROTECTED]>; "Terrence Brannon"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 9:23 AM
Subject: Re: DBIx::Records
The Perl object-oriented Persistence group ([EMAIL PROTECTED]), has
stated that their list of reviewed modules will drop DBIx::Recordset within
six months unless it appears that the module is being maintained (ie, new
releases are made).
I told them that I am creating a set of docs for Recordset w
- Original Message -
From: "Neil Gunton" <[EMAIL PROTECTED]>
To: "embperl" <[EMAIL PROTECTED]>
Sent: Tuesday, September 16, 2003 7:48 PM
Subject: What's going on with Embperl???
> I even
> offered to try and have a go at writing an (English) book on Embperl,
> perhaps some sort of cookb
> Hello Terrance,
>
> This is all very interesting, as usual with Perl, everything looks rather
> odd at first when looking at the DBIx::Recordset documentation. I would
> assume that is it being more widely used than DBIx::Abstract since it is
> designed to work with EMBPerl. Anyway, thank you
From: "Neal Gamradt" <[EMAIL PROTECTED]>
> Hello Terrance,
>
Hi!
> I thank you for the feedback. I was actually going to use DBIx::Abstract
> (http://search.cpan.org/author/TURNERA/DBIx-Abstract-1.005/Abstract.pm) I
> was wondering of you or anyone knows of any specific reason to use
> DBIx::Rec
> Hello All,
>
> I had sent this question right after I signed up to the mailing list and I
> am not sure if it actually made it to everyone. I was wondering if anyone
> had developed a forum using EMBPerl? I have had trouble finding one that
I
> like and I am thinking that I may just build one
For "Embperl 2 Advanced" this URL:
http://perl.apache.org/embperl/pod/intro/IntroEmbperl2.htm
this link is broken
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I have the following tables:
mysql> describe authors; describe titles; describe titleauthors;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| au_id| varchar(11) |
-
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
=
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
__
Do You Yahoo!?
Kick off yo
-
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
=
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
__
Is there anyway to ensure a database handle is not being used by more than one process on the machine at one time without developing one's own locking mechanisms?
We want to limit the number of connections to our database. If the same .epl page is being hit 50 times simultaneously, we risk an atte
It is tedious to check each month of the mailing list separately for a topic of interest. It would be more expedient to be able to search across months. As more months of the list become archived, searches will be more and more tiresome to perform.
Terrence Brannon90 St. Mark's PlaceApt. 2E NorthS
]PERF: input =
/home/angryman/www/cgi-bin/angrycards/send-card.epl
[6172]PERF: Time: 100 ms Evals: 3 Cache Hits: 0 (0%)
[6172]Request finished. Thu Jun 8 13:43:56 2000
. Entry-SVs: 53265 -OBJs: 159 Exit-SVs: 58097 -OBJs:
155
[6172]MEM: Free buffer for card-notification.epl in
HTML::Embperl::DOC::_25
e "Cannot INSERT to
> '$table'" ;
>
>
> Is there a different way I need to reference my
> variables?
>
> Any help is much appreciated.
>
> --Diana
>
>
-----
> To unsubscribe
+49
> 6133 925151
> WWW:http://www.ecos.de Fax: +49
> 6133 925152
>
-----
>
>
>
-
> To unsubscribe, e-mail:
> [EMAIL PROTECT
I was using embpcgi.pl but got DBIstore to work once
I used mod_perl.
Sorry for the interruption.
--- Terrence Brannon <[EMAIL PROTECTED]> wrote:
> I created the required table (I had to go hunt for
> the
> table to create in Apache::Session::DBIStore).
>
> And setup s
The title says it all: must one run under mod_perl to
have session handling with HTML::Embperl?
=
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
__
Do You Yahoo!?
Send instant messages &
new PID: 14076
[root@prwwny01 /home/angryman/www/admin-bin]#
=====
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
914-755-4360
__
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! M
this
automatically from page to page
however, by the third screen, it was empty and my
macro had done it's job.
Any input into why %idat is empty and hence doesnt
equal what I copied into %udat?
=
Terrence Brannon
90 St. Mark's Place
Apt. 2E North
Staten Island, NY 10301
91
63 matches
Mail list logo
