Simple If statement in ASP

[kamazoo]

I have no programming experience whatsoever, but nevertheless am I currently responsible for an update of a website, where a few hotels can be booked using an orderform.

The website is built with Frontpage and the orderform calls a rather simple asp-script, which basically just defines a few parameters and inserts these into an email, which is sent to the booking department.

The orderform lists the different types of rooms that can be ordered for each hotel and currently the complete list of rooms is repeated in the email that gets generated and then the number of rooms is listed for each type of room.

However it has been requested that only rooms that have been ordered (and the quantity) is being included in the email and I guess that this can be achieved using an If statement, but after a few attempts based on some ASP tutorials, I must confess that I need help - although it is probably very simple.

Below I have cut out the part of the ASP script where the variables are being inserted into the email. I now hope that someone can help me with how I get each of the the last two lines to only appear in the email, if they have been ordered in the orderform.
The values of the variables "SingleRoom" and "DoubleRoom" are the number of this room type that the customer has ordered, so you could say that the DoubleRoom line should only be included in the email if "DoubleRoom > 0".

Emailtext     = "Hotel:    " & Hotel & VbCrLf &_
                "Arrival:    " & DayOfArrival & "-" & MonthOfArrival & "-" & YearOfArrival & VbCrLf &_
                "NumberOfNights:    " & NumberofNights & VbCrLf & VbCrLf &_
                "RoomTypes:"  & VbCrLf &_
                "Single Room    " & SingleRoom & VbCrLf &_                                                                                     "Double Room    " & DoubleRoom & VbCrLf &_

I hope that someone can help!

[karthi84]

hi kamazoo,

i am not clear in ur question. what are the details u r in need to send through the mail. where are the room details stored i.e., in which database.

get me these details and let me try helping u.

regards....

[kamazoo]

hi kamazoo,

i am not clear in ur question. what are the details u r in need to send through the mail. where are the room details stored i.e., in which database.

get me these details and let me try helping u.

regards....

Hi karthi84,

I hope that I can provide you with the details that you need...

There is no database involved (it is a very simple solution). All information about the room types is coming from a form created in Frontpage, where the user select the number of rooms for each room type that he would like to book.

When the submit button is pressed on the Order form, the ASP script is called and inserts the room type variables into an order email that is sent to the booking department. What I hope to achieve is to only receive information about the room types that have been ordered - currently I get a full list of rooms, whether they have been ordered or not.

If this is not enough explanation, I could perhaps email you a sample booking form + asp-script. That would probably give you a better understanding of how it works currently.

Regards,

[karthi84]

hi,

now i got a better idea about it. how u transfer the details from the front page. i.e., do u use any querry to get the details from frontpage or by how u r getting the info. i ask this question as i dont have any idea about the frontpage. if u use a querry then u can easily filter the details that have been selected and send them to the asp page. if u are able to send the code then send it to the pm so i can solve it personally for u.

[kamazoo]

hi,

now i got a better idea about it. how u transfer the details from the front page. i.e., do u use any querry to get the details from frontpage or by how u r getting the info. i ask this question as i dont have any idea about the frontpage. if u use a querry then u can easily filter the details that have been selected and send them to the asp page. if u are able to send the code then send it to the pm so i can solve it personally for u.

Hi,

I sent you an email instead, since I had to attach the relevant files. I hope that is ok.


Thanks and regards,

[karthi84]

hi,
i got ur mail, i will be checking it and reply u. u can even attach a file in this form also.

let me reply u after solving ur problem

[karthi84]

hi kamazoo,
i got a problem in editing ur asp page, when i run ur asp page it is checking the if condition with ur server from where i am not getting any response so i think i need all the pages that r linked with this two pages.

better let me guide u from here so that u can solve ur problem urself or get me all the pages that gets linked with its operations.

can u tell what information u get in the mail about the non selected rooms, i.e., room informations. is that empty or contains some value so i can easily assist u in solving it.

the problem seems to be in the region of webmaster text and the hotel text. as there only u call on all the values.