I am currently coding an accommodation rentals website and one of the searches required is an availability check.
At the time of booking you search for an accommodation that matches the accommodation type, no. of people and a start and end date from which to book.
I need to return a list of accommodations available using that criteria, I wanted to know if anybody has any ideas how to achieve this and do it efficiently.
at the moment i have a table that lists the accommodations and a bookings table that stores existing bookings.
I have this textfield named idNum and users are supposed to key in their id numbers into the field eg (S1234567D, F1234567Z). The id numbers either start with a S or F followed by 7 numbers and then end with an alphabet (A-Z). How can i check if the id number the user keyed in is valid? I'm using VBScript to code and the format is something like that:
If Request.Form("idNum") = "" Then validateForm=False errorMsg = errorMsg & "Please key in your ID number.<br>" End If
I'm creating a pseudo-shopping cart site for a client. Their IT has said that I'm not allowed to use a Database on their servers, so I'm working around that.Currently the user's shopping cart is stored in a cookie (prod ID, quantity), and it takes the Product ID from there and matches it with a product array that I have built into an included file (price, prod name, etc).
Now, I'm thinking about stream-lining this even more (as I would if I had a DB), and considering placing short and long descriptions in each product.So, my question is, how efficient is an array that could be loaded with hundreds of products and includes some lengthy text cells?Or would I be better off pursuing a different direction?
I'm in the process of optimising the code on my website and wanted to know the best way to do it. The majority of my pages make a connection to the database, create several different recordsets, and then display that data. My site gets alot of traffic and upwards of several hundred concurrent users. I'm trying to determine the most efficient way to do this.
1. Do I make the connection, create my recordsets, display the data, close the recordset, close the connection, clean up.
2. Make the connection, create the recordsets, disconnect the recordsets, close the connection, display the data, close the recordsets, clean up. This is what I am doing now, but am unclear if this is really neccesary as I'm not updating any data, only displaying it.
i am doing a new asp site with a lot of sql queries. i was just wondering if there was a tool to check if all recordsets or DB connections have been closed?
i have combined the main queries into functions, and i just want to check that i haven't missed anything.
ok so include file is a very useful and powerful tool that asp has. what i'd like to know is how efficient is it since it to looks through all the pages that are lincluded on a single page even if they are not 'used' via an if statement.
is this a memory hog if you have alot of pages that have multiple includes? does this cause any other problems/issues?
We have an "API" that is written in ASP. Basically it is an ASP page that receive an XML Query string post and sends back a response as a "response.write". The ASP page does validation and SQL calls then eventually written to the SQL 2000 DB and send the response. This works perfect. It is similar how Authorize.Net users post transactions. I am concerned about the availability and scalability of this. Our webserver is dedicated and the SQL DB is on a separate server (dedicated too). What happens when we have 100 concurrent users transmitting this query string to the ASP file? Will it freeze, hang, lose transactions? Is there a better way that does not re-writing in .NET or another language?
i have a task at work that i cant acomplish on my own. I have to create availability calendar of this type http://www.villarenters.com/advert_price.asp?ref=5731&rag=10821A&rcam=myvillarenters&sag=&sc=
and to make it work with our database. I try looking for the code of this type of calendars but i couldnt find anything . Please help me or tell me where i can find a script for this type of calendars (it must be a data base driven)
Does anyone know where I can download an ASP based availability calendar, or have one that I can buy? I've trawled the web and can find plenty in CGI/Perl running on MYSQL but none in ASP running on MSSQL or Access.
I'm running a small villa rental website and need functionality like total cost of rental based on numer of days, different colours for days booked, two year forward looking, that kind of stuff.
In ASP (vbscript) is there a way to check to see if a SQL server is online before trying to open a connection?
I have a situation where we have a SQL server that may be offline for a couple minutes and right the ASP page returns:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I'd like to be able to first check to make sure the server is available and if NOT, then skip the database connection on that page altogether. Or, at least load the page without showing the error. I have on error resume next but it still displays this error.
A field such as name was created to perform a search to find a person. However, if that person is not found, the user can click on the add button and it automatically populates that last name field in the add student form.
Is that possible to do the same with the student id number - by putting in the student id number and if not found click on the add button and the student id is populated on the next form? If so, how? Any tutorials would be very helpful?
how to go about creating my own custom ASP page that can show several different peoples availability from their Outlook/Exchange 2000 calendars?I don't want to have to ask users to setup permissions for their respective calendars, i just want to be able to see if they're busy or not.
I would like some help in having the form check to see if the selected course is available before submitting the info to the database and instructs them to choose another date if the course is closed. I have a qry that does a check and brings the information on availability. Any way to run that qry -check and send back the message or submit the confirmtion?
I'm working on a "hybrid" application some classic ASP, and some asp.net. I'm trying to develop a support type page that checks necessary components, database connections etc.. last item is to check for the .NET extensions. Is there a way to do that from a classic ASP page?
I am working on a website that requires a login before accessing an appointment book application written in ASP.Basically what I want to do is when the customer first clicks on "appointment_book" link, it takes them to the registration form. After they are registered, It will then redirect them to the actual application. I also want the same thing to happen when a customer clicks on the login link. I want them to login, then get redirected to the appointment_book. at the moment the customer click on the registratration link and it shows them the registration form, they are then automatically logged in after registration. However, when I click on the Appointment_book link again, it brings me back to registration form. How can I have the link always point to the appointment book after they are registered or logged in?
can i restrict that only domain1.com can access to http://www.xxx.com/file.asp page? so when user suft http://www.xxx.com/file.asp, they unable to view the content.both domain is on diff IP.
I have a form with several check boxes.they are all set to default to "unchecked."The db also defaults to unchecked.But,as soon as we hit the "form1.recordset.addnew" all of the cb's change themselves to "checked."?
Does anyone know of any nice ready made asp scripts to check a website's visitors age? I mean the sort of thing you see where you have to choose your day, month and year of birth from drop down lists to comply with US laws Code:
I'm trying to guard against SQL injection, but I have an ID number being embedded into a querystring for MSSQL table selection.
Is it good enough just to check if the querystring value is an int, if so could you quickly remind me how to check that. In PHP we use is_numeric or is_int.
I moved an ASP app to a new Win03 server. The sendmail function using CDO in all ASP appls suddenly stopped working. It worked fine on the previous server (also Win03/IIS6.0). Where should I go to check?
I would like to check if a website is currently down, but don't know how to do this efficiently. I do not have access to the remote server. I have tried using XMLHTTP, and it worked, it just took a long time and I felt it wasn't effecient enough. Is there some other way to check if the website is up or not using ASP?
I have a form that a user submits their clan's website, and roster page. What I want to do, is check to see if the field submitted contained "http://" and if not, add it to the field submission.
I know i can make this easier, and put the http:// in the field as a default value, but i want to know how to do this with a bit of form validation or something.
I've got a page that displays product details. One of the fields in my products table is called Include and is set to Yes/No. I use this to distinguish when I want to add that particular record to a recordset and when I don't. For example, I may have 20 products with the name Ash in them and create a recordset which pulls in all Ash products. However, I only want to pull them in when Include is set to Yes (the others aren't ready yet.) I'm using Dreamweaver and I've setup my product details page to include that Include field with a checkbox. It checks the box if the Include field is set to True. What I would like to do, though, is be able to then uncheck that box and have it update that field to False, or No. Right now, when I uncheck the box and submit the form I can go back in and it's still showing up in that recordset and the box is still checked when I go to the details page.
