Skip to content

SiteKickr Web Development

search
search
Combining multiple SQL queries for listing pages into one
Sep16September 16, 2014SQL / Database

Combining multiple SQL queries for listing pages into one

With a little extra effort, you can construct a single query that returns multiple rows using the SQL IN operator.
From there, you can convert the query results into a language construct that is easy to work with.

Jun10June 10, 2011Algorithms, ColdFusion

ColdFusion SQL Bulk Insert based on structure keys

I realize this particular requirement might be rare, but it comes in handy when you have an XREF (cross-reference) table which ties two tables together.…

© 2023 SiteKickr