Hello,
I have an Access table that I need to get a count for a specific value in
each column. The coding below does the trick (on one column), but is too
slow since I have numerous columns. I'm kinda a newbie on this so I was
wondering is there away to make the count quicker by combining some of
I am hoping this isn't overkilling a topic, but say I wanted to use something
different the the verify search which checks pages, docs, the db's and what not. What
else would I use that can do all that.
Thanks
~~
Structure your ColdFusion code
You could turn this into a GROUP BY query
cfquery name="Getastindex" datasource="wweb"
SELECT COUNT(ast) AS ast_count, ast
FROM wweb
GROUP BY ast
ORDER BY ast
/cfquery
Then, your results set would be something like:
ast ast_count
You could use a combination of Index Server and SQL Full text searching.
That's all I know of.
Robert Everland III
Web Developer
Dixon Ticonderoga
-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 4:24 PM
To: CF-Talk
Subject: Verifty
Maybe one of the Gurus here can enlighten us. I have used the Attribute
variables in many SQL queries. Here is an example query I use:
SELECT AssetName, ...
FROM Asset
WHERE AssetID = #ATTRIBUTES.AssetID#
AssetID is a select box value in the previous form. This query has never
given
Hey, all those multimedia gurus
My supervisor asked me to make a training video of our applications.
He likes the results that the virtual training company... www.vtco.com produces and so
do I. What are they using to
produce such fine quality?
I just do not know what software to use to
SELECTast, count(ast) AS counter
FROM wweb
WHERE ast IN ('ASTIndex', 'ASTAI', 'ASTft')
GROUP BY ast
You're using LIKE improperly here as it's useless w/o a wildcard (%) char;
just use = if you want a direct match. If you do need the wildcard use a ast
LIKE '%foo%' OR ast LIKE
I'm doing this via the web component server and page server. It works very
well (after a bit of frustration figuring it out and setting it up.) The
documentation is very weak. But the product itself is easy to use and it's
easy to integrate CF. If you'd like more specific info, feel free to
We too are using this. You do not need the development version for
this either.
Has anyone had success using the CFREPORT tag with CrystalReports 8
and CF4???
Cheers!
--
Douglas Knudsen
LTT, that's Leveraged Technologies Team --- Hey! These views are
mine!
[EMAIL PROTECTED]
Got
Nope. I mean that you choose the right tool for the job. Jeffry Houser said
it best when he stated "Each one has it's strengths and weaknesses". You
need to evaluate your project, define the requirements and choose the best
tool for producing a solid solution, on time and within budget.
Rey...
I've found that the easiest way to reduce the amount of
whitespace is to remove it from the actual templates once
they've been deleloped, though it obviously means your file
back up system needs to be pretty, er, well backed up.
Here's what i do:
1. develop on one server and use visual
No. I tried this for a while. Then heard (thru this list) that the
CFREPORT tag would not work with CR8 and there was no plan to make it work.
So I started working on Crystal instead. Actually, now that I'm using CR, I
prefer it anyway.
Athelene Gieseman
-Original Message-
From:
if you're using SQL server 7 you should _always_ use Val() in
CFQUERY tags when expecting an integer because if your CFQUERY
says:
SELECT foo
FROM bar
WHERE id=#url.id#
and someone changes the URL from:
www.mysite.com/qwe.cfm?id=1
to
www.mysite.com/qwe.cfm?id=1;delete%20from%20bar
On a side note, Windows NT/2000 Magazine publishes an archive
CD of their magazine a couple of times a year. Up until a couple
of years ago all the content had a .cfm extension and allowed
dynamic searches on the content contained on the CD. This was
possible even if no network
Has anyone here implemented a progress bar.
Similar to what happens on expedia when searching for travel information.
What is the key to this with a web based app?
Thanks,
John Anderson
~~
Structure your ColdFusion code with Fusebox. Get the
Hello everyone.
I am working on an application that manages private groups membership, and
one of the function the client wants included is the ability for an
administrator to write an email, then submit it to all the members of a
given group. What I want to know, is will the built in cf mail
i loop over a db of over 50,000 addresses and it's fine, but i have to break
into chunks of about 8,000. and don't forget to set your timeout to be
slightly higher if you start looping over hundreds or thousands.
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent:
Chris,
I had to create a mail solution similar to this once. I couldn't put
multiple email addresses in "to" or "cc", and I couldn't use "bcc". I had to
loop over the cfmail tag to send each message. It was for a list of about
300,000 people, so I had to limit the number of emails that went out
Hi all,
I'm just getting my feet wet with CF and am having a problem using the
abovementioned title that the author doesn't address. I've gotten several
problems that I think I fixed. First was something about server development
which I fixed by switching directories (I think I've forgetten
I'm trying to execute a dts package through CF but have only been able to do
it through the dtsrun.exe utility and using cfexecute. The problem is the
server I need to do this on doesn't have dts installed. Is there anyway I
can still execute a dts packaged from this machine? Maybe using a stored
Try using inFusion Mail Server SE. I think it allows up to 50 or 60
recipients, use of BCC. It free, so why not try it.
Richard Ramos
Network Administrator
Softitler Net, Inc.
www.softitler.com
[EMAIL PROTECTED]
- Original Message -
From: "Chris Martin" [EMAIL PROTECTED]
To: "CF-Talk"
Yeah, they did basically scour their existing content, index it and so on
but, the CD definitely allowed you to perform dynamic searches, highlighted
by relevance, etc. I think that's what most people really want when they ask
"is their an 'embedded' CF?". It would be nice, of course, to have the
The number of recipients in POST-SE is limited only by system resources...
Regards,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE
John, there is no real clean way to do this now (lots of kludges though). As
I demonstrated at the Developer's Conference, CF5 has a new tag called
CFFLUSH that does exactly what you want. And CF5 starts beta pretty soon.
--- Ben
-Original Message-
From: John Anderson [mailto:[EMAIL
I demonstrated at the Developer's Conference, CF5 has a new tag called
CFFLUSH that does exactly what you want
^
|
|_ yeah baby! That cures some of my ASP-envy. :)
thanks for the info, Ben!
-ron
~~
Structure your
Expedia uses the IE specific document.readyState and a timer calling the
function (Javascript).
Both the initial search criteria and the "Please wait" section are on the
same page. When you begin the search it hides the one part and displays the
"Please wait" part. A timer is started and it
Ah... the Evil Whitespace...
All CFSETTING does is remove any white space that "CF puts in". If you love
indented web pages and use this extensively for your HTML, CF didn't put it
in, YOU DID. If, however, a CF tag, once processed, would introduce space,
CF will do string processing to
Steve,
404 is always a path error or a type in the URL. I suspect that you have a
path mapping problem. If you tell me the URL you are using, where your
scripts directory is, and how it is mapped I can try help you.
--- Ben
PS Reply to me directly, not the list.
-Original Message-
I'm trying to execute a dts package through CF but have only
been able to do it through the dtsrun.exe utility and using
cfexecute. The problem is the server I need to do this on
doesn't have dts installed. Is there anyway I can still
execute a dts packaged from this machine? Maybe using
Yeah, they did basically scour their existing content, index
it and so on but, the CD definitely allowed you to perform dynamic
searches, highlighted by relevance, etc. I think that's what
most people really want when they ask "is their an 'embedded'
CF?". It would be nice, of course, to
Feature of ColdFusion:
-Database Connection Pooling
-Automatic Server Fail Over
-Server Sandbox Security
-Dynamic Load Balancing
-Standards-based integration with directory, mail,
HTTP, FTP, and file servers
-Multi-threaded
I don't understand about that. Can someone help me to
tell me(explain
I did it in a rather simple way... doing it by creating a hidden layer that
has a "bar" (a graphic, button, etc.) in it. Create a function in
Javascript that shows the layer when you click something. The function
alters the size of the bar as time passes, say every 10th of a second. When
the
hallo, everyone
I want to ask some question.
What is the use of Session and Application Variable?
What is the use of evaluate dynamic expression ?
Thank's for your answer.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Session Application Variables are variables that are stored on in SERVER
RAM, and hence due to that fact need to belocked using CFLOCK, what you can
do with those variables though is to use them to pass persistant data to the
client browser.
Evaluate() is a command that lets you evaluate the
-Database Connection Pooling
Database connection pooling simply means that
ColdFusion can be set up so that a database connection
is opened once and re-used many times. The
alternative is that database connections are opened
and closed every time a query is executed in a
ColdFusion page. With
Sounds like you are diving into CF with your eyes closed. You would
probably benefit from reading the documentation that comes with it. You can
download it at the following location if you don't have a hardcopy.
http://www.allaire.com/developer/documentation/ColdFusion.cfm
Don't let that stop
Session and application variables are global
variables. Once they are created, they can be accessed
by any page in a ColdFusion application. The
application.cfm file must be used to name the
application before application scoped variables can be
used and session managment must be turned on
And taking the Allaire classes. They are so well
constructed that they really pack a lot in three days
and always get you so far ahead.
--- Cameron Childress [EMAIL PROTECTED] wrote:
Sounds like you are diving into CF with your eyes
closed. You would
probably benefit from reading the
--part1_6b.f450db3.27aa2d86_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Hi All,
I'm new to CF can you please take a look at my code and tell me what's wrong
with it. Or if you know of a tutorial for this script?
tell.cfm
form action="mailpage.cfm"
the fast track classes i have heard nothing but bad things about.
When i took the Advancaed class it was much better
Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
AFAK these issues are the core ones addressed by J2EE.
That is to say (ask), is CF about to provide a 'link' to EJB, so you
don't have to know EJB, just use CF tags?
(BTW I love CFOBJECT and I know, there must be *tons* of things behind
the tag.)
That would be *great* (if it's feasible and
You must have children, Steve. ;o)
Rey,\\
Certified Allaire Instructor
Member of Team Allaire
"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
- Original Message -
From: "Steve Bernard" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, January 31,
If the tell a friend link is on the page you want to send in the email then
use #CGI.HTTP_REFERER# in the hidden input field.
Sebastian
on 1/31/01 9:09 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
--part1_6b.f450db3.27aa2d86_boundary
Content-Type: text/plain; charset="US-ASCII"
better if you can provide the error message that you get when you run these
pages, so we can help you to debug.
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, February 01, 2001 11:09 AM
Subject: Help with Tell Friend script
FYI
~~
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:
Or thought of in a simpler way:
The Cold Fusion parser takes the CFML tags OUT of the page, and replaces them with the
HTML that the tags generated.
The "NEWLINE" at the end of each CFML line is *NOT* considered part of the CFML tag
(obviously, only the parts in are part of the tag) and the
No, but Spiderman is much better than the Hulk.
End of topic please.
At 06:42 AM 1/31/01 -0800, Michael wrote:
So do you mean jsp pages are better then cfm pages?
"Rey Bango" [EMAIL PROTECTED] wrote in message
really? i took the fast track and thought it was pretty good. i had tought
myself much of what was in it, but it was nice to see why things worked the
way they do.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: William J
I am building a Multilingual / Multi-locale site. The most effective way I
have found to do this is to pregenerate versions of each page for each
locale and each language. The involves a simple publishing system that
glues various components together and writes out multiple versions of each
Dear all,
The CFX_CRWTOPDF tag doesn't appear to be avavilable on the Allaire DevEx
site. Can anyone provide me with a copy? The full package with the
included instructions if possible.
Many thanks,
Keith
~~
Structure your ColdFusion code
well maybe its the teachers =) but a quite a few people have said they
thought they were
taught poorly but to each his own
Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
Can I ask how you invoked the layer switch?
I am assuming on loosing the focus of the window, but I guess you could have
also used the events handlers!
-Original Message-
From: Joby Bednar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 February 2001 12:55 PM
To: CF-Talk
Subject: RE:
How do you open .ppt and .xls inline within a cfm file with out the download
dialogue box?
I've been trying to use the cfcontent tag with various mime types to no
avail.
-Tom
~~
Structure your ColdFusion code with Fusebox. Get the official book
John, there is no real clean way to do this now (lots of kludges
though). As
I demonstrated at the Developer's Conference, CF5 has a new tag called
CFFLUSH that does exactly what you want. And CF5 starts beta
pretty soon.
Just a question on CFFlush - can it be used at any time, or multiple
If anyone has had any experience or knows anything about the following
scenario, please could you get in contact with me as we're not sure what
happens when you run ipsvcs.exe.
Scenario:
It looks as though one or two of our servers have been hacked at some point
(anytime between now and last
I don't know that I'd make that a blanket recommendation. If you use
CFQUERYPARAM to make a prepared statement, you can't use
CACHEDWITHIN/CACHEDAFTER with your CFQUERY tags. You'll want to determine
which is more appropriate in a given case.
In any case, you'll get better performance using
Yes, and yes - as many times as you want. The CFFLUSH tag flushes the
current ColdFusion output buffer to the web server, which then sends it back
to the client. The first instance of the CFFLUSH tag on a page sends back
all of the HTML headers as well. Subsequent CFFLUSH tags send the output
I'm assuming the file is not within the web root.
What I've done is the link that downloads the file looks like
index.cfm/filename=help.xls?documentid=1234
Your PC then thinks the file is an excel file. If you have Excel installed
it will fire it up.
Adam
-Original Message-
From:
Has anybody figured out how to index include files?
-Tom
~~
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/
There's a tag on the tag gallery that helps with this -
CF_SQLSafe
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2001 11:02
To: CF-Talk
Subject: RE: String to Int
I don't know that I'd make that a blanket recommendation. If you use
Damm, ain't gonna work with Fusebox :(
Explanation: Fusebox works by processing the content of the page then,
displaying the layout around it after the content has been completed. :(
-Original Message-
From: Ben Forta [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 11:36
Yes, and yes - as many times as you want. The CFFLUSH tag flushes the
current ColdFusion output buffer to the web server, which then
sends it back
to the client. The first instance of the CFFLUSH tag on a page
sends back
all of the HTML headers as well. Subsequent CFFLUSH tags send the
Explanation: You have used a CFTRANSACTION tag within the
scope of another CFTRANSACTION tag (nesting of
CFTRANSACTION tags is not permitted).
Sorry to point out the obvious but!
Lol!
Well, I was clutching at straws thinking that maybe certain attribute
combinations allowed it, but now
Damm, ain't gonna work with Fusebox :(
Explanation: Fusebox works by processing the content of the page then,
displaying the layout around it after the content has been completed. :(
Sorry, but how can it put a Table layout above some already generated
content?
You must have to do the top
Has anybody figured out how to index include files?
-Tom
Someone on the fusebox list is busy building an application that will do
this.
Once he has completed it, it will be publically available.
In fact I think he was asking for assistance from the fusebox community to
build it as a open
I spoke with a tech rep from Seagate Software (makers of CR), and he
corroborated this info--that CFREPORT is no longer supported.
The rep told me that CR8 would accomplish what I described in my previous
post, but if we didn't want to have anything installed on clients then our
only choice
Do we know what sort of processor hit it will cause yet? For example
would...
cfoutput query...
trtd#name#/tdtd#phone#/td/tr
cfflush
/cfoutput
be painfully slow to be practical?
--
James Smith
[EMAIL PROTECTED]
Brainbench transcript ID: 822462
Not much at all.
But, it is worth noting that your specific example will not really work.
Yes, data will get sent to the client, but as what you are sending is part
of a table it won't be displayed anyway until the entire table is retrieved.
That's how Web browsers handle tables, and there is
Thanks Raymond.
Am I right in figuring the code you emailed searches for an occurrence of
"AST" in the "ASTIndex", "ASTAI", and "ASTFT" columns?
I should have explained it's the other way around; I'm searching for
"ASTIndex", "ASTAI", and "ASTFT" in the "AST" column and then doing a
separate
It looks as though one or two of our servers have been hacked
at some point
(anytime between now and last August). Someone has just sent
FYI, Norton just said that "ipsvcs.exe" is a BO2K variant.
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
Actually CFTransaction can be nested in 4.5
Here is the sample code from the CFStudio 4.5.2 docs:
CFTRANSACTION ACTION="BEGIN"
CFQUERY NAME='makeNewCourse' DATASOURCE='cfsnippets'
/CFQUERY
---
CFCATCH
ouch! Did they give you a fix Aidan...?
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 1:16 PM
To: CF-Talk
Subject: RE: Hacked server - iindex.cfm, CFX_SpawnL and ipsvcs.exe
It looks as though one or two of our servers
ouch! Did they give you a fix Aidan...?
We just moved the files off the servers (found it on 3 out of 4). Do you
think we'd need to take any further steps?
The network admin says he's reluctant to install anti-virus software on any
of the servers but this seems to be a good reason to do
I have a question. One of my developers is working on a 'file browser'
type coldfusion application. He has the simple stuff done , but now he
is wondering how best to handle files other than plain text - gifs, etc.
What is the best way for a ColdFusion app to feed a file back to an
arbitrary
One of the upload options should be 'delete existing directories on
server'.
Dangerous? Yes, but in reality, probably very useful.
Best Regards,
Adam Reynolds
ColdFusion Web Developer
ISMG Development, Unilever
London
( +44 20 7822 x5450
m: +44 7973 386620
* [EMAIL PROTECTED]
Tom wrote:
Has anybody figured out how to index include files?
-Tom
I'm no fusebox expert. (That's my disclaimer)
If your include file is in a directory called: 'inc' just index that directory.
The question I have, is why do you want to index ColdFusion templates? Unless you
-Original Message-
ouch! Did they give you a fix Aidan...?
We just moved the files off the servers (found it on 3 out of 4). Do you
think we'd need to take any further steps?
If I were you I'd find out what port(s) that particular Trojan runs on and
block it. Also get yourself a
Scenario:
It looks as though one or two of our servers have been hacked at
some point
(anytime between now and last August). Someone has just sent us an e-mail
saying that there was a file in the CFIDE directory called iindex.cfm,
written by Kevin Klinsky. Calling it appears to display a
This isn't really a nested CFTRANSACTION.
The word CFTRANSACTION appears 3 times but the ACTION="ROLLBACK"
and ACTION="COMMIT" are effectively sub-tags.
The 3 different things are analogous to the 3 SQL commands, BEGIN/END
TRANSACTION, ROLLBACK and COMMIT.
There's only one transaction block,
If I were you I'd find out what port(s) that particular
Trojan runs on and
Thanks.
All points noted and passed on to the "relevant authorities".
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744)
if you go to cfcomet.com and cick the SQL Server link at the top, there are
examples and instructions on how to do this with CFOBJECT and COM.
~Simon
Simon Horwith
Allaire Certified ColdFusion Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 220
Washington DC
I don't know that I'd make that a blanket recommendation. If
you use CFQUERYPARAM to make a prepared statement, you can't
use CACHEDWITHIN/CACHEDAFTER with your CFQUERY tags. You'll
want to determine which is more appropriate in a given case.
In any case, you'll get better
These are all things that are... well... forces for good in
the right hands,
but in others they're stepping stones useful to hack a
machine if you know
what you're doing.
So you're trying to deny you're responsible! Nah, just j/k.
You're right, of course. For example, guns can also be
-Database Connection Pooling
Database connection pooling simply means...
AFAK these issues are the core ones addressed by J2EE.
That is to say (ask), is CF about to provide a 'link' to
EJB, so you don't have to know EJB, just use CF tags?
(BTW I love CFOBJECT and I know, there must be
How so? If your concern is that the value passed may not be numeric, both
will do the same thing. The only difference is that CFQUERYPARAM may also
improve database processing performance.
At least with CFQueryParam it gives you error control over your passed
variables, so if there is
Is there a VTM for the CFX_iMSMail tag?
I just downloaded the CFX, but the instructions look complicated.
Russel
Russel Madere, Jr. Senior Web Developer
ICQ: 5446158 http://www.TurboSquid.com
I have a page where I allow users to download an excel file of the query
they have done. I use the CFCONTENT TYPE="application/vnd.ms-excel" and
it works nicely except for one field. It's a 12 digit number that shows in
the excel file in exponential notation (i.e 446547798380 is
Hello:
Does any one know of a way to use HTTP_USER_AGENT to do page redirects with
CF?
I am trying to get a template to output code based on the browser type NS or
MSIE so far nothing seems to work.
Here's the code i am using so far
cfset "brow" eq "#HTTP_USER_AGENT#"
cfif "brow" eq
I have one that someone sent me. I have not yet tested it but I can send it
to you or put it on our ftp server.
Regards,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail
CGI.HTTP_USER_AGENT?
^^^
-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 3:41 PM
To: CF-Talk
Subject: Detecting HTTP_USER_AGENT
Hello:
Does any one know of a way to use HTTP_USER_AGENT to do page redirects with
CF?
I am trying to
You could just do something very simple, like
cfif Find( "MSIE", CGI.HTTP_USER_AGENT )
!--- It's Internet Explorer ---
cfelse
!--- Assume it's probably Netscape ---
/cfif
It works for me, anyway. We checked the IIS logs, and found that 98.8% of
users were using IE 4+ or
Try outputing the number already formatted:
#NumberFormat(YourNumberVariable,'_99,999,999')#
HTH,
Stephen
I have a page where I allow users to download an excel file of the
query they have done. I use the CFCONTENT
TYPE="application/vnd.ms-excel" and it works nicely except for one
field.
Use CONTAINS instead of EQ or IS in your CFIF-statement.
You might also want to add the prefix "cgi." to the variable
#http_user_agent#. That is #cgi.http_user_agent#.
I believe it's a good practice to tell CF that it is a cgi-variable, or else
CF has to find out. #http_user_agent# could be
Try this:
cfif cgi.http_user_agent CONTAINS "MSIE"
!--- Browser is MS IE ---
cflocation url="index_ms.cfm"
cfelseif cgi.http_user_agent CONTAINS "Mozilla"
!--- Browser is NN ---
cflocation url="index_nn.cfm"
cfelse
!--- Browser is unknown ---
Try this:
cfset "brow" eq "#HTTP_USER_AGENT#"
cfif FindNoCase("Mozilla/4.7 [en]", brow) gt 0
cflocation url="index.cfm"
cfelseif FindNoCase("Mozilla/4.01 (compatible; MSIE 4.01; Windows NT)",
brow) gt 0
/cfif
Regards,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
On the first statement, don't you mean:
cfset brow = cgi.http_user_agent
You need to use an "=" not the "eq" operatior. You use the symbol for
setting variables and the "eq" for comparisons.
You could actually just do something like:
cfif listContainsNoCase(cgi.http_user_agent,"MSIE")
Sandi,
I don't know if I understand exactly what you are trying to do, but I can
give you some information that might help. At some point in what you are
doing you are populating an Excel file, right?
If this is a static Excel file that is dynamically populated, you can change
the formatting
you don't need the CGI scope. i think you're looking for strings that are
too specific in your code.
try looking for the presense of MSIE or not.
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 7:50 AM
To: CF-Talk
Subject: RE: Detecting
Are you running iMS Mail server?
-Kev
-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 10:26 AM
To: CF-Talk
Subject: CFX_iMSMail VTM
Is there a VTM for the CFX_iMSMail tag?
I just downloaded the CFX, but the instructions look
cfset "brow" eq "#HTTP_USER_AGENT#"
Should read (although this line is not required)
cfset brow = cgi.HTTP_USER_AGENT
cfif FindNoCase("Mozilla/4.7 [en]", brow) gt 0
should read
cfif FindNoCase("Mozilla/4.7",CGI.HTTP_USER_AGENT)
the other way is like saying if X gt 0...
FindNoCase returns the
1 - 100 of 224 matches
Mail list logo