I'm not 100% sure about this information, but it'll give you a place to
start.
Content schedules are saved in the container's objectdata. If you know the
id of the container containing the scheduled content you should be able to
query for that container's objectdata directly and find it from there. No
spectra tags, just straight sql statement
If you want to find the schedule based only on the content, then you've got
a different problem. I happen to be running SQL 2000 (as opposed to
oracle). When I needed to find which containers a particular content object
was published in I did a LIKE search on the objectdata of all containers,
filtering out for particular display methods where necessary with additional
LIKE conditions. Doing the like search allowed me to look inside the
serialized WDDX packet of the container's objectdata. since containers are
system objects and we can't change them, making things searchable or the
like, I found this to be the only way for me.
|-----Original Message-----
|From: Nick Lansbury [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, July 25, 2001 10:53 AM
|To: Spectra-Talk
|Subject: Getting schedule information...
|
|
|I have a container with content scheduled between two dates
|(e.g. July 25 to
|August 1st). On another page on my site I want to show the
|'end date' (i.e.
|August 1st in this example) of this scheduled content.
|Ultimately I want to
|display the 'end date' of the last 'n' scheduled entries for
|this container.
|
|Can anyone tell me where I can programatically get this info from?
|
|
|
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
