ColdFusion Error message:
[Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s).
Your problem might be:
<cfquery name="clinicalTrialsEncounterInsert" datasource="#variables.dsn#">
INSERT INTO table
(
value1,
value2,
value3,
value4,
value5
)
VALUES
(
<cfqueryparam cfsqltype="CF_SQL_INTEGER" value="0"/>,
<cfqueryparam cfsqltype="CF_SQL_BIT" value="0"/>,
<cfqueryparam cfsqltype="CF_SQL_BIT" value="0"/>",
<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP" value="#now()#"/>,
<cfqueryparam cfsqltype="CF_SQL_INTEGER" value="8"/>
)
</cfquery>
Notice the stray double-quotes following the queryparam? Sneaky little devil!