Connecting Tech Pros Worldwide Forums | Help | Site Map

VB code is too fast => gives wrong value

Andre
Guest
 
Posts: n/a
#1: Jul 19 '05
Hi,

I need to fetch a value in an Access db, so i use a form to pass the
parameter for the SQL statement fromVB client to ASP. After the submit line
in VBscript, i expect the value in order to test it and go further in
VBscript. But my problem is when clicking on the button, that the VB code
doesn't wait to get that value and continues directly, so the a=<%=totd%>
line give 0 in stead of the real value. If i click a second time, i get the
value.
Any way to let de VB code after dtot.submit wait before it gets the value?
See the code:
<%
totd = 0
dat=Request.Form("dt")
If Request.Form("dt") <> "" Then totd = records()
Function records()
set objdc = Server.CreateObject("ADODB.Connection")
objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source
=d:\access\newres.mdb")
sql="select logon, count(uur) as totdag from studres where cdate(dag)='" &
dat & "' "
set rs=Server.CreateObject("ADODB.recordset")
rs.open sql, objdc, 3, 3
records=rs.recordcount
Set rs = Nothing
End Function
%>
<html><head><title>Nieuwe pagina 1</title></head><body>
<script language=vbscript>
sub hfd_onclick()
a=0
dat="6/30/2004"
document.getElementById("dt").value=dat
dtot.action="test3.asp" '=name of this file
dtot.method="post"
dtot.submit
'too fast here
a=<%=totd%> '=0 on the first click, the real value on the second
click
msgbox a
end sub
</script>
<form name=dtot>
<input name="dt" type="hidden" value="" >
<INPUT name=hfd TYPE="button">
</form>

Thanks
andré



Mark Schupp
Guest
 
Posts: n/a
#2: Jul 19 '05

re: VB code is too fast => gives wrong value


a=<%=totd%>

is in the client-side vbscript so it will already be executed (and a set to
0) before you submit the form. If you need an alert box to display a result
of the form post you will have to put it outside of the onsubmit function

Try

MsgBox "=<%=totd%>"

after the "End Sub" statement in your client-side script block

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"Andre" <aa@no.it> wrote in message
news:OK2SCgeXEHA.3112@tk2msftngp13.phx.gbl...[color=blue]
> Hi,
>
> I need to fetch a value in an Access db, so i use a form to pass the
> parameter for the SQL statement fromVB client to ASP. After the submit[/color]
line[color=blue]
> in VBscript, i expect the value in order to test it and go further in
> VBscript. But my problem is when clicking on the button, that the VB code
> doesn't wait to get that value and continues directly, so the a=<%=totd%>
> line give 0 in stead of the real value. If i click a second time, i get[/color]
the[color=blue]
> value.
> Any way to let de VB code after dtot.submit wait before it gets the value?
> See the code:
> <%
> totd = 0
> dat=Request.Form("dt")
> If Request.Form("dt") <> "" Then totd = records()
> Function records()
> set objdc = Server.CreateObject("ADODB.Connection")
> objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source
> =d:\access\newres.mdb")
> sql="select logon, count(uur) as totdag from studres where cdate(dag)='" &
> dat & "' "
> set rs=Server.CreateObject("ADODB.recordset")
> rs.open sql, objdc, 3, 3
> records=rs.recordcount
> Set rs = Nothing
> End Function
> %>
> <html><head><title>Nieuwe pagina 1</title></head><body>
> <script language=vbscript>
> sub hfd_onclick()
> a=0
> dat="6/30/2004"
> document.getElementById("dt").value=dat
> dtot.action="test3.asp" '=name of this file
> dtot.method="post"
> dtot.submit
> 'too fast here
> a=<%=totd%> '=0 on the first click, the real value on the[/color]
second[color=blue]
> click
> msgbox a
> end sub
> </script>
> <form name=dtot>
> <input name="dt" type="hidden" value="" >
> <INPUT name=hfd TYPE="button">
> </form>
>
> Thanks
> andré
>
>[/color]


Aaron [SQL Server MVP]
Guest
 
Posts: n/a
#3: Jul 19 '05

re: VB code is too fast => gives wrong value


> MsgBox "=<%=totd%>"

Or

MsgBox "<%=totd%>"

--
http://www.aspfaq.com/
(Reverse address to reply.)


Patrice
Guest
 
Posts: n/a
#4: Jul 19 '05

re: VB code is too fast => gives wrong value


It looks like you expect the change to take place immediately after calling
the submit method. Display the HTML source for your page. It's likely you'll
see :

dtot.submit
a=0
MsgBox a

So :
- the page is "submitted" (actually it's more likely "queued" as the script
must terminate before the page is really submitted)
- a is 0
- 0 is displayed

The script ends, the page is submitted and you get the new updated client
side code...

Patrice

--

"Andre" <aa@no.it> a écrit dans le message de
news:OK2SCgeXEHA.3112@tk2msftngp13.phx.gbl...[color=blue]
> Hi,
>
> I need to fetch a value in an Access db, so i use a form to pass the
> parameter for the SQL statement fromVB client to ASP. After the submit[/color]
line[color=blue]
> in VBscript, i expect the value in order to test it and go further in
> VBscript. But my problem is when clicking on the button, that the VB code
> doesn't wait to get that value and continues directly, so the a=<%=totd%>
> line give 0 in stead of the real value. If i click a second time, i get[/color]
the[color=blue]
> value.
> Any way to let de VB code after dtot.submit wait before it gets the value?
> See the code:
> <%
> totd = 0
> dat=Request.Form("dt")
> If Request.Form("dt") <> "" Then totd = records()
> Function records()
> set objdc = Server.CreateObject("ADODB.Connection")
> objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source
> =d:\access\newres.mdb")
> sql="select logon, count(uur) as totdag from studres where cdate(dag)='" &
> dat & "' "
> set rs=Server.CreateObject("ADODB.recordset")
> rs.open sql, objdc, 3, 3
> records=rs.recordcount
> Set rs = Nothing
> End Function
> %>
> <html><head><title>Nieuwe pagina 1</title></head><body>
> <script language=vbscript>
> sub hfd_onclick()
> a=0
> dat="6/30/2004"
> document.getElementById("dt").value=dat
> dtot.action="test3.asp" '=name of this file
> dtot.method="post"
> dtot.submit
> 'too fast here
> a=<%=totd%> '=0 on the first click, the real value on the[/color]
second[color=blue]
> click
> msgbox a
> end sub
> </script>
> <form name=dtot>
> <input name="dt" type="hidden" value="" >
> <INPUT name=hfd TYPE="button">
> </form>
>
> Thanks
> andré
>
>[/color]


Andre
Guest
 
Posts: n/a
#5: Jul 19 '05

re: VB code is too fast => gives wrong value


Thanks, but in fact, i need that value from ASP in the procedure
hfd_onclick() because that value must be tested further in that procedure. I
put msgbox just to check the value. For example, if the value = 2, then
button "A" in the page must become visible, otherwise button "B" etc ...

"Patrice" <nobody@nowhere.com> wrote in message
news:eMb0vyeXEHA.3016@tk2msftngp13.phx.gbl...[color=blue]
> It looks like you expect the change to take place immediately after[/color]
calling[color=blue]
> the submit method. Display the HTML source for your page. It's likely[/color]
you'll[color=blue]
> see :
>
> dtot.submit
> a=0
> MsgBox a
>
> So :
> - the page is "submitted" (actually it's more likely "queued" as the[/color]
script[color=blue]
> must terminate before the page is really submitted)
> - a is 0
> - 0 is displayed
>
> The script ends, the page is submitted and you get the new updated client
> side code...
>
> Patrice
>
> --
>
> "Andre" <aa@no.it> a écrit dans le message de
> news:OK2SCgeXEHA.3112@tk2msftngp13.phx.gbl...[color=green]
> > Hi,
> >
> > I need to fetch a value in an Access db, so i use a form to pass the
> > parameter for the SQL statement fromVB client to ASP. After the submit[/color]
> line[color=green]
> > in VBscript, i expect the value in order to test it and go further in
> > VBscript. But my problem is when clicking on the button, that the VB[/color][/color]
code[color=blue][color=green]
> > doesn't wait to get that value and continues directly, so the[/color][/color]
a=<%=totd%>[color=blue][color=green]
> > line give 0 in stead of the real value. If i click a second time, i get[/color]
> the[color=green]
> > value.
> > Any way to let de VB code after dtot.submit wait before it gets the[/color][/color]
value?[color=blue][color=green]
> > See the code:
> > <%
> > totd = 0
> > dat=Request.Form("dt")
> > If Request.Form("dt") <> "" Then totd = records()
> > Function records()
> > set objdc = Server.CreateObject("ADODB.Connection")
> > objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source
> > =d:\access\newres.mdb")
> > sql="select logon, count(uur) as totdag from studres where cdate(dag)='"[/color][/color]
&[color=blue][color=green]
> > dat & "' "
> > set rs=Server.CreateObject("ADODB.recordset")
> > rs.open sql, objdc, 3, 3
> > records=rs.recordcount
> > Set rs = Nothing
> > End Function
> > %>
> > <html><head><title>Nieuwe pagina 1</title></head><body>
> > <script language=vbscript>
> > sub hfd_onclick()
> > a=0
> > dat="6/30/2004"
> > document.getElementById("dt").value=dat
> > dtot.action="test3.asp" '=name of this file
> > dtot.method="post"
> > dtot.submit
> > 'too fast here
> > a=<%=totd%> '=0 on the first click, the real value on the[/color]
> second[color=green]
> > click
> > msgbox a
> > end sub
> > </script>
> > <form name=dtot>
> > <input name="dt" type="hidden" value="" >
> > <INPUT name=hfd TYPE="button">
> > </form>
> >
> > Thanks
> > andré
> >
> >[/color]
>
>[/color]


Mark Schupp
Guest
 
Posts: n/a
#6: Jul 19 '05

re: VB code is too fast => gives wrong value


That is not how http works. You will have to submit the form and then in the
new page returned by that request to the server, add Javascript code to do
whatever further processing you need.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"Andre" <aa@no.it> wrote in message
news:uhNKD9gXEHA.2844@TK2MSFTNGP12.phx.gbl...[color=blue]
> Thanks, but in fact, i need that value from ASP in the procedure
> hfd_onclick() because that value must be tested further in that procedure.[/color]
I[color=blue]
> put msgbox just to check the value. For example, if the value = 2, then
> button "A" in the page must become visible, otherwise button "B" etc ...
>
> "Patrice" <nobody@nowhere.com> wrote in message
> news:eMb0vyeXEHA.3016@tk2msftngp13.phx.gbl...[color=green]
> > It looks like you expect the change to take place immediately after[/color]
> calling[color=green]
> > the submit method. Display the HTML source for your page. It's likely[/color]
> you'll[color=green]
> > see :
> >
> > dtot.submit
> > a=0
> > MsgBox a
> >
> > So :
> > - the page is "submitted" (actually it's more likely "queued" as the[/color]
> script[color=green]
> > must terminate before the page is really submitted)
> > - a is 0
> > - 0 is displayed
> >
> > The script ends, the page is submitted and you get the new updated[/color][/color]
client[color=blue][color=green]
> > side code...
> >
> > Patrice
> >
> > --
> >
> > "Andre" <aa@no.it> a écrit dans le message de
> > news:OK2SCgeXEHA.3112@tk2msftngp13.phx.gbl...[color=darkred]
> > > Hi,
> > >
> > > I need to fetch a value in an Access db, so i use a form to pass the
> > > parameter for the SQL statement fromVB client to ASP. After the submit[/color]
> > line[color=darkred]
> > > in VBscript, i expect the value in order to test it and go further in
> > > VBscript. But my problem is when clicking on the button, that the VB[/color][/color]
> code[color=green][color=darkred]
> > > doesn't wait to get that value and continues directly, so the[/color][/color]
> a=<%=totd%>[color=green][color=darkred]
> > > line give 0 in stead of the real value. If i click a second time, i[/color][/color][/color]
get[color=blue][color=green]
> > the[color=darkred]
> > > value.
> > > Any way to let de VB code after dtot.submit wait before it gets the[/color][/color]
> value?[color=green][color=darkred]
> > > See the code:
> > > <%
> > > totd = 0
> > > dat=Request.Form("dt")
> > > If Request.Form("dt") <> "" Then totd = records()
> > > Function records()
> > > set objdc = Server.CreateObject("ADODB.Connection")
> > > objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source
> > > =d:\access\newres.mdb")
> > > sql="select logon, count(uur) as totdag from studres where[/color][/color][/color]
cdate(dag)='"[color=blue]
> &[color=green][color=darkred]
> > > dat & "' "
> > > set rs=Server.CreateObject("ADODB.recordset")
> > > rs.open sql, objdc, 3, 3
> > > records=rs.recordcount
> > > Set rs = Nothing
> > > End Function
> > > %>
> > > <html><head><title>Nieuwe pagina 1</title></head><body>
> > > <script language=vbscript>
> > > sub hfd_onclick()
> > > a=0
> > > dat="6/30/2004"
> > > document.getElementById("dt").value=dat
> > > dtot.action="test3.asp" '=name of this file
> > > dtot.method="post"
> > > dtot.submit
> > > 'too fast here
> > > a=<%=totd%> '=0 on the first click, the real value on the[/color]
> > second[color=darkred]
> > > click
> > > msgbox a
> > > end sub
> > > </script>
> > > <form name=dtot>
> > > <input name="dt" type="hidden" value="" >
> > > <INPUT name=hfd TYPE="button">
> > > </form>
> > >
> > > Thanks
> > > andré
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]


Patrice
Guest
 
Posts: n/a
#7: Jul 19 '05

re: VB code is too fast => gives wrong value


Here you are mixing client and server side processing :

- if you want to post the data, post them and have the server side page
recreates the page with the appropriate buttons
- if you don't need to post the data just have some client JavaScript code
that updates the current page

Keep in mind that the life cycle is always :
- the browser ask a page (possibly posting data)
- the server responds with a new page
- the browser can then handle the page locally until another request is made
to the server (possibly posting data)

Patrice



"Andre" <aa@no.it> a écrit dans le message de
news:uhNKD9gXEHA.2844@TK2MSFTNGP12.phx.gbl...[color=blue]
> Thanks, but in fact, i need that value from ASP in the procedure
> hfd_onclick() because that value must be tested further in that procedure.[/color]
I[color=blue]
> put msgbox just to check the value. For example, if the value = 2, then
> button "A" in the page must become visible, otherwise button "B" etc ...
>
> "Patrice" <nobody@nowhere.com> wrote in message
> news:eMb0vyeXEHA.3016@tk2msftngp13.phx.gbl...[color=green]
> > It looks like you expect the change to take place immediately after[/color]
> calling[color=green]
> > the submit method. Display the HTML source for your page. It's likely[/color]
> you'll[color=green]
> > see :
> >
> > dtot.submit
> > a=0
> > MsgBox a
> >
> > So :
> > - the page is "submitted" (actually it's more likely "queued" as the[/color]
> script[color=green]
> > must terminate before the page is really submitted)
> > - a is 0
> > - 0 is displayed
> >
> > The script ends, the page is submitted and you get the new updated[/color][/color]
client[color=blue][color=green]
> > side code...
> >
> > Patrice
> >
> > --
> >
> > "Andre" <aa@no.it> a écrit dans le message de
> > news:OK2SCgeXEHA.3112@tk2msftngp13.phx.gbl...[color=darkred]
> > > Hi,
> > >
> > > I need to fetch a value in an Access db, so i use a form to pass the
> > > parameter for the SQL statement fromVB client to ASP. After the submit[/color]
> > line[color=darkred]
> > > in VBscript, i expect the value in order to test it and go further in
> > > VBscript. But my problem is when clicking on the button, that the VB[/color][/color]
> code[color=green][color=darkred]
> > > doesn't wait to get that value and continues directly, so the[/color][/color]
> a=<%=totd%>[color=green][color=darkred]
> > > line give 0 in stead of the real value. If i click a second time, i[/color][/color][/color]
get[color=blue][color=green]
> > the[color=darkred]
> > > value.
> > > Any way to let de VB code after dtot.submit wait before it gets the[/color][/color]
> value?[color=green][color=darkred]
> > > See the code:
> > > <%
> > > totd = 0
> > > dat=Request.Form("dt")
> > > If Request.Form("dt") <> "" Then totd = records()
> > > Function records()
> > > set objdc = Server.CreateObject("ADODB.Connection")
> > > objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source
> > > =d:\access\newres.mdb")
> > > sql="select logon, count(uur) as totdag from studres where[/color][/color][/color]
cdate(dag)='"[color=blue]
> &[color=green][color=darkred]
> > > dat & "' "
> > > set rs=Server.CreateObject("ADODB.recordset")
> > > rs.open sql, objdc, 3, 3
> > > records=rs.recordcount
> > > Set rs = Nothing
> > > End Function
> > > %>
> > > <html><head><title>Nieuwe pagina 1</title></head><body>
> > > <script language=vbscript>
> > > sub hfd_onclick()
> > > a=0
> > > dat="6/30/2004"
> > > document.getElementById("dt").value=dat
> > > dtot.action="test3.asp" '=name of this file
> > > dtot.method="post"
> > > dtot.submit
> > > 'too fast here
> > > a=<%=totd%> '=0 on the first click, the real value on the[/color]
> > second[color=darkred]
> > > click
> > > msgbox a
> > > end sub
> > > </script>
> > > <form name=dtot>
> > > <input name="dt" type="hidden" value="" >
> > > <INPUT name=hfd TYPE="button">
> > > </form>
> > >
> > > Thanks
> > > andré
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]


Closed Thread