> When the function receives the data it throws one of two > errors: If I set a type for group_id (as int) it throws an > error saying that group_id is not of type int. (I've since > discovered that ColdFusion passes almost all form values as > strings). If I remove the type from the CFArgument I get > [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). > > I need to get an answer and move past this.. what am I missing? > > http://cfm.pastebin.com/m5279dcb4
In your query, you have a single quote directly before the line containing group_id. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4