T
titus.hanke
Hi all, I am hoping that somebody can help me with my problem bcause
have been trying for weeks to get this done and am failing because o
my lack of knowledge of VB. Here is what I intend to do...
For a student project, I want to analyze a set of given hotels an
their rates published. The Global Distrubion Systems (GDS) that contai
those published rates are used by several e-commerce websites t
display the rates to the online-customer. One of those sites is:
*http://www.available-rooms.com*
with the hotel search engine here:
http://res.available-rooms.com/nexres/search/power_search.cgi
When inserting the search options (arrival date, departure date, hote
name and location), the result is a page such as this:
<br /
<b>Warning</b>: mysql_pconnect(): Lost connection to MySQL serve
during query in <b>/home/sites/site15/web/db_connect.php</b> on lin
<b>3</b><br /
<br /
<b>Fatal error</b>: Call to undefined function: mysqlerror() i
<b>/home/sites/site15/web/db_connect.php</b> on line <b>3</b><br /
Notice that the URL carries ALL the information needed for the query:
- the hotel id number
- the arrival date
- the departure date
- number of guests
- the desired currency (in this case Euros)
In the search results, something like this appears:
WCT Call Center Discount Rates!
Total Rate: $749.39 USD
Rate Plan: WCT Call Center Discount Rate
Room Type: Deluxe Room with 2 Twins or 1 King Bed
$749.39 USD
(614.49 EUR)
Nightly Rate Book Now
The information I want to extract with the Excel web query is:
$749.39 USD
Deluxe Room with 2 Twins or 1 King Bed
=========================
This information should be queried for different date patterns though
so the URL should contain variables for the arrival and departur
dates, where the departure date is always arrival +2 days.
Example:
doa_dd=22&doa_mm=09
doa_dd=23&doa_mm=09
doa_dd=24&doa_mm=09
....
doa_dd=30&doa_mm=09
(DOA_DD = Date of Arrival_Day; DOA_MM = Date of Arrival_Month)
THERE IS a pretty good attempt already to be found here:
http://www.willowsolutions.com/tips/tips_2002_08.shtml
The problem is that with my lack of VB, I am not capable of modifyin
the code to my requirements...
In the long, long, long end of the process, I would ideally want
table structured something like this:
ArrivalDate Hotel 1 Hotel 2
22/09 EUR 499,00 EUR 437,00
23/09 EUR 479,00 EUR 429,00
24/09 EUR 499,00 EUR 399,00
25/09 EUR 519,00 EUR 478,00
..the whole thing for 5-10 hotels, to get a good picture for m
project... The date ranges should be somehow inputtable without to muc
difficulty (another sheet with all the dates arrival dates would b
perfectly fine...).
Anyway, I hope to have expressed myself somehow clearly and I do hop
that somebody has the time to read my huge post here !!! Thanks i
advance for anybody who can help me with my project as I am reall
getting desparate!!!
Regards, Titus
have been trying for weeks to get this done and am failing because o
my lack of knowledge of VB. Here is what I intend to do...
For a student project, I want to analyze a set of given hotels an
their rates published. The Global Distrubion Systems (GDS) that contai
those published rates are used by several e-commerce websites t
display the rates to the online-customer. One of those sites is:
*http://www.available-rooms.com*
with the hotel search engine here:
http://res.available-rooms.com/nexres/search/power_search.cgi
When inserting the search options (arrival date, departure date, hote
name and location), the result is a page such as this:
<br /
<b>Warning</b>: mysql_pconnect(): Lost connection to MySQL serve
during query in <b>/home/sites/site15/web/db_connect.php</b> on lin
<b>3</b><br /
<br /
<b>Fatal error</b>: Call to undefined function: mysqlerror() i
<b>/home/sites/site15/web/db_connect.php</b> on line <b>3</b><br /
Notice that the URL carries ALL the information needed for the query:
- the hotel id number
- the arrival date
- the departure date
- number of guests
- the desired currency (in this case Euros)
In the search results, something like this appears:
WCT Call Center Discount Rates!
Total Rate: $749.39 USD
Rate Plan: WCT Call Center Discount Rate
Room Type: Deluxe Room with 2 Twins or 1 King Bed
$749.39 USD
(614.49 EUR)
Nightly Rate Book Now
The information I want to extract with the Excel web query is:
$749.39 USD
Deluxe Room with 2 Twins or 1 King Bed
=========================
This information should be queried for different date patterns though
so the URL should contain variables for the arrival and departur
dates, where the departure date is always arrival +2 days.
Example:
doa_dd=22&doa_mm=09
doa_dd=23&doa_mm=09
doa_dd=24&doa_mm=09
....
doa_dd=30&doa_mm=09
(DOA_DD = Date of Arrival_Day; DOA_MM = Date of Arrival_Month)
THERE IS a pretty good attempt already to be found here:
http://www.willowsolutions.com/tips/tips_2002_08.shtml
The problem is that with my lack of VB, I am not capable of modifyin
the code to my requirements...
In the long, long, long end of the process, I would ideally want
table structured something like this:
ArrivalDate Hotel 1 Hotel 2
22/09 EUR 499,00 EUR 437,00
23/09 EUR 479,00 EUR 429,00
24/09 EUR 499,00 EUR 399,00
25/09 EUR 519,00 EUR 478,00
..the whole thing for 5-10 hotels, to get a good picture for m
project... The date ranges should be somehow inputtable without to muc
difficulty (another sheet with all the dates arrival dates would b
perfectly fine...).
Anyway, I hope to have expressed myself somehow clearly and I do hop
that somebody has the time to read my huge post here !!! Thanks i
advance for anybody who can help me with my project as I am reall
getting desparate!!!
Regards, Titus