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?
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.
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?
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.
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?
At the core of my DB schema is a request table. This entity has one or more assignment records and each assignment record has one or more assignment log records. The log tracks assignment actions such as hold, release, open, close, etc. In VB, I would normally create Request, Assignment, and AssignmentLog for the data. I would also create two custom collections for Assignments and AssignmentLogs. Given any Request ID, I could populate everything else with encapsulated queries and recordsets. The request object could implement properties to give the currently assigned helper, open state, elapsed time, etc. My question to you is; how to I implement this model for the Web? As I understand it, web objects are stateless. If my request object can't persist its data in memory, then does it have to fire a query every time the caller wants a property value? Will I always have to pass the RequestID in as a parameter?
I want to write a shop content management system in ASP.However the database holding the products for sale will be on a different pc to the webserver.I do not want the remote webserver pc to authenticate against the sql server.
Ideally the cms should produce static html pages which could be indexed by a search engine.So far,the most likely solution will be for the web pages to include javascript includes which will reference an asp page on the same machine which houses the sql server, this will then insert the values into the web page at run time.
I could make it so that the sql server PC creates the entire website, then automatically ftps' it to the remote website - however the problem here would be that the ftp would probably go wrong a lot and generate loads of support calls.
which is a better model to implement to design a database with all the constraints during the design of tables, etc, etc or to write the code ( in asp ) and implement the constraints needed when storing data by means of the code.
yet my colleague can? (when looking at exactly the same page - same destination folder etc) Is there some sort of setting, so that you dont only see those small yellow ASP blocks when looking at the design view, and see the layout of the page , with the tables etc? I realise that most of you gurus dont use the design view at all, but it is something that using ASP,
I need to have a webpage that starts off with content down the side and along the top, when the respective top and side have a value id like it showing up at where the side and the top meet. I had tables in my database that linked up and when I ran a form with a subform it seemed to work well.
But I cant seem to get anywhere close to pulling the data down correctly to a webpage so help.Its difficult to kinda explain what I want to do and I seem to be having a difficult time making it run properly.
how most of ya'll design your databases and why in that particular way? I'm specifically interested in setting up tables in which the data are linked.ie:table1 contain registration information and table2 contains account information and comments.
How would I link these? I'm thinking using a standard primary such as autonum and when they register to write to the two tables but i might be mistaken.
I have customers that I designed a site for. I am almost complete with the site, and they are saying that the font is too small. However, on my computer it looks just like the font on devshed and everyother site. Are there any suggestions out there, as to maybe their settings are messed up or my scripting is bad .
I am currently creating an intranet application, in which the staff will be able to create their personal profile uploading their pictures and such. Now i have tend to act cautious when users need to upload their picture. i have set the maximnum size to 30kb.
my project manager seem to think otherwise saying this might discourage pple from using the application. I need some advice though as regards the maximum size of the picture. Also, does ASP has any inbuilt object that can resize a picture before storing in a database.
I have coded my pages in HTML and named them as ASP. I would like to use a trailing string i.e. domain.com/page.asp@somthing=4 . which pulls from a database of plan names and corresponding prices over a user selected interval. I want to offer pricing over these intervals:
1month 3months 6months 12months 24months
with a percentage discount being offered for each greater length of time. The user should be able to use radio buttons to select how to pay and after this a paypal button should be generated with the designated amount.
Now that I have layed out what my intensions are, does anyone have any ideas of how to complete my goals using ASP? and if ASP will not do the trick does anyone know of a better/differnat way to do this.
I need some help optimising my object design. Since one article has 1+ authors, I assume the logical way to represent this is for my Article object to have a Authors property, of type "array", capable of representing any number of authors.
The code I have written (below) works, but is very inefficient; if I want the asp page to fetch a list of 30 authors using GetAuthors(30), there will be a total of *31* calls to the database - one call in GetArticles(), and one call to GetAuthors() for EACH article! Code:
I have an array of records, would like to put them into X no of tables depending on the number of records. The max X is 3. For eg, i have 15 records in the array
I would to have record 0,3,6,9,12,15 in table 1,record 1,4,7,10,13 in table 2, record 2,5,8,11,14 in table 3.
I tried to use 3 for loop, it did the job but is there a better way to do.?
We have a cart we built using sessions, it has been fine until now where our server times out at 20 mins no matter what we or the server techs do, so now we want to redesign the cart using tables soley, can this be done?
If so is there any disadvanages of doing this? Anyone know of a tutorial to do this so we can get started?
I'm using GET to pass variables from a page that consists of 20 choices that each redirect to a different page. I had originally planned on making 20 form, which would allow me to use jpeg images for the buttons.
The problem I am having is if you put forms one under the other, the browser puts a carriage return between them...and it's making my page much larger than I would like. Is there a way to pass the variables using GET(or any other method) that would allow me to use links instead of images?
This string is supposed to provide all records from an MDB database that match the courier and date specified in the query. I Response.Write the query and I get a date as 1/27/2007. The date format style is exactly the field specification as I see in the MDB Date field in the Courier table. The data for this query exists - both the courier and date that I'm selecting. However, when the file continues processing and the results are displayed - no data! What am I doing wrong here? Why would an MDB not understand a date format of mm/dd/yyyy if that is what I'm explicitly seeing in the field of the table? There are no constraints on the field design.
'<snip of the code> cfedexSQLstr = "SELECT * FROM Courier WHERE Courier.Courier = 'Fedex' AND Courier.Date = " & strDate & ""
I would like to create a chat room but I don't know where to start. for example: Should I create a database for the user input and output. I never done this before.
My coding experience comes from mostly application development instead of web coding. In the application world, if the user receives a system error, a new form would display the error, with any helpful information for the user and the application administer. This way there is a systematic way to handle errors. In the web world, how is this done?
For example, if I have a form where the user is entering data to be inserted into a DB. Is this the correct flow of pages?
-On submit of Entry form, an ASP page is called to insert the data -If insert successful, take the user to the next logical page -If insert not successful, display an error.htm page.
Basically, the entry page does not have the insert SQL and if there is an error in the insert (not because of missing fields because those are handled with JavaScript before submit), the error is displayed on a completely different page. Is this correct flow?
our database could be designed better because the more tables we have in our database, the less efficient it will be with a lot of activity. our database uses mysql and currently has about 6000 tables in it.
here's how i need the site to be. first of all, it's a gaming site, so if anyone has gaming knowledge that will help. for the tables, i currently have one table for each game that's. Code:
I have an ASP site with about 50 ASP files, all of which are currently including a common "includes.asp" file near the top of the file, responsible for generating the <HEAD/> section of the HTML.
I need to make a change for 3 of those ASP files such that some dynamic HTML is generated in the <HEAD/> section. I want those dynamic HTML to appear only for 3 specific ASP files. Is there a more elegant way other than to:
1) Dim strOptionalDymanmicHtml1 in includes.asp 2) Initialise strOptionalDymanmicHtml1 to "" in includes.asp 3) In the 3 ASP files which require additional optional dynamic HTML, initiliase strOptionalDymanmicHtml1 *before* including includes.asp
There is an additional even more tricky problem, I have most file taking this structure Code:
I need to create dynamicly an ouput table that users can edit their hours and cost center. Each day have maximum 2 entries for week if they have one entry per week, then the design table will have an empty text box for users to enter in.see the attached outline to show the weekly timesheet in edit mode. Below is the query I am using it ....
I work for a Startup based out of San Diego, CA. We are succesfull team of entrepreneurs with a proven track record. We have finished an initial design for a site that helps people be more productive with social networking aspects. This means we have a bunch of use cases and wireframes completed. We need help in putting it all together and creating a great overall design.
We are looking for referrals from the community for designers with solid portfolios. West Coast bases teams/indivduals are preferred.
Is it possible to implement a Service to Worker design pattern using ASP Classic?
For example, lets say I want to design an e-mail process.
My EmailEntity.asp would include: toAddress fromAddress emailSubject emailBody
Then I would want a driving event which would create an EmailEntity.asp. It would then populate the toAddress, fromAddress, emailSubject and emailBody. It would then call an email generating .asp file.
I can does this in Java at work but I was curious if I could use this pattern using ASP Classic.
i'm wondering if it's possible to modify the design of an sql database from within a script. I don't have MS SQL installed on my machine but i need to add a few fields to some of the tables.
I know it's possible to create and drop tables so that is one option. ie: drop the existing one and create it again with the extra fields. the problem with that way is I'll lose all the data. so long story short. how do i modify the design of a table from within a vbscript?
I have 2 include files on my page which are both navigation bars. When i view my pages in IE they look fine and everything is in the correct place, however the problem is that when i look at the pages in design view in Dreamweaver i can only see my first include file. the rest of the page is not displayed so makes designing hard as i cant really see what i am doing until i view my page in IE.
WHY IS IT DOING THIS???????????????? Or is this meant to happen, i have never used include files before, but im assuming this shouldnt happen?
Got an item master, think of it like an inventory: description, supplier, cost, unit of measure, etc.
There is an item_type field, which, when set to a particular value, REQUIRES that labor be also entered for this inventory item. I was going to just show/hide a part of the form, but the kicker is that more than 1 labor item can be entered for each inventory item.
I need to create dynamicly an ouput table that users can edit their hours and cost center. Each day have maximum 2 entries for week if they have one entry per week, then the design table will have an empty text box for users to enter in....
Please see the attached outline to show the weekly timesheet in edit mode. Below is the query I am using it. Code:
