- see footer for list info -<
my guess would be its the connection layer that is holding table information and that closing and reopening the connection between CF and the database would clear this, but I may be wrong.
On 8/10/06, Simon Baynes <[EMAIL PROTECTED]> wrote:
>- see footer for list info -< Yes, ColdFusion does have a habit of caching things to do with database calls. For example if you run some SQl and then change the field type and run the SQL again it will start throwing some strange errors. On 8/9/06, Hooman Behnia <[EMAIL PROTECTED]> wrote: > >- see footer for list info -< > I think I have run into your error a few times as well. If I am correct, it > has nothing to do with your database or any new column that you are > creating, and more to do with a little known bug in CF7. > > Russ would be able to explain more about this, but in a nutshell, on some > very large tables, if you add a new column, you will need to restart CF > before using the db again, otherwise ColdFusion tries to use a copy of the > "old version" of the db (which does not have the newly created column) and > hence CF craps its pants. > > I first noticed this problem when long-standing queries started to cause > errors, ALL of them were of the "SELECT * FROM myTable" nature; none of the > queries where I specified the fields I want caused a problem. Took me ages > to work out that a simple CF restart would fix it! > > Anyways, I hope that sheds some light on it. I know it's not ideal to have > to restart CF every time you make a DB change, but it seems to be the only > way of being certain... > > Hooman > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Allan Cliff > Sent: 09 August 2006 15:32 > To: [email protected] > Subject: Re: [CF-Dev] Unsupported data conversion > > >- see footer for list info -< > > Yeah that worked for me too previously but now on shared > hosting so its not possible. > > Really weird. > > I suppose I'll wait a few days, see if the host reboots sometime and change > back the code to see if it runs ok. Not a very technical fix. > > ---------------------------------------- > > From: Jim <[EMAIL PROTECTED]> > Sent: 09 August 2006 09:53 > To: Coldfusion Development <[email protected]> > Subject: Re: [CF-Dev] Unsupported data conversion > > >- see footer for list info -< > I just got the exact same error, but for something different: > > AND > CategoryID = > cfsqltype="CF_SQL_NUMERIC" value="#call.categoryID#"> > > Restarted CF, problem went away. > > Allan Cliff wrote: > >> - see footer for list info -< > >> > > I am adding a column to an SQL table, > > when I press save the column saves and then my queries related to that > table go tits up. > > > > > > SELECT * > > FROM Requests > > WHERE email = > > > > > > The only fix is to remove the (not ideal) > > > > > > SELECT * > > FROM Requests > > WHERE email = '#Trim(attributes.email)#' > > > > > > Why would the adding of a "new" column cause existing fully working > queries to stop working and why "Unsupported data conversion" ?? > > > > Error Executing Database Query. [Macromedia][SQLServer JDBC > Driver]Unsupported data conversion. > > > > Anyone got any ideas or run into anything similar? > > > > Using CFMX 7, SQL 2000 on a Windows box. > > > > Allan > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > > >> - Hosting provided by www.cfmxhosting.co.uk -< > >> - Forum provided by www.fusetalk.com -< > >> - DHTML Menus provided by www.APYCOM.com -< > >> - Lists hosted by www.Gradwell.com -< > >> - CFdeveloper is run by Russ Michaels, feel free to volunteer your help > -< > >> > > > > > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > -- Simon Baynes www.simonbaynes.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
-- Mike T Blog http://www.socialpoints.com/ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -< - Forum provided by www.fusetalk.com -< - DHTML Menus provided by www.APYCOM.com -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
