SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Member
    Join Date
    Oct 2001
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ASP newbie: needs some advice

    I'm looking to add a few asp pages to a static site.

    o.k. i would like to add a search to a vacation web site, basically have it access a database and return tables of html. similar to this one.http://onlineagency.com/0content/vac...=2798&sid=1151 .

    I started messing around with ASP and VB-Script about a month ago, and read a book or two.Would this project be too difficult for a novice to perform? until recently I have been using just html and javascript.


    thanks in advance

  2. #2
    SitePoint Zealot Podge's Avatar
    Join Date
    Aug 2000
    Location
    Dublin, Ireland
    Posts
    156
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have a search through www.aspin.com , its probably been done before.

    http://www.aspin.com/home/webapps/search
    Padraic Lavin

    Advertising Free Message Boards $5/mo
    Instant Setup. ForumCo.com

  3. #3
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    tmess, it shouldn't be that hard, and it will gobe good for getting experince with ASP.

    SO I would suggest you get on with it, and if you get stuck, post here, either me or other people that know ASP will help.

    Have fun!

  4. #4
    SitePoint Member
    Join Date
    Oct 2001
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, i'm going to start on it probably tomorrow.
    thanks for the resources podge!

  5. #5
    SitePoint Member
    Join Date
    Oct 2001
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    another thing, can I put html tags with the information into my database tables and pull them out using code?, and represent the html from a database query? or do I store only text in the data base,and html on the ASP? sorry if that's not clear?

  6. #6
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah, it's perfectly fine to store HTML inside a database.


  7. #7
    grasshoppa Snowbird122's Avatar
    Join Date
    Apr 2001
    Location
    Austin
    Posts
    353
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would agree that this is a great project for you. It is almost exactly the same as my first project.

    I am going to have to disagree with dhtmlgod about storing html in the database. Although it will work fine, it limits your flexibility. If you store html in the database, you have to display the data with the html. This may be fine if you have for example, a bulleted list of grocery items, but what if later in your application you want to number the grocery items? Well, you can't unless you want them numbered and bulleted.

    It is better to keep the data separate from the presentation code if possible.
    http://www.echo-consulting.net - Sound Solutions for Online Inspriations.

  8. #8
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When sorting HTML in a databse make sure you replace single quotes with double quotes and apostraphies with double apostraphies ''

    As they can cause a little trouble when trying to insert the data

    The replace functions are pretty easy.

    Code:
    sString = Replace(sOtherStirng, """", """""")
    sString = Replace(sOtherStirng, "''", "''''")
    Hope that helps a little
    .NET Code Monkey

  9. #9
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Snowbird122
    I would agree that this is a great project for you. It is almost exactly the same as my first project.

    I am going to have to disagree with dhtmlgod about storing html in the database. Although it will work fine, it limits your flexibility. If you store html in the database, you have to display the data with the html. This may be fine if you have for example, a bulleted list of grocery items, but what if later in your application you want to number the grocery items? Well, you can't unless you want them numbered and bulleted.

    It is better to keep the data separate from the presentation code if possible.
    Hmm.. maybe I should have explained my self clearer... its ok to keep HTML in the databse, BUT not the whole page. Say some paragraphs with font tags etc. etc.

  10. #10
    SitePoint Member
    Join Date
    Oct 2001
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    o.k so it's not wise to store anything other than,like paragraph or line break tags to store...say a paragraph or a long description of text in my new database.
    Thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •