Wrap even the ones that are required? What is the reason for this?
I have CFPARAM for thos that aren't required. Here is an example <cfparam name="FORM.wedDate" default="N/A"> <cfparam name="FORM.lengthOfSeperation" default="N/A"> <cfparam name="FORM.seperationExplanation" default="N/A"> Is this not the correct way? Thanks so much!!! >Torrent Girl wrote: > >Depending on the database, it might work happily, but there again it may >not. > >Wrap it in a cfqueryparam of sqltype date/time and that should make sure >it works fine. > >Really you should wrap each of the inserted data in a cfqueryparam with >the sqltype set appropriately for that column. > >Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Studio MX with Flash Pro from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=51 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
