Skip to main content
DReevesy
DReevesy
Participant
December 1, 2016
Frage

cfquery of query not working in CF2016

  • December 1, 2016
  • 1 Antwort
  • 618 Ansichten

I have a query which has run well on our old server. However we've upgraded to CF2016 and yet when I run a query of a query I get no results.

<cfquery datasource="travcomus" name="firstquery">

  SELECT * FROM tablename

</cfquery>

Followed by

<cfquery dbtype="Query" name="secondquery" >

  select * from firstquery

</cfquery>

Any ideas?

Dieses Thema wurde für Antworten geschlossen.

1 Antwort

WolfShade
WolfShade
Legend
December 1, 2016

Do you get absolutely nothing in return?  Or an error message?  Have the CFAdmin logs provided anything?

If you do a CFDUMP of both queries, does the second one show as empty?  Or that it doesn't exist?

I'm not at all familiar with CF2016, so I have to ask.

V/r,

^_^

DReevesy
DReevesyAutor
Participant
December 1, 2016

It shows as empty and the CFAdmin logs aren't returning anything useful

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
December 2, 2016

My problem is it works on our dev server. I am sure it's buried somewhere in the admin settings, just for the life of me I can't find it. Can't find any notes stating that the exact functionality is depreciated so it's not that. Thanks anyway


Try this (pun ):

<cftry>

<cfquery datasource="travcomus" name="firstquery">

  SELECT * FROM tablename

</cfquery>

<cfquery dbtype="Query" name="secondquery" >

  select * from firstquery

</cfquery>

<cfdump var="#firstquery#" label="firstquery">

<cfdump var="#secondquery#" label="secondquery">

<cfcatch type="any">

<cfdump var="#cfcatch#">

</cfcatch>

</cftry>

Allgemeine NutzungsbedingungenAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices