Link to home
Create AccountLog in
Avatar of Albee_J
Albee_J

asked on

Difference: CFQUERY PARAM and VAL()

I am trying to find out what is the difference between the two lines of code below:  How does the VAL() differer from cfqueryparam type = integer.

WHERE OrderID = #val(OrderID)#

AND

WHERE OrderID = <cfqueryparam value = "#OrderID#"  cfsqltype = "cf_sql_integer">
ASKER CERTIFIED SOLUTION
Avatar of SidFishes
SidFishes
Flag of Canada image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Albee_J
Albee_J

ASKER

How does the cfqueryparam increase performance ?
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Avatar of Albee_J

ASKER

Thanks Sid!