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!

Register Log in
  • Congratulations derfloh 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: *

  1. OneTrickPony

    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...
  2. OneTrickPony

    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!
  3. OneTrickPony

    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 =...

Part and Inventory Search

Back
Top