Couldn't agree more Rick. The day I moved away from Access was a great day.
-----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 23 January 2008 20:24 To: CF-Talk Subject: Re: CF MX8: This is driving me nuts!!! On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote: > Thanks fo rthe reply. No the DB fields are "UserLogin" and "UserPwd". I changed the code based on another members suggestion and this is the error I received: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 4. I can't suggest anythign else other than to double check the field names by doing a simple select * from Users and then dumping the output or at least the ColumnList. Because that error "Too few parameters" almost *ALWAYS* suggests that you're attempting to refer to a column that does not exist. It's another reason I hate MS Access. Retarded error messages. And that's an insult to retarded people everywhere. -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
