versioned types

[AJ Mercer]

Should a type that has a 'Status' field also have a 'versionID' field?

I am trying to view a dmInclude (verity plugin search results) which is still in draft and I am getting the following error

    Unknown column 'versionID' in 'where clause'

    

I have tracked it back and it looks like if the type has a 'Status' field it calls versioning.checkIsDraft()

which runs the follwoing SQl

    SELECT objectID,status from #application.dbowner##arguments.type# where versionID = '#arguments.objectID#' 

    

-- 

AJ Mercer

Web Log: http://webonix.net

Once you come to the realisation that everyone is crazy,

You will never be surprised or disappointed ever again.

AJM 2008

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-beta" group.
To post to this group, send email to farcry-beta@...
To unsubscribe from this group, send email to farcry-beta+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-beta?hl=en
-~----------~----~----~----~------~----~------~--~---

[Blair McKenzie-2]

A versioned object should have a status property, but not necessarily
the other way around. Can you report this as a bug?

Blair

On 9/15/08, AJ Mercer <ajmercer@...> wrote:

> Should a type that has a 'Status' field also have a 'versionID' field?
>
> I am trying to view a dmInclude (verity plugin search results) which is
> still in draft and I am getting the following error
>     Unknown column 'versionID' in 'where clause'
>
> I have tracked it back and it looks like if the type has a 'Status' field it
> calls versioning.checkIsDraft()
> which runs the follwoing SQl
>     SELECT objectID,status from #application.dbowner##arguments.type# where
> versionID = '#arguments.objectID#'
>
>
> --
> AJ Mercer
> Web Log: http://webonix.net
>
>
> Once you come to the realisation that everyone is crazy,
> You will never be surprised or disappointed ever again.
> AJM 2008
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-beta" group.
To post to this group, send email to farcry-beta@...
To unsubscribe from this group, send email to farcry-beta+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-beta?hl=en
-~----------~----~----~----~------~----~------~--~---