Hi if I am using the datfield option with cfinput, it will only return the date
in U.S format. Is there anyway to force it to return and display the date in
Non U.S format?
Thanks
~|
ColdFusion MX7 by Adobe®
Dyncamically
Ben Nadel wrote:
I find that word (as web page) puts 3D in front of each of it
attributes:
p style=3Dcolor:black;
Here is text
/p
I think it is 3D but it might be something else.
=3D is the representation of the equals sign = in quoted-printable
encoding. = is the escape
Matthew Chambers wrote:
I've just checked and the DB has been create with MyISAM. Am I in trouble?
Not with regard to this specific problem. Just use cftransaction and the
MySQL last_inserted_id() function.
In general though, don't expect any other benefits from transactions as
long as you
On Thursday 29 Mar 2007, Adkins, Randy wrote:
Any ideas on how I can get the same request against database servers?
SNMP is the generic answer here.
--
Tom Chiverton
Helping to proactively bully viral methodologies
on: http://thefalken.livejournal.com
null=#iif(COURSE.COU_LANGUAGE_STUDY IS '',de('Yes'),de('No'))#
Why not #yesNoFormat(COURSE.COU_LANGUAGE_STUDY IS '')# ?
The code we're using is:
null=#yesNoFormat(NOT Len(trim(CFQUERYPARAM VALUE IN HERE)))#
It looks like my bosses previous suggestion doesn't work if you have any
spaces.
cfcontent type=application/msexcel
cfheader name=Content-Disposition value=filename=h:\File.xls
td#LSNumberFormat(List_Excl,_-_,___,___.__)#/td
td#decimalformat(List_Excl)#/td
it will display as 7 in Excel and i want it to display 7.00
Please anyone help!
Thanx Ismail
Translated has one, not free but cost effective
http://www.translated.net/en/hts.php
http://www.translated.net/hts/soap.php
marco
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
Hi,
Coldfusion5 + cfgrid + numberformat does not work
Normall in a table this works: #LSNumberFormat(SumInv,_-_,___,___.__)#
it will display as : 4,100.00 which is correct.
but when in a cfgrid
cfgridcolumn name=Invoice_Value numberformat=_-_,___,___.00
but it displays in the grid as: -,
Oooh. That is good to know :) I had no idea what they did that. Thanks
for the tip.
..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL
Are the ad-scripts just disabled right now? I set mine up, but it does
not get executed. I think you will have to do some funky trickery to
get Javascript loaded using Ajax to actually execute. I see the script
being retrieved in a GER request, it just does not render / run.
Chris / Justice
I'm doing something wrong which I'm sure it obvious to most.
I would like to see if a session variable has been defined.
I'm using:
cfset request.theEvenID = 70
cfif isDefined(SESSION['eventID'
REQUEST.theEventID].registration.groupBookingID)
So on this occasion I would be checking
Try StructKeyExists:
cfif StructKeyExists(SESSION, eventID REQUEST.theEventID
.registration.groupBookingID)
On 3/30/07, Richard Cooper [EMAIL PROTECTED] wrote:
I'm doing something wrong which I'm sure it obvious to most.
I would like to see if a session variable has been defined.
I'm
I gather evenID should be eventID.
This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant,
Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It
It's always safest to check each level of the variable...
cfif StructKeyExists(Request, 'EventId')
AND StructKeyExists(Session,'eventID#Request.EventId#')
AND StructKeyExists(Session['eventID#Request.EventId#'], 'registration')
AND
Thanks all, that worked.
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
I realize that I can remove and modify what is printed in the header and footer
of a page within my browser, but what I'd rather figure out is if there's a way
to launch a special page (a packing list) that I can print that will exclude
these items. Thanks.
You can't control any browser's printing features except your own.
In this case, I would suggest using CFDOCUMENT and create a PDF that
contains only the information you need.
M!ke
-Original Message-
From: Curt Schryver [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 8:34 AM
+1 on pushing the content to PDF to be printed
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 9:44 AM
To: CF-Talk
Subject: RE: Printing a page without the standard header and footer
You can't control any browser's printing features
BlueDragon 7 has been released today...
http://www.newatlanta.com/products/bluedragon/index.cfm
David Low
Senior Developer and Data Manager
MyHousePrice.com
3 Wellgreen Lane
STIRLING, FK8 2BS
tel: +44 (0) 1786 472 186
fax: +44 (0) 1786 472 109
Thanks Jim, this is very helpful.
Dan
On 3/23/07, Jim Davis [EMAIL PROTECTED] wrote:
-Original Message-
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 7:54 AM
To: CF-Talk
Subject: WDDX v.s. CF 7 XML functionality
While having a few legacy apps
i am trying to install E:\CFusionMX7
have manually mapped the .cfm et. to
E:\CFusionMX7\runtime\lib\wsconfig\jrunwin32.dll
with no luck, i cant get cfadmin to run
i also cant get Web Server Configuration Tool on
E:\CFusionMX7\runtime\bin\wsconfig.exe
to run.. i mean it runs, but wont configure
I have version 5.0 of CF.
In the Scheduler I have set a cfm page to run every day at 9:15, but it does
not.
Its is checked as Daily at 09:15:00. There is a Start date of yesterday.
Are there inherent problems with the Scheduler that I don't know about or is
there a better way to do this?
On Friday 30 Mar 2007, Orlini, Robert wrote:
In the Scheduler I have set a cfm page to run every day at 9:15, but it
does not.
It doesn't require a login or something does it ?
Is there no entry even in the web server logs ?
--
Tom Chiverton
Helping to vitalistically differentiate low-risk
I found the scheduler in version 5.0 and lower to be inherently
unreliable. When we still had CF5.0, we used the NT scheduler and the
CFML.EXE executable for our scheduled tasks.
-Original Message-
I have version 5.0 of CF.
In the Scheduler I have set a cfm page to run every day at
You could use CSS to hide the header and footer when printing (not 100% this
syntax is correct):
@media print{
.header{display:none;}
..footer{display:none;}
}
Or, something I've done is use custom comment tags above and below the
required content. The print page then cfhttp's the
No, nothing in log and it does not require a login.
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 10:40 AM
To: CF-Talk
Subject:Re: Scheduler settings
On Friday 30 Mar 2007, Orlini, Robert wrote:
In the Scheduler I have
Try turning off your anti-virus, if you have one, and reinstalling. A
lot of anti-virus software shuts down some useful ports by default.
On 3/30/07, Paul Ihrig [EMAIL PROTECTED] wrote:
i am trying to install E:\CFusionMX7
have manually mapped the .cfm et. to
I am not sure of this offhand, but I think if the data is a HUGE table,
then using the THEAD and TFOOT tag within the TABLE tag willactually
print the table header/footer on each page... Not the same as the page
header/footer, but at least it's a start.
..
Ben Nadel
Hello!
I have a page setup that lists data about certain records in a DB2 database.
The user can choose between two different methods of showing data. The first
(ONLY Mode) shows orders for a specific account. (This is working fine)
The second mode (Called Normal) shows all of the order for
So I noticed when I add new instances to CF Enterprise (through the
instance manager in ColdFusion Administrator) if I don't check the
create windows service (Windows server) then when I restart the
operating system the instances are stopped still until I manually start.
I assume this is the
Bob Johnson wrote:
How to I take two queries and combine them so they paging will work?
Check your database manual for UNION.
Jochem
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free
ok 6.01 installed just fine, but without cfdocs.
so will try to upgrade to 7.02
if i can upgrade.
firewall viri turned off, but cant kill nod32 for some reson
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build
Yea, in DB2 you can just do
SELECT col1, col2, col3 FROM file
UNION ALL
SELECT col1, col2, col3 FROM file2
ORDER BY col1
Note the order by goes after all your UNION's, and sorts the entire
result set.
Chris
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
On Friday 30 Mar 2007, Bob Johnson wrote:
How to I take two queries and combine them so they paging will work? Should
I use an array and stick all of the results into this array?
For preference, UNION in your database.
--
Tom Chiverton
Helping to proactively deploy unique e-commerce
on:
I am running multiple schedule tasks and there is one that when the
scheduler attempts to run it, it produces the following error in the
log.
Information, scheduler-3, 03/30/07, 11:08:21, , Error while
executing task Connection Failure: Status code unavailable
I have other tasks running without
Thanks, but that is not what I am asking. The queries have multiple
tables combined with the UNION command.
I can't get all of the data from one query. I have to create a query to
get the child/parent relationship and then use another query to extract
record info.
Bob
On Fri, 30 Mar 2007
I think Curt is asking how to remove IE's page numbers or FF's page
title, for example, from the printed page, not removing his generated
content. He wants to remove the information that you can see when you
go to File Page Setup.
If I'm wrong, then I apologize for the confusion and then I
You don't have to do it that way. Try using sub-selects to get the
child data. I do this in DB2 all the time, here is an example.
SELECT
Col1,
Col2,
Col3,
(SELECT SUM(Revenue) FROM rev WHERE Order = A.Order) as
TotalRevenue
FROM
ORDER A
WHERE
Thanks everyone. I misunderstood the last UNION post.
The UNION ALL is working perfectly.
Thanks for helping me out.
Bob
On Fri, 30 Mar 2007 11:30:55 -0400, Peterson, Chris
[EMAIL PROTECTED] said:
Yea, in DB2 you can just do
SELECT col1, col2, col3 FROM file
UNION ALL
SELECT col1,
Thanks Chris!
I am going to remember this. This is extremely useful!!
Bob
On Fri, 30 Mar 2007 11:39:47 -0400, Peterson, Chris
[EMAIL PROTECTED] said:
You don't have to do it that way. Try using sub-selects to get the
child data. I do this in DB2 all the time, here is an example.
SELECT
On Friday 30 Mar 2007, Chad McCue wrote:
If I copy the URL that is suppose to run into an IE window and run it,
What about with wget or some other simply command line tool ?
--
Tom Chiverton
Helping to augmentatively generate interactive technologies
on: http://thefalken.livejournal.com
ok that worked.
how bizzar.
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
I figure I might have to set the services to NOT auto-start and then
create a startup script to start CF and IIS in the right order.
You could do this, or you could probably just set the DependOnService
registry key for IIS so that it doesn't start until the services you specify
have already
If you can restrict use to IE, I have used http://www.meadroid.com/scriptx/
activeX object very successfully.
I have a Work Order system where I use this. Works great and is all
accomplished transparently to the user. The user, while viewing the WO can
click on a button (using JS). With no
Sweeet dawg!
Thanks, I'll give it a try.
~Brad
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 12:10 PM
To: CF-Talk
Subject: RE: New instances as a Windows service
I figure I might have to set the services to NOT auto-start and then
create
I still use WDDX in old and new applications. Not often, but I find it
valuable for storing data in the database that I don't need to be
searchable.
I'm currently working on a flex application where the user can set a variety
of preferences. For example, a list of items to be automatically
Brad Wood wrote:
So I noticed when I add new instances to CF Enterprise (through the
instance manager in ColdFusion Administrator) if I don't check the
create windows service (Windows server) then when I restart the
operating system the instances are stopped still until I manually start.
I
Or better yet use Apache which doesn't suffer from such shortcomings...
Russ
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 1:10 PM
To: CF-Talk
Subject: RE: New instances as a Windows service
I figure I might have to set the services
I'm using cflogin to authenticate users on a site. Is there a way to
return the roles that a user is in (i.e. the roles that are passed in
using CFLOGINUSER)? I'm using a very hackish method of looping
through all of the roles for a site and using isuserinrole() to
determine this, but was hoping
It's not really that bizzare. As I mentioned, a lot of AV software
closes off all ports and then only opens the ones you specify (some
common ports are open by default). The port you needed (5100, I
think?) wasn't open by default so the connector wouldn't respond. You
should be able to open
So I deleted all the instances and re-added them and checked the
create
windows service and auto-start checkbox.
You could have just run jrunsvc -install servicename.
Ahh-- I figured there was a better way to do that. If it is that easy,
why didn't Adobe make the create
Problem I had. NOD32 closed the port. Do not install the Internet Module
and you are fine.
-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 10:32 AM
To: CF-Talk
Subject: Re: CFusionMX7 IIS XP instalation problems...
It's not really that
not sure.
nothing worked until i instaled 6.02 the upgraded to 7.02
i had 51010 51011 unblocked befor...
now i just turned nod32 firewall back on admin is not loading right.
~|
Create Web Applications With ColdFusion MX7 Flex
where do i turn that off at??
i love nod32.. but i need a stable cf server.
On 3/30/07, Jacob [EMAIL PROTECTED] wrote:
Problem I had. NOD32 closed the port. Do not install the Internet Module
and you are fine.
-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED]
Sent:
ok, just turn off IMON
fark...
On 3/30/07, Paul Ihrig [EMAIL PROTECTED] wrote:
where do i turn that off at??
i love nod32.. but i need a stable cf server.
On 3/30/07, Jacob [EMAIL PROTECTED] wrote:
Problem I had. NOD32 closed the port. Do not install the Internet Module
and you are
You need to apply the Excel number formatting to it. Something like:
spancfif report_format eq XLS
style=mso-number-format:0.00;/cfif#List_Excl#/span
it will display as 7 in Excel and i want it to display 7.00
Cheers,
Kris
~|
Or better yet use Apache which doesn't suffer from such shortcomings...
Well, actually, that's not correct; I've seen several cases where Apache
would start before CF, and users would get an error. But don't let that
stand in the way of your unbridled enthusiasm for Apache.
Dave Watts, CTO,
Yea.
I have NOD32 on our systems, but I never installed the IMON on them. So
when I installed CF, I never had a problem.
When I installed CF on a XP laptop a couple weeks ago, IMON was installed
and running. That causes CF not to install and give me the same error you
got.
-Original
Hey all,
Heres a weird question
We have a query that uses like in the where clause. The like variable is
passed dynamically.
Where x like #arguments.blah#%. If nothing is passed via arguments.blah, the
where clause looks like this
where x like %
How does T-SQL interpret
Well, in Oracle, it'll interpret that as matching everything. For example:
SELECT sysdate
FROMdual
WHERE 1 like '%'
On 3/30/07, Scott Stewart [EMAIL PROTECTED] wrote:
Hey all,
Here's a weird question
We have a query that uses like in the where clause. The like variable is
You should only conditionally use that clause if the arg has a length IMHO ;-)
I suspect it will either return ALL records or chokeneither I suspect is
what you want ;-)
.and run or not...it's sloppy SQL
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric
T-SQL will return every record in this case. % is a placeholder for any
characters, so your query would essentially tell the database where x = any
pattern of characters and would return everything.
You could just run a query with that syntax in Query Analyzer or Management
Studio and see for
Here's a head scratcher:
Doing this on a form to encrypt a 5 digit security code:
cfset request.encrptVAR=encrypt(#FORM.myVAR#,#request.encCODE#)
I can enter any five numbers 12345 I want, and it works perfect when
decoded
**EXCEPT** - if the number ends in a 2 like 2, the 2 gets
Steve Milburn wrote:
T-SQL will return every record in this case. % is a placeholder for any
characters, so your query would essentially tell the database where x = any
pattern of characters and would return everything.
if there are no NULLs in x.
Correct - I should have stated that in my original email. Thanks for the
clarification.
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Friday, March 30, 2007 3:48 PM
To: CF-Talk
Subject: Re: SQL Like
Steve Milburn wrote:
T-SQL will return every record in this
have to say even though i had problems getting a dev box up and running
he grief NOD32 has saved me over the years is well worth it.
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade see
Odd.
You can get one or two =s used by the CF encryption for padding encoded values
to a certain length, so that might explain the character itself, but not really
/why/ it's happening.
What is in Request.encCode?
Is it definitely constant between encrypt and decrypt?
( The solution is of
A couple months ago Russ posted because he was getting an error / by
zero and the line number pointed to his cfapplication tag.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:49144
It was determined that he was using multiple instances of CF on the same
server. At any
Hello All!
This post relates to Jen N's on Extending Application.cfc.
We have multiple environments set up on both Windows and Unix, with Unix being
our production. Since moving to Unix, we replaced the so convenient
CGI.REMOTE_USER with a process that calls web services, stored procedures
Hello All!
This post relates to Jen N's on Extending Application.cfc.
We have multiple environments set up on both Windows and Unix, with Unix being
our production. Since moving to Unix, we replaced the so convenient
CGI.REMOTE_USER with a process that calls web services, stored procedures
happy April fools all...
though it just might.
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
Sorry All, had a tab key/enter issue on this, please disregard this post...
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
Ok, so I *might* have a solution. Someone on my QA team noticed that
they could reproduce the divide by zero error when they logged in, did a
ctrl-N to get a new window and then logged out of our site in ONE
window. When they hit refresh in the other window... crash boom bang.
I was looking at
Peter Boughton wrote:
Odd.
You can get one or two =s used by the CF encryption for padding encoded
values to a certain length, so that might explain the character itself, but
not really /why/ it's happening.
What is in Request.encCode?
It's a random string that's stored in another
dude
april fools is like 2 days from now.
like duh
:)
On 3/30/07, Paul Ihrig [EMAIL PROTECTED] wrote:
happy April fools all...
though it just might.
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs
On 3/30/07, Dave W wrote:
Or better yet use Apache which doesn't suffer from such shortcomings...
Well, actually, that's not correct; I've seen several cases where Apache
would start before CF, and users would get an error. But don't let that
stand in the way of your unbridled enthusiasm for
well teh ps3 is that advanced.
didnt think any one would notice.
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
On 3/30/07, Paul Ihrig wrote:
well teh ps3 is that advanced.
LOL, at first, I read that as it's so advanced, it's from a few
days in the future =]
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion
But you don't have to restart it after CF comes up, which
apparently you do with IIS?
No, I've had clients who had to ensure that Apache started after JRun.
I like how with httpd* you can specify a page to show instead
of the familiar JRun error or whatnot... can you do that
with IIS
well if he waited 24 more hours it would have worked here...
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
I had trouble doing the exact same thing a few weeks ago. Wound up using the
IDAutomationHC39M font from http://www.idautomation.com/fonts/free/
I'm having a problem using barcodes on a pdf created with Coldfusion's
Report Builder. I followed the steps Jeff Houser identifies in his
Hello anybody who takes the time to read this!
I am not new to CFM but have not hit it to deep as of this point. Here is my
problem and I hope I can explain this well enough.
I have a page that will be driven left to right based on a parent/child
relationship. The problem I have is figuring
Hello anybody who takes the time to read this!
I am not new to CFM but have not hit it to deep as of this point. Here is my
problem and I hope I can explain this well enough.
I have a page that will be driven left to right based on a parent/child
relationship. The problem I have is figuring
83 matches
Mail list logo
