fixed now.. you were right Simon, for some reason the data had disappeared :)
----- Original Message ----- From: "Simon Horwith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 06, 2003 12:56 AM Subject: RE: [ cf-dev ] Query not producing any output > looks fine... are you sure that there is data in the DB that the CF 5 > environment is using? > > ~Simon > > Simon Horwith > CTO, Etrilogy Ltd. > Member of Team Macromedia > Macromedia Certified Instructor > Certified Advanced ColdFusion MX Developer > Certified Flash MX Developer > CFDJList - List Administrator > http://www.how2cf.com/ > > > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED] > Sent: 06 November 2003 00:16 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Query not producing any output > > > Hey all, in a bit of a rush. I've got this query that works fine on MX, but > not on a server that's 5. However, it does not throw an error, just gives no > data... can anyone see anything wrong with it? > > <cfquery name="getThreads" datasource="#request.dsn#"> > SELECT > threadID,threadTitle,threadDescription,messageCount,lastEdited,dateCreated,m > embers.memberID,firstname,lastname,showEmail > FROM contentThreads,members > WHERE > contentThreads.topicID = #attributes.topicID# AND > contentThreads.memberID = members.memberID > </cfquery> > > > Cheers > d > > > ----- Original Message ----- > From: "Jolly Green Giant" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, November 05, 2003 3:51 PM > Subject: Re: [ cf-dev ] Request scope > > > > One of the best pieces of advice I can give you is to put related stuff in > > a structure if it's going to becopied back and forth much. Then you can > > just duplicate the structure from the session to request (using just one > > line of code), rather than several cfset statements. > > > > __________/ Matt Horn \__________ > > >Hi > > > > > > for as long as I have been writing Cold fusion code I have done this: > > ><cflock scope="session" timeout="10"> > > > <cfset request.userId= session.userId> > > > <cfset request.productionhouseId = session.productionhouseId> > > ></cflock> > > >but everything works fine without the request scope > > > > > ><cflock scope="session" timeout="10"> > > > <cfset userId= session.userId> > > > <cfset productionhouseId = session.productionhouseId> > > ></cflock> > > > > > > > > >so my question is this > > > > > > Am I correct in setting session variables down to Request scope > > > > > >or will the other way work just as well? > > >and if so .. why even have a request scope? > > > > > >Matt *Newbie > > > > > > > > > > > >|\--------------------/| > > >Matt Horn > > >Web Applications Developer > > >Ph:+2782 424 3751 > > >W: http://www.matt-horn.org > > >E:[EMAIL PROTECTED] > > >|\--------------------/| > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
