Re: [WebDNA] An unknown error occured // Deadlock avoided
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106921
interpreted = N
texte = You guys are all missing the point. The guys wants it. You all are acting like you have never had to appease a boss or a client and give them a stupid feature. Whatever, I have to do it all the time with my clients. Ken I too have an issue with telling people what I think, but once that is done (which it sounds like tommy did) you move on and give it to them. That all being said, that code looks like it could be done with a two lines of code. Both are as Govinda suggested. Use the REPLACE tag with the APPEND flag. I can see no reason to have the Counter inside a search. It too can be a simple REPLACE with APPEND. I cannot see how you know if someone has gone offline or not based on the above code. So if you need that simply add a timestamp to the db and run a different script, I recommend from a trigger or cron job, and have it remove anyone that is idle for more than X minutes. Or something along those lines anyway. Just my 2 cents. Ron On Mon, Jul 11, 2011 at 7:49 AM, Dan Strong
wrote: > Ken I was just think something very similar :-) > > Tommy, also maybe zero in on what info he actually wants to see -- i.e. d= oes > he really need to know a visitor's IP address in semi real time? Does he > really need to know what formvariables are being used on a page in semi r= eal > time? Likely he just wants to know how busy the site is and if that's the > case then perhaps only document a simple count or get creative and every > time someone hits the site, have the server play a sound file of a cash > register from a speaker in his office, so when the site is busy it sounds > like the money is rolling in :-) You get the drift... > > Lastly, if all else fails, hit him between the eyes with the thing everyb= ody > understands: money. They way he's doing it now is costing him in lost sta= ff > time and ultimately money. They way you are proposing to do it will save = you > time and him money, etc. etc. etc. > > -Dan > > On 7/11/2011 7:41 AM, Kenneth Grome wrote: >>> >>> Ken, He is quite pigheaded, I've spoken to him >>> repeatedly, about why he is interested in this >>> information, he has no clear answer, but he >>> signs my paycheck. >> >> Instead of appending the data to a db that's open all the >> time, append it to the end of a text file instead. =A0This is >> basically a log file, so you'll have to roll it daily or >> hourly which is easy in WebDNA. >> >> Then when your pigheaded boss wants to see this data, you >> can give him access to a special template that he must login >> in order to use. =A0When he logs in, your code will create a >> table by including the most recent copy of the text file. >> >> This gives your boss exactly what he wants to see, and the >> code that appends each visitor's click to the log file will >> not affect any databases, so it eliminates the deadlock >> issue. >> >> Sincerely, >> Kenneth Grome >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us >
Associated Messages, from the most recent to the oldest:
You guys are all missing the point. The guys wants it. You all are acting like you have never had to appease a boss or a client and give them a stupid feature. Whatever, I have to do it all the time with my clients. Ken I too have an issue with telling people what I think, but once that is done (which it sounds like tommy did) you move on and give it to them. That all being said, that code looks like it could be done with a two lines of code. Both are as Govinda suggested. Use the REPLACE tag with the APPEND flag. I can see no reason to have the Counter inside a search. It too can be a simple REPLACE with APPEND. I cannot see how you know if someone has gone offline or not based on the above code. So if you need that simply add a timestamp to the db and run a different script, I recommend from a trigger or cron job, and have it remove anyone that is idle for more than X minutes. Or something along those lines anyway. Just my 2 cents. Ron On Mon, Jul 11, 2011 at 7:49 AM, Dan Strong wrote: > Ken I was just think something very similar :-) > > Tommy, also maybe zero in on what info he actually wants to see -- i.e. d= oes > he really need to know a visitor's IP address in semi real time? Does he > really need to know what formvariables are being used on a page in semi r= eal > time? Likely he just wants to know how busy the site is and if that's the > case then perhaps only document a simple count or get creative and every > time someone hits the site, have the server play a sound file of a cash > register from a speaker in his office, so when the site is busy it sounds > like the money is rolling in :-) You get the drift... > > Lastly, if all else fails, hit him between the eyes with the thing everyb= ody > understands: money. They way he's doing it now is costing him in lost sta= ff > time and ultimately money. They way you are proposing to do it will save = you > time and him money, etc. etc. etc. > > -Dan > > On 7/11/2011 7:41 AM, Kenneth Grome wrote: >>> >>> Ken, He is quite pigheaded, I've spoken to him >>> repeatedly, about why he is interested in this >>> information, he has no clear answer, but he >>> signs my paycheck. >> >> Instead of appending the data to a db that's open all the >> time, append it to the end of a text file instead. =A0This is >> basically a log file, so you'll have to roll it daily or >> hourly which is easy in WebDNA. >> >> Then when your pigheaded boss wants to see this data, you >> can give him access to a special template that he must login >> in order to use. =A0When he logs in, your code will create a >> table by including the most recent copy of the text file. >> >> This gives your boss exactly what he wants to see, and the >> code that appends each visitor's click to the log file will >> not affect any databases, so it eliminates the deadlock >> issue. >> >> Sincerely, >> Kenneth Grome >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list. >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us >
Ronald Kirkland
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Problems with [Search] param - Mac Plugin b15 (1997)
New Site Announcement (1998)
2.0 Beta (1997)
Errata: WCS Newbie question (1997)
Credit card processing - UK (1997)
Showif, Hideif reverse logic ? (1997)
Slightly off-topic hits to purchase ratio? (1999)
apparently to problem isolated (1997)
Projects & Contractors (1997)
Emailer help....! (1997)
TCP connect, how long does it take (PCS please) (1999)
SAVECART (1997)
return missing item (was:WebCat Sales) (1997)
Forumulas.db & Variables (2002)
Problems with Frames (1998)
Only charge card when product shipped ? (1997)
Appligent PDFs (was: OT - Dig Sigs) (2004)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Surprise x and y post args (1998)
Caching [include] files ... (1997)