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,
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
~|
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
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] wrote:
I am attempting to dynamically call a cfc's functions without resorting
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
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,
Included below is a stored procedure that you can use
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
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/class locations without restart
I am reposting this question
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
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
, 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 try and put this problematic set of jars,
CF just won't see them
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 trying to use CF to access a Java class method. One
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 clearing this up for me.
I guess this was as perfect excuse as any to finally learn
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,
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 do
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).
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.
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
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
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
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
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 14, 2005 6:21 AM
To: CF-Talk
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.
For the application requirements, this should remain
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
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
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
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 anyone know where I can download
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 tried a
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
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 good
# 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
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.They are
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
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 Everyone,
I was thinking of putting together a db app that tracks the team information
and game
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
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
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:
cfprocparam type=In cfsqltype=CF_SQL_CHAR variable=DateValue
value=#DateFormat(Now(), mm/dd/)#
@DateValue varchar(10)
As long as the date is formated properly,
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
- Original Message -
From: Chris Terrebonne [EMAIL PROTECTED]
To: CF
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 file to
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
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]
Subject:
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]
Subject:
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]
Subject:
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:
cfset MyList = "23,24,27,30,543,675,980"
cfset Start = ListFind(MyList, 543) - 1
cfset Max = 3
cfx_ListGetChunk
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,
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
table border="0" cellpadding="1" cellspacing="0"
tr
td bgcolor="Navy"
table border="0" cellpadding="3" cellspacing="0"
tr
td bgcolor="White"Some Content/td
/tr
/table
/td
/tr
/table
--
Original Message
From: ""[EMAIL PROTECTED]
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
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
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 2000
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
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?
cfset RealSize = 900
cfset kSize = Round(Size / 1024)
cfset mSize = Round(kSize / 1024)
--
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
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
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 this...
Try:
Search_RC1('WHERE State=''NC''')
Those are 2 single quo
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
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
='NC''.
Line 1: Incorrect syntax near 'WHERE State="NC"'.
Is to possible 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
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
In the CFM file, you can do either of these:
Use this if the image doesn't reside on your server.
CFHEADER NAME="Content-type" Value"image/gif"
CFHEADER NAME="Location" Value="#IMAGE#"
or, use this if the image is on your server
cfcontent type="image/gif" file="c:\images\Blank.gif"
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
onMasters, 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: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, September 05, 2000 6:15 PM
Subjec
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 the
ill 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]]
Sent: Tuesday, September 05, 2000 9:45 AM
To: [EMAIL PROTECTED]
Su
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 =
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
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
--
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
to worst :) G
Lies, Damn Lies, Statistics, Benchmarks
Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]
-Original Message-
From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 10:55 AM
To: [EMAIL PROTECTED]
Subject: RE: oledb and native drivers
I ha
You can add a random number to your query then order by that.
Try this:
cfquery datasource="#Attributes.DataSource#" name="q_banners"
SELECT BannerAdID, #RandRange(1,9)# AS "Rand"
FROMBannerAds
WHERE Active = 1
ORDER BY RAND
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
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 type
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
Just test for the RecordCount...
CFQUERY datasource="bwpc" name="TestForExistingQuote"
Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
/cfquery
CFIF TestForExistingQuote.RecordCount
CFQUERY datasource="bwpc"
DELETE FROM SystemQuote WHERE CFID = #CFID#
---
Original Message
From: "Chris Terrebonne"[EMAIL PROTECTED]
Subject: Re:Checking for a record, and then deleting it
Date: Fri, 23 Jun 2000 08:43:08 -0500
Just test for the RecordCount...
CFQUERY datasource="bwpc" name="TestForExistingQuote"
Select * FROM S
ation
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, and then deleting it
Or you could do it all via SQL:
CFQUERY da
ot
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:[EMAIL PROTECTED]]
Sent: Friday, June 23, 200
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
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:
For each ad,
calculates all
campaigns based on the new average. This ensures that if a buyer
purchases
100,000 impressions for 30 days, that is exactly what they get.
Chris Terrebonne
--
Original Message
From: "Al Musella, DPM"[EMAIL PROTECTED]
Subject: RE: b
set Rand = RandRange(1,100)
cfset End = 0
cfloop query="GetAd"
cfset Start = End
cfset End = Start + GetAd.Weight
cfif (Rand GTE Start) AND (Rand LTE End)
!--- We have a winner ---
/cfif
/cfloop
And that's it.
Hope
86 matches
Mail list logo
