Here's a database stumper for ya...

[artdirectoreric]

My new webpage has a database of articles. I eventually want to include responses to those articles below the article. I will build a relational database to house them. Here's my question... If there are no responses, I don't want that portion of the site to contain anything that looks like there should be something there that isn't. For example, I have a white box with the text for the article. If there are no responses, then that white box will be all there is. If there are responses, then a new white box(es) will appear below the article with a response(s).

I think an Include statement will handle this, but how could I ask the page to check the database for responses and include an html file of those responses only if it finds any, and to ignore the Include statement if there aren't any (or maybe even call up a different file if there aren't any)???????????????? and ?

The database in question is an Access file.

Site in question is

http://www.ericjcarter.com

 

[DeZiner]

if returned results are greater than 0

include file

else

don't do anything

That is the logic. Start there to write the ASP code to do it. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic

 

[artdirectoreric]

Any tutorials on how to do this? I don't actually code ASP, I just let FP do it for me. Thanks.

 

[artdirectoreric]

I feel dumb now. I see from my site that if there's nothing in the database that matches the criteria, then it will just be blank. I have some graphics in my database results area that I thought would show up even if there was no records to show. Stupid me.