Posts by ericstenson

Using your example above, the following reservation has been made:

A: 4/17/2009
D: 4/25/2009.

Now, a customer calls and says I want to book 04/16/09 to 04/27/09.

Let's go through my steps.

1. Do any arrivals fall within the date range?
Arrival of 4/17/2009 falls between 4/16 and 4/27 -- record is returned

2. If there is a record returned, you cannot book.
We cannot book this the 2nd reservation.

****

Let's modify the example, and say your 2nd resevation was 4/18/09 to 4/27/09.

1. Do any arrivals fall within the range?
Previous booking has arrival of 4/17, so NO.

2. If so, you cannot continue.
We can continue, because the answer was NO.

3. Are any departures within the date range of 4/18/09 to 4/27/09?
Yes, the first booking is leaving 04/25/09.

4. If so, you cannot continue.
We cannot make the reservation, because a deperature falls within the range.

Does this make sense??

Hi - Why not have the user validate the email on registration? I send the user an email with a random number that I generate. Store that number in the database and have them enter it to activate the account. You can also give a link to a blank page in the email and pass the number in the query string (which gets retrieved when they go to the page) and activate that way.

Ask Al Gore, he invented it.

Password length probably hasn't changed, I think SQL just standardizes how it displays the ******* so people can't tell how long it realy is. Password (and correct me if I am wrong), I do not think is kept by SQL as plain text.

With respect to the log-in, check the DB & Server properties. Make sure "deny" isn't checked anywhere, and make sure you have both access to the server and DB.

Best,
Eric

sBIG.contains("WHATEVERYOUWANTTOFIND")

so like:

if SBIG.contains("#") then

label1.text = "Hello World"

end if

Please mark as solved and give me some rep points :) I am glad you got it working!

double click on your dropdownlist and change the end text of the sub from .selectedindexchanged to .databound

then write your code that sets the selected value to the cell value from the database.

if you are doing it on page load, call a dropdownlistX.databind() to make this code function on load.

ok, give me some brownie points