I'm creating a room reservation system. For some reason I can think of how I can track of Time so that there can NOT be double booking. I figure I should put it in the script but I just am having "writers block" and can't figure it out.
I thought of doing a start time and and end time. But how to I stop people from trying to book in between. Say a room is book from 8:00am till 1:00 pm but someone wants to book 1:30p but they accidently key in 10:30a (it's a stretch I know but work with me here). I want to stop them from booking that. They should get a error saying it is already booked at that time.You don't have to write out the code for me, unless you really want to. However help me get my thought process through the tunnel.
Does anyone know of any free ASP 2.0 room reservation code? I have been looking at Webervations.com and they have what i want but i don't want to pay the $80 for it per year.What it is, is a website to check to see if (in my case) there are rooms available in my bed and breakfast.
I am not looking for online payments I am just looking for the customer to be able to search and see if there are rooms available and then book/reserve them if the customer would like to.
I want to develop a hotel reservation sytem.but i have some problems. this project is VB project. I'm doing a web part. I need to check available rooms with available dates.
i want to check item before insert new item. let say resID = 1052. before that, i have inserted item which is prodNumber = 100 for resID = 1052. then, still at resID = 1052, i insert another item, prodNumber = 100.
then an error message will come out. but if i insert item, prodNumber = 100 but for resID = 1047, suppose there is no an error message.
that means the sql conditions are at current resID and prodNumber.
I have problem i want created simple site This site should epitomize table about organizer free or busy room in month the rooms is 6 but people should mark
we have 7 computers can access our web application.Is there a way I can use their computer names to identify which computer login?I use asp and javascript.
I Am Creating A Room-Booking System. The Establishment I'm Making For Has 6 Periods Of Time A Day. Any Examples Of A Statement I Could Use Whuch Searches A "Day" Field For 6 Identical Dates, And If It Does, Says "Fully Booked" Or Something?
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.
I am working on developing a chat room using mysql database. the chat room has two frames one for the display text and the second frame for submit text from the user.
the two frames are: display.asp send.asp
what I need help with is when the user send a message how can I update the data with the new entry. Code:
I am currently developing a final year project which is a web based tracking system tracking exam questions. I am using IIS as the server, MS access for the database, and ASP with VBScript for the scripting side of things.
One of the things I want to do would be to e-mail a user/moderator whenever a exam question is edited/completed/updated. does anyone have any previous expierence in this? i don't even know where to start.
What is the asp code variable for System Date and System Time? Are they built-in system variables, or is there some code involved to return the values?
Ok the kid who put together my shopping cart did a pretty good job. Each item is housed in a SQl db table, however I one problem..
The description field can only carry a max of 1024 char and is a NVARCHAR.
Should I...
A. just add three more fields to the db of the same type and add 3 more text boxes to my eidt product page and pull all 3 out when i build the page?
B. Change the current DB type to something other than NVARCHAR?
C. Find some other way to store my descriptions that I have not yet even realized could be done?
anyone have any ideas... Im no guru, but I know enough to get myself in trouble. heehee 1024 is not even close to enough room on some products. Some of them I need about triple that space easy.
I've created a system DSN called 'accessDSN' for a MS Access DB. I get an error when running the following.
Code : <% Set Con = Server.CreateObject("ADODB.Connection") Con.Open "accessDSN" sqlString = "INSERT INTO Products(product_name,product_price) values('Gift Basket',34.54)" Con.Execute sqlString Con.Close %>
Error :
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /asp/l52.asp, line 5
I want to stick with VB on this project. The only problem I have with this is that I might have a problem with printing. The POS system is designed on a small 10-15 computer networked system. They are all good systems so nonone say that it may be a little to intensive for the systems.
Now once the system runs through basic checks: change exchange, enough money to pay, and other smaller features then it has to print the invoice. Now we have a small Epson Thermol (prints like Lazer) printer. How would my VB application send that information to the printer?
Microsoft, in one of its "Help & Support" pages on ADO, says that a System DSN is three times faster than a File DSN. I find that a bit odd for the simple reason that won't it be faster for a script to access a file to get info about the database source than access the same info from the registry which will be the case if a System DSN is used instead of a File DSN?
I wanna build an email/messaging system whereby all members of a portal can send messsages to each other (internally). An example of this application would be the system available in www.friendster.com whereby all friendster members can message each other. Each member has his/her own inbox, trash, sent messages and so on. Can anyone help me with this? I would be eternally grateful
Secondly, i need help with building a forum as well. So far i'm having difficulties getting one that is easily customisable.
I have been working on a simple eLeave System. I would like to get more advice of my db design. Basically, I have 2 tables here: user and leave_application. I will just put the relevant field needed for leave calculation. user: date_employment, type, t_annual_entitled, t_annual_actual_taken, t_annual_balance leave_application: date_leave_from, date_leave_to There are 2 values under type, E - Executive and NE - Non-Executive.
Example - If type = E, t_annual = 22 - If date_employment = 7 July 2005, t_workingdays = 187 - So, my formula for t_annual_entitled = (22 * 187) / 365
So, is my db design and my formula okay for this system? Any other better ways?
Created a basic ASP/ADO/Access 2000 Newsletter system using JMail. Basically client has 300+ subscribers and wants to send 1 newsletter email to them all every 1 - 2 months.
Missed my client's call to say it wasn't working, but having checked with my ISP (FastHosts), they have some kind of embargo on the amount of emails that can be sent every 10 seconds.
how to create a simple rating system just like the ones on Amazon.com? I found a link which i tried and i think it is flawed. No attemp was made to provide the source files
At the beginning of the month,the whole DB server is down because of the change and upload of tables. So naturally the ASP pages would show errors. I have 1 dbconnect.asp page which gives the db connection information. How can I display a status.html based on the DB's down period?
I am spawning a process on the web using ProcessInfo and Process classes. Running on my dev. XP Pro machine all is fine. Running the same thing on w2k3 server I get "Access Denied" on the page. It seems like a security problem though I don't know how to resolve it. I have tried all sorts of combinations on directories, vdirs, etc.
Am implementing an alert system that will notify users by mail of activity on a pre-defined date. What function or event can I use to achieve auto-execution of this alert on a specified date without human intervention.
I wanna build a mail/messaging system whereby all registered members of a portal can send messages to one another (internally). An example of such an application would be the mail/messaging system at www.friendster.com whereby users can send messages to other friendster users. Can someone help me with this?
i need a rating system on my website were people would be able to vote out of to topics and once say 10 votes have been made it adds up the totals and inputs the result of the topic which won
I am currently working on a site that's hosted on IIS. I need to implement a user login system for multiple members. Basically I need to secure mulitple pages and each member would be directed to a different page once they log in.
For example:
client1 logs in and is directed to /client1/reports.html client2 logs in and is directed to /client2/reports.html
Also, it would be good to be able to display error message below the form if the username or password is incorrect.
I am new to asp and IIS and am having problems finding something that works easily. Can anyone refer me to a script that I can use? It can even be something retail, I have a small budget to pay for something that works.
I recently developed my first website and I hosted it on my pc.But when I try to access it from other computers, I am able to do that only when I turned the firewall off.Is there any possibility to access my website in internet on providing security to my system?
And one more problem is when ever I access any control on my webpage in internet, I am getting a dailogue box indicating that "connecting to mysite.dnsalias.com" and it is asking for userid and password.If any one knows please tell me why I'm getting the dailogue box and how to avoid getting it.
I have this simple problem and I have no idea why I havent got this to work. How can I change the system time with asp --> 08/28/2005 to a format like this --> 28.08.2005?
I am trying to create an online class booking system for a project, how can I sort out the classes so that when a user selects one it gives them the date of the next class, which would be the week afterfor example if I book a class for Thursday then I will be told that the next available class will be Thursday next week. Also if it was Thursday and I wanted to book a class on Monday then I would want it to book the next coming Monday.
The classes are changed every four months, therefore having to put these in a calendar would be extremely time consuming. Is there a calculation I can use in ASP to automate this on the basis of the above example?