problem with FMFind

[bxm]

Hi, I'm having trouble getting ther FMFind function to work using FM7.

FMNew() works, so the problem does not seem to be with the webserver.

Here is my code, maybe there's something I'm overlooking?

$fm_server = "fmtest";

$query = new FX($fm_server, 80, "FMPro7");

$query->SetDBUserPass("user", "pass");

$query->SetDBData("Clients.FP7","FormView",'All');

$query->AddDBParam('Client_number',$row["client_number"], 'eq');

$queryUpdate = $query->FMFind();

echo "found:" . $queryUpdate["foundCount"];

foundCount is always zero, even though this client number exists in the database.

Any suggestions?

[andygaunt]

Hi,

First your username password are backwards. It should be

$query->SetDBUserPass( "pass", "user");

Also, in your find you are referencing a variable $row["client _number"].

Where are you gathering this from?

To ensure your query is well formed and to debug searches it is sometimes valuable to hard code the value in your query that you are looking for in your database. This can ensure it will return the correct result.

Let us know how you get on.