Ask a Question related to Coldfusion Database Access, Design and Development.
-
alexford #1
Joins or subqueries
Lately I have been using a lot of subqueries to get at information from
different tables in my databases. I do this by cfincluding a cfm within the
cfoutput query of the primary query. I'm wondering if I should be using joins
instead. Does it matter?
Lately our server performance has been greatly compromised by something and we
are trying to figure it out. Indeed, we are getting many more users, so I am
wondering if subqueries have their limits. What are they? We are currently
using MS Access (we will move to SQL Server soon).
Any advice is welcome.
thanks.
alex
alexford Guest
-
#39146 [NEW]: Named placeholder is not bound correctly with Subqueries
From: php at mailingslists dot birkholz dot biz Operating system: Linux 2.6.17-gentoo-r7 PHP version: 5.1.6 PHP Bug Type: PDO... -
Using COALESCE for subqueries
Hi! I'm trying to set an '1' to all records that return NULL in below query, using COALESCE, but I get errors which way I try...probably a... -
subqueries in query of queries
I've been looking at this for a while so I might be punch drunk. I have a query of queries on a mySQL sales database. I want to display columns... -
DBI and subqueries in mysql 4.1
Using perl DBI, mysql 4.1, we don't get any rows back. The query is perfectly ok, works on mysql-client. Trying to get some results from this code:... -
Why are subqueries recongized as dependencies
I have this view: SELECT ClientID, ClientDisplayName, LoginName, ClientEmail, (SELECT COUNT(*) FROM qryWorkOrders WHERE ... -
Dan Bracuk #2 Re: Joins or subqueries
This is a duplicate post. It has been answered at least once in the cfml general forum.
Dan Bracuk Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
