Re: Bizarre Client Variables problem
I've never seen anything like this...check your login script to make sure it is setting the proper client variables. Check your queries too...Use clientvariablelist() to view what the variables are being set to. Make sure your users are not logging in from the same computer without closing all browser windows, I once had 50 Puerto Ricans signing up from the same computer...scratched my head for awhile on that one. jon - Original Message - From: "W Luke" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 07, 2001 8:07 AM Subject: Bizarre Client Variables problem > Hi, > > I wrote a page last night, to allow Members to update their Personal Details > that are on the DB. As with all the other pages on my site, I make them a) > login, then b) query the DB by their login-email (client.email) and c) > display information. > > Instead though, the query is displaying the last updated record's > information, and not the users'. This is a major problem - when Jeff Smith > goes to update his records, he's presented with Nancy Bowhearts' instead... > The query is about as basic as you can get, but still I can't work out why > it isn't pulling the user's information. All other pages work fine using > "WHERE email = '#client.email#'" - here's a small chunk of the code: > > Please login, by entering your email and > password on the left > > > > > SELECT * FROM members > WHERE email = '#client.email#' > > > > > > > > First Name > > > > .etc > > > Can anyone offer a reason why this is happening? > > Regards > > Will > -- > [EMAIL PROTECTED] -=- www.lukrative.com > Local-Advertising -=- www.localbounty.com > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bizarre Client Variables problem
I don't know why it helped - but the server was restarted by my hosters, and everything's working fine again. It suddenly woke up again, and I had no idea the server had been restartedvery weird. Will - Original Message - From: ""Jon Hall"" <[EMAIL PROTECTED]> Newsgroups: dotcom.lists.cftalk Sent: Saturday, April 07, 2001 3:18 PM Subject: Re: Bizarre Client Variables problem > I've never seen anything like this...check your login script to make sure it > is setting the proper client variables. Check your queries too...Use > clientvariablelist() to view what the variables are being set to. Make sure > your users are not logging in from the same computer without closing all > browser windows, I once had 50 Puerto Ricans signing up from the same > computer...scratched my head for awhile on that one. > > jon > - Original Message - > From: "W Luke" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, April 07, 2001 8:07 AM > Subject: Bizarre Client Variables problem > > > > Hi, > > > > I wrote a page last night, to allow Members to update their Personal > Details > > that are on the DB. As with all the other pages on my site, I make them > a) > > login, then b) query the DB by their login-email (client.email) and c) > > display information. > > > > Instead though, the query is displaying the last updated record's > > information, and not the users'. This is a major problem - when Jeff > Smith > > goes to update his records, he's presented with Nancy Bowhearts' > instead... > > The query is about as basic as you can get, but still I can't work out why > > it isn't pulling the user's information. All other pages work fine using > > "WHERE email = '#client.email#'" - here's a small chunk of the code: > > > > Please login, by entering your email and > > password on the left > > > > > > > > > > SELECT * FROM members > > WHERE email = '#client.email#' > > > > > > > > > > > > > > > > First Name > > > > > > > > .etc > > > > > > Can anyone offer a reason why this is happening? > > > > Regards > > > > Will > > -- > > [EMAIL PROTECTED] -=- www.lukrative.com > > Local-Advertising -=- www.localbounty.com > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bizarre Client Variables problem
Try appending the CDIF and CFTOKEN to your transactions (eg: URL's, forms, etc) eg: This should ensure that your application can differentiate which client is making the request. You should use this method throughout your app. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, 7 April 2001 22:07 To: CF-Talk Subject: Bizarre Client Variables problem Hi, I wrote a page last night, to allow Members to update their Personal Details that are on the DB. As with all the other pages on my site, I make them a) login, then b) query the DB by their login-email (client.email) and c) display information. Instead though, the query is displaying the last updated record's information, and not the users'. This is a major problem - when Jeff Smith goes to update his records, he's presented with Nancy Bowhearts' instead... The query is about as basic as you can get, but still I can't work out why it isn't pulling the user's information. All other pages work fine using "WHERE email = '#client.email#'" - here's a small chunk of the code: Please login, by entering your email and password on the left SELECT * FROM members WHERE email = '#client.email#' First Name ..etc Can anyone offer a reason why this is happening? Regards Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bizarre Client Variables problem
TIP: it can help to have two browser sessions open to track your applications. They should be different browsers (ie: one Navigator and the other IE) as CF identifies them is different "clients". Whack a header at the top of your pages (for testing purposes) displaying your applicats client variables and check that they remain what you expect them to be while switching between the browsers and testing your application. If user one suddenly switches to user two you will know you have a problem. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists