Shannan, This probably won't address you situation but... 1) you should always use <cfqueryparam> in your SQL 2) there is a logic problem in your login page: I would replace <CFIF #Form.password# IS NOT get_pass.Pass> with <cfif get_pass.RecordCount NEQ 1>
For your issue, I wold double check the cookie settings. Thanks, Joe Kelly On 8/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Hello all, > > I have an "Element LOCID is undefined in CLIENT" error for 1 person out of > 200+. > > I have 200+ people who can log in to a password-protected web page that uses > Cold Fusion to check the username and password against their account in an > MSSQL DB. If it matches, it sets a cookie and a Client variable. One > person in this whole bunch cannot log in from 2 of his 3 computers (on one > of them he can log in). I have tried every setting I can think of and > nothing works. The cookie is getting set because he can get to the > main.cfm page which checks for a cookie and then he gets the error at the > next line of code where it calls in LOCID. (see code below) > > Here's the error: > > > Element LOCID is undefined in CLIENT. > (code that gets this error is: SELECT * from locations WHERE LocID = > #Client.LocID#) see all code below . . . > > He is using XP Home Service pack 2 with IE7 > > > Here's the code for the login action page: > > <CFIF #Form.password# IS ""> > <META HTTP-EQUIV="Refresh" CONTENT="0;URL=login.cfm"> > <CFELSE> > > <CFQUERY name="get_pass" DATASOURCE="cbar2"> > SELECT * FROM locals > WHERE Username = '#Form.username#' AND Pass = > '#Form.password#'</CFQUERY> > > <CFIF #Form.password# IS NOT get_pass.Pass> > <span class="style8"><H1>Oops!</H1> Your username or password are > incorrect.</span> > <p><A HREF="login.cfm">Please try again.</A></p> > > <CFELSE> > <CFCOOKIE NAME="admin1" value="1"> > > <CFOUTPUT QUERY="get_pass"> > <CFSET CLIENT.LocID = "#get_pass.LocID#"> > <META HTTP-EQUIV="Refresh" CONTENT="0;URL=main.cfm"> > </cfoutput> > </CFIF> > > </CFIF> > Here's the code for main.cfm: > > <CFIF ParameterExists(Cookie.admin1) is "false"><CFLOCATION > URL="login.cfm"></CFIF> > <CFQUERY name="fmenu" DATASOURCE="cbar2"> > SELECT * from locals WHERE LocID = #Client.LocID# > </CFQUERY> > > > Does anyone have any suggestions? Like I said, 200+ people can log in with > this just fine. I believe it is a setting on his computer. > > Here's what I have tried: > turn off firewall > ensure there are not 2 firewalls running > turn off antivirus > enable cookies > clear cache > try a different browser > change IE settings > > > > > THANKS! I know you all are busy people so thank you in advance for reading > this!!!! > > > Shannan Hauser > Professional Web Designer > Web Image Media > [EMAIL PROTECTED] > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.instantspot.com/ > www.teksystems.com/ > > _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
