select *
from Profiles
where PID = #pid# and
ProfileName <> 'GENERIC' and
Active = TRUE
select ProfilesRooms.*, Room.RoomName, RoomOption.OptionName
from RoomOption INNER JOIN (Room INNER JOIN ProfilesRooms ON Room.RID = ProfilesRooms.RID) ON RoomOption.OID = ProfilesRooms.OID
where ProfilesRooms.PID = #pid#
order by ProfilesRooms.RID, ProfilesRooms.OID
">
insert into ProfilesUsers
(
PID,
GroupName,
UserName,
UserAddress,
UserCity,
UserState,
UserZip,
UserPhone,
UserFAX,
UserEmail,
UserNotes,
UserRoomInfo,
ReservationType,
PaymentType,
ReservationDateBegin,
ReservationDateEnd,
SubmittedDate
)
values
(
#pid#,
'#form.GroupName#',
'#form.UserName#',
'#form.UserAddress#',
'#form.UserCity#',
'#form.UserState#',
'#form.UserZip#',
'#form.UserPhone#',
'#form.UserFAX#',
'#form.UserEmail#',
'#form.UserNotes#',
'#UserRoomInfo#',
'#form.ReservationType#',
'#form.PaymentType#',
#CreateODBCDate(form.ReservationDateBegin)#,
#CreateODBCDate(form.ReservationDateEnd)#,
#CreateODBCDateTime(Now())#
)
#form.UserName#,
Your group request for rooms was received on #DateFormat(Now(),"mmmm d")# at #TimeFormat(Now(),"h:mm:ss tt")#.
==============================================
Event: #form.EventName#
Event Location: #form.EventLocation#
Event Dates: #form.EventDates#
Reservation Dates: #form.ReservationDates#
Rooms Requested:
#UserRoomInfoDesc#
Group: #form.Groupname#
Name: #form.UserName#
Address: #form.UserAddress#, #form.UserState# #form.UserZip#
Phone: #form.UserPhone#
FAX: #form.UserFAX#
Email: #form.UserEmail#
==============================================
A #whoThisMin# representative will be in contact with you shortly.
Sincerely,
#whoThis#
#contactInfo#
Your room request has been successfully submitted.
We have e-mailed you a copy of your request for your records.
Please be aware you have made a room request, not a reservation. A #whoThisMin# representative will contact you within two business days to guarantee your reservation. Thank you for choosing to stay at #whoThisMin#.
Please feel free to call us at #whoThisPhone# if you have any questions or concerns.
#introtext#
The following group request has been made available to you:
To sign up for this event, please enter your information below:
Group Name
Name
Address
City
State
>#ListGetAt(StateNames, curIndex, ",")# - #ListElement#
Error. Length of State Codes does not match length of State names.
Zip Code
Phone Number (Daytime)
FAX Number
E-mail
Reservation Type
Payment Type
Arrival Date
Begin Date
Departure Date
End Date
Please select your room preferences:
#RoomName# #OptionName#
Rooms at $#DecimalFormat(RoomPrice)# per room
Rates include complimentary adult beverages from 5 - 7 pm and two complimentary breakfasts per bed. If a room has two beds, the rate includes four breakfasts. If a room has two beds and a sleeper-sofa, the rate includes six breakfasts. More breakfasts may be purchased at check-in if needed.
