[FX.php List] Searching...
FX
fx at 9degrees.com
Mon Dec 13 10:21:49 MST 2004
I was having the same problem. I knew data was there, and the
"FMPXMLRESULT.xml" string, when submitted alone returned '0' (no
problems.)
my ID I was looking for was a number field in FM7. I changed it to
'text', and everything worked.
Try changing your number fields to text fields that are involved in
search parameters (FMFind())
On Nov 22, 2004, at 6:09 PM, Baard Belsaas wrote:
> It is planed that you schoud log in with IDnr and Fodt (born-date).
> But this
> is not in work yet because I get this trole for searching
> number-fields.
>
> Here is my code:
> <?php
> include_once('FX/FX.php');
> include_once('FX/FMErrors.php');
> include_once('FX/server_data.php');
>
> $IDnr=$_POST['IDnr'];
> $Fodt=$_POST['Fodt'];
>
> $search=new FX($serverIP,$webCompanionPort);
> $search->setDBData('Medlemsbase.fp7','web');
> $search->AddDBParam('IDnr',$IDnr);
> $searchResult=$search->FMFind();
> ?>
> </head>
>
> <body>
> <?php
> include_once("includes/header.php");
> ?>
>
> Found Count: <?php echo $searchResult['foundCount']; ?><br>
> Error: <?php echo $searchResult['errorCode']; ?><br>Søk: <?php
> echo
> $IDnr; ?> <br>
> Født: <?php echo $Fodt; ?>
> <?php
> include_once("./includes/search_result_yes.php");
> ?>
>
>
> The include-file is this:
> <?php
> foreach($searchResult['data'] as $key=>$searchData) {
> ?>
> <table width="250" border="1" cellspacing="2" cellpadding="0">
> <tr>
> <td width="100">
> <div align="right">
> <b>IDnr</b></div>
> </td>
> <td><?php echo $searchData['IDnr'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Født</b></div>
> </td>
> <td><?php echo $searchData['Fodt'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Type medlem</b></div>
> </td>
> <td><?php echo $searchData['Type_medlem'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Navn</b></div>
> </td>
> <td><?php echo $searchData['Navn'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Medlems adresse</b></div>
> </td>
> <td><?php echo $searchData['Medlem_adresse'] [0];
> ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Postnummer</b></div>
> </td>
> <td><?php echo $searchData['Postnr'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Poststed</b></div>
> </td>
> <td><?php echo $searchData['Poststed'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Land</b></div>
> </td>
> <td><?php echo $searchData['Land'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Mobil</b></div>
> </td>
> <td><?php echo $searchData['Mobil'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Telefon privat</b></div>
> </td>
> <td><?php echo $searchData['Tlf_priv'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Arbeidsgiver</b></div>
> </td>
> <td><?php echo $searchData['Arbeidsgiver'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Arbeidssted</b></div>
> </td>
> <td><?php echo $searchData['Arbeidssted'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Telefon arbeide</b></div>
> </td>
> <td><?php echo $searchData['Tlf_arb'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Telefaks arbeide</b></div>
> </td>
> <td><?php echo $searchData['Faks_arb'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Epost</b></div>
> </td>
> <td><?php echo $searchData['Epost'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Stillingskode</b></div>
> </td>
> <td><?php echo $searchData['Stillingskode'] [0];
> ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Stilling</b></div>
> </td>
> <td><?php echo $searchData['Stilling'] [0]; ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Stillingsprosent</b></div>
> </td>
> <td><?php echo $searchData['Stillingsprosent'] [0];
> ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Årslønn</b></div>
> </td>
> <td><?php echo $searchData['Aarslonn_100P'] [0];
> ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
> <b>Lønnsramme-alternativ</b></div>
> </td>
> <td><?php echo $searchData['Lonnsrammealternativ'] [0];
> ?></td>
> </tr>
> <tr>
> <td width="100">
> <div align="right">
>
> </div>
> </td>
> <td><a href="edit.php?recid=<?php
> $recordDetails=explode('.',$key);
> $currentRecord=$recordDetails[0];
> echo $currentRecord;
> ?>"><img src="./images/detail.gif"></td>
> </tr>
> <?php
> }
> ?>
>
> </table>
>
>
>
> På 22-11-04 18:39, skrev "Dale Bengston"
> <dbengston at preservationstudio.com>:
>
>> In FM6 you could get around this by storing the default language for
>> indexing and storing to ASCII. That option is gone for FM7; perehaps
>> Unicode produces the same results?
>>
>> Also, Baard, please post your code that queries FX.
>>
>> Dale
>> --
>> Dale Bengston | Streamline Studio, LLC |
>> dbengston at streamline-studio.com
>> Associate Member, FileMaker Solutions Alliance
>>
>> On Nov 22, 2004, at 9:41 AM, Milos Vukotic wrote:
>>
>>> Not just number-fields, any fields with particular characters (like
>>> "@")... Look at my previous posts.
>>> There is NO good work around in FM7. Maybe after v9 everything will
>>> work as it is supposed to!?
>>>
>>> Cheers,
>>> Milosh
>>> --
>>> Milos Vukotic
>>> Software Engineer
>>> MC Services
>>> http://www.mcservices.com
>>>
>>> Baard Belsaas wrote:
>>>
>>>> Hello, I have made my first fx-site in FM5, and get it working!
>>>> Now I have converted this to FM7. After a bit of troubles I can
>>>> acsess the
>>>> database from the site, and searching on a text-filed is ok. But
>>>> when
>>>> I
>>>> search on a number-filed its "game over"; the found counter is "-1"
>>>> and the
>>>> current error=401.
>>>>
>>>> Search is the same to number- or textfield? Or have I sleeping in my
>>>> fx-lessons?
>>>>
>>>>
>>>> In kindness
>>>> Baard Belsaas
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>
>
>
> _______________________________________________
> 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: 9300 bytes
Desc: not available
Url : http://www.iviking.org/pipermail/fx.php_list/attachments/20041213/d2b45418/attachment.bin
More information about the FX.php_List
mailing list