[AOLSERVER] Retrieving oid from INSERT

2006-03-28 Thread William Scott Jordan
Hi all! Is there any way to get the oid or any other row identifier from a database insert with ns_db on Postgres? Say for example I have the following table: CREATE TABLE test ( test_column int ) ; And then I do an insert with aolserver, along the lines of: ns_db dml $db INSERT INTO test

[AOLSERVER] Design for a framework

2006-03-28 Thread Wojciech Kocjan
Hello everyone, Lately I've been wondering about a new framework for AOLserver web applications. Term package below is used to describe on-demand loaded Tcl code, where one package usually serves one application, where usually one application resides per one domain. The previous model is

Re: [AOLSERVER] Retrieving oid from INSERT

2006-03-28 Thread Janine Sisk
The way we do this in OpenACS is to have a primary key in each table that is populated from a sequence. So in your code you get the next number from the sequence, do the insert (storing the number in the primary key column), and then you have that number already in your possession to use