Re: Using IIf() in query value

On Friday 02 June 2006 23:20, Jim McAtee wrote: cfquery datasource=#dsn# INSERT INTO cctransactions ( name, response ) VALUES ( '#form.name#', '#IIf(StructKeyExists(authresponse, http_response), authresponse.http_response, DE())#' ) /cfquery VALUES (  

Using IIf() in query value

I'm working in CF5. I thought single quotes within strings were always escaped in a cfquery. I have a query using an IIf() in the value and this doesn't appear to be the case. Does this have something to do with how I'm doing the evaluation of the second argument in the IIf() below? In this