to a
database query? Any other suggestions on how I might accomplish this?
Thanks.
Mike Klostermeyer
[EMAIL PROTECTED]
402.408.3733 ext. 101
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date
No need for IFRAME's. Simply use javascript to trigger an onchange event in
the student drop-down. The event should locate the browser to the same
page, with a URL parameter consisting of at least the student ID that was
chosen. Query for the data for this student, then, underneath the
Remember, anytime you are taking input from a URL, use cfqueryparam within
your queries to filter out the bad guys.
Mike
-Original Message-
From: Andrew McDuff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 3:28 PM
To: CF-Talk
Subject: Re: One-to-many application on one screen
with standard
DB queries, this particular one is the result of a Verity search. Any way I
can resort the verity collection, perhaps within the CFSEARCH tag?
Mike Klostermeyer
[EMAIL PROTECTED]
402.408.3733 ext. 101
~|
Message: http
Subject: RE: Q of Q sorting
I haven't run into this problem, but have you tried converting the
string to numeric using Val? I'm not sure if that would work in Q of Q
(it's a CF function not SQL), but it's worth a try.
-Original Message-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED
You are correct that they should have an ArrayFind function, but knowing
this limitation you should code to the strength of the language. In CF,
that means using a lot of lists and queries vs. something like C++ in which
I would use arrays.
Mike
-Original Message-
From: Andy Matthews
and 2) more importantly, a great deal of the time an array doesn't just
contain simple values, but rather contains other arrays, CFC instances,
queries, etc. In a large number of cases a simple arrayFind() wouldn't work
anyway, and a custom function would have to be written anyway.
The same
() searches for a key in a structure, not a value. The
arrayFind() they are talking about is looking for a value. Its not
the same.
there is a StructFindValue() but it will only search for simple
variables, not complex ones.
On 6/1/06, Mike Klostermeyer [EMAIL PROTECTED] wrote:
and 2) more
Third. Their tools are sweet.
-Original Message-
From: Steve Kahn [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 01, 2006 9:56 AM
To: CF-Talk
Subject: RE: free sql tool
I'll second that, were big fans of red gate too. Thanks Dave
-Original Message-
From: Munson, Jacob
There you go again, Dave. You need to really stop throwing logic into these
conversations. It gets really annoying. :)
Mike
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 11:13 AM
To: CF-Talk
Subject: RE: Any reason why a file field can be
The reason you don't need helmets on car drivers is that the law of
diminishing returns applies when you are talking about a 2nd or 3rd layer or
protection (car + air bags + helmet) vs. the first layer of protection
(helmet alone), as is the case of a motorcycle.
It should also be noted that a
Mike - check this post out:
http://succor.co.uk/index.cfm/2006/2/13/Google-analytics---urchin
On 22/05/06, Mike Klostermeyer [EMAIL PROTECTED] wrote:
Since it appears many here use Google Analytics, I have a question. Does
anyone use it over an SSL connection (during the checkout process
Since it appears many here use Google Analytics, I have a question. Does
anyone use it over an SSL connection (during the checkout process of a cart,
for example)? I can't figure out how to use it without throwing browser
security warnings (domain name does not match, etc.). Any way around
I'm still getting the security warning. Any ideas what I need to do?
Mike
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 11:24 AM
To: CF-Talk
Subject: RE: Google Analytics?
This must no longer be true; I just set up Analytics last
month on
Found the problem. I had the wrong SSL URL. Doh! Thanks for everyone's
help.
Mike
-Original Message-
From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 3:36 PM
To: CF-Talk
Subject: Re: Google Analytics?
Mike, Did you check out my post?
your
disaster recovery plan to work.
-e
-Original Message-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 3:58 PM
To: CF-Talk
Subject: RE: Server Backup Solutions
Thanks. Now thinking about it, an ideal solution would be able to manage,
say, a weeks worth
create a PDF with CFDOCUMENT
-Original Message-
From: Raven Technology [mailto:[EMAIL PROTECTED]
Sent: Friday, May 19, 2006 9:16 AM
To: CF-Talk
Subject: Print Friendly Version
Can anyone assist in how to offer the user to print a friendly version of
a web page?
Steve LaBadie
Raven
I wouldn't say that. Sometimes it is helpful to know how many records were
updated or deleted without having to do a select query beforehand. Is there
a Java service factory way of getting at this information?
Mike
-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED]
Sent:
I've served images from a Windows 2000 Server that was fine until it reached
20,000-30,000, at which point it became unstable.
Mike
-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 10:19 AM
To: CF-Talk
Subject: RE: maximum number of files
No. In your version, '5' would be incorrectly found in the list
'50,150,250', whereas it would NOT be found in the SQL below.
Another route to go if you are using SQL Server (possibly others as well) is
to find or create a user defined function in SQL that parses lists. I've
used this before it
By chance is one or more of the possible values of code a number?
Mike
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 12:44 PM
To: CF-Talk
Subject: Query of Queries
I don't use QofQ much and am having some troubles that maybe someone
I've seen reference to cfdocument in this thread. Is it going to be a
problem as well?
-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006 2:38 PM
To: CF-Talk
Subject: RE: Update on eolas/cfform/cfchart fixes
As mentioned numerous times, the
I understand from the documentation that it is no longer best practice in
CF7 to use cflock around cfsearch. Does this apply to CFMX a well?
Mike Klostermeyer
[EMAIL PROTECTED]
~|
Message: http://www.houseoffusion.com
anything change regarding Verity between these versions?
Mike Klostermeyer
[EMAIL PROTECTED]
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236334
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Use the isNull() function directly in the SQL.
Mike
-Original Message-
From: Steve Milburn [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 2:50 PM
To: CF-Talk
Subject: Re: CFIF and null values
What is the data type of the field in the database? If it is a char, it
could be an
Sorry, you are right. Meant to mention that, but forgot.
Mike
-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 3:02 PM
To: CF-Talk
Subject: RE: CFIF and null values
Use the isNull() function directly in the SQL.
FYI, coalesce() is ANSI
.
Thanks.
Mike Klostermeyer
[EMAIL PROTECTED]
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232756
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm
I need to be able to set the background color of a Flash CFForm DateField
input box. Any idea how to do this?
Mike
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231301
Archives:
Great, thanks!
Mike
-Original Message-
From: Michael Grove [mailto:[EMAIL PROTECTED]
Sent: Friday, February 03, 2006 2:21 PM
To: CF-Talk
Subject: Re: Flash CFForm Style
I have been working on a form with custom colors.. here is the code I found
and am using. There are alot of global
By selecting the ID along with the email (assuming a autonumber-type ID),
you will return all records, nullifying the desired result of the distinct.
Mike
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 2:23 PM
To: CF-Talk
Subject: RE:
This will give you the emails in question, but it doesn't give you the ID's
that you need in order to remove them safely. Ben's idea of joining the
table to itself (earlier post):
select id from emails as a, emails as b where a.id b.id and a.email =
b.email
is darn near brilliant in my view,
I know I've seen this thread before, but I cannot find it on the archives.
In the debug, the TOTAL EXECUTION TIME doesn't equal the sum of the
individual template times in CF7. Which one is correct (if any)?
Mike Klostermeyer
[EMAIL PROTECTED
Make the input argument of type 'struct'. Within the function you can then
loop over it via the StructKeyList() function.
Mike
-Original Message-
From: Oleg Gunkin [mailto:[EMAIL PROTECTED]
Sent: Friday, January 27, 2006 2:51 PM
To: CF-Talk
Subject: cffunction with infinite number of
I have used some stored procedures in SQL Server that gives drive free
space. Of course, the server that you need the information from must have
SQL Server installed on it.
Mike
-Original Message-
From: J W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 8:50 AM
To: CF-Talk
I agree with the idea that flash forms should mirror html forms. A couple
examples:
1. Not being able to name fieldnames the same. In HTML, it simply returns a
comma delimited list upon submit, but throws an error in flash forms.
2. The calendar popup should have a way to quickly change the
so if they are in the middle of typing War and Peace in a form field when
the JS kicks off, they lose it all?
Mike
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 01, 2005 1:22 PM
To: CF-Talk
Subject: Re: Keeping a session alive
Ive got a js
Hello all,
I'm hoping someone out there has an example they could share
for a SIM request to authorize.net that generates the required fingerprint.
Mike Klostermeyer
~|
Logware (www.logware.us): a new and convenient web-based
what exactly are we talking about here?
Mike
-Original Message-
From: Tony [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 10:32 AM
To: CF-Talk
Subject: Re: [SPAM : 8.1] Re: Rumors from Max...
macromedians are more prevalent than you might think.
i have NEVER had a moment,
If you have a subquery within the IN, no, there is no limit. If you specify
individual items (1,2,4,2, etc.), I have reached a limit with SQL Server,
but I don't recall what it was (well into the 5 figures). A subquery is the
best solution.
Mike
-Original Message-
From: Robert Everland
Yes, I found this as well. I did my own work-around, but it is not fit for
public reading!
Mike
-Original Message-
From: Peter Coppinger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 10:22 AM
To: CF-Talk
Subject: ColdFusion Bug :- functions return additional spaces(!)
That is not true. In SQL Server:
select * from a, b
where a.col *= b.col
is a left join
Mike
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 7:56 PM
To: CF-Talk
Subject: Re: OT Joins
The type of join is not related to where the
I never said that it was. You stated that it was impossible, which is
incorrect. Notice the ...In SQL Server... proceeding the code.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 20, 2005 9:38 AM
To: CF-Talk
Subject: Re: OT Joins
That is
Done that as well, but evidently I was a lot more patient than you, as I
generated 34,000 emails!
Mike
-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 10:21 AM
To: CF-Talk
Subject: RE: Using try/catch all over the place a good thing?
I
I'd figure there are more security concerns when you involve the human
error factor
Not only error, but theft as well. I put myself through college working
retail at a nationally known retailer, and I had access to every one of our
customers credit card numbers, anytime I wanted.
It boggles my
Yikes, are they storing War and Peace? If you can/want to break it out of
the DB, write it to a file then store the file location in the DB. This
would require an initial pass to write out the data already in there and
some CF work to pull the data in a different way (files vs. DB), but it
would
A couple problems with this:
1. Typically you will want to sort on something other than the ID (date,
alpha, etc.)
2. This query will return all records from the 200th record through the end
of the table. If this table has a million records, you will be returning A
LOT of data that you don't
-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 10:01 AM
To: CF-Talk
Subject: RE: SQL row select?
A couple problems with this:
1. Typically you will want to sort on something other than the ID (date,
alpha, etc.)
2. This query will return all records
MSSQL does not support LIMIT. Sure wish it did.
Mike
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 10:42 AM
To: CF-Talk
Subject: RE: SQL row select?
Did no one see this post? After reading, and re-reading the original post,
it
The ultimate result will be 50 records, but the NOT IN clause is very
inefficient, especially when dealing with what is essentially a list of
record ID's from 200- 1 million.
Bottom line, when using SQL Server there isn't much you can do to improve
efficiency. You may want to play around with
There were a couple typos, but it works rather nicely. Try
SELECT *
FROM (
SELECT TOP 20 *
FROM (SELECT TOP 220 *
FROM table C
ORDER BY C.column ASC) B
ORDER BY B.column DESC ) A
ORDER BY A.column ASC
Mike
-Original Message-
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Wednesday,
Yet the one question that I wanted .NET to appear in (what languages do you
want CF to interoperate with) the only choices were PHP and Python! At
least they provided an 'other' text box for write in votes.
Mike
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent:
I noticed you are calling a .cfc directly from the currency drop down.
Never seen this before, curious what the general consensus was on this
practice.
Mike
-Original Message-
From: Andrew Grosset [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 11:55 PM
To: CF-Talk
Subject:
variables and then uses cflocation to
return to previous page.
mike
-Original Message-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 September 2005 8:30 a.m.
To: CF-Talk
Subject: RE: Is my site working in the US?
I noticed you are calling a .cfc directly from the currency
in the US?
Fair enough. I will look at using an alternative call to the cfc.
(it seemed so damn easy but...)
mike
-Original Message-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 September 2005 8:50 a.m.
To: CF-Talk
Subject: RE: Is my site working in the US?
Although
Does anyone have a version of cf_twoselectsrelated (or something similar)
that accepts a parameter to 'preselect' records in the second select
depending upon what is selected in the first? Thanks.
Mike
~|
Logware
SELECT * FROM thetable ORDER BY [my column]
Mike
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 1:01 PM
To: CF-Talk
Subject: RE: QoQ Trouble for Column Names with Spaces
Give it an alias in your original query that doesnt have spaces.
cfquery
OK here.
Mike
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 20, 2005 10:44 PM
To: CF-Talk
Subject: RE: frickin ie!!! quick new eyes on css
Seems fine in frickin ie to me :)
And yes, thats an ugly green lol
-Original Message-
From: dave
Nothing like writing beautiful code that does the wrong thing (been there a
time or two)!
Mike
-Original Message-
From: Kristopher Pilles [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 10:24 AM
To: CF-Talk
Subject: RE: Confused about this...
Lol Thanks for your help... I got
I think there are basically two questions here:
1. Does being certified mean you are good? Obviously not.
2. Does being certified mean you have a better chance of getting hired?
Possibly, and it certainly never hurts. Being certified might be the
one
line on your resume that peaks
Please contact me at [EMAIL PROTECTED] I'd appreciate working with you
to get this resolved.
Mike
-Original Message-
From: Rupesh Kumar [mailto:[EMAIL PROTECTED]
Sent: Friday, July 22, 2005 11:38 AM
To: CF-Talk
Subject: CFDOCUMENT image zooming problem not resolved with MX7 hotfix
3?
I just installed hotfix 3 and now cannot create ANY PDF using CFDocument.
Anyone have a similar problem with hotfix 3?
Mike
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 10:04 AM
To: CF-Talk
Subject: CFDOCUMENT image zooming problem
Is there anything else I need to do to roll back to updater 2 besides
removing the chf703.jar file? Since updating I cannot create ANY PDF's,
and removing the newest .jar didn't seem to solve the problem. Did updater
3 do anything behind the scenes that I may need to change manually?
Mike
The determining factor in RAD is going to be your proficiency with each
tool, not necessarily the tool itself. I have heard from many CF/ASP.NET
guys will tell you that given an equal amount of skill between the two
tools, they can create the same app in the same amount of time with either
tool.
What is the preferred method to purge old client variables, either from the
Registry or database? Thanks.
Mike
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
a setting for exactly that, with a length of time you
want to keep them around. Other than that, just doing a DELETE
against the database will wipe them out quite effectively.
cheers,
barneyb
On 7/12/05, Mike Klostermeyer [EMAIL PROTECTED] wrote:
What is the preferred method to purge old client
Is these checkboxes within a CFForm, or plain HTML?
Mike
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 06, 2005 5:40 AM
To: CF-Talk
Subject: Frigging annoying Checkbox behaviour
I vaguely recall reading this somewhere before; when I submit a form
Scott,
It's a little fuzzy now, but we had a problem with CFDocument initially
after upgrading to 7. We resolved it by removing the other JVM(s) that were
installed before the install of 7, then specifically installing the version
CF 7 required (if it wasn't done already). Has worked flawlessly
PHP Live Support is fantastic for the money. Don't know if the PHP part is
a non-starter for you, however. http://www.phplivesupport.com
Mike
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: Friday, June 17, 2005 12:25 PM
To: CF-Talk
Subject: Live Support
Who's
Check the CGI variables when the error happens by emailing yourself a CFDUMP
of the various scopes. Chances are it is google or some other indexing
service jumping directly to your scripts.
Anyone know of a way around this, as I have had this problem in the past as
well?
Mike
-Original
If he submitted the form as expected, then (for some reason) clicked on the
address bar and hit go or enter, that could produce a get vs. a post. May
seem far fetched, but I know an end user or two, so nothing is out of the
question!
Mike
-Original Message-
From: Ryan Stille
Anyone have any experience with the 32k limit in flash-based CFForms (and
Flex)? See error below:
Error generated version of _watcherSetup:738
Branch between 71782 and 104556 around line 0 exceeds 32K span. If possible,
please refactor this component.
Mike
If you'll send me the code in the TranslateRSSItems function, I will play
with it a little.
Mike
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 8:58 AM
To: CF-Talk
Subject: flash forms accordian scrollbars
Below is a link to check out a
;
break;
} // end default case
} // end switch
Token = GetToken(rssDoc,NextToken,);
} // end while
return (ResultQuery);
}
/cfscript
Mike Klostermeyer wrote:
If you'll send me the code in the TranslateRSSItems function, I will play
with it a little
forms accordion scrollbars
Thanks Mike. I've changed those height values so many times, I was sure
I had changed that one too. Anyway, I guess I hadn't.
Mike Klostermeyer wrote:
I know that isn't the problem, just needed a working example to play with.
The problem is with the height
...once Marc left last year, I think that was the sign that Microsoft is
over as a software company...
Yep, couldn't agree more. I'm tossing all of my MS servers/desktops and all
MS software out in the trash today. That trillion dollar, market
dominating, company is finished!
give me a
my silly estimate of MS's financial net worth.
Mike
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Friday, May 27, 2005 1:36 PM
To: CF-Talk
Subject: Re: Regarding Java and .NET's incestuous ties, and Windows'
future
On 5/27/05, Mike Klostermeyer [EMAIL PROTECTED] wrote
I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user closed
their browser (without 'logging off'), the session expired. This is no
longer happening. From what I can find, MX uses session variables
differently, but I can't find anything that tells me what I need to do to
get
Sorry, using J2EE Sessions variables does fix the problem.
-Original Message-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
Sent: Monday, May 23, 2005 3:53 PM
To: CF-Talk
Subject: New to CFMX - session problem
I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user
I am having trouble getting to the visibleattribute in my flash-based CFForm
(CFMX 7). In the code below, when the user clicks on the Notify button, I
would like the text box (currently not visible) to become visible. Thanks
in advance for your assistance.
Mike Klostermeyer
[EMAIL PROTECTED
79 matches
Mail list logo