Welcome Guest, Not a member yet? Register   Sign In
ODBC SELECT - no value escape ?
#3

[eluser]MRosenello[/eluser]
For MSSQL sepcifically, you would add another ' to it. So 'D'Andrea, First' would become 'D''Andrea, First'.

So for example to make this work you would have to do a str_replace("'","''",$dbRecord) before using that value in a where clause or insert value etc.

Hopefully this helps, as I just had the same issue last week.


Messages In This Thread
ODBC SELECT - no value escape ? - by El Forum - 06-18-2012, 04:52 AM
ODBC SELECT - no value escape ? - by El Forum - 06-20-2012, 12:35 PM
ODBC SELECT - no value escape ? - by El Forum - 06-20-2012, 06:51 PM



Theme © iAndrew 2016 - Forum software by © MyBB