473,385 Members | 1,907 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

keyword based Ads

NiQ
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
Jul 19 '05 #1
3 1085
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!
Jul 19 '05 #2
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/.../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!
Jul 19 '05 #3
ASP Design Tips - Search For an Expression on Multiple Fields
http://www.bullschmidt.com/devtip-se...iplefields.asp

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!
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Steven Bethard | last post by:
I mentioned in a previous post that I'd much prefer some sort of keyword as a decorator indication than a character like @ (or the recently suggested |). A promising note on python-dev: ...
2
by: Torfi Sackbatten | last post by:
Hi Everyone, I´m asked to "speed up" a keyword search based on MySQL. The material i´m given to work with is a quite large MySQL table with 1.5 mio rows, defined something like: CREATE TABLE...
3
by: Paul Auleciems | last post by:
Hi: I'm having trouble using an Object which is created based on the following: Public CarDetail () as Car Where the CLASS "Car" is defined as: Public Class Car
20
by: talin at acm dot org | last post by:
Although I realize the perils of even suggesting polluting the Python namespace with a new keyword, I often think that it would be useful to consider defining an operator for testing whether or not...
7
by: tweak | last post by:
Can someone give me a short example as how to best use this keyword in your code? This is my understanding: by definition restrict sounds like it is suppose to restrict access to memory...
3
by: Brian Gideon | last post by:
I stumbled across something odd today about the placement of the using keyword. Section 9.3.2 of the C# v1.1 specification did not answer my question. My confusion is isolated to what happens in...
33
by: Snis Pilbor | last post by:
With the "as if" rule in play, doesn't that effectively render the "register" keyword completely useless? Example: I make a silly compiler which creates code that goes out of its way to take a...
7
by: pbd22 | last post by:
Hi. I am somewhat new to this and would like some advice. I want to search my xml file using "keyword" search and return results based on "proximity matching" - in other words, since the search...
8
by: Laser Lu | last post by:
Sometimes, I need to do some time-consuming operations based on whether a specific keyword was contained in a lengthy string. Then, for a better performance, I wrapped that lengthy string into a...
2
by: DaTurk | last post by:
Hi, I have an interesting issue, well, it's not really an issue, but I'd like to understand the mechanics of what's going on. I have a file, in CLI, which has a class declared, and a static...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.