om_odbc sql_exec bind parameters

Tags: bind parameters | om_odbc | sql_exec

#1 michaels 8 years ago

Hello

When I call sql_exec with a bind parameter

if (sql_exec("INSERT INTO Events (Id) VALUES(?)", $ID) == TRUE) {}

I get the following error:

INFO SQLBindParam failed; HY104:1:0:[Microsoft][ODBC SQL Server Driver] Invalid precision value

Same commnad using string concatenatiion works fine:

if (sql_exec("INSERT INTO Events (Id) VALUES(" + $ID +")") == TRUE) {}

Could you help me with it?

Permalink

#2 adm Nxlog ✓ 8 years ago

#1 michaels

Hello When I call sql_exec with a bind parameter if (sql_exec("INSERT INTO Events (Id) VALUES(?)", $ID) == TRUE) {} I get the following error: INFO SQLBindParam failed; HY104:1:0:[Microsoft][ODBC SQL Server Driver] Invalid precision value Same commnad using string concatenatiion works fine: if (sql_exec("INSERT INTO Events (Id) VALUES(" + $ID +")") == TRUE) {} Could you help me with it?

Can you also show the schema (or at least the type of the Events.Id column)?