[FX.php List] Adding records in FMSA7

Michael Layne fx at 9degrees.com
Thu Dec 16 06:11:36 MST 2004


Sorry, I'll post the code from now on.  it ended up being a script that  
broke upon migrating to FM7.  I was calling a script:

AddDBParam('-script','createReg');

when I removed the line, all worked.  then debugging the script in FM7,  
the script went to an external table/layout and never returned.  once I  
corrected the problem in FM, the FX call worked.

Thanks.

On Dec 16, 2004, at 5:26 AM, Gjermund Gusland Thorsen wrote:

> Would be great if you posted the code that has the problem...
> The code that makes the faulty object, i. e.
>
>
> On Tue, 14 Dec 2004 15:28:38 -0600, Jason H. Awbrey
> <jason at stravinsoft.com> 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= 
>>> &c
>>> ity=La+Presa&st=CA&zip=92022&country=USA&dobMonth=Month&dobDay=Day&do 
>>> bY
>>> ear=&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
>>
>>
>>
>>
> _______________________________________________
> 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: 3657 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20041216/4c6ed50f/attachment.bin


More information about the FX.php_List mailing list