MSSQL data search

Hello there,

Is it possible to incorporate MSSQL query into the Search plugin so that I can create search filter?

If so, how can it be done?

Thank you.

DataBridge includes a MySQLi Database Search server behavior. Just create your search form, have it submit to the results page with your Recordset and then use the Search server behavior to filter the results.

Thank you, Ray.

I'm using Microsoft SQL server and not MySQL. Example below.

$sql1 = "SELECT * from table'";
$stmt1= sqlsrv_query($conn,$sql1);

if($stmt1 === false){
die (print_r(sqlsrv_errors(), true));
}
$row1 = sqlsrv_fetch_Array($stmt1,SQLSRV_FETCH_ASSOC);

Sorry I didn't understand the question.

That would have to be hand coded. I could help you with that in a premier support ticket, but we don't have any tools that work with Microsoft SQL server.

Thank you, Ray.

How do I go and set up the premier ticket? What's the cost?

Thanks

I charge $100/hour. I'm sure we could get this figured out in a 1 hour session.

You can call the number at the bottom of the site, or send me a skype message: webassist.rborduin