[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?
(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.
QUERY: SELECT VALARM.TRIGGER FROM VEVENT
org:INET-Consulting LLC <http://INET-Consulting.com>
title:Chief Executive Manager