any dynamic variable (IE: anything wrapped in ##) in the SQL statement. WHERE X = <cfqueryparam value="#dynamic.variable#" cfsqltype="some SQL type">
Toby King wrote: > Hi there > > Without copying and pasting the entire query can you show an example of > how/where you can use the cfqueryparam in the code. > > Thanks in advance. > > > > > > > > > >> On Wednesday 05 Nov 2008, Toby King wrote: >> >>> Just a quick question in relation to the CFQueryParam - where are >>> >> you >> >>> advising that I use this command. >>> >> In *every single* CFQUERY. >> >> -- >> Tom Chiverton >> Helping to widespreadedly supply strategic e-services >> >> >> >> **************************************************** >> >> This email is sent for and on behalf of Halliwells LLP. >> >> Halliwells LLP is a limited liability partnership registered in >> England and Wales under registered number OC307980 whose registered >> office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, >> Manchester, M3 3EB. A list of members is available for inspection at >> the registered office. Any reference to a partner in relation to >> Halliwells LLP means a member of Halliwells LLP. Regulated by The >> Solicitors Regulation Authority. >> >> CONFIDENTIALITY >> >> This email is intended only for the use of the addressee named above >> and may be confidential or legally privileged. If you are not the >> addressee you must not read it and must not use any information >> contained in nor copy it nor inform any person other than Halliwells >> LLP or the addressee of its existence or contents. If you have >> received this email in error please delete it and notify Halliwells >> LLP IT Department on 0870 365 2500. >> >> For more information about Halliwells LLP visit www.halliwells.com. >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
