For future proofing, I would agree with Chris that the proper attribute would be "longchar"
On Mon, Oct 5, 2009 at 1:54 PM, Chris Roth <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
