Hi,
sorry for the delay but the phone in my new flat don't work until yet.
So I can read my mail only if I'm at work (only twice a week because I
prepare an examen).
[EMAIL PROTECTED] wrote:
> LLLLLLLLLLLLLLLLLLLLLLLLLLLLLL.....### new function call ###
> Entering function searchItems
This function (searchItems) brings the real data
> ### new function call ###
> Entering getArguments
> attribute: KEY
> value:
> attribute: STATUS
> value:
> attribute: DN
> value:
> attribute: CN
> value:
> attribute: EMAIL
> value:
> attribute: RA
> value:
> attribute: OPERATOR
> value:
> attribute: ROLE
> value:
> ### new function call ###
> Entering getStatus
> no status given using datatype: PENDING_REQUEST
> given mode is: "PENDING"
> legal status
> ### leaving function successful ###
> status: PENDING
> completed successful
> ### leaving function getArguments ###
> dbi-status:PENDING
> query now:select * from request
> scan attribute: KEY
> scan attribute: STATUS
> attribute's content: PENDING
> scan attribute: DN
> scan attribute: CN
> scan attribute: EMAIL
> scan attribute: RA
> scan attribute: OPERATOR
> scan attribute: ROLE
> query:select * from request where (status like ?)
The query is correct.
> ### new function call ###
> Entering sub doConnect
> status: 0
> errors: 0
> connect never failed so using standard
> DSN STANDERD= dbi:Oracle:PKI1 Databasetype:Oracle
> try to connect
> function succeeded
> ### leaving function doConnect successfully ###
> ### new function call ###
> Entering sub doQuery
> query: select * from request where (status like ?)
> bind_values: 'PENDING'
> prepare statement
> statement nr.: 1
> execute statement
> execute succeeded
> ### leaving function doQuery successfully ###
> XXXXXXXXX 1 XXXXXXXXXXX state(false is OK):
> rows: 0
The database returns no results!
> baha baha baha baha function searchItems completed successful
> ### leaving function searchItems ###
Questions:
* are there any requests in the database (check this please
directly via a databaseinterface)
* is status of a request in the database PENDING (-"-)
* are the table- or columnnames of Oracle casesensitive
Michael
P.S. is the DSN correct (dbi:Orcale:PKI1 Databasetype:Oracle)? The last
Oracle looks a little bit suspect - but I never seen an Oracle-DB. I
read my mail at least tomorrow :-D
-------------------------------------------------------------------------
Michael Bell Email: [EMAIL PROTECTED]
Rechenzentrum - Datacenter Email (work):
[EMAIL PROTECTED]
Humboldt-University of Berlin Tel.(work): +49 (0)30-2093 2482
Unter den Linden 6 Fax.(work): +49 (0)30-2093 2959
10099 Berlin
Germany [OpenCA Core
Developer]
http://openca.sourceforge.net
_______________________________________________
Openca-Users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-users
