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?
| > | > |
| > | >
| > | >
| > | >
| >
| >
|
|
