Ask a Question related to Coldfusion Database Access, Design and Development.
-
charlese #1
I Need help writing a query
I hope I give enough information for my delimma. I have an ACCESS database
with 3 tables: -Client (clientid, name) -ClientClosedDates (clientid, date)
- contains the date that the client is NOT avaialble -Event (date, eventName)
What I am having trouble with is writing an ACCESS SQL statement that will list
only the Clients that are not closed out for a particular event. e.g. I give a
date in the event table and the result is a list of all available clients.
Please help. Thanks Charles:confused;
charlese Guest
-
mySQL query writing problem
I have a table with a dozen or so fields. I am trying to return all 12 fields in all records that contain an entry in the field named 'week'. This... -
Writing Query for data range does not output
The cfoutput tag for this query does not display any data. SELECT Title, SVNo, RevNo, FileName, Type, ReleaseDate, Platform, PCNs,... -
Query of Queries on query New type query
In CF5 we have a page that creates a query, using queryNew and querySetCell and the like, we then used dbtype="query" and gave it's name so we could... -
Writing SQL query without subselect
I'm stuck on a host that is still running MYSQL version 3. I need to flatten out a relationship to AND a set of criteria. In a nutshell User... -
BCP query out executed by xp_cmdshell works fine from query analyzer but fails from VB Component
Hi all, I have a stored procedure which returns a vast number of record and i have to write the output into a csv file. I'm using BCP utility to... -
Tulsa #2 Re: I Need help writing a query
SELECT client.clientid, client.name
FROM Client
INNER JOIN ClientClosedDates
ON Client.clientid = ClientClosedDates.clientID
WHERE ClientClosedDates.date <> #form.whateverdate#
Tulsa 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
