[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: CAL-QUERY value type - clearing up '.'



Bernard Desruisseaux wrote:

> >
> >   (5) The '.' means <table>.<column> when needed for contained
> >       properties or their associated contained components.
> >       As long as all were contained (as defined by iCalendar or CAP)
> >       in the SINGLE component type named in the FROM clause OR
> >       its contained component.
> 
> This paragraph will be hard to understand for the
> first time readers.  Perhaps we could rephrase it?

Yes.

How about:

	(5) The '.' is used to separate the table name (component)
            and column name (property) when selecting a property that
            is contained inside of a component that is targeted in
            the TARGET property.

	    In this example the '.' is used to separate the
            TRIGGER property from its contained component (VALARM)
	    which is contained in any VEVENT in the selected TARGET
            (relcalid). All TRIGGER values in any VEVENT in relcalid
            would be returned.

		TARGET:relcalid
		QUERY: SELECT VALARM.TRIGGER FROM VEVENT
begin:vcard 
n:Royer;Doug
tel;pager:pager@xxxxxxxxx
tel;cell:208-520-4044
tel;fax:866-594-8574
tel;work:866-594-8574
x-mozilla-html:FALSE
url:http://Royer.com/People/Doug
org:INET-Consulting LLC <http://INET-Consulting.com>
adr:;;;;;;
version:2.1
email;internet:Doug@xxxxxxxxx
title:Chief Executive Manager
x-mozilla-cpt:;-8832
fn:Doug Royer
end:vcard