Our company has a lot of legacy FoxPro still running. As I understand
it, though, support for Visual FoxPro 9 ended April 2010. It is
certainly not a living product, despite the fact that Microsoft did
release several versions of Visual FoxPro after they bought the line.
On 10/7/2010 5:56
ds.
>
> The result set should only be the 10 missing records
> present in properties_copy that are not in properties.
>
>
>
> -Original Message-
> From: Jason Fisher [mailto:ja...@wanax.com]
> Sent: Sunday, October 03, 2010 3:39 PM
> To: cf-talk
> Subject: Re
Can't you just do this?
SELECT p.mls_number
FROM properties p LEFT OUTER JOIN
properties_copy pc ON p.mls = pc.mls
WHERE pc.mls IS NULL
AND p.mls = 'hmls' (wouldn't need this bit unless you really only
want the 'hmls' records)
On 10/3/2010 3:12 PM, Rick Faircloth wrote:
> select
As I understand it, the files are not actually "sent" in any MIME type, per
se, but the receiving browser interprets MIME type based on its coding,
which, as you found out, is determined by both OS and browser settings. As
far as I know, there's no way around it, especially since the browser o
Actually, I don't use ORM for much the same reason I don't use cfinsert /
cfupdate. I still like to craft my SQL and I often have complex relationships
that are easy to write in SQL and a PITA to model in an ORM.
- Jason
"Smokey the Bearâs rules for fire safety also apply to government: Keep
Well, he's completely right, of course. Personally, I really like to have the
control over my SQL statements, just like I do over my other code, so I write
them out. Allows me to test for NULLs (empty integer fields, for example) or
to build computed fields or wrap sequences of queries in cft
Assuming your pages are in a database-driven system, then the custom 404 is
largely just an extension of ColdFusion serving pages: which page? dunno,
lemme check the aliases, ah, there it is ... this page. Web server rewrite
is fine, too, but if the code is already running in CF to determine
If it was MSSQL, you would want single quotes, so more like this:
SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on
views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 0 = 0
AND categoryname IN ('''s') ORDER BY viewname ASC LIMIT 0, 300
Instead
Beat me to it, Phillip, but she'll want ceiling() to get the upper 1000:
From: "Phillip Vector"
Sent: Thursday, September 16, 2010 10:54 AM
To: "cf-talk"
Subject: Re: Rounding Numbers
Couldn't you divide it by 1000 then round, then multiply by 1000?
Or instead of using a variable, if you can just put the clause in the SQL
statement, let the list param do the work for you:
HAVING categoryname IN ( )
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Ad
Also keep in mind that many, many CF projects are internal-only within their
organizations.
- Jason
"feed me moar web2 loafmeat"
From: "Andrew Scott"
Sent: Wednesday, August 25, 2010 1:01 PM
To: "cf-talk"
Subject: RE: Number of site using ColdFusion
Seems like the error isn't really giving much help.
Can you get full debugging from that error on jobs.cfm?
Can we see the code on and around line 346 of jobs.cfm?
- Jason
"feed me moar web2 loafmeat"
From: "daniel kessler"
Sent: Wednesday,
Yes, CFHTTP is your buddy here. Just enter the actual column names that
are coming back in your search query in the 'columns' attribute, and try
this:
https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp
" port="443" name="mySearchQuery"
columns="whatever,columns,are,comi
Depending on what you need to replace those chars with, this will simply
remove them:
(I assumed that 13 & 10 were a single EOL set, but you could add a comma
in between there and in the replacement set, if needed.)
- Jason
On 8/22/2010 6:49 PM, Matthew Smith wrote:
> I am trying to write
It's because you re-used the variable names startDate and endDate, so you
re-wrote the value of each variable to strip out the time and then asked
for the time. Always be sure to 'var' all variables in a function, and
you'll avoid the snafu. If you do the following, you'll even get a runtime
I do exactly that, Rick, and it works fine. All my app vars are set in
onApplicationStart, except for the constants like 'name', which I set
outside the methods:
this.name = "myAppName";
this.applicationTimeout = createTimeSpan(0, 8, 0, 0);
...
Think iframes or Ajax calls or other types of situations where A User may
be session-linked to more than one current thread / process. In those
cases, if there is potential for simultaneous writes to a session var, then
you could theoretically have a clash. If your app uses no Ajax and has no
Makes sense. Clearly, if you were testing for "ID = '#myVar#'", then the
number of variances would make caching irrelevant, but it sounds like this
case might be a good candidate.
~|
Order the Adobe Coldfusion Anthology now
Well, that code will create a separate cache for each version of the
variable query statement.
Cf
http://forums.devshed.com/coldfusion-development-84/cfml-cfquery-cachedwithi
n-does-changing-order-by-create-new-query-680793.html
In other words, I think it will work the way you expect.
Also, note that CROSS APPLY works just fine in ColdFusion. Anything that works
in SQL Server can be put between the CFQUERY tags. ROW_NUMBER() and PARTITION
will also work for you. Try this:
SELECT catg,
nltitle,
nldate
FROM (
SELECT n.catg,
Les,
If that gives you mostly the right answer, then you can consolidate your two
queries into one with a sub-select, instead of the valueList():
SELECT TOP 5 nl_hed,
nl_date,
nl_id,
nl_title,
goodURL
FROM nl_m
+1 for Longtail. Yes, it's commercially licensed, but it's not
expensive and the feature set continues to grow. We use it on both CF
and .NET sites, because it just runs anywhere that uses JavaScript; it's
not platform-dependent.
On 7/22/2010 4:02 PM, Maureen wrote:
> I'm with Dave on Longt
Elsewhere on HoF ...
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335322
> Last night our server admin went through all of our development and
> staging boxes and applied the 9.0.1 patch. Most of these upgrades
> when fine, however, one collection of machines - for some r
> I dislike .Net but it certainly was simple there. It took 3 lines:
>
> db = Session("DBpath") & "myDB.mdb"
> Dim myFile as FileInfo = New FileInfo(db)
> Dim ModDate as Date = myFile.LastWriteTime
>
That makes it look like the path was really just in a Session var in .NET; is
Problem's not the concatenation, it's just the browser interprets anything
between < and > as tags, so they're hidden by design.
Once you have your list, try this:
#htmlCodeFormat(the_from)#
or this:
#htmlEditFormat(the_from)#
From: "daniel kessl
Try this (you don't need the middle bit if you never use SSL):
On 6/8/2010 6:28 PM, Dave Burns wrote:
> In my Application.cfc's init code, I'm trying to set a variable in the
> application scope that is the base URL for the pages in the app. I need this
> to overcome some issues later wi
e
most part, so I'm really clueless now that I need it. I've tried reading
through the documentation but it all seems like Greek to me. How can I test
for the combination of those three characters?
Deb
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: Mon
Especially true since any tag can be called from any location with
CFMODULE.
From: "Dave Watts"
Sent: Monday, June 07, 2010 4:26 PM
To: "cf-talk"
Subject: Re: List Of Custom Tags
> Is there any possible way to pull a list of all custom tags available?
Assuming that those are tabs between the elements, the following will
expand on Andy's suggestion.
#mid(testString, test.pos[2], test.len[2])#
From: "Andy Matthews"
Sent: Monday, June 07, 2010 3:32 PM
To: "cf-talk"
Subject: RE: RegEx help
If you ca
Easy enough to come up with a handler that will wrap CFDOCUMENT around
your page content and include the relevant CSS to produce a PDF, but
there are still issues with content flow. You really can't easily
control page breaks and page flow in the transition from the 4:3 or 16:9
screen ratio t
Don't know if anyone pointed this out, but cgi.server_name doesn't include the
protocol (like 'http://').
So, your test should be more like so:
http://www.domain.com";>
~|
Order the Adobe Coldfusion Anthology now!
http
zoneedit.com is really solid, despite the look of their site. Been
really happy with their servers and the ease with which I can manage
domains there. After the first 5 domains, there is a monthly fee, but
it's not much.
On 6/3/2010 11:09 AM, Chad Gray wrote:
> Hello, we are going through
Can't speak for others, but it's a real challenge for me because I may
be primarily working on "one application" at any given time, but I also
support many other legacy applications. These are all, in fact, in one
web root on the web server, but each is an entirely separate site and
applicati
A little different for radios: use checked="checked", but, yes,
otherwise the same.
checked="checked" />#thisText#
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz
fmeat"
From: "DURETTE, STEVEN J (ATTASIAIT)"
Sent: Friday, May 21, 2010 10:17 AM
To: "cf-talk"
Subject: RE: ColdFusion memory leaks
You don't have to worry about load balancing them even if you have
multiple datasources that point to the same database server?
-----Origi
Another option might be to have the auto-suggest test ONLY against article
titles and return a list only of article titles, even though the search
might cover body content and other things as well. Would at least reduce
the overhead of the auto-suggest while at the same time returning
specifi
Wow, CrystalTech has been nothing but great for me. Solid beta of CF9 before
they released it commercially, too, so they are definitely on the ColdFusion
train. Not sure why you got a bad tech there, but that has certainly never
been their attitude to me, and I've hosted with them for years.
www.crystaltech.com
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message
CFCOLLECTION can return a list of all collections as a query, so then just QoQ
that:
SELECT *
FROM existingCols
WHERE name =
~~~
use the
same settings for each data source, or do you split that 5 * CPU cores
across the data sources?
Steve
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: Friday, May 14, 2010 7:37 PM
To: cf-talk
Subject: Re: ColdFusion memory leaks
In addition to the other good
One way is to set vars after each upload:
The other way (if you're not on CF6.1 still) is to use the result param:
On 5/16/2010 9:32 PM, Terry Troxel wrote:
> If I have a form with two form fields pic1 and pic2, how do I get a return
> variable cffile.serverfile for each after a succe
In addition to the other good suggestions so far, check your datasource
settings. It is often the case that datasources are allowed to have a
huge number (or even infinite) connections to the database, and there
are often excessive timeout values with each datasource as well. If CF
sits pati
We just implemented 6.20 (1.6.0_20) on a new server with CF 8.0.1 and
it's running fine.
On 5/12/2010 5:24 PM, b...@bradwood.com wrote:
> I would recommend anything later than updater 10. Just make sure you
> get the JDK and not just the JRE.
> I'm using 1.6.0_12 on my CF8 servers.
>
> ~Brad
Ben, thanks for the updates and glad to hear they're working on it.
- Jason
On 5/12/2010 4:01 PM, Ben Forta wrote:
> Ugh. Engineering team was able to recreate the issue on 64bit CF, but some
> are seeing it on 32bit CF, too. They are working on a fix right now. If you
> have yet to apply the pa
Cross-posted from the comments on Ben's blog, but I saw it on my development
machine at work, Windows XP, still 32-bit, so don't count on it being only
64-bit ...
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.
Just a note to let people know that several of us have had trouble with this
hot fix.
http://forta.com/blog/index.cfm/2010/5/11/ColdFusion-Security-Hotfix-Released#comments
~|
Order the Adobe Coldfusion Anthology now!
http://
+1 to making it a custom tag in the server's default custom tag directory.
> Definitely a custom tag or a
cfc seem like overkill.
Custom tag is just that: a bit of code that can be called in a single tag,
that's all. Nothing 'overkill' about it to implement for a simple
computation. se
If you just want to style it, the template (on CF8) can be found here:
C:\ColdFusion8\wwwroot\WEB-INF\debug\classic.cfm
I don't usually reskin the output, but I often tweak, for instance to suppress
the CGI.auth_password etc.
> Fellow CFers:
>
> I have been developing using the wonderful tool
e results or would I
> have to r-index the collection?
>
> Thanks again
>
> --- On Fri, 5/7/10, Jason Fisher wrote:
>
> From: Jason Fisher
> Subject: re: Setting up a Site Search
> To: "cf-talk"
> Date: Friday, May 7, 2010, 10:48 AM
>
>
> Verity i
Verity is simple to use, I assume Solr is similar. The instructions here are
for CF8.
Create an Index of your files, first decide where you want the INDEX files:
Then point at the directory of files you want to put IN the index:
Once that runs, you will have results of the indexi
No, it comes with Solr, an instance of Lucene.
From: "Rob Barthle"
Sent: Thursday, May 06, 2010 10:56 AM
To: "cf-talk"
Subject: CF9 Developer Edition and Verity?
I can't seem to find anything concrete on this. Does the CF9 Developer
Edition not come w
OK, that's some pretty sloppy HTML, but let's see. Same principal
should work:
myVar = reReplaceNoCase(myVar, '<\s*a ', '
>> how about simplifying?
>>
>> replaceNoCase(myStr, '> ', 'all');
>>
>> [note the training space in the test and the replacement]
>>
> This doesn't work for:
>
>
CFParam, unless you want to go the multiline route:
But you can't go
because value="#form.myVar#" will fail to compile if form.myVar doesn't
exist.
From: "Dave Watts"
Sent: Monday, May 03, 2010 12:05 PM
To: "cf-talk"
Subject: Re: que
how about simplifying?
replaceNoCase(myStr, 'http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333292
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looks like section is reserved in QoQ. Try
SELECT *
FROM questions
WHERE [section] = #i#
From: "Kris Sisk"
Sent: Thursday, April 29, 2010 3:34 PM
To: "cf-talk"
Subject: What's wrong with this QoQ?
This is driving
Wow. Post back after you update. I can't image that there's any real
difference between 6.17 and 6.18, but if there is, I'll gladly update
all of our servers NOW! :)
~|
Want to reach the ColdFusion community with something t
Window > Preferences
ColdFusion > Editor Profiles > Editor > Code Assist
There's a setting there called "Dealy Before Showing Code Assist(in
milliseconds)
~|
Want to reach the ColdFusion community with something they want? Let
I'd say that earns a WTF. It would appear that one of the servers must
be adjusting the original CreateDate(), but your output shows that it's
just not happening that way. I always thought that the DateAdd() was a
simple math function. What are the differences (if any) in JVM and CF
version
Just do this:
SELECT *
FROM table
WHERE ID IN ( )
From: "Paul Alkema"
Sent: Tuesday, April 20, 2010 1:56 PM
To: "cf-talk"
Subject: MSSQL "Where In" not working with variables
I know this is a CF list, sorry for posting this in the wrong area, but I
t
2 types of JPG that can cause problems: CMYK and progressive JPEG. As
others have noted on this thread, this is not just a problem with the
image engine used by CF, but is a problem with any browser as well.
CMYK images will *not* (in my experience) convert properly within CF
image functions
This works for me:
function jscript1(){
var theString = "screen1.cfm";
var fileName = theString.substring(0,theString.lastIndexOf("."));
callURL = "Link1";
alert(callURL);
}
On 4/15/2010 5:14 PM, fun and learning wrote:
>
>> callURL = "Link1";
callURL = "Link1";
On 4/15/2010 4:58 PM, fun and learning wrote:
> Hi All,
>
> I know this is coldfusion forum, but can any one tell me what I am missing to
> make the fileName get within quotes in javascript. I am getting everything
> right except in callURL, the fileName is sent as argument
Ah, yeah, true. Just used to using the Evaluate(DE()) combo back in the day
when outputting blocks of dynamic content, because otherwise the double-quotes
in content killed the Evaluate() function. With something like 'Vin #', the
DE() adds nothing to the party.
@Doug,
Did you try evaluate(de(yourVariable)) ? The Dynamic Evaluation [DE()]
method should cover you there.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing l
Also, to address the first example you gave, if this is blowing up on
"Vin #":
#evaluate(columnName)#
Then try this:
#evaluate(de(columnName))#
(if I recall correctly)
~|
Want to reach the ColdFusion community with something
Yes, the long datetime in SQL Server tracks out to fractions of seconds.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion
Then you also have access to the result in the cfhttp struct that gets
returned.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Ar
Really should not be sending in "". Can we see your full, revised query?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusio
Let queryParam do the work for you:
UPDATE Soc
SET TransProv =
WHERE ID =
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoff
Well, depends on what your data needs to be. Sometimes 0 is not the same
as "no answer given". If you're allowing NULL in that data column and NULL
means something different than 0, then you will want to *not* use
default="0".
Often in those cases, I do something like the following, where I
You're testing for the actual string 'GroupID'. Add the # signs.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.c
No, from a cookie perspective, http://mysite.com and https://mysite.com
are 2 different domains, so you need to send the session tokens across
the gap. Any of a number of approaches can work, but here's the quick
and dirty:
https://#mySecureURL#"; addtoken="yes" />
Or, if you are using some
So, you could make those line breaks tags -OR- return your current
output to the browser in a large which will show your line
breaks cleanly.
From: "Kym Kovan"
Sent: Tuesday, March 30, 2010 6:53 AM
To: "cf-talk"
Subject: Re: How to output formatted
sweet
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332414
Subscription: http
I don't know PHP either, but this looks pretty straightforward.
I'm assuming that the "request" in this case is a form post, and I don't
know if the "save" action should do an APPEND or a WRITE (I'm guessing it's
a WRITE), but this looks close to me.
#ff#
#form.repo
Look at the CFPOP tag: send those emails to a specific box, have CFPOP
read messages from that box, and then all those mail elements are exposed
in the query-like return for each message.
~|
Want to reach the ColdFusion comm
@Joe, last time I got a quote for Visual Studio for my developers, it
ran over $600 / seat ...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
htt
From a session perspective, the session cookie (the browser side of the
session) for https://www.mysite.com is *not* shared with the session
cookie for http://www.mysite.com. If crossing from one to the other,
therefore, there are 2 options:
1) User has to log back in after the switch
2)
On 3/19/2010 4:45 PM, Frank Liu wrote:
> Hello,
>
> In my table, I have several fields with numberic data type.
> After the form is submitted, I found out zero are inserted into those fields
> in the table if those fields are left blank in the form. However, I want null
> value in my table. Pl
The double quotes are your problem. This will NOT work:
""
This is all you need:
The cfqueryparam already handles the correct quotes based on the cfsqltype
for each element.
From: "Steven Sprouse"
Sent: Thursday, March 18, 2010 10:18 AM
To: "cf-ta
IIRC, JVM 6.4 is the really bad slow one, isn't it? Update to 6.11 or
higher and you're likely to see improvement in several areas.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the Hou
Actually, if you're just authenticating against the database, then you could
create a service easily in CF and then consume it from the .NET side. At that
point, you wouldn't even need the database side to be involved.
From: "Dave Watts"
Sent: Friday,
Have them both use the same database for user / auth lookups. That's the
simplest, assuming that both servers can access at least one of the SQL
Servers. If that's a challenge, then build a quick webservice to wrap the
authentication call, which is a good idea in any case, and then allow both
I still use HomeSite more than not, but I'm using CFBuilder more and more for
side work (at home at night). Still not used to the lag ... HomeSite is just
so dang fast, while CFB waits forever to popup code assistance within a tag and
it often fails to close a tag, resulting in lots and lots o
If you're talking about 200 copies, each of 150,000 records, then Session
and Application storage are going to be feasible only if you have
sufficient physical memory on the ColdFusion server.
200 x 15 x ?? = 30,000,000 x ?? bytes average record size
So, if an average record in the repor
Good to know, thanks. My next trick is to get a 356 MB script to run LOL
... time to break things up, I guess.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing
Nice, I hadn't ever seen that tool before. Can't wait to give it a
spin. Thanks!
On 3/3/2010 5:08 PM, Matthew Smith wrote:
> I use this. Simple, works.
>
> http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
>
> On Wed, Mar 3, 2010 at
You can usually get that info from the database's system tables, depending
on your RDBMS. (In the following queries, 'typename' will give you the
datatype.)
MSSQL:
SELECT syscolumns.colid,
syscolumns.name,
syscolumns.colorder AS sortorder,
I've seen a number of suggestions for hosting your own, if you have a separate
box. We implemented VisualSVN server about a year ago on a spare scheduling
server and we've been very happy with it. Frequent updates of the server
engine for both functionality and security and the patches have a
I have success just having an index.cfm in the root directory of a
shared host that works a cfswitch statement against the cgi.server_name
(and some other stuff when necessary). I don't think this helps with
your aliasing, but CF mapping can probably handle that, and this does
manage multi-si
Agreed. The question has come up from the OP on how to deal with the CC
if you never have it in persistent scope, and the answer is simply that
capturing the CC number (and IPV code etc) should only ever be the final
step. In other words:
* build the cart: in session or DB, your preference
All this code is doing is setting 2 variables, based on values that existed
in the user's previous request, as tracked in cgi.http_referer.
referer_itemID: holds the value of a url param called "item_id:" or '0' if
the param is invalid or missing or '-1' if there is already a variable
called
Right, what Dave said. If the website is set to allow Anonymous Access,
then the CGI vars that are tracked by the web server will not be set.
From: "Dave Watts"
Sent: Friday, February 05, 2010 11:23 AM
To: "cf-talk"
Subject: Re: ColdFusion & Windows
Can you pass cgi.auth_user and cgi.auth_password into the SSRS call in some
way?
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.hou
I think you just want
#myVar[1].Owner.Cost#
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message
Yep. Don't know about the site, but the mail list is working fine.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com
Looks like you're missing your comma before the queryparam:
,#form.product_id#
,
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Someone mentioned the 'hosts' file, too, which can be useful for spoofing
URLs in development.
c:\windows\system32\drivers\etc\hosts
~|
Want to reach the ColdFusion community with something they want? Let them know
on the
works for me.
On 12/29/2009 8:50 AM, Michael Dinowitz wrote:
> Sorry for the totally off topic post but I need to test the status of the
> list.
>
> Thanks
>
> --
> Michael Dinowitz
>
>
~|
Want to reach the ColdFusion communit
It looks like the reason for the original rewrite was due to subquerying
the same table twice. Nothing wrong with that, but the wizard decides to
ensure that every reference is unique, thus the aliasing of the second
reference. You could get around that by adding your own table aliases in
th
101 - 200 of 513 matches
Mail list logo