Thanks for the help. The escaped double-quotes did the trick.
Adrian Showalter
Software Developer
Holmes BizNet
www.HolmesBizNet.com http://www.HolmesBizNet.com
330.893.3901 ext 102
~|
Logware
Put quotes around your filename. Escape them. Chr(34)
- Matt Small
-Original Message-
From: Adrian Showater [mailto:[EMAIL PROTECTED]
Sent: Monday, November 07, 2005 4:39 PM
To: CF-Talk
Subject: Spaces in cfexecute on Windows machine
I am having a problem using cfexecute on a windows.
Perhaps you need to go to a DOS prompt (yes, old skool), and do a:
Dir /x
which shows you the 8.3 format directory names? (should only apply to
old OS or old FAT formatting, etc., though)
-Original Message-
From: Adrian Showater [mailto:[EMAIL PROTECTED]
Sent: Monday, November 07,
try:
name=C:\program files\directory\file.ext
This would put put double quotes around the file name.
HTH,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
PrismAV - Virus
Hey Adrian,
Someone else may have a better approach, but this should work too. Open a
command prompt, navigate to the folder in question, and do 'dir /x'. This
will output the 8-dot-3 name in the 5th column, and the long name in the 6th
column.
For example, Program Files is USUALLY PROGRA~1,
It's an HTML thing, it will reduce many spaces to one, try replacing the
spaces with nbsp;
Ade
-Original Message-
From: Yexley Robert D Contr Det 1 AFRL/WSI
[mailto:[EMAIL PROTECTED]]
Sent: 29 July 2002 17:06
To: CF-Talk
Subject: Spaces stripped out of query return values?
I have a
-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 12:13 PM
To: CF-Talk
Subject: RE: Spaces stripped out of query return values?
It's an HTML thing, it will reduce many spaces to one, try replacing the spaces with
nbsp;
Ade
-Original Message-
From: Yexley Robert
have you tried HtmlEditFormat()
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 29, 2002 10:10 AM
Subject: RE: Spaces stripped out of query return values?
DOH
character for the rpad so you don't end
up replacing something in your data.
Dan
-Original Message-
From: Yexley Robert D Contr Det 1 AFRL/WSI
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 10:10 AM
To: CF-Talk
Subject: RE: Spaces stripped out of query return values?
DOH!! I should
new values.
I hope this is helpful,
Matthieu
-Original Message-
From: Yexley Robert D Contr Det 1 AFRL/WSI
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 1:10 PM
To: CF-Talk
Subject: RE: Spaces stripped out of query return values?
DOH!! I should have known that. I've been
Why don't you use column aliases in the query:
SELECT 'First Name' AS FirstName, 'Last-Name'AS LastName, PhoneExtension
FROM Employees
ORDER BY 'Last-Name', 'First Name'
(example from Ben Forta's CF Web Application Construction Kit book)
Eric
-Original Message-
From: Williams, Ryan
I have a table that is out of my control and some of the
column names have spaces or dashes in them and one is a number.
Querying the table works fine, but when I go to output the
results of the query CF chokes on these various column names.
I've tried different formatting functions to
try aliasing the columns.
if it's access, use []'s to enclose the column names.
SELECT
[bad column] as badcolumn,
then use queryname.badcolumn to reference it in your CFOUTPUT.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original
-Original Message-
From: Melanie Gann [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 07, 2000 3:22 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Spaces
My case is slightly different but the same problem.
The Novell server does not understand space chars and says
"The s
I pretty much took this right out of ColdFusion Help.
cfset FORM.MyString = "Replace all spaces with nothing."
cfset FORM.MySubstring1 = " "
cfset FORM.MySubstring2 = ""
PThe Replace function returns Istring/I with
Isubstring1/I being replaced by Isubstring2/I in
the specified scope. This is
:11:PM
To: [EMAIL PROTECTED]
Subject: RE: Spaces
Kevin;
I believe that you have to type all inside your last pair of quotes in order
to replace ALL of the spaces.
Your code should like this:
#Replace(CompanyName, " ", "ALL")#
Hope this helps
H Larry Juncker
L Senior Co
Kevin;
I believe that you have to type all inside your last pair of quotes in order
to replace ALL of the spaces.
Your code should like this:
#Replace(CompanyName, " ", "ALL")#
Hope this helps
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications Group
No I had this same problem even with the "ALL".
I'm stumped to.
Regards,
Melanie
At 07:41 AM 7/7/00 -0500, Larry Juncker wrote:
Kevin;
I believe that you have to type all inside your last pair of quotes in order
to replace ALL of the spaces.
Your code should like this:
ie Gann [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 07, 2000 9:04 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Spaces
No I had this same problem even with the "ALL".
I'm stumped to.
Regards,
Melanie
At 07:41 AM 7/7/00 -0500, Larry Juncker wrote:
Kevin
Replace(CompanyName, " ", "", "ALL")
Specify the space, then the null (""), then ALL.
Chris
--
Original Message
From: "Larry Juncker"[EMAIL PROTECTED]
Subject: RE: Spaces
Date: Fri, 7 Jul 2000 07:41
aving the same problem.
Regards,
Melanie
At 08:31 AM 7/7/00 -0500, Chris Terrebonne wrote:
Replace(CompanyName, " ", "", "ALL")
Specify the space, then the null (""), then ALL.
Chris
--
Original Message
From: &
21 matches
Mail list logo