On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote: > ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A > SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A > SIMPLE LOGIN APPLICATION. > > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected > 1.
double check your column names again because in your other thread one of the column names was different and your error said "Expected 2"... so now you've got one bad column name still. Rick > 20 : </cfquery> 21 : SQL SELECT * FROM Users WHERE UserLogin = 'paulw' > AND Password = 'PPMILL' Watch what you paste into email messages. -- 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:297206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4