RE: screenshots

2011-05-16 Thread Mark A. Kruger
Tada!! :) -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, May 16, 2011 4:24 PM To: cf-talk Subject: Re: screenshots Genius. 2 lines of CF. Eat your heart out PHP et al: http://myurl.com "> On Mon, May 16, 2011 at 4:19 PM, Dave Watts wrote: > >

Re: MySQL install

2011-05-16 Thread Ken Hammond
I have no need for remote access. I RDP into the machine over VPN already. -Original Message- From: Russ Michaels To: cf-talk Date: Mon, 16 May 2011 22:17:39 +0100 Subject: Re: MySQL install that would depend if you want to open up remote access. If you do then at least restrict it

Re: screenshots

2011-05-16 Thread John M Bliss
Genius. 2 lines of CF. Eat your heart out PHP et al: http://myurl.com "> On Mon, May 16, 2011 at 4:19 PM, Dave Watts wrote: > > > But you can produce a PDF and then generate a thumbnail... right? > > Yes. The courseware I linked earlier in the thread has an example of > exactly this. > > D

Re: screenshots

2011-05-16 Thread Dave Watts
> But you can produce a PDF and then generate a thumbnail... right? Yes. The courseware I linked earlier in the thread has an example of exactly this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOS

Re: MySQL install

2011-05-16 Thread Russ Michaels
that would depend if you want to open up remote access. If you do then at least restrict it by IP or use a VPN. MySQL ports are regularly scanned for and attacked if found open. On Mon, May 16, 2011 at 8:01 PM, Raymond Camden wrote: > > Not sure I'd recommend phpmyadmin - wouldn't that also imp

RE: screenshots

2011-05-16 Thread Mark A. Kruger
But you can produce a PDF and then generate a thumbnail... right? Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Monday, May 16, 2011 3:34 PM To: cf-talk Subje

Re: screenshots

2011-05-16 Thread Ian Skinner
On 5/16/2011 1:11 PM, John M Bliss wrote: > Hi! Has anyone built anything with CF that'd take as an argument a URL and > would return an image representing a screenshot of that page? Is this crazy > talk? Yes, it is pretty crazy, ColdFusion has NO SCREEN of which to take a SHOT. There is the

Re: screenshots

2011-05-16 Thread Wil Genovese
Isn't this sort of like creating a PDF format of a page? I would think the same techniques would apply. I've never tried to generate as an image before. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On M

Re: screenshots

2011-05-16 Thread Matt Blatchley
This might help. Should have sent this with my earlier post. http://tips.webdesign10.com/how-to-take-a-screenshot-with-ubuntu-linux ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/d

Re: screenshots

2011-05-16 Thread Dave Watts
> Hi!  Has anyone built anything with CF that'd take as an argument a URL and > would return an image representing a screenshot of that page?  Is this crazy > talk? There's actually an example of this in the Advanced ColdFusion 8 Development curriculum, in the PDF unit if I recall correctly. htt

Re: screenshots

2011-05-16 Thread Matt Blatchley
I think Linux and a Firefox Plugin will do it running as a process in the background. On Mon, May 16, 2011 at 3:11 PM, John M Bliss wrote: > > Hi! Has anyone built anything with CF that'd take as an argument a URL and > would return an image representing a screenshot of that page? Is this >

screenshots

2011-05-16 Thread John M Bliss
Hi! Has anyone built anything with CF that'd take as an argument a URL and would return an image representing a screenshot of that page? Is this crazy talk? -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusio

Re: MySQL install

2011-05-16 Thread Raymond Camden
Not sure I'd recommend phpmyadmin - wouldn't that also imply installing PHP? MySQL has free tools for management - why not just use them? (And yeah - they kinda suck in terms of UX but you can deal with it. :) On Mon, May 16, 2011 at 12:34 PM, Russ Michaels wrote: > > You should real the notes o

Re: MySQL install

2011-05-16 Thread Russ Michaels
You should real the notes on the various install modes/settings to make sure you install it configured with the best options for your needs, it isn't really as straight forward as MSSQL. I would suggest you block remote access to mysql in your firewall and use phpmyadmin to access it or just login

Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell
If the cache filling up is the cause - the following should provide a useful look at whats feeling it up - SELECT total_worker_time/execution_count AS [Avg CPU Time], SUBSTRING(st.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(

Re: Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
In the vast majority of cases (anecdotally), it's updates that are occuring, not inserts. It's people editing existing content, not adding new content. That said, this table only has a PK field set up with an index. On 5/16/11 11:11 AM, DURETTE, STEVEN J (ATTASIAIT) wrote: > Do you have any in

Re: Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
What I'm finding now, in the last little bit, is that in the case of a content-save triggering the hang, the content *does* seem to save - the queries being the "larger" ones as far as raw data being moved around. I'm in the process of poking about some older code that executes after those que

RE: Odd issue with DB "pausing"

2011-05-16 Thread DURETTE, STEVEN J (ATTASIAIT)
Do you have any indexes on this table. Improper indexes can really hamper the database while doing inserts. Steve -Original Message- From: Scott Weikert [mailto:li...@alphageek.cc] Sent: Monday, May 16, 2011 12:27 PM To: cf-talk Subject: Re: Odd issue with DB "pausing" Ok just happen

MySQL install

2011-05-16 Thread Ken Hammond
As suggested by Raymond, I am going to install MySQL server. Is there anything special I need to know security wise? It's going onto a win2k8 box. How do I setup a datasource in CFAdmin for MySQL? I've only ever dealt with MS SQL, Access, Excel, ODBC connections, etc... ~

Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell
Other than an eventual timeout thrown by CF - are you getting any SQL errors when this situation arises? (from either cf trying to run a query or when trying to execute a query via analyzer) Do any errors show up in the SQL logs? On Mon, May 16, 2011 at 12:37 PM, Charlie Stell wrote: > An inc

Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell
An increase of the number of queries being executed via cfquery where queryparam isn't being used - regardless of it being from a user request or a scheduled process... On Mon, May 16, 2011 at 12:13 PM, Scott Weikert wrote: > > No, no recent updates (that I'm aware of), no increase in traffic.

Re: Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
Ok just happened again... one thing to note is that when these hangs occur, all DB activity is affected. Even firing up query analyzer (SQL toolset), doing a simple query that would normally come back very quickly, it just spins.

Re: Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
Anecdotal evidence so far indicates the hangs occur when writing to a given table - not reading, that's for sure. It's when a client is saving content - which in our system is pretty much the spot where the most content can be written to the DB. And no, no locks or transaction settings in that

Re: Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
No, no recent updates (that I'm aware of), no increase in traffic. When you say "request increase" are you talking about behind-the-scenes DB requests? Or an increase in usage by people with a corresponding increase in DB traffic? On 5/16/11 10:06 AM, Charlie Stell wrote: > Have you recently u

RE: Odd issue with DB "pausing"

2011-05-16 Thread Al Musella, DPM
Try running fusionreactor and see what is running at the time you have the problem It just helped me solve a tricky problem.. cold fusion was hanging after running one template multiple times.. worked perfectly when I tried it, hung the server when others ran it. The template was indexing

Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell
Have you recently upgraded versions of MS-SQL? And/or recently had a significant increase in requests? In the system I was referring to, it had been running for 3 years without this being an issue - then we upgraded to SQL 2005 and had a request increase of about 25% - at this point we started h

Re: Odd issue with DB "pausing"

2011-05-16 Thread Maureen
Are you doing any locking on the DB? If it is always happening with when querying the same table, you could be getting locks or conflicts on that table. On Mon, May 16, 2011 at 8:53 AM, Scott Weikert wrote: > > Yep, there's quite a few queries without cfqueryparam - but again, this > is behavio

Re: IMing without access to the CF Administrator

2011-05-16 Thread Phillip Vector
Thanks. I'll try it when I get home from work (Pretty severe firewall at work). > Try IMIfied - > > http://www.imified.com/ > http://www.coldfusionjedi.com/index.cfm/2008/9/11/IMified-Relaunches > > On Mon, May 16, 2011 at 9:59 AM, Phillip Vector > wrote: > > > > I'm on shared hosting, therefo

Re: IMing without access to the CF Administrator

2011-05-16 Thread Phillip Vector
Thanks. I'll try it when I get home. I have a pretty restrictive blocker at work. > Try IMIfied - > > http://www.imified.com/ > http://www.coldfusionjedi.com/index.cfm/2008/9/11/IMified-Relaunches > > On Mon, May 16, 2011 at 9:59 AM, Phillip Vector > wrote: > > > > I'm on shared hosting, ther

Re: Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
Yep, there's quite a few queries without cfqueryparam - but again, this is behavior that has popped up of late - this is code that's been around for years that hasn't had this sort of issue. So I don't know that this is a problem. I'm unsure as to recovery model - we have a hosting guy who mai

Re: Odd issue with DB "pausing"

2011-05-16 Thread Charlie Stell
Do you have many queries (especially queries ran very often) that do not use cfqueryparam? Those symptoms remind me of system I worked in once where most of the queries were not using queryparam or any other form of binding - and as a result sql's query cache was filling up too often... though I'm

Re: IMing without access to the CF Administrator

2011-05-16 Thread Raymond Camden
Try IMIfied - http://www.imified.com/ http://www.coldfusionjedi.com/index.cfm/2008/9/11/IMified-Relaunches On Mon, May 16, 2011 at 9:59 AM, Phillip Vector wrote: > > I'm on shared hosting, therefore, I don't get to access the CF Administrator. > What I would like to do is send an IM to a servi

RE: Odd issue with DB "pausing"

2011-05-16 Thread Mark A. Kruger
Scott, It might pay to eliminate networking as a possible issue. For example - are the ports on the switch trying to "scale up" to 1000/mbs from 100? This could cause what looks like a temporary "hang". (try statically setting ports end to end between the server and db). Or perhaps you have

IMing without access to the CF Administrator

2011-05-16 Thread Phillip Vector
I'm on shared hosting, therefore, I don't get to access the CF Administrator. What I would like to do is send an IM to a service (AIM, Yahoo, ICQ, MSN, Google, Whatever). Is this at all possible without access to CfAdmin? Anyone know of any services that will IM someone with an email message pe

Re: Odd issue with DB "pausing"

2011-05-16 Thread Dave Watts
> Got CF8 running using MSSQL. Lately, every now and again (too often) the > DB appears to hang, anywhere from a minute or so to several minutes. As > best I can tell (from previous times when it's happened, and I was > remoting our DB box at the time) the CPU isn't spiking during these > hangs. I

Odd issue with DB "pausing"

2011-05-16 Thread Scott Weikert
Ok I've got a headscratcher here, would love some input from some other brains out there. Sometimes it sucks to be the lone gunman developer. :( Got CF8 running using MSSQL. Lately, every now and again (too often) the DB appears to hang, anywhere from a minute or so to several minutes. As best

Re: Model Glue

2011-05-16 Thread Maureen
I don't "need" anything. I was simply commenting on how good the report builder in Access is. And yes, I've used Report Builder, SQL Reporting Services, Crystal Reports and all the other tools that have been available over the last 20 years. None of them have the ease and the intuitive interfac

Re: Model Glue

2011-05-16 Thread Maureen
Yes, you can attach tables from other databases and only use Access for reporting. On Mon, May 16, 2011 at 5:26 AM, Mark A. Kruger wrote: > > Maureen... actually you can connect to SQL server using Access as a client > right? So you can get the full RDBMS but still get all the fun client stuff >

Re: ColdFusion 9 Cloud Hosting

2011-05-16 Thread Russ Michaels
Amazon is brilliant for fast provisioning, auto scaling and short term usage. But you actually want a long term solution that is up 24/7 it is actually very expensive compared to having your own Private Cloud/VPS solution. On Mon, May 16, 2011 at 12:16 PM, N kips wrote: > > When you google "Ama

Re: Model Glue

2011-05-16 Thread Russ Michaels
Maureen, obviously I don't know exactly what you need, but have you actually tried out the Report Builder? http://www.mssqltips.com/tip.asp?tip=1690 On Mon, May 16, 2011 at 8:45 AM, Maureen wrote: > > Not even close. > > On Sun, May 15, 2011 at 2:30 AM, Russ Michaels > wrote: > > > > You c

RE: Model Glue

2011-05-16 Thread Mark A. Kruger
Maureen... actually you can connect to SQL server using Access as a client right? So you can get the full RDBMS but still get all the fun client stuff you like :) No? Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message-

Re: ColdFusion 9 Cloud Hosting

2011-05-16 Thread N kips
When you google "Amazon Cloud + Coldfusion 9", you'll find alot of articles about a coldfusion beta for Amazon's cloud. E.g. http://www.adobe.com/aboutadobe/pressroom/pressreleases/200910/AdobeColdFusion9NowAvailable.html What does this mean? That a time would come when we'd visit amazon to cho

Re: Model Glue

2011-05-16 Thread Maureen
Not even close. On Sun, May 15, 2011 at 2:30 AM, Russ Michaels wrote: > > You can already do this on SQL Server > > http://msdn.microsoft.com/en-us/library/ms159106.aspx > > > On Sun, May 15, 2011 at 4:03 AM, Maureen wrote: > >> >> Access