Re: DBIx::Recordset andLongNames error
> 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.
There's a $set -> Begin. Not sure how to use it though as I'd prefer to begin
my transaction before any read, but I guess it's like this
my $set = DBIx::Recordset -> Search ({ %search });
$$set -> Begin;
updates, deletes and inserts
$$set -> Commit;
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize Fax:3816 2501
Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED]
2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Antwort: Re: Antwort: Re: [mp2] segfault when generating graphs with GD::Graph under Embperl
Hi again! I installed WhiteBox Linux 3.0 (a free version of RedHat Advanced Server 3.0) yesterday. Now i've hot EXACTLY the same troubles as one month ago with Fedora Core 1!!! My apache2 segfaults when i use GD::Graph. @Gerald: have you look further into this? HELP NEEDED! Thanks, Alex Von: Gerald Richter <[EMAIL PROTECTED]> am 14.11.2003 14:19 An: Alexander Hartmaier/DEBIS/EDVG/[EMAIL PROTECTED] Kopie: Thema:Re: Antwort: Re: [mp2] segfault when generating graphs with GD::Graph under Embperl Hallo Alexander, ich schau mir das mal an, aber ich kann noch nicht 100% versprechend wann ich dazu komme, vermutlich am Wochenende. Gruß Gerald Alexander Hartmaier wrote: > Hi Gerald! > > Ich hab alle library function aufrufe entfernt. Du musst nur GD und > GD::Graph installieren (CPAN...). > > Hier sind die files: > > (See attached file: 2003-08-gate-dest)(See attached file: > 2003-08-gate-dest-percent)(See attached file: 2003-08-gate-src)(See > attached file: 2003-08-gate-src-percent)(See attached file: AS)(See > attached file: flow-graph-test.pl) > > Du musst eigentlich nur die Pfade ändern damit die datenfiles > (2003-08-gate-dest, 2003-08-gate-dest-percent) gefunden werden und > das file 'AS'. > > Die parameter hab ich am Anfang fix gesetzt: > 2003-08 > dest (kannst du auf src ändern, das wäre die 2te grafik die auf der > page angezeigt werden sollte). > > Bei Fragen kannst du mich heute bis ca. 15h anrufen wenn du willst. > (geht schneller als mail). > > Danke, Alex > > T-Systems > > T-Systems Austria > TCS/Network Monitoring & Security Specialist > Hausanschrift: Hofmühlgasse 3-5, 1060 Wien > Telefon: +43 (0)57057 - 4320 > Telefax: +43 (0)57057 - 4152 > Mobiltelefon: +43 (0)676 8642 - 4320 > E-Mail: [EMAIL PROTECTED] > Internet: http://www.t-systems.at > > > > > Von: Gerald Richter <[EMAIL PROTECTED]> am 14.11.2003 13:16 > > > > An: Alexander Hartmaier/DEBIS/EDVG/[EMAIL PROTECTED] > Kopie:Stas Bekman <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED], [EMAIL PROTECTED] > > Thema:Re: [mp2] segfault when generating graphs with GD::Graph > under Embperl > > Alexander Hartmaier wrote: >> snip from httpd.conf: >> >> >> SetHandler perl-script >> PerlResponseHandler ModPerl::Registry >> PerlOptions +ParseHeaders >> Options +ExecCGI >> >> > > So it seems to be only happening when Embperl is involved. > > Any chance that you can send me a small test case of your GD script, > that I > can run and debug here? > > Gerald > > >> Yours sincerly >> Alexander Hartmaier >> >> T-Systems >> >> T-Systems Austria >> TCS/Network Monitoring & Security Specialist >> address: Hofmühlgasse 3-5, 1060 Wien >> telephone: +43 (0)57057 - 4320 >> fax: +43 (0)57057 - 4152 >> mobile: +43 (0)676 8642 - 4320 >> mail: [EMAIL PROTECTED] >> Internet: http://www.t-systems.at >> >> >> >> >> Von: Gerald Richter <[EMAIL PROTECTED]> am 14.11.2003 12:38 >> >> >> >> An: Alexander Hartmaier/DEBIS/EDVG/[EMAIL PROTECTED], Stas Bekman >> <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >> Kopie:[EMAIL PROTECTED], [EMAIL PROTECTED] >> >> Thema:Re: [mp2] segfault when generating graphs with GD::Graph >> under Embperl >> >>> >>> If i call flow-graph.pl directly from the browser the page works!!! >>> >> How is the file run when you call it directly, as CGI or via >> Apache::Registry ? >> >> Gerald >> >> -- >> Gerald Richter ecos electronic communication services gmbh >> IT-Securitylösungen * dynamische Webapplikationen * Consulting >> >> Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz >> E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122 >> WWW:http://www.ecos.de/ Fax: +49 6133 939-333 >> -- >>> >>> ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info >>> >> +- >> >> *2* > > -- > Gerald Richter ecos electronic communication services gmbh > IT-Securitylösungen * dynamische Webapplikationen * Consulting > > Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz > E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122 > WWW:http://www.ecos.de/ Fax: +49 6133 939-333 > -- >> >> ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info >> > +- > > *1* -- Gerald Richter ecos electronic communication services gmbh IT-Securitylösungen * dynamische Webapplikationen * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122 WWW:http://www.ecos.de/ Fax:
Re: DBIx::Recordset andLongNames error
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.
There's a $set -> Begin. Not sure how to use it though as I'd prefer to begin
my transaction before any read, but I guess it's like this
my $set = DBIx::Recordset -> Search ({ %search });
$$set -> Begin;
updates, deletes and inserts
$$set -> Commit;
In the version I will release to CPAN today those functions are
implemented and
should be useable.
[ANNOUNCE] DBIx::Recordset 0.25 now on CPAN
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(), and Insert(). It was added in order that the SQL generated for the test "Order, Group, Append" would pass on Postgres which finds the generated SQL invalid. BUGFIXES (Angus Lees, Terrence Brannon, Gerald Richter) * when building the FROM clause for LEFT JOINs Recordset placed parentheses around it, like this: SELECT dbixrs1.id,dbixrs1.name,dbixrs1.value1,dbixrs1.addon,dbixrs2.value2 FROM (dbixrs1 left join dbixrs2 on dbixrs1.id = dbixrs2.id) WHERE dbixrs1.id IN (2, 5, 10); but this caused a syntax error in sqlite, so a new leftjoin type of 4 was introduced to support LEFT JOIN with no parentheses around the join * Fixed a bug that cause TableAttr with value zero not to work correctly. Patch from Rene Seindal * Made sure that filters given by name override filters given by type. * Fixed PreFetchIfExpires() so that it works for a specified time period as well as for a CODE ref * Added support to DBIx::Compat so that the pseudo-type "counter" was converted to SERIAL when DBD::Pg is in use * DBD::mysql versions > 2.9002 quote the table name. While is good and valid practice, the other drivers tested (SQLite and Pg) do not do this, making it difficult to create a consistent test suite. For the time being, a custom ListTablesMySQL was added to DBIx::Compat which strips the backquotes. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
