<cfcomponent displayname="Category References" hint="Category-Object associations" extends="schema" output="false"> <cfproperty name="objectid" type="uuid" dbNullable="false" dbPrimaryKey="true" /> <cfproperty name="categoryid" type="uuid" dbNullable="false" dbPrimaryKey="true" /> </cfcomponent>
looking at refCategories.cfc... Is is legit to have 2 primary keys in a table? On Monday, April 1, 2013 4:37:57 PM UTC-7, Blair McK wrote: > > Can you try "mssql2005" as the dbtype? I don't remember what the > differences where that required a separate db gateway, but this issue may > be related. > > Blair > > > On Tue, Apr 2, 2013 at 8:39 AM, Might Aswell <[email protected]<javascript:> > > wrote: > >> MSSQL 2005 - Collation: SQL_Latin1_General_CP1_CI_AS >> >> >> >> On Tuesday, March 26, 2013 5:26:20 PM UTC-7, Jason Barnes wrote: >> >>> Can you paste the db collation >>> >>> On 27 March 2013 11:21, Might Aswell <[email protected]> wrote: >>> >>>> I'm using MSSQL2K5 I dont believe any case sensitive settings have >>>> been set.. >>>> >>>> >>>> On Tuesday, March 26, 2013 4:17:47 PM UTC-7, Blair McK wrote: >>>> >>>>> Jason gave me poke to take a look at the dumps. The second dump you >>>>> sent (tablemetadata) is the struct that FarCry compares with the DB as it >>>>> is. You've mentioned refCategories, nested_tree_objects, and dmHTML - all >>>>> three have an "objectid" property in their array of fields, and FarCry >>>>> should only suggest dropping a field if it ISN'T in that struct and IS in >>>>> the database. I think we can firmly rule out memory corruption / >>>>> ColdFusion >>>>> weirdness. >>>>> >>>>> What DB are you using? Is it possible you have case-sensitivity >>>>> enabled? - that has caused problems for us in past. >>>>> >>>>> Blair >>>>> >>>>> >>>>> On Wed, Mar 27, 2013 at 6:43 AM, Might Aswell <[email protected]>wrote: >>>>> >>>>>> Any thoughts? >>>>>> >>>>>> >>>>>> On Wednesday, March 20, 2013 10:53:13 PM UTC-7, Jason Barnes wrote: >>>>>> >>>>>>> Not sure if my previous post worked but cfdump the following two >>>>>>> scopes for debugging and attach as txt files to this thread: >>>>>>> >>>>>>> application.fc.lib.db.**tablemet****adata >>>>>>> >>>>>>> application.stCoapi["dmHTML"] >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Thursday, March 21, 2013 3:50:51 AM UTC+11, Might Aswell wrote: >>>>>>>> >>>>>>>> Hi all.. just a quick ? for anyone that might know... just upgraded >>>>>>>> from 6-0-15 to 6.2.7 and see a lot of schema changes.. I notice >>>>>>>> objectid is >>>>>>>> to be dropped in many tables.. should I be worried about this.. seems >>>>>>>> like >>>>>>>> I use objectID in a lot of places... >>>>>>>> >>>>>>> -- >>>>>> You received this message cos you are subscribed to "farcry-dev" >>>>>> Google group. >>>>>> To post, email: [email protected] >>>>>> To unsubscribe, email: farcry-dev+...@**googlegroups.**com >>>>>> >>>>>> For more options: >>>>>> http://groups.google.com/**group**/farcry-dev<http://groups.google.com/group/farcry-dev> >>>>>> ------------------------------****-- >>>>>> Follow us on Twitter: http://twitter.com/farcry >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "farcry-dev" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to farcry-dev+...@**googlegroups.**com. >>>>>> >>>>>> For more options, visit >>>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>>> . >>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>> You received this message cos you are subscribed to "farcry-dev" Google >>>> group. >>>> To post, email: [email protected] >>>> To unsubscribe, email: farcry-dev+...@**googlegroups.com >>>> For more options: >>>> http://groups.google.com/**group/farcry-dev<http://groups.google.com/group/farcry-dev> >>>> ------------------------------**-- >>>> Follow us on Twitter: http://twitter.com/farcry >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "farcry-dev" group. >>>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>>> topic/farcry-dev/fAT9Z3jy-LE/**unsubscribe?hl=en-GB<https://groups.google.com/d/topic/farcry-dev/fAT9Z3jy-LE/unsubscribe?hl=en-GB> >>>> . >>>> To unsubscribe from this group and all of its topics, send an email to >>>> farcry-dev+...@**googlegroups.com. >>>> >>>> For more options, visit >>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>>> . >>>> >>>> >>>> >>> >>> >>> >>> -- >>> Jason Barnes | CTO | Daemon | p. 02 8999 8885 | http://www.daemon.com.au >>> >> -- >> You received this message cos you are subscribed to "farcry-dev" Google >> group. >> To post, email: [email protected] <javascript:> >> To unsubscribe, email: [email protected] <javascript:> >> For more options: http://groups.google.com/group/farcry-dev >> -------------------------------- >> Follow us on Twitter: http://twitter.com/farcry >> --- >> You received this message because you are subscribed to the Google Groups >> "farcry-dev" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- 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 --- You received this message because you are subscribed to the Google Groups "farcry-dev" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
