Can anyone help...?
Im trying to load data from Filemaker via ODBC that using wildcards.
For example I need to get values that contain VPB or VGF
The user enters what they need through a form which passes their choice as $FromPoint, anybody know if this is possible.
At the moment my query looks like this:
$cnx = odbc_connect( 'CityGet' , 'Tester.fp5', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}
// send a simple odbc query . returns an odbc cursor
$cur= odbc_exec( $cnx, "select StreetName1 from Tester where StreetName1 = $FromPoint" );
if (!$cur) {
errorHandler ( "Error in odbc_exec( no cursor returned ) " , $cnx );
};
Cheers
Bert