Display a date datatype

Author Message

Roberta Gatti

Friday 05 March 2004 1:49:13 am

hi,
I create a new class with the date field (yyy/mm/dd)... when I use a fetch function to display the data {$:item.data1} I can't see the date field and appear an error "Object(ezcontentobjectattribute)"

What is the problem?

TIA
R.

Trond Åge Kvalø

Friday 05 March 2004 2:33:27 am

Hello Roberta!

Maybe some of the info in this thread might help?

http://www.ez.no/community/forum/setup_design/date_format

best regards
trondåge

trondåge

Roberta Gatti

Friday 05 March 2004 3:03:44 am

Hi,
I read this topic but this is my code:

{let children=fetch('content','list',hash(parent_node_id,72))
sub_children_count=fetch(content,list_count,hash(parent_node_id,72))}

{section name=Child loop=$:children max=2}
<tr valign="top">
<td>{$:item.data1.content}</td>
<td colspan="2"><a href={concat('content/view/full/',$:item.node_id)|ezurl}>{$:item.data_map.title.content}<br/></a></td>
</tr>
{/section}
{/let}

<td>{$:item.data_map.data1.content}</td> don't appear

I try to use <td>{$:item.data_map.data1.content}</td>

The error now is "Object(ezdate)"

Why?

TIA
R.

Trond Åge Kvalø

Friday 05 March 2004 3:15:41 am

Hi Roberta!

Try this code:

<td>{$:item.data_map.data1.data_int|datetime(custom,"%Y/%m/%d")}</td>

Hope this helps
trondåge

trondåge

Roberta Gatti

Friday 05 March 2004 3:31:43 am

now the date appears

Thank you !!!!

R.

Trond Åge Kvalø

Friday 05 March 2004 4:04:04 am

Excellent!

Now if you want to use other formats on your date you can use the codes found in this page:

http://www.ez.no/ez_publish/documentation/customization/tips_tricks/date_and_time_formats

Let's say that you for instance want to show your date as Friday 5. March 2004 then you'd use the following code:

<td>{$:item.data_map.data1.data_int|datetime(custom,"%l %j. %F %Y")}</td>

best regards
trondåge

trondåge

Roberta Gatti

Friday 05 March 2004 7:49:39 am

Ok,
but now I have another problem .... using fetch function I want to order the results by date field (data1)

{let children=fetch('content','list',hash(parent_node_id,72,
sort_by, data1 )) }

but it daesn't work, why?
TIA
R.

Trond Åge Kvalø

Sunday 07 March 2004 1:31:26 pm

The sort_by parameter should be an array.

Try this:

{let children=fetch('content','list',hash(parent_node_id,72,
sort_by, array('data1', false())))}

And hopefully your data should be sorted with the most recent element at the top.

hth
trondåge

trondåge

Roberta Gatti

Monday 08 March 2004 7:16:51 am

Hi,
unfortunately your code produces a blank line. I don't find a right code.

:-((

R.

Alex Jones

Monday 08 March 2004 7:29:33 am

Try

{let children=fetch('content','list',hash(parent_node_id,72,
                                          sort_by,array(array('attribute',false(),'data1'))))}

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Roberta Gatti

Monday 08 March 2004 7:32:04 am

Don't work.

Bruce Morrison

Monday 08 March 2004 3:26:00 pm

Hi Roberta

See http://ez.no/ez_publish/documentation/reference/data_fetching/content/list

Also turn on debugging. This will give some error messages that will either lead you the the answer or help people in the list solve the issue.

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Trond Åge Kvalø

Tuesday 09 March 2004 12:15:01 am

Hi Roberta!

I'm new at this as well, and my earlier post was not entirely correct. According to the link:

http://ez.no/ez_publish/documentation/reference/data_fetching/content/list

I believe this would do it though

{let children=fetch('content','list',hash(parent_node_id,72,
                                          sort_by,array('attribute',false(),'data1')))}

If that doesn't work, you should turn on debugging and see if there are any error messages.

hth
trondåge

trondåge

Roberta Gatti

Tuesday 09 March 2004 7:52:56 am

It doesn't work .... how can I turn on debugging to try error?

R.

Trond Åge Kvalø

Tuesday 09 March 2004 9:27:15 am

In your site.ini.append file, insert the following lines:

[DebugSettings]
DebugOutput=enabled

This will show the debug output beneath your page

best regards
trondåge

trondåge

Roberta Gatti

Wednesday 10 March 2004 2:13:40 am

An error appears, but I don't know what it means:

Error: eZMySQLDB Mar 10 2004 11:11:06
Query error: You have an error in your SQL syntax near 'AND
a0.version = ezcontentobject_name.conten' at line 18. Query: SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name

, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
, ezcontentobject_attribute as a0


WHERE
path_string like '/1/2/72/%' and depth <= 3 and


a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = AND
a0.version = ezcontentobject_name.content_version AND
a0.language_code = ezcontentobject_name.real_translation AND

ezcontentclass.version=0 AND
node_id != 72 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND

ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'ita-IT'

ORDER BY a0.sort_key_int DESC
Notice: eZMySQLDB::query(0.000 ms) query number per page:0 Mar 10 2004 11:11:06
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name

, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
, ezcontentobject_attribute as a0


WHERE
path_string like '/1/2/72/%' and depth <= 3 and


a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = AND
a0.version = ezcontentobject_name.content_version AND
a0.language_code = ezcontentobject_name.real_translation AND

ezcontentclass.version=0 AND
node_id != 72 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND

ezcontentobject_tree.contentobject_is_published = 1
and ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
ezcontentobject_name.content_translation = 'ita-IT'

ORDER BY a0.sort_key_int DESC

Trond Åge Kvalø

Thursday 11 March 2004 1:57:51 am

The error appears because the line

a0.contentclassattribute_id = AND

is missing a contentclassattribute_id after the equals character

And the reason for this is that the attribute 'data1' in

{let children=fetch('content','list',hash(parent_node_id,72,
                                          sort_by,array('attribute',false(),'data1')))}

doesn't return the contentclassattribute_id. What you should try to do is to find the contentobjectatribute_id of 'data1' manually, and insert that instead of 'data1' in the sort_by expression.

You'll find the contentobjectattribute_id by editing your class. In the attributes list the attributes are listed by number, name, datatype and id. The id is the needed contentobjectattribute_id.

Try this an see if that helps.

best regards
trondåge

trondåge

Roberta Gatti

Friday 12 March 2004 12:37:26 am

Hi,
thank you very much for your precious help!!

Roberta
;-))))

Trond Åge Kvalø

Friday 12 March 2004 1:54:34 am

> ;-))))

I presume this means that it worked? :-)

trondåge

trondåge

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.