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]
