I thought of this, but it won't handle a string with more than one
period. Shucks.
select Val(Paragraph) as Para
from myTable
order by Val(Paragraph)
Any chance of changing the database so that Paragraph = 7.1.2 is stored
as 3 fields: ParaMajor = 7, ParaMinor = 1, ParaReallyMinor = 2?
SELECT Functubakthing, Count(Functubakthing) AS Count
FROM Table
GROUP BY Functubakthing
hth
e
From: James Taavon [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: What should be easy has eluded me...
Date: Wed, 10 Jan 2001 16:06:53 -0500
I am trying to
Why not write a form generator?
zero administration.
just cuz you asked.
doesn't mean you can't cashe the generated form.
(wait a minute aren't both scenarios "form generators". (i mnow what you
mean though).
E
From: David Cummins [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk
thanks for the responses.
actually I would like to have the word 2000 styles but insert the generated
html document into a cf template and it screws up existing style sheets. so
I need to parse through and remove the formatting elements, or cut and paste
the text and format myself (the winner
- Original Message -
From: "Al Musella, DPM" [EMAIL PROTECTED]
Sent: Wednesday, January 10, 2001 7:45 PM
my problem is the change in the database. I tried to restore the sample
database that comes with the new version, (into sql server 7), and I get an
error that says the header
Excuse me, folks, but has anyone else had trouble getting
messages from the
list? I didn't receive anything for several hours and now am getting
messages, but no backlog. Is it the list or my system?
The list server fell asleep again. That or everyone woke up at midnight
after a nice nap
I see the same thing from here...
Regards,
Howie
- Original Message -
From: "Hal Helms" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 12:46 AM
Subject: OT: list problems
Excuse me, folks, but has anyone else had trouble getting messages from
the
BE SURE TO REMOVE THE DOUBLE QUOTES...SEE REFERENCE MANUAL
-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 9:38 PM
To: CF-Talk
Subject: RE: App timeout and caching
that is correct, to the best of my knowledge and belief.
Both correct, but...
There is such a thing as CSS. If you think about it, the most useful thing
about HTML is that some of the attributes are defaulted on the client
machine. Bear this in mind, and you could easily create a form.
BTW a form generator is something that takes some data and
Joe
If I'm not mistaken you are only generating one recordset
(ie doing one SELECT) if the default record gets created,
whereas if it doesn't, you are generating 2 because of your
placeholder query.
Nick
-Original Message-
From: Joe Sheble aka Wizaerd [mailto:[EMAIL PROTECTED]]
Sent:
q is a struct already.
Nick
-Original Message-
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 6:06 AM
To: CF-Talk
Subject: WDDX result set
hi..
i want to convert the output of CFWDDX into a structure, how can i do that?
i tried with the following code
Maybe some of you already got this, but because of list problems and the
urgency, I dare to post again Please don't blame me too much
Does anyone know of alternatives to the CFLDAP tag. We are having problems
with CFLDAP tag and LDAP3 functions that are not suported by CFLDAP like
No.
Unfortunately RecordCount is only set by SELECT,
not by UPDATE, INSERT or DELETE.
Nick
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in
What's a "galldern minute"?
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with
How much a gall earns per minute?
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2001 10:58
To: CF-Talk
Subject: RE: (little OT) MS Word 2000 convert to HTML
What's a "galldern minute"?
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Are you planning on keeping Access as the data repository?
Back in 97 [Access 2.0/Access 95], I was involved in web-enabling an Access
application and it was not an easy task. The forms included multiple controls
including Access's sub-form control. The point is that these controls are
going
what was the context again?
galldern: Winnipeg Colloquialism: Gosh Darn
Eric
From: Aidan Whitehall [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: (little OT) MS Word 2000 convert to HTML
Date: Thu, 11 Jan 2001 10:58:01 -
What's a "galldern
Dan,
Careful! There are alot more than 50 records for this as they are generally
by county.
For example, Florida sales tax rates may be 6%, 6.5%, 6.75%, and 7%; South
Carolina rates are 5%, 6%, and 7%. Same thing with most states. I'm not
sure of a single source for all states. I got the 2
True, but it is my understanding that if you are shipping inside your own
state, you use your own office's county/city sales tax rate. But if you
are shipping outside of the state, you use that state's overall sales tax
rate, unless you have an office/location in that state and then you use the
I had a complete drought yesterday from 2PM CST until after 5PM CST.
Nothing from House of Fusion at all.
Russel
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
Some days you
Use the CGI Variable CGI.HTTP_USER_AGENT.
This little bit of code will detect any version od Internet Explorer:
cfif ListContains(CGI.HTTP_USER_AGENT, "MSIE", " ")
/cfif
Russel
Russel Madere, Jr. Senior Web Developer
yep, thanks.
"Christopher Olive, CIO" wrote:
recordcount is the number of records returned by the query. you're looking
for something like
select agency, count(*) as thecount
fromoimdbadm.assigned
where completed = 'Incomplete'
GROUP BY agency
At 10:46 1/11/01 -, you wrote:
No.
Unfortunately RecordCount is only set by SELECT,
not by UPDATE, INSERT or DELETE.
Here is what I ended up doing, in case anyone else ever has the same
problem.
SET nocount ON
UPDATE site SET password = CFQUERYPARAM VALUE="#Hash(Attributes.password1)#"
At 14:21 1/10/01 -0600, you wrote:
I've tried to get some help for this from the sql lists but haven't got any
response, so I'm going with the trusty CF group on this. Is what I'm looking
for is software to encrypt certain table fields in a sql 7.0 database. I
would also like to here from any of
-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 00:51
To: CF-Talk
Subject: chking of version in CF?
hi.. is there any wayi can chk the version of the client's browser in CF??
... or i must use javascript?
hmm.. any one know abt this
Anyone out there set a request.dsn instead of an application.dsn?
If so is there an advantage?
OK, answering the actual question;
The main advantage is that Request doesn't need an Application to be
defined, while (suprisingly) the Application scope does
The Request scope quickly allows you
it will not fix all your POP woes. trust me. ;)
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 12:18 PM
To: CF-Talk
Subject: CFX_POP
Hi fellow CFers,
I've heard a lot about a CFX_POP tag that will fix all your mail fetching
woes...
I have searched the archive but can not seem to find the answer to this
exact question...
Did NT 4.0 SP 6a fix the problem with CFCONTENT? I know 6 broke it... but
did 6a actually FIX it?
Thanks.
Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729
If a field in access has never had anything in it at all does it appear as
NULL or as "".
So would you check it with CFIF FieldName IS "" or would you use CFIF
FieldName IS NULL
Kevin Schmidt, Web Technology Manager
Allaire Certified ColdFusion Developer
pwb inc.
integrated marketing
When I got back from a parent/teacher meeting yesterday I found the list was
down. When I dug through it I found that the problem was a base64 encoded
message that was causing my CF template to bomb. I use a CF template to
parse ALL mail for the lists to clean it up, check it for viruses and
If a field in access has never had anything in it at all does it appear as
NULL or as "".
It appears as null.
So would you check it with CFIF FieldName IS "" or would you use CFIF
FieldName IS NULL
Well, ColdFusion does not support the word "NULL", so you would use the
cfif FieldName is
Anyone using fusebox uses the request.dsn (or .datasource). It can be done
either way and as far as I am concerned, there isnt an
advantage/disadvantage to either way.
--=@ greg @=--
- Original Message -
From: "Won Lee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday,
Hi everyone,
I wanted to know if anyone in the forum has developed a hard core interactive database
system using ColdFusion as the front end and SQL SERVER 7.0 as the backend. Does
anyone know if there are any examples on the web. I have seen allot of ColdFusion
sites but none of the
Hal:
The same thing is happening with me to and I have a pretty reliable network
and a brand spanking new Dell i800 laptop with plenty of juice, so I think
its the list.
--=@ greg @=--
- Original Message -
From: "Hal Helms" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent:
Nevermind, figured it out... wrap URLEncodedFormat() around your values...
-Original Message-
From: Scott Becker
Sent: Thursday, January 11, 2001 10:07 AM
To: '[EMAIL PROTECTED]'
Subject: CFHTTP to ASP, losing spaces
Alrighty,
I've got a CF page with CFHTTP
David said Why not write a form generator?
I said zero administration.
I say now: Huh, what was I saying?
Paul said
The only solution I can come up with, is to create a custom tag to generate
the custom HTML tags we want from a limited source, and then we get back to:
"Why not ignore
i want to convert the output of CFWDDX into a structure, how can i do
that?
i tried with the following code by using QueryToStruct custom tag but to
no
avail as it returns with an error saying that "q" is not a query.
If the wddx packet a query? What is being stored in the wddx packet? Can
Uh yehI'm in the middle of one! I am storing complex structures of user
data in SQL tables and pulling them into CF as Structures. About 5
databases. One holds a table containing 1/2 million recs and another holds
user data which we expect could be around 3 million users after 3
yearsso
True, but it is my understanding that if you are shipping inside your own
state, you use your own office's county/city sales tax rate. But if you
are shipping outside of the state, you use that state's overall sales tax
rate, unless you have an office/location in that state and then you use
what did your CFQUERY look like? did you use ;'s between statements? i was
playing around with cramming multiple statements in one CFQUERY, and could
never get the darn things to work correctly.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original
I wanted to know if anyone in the forum has developed a hard core
interactive database system using ColdFusion as the front end and SQL SERVER
7.0 as the backend. Does anyone know if there are any examples on the web.
I have seen allot of ColdFusion sites but none of the ColdFusion sites are
At 10:07 1/11/01 -0500, you wrote:
Anyone using fusebox uses the request.dsn (or .datasource). It can be done
either way and as far as I am concerned, there isnt an
advantage/disadvantage to either way.
If you use the application scope you always have to use CFLOCK to read
and write to it. A
I don't know but, but I do know I don't know much.
http://www.nsiregistry.com/cgi-bin/whois?whois_nic=dns2.alivenewmedia.mb.catype=nameserver
From what I understand. To have a name server recognized as a name server
all you need is a name server entry and a host record on the DNS running the
Let me see if I can help clarifyyou're asking if CF can be used as the
front end for a complex database?
The answer is...OF COURSE! And it will do it in a much more maintainable
way than ASP will.
If the database is properly designed, it doesn't matter what front end you
put on it.
If
Greetings,
I'm having a problem with the return values from a stored procedure.
Here's the call to the SP:
cfstoredproc procedure="sp_getrelationships"
datasource="EFGprograms"
returncode="Yes"
debug="Yes"
!--- Input to stored procedure ---
CFIF FieldName IS ""
has always worked for me.
Shawnea
- Original Message -
From: "Kevin Schmidt" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 11:08 AM
Subject: Access question
If a field in access has never had anything in it at all does it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We've been trying to get some domain record changes completed
through networksolutions and they haven't taken effect over the
last
couple days.
We've sent the request form a couple times. Last batch of
changes we made several weeks ago went
Hey Guys:
I was wondering if there is a way to insert the server path (e.g.
c:\inetpub\wwwroot\images) to just be /images. I need it to be able to resolve the
image path even if its deep into a directory stucture such as the user is in
/blocks/category/index.cfm, the images will resolve up
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
CFContent works fine in sp6a. You can't do the URL faking thing
anymore, but that was a bug that was fixed never should have worked
in the first place.
SP6 broke both CFContent and the URL thing. SP6a fixed CFContent,
but not the URL thing.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Assuming your webroot is pointing at c:\inetpub\wwwroot\ (IE
http://www.yoursite.com/index.cfm is really
c:\inetpub\wwwroot\index.cfm), then you don't need to do anything to
do what you want.
/images will be /images no matter what. Now... images
Did NT 4.0 SP 6a fix the problem with CFCONTENT? I know 6
broke it... but did 6a actually FIX it?
No. The "problem" with SP6+ and CFCONTENT is that, on pre-SP 6 IIS servers,
you could use a "fake" URL to tell the browser the file name of the
downloaded file. Here's an example of this:
Hi,
I use Dreamweaver's "Clean up Word HTML" function and it works fantastic. It
automatically discerns if the HTML doc was created from Word 97 or Word 2000
and wipes all the MS specific tags and CSS out.
Mike
-Original Message-
What are you guys using to convert word to simple
Hmm my thinking is this...
If you put in an application scope the CF Server has to open up a new thread
for each application variable and you need to lock it. If you put it in the
request scope in the Application.cfm you don't have use CFLOCK. However if
you put it in the request scope you will
Are you using a url encoded format for the form field values?
- Original Message -
From: "Scott Becker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 9:07 AM
Subject: CFHTTP to ASP, losing spaces
Alrighty,
I've got a CF page with CFHTTP call to an
Someone was asking me recently about a 'major' security hole in IIS. My
response was to point out the security pages at MS as well as other
resources. I'm reposting them to the list so that you remember the laws as
well. Security is everyone's business.
The Ten Immutable Laws of Security
I'm using CFStoredProc for Access queries. Is there
any way to cache them?
You can't use CACHEDWITHIN/CACHEDAFTER query caching with the CFSTOREDPROC
tag, but you can stick the recordset into a persistent memory variable
(Session, Application, Server).
Dave Watts, CTO, Fig Leaf Software
Try replacing the spaces with "+" signs or just URLENCODE the entire value.
Regards,
Howie
- Original Message -
From: "Scott Becker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 10:07 AM
Subject: CFHTTP to ASP, losing spaces
Alrighty,
I've got
I have a table that has three fields: Paragraph, Title, Content.
The Paragraph field is a text field, but is the outline number for the
particular paragraph in a document. For example, 7.1.1, 7.1.2, etc.
I need to output these paragraphs in outline order as they appear in the
printed
The query looked exactly as I posted (below). It has to have
CFQUERY tags around it, of course. No ;'s needed. The "set nocount on"
is the key. Multiple statements will run without that but you will
have a hard time getting anything back.
RPS
At 10:19 1/11/01 -0500, you wrote:
what did your
This is what I use:
CFIF isDefined("form.RefPresDate") AND form.RefPresDate IS NOT
""#CreateODBCDate(form.RefPresDate)#CFELSENull/CFIF,
On Thu, 11 January 2001, "Sean Daniels" wrote:
If a field in access has never had anything in it at all does it appear as
NULL or as "".
It appears
Okay, I have many existing verity collections that need to be indexed
weekly. I currently run a cfindex action="update" tag, followed by a
cfcollection action="optimize" tag. Is this the best way?
Thanks,
Ryan
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
if you're using IIS, use the MMC to create a virtual directory to resolve to
/images.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:35 AM
To:
I don't think it has anything to do with the SP. This:
CFLOOP INDEX="type"
LIST="#termtype#"
tells CF to try to treat the entire query as a list, which is why you get
the error. Try
CFLOOP INDEX="type"
LIST="#termtype.termtype#"
to pass just that field of the query as the
Has anyone done this exam? (Allaire Certified Web Developer Exam)
I went through the study guide on alliare.com a few days ago, but I
don't see any sample questions or references to standards i.e. W3C
HTML 4 standards, etc.
I'm certain I could pass the test anyway, but I would like to be able
to
When we do a simple CF output, as in:
cfoutput query="termtype"#termtype#BR/cfoutput
We get what appears to be a simple list:
30/15 Balloon,15 Year Fixed
You are probably not getting a list, but rather the first record of a one
row query resultset. The queryname being "termtype" and the
If you're only returning one result set, you can call the stored proc with
the CFQUERY tag, which will then allow you to cache the results as well. I
have also found that using CFQUERY rather than CFSTOREDPROC gives me much
more meaningful error messages. I got really tired of seeing "Unknown
Assuming your webroot is pointing at c:\inetpub\wwwroot\ (IE
http://www.yoursite.com/index.cfm is really
c:\inetpub\wwwroot\index.cfm), then you don't need to do anything to
do what you want.
What if this isn't the case and the site begins in a sub directory?
--=@ greg @=--
- Original
Use the CGI Variable CGI.HTTP_USER_AGENT.
This little bit of code will detect any version od Internet Explorer:
cfif ListContains(CGI.HTTP_USER_AGENT, "MSIE", " ")
/cfif
List commands are actually quite slow - try using
cfif CGI.HTTP_USER_AGENT Contains "MSIE"
/cfif
It should
No, still 100%
Aargh!
Michel Vuijlsteke
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 4:52 PM
To: CF-Talk
Subject: RE: CPU 100% (again, sorry) - with screen shot and theory :)
So no more 100%?
Robert Everland III
Web Developer
You could set an application variable that points to the images directory.
then just reference it where ever you need it through the directory
structure.
cfset application.root = "C:\inetpub\wwwroot\images\"
cfset application.webRoot = "http://yourdomain.com/images/"
EX:
img name="b2"
In that case I'll often set Request.urlroot or Request.imageroot in my
application.cfm file and then call images with
img src="#request.urlroot#/images/blah.gif"
or
img src="#request.imageroot#/blah.gif"
inside a cfoutput.
Take care,
Evan
-Original Message-
From: Greg Wolfinger
I've heard that if you can pass the CF test at www.brainbench.com with at
least a 4.0 out of 5.0, you should be OK for the Allaire test.
Todd Ashworth
- Original Message -
From: "Guy J. McDowell" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 11:48 AM
I would agree, the brainbench test was much more difficult then the Allaire
Certification.
-- Chris Stoner
- Original Message -
From: "Todd Ashworth" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 12:16 PM
Subject: Re: Allaire Certified Web
You could set an application variable that points to the images directory.
then just reference it where ever you need it through the directory
structure.
Thanks, Worked like a charm.
--=@ greg @=--
- Original Message -
From: "David Livingston" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL
True,
But in our IIS log, we found some spiders that had that in the string. The
difference was that the spiders had commas on both sides of the word, not
spaces. I could probably have used 'CGI.HTTP_USER_AGENT Contains " MSIE "'
instead, but ease of development our the primary concern right
Has anyone used this?
My Manager wants me to use this instead of CF for an application we have to
do.
The reasons sited was that he doesn't want to insert another layer of
complexity into the application design by having a CF Server running as
well, and having the hassles of adminstrating that.
We've been trying to get some domain record changes completed through
networksolutions and they haven't taken effect over the last couple days.
We've sent the request form a couple times. Last batch of changes we made
several weeks ago went through same day.
Anybody else notice this problem
The same thing is happening with me to and I have a pretty
reliable network
and a brand spanking new Dell i800 laptop with plenty of juice, so I think
its the list.
Funnily enough, PC speed has little to do with email speed - I could run a
P100 through a T1 link and it'd work faster over the
Hi. On the site that I maintain, each page has a series of links along the
side and bottom of the page. I want to set up header (side links) and
footer (bottom links) documents that I can CFINCLUDE from all over the site.
Links on the bottom are constant across the site. Easy. But links on
Thanks all it worked.
larry
--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]
Chaos, panic, and disorder - my work
The network admin is going to patch an NT4 server running CF 4.0.1 from
5-something to SP6a.
Are there any issues we should be aware of?
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
I am not criticizing any ColdFusion sites. I am only looking to obtain information
from the forum concerning the use of ColdFusion as an application and how it compares
to ASP with a backend database (SQL SERVER 7.0). I am on a deadline and I need to
make a presentation soon. I am gather
Thanks Brian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 10:45 AM
To: CF-Talk
Subject: RE: Complex Database System
Let me see if I can help clarifyyou're asking if CF can be used as the
front end for a complex database?
Talk to webserve @ LMCO EIS in Orlando, they have projects that are written
in CF.
-Original Message-
From: Foggy, Doreen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 1:28 PM
To: CF-Talk
Subject: RE: Complex Database System
Thanks Brian
-Original Message-
I tried again, didn't work.. I think the versions are different..
can someone who has forums running on sql server 7 generate a script for me
to create the database? (from enterprise manager, just select the database,
then all tasks, then generate scripts..)
Al
I ported the database
Matthieu-
I have done this on a medium sized site before. I don't know the size of
your site but here is what I did.
At the top of each page set a variable named "location"
cfset location="home"
Then within your navigation test your location so the site knows what to
show on the nav.
cfif
Here are some reviews of a few relative technologies:
http://www.zdnet.com/enterprise/stories/linux/0,12249,2646052,00.html
http://www.zdnet.com/eweek/stories/general/0,11011,2646051,00.html
Here are a few product comparisons between ColdFusion and ASP. Keep in mind
that they are both biased
I have developed extensive CF applications using SQL Server 6.5 and 7 as the
back ends. E-commerce, etc. with very complex databases. CF can certainly
handle the job. As can ASP. If don't know either of them, IMHO CF is the
easier of the 2 to learn. I think a definition of "complex database
Although you was probably only showing off g
Hell Yeh I was, I spent enough money on the damn thing. It rides up front
with a seatbelt on when I go to and from work.
--=@ greg @=---
- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Hi,
I am trying to send dynamic content, selected from one query, using CFMAIL.
It works fine as long as I am sending it to one person. The problem is I
need this mail sent to a group of people, from a second query. I can't seem
to nest (or not nest) my CFOUTPUT and CFMAIL statements properly.
Matthieu:
What I do is either CFMODULE a header file in, so it looks something like
this:
cfmodule template="header.cfm" PAGE="home"
or I include it like this:
cfset page="attributes.home"
cfinclude template="header.cfm"
And then the header.cfm file looks like this.
cfif
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
I am not criticizing any ColdFusion sites.
I'm sorry, I didn't mean for you to interpret my e-mail as being disgruntled
at your post. I was just wondering what lead you to believe that sites
weren't using complex data types. The fact is that ColdFusion actually
makes storing complex data
you know the tt mask in the timeformat function? well it always comes out
Uppercase. is there a mask that makes it come out lowercase? I was
thinking of using string functions to parse out the AM or PM and make them
lowercase, but there must be a simpler way!
use the LCASE function around the timeformat
-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 2:08 PM
To: CF-Talk
Subject: TimeFormat Function
you know the tt mask in the timeformat function? well it always comes out
Uppercase. is there
#lcase(TimeFormat(now(),'tt'))#
- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 2:08 PM
Subject: TimeFormat Function
you know the tt mask in the timeformat function? well it always comes out
Uppercase. is
Actually, isn't the Certified Web Developer a separate exam/cert. than
the ColdFusion cert?
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
Todd Ashworth wrote:
I've heard that if you can pass the CF test at www.brainbench.com with at
least a 4.0 out of 5.0, you should be
Here is a little snippet I use to encrypt and decrypt data that someone
posted to the list a while back
cfset
secret_word_encrypted=#ToBase64(encrypt("#customer_secret_word#","#customer_
last_name#1234"))#
cfset thevalue="#tostring(tobinary("#secret_word_encrypted"))#"
jon
- Original
thanx!!
-Original Message-
From: Brandon Paolin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 11, 2001 1:22 PM
To: CF-Talk
Subject: Re: TimeFormat Function
#lcase(TimeFormat(now(),'tt'))#
- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL
I have a problem and I'm not sure if it is CF, IE, or something else. I
have a page with lots of images (40), and usually when I hit it, everything
works fine, but occasionally, the page hangs while downloading the
images. I can check the downloaded code, and it looks fine, but the images
1 - 100 of 168 matches
Mail list logo