Re: [PEAR] More DB_DataObject problems...

i think, we have to use table_* when we use multiple base that own the
same table name, if not you can just enter :

[DB_DataObject]
; PEAR::DB DSN
database_hardware = mysql://xxxxxx:xxxxxx@localhost/hardware
database_userdb	= mysql://xxxxxx:xxxxxx@localhost/userdb
database_supportdb = mysql://xxxxxx:xxxxxx@localhost/supportdb
schema_location = /srv/www/htdocs/prj/DataObject
class_location  = /srv/www/htdocs/prj/DataObject
require_prefix 	= DataObjects/
class_prefix   	= DataObjects_
proxy		= FULL
dont_die 	= false

regards.


Ian a écrit :

>I've tried it in the following two ways...........
>
>[DB_DataObject]
>; PEAR::DB DSN
>database_hardware         		=
>mysql://xxxxxx:xxxxxx@localhost/hardware
>table_hardware_catagory			= hardware
>sequence_hardware_catagory		= hw_cat_id
>table_hardware_index     		= hardware
>sequence_hardware_index			= hardware_index_id
>table_hardware_models     		= hardware
>sequence_hardware_models		= hardware_model_id
>table_hardware_manufacturer		= hardware
>sequence_hardware_manufacturer	= manufacturer_id
>
>
>database_userdb					=
>mysql://xxxxxx:xxxxxx@localhost/userdb
>table_users						= userdb
>sequence_users					= user_id
>table_user_locations			= userdb
>sequence_user_locations			= user_location_id
>table_locations					= userdb
>sequence_location_id			= location_id
>table_assigned_hardware			= userdb
>sequence_assigned_hardware		= assigned_hardware_id
>
>
>database_supportdb				=
>mysql://xxxxxx:xxxxxx@localhost/supportdb
>table_user_issues				= supportdb
>sequence_user_issues			= user_issue_id
>table_support_type				= supportdb
>sequence_support_type			= support_type_id
>table_support_index				= supportdb
>sequence_support_index			= support_index
>table_module_index				= supportdb
>sequence_module_index			= modules_id
>table_issue_index				= supportdb
>sequence_issue_index			= issue_log_id
>
>
>schema_location  				=
>/srv/www/htdocs/prj/DataObject
>class_location   				=
>/srv/www/htdocs/prj/DataObject
>require_prefix   				= DataObjects/
>class_prefix     				= DataObjects_
>proxy							= FULL
>dont_die 						= false
>
>
> ========================================
===========================
>
>And this way..........
>
>
>[DB_DataObject]
>; PEAR::DB DSN
>database_hardware         		=
>mysql://xxxxxx:xxxxxx@localhost/hardware
>database_userdb					=
>mysql://xxxxxx:xxxxxx@localhost/userdb
>database_supportdb				=
>mysql://xxxxxx:xxxxxx@localhost/supportdb
>
>table_hardware_catagory			= hardware
>sequence_hardware_catagory		= hw_cat_id
>
>table_hardware_index     		= hardware
>sequence_hardware_index			= hardware_index_id
>
>table_hardware_models     		= hardware
>sequence_hardware_models		= hardware_model_id
>
>table_hardware_manufacturer		= hardware
>sequence_hardware_manufacturer	= manufacturer_id
>
>table_users						= userdb
>sequence_users					= user_id
>
>table_user_locations			= userdb
>sequence_user_locations			= user_location_id
>
>table_locations					= userdb
>sequence_location_id			= location_id
>
>table_assigned_hardware			= userdb
>sequence_assigned_hardware		= assigned_hardware_id
>
>table_user_issues				= supportdb
>sequence_user_issues			= user_issue_id
>
>table_support_type				= supportdb
>sequence_support_type			= support_type_id
>
>table_support_index				= supportdb
>sequence_support_index			= support_index
>
>table_module_index				= supportdb
>sequence_module_index			= modules_id
>
>table_issue_index				= supportdb
>sequence_issue_index			= issue_log_id
>
>schema_location  				=
>/srv/www/htdocs/prj/DataObject
>class_location   				=
>/srv/www/htdocs/prj/DataObject
>require_prefix   				= DataObjects/
>class_prefix     				= DataObjects_
>proxy							= FULL
>
>
>(sorry about the mess!)
>
>
>
>-----Original Message-----
>From: foxmask [mailto:foxmask@gmail.com]
>Sent: 26 March 2005 18:05
>To: Ian
>Subject: Re: [PEAR] More DB_DataObject problems...
>
>what does the ini file look like ?
>
>
>On Sat, 26 Mar 2005 18:05:03 -0000, Ian <zen54565@zen.co.uk> wrote:
>
> 
>data
>
> 
>
>
>
>


--