Re: concurrent users and filtering data down to other users

[denstar]

On Tue, Sep 30, 2008 at 2:39 AM, Tom Chiverton wrote:
> On Monday 29 Sep 2008, Ian Skinner wrote:
>> connected to receive content.  The closest you can get with these
>> technologies is to regularly pull updated data from the client.  I.E.
>> Set a function on the client to check the server for new data every X
>> seconds.
>
> There are actually several ways to simulate server PUSH in AJAX applications,
> using variations on the 'long request' trick which holds the HTTP connection
> open.
> See the first Google hit:
> http://www.google.com/search?hl=en&q=ajax+push&btnG=Search

The long request trick has been hit or miss for me.

There are webservers that are really aimed at AJAX, I'd think about
looking into them if you're getting serious about it.

There's this, too: http://cometdproject.dojotoolkit.org/

HIH!

-- 
We cannot therefore say that mental acts contain a cognitive as well
as a conative element.
Samuel Alexander

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: concurrent users and filtering data down to other users

[Tom Chiverton]

On Monday 29 Sep 2008, Ian Skinner wrote:
> connected to receive content.  The closest you can get with these
> technologies is to regularly pull updated data from the client.  I.E.
> Set a function on the client to check the server for new data every X
> seconds.

There are actually several ways to simulate server PUSH in AJAX applications, 
using variations on the 'long request' trick which holds the HTTP connection 
open.
See the first Google hit: 
http://www.google.com/search?hl=en&q=ajax+push&btnG=Search

-- 
Tom Chiverton
Helping to apprehensively maintain appliances





This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.com.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313268
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: concurrent users and filtering data down to other users

[Richard White]

thanks for your advice iain. 

its a good idea with the original value except with this software there is alot 
of data on some pages (grids and trees etc...) 

thanks again, really do appreciate your advice and input

richard 

>I don't know if this is easier or not... but it is what I've done when 
>worried about 'brown' data.
>
>When a user views a data set for editing, keep of a copy of the data as 
>they received it, probably in a session variable.  Then when they submit 
>changes to this data, compare the 'original state' to the current state 
>of the same data in the database.  If the data in the database is 
>different then this 'original state' then you know it has been changed 
>and the user needs to be informed for appropriate action.
>
>Seems to be more straight forward and direct to me then trying to keep 
>application and session 'change' state variables in sync. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313225
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: concurrent users and filtering data down to other users

[Ian Skinner]

I don't know if this is easier or not... but it is what I've done when 
worried about 'brown' data.

When a user views a data set for editing, keep of a copy of the data as 
they received it, probably in a session variable.  Then when they submit 
changes to this data, compare the 'original state' to the current state 
of the same data in the database.  If the data in the database is 
different then this 'original state' then you know it has been changed 
and the user needs to be informed for appropriate action.

Seems to be more straight forward and direct to me then trying to keep 
application and session 'change' state variables in sync.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313220
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: concurrent users and filtering data down to other users

[Richard White]

hi, 

we were thinking that we could have an application variable that stores the 
state of the data, for example if it has not changed then it is set to 'no 
change', else if it is processing a request then it would be set to 
'processing', and if it has finished processing and no errors occurred then it 
would be set to 'changed'.

then if another user tries to change information then it checks the state if it 
is 'processing' then they will be asked to wait, and if it is set to 'changed' 
then they have to click a button that reloads the data before they save, as 
otherwise there may be 2 people trying to change the same bit of data and would 
result in data inconsistency.

it will keep track of whether each user has reloaded the data by storing a 
variable in their session scope and set to either 'reload required' or 
'reloaded'

just wondering what you think of this scenario or whether others have achieved 
this in a more simple way.

thanks

richard

>You can not do this with basic HTTP/HTML/AJAX level technology.  There 
>is no connection between the server and any client that recently 
>connected to receive content.  The closest you can get with these 
>technologies is to regularly pull updated data from the client.  I.E.  
>Set a function on the client to check the server for new data every X 
>seconds.
>
>If you want to truly push data from the server to the client you are 
>going to have to use something beyond the basic HTTP client.  Of course 
>Adobe would probably suggest their FLASH/FLEX/LIVECYCLE family of tools 
>that would allow this type of functionality. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313217
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: concurrent users and filtering data down to other users

[Richard White]

thanks for your advice Ian, i thought we may be missing something and that 
there was a common way people handled this through ColdFusion; so it looks like 
we are going to have to add some form of page locking or content updater 
function as you suggested.

thanks for your advice

richard

>You can not do this with basic HTTP/HTML/AJAX level technology.  There 
>is no connection between the server and any client that recently 
>connected to receive content.  The closest you can get with these 
>technologies is to regularly pull updated data from the client.  I.E.  
>Set a function on the client to check the server for new data every X 
>seconds.
>
>If you want to truly push data from the server to the client you are 
>going to have to use something beyond the basic HTTP client.  Of course 
>Adobe would probably suggest their FLASH/FLEX/LIVECYCLE family of tools 
>that would allow this type of functionality. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313212
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: concurrent users and filtering data down to other users

[Ian Skinner]

You can not do this with basic HTTP/HTML/AJAX level technology.  There 
is no connection between the server and any client that recently 
connected to receive content.  The closest you can get with these 
technologies is to regularly pull updated data from the client.  I.E.  
Set a function on the client to check the server for new data every X 
seconds.

If you want to truly push data from the server to the client you are 
going to have to use something beyond the basic HTTP client.  Of course 
Adobe would probably suggest their FLASH/FLEX/LIVECYCLE family of tools 
that would allow this type of functionality.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313210
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

concurrent users and filtering data down to other users

[Richard White]

hi,

we cannot seem to find any discussion on the internet regarding this issue.

this is regarding multiple users looking at a page where data can be changed by 
those users, and we want the data changes to filter to the other people looking 
at the data? is there any general disdussions on this?

our scenario is a little different though as we are using JSMX to request and 
send data to the server. users will look at one page of data and when saving 
data a JSMX call is sent to the server to save the data, then when a user saves 
some data then we want it to filter down to the other users.

we were thinking that we may have to handle this manually by checking if any 
users are looking at the same page and then inform them that a change has been 
made and to click a reload button or something like that, or maybe it could 
just autmatically update it with the changes.

we would appreciate some general help on this

thanks

richard 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313208
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

OT: Desperately Seeking Crystal Reports 8 Enterprise License (~30 Concurrent users)

[Rachel Maxim]

 
Years ago my company made the (poor) decision to develop lots and lots
of reports on Crystal Reports 8 Enterprise. We are now switching to new
servers and have been unable to locate our old license(s). Version 8 is
no longer sold, and we are moving away from Crystal to CF Reports and
naturally don't want to incur the expense of an upgrade for such a short
time period.

Does anyone have any license(s) you would be willing to sell? Please let
me know ASAP!

Thanks!

Rachel Maxim
- - - - - - - - - - - - - - - - - - - - - - - - 
Creative Director 
Case Design/Remodeling, Inc. 
& Case Handyman Services, LLC.

:: direct 240.235.9748
:: toll free 800.426.9434
:: [EMAIL PROTECTED] 

CaseDesign.com - CaseHandyman.com

4701 Sangamore Road
North Plaza Suite 40
Bethesda, MD 20816



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226858
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: COncurrent Users

[Keen]

Sorry misread the question...thought you were trying to figure out the
setting for simultaneous request in the CF Admin.

-Original Message-
From: Keen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 9:26 AM
To: CF-Talk
Subject: RE: COncurrent Users


The best way to do this is with a load test tool.  Create a script that
walks through your site and then run the test with different settings for
the number of concurrent users.  Compare the results to determine the best
setting for that application.  That is also a good time to enable debugging
and get a good idea of where your bottlenecks might be - go through the site
manually while it is under load and examine the execution times.  Microsoft
has a free tool that you can use for putting the load against the site -
http://webtool.rte.microsoft.com/.  Ballpark figures seem to be between 5-10
per processor depending on who you speak with.  If you have more questions
feel free to contact me offline.

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:17 AM
To: CF-Talk
Subject: COncurrent Users


Hi,
Is there a way to test system performance based on differenet number of
concurrent users?  Are there any guidelines from macroMedia on the
maximum number of concurrent users CF server supports? I realise this is
quite ballpacrk but basically need to presnet some figures to our
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the 




   
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   





At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)
>
>Thanks
>
>Bryan Stevenson
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>p. 250.920.8830
>e. [EMAIL PROTECTED]
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>
>- Original Message -
>From: "Steve Oliver" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, February 06, 2002 5:06 PM
>Subject: RE: looping inside cfquery - brain on vacation
>
>
>> Oh nevermind, your not looping over the columns of the query (long
day
>> as well)
>>
>> I think you need a semi-colon at the end of your query, since that
will
>> put multiple inserts in one cfquery.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:02 PM
>> To: CF-Talk
>> Subject: RE: looping inside cfquery - brain on vacation
>>
>>
>> Hmmm, well if one of your fields is numeric, then that wouldn't work,
>> since numeric values don't need 's around them,  you could use the
>> isNumeric() function for that.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:01 PM
>> To: CF-Talk
>> Subject: looping inside cfquery - brain on vacation
>>
>>
>> OK..long day..CF whining about syntax...help!
>>
>> The situation:
>>
>> CF doesn't like my syntax for this bit of looping over a query to
insert
>> muliple records.  It's
>> complaining about the final ")" closing bracket for the insert.  Any
>> ideas?  I'm sure I've done it
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>> 
>>   
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>   
>> 
>>
>> TIA
>>
>> Bryan Stevenson
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> p. 250.920.8830
>> e. [EMAIL PROTECTED]
>> ---

RE: COncurrent Users

[Keen]

The best way to do this is with a load test tool.  Create a script that
walks through your site and then run the test with different settings for
the number of concurrent users.  Compare the results to determine the best
setting for that application.  That is also a good time to enable debugging
and get a good idea of where your bottlenecks might be - go through the site
manually while it is under load and examine the execution times.  Microsoft
has a free tool that you can use for putting the load against the site -
http://webtool.rte.microsoft.com/.  Ballpark figures seem to be between 5-10
per processor depending on who you speak with.  If you have more questions
feel free to contact me offline.

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:17 AM
To: CF-Talk
Subject: COncurrent Users


Hi,
Is there a way to test system performance based on differenet number of
concurrent users?  Are there any guidelines from macroMedia on the
maximum number of concurrent users CF server supports? I realise this is
quite ballpacrk but basically need to presnet some figures to our
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the 




   
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   





At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)
>
>Thanks
>
>Bryan Stevenson
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>p. 250.920.8830
>e. [EMAIL PROTECTED]
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>
>- Original Message -
>From: "Steve Oliver" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, February 06, 2002 5:06 PM
>Subject: RE: looping inside cfquery - brain on vacation
>
>
>> Oh nevermind, your not looping over the columns of the query (long
day
>> as well)
>>
>> I think you need a semi-colon at the end of your query, since that
will
>> put multiple inserts in one cfquery.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:02 PM
>> To: CF-Talk
>> Subject: RE: looping inside cfquery - brain on vacation
>>
>>
>> Hmmm, well if one of your fields is numeric, then that wouldn't work,
>> since numeric values don't need 's around them,  you could use the
>> isNumeric() function for that.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:01 PM
>> To: CF-Talk
>> Subject: looping inside cfquery - brain on vacation
>>
>>
>> OK..long day..CF whining about syntax...help!
>>
>> The situation:
>>
>> CF doesn't like my syntax for this bit of looping over a query to
insert
>> muliple records.  It's
>> complaining about the final ")" closing bracket for the insert.  Any
>> ideas?  I'm sure I've done it
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>> 
>>   
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>   
>> 
>>
>> TIA
>>
>> Bryan Stevenson
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> p. 250.920.8830
>> e. [EMAIL PROTECTED]
>> -
>> Macromedia Associate Partner
>> www.macromedia.com
>> -
>> Vancouver Island ColdFusion Users Group
>> Founder & Director
>> www.cfug-vancouverisland.com
>>
>>
>>
>>
>


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

COncurrent Users

[Nick Betts]

Hi,
Is there a way to test system performance based on differenet number of 
concurrent users?  Are there any guidelines from macroMedia on the 
maximum number of concurrent users CF server supports? I realise this is 
quite ballpacrk but basically need to presnet some figures to our 
client.

Regards,
Nick

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 08:02
To: CF-Talk
Subject: Re: looping inside cfquery - brain on vacation


Maybe this?  Loop around the 




   
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   





At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)
>
>Thanks
>
>Bryan Stevenson
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>p. 250.920.8830
>e. [EMAIL PROTECTED]
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>
>- Original Message -
>From: "Steve Oliver" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, February 06, 2002 5:06 PM
>Subject: RE: looping inside cfquery - brain on vacation
>
>
>> Oh nevermind, your not looping over the columns of the query (long 
day
>> as well)
>>
>> I think you need a semi-colon at the end of your query, since that 
will
>> put multiple inserts in one cfquery.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Steve Oliver [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:02 PM
>> To: CF-Talk
>> Subject: RE: looping inside cfquery - brain on vacation
>>
>>
>> Hmmm, well if one of your fields is numeric, then that wouldn't work,
>> since numeric values don't need 's around them,  you could use the
>> isNumeric() function for that.
>>
>> __
>> steve oliver
>> atnet solutions, inc.
>> http://www.atnetsolutions.com
>>
>>
>> -Original Message-
>> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, February 06, 2002 8:01 PM
>> To: CF-Talk
>> Subject: looping inside cfquery - brain on vacation
>>
>>
>> OK..long day..CF whining about syntax...help!
>>
>> The situation:
>>
>> CF doesn't like my syntax for this bit of looping over a query to 
insert
>> muliple records.  It's
>> complaining about the final ")" closing bracket for the insert.  Any
>> ideas?  I'm sure I've done it
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>> 
>>   
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>   
>> 
>>
>> TIA
>>
>> Bryan Stevenson
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> p. 250.920.8830
>> e. [EMAIL PROTECTED]
>> -
>> Macromedia Associate Partner
>> www.macromedia.com
>> -
>> Vancouver Island ColdFusion Users Group
>> Founder & Director
>> www.cfug-vancouverisland.com
>>
>>
>>
>> 
>

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Concurrent users and client certificates

[Kevin Gilchrist]

Thank you!

-Original Message-
From: Teng-Yan Loke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 11:11 PM
To: CF-Talk
Subject: RE: Concurrent users and client certificates


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Try this:

http://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/7F4D0522-EC4C-1
1D3-85030050DABEAE1B/Tutorial_Page/1

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBOstxpRQsl2B8K+e4EQKxnwCeLYN5+KuQcCxOF9tJZpy24Qpzhr0AoKWr
PzJy7lg5fq4GfM+F/Mrbb7th
=R2Wn
-END PGP SIGNATURE-
~~
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: Concurrent users and client certificates

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Try this:

http://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/7F4D0522-EC4C-1
1D3-85030050DABEAE1B/Tutorial_Page/1

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOstxpRQsl2B8K+e4EQKxnwCeLYN5+KuQcCxOF9tJZpy24Qpzhr0AoKWr
PzJy7lg5fq4GfM+F/Mrbb7th
=R2Wn
-END PGP SIGNATURE-


~~
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: Concurrent users and client certificates

[Thomas Chiverton]

You cant read another users cookie
:thinks more

I really cant think of a way to do it nicly... 
:hmms

~~
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: Concurrent users and client certificates

[Thomas Chiverton]

Wont that need an application var. per user ?

-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 4:10 PM
To: CF-Talk
Subject: Re: Concurrent users and client certificates


Ok if my logic is not totally wacky here, what I am proposing is that the
top level application variable will come and go with ever page request. The
factor that determines that the user is loggedin is a match between the
application and cookie var of the same name.


 
  
  
 
  
  
 

 
 
 


- Original Message -
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:27 AM
Subject: Concurrent users and client certificates


> Hi all,
>
> I need to meet a business requirement where the same user cannot be logged
> in concurrently, i.e. if I log in a kgilchrist from one machine, I can't
log
> in again from another machine until at least the first session ends.
>
> At the moment users are given a client certificate which I authenticate
> against a database and I then set a few session variables to mark them as
> authenticated etc.  The session vars are disassociated when the browser
> closes loses the temp cookie.
>
> As part of the authentication process, do I need to somehow search through
> all the other sets of session variables?  How would I do that?
>
> >From reading some of the threads on the list it seems that using session
> variables isn't necessarily a good thing either.  Need to do some
> reading
>
> Thanks,
> Kevin
>
> Kevin Gilchrist
> Senior Consultant
> RedSiren Technologies Inc.
> (412) 281 4427 ext 466
>
>
~~
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: Concurrent users and client certificates

[Kevin Gilchrist]

I'm a bit uneasy about doing a periodic clean out because it their browser
does crash a user will try to re-connect and will have to wait for the next
cleanup to kick in.

Would it be possible to do something like this?

User arrives at the site with the relevant certificate fields set in their
cgi vars.  
Set session.authenticated="TRUE", possibly insert the username and with
cookie CFID into an application level struct or array (I'm not expecting
large numbers of users so I'd prefer not to have to make a trip to the
database).

If that user tries to log in on another machine:
Search the application array to see if they're already logged in looking for
the right username and when you find it, you try to read their cookie CFID.
Deny access if you can read it, if you can't it means that their session has
ended and then go ahead and authenticate them.
How would you try to read another user's cookie though?

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:38 AM
To: CF-Talk
Subject: RE: Concurrent users and client certificates


Seems fairly easy...

In you application.cfm you need to do something like:
a = username
b = locationname
if (select * from database where username=A => no records) and not
(session.ok != OK)
insert into database (UserName, Location, time) values
(A,B,now())
session.ok = OK
(1) else if (select * from database where username=A => 1 record) and 
  (query.location = B)
update database (UserName, Location, time) values
(A,B,now()) where username=a
session.ok = OK
else
print "Already connected"
fi

Periodicly, you need to go through the table and remove all records where
time is further ago than now() - lifetime_of_session.
Trouble is, when the user A closes their browser, then repoens it, we have
to force a login,, hence (1).
However, you still have problems if they close their browser, and open a new
one from a new location before the periodic clean out gets done - tune your
lifetimes down :-)

-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 3:28 PM
To: CF-Talk
Subject: Concurrent users and client certificates


Hi all,

I need to meet a business requirement where the same user cannot be logged
in concurrently, i.e. if I log in a kgilchrist from one machine, I can't log
in again from another machine until at least the first session ends.

At the moment users are given a client certificate which I authenticate
against a database and I then set a few session variables to mark them as
authenticated etc.  The session vars are disassociated when the browser
closes loses the temp cookie.

As part of the authentication process, do I need to somehow search through
all the other sets of session variables?  How would I do that?

>From reading some of the threads on the list it seems that using session
variables isn't necessarily a good thing either.  Need to do some
reading

Thanks,
Kevin

Kevin Gilchrist
Senior Consultant
RedSiren Technologies Inc.
(412) 281 4427 ext 466
~~
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: Concurrent users and client certificates

[Bryan LaPlante]

Ok if my logic is not totally wacky here, what I am proposing is that the
top level application variable will come and go with ever page request. The
factor that determines that the user is loggedin is a match between the
application and cookie var of the same name.


 
  
  
 
  
  
 

 
 
 


- Original Message -
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:27 AM
Subject: Concurrent users and client certificates


> Hi all,
>
> I need to meet a business requirement where the same user cannot be logged
> in concurrently, i.e. if I log in a kgilchrist from one machine, I can't
log
> in again from another machine until at least the first session ends.
>
> At the moment users are given a client certificate which I authenticate
> against a database and I then set a few session variables to mark them as
> authenticated etc.  The session vars are disassociated when the browser
> closes loses the temp cookie.
>
> As part of the authentication process, do I need to somehow search through
> all the other sets of session variables?  How would I do that?
>
> >From reading some of the threads on the list it seems that using session
> variables isn't necessarily a good thing either.  Need to do some
> reading
>
> Thanks,
> Kevin
>
> Kevin Gilchrist
> Senior Consultant
> RedSiren Technologies Inc.
> (412) 281 4427 ext 466
>
>
~~
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: Concurrent users and client certificates

[Tumy, Brad]

yeah I think your right...sorry didn't think through fully before I
responded.

-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:42 AM
To: CF-Talk
Subject: RE: Concurrent users and client certificates


Thanks for your answer Brad!
I thought of this but what would happen if the browser crashed or was
closed?
The Boolean field would need to reset to zero to allow the user log back in
again but I can't trigger that kind of query without a client request or by
scheduled process right?

-Original Message-
From: Tumy, Brad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:27 AM
To: CF-Talk
Subject: RE: Concurrent users and client certificates


Kevin,

add a boolean field to your user table called "loggedin" ...when you query
the table to authenticate check the value of this field...if 0...user can
log in...otherwise "sorry you are already logged in"...be sure to trip this
field to 1...whenever the user logs in.

Brad Tumy

-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:28 AM
To: CF-Talk
Subject: Concurrent users and client certificates


Hi all,

I need to meet a business requirement where the same user cannot be logged
in concurrently, i.e. if I log in a kgilchrist from one machine, I can't log
in again from another machine until at least the first session ends.

At the moment users are given a client certificate which I authenticate
against a database and I then set a few session variables to mark them as
authenticated etc.  The session vars are disassociated when the browser
closes loses the temp cookie.

As part of the authentication process, do I need to somehow search through
all the other sets of session variables?  How would I do that?

>From reading some of the threads on the list it seems that using session
variables isn't necessarily a good thing either.  Need to do some
reading

Thanks,
Kevin

Kevin Gilchrist
Senior Consultant
RedSiren Technologies Inc.
(412) 281 4427 ext 466
~~
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: Concurrent users and client certificates

[Tumy, Brad]

Kevin,

add a boolean field to your user table called "loggedin" ...when you query
the table to authenticate check the value of this field...if 0...user can
log in...otherwise "sorry you are already logged in"...be sure to trip this
field to 1...whenever the user logs in.

Brad Tumy

-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:28 AM
To: CF-Talk
Subject: Concurrent users and client certificates


Hi all,

I need to meet a business requirement where the same user cannot be logged
in concurrently, i.e. if I log in a kgilchrist from one machine, I can't log
in again from another machine until at least the first session ends.

At the moment users are given a client certificate which I authenticate
against a database and I then set a few session variables to mark them as
authenticated etc.  The session vars are disassociated when the browser
closes loses the temp cookie.

As part of the authentication process, do I need to somehow search through
all the other sets of session variables?  How would I do that?

>From reading some of the threads on the list it seems that using session
variables isn't necessarily a good thing either.  Need to do some
reading

Thanks,
Kevin

Kevin Gilchrist
Senior Consultant
RedSiren Technologies Inc.
(412) 281 4427 ext 466
~~
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

Concurrent users and client certificates

[Kevin Gilchrist]

Hi all,

I need to meet a business requirement where the same user cannot be logged
in concurrently, i.e. if I log in a kgilchrist from one machine, I can't log
in again from another machine until at least the first session ends.

At the moment users are given a client certificate which I authenticate
against a database and I then set a few session variables to mark them as
authenticated etc.  The session vars are disassociated when the browser
closes loses the temp cookie.

As part of the authentication process, do I need to somehow search through
all the other sets of session variables?  How would I do that?

>From reading some of the threads on the list it seems that using session
variables isn't necessarily a good thing either.  Need to do some
reading

Thanks,
Kevin

Kevin Gilchrist
Senior Consultant
RedSiren Technologies Inc.
(412) 281 4427 ext 466

~~
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