Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 27

  Posted: Dec 07, 2005 - 10:45 PM

  hi,
  
  I use Example module to write a custom module but the $dbconn->GenId(...) always returns 0 (in my module as in Example module).
  
  I saw a hack by Larsneo in :
  /includes/classes/adodb/drivers/adodb-mysql.inc.php
  and the explanation in:
  /includes/classes/adodb/readme_postnuke.txt
  
  But why using $dbconn->GenId(...) if it always return 0 ???
  
  I need to know the item id I insert in database. How to do that without calling GenId() ?
  
  chaKal

  • 
  •  
• markwest
  
  

  • Rank: Team Member
  • Registered: Mar 18, 2002
  • Last visit: Oct 21, 2009
  • Posts: 6606

  Posted: Dec 09, 2005 - 11:47 AM

  You're recommended to use this code becuase certain databases don't have auto-increment fields but use sequences instead. One example is oracle. However mysql has auto-increment fields so the GenID method of adodb has no effect when used on a mysql DB.
  
  If you follow the example module code further you'll see that the inserted id is calculated later using the PO_Insert_ID method.
  
  -Mark
  
  --
  Visit My homepage and Zikula themes.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 27

  Posted: Dec 11, 2005 - 10:24 PM

  ok,
  thank mark
  
  chaKal

  • 
  •  
•  
•  

Users on-line

• DirkThiele,
• Paustian,
• jmvaughn,
• mdee

This list is based on users active over the last 60 minutes.