SELECT DISTINCT color from tableName where name='bar'
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 1:16 PM
To: CF-Talk
Subject: SQL query help
I have a database similar to this:
SKU NAMECOLOR STYLE
1 bar blue12
2
You can cfloop on a list
cfloop list=#ValueList(GetEmails.EMail)# index=oneName
cfmail to='[EMAIL PROTECTED]'
from='[EMAIL PROTECTED]'
subject='newsletter'
bcc='#oneName#
#Message#
/cfmail
/cfloop
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
And PLEASE be aware that this is potentially very dangerous. Do YOU have
full control over what goes in and out of the database? Be aware of your
risks before you take this action.
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 12:46 PM
No, I think cfselect NEEDS just a field name.
You CAN do what you want directly in your query. The syntax will differ
with DBMS, but with SQLServer you can do:
cfquery ...
SELECT 'ratecenter '+substring(phonenum,6) as myRateField
/cfquery
and then you could use myRateField in your cfselect.
Look up the BETWEEN operator -- it is your friend
-Original Message-
From: Tim [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 10:50 AM
To: CF-Talk
Subject: WHERE statement with multiple ANDs
I am a little confused as to how to code a WHERE
statement that has more than one
Your problem is because the adminstrator applet that shows you files doesn't
recognize network drives.
You can write CF code to index your varity collections -- see the CFINDEX
tag. THIS tag CAN take network names like \\joesServer\hisdocuments
-Original Message-
From: MacDiarmid,
I thought that Netscape came WITH such a thing? Composer I think it was
called. Check out your Netscape menus and see if it has an edit option
and go to town!
-Original Message-
From: Bill Holloway [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 11:24 AM
To: CF-Talk
Subject: NS
Yes, certainly it does. when you use that same variable name as the loop
index. Change the name of your loop index. call it iProd maybe like
this:
cfloop list=#valuelist(prod.productID)# index=iProd
cfparam name=total#iProd# default=0
cfparam name=amttotal#iProd# default=0
Count doesn't need the ISNull check. I believe that Count will count all
non-null fields so you just need:
count(go.dMonthlyEventDate)
-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 1:36 PM
To: CF-Talk
Subject: SQL - Count Function Error
No, you're not still asleep, just bitten by the boolean bug.
Look at your statement:
if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9))
{ report error }
This says, if the length is not 5 or if the length is not 9, report the
error. To get past this, the length of the variable
The easy answer is to put a title attribute on the link, then many
browsers show it automatically.
a href=... title=Click here to go therelink text /a
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 11:06 AM
To: CF-Talk
Subject: ot on
Here's a combination of things I do for this to 1) ensure that all users get
a download window (including Macintosh users) and 2) get the fastest time to
write the file.
I do it with a combination of CFM and Java. I've got a Cold Fusion custom
tag written in Java -- I've pasted the source code
Which search engines? Each one could do it their own way.
When I worked in a corporation with a webcrawler, it crawled everything,
indexing Word, Excel, PDF, everything. We had to make special efforts to
get them to stay OUT of the CFM files.
-Original Message-
From: Bud
You said:
this always open a new window from the mail program.
What else would you have it do? I wouldn't want to browse your web page
from inside my mail program. I want it to open a browser window
Yes, you can use style sheets if you give them a full url, including
Nope. Sorry, Steve, but this won't open in a MAXIMIZED window unless the
original window was also maximized.
btw: any solution to this will be completely WINDOWS specific. My mac could
care less if you want my windows maximized. For demo purposes (as Erika was
asking for) or for an Intranet,
Yep -- just what I thought. You never close your table. Netscape won't
display a table unless it's complete. Make sure to include a closing table
tag.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 1:41 PM
To: CF-Talk
Subject: blank cfm
Na, don't give up control to CFTable -- you CAN do this, it is just a bit
trickier.
The following code will start a row for odd-numbered entries and close the
row after even numbered entries. Take a look:
cfoutput query=qry_list_links
cfif currentRow mod 2 is 1 !--- this is an odd row ---
tr
Bill, please post the code that threw the error. Let's see
qry_postcompanysurvey.cfm
We're not psychic! ;-)
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 2:05 PM
To: CF-Talk
Subject: Email Forms
Ok heres the issue, i am sending
You can do this ALL with one function:
timeFormat(BeginTime,h mm)
The lower case h tells it to use 12 hr clock (use upper case for 24 hr)
(Note you don't have to say QRYCasacActivity.BeginTime because you are
inside a CFOUTPUT with query = QRYCasacActivity)
-Original Message-
From:
If you want to use CFINPUT, you have to live with it.
I found early on that I couldn't count on the CFFORM javascript and write
all my own Javascript validation code. You can find many examples on the
net, like http://irt.org
-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL
The best way I know of is to use surround it with pre/pre That will
perserve spaces and line breaks
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 12:26 PM
To: CF-Talk
Subject: Access Memo field format
This has probably been asked before,
??? You say the name of the query is an integer, but in the example you
gave,the name is myQuery. If it is really an integer, this is NOT good!
Names cannot begin with a number. Try adding a character on the front of
it, like:
cfquery name=q_#queryName# ...
...
cfset queryCount=
Yes, but his queryName was dynamic, that's why the evaluate IS needed.
-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 4:29 PM
To: CF-Talk
Subject: Re: Dynamic Queries (RecordCount)
you should be able to just output the
The field that you are using as part of your variable name contains a /
which is not a valid character in a variable name. In the error message you
included, your field value was
E6_HL_C/CCNOADD THIS is the forward slash you have to get rid of.
-Original Message-
From: JAAV
So, what's your problem. You said what you'd like to do, you showed your
code, what's not working?
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 6:13 AM
To: CF-Talk
Subject: Select Boxes limiting drop down :: Brian Lock
Ok i know this is
Your query and select look a bit screwy. In your query you are selecting
all rows where the name is not equal to the ID. Is that really what you
wanted? Go back to your original queries -- you were trying to select all
where #get_golf.employeeName# .employeeID Did you really mean to compare
There's a CF function that should replace your CFLOOP
Change:
cfloop
query=Get_GolfCFOUTPUT#Get_Golf.EmployeeName#,/CFOUTPUT/CFLOOP
To:
#valueList(Get_Golf.EmployeeName)#
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 9:48 AM
To: CF-Talk
You can use structDelete.
For example, to delete session.fldName, structDelete(session,fldName)
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 8:21 PM
To: CF-Talk
Subject: Delete session variable
Is there a way to delete a session
Logic error -- do you have any records where the part_id is 751 AND 752?
Change Part_ID = 751
AND
PART_ID = 752
to Part_ID IN (751,752...)
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 8:25 AM
To: CF-Talk
Subject: Updating multiple rows!
Duane -- if you really don't have control over the input (ie you don't have
the option to use tabs instead of commas), you may have to write the import
code yourself. Read in one line, parse the line for strings inside double
quotes, change the commas in those strings to some type of place
Here's the magic you need:
#evaluate(form.materiali)#
-Original Message-
From: Jen R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 12:17 PM
To: CF-Talk
Subject: Dynamic Variable Names
In my database I have the fields material1, material2, material3,
Yes, Zac, but there are MANY people who use the web from public kiosks --
public libraries, schools, and internet cafes. There is no blame here --
only the awareness of WE -- the developers.
WHO uses your application should dictate HOW you allow them to send you
feedback.
If you want
Yeah -- Java more than JSP. Java custom tags are killer.
But what do you need to do?
Splash up a user interface, then Flash yes.
Energize serverside processing? Perl or Java -- generally Perl is used more
on Unix systems, but that line is fading fast. I work at a company that's a
Java
There is also a tag at the Allaire sight that not only checks the syntax of
the email, but also ensures that the mail server exists. I think it's
called "isEmail" and the only downside I found with it is that it hangs and
causes a timeout if you are not connected to the net when it's used (kinda
What Homer Simpson (? aka HTH) wrote was NOT that you couldn't create or
reference QUERIES (ala CFQUERY) in a CFINCLUDE but that you couldn't pass
parameters on the QUERY STRING (the stuff after a ? in the URL) with
CFLOCATION.
We can all agree on this, right?
The original code that Gina showed
If you have cookies turned off, you must pass #session.urltoken# to each new
page.
So your form would look like:
form action="login.cfm?#session.urltoken#"
You must remember to add this to ANY link (a) or form that moves to a new
page.
-Original Message-
From: Jordie Fike
Oops -- of course I meant CFINCLUDE, not CFLOCATION in that first paragraph.
-Original Message-
From: Jann VanOver [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 12:52 PM
To: CF-Talk
Subject: RE: CFINCLUDE problems
What Homer Simpson (? aka HTH) wrote
This will not work because you be overwriting "GetRolloverDetails" each time
through the loop. When you're done you'll only have values from the last
time through.
CF actually gives us a GREAT way to do what you want!
The function "valuelist" takes the description of a query field (query
Whoa there -- Studio DOES do wildcard search and replace! It even does
(it's own version of) Regular Expressions! Take a look at "EXTENDED" search
and replace!
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 4:15 PM
To: CF-Talk
Joshua,
RE your Question #1
Check out "CF_Popdate_Resolve" available from the Allaire Tag Gallery. It
"converts date strings commonly found in POP mail to usable date/time
format."
URL =
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347736-2830-11D4-AA
9700508B94F380method=Full
No, but you CAN put the CATCH CLAUSE in an include. This allows you to use
the same CATCH processing on many pages in a modular way.
For example
cftry
... code code and more code ...
cfcatch type="database"
cfinclude template="catchDBClause.cfm"
/cfcatch
cfcatch type="all"
cfinclude
I have found many cases when this doesn't work. I've often gotten errors
that look like the "onLoad" handler was run before the page finished
loading. (error says form or field not found). I do NOT trust the "onLoad"
handler. In cases like this, I've put the focus statement at the end of the
One Caveat that kept catching me -- when you use the "submit()" method to
submit a form, the "onSubmit" will NOT be executed. I had to learn to
explicitly call any javascript that I wanted to be executed before the form
was submitted.
-Original Message-
From: David Shadovitz
No. A Case value must be a primitive expression.
To do what you want, abandon CFCASE and use a series of IF/Else statements.
That has flexiblity to evaulate other conditional expressions.
Can you use CFCASE to evaluate numeric expressions such as a between =
statement, or greater
I use the "ObjectDump" tag (by Nathan Dintenfass) from Allaire's tag
gallery to dump out ANY variable -- array, query, structure, or unknown. I
couldn't live without it.
Anyone know of a quick way to dump an entire arrays contents to the
screen?
jon
I use the "ObjectDump" tag (by Nathan Dintenfass) from Allaire's tag
gallery to dump out ANY variable -- array, query, structure, or unknown. I
couldn't live without it.
Anyone know of a quick way to dump an entire arrays contents to the
screen?
jon
Jason didn't say WHY he cared about even or odd, but if you want to use it
to make every other row a different color, a great "trick" is to include
the digits "0" and "1" in style class names and then use the MOD value to
pick which style without ever having to use CFIF
You just define style
Has anyone been able to get CF server to log the content of all emails
sent?
Not Automatically. On some apps we use our own custom tag to send email
and in that we can log the entire text of the email.
Not one of our CF servers is doing so, despite the mail logging severity
being set to
The only time I've had recordcount undefined is when 1) the query was
somehow invalid OR
2) the CFQUERY didn't contain a SELECT but instead did an INSERT or UPDATE.
I suggest you look more closely at your query to ensure it has no "hidden"
problems.
-Original Message-
From: [EMAIL
This is a SQL command -- it depends on which DBMS you're using. It has no
dependance on CF except that CF pass the info to the DBMS correctly.
-Original Message-
From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 08, 2000 6:05 AM
To: CF-Talk
Subject: Re: Bulk imports
Item number 1 is not true.
Item number 2 is not true some of the time
Item number 3 is true all of the time
-Original Message-
From: Kinley Pon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 21, 2000 12:02 PM
To: CF-Talk
Subject: Session Variables
Hello everyone,
I was under
You should always "protect" text going into URLs with CF's
URLEncodedFormat() function. This SHOULD prevent vagaries of browsers.
Try:
a href="template.cfm?word=cfoutput#URLEncodedFormat("a,b
c")#/cfoutput"
-Original Message-
From: cf-talk [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
What is the title of a template?
You may be able to get the title of the HTML with Javascript (document.title
or something like that).
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 15, 2000 7:32 PM
To: CF-Talk
Subject: template title
Is
Your function (checkfield) must return true if it wants the anchor acted on.
-Original Message-
From: Nathan Chen [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 15, 2000 1:42 PM
To: CF-Talk
Subject: Re: Not Working in Netscape
Hi Jay,
I ran into a similar problem and I used your
How is caching the query different from saving it as a session variable?
Both are kept in memory, right? Except that the cached one will get bumped
if memory is needed?
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 8:31 AM
To:
Read up on regular expressions. They can do this.
-Original Message-
From: Albert, Gregory Mitchell (Greg) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 10:15 AM
To: CF-Talk
Subject: Find "n" occurrence
Is there a way to find the third (or "n") occurrence of a
Each piece of email you send should look something like this:
html
body
the real message
/body
/html
-Original Message-
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 2:54 PM
To: CF-Talk
Subject: Re: Email links lost
Ok, I see what you are saying, but
If you're displaying it as HTML, try the HTML PRE tag around the output.
That will retain line breaks
-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 4:30 PM
To: CF-Talk
Subject: RE: format question
But doesn't that one pick up blank lines
Thanks Aaron! I wasn't the person who posted the problem originally, but
I've been having the same problem with Studio 4.5.1
The article you referred to fixed it for me!
Thanks again!
-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001
It turned it into "1" because in CF the "backwards" slash is the integer
division operator. (very confusing imho -- why not use DIV as some other
languages do?) I've asked my programmers to ALWAYS comment their code when
using this operator to prevent future confusion factors.
-Original
I believe that NS is following spec.
DIV is a high level container. a FORM element is not SUPPOSED to be split
across multiple DIV elements. You must have a separate form in each one.
In this case, other browsers are just more forgiving, not more correct.
-Original Message-
From:
It says in the docs,
"The absolute value of the counter has no meaning. Generate useful timing
values by taking differences between the results of GetTickCount() at
specified points during page processing."
Take the count at different times, subtract, you're left with the number of
milliseconds
Are you talking to SQL Server? I don't think it likes the table name
"Users" Try putting square brackets around the table name, eg. "[Users]"
and see if that helps.
AND run it with debugging on to show the SQL and the result. This will let
you know whether the SQL is actually being executed
BTW: a GREAT Javascript resource, http://irt.org/ (irt stands for Internet
Related Technologies)
script
function checkAll() {
document.formName.chk1.checked=true;
document.formName.chk2.checked=true;
document.formName.chk3.checked=true;
}
/script
Or just give the checkboxes a name
Beware! Mastering Cold Fusion 4 has MANY MANY misprints in it.
-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 3:34 PM
To: CF-Talk
Subject: RE: SESSION Timing out WAY before it's supposed to.
If removing those double quotes is the
Um ... Netscape doesn't perform these functions, your server does. If you
were doing it in Javascript, it would be up to the client (Netscape or IE),
but this looks like CF code which executes on the server.
As someone else hinted -- Netscape is slow to render tables so if your app
has a lot of
Escape single quotes to SQL with \'
-Original Message-
From: Dixon, Aidan [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 7:08 AM
To: CF-Talk
Subject: Escaping quotes in Replace function for SQL Server 7
We have a classified ads section on our intranet currently running on
It may not be clear from the documentation, but CFMAIL ACTS like a
CFOUTPUT tag (with no query name). You do NOT have to use CFOUTPUT to
access CF variables inside the CFMAIL tag. Try just taking the CFOUTPUT
tags out.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Some of Katrina's code could be even shorter. Check out the functions
"LJustify", "Rjustify", "CJustify" and "RepeatString"
- Original Message -
From: "Chapman, Katrina" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, November 03, 2000 12:53 PM
Subject: RE: padding a
First clue, you don't need to use CFOUTPUT inside a CFMAIL. Fields from the
query named in the cfmail tag don't need to be qualified with their query
name, but fields from the other query DO. In the example below, stuff from
the query named "details" must have the "details." before the field
This has happened to me when the browser is short on memory or its cache
area is low on hard disk space
-Original Message-
From: Greg Saunders [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 11:35 AM
To: CF-Talk
Subject: images stop loading?
I have a problem and I'm not
FYI: John's solution doesn't work with older (v#?) CF. It counts on the
expression evaluation short circuiting -- in other words if
"form.refpresdate" is not defined, it doesn't attempt to evaluate the rest
of the expression.
Older versions will STILL attempt to evaluate 'form.refpresdate is not
Gee, in my state I believe that even City municipalities can levy sales tax.
I live in Seattle and the sales tax is higher here than in outlying cities
in the same county.
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 9:43 PM
To:
FYI:
Java is NOT the same as Javascript
That being said, what kind of compare would you like to do? Once you learn
Javascript, it is an easy thing to check any and all form values before a
form is submitted, but exactly how to do it depends on what you want to
compare.
-Original
First guess -- the problem is in the CFAPPLICATION tag --
setclientcookies="no"
Without this, you have to pass CFID and CFTOKEN on URLs.
adm.cfm?pid=#pa_id#
must become
adm.cfm?pid=#pa_id#CFID=#session.cfid#CFTOKEN=#session.cftoken#
If you setclientcookies="yes" it doeesn't need this.
The
Did you send this to Spectra-Talk? They may know what's up
-Original Message-
From: Deepak Agarwal [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 8:14 AM
To: CF-Talk
Subject: PLEASE HELP!!! cfserver.exe takes up 100% resources
Dear All,
We've been using CF4.5.1, Spectra
No. CF doesn't see the file until AFTER it's moved to the server
-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 9:11 AM
To: CF-Talk
Subject: ColdFusion File Handling
We got a bunch of file uploading forms. we want the max file size to be
Wow indeed! I hope that means that Allaire Partners will now get Macromedia
products! I'd LOVE it if my dev team all had Dreamweaver but we just can't
afford it for everyone.
-Original Message-
From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 2:05 PM
To:
Yes -- have you tried what you describe? I think that should work as you
typed it!
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 12:41 PM
To: CF-Talk
Subject: Passing Queries to custom tags
Is there a way to pass a query to a custom
I haven't tried this, but I expect it wouldn't work. I certainly don't
think it's good style because you have two "containers" (the CFIF element
and the CFLOOP element) that overlap and this is never good markup.
Try it and see.
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL
cfoutput
#evaluate(variable2)#
/cfoutput
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 12:15 PM
To: CF-Talk
Subject: Questio\n
Dave,
Sorry to bother you but the list is down and I have a project to get done
asap. I am stuck.
I have
Use the Database to do the hard part:
cfquery name="Get" datasource="wweb"
SELECT count(cbi) as cbicount
FROM wweb
Where cbi like 'CBI'
/cfquery
CFOUTPUT
#wweb.cbiCount#
/CFOUTPUT
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18,
No, this is not correct.
Application.cfm MAY have HTML in it -- but that HTML will be included at the
top of EVERY PAGE! If that's your intention then it will work.
I have coded apps before that use Application.cfm to write the entire HEAD
(tailoring the title by looking at cgi.script_name)
Will this stop altleft-arrow from going back?
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 2:27 AM
To: CF-Talk
Subject: RE: How to disable "Back" function on browser
Is there a way to disable the "Back" function when the user
Look into the CF function "fileExists()"
-Original Message-
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 1:01 PM
To: CF-Talk
Subject: check for file
i'm trying to include a file, but i'm not sure that it's there. if it's
not, i need to run a module that
Yes. CFINDEX has attributes that tell it you're UPDATING the catalog.
-Original Message-
From: Chris Stoner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 8:45 AM
To: CF-Talk
Subject: Indexing Query and Files at a same time
I have a publication system that catalogs files
Umm ... I think you just learned a bit about how CFFILE works.
It will NOT attempt to replace CF variables in the file you are reading and
writing. That is NOT what CFFILE does.
Perhaps:
CFFILE ACTION="Write"
FILE="h:\contracts\documents\#newfilename#"
OUTPUT="#evaluate("contract")#"
queryname.fieldname[#]
So, if your query is named "mystuff" and the field is "myfield", you get to
row 3 with:
mystuff.myfield[3] or in your case mystuff.myfield[thisRecord]
-Original Message-
From: Geoff Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 4:36 PM
To:
Well, I've used it mostly to translate POP dates (the kind that come in
email headers) into "standard" date formats.
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 4:27 PM
To: CF-Talk
Subject: ParseDateTime()
What exactly is the use of
Just one thought -- is your mail server in the "actLogin.com" domain? If
not it may not be allowing you to send mail with that domain in the "from"
header.
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 8:06 AM
To: CF-Talk
Subject:
Yes -- you may need parenthesis -- I usually do, just in case:
CFIF (mTEST1 EQ "ABC" AND mTEST2 EQ "DEF")
Sometimes I'm REALLY careful and do:
CFIF ((mTEST1 EQ "ABC") AND (mTEST2 EQ "DEF"))
-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 09, 2001
Jimmy,
We sometimes use Perforce and it works very smoothly with CF Studio. Define
projects, tie them to Perforce, and Studio helps manage your check-ins and
check-outs. We have also used Visual Source Safe and they both behave quite
well with CF Studio.
-Original Message-
From:
I like to use this in a little different form:
cfif NOT ListContainsNoCase("popup.cfm,popup1.cfm",PageName)
...
/cfif
More efficient (List functions are very fast in CF 4) and easier to add more
exception pages when you need to.
-Original Message-
From: Adrian Cesana
Nope. Can you post the full error message and the code that you think is
throwing it?
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:27 PM
To: CF-Talk
Subject: unbalanced in cfmail
anyone know what unbalanced error when running a cfmail tag
09
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 1:48 PM
To: CF-Talk
Subject: Tab Char Code
Anyone know the #CHAR()# code for a TAB???
Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[EMAIL
I think you've misunderstood GROUP BY What is your intent for the GROUP
BY ??
If you change GROUP BY to ORDER BY, you can then use the GROUP
attribute on CFOUTPUT (or CFLOOP) to group together records with one
field in common.
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL
Like you said, you've got a firewall -- I get cannot find server with that
URL.
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:17 PM
To: CF-Talk
Subject: OT: HTML Question with Netscape 4 and 6
Can someone please tell me why these
If your hosting provider allows CFX, there's a CFX_File in the Allaire dev
exchange that would do the job.
-Original Message-
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 10:46 AM
To: CF-Talk
Subject: file uploads without using CFFILE
If hosted
I sincerely disagree. I'm just a home user of Mac (my work is all Windoze)
and I keep TRYING to like IE 5 for the mac, but it bombs out, locks up, and
is a whole lot slower than 4.5. Each time they come out with a new 5.0
version I try it out, and each time I've ended up going back to 4.5.
As
Well, you should wait at least a day or two before you whine. Your question
just showed up this morning.
-Original Message-
From: Craig Kiessling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 1:45 PM
To: CF-Talk
Subject: RE:
Dylan-
1) Probably so - I posted it previously
1 - 100 of 215 matches
Mail list logo