Hi all. I have started to notice some very strange activity of late with a new site that I am writing. Here are the details,
I have a number of form fields, 4 of which are date fields. The date fields can all be blank. All of my form fields are put into a new staructure and this structure is then passed to a CFC using the 'argumentcollection=' syntax. Within my CFC I am using cfstoredproc to call a SQL2000 stored procedure, all of the parameters are passed out using cfprocparam. I check here whether my datefields do in fact contain a date else I set null="yes" for that specific cfprocparam. This is where the problem starts, if one of my date fields is empty, i.e. pass out null, my stored procedure does not receive the correct number of parameters and I get an error. If all of my date fields are populated then I get no error as the correct number of parameters have been passed. It almost seems that the blank date fields that are being passed out as null with a cfsqltype = CF_SQL_DATE are being lost and not getting passed to procedure. Anybody have any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211985 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
