It's one primary key made up of two properties which is valid. Sent from my iPhone
On 03/04/2013, at 6:16 AM, Might Aswell <[email protected]> wrote: > > <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]> 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.tablemetadata >>>>>>>> >>>>>>>> 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: [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. >>>>> >>>>> -- >>>>> 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 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. >>>>> To unsubscribe from this group and all of its topics, send an email to >>>>> [email protected]. >>>>> >>>>> For more options, visit 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] >>> 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. > -- > 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 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. > To unsubscribe from this group and all of its topics, send an email to > [email protected]. > 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.
