I'm trying to do this sort of thing:
cfscript
// Set some variables
bunchOfOtherVariables = Values;
// Plain or HTML format?
formatType = html; // (html|plain)
/cfscript
cfmail from=#myFrom#
to=#myTo#
subject=#mySubject#
#IIF(formatType IS 'html', DE(type=html), '')#
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to update or refresh the queries at will.
Here is my current process:
1. Break the
See below:
On Thu, 31 May 2001 16:12:03 -0600, David Clay [EMAIL PROTECTED]
wrote:
Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a
blank space, thus producing an error.
Code below:
CFQUERY name=getWaitingStudent datasource=SMC
SELECT ClassSchedID,
See below:
On Thu, 31 May 2001 16:12:03 -0600, David Clay [EMAIL PROTECTED]
wrote:
Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a
blank space, thus producing an error.
Code below:
CFQUERY name=getWaitingStudent datasource=SMC
SELECT ClassSchedID,
(Please pardon the doubled post, newsgroup users)
What's the best way to clear out a cached query, so that your
production site will use the most current database information? I want
to retain my long cache spans on a production box, but I want to be
able to update or refresh the queries at
-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 4:28 PM
To: Jamie Jackson
Subject: Re: CFSET / UPDATE SQL
I get he correct answer. It, for some reason, is not putting the value in
the UPDATE query.
Dave Clay
Internet Facilitator
Trus Joist
, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
--
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED
Don't think you can. I found this reply to an identical question on
the Web:
I've been looking through the ANSI SQL documentation, and I can't
find any syntax to do that. The allow zero length is an MS-Access
quirk, anyway -- most databases (e.g. SQL Servers) just allow it --
and it certainly
When last I checked, there was no way to directly evaluate CF tags
from a DB.
I think people have been getting around this by creating (using
cffile) a temp.cfm file with DB field's contents, and then including
the created file.
Good luck.
Jamie
On Wed, 30 May 2001 13:11:05 -0400, in cf-talk
Instead of upgrading NT4/IIS4 to Win2K/IIS5, I'd like to start with a
clean slate, and install Win2K/IIS5 on a wiped drive. Moving over the
old IIS metabase and Web site directories should be somewhat
straightforward, and I should be able to copy over the ODBC
information from registry to
NT, IIS4 or any old applications
that are no longer relevant.
If a jobs worth doing - its worth doing well. Don't cut corners by trying to
dump information from your old system into your nice clean installation.
Regards
Stephen
-Original Message-
From: Jamie Jackson [mailto:[EMAIL
system into your nice clean installation.
Regards
Stephen
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2001 14:01
To: CF-Talk
Subject: Moving CF from one server to another?
Instead of upgrading NT4/IIS4 to Win2K/IIS5, I'd like to start
in my tag, and you omit it
to return the value in place of the custom tag call itself.
Thanks again,
Jamie
P.S. Here is a third alternative, if, for some reason, you're avoiding
tags in your custom tag (just a use of the CF comment markers):
cfsetting enablecfoutputonly=Yes!---
Author: Jamie Jackson
limitation of only function calls valid from within cfscript
and all. As of
my knoweldge this still is the case in cf 5.
2) I also believe this is nope. Check my post (came in just
after your
self-posted solution).
|-Original Message-
|From: Jamie Jackson [mailto:[EMAIL
On Fri, 18 May 2001 12:34:30 -0600, Jim McAtee
[EMAIL PROTECTED] wrote:
snip
See the value in this?
No. If you don't want white space around the returned string then there's
no reason it should be returned by the custom tag!
Uhh that was my point, I think you missed something. I was
I've got a custom tag which returns a small string, but I can't get
rid of the extra spaces around the string when it's called. This has
screwed me up several times, and I haven't found a solution yet.
EnableCFoutputOnly gets rid of most of the garbage whitespace, but it
leaves a space to the
enableCFoutputOnly=no
Thanks,
Jamie
On Thu, 17 May 2001 16:01:09 -0400, Jamie Jackson [EMAIL PROTECTED]
wrote:
I've got a custom tag which returns a small string, but I can't get
rid of the extra spaces around the string when it's called. This has
screwed me up several times, and I haven't found a solution
:
Have you tried using the Trim() function?
-- Original Message --
From: Jamie Jackson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Thu, 17 May 2001 16:01:09 -0400
I've got a custom tag which returns a small string, but I can't get
rid of the extra
I've got an Access database full of information to list in in a
directory which is to be printed at a print shop. So I need the
database to populate my directory pages. I'll probably need to use
Quark or PageMaker. Is one or the other better suited for this
endeavor?
I'm also a ColdFusion
The problem with that is you would have to lock a query, and you
probably don't want to use a lock for that long. I would think it's
best to set the variable aftewards, only locking the cfset.
Jamie
On Tue, 08 May 2001 10:18:06 -0700, Jason Lotz
[EMAIL PROTECTED] wrote:
Actually, if you want
Exclusively lock all of your sets, and ReadOnly lock all of your reads
(references).
Just do it, it's not too tough. :)
Watch out for application variables too.
Jamie
On Tue, 08 May 2001 11:15:20 -0700, Gregory Harris
[EMAIL PROTECTED] wrote:
Ok, what is the consequence for failing to lock
Hello,
Is there a way to call a custom tag that's in a subdirectory of ...
\CFUSION\CustomTags ?
In other words, I want to organize some custom tags into
subdirectories:
\CFUSION\CustomTags\Site1\CT1.cfm (+ CT1a.cfm , CT1b,cfm, ...)
\CFUSION\CustomTags\Site2\CT2.cfm (+ CT2a.cfm, CT2b.cfm, ...)
On Fri, 30 Mar 2001 09:42:25 -0500, Dave Watts [EMAIL PROTECTED]
wrote:
If you've got a file "ct1.cfm" in \cfusion\customtags\site1\, and nowhere
else, this syntax should work:
cf_ct1
Yeah, this is what I tried before, and I got an error saying CF
couldn't find the template. (Custom tag
.
Try creating a new custom tag in a subdirectory and calling it.
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 8:31 AM
To: CF-Talk
Subject: Subdirectories in CustomTags directory?
Hello,
Is there a way to call a custom tag that's
Hi,
Is there a way to do this sort of thing?
cfscript
REFind("(before)(HeresTheStringIWant)(after)", myTargetString);
variables.foundstring = \2;
/cfscript
If not, what's the usual way to go about it? Seems like it could get
pretty ugly if there isn't a similar way.
Thanks,
Jamie
Wow, brilliant! I didn't know about REFind's 4th attribute.
You've helped me before, and you helped me again.
Thanks,
Jamie
On Fri, 30 Mar 2001 15:26:40 -0500, in cf-talk you wrote:
To get a backreference in a REFind() you have to set the 4th attribute of
the function to true. Your function
Is there no elseif in cfscript? If not: Why not, and what's the
usual workaround?
Thanks,
Jamie
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
PROTECTED]
www.wwstudios.com
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 11:43 AM
To: CF-Talk
Subject: elseif in cfscript?
Is there no elseif in cfscript? If not: Why not, and what's the
usual workaround?
Thanks,
Jamie
eater then 15");
}
else if (x LT 15) {
writeOutPut("Less then 15");
}
else {
writeOutPut("Equals 15");
}
/cfscript
-----Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March
Of course, that is a common task.
Just do an INSERT and a CFMAIL, both with the same fields.
Jamie
On Mon, 05 Mar 2001 12:04:04 -0500, "Jones, Becky"
[EMAIL PROTECTED] wrote:
is there a way to have a form that when a user types in data, it gets
submitted to a database and an email of the data
d to replace anything, but I'm very
curious about the matching regex--how do you exclude a certain string
("cfm"), a space (" "), AND a "" from matching (see my original
question below).
If you care to refer to the book, "Mastering Regular Expressions," I
h
Hi, I'm trying to globally replace (with CF Studio) application
variables with request variables in several sites. I can't figure out
exactly how, as I don't know how to negate strings (as opposed to just
character classes).
I want to change application.variableX to request.variableX, but I
We use this one.
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3472D2-2830-11D4-AA9700508B94F380method=Full
On Thu, 22 Feb 2001 16:13:07 -, in cf-talk you wrote:
Hi all. Does anyone know where I can hold of aquery driven Events calendar
which I need to incorporate into a site
, then do an EXTENDED REPLACE, and choose ALL
OPEN DOCUMENTS. it will do the search and replace on all open documents.
or instead, u can tell it to do it from a directory. same thing :)
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 10
I've heard Ben Forta say several times that the following way of
determining the just-inserted value of an autonumber field is
unnecessary and unreliable. He said that databases have built-in ways
of returning the value.
So what is the database method, triggers? If so, how can you get at
this
Hello,
I've got some code that I'd like to make more maintainable and more
elegant.
In an included header file, I've got something like this (but much
more complicated and lengthy):
!--- Which title banner to output at the top of the page? ---
cfif findnocase("Dogs.cfm","#cgi.script_name#")
How's bout giving us the post-parse SQL in the debug output?
J
On Thu, 09 Nov 2000 08:37:26 -0800, in cf-talk you wrote:
I recieved the following error and can not figure out how to fix it. My query looks
just like the rest of my other ones, but this one just doesn't seem to work. Can you
Say I'm a developer, but not a not a SysAdmin.
It is too easy for me to get an administrator's username/password like
this, using Win2k basic authorization:
Hey, administrator, I'm troubleshooting a template, would you see if
the test passes?:
htmlbody
Test Passed! Thanks, for checking,
How's about cutting and pasting the error, along with the debug
outputted query.
J
On Fri, 03 Nov 2000 08:13:45 -0800, in cf-talk you wrote:
I was using the following query:
cfquery name="AddUser" datasource="NOW"
INSERT INTO Users
(First,Last,Ride,Fav_Place)
Okay, here's what I'm trying to do:
I have a custom tag call embedded in a database field, which is being
displayed on a Web page.
Right now, the custom tag call doesn't work, because it's showing up in the
source without being evaluated.
So my database field says:
...blah blah blah
401 - 440 of 440 matches
Mail list logo