What is the "appropriate" type attribute for a Object Types "property" "catMyType"?
They seem to be inconsistent... I think my core types have been left alone but here's an example. dmNews: (longchar) <cfproperty ftseq="4" ftfieldset="Categorisation" ftwizardStep="General Details" name="catNews" type="longchar" dmInclude: (string) <cfproperty ftSeq="20" ftFieldset="Categorisation" name="catInclude" type="string" In the MSSQL2005 DB, longchar seems to = ntext, string seems to = varchar(255). varchar(255) would allow me to check off about 7 categories, ntext... would permit many more, so that makes sense, but I seem to be having a problem with SQL where clauses and ntext, so fitler categories on somne rules is not working properly. It also appears that some of these datatypes are deprecated in mssql2008. http://msdn.microsoft.com/en-us/library/ms143729.aspx It seems to me that the CatMyType properties for "type" should be longchar which should translate (for MSSQL) to varchar(max)???? --~--~---------~--~----~------------~-------~--~----~ You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry -~----------~----~----~----~------~----~------~--~---
