Forum OpenACS Q&A: Re: date formats in bboard package

Collapse
2: Re: date formats in bboard package (response to 1)
Posted by Cathy Sarisky on 06/12/03 05:23 AM
Are you making the change in the sql text in message.tcl itself, or in message-postgresql.xql?  If not in message-postgresql.xql, check there to see if the code that's actually being used is hiding THERE instead of in message.tcl.  (Most db-specific code is in an .xql file, not in the .tcl file.)

Hope that helps.

Collapse
3: Re: date formats in bboard package (response to 2)
Posted by Jose Carrion on 06/12/03 05:52 AM
It certainly sounded like a promising suggestion. After making the same change in message-postgresql.xql I'm still getting "June 11, 2003 11:46 pm", though. Rrrr...

Thanks for the info about database code location, though. I had overlooked this completely.

Collapse
4: Re: date formats in bboard package (response to 3)
Posted by Tilmann Singer on 06/12/03 07:14 AM
You also need to go to the apm (/acs-admin/apm/) and watch that file to make the change become effective without server restart.

I just wanted to refer you to the docs here: https://openacs.org/doc/openacs-4-6-3/db-api.html - but it seems they don't contain anything about xql files, oops. Anybody knows if/where this stuff is documented? Maybe someone could at least add a comment at the bottom of that doc.