Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
danorahs #1
Using <CFIF> on query results
I'm using Coldfusion with SQL databases to develop a dynamic calendar. The
issue I have is how to get it to know if a particular day is a Holiday. I have
a Holidays table with each holiday date entered. I'm trying not to bog down
the page with so many queries. What I want to avoid is having to run 31
separate queries on each page (in addition to all the other queries) just to
find the Holidays for that month (I also have to do this with another table to
identify Down Days). Is there a way to run one SQL query and then use <CFIF>
to search WITHIN those results? For example: SELECT holiday.day,
holiday.month FROM holiday WHERE holiday.month = 'FEB' AND holiday.year =
'2005' Let's say the query above will return 3 dates. I want to put a <CFIF>
tag on each calendar date to look and see if that particular date was returned
somewhere in the query results (instead of writing 31 queries and putting the
specific date in the WHERE clause). Can <CFIF> work within query results? Is
there any easier way that I'm missing? Thanks!
danorahs Guest
-
Complex join = no results (for a query that shouldreturn results)
I am trying to use a rather complex join that returns many results when the SQL server is queried directly, but returns no results when used on a... -
cfif not giving expected results
Hi, I am firing Query & comparing Name with string1 even Name is equal to string1 statements inside cfif is not executed Code: ... -
Dymanic Query and CFIF Problems
Problem: I have an application where I have one access table with the following fields: autonum, cca_index, cca_category, wt_index, wt_category. ... -
Query results don't display properly in results table.IGNORE PREVIOUS
:disgust; I need to display the results of a query. The query runs properly. My problem is having specific results display in specific locations in... -
Query results don't display properly in results table.
:disgust; I need to display the results of a query. The query runs properly. My problem is having specific results display in specific locations in... -
Iceborer #2 Re: Using <CFIF> on query results
Couldn't you use valueList to dump the returned holiday.day values into a list, then just test for listFind (holdayList, thisDay) neq 0
Iceborer 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
