The last few days, my production webserver has had an issue with Java
unable to create cache files. This is triggered when firing a cfimage
tag, pointing at a graphic file in the filesystem, the purpose of which
is to retrieve the width/height values.
As best I can tell (as this is generally
Another method, assuming you're using MS SQL Server (not sure how far
this goes back compatibility-wise) is to toss in the criteria for the
full search, but then to only pull back X rows:
WITH Results_Full AS (
SELECT Field1, Field2, Field3, ROW_NUMBER()
OVER (ORDER BY
On the subject of jQuery-based tooltip solutions, I recommend giving
Tipped a looksee.
http://projects.nickstakenburg.com/tipped
Lots of options available for styling tooltips.
--Scott
On 12/22/12 10:36 AM, Billy Cravens wrote:
You can't add a class to the cftooltip tag itself. Personally,
Lately I've been furiously modifying my main work project codebase,
going through old (old!) code bits and reworking where I could, to
modernize (i.e. take advantage of functions/tags that didn't exist back
in the day) and/or just increase efficiency. I fully expect my keyboard
to just say
Hey all,
Hoping one of you guys who are CF folks but also know something on JVM
and heap memory management (and how CF affects heap usage) can shed some
light on my situation.
Basically my server (CF9 on Linux) has been having heap memory issues
from the get-go. And this is after moving
I believe the jquery show()/hide() functions use the display attribute
and not the visibility attribute. Not long ago I switched over from
using Prototype to jQuery and had to recode hidden divs to use those
jQuery functions.
On 12/16/12 12:38 PM, Steve Milburn wrote:
My personal preference
Hey gang -
Running CF 9.0.1 on Linux, also running FusionReactor for monitoring.
Let's get that out of the way :)
I have an old export utility that writes out to Excel (using Ben Nadel's
POIutil) and I'm exploring migrating that over to using CF9's
cfspreadsheet functionality. Thanks to a
I don't recall if there's an easy config setting to turn off uploads,
but it's not difficult to go into the relevent code and comment out the
upload button.
Are you still on FCKEditor or CKEditor (i.e. v2 vs. v3)?
On 12/30/11 4:21 PM, Terry Troxel wrote:
Is it possible to safely use
BoogieTools does have a Linux version now - and according to the
BoogieTools contact guy, it's a shared object.
I'm not finding any real helpful info on how to use CF (or in my case,
Railo - even if CF9 does it, Railo may not) to connect to and interact
with a shared object, though.
Anyone
Is there anyone out there using BoogieBounce for bounce processing in a
CF/Linux environment?
I've been using it for the last few years in a Windows environment, but
we've been switching over to Linux. The Linux version of the trial
download doesn't reference CF at all, and the method to fire
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
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
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.
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
Re: good code:
I've done this once (and am about to do it again) so I'll share a few
bits that I learned re: code changes:
99% of my code was fine. But I had to adjust some syntax.
MSSQL vs MySQL:
LEN needs to be LENGTH
CHARINDEX needs to be LOCATE
There probably are more differences like
I've done some digging on this and everything I'm finding is ancient
(circa 2007).
Today I started getting a corrupt table error with every query that
has a cachedwithin set on it on one of my servers.
On another server, a backup for the main server, with (as best I can
tell) the same CF
Yes, and I had that in my one-off test - just removed the * and
specified a field, but no change, the cache-set query still bombs.
Again, this is code that has worked fine for years.
More on the timeline though - my server guy was doing a bit of tinkering
this morning (while I was doing some
I should also add that this is happening across multiple datasources on
the affected server, not just the one that my server admin guy fiddled with.
On 4/25/11 12:17 PM, Scott Weikert wrote:
Yes, and I had that in my one-off test - just removed the * and
specified a field, but no change
Well, finally got my server guy to cycle the CF service on the affected
box - and now queries with cachedwithin set seem to work fine.
I suspect somehow his fiddling with a DSN setting (which one, I'm
unsure) somehow tripped this ancient bug, and a service cycle cleared
that particular deck.
Hey gang.
It seems that (in CF8) using IsValid() to check for valid email
addresses has an issue.
I've got a system where folks can upload data files to get dumped into
DB tables. Sometimes, these data files end up with extra odd invisible
characters on the end of some fields (junky source
Oh, it's easy enough to work-around. Doing that now.
I'm just saying, it looks like a bug that *shouldn't* need work-arounds.
Jason Fisher wrote:
As a hack to your script, how about adding a simple string test?
cfif not isValid(email, emailVal) or emailVal is not trim(emailVal)
... handle
Basically, yeah. That's a good way to put it - it's doing an implicit trim.
The string going into the IsValid is a legit email, followed by some
other characters - not just spaces.
Those extra charactesrs *should* trip the validation and return false -
but it's not. And even if it were spaces
Hey gang -
In the middle of a project and have run across an oddity, and I have yet
to find any answers - I'm under the gun here.
Working on migrating our main database from MS SQL Server to MySQL. So
far so good.
Two different versions of CF running on different boxes - CF8 (works
great)
Rob Parkhill wrote:
Awesome form protection
http://cfformprotect.riaforge.org/
I second that. I've been using CFFormProtect for a while now with good
results.
~|
Want to reach the ColdFusion community with something they
Well this may sound goofy, and if it's a bad idea, say so...
But why not use a RegEx to pull the table tag out of both bits of
content, then scan over using list functions, using a space as a
delimeter to start, then = as the secondary delimeter, build up a
structure of attributes and their
Is there any reason you can't simply lock the app scope, grab
application variable and put it into a local variable, unlock, lock
session, copy from local var to session var, unlock?
~|
Want to reach the ColdFusion community
Hey gang -
Having some issues with cfflush not... flushing. :P
Same page, same code, running on two different servers - flush works on
one, not the other.
Both servers are sporting CF8, but the underlying platform is different
- Windows 2k server (working) vs. Windows 2003 server (not
Oh I've been through this.
What the issue is is, DW *hates* p tags without closing /p tags.
And opening a file with p tags, it will sometimes rejigger perfectly
valid tags.
Lost count of how many times I would start with
/cfcase
/cfswitch
in my code and then save my changes, to find that
Casey Dougall wrote:
In preferences,
code Rewriting make sure fix invalidly nested and unclosed tags is
UnChecked. Also, never rewrite code: .cfm should be listed in the filetypes.
Does that work for you? Because on my copy of DW CS3, I've had that
option unchecked for months... but
If it's an either/or issue, then I would rework your CFC to add your
select a category option to the data being returned.
I assume you're currently doing a simple query and dumping that query
out - so you may have to rework that a bit. *shrug*
Well as you loop on the 0, 1, 2, spitting out 0|0, 1|1, 2|2, etc...
Why not, before the loop, create a variable, and do a ListAppend on it
each time?
like
cfset listVar = ''
cfloop from=0 to=20 step=i
cfset sidewalls_Quantity[i] = new Array()
cfset thisValue = #i#|#i#
cfset listVar =
Hey gang -
Been tinkering with the bind options on the cfselect etc. bits today.
Works great. A lot less code/hassle than doing it using Prototype/etc.,
which is what I've been doing the past couple of years.
But - the one thing I'm not finding any good info on, is how to present
the user
If I'm reading you right, you want the *first* part of String2 to match
the entirety of String1...?
If so, you could use the Left() function, i.e.
cfif Len(string2) GE Len(string1) AND Left(string2, Len(string1)) IS
string1
match
/cfif
If you're just looking to see if String1 is *in*
Ian Skinner wrote:
If you set up a ColdFusion template as a custom 404 error page in your
web server. Is there a way for this code to know what URL was requested
that resulted in the 404 error?
I've dumped the cgi scope and the getHTTPRequestData() structure and
neither of these seem to
Ian Skinner wrote:
I have this line set up for the Apache server.
We're on IIS. So that may make a difference.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Fiddling around with the new cfimage tag goodies lately - fun fun :D
I've been tinkering with the image tools to take a data set, plot points
onto a grid, toss the image out via the writetobrowser action. Works
like a champ.
But now, I'd like to try and use the resulting image as a background
Raymond Camden wrote:
Why not just save the image? I generally recommend folks only use
writeToBrowser for testing. Yes - you can generate images on the fly
and show them to the user. But if you get any kind of load you really
want to start saving those images to the file system.
Thinking
Well thinking about it MORE, I really *do* need to write the images
right out to the browser.
The sheer number of combinations of the data preclude pre-writing out
the images to the file system - it would be a huge number of files.
But I figured out my background issue. I'm just using a pair
Brad Wood wrote:
I suppose perhaps Scott could chime in and tell us if he truly wants
one-time-use, throw-away images, or if he is hoping to save them and
reuse them for multiple page requests later or even archive them for
later retrieval.
I guess that's my cue. :D
Ok a little
I had to deal with this same issue some time back...
Here's what I do.
First, I create a temporary table for the import, and do a dump into
that, straight up. I create an identity field so that every record has a
unique integer value to use later.
I run updates on the fields in that table to
Christopher Watson wrote:
Just to verify: one cannot establish a repeating Scheduled Task with a start
time in front of Midnight (PM), and and end time after Midnight (AM).
Correct? If one wants such a thing, you'd have to create two tasks: one that
handled the PM times, and another to
Hey gang -
Got a little personal side project I've been working on lately, and I've
come across a small stumper.
What I have is a GreaseMonkey (FF plug-in) script that will do a
screenscrape of a particular page, package up the needed data into a
query string, and push it via HTTP to my CF
Hey gang -
I've googled around a fair bit, poked in the prefs, but no love yet.
Hence, this post.
I recently picked up a new Mac tower (sweet!) and I've got Dreamweaver
CS3 loaded up. All works fine except for one annoying issue - with
certain files, Dreamweaver is changing my code when
I'm working on a little app that I need to be able to store and retrieve
strings with Unicode characters in them, using MySQL (version 5.0.37).
I'm able to create a table (via phpMyAdmin), set a field to use utf8 in
varying ways, and do an insert (again via phpMyAdmin) into said field of
a
Hosting support killed the old DSN and created a JDBC one - works fine
now. :P
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Our server guy is getting ready to do some major work on our DB server
(MS SQL). I'm trying to get the CDATA/CGLOBAL tables trimmed down so
that the DB will copy off that box over to a temp DB box easier.
I've set the purge unvisited setting for the client variables down to
one day (we don't
The data in my CDATA/CGLOBAL tables finally ended up getting flushed -
just had to be patient. :)
Nevermind!
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how
erik tom wrote:
Tell me how. I am calling the function like this input id=moveUP
name=moveUp onclick=moveUp(-1) and the same for movedown . And it works
my question is how can i update the database
With your moveUp(-1) call, are you passing just a -1 or are you also
passing whatever
Like the other fellow said, the items in your second select box aren't
'selected' so they don't pass through.
To do that, you'll need to run a JS function when submitting the form.
Here's the one I use:
function selectAllOptions(obj) {
if (!hasOptions(obj)) { return; }
for (var i=0;
Rich wrote:
That's from the same package I directed him to, except that you did not
include the hasOptions(obj) function to make this useable.
*bonk!* Correct.
~|
Enterprise web applications, build robust, secure
scalable
Hey folks,
Still having this issue, and would like some more eyes on it, if
possible. Below is my original post from earlier this week.
I'm getting an odd error when using cfqueryparam. I've got the type
set to cf_sql_integer - the value I'm passing is an integer (even
throwing Int() into
Well I dunno how to do such a regex, but here's an alternate idea:
Make a copy of your codebase to another folder.
Do a find/replace on THAT folder, deleting all your commented code (i.e.
starting with !--- and ending with ---). I imagine you could tweak
your existing regex you're using to
I've got a CMS-ish type project heading my way, and was pondering using
FarCry for the first time with it.
I've got some questions that I'd like to ask someone who's been around
the block with FarCry.
So - anyone out there that fits that description, and is willing to
field a few questions
I'm getting an odd error when using cfqueryparam. I've got the type
set to cf_sql_integer - the value I'm passing is an integer (even
throwing Int() into the mix - and yet, I'm getting the error:
[Macromedia][SQLServer JDBC Driver]Value can not be converted to
requested type.
However, when I
Gaulin, Mark wrote:
Are you positive that the datatype in the database for that field is
really int? Could it be different in the two environments (which I
assume have different db servers)?
Quite certain. It's the primary keyed identity field in the given table.
The dev database is a
Kim Hoopingarner wrote:
using the FCKEditor, I see br / being put into my database when storing the
editor's output. When I go to select it out of MYSQL, the br / is missing
from the string therefore causing the web page formats to be wrong.
Does anyone know how to correct this?
Kim Hoopingarner wrote:
Yes - I did all the debugging already. I see in MYSQL the br / that
FCKEditor submitted. So the page submit inserted it fine.
My problem is when I do a SELECT * FROM TABLEA. The SELECT is removing the
br /. And the form trying to display that column loses its
Chad Gray wrote:
I am taking a page and sending it to CFDocument for a PDF.
Is there a way to kill all hyper links on the page so there are no hyperlinks
in the PDF?
Why is this a Javascript question?
Just do some regex fun on your output content, stripping all anchor
tags, before
I think you meant to use get_events.currentrow.
And, all other things being equal, you might try:
td style=padding-top: 1px; padding-bottom: 2px; width: 35px; border-left:
1px solid ##aaa; border-bottom: 1px solid ##aaa;
background: ###IIF(get_events.currentrow mod 2, DE(eee), DE(ccc))#;
Tom Chiverton wrote:
On Wednesday 26 Sep 2007, [EMAIL PROTECTED] wrote:
Sack your server guy. He should know better to back things up, because
if something goes wrong how does he expect to roll back?
Second that.
He performed an unannounced upgrade to a live server, without taking a
Tom Chiverton wrote:
Howso hard ? They're standard for a reason.
I think he's saying, that there's no way to override the settings
without hacking the config files - which are shared across the board.
And there's MANY things in the main FCKEditor package that I think ought
to be
My server guy upgraded my development server from CF 6.1 to CF 8 earlier
today. Yay.
In doing so, he blew away all my scheduled task info. Grr.
Is there anywhere one might recover that info (file system, registry,
etc)? Enough info to reset them manually?
Talking about a Win2k server
Andrew Peterson wrote:
Hello, I have a mass email which times out due to our shared server's timeout
of 60,000 ms. (It takes longer than that to process the page.) I could loop
through and send out 2000 emails at a time, but I am still stuck with having
the client wait and click on âSend
Brad Wood wrote:
Those are stored in coldfusion_root\lib\neo-cron.xml
That's where they're stored in CF 8. I'm asking where they were stored
in CF 6.1.
Fortunately, the CF6.1 files are still there - so if I can figure out
where to look in THOSE, I should be good.
You made a backup the
Scott Weikert wrote:
Brad Wood wrote:
Those are stored in coldfusion_root\lib\neo-cron.xml
That's where they're stored in CF 8. I'm asking where they were stored
in CF 6.1.
I should clarify - on my dev server, there's still the old CFusionMX
folder on the C drive, along
Gary McNeel wrote:
Essentially, I would like them to be able to go to:
www.somesite.com/theirUserName and it would redirect them their area. If
they went to www.somesite.com/theirUserName/somePhotoAlbum it would redirect
them to a that photoAlbum.
I know I can look at the URL and pull out
I do cfdumps on the form struct all the time...
You sure it's present in that case? Try sticking
#IsDefined(form)# and
#IsStruct(form)#
somewhere in there as well
~|
Get the answers you are looking for on the ColdFusion Labs
Ah *bonk* I missed the bit where he tried to SET form to something.
Nevermind my comment. :P
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
I've been using CF_CAPTCHA for a while now, and it's old enough that the
spambots have 'cracked the code', so to speak, and is nigh useless.
Anyone out there have any recommendations on a good, CF-based (or non
CF-based, but can be easily used from within CF) CAPTCHA solution that's
a bit
Michael E. Carluen wrote:
Have your tried CFFormProtect? http://cfformprotect.riaforge.org/
Looks neat - I'll give it a looksee. Thanks Michael!
~|
Download the latest ColdFusion 8 utilities including Report Builder,
Will Tomlinson wrote:
+1 on cfformprotect. works like a champ!
That said, what's the peanut gallery's opinion on ditching CAPTCHA in
favor of CFFP, or using both in conjunction?
~|
Get involved in the latest ColdFusion
Johnny Le wrote:
Would you please tell me how I can fix it so that ColdFusion would handle the
error on the second server instead of the IIS?
CF Admin, main Settings area, Missing Handler Template.
~|
Get the answers you
Johnny Le wrote:
Thank you. That wasn't my question though. I just want to know why on one
server, ColdFusion handles the error and on the other, IIS handles the error.
Are there any configuration somewhere either in the IIS or CFadmin that
dictates which one to handle the error?
See
Try setting it up like:
cfset CacheTime = CreateTimeSpan(2,0,0,0)
or
cfset CacheTime = CreateTimeSpan(0,0,0,0)
and then
cfquery cachedwithin=#CacheTime#
~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and
Michael David wrote:
I did originally ponder simply sending messages to each carrier's email
gateway, but the effort required to track down all those email addresses
seemed a bit daunting. In addition, I would not be surprised to find
that many of the smaller carriers don't provide such a
Hi folks -
I've got a small issue with my project. By 'small' I mean, it's a bit
annoying, and nothing major, doesn't affect performance, it just BUGS ME
and I'd like to figure a way to get around it in a better way.
So we've got our site on a domain (let's call it 'domain.com') and our
[EMAIL PROTECTED] wrote:
I'm using this very simple server side imagemap to send coordinates my
results script of where the user clicked on the image. My questions is how
can I extract the x and y coordinates once it's passed as ...
http://www.domainname.com/map.cfm?231,266
Can't you
Ian Skinner wrote:
Instead of a page with content to try and head off the robots, you could
try sending the 410 Gone HTTP Status Code:
410 Gone
Good idea - for when I get the rest of my issues figured out (i.e. how
to centralize all the folder related stuff). :D
I'm realizing
Ian Skinner wrote:
That should be fairly easy to do then.
I would think your index.cfm page could have logic to determine that the
requested 'sub' site does not exist and serve up a 410 header with the
appropriate cfheader tags within the index.cfm page.
Just got back from being away
Ian, thanks much - I didn't think it was quite that simple. :P
I'll give that a go and see how well it works.
~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
One last bit on the fake folder front - more of a philosophical
question, not techie per se -
Like I stated before, clients can create a mini-site and give it a code,
which is used as the folder name. And then they can delete that site,
deleting the folder that was created for it, and then web
Well a final report on the fake-folder situation, for those of you who
might find it useful:
Turns out there were two bits I had to do:
1) set the missing template header in the CF admin to point at my
handler script (cleverly titled missingTemplate.cfm)
2) set the '404' custom error in IIS for
Japanese porn? Rock on!
:D
Just kidding. It's never fun to put a lot of effort into something and
see it trashed.
--Scott
~|
ColdFusion is delivering applications solutions at at top companies
around the world in government.
Joel Watson wrote:
So let's say that my form has 20 hobbies/interests. I would be creating 20
entries in this middle table, correct? Is this going to create a problem if
I have hundreds of users?
No, you'll have twenty entries in the 'hobbies' table. The middle table
- the lookup
Rich wrote:
We are doing some heavy SMS work, and currently utilize Openmarket (formerly
known as Simplewire), which is a SMS aggregator. We are using their JAVA
SDK and are rather happy with the results.
I assume you're talking about this?
http://www.openmarket.com/messaging/overview.jsp
John Blayter wrote:
If you are going for 2 way I would use MX Telcom. They are super
reliable and I have never had a problem with them. If you are just
doing 1 way then I would suggest Clickatell. Whatever you do don't use
BulkSMS as they don't deliver to all carriers in the US.
Well
The direct-to-carrier bits would work fine for me - as I'm just looking
to set up alerts for myself.
A little googling yields THIS wonderful page:
http://en.wikipedia.org/wiki/SMS_gateways
Scroll down to the Email to SMS section and it lists a TON of email
address formats for different
I assume you're doing a cfoutput or cfloop on the query results
directly, as you said you don't know the year is 'til you output.
One way might be to create a structure, loop over your query results and
populate the structure as you go - then you can look at that structure
and see where the
Messing about with logging scheduler events. I'm seeing what I expect -
executing and rescheduling entries - but I'm curious if errors in
scheduled tasks get logged here as well as the normal
application/exception logs?
--Scott
Tom Chiverton wrote:
I've not tested on CF, but in kRegExpEditor, (.)+ would match that portion
of the string, so I'd expect it to vanish as indicated.
Ahh - because that's not what I sent. I wonder if it didn't get mucked
with in transition.
(.|\n)+?, or more spelled out to be safe,
JB Cameron wrote:
We are trying to figure out a way to right text files to a user's local hard
disk via a coldfusion page. Anyone have suggestions? Is this possible if the
user trusts our website. Thanks for the input.
Write vs right? :D
Can't be done, as far as I know, like the other
NUGROHO NOTO wrote:
I am looking for those script which can strip the HTML part.. but still can
retain the carriage return (otherwise my text will just continue without
break)
anybody knows where we can get / buy this custom tags ?
Sounds like a three-step thing to me.
First, find all
It sounds like you're wanting to do your own action with your form data,
using your own code, but then also pass the data onto a shopping cart
app that you can't/don't want to hack.
Point your main form at your own code - do your own jiggling with it -
then simply output a new form with hidden
Tom Chiverton wrote:
strip out all content that starts with a . :-)
Heh, you saying the less-than character got stripped for you? Or that
the regex is goofed? :/
~|
Get the answers you are looking for on the ColdFusion
Since it looks like it's going to take a good while for us to get this
book in our hands...
A question to Ben - any chance folks can acquire the book directly from
you quicker?
:D
~|
ColdFusion 8 - Build next generation apps
Andy Chen wrote:
Now the reason that I heard is that it was disabled in the first place is
that the FCKEditor file manager isn't too good (which I can agree) and there
is a potential security problem which can happen if you do this... what is
the security problem? Besides seeing a bit of
Dunno how to do this from CF, but Excel allows you to set a format for a
cell.
So if you set the cell format as 'text', it won't strip the leading zeros.
I just fired up Excel, set one column as a 'text' format, the next
untouched, and typed in '01234' in both. The first one (text column)
1 - 100 of 436 matches
Mail list logo