Not even close.
On Sun, May 15, 2011 at 2:30 AM, Russ Michaels r...@michaels.me.uk wrote:
You can already do this on SQL Server
http://msdn.microsoft.com/en-us/library/ms159106.aspx
http://msdn.microsoft.com/en-us/library/ms159106.aspx
On Sun, May 15, 2011 at 4:03 AM, Maureen
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
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
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 mamamaur...@gmail.com wrote:
Not even close.
On Sun, May 15, 2011 at 2:30 AM, 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 nich...@gmail.com wrote:
When
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 mkru...@cfwebtools.com 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
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 interface
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
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. It
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
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 a
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
vec...@mostdeadlygame.com wrote:
I'm on shared hosting, therefore, I don't get to access the CF Administrator.
What I would like to do
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
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
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
vec...@mostdeadlygame.com wrote:
I'm on
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
vec...@mostdeadlygame.com wrote:
I'm on shared
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 li...@alphageek.cc wrote:
Yep, there's quite a few queries without cfqueryparam - but again,
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
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
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
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
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.
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 li...@alphageek.cc wrote:
No, no recent updates (that I'm aware of), no
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
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...
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
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
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
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
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
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 r...@michaels.me.uk wrote:
You
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
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 bliss.j...@gmail.com 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
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.
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!
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
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
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
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 rcam...@gmail.com wrote:
Not sure I'd recommend phpmyadmin -
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
Genius. 2 lines of CF. Eat your heart out PHP et al:
cfdocument format=PDF filename=my.pdf src=http://myurl.com
/cfdocument
cfpdf action=thumbnail source=my.pdf scale=25
On Mon, May 16, 2011 at 4:19 PM, Dave Watts dwa...@figleaf.com wrote:
But you can produce a PDF and then generate a
I have no need for remote access. I RDP into the machine over VPN already.
-Original Message-
From: Russ Michaels r...@michaels.me.uk
To: cf-talk cf-talk@houseoffusion.com
Date: Mon, 16 May 2011 22:17:39 +0100
Subject: Re: MySQL install
that would depend if you want to open up
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:
cfdocument format=PDF filename=my.pdf src=http://myurl.com
/cfdocument
cfpdf
43 matches
Mail list logo