Some CFML Stuffs Me Do

From: Ken (SHIELDSIT) 5 May 2011 20:33
To: steve 17 of 75

Hey is there a way to do this?

 

After I click an image and make the page print, make it automatically load a different page?

From: af (CAER) 5 May 2011 21:01
To: Ken (SHIELDSIT) 18 of 75
Surely that's just a case of
JavaScript code:
...
window.print();
window.location = "http://new.url.com";
From: Ken (SHIELDSIT) 5 May 2011 21:02
To: af (CAER) 19 of 75
I will let you know if you win or not! Just one second please!
From: af (CAER) 5 May 2011 21:03
To: Ken (SHIELDSIT) 20 of 75
I suspect the window.print() function returns immediately btw, so the page may well change straight away, rather than after the user clicks OK in the Print dialog.
From: Ken (SHIELDSIT) 5 May 2011 21:08
To: af (CAER) 21 of 75
Ahh I see what you're saying. I can't test it right now, but I'll let you know how I make out. Thanks!
From: CHYRON (DSMITHHFX) 6 May 2011 11:21
To: Ken (SHIELDSIT) 22 of 75
You're trying to make it too easy. Computers are supposed to be too hard for mere users. That's why they pay us to come over and click the "print" button.
From: Ken (SHIELDSIT) 6 May 2011 11:39
To: CHYRON (DSMITHHFX) 23 of 75
I suppose but I'm a sucker for automation!
From: CHYRON (DSMITHHFX) 6 May 2011 11:54
To: Ken (SHIELDSIT) 24 of 75
As long as it breaks and causes extreme frustration and panic...
From: Ken (SHIELDSIT) 6 May 2011 11:55
To: CHYRON (DSMITHHFX) 25 of 75
When I want to show my power I reboot the mail server!
From: Ken (SHIELDSIT) 6 May 2011 12:59
To: Peter (BOUGHTONP) 26 of 75

I think I'm approaching this from the wrong angle. I think I'd be better served if I put my effort into the SQL Server Reporting Service.

 

Have you or anyone here used it?

From: Peter (BOUGHTONP) 6 May 2011 13:12
To: Ken (SHIELDSIT) 27 of 75
I've not used it - no idea if anyone else has though.
From: Ken (SHIELDSIT) 6 May 2011 15:33
To: Peter (BOUGHTONP) 28 of 75

I can fumble through most of it, but I'm having a hard time getting it to perform some math and getting it to let me select what I want from the database.

 

Think I'm going to buy a book about it.

From: CHYRON (DSMITHHFX) 7 May 2011 02:43
To: Ken (SHIELDSIT) 29 of 75

The point is not to show YOUR power (which frankly, there is none, but I'm not telling), but THEIR abject helplessness (of which there is a copious, abundant and boundless supply, until the end of time, oh lord).

 

The easiest way to do that is to go out and get smashed, then show up for work the next day. Enjoy.

From: Peter (BOUGHTONP) 7 May 2011 02:59
To: CHYRON (DSMITHHFX) 30 of 75
I'm not sure showing up for work smashed is going to do much on a weekend.
From: CHYRON (DSMITHHFX) 7 May 2011 18:08
To: Peter (BOUGHTONP) 31 of 75
It's going to do great things. GREAT. THINGS. Oh yee of little fathe...
From: Ken (SHIELDSIT) 9 May 2011 16:36
To: Peter (BOUGHTONP) 32 of 75

Pete - These numbers are what I get if I query a table in my db. How can I add ONLY the positive numbers and ignore the negatives?

 

-114.68
79.50
-8.48
2221.93
3994.88
-142.04
2655.45
-157.36
1084.00
-108.40
986.85
-58.48
15258.80

From: Peter (BOUGHTONP) 9 May 2011 17:07
To: Ken (SHIELDSIT) 33 of 75
Uh.... like this:

Select sum (colname)
from table
where colname > 0

?
From: Ken (SHIELDSIT)10 May 2011 12:57
To: Peter (BOUGHTONP) 34 of 75
What is your schedule looking like this fine day? I need you to hold my hand and whisper in my ear!
From: Peter (BOUGHTONP)10 May 2011 13:20
To: Ken (SHIELDSIT) 35 of 75
Dunno. Ask me again in an hour, when I've eaten and might be more awake.
From: Ken (SHIELDSIT)10 May 2011 13:22
To: Peter (BOUGHTONP) 36 of 75
k thanks you handsome man!