Hello, I have an application, which does something like this:
In the first cfml file (file1.cfm), a new database entry is created where the sequence number is created using ".nextval" in the SQL query. A few following SQL queries in the same file use ".currval" to reference the same number and insert values to other tables. After finishing this task. A popup window will be opened with a second cfml file (file2.cfm), which directly uses ".currval" to reference back to the created database entry. In this popup window, I now get a SQL Error: ORA-08002: sequence T_REQUEST_SEQ.CURRVAL is not yet defined in this session This application worked well with Adobe Coldfusion. For me it seems like Coldfusion somehow opened one "global session" on the database which exists between requests but OpenBD opens one session per page request, right? Is it possible to change this configuration, so a global DB session is created on OpenBD or is it better to rewrite my code to pass the database ID via HTTP GET parameter? Mit freundlichen Grüßen / Best regards Manuel Reimer Tel. 09352/18-1578 -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
