XML Schema Complete Reference, The

28.6. Template Query

We looked at template queries in Chapter 27 in detail. In this chapter all you need to use is the template query, shown in Listing 28.10, to retrieve all reservations for a specific resource between two date ranges. The template query for looking up your resource calendar is in Listing 28.10.

Listing 28.10. XML Template Query

<viewReservations xmlns:sql='urn:schemas-microsoft-com:xml-sql'> <sql:header> <sql:param name='pBldg'>Linden Hall</sql:param> <sql:param name='pSDate'>05-01-2001</sql:param> <sql:param name='pEndDate'>06-01-2003</sql:param> </sql:header> <sql:query > SELECT building.name AS Building, room.roomName AS Room, room.roomNumber AS [Room Number], reservation.start_date AS Date,reservation.start_time AS Time, ...