Thomas Peer
Member since Nov 25, 2021
- Profile: /members/14339-thomas-peer.htm
- Comments: 1
Recent Blog Comments By Thomas Peer
-
Phill Nacelli's SQL Tip Is Making My CFQuery Upgrades In Adobe ColdFusion 2021 Easy
Posted on Nov 25, 2021 at 4:17 PM
I always prefer to build the SQL string and then execute. sqlText = "select bookid, title, genre from books where bookid = :bookid "; You can use any sort of logic then to build the string. myQry.setSQL(sqlText); myQry.addParam(name="bookid",value="5",CFSQLTYP... read more »