Recent content by DavidC271

Feherke, Thank you very much for your answer. I took what you gave me and adjusted a bit to come up with what I was looking for. FYI - case is the one method I did not try... SELECT branch_id, COUNT(CASE report_status WHEN 'open' THEN 1 END) AS rptCount FROM report_feeder WHERE rpttype =...

I am trying to pull a query that will show me all my branches and how many reports they have open at any given time. I want to see 0 if they do not have any reports open. Here is my SQL: SELECT DISTINCT branch_id, count(report_id) AS rptCount FROM report_feeder WHERE rpttype = 'report' AND...

YOU ARE A LIFE SAVER!!! Dropped the cfset and changed the cfoutput query to what you have it bingo presto... Thanks again, I have been trying to figure out my mistake for three hours now and was getting very frustrated.

Im trying to output a cfquery to one line so it can be scrolled across a news ticket. My problem is that when I setup my output I get: Item 1 Item 2 Item 3 Im trying to get: Item 1 Item 2 Item 3 ... So far I have gotten CF to output one line but its the first record over and over again... Not...

I’m trying to modify Microsoft's DXImageTransform.Fade() code from having to use a toggle button to loading it on startup and having it loop continuously. I'll be honest; I do not really know JavaScript that well so I really don't know where to begin. Here is the code MS provides: <SCRIPT> var...

I had a similar problem when I installed 5.1 on my server. It turned out to be an install issue with multi-processors. I updated the boot.ini with /numproc=1 I was able install without problems. Then went back to remove the switch and everything seems to be working fine. Been running along...

Thanks for the great information everyone. I will give the OSN a try.

My supervisor asked an interesting question to me this afternoon. He would like to be notified when a user makes a call to 911 from any of our phone sets. I don't think there is a way for a network announcement or an email, but can the call be flagged on the terminal screen for our CS1000. I...

I just got done installing CPSECPEPSP2S last week. Even after you run the disk cleanup PEP you will still need to change the virtual memory to 16 MB on the C: drive and 752 MB on the D: drive. This will give it just enough space to install the PEP. Once installed you will need to change the...

Well, there has been some development with this issue. WP released a new SP (WPOX3_SP2_EN_Retail) a few weeks ago and I tried it on one of our systems that have the problem. It fixed it 100% from what we can tell with the testing. I tried it on another and it fixed it enough to allow the user...

On a handful of our systems we are seeing multiple instances of wpwin13.exe running. It is causing problems for our users when it comes time to shutdown the system for the evening as they have to end all the processes before the system will reboot. I’ve narrowed down to what I think is...

I have an odd issue that I just can't seem to find any help on. I have a W2K3 server (standard) not connected to a domain. I am in the process of locking it down for a security review and now I have one account (with admin rights) that can logon to the system but when you lock the desktop...

Thanks for the help. I tried your code and I did not get any errors but the image was not displaying. I changed If rs(&quot;Signed_4247&quot;)=TRUE Then to If rs(&quot;Signed_4247&quot;)=&quot;TRUE&quot; Then and it worked. Now I think I will find an X jpg and use that for the False...

I need help in getting my code right. I am very new at programming and am learning on the fly. I would like to display a checkmark image when the value of my data is true. I have an enum('TRUE','FALSE') data type in my DB. I want ASP to display the check when the value is true and nothing...

You hit the nail on the head. Thanks. Not sure why I did not think of that. Thanks again for the help Daniel.