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

    Retrieving data via date

    If all the times in the db are set to midnight, then Carl's version works. If not, I believe this will do it: <cfset begindate = #CreateDateTime(DatePart('yyyy', Now()), DatePart('m', Now()), DatePart('d', Now()), 0, 0, 0)#> <cfset enddate = #CreateDateTime(DatePart('yyyy', Now())...
  2. parrotgurl

    Retrieving data via date

    &quot;The nice thing about Date/Time data is the time portion is assumed. If it's absent in the SQL, the driver should automatically assume that you're talking about midnight. So you don't need to do any further formatting.&quot; But we don't know about the values in the database. They could...
  3. parrotgurl

    Is my query right?

    Hi, No, the term1 and term2 columns are set in the database not to allow nulls. If there's no term1 or term2 date for a given record, then there's just a 0 in that field (it's actually not a date datatype, just a number like 2002123, a combination of year and julian day of the year). Thanks.
  4. parrotgurl

    Is my query right?

    I want to make sure I'm doing this query correctly. There are two tables of interest, let's call them plans and transactions. In the plans table, there are two columns that serve as a combined key - tan and pin. Tan is an employer number and pin is an employee number. There can be employees...

Part and Inventory Search

Back
Top