anyone have any luck using openquery request to see if a record exists before adding? using the following command. it working in SQL with the real value.
$strSQLExists = "Select From OpenQuery(Line, 'SELECT FROM testcp.order where order='".$values["order"]."')";
$rsExists = db_query($strSQLExists,$conn);
$data=db_fetch_array($rsExists);