Search results for query: *

Thank you so much, MrGreed! you solved my problem! Eva

Hello MrGreed, I think I went 1 step forward and 2 back. The thing with the security settings worked, I am now getting the active x window and when I click yes it opens netscape - and then it opens also an IE window with the link it is supposed to go to! So I think there is still something in...

Hello MrGreed, I tried it (with a link instead of a button, but still with the onCLick event) and I get an error: Automation server can't create object. Any idea why. Or any other idea of how to solve the problem? Thanks, Eva

Hello, My company has an intranet where all users have the same version of IE and Netscape. Everybody uses IE for our web based reports and company pages. However, there is one website (for GUI) that some employees use that can only be viewed in Netscape. I have a page with a bunch of...

Hello, I have a table with all kinds of absence records for all employees, but I only want to get the last absence for each employee. Here is what I tried: SELECT DISTINCT SocSec, BeginAbsenceDate, AbsenceCode, (SELECT TOP 1 BeginAbsenceDate FROM...

Thanks guys for trying to help! fusionaire: your idea didn't work, I got the "Can't find symbol: -1.#IND00" error again. Rudy, your answer makes sense, but how can I fix it? How can I make it generate the results for the SELECT list? And Carl, sorry I didn't make sense. So let me...

I can't figure out how to do a CFIF ... Is Null. From what I read on other threads, CF does not do Is Null? I also tried CFIF ... EQ &quot;&quot;, Trim(Len(...)), Len(Trim(...)), but nothing works. Here is part of my query: SELECT <CFIF qrySumAbsent.Jan IS NULL><CFSET PercJan =...

I have a SQL table with columns QD1-QD8. I have a query that looks like this: <CFQUERY name=&quot;ShowData&quot; datasource=&quot;EdropSQL&quot;> SELECT SUM(CASE WHEN QD1 = '5' THEN 1 ELSE 0 END) AS StA1, SUM(CASE WHEN QD1 = '4' THEN 1 ELSE 0 END) AS A1, SUM(CASE WHEN QD1 = '3' THEN 1...