How to show record in new form by clicking on name

[Krechting]

Hi All,

I have a asp-build grid with some records.
The name of a record is a {Link}. I want to be able to click
on the link and open a new asp-form that has an editable grid.
That form must only show the record which was clicked.

This is the query I use in the new form:

SQL = "SELECT * " & _
"FROM Weapon"
CountSQL = "SELECT COUNT(*) " & _
"FROM Weapon"
Where = "name = '1A'"
Order = "name"

'1A' (example) should be changed to the name of the record which was
clicked on in the first form.

Regards,
Marco
The Netherlands

[Ray at]

Hi Marco,

You can pass the name in a querystring, as an option.

<a href="page.asp?name=1A">Click me</a>

Links to:

<%
Dim sName
sName = Request.Querystring("name")
CountSQL = "SELECT COUNT(*) FROM Weapon WHERE [Name]='" & Replace(sName,
"'", "''") & "'"
%>


Some links for reading:
[url]http://www.aspfaq.com/show.asp?id=2096[/url]
[url]http://www.aspfaq.com/show.asp?id=2073[/url] (specifically the count(*) thing)
[url]http://www.aspfaq.com/show.asp?id=2080[/url] (name vs. [name])


Ray at work

"Krechting" <m.krechting@chello.nl> wrote in message
news:a71c776d.0312240121.623e3bbc@posting.google.c om...

> Hi All,
>
> I have a asp-build grid with some records.
> The name of a record is a {Link}. I want to be able to click
> on the link and open a new asp-form that has an editable grid.
> That form must only show the record which was clicked.
>
> This is the query I use in the new form:
>
> SQL = "SELECT * " & _
> "FROM Weapon"
> CountSQL = "SELECT COUNT(*) " & _
> "FROM Weapon"
> Where = "name = '1A'"
> Order = "name"
>
> '1A' (example) should be changed to the name of the record which was
> clicked on in the first form.
>
> Regards,
> Marco
> The Netherlands

[Bullschmidt]

Example URL with a querystring:
[url]http://www.mysite.com/mydir/mypg.asp?myvar1=hey&myvar2=ho[/url]

Because a variable might contain some odd characters like spaces, it's
usually a good idea to use Server.URLEncode when creating a querystring
from a variable:
<a href="http://www.mysite.com/mypage?id=<%=
Server.URLEncode(objRS("MyIDFldFromDB")) %>">objRS("MyIDFldFromDB")</a>

And in the page that is opened you can use Request.QueryString("id") to
get the value of id.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!