Approach This Task
I have a table which stores details of businesses. These businesses have associated links to 2 tables called areas and categories. What I would like to be able to do is display a list of all the businesses in a particular area with a breakdown of all the different categories in that area together with a corresponding count of records.
i.e. pull out all the businesses for a given area and order by business category
then for each category, display a count of the records in that particular category in that area.
View Replies
ADVERTISEMENT
you have a DB that contains about 2000 records.
Assume that the records are houses with addresses, already known to the user,
[remember, there are rooms, bathrooms fireplaces, garages etc].
What I want is this:
A user enters a known address in the form. The form seaches the DB and returns the address with full details.
That is, search results will be like,
Address 1234, number of rooms 3, bathrooms 3 etc.
If the address the user seached for is not found, the user is redirected to a page that prompts them to add it
to the DB. Also I would like for it [search results] to open in a mini window with an option for the user to close window after reviewing the records.
I have thought of using a drop-down but discarded that, 'cos what happens if the DB records gets to be in the thousands?
View Replies
View Related
We need to create a user control (COM) in which it should be able to retrieve binary data from a given website after a user selects an item ID and clicks Retrive button.
We then can put this user control in a html page (generated by .asp page) so that internet users can use our data stored in our web server.
Any reference paper or sample source code?
View Replies
View Related
I will have a web site where hotels can list themselves on it.One thing I am encountering that is a challenge, is that every hotel has different types of rooms. Also, every hotel has the normal high and low seasons, and some even have more seasons such as shoulder, weekend, etc. which affect room rates. So here is how I concieve the design:
First, allow hotels to specify how many seasons they have, perhaps with a drop-down box of values such as 1,2,3...6,7 etc. They would then be presented with a series of text boxes, and asked to define the season, such as "High" "Low", etc. Adjacent to every season would be a beginning and ending date for that season. Next, they would be asked how many types of rooms they have, such as a drop down with 1,2,3,....5,6,7. Once decided,a form would present itself with form fields for the each room, such as description, ameneities, and most importanty, rates PER season. The seasons would be defined from previous step and would be unique for each hotel.
Once complete, this would give a web site where I could list hotels and each would have its seasons, rooms and rates listed uniquely.Is this a good concept?
View Replies
View Related
I'm able to pull the image from the database but I'm not able to pull the text from the record using this script. What am I doing wrong? Code:
View Replies
View Related
Say I have a DB with 10,000 records and using MySQL paging. I want to put a link setup at the top of the page with the alphabet that will pop to the proper page for each of the letters.
So: 1 A B C D...
Click on 1, goes to page 1, click on A goes to page 7, click on B goes to page 10.. so on so forth. how to find the pages either through an SQL subquery or through ASP. I can write code to make it happen, but I'm looking for a solution that will not hamper performance as much as an array dump and search.
View Replies
View Related
What would be the best approach to sending a mass email out without clogging the server or running the risk that emails maybe lost (possibly due to a timeout).
Currently, I've been given the task with sending out a monthly newsletter to our customers (upon request of course). It is an easy task from what I can tell, simply bcc all the emails, set HTMLBody and TextBody and send it off. But, I will be sending this to 5000 clients and dont want any dropped emails.
Plus, is there a way to determine failed email address (due to bad domain names, bad email address, etc) and report it to the web application?
View Replies
View Related
i need to create a xml file with asp. I think i can handle that part but before i start is there a way to create an xml then have it upload that file when it's not really creating a new page? hopfully that makes sense. so i need to create a xml file with asp then upload it to an ftp using asp.
View Replies
View Related
I have a problem. I have a database with 1000 e-mails that i use in my
mailinglist. And when i send them mails it takes kinda long since i attach a
..pdf file each time. so i was wondering if there is a way in asp to create a
task on the webserver using asp to trigger a script that sends the mails.
sure i could use server.scripttimeout but the thing is that i dont want to
wait 30 seconds for the page to finish loading. and if there will be 3000 in
near future i'll have to wait for a very loooooong time.
anyone know how to create a task using asp dynamically?
View Replies
View Related
I am trying to create a Function to delete records in database on daily basis. I am stuck with date/time.
Sql:
Delete * from MyTable where date = &date& 'not sure of quotes also.
How can I rewrite my sql to delete records daily at 8.00pm?
View Replies
View Related
I am attempting to design a maintenance program which includes a series of recurring tasks. I would like for the user to be able to assign their tasks to recur similar to the way Outlook does.
I have been searching on the web for quite a while and have been unsuccessful with getting ideas on how to start this. I would like to use ASP VB or JavaScript.
Does anyone have any suggestions or links that could point me in the right direction?
View Replies
View Related
i want to print a string (that i retrieve from database field), that contains say 60 lines, then i want to insert a page break and a common header for each page.
View Replies
View Related
I want is to have my asp code test if it is the first time the page has loaded. If so it will need to skip my validation info, if not then run the validation code:
View Replies
View Related
I want to send email atomatically everyday.I tried using the scheduled task but when I typed in the URL i the "Run" textfield,the scheduler could not start.Anyone knows why?
View Replies
View Related
Any way to do a Scheduled task without having access to a "Scheduled Task" feature in the hosting control panel. IOW, I want to run a single Update Table query every Sunday at Midnight but I don't want to have to manually run it. I use SQL 2000 on a Win2k machine.
View Replies
View Related
I'm trying to find a way where I can schedule a task to be run within a web site, either in VB (COM) or within the web site (ASP). What I want to do is to run a daily scheduled task which will cleanup a desired folder within the web site. As I say, this must be an automated scheduler which can kicked off by itself without any interaction from a user etc.
View Replies
View Related
I need an end task program in VB6.0 (the source code). I have searched planet-source-code.com inside out and can't find just 1 regular end task program that works on my system. Is it because I am running on XP and they only work on ME and younger systems?
Anyways I need an XP, source, compatible version of the software. I am writing an interesting program, which once complete will tell you what its for (dont worry this one is totally legal ). It should list and then allow users to click END/close. I think its done through an API.
View Replies
View Related
I have an ASP application which includes an asp page which
processes a user submitted file. I would like to
automate the process so the server scans the directory
every 5 minutes and processes any files in the directory.
I would like to 'reuse' the existing logic in the asp
page.
How can I create a server process to do this?
The closest I can figure out is to hook the logic into a
application/session start logic in global.asa where it
would run everytime a new session was started, but I would
like it to run like a cron job every 5 minutes. Code:
View Replies
View Related
Is it possible to run an asp page as a scheduled task?
View Replies
View Related
Does anyone know if its possible to send an Outlook task from an ASP page running on a Windows 2000 Server on an intranet. There is also Microsoft Exchange Server on the same network which handles Outlook mailboxes.
The Windows 2000 server will soon be upgraded to Wndows 2003, if that makes a difference.
View Replies
View Related
Is it possible to create an outlook task item from ASP? I tried using server.createobject("Outlook.application") but the page just hangs without output. I use CDO.message for mails.
View Replies
View Related
