/wsr/ - Worksafe Requests » Thread #1530273

[4 / 1 / 1]

328KiB, 2048x1371, c6fabb21e6dde57e432babc25dd137ec.jpg

Anonymous Mon 16 Jun 2025 05:06:49 No.1530273 View View Reply Original Report

Quoted By:

Trying to recreate the serverside part of a Flash game that runs on ColdFusion.

One thing that's making me stuck is that some functions are supposed to return an object that contains a recordset (results from a query) that contains *another* recordset, and I'm stumped on how to properly do that. Can someone give me a "for retards" guide? I got recordsets in objects down, but not recordsets in recordsets

My local environment using PostgreSQL with ColdFusion 2018, if that matters

Anonymous

Anonymous Tue 17 Jun 2025 02:16:12 No.1530381 Report

Quoted By:

Well I decided to try *something*

[code:lit]
<cfquery name="getMissionData" datasource="HistoryDB">
SELECT *
FROM "Missions"
WHERE "MissionID" = #arguments.missionId#
</cfquery>

<cfquery name="getClues" datasource="HistoryDB">
SELECT c.*
FROM "Clues" c
INNER JOIN "Mission_Clues" mc ON c."ClueID" = mc."ClueID"
WHERE mc."MissionID" = #arguments.missionId#
</cfquery>

<cfloop query="getClues">
<cfquery name="getOptions" datasource="HistoryDB">
SELECT o."optionID", o."optionValues"
FROM "ClueOptions" o
INNER JOIN "Clues_Options" co ON o."optionID" = co."optionID"
WHERE co."ClueID" = #ClueID#
</cfquery>

<cfloop query="getOptions">
<cfquery name="getValues" datasource="HistoryDB">
SELECT v."copy", v."valueDefinition"
FROM "ClueOptions" v
WHERE v."optionID" = #optionID#
</cfquery>

<cfset getOptions.optionValues = getValues>
</cfloop>

<cfif getOptions.recordCount GT 0>
<cfset getClues.ClueOptions = getOptions>
</cfif>
</cfloop>
[/code:lit]

It *works*, but is it REALLY best practice here?

Anonymous

Anonymous Tue 17 Jun 2025 05:26:54 No.1530400 Report

Quoted By: >>1530401

Scratch that, I discovered a big flaw: clues get multiple times, in fact, as many times as there are optionValues.

Maybe INNER JOIN isn't the answer?

Anonymous

Anonymous Tue 17 Jun 2025 05:40:33 No.1530401 Report

Quoted By:

>>1530400
Actually, I misspoke. It's duplicate optionIDs that get added whenever they have multiple value definitions associated with them

Capcode	All Only User Posts Only Verified Posts Only Moderator Posts Only Manager Posts Only Admin Posts Only Developer Posts Only Founder Posts
Show Posts	All Only With Images Only Without Images Only Spoiler Images Only Non-Spoiler Images
Deleted Posts	All Only Deleted Posts Only Non-Deleted Posts
Ghost Posts	All Only Ghost Posts Only Non-Ghost Posts
Post Type	All Only Sticky Threads Only Opening Posts Only Reply Posts
Results	All Grouped By Threads
Order	Latest Posts First Oldest Posts First

On these archives

Your latest searches