CFFTP - put file problems

2007-11-28 Thread Giles Roadnight
Hi All I'm trying to get my CF server to FTP files to another server. I can connect ok but cannot put files. *My code:* cfdirectory directory=#request.dataArchiveLocation# action=list filter=*.rar name=archiveList / cfoutput p h1Files to transfer:/h1 cfloop query=archiveList

Re: CF8 and CFmail, sending duplicate emails

2007-11-28 Thread Tom Chiverton
On Tuesday 27 Nov 2007, Will Swain wrote: Are you talking about one thread for all the cfmails (outside the loop), or one for each mail? I'm assuming the latter wouldn't be a good plan where there might be thousands of emails, particularly on CF8 Standard. I'd batch them, with one thread for

Re: OT: SQL Data Type

2007-11-28 Thread Claude Schneegans
What are the benefits on using a CHAR field versus VARCHAR? The basic idea, back to the first database systems, is that all records have the same length and use the same amount of space in the database. Thus finding a record is just a matter of multiplying this record length by the record

Re: CFFTP - put file problems

2007-11-28 Thread Jochem van Dieten
Giles Roadnight wrote: I'm trying to get my CF server to FTP files to another server. I can connect ok but cannot put files. That can be caused by several issues with filesystem permissions and firewalls as the most likely culprits. Check the log files on the FTP server and if that doesn't

Re: OT: SQL Data Type

2007-11-28 Thread Tom Chiverton
On Wednesday 28 Nov 2007, Claude Schneegans wrote: It is then up to the programmer to decide what type of efficiency is the best for his application. However, almost no programmers will ever have to care about the tiny performance changes betwen the two, in which case VARCHAR is better because

Re: OT: SQL Data Type

2007-11-28 Thread Jochem van Dieten
ColdFusion wrote: What are the benefits on using a CHAR field versus VARCHAR? Check your database manual, the differences between implementations are such that for every other answer is pure speculation. Jochem ~| ColdFusion

Re: CFFTP - put file problems

2007-11-28 Thread Giles Roadnight
Thanks for the reply. Unfortunately I still can't get it working. I have looked at the FTP server logs. If I try a passive transfer I get the following when trying to transfer 2 files: userName logged in. (45) 28/11/2007 13:07:30 - userName () TYPE I (45) 28/11/2007 13:07:30 - userName

Re: Updating to Eclipse 3.3...

2007-11-28 Thread Brian Kotek
This is why I maintain a separate eclipse-extensions folder and install all my plugins there. If you have to install a fresh copy of Eclipse, all you need to do is point that new install at the extensions folder (in Manage Configuration). From there you can pull down updates to the plugins as

Re: CFDocument: 3x2 document but only uses 3/4 of it

2007-11-28 Thread Jane zheng
Hi Rob, I have been searching the internet and glad to find what I am trying to achieve is exactly the same as yours. At the same time I am sad that there were no responses to your questions since I am currently experiencing the same problems as you described. Bob, did you have the problem

Re: Conceptual Search against Database(s)

2007-11-28 Thread d l
Update: -- Have improved query performance substantially; -- Add additional notes... -- If we're talking about searching against a specific set of data, say, a particular data column in a database's table then, this approach, imho, kicks ass. So, probably one could consider to use it against

Open Source Ticket Software

2007-11-28 Thread Scott Raley -ITC
Can anyone recommend any CF based open source trouble ticket or issue tracking software? I know that there are tons of php out there which you can recommend but because of the restrictions I don't know that I can run it on this non-profits server. They have CF installed and Sharepoint but

RE: Open Source Ticket Software

2007-11-28 Thread Will Swain
http://lighthousepro.riaforge.org/ -Original Message- From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] Sent: 28 November 2007 17:06 To: CF-Talk Subject: Open Source Ticket Software Can anyone recommend any CF based open source trouble ticket or issue tracking software? I know that

Re: Open Source Ticket Software

2007-11-28 Thread Jim Rising
http://lighthousepro.riaforge.org/ http://skweegee.riaforge.org/ (based off trac) -jim On 11/28/07, Scott Raley -ITC [EMAIL PROTECTED] wrote: Can anyone recommend any CF based open source trouble ticket or issue tracking software? I know that there are tons of php out there which you can

RE: CFFTP - put file problems

2007-11-28 Thread Steve Logan
Unfortunately, no answer for you, but we're also have an CFFTP issue under CF8. A working template (under CF5) that FTP'd backup files to a remote server nightly no longer works on CF8. The files are generally around 10mb, but they always time out now at around 3mb +/-. Generally around 30

CFInvoke not finding method

2007-11-28 Thread C. Hatton Humphrey
Running into a strange thing - I'm trying to execute a CFInvoke tag, calling a method I just wrote into a CFC but I'm getting an error saying that the method can't be found. CFM code: cfinvoke component=parser method=requestMethod returnvariable=ReturnXML cfinvokeargument

Re: CFInvoke not finding method

2007-11-28 Thread C. Hatton Humphrey
cffunction name=requestMethod access=publicreturntype=struct output=false Found the problem... there wasn't a space between the public and returntype. Oops! ~| ColdFusion 8 - Build next generation apps today, with

re: Getting the data time from an unfamiliar returned value

2007-11-28 Thread CF Developer
Initial thought is the date /time would be: 11/21/2007 @ 7:35 (PM) ( 28 seconds as well). The 000Z would probable reference the date/time is in a Zulu Time. Now using CF to format it, if you can use RegEx and parse the T and .000Z and see if it validates as a date/time

RE: CFInvoke not finding method

2007-11-28 Thread Andy Matthews
Try invoking another method in that component? -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 1:05 PM To: CF-Talk Subject: CFInvoke not finding method Running into a strange thing - I'm trying to execute a CFInvoke tag, calling

Getting the data time from an unfamiliar returned value

2007-11-28 Thread Che Vilnonis
Here is the value: 2007-11-21T19:35:28.000Z It comes from the eBay REST API. It is in a format I have not seen. What can I do (with CF) to pull a valid date and time? Thanks, Che ~| Check out the new features and enhancements

CF8 Java Problem, Works on CF7

2007-11-28 Thread Matthew Lesko
See the class definitions below. In CF7 if create an instance of Outer, say outer, and code: outer.getInner().getID() things are fine. In CF8, I get the error The getID method was not found. If I cfdump outer in CF8 I see className: Outer$Inner Methods: [list of methods and return

sql and order by ?

2007-11-28 Thread Dave l
I have a list of serial numbers that I need listed in order but they aren't formatted the same, they start with 4 digit year and then item serial. Ok sounds easy but the serial numbers arent the same length, so serial #9 for 1950 would be 19509 and serial #101 for 1950 would be 1950101. So if

Re: sql and order by ?

2007-11-28 Thread d l
-- find sql env select @@version; --Microsoft SQL Server 2000 - 8.00.818 (Intel X86) -- dll create table #tmp (sYear int, sNum int); -- dml test data population insert into #tmp values(1950,12); insert into #tmp values(1950,9); insert into #tmp values(1955,11); -- dml solution -- looks like

Re: sql and order by ?

2007-11-28 Thread Azadi Saryev
you could add 2 columns in your sql: 1 with left(serial_number_column, 4) [if the year part of sn is always 4 digits], the other with the rest of the serial number, and sort the results first by one and hen y the other. exact sql syntax would be db-specific -- --- Azadi Saryev

Re: sql and order by ?

2007-11-28 Thread Alan Rother
ORDER BY LEFT(FieldName, 4), Right(FieldName, (LENGTH(FieldName)-4) ) That should do it, assuming the date part is always the same length. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org

Re: sql and order by ?

2007-11-28 Thread Dave l
@Azadi Saryev d l I need to use the data that is already there and it's not split up. @Alan Rother I had already tried that but it gives same results as reg order by asc ~| Check out the new features and enhancements in the

Re: sql and order by ?

2007-11-28 Thread Dave l
nope urgg lol How about this? SORT BY val(left(serial, 4)), val(substring(serial, 3)) ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki.

Re: sql and order by ?

2007-11-28 Thread Claude Schneegans
How about this? SORT BY val(left(serial, 4)), val(substring(serial, 3)) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks.

detecting pdas and redirecting them

2007-11-28 Thread mayo
I need to do a quick down and dirty retrofit of a site. Adding a Stylesheet media=handheld will be too time-consuming. I would rather do this server-side: if HTTP_USER_AGENT = handheld redirect to another page. Looking around - and asking on a CSS list doesn't get me very far. I can't be

re: CF8 Java Problem, Works on CF7

2007-11-28 Thread Kevan Stannard
Matthew, I gave this a try using your mock classes and it work fine for me, however a dump of outer.getInner() showed Class Name: Outer$Inner Parent Class: AbstractDecorator Class Name: AbstractDecorator Methods: getID() int Parent Class: Wrapped Class Name: Wrapped Methods: getID() int

Re: sql and order by ?

2007-11-28 Thread morgan l
If ordering by the Left() and Right() don't work, can you Select Left(SerialNum,4) as sYear, Right(SerialNum,Length(SerialNum)-4) as sNum and then order by sYear, sNum? Been a while since I've worked in mysql, but several of the suggestions here look like they should be working.

SOLVED: Re: sql and order by ?

2007-11-28 Thread Dave l
Thanks to all who tried, i got it working with the following: order by left(serial, 4) asc, abs(mid(serial, 5,3)) asc when in doubt visit the office lol ~| Download the latest ColdFusion 8 utilities including Report Builder,

Re: sql and order by ?

2007-11-28 Thread Antony Sideropoulos
Dave, Try Alan's solution again, but cast as integers. something like: order by cast(left(FieldName, 4) as int), cast(Right(FieldName, (LENGTH(FieldName)-4) ) as int) I haven't tested the above so you may need to adjust the syntax. Antony On Nov 29, 2007 7:59 AM, Dave l [EMAIL PROTECTED]

Re: CFDocument: 3x2 document but only uses 3/4 of it

2007-11-28 Thread Jane zheng
Hi anyone, Any suggestions on this issue? Thanks a lot. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now

re: Getting the data time from an unfamiliar returned value

2007-11-28 Thread Kevan Stannard
That looks like ISO 8601 date time format You can get more info http://en.wikipedia.org/wiki/ISO_8601 http://www.w3.org/TR/NOTE-datetime And a UDF from http://www.cflib.org/udf.cfm?id=1144enable=1 ~| ColdFusion is

Re: sql and order by ?

2007-11-28 Thread Dave l
thanks but I already had gotten it and posted it as solved, i ended up with order by left(serial, 4) asc, abs(mid(serial, 5,3)) asc If ordering by the Left() and Right() don't work, can you Select Left(SerialNum,4) as sYear, Right(SerialNum,Length(SerialNum)-4) as sNum and then order by

CFLayout and Spry

2007-11-28 Thread Steve Milburn
Hi all I'm using a tabbed cflayout. The source for a particular tab points to a page that uses spry. When viewed on its own, the spry page works fine, but it does not work in the cflayout. Apparently there are issues with using spry and cflayout like this. Has anyone successfully

Re: CFLayout and Spry

2007-11-28 Thread Dave l
Are you trying to use a full html page?(the spry page) You should only be using content and not the full html code as you would be putting a full html page into another which can cause issues. If you are just putting content then also make sure you are adding the spry calls into the html head

Re: Open Source Ticket Software

2007-11-28 Thread Mark Phillips
Many people use Vertabase for issue tracking. It isn't open source but it is Cf and affordable (especially for non-profits). http://www.vertabase.com ~| ColdFusion is delivering applications solutions at at top companies

Re: Open Source Ticket Software

2007-11-28 Thread Mark Phillips
http://lighthousepro.riaforge.org/ http://skweegee.riaforge.org/ (based off trac) -jim Many people use Vertabase for issue tracking. It isn't open source but it is Cf and affordable (especially for non-profits). http://www.vertabase.com

Re: Conceptual Search against Database(s)

2007-11-28 Thread James Wolfe
DL, You can find my email address here: http://www.omnibrow.com/deleteme.txt sorry for the runaround, but I don't want to post it online permanently and as soon as you email me, i will be taking it down. Sorry to everyone else that they have to be bothered with non-public business. James.

Re: Conceptual Search against Database(s)

2007-11-28 Thread d l
James, Got your email, will send you email tomorrow. Thks. Don DL, You can find my email address here: http://www.omnibrow.com/deleteme.txt sorry for the runaround, but I don't want to post it online permanently and as soon as you email me, i will be taking it down. Sorry to