Richard,
A simple way to do this is to use a "Tally" table. A "Tally" table
contains one column, ID, that contains numbers from 1 to [x]. You can
then do joins against this table to do what you are looking for. Here's
an example:
SELECT t.ID,
a.Taken,
a.assessm
This can be accomplished by using a Tally table. A "tally table" is
simply a table that contains one column, ID, that increments up to
several thousand (or several million, depending on your application).
For this application, you would use it like this:
Tally
--
ID int
MyData
--
I'm hoping someone here can point me in the right direction. I am looking
for a W4 withholdings calculator that is CF compatible (COM, Java, SOAP,
whatever). Is there anything out there like that?
Thanks,
Chris
~|
Message
rk as expected.
If you want to call a method dynamically, take a look at CFINVOKE.
You still invoke the method on the CFC instance, but you can pass in a
dynamically computed method name. Would that meet your need?
cheers,
barneyb
On 8/23/05, Chris Terrebonne <[EMAIL PROTECTED]> w
I am attempting to dynamically call a cfc's functions without resorting to
evaluate, but something isn't working correctly.
I have read in the archive that you can assign a function to a var, then call
the var as a method but this doesn't appear to be working with setters in a
cfc. Take the fol
This looks like a good use of a Tally table. A "Tally" table is a table that
contains just an ID field with records from 1 to 10,000 (you can use any upper
bound you need). You can then join this table to generate queries based on
ranges.
To test, I created the following table:
ID int
arrival
Ahh, you're using Oracle. Yea, it's going to choke on that one. You could
always try porting it. :)
>>> [EMAIL PROTECTED] 07/06/05 12:37AM >>>
That's unlikely to work in Oracle ;-)
On 7/6/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote:
> Daniel,
>
Daniel,
Included below is a stored procedure that you can use to search any or all
columns in all tables.
Once you have installed the SP, call it as follows:
exec spDBSearch @value='MySearchString'
You can also specify a specific column, table or datatype. Let me know if you
have any questio
searched; jars not
mentioned are ignored.
Again, you can probably do a custom classloader to get around this, but
I've never used one.
Mark
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 8:29 AM
To: CF-Talk
Subject: Java jar
I am reposting this question. I should have known better than to post on a
Friday. ;)
I am trying to determine where I can store Java jar files that will allow CF to
find them WITHOUT reloading the server. Is this possible?
Placing the jars in the WEB-INF/lib directory doesn't work without a r
e wars, ears, and servlets.
DK
On 6/10/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote:
>
> I have read through all of the documentation as well as Christian
> Cantrell's blog regarding where to put Java classes and jars so that CF can
> find them. But no matter where I t
I have read through all of the documentation as well as Christian Cantrell's
blog regarding where to put Java classes and jars so that CF can find them.
But no matter where I try and put this problematic set of jars, CF just won't
see them. Is there a location that I can place the jars that wo
CF editors and
various other things, so you can do your CF work in the same
application. And it itegrates easily with myriad version control
systems too. Very nice package.
cheers,
barneyb
On 6/9/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote:
> Thanks Nathan and Barney for clearin
8/05 01:26PM >>>
Perhaps there's already a java object that impliments this interface?
Look around to see if there's anything that impliments your target
class. Otherwise, you could make one in java and createObject() it in CF.
-nathan strutz
Chris Terrebonne wrote:
> I am
I am trying to use CF to access a Java class method. One of the required
arguments is an object extended from an interface. Using createObject() to
instantiate the object, then passing it to the method as an argument causes an
error because the interface is abstract and must be extended. Sinc
Thanks for the help everyone.
I'll start digging through those libs and see what I can use.
Thanks again,
Chris
>>> [EMAIL PROTECTED] 06/08/05 10:06AM >>>
> Actually, I had my acronym backwards (which apparently makes
> a HUGE difference :).
> I am really looking for FTPS ability (FTP over SSL
Actually, I had my acronym backwards (which apparently makes a HUGE difference
:).
I am really looking for FTPS ability (FTP over SSL).
Sorry for the confusion. Any idea where I can find a CF resource for that
protocol?
Thanks again,
Chris
>>> [EMAIL PROTECTED] 06/08/05 08:58AM >>>
> Can CF
Can CF do secure FTP (SFTP)?
If not, is there a Java class that can be used in CF that will?
Any advise?
Thanks,
Chris
This email and its attachments may contain confidential information
which is intended only for the use of the person(s) named above.
If you are not the intended recipient, yo
Any chance one of you have experience with using CF to format a standardized
ACH file? Any CFC's or custom tags that will do this?
I was going to write one, but no need to reinvent if it already exists.
Thanks!
Chris
This email and its attachments may contain confidential information
which is
Morning everyone.
I have developed a permission model for an application but, before I start
coding around it, I wanted to see how everyone else handles this problem.
In this application, a "Party" is any entity that can act as an individual
(Person,Group, Organization,Department, etc). An "Ob
In a relationship model like this, you can track history by assigning a time
span for the relationship. For example, you would modify your
Employee_Positions table to contain from and to date fields:
Employee_Positions
Employee_ID
Position_ID
fromDate
toDate
You could then find t
post the query you may get
some very useful tips on how to solve the performance problems at the
root...
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 8:35 AM
To: CF-Talk
Subject: RE: Dynamic cfoutput groups
Thanks for the response.
Fo
>>
It sounds like you're after a kind of pivot table functionality... Do you
have OLAP capabilities at your disposal? (MS Reporting Services is
installed w/ SQL Server if that applies...)
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]
Sent: Thursday, April
Morning everyone.
I currently have a reporting app that allows output to be grouped dynamically
based on user preference. The user can select an unlimited number of values to
group on and the groups are nested accordingly. I wasn't able to figure out a
way to performing the grouping using cfo
Here are a few general db standards:
http://livedocs.macromedia.com/wtg/public/coding_standards/database.html
>>> [EMAIL PROTECTED] 03/29/05 01:37PM >>>
Why is everyone naming their tables singularly?
:)
Will
~|
Logware
Off the cuff, I would do something like this:
Candidate
---
id (int)
name (varchar)
parent_ID (int)
dependsOnParent (bit)
parent_ID would signify which Prez the VP is affiliated with.
dependsOnParent would signify if the child (VP) can run alone or not.
The query would b
Perfect! thanks
>>> [EMAIL PROTECTED] 03/22/05 12:14PM >>>
http://www.adersoftware.com/index.cfm?page=cfbb
____
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]
Sent: Tue 3/22/2005 1:06 PM
To: CF-Talk
Subject: Spam:Message Board
Does anyon
Does anyone know where I can download "Simple Message Board"? The url on the
exchange no longer offers the download.
If not, can anyone suggest a good message board app?
Thanks,
Chris
This email and its attachments may contain confidential information
which is intended only for the use of t
The problem is that there are no values for those dates so there are no rows
being returned. In this case isNull won't work. An easy way to do this is if
you query against a table containing the dates then join the orders table. If
you are using SQLServer, you can do the following:
DECLARE @
SELECT *
FROM myTable
WHERE DAY(DOB) = DAY(GetDate())
AND
MONTH(DOB) = MONTH(GetDate())
HTH,
Chris
>>> [EMAIL PROTECTED] 02/01/05 08:19AM >>>
My field name is DOB, and I want to query the list for dates that match
today. Of course, the year will never match. I have tri
Happy Holidays everyone!
A few months ago there was a pretty in depth discussion regarding the database
model and programming techniques of a scheduling/appointment application, but I
can't seem to find it in the archives anywhere. If anyone could point me to
this discussion or to any articles
Thanks Adam. I appreciate the info. I have looked into your crash course and it looks great. Unfortunatly I wouldn't have company support so that puts the crash course a little out of my range. I think I'll have to stick to the book route.
I have noticed the drastic range of book available. T
I just took one in
> C# and it was great. (they aren't cheap though)
>
> Brian
> - Original Message -
> From: Chris Terrebonne
> To: CF-Talk
> Sent: Wednesday, August 11, 2004 2:35 PM
> Subject: SOT: ASP book for CF programmer?
>
>
&
Hello,
I hope this isn't too off topic, but I figured this would be the best place to get good info.
I am currently a long time CF and C++ programmer and I want to try my hand at ASP.NET (VB & C#). Any other CF'ers made the ASP transition? If so, were there any books that you found that were go
you write something for our firm intranet for our firm team.
>
>-Nate
>
>
>-----Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, April 20, 2004 10:29 AM
>To: CF-Talk
>Subject: Softball/Baseball db app? (Maybe OT)
>
>
>Morning
Morning Everyone,
I was thinking of putting together a db app that tracks the team information and game schedule/results for my daughter's softball team. Before I started hacking this out, I wanted to see if there was anything pre-rolled for this purpose. Anyone done this before?
Thanks in adva
Use this instead. It's fast and free.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: "Jason Dowdell"<[EMAIL PROTECTED]>
Subject: RE: Encrypting Numeric ID's
Date: Thu, 18 Apr 2002 18:38:53 -0400
>I tried all of
: Re: SP pulling my hair out!!!
Date: Tue, 16 Apr 2002 15:40:51 -0400
>It was not addressed and you are the man! How in the world was I supposed
>to know it has to be CHAR?! That seems so backwards. I guess the
>CF_SQL_DATE is for another DB server?!
>
>Thanks,
>
>Neil
Not sure if this has been addressed yet but you should be able to send the
date as a CHAR and have SQL determine if its a date:
@DateValue varchar(10)
As long as the date is formated properly, SQL will accept a char/varchar as
a datetime value.
HTH,
Chris
Try this:
CREATE TABLE #x (ID int)
INSERT INTO #x (ID) VALUES(1607)
INSERT INTO #x (ID) VALUES(1627)
INSERT INTO #x (ID) VALUES(1647)
INSERT INTO #x (ID) VALUES(1667)
SELECT my_id
FROM my_table
WHERE my_table.my_id IN (SELECT ID FROM #x)
ORDER BY my_table.my_id
DROP TABLE #x
You can use many
TRUNCATE TABLE MyTable
Chris
--
Original Message
From: "Jason Larson"<[EMAIL PROTECTED]>
Subject: RE: SQL Statement dumping data
Date: Fri, 8 Mar 2002 09:30:54 -0700
>What I am trying to accomplish is:
>
>I have a client that will be pushing up a csv f
Only the TransactionID is required on credits. The address information is
only required for original auths if you have the AVS settings enabled. All
they did as far as the AVS changes was enabled certain fields by default.
Just login and uncheck them.
Chris
We've done some pretty extensive integration with Paymentech. Our first
move was to Authorize.net, but as of late thier stability is a huge issue.
The gateway goes down several times a day and forget about getting anyone
on the phone never happen.
We are in the process of switching to either
Here is a free CFX tag that used 3DES encryption and hex encodes the
results for URL safe transfer. Very fast and very secure.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: "Dave Watts"<[EMAIL PROTECTED]>
Subje
Here is a free CFX tag that used 3DES encryption and hex encodes the
results for URL safe transfer. Very fast and very secure.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: "Dave Watts"<[EMAIL PROTECTED]>
Subje
Here is a free CFX tag that used 3DES encryption and hex encodes the
results for URL safe transfer. Very fast and very secure.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: "Dave Watts"<[EMAIL PROTECTED]>
Subje
Here is a sp I used for a forum application. It doesn't require nested
loops and is VERY fast. You will have to adjust it for your needs, but it
should be pretty easy.
--CREATE PROCEDURE expand (@current int) as
DECLARE @current int
DECLARE @level int, @line char(20)
DECLARE @Pos int
DECLARE @
James,
I am attaching a CFX tag I wrote that will do what you need. It's called
ListGetChunk and it allows you to extract a portion of a list.
You could use it like this:
Hope that helps,
Chris
--
Original Message
From: "James Maltby"<[EMAIL P
You are encountering file locking errors. The write is trying to begin
before the delete has released it's lock on the file. When writing and
deleting, I always rename the file first, then delete the renamed file.
Same for the write. Write to a temp file, then once the write is complete,
renam
You will need to find a program (script, cfx, com) that will allow you to
send messages as multipart/alternative. That way you can set a text/plain
part and a text/html part. This will allow you to send a message using
both text and html and the mail client will determine which it is capable
of
Some Content
--
Original Message
From: ""<[EMAIL PROTECTED]>
Subject: HTMl:Border Around Tables
Date: Fri, 15 Dec 2000 13:05:01 -0500 (EST)
>
>I have been struggling with this one for quite some time
>now: I need a on
Kill the single quotes. No need to put them around an SQL var.
Chris
--
Original Message
From: "sebastian palmigiani"<[EMAIL PROTECTED]>
Subject: Re: cfstored procedure problem
Date: Tue, 05 Dec 2000 22:29:16 -0600
>on 12/5/00 3:46 PM, S R at [EMAIL P
Look up the syntax for sp_dettach and sp_attach.
With that you can move the db by hand with no leftovers.
Chris
--
Original Message
From: "ryo watanabe"<[EMAIL PROTECTED]>
Subject: SQL 7 database transfer from one server to another
Date: Thu, 30 Nov 200
Yes, * is the syntax for ALL in SQL7, but you don't need to specify that
for a DELETE.
When you issue a delete, you delete the entire record, so there is no need
to specify columns.
Try:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
Chris
-
Actually a query is an array of structures.
Chris
--
Original Message
From: "Eric Bradburn"<[EMAIL PROTECTED]>
Subject: RE: Query as a structure
Date: Wed, 29 Nov 2000 11:49:38 -0500
>This message is in MIME format. Since your mail reader does not unde
I havn't tested this, but you should be able to do either of the following:
SELECT (Sum(paymentamt) + 0) AS total
or
SELECT CAST(Sum(paymentamt) AS int) AS total
Chris
--
Original Message
From: "Jim McAtee"<[EMAIL PROTECTED]>
Subject: MS SQL Shortcut?
--
Original Message
From: "Emmet McGovern"<[EMAIL PROTECTED]>
Subject: convert kilobytes to megabytes?
Date: Wed, 1 Nov 2000 17:54:56 -0500
>Is there an easy way to convert byte values to megabyte values.
>
>ex. 9 bytes is 9k or 90 is 9m
For other db servers, this may not be the case, but for SQL Server, ODBC is
the fastest method for accessing your data.
Here are some reasons, directly from MS, for using ODBC:
-- While many database vendors support ODBC by using a mapping layer on top
of their proprietary interface, this is not
This will do it:
SELECT FirstName, LastName
FROM RealtorInfo
WHERE RealtorID IN (SELECT RealtorID FROM Homes WHERE HomeID IN(#homelist#))
Chris
--
Original Message
From: ""<[EMAIL PROTECTED] (paul smith)>
Subject: Re: SQL Question
Date: Tue, 10 Oct 2
dministrator
> Vivid Media
> [EMAIL PROTECTED]
> www.vividmedia.com
> 608.270.9770
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Monday, October 09, 2000 4:23 PM
>To: CF-Talk
>Subject: RE: You are a stored Proc god if you can answer
to pass quotes to a stored proc and build a query in this
>fashion.
>Am I missing something?
>
>Thanks
>
>Mark W. Breneman
>-Cold Fusion Developer
>-Network Administrator
> Vivid Media
> [EMAIL PROTECTED]
> www.vividmedia.com
> 608.270.9770
>
>
>-Original M
Try this:
CREATE PROCEDURE [Search_RC] @where varchar(255)
AS
DECLARE @Select varchar(255)
SET @Select = 'SELECT count (*) as noofrecords FROM NPO_IRS_primary ' +
@where
CREATE TABLE #x (MyCount int)
INSERT INTO #x
EXECUTE(@Select)
SELECT MyCount FROM #x
DROP TABLE #x
--
text
--
Original Message
From: "Andy Peterson"<[EMAIL PROTECTED]>
Subject: OT: SQL Server
Date: Thu, 5 Oct 2000 13:15:41 -0500
>Hi,
>
>Can anyone tell me what the equivalent of a MS Access "memo" field is in
SQL
>Server 7.0?
>
>TIA,
>Andy
>
>
>---
In the CFM file, you can do either of these:
Use this if the image doesn't reside on your server.
or, use this if the image is on your server
Chris
--
Original Message
From: "Gavin Myers"<[EMAIL PROTECTED]>
Subject: RE: HTML Email Tracking
Look up the "sp_attach" and "sp_detach" procedures.
You will need to install SQL on the new server, then sp_detach the
databases that you wish to transfer. Copy the mbf and ldf files to the new
server, then use sp_attach to "add" the db's to the new installation.
Chris
--
nipulate
>them.
>
>--
>Jamie Keane
>Programmer
>SolutionMasters, Inc.
>9111 Monroe Rd., Suite 100
>Charlotte, NC 28270
>www.solutionmasters.com
>704.563.5559 x 228 Voice
>704.849.9291 Fax
>-Original Message-
>From: Chris Terrebonne <[EMAIL PROTECTED]>
>To:
This has probably been covered already but...
Is there any way to replace or customize CF's internal error messages
("canceled or ignored by server...", etc)?
Thanks,
Chris
_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
---
Here are two sql statements that I use for a forums app. Both use multiple
columns:
SELECT TOP 300
ID,Name,Catagory,Description,TotalThreads,TotalTopics,IsPrivate,WebName,KeyW
ords,KEY_TBL.RANK
FROM Forums AS FT_TBL,
FREETEXTTABLE(Forums, *,'#SearchString#') AS KEY_TBL
WHERE FT_TBL.ID = KEY_
s preparing the SQL to send to the database. It will not be
>evaluated for each row of the query. Build your query with CF. Use SQL
>statements and functions for manipulating each row of the query.
>
>Dan
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED
SELECT Date, #DateDiff(date, now())# AS "DateSpan"
FROM Dates
ORDER BY DateSpan
chris
--
Original Message
From: "David Shadovitz"<[EMAIL PROTECTED]>
Subject: Re: SQL ORDER BY Problem
Date: Tue, 5 Sep 2000 06:18:33 -0700
>Wouldn't your results be th
Cold Fusion DOES have scalability issues. Sure, if you throw enough
servers at it, it will scale...but the same can be said for virtual any
language.
Don't get me wrong, CF is a very robust language, but the fact is there are
issues.
imho,
Chris
--
Or
how you obtained the benchmarks
>I would love to hear it :)
>
>There are four types of lies (In order from best to worst :)
>
>Lies, Damn Lies, Statistics, Benchmarks
>
>
>
>Jeremy Allen
>[EMAIL PROTECTED]
>[Insert cool title here]
>
>
>
>
>-Or
I have done side by side comparisons with ODBC and OLEDB using SQL 7.
Contrary to common belief, the OLEDB actually ran anywhere from 5-20 ms
slower than with ODBC. I just completed work on a new version of our ad
serving software and I obviously wanted the fastest option available. I
was very
You can add a random number to your query then order by that.
Try this:
SELECT BannerAdID, #RandRange(1,9)# AS "Rand"
FROMBannerAds
WHERE Active = 1
ORDER BY RAND
--
Original M
Cookie: Name=Value;Name=Value;Name=Value
Make sure the cookie header is on it's own line.
Chris
--
Original Message
From: "!jeff!"<[EMAIL PROTECTED]>
Subject: COOKIES: CFX_HTTP: sending with header
Date: Thu, 20 Jul 2000 18:24:52 -0700
>After becoming
Are you in control of the mail client (ie. is this a web-based mail client)?
If so, you can easily send one message to the intended address and send a
copy of the message to your client's address and encrypt the body of the
copied message. Then set up a simple page that the client can use to cut
Try here:
http://www.gyldan.com/~cuspy/cuspy/escape.htm
Chris
--
Original Message
From: "Ric Smith"<[EMAIL PROTECTED]>
Subject: Know where I can find Chr(*) definitions?
Date: Fri, 7 Jul 2000 11:13:31 -0400
>Anyone know of anywhere I can find the defin
Replace(CompanyName, " ", "", "ALL")
Specify the space, then the null (""), then ALL.
Chris
--
Original Message
From: "Larry Juncker"<[EMAIL PROTECTED]>
Subject: RE: Spaces
Date: Fri, 7 Jul 2000 07:41:01 -0500
>Kevin;
>
>I believe that you have to typ
and it is not
>working !
>The Oracle Database returns "Invalid SQL statement".
>
>Where did you see that king of statement ? Can you give me more information
>on how to make this king of SQL working ?
>
>
>-Original Message-
>From: Chris Terrebonne [mailto:
n you give me more information
>on how to make this king of SQL working ?
>
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 23, 2000 9:48 AM
>To: [EMAIL PROTECTED]
>Subject: Re:[Another Way...]Checking for a record,
Or you could do it all via SQL:
IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
CFTOKEN=#CFTOKEN#)) > 0)
DELETE FROM SystemQuote WHERE CFID = #CFID#
Chris
--
Original Message
From: "Chris Terrebonne"<[EMAIL PRO
Just test for the RecordCount...
Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
DELETE FROM SystemQuote WHERE CFID = #CFID#
--
Original Message
From: "Chris Farrugia"<[EMAIL PROTECTED]>
Subject: Check
How does the CFX API handle simutaneous requests? Does CF spawn a new
instance of the attached CFX DLL for each simultaneous request, or does it
assume that the CFX DLL can handle simultaneous requests itself and direct
requests to the existing instance?
If it is the later, then is there a way wi
That will make CF parse the list twice. You definitly don't want to do
that if the file is large.
Try this:
I haven't tested the code, but you get the idea.
Hope that helps,
Chris
--
Original Message
against the average impressions for the site. This
>>can easily be accomplished by using a nightly task that calculates the
>>average site impressions for the last 5-7 days then re-calculates all
>>campaigns based on the new average. This ensures that if a buyer
purchases
&
for 30 days, that is exactly what they get.
Chris Terrebonne
--
Original Message
From: "Al Musella, DPM"<[EMAIL PROTECTED]>
Subject: RE: banner ad weighting
Date: Thu, 13 Apr 2000 15:40:27 -0400
>There may be a much simpler way:
&
by
the random number and the weight.
And that's it.
Hope that helps.
Chris Terrebonne
--
Original Message
From: "Bob Hendren"<[EMAIL PROTECTED]>
Subject: RE: banner ad weighting
Date: Wed, 12
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
88 matches
Mail list logo