Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Multiview records on the same page?

Posted 22 Jan 2006 15:10:05
1
has voted
22 Jan 2006 15:10:05 allan khalil posted:
Greetings ya all...

Guys a quick question, hopefully somebody might be able to help me... I have created a table on my database (MS Acx) and its called "Articles". Now I have no problem displaying records, repeating regions or anything like that... BUT what I do have a issue with is having the the most recent article displayed at the head of the page with a image and have the next 13 odd articles displayed below in summery without a image.
Sounds easy enough right? Well it is but it also isnt... <b>The problem is, i dont know what to set on the recordset in the below summerised articles to not display the head article with the image?</b> Im using asp vb script. PLEASE somebody help!

At the moment I have created a second table called "headarticles" and have them display on its own, but i dont want to have to update two tables...

Thanks
Allan

Replies

Replied 24 Jan 2006 15:44:05
24 Jan 2006 15:44:05 allan khalil replied:
Just in case anyone was interested....

I worked it and it was a very silly problem i had and a very easy solution.

All i had to do was create an additional feild in the table 'articles' called 'headart' and gave it the value of Y or N.
Created the recordset to show all from bla bla bla WHERE headart = Y
created a second recordset to show all from bla bla bla WHERE headart = N

All done and working well, hope it would help someone..

Regs

Allan

Reply to this topic