Previous Thread
Next Thread
Print Thread
filtering data #145158 11/08/04 11:38 PM
Joined: Oct 2004
Posts: 3
roxannamar Offline OP
OP Offline
Joined: Oct 2004
Posts: 3
Hi girls.....Hoping you can help me out real quick. I am trying to do something like this:

objRS.Filter = "eventdate = 2"
If objrs.EOF then
eventcaption = ""
Response.Write"<a href=""Showevent.asp?eventid=" & objrs.Fields ***"eventdate"*** .Value & ">" & objRs***"eventcaption"***& "</a>"
End If
objRS.Filter = adFilterNone

The problem is that my filtered eventcaption does not print on my html page. In fact it prohibits the whole process. Is my syntax incorrect? tut I've taken the parenthesis out of objrs.Fields "eventdate" .Value and changed it to *** to be able to post.

Re: filtering data #145159 12/02/04 04:58 AM
Joined: Jan 2004
Posts: 22,776
Lisa LowCarb Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
BellaOnline Editor
Highest Posting Power Known to Humanity
Joined: Jan 2004
Posts: 22,776
I would always start with something simple. Just say

if EOF then
response.write "EOF"
response.write "not EOF"
end if

and see which it does. Make sure the basic syntax works. Then just start slowly changing what the response.write puts out on the screen.

Lisa Shea, Low Carb and Video Games Editor
Low Carb Forum

Moderated by  Lisa LowCarb 

Brand New Posts
Astro Advent 2020
by Mona - Astronomy - 12/01/20 12:08 AM
When does Christmas Season End?
by Angie - 11/30/20 11:54 PM
2020: On this day . . .
by Mona - Astronomy - 11/30/20 01:50 PM
Container Gardening TIP OF THE DAY
by Lestie4containergardens - 11/30/20 05:59 AM
Advent 2020
by Angie - 11/29/20 05:23 PM
Native American Heritage Month
by Angela - Drama Movies - 11/29/20 01:25 AM
Thanksgiving and Gratitude
by Angie - 11/28/20 01:36 PM
Meanwhile in Canada
by Angie - 11/28/20 01:34 PM
Thanksgiving in Space
by Angie - 11/28/20 01:30 PM
The Solar System - for Kids & Others
by Mona - Astronomy - 11/28/20 12:39 PM
This forum uses cookies to ensure smooth navigation from page to page of a thread. If you choose to register and provide your email, that email is solely used to get your password to you and updates on any topics you choose to watch. Nothing else. Ask with any questions!
Channel List
Beauty & Self
Books & Music
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
News & Politics
Religion & Spirituality
Travel & Culture
TV & Movies
We take forum safety very seriously here at BellaOnline. Please be sure to read through our Forum Guidelines. Let us know if you have any questions or comments!

| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2020 Minerva WebWorks LLC. All rights reserved.

Powered by UBB.threads™ PHP Forum Software 7.7.3