OK, eventually found a fix..
SELECT *, STR(the-field) AS TheField
FROM theTextFile
Kind of works but still drops leading zeroes so I have to re add them
after the select...
--
Jay
On Wed, May 14, 2008 at 12:11 PM, James Smith [EMAIL PROTECTED] wrote:
I am querying a text file and getting
hi all!
im having an odd issue whereby a log file of some sort is filling up fairly
quickly... the contents of this file, are growing by gigs... anyway, anyone
know: 1. what this is? 2. how i can stop it? 3. how can i control its growth?
below is a snippet...
2008-05-19 00:00:00
I don't think it uses java image library as previous versions predate CFMX.
http://www.kolumbus.fi/jukka.manner/
When I download this, I receive dll files. These need to be installed at the
server? I don't suspect it'll happen, if that's the case.
I was hoping for something that I could just
Check out CFIMAGE in the CF docs on the Adobe site. Upgrade now! The
image handling alone is reason enough!
Rick, it's not important whether I want to upgrade. The University will do so
when it does. I've made my thoughts known to them. However, until that time,
I'm on 7.02 and need a
HI all
I'm wondering if anyone has ever developed an application with one requirement
being to print to an Epson receipt or any other type of receipt printer.
I look forward to hearing from anyone who may have done this.
Regards
It seems odd to me because Jrun uses significantly less memory on both
of my other development machines (my 1GB laptop runs at under 75MB on
Vista Ultimate). The numbers I've been quoting are from Jrun just after
boot (idle, no applications loaded) or after only running CFAdmin.
Maybe Jrun needs
If you are using Task Manager to judge sizes then be sure to notice the
difference between Mem Usage and VM Size... Mem Usage is the amount
of physical ram currently in use by a process, but VM Size is, well,
different. If you have less physical ram on a machine then you may see
less Mem Usage
I have many years ago - using asp
From memory, you have to use a particular font and send down control
characters using ascii()
On Mon, May 19, 2008 at 9:05 PM, Toby King [EMAIL PROTECTED] wrote:
HI all
I'm wondering if anyone has ever developed an application with one
requirement being to
On Monday 19 May 2008, AJ Mercer wrote:
From memory, you have to use a particular font and send down control
characters using ascii()
These days CF8 has built in print support, and most label printers work just
like a 'normal' printer but with a funny* page size.
--
Tom Chiverton
There is nothing to install. However, CFX's need to be registered with CF
server. You drop it in the CFX dir under the CF install directory and go to
the cf admin Extensions CFX Tags And point it to the executable cfx.
It is standard fair and most reputable hosting companies will register a
There was a 100-150MB difference between the Memory Usage reported in CF
Admin (which I'm assuming is taping directly into JVM?). Thanks for the
tip with the Task Manager. I don't seem to have a PID for VM Size?
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent:
We did using this utility:
http://www.download32.com/bersoft-html-print-i8522.html
Jacob
-Original Message-
From: Toby King [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 6:05 AM
To: CF-Talk
Subject: coldfusion printing to an Epson receipt printer
HI all
I'm wondering if anyone
On Sat, May 17, 2008 at 3:55 AM, Adam Haskell wrote:
Dependency conflicts are a fact of life as far as I have found.
These can usually be avoided by getting everything into a classloader
and calling the classes from that.
Do you know of any samples / examples on how to do this? This is
How can I add VASID to the generated XML? there's not an option for it in
the send.bat file?
You will need to modify the java source (MM7SenderAndReceiver.java) and add:
request.setVasId(yourVasId);
Then recompile, run it again, and you'll see it in the XML packet.
HTH,
Rich Kroll
I found it in C:\vaspsdk\src\samples\standalone
Same error..
http code 500
235 [Thread-0] DEBUG com.openwave.mms.mm7.RelayConnection - [End
Outgoing Requ
est to Relay]
APIException submitting message: http return code: 500(ClientError:2000)
[End Thread[Thread-0,5,main] Iteration 0]
hi,
just wondering how you guys deal with you reusable functions
we were thinking that instead if having to look into what reusable functions we
have, then decide which functions we need in a page and then including them
within a page, that we just build our library and include everything in
I typically divide them up into separate CFCs based upon what they do. Like
a string library, query library, and so on. I used to just have a UDFs
library but quickly saw that as something to get too big.
On Mon, May 19, 2008 at 9:24 AM, Richard White [EMAIL PROTECTED] wrote:
hi,
just
I tried adding the project in Eclipse and it shows 100+ errors. So I
have mainly been messing with the standalone folder..
I tried to compile the .java file using the command javac
MM7MessageSender.java and got this..
MM7MessageSender.java:507: cannot find symbol
symbol : class
On Monday 19 May 2008, Richard White wrote:
just wondering how you guys deal with you reusable functions
Huge topic Richard :-)
Do you mean you have several functions, not already in some object
(i.e. 'utility' type stuff) ? Are there any dependencies or couplings between
them ?
--
Tom
I'd say this was absolutley fine. I'd put the includes in
OnApplicationStart and then put each udf into the application scope to
avoid including the files on each request (well I'd actually use
Model-Glue 3 but this is what I'd do if I was doing what you're
doing); something like:
cffunction
I tried adding the project in Eclipse and it shows 100+ errors. So I
have mainly been messing with the standalone folder..
I tried to compile the .java file using the command javac
MM7MessageSender.java and got this..
MM7MessageSender.java:507: cannot find symbol
symbol : class
Don,
I hear you. So far I have avoided using a lot of the Ajax features in CF 8
(save cfajaxproxy ) and sticking with their source libraries like EXT and
FCKeditor and the like. If anything for the foot print. I am still a sucker
for cfform though.
BTW FCKeditor has a CFC that works out of the
Lol. I guess it depends on how friendly 's' is. Q doesn't touch him so
I didn't count it. :)
~Brad
how about that as an extra spin on the thing?
and where's the 'q' in neighbours of 's'? :)
Brad Wood wrote:
Passing in s to the neighbors function returns the following
letters:
w,e,a,d,z,x
http://javaloader.riaforge.org/
On Mon, May 19, 2008 at 10:14 PM, Rich [EMAIL PROTECTED] wrote:
On Sat, May 17, 2008 at 3:55 AM, Adam Haskell wrote:
Dependency conflicts are a fact of life as far as I have found.
These can usually be avoided by getting everything into a classloader
and
A couple of my clients have updated their browsers to IE7 and now
complain that they cant see the Inline Rich Text Editor in their CMS -
it's FCKEditor 2.5.
I Look at the pages myself, and with Firefox and IE6 everything's
working fine. But with IE7 the page just shows the blank space
where
There is a page which will display data from a table. I have to add a
delete button in the page so that after clicking on that delete button
then it should refresh page and delete that data from the page and also
delete that data from the table
I can use javascript and coldfusion.
Dom,
I think I follow. Loading them in memory like mini CFC's?
Very interesting.
I take it you can load the function in to memory like using an init method
on a CFC... by calling the function with out the the () and not passing it
any vars?
cfset application.udfs.MyFunction1 = MyFunction1
Is
There are several ways to do this..
1) Look into Prototype AJAX handlers. Best way to do it IMHO so no
reload is needed.
2) Look into CF AJAX if using CF8.
3) Have the form submit to a delete page and have that then reload the form.
4) Refer to itself and check to see if form.delete is passed to
James,
I had the same problem. I was picking up a phone number from a flat file and
getting a float out of it. Most annoying.
I ended up with a function in TSQL. You can modify this to
use simialar padding on the area code as I did on the number.
Just download the Library and look under examples. There are a bunch of them
that work right out of the box. You pass just it a couple vars and you are
done. Very easy.
There is also a custom tag version too if that is more to your liking.
hth
G
On Mon, May 19, 2008 at 11:09 AM, Don L [EMAIL
Well if you're bonkers, I'm bonkers too!
Adrian
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: 19 May 2008 15:50
To: CF-Talk
Subject: Re: reusable components
I'd say this was absolutley fine. I'd put the includes in
OnApplicationStart and then put each udf into
If you don't mind the page refreshing, there's no need to use JS.
Here's a basic page:
cfif IsDefined(FORM.id)
cfquery name= datasource=#APPLICATION.DSN#
DELETE FROM yourTable
WHERE id = cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#FORM.id#
don't know if anyone has encountered this before, but I'm using CF8
components to return JSON to my applications, but even when i specify
dataType:'json' on my ajax requests in JS, ColdFusion returns
something along the lines of the following:
Just a guess... Look in your application.cfm or other include files.
G
On Mon, May 19, 2008 at 12:08 PM, adam j. sontag [EMAIL PROTECTED]
wrote:
don't know if anyone has encountered this before, but I'm using CF8
components to return JSON to my applications, but even when i specify
Hi, all...
How do I combine multiple fields into one alias in my SQL (MySQL 5)?
E.g.,
select remarks_01, remarks_02, remarks_03, remarks_04 as remarks
That would give me remarks_04 an alias of remarks. How do I combine
all the remarks into one alias?
Or should I do that in the value
You need to concatenate the values.
In DB2, you use ||. In SQL Server you use +.
SELECT col1 || col2 AS newCol
SELECT col1 + col2 AS newCol
I'm not sure about MySQL, but it should be similar.
You might also find a CONCAT() database function with unlimited
arguments:
SELECT CONTACT(col1,
After reading your original post, again, I think you may get quite a few
suggestions that you need to improve your database schema.
If you have control over the database schema, you may be better of
storing your remarks in different records, rather than different fields.
In other words, store
Concerning the schema...
I'm trying to merge the data from two different data providers' databases
into one database. One provider has all remarks in a 'remarks' field and the
second provider decided to divide their clients' remarks into four separate
fields. (Don't know why they wanted to
And yes, 'Concat' is a MySQL function and will work perfectly.
Just didn't know what to call what I needed. Haven't used that
function before.
Thanks, m!ke!
Rick
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 12:38 PM
To: CF-Talk
I just went through the cf documentation about this tag, did not come off as it
is able to support a PDF document editing via web interface, a quick search of
this forum did not yield an answer neither, hence, ask here.
Thanks.
Just download the Library and look under examples. There are a bunch of them
that work right out of the box. You pass just it a couple vars and you are
done. Very easy.
There is also a custom tag version too if that is more to your liking.
hth
G
Gerald Guido
Thanks, Gerald, check it out
depending on your needs you may find CONCAT_WS to be more useful:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Rick Faircloth wrote:
And yes, 'Concat' is a MySQL function and will work perfectly.
Just
You've got some code somewhere that is placing that doctype declaration into
the output stream. As Gerald suggested, look for an include or something in
application.cfc/cfm that is placing this there.
On Mon, May 19, 2008 at 12:08 PM, adam j. sontag [EMAIL PROTECTED]
wrote:
don't know if anyone
Probably Flash and/or Flex can. But it would be nice if cf8 can do that as
well (not something fancy/full-blown), if this capability is already built in
with cf8, pls show me. Thanks.
Process flow: a) simple draw -- b) the {cf image tag} capture it -- c) store
it...
Sorry if asking too
I was having a lot of issue with CF's out of the box Richtext Editor.
Biggest issue was that we could not use any of the image or file upload
features, and the editor would not retain the layout of my pages when
editing. I downloaded the most recent version of FCKEditor and am using
the
Why would I get an error, Unknown column 'street number' in 'field list' (line
25).
Line 25 is the last line in the insert query beginning with cfqueryparam...
I figured there was a typo, but I can't see one.
cfquery name=get_hmls_lots_land_data datasource=c21ar
select mls_number,
check out ben nadel's blog for this and a lot more:
www.bennadel.com
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Don L wrote:
Probably Flash and/or Flex can. But it would be nice if cf8 can do that as
well (not something fancy/full-blown), if this capability is already built in
That sounds very reasonable. You may also want to consider adding a
delimiter to your remarks so that they can be broken up at a later time.
For example:
SELECT CONCAT(col1, chr(9), col2, chr(9), coln, etc) AS newCol
m!ke
-Original Message-
From: Rick Faircloth [mailto:[EMAIL
Thanks, Azadi, I'll check it out.
-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 12:54 PM
To: CF-Talk
Subject: Re: How to combine multiple fields into one alias?
depending on your needs you may find CONCAT_WS to be more useful:
Thanks for the tip, Mike... I'm sure that will be useful.
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 1:04 PM
To: CF-Talk
Subject: RE: How to combine multiple fields into one alias?
That sounds very reasonable. You may also want
Wasn't there recently an update that fixed that issue? I seem to remember
reading that somewhere...
Eric
/*-Original Message-
/*From: Bruce Sorge [mailto:[EMAIL PROTECTED]
/*Sent: Monday, May 19, 2008 12:00 PM
/*To: CF-Talk
/*Subject: Re: Cftextarea and Fukeditor
/*
/*I was having a lot
Has anybody already written a Coldfusion job board application similar to
Elance.com or Guru.com? If so, please contact me at [EMAIL PROTECTED]
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
Not sure. I screwed with the out of the box version for a few weeks
and never got it to do what I want, and installed FCKEditor and it
worked great. Even if they fix it, I am sticking with that is
currently working. Like the saying goes, if it ain't broke, don't fix
it.
Bruce
On Mon, May 19,
Anyone tell me what I'm doing wrong here? XML and Arrays are not my strong
points.
cfif structKeyExists(ledata.callmeasurement.resultscall,
numbers)
cfif
structKeyExists(ledata.callmeasurement.resultscall.numbers, dnis)
cfset dnis_array = ArrayNew(1) /
CF8 had that functionality disabled. CF8.01 has full filebrowser and
image uploading support.
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Bruce Sorge wrote:
Not sure. I screwed with the out of the box version for a few weeks
and never got it to do what I want, and installed
My personal opinion
I have fiddled with FCKEditor for several years.
It is a nice interface, and provides the users with a nice toolset.
However, as far as browser compatibility. I think FCKEditor has some
room for improvement.
Be it the image uploader, or like you have pointed out, it simply
im having an odd issue whereby a log file of some sort is
filling up fairly quickly... the contents of this file, are
growing by gigs... anyway, anyone
know: 1. what this is? 2. how i can stop it? 3. how can i
control its growth?
below is a snippet...
2008-05-19 00:00:00
Anyone tell me what I'm doing wrong here? XML and Arrays are
not my strong points.
cfif structKeyExists(ledata.callmeasurement.resultscall,
numbers)
cfif
structKeyExists(ledata.callmeasurement.resultscall.numbers, dnis)
cfset dnis_array = ArrayNew(1)
Thanks Matthew - but i've had it running reliably on IE6 and Firefox
for ages . It's just now, on IE7 thats the problem.
Have you ever managed to make it work wtih IE7?
I notice by the way that when i go to the FCKEditor site, the demos
there work on IE7, so i do konw it's possible to make it
Stupid flipping typos... Thanks Dave.
On Mon, May 19, 2008 at 12:55 PM, Dave Watts [EMAIL PROTECTED] wrote:
Anyone tell me what I'm doing wrong here? XML and Arrays are
not my strong points.
cfif structKeyExists(ledata.callmeasurement.resultscall,
numbers)
cfif
you don't have any silly code like cfform inside a table on you page, do
you? that tends to often break things...
also check your doctype declaration: the way IE7 renders pages differs
depending on what you have in the doctype, though i forget specifics of
this...
Azadi Saryev
Sabai-dee.com
For what it is worth, I used Rick Root's CFFM - Coldfusion File Manager with
Fckeditor a few years back and they play(ed) nice with each other. He was
also nice enough to help me work out some issues I was having when trying to
tweak some settings with Fckeditor as it related to CFFM.
I know that demo site very well.
The think I had to do to get it to work in the various flavors was go in
and tinker with all the .cfg files and make sure the \ and /
were being intepreted correctly for my file system.
The app on the demo site works because it is configured for their
thanks dave, we actually figured it out by googling the VERY top line of that...
:) and yes, it was that, and my new network admin who setup the box
didnt realize that wasnt supps to be checked!
all good.
take'er easy
tony
On Mon, May 19, 2008 at 1:53 PM, Dave Watts [EMAIL PROTECTED] wrote:
im
THanks Matthew, i know for sure it works because it's been working
for at least two years on this server.
It's only since the advent of IE7 that it's giving problems. It still
works fine with Firefox and IE6. SO the question is,, what's
different about IE7 that makes it break?
Axzadi's
Just an FYI in case many of you didn't know, but ActivEdit, the other
WYSIWYG editor for web pages, is now open source and available for download
at the creator's website: http://www.zrinity.com/activedit
Just an alternative solution for those who haven't invested a lot of time
into FCKEditor.
check out ben nadel's blog for this and a lot more:
www.bennadel.com
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Thanks, will do.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
Nice, thanx for the 411.
G
On Mon, May 19, 2008 at 2:39 PM, Erika L. Walker [EMAIL PROTECTED]
wrote:
Just an FYI in case many of you didn't know, but ActivEdit, the other
WYSIWYG editor for web pages, is now open source and available for download
at the creator's website:
I have two series of data. One is on a scale of 0-10 and the other is 0-1000.
Is there a way to set the left Y axis to show the scale 0-10 and the right Y
axis 0-1000?
Thanks,
Chad
~|
Adobe® ColdFusion® 8 software 8 is the
you could always multiply the Y scale by 100 to get them closer ;) Just
represent that multiplication in your description somehow.
Chris
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, May 19, 2008 3:07 PM
To: CF-Talk
Subject: cfchart
I have two series of
I recently upgrade my application from a Visual FoxPro database to and Oracle
10g database. I converted the foxpro memo fields to Oracle Clobs. Now my
Verity Indexing doesn't work. The table contains only 5600 records with the
largest CLOB containing approx 9K characters. The query works
Probably Flash and/or Flex can. But it would be nice if cf8 can do
that as well (not something fancy/full-blown), if this capability is
already built in with cf8, pls show me. Thanks.
Process flow: a) simple draw -- b) the {cf image tag} capture it --
c) store it...
Sorry if asking
However, as far as browser compatibility. I think FCKEditor has some
room for improvement.
With IE, there are so many options the user can deactivate that it is
not easy for the Javascript developer.
There are for instance several security checks that locks ActiveX, even
internal activeX
Claude do you have any idea of the settings needed? Perhaps i can
give my clients a how-to document that will let them set up their IE
so they can continue to use their CMS with IE7 as they have for teh
last year
Cheers
Mike Kear
On Tue, May 20, 2008 at 7:19 AM, Claude Schneegans
[EMAIL
Hi all. I'm hoping someone can help out with this problem I've run into.
I'm trying to make our home grown CMS a bit easier to use for our
editors and easier to maintain. The issue at hand involves how we code
email addresses into the content. I have an even that pops up a new
contact window
I originally posted this as a reply to another post in the CF-Community form
that I found through a search. Apologies for the double post.
Using cfdocument I am creating a PDF that starts with an information page that
requires no header, and then needs produce a header on each following page.
On Thu, May 15, 2008 at 1:49 PM, Rich [EMAIL PROTECTED] wrote:
Does anyone have any experience with CF8 ActiveMQ integration?
Yes (I wrote the event gateway).
I was attempting to set up activeMQ 5.1 and leverage the ActiveMQ event
AMQ5.1 won't work. AMQ4.1 will. Not sure what they fubar'd in
Hey Mike,
On Mon, May 19, 2008 at 11:07 PM, Mike Kear [EMAIL PROTECTED] wrote:
I Look at the pages myself, and with Firefox and IE6 everything's
working fine. But with IE7 the page just shows the blank space
where FCKEditor must go.
This is probably not much help, but IE7 is far more
Just an FYI in case many of you didn't know, but ActivEdit, the other
WYSIWYG editor for web pages, is now open source and available for download
at the creator's website: http://www.zrinity.com/activedit
Just an alternative solution for those who haven't invested a lot of time
into FCKEditor.
cfif structKeyExists(ledata.callmeasurement.resultscall.numbers, dnis)
cfset dnis_array = ArrayNew(1) /
cfloop from=1
to=#arrayLen(ledata.callmeasurement.resultscall.numbers.XMLChildren)#
index=i
...etc
Also, the ArrayLen() of
I take it you can load the function in to memory like using an init method
on a CFC... by calling the function with out the the () and not passing it
any vars?
Kind of, though I wouldn't make that comparison. My theory is less
than solid here so please someone patch where it is mistaken:
When
Alagad's ImageComponent (http://www.alagad.com) is platform
independent the CFC doesn't need to be 'installed' on the server, it
can sit in the same directory as the page that is calling it.
The only problem it that it's a commercial product (US$150) but if an
upgrade to CF8 isn't likely
Hi Jeremy, Here is how I do it in CF4em to replace things like [code]some
code[/code]
Loop the string, replacing the blocks with a marker and storing the name in
an array (the array position would match the marker)
Then you can loop the array, convert the names to links and put them back
into
. When ColdFusion processes a 'page' with a udf (either cffunction or
scripted 'function'); the function is parsed and created as an
*object* in memory (a special function type object). By 'calling' the
function without the () you are actually referencing the object itself
rather than invoking the
I have a growing collection of misc UDFs and was thinking that there must be
a better way
than doing an include for every page load or loading some monster cfc of
random functions.
I've not tried it yet, but Model-Glue 3 handles this so beautifully. A
'helpers' folder is created in the root
Kind of, though I wouldn't make that comparison. My theory is
less than solid here so please someone patch where it is mistaken:
When ColdFusion processes a 'page' with a udf (either
cffunction or scripted 'function'); the function is parsed
and created as an
*object* in memory (a
Thanks Bobby, I'll give that a shot.
On Mon, May 19, 2008 at 6:20 PM, Bobby Hartsfield [EMAIL PROTECTED] wrote:
Hi Jeremy, Here is how I do it in CF4em to replace things like [code]some
code[/code]
Loop the string, replacing the blocks with a marker and storing the name in
an array (the
Just download the Library and look under examples. There are a bunch of them
that work right out of the box. You pass just it a couple vars and you are
done. Very easy.
Hi Gerald, were you referring to the following url for the current cfc for this
editor?
What takes more time? Reading a you've made a mistake message or
taking the time to write a you made a mistake message even though
someone has already written one without you knowing about it.
I would prefer correction messages posted to the list because it lets me
know that one was already
Reading one.
On 5/19/08, Jordan Michaels [EMAIL PROTECTED] wrote:
What takes more time? Reading a you've made a mistake message or
taking the time to write a you made a mistake message even though
someone has already written one without you knowing about it.
I would prefer correction
So you agree that the post was a good one. Thanks. :)
On Mon, May 19, 2008 at 10:19 AM, sherri sonnier [EMAIL PROTECTED] wrote:
Reading one.
On 5/19/08, Jordan Michaels [EMAIL PROTECTED] wrote:
What takes more time? Reading a you've made a mistake message or
taking the time to write a
91 matches
Mail list logo
