I meant set/write session variables *without any condition* to see if this
is a logic problem or really a technical problem with the session.
--
"Patrice" <nobody@nowhere.com> a écrit dans le message de
news:%23QaIaNdjFHA.3580@TK2MSFTNGP09.phx.gbl...[color=blue]
> I don't see the "end if". If there is no record could the user proceed to
> the next page without having session variables propery set ?
>
> IMO the first step would be to set a seession variable on the first page[/color]
and[color=blue]
> writing the value on the second page. It should allow to see if this a
> problem with session variables or with the logic used...
> You can also write down the sessionid on both pages to see if this is the
> same...
>
> Good luck.
> --
>
> Patrice
>
> "Lina Manjarres" <LinaManjarres@discussions.microsoft.com> a écrit dans le
> message de news:A5EDF5A0-6F25-40E3-BB89-83E9280EEE42@microsoft.com...[color=green]
> > Oh! Yes... I have a login page where I read the session variables as[/color][/color]
this:[color=blue][color=green]
> >
> > StrCons = "SELECT * FROM mills WHERE sigla='"& Usuario &"' and Clave='"&
> > Clave &"'"
> > Call Consulta(StrCons,RSDatos,MotorBD,DSource,InCat,Usu arioSQL,Password)
> > IF NOT RSDatos.EOF AND NOT RSDatos.BOF THEN
> > Session("NIT") = RSDatos(2) 'Nit del usuario
> > Session("Fabrica") = RSDatos(1) 'Nombre del usuario
> > Session("Perfil") = RSDatos(4) 'PERFIL DEL USUARIO: FABRICA=2,[/color][/color]
AGENCIA=3,[color=blue][color=green]
> > DIAGONAL=1
> > Session("Codigo") = RSDatos(0) 'Codigo del usuario
> > Session("Filtro") = Request("Filtro")
> > Call CerrarConsulta("RSDatos")
> > Call CerrarConexion("Conexion")
> > Response.redirect PaginaDestino
> >
> >
> > Thks, Lina
> >
> > "Bullschmidt" wrote:
> >[color=darkred]
> > > I didn't see where you actually set the session variables. But on a
> > > page receiving a post you could do something like this to set them:
> > >
> > > Session("UserName") = Request.Form("UserName")
> > > Session("UserLevel") = Request.Form("UserLevel")
> > >
> > > Best regards,
> > > J. Paul Schmidt, Freelance ASP Web Developer
> > >
http://www.Bullschmidt.com
> > > ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
> > >
> > > <<
> > >
> > > All the files are in the same IIS application.
> > > I do not get error messages. A get the result wrong data'.
> > > The login filters Usr and Password and reads from SQL the profile. I
> > > need to
> > > use this profile in many pages from there on, and I can use it in the
> > > first
> > > page I go to. It seems like the Session variables were deleted or had[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > ver
> > > short live. Funny?
> > >
> > > So I have a login, and a validation page, and a Form page. Up until[/color][/color][/color]
now[color=blue][color=green][color=darkred]
> > > every thisn is correct. The form page has a combo that is filled with[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > recorset and then all the values are sent using this jscipt:
> > >
> > > function PasaValoresFab()
> > > { var Fabrica = document.frmConsulta.Fabrica.value
> > > var VecFabrica = Fabrica.split("-");
> > > document.frmConsulta.cFabrica.value = VecFabrica[0]
> > > document.frmConsulta.NombreFabrica.value = VecFabrica[1]
> > > }
> > >
> > > This is the combo code:
> > >
> > > <select name="Fabrica" tabindex="10"
> > > onChange="javascript
:PasaValoresFab();">
> > > <option selected>Escoja la fc!brica</option>
> > > <%Call ComboGR(Fabricas)%>
> > >
> > >
> > >
> > > This is the code for the form:
> > > <form method="post" action="resultado.asp" name="frmConsulta"
> > > onSubmit="return ActivarFiltro();">
> > >
> > > And this is the code for the ActivarFiltro:
> > > if (document.frmConsulta.cFabrica.value != "")
> > > { Vec[12]="(MILL ='"+document.frmConsulta.cFabrica.value +
> > > "')"
> > > Vec2[12]="Fabrica = "+document.frmConsulta.cFabrica.value[/color][/color][/color]
+[color=blue][color=green][color=darkred]
> > > " ("+
> > > document.frmConsulta.NombreFabrica.value +") "
> > > }
> > >
> > >
> > > Kind of confusing? The result page has this at some point:
> > >
> > > IF PACASOLA = "SI" THEN
> > > Call ActivarFiltroVB()
> > > ELSE
> > >
> > > Where Activar Filtro has this at some point:
> > > IF Session("PERFIL") = 3 THEN
> > > Ag = Session("CODIGO")
> > > Session("StrSQL") = Session("StrSQL") & "AND Agency = '" & Ag[/color][/color][/color]
&[color=blue][color=green][color=darkred]
> > > "' "
> > > END IF
> > > If Session("PERFIL") =2 THEN
> > > Fa = Session("Codigo")
> > > Session("StrSQL") = Session("StrSQL") &" AND Agency is not[/color][/color][/color]
null[color=blue][color=green][color=darkred]
> > > AND "
> > > Session("StrSQL") = Session("StrSQL") &" MILLS = '" & Fa & "'[/color][/color][/color]
"[color=blue][color=green][color=darkred]
> > > END IF
> > >
> > > And here is part of the problem: the Session Variable PERFIL is lost,[/color][/color][/color]
I[color=blue][color=green][color=darkred]
> > > can't make it work.
> > >
> > > Well, I guess it is all!
> > >
> > > Thanks a lot, Lina
> > > >>
> > >
> > > *** Sent via Developersdex
http://www.developersdex.com ***
> > >[/color][/color]
>
>[/color]
