Macromedia Flash Server - sending info to a database from server-side

This is Interesting: Free IT Magazines  
Home > Archive > Macromedia Flash Server > August 2005 > sending info to a database from server-side





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author sending info to a database from server-side
Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-26, 5:45 pm

I've seen several threads on this topic. We have a tracking system setup
in order to track the time a user connects and disconnects from the
server. Everything is saved in clientGlobals, and then written to a
shared object on application.onDisconnect. I'd like to save the info in a
database. What is the best way to send this info to a database on
application.onDisconnect?

Thanks,
Brandon

=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Stefan Richter

2005-08-26, 5:45 pm


There is a way to send message from FCS to ASP (or another script lannguage)
without remoting, but you don't get the response. It may work for you.

// inside onDisconnect
var myConn = new NetConnection();
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
myConn.call("",null);

HTH

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 7:50 PM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: [FlashComm] sending info to a database from server-side
>
> I've seen several threads on this topic. We have a tracking
> system setup in order to track the time a user connects and
> disconnects from the server. Everything is saved in
> clientGlobals, and then written to a shared object on
> application.onDisconnect. I'd like to save the info in a
> database. What is the best way to send this info to a
> database on application.onDisconnect?
>
> Thanks,
> Brandon
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-26, 5:45 pm

That might work. You mentioned that this is a way to do it "without
remoting". Do you not recommend remoting?

Thanks,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/26/2005 03:06 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side







There is a way to send message from FCS to ASP (or another script
lannguage)
without remoting, but you don't get the response. It may work for you.

// inside onDisconnect
var myConn = new NetConnection();
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
myConn.call("",null);

HTH

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 7:50 PM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: [FlashComm] sending info to a database from server-side
>
> I've seen several threads on this topic. We have a tracking
> system setup in order to track the time a user connects and
> disconnects from the server. Everything is saved in
> clientGlobals, and then written to a shared object on
> application.onDisconnect. I'd like to save the info in a
> database. What is the best way to send this info to a
> database on application.onDisconnect?
>
> Thanks,
> Brandon
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Stefan Richter

2005-08-26, 5:45 pm

Nono, Remoting is great but if all you need is send something onDisconnect
then this may be easier to use and implement.
If you got Coldfusion then Remoting is already built in.

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 8:10 PM
> To: FlashComm Mailing List
> Cc: 'FlashComm Mailing List'; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: RE: [FlashComm] sending info to a database from server-side
>
> That might work. You mentioned that this is a way to do it
> "without remoting". Do you not recommend remoting?
>
> Thanks,
> Brandon
>
>
>
>
> "Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org> Sent by:
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/26/2005 03:06 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
>
> There is a way to send message from FCS to ASP (or another script
> lannguage)
> without remoting, but you don't get the response. It may work for you.
>
> // inside onDisconnect
> var myConn = new NetConnection();
> myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
> myConn.call("",null);
>
> HTH
>
> Stefan
>
>
>
>
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-26, 5:45 pm

I don't have ColdFusion, but I can still install the necessary gateway
remoting files on the webserver, no? I'll try your way first though.

Thanks,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/26/2005 03:24 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side






Nono, Remoting is great but if all you need is send something onDisconnect
then this may be easier to use and implement.
If you got Coldfusion then Remoting is already built in.

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 8:10 PM
> To: FlashComm Mailing List
> Cc: 'FlashComm Mailing List'; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: RE: [FlashComm] sending info to a database from server-side
>
> That might work. You mentioned that this is a way to do it
> "without remoting". Do you not recommend remoting?
>
> Thanks,
> Brandon
>
>
>
>
> "Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org> Sent by:
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/26/2005 03:06 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
>
> There is a way to send message from FCS to ASP (or another script
> lannguage)
> without remoting, but you don't get the response. It may work for you.
>
> // inside onDisconnect
> var myConn = new NetConnection();
> myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
> myConn.call("",null);
>
> HTH
>
> Stefan
>
>
>
>
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-27, 5:45 pm

Hmmm. Can't get this to work. Got this server-side, inside of
application.onDisconnect = function ( client ) {

var myConn = new NetConnection();
var myUrl = "http://.../record.asp?user=" + cglobal.user + "&inDate=" +
cglobal.dateIn + "&inTime=" + cglobal.hoursIn + "&outTime=" +
cglobal.hoursOut;
myConn.connect(myUrl);
myConn.call("",null);

If I hit the .asp page directly, the values are entered into an access
database, no problem. Nothing happens when I close my browser to log out
of the session, activating onDisconnect.

Thanks,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/26/2005 03:06 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side







There is a way to send message from FCS to ASP (or another script
lannguage)
without remoting, but you don't get the response. It may work for you.

// inside onDisconnect
var myConn = new NetConnection();
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
myConn.call("",null);

HTH

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 7:50 PM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: [FlashComm] sending info to a database from server-side
>
> I've seen several threads on this topic. We have a tracking
> system setup in order to track the time a user connects and
> disconnects from the server. Everything is saved in
> clientGlobals, and then written to a shared object on
> application.onDisconnect. I'd like to save the info in a
> database. What is the best way to send this info to a
> database on application.onDisconnect?
>
> Thanks,
> Brandon
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-27, 5:45 pm

Do I need to activate the onDisconnect WITHOUT closing my browser?

Thanks,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/26/2005 03:06 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side







There is a way to send message from FCS to ASP (or another script
lannguage)
without remoting, but you don't get the response. It may work for you.

// inside onDisconnect
var myConn = new NetConnection();
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
myConn.call("",null);

HTH

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 7:50 PM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: [FlashComm] sending info to a database from server-side
>
> I've seen several threads on this topic. We have a tracking
> system setup in order to track the time a user connects and
> disconnects from the server. Everything is saved in
> clientGlobals, and then written to a shared object on
> application.onDisconnect. I'd like to save the info in a
> database. What is the best way to send this info to a
> database on application.onDisconnect?
>
> Thanks,
> Brandon
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-27, 8:45 pm

OK, it works when I give myConn.connect() a full URL in quotes:

var myConn = new NetConnection();
myConn.connect("http://.../record.asp?user=brandon&inTime=1245&outTime=115");
myConn.call("",null);

Info is stored in databse no problem. I can't seem to make this work
though. If I do a trace, the entire URL is correct.

var myConn = new NetConnection();
var myUrl = "http://.../record.asp?user=" + cglobal.user + "&inDate=" +
cglobal.dateIn + "&inTime=" + cglobal.hoursIn + "&outTime=" +
cglobal.hoursOut;
myConn.connect(myUrl);
myConn.call("",null);

trace(myUrl);

I tried this as well:
myConn.connect("'" + myUrl + "'");





Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/27/2005 05:09 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
Subject
RE: [FlashComm] sending info to a database from server-side






Do I need to activate the onDisconnect WITHOUT closing my browser?

Thanks,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/26/2005 03:06 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side







There is a way to send message from FCS to ASP (or another script
lannguage)
without remoting, but you don't get the response. It may work for you.

// inside onDisconnect
var myConn = new NetConnection();
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
myConn.call("",null);

HTH

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 7:50 PM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: [FlashComm] sending info to a database from server-side
>
> I've seen several threads on this topic. We have a tracking
> system setup in order to track the time a user connects and
> disconnects from the server. Everything is saved in
> clientGlobals, and then written to a shared object on
> application.onDisconnect. I'd like to save the info in a
> database. What is the best way to send this info to a
> database on application.onDisconnect?
>
> Thanks,
> Brandon
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-27, 8:45 pm

Got it.

var myConn = new NetConnection();
var myUrl = "http://..../record.asp?user=" + cglobal.user + "&inDate=" +
cglobal.dateIn + "&inTime=" + cglobal.hoursIn + "&outTime=" +
cglobal.hoursOut;
myConn.connect(myUrl);
myConn.call("",null);

Any spaces in any of the variables cause an error. I'll just create a
function to remove any spaces.

Thanks,
Brandon




Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/27/2005 07:17 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
Subject
RE: [FlashComm] sending info to a database from server-side






OK, it works when I give myConn.connect() a full URL in quotes:

var myConn = new NetConnection();
myConn.connect("http://.../record.asp?user=brandon&inTime=1245&outTime=115
");
myConn.call("",null);

Info is stored in databse no problem. I can't seem to make this work
though. If I do a trace, the entire URL is correct.

var myConn = new NetConnection();
var myUrl = "http://.../record.asp?user=" + cglobal.user + "&inDate=" +
cglobal.dateIn + "&inTime=" + cglobal.hoursIn + "&outTime=" +
cglobal.hoursOut;
myConn.connect(myUrl);
myConn.call("",null);

trace(myUrl);

I tried this as well:
myConn.connect("'" + myUrl + "'");





Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/27/2005 05:09 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
Subject
RE: [FlashComm] sending info to a database from server-side






Do I need to activate the onDisconnect WITHOUT closing my browser?

Thanks,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/26/2005 03:06 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side







There is a way to send message from FCS to ASP (or another script
lannguage)
without remoting, but you don't get the response. It may work for you.

// inside onDisconnect
var myConn = new NetConnection();
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=disconnect&user=100");
myConn.call("",null);

HTH

Stefan



> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Friday, August 26, 2005 7:50 PM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: [FlashComm] sending info to a database from server-side
>
> I've seen several threads on this topic. We have a tracking
> system setup in order to track the time a user connects and
> disconnects from the server. Everything is saved in
> clientGlobals, and then written to a shared object on
> application.onDisconnect. I'd like to save the info in a
> database. What is the best way to send this info to a
> database on application.onDisconnect?
>
> Thanks,
> Brandon
>
> =-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Simon Skrødal

2005-08-29, 2:45 am

Hi Brandon,

Just a quick tip for you before you end up spending hours of de-bugging
because your logging does not always work, or you get erroneous data:

There is a bug with FlashCom, which sometimes causes the onDisconnect()
function not to fire when a client disconnects. This will cause the clien=
t
to be stuck in the system for however long it takes for the application t=
o
shut down. When the app unloads, the client(s) that did not disconnect
properly will finally unload and fire onDisconnect(), however, you will f=
ind
that some of the log data will be corrupted (in particular bytes_out).
Sometimes the app and/or stream name will be missing.

I have reported this bug to MM a couple of times, without any feedback. A
little disappointing, since I know they have helped a different company f=
ind
a fix for the bug, but without posting a technote or anything.

This bug is my little pet-hate, and I can't wait to learn how to get rid =
of
it.

Kind regards,
Simon Skr=F8dal



----- Original Message -----=20
From: <Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org>
To: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>;
<flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
Sent: Sunday, August 28, 2005 10:35 AM
Subject: RE: [FlashComm] sending info to a database from server-side


> Got it.
>
> var myConn =3D new NetConnection();
> var myUrl =3D "http://..../record.asp?user=3D" + cglobal.user + "&inDat=

e=3D" +
> cglobal.dateIn + "&inTime=3D" + cglobal.hoursIn + "&outTime=3D" +
> cglobal.hoursOut;
> myConn.connect(myUrl);
> myConn.call("",null);
>
> Any spaces in any of the variables cause an error. I'll just create a
> function to remove any spaces.
>
> Thanks,
> Brandon
>
>
>
>
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/27/2005 07:17 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
> OK, it works when I give myConn.connect() a full URL in quotes:
>
> var myConn =3D new NetConnection();
> myConn.connect("http://.../record.asp?user=3Dbrandon&inTime=3D1245&outT=

ime=3D115
> ");
> myConn.call("",null);
>
> Info is stored in databse no problem. I can't seem to make this work
> though. If I do a trace, the entire URL is correct.
>
> var myConn =3D new NetConnection();
> var myUrl =3D "http://.../record.asp?user=3D" + cglobal.user + "&inDate=

=3D" +
> cglobal.dateIn + "&inTime=3D" + cglobal.hoursIn + "&outTime=3D" +
> cglobal.hoursOut;
> myConn.connect(myUrl);
> myConn.call("",null);
>
> trace(myUrl);
>
> I tried this as well:
> myConn.connect("'" + myUrl + "'");
>
>
>
>
>
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/27/2005 05:09 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
> "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
> Do I need to activate the onDisconnect WITHOUT closing my browser?
>
> Thanks,
> Brandon
>
>
>
>
> "Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/26/2005 03:06 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
>
> There is a way to send message from FCS to ASP (or another script
> lannguage)
> without remoting, but you don't get the response. It may work for you.
>
> // inside onDisconnect
> var myConn =3D new NetConnection();
> myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=3Ddisconnect&user=3D100")=

;
> myConn.call("",null);
>
> HTH
>
> Stefan
>
>
>
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=3D-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=3D-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-29, 2:45 am

Simon:

Thanks for the note. I've heard of this issue, but I'd have the same=20
problem if I saved the data in a shared object onDisconnect(). Either=20
way, it's an onDisconnect issue. I can't really afford to not depend on=20
it at this point. If it doesn't fire, then I'll chalk it up to the bug.=20


Thanks again,
Brandon




Simon Skr=F8dal <simon-fOXyMSD3e6XvnOemgxGiVw@public.gmane.org>=20
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/28/2005 09:53 PM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
Re: [FlashComm] sending info to a database from server-side






Hi Brandon,

Just a quick tip for you before you end up spending hours of de-bugging
because your logging does not always work, or you get erroneous data:

There is a bug with FlashCom, which sometimes causes the onDisconnect()
function not to fire when a client disconnects. This will cause the client
to be stuck in the system for however long it takes for the application to
shut down. When the app unloads, the client(s) that did not disconnect
properly will finally unload and fire onDisconnect(), however, you will=20
find
that some of the log data will be corrupted (in particular bytes=5Fout).
Sometimes the app and/or stream name will be missing.

I have reported this bug to MM a couple of times, without any feedback. A
little disappointing, since I know they have helped a different company=20
find
a fix for the bug, but without posting a technote or anything.

This bug is my little pet-hate, and I can't wait to learn how to get rid=20
of
it.

Kind regards,
Simon Skr=F8dal



----- Original Message -----=20
From: <Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org>
To: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>;
<flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
Sent: Sunday, August 28, 2005 10:35 AM
Subject: RE: [FlashComm] sending info to a database from server-side


> Got it.
>
> var myConn =3D new NetConnection();
> var myUrl =3D "http://..../record.asp?user=3D" + cglobal.user + "&inDate=

=3D" +
> cglobal.dateIn + "&inTime=3D" + cglobal.hoursIn + "&outTime=3D" +
> cglobal.hoursOut;
> myConn.connect(myUrl);
> myConn.call("",null);
>
> Any spaces in any of the variables cause an error. I'll just create a
> function to remove any spaces.
>
> Thanks,
> Brandon
>
>
>
>
> Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/27/2005 07:17 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
> OK, it works when I give myConn.connect() a full URL in quotes:
>
> var myConn =3D new NetConnection();
> myConn.connect("

http://.../record.asp?user=3Dbrando...5&outTime=3D115
> ");
> myConn.call("",null);
>
> Info is stored in databse no problem. I can't seem to make this work
> though. If I do a trace, the entire URL is correct.
>
> var myConn =3D new NetConnection();
> var myUrl =3D "http://.../record.asp?user=3D" + cglobal.user + "&inDate=

=3D" +
> cglobal.dateIn + "&inTime=3D" + cglobal.hoursIn + "&outTime=3D" +
> cglobal.hoursOut;
> myConn.connect(myUrl);
> myConn.call("",null);
>
> trace(myUrl);
>
> I tried this as well:
> myConn.connect("'" + myUrl + "'");
>
>
>
>
>
> Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/27/2005 05:09 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
> "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>,
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
> Do I need to activate the onDisconnect WITHOUT closing my browser?
>
> Thanks,
> Brandon
>
>
>
>
> "Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/26/2005 03:06 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>
> Subject
> RE: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
>
> There is a way to send message from FCS to ASP (or another script
> lannguage)
> without remoting, but you don't get the response. It may work for you.
>
> // inside onDisconnect
> var myConn =3D new NetConnection();
> myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=3Ddisconnect&user=3D100");
> myConn.call("",null);
>
> HTH
>
> Stefan
>
>
>
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=3D-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=3D-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Stefan Richter

2005-08-29, 5:50 pm

If you close your browser the onDisconnect event does not fire straight
away. It will and may take a bit of time for FCS to garbage collect
disconnected clients. Mac users may take longer to trigger ondisc that =
Win
users.

Therefore you should first test your logic by using a nc.close in your =
app
(a logoff button). Once that works and fires the asp script you should =
lower
your garbage collection and app idle times (check your server config xml
files for details on that) and deploy some scripts on the client and =
server
which will help trigger the ondisconnect sooner.=20
The latter has been discussed a gazillion times, this may get you =
started
http://www.flashcomguru.com/forum/f...TID=3D23&PN=3D1

Stefan


=20

> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org=20
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of=20
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Monday, August 29, 2005 3:35 AM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: Re: [FlashComm] sending info to a database from server-side
>=20
> Simon:
>=20
> Thanks for the note. I've heard of this issue, but I'd have=20
> the same problem if I saved the data in a shared object=20
> onDisconnect(). Either way, it's an onDisconnect issue. I=20
> can't really afford to not depend on it at this point. If it=20
> doesn't fire, then I'll chalk it up to the bug.=20
>
>=20
> Thanks again,
> Brandon
>=20
>=20
>=20
>=20
> Simon Skr=F8dal <simon-fOXyMSD3e6XvnOemgxGiVw@public.gmane.org>
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/28/2005 09:53 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>=20
>=20
> To
> "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>=20
> Subject
> Re: [FlashComm] sending info to a database from server-side
>=20
>=20
>=20
>=20
>=20
>=20
> Hi Brandon,
>=20
> Just a quick tip for you before you end up spending hours of=20
> de-bugging
> because your logging does not always work, or you get erroneous data:
>=20
> There is a bug with FlashCom, which sometimes causes the=20
> onDisconnect()
> function not to fire when a client disconnects. This will=20
> cause the client
> to be stuck in the system for however long it takes for the=20
> application to
> shut down. When the app unloads, the client(s) that did not disconnect
> properly will finally unload and fire onDisconnect(),=20
> however, you will=20
> find
> that some of the log data will be corrupted (in particular bytes_out).
> Sometimes the app and/or stream name will be missing.
>=20
> I have reported this bug to MM a couple of times, without any=20
> feedback. A
> little disappointing, since I know they have helped a=20
> different company=20
> find
> a fix for the bug, but without posting a technote or anything.
>=20
> This bug is my little pet-hate, and I can't wait to learn how=20
> to get rid=20
> of
> it.
>=20
> Kind regards,
> Simon Skr=F8dal
>=20
>=20
>=20
> ----- Original Message -----=20
> From: <Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org>
> To: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>;
> <flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Sent: Sunday, August 28, 2005 10:35 AM
> Subject: RE: [FlashComm] sending info to a database from server-side
>=20
>=20
> "&inDate=3D" +
> just create a
> http://.../record.asp?user=3Dbrando...5&outTime=3D115
> this work
> "&inDate=3D" +
> work for you.
myConn.connect("http://xxxxxxxx/xxxxx.asp?msg=3Ddisconnect&user=3D100");[vbcol=seagreen]
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
>=20
>=20
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>=20
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>=20
>=20
> =3D---------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D---------------------------------------------------------
>=20
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>=20



=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-29, 5:50 pm

Thanks a lot.

Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>=20
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/29/2005 09:40 AM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side






If you close your browser the onDisconnect event does not fire straight
away. It will and may take a bit of time for FCS to garbage collect
disconnected clients. Mac users may take longer to trigger ondisc that Win
users.

Therefore you should first test your logic by using a nc.close in your app
(a logoff button). Once that works and fires the asp script you should=20
lower
your garbage collection and app idle times (check your server config xml
files for details on that) and deploy some scripts on the client and=20
server
which will help trigger the ondisconnect sooner.=20
The latter has been discussed a gazillion times, this may get you started
http://www.flashcomguru.com/forum/f...TID=3D23&PN=3D1

Stefan


=20

> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org=20
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of=20
> Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Monday, August 29, 2005 3:35 AM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: Re: [FlashComm] sending info to a database from server-side
>=20
> Simon:
>=20
> Thanks for the note. I've heard of this issue, but I'd have=20
> the same problem if I saved the data in a shared object=20
> onDisconnect(). Either way, it's an onDisconnect issue. I=20
> can't really afford to not depend on it at this point. If it=20
> doesn't fire, then I'll chalk it up to the bug.=20
>
>=20
> Thanks again,
> Brandon
>=20
>=20
>=20
>=20
> Simon Skr=F8dal <simon-fOXyMSD3e6XvnOemgxGiVw@public.gmane.org>
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/28/2005 09:53 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>=20
>=20
> To
> "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>=20
> Subject
> Re: [FlashComm] sending info to a database from server-side
>=20
>=20
>=20
>=20
>=20
>=20
> Hi Brandon,
>=20
> Just a quick tip for you before you end up spending hours of=20
> de-bugging
> because your logging does not always work, or you get erroneous data:
>=20
> There is a bug with FlashCom, which sometimes causes the=20
> onDisconnect()
> function not to fire when a client disconnects. This will=20
> cause the client
> to be stuck in the system for however long it takes for the=20
> application to
> shut down. When the app unloads, the client(s) that did not disconnect
> properly will finally unload and fire onDisconnect(),=20
> however, you will=20
> find
> that some of the log data will be corrupted (in particular bytes=5Fout).
> Sometimes the app and/or stream name will be missing.
>=20
> I have reported this bug to MM a couple of times, without any=20
> feedback. A
> little disappointing, since I know they have helped a=20
> different company=20
> find
> a fix for the bug, but without posting a technote or anything.
>=20
> This bug is my little pet-hate, and I can't wait to learn how=20
> to get rid=20
> of
> it.
>=20
> Kind regards,
> Simon Skr=F8dal
>=20
>=20
>=20
> ----- Original Message -----=20
> From: <Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org>
> To: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>;
> <flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Sent: Sunday, August 28, 2005 10:35 AM
> Subject: RE: [FlashComm] sending info to a database from server-side
>=20
>=20
> "&inDate=3D" +
> just create a
> http://.../record.asp?user=3Dbrando...5&outTime=3D115
> this work
> "&inDate=3D" +
> work for you.
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
>=20
>=20
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>=20
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>=20
>=20
> =3D---------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D---------------------------------------------------------
>=20
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>=20



=3D-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=3D-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+w

2005-08-29, 5:50 pm

Seems to work like a charm. Right into the database. Ultimately, it's=20
going to go to a Lotus Notes database, but testing with an Access Database =

seems to work fine.

I've been doing this same sort of onDisconnect thing, writing the data to=20
a shared object for some time now. Haven't seen too many problems with=20
onDisconnect not firing, although I have read about it.=20

Thanks again,
Brandon




"Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>=20
Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
08/29/2005 09:40 AM
Please respond to
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
cc

Subject
RE: [FlashComm] sending info to a database from server-side






If you close your browser the onDisconnect event does not fire straight
away. It will and may take a bit of time for FCS to garbage collect
disconnected clients. Mac users may take longer to trigger ondisc that Win
users.

Therefore you should first test your logic by using a nc.close in your app
(a logoff button). Once that works and fires the asp script you should=20
lower
your garbage collection and app idle times (check your server config xml
files for details on that) and deploy some scripts on the client and=20
server
which will help trigger the ondisconnect sooner.=20
The latter has been discussed a gazillion times, this may get you started
http://www.flashcomguru.com/forum/f...TID=3D23&PN=3D1

Stefan


=20

> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org=20
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of=20
> Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Monday, August 29, 2005 3:35 AM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: Re: [FlashComm] sending info to a database from server-side
>=20
> Simon:
>=20
> Thanks for the note. I've heard of this issue, but I'd have=20
> the same problem if I saved the data in a shared object=20
> onDisconnect(). Either way, it's an onDisconnect issue. I=20
> can't really afford to not depend on it at this point. If it=20
> doesn't fire, then I'll chalk it up to the bug.=20
>
>=20
> Thanks again,
> Brandon
>=20
>=20
>=20
>=20
> Simon Skr=F8dal <simon-fOXyMSD3e6XvnOemgxGiVw@public.gmane.org>
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/28/2005 09:53 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>=20
>=20
> To
> "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>=20
> Subject
> Re: [FlashComm] sending info to a database from server-side
>=20
>=20
>=20
>=20
>=20
>=20
> Hi Brandon,
>=20
> Just a quick tip for you before you end up spending hours of=20
> de-bugging
> because your logging does not always work, or you get erroneous data:
>=20
> There is a bug with FlashCom, which sometimes causes the=20
> onDisconnect()
> function not to fire when a client disconnects. This will=20
> cause the client
> to be stuck in the system for however long it takes for the=20
> application to
> shut down. When the app unloads, the client(s) that did not disconnect
> properly will finally unload and fire onDisconnect(),=20
> however, you will=20
> find
> that some of the log data will be corrupted (in particular bytes=5Fout).
> Sometimes the app and/or stream name will be missing.
>=20
> I have reported this bug to MM a couple of times, without any=20
> feedback. A
> little disappointing, since I know they have helped a=20
> different company=20
> find
> a fix for the bug, but without posting a technote or anything.
>=20
> This bug is my little pet-hate, and I can't wait to learn how=20
> to get rid=20
> of
> it.
>=20
> Kind regards,
> Simon Skr=F8dal
>=20
>=20
>=20
> ----- Original Message -----=20
> From: <Brandon=5FKrakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org>
> To: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>;
> <flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Sent: Sunday, August 28, 2005 10:35 AM
> Subject: RE: [FlashComm] sending info to a database from server-side
>=20
>=20
> "&inDate=3D" +
> just create a
> http://.../record.asp?user=3Dbrando...5&outTime=3D115
> this work
> "&inDate=3D" +
> work for you.
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
>=20
>=20
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>=20
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>=20
>=20
> =3D---------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D---------------------------------------------------------
>=20
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>=20



=3D-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=3D-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Simon Skrødal

2005-08-30, 2:46 am

Hi Stefan,

The problem is more serious than just a bit of wait time - sometimes a
client will not be disconnected until the application terminates, which m=
ay
take hours. Personally, I solve the problem by pinging each client at a
regular interval and disconnect the ones who do not respond (thanks, Peld=
i).
First problem solved.

The second problem has to do with erroneous data received from a client t=
hat
does not trigger onDisconnect() in a normal fashion. The outcome is norma=
lly
a bytes_out value of 2, 4 or 8GB(!), and sometimes no app and/or stream
name.

Now, the logic of my program seems to work as it should, and correct me i=
f I
am wrong, but shouldn't FCS detect when a browser window is closed, i.e.
shutting down the client? Normally, I would be a little more cautious
blaming this on a bug and blame my code instead. But having heard reports=
of
others having the exact same problem, and also established the correlatio=
n
between failed onDisconnect and erroneous data, I feel my suspicion is
justified.

I'd be grateful for any further input you might have.

Kind regards,
Simon Skr=F8dal

PS! The link you supplied to your forum deals with the opposite problem,
i.e. keeping a connection alive.


----- Original Message -----=20
From: "Stefan Richter" <stefan-fMeCE+ULXElEfu+5ix1nRw@public.gmane.org>
To: "'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
Sent: Monday, August 29, 2005 11:10 PM
Subject: RE: [FlashComm] sending info to a database from server-side


If you close your browser the onDisconnect event does not fire straight
away. It will and may take a bit of time for FCS to garbage collect
disconnected clients. Mac users may take longer to trigger ondisc that Wi=
n
users.

Therefore you should first test your logic by using a nc.close in your ap=
p
(a logoff button). Once that works and fires the asp script you should lo=
wer
your garbage collection and app idle times (check your server config xml
files for details on that) and deploy some scripts on the client and serv=
er
which will help trigger the ondisconnect sooner.
The latter has been discussed a gazillion times, this may get you started
http://www.flashcomguru.com/forum/f...TID=3D23&PN=3D1

Stefan




> -----Original Message-----
> From: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> [mailto:flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org] On Behalf Of
> Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org
> Sent: Monday, August 29, 2005 3:35 AM
> To: FlashComm Mailing List
> Cc: FlashComm Mailing List; flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> Subject: Re: [FlashComm] sending info to a database from server-side
>
> Simon:
>
> Thanks for the note. I've heard of this issue, but I'd have
> the same problem if I saved the data in a shared object
> onDisconnect(). Either way, it's an onDisconnect issue. I
> can't really afford to not depend on it at this point. If it
> doesn't fire, then I'll chalk it up to the bug.
>
>
> Thanks again,
> Brandon
>
>
>
>
> Simon Skr=F8dal <simon-fOXyMSD3e6XvnOemgxGiVw@public.gmane.org>
> Sent by: flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
> 08/28/2005 09:53 PM
> Please respond to
> FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
>
>
> To
> "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> cc
>
> Subject
> Re: [FlashComm] sending info to a database from server-side
>
>
>
>
>
>
> Hi Brandon,
>
> Just a quick tip for you before you end up spending hours of
> de-bugging
> because your logging does not always work, or you get erroneous data:
>
> There is a bug with FlashCom, which sometimes causes the
> onDisconnect()
> function not to fire when a client disconnects. This will
> cause the client
> to be stuck in the system for however long it takes for the
> application to
> shut down. When the app unloads, the client(s) that did not disconnect
> properly will finally unload and fire onDisconnect(),
> however, you will
> find
> that some of the log data will be corrupted (in particular bytes_out).
> Sometimes the app and/or stream name will be missing.
>
> I have reported this bug to MM a couple of times, without any
> feedback. A
> little disappointing, since I know they have helped a
> different company
> find
> a fix for the bug, but without posting a technote or anything.
>
> This bug is my little pet-hate, and I can't wait to learn how
> to get rid
> of
> it.
>
> Kind regards,
> Simon Skr=F8dal
>
>
>
> ----- Original Message -----=20
> From: <Brandon_Krakowsky-t6Q6IArRIhmxKhIkFyZ7poFTLv+wk40W@public.gmane.org>
> To: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>;
> <flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org>
> Sent: Sunday, August 28, 2005 10:35 AM
> Subject: RE: [FlashComm] sending info to a database from server-side
>
>
> "&inDate=3D" +
> just create a
> http://.../record.asp?user=3Dbrando...5&outTime=3D115
> this work
> "&inDate=3D" +
> work for you.
");[vbcol=seagreen]
> flashcomm-bounces-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gmane.org
>
>
> =3D-----------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D-----------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>
>
> =3D---------------------------------------------------------
> Supported by Fig Leaf Software - http://www.figleaf.com
> =3D---------------------------------------------------------
>
> To change your subscription options or search the archive:
> http://chattyfig.figleaf.com/mailman/listinfo/flashcomm
>



=3D---------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=3D---------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm


=3D-----------------------------------------------------------
Supported by Fig Leaf Software - http://www.figleaf.com
=3D-----------------------------------------------------------

To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcomm

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com