Hi all, I have had a horrible time with <cfinsert> on cf5 linux and mysql. I know that a lot of people say to stay awayfrom it but I have almost got it to work. It seems to have something to do with the version of mysql and text vs blobfields.
Under mysql-3.23.29a cfinsert would fail saying "SQL operation updated no rows" on text and blob fields. Onlyinserting 10 char on text fields and inserting everything on blob fields. Again both reporting errors. Under mysql-3.23.49 and 3.23.41 cfinsert will insert with no error into fields both text and blob. On text fields it will only insert10 chars. Also the rds description of the database says that the text field is a char(10) When I have verified that the field is text. The rds description of of blob is correct and it seems to insert fine. I have down loaded the cfodbc45.soand installed it it does not seem to make a difference either way. I have also enabled and disabled the retrieval of long text in the odbc setup and it makes no difference. I recently moved from soloris to linux. <cfinsert> worked fine under solaris and I have a lot of code in production using cfinsert. I also have converted all of the fields in my data base from text to there equivelent in blob. Does anyone know what the deal is with the diffrent mysql versions? I am new to all of this stuff and from what I can tellblob and text are almost the same except that blob has a case sensitive comparison. My developers were using textfields in there databases and for now I have told them to use blob mainly because it works. I also really don't want totell them that they cant use cfinsert anymore. It seems to me that it would not be that hard just to write out the sqlbut as an administrator I want to make my users happy rather than pissed off. /following statement could be just plain ignorance and frustration. I also think that if Macromedia is going to release cf for linux cfinsert should work on it with mysql be it a text field or a blob. /end ignorance and frustration Am I going to be shooting myself in the foot down the road for going with what works (i.e The newer version of mysql and using blob for large text fields.) Any comments or suggestions are greatly appreciated. -devin- ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
