Re: Coldfusion 8 on Linux Installation ( Linus ver. ie. Aspire One laptop )

2008-08-26 Thread rex
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have CF8 running on Debian 4 on a P3-800 MHz 512MB RAM, 12GB HDD I have 256MB assigned to the JVM, and it works fine for a small app. I'm sure you'll run into memory issues, though, if your app needs it. Don wrote: Anyone else? thoughts or

Re: Centering text written on an image

2008-08-26 Thread Kevin Roche
I think you have to figure out the offset, and start from there. So, you'll need to determine the approximate width in pixels of your text string, But the quetion is how? How can I find the width of the string? I tried making a table of widths and that does not work really. For example with

RE: Centering text written on an image

2008-08-26 Thread Rick Faircloth
Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width, then with that info in hand, write your text onto your image? Rick -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Re: Centering text written on an image

2008-08-26 Thread Azadi Saryev
that's exactly what i am doing for my client who wants to create custom ads for their products (tours). my situation is easier in a way that the ads are pre-st size and i have a transparent .png of same size to put text on, add shadows etc, and then overlay it over the product image. easy as pie

Re: SQL injection attack on House of Fusion

2008-08-26 Thread Peter Tilbrook
Just got nailed myself - dammit - 15 years of knowledge. Have code reviewed and wasn't my CFML (at this stage) so maybe a new IIS vulnerability? My attack occured recently - possibly in the last 24 hours or so. Have disabled the database and CFABORTed any code that interacts with the database

Re: Centering text written on an image

2008-08-26 Thread Raymond Camden
You will also find related functions in ImageUtils as well. If I remember right we (CFC was made by Ben Nadel, myself, and others) also have a generic 'getSize' func for text as well. Either way though, the CFC makes this operation trivial. On Fri, Aug 22, 2008 at 1:03 PM, Chris Blackwell [EMAIL

Re: Centering text written on an image

2008-08-26 Thread Kevin Roche
Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I have no Idea how to do that. Can you tell me how to find the width of the text? ~| Adobe®

Re: CFHTTP and SSL

2008-08-26 Thread Gerald Guido
Is your cert self-signed or was it purchased from a place like Thawte? I ran into this a few years back... CFHTTP flat out failed with a self signed cert. I feel your pain. Took me better part of a day to figure out wft was going on. You have to register the cert with CF some how. I forgot what

Re: Centering text written on an image

2008-08-26 Thread Raymond Camden
Yes, again, the CFC has a way to get the height/width of _just_ a textual component. On Tue, Aug 26, 2008 at 7:42 AM, Kevin Roche [EMAIL PROTECTED] wrote: Is there a way to add an extra step or two and make an image of just your text, determine that width which gives you your string width I

RE: Centering text written on an image

2008-08-26 Thread Rick Faircloth
What I'm thinking is trying to avoid determining the text width by creating an image of just the text and measuring that. Once you have that width information, you can use it to determine how to center the text when you apply it to the background image. Such as: Here's your text: MyText

RE: SQL injection attack on House of Fusion

2008-08-26 Thread Dave Watts
Have code reviewed and wasn't my CFML (at this stage) so maybe a new IIS vulnerability? I seriously doubt this has anything to do with IIS, since IIS can't interact directly with your database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest

RE: PID errors - much simpler

2008-08-26 Thread Dave Watts
James, if the JVM crashes, it will certainly create a hs_err_pid file, but how do you know that the OP's problem is related to hotspot optimization? I'm pretty sure that hs_err_pid files are only generated for Hot Spot errors specifically. Other JVM crashes don't create them. Dave Watts,

RE: Centering text written on an image

2008-08-26 Thread Rick Faircloth
Ray's approach is the best way to go. It's going to be better for the long run. It's good to know that CFC is there, Ray. I'm sure I'll be making using of it, too! By the way...if it can be explained without taking too much of your time...how does the CFC measure the height and width of text

RE: cfhttp and Google Search Appliance

2008-08-26 Thread Dave Watts
Thanks for your help Dave. Yes, the URL is http://IP:8000/EnterpriseController I don't expect you to do my job for me, but I have included my initial script below. Does anything jump out as being wrong? My code is probably not the best since I am still learning coldfusion. I don't

Re: Centering text written on an image

2008-08-26 Thread Claude Schneegans
how does the CFC measure the height and width of text without resorting to an image Any decent text/Image processing library will provide some function to calculate the physical length of a string given a specific font and size. And I'm pretty sure Ray's CFC is using a decent library.

Re: Centering text written on an image

2008-08-26 Thread Kevin Roche
What I'm thinking is trying to avoid determining the text width by creating an image of just the text and measuring that. Yes but how? When you create an image in ColdFusion you have to give it a width and a height. If you don't you get an error when you try and use it: The image on which the

Re: Centering text written on an image

2008-08-26 Thread Raymond Camden
It's using a bunch of Java code from an Adobe blogger (used with permission). I forget the name, but it should be credited in the CFC itself. I definitely can't take credit for the code, although I think I handled the wrapping up in the method. That counts for something, right? ;) Anyway, that

RE: Centering text written on an image

2008-08-26 Thread Rick Faircloth
Thanks, Claude. I figured I could look at the CFC code, but it would most likely take wy too long for me to figure out what was happening. Good stuff to know. Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 9:57 AM To:

Re: PID errors - much simpler

2008-08-26 Thread James Wolfe
Dave, I believe that you are correct. I'm fairly certain that the prefix hs_ is indicating that it was a HotSpot error. - James # Java VM: Java HotSpot(TM) Server VM (10.0-b19 mixed mode windows-x86) James, if the JVM crashes, it will certainly create a hs_err_pid file, but how do you know

Re: PID errors - much simpler

2008-08-26 Thread James Wolfe
Brad, Do you know what it WAS related to? Do you make extensive use of CFTHREAD ? - James Yes, I've gotten them when JRUN had a hard crash, but it was never related to image manipulation. ~Brad ~| Adobe® ColdFusion® 8

Re: PID errors - much simpler

2008-08-26 Thread James Wolfe
Our JVM is fully updated. No love. We have the new CFImage patch from Adobe. No love. I am curious what you meant about this being a classic sign of the problem. We can often go through 7,000 images without one error and then we'll get two errors within 20 images of each other and then go

Multiserver Step Debugging with CF8

2008-08-26 Thread Laura Norris
I'm new to step debugging and new to Eclipse. I'm desperate to use the step debugging feature to track down a problem. My hangup is turning on the debugging in a multiserver environment. Our site has two instances running. I've found instructions to edit the jrun/bin/jvm.config file with the

Multiserver Step Debugging with CF8

2008-08-26 Thread Laura Norris
I'm new to step debugging and new to Eclipse. I'm desperate to use the step debugging feature to track down a problem. My hangup is turning on the debugging in a multiserver environment. Our site has two instances running. I've found instructions to edit the jrun/bin/jvm.config file with the

Re: SQL injection attack on House of Fusion

2008-08-26 Thread Al Musella, DPM
Open the website log with word and do a search for DECLARE you will find a lot of entries.. Look for a filename that is in a different directory than what you expected.. I think I got hit from a template that was in an old, unused directory from many years ago. I recently went through

Re: Multiserver Step Debugging with CF8

2008-08-26 Thread Jo�o_Fernandes
Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this instructions to assign a specific config to each instance: http://mkruger.cfwebtools.com/index.cfm/2006/4/17/multiserver Then,

Re: Multiserver Step Debugging with CF8

2008-08-26 Thread Laura Norris
what are good port numbers to use? Laura Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this instructions to assign a specific config to each instance:

RE: PID errors - much simpler

2008-08-26 Thread Dave Watts
Our JVM is fully updated. No love. We have the new CFImage patch from Adobe. No love. I am curious what you meant about this being a classic sign of the problem. We can often go through 7,000 images without one error and then we'll get two errors within 20 images of each other and

Print Page Controls

2008-08-26 Thread Jeanmarie Richardson
Hi -- I am working on an application where the user will need to print different reports to different printers. I.E. a receipt printer and a dcoument printer. I read an older post in this list that somone was using MeadCo's ScriptX, Active X Control to do this -- are there any other ways to

ODBC Connection to Microsoft SQL DB Stored Proc

2008-08-26 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
My Microsoft SQL database contains multiple stored procedures with access to these stored procedures secured by SQL Authenticated Login Accounts (i.e. Manager, User, Auditor). I am setting two session variables, session.UserName and session.Password, to the SQL Authenticated Login account for

XML rendering issue

2008-08-26 Thread Simon Bailey
Hi all, I have this pain in the rear issue with cf generated xml. I have a flex app that is sending inputted text to cf, this is then sent to a database and then runs a query to generate xml from the data in the database. cffunction name=updateXMLStream access=remote

RE: XML rendering issue

2008-08-26 Thread Dave Watts
This still generates problems with certain characters such as ' and I was wondering if people had any tips or advise on this at all? While you're using a CDATA block in body_text, and that will take care of the problem there, you also have to escape XML character entities in attribute

Re: XML rendering issue

2008-08-26 Thread James Holmes
XMLFormat() takes care of escaping those characters and making them XML safe. On Tue, Aug 26, 2008 at 11:35 PM, Simon Bailey [EMAIL PROTECTED] wrote: Hi all, I have this pain in the rear issue with cf generated xml... [snip] This still generates problems with certain characters such as '

Re: XML rendering issue

2008-08-26 Thread Dominic Watson
test name=#XMLEncodedFormat(qTemplate.test)# I think that should be XmlFormat(), not XmlEncodedFormat() ;) Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

RE: ODBC Connection to Microsoft SQL DB Stored Proc

2008-08-26 Thread Mark Kruger
First, keep in mind that this is going to be JDBC, not ODBC (2 different animals). Second, you should be able to set up a datasource without any credentials (no username and password). In which case your stored proc code will require a username password to work. If you are going to set up

Re: XML rendering issue

2008-08-26 Thread Simon Bailey
Ahhh ok so I can implement the XMLFormat method as opposed to the XMLEncodedFormat, wicked thanks! Is there a way of avoiding having to utilise that method on each xml node i.e. use it higher up the xml generation method? Cheers, Simon On 26 Aug 2008, at 16:43, Dominic Watson wrote:

RE: XML rendering issue

2008-08-26 Thread Dave Watts
test name=#XMLEncodedFormat(qTemplate.test)# I think that should be XmlFormat(), not XmlEncodedFormat() ;) Yes, it should! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in

Re: XML rendering issue

2008-08-26 Thread Simon Bailey
Sweet thanks Dave and all :-) On 26 Aug 2008, at 16:43, Dave Watts wrote: This still generates problems with certain characters such as ' and I was wondering if people had any tips or advise on this at all? While you're using a CDATA block in body_text, and that will take care of the

Re: PID errors - much simpler

2008-08-26 Thread Brad Wood
No. Usually, I have only gotten errors like that just after a botched install CF, or when I am screwing around with stuff. (Fiddling with core JAR files and such for experiments) I can't remember the last time I got an error like that under a normal usage scenario. ~Brad - Original

RE: Centering text written on an image

2008-08-26 Thread Rick Faircloth
This just shows my ignorance about text overlay. I was hoping there was a way with CF 8 to just tell it what font, size, and text and it would calculate the rest. But, apparently not. CF 9 should definitely incorporate that. Ray's approach seems to be the best solution of all. It's the only one

Re: PID errors - much simpler

2008-08-26 Thread Brad Wood
What the other James and Dave said actually makes some sense now that I think about it. Read http://java.sun.com/javase/technologies/hotspot/index.jsp-- it explains what hotspot optimization does. Basically, your JVM will actually change how it is compiling code after your server had been

Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
I need to order query results by class desc. Classes are typically AA, A, B, C, D, etc. Order by class desc puts the AA, A in the correct order, but when all are ordered, I get: D C B AA A The only double letters involved in classes are AA, and AAA. I need a conditional order by statement...

RE: Here's an interesting little problem...

2008-08-26 Thread Dave Phillips
Rick, What database are you using? One thought that comes to mind is to do TWO selects with a UNION and give each their own ORDER BY clause. Something like this: Select . where class NOT in ('A','AA','AAA') ORDER BY class DESC UNION ALL Select . where class in ('A','AA','AAA') ORDER BY

Re: Multiserver Step Debugging with CF8

2008-08-26 Thread Laura Norris
so, trying to get the custom jvm file to work completely hosed the instance i tried it on. any other suggestions? Thanks, Laura Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this

Re: Multiserver Step Debugging with CF8

2008-08-26 Thread Laura Norris
so, trying to create a separate jvm file completely hosed the instance i was working with. any other suggestions? Thanks, Laura Laura, what I usually do is to assign a different JVM config file to each instance and then assign different port numbers for each one of them. You can follow this

Re: Here's an interesting little problem...

2008-08-26 Thread Carl Von Stetten
Rick, Could you add an additional column to the database table to store a numeric sorting value? Or a second character column with spaces prepended to the single character and double character values (like A, B, AA, AAA)? Carl Rick Faircloth wrote: I need to order query results by

RE: Multiserver Step Debugging with CF8

2008-08-26 Thread Dave Watts
so, trying to create a separate jvm file completely hosed the instance i was working with. any other suggestions? I suggest you more clearly define completely hosed. What happens if you attempt to start the instance from the command line? What do you see in your JRun log files, if anything?

Re: cftimer does not work

2008-08-26 Thread Developer MediaDoc
Oh boy, thanks a TON RAY... somehow some IP's got in the IP restrictions, so that was the cause... MANY MANY thanks, this has 'bugged' me for 1/2 a year! Matts Check the IP restrictions for db output in the admin. Hi all, CF 8.01 Standard Windows 2003 I cannot get cftimer to display

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
Sounds like a good idea to me. I'll give it a shot. Thanks, Rick -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 12:44 PM To: CF-Talk Subject: RE: Here's an interesting little problem... Rick, What database are you using?

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
Oh, sorry... MySQL 5. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 12:44 PM To: CF-Talk Subject: RE: Here's an interesting little problem... Rick, What database are you using? One thought that comes to mind is to do TWO

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
I'd rather avoid the extra column for numeric sorting. My client is terribly lazy and would see that as just one more thing to do to maintain the app. G... Prepending the spaces sounds interesting. I may try that. I can do that on the fly, with concat(A, ), etc... Well actually concat

Re: cftimer does not work

2008-08-26 Thread Raymond Camden
Wow can I send a check for my services for half a year? ;) On Tue, Aug 26, 2008 at 12:18 PM, Developer MediaDoc [EMAIL PROTECTED] wrote: Oh boy, thanks a TON RAY... somehow some IP's got in the IP restrictions, so that was the cause... MANY MANY thanks, this has 'bugged' me for 1/2 a year!

Re: Here's an interesting little problem...

2008-08-26 Thread Greg Morphis
Rick, did you want to see AA D C B A or D C B A AA ? On Tue, Aug 26, 2008 at 12:25 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Sounds like a good idea to me. I'll give it a shot. Thanks, Rick -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday,

cfscript question

2008-08-26 Thread Scott Stewart
Is it possible to do a query output loop in cfscript using something other than WriteOutput? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600

Re: Multiserver Step Debugging with CF8

2008-08-26 Thread Laura Norris
ok, i got the instance working again, but i still get the same error when i try to go into debugging in eclipse i get the same error, except with the new port number i used. so, trying to create a separate jvm file completely hosed the instance i was working with. any other suggestions?

Re: cfscript question

2008-08-26 Thread Charlie Griefer
On Tue, Aug 26, 2008 at 10:45 AM, Scott Stewart [EMAIL PROTECTED]wrote: Is it possible to do a query output loop in cfscript using something other than WriteOutput? obvious question is... why? :) for (i=1; i lt queryname.recordcount; i=i+1) { // you can pretty that up a bit if you're on CF8

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
AA A B C D E etc. -Original Message- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 1:41 PM To: CF-Talk Subject: Re: Here's an interesting little problem... Rick, did you want to see AA D C B A or D C B A AA ? On Tue, Aug 26, 2008

Re: cfscript question

2008-08-26 Thread Brad Wood
Are you wishing for your function to return the generated content as a return variable as opposed to directly outputting to the page buffer? If so, you can concatenate strings together and then return the string at the end of the function. I'm not really sure where you are going with this

Re: cfscript question

2008-08-26 Thread Scott Stewart
trying to make sense out of some screwy logic that someone else did although I'm about ready to rewrite it with tags... Charlie Griefer wrote: On Tue, Aug 26, 2008 at 10:45 AM, Scott Stewart [EMAIL PROTECTED]wrote: Is it possible to do a query output loop in cfscript using something

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
Hmmm... why would I get this error: (MySQL 5) Unknown column 'lower_shooter_class' in 'order clause' from this query: cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname,

RE: Here's an interesting little problem...

2008-08-26 Thread Milburn, Steve
How about this: order by len(class) desc, class ? Steve From: Rick Faircloth [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:00 PM To: CF-Talk Subject: RE: Here's an interesting little problem... AA A B C D E etc. -Original Message-

Re: Here's an interesting little problem...

2008-08-26 Thread Charlie Griefer
ORDER BY CASE class WHEN 'AA' THEN 10 WHEN 'A' THEN 20 WHEN 'B' THEN 30 WHEN 'C' THEN 40 WHEN 'D' THEN 50 WHEN 'E' THEN 60 END incremented by 10 so you can add 'AAA' etc later :) On Tue, Aug 26, 2008 at 11:00 AM, Rick Faircloth [EMAIL

Re: cfscript question

2008-08-26 Thread Scott Stewart
nope, I need to populate a function call based on another query Brad Wood wrote: Are you wishing for your function to return the generated content as a return variable as opposed to directly outputting to the page buffer? If so, you can concatenate strings together and then return the

RE: Here's an interesting little problem...

2008-08-26 Thread Dave Phillips
Because the column name will be represented by whatever the FIRST select is, and in this case, that is 'top_shooter_class'. Try this: cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time,

RE: Here's an interesting little problem...

2008-08-26 Thread Milburn, Steve
Sorry, I just saw the post where you stated you are using MySQL. len is not a MySQL function, but length is. try this: order by length(class) desc, class. Steve From: Milburn, Steve [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:07 PM To: CF-Talk

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
We have a winner! Charlie! Solution: cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state, s.nsca, r.con, r.class, r.shot, r.broke

RE: cfscript question

2008-08-26 Thread Dave Watts
Is it possible to do a query output loop in cfscript using something other than WriteOutput? The only way to write any output directly from CFSCRIPT is to use WriteOutput. You can, of course, invoke functions written in CFML from CFSCRIPT. Dave Watts, CTO, Fig Leaf Software

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
Thanks, Dave! Rick -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 2:16 PM To: CF-Talk Subject: RE: Here's an interesting little problem... Because the column name will be represented by whatever the FIRST select is, and in this

Re: cfscript question

2008-08-26 Thread Scott Stewart
lemme rephrase... I'm trying to populate a function call, by looping over the record count of a query to end up with something like this: function(sunday_0, mon_0, tues_0) function(sunday_1, monday_1, tues_1) etc. the number is dynamic based on the record count of a query.. code:

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
And we have another winner! Steve! With an even faster way to skin the cat. (My apologies to my cat, Maggie...) cfquery name=get_results datasource=#application.dsn# select t.name, t.date, t.time, s.firstname, s.lastname, s.state,

Re: Here's an interesting little problem...

2008-08-26 Thread Charlie Griefer
i'm not givin' back my prize. On Tue, Aug 26, 2008 at 11:38 AM, Rick Faircloth [EMAIL PROTECTED]wrote: And we have another winner! Steve! With an even faster way to skin the cat. (My apologies to my cat, Maggie...) cfquery name=get_results datasource=#application.dsn# select

Re: cfscript question

2008-08-26 Thread Yuliang Ruan
yea but...function calls shouldn't have dynamic number of arguments. perhaps u mean to create a list of arguments and pass it in as 1 argument? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to

RE: cfscript question

2008-08-26 Thread Dave Watts
yea but...function calls shouldn't have dynamic number of arguments. Why not? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern

RE: cfscript question

2008-08-26 Thread Dave Watts
I'm trying to populate a function call, by looping over the record count of a query What you have looks fine to me. What's the problem, exactly? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our

RE: Here's an interesting little problem...

2008-08-26 Thread Rick Faircloth
It's already in the mail! :o) I definitely put yours and Steve's solutions in my snippets. Steve's will work when value length is a determinant, but yours will work in any case. :o) Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26,

Re: SQL injection attack on House of Fusion

2008-08-26 Thread denstar
On Tue, Aug 26, 2008 at 4:46 AM, Peter Tilbrook wrote: Just got nailed myself - dammit - 15 years of knowledge. There are at least 2 tools available that will search through your code looking for unparamed variables, and I think Larry posted a simple regex that you could use from within Eclipse.

RE: Here's an interesting little problem...

2008-08-26 Thread Eric Roberts
There is also a way in Oracle(just for reference)...you can used decode() to do this (not sure if any of the other db's have this or a similar function). You would add decode(class,'aa',1,'a',2,'b',3...,/default value/) as sort_order in the select statement then in the order by, order by

Re: Here's an interesting little problem...

2008-08-26 Thread Greg Morphis
Yeah but you can do the same with a case statement... which was introduced in Oracle 9i.. Plus there's no reason to select it unless you intend on using it later. Just do select class from classes order by decode(lower(class),'aa',1,'a',2,...) just FYI On Tue, Aug 26, 2008 at 2:31 PM, Eric

Re: Here's an interesting little problem...

2008-08-26 Thread Chris Blackwell
i know i'm a little late to this party but... SELECT `class`, concat(left(`class`, 1),100-length(`class`)) AS `sort` FROM myTable ORDER BY `sort` ASC will give you AAA AA A B CC C D etc ~| Adobe® ColdFusion® 8 software 8

RE: SQL injection attack on House of Fusion

2008-08-26 Thread Dave Watts
It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if you're calling a stored procedure from CFQUERY you have

RE: Here's an interesting little problem...

2008-08-26 Thread Eric Roberts
Guess you can do that too ;-) I like it better in some ways than the case (it's easier to create a dynamic list), though the case statement would be easier to read... /*-Original Message- /*From: Greg Morphis [mailto:[EMAIL PROTECTED] /*Sent: Tuesday, August 26, 2008 2:42 PM /*To:

RE: Something other than SQL injection attack on House of Fusion

2008-08-26 Thread Andy Matthews
Can someone PLEASE change the title of this thread??? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:01 PM To: CF-Talk Subject: RE: SQL injection attack on House of Fusion It doesn't work with stored procedures (which shouldn't matter,

Andy Matthews has too much free time - was... SQL injection attack on House of Fusion

2008-08-26 Thread Alan Rother
Sorry Andy, I couldn't resist. =] On Tue, Aug 26, 2008 at 1:46 PM, Andy Matthews [EMAIL PROTECTED]wrote: Can someone PLEASE change the title of this thread??? -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: Increasing Max Memory

2008-08-26 Thread Steve Moore
Thanks for the ideas. It appears the Request Throttle Memory setting was the limiting factor. Once upped, I can successfully upload files to that limit. Steve ~| Adobe® ColdFusion® 8 software 8 is the most important and

RE: Andy Matthews has too much free time - was... SQL injection attack on House of Fusion

2008-08-26 Thread Andy Matthews
:P -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:57 PM To: CF-Talk Subject: Andy Matthews has too much free time - was... SQL injection attack on House of Fusion Sorry Andy, I couldn't resist. =] On Tue, Aug 26, 2008 at 1:46 PM, Andy

Uninstall ColdFusion 8 seems to be frozen.

2008-08-26 Thread Ian Skinner
I'm uninstalling CF8 to do a clean re-install and it seems to be frozen near the end of the 'Folders' section. What type of pain am I in for if I abort the uninstaller at this point? Windows 2003 server FYI ~| Adobe®

Re: Cybersource Gateway Solution Found For ColdFusion

2008-08-26 Thread Casey Dougall
Hey Philip, Was searching through my archives here. I'd love to know if you are using the SOAP api do do this as java version is just driving me nuts. We were using the ASP/COM version and that worked well but we're setting up a new site on a BlueDragon server and you can't use COM objects in

Re: Increasing Max Memory

2008-08-26 Thread Brian Kotek
Just a note to be careful with this. Each upload is going to use up a CF thread for the entire duration of the upload, which means that if you have 10 threads allocated to CF and 10 people upload large files, you've used up all of your CF threads for quite a long time. On Tue, Aug 26, 2008 at

Solution to xmlFormat() and Restricting String Length

2008-08-26 Thread Sonny Savage
I have a project where I'm sending an XML string to an interface, and I'm performing xmlFormat() on the XML text values that I'm sending up. The XML elements have maximum field lengths so I'm using the left() function to constrain the values. My concern was that the left() function may cut my

Manually uninstalling ColdFusion 8

2008-08-26 Thread Ian Skinner
Does the technote describing how to manually uninstall CF 6 and 7 still apply to CF 8? http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19187 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

Strange ColdFusion folder

2008-08-26 Thread Ian Skinner
E:\JRun4\servers\general\cfusion.ear\cfusion.war\WEB-INF\cfusion\tmpCache\CFFileServlet\_cfreport\ What does this folder do and what would these virtX files be. There are so many on our server that I can not delete with the recycle bin. I as because this was a server that was

Re: SQL injection attack on House of Fusion

2008-08-26 Thread denstar
On Tue, Aug 26, 2008 at 2:01 PM, Dave Watts wrote: It doesn't work with stored procedures (which shouldn't matter, 'cause I think they are type-checked by the DB first anyways) Well, not necessarily. As Mark pointed out when this thread started - it feels like it was long, long ago - if

Re: SQL injection attack on House of Fusion

2008-08-26 Thread Brad Wood
That is, unless you concatenate SQL in your stored procedure. http://www.codersrevolution.com/index.cfm/2008/7/22/When-will-cfqueryparam-NOT-protect-me ~Brad - Original Message - From: denstar [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 26, 2008 6:26

The thread formally known as the SQL injection attack on House of Fusion

2008-08-26 Thread Gerald Guido
I hereby decree, in the name of all that doesn't suck, that from this day forth this thread will be hereby named The thread formally known as the SQL injection attack on House of Fusion . ~G~ On Tue, Aug 26, 2008 at 4:46 PM, Andy Matthews [EMAIL PROTECTED]wrote: Can someone PLEASE change the

Weird Time Issue Between Linux and Windows Server

2008-08-26 Thread Randy Johnson - CFConcepts
Hello, The following code displays different dates whether it is ran on a windows machine or a linux machine. form.thedates are javascript times that get passed in. cfset form.thedates=122050080|122110560|122171040|122231520| cfloop list=#form.theDates# index=i DELIMITERS=|

Re: Weird Time Issue Between Linux and Windows Server

2008-08-26 Thread Carl Von Stetten
Randy, Looks like a DST issue on Linux. Carl Randy Johnson - CFConcepts wrote: Hello, The following code displays different dates whether it is ran on a windows machine or a linux machine. form.thedates are javascript times that get passed in. cfset

Re: Weird Time Issue Between Linux and Windows Server

2008-08-26 Thread Randy Johnson - CFConcepts
Here is the out of a command I found to show you the DST dates: zdump -v /etc/localtime | grep 2008 /etc/localtime Sun Mar 9 06:59:59 2008 UTC = Sun Mar 9 01:59:59 2008 EST isdst=0 gmtoff=-18000

RE: Something other than SQL injection attack on House of Fusion

2008-08-26 Thread Bobby Hartsfield
Why? So everyone can create more filters? ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 4:47 PM To: CF-Talk Subject: RE: Something other than SQL injection

Re: Weird Time Issue Between Linux and Windows Server

2008-08-26 Thread Paul Hastings
Randy Johnson - CFConcepts wrote: Any ideas on what is going on? I cannot seem to find anything that indicates what is going on. are both boxes in the same timezone (tz)? what tz is the linux box in? ~| Adobe® ColdFusion®

Re: SQL injection attack on House of Fusion

2008-08-26 Thread denstar
On Tue, Aug 26, 2008 at 5:42 PM, Brad Wood wrote: That is, unless you concatenate SQL in your stored procedure. http://www.codersrevolution.com/index.cfm/2008/7/22/When-will-cfqueryparam-NOT-protect-me Perfect example, thanks! Yeah, dunno what I was thinking... parsing that stuff would be not

Re: Something other than SQL injection attack on House of Fusion

2008-08-26 Thread denstar
On Tue, Aug 26, 2008 at 7:18 PM, Bobby Hartsfield wrote: Why? So everyone can create more filters? Filters?!?! If you've been filtering, you've been missing out! There's been action, adventure, intrigue! We've been working on it this whole time. Has a nice little narrative... a beginning,

  1   2   >