Using Request.QueryString with aspDBPro

[Kevin]

I have an application that needs to carry a parameter in the URL
from page to page. When I generate the page that uses aspDB,
everything works fine, but when I sort columns or use any of
the other controls, I lose the variable in the URL because
it is replaced with the aspDB specific URL (like ....?gridsort_1=...).
This causes a problem because my application then calls
Request.QueryString("varibale in URL&#34 and fails because aspDB
writes over it.

Is there anyway to append what aspDB URL encodes with what I
already have in the URL?

Thanks in advance for any help.

[FK]

Give me a legi case that you need to "carry thru" you own URL variable from "Page to Page" including ASP-db pages.

FK


------------
Kevin at 7/26/99 11:00:01 AM

I have an application that needs to carry a parameter in the URL
from page to page. When I generate the page that uses aspDB,
everything works fine, but when I sort columns or use any of
the other controls, I lose the variable in the URL because
it is replaced with the aspDB specific URL (like ....?gridsort_1=...).
This causes a problem because my application then calls
Request.QueryString("varibale in URL&#34 and fails because aspDB
writes over it.

Is there anyway to append what aspDB URL encodes with what I
already have in the URL?

Thanks in advance for any help.

[Hayne Shumate]

Kevin,

Usually this is done by using session variables instead of URL variables. Much easier and more secure.

FK: "legi case"
Some web server administrators turn off sessioning to improve the performance of high demand web sites. Things that would normaly be put in session variables are passed from screen to screen in the URL. It has been a while since I have met a Web master who set these kinds of policies.

It is a legitimate strategy for high volume, low complexity sights on a shoestring.

Of course if Kevin is moving his sight to a server that requires URL passes and forbids sessions, we both know he is really in trouble. I haven't tried but I imagine ASPDB doesn't work exactly right without it's session variables.




------------
FK at 7/26/99 9:50:35 PM

Give me a legi case that you need to "carry thru" you own URL variable from "Page to Page" including ASP-db pages.

FK


------------
Kevin at 7/26/99 11:00:01 AM

I have an application that needs to carry a parameter in the URL
from page to page. When I generate the page that uses aspDB,
everything works fine, but when I sort columns or use any of
the other controls, I lose the variable in the URL because
it is replaced with the aspDB specific URL (like ....?gridsort_1=...).
This causes a problem because my application then calls
Request.QueryString("varibale in URL&#34 and fails because aspDB
writes over it.

Is there anyway to append what aspDB URL encodes with what I
already have in the URL?

Thanks in advance for any help.

[John]

Hi Kevin,

Simply store your variable in Session variables as Hayne suggests and always use the session var. in your code. You must have session variables enabled or ASP is basically useless. ASP-db will not work with out it, so you can count on it. Here's an example where you're passing "myName" on the URL and using it in your WHERE condition:

<%
If Request(&#34;myName&#34 <> &#34;&#34; Then Session(&#34;myNameVar&#34 = Request(&#34;myName&#34

...

X.dbSQL=&#34;SELECT * FROM myTbl WHERE namefld = &#39;&#34; & Session(&#34;myNameVar&#34 & &#34;&#39;&#34;

There ya go!

John



------------
Hayne Shumate at 7/27/99 12:20:54 PM

Kevin,

Usually this is done by using session variables instead of URL variables. Much easier and more secure.

FK: &#34;legi case&#34;
Some web server administrators turn off sessioning to improve the performance of high demand web sites. Things that would normaly be put in session variables are passed from screen to screen in the URL. It has been a while since I have met a Web master who set these kinds of policies.

It is a legitimate strategy for high volume, low complexity sights on a shoestring.

Of course if Kevin is moving his sight to a server that requires URL passes and forbids sessions, we both know he is really in trouble. I haven&#39;t tried but I imagine ASPDB doesn&#39;t work exactly right without it&#39;s session variables.




------------
FK at 7/26/99 9:50:35 PM

Give me a legi case that you need to &#34;carry thru&#34; you own URL variable from &#34;Page to Page&#34; including ASP-db pages.

FK


------------
Kevin at 7/26/99 11:00:01 AM

I have an application that needs to carry a parameter in the URL
from page to page. When I generate the page that uses aspDB,
everything works fine, but when I sort columns or use any of
the other controls, I lose the variable in the URL because
it is replaced with the aspDB specific URL (like ....?gridsort_1=...).
This causes a problem because my application then calls
Request.QueryString(&#34;varibale in URL&#34 and fails because aspDB
writes over it.

Is there anyway to append what aspDB URL encodes with what I
already have in the URL?

Thanks in advance for any help.

[kevin]

I am guessing from the replys that the simple answer
to my question is that you cannot pass variables
when using aspDB. This is unfortunate because with
the number of hits (this is a web application I
am developing not a web page) it would be impossible
to use the session variable. I have already lost about
30 percent performance due to aspDB using it.

I thank everybody for their help and responses.


------------
John at 7/27/99 11:14:23 PM

Hi Kevin,

Simply store your variable in Session variables as Hayne suggests and always use the session var. in your code. You must have session variables enabled or ASP is basically useless. ASP-db will not work with out it, so you can count on it. Here&#39;s an example where you&#39;re passing &#34;myName&#34; on the URL and using it in your WHERE condition:

<%
If Request(&#34;myName&#34 <> &#34;&#34; Then Session(&#34;myNameVar&#34 = Request(&#34;myName&#34

...

X.dbSQL=&#34;SELECT * FROM myTbl WHERE namefld = &#39;&#34; & Session(&#34;myNameVar&#34 & &#34;&#39;&#34;

There ya go!

John



------------
Hayne Shumate at 7/27/99 12:20:54 PM

Kevin,

Usually this is done by using session variables instead of URL variables. Much easier and more secure.

FK: &#34;legi case&#34;
Some web server administrators turn off sessioning to improve the performance of high demand web sites. Things that would normaly be put in session variables are passed from screen to screen in the URL. It has been a while since I have met a Web master who set these kinds of policies.

It is a legitimate strategy for high volume, low complexity sights on a shoestring.

Of course if Kevin is moving his sight to a server that requires URL passes and forbids sessions, we both know he is really in trouble. I haven&#39;t tried but I imagine ASPDB doesn&#39;t work exactly right without it&#39;s session variables.




------------
FK at 7/26/99 9:50:35 PM

Give me a legi case that you need to &#34;carry thru&#34; you own URL variable from &#34;Page to Page&#34; including ASP-db pages.

FK


------------
Kevin at 7/26/99 11:00:01 AM

I have an application that needs to carry a parameter in the URL
from page to page. When I generate the page that uses aspDB,
everything works fine, but when I sort columns or use any of
the other controls, I lose the variable in the URL because
it is replaced with the aspDB specific URL (like ....?gridsort_1=...).
This causes a problem because my application then calls
Request.QueryString(&#34;varibale in URL&#34 and fails because aspDB
writes over it.

Is there anyway to append what aspDB URL encodes with what I
already have in the URL?

Thanks in advance for any help.