[TYPO3-dev] IRRE - processDatamap_afterDatabaseOperations

[Ingmar Schlecht]

Hi Brian,

without having looked into your issue in detail: Try using the new hook 
in TYPO3 4.2 called processDatamap_afterAllOperations.

cheers
Ingmar

Brian Bendtsen schrieb:
> Hi
> 
> This one is hard to explain, but here goes...
> 
> I need to update a table when I create another, therefore I use the 
> processDatamap_afterDatabaseOperations hook.
> 
> Lets say Im making a hotel application and have 3 tables:
> 
> Room(uid, size, facilities, section ...)
> Bed(uid, room, size ...) - room is foreign key
> Stats(uid, section, numberOfBeds ...)
> 
> I have an IRRE between Room and Bed, so its possible to create/delete 
> beds from editing a room.
> 
> When I add a bed to a room I want to update the stats table, which holds 
> the number of beds in different sections of a hotel.
> 
> If I create a bed item the traditional way, where I choose a 
> room(foreign key), size and so on everthing runs as it should, but if I 
> create the bed from within the room, thereby setting the room 
> automatically it fails.
> 
> The first thing I do in my function is fetching the room like this:
> 
> $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('Bed.room, Bed.size', 
> 'Bed','Bed.uid ='.$id);
> 
> Apparently, when using IRRE the Bed.room returns a 0 but Bed.size 
> returns the correct value.
> 
> When not using IRRE to create a Bed, Bed.room is returning the correct 
> value.
> 
> I cant quite grasp what the problem is.
> 
> Any hints?
> 
> /Brian


-- 
Ingmar Schlecht
TYPO3 Association Active Member