Has this been fixed now?
Tarjei
----- Original Message -----
From: "David Guerizec" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 12:11 PM
Subject: Re: [midgard-user] calanderfunction date format.
> > What is the dateformat to be used in this midgard function ?
> >
> > object mgd_list_topic_calendar_all(int topic, int start, int stop,
string
> [sort], int [type]);
> >
> > I've tried timestamp and mm-dd-year, but I cannot figure it out. Any
tips?
>
> It seems, from the source that it's timestamps:
>
> convert_to_long_ex(startn);
> convert_to_long_ex(stopn);
> ...
> startv = (*startn)->value.lval;
> stopv = ((*stopn)->value.lval > 0) ? (*stopn)->value.lval :
> DATE_MAX;
>
> but it seems also there is something wrong with the SQL query:
>
> php_midgard_select(&MidgardArticle, return_value,
> ARTICLE_SELECT "," ARTICLE_CALENDAR, ARTICLE_FROM,
> "article.topic IN $D AND author=person.id"
> " AND article.up=0 AND Unix_Timestamp(calstart)<$d"
> " AND 24*60*60-1+Unix_timestamp("
> " Date_Add(calstart, INTERVAL caldays DAY))>$d",
> sortv, topics, stopv, startv);
>
> ie. the startv and stopv seem not to be in the right order, and the < and
>
> signs look reversed too...
>
> Unfortunatly, I'm pretty busy these days at my new job, and I won't have
> time to do any development during an unkown period, so if someone could
look
> deeper into it...
>
> > Tarjei
>
> David
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
