Search results for query: *

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

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

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

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

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

I am having a problem getting the correct information on the following Select statment. SELECT * FROM Device_Main WHERE Mail_Code=019-2 It will give me all records where the mail code = 017-6. If I run a query where the Mail_Code=019-1, I get all records for mail_code 018-4. If I run the...

I need help in moving one record (split across two tables) from its original table to a different table. I have an inventory database that has our asset information split into two tables, Device_Main and Device_Detail. The Asset number links them both, and is the PK in both tables. I want to...