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 Rhinorhino 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. drizzage

    Does CFLOCATION allow page completely load first?

    Does anyone know, will CFLOCATION allow images on the page it's redirecting from to load before redirecting? I don't see how it could unless it waits for a status reply from the browser before executing. The reason I'm asking is because I have a page that processes the inclusion of new records...
  2. drizzage

    Suddenly logged in as someone else

    Thank you GUJUm0deL for the tip. My cflocks were not being set exclusively. And thank you ECAR for the snip. Even though I don’t know exactly how it works, I will use it as well! I'm fairly new to this, and thought that as long as the cookies were only being written to RAM, they would...
  3. drizzage

    Suddenly logged in as someone else

    My site has a common Aplication.cfm tag that checks the log-in status of each user. It saves the ID and token of each user in a cookie, or passes this information through the URL if cookies are not turned on. I think this is how it's usually done. Here is my application management tag...
  4. drizzage

    Getting distinct results

    Thank you very much! I tried to stick the DISTINCT function in there but didn't know exactly how to incorporate it. This seems to have done the trick. Thanks again.
  5. drizzage

    Getting distinct results

    This one should be pretty simple. I know very little about SQL, and can't seem to get a handle on it. I'm generating a graph showing the age ranges of all users who have submitted records. My query retrieves the actual ages, as well as how many users of each age. My current query: SELECT...
  6. drizzage

    Scheduled task timing out

    Much of it is sending mailing lists, and other dynamic queries that change daily and cannot be done automatically.
  7. drizzage

    Scheduled task timing out

    I have a scheduled template that needs slightly longer than 60 seconds to run. It’s timing out, and not allowing all of the processes to run. The problem is, I’m on a shared server where all scheduled tasks must be set through the administrator, and the host is not willing to extend the time...
  8. drizzage

    Charting recordcounts for each day of the month

    Gotcha. The date field is not currently indexed in the db, but I may want to do that. Thanks again for all your help!
  9. drizzage

    Charting recordcounts for each day of the month

    Ahhh I get it! The list contains all of the days that need to be populated by the query. I just had to change "<CFIF x EQ pos>" to "<CFIF pos NEQ 0>", and it works! I sure do appreciate the help rudy. I'm curious about one thing though. You specified the date range with the "first" and "last"...
  10. drizzage

    Charting recordcounts for each day of the month

    This is my query: <cfset first = DateAdd("d",-Day(Now())+1,Now())> <cfset last = DateAdd("d",-1, DateAdd("m",1, DateAdd("d",-Day(Now())+1,now())))> <cfquery Name="getCounts" Datasource="mydb"> select Day(DateEntered) as theday , count(*) as thecount from myTable...
  11. drizzage

    Charting recordcounts for each day of the month

    Thanks a bunch for the help, you've definitely brought me one step closer. I've included your code, but I need to know how to pass the entire recordset to the loop. Right now only the first returned record is showing up on the graph. In other words, my result set looks like this: 1 1
  12. drizzage

    Charting recordcounts for each day of the month

    I'm using CF 5, and need to generate a graph of how many new records have been entered into the db for each day of the month. I also need to make sure that every day of the month is represented even if there are no new records to display for that day. I know that there must be a way to do this...
  13. drizzage

    Retrieving counts from multiple collumns (Crosstab?)

    Thanks indrahig. That runs a tiny bit faster, but it's searching such a large recordset, that it's still to slow. What I'm going to do is drop the monthly breakdown from the list, and make that info available in a pop-up window for each list item.
  14. drizzage

    Retrieving counts from multiple collumns (Crosstab?)

    I know just enough SQL to get by, and lately, I'm not getting by so well! I have a listing of records on my Web site that displays the total number of views each has received, along with last month's views, and this month's views. I'm currently running 3 separate queries, and using the...

Part and Inventory Search

Back
Top