Re: escape '

2001-05-18 Thread barries
On Fri, May 18, 2001 at 01:56:29PM -0400, Ilia Lobsanov wrote: > the SQL way to escape ' is to use ''. > The preferred DBI way to escape things is to always use placeholders. > See perldoc DBI... or checkout DBIx::AbstractLite as an easier DBI alternative ala >$DB->query('SELECT * FROM foo WHERE

Re: escape '

2001-05-18 Thread Kee Hinckley
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At 5:41 AM -0700 5/18/01, E B wrote: >Hi > >I have a problem which I am sure there is an easy >solution to but I just can't find it. > >I use DBI and when I write to MySQL a string >containing ' (for example the word can't) I get this >error. As some

Re: escape '

2001-05-18 Thread Ilia Lobsanov
the SQL way to escape ' is to use ''. The preferred DBI way to escape things is to always use placeholders. See perldoc DBI... or checkout DBIx::AbstractLite as an easier DBI alternative ala $DB->query('SELECT * FROM foo WHERE bar = ?', $bar); ilia. On Fri, May 18, 2001 at 05:41:18AM -0700, E B

escape '

2001-05-18 Thread E B
Hi I have a problem which I am sure there is an easy solution to but I just can't find it. I use DBI and when I write to MySQL a string containing ' (for example the word can't) I get this error. [6631]ERR: 32: Line 157: Warning in Perl code: DBD::mysql::st execute failed: You have an error in

embperl 2.0 and sun cc

2001-05-18 Thread Michael Stevens
Hi. I'm trying to build embperl 2.0b3_dev-5 on cc: Sun WorkShop 6 2000/04/07 C 5.1 and perl 5.004_05, and getting compiler errors. Here's what I see: --cut here-- cc -c -I/usr/local/include -O-DVERSION=\"2.0b3_dev-5\" -DXS_VERSION=\"2.0b3_dev-5\" -Kpic -I/www/common/perl-builds/installs

Help! delay finishing pages

2001-05-18 Thread Edwin Ramirez
Hello, I am experiencing a strange behavior with Apache 1.3.19 & mod_perl/1.25 & Embperl 1.2.1. The pages are executed and served appropriately but the connection stays open for another 10-20 seconds at the end. If the stop button is pressed, it places a transfer interrupted. However, the

Re: Embperl & Postgres & Session

2001-05-18 Thread Robert
Robert wrote: > > ... > > Indeed, that's exactly what Apache::Session::Store::Postgres does... so, > Gerald, there's no need for Semaphore after all, is it? > > However, Angus complaints 11/5/01 that under Embperl, DESTROY is never > called and so no session is ever commited, but this is separa

Re: Embperl & Postgres & Session

2001-05-18 Thread Robert
Robert wrote: > > Gerald Richter wrote: > > > > > > > > > > When using %mdat you should not use NullLocker, because you need > > locking, > > > > otherwise you may get corrupted data, because multiple request can > > happen at > > > > the same time to the same page. > > > > > > I apparently don't

Re: Embperl & Postgres & Session

2001-05-18 Thread Robert
Gerald Richter wrote: > > > > > > > When using %mdat you should not use NullLocker, because you need > locking, > > > otherwise you may get corrupted data, because multiple request can > happen at > > > the same time to the same page. > > > > I apparently don't get it - I thought Postgres didn't

Re: Embperl & Postgres & Session

2001-05-18 Thread Gerald Richter
> > > > When using %mdat you should not use NullLocker, because you need locking, > > otherwise you may get corrupted data, because multiple request can happen at > > the same time to the same page. > > I apparently don't get it - I thought Postgres didn't need application > locking because it tak

Re: Embperl & Postgres & Session

2001-05-18 Thread Robert
Gerald Richter wrote: > > > I'm sorry for the opening discussion on sessions with postgres again. > > > > no problem! > > > I'm using Embperl with Postgres as its session management, > > > > when I uses $udat that is working OK, but using $mdat causes idle > > process and disable sessions > >

Re: Embperl & Postgres & Session

2001-05-18 Thread Gerald Richter
> I'm sorry for the opening discussion on sessions with postgres again. > no problem! > I'm using Embperl with Postgres as its session management, > > when I uses $udat that is working OK, but using $mdat causes idle > process and disable sessions > on server till server restart. looks like lo

Re: EmbperlObject Execute Order

2001-05-18 Thread Gerald Richter
> > The above works perfectly however it doesn't work in my project since I have all my functions in a seperate file. > I tried doing this in my page: > > [- $subs = $param[0] -] > [! sub getstatus { return $subs->status } !] > > But unfortunately I get the following error message: 'Can't call met

Re: embedding .pl references in html

2001-05-18 Thread Gerald Richter
> Hi, I was wondering if embperl could be used to call an existing script on > another server: > > i.e. > > > > other html here > [- Execute ('http://www.otherserver.com/cgi-bin/script.pl') -] > other html here > > > > The idea is to have the perl be executed and embeded into a table in the >

Re: Make test error with V1.3.2

2001-05-18 Thread Gerald Richter
Hi Lukas and Andy, thanks for the logfiles. Because of your logfiles I have found the problem. It only occurs with perl 5.6.0+. The reason is that Embperl cleans up %udat after the request with this Perl versions. The solution is to change the lines 1324 _and_ 1413 in Embperl.pm from $varfile