RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-17 Thread Tommy Pham
stem, > please contact Linda Williams x5984 > > > > http://shhsnet/";>Return to > SHH Intranet > > > > > > > > At the end of the this page 'mainRedirect

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick (SOLVED)

2010-09-17 Thread Cheryl Sullivan
P as well - Thanks again - -Original Message- From: Andrew Ballard [mailto:aball...@gmail.com] Sent: Friday, September 17, 2010 11:15 AM To: Cheryl Sullivan Cc: Peter Lind; tommy...@gmail.com; a...@ashleysheridan.co.uk; php-general@lists.php.net Subject: Re: [PHP] Session Vars loaded f

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-17 Thread Andrew Ballard
On Fri, Sep 17, 2010 at 10:50 AM, Cheryl Sullivan wrote: > Hi there - just to clear things up, I didn't mean your answer was irrelevant. >  It was an excellent point - I just took the function call encompassing the > query string out of the code I posted to avoid people having to read too > muc

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-17 Thread Cheryl Sullivan
quot;; print "hidden_SSN = ".$_POST['hdnSSN'].""; print "hidden_CostCenter = ".$_POST['hdnCostCenter'].""; print "session_empFName = ".$_SESSION['empFName'].""; print "session_userLastName = ".$_SESSIO

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-17 Thread Andrew Ballard
On Fri, Sep 17, 2010 at 8:13 AM, Cheryl Sullivan wrote: > Hi Andrew - I didn't mean to ignore your reply... > > Here is your earlier post - > > " The fact that you can echo the $_SESSION information on the same page and > they contain the correct values suggest to me that the issue of MySQL/MSSQL

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-17 Thread Cheryl Sullivan
s to me? Thanks - -Original Message- From: Andrew Ballard [mailto:aball...@gmail.com] Sent: Thursday, September 16, 2010 2:21 PM To: Cheryl Sullivan Cc: Tommy Pham; php-general@lists.php.net Subject: Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query st

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Tommy Pham
> -Original Message- > From: Cheryl Sullivan [mailto:csull...@shh.org] > Sent: Thursday, September 16, 2010 11:12 AM > To: Tommy Pham; php-general@lists.php.net > Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those > loaded from MYSQL Query stick > >

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Peter Lind
On 16 September 2010 20:03, Cheryl Sullivan wrote: > We are actually running the query through a function that removes single > ticks, etc to avoid this, but I didn't think that was relevant to the > question so I didn't include it.  Thanks, though! You're the one with the problem you don't under

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Andrew Ballard
On Thu, Sep 16, 2010 at 10:26 AM, Cheryl Sullivan wrote: [snip] > When I echo all five $_SESSION vars from here, they are all populated. > Then I can either redirect or form post to the next page. In either > case, the $_SESSION vars populated from SQL Server ( the SSN and Cost > Center vars) are

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Cheryl Sullivan
Tommy Pham [mailto:tommy...@gmail.com] Sent: Thursday, September 16, 2010 11:39 AM To: php-general@lists.php.net Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick > -Original Message- > From: Cheryl Sullivan [mailto:csull...@shh.org] > Sent:

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Cheryl Sullivan
September 16, 2010 12:03 PM To: Cheryl Sullivan Cc: a...@ashleysheridan.co.uk; php-general@lists.php.net Subject: Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick On 16 September 2010 16:26, Cheryl Sullivan wrote: > Absolutely - > > > > Th

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Peter Lind
On 16 September 2010 16:26, Cheryl Sullivan wrote: > Absolutely - > > > > This is from the first page > > > > > $_SESSION['UserLastName'] = strtolower(trim($_POST['txtLastName'])); > > $_SESSION['BadgeID'] = trim($_POST['txtBadgeID']); > > > > //access MS SQL Server database > > $q1 = "select * f

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Tommy Pham
> -Original Message- > From: Cheryl Sullivan [mailto:csull...@shh.org] > Sent: Thursday, September 16, 2010 8:33 AM > To: Tommy Pham; php-general@lists.php.net > Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those > loaded from MYSQL Query stick >

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Cheryl Sullivan
tommy...@gmail.com] Sent: Thursday, September 16, 2010 11:00 AM To: php-general@lists.php.net Subject: RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick > -Original Message- > From: Cheryl Sullivan [mailto:csull...@shh.org] > Sent: Thursday, Sept

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Andrew Ballard
On Thu, Sep 16, 2010 at 10:26 AM, Cheryl Sullivan wrote: > Absolutely - > > This is from the first page > > > $_SESSION['UserLastName'] = strtolower(trim($_POST['txtLastName'])); > > $_SESSION['BadgeID'] = trim($_POST['txtBadgeID']); > > //access MS SQL Server database > > $q1 = "select * from em

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Tommy Pham
> -Original Message- > From: Cheryl Sullivan [mailto:csull...@shh.org] > Sent: Thursday, September 16, 2010 7:12 AM > To: php-general@lists.php.net > Subject: [PHP] Session Vars loaded from MSSQL Query drop, those loaded > from MYSQL Query stick > > Hi there – I’

RE: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Cheryl Sullivan
__ From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] Sent: Thursday, September 16, 2010 10:14 AM To: Cheryl Sullivan Cc: php-general@lists.php.net Subject: Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick On Thu, 2010-09-16 at 10:11 -0400, Cheryl Sulliv

Re: [PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Ashley Sheridan
On Thu, 2010-09-16 at 10:11 -0400, Cheryl Sullivan wrote: > Hi there – I’m new to this news group. Any help with this is appreciated – > > When I populate session vars from a MYSQL query, they are still there when I > change pages. If I populate them from an MSSQL query, they drop. > > It d

[PHP] Session Vars loaded from MSSQL Query drop, those loaded from MYSQL Query stick

2010-09-16 Thread Cheryl Sullivan
Hi there – I’m new to this news group. Any help with this is appreciated – When I populate session vars from a MYSQL query, they are still there when I change pages. If I populate them from an MSSQL query, they drop. It doesn't matter if I get to the next page using a header redirect or a fo