Availability Check Efficiency
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.
View Replies
ADVERTISEMENT
how can i create a button/link to check availability of a user ID against a an ID field. Code:
View Replies
View Related
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
View Replies
View Related
how to check the availability of data in table. If there is, I want a messagebox to prompt the users.
View Replies
View Related
I have an if statement with 3 out comes. Each out come requires a different html output, which is about 25 lines. Is it more efficient to use Code:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
If my user turns cookies off, both permanent and temporary cookies can't be used or only permanent cookies can't be saved on the user's machine?
View Replies
View Related
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?
View Replies
View Related
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)
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Can anyone offer a good reference for a domain avialaibility checker? I'd like to create a web page to see if domains are available or not.
View Replies
View Related
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?
View Replies
View Related
Somebody know a component or code to ckeck. The availability of a domain?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
let say:
http://www.domain1.com/index.asp?url=http://www.xxx.com/file.asp
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.
View Replies
View Related
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."?
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
how to check any value in asp that it is null or not.
View Replies
View Related
I have a form that has simple vaidation but how do i check to make sure there is and email in the email section.
View Replies
View Related
How can I check that entered value in a text box is numeric or not in next page?
View Replies
View Related
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.
View Replies
View Related
I have a signup form.
I would like to be able to check for duplicate entries during the signup.
E.g. Check for duplicate
1. Usernames
2. Phone numbers
How could this be achieved ?
My code basically is two fold.
1. A recordset that checks
if not recordset.bof and not recordset.eof then
'do something. And redirect to say the value exists
end if
2. Run a SP to do an insert and authentication
View Replies
View Related
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.
View Replies
View Related
