How to Reference HTML Meta Tag in a Stored Procedure or Insert Query

  • Garadin (4/29/2010)


    Sid Childers (4/29/2010)


    This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it will be a maintenance nightmare especially as he adds more content pages/articles.

    This doesn't make any sense to me. Nothing about 2.0 bars dynamic data. You could make dynamic pages with classic ASP. Maybe I'm missing something?

    Seth,

    Typo, my bad. When I said 3.5/dynamic data, I meant 3.5/LINQ. Sorry for the confusion!

  • I think I'm starting to bring this into focus 🙂

    So, serve up the article dynamically via SQL query where 0001.aspx calls query such as select the article ID with the highest votes (max?) and output article content on 0001.aspx. If that's the case, what kind of SQL syntax would be used to get the 2nd to nth articles loaded in pages 0002.aspx through 000n.aspx ?

    Thanks much!

    the example i gave would do it; if i was on page 0004.aspx, the query would order the data by "RW" (my rownumber alias)

    WHERE RW = [int of this pages name: 0004]

    that'd be a dataset with one row...witht eh right article and all that..it might be articleID=2, but it's the fourth most popular.

    it's kind of dumb, because you could easily have a single page do all the work, just by keeping track of what the next page is/should be, but this is a work around for fulfilling bad requirements.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Sid Childers (4/29/2010)


    Garadin (4/29/2010)


    Sid Childers (4/29/2010)


    This client is stuck on ASP.NET 2.0, unwilling to consider 3.5/dynamic data because he feels that 2.0 can do the job. I'm afraid it will be a maintenance nightmare especially as he adds more content pages/articles.

    This doesn't make any sense to me. Nothing about 2.0 bars dynamic data. You could make dynamic pages with classic ASP. Maybe I'm missing something?

    Seth,

    Typo, my bad. When I said 3.5/dynamic data, I meant 3.5/LINQ. Sorry for the confusion!

    OK... but you don't need LINQ to do this either. I don't care for LINQ to SQL personally and we don't use it here even though we are on 3.5. Still not seeing the obstacle with doing all of this dynamically with .Net 2.0

    Seth Phelabaum


    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply