keyword based Ads

Discussion in 'ASP General' started by NiQ, Feb 24, 2004.

  1. NiQ

    NiQ Guest

    Hello everyone,


    i want to develop a small application which will generate a list of
    product from a database based on a user web page contents. something
    like google adsense but not that extensive. any help or resource
    available?

    any guidelines. i want to use ASP , access or SQL server .

    in short a script page, when called, read the contents and search a DB
    for products and diplay it .

    any help would be of great help

    thanking in anticipation

    regards
    niq
     
    NiQ, Feb 24, 2004
    #1
    1. Advertising

  2. NiQ

    Bullschmidt Guest

    Example of a SQL statement based on two listboxes that might each say
    All to show all with no criteria restrictions:

    strSQL = "SELECT * MyTable WHERE (1=1)"
    If MyFirstListBox <> "All" Then
    strSQL = strSQL & " AND (MyType='" & Request.Form("MyFirstListBox") &
    "')"
    End If
    If MySecondListBox <> "All" Then
    strSQL = strSQL & " AND (MyDetail='" & Request.Form("MySecondListBox")
    & "')"
    End If

    Best regards,
    J. Paul Schmidt, Freelance ASP Web Developer
    http://www.Bullschmidt.com
    ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    Bullschmidt, Feb 25, 2004
    #2
    1. Advertising

  3. NiQ

    Bullschmidt Guest

    Here is something I put together about ASP that hopefully might help
    somehow.

    You and others can have access to a database hosted on the Web from any
    location that has a browser with an Internet connection.

    The Web database concept makes sense if you and your people want to do
    work in various locations in or outside the office and still be
    "plugged" in.

    For example you could have employees enter timesheets or have sales reps
    log their contacts. Or perhaps you'd like customers to be able to check
    the status of their orders online without having to call the company.

    If you want a Web database, typically what would happen is that a
    database such as Access or MySQL (basically just consisting of tables)
    would be put on the Web.

    Then "dynamic" Web pages (actually ASP pages which include VBScript,
    HTML, and/or JavaScript) would be created acting like the old desktop
    database's queries, forms, and reports to access the database - all
    hosted on a Web Server.

    Dynamic Web pages are similar in many ways to regular HTML pages. But
    they are "live" because the user can read from and write to information
    in the database. An example where you can login and add, edit, or view
    fictional customers and invoices is at
    http://www.bullschmidt.com/login.asp

    Not all Web hosts will handle dynamic Web pages but many do. The Web
    hosts that can handle ASP pages usually have a Windows 2000 or Windows
    2003 operating system running an IIS Web server.

    Here are a few good ASP sites:
    o ASP101 Samples - http://www.asp101.com/samples
    o W3Schools ASP Tutorial - http://www.w3schools.com/asp
    o Microsoft VBScript Language Reference -
    http://msdn.microsoft.com/scripting/default.htm?/scripting/VBScript/doc/
    vbscripttoc.htm

    And the following newsgroup is good:
    microsoft.public.inetserver.asp.general

    Or for a "quick and dirty" generic ASP open source solution to putting
    databases on the Web that just requires setting up a configuration page
    for each table or query and uploading the database to the Web as long as
    there is an autonumber field in each table (and you'll probably also
    separately want to create login capabilities), perhaps try something
    like this:
    GenericDB by Eli Robillard
    http://www.genericdb.com and then click on the Tips link to see an
    example

    Best regards,
    J. Paul Schmidt, Freelance ASP Web Developer
    http://www.Bullschmidt.com
    ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    Bullschmidt, Feb 25, 2004
    #3
  4. NiQ

    Bullschmidt Guest

    Bullschmidt, Feb 25, 2004
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ray5531
    Replies:
    1
    Views:
    1,670
    Marc Jennings
    Apr 4, 2005
  2. Replies:
    6
    Views:
    478
    Peter Otten
    May 10, 2007
  3. Hamilton, William

    RE: keyword checker - keyword.kwlist

    Hamilton, William, May 10, 2007, in forum: Python
    Replies:
    4
    Views:
    372
  4. Replies:
    4
    Views:
    407
    Mark Space
    Aug 5, 2008
  5. coolpaddu
    Replies:
    0
    Views:
    506
    coolpaddu
    Apr 21, 2012
Loading...

Share This Page