[FX.php List] Adding records in FMSA7 - careful with calling scripts.

[FX]

Upon trying your suggestion, I discovered something else that might be  
important.

I cleared all the related fields from the layout, no change.  I then  
started to systematically remove  each 'AddDBParam' call.  The first  
one was a '-script' that actually wasn't functioning properly in 7 (of  
course was in 6).  I tested the script, which went to another external  
table, and once I made the script return to the existing table/layout  
of the FX page, the error disappeared.  The data was returned as  
expected.

Thanks!




On Dec 14, 2004, at 4:28 PM, Jason H.Awbrey wrote:

> The problem seems to be when you are referencing a layout with related  
> fields. If there is no related record but the related fields exist on  
> the layout, you will get this error. Wrapping the related fields in a  
> portal seems to fix the problem.
>
> HTH,
> Jason H. Awbrey
> StravinSOFT, Incorporated
> http://www.stravinsoft.com
>
>
> On Dec 14, 2004, at 3:21 PM, FX wrote:
>
>> I have several applications running well in 6, and have spent days  
>> working through the "quarks" of 7.
>>
>> Here is an error I get when trying to add a record - works in 6...
>>
>> Accessing FileMaker Pro 7 data.
>>
>> Using FileMaker URL:  
>> http://127.0.0.1:80/fmi/xml/FMPXMLRESULT.xml?-db=wcamper&-lay=web&- 
>> max=50&firstName=John&lastName=Dessen&add1=420+East+Sussex+Road&add2=& 
>> city=La+Presa&st=CA&zip=92022&country=USA&dobMonth=Month&dobDay=Day&do 
>> bYear=&school=&grade=&camp=ayc&pid=4001&-script=createReg&-new
>>
>> // the above code gets a XML PARSING ERROR when pasted in the URL.
>>
>> i find records and update them with the same page...
>>
>> Warning: Cannot use a scalar value as an array in  
>> /Library/WebServer/web/ycamp7/information.php on line 29
>>
>> Warning: current(): Passed variable is not an array or object in  
>> /Library/WebServer/web/ycamp7/information.php on line 29
>>
>>
>> fx_error Object (  [error_message_prefix] => [mode] => 1  [level] =>  
>> 1024  [code] => 100  [message] => FX: ExecuteQuery XML error: no  
>> element found at line 2 [userinfo] => [backtrace] => Array  (  [0] =>  
>> Array  (  [file] => /Library/WebServer/web/ycamp7/inc/FX.php  [line]  
>> => 894  [function] => fx_error  [class] => fx_error [type] => ->   
>> [args] => Array  (  [0] => ExecuteQuery XML error: no element found  
>> at line 2  )  )  [1] => Array  (  [file] =>  
>> /Library/WebServer/web/ycamp7/inc/FX.php [line] => 1056  [function]  
>> => executequery  [class] => fx  [type] => ->  [args] => Array  (  [0]  
>> => -new  )  )  [2] => Array  (  [file] =>  
>> /Library/WebServer/web/ycamp7/inc/FX.php  [line] => 1122  [function]  
>> => fmaction  [class] => fx  [type] => ->  [args] => Array  (  [0] =>  
>> -new  [1] => 1  [2] => full  ) )  [3] => Array  (  [file] =>  
>> /Library/WebServer/web/ycamp7/information.php  [line] => 28   
>> [function] => fmnew  [class] => fx  [type] => ->  [args] => Array  (   
>> )  )  ) [callback] => )
>>
>> Can anyone glance at this and share any thoughts?  Thanks!
>>
>> _________________
>> Michael Layne
>> 9 degrees development
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
_________________
Michael Layne
9 degrees development
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 4028 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20041214/2fcc4de9/attachment.bin