FMNew dont work to relational table?

[bondansentanu]

dear fm gurus

i want to add new record through php using fx..

in my fm layout, the fields are from 2 different tables..

i made explicit field name adddbparam in my php to point the field from other table. it worked before but i dont know why right now it doesnt.

$insert = new FX($serverIP, $webCompanionPort, $dataSourceType);             

$insert->SetDBData($dbName,$layoutName);          

$insert->SetDBUserPass ($webUN,$webPW);                	



$insert->AddDBParam('FirstName', $fname);

$insert->AddDBParam('LastName', $lname);		

$insert->AddDBParam('EmailAddress', $email);		

$insert->AddDBParam('BusinessPhone', $phone);	

$insert->AddDBParam('Reservation_Information::check_in_date', $checkin);	



$ReturnedData = $insert->FMNew();

if i remove the $insert->AddDBParam('Reservation_Information::check_in_date', addslashes($checkin)); line, its working..so, the problem is only the relational table.

any idea? please help

Edited March 24, 2010 by Guest