| 
                                                                        
                                                                         
                                                                            
                                                                                brendan-ignitedcoder
                                                                            - 
                                                                                10/10/2012 2:06:09 AM
                                                                            
                                                                         
                                                                         
                                                                            
                                                                        
                                                                        
                                                                         
                                                                        
                                                                        
                                                                        
                                                                        
                                                                        
                                                                         
                                                                        
                                                                            Teaser Image for Event Entry/News
                                                                        
                                                                            Hi Guys,
  I have successfully queried the top 3 events from the CONTENT_Events table but my client needs to show a teaser image for each event. I was using MVC before but that proved to be a little trickier than expected so I've switched to Web Parts/ASCX files instead. I need to do the following if possible.
  1. Add a field to upload a teaser image for an event entry 2. Read this image and display it on the page 3. Get the teaser image used for a news item and display it also.
  And lastly, can anyone suggest the SQL for reading the top 5 news items, and also how do I make a news item and an event featured items. Perhaps a flag in the DB to indicate the item as featured??
  Thanks in advance,
  Brendan
                                                                         
                                                                        
                                                                            
                                                                         
                                                                        
                                                                         
                                                                        
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                        
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                        
                                                                         
                                                                     |