dbfield = cfqueryparam cfsqltype=cf_sql_tinyint value=#mydatefield#
null=#yesnoformat(mydatefield is '')#
On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison rharri...@aimg.com wrote:
In an update query, to a tinyint field which allows nulls, I have the
update
dbfield=#mydatefield#
If
On Apr 11, 2015, at 2:09 PM, John M Bliss bliss.j...@gmail.com wrote:
Hello. Yesterday, I installed Microsoft Updates for Windows Server 2012
and
today, from Internet Explorer on server, I can no longer surf to:
http://127.0.0.1/CFIDE/administrator/
It just spins and spins. Any
Hello. Yesterday, I installed Microsoft Updates for Windows Server 2012 and
today, from Internet Explorer on server, I can no longer surf to:
http://127.0.0.1/CFIDE/administrator/
It just spins and spins. Any ideas?
--
John Bliss - http://www.linkedin.com/in/jbliss
I think you'll need to update the hosts file so that:
prerelease-api.anotherdomain.com
...points to the right IP and then refer to:
prerelease-api.anotherdomain.com
...in your code. That should make everything line up.
On Wed, Apr 8, 2015 at 5:23 AM, Ian Chapman ian.chap...@melodimedia.co.uk
What Dave said.
On Wed, Apr 8, 2015 at 10:01 AM, Dave Watts dwa...@figleaf.com wrote:
I think you'll need to update the hosts file so that:
prerelease-api.anotherdomain.com
...points to the right IP and then refer to:
prerelease-api.anotherdomain.com
...in your code. That
Working on configuring ACF10 mail on Windows Server 2012. I followed these
steps:
http://blog.hyperfive.com/2013/07/how-to-setup-internal-smtp-service-for.html
...but, in ACF10 admin interface Server Settings Mail when I set Mail
Server to localhost, check Verify mail server connection, and
In the SMTP Server properties, I changed the IP from one of the IP's on the
box to all unassigned and it worked.
Next question: resulting plaintext emails appear to have carriage returns /
line feeds stripped out. Any idea how to get those back?
On Tue, Apr 7, 2015 at 7:52 AM, John M Bliss
, 2015 at 1:19 PM, John M Bliss bliss.j...@gmail.com wrote:
In the SMTP Server properties, I changed the IP from one of the IP's on
the
box to all unassigned and it worked.
Next question: resulting plaintext emails appear to have carriage
returns /
line feeds stripped out. Any idea how
PM John M Bliss bliss.j...@gmail.com wrote:
Yes. The code didn't change. Just moved from 32 bit Windows Server 2003
to 64 bit Windows Server 2012 and 32 bit ACF10 to 64 bit ACF10.
On Tue, Apr 7, 2015 at 10:49 AM, Russ Michaels r...@michaels.me.uk
wrote:
are you sure you do
Yes.
On Mon, Mar 30, 2015 at 10:29 PM, wrote:
Is this list working?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
I also once solved this by editing the hosts file on the server and adding
lines to force the name on the cert to point to the right IP.
On Tue, Mar 31, 2015 at 8:51 AM, Byron Mann byronos...@gmail.com wrote:
What is the URL and does the domain name match the certificate exactly,
meaning not
Hi. So we're moving from ACF10 32 bit to ACF10 64 bit. On ACF10 32 bit, we
settled on:
Minimum JVM Heap Size (in MB)1369
Maximum JVM Heap Size (in MB)1369
On the ACF10 64 bit box, we have 32 GB of RAM to play with. Given that this
box is just:
ACF10
The OS (Windows Server 2012)
I think it did. Then I deleted it. Genius.
On Thu, Mar 5, 2015 at 3:54 PM, Dave Watts dwa...@figleaf.com wrote:
Found it, I think: I was missing the IIS virtual directory /jakarta
mapped
to C:\ColdFusion10\config\wsconfig\1
Does that look right?
Yes, you will need that. The web
In IIS, the handler for *.cfm is:
C:\ColdFusion10\config\wsconfig\1\isapi_redirect.dll
Does that look right...?
Could this be a permissions issue...?
On Thu, Mar 5, 2015 at 2:28 PM, John M Bliss bliss.j...@gmail.com wrote:
Hi. I'm moving an ACF10 / FuseBox 5 site from Windows Server 2003
Hi. I'm moving an ACF10 / FuseBox 5 site from Windows Server 2003 (32 bit)
to Windows Server 2012 (64 bit) with new IIS, etc. My default fuse seems to
work fine but whenever I specify another fuse like:
http://www.domain.com/index.cfm?fuseaction=User.ShowLoginForm
...I'm getting the generic IIS
Found it, I think: I was missing the IIS virtual directory /jakarta mapped
to C:\ColdFusion10\config\wsconfig\1
Does that look right?
On Thu, Mar 5, 2015 at 3:14 PM, Dave Watts dwa...@figleaf.com wrote:
In IIS, the handler for *.cfm is:
In the old days, the wisdom was to make min and max match so that CF
wasn't spending horsepower constantly re-sizing the heap. Is that no
longer true?
On Thu, Mar 5, 2015 at 7:08 PM, Dave Watts dwa...@figleaf.com wrote:
Hi. So we're moving from ACF10 32 bit to ACF10 64 bit. On ACF10 32
In the last week, we maxed out at 960 MB.
On Thu, Mar 5, 2015 at 5:35 PM, Dave Watts dwa...@figleaf.com wrote:
Hi. So we're moving from ACF10 32 bit to ACF10 64 bit. On ACF10 32 bit,
we
settled on:
Minimum JVM Heap Size (in MB)1369
Maximum JVM Heap Size (in MB)1369
So I'm looking at this:
http://blogs.coldfusion.com/post.cfm/cautions-for-configuring-cf-10-with-iis-8-on-windows-2012-server
...and I'm here:
4) If all the above steps have been followed and if you are still getting
the error, please verify that update 8 is installed properly by checking
the
manual install instructions
On Thu, Feb 26, 2015 at 7:59 PM, John M Bliss bliss.j...@gmail.com
wrote:
So I'm looking at this:
http://blogs.coldfusion.com/post.cfm/cautions-for-configuring-cf-10-with-iis-8-on-windows-2012-server
...and I'm here:
4) If all the above steps have
-enabling-it-configuring-it-reconsidering-it
Wil Genovese
Sr. Web Application Developer/
Systems Administrator
CF Webtools
www.cfwebtools.com
wilg...@trunkful.com
www.trunkful.com
On Feb 26, 2015, at 1:59 PM, John M Bliss bliss.j...@gmail.com wrote:
So I'm looking
Working on this:
https://helpx.adobe.com/coldfusion/kb/coldfusion-10-mandatory-update.html
I have the update saved to:
C:\ColdFusion10\cfusion\hf-updates\cf10_mdt_updt.zip
...and then, from:
C:\ColdFusion10\jre\bin
...I run:
java -jar C:\ColdFusion10\cfusion\hf-updates\cf10_mdt_updt.zip
That's why I:
;-)
I'm constantly posting dumb questions here. :-)
On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk wrote:
Hey everyone does something dumb occasionally ð
On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com
wrote:
No.
Come on, Russ
Reinstalling ACF10 64 bit from physical media from Adobe and getting this
when I run the installer:
Fatal Application Error
This Application has Unexpectedly Quit
Invocation of this Java Application has caused an
InvocationTargetException. This application will now exit. (LAX)
Anyone else seen
No.
Come on, Russ, you've known me for, like, a decade on here! ;-)
On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk wrote:
Not trying to install it on a 32bit os are you?
On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com
wrote:
Reinstalling ACF10 64 bit
Do you know where that's located?
On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote:
Try running as administrator.
Take a look at the installer log for more info.
On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com
wrote:
That's why I
?
On Wed, Feb 25, 2015 at 4:37 PM, Mark A Kruger mkru...@cfwebtools.com
wrote:
Sorry this one!
http://www.coldfusionmuse.com/index.cfm/2010/2/24/CF8-Install-Windows-2003-64bit
-mark
-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com]
Sent: Wednesday, February
java to do the
install, try removing it from your environment variables so that the
cfinstaller can't find it and might not try to use it
On Wed, Feb 25, 2015 at 10:07 PM, John M Bliss bliss.j...@gmail.com
wrote:
Thanks. I installed 32 bit Java and edited that .lax file
:39 PM, John M Bliss bliss.j...@gmail.com
wrote:
Thanks, guys. This fixed it:
http://www.instructables.com/id/How-to-install-coldfusion-10-64-bit-on-Windows-Ser/?ALLSTEPS
On Wed, Feb 25, 2015 at 5:37 PM, Russ Michaels r...@michaels.me.uk
wrote:
did you already have a JRE
I'll add: while you're checking stuff out, be sure to check out:
http://brackets.io Has a CFML extension, is super-fast lightweight, has
great find-and-replace, and has amazing front-end dev tools.
On Sat, Jan 10, 2015 at 12:23 PM, Rob Voyle robvo...@voyle.com wrote:
Hi Steve
I use
An anomaly with a remote API was causing my CF server to attempt to
instantiate ten thousand objects, crashing the server.
On Wed, Dec 31, 2014 at 9:36 AM, Byron Mann byronos...@gmail.com wrote:
I would look to the code then. Something running well today does not mean
it will run well
I have a process which used to run fine. Now, it produces:
Bad Gateway!
There is a problem with the page you are looking for, and it cannot be
displayed. When the Web server (while acting as a gateway or proxy)
contacted the upstream content server, it received an invalid response from
the
That's exactly what's happening. Thanks.
On Tue, Dec 30, 2014 at 3:30 PM, Byron Mann byronos...@gmail.com wrote:
This is the kind of error you might get when the CF service is down.
First impression is something you are running is crashing the CF service.
Anything in the logs that might
Starting point...? http://picasacfc.riaforge.org
On Thu, Dec 18, 2014 at 4:37 PM, Les Irvin les.cft...@gmail.com wrote:
I'm trying to write a CF script to automate the creation of a photo
slideshow video in Picasa. I want to programatically take, say, a folder of
JPGs, convert them to a
Does the line number on that error indicate that the query is what's timing
out?
On Fri, Nov 28, 2014 at 11:46 AM, Don danfar...@hotmail.com wrote:
The errors getting back are all The request has exceeded the allowable
time limit Tag
Seems that the whole server eventually crashes/slows to
Were you getting an error?
On Thu, Nov 27, 2014 at 3:08 AM, Don danfar...@hotmail.com wrote:
Does anyone know of any supposed issues with CF 11 and cfqueryparam ?
I had a few of them in a query. One by one I removed them to see if I
could get the query working and then, adding them in. All
http://smsgateway.riaforge.org
On Tue, Nov 18, 2014 at 6:09 PM, Rick Sanders r...@webenergy.ca wrote:
Hey guys,
Does anyone know a service I can use for sending sms messages from cold
fusion? I want to make an app that notifies someone by sms when their
product is ready.
Kind Regards,
Only by restoring from backup. No clue as to root-cause / preventing it
from happening again.
On Sun, Nov 9, 2014 at 6:37 PM, Sebastian Powell bas...@gmail.com wrote:
[crickets] :-)
--
John Bliss - http://www.linkedin.com/in/jbliss
I am experiencing the same issue on CF 11,
Not sure I understand your question. Check out
https://wikidocs.adobe.com/wiki/display/coldfusionen/cflocation
On Mon, Nov 10, 2014 at 3:39 PM, Steve LaBadie slaba...@po-box.esu.edu
wrote:
We are currently using a meta date redirect from a UNIX box. The redirects
currently sit on www and the
...?
https://merchant.paypal.com/us/cgi-bin/?cmd=_render-contentcontent_ID=merchant%2Fdonations
On Tue, Oct 28, 2014 at 2:26 PM, Rob Voyle robvo...@voyle.com wrote:
Hi Folks
Any recommendations for church/non-profit online donations, especially
recurring donations?
Thanks
Rob
Robert J.
That's the way it's always looked for me...
On Thu, Oct 23, 2014 at 9:29 PM, Eric Roberts
ow...@threeravensconsulting.com wrote:
Here's the screenshot: https://www.diigo.com/item/image/50m7r/eyn5 Look
at
the center column
Eric
-Original Message-
From: Jenny Gavin-Wear
Helpful...? http://www.houseoffusion.com/groups/xml/thread.cfm/threadid:108
On Tue, Oct 14, 2014 at 4:08 PM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:
I'm having an issue with a XMLRPC webservice using CFHTTP. I am getting
text/html responses instead of xml. A successful
wrote:
Just use the previously mentioned commands that is all you need
On Wed, Oct 1, 2014 at 22:57 PM, John M Bliss bliss.j...@gmail.com
wrote:
Care to share the batch file?
On Oct 1, 2014 5:56 PM, Russ Michaels r...@michaels.me.uk
javascript:;
wrote:
we have a batch file
Hi. What's the current best way to use CFML to restart ACF 10 app server
service (on Windows server)?
--
John Bliss - http://www.linkedin.com/in/jbliss
~|
Order the Adobe Coldfusion Anthology now!
/cfexecute
HTH
G!
*Gerald Anthony Guido*
Nullius in verba http://en.wikipedia.org/wiki/Nullius_in_verba
-- Horace
learn.geraldguido.com
Twitter https://twitter.com/CozmoTrouble
Facebook https://www.facebook.com/gerald.guido.9
On Wed, Oct 1, 2014 at 9:22 AM, John M Bliss
Care to share the batch file?
On Oct 1, 2014 5:56 PM, Russ Michaels r...@michaels.me.uk wrote:
we have a batch file which we run via a windows scheduled task, we don't do
it via CF.
On Wed, Oct 1, 2014 at 7:10 PM, John M Bliss bliss.j...@gmail.com wrote:
And do you do it the way Gerald
ACF 10's isvalid(url) says that this is not a valid URL. What's your
favorite alternative to isvalid(url)?
http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path/page.htmvar=value
--
John Bliss - http://www.linkedin.com/in/jbliss
://www.validatethis.org/
On Wed, Aug 27, 2014 at 7:02 PM, John M Bliss bliss.j...@gmail.com
wrote:
ACF 10's isvalid(url) says that this is not a valid URL. What's your
favorite alternative to isvalid(url)?
http://www.domain.com/page.php?var=valuevar=valuevar=http://www.domain.com/path
[crickets] :-)
On Sat, Aug 23, 2014 at 10:13 AM, John M Bliss bliss.j...@gmail.com wrote:
Appears that my neo-cron.xml disappeared and neo-cron.bak is of size zero.
Trying to restore from backup. Any idea how this could have happened?
On Sat, Aug 23, 2014 at 9:48 AM, John M Bliss bliss.j
ACF 10,0,12,286680
This AM, when I login to the admin and click Scheduled Tasks, I get the
following error. Ideas?
The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code.
Null Pointers are another name for
Appears that my neo-cron.xml disappeared and neo-cron.bak is of size zero.
Trying to restore from backup. Any idea how this could have happened?
On Sat, Aug 23, 2014 at 9:48 AM, John M Bliss bliss.j...@gmail.com wrote:
ACF 10,0,12,286680
This AM, when I login to the admin and click
Here's a strange one: ACF 10,0,12,286680 Scheduled Tasks not attempted. I
have numerous Scheduled Tasks that run daily in the early AM hours. This
AM, it appears that none of them ran. No errors. The Scheduled Task page in
the Admin shows two types:
Duration Interval Last Run Next Run
Sep 17,
I hope this saves someone some time and I hope I'm not way late to the
RANK() party:
Let's say you have this table:
column1 - column2
A - 1
A - 2
A - 2
B - 3
B - 4
B - 4
...and you need to write SQL to return the most frequently occurring
column2 for each distinct column1:
A - 2
B - 4
Enter
Happy to not be the only one. 18 years in and I just learned about it today
(IIRC). :-)
On Aug 12, 2014 8:49 PM, Rick Faircloth r...@whitestonemedia.com wrote:
Nice!
I've never heard of Rank()...
On 8/12/2014 4:21 PM, John M Bliss wrote:
I hope this saves someone some time and I hope
http://cflib.org/udf/longTime
On Sat, Aug 9, 2014 at 8:40 AM, Phillip Vector vec...@mostdeadlygame.com
wrote:
So I want to display the time between 2 events (down to the second). I have
the following code..
cfset Years = #DateDiff(,
Leaderboard.CreatedOn,
I have a case where I need to have an application variable expire after a
known amount of time. Do you have a favorite method for doing this? I was
thinking of something like:
application.thevar = structnew();
application.thevar.createtick = gettickcount();
application.thevar.thevalue = foo;
flush that
region using CacheRemoveAll( region ) .
-Carl V.
On 8/7/2014 1:06 PM, John M Bliss wrote:
I have a case where I need to have an application variable expire after a
known amount of time. Do you have a favorite method for doing this? I was
thinking of something like
Are you talking about updating the page while end-user is looking at it? Or
do you just need to have it updated on load / refresh?
On Wed, Aug 6, 2014 at 8:03 AM, Mike K afpwebwo...@gmail.com wrote:
I have a radio station site, and I want to be able to update the pages
automatically as
, ASP.NET hosting from AUD$15/month
On Wed, Aug 6, 2014 at 10:17 PM, John M Bliss bliss.j...@gmail.com
wrote:
Are you talking about updating the page while end-user is looking at it?
Or
do you just need to have it updated on load / refresh?
On Wed, Aug 6, 2014 at 8:03 AM, Mike K
This is what I've used in the past: https://softbytelabs.com/en/BlackWidow/
On Aug 6, 2014 8:32 PM, Michael Dinowitz mdino...@houseoffusion.com
wrote:
Does anyone have a suggestion for a good application that can be pointed to
an url and then download every page under that url. For example,
In short, no. You'd have to deliver file to server via email / FTP / etc.
On Aug 6, 2014 8:36 PM, Phillip Vector vec...@mostdeadlygame.com wrote:
So I have a server that reads a file that is submitted to it and processes
the contents. I can not touch this server and change any settings on
...or HTTP post.
On Aug 6, 2014 8:39 PM, John M Bliss bliss.j...@gmail.com wrote:
In short, no. You'd have to deliver file to server via email / FTP / etc.
On Aug 6, 2014 8:36 PM, Phillip Vector vec...@mostdeadlygame.com
wrote:
So I have a server that reads a file that is submitted
In other words, if you have CF running locally, you could write something
that performs a cfhttp post to server...mimicking browse, select file,
click submit.
On Aug 6, 2014 8:42 PM, John M Bliss bliss.j...@gmail.com wrote:
...or HTTP post.
On Aug 6, 2014 8:39 PM, John M Bliss bliss.j
Maybe
http://www.andyscott.id.au/blog/getting-better-zip-support-in-coldfusion-with-zip4j
On Thu, Jul 31, 2014 at 12:18 PM, Richard White rich...@re-base.net wrote:
Hi,
What is the best way to encrypt a zip file in ColdFusion?
Many thanks,
Richard
https://www.copy.com/s/i0LSL1n8A6QC/ColdFusion%20Installs
On Sun, Jul 27, 2014 at 10:59 AM, Richard Colman rcol...@cox.net wrote:
Does anyone know where to find a download of V. 10 ... Adobe only seems
to have Coldfusion11 available.
TNX if you can help.
-- Rick
Here's the official replacement for cfgrid. Double-quotes because
there're many way to replace cfgrid...this is just one suggestion.
https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md
On Tue, Jul 22, 2014 at 1:34 PM, Andrew Scott
One such tool: http://tools.pingdom.com/fpt/
On Sun, Jul 20, 2014 at 9:20 AM, Russ Michaels r...@michaels.me.uk wrote:
this sounds like a network issue.
You have not mentioned if you are connecting on a local network or across
the internet, but the fact that it works on the local machine,
Check out https://wikidocs.adobe.com/wiki/display/coldfusionen/EncryptBinary
including example at bottom.
On Thu, Jul 17, 2014 at 4:10 PM, Bryan Stevenson
br...@electricedgesystems.com wrote:
Hey Rick,
You can use more secure forms of FTP as opposed to getting that
draconian - just a
Hope to save someone a bunch of time:
http://www.brandiandjohn.com/post.cfm/oauth-2-google-and-cfml-without-cfoauth
--
John Bliss - http://www.linkedin.com/in/jbliss
~|
Order the Adobe Coldfusion Anthology now!
Warning: I'm side-stepping your question for a moment...
Best-practice is now to use the following (or similar) in place of
cftextarea:
https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cftextarea/index.md
Now, back to our regularly scheduled thread...answer to
Interesting. Can you provide an example where that'd be useful?
On Sat, Jun 28, 2014 at 1:05 AM, Dave Watts dwa...@figleaf.com wrote:
Official list:
http://www.adobe.com/products/coldfusion-enterprise/features._sl_id-contentfilter_sl_featuredisplaytypes_sl_new.html
Your needs are
Official list:
http://www.adobe.com/products/coldfusion-enterprise/features._sl_id-contentfilter_sl_featuredisplaytypes_sl_new.html
Your needs are almost surely different from ours...however...in case it's
helpful, my boss asked me to order these from most important (for us)
through least
I'm working with a vendor to troubleshoot an error and he's asked me to
*not* replace with amp; etc in a URL field. I'm building an XML doc
with xmlnew() and then posting it with cfhttp method=post and I'm not
explicitly calling urlencodedformat() or anything. CF is just automatically
and (I
ttp://myurl.com?x=ya=b';
Most XML libraries for other languages will read CDATA just like they
would a non-escaped node.
On Jun 17, 2014, at 2:33 PM, John M Bliss bliss.j...@gmail.com wrote:
I'm working with a vendor to troubleshoot an error and he's asked me to
*not* replace with amp
Element. This changed my XML from this:
Urlhttp://myurl.com/?x=yamp;a=b/Url
...to this:
Url![CDATA[ http://myurl.com/?x=ya=b]]/Url
...which, I guess, was the desired effect. Now, response I'm getting has
changed to, URL 'http:// http://myurl.com/?x=ya=b' is not in the expected
format.
SOLVED: URL had leading space. trim() fixed it. Thanks! :-)
On Tue, Jun 17, 2014 at 3:10 PM, John M Bliss bliss.j...@gmail.com wrote:
Element. This changed my XML from this:
Urlhttp://myurl.com/?x=yamp;a=b http://myurl.com/?x=ya=b/Url
...to this:
Url
