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