Well that didn't change anything. I got this from the easycfm.com tutorial.
Hey I thought this was easy LOL -----Original Message----- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 10:44 PM To: CF-Talk Subject: RE: login prob If you have a DSN already set up (I asusme you do and it's called users) try using just <CFQUERY Datasource="users" name="qVerify"> John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -----Original Message----- From: Mike Miessen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:37 PM To: CF-Talk Subject: RE: login prob Well I took that out of my tag and it does not error but now it does not seem to be checking the database table either because it is not passing me through I'm still trying to understand Peter's response LOL -----Original Message----- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 10:23 PM To: CF-Talk Subject: RE: login prob Have you tried taking dbname="#myDSN#" out of your tag? IIRC dbname isn't used anymore, I could be wrong there. I never use it. What CF version? J. John Wilker Web Applications Consultant, Writer Macromedia Certified ColdFusion Developer Founder/President IE CFUG www.red-omega.com Whatever is wrong it is better than a poke in the eye with a sharp stick. Unless of course you just got poked in the eye with a sharp stick. -----Original Message----- From: Mike Miessen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:13 PM To: CF-Talk Subject: login prob I keep getting this error but I don't understand whats wrong with my code can anybody tell me? The tag does not have an attribute called dbname. The valid attribute(s) are name, datasource, dbtype, sql, username, password, maxrows, blockfactor, timeout, cachedafter, cachedwithin, debug. The Error Occurred in D:\wwwroot\MembersOnly\Login_Process.cfm: line 9 7 : <body> 8 : <!--- Get all records from the database that match this users credentials ---> 9 : <cfquery name="qVerify" dbname="#myDSN#" datasource="Users" username="#DSNUsername#" password="#DSNPassword#"> 10 : SELECT UserName, Password 11 : FROM users ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
