Search results for query: *

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

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

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

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.

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

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

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

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

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

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

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

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

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.

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