First published on MSDN on Sep 30, 2008
I recently attended ZendCon 08 in Santa Clara, CA with David Sceppa, Program Manager for the SQL Server 2005 Driver for PHP. We host...
Updated Mar 23, 2019
Version 2.0
Blog Post
What if you need conditional parameters like
textbox(id="txtName", Prompt="Filter by Name")
strSQL = "SELECT * FROM tblNames "
if txtName <> "" Then
param = txtName
strSQL &= "WHERE Name LIKE ?"
end if
ds = sqlsrv_query(conn, strSQL , param)
(don't mind the syntax)
Would that work?