when I need to get the next value of a sequence, the system doesn't respond.
I use this code:
Expand|Select|Wrap|Line Numbers
- public function nextSequenceId($sequenceName)
- {
- $this->_connect();
- $value = $this->fetchOne('SELECT '.new Zend_Db_Expr('nextval(\'"'.$sequenceName.'"\')'));
- return $value ;
- }
1- when I use the statement in pgadminIII:
Expand|Select|Wrap|Line Numbers
- SELECT nextval('"SEQ_QUT_QUOTATION"')
2- all objects in my database have names in capital letters, so I can't access to them with out double quotes.
may any one help me to fix this issue?
THANKS.