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.
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?
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.
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?
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.
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?
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.
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?
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?
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.
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:
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?
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.
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.
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.
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:
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.
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.
