Ok, I found the issue and it's more than likely a bug. But I'm not sure if it's a bug with FB4 or CF9 though...
The issue is that in my MySQL tables the foreign keys are of type BIGINT. Any/every database field with BIGINT assigned to it will be discovered by FB4 as type STRING. To get around this, I went into my database and changed the field types from BIGINT to INT (which is ok right now because I'm just in development). I then went into the service and re-configured the return type and selected the auto-detect. It then showed the correct type and I then selected the original datatype which just updates the current object with the new information. After I did that, I went back into the DB and reset the fields to BIGINT and everything seems to be staying; at least until I need to update that object or service call again. Then I assume I'm going to go through all of this once again. Anyway... A bug. Anyone have any thoughts on who could be the culprit? sj ________________________________ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Scott Sent: Sunday, June 13, 2010 1:05 PM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] FB4 CF data wizard bugs? Ok, this is a much bigger issue than I thought it would be this time. The autogenerated objects regenerate with the wrong variable types. I don't know of a work around either... When it generates the objects it shows the wrong variable type but it won't let me set it. If I have a coldfusion object with type object as the parameter, then assign FB4 to that CF object, it runs a query against it to see what the variables are in that object. There's something very wrong with the variable detection on larger objects (~15 fields). If I try to run a refresh on the dataservice call it still does not detect the object correctly. If I go into the object's .as file I see that it's wrong, if I modify the file to the correct type it regenerates with the wrong data. Where is it pulling this from? Is it re-running the query? Also, if right click on the dataservice call in FB4 there's an option for "configure input type". If I select this it just shows my bad object; not the object contents. Is there a quick way around this issue? Thanks. sj ________________________________ From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of Scott Sent: Sunday, June 13, 2010 10:37 AM To: flexcoders@yahoogroups.com Subject: [flexcoders] FB4 CF data wizard bugs? I've been using the FB4 data wizards to make the initial connections to my CF functions then modify them to do exactly what I want them to. (saves a heck of a lot of time!) I've been noticing that frequently the data wizard detects my DB fields wrong. My private keys for instance are almost always numbers and FB4 thinks they are strings. This is also true for the form generation. Is anyone else running into this? sj -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner <http://www.mailscanner.info/> , and is believed to be clean.