Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: OneTrickPony
- Order by date
-
Query of Queries Union Not Totaling Across Fields
One a more fundamental note - this points out one of the advantages to keeping your databases in third normal. If you had a related table where you kept email addresses you could have as many or as few as you wanted per user and you wouldn't have a bunch of fields with null values - and - these...- OneTrickPony
- Post #3
- Forum: Adobe
-
Variables in Variables
Excellent - Thanks. I also found out I could use array notation: <CFSET VARIABLES['Date' & i] = DateFormat(DateAdd("M", i, Now()))> I still have a lot of optimization to do but I'm on my way no. Thank you!- OneTrickPony
- Post #3
- Forum: Adobe
-
Variables in Variables
I have some code that creates variables for each of the next 12 months. This is an example for the second month. <CFSET VARIABLES.Date1 = DateFormat(DateAdd("M", 1, Now()))> <CFSET VARIABLES.numDays1 = DaysInMonth(Date1)> <CFSET VARIABLES.Month1 = Month(Date1)> <CFSET VARIABLES.MonthString1 =...- OneTrickPony
- Thread
- Replies: 2
- Forum: Adobe
