[FX.php List] FMNew adds two records?

[Jon Montgomery]

Chris,
    I turned on DEBUG and here is the url:

http://@66.99.104.15/fmi/xml/FMPXMLRESULT.xml?-db=IGSMA_SE.fp7&-lay=IGSMA_SE
&-max=1&School_ID=9998&Event_web=201+Piccolo+Solo&Title=&Class=A&SPPerTime=N
o&State_Choice=Yes&State_Site=&Accompanist=&St_First%5B1%5D=Test+in+Fire+Fox
&St_First%5B2%5D=&St_First%5B3%5D=&St_First%5B4%5D=&St_First%5B5%5D=&St_Firs
t%5B6%5D=&St_First%5B7%5D=&St_First%5B8%5D=&St_First%5B9%5D=&St_First%5B10%5
D=&St_First%5B11%5D=&St_First%5B12%5D=&St_First%5B13%5D=&St_First%5B14%5D=&S
t_First%5B15%5D=&St_First%5B16%5D=&St_First%5B17%5D=&St_First%5B18%5D=&St_Fi
rst%5B19%5D=&St_First%5B20%5D=&St_First%5B21%5D=&St_First%5B22%5D=&St_First%
5B23%5D=&St_First%5B24%5D=&St_First%5B25%5D=&St_Last%5B1%5D=&St_Last%5B2%5D=
&St_Last%5B3%5D=&St_Last%5B4%5D=&St_Last%5B5%5D=&St_Last%5B6%5D=&St_Last%5B7
%5D=&St_Last%5B8%5D=&St_Last%5B9%5D=&St_Last%5B10%5D=&St_Last%5B11%5D=&St_La
st%5B12%5D=&St_Last%5B13%5D=&St_Last%5B14%5D=&St_Last%5B15%5D=&St_Last%5B16%
5D=&St_Last%5B17%5D=&St_Last%5B18%5D=&St_Last%5B19%5D=&St_Last%5B20%5D=&St_L
ast%5B21%5D=&St_Last%5B22%5D=&St_Last%5B23%5D=&St_Last%5B24%5D=&St_Last%5B25
%5D=&extra_perf=&-new

On 1/19/08 10:49 AM, "Chris Hansen" <chris at iViking.org> wrote:

> define('DEBUG', true); // this goes at the top of your query page
> 
I am getting an error when trying to go to the link above.  A second FMView
on my page works fine however.  I have screen shots if you need to see them.

> That will allow you to see if an XML query does the same thing, and
> also see if two queries are being performed somewhere.
> 
> Jon, can we have a look at your code?  Best,

Here is the code.  It is long with one field having 25 repeats.  I hope to
fix that in the next data base redesign.  This started out in FMP 4 and just
got UPDATED but not modified so it is mostly still a FLAT file.  That will
change but for now, it works with the exception of the double records, one
with data and one without.

Please note that Safari DOES NOT CREATE TWO Records, just ONE.  FireFox
creates ONE with DATA and ONE without data.

Code:
Attached PDF has the code.

In my other site, which does the same thing as this page, all works fine
including the DEBUG view.  So I must have some faulty code.  This page was
copy and pasted from the other site I believe, with the modifications to the
field names. 

It is late and not sure I am making since.  Hope the pictures and PDF files
help.

Thanks in advance!

Jon Montgomery

-------------- next part --------------
A non-text attachment was scrubbed...
Name: igsma_add_result.php (XHTML).pdf
Type: application/octet-stream
Size: 77139 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20080120/104e99ff/igsma_add_result.phpXHTML-0001.obj