K
Kiratadas Kutikkad
Hi, I have an Access '03 Db and am using FP '03 for webpages. In the first
page I am retrieving 2 fields of all records and made 1 field a hyperlink.
I want to retrieve all the data of 1 record when the user clicks on any of
the link field. But it comes out saying "no records found". For eg; I have
2 files called list.asp and results.asp. list.asp lists name and number
where name is a hyperlink. When the user clicks on one of the names it
calls results.asp to display all the fields of that record. This is part of
what I have in list.asp:
.........
fp_sQry="SELECT Name, Number FROM Students WHERE Class LIKE '%Grad%' ORDER
by Name ASC"
.......
<a href="results.asp?Name = <%=FP_FieldURL(fp_rs,"Name")%>
"><%=FP_FieldVal(fp_rs,"Name")%>
.......
Following is part of results.asp:
....
fp_sQry="SELECT * FROM Students WHERE Name = ' " & Name & " ' "
I can't figure out where the problem is. Any help is greatly appreciated.
page I am retrieving 2 fields of all records and made 1 field a hyperlink.
I want to retrieve all the data of 1 record when the user clicks on any of
the link field. But it comes out saying "no records found". For eg; I have
2 files called list.asp and results.asp. list.asp lists name and number
where name is a hyperlink. When the user clicks on one of the names it
calls results.asp to display all the fields of that record. This is part of
what I have in list.asp:
.........
fp_sQry="SELECT Name, Number FROM Students WHERE Class LIKE '%Grad%' ORDER
by Name ASC"
.......
<a href="results.asp?Name = <%=FP_FieldURL(fp_rs,"Name")%>
"><%=FP_FieldVal(fp_rs,"Name")%>
.......
Following is part of results.asp:
....
fp_sQry="SELECT * FROM Students WHERE Name = ' " & Name & " ' "
I can't figure out where the problem is. Any help is greatly appreciated.