Re: varchars as foreign keys in Cake leads to conversion to Int Error - using MS SQL

I had a look at the code yesterday, and I couldn't see anything obvious that would result in [Dy].[GLID] = (1) when it should have been [Dy].[GLID] = 'G12345'.  Mind you, I haven't looked at the scaffold code to see what assumptions it might make around primary keys and foreign keys.

Even though item.GLID is not a primary key, if it is a foreign key, it is probably a primary key somewhere else.  It might be helpful to see the create table statements for the could of tables in question, since we don't have models to look at, even if they're cut down to primary key, foreign keys and perhaps a display field.  It also might be helpful to say when function is erroring.  Is it just the index of one of the pages, or is it the view, add or edit?

If I had this issue on my local system, I would be getting very interested in why [Dy].[GLID] is getting assigned (1).  To work this out better, I would be using XDebug (or CakeLog::debug(print_r(<>, true));) to step through the code to work out why that assignment is happening.

On Friday, 16 November 2012 07:49:36 UTC+10, Tomas wrote:

changing foreign keys to nvarchar did not help.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.