Don't quite see how you can make this claim, I always use it. Every
application I've ever written makes use of it. I may be in the minority,
but you have no real way of knowing that, so it is not quite accurate nor
fair to say it's rarely used.
At 10:25 AM 7/11/01 -0700, you wrote:
To
If hosted at an outside hosting provider, and that provider has CFFILE
turned off, what other alternatives are there for uploading files from
the client to the server. CFFTP won't work because it's expected to work
via FTP server to server. This is for CF 4.5.
Is there perhaps a free COM
How long has CF been available?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
As strange as this may sound in light of normal developmental thought
processes... I like to re-invent the wheel... each time I do, I get a
better, more efficient, and sometimes a much better looking wheel... of
course I don't do this all the time, and I may use a function or two that
When I used to run CF sites, I had good luck with Media3
(http://www.media3.net).. Now that I only personally run PHP on Linux
systems, I use JTL Networks (http://www.jtlnet.com) and they do have a CF
offering as well. They've had good support and reliability, but I don't
know if their NT
There was an interesting answer to this type of question in Mid-March... I
hadn't tried it myself, and would be curious if anyone else has...
CFQUERY ... cfquery parameters ...
SET NOCOUNT ON
INSERT INTO SomeTable( SomeField ) VALUES( 'SomeValue' )
SELECT nNewID = @@IDENTITY
SET NOCOUNT OFF
Could you do a CFEXIT or CFABORT?
At 03:46 PM 4/5/01 -0400, you wrote:
That is a pain. As I said, I generally put everything into a variable and
then send that, but you still have to be careful about whitespace. There's
no magic way to say "CFCONTENT only up to this point" that I know of.
Is it possible using a view to do an INSERT or UPDATE?
Joseph E. Sheble
[EMAIL PROTECTED]
PHP/mySQL | ColdFusion/SQL Server
Canvas, Cinema 4D XL, and more...
Wizaerd's Realm
http://www.wizaerd.com
The Canvas Expert
http://www.TheCanvasExpert.com
Here's an example:
CFQUERY NAME="qTest" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#"
PASSWORD="#DSN_Password#"
SELECT ID, Option_Desc
FROM Forecast.dbo.Options
ORDER BY ID
/CFQUERY
CFSCRIPT
for( x = 1; x LTE qTest.RecordCount; x=x+1 ) {
WriteOutput(
Isn't there a way to create a singular ODBC Datasource that could access
any database on a SQL Server? In the past we've always created a sperate
ODBC Datasource for every database, and while this isn't necessarily a bad
thing, I'd like to be able to access any database...
Joseph E. Sheble
anti-trust verdict aside, there are whisperings of AOL and Sun pushing more
anti-trust action onto Microsoft due to the whole .NET thing...
see http://www.thestandard.com/article/display/0,1151,22965,00.html
At 09:16 AM 3/21/01 -0500, Nick McClure wrote:
1. ASP is much powerful for people
I use CFHEADER name="Expires" VALUE="0"
has worked for me so far...
At 11:55 AM 3/20/01 -0500, Kevin Gilchrist wrote:
Changed it and it didn't seem to make a difference
-Original Message-
From: Savan Thongvanh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 11:34 AM
To:
Dave, this is a good explanation as to why you would want to use it, but do
you have anything to offer in regards to the performance difference?
At 04:02 PM 3/20/01 -0500, you wrote:
I am curious, I replaced the
SELECT newID = @@identity
with
SELECT max(id) as myVar
and max(id) is
I have some text, and in this text there may or may not be URLs. Some of
these URLs may already be inside of an A HREF tag while others may not. I
need a regular expression that will find all the URLs (starting with
http:// or www. or email addresses) that are not already inside of HREF
I've downloaded and installed the CFX_USER custom tag from Allaire, but it
doesn't seem to want to work. I've emailed the author of that tag, but
I've not heard any response.
If I have my CF Server running as a user (an administrator user) the verify
action of the tag fails with the
escape it with another #
##FF
this is only necessary between a set of CFOUTPUT /CFOUTPUT tags
At 08:31 AM 2/5/01 -0500, you wrote:
Hey everone:
Does anyone know a way to escape hex values, ie
stuff like #FF CF throws an error when I do this
The only work around I have found to date
I've never done Perl or Mason, but I can say without a doubt this is not
true about PHP and ASP. They do not leave whitespace around at
all... I've seen some real bad examples of both, and nope, there just
ain't lines after lines of whitespace.
Perl (if badly written), PHP (if badly
How about:
CFIF trim(ListGetAt(Phone,x)) contains "n/a"
Phone = NULL,
CFELSE
Phone = '#ListGetAt(Phone,x)#',
/CFIF
At 01:56 PM 1/29/01 -0500, you wrote:
I was trying to insert a blank or null value into the table,
if the current list item contains 'n/a'. Not having much
I don't know about running it on W2K, but I have seen that exact message
over and over again, and everytime I've gotten it, I re-installed the MDAC
from MS, and all was well...
At 09:04 AM 1/25/01 -0500, you wrote:
I'm running SQL7 on W2K Professional. When I try to use the query designer
Strangely enough, I've always had problems with figuring this stuff out,
but this little demonstration suddenly makes sense. I've never seen it put
this way, and yet it makes it appear so simple. Thanx!
At 08:35 AM 1/22/01 -0600, you wrote:
Just remember binary numbers:
(rwx)(rwx)(rwx) =
Didn't CF Studio have an option to create a backup file automatically when
it saved a file? In 4.5.2, I've looked all through the different options,
and I'm either missing it or it's not there. I've got to find it, because
after attempting to close studio several times, it has given me an
I guess it depends on your definition of support. I use PHP all the time
in Studio. It doesn't have template expansion, but it does recogize PHP
keywords in the syntax color hilighting.
At 05:56 PM 1/18/01 +, you wrote:
Hi,
A friend tells me that Allaire's Studio might be supporting PHP
There is a whole lot of support for PHP in the form of mailing lists,
websites, books (of which there is more than one... closer to three or
four) It is for a whole lot more than accessing databases, and while this
may likely get me flamed, it a lot more powerful in functionality than CF
This intrigues me a bit... how can you get the CF server piece to interact
with that flash form without submitting it? You'd still have to perform an
HTTP post in order to get the filled in data to the CF server, which would
in fact force a new page to load or a refresh of the current page.
HierMenus is a good script
http://www.webreference.com/dhtml/
At 01:21 PM 1/17/01 -0500, you wrote:
Check out this site
http://www.ivanpeters.com/
Joust is a pretty cool content outliner
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
instead of burring the input field, force the focus to the field you do
want it to go to...
onFocus="form.otherfield.focus()"
At 09:30 AM 1/16/01 -0800, you wrote:
Reposting, didn't seem to make it thru the first round...
Within an INPUT tag Im using a onFocus="this.blur()" so the user
I've been experimenting with calling Java classes using CFOBJECT, and so
far all my tests have run successfully. However, there is one quirk about
this whole process that irks me, and I was hoping somebody here would have
a solution.
If I call the class, find something wrong with it, go back
This is not an option when using CFOBJECT with Java...
At 02:08 PM 1/12/01 +, you wrote:
Are you using RELOAD="Always" ???
Justin
-Original Message-----
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 1:39 PM
To: CF-Talk
Subject
Actually starting with 4.5 you can execute CF code in a template specified
by the CFERROR tag, but only if you use the TYPE="Exception" and
EXCEPTION="Any" in your tag. Such as:
CFERROR TYPE="EXCEPTION" EXCEPTION="Any" TEMPLATE="/cf_error_handler.cfm"
MAILTO="[EMAIL PROTECTED]"
Or you can
I've been experimenting with calling Java classes using CFOBJECT, and so
far all my tests have run successfully. However, there is one quirk about
this whole process that irks me, and I was hoping somebody here would have
a solution.
If I call the class, find something wrong with it, go back
I ahve a stored procedure that checks to see if any records exisit, and if
not creates a default one. The it polls the database and creates basically
an empty query. The problem is if this new default record gets created, my
main resultset variable does not contain a valid query. Whereas if
For those that are using Delphi, what role does it play in the
internet? Is it being used strictly for COM access with CF, or are there
hidden web abilities some of us may be unaware of?
At 07:45 AM 1/9/01 -0600, you wrote:
We use Delphi and CF here. The main reason for that is most of our
I am able to retrieve hierarchial data just fine using a nested custom tag,
and this tag populates a query for me with the data. However, I'm having a
real problem with trying to figure out how to display it. Here's an
example of the data:
0325 - Thomas - Graf -
0645 - Robert - Nudo
Wat do you mean by a tree structure?
At 05:51 PM 1/8/01 +, you wrote:
Why not get the custom tag to populate a tree structure instead of a
query? Then you can write another recursive custom tag to display the
data much more easily.
-Original Message-
From: Joe Sheble aka Wizaerd
easily build an
XML based tree control to contain your information...
-Original Message-
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 12:41 PM
To: CF-Talk
Subject: Hierarchial Display
I am able to retrieve hierarchial data just fine using a nested
I've never had any difficulties in using this..
CFQUERY NAME="qQuery"
SELECT BLAH BLAH BLAH
/CFQUERY
CFOUTPUT#qQuery.SomeField[10]#/CFOUTPUT
At 09:02 AM 1/4/01 -0500, you wrote:
subject says it all
let's say a have a record set of users and wanted to get the first name
of row
This sytnax will not work with recordsets... the index of the array must
come after the fieldname...
At 03:13 PM 1/4/01 +0100, you wrote:
Try User[13].FullName, u can use that with recordsets.
Structures work the same, and you have a tool called QueryToStruct, which
converts your query to a
If I'm understanding the lack of information or the omitted information,
this is not an on-line application, accessible through the web browser,
correct?
At 10:53 AM 1/4/01 -0500, you wrote:
As opposed to starting from scratch, check out DocuShare by Xerox
Corporation. It will do what you want
If you have the TYPE attribute to HTML, you'll beed to specify a break tag:
lt;BRgt;
At 09:22 AM 1/4/01 -0600, you wrote:
Hey all,
I have this ongoing problem with line breaks not being respecting when
formatting my email bodies using the cfmail tag. For example something like
this:
cfmail
I'm wondering if any CF'ers here has found an affordable alternative to SQL
Server's Enterprise Manager? I had found SQL Navigator from
http://www.quest.com/sql_navigator_ss/index.asp, but have found it lacking
in a lot of areas, as well as buggy as h*ll...
Enterprise Manager gives a lot of
and then selecting "Edit SQL Server Registration
Properties". Uncheck "Show system databases and system objects."
Chris
- Original Message -----
From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, January 02, 2001
What's the best way to create a search function for one's website, one that
would search HTM, HTML,CFM,DOC,XLS,PPT,SQL? We currently use Site Server
for our server indexing and searching, but as I pull more and more into SQL
Server and CFM templates, I want to maintain full searchability on
are on
index server, you'll be surprised by the speed.
http://www.cfcomet.com/cfcomet/index_server/index.cfm?ArticleID=0306FEED-E87
3-4D21-881655F4EFB68127
Robert Everland III
Web Developer
Dixon Ticonderoga
-Original Message-
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Thursday
Check out NCompass at http://www.ncompasslabs.com
Here's where I found it (after a quick 10 second search...)
http://browserwatch.internet.com/news/story/plugin46.html
At 09:06 AM 12/27/00 -0500, you wrote:
Can anyone tell me if a Netscape plugin exists that will allow you to run
ActiveX
Fusebox methodologies are analogous to an event handler in any sort of
Windows programming. The event model is not new to developers, and is a
tried and true practice. Moving that methodology to CF apps makes more
than enough sense to me. I use FB methodologies in my CF apps, and they're
there are a couple of tags in Allaire's tag gallery that handle this, but
it relies all on java script. On the onclick or onsubmit events, I set a
variable and then if the user clicks the button a second time, I evaluate
that variable, and if it's set I return false from the javascript
2 seperate
queries.
From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: SQL: Aliases in where clauses.
Date: Fri, 15 Dec 2000 23:15:29 -0700
COuld you give an example... I've been using RDMS's for ov
Unfortunately, aliases are not available in a WHERE clause.. I've asked
this before in various different places, and the response has always been
the same.
At 01:17 PM 12/15/00 -0500, you wrote:
Hi all.
I was wondering, is it possible to use aliases in an sql where clause?
We recently
worked for me numerous times.
From: Joe Sheble aka Wizaerd [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: SQL: Aliases in where clauses.
Date: Fri, 15 Dec 2000 13:19:54 -0700
Unfortunately, aliases are not available in a WHERE clause.. I've asked
All of this boils down to opinion and personal choice. You say CF is a
great technology and PHP is a good technology, while I say PHP is a great
technology and CF is only a good technology... either way, we could argue
this for hours, days, weeks, years and neither one of us (not you
I'm currently going through the same thing, except my new IT director's
pushing for ASP and Java... ick...
If he'd suggest PHP, I'd be all for it since I know PHP intimately, (and
personally prefer it over CF, but that's strictly my opinion)
- Original Message -
From: "Michael Dinowitz"
Yup, you can access queries like they're arrays... here's an example:
CFQUERY NAME="qGraph" DATASOURCE="#DSN_Name#" USERNAME="#DSN_Username#"
PASSWORD="#DSN_Password#"
SELECT COUNT(FilePath) AS pathCount, FilePath
FROM MasterFPPList
GROUP BY FilePath
/CFQUERY
CFLOOP
I'm no means an expert in regular expressions, but wouldn't it be easier and
quicker to use ReReplace() with a regular expression to remove letters?
Especially if it was a rather long text string, looping through it and
concatenating the string would be inefficient...
- Original Message
C++ was only efficient before MS developed the bloated MFC...
Remember OWL? Now there was efficiency
- Original Message -
From: "DeVoil, Nick" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 05, 2000 4:02 AM
Subject: RE: Assembler.
Mike,
Yes, you
5:59 AM
Subject: Re: Big companies using CF
onvia.com and even Hewlett Packard uses it for their site.
At 07:18 PM 12/04/00 -0700, Joe Sheble aka Wizaerd you wrote:
I know this is probably one of those discussions that turn up all the
time
on a mailing list such as this, and I apologize fo
tial political arguments.
:o))
Jeff Craig
- Original Message -
From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 05, 2000 8:00 AM
Subject: Re: Big companies using CF
having worked for onvia.com (their
CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="userpreferences"
PROCEDURE="GetUserID"
CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName"
VALUE="#GetUser.SAMAccountName#" TYPE="In"
!--- CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID"
I know this is probably one of those discussions that turn up all the time
on a mailing list such as this, and I apologize for bringing it up. I have
a new IT Director starting at my company in the very near future who's a big
Microsoft fan, and thinks there's nothing better than ASP and/or C#
58 matches
Mail list logo