[FX.php List] Solution of "Searching..."
Baard Belsaas
fmweb at belsaas.no
Wed Nov 24 15:45:05 MST 2004
After searching in old messeages of this list I find a solution, a way to
get this thing working:
Use:
$search->AddDBParam('IDnr',"=".$IDnr);
Instead of the:
>
$search->AddDBParam('IDnr',$IDnr);
Now I can search fields containg number-fields:-))
Baard Belsaas
Norway
På 23-11-04 00:09, skrev "Baard Belsaas" <fmweb at belsaas.no>:
> 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
>>
More information about the FX.php_List
mailing list