sending info to a database from server-side
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Macromedia Flash Server > sending info to a database from server-side




Pages (2): [1] 2 »   Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-26-05 10: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






[ Post a follow-up to this message ]



    RE: sending info to a database from server-side  
Stefan Richter


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-26-05 10: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.gman
e.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/9ZfFG6B
LHNm@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






[ Post a follow-up to this message ]



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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-26-05 10: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.gm
ane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gman
e.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/9ZfFG6B
LHNm@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






[ Post a follow-up to this message ]



    RE: sending info to a database from server-side  
Stefan Richter


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-26-05 10: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.gman
e.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/9ZfFG
6BLHNm@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@pub
lic.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






[ Post a follow-up to this message ]



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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-26-05 10: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.gm
ane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gman
e.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/9ZfFG
6BLHNm@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@pub
lic.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






[ Post a follow-up to this message ]



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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-27-05 10: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.gm
ane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gman
e.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/9ZfFG6B
LHNm@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






[ Post a follow-up to this message ]



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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-27-05 10: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.gm
ane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gman
e.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/9ZfFG6B
LHNm@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






[ Post a follow-up to this message ]



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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-28-05 01:45 AM

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.gm
ane.org>


To
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gm
ane.org>
cc
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gm
ane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gman
e.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/9ZfFG6B
LHNm@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






[ Post a follow-up to this message ]



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


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-28-05 01:45 AM

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.gm
ane.org>


To
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gm
ane.org>
cc
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gm
ane.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.gm
ane.org>


To
FlashComm Mailing List <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@public.gm
ane.org>
cc
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gm
ane.org>


To
"'FlashComm Mailing List'" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@publi
c.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.gman
e.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/9ZfFG6B
LHNm@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






[ Post a follow-up to this message ]



    Re: sending info to a database from server-side  
Simon Skrødal


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
08-29-05 07: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@pub
lic.gmane.org>
Cc: "FlashComm Mailing List" <flashcomm-1Ss2GqJETD3yZ38Mhd3e/9ZfFG6BLHNm@pub
lic.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.o
rg
> 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.o
rg
> 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@pub
lic.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.o
rg
> 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@pub
lic.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






[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 06:22 AM.      Post New Thread    Post A Reply      
Pages (2): [1] 2 »   Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register