[TYPO3-irre] One table four times related in the same table as inline element
ri_beeli at web.de
ri_beeli at web.de
Mon Oct 6 21:24:29 CEST 2008
hey guys out there,
the title says almost everything...
The current situation...
I have the following tables:
tx_..._hotel
tx_..._txtboxes
Now the tx_..._hotel table contains the following columns (type is inline):
hotel_tab_hoteldetails
hotel_tab_bedrooms
hotel_tab_prices
hotel_tab_destination
All these columns contains the following config (tca.php):
"config" => Array (
"type" => "inline",
"foreign_table" => "tx_..._txtboxes",
"foreign_field" => "parentid",
"foreign_table_field" => "parenttable",
"foreign_sortby" => "sorting",
"foreign_label" => "txtbox_title",
"maxitems" => 20,
"appearance" => array (
"newRecordLinkAddTitle" => 1,
"expandSingle" => 1,
"useSortable" => 1,
),
),
Here the structure of the tx_..._txtboxes table:
#
# Table structure for table "tx_..._txtboxes"
#
CREATE TABLE tx_..._txtboxes (
uid int(11) NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
parenttable varchar(255),
parentid int(11) default '',
sorting int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
crdate int(11) NOT NULL default '0',
cruser_id int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
l18n_parent int(11) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL,
txtbox_title varchar(255),
txtbox_type int(11) NOT NULL default '0',
txtbox_text text NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
Everything works fine, but when I create a new record let's say in hotel_tab_destination, then the record is in every column (hotel_tab_hoteldetails, hotel_tab_bedrooms, hotel_tab_prices, hotel_tab_destination) in tx_..._hotel in the backend visible. That's logical because of the parentid and of course because they all have the same configuration.
Now, what do I have to do, that each "column" of these four inline element has its own txtboxes?
Any keywords for me?
Thank you!
________________________________________________________________________
"50 erste Dates" mit Adam Sandler u. Drew Barrymore kostenlos anschauen!
Exklusiv für alle WEB.DE Nutzer. http://www.blockbuster.web.de
More information about the TYPO3-project-irre
mailing list