Its probably a bit late to mention, but a view can return columns with the wrong names if you alter the table that the view is based on. An MSSQL view only records the positions of the columns in the table, not the names. Therefore any re-ordering of the columns in your table may cause the view to "mix up" columns. Recreating the view fixes the problem, as the new view is based on the new table definitions.
David JAAV wrote: > I have more data for this problem, maybe it can give more clues : > > I've dropped and re-created a view related to the problem page and the > problem seems to be fixed up in this part ;( > > this is annoying!! Don't you think? > > Another possible clue is what the DB Server are more busy than usual... but > I don't think this can be related > > Juan > > ----- Original Message ----- > From: "Robert Berndt" <[EMAIL PROTECTED]> > To: "SQL" <[EMAIL PROTECTED]> > Sent: Monday, July 01, 2002 8:23 PM > Subject: RE: Weird error in SQL Server + CF > > > Is it displaying unicode? > > > > -----Original Message----- > > From: JAAV [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 01, 2002 12:12 PM > > To: SQL > > Subject: Weird error in SQL Server + CF > > > > > > Hello all, > > > > Well, I'm having a weird behavior with SQL Server + CF server : Suddenly, > > my generated web pages are displaying a numbers instead a varchar fields. > I > > don't have neither CF error nor Database... And I didn't make any change > at > > the code... > > > > Any ideas? > > > > Thanks in advance, > > > > Juan > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
