[FX.php List] Re: Mysterious asterisks appearing in fields

Fri Mar 9 11:42:32 MST 2007

Okay, I have simplified all the HTML, the FX query, and the FileMaker
database to their absolute bare-bones necessities, and I am still
getting the asterisk problem. I have no idea what else to check, as it
really seems to me as if something is happening between FX and
FileMaker. I am pasting all the code and a print_r() of the resulting
data array below. Does anyone see anything wrong with my code? Also,
note that the asterisks are in the array, but not in the FileMaker
URL... Is that significant? Thanks, yet again, to anyone with ideas.
--Chris Bisgard

----------
FORM PAGE:
----------

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>

<body>
<form id="clp" name="clp" method="post" action="submit.php">
Name of Organization: <input name="OrgName" type="text"
id="OrgName"><br>
Your Name:<input name="OrgContact" type="text" id="OrgContact"><br>
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

------------
SCRIPT PAGE:
------------

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
include_once("/inetpub/wwwroot/FX/FX.php");
include_once("/inetpub/wwwroot/FX/server_data.php");
include_once("/inetpub/wwwroot/FX/FMErrors.php");
$q=new FX( $serverIP, $webCompanionPort ); 
$q->setDBData( 'CLPtest', 'Web' ); 
$q->AddDBParam( 'OrgName', $_POST['OrgName'] ); 
$q->AddDBParam( 'OrgContact', $_POST['OrgContact'] ); 
$r=$q->FMNew();
?>
</head>

<body>
<h4>POST data:</h4>
<p>Organization Name: <?php echo $_POST['OrgName']; ?><br>
Organization Contact: <?php echo $_POST['OrgContact']; ?></p>
<h4>Contents of "$r" array:</h4>
<pre><?php print_r($r); ?></pre>
</body>
</html>

--------------
RESULTS ARRAY:
--------------

Array
(
    [data] => Array
        (
            [402.0] => Array
                (
                    [OrgName] => Array
                        (
                            [0] => *RACC*
                        )

                    [OrgContact] => Array
                        (
                            [0] => *Chris Bisgard*
                        )

                )

        )

    [linkNext] => 
    [linkPrevious] => 
    [foundCount] => 1
    [fields] => Array
        (
            [0] => Array
                (
                    [emptyok] => YES
                    [maxrepeat] => 1
                    [name] => OrgName
                    [type] => TEXT
                    [extra] => 
                )

            [1] => Array
                (
                    [emptyok] => YES
                    [maxrepeat] => 1
                    [name] => OrgContact
                    [type] => TEXT
                    [extra] => 
                )

        )

    [URL] =>
http://192.168.0.7:80/fmi/xml/FMPXMLRESULT.xml?-db=CLPtest&-lay=Web&-max
=50&OrgName.op=cn&OrgName=RACC&OrgContact.op=cn&OrgContact=Chris+Bisgard
&-new
    [query] => 
    [errorCode] => 0
    [valueLists] => Array
        (
        )

)

---------
   END
---------