Hi I have the following code in cf and I want to alert out the values
......
......
<cfelse>
<cfset val = structFind(request.session.prefs, key)>
<cfquery name="insertPref" datasource="database">
INSERT INTO
`database`.`user` (
`cID`,
`cliID`,
`userID`,
`userPID`,
`value`
)
SELECT
#request.cID#,
#request.cliID#,
#request.userID#,
`user`.`userPID`,
<cfqueryparam value="#preserveSingleQuotes(val)#">
FROM
`database`.`user`
WHERE
`applicationID` = 1
AND
`name` = <cfqueryparam value="#preserveSingleQuotes(key)#">
ON DUPLICATE KEY UPDATE
`value` = <cfqueryparam value="#preserveSingleQuotes(val)#">
</cfquery>
</cfif>
</cfif>
</cfloop>
Any help will be appreciated