Re: Rows returned are out of sync with the request.

2006-08-25 Thread Jared Still
On Tue, 2006-08-22 at 16:11 -0700, Stephen Carville wrote: I'm not quite sure how to describe this problem. When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. Is the Oracle version 10.2? Are

Re: Rows returned are out of sync with the request.

2006-08-25 Thread Stephen Carville
Jared Still wrote: On Tue, 2006-08-22 at 16:11 -0700, Stephen Carville wrote: I'm not quite sure how to describe this problem. When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. Is the Oracle

Re: Rows returned are out of sync with the request.

2006-08-23 Thread Dr.Ruud
Stephen Carville schreef: When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. For example, If I send the following: select a.statid, b.webstatdesc, a.pendid, c.penddesc, a.certno,

RE: Rows returned are out of sync with the request.

2006-08-23 Thread Garrett, Philip \(MAN-Corporate\)
Stephen Carville wrote: I'm not quite sure how to describe this problem. When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. What happens when you use DBI *without* SQLRelay? Philip

Re: Rows returned are out of sync with the request.

2006-08-23 Thread Stephen Carville
Dr.Ruud wrote: Stephen Carville schreef: When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. For example, If I send the following: select a.statid, b.webstatdesc, a.pendid, c.penddesc, a.certno,

Re: Rows returned are out of sync with the request.

2006-08-23 Thread Stephen Carville
Garrett, Philip (MAN-Corporate) wrote: Stephen Carville wrote: I'm not quite sure how to describe this problem. When I make a call to an Oracle 10g database using DBI and SQLRelay (for connection pooling) I seem to get results from the previous SELECT. What happens when you use DBI

Re: Rows returned are out of sync with the request.

2006-08-23 Thread Dr.Ruud
Stephen Carville schreef: Dr.Ruud: The tranid and certno in your where don't have table identifiers. If you assume that the result is one record, check for more. I didn't know that dropping the table ids could make a difference. I'll try adding them. Thanks. They shouldn't make a

Re: Rows returned are out of sync with the request.

2006-08-23 Thread Stephen Carville
Dr.Ruud wrote: Stephen Carville schreef: Dr.Ruud: I've been reviewing the sqltrace logs and I thinks this may be a case where safe signals are biting me in the butt. - prepare for DBD::SQLRelay::db (DBI::db=HASH(0x8e05078)~0x8de04f4 'select a.statid, b.webstatdesc, a.pendid,