Yes, we scope about 99% of all our variables ... I should clarify, that time was of the essense and by changing the name the scalar error went away . at that point in time that is all that was needed. We didn't go deep into why or why not it worked.
Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Rob Rohan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 12:35 PM Subject: RE: Client Variables > Did you have the problem even when the variables were scoped? > > IE query.blag > session.blarg? > > -----Original Message----- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 03, 2002 10:25 AM > To: CF-Talk > Subject: Re: Client Variables > > > It seems that CFMX has us tighting up our code. We had an issue where a db > column conflicted with a session structure setting, we had to rename the > structure (or the table column name). There are other things, but we found > that it was usually something sloppy on our end ... I am not sure if they > meant for it to be that way, but all the errors we found could have been > done a better way so we changed things. > > Paul Giesenhagen > QuillDesign > > ----- Original Message ----- > From: "Rob Rohan" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, October 03, 2002 12:19 PM > Subject: Client Variables > > > > Is anyone experiencing odd database issues with MX? We are migrating to > MX, > > have MS SQL 7 database, and are experiencing things such as: > > > > * client variables not being saved - cfide:token are but the data is not > > * some select statements that used to work in 5 are now returning 0 > records > > in MX, but when run in query analyzer return records (so it's good SQL) > > > > Seems odd that everything worked fine on 5 now lots of stuff is bombing on > > MX. We are thinking it might be a JDBC-ODBC problem... > > > > Anyway, is anyone having strange database happenings with MS SQL 7? > > > > Cheers, > > Rob > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

