no records returned when I click on a hyperlink db field...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have built a database and 2 database results pages. The first page,
"events.asp" has the event name, date and time. I used the tips from
http://support.microsoft.com/kb/825500/en-us to create a hyperlink out of the
event name, and it opens a detail page, which pulls in the same fields, plus
the details field. The database (eventdb.mdb) contains the following fields
(used wizard to create Access db) "Key", "event", "date", "time", and
"details". When I click on the hyperlink "Event", I get "no records
returned".

Can anyone help?
 
Your hyperlink needs to pass a parameter to the new page (a field from the DB) so the DB knows which record to display
See http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm
Or http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have built a database and 2 database results pages. The first page,
| "events.asp" has the event name, date and time. I used the tips from
| http://support.microsoft.com/kb/825500/en-us to create a hyperlink out of the
| event name, and it opens a detail page, which pulls in the same fields, plus
| the details field. The database (eventdb.mdb) contains the following fields
| (used wizard to create Access db) "Key", "event", "date", "time", and
| "details". When I click on the hyperlink "Event", I get "no records
| returned".
|
| Can anyone help?
|
 
The event.asp has the following parameter in the hyperlink "event":
<a href="Event_%20Details.asp?Event='<%=FP_FieldURL(fp_rs,"Event")%>'">

The event_details.asp has the following:
SELECT * FROM Results WHERE (Event = '::Event::') ORDER BY Date ASC,Time ASC

Is this correct? Thank you.
 
It should be except that the page is:
event_details.asp
And your link is
Event_ Details.asp
- the space is causing the %20 in your link
Event_%20Details.asp

If the field Event in your DB is numeric you need to remove the text delimiters in your select and make it
WHERE (Event = ::Event::)
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| The event.asp has the following parameter in the hyperlink "event":
| <a href="Event_%20Details.asp?Event='<%=FP_FieldURL(fp_rs,"Event")%>'">
|
| The event_details.asp has the following:
| SELECT * FROM Results WHERE (Event = '::Event::') ORDER BY Date ASC,Time ASC
|
| Is this correct? Thank you.
|
| "Stefan B Rusynko" wrote:
|
| > Your hyperlink needs to pass a parameter to the new page (a field from the DB) so the DB knows which record to display
| > See http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm
| > Or http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > |I have built a database and 2 database results pages. The first page,
| > | "events.asp" has the event name, date and time. I used the tips from
| > | http://support.microsoft.com/kb/825500/en-us to create a hyperlink out of the
| > | event name, and it opens a detail page, which pulls in the same fields, plus
| > | the details field. The database (eventdb.mdb) contains the following fields
| > | (used wizard to create Access db) "Key", "event", "date", "time", and
| > | "details". When I click on the hyperlink "Event", I get "no records
| > | returned".
| > |
| > | Can anyone help?
| > |
| >
| >
| >
 
Also, 'date' is a reserved word, rename your database field to eventDate or
something similar.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/




Stefan B Rusynko said:
It should be except that the page is:
event_details.asp
And your link is
Event_ Details.asp
- the space is causing the %20 in your link
Event_%20Details.asp

If the field Event in your DB is numeric you need to remove the text
delimiters in your select and make it
WHERE (Event = ::Event::)
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| The event.asp has the following parameter in the hyperlink "event":
| <a href="Event_%20Details.asp?Event='<%=FP_FieldURL(fp_rs,"Event")%>'">
|
| The event_details.asp has the following:
| SELECT * FROM Results WHERE (Event = '::Event::') ORDER BY Date
ASC,Time ASC
|
| Is this correct? Thank you.
|
| "Stefan B Rusynko" wrote:
|
| > Your hyperlink needs to pass a parameter to the new page (a field from
the DB) so the DB knows which record to display
| > See http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm
| > Or
http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > |I have built a database and 2 database results pages. The first
page,
| > | "events.asp" has the event name, date and time. I used the tips
from
| > | http://support.microsoft.com/kb/825500/en-us to create a hyperlink
out of the
| > | event name, and it opens a detail page, which pulls in the same
fields, plus
| > | the details field. The database (eventdb.mdb) contains the
following fields
| > | (used wizard to create Access db) "Key", "event", "date", "time",
and
| > | "details". When I click on the hyperlink "Event", I get "no records
| > | returned".
| > |
| > | Can anyone help?
| > |
| >
| >
| >
Click to expand...
 
PS
So is "Time"

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Also, 'date' is a reserved word, rename your database field to eventDate or
| something similar.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| FrontPage Support: http://www.frontpagemvps.com/
|
|
|
|
| | > It should be except that the page is:
| > event_details.asp
| > And your link is
| > Event_ Details.asp
| > - the space is causing the %20 in your link
| > Event_%20Details.asp
| >
| > If the field Event in your DB is numeric you need to remove the text
| > delimiters in your select and make it
| > WHERE (Event = ::Event::)
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | The event.asp has the following parameter in the hyperlink "event":
| > | <a href="Event_%20Details.asp?Event='<%=FP_FieldURL(fp_rs,"Event")%>'">
| > |
| > | The event_details.asp has the following:
| > | SELECT * FROM Results WHERE (Event = '::Event::') ORDER BY Date
| > ASC,Time ASC
| > |
| > | Is this correct? Thank you.
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your hyperlink needs to pass a parameter to the new page (a field from
| > the DB) so the DB knows which record to display
| > | > See http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm
| > | > Or
| > http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | > |I have built a database and 2 database results pages. The first
| > page,
| > | > | "events.asp" has the event name, date and time. I used the tips
| > from
| > | > | http://support.microsoft.com/kb/825500/en-us to create a hyperlink
| > out of the
| > | > | event name, and it opens a detail page, which pulls in the same
| > fields, plus
| > | > | the details field. The database (eventdb.mdb) contains the
| > following fields
| > | > | (used wizard to create Access db) "Key", "event", "date", "time",
| > and
| > | > | "details". When I click on the hyperlink "Event", I get "no records
| > | > | returned".
| > | > |
| > | > | Can anyone help?
| > | > |
| > | >
| > | >
| > | >
| >
| >
|
|
 
Thank you!! It's working beautifully now.

How can I make it not show events after their date has passed?

Thanks.

Stefan B Rusynko said:
PS
So is "Time"

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Also, 'date' is a reserved word, rename your database field to eventDate or
| something similar.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| FrontPage Support: http://www.frontpagemvps.com/
|
|
|
|
| | > It should be except that the page is:
| > event_details.asp
| > And your link is
| > Event_ Details.asp
| > - the space is causing the %20 in your link
| > Event_%20Details.asp
| >
| > If the field Event in your DB is numeric you need to remove the text
| > delimiters in your select and make it
| > WHERE (Event = ::Event::)
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | The event.asp has the following parameter in the hyperlink "event":
| > | <a href="Event_%20Details.asp?Event='<%=FP_FieldURL(fp_rs,"Event")%>'">
| > |
| > | The event_details.asp has the following:
| > | SELECT * FROM Results WHERE (Event = '::Event::') ORDER BY Date
| > ASC,Time ASC
| > |
| > | Is this correct? Thank you.
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your hyperlink needs to pass a parameter to the new page (a field from
| > the DB) so the DB knows which record to display
| > | > See http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm
| > | > Or
| > http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
| > http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | > |I have built a database and 2 database results pages. The first
| > page,
| > | > | "events.asp" has the event name, date and time. I used the tips
| > from
| > | > | http://support.microsoft.com/kb/825500/en-us to create a hyperlink
| > out of the
| > | > | event name, and it opens a detail page, which pulls in the same
| > fields, plus
| > | > | the details field. The database (eventdb.mdb) contains the
| > following fields
| > | > | (used wizard to create Access db) "Key", "event", "date", "time",
| > and
| > | > | "details". When I click on the hyperlink "Event", I get "no records
| > | > | returned".
| > | > |
| > | > | Can anyone help?
| > | > |
| > | >
| > | >
| > | >
| >
| >
|
|
Click to expand...
 
WHERE (eventDate>=Date())

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


khaymon said:
Thank you!! It's working beautifully now.

How can I make it not show events after their date has passed?

Thanks.

Stefan B Rusynko said:
PS
So is "Time"

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


message | Also, 'date' is a reserved word, rename your database field to
eventDate or
| something similar.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| FrontPage Support: http://www.frontpagemvps.com/
|
|
|
|
| | > It should be except that the page is:
| > event_details.asp
| > And your link is
| > Event_ Details.asp
| > - the space is causing the %20 in your link
| > Event_%20Details.asp
| >
| > If the field Event in your DB is numeric you need to remove the text
| > delimiters in your select and make it
| > WHERE (Event = ::Event::)
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | > | The event.asp has the following parameter in the hyperlink "event":
| > | <a
href="Event_%20Details.asp?Event='<%=FP_FieldURL(fp_rs,"Event")%>'">
| > |
| > | The event_details.asp has the following:
| > | SELECT * FROM Results WHERE (Event = '::Event::') ORDER BY Date
| > ASC,Time ASC
| > |
| > | Is this correct? Thank you.
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Your hyperlink needs to pass a parameter to the new page (a field
from
| > the DB) so the DB knows which record to display
| > | > See
http://spiderwebwoman.com/tutorials/picklist_with_dropdown.htm
| > | > Or
| >
http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
| >
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| > | > _____________________________________________
| > | >
| > | >
| > | > | > |I have built a database and 2 database results pages. The first
| > page,
| > | > | "events.asp" has the event name, date and time. I used the
tips
| > from
| > | > | http://support.microsoft.com/kb/825500/en-us to create a
hyperlink
| > out of the
| > | > | event name, and it opens a detail page, which pulls in the same
| > fields, plus
| > | > | the details field. The database (eventdb.mdb) contains the
| > following fields
| > | > | (used wizard to create Access db) "Key", "event", "date",
"time",
| > and
| > | > | "details". When I click on the hyperlink "Event", I get "no
records
| > | > | returned".
| > | > |
| > | > | Can anyone help?
| > | > |
| > | >
| > | >
| > | >
| >
| >
|
|
Click to expand...
Click to expand...
 
Back
Top