On Wednesday 16 April 2008 17:35, Bas Scheffers wrote:
> On 17/04/2008, at 9:25 AM, Tom Jackson wrote:
> > Your script/page level code can remain unchanged even when you switch
> > databases.
>
> That looks more like an OR mapping framework. I think that is a good
> thing to have also but to me it
On Apr 16, 2008, at 8:37 PM, Bas Scheffers wrote:
It is the obvious way to do it. I would suspect that the OpenACS
team decided to mimic Oracle behavior simply to lower the amount of
re-writing of existing queries to be done. Which is perfectly valid
for their goal and how I would likely hav
Uhm, yes, possible. :)
On 17/04/2008, at 12:54 PM, Michael A. Cleverly wrote:
On Wed, Apr 16, 2008 at 5:20 PM, Bas Scheffers <[EMAIL PROTECTED]>
wrote:
On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
I don't really like bind variables, I would much rather see it
implemented
like:
ns_db s
Message
From: Bas Scheffers <[EMAIL PROTECTED]>
To: AOLSERVER@LISTSERV.AOL.COM
Sent: Wednesday, April 16, 2008 4:20:46 PM
Subject: Re: [AOLSERVER] aolserver and Pgtcl
On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
I have wanted to add bind variable support to nsdb for a _long_ time,
but
On Wed, Apr 16, 2008 at 5:20 PM, Bas Scheffers <[EMAIL PROTECTED]> wrote:
> On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
>
> I don't really like bind variables, I would much rather see it implemented
> like:
>
> ns_db select $db "select * from people where country = $1 and age > $2"
> [list "
The other is performance.
Jade
On Wed, Apr 16, 2008 at 5:40 PM, Bas Scheffers <[EMAIL PROTECTED]> wrote:
> I would never say that; not having to worry about quoting is one of the
> main advantages of using bind variables/parameters.
>
> Bas.
>
>
>
> --
> AOLserver - http://www.aolserver.com/
>
>
This is how pgtcl actually does bind variables...
- Original Message
From: Bas Scheffers <[EMAIL PROTECTED]>
To: AOLSERVER@LISTSERV.AOL.COM
Sent: Wednesday, April 16, 2008 4:20:46 PM
Subject: Re: [AOLSERVER] aolserver and Pgtcl
On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
&g
On 17/04/2008, at 9:10 AM, Don Baccus wrote:
ns_db select $db "select * from people where country = $1 and age >
$2" [list "au" 25]
Geez, names are more readable than numbers in any sizable query.
The numbers/names isn't that important to me. What is important is
that I would like to see vari
On 17/04/2008, at 9:25 AM, Tom Jackson wrote:
Your script/page level code can remain unchanged even when you switch
databases.
That looks more like an OR mapping framework. I think that is a good
thing to have also but to me it is separate from having bind variables
in the core nsdb api. I wo
On Wednesday 16 April 2008 16:20, Bas Scheffers wrote:
> I don't really like bind variables, I would much rather see it
> implemented like:
> ns_db select $db "select * from people where country = $1 and age >
> $2" [list "au" 25]
You can look at the examples in my recent post. It works with pl
On Apr 16, 2008, at 4:20 PM, Bas Scheffers wrote:
On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
I have wanted to add bind variable support to nsdb for a _long_ time,
but never got around to computing this support matrix that I describe
above.
I don't really like bind variables, I would much r
On 17/04/2008, at 8:14 AM, Dossy Shiobara wrote:
I have wanted to add bind variable support to nsdb for a _long_ time,
but never got around to computing this support matrix that I describe
above.
I don't really like bind variables, I would much rather see it
implemented like:
ns_db select $db
On Apr 16, 2008, at 3:44 PM, Dossy Shiobara wrote:
I have wanted to add bind variable support to nsdb for a _long_ time,
but never got around to computing this support matrix that I describe
above.
If you do, it needs to be a config option, because with Oracle you do
*not* want to do this i
On Wednesday 16 April 2008 15:11, Don Baccus wrote:
> On Apr 16, 2008, at 2:33 PM, Tom Jackson wrote:
> > You should look at the pg driver, I think it can emulate bind
> > variables, or
> > maybe it is part of the db_* API of OpenACS.
>
> You have to compile nspostgres.c for OpenACS use to make the
On 2008.04.16, Tom Jackson <[EMAIL PROTECTED]> wrote:
> In general, bind variables is something which is handled by the
> driver, because there is no standard on how to do it. Some use ?, some
> use :varname.
Can someone please help by doing the necessary research and put together
a matrix of supp
On Apr 16, 2008, at 2:33 PM, Tom Jackson wrote:
You should look at the pg driver, I think it can emulate bind
variables, or
maybe it is part of the db_* API of OpenACS.
You have to compile nspostgres.c for OpenACS use to make the command
available.
Then use ns_pg_bind rather than ns_db.
You should look at the pg driver, I think it can emulate bind variables, or
maybe it is part of the db_* API of OpenACS.
I also have a wrapper API for ns_db which has more of a stored procedure type
API.
Here is a link to an example application:
http://junom.com/gitweb/gitweb.perl?p=twt.git;
Hi Brett,
Thanks for the message.
I just wanted to try it with pgtcl.
My problem with the underlying db api in aolserver is that there is no
mechanism for binding variables to an SQL statement, e.g:
set sql {
select
*
from
table
where
status = ?
}
There is no
I think the ns_odbc driver can survive from one connection to another. When I
use it, I have to put in a trace filter to close/return the handle.
I can't imagine that it is a good idea to just randomly reuse an open handle.
You risk running out of handles for one, but the state of the connectio
> Hi,
>
> I know aolserver comes with postgres support, but I would like to use
> the Pgtcl library for a project.
> Has anybody managed to use Pgtcl and keep a persistent connection to
> the database that can be re-used by the requests coming in, or do you
> have to keep opening a connection to t
Hi,
I know aolserver comes with postgres support, but I would like to use
the Pgtcl library for a project.
Has anybody managed to use Pgtcl and keep a persistent connection to
the database that can be re-used by the requests coming in, or do you
have to keep opening a connection to the db, query t
21 matches
Mail list logo
