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

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 doesn't matter if I get to the next page using a header redirect or a form submit. I > have two session vars I'm loading from a MYSQL query and they remain, the two loaded from MSSQL > disappear. > > I have confirmed that all four session vars are loading ok initially and I can echo them out to > the page, but when the application moves to the next page via redirect or form submit, the two vars > loaded from MSSQL are empty.. > > Any ideas? > > > Cheryl L. Sullivan > Interface Analyst / Web Developer > > Sacred Heart Hospital (www.shh.org) > 421 Chew Street • Allentown, PA 18102 > Office: 610-776-4784 • Cell: 484-544-2416 >  Please consider the environment before printing this e-mail > > > > Notice: This communication, including attachments, may contain information that is confidential > and protected. It constitutes non-public information intended to be conveyed only to the designated > recipient(s). If you believe that you have received this communication in error, please notify the > sender immediately by return e-mail and promptly delete this e-mail, including attachments without > reading or saving them in any manner. The unauthorized use, dissemination, distribution, or > reproduction of this e-mail, including attachments, is prohibited and may be unlawful. Thank you. > > There should be no difference. Can we see some examples of the MySQL and the MSSQL code to see what you're doing differently? Thanks, Ash http://www.ashleysheridan.co.uk