[GENERAL] getting nextval from query?

2001-07-28 Thread G.L. Grobe
To create a primary key for one of my session beans within the ejbCreate(), I'm doing a the following.     ... query = "SELECT NEXTVAL('versions_seq')";   pstmt = dbConn.prepareStatement(query);   rs = pstmt.executeQuery();   rs.next(); nu

Re: [GENERAL] "Oracle's ROWNUM"

2001-07-28 Thread Ryan Mahoney
I think you should look into the documentation for your particular interface. We generally use PHP as an interface. We use the pg_exec function to create an indexed result set from a connection and statement. Then we iterate through each indexed row, calling pg_fetch_array so we can manipul

Re: [GENERAL] Visual Basic and PostgreSQL ODBC

2001-07-28 Thread Andre Schnabel
- Original Message - From: "Mr. Shannon Aldinger" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 28, 2001 7:32 AM Subject: Re: [GENERAL] Visual Basic and PostgreSQL ODBC > -BEGIN PGP SIGNED MESSAGE- (...) > Two solutions use .EOF or .BOF on your recordset, or .M