CFFTP - put file problems
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 #archiveList.name#br / /cfloop /p cfftp connection = backupFTP username = #request.username# password = #request.password# server = #request.server# action = open stopOnError = No pConnection success: #cfftp.succeeded#/p cfloop query=archiveList p Transferring #archiveList.directory#\#archiveList.name#...br / Exists: #fileexists(#archiveList.directory#\#archiveList.name#)#br / cfflush cfftp connection = backupFTP action = putFile localFile = #archiveList.directory#\#archiveList.name# remoteFile = #archiveList.name# Done: #cfftp.succeeded# /p /cfloop /cfoutput *Page output:* Files to transfer: Data Sources 23_11_07.rar Data Sources 24_11_07.rar Data Sources_old.rar Connection success: YES Transferring C:\Inetpub\Data Sources\backup\Data Sources 23_11_07.rar... Exists: YES Done: NO struct (cfftp dump) ErrorCode -1 ErrorText An error occurred during the FTP putFile operation. ReturnValue NO Succeeded NO I can connect to the FTP server (from the server) no problem. Does anyone have any ideas? The connection is being established ok, the file exists, permissions on the files are fine. Where do I go from here? Thanks -- Giles Roadnight http://giles.roadnight.name ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 and CFmail, sending duplicate emails
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 every 100 emails or whatever. As you mention, you need to balance the number of available threads against how many you would be creating. You'll also need to watch the error handerling/reporting as it's not completely 'fire and forget'. I'm still not convinced that the duplicated emails were caused by the user double clicking though. Me neither, tbh. We'll see. -- Tom Chiverton Helping to globally administrate principle-centered users on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: SQL Data Type
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 number, and read a bunch of bytes: pretty fast. The problem is that database may grow pretty big if large fields are needed, and use much empty space, especially if many of the fields are empty, an empty field taking exactly as much space than a full field. Then came the VARCHAR, AKA memo field. The idea is to store this field in a special area where all fields have a specific length and occupy only the space they need. The database then stores the address of the data in the record, instead of the data itself, but the record still has the same length. The advantage of memo fields is more efficiency in terms of disk space used, but it also implies a two step process to retrieve data, then it is less efficient in terms of speed. It is then up to the programmer to decide what type of efficiency is the best for his application. General rules are: - the larger the field must be, - the more often this field can be empty, then the better it is to use VARCHAR. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFTP - put file problems
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 provide any clues log on to the server hosting CF and run the command line FTP client and try to upload a file using both an active and a passive connection. That will most likely tell you what the problem is. Jochem ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Data Type
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 you don't need to TRIM() everything all the time. -- Tom Chiverton Helping to completely restore best-of-breed markets on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Data Type
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 is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFTP - put file problems
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 () 200 Type set to I. (45) 28/11/2007 13:07:31 - userName () PASV (45) 28/11/2007 13:07:31 - userName () 227 Entering Passive Mode (192,168,0,30,71,171) (45) 28/11/2007 13:07:54 - userName () TYPE I (45) 28/11/2007 13:07:54 - userName () 200 Type set to I. (45) 28/11/2007 13:07:55 - userName () PASV (45) 28/11/2007 13:07:55 - userName () 227 Entering Passive Mode (192,168,0,30,47,141) (45) 28/11/2007 13:08:18 - userName () QUIT (45) 28/11/2007 13:08:18 - userName () 221 Bye bye ... (45) 28/11/2007 13:08:18 - userName () disconnected. (00:00:48) so apparently it doesn't even try to copy the 2 files. if I don't use passive I get the following: (47) 28/11/2007 13:15:22 - userName (IP) logged in. (47) 28/11/2007 13:15:22 - userName (IP) 230 User userName logged in. (47) 28/11/2007 13:15:23 - userName (IP) TYPE I (47) 28/11/2007 13:15:23 - userName (IP) 200 Type set to I. (47) 28/11/2007 13:15:23 - userName (IP) PORT 213,232,95,93,7,95 (47) 28/11/2007 13:15:23 - userName (IP) 200 Port command successful. (47) 28/11/2007 13:15:23 - userName (IP) STOR log 20071127191937.rar (47) 28/11/2007 13:15:23 - userName (IP) asked to upload 'log 20071127191937.rar' in '\\Vault\Server Backup\' -- Access allowed. (47) 28/11/2007 13:15:23 - userName (IP) 150 Opening data connection for log 20071127191937.rar. (47) 28/11/2007 13:15:44 - userName (IP) 226 File received ok. (47) 28/11/2007 13:15:44 - userName (IP) finished uploading 'log 20071127191937.rar' in '\\Vault\Server Backup\' - (13:15:45 - -0.001 KB - 0.000 KBytes/s). (47) 28/11/2007 13:15:54 - userName (IP) TYPE I (47) 28/11/2007 13:15:54 - userName (IP) 200 Type set to I. (47) 28/11/2007 13:15:54 - userName (IP) PORT 213,232,95,93,7,100 (47) 28/11/2007 13:15:54 - userName (IP) 200 Port command successful. (47) 28/11/2007 13:15:55 - userName (IP) STOR log 20071127230005.rar (47) 28/11/2007 13:15:55 - userName (IP) asked to upload 'log 20071127230005.rar' in '\\Vault\Server Backup\' -- Access allowed. (47) 28/11/2007 13:15:55 - userName (IP) 150 Opening data connection for log 20071127230005.rar. (47) 28/11/2007 13:15:55 - userName (IP) QUIT (47) 28/11/2007 13:15:55 - userName (IP) 221 Bye bye ... (47) 28/11/2007 13:15:55 - userName (IP) aborted uploading 'log 20071127230005.rar' in '\\Vault\Server Backup\' - (13:15:56 - -0.001 KB - 0.000 KBytes/s). (47) 28/11/2007 13:15:55 - userName (IP) disconnected. (00:00:33) Here it does try to upload the files but nothing appears in the target directory. Both files are around 3 MB. I have successfully uploaded a sample file from explorer so I know that the FTP server is ok. I also successfully put a file using the command line ftp client. I'm beginning to think that it might be better to try getting the file using CF on the target server rather than putting the file from the source server. Any other suggestions? On Nov 28, 2007 11:30 AM, Jochem van Dieten [EMAIL PROTECTED] wrote: 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 provide any clues log on to the server hosting CF and run the command line FTP client and try to upload a file using both an active and a passive connection. That will most likely tell you what the problem is. Jochem ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updating to Eclipse 3.3...
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 needed in case a plugin doesn't work with the new version, or else disable that plugin until a new version of it becomes available. Finally, import the existing projects and you should be good to go. On Nov 27, 2007 5:05 PM, Rebecca Younes [EMAIL PROTECTED] wrote: To copy existing projects along with local history, copy the folder .metadata\.plugins\org.eclipse.core.resources from your workspace. You can also copy the snippets folder. The default location is .metadata\.plugins\org.cfeclipse.cfml\snippets, or you can check CFEclipse preferences if they're in another location. The good news is you should be able to go to File Import Existing Projects into Workspace and it should import your project into your new build (although things like the local history won't be imported.) ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDocument: 3x2 document but only uses 3/4 of it
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 solved, and if so, would you please let me know how you get around this? Thanks a lot. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Conceptual Search against Database(s)
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 the most important data sets of a web app to provide more value for data search... Greetings to all, I know Verity and Google search etc. etc. Try the following if you're interested in the topic, but before you begin let me issue some warnings: a) I'm not implementing some of the stuff that a beginner programmer would have implemented such as telling peole, oh query does not find such and such... just provide the core function... b) Please do no ask me for source code nor alg... c) Now let's get to the 'meat' part :) You may try the following 'concepts' respectively luck computer environmental protection Hollywood star --- another perspective, get a feel of what's on people's mind back then... try, future energy -- our interest in other nation Japan (hint, you may try any of the following respectively as well japanese archipelago japanese islands nihon nippon ) -- my own opinion, the 'thing' is good enough but not perfect. e.g. concept of 'energy' would get department of energy, good, but meantime, it would get 'zip' as well, wtf? NOW, here you go (the server is an old box, bear with me...) http://24.254.6.28:8000/myta/search.cfm P.S. I think there's a recent thread on Verity, customerizable parameter weighting something,yes, that would be doable with my approach... ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Open Source Ticket Software
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 sharepoint can't be configured to do what we need it to do (submit trouble tickets via email submission). Thanks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Open Source Ticket Software
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 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 sharepoint can't be configured to do what we need it to do (submit trouble tickets via email submission). Thanks ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source Ticket Software
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 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 sharepoint can't be configured to do what we need it to do (submit trouble tickets via email submission). Thanks ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFTP - put file problems
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 seconds. I've tried adjust the timeouts in the CFFTP tag, adding a request timeout etc. Here it does try to upload the files but nothing appears in the target directory. Both files are around 3 MB. I have successfully uploaded a sample file from explorer so I know that the FTP server is ok. I also successfully put a file using the command line ftp client. I'm beginning to think that it might be better to try getting the file using CF on the target server rather than putting the file from the source server. Steve Logan No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.9/1155 - Release Date: 11/27/2007 8:30 PM ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFInvoke not finding method
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 name=Request value=#ThisXML# /cfinvoke CFC code: cfcomponent cffunction name=requestMethod access=publicreturntype=struct output=false cfargument name=Request type=XML required=true cfset ReturnThis = StructNew() cfreturn ReturnThis /cffunction /cfcomponent Error Text: The method 'requestMethod' could not be found in component C:\inetpub\wwwroot\mysite.com\parser.cfc. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFInvoke not finding method
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 easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Getting the data time from an unfamiliar returned value
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 object. Other than that, may have to parse it more. My 2 cents. Maybe someone else has already done this or something easier From: Che Vilnonis [EMAIL PROTECTED] Sent: Wednesday, November 28, 2007 11:38 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Getting the data time from an unfamiliar returned value 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 ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFInvoke not finding method
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 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 name=Request value=#ThisXML# /cfinvoke CFC code: cfcomponent cffunction name=requestMethod access=publicreturntype=struct output=false cfargument name=Request type=XML required=true cfset ReturnThis = StructNew() cfreturn ReturnThis /cffunction . /cfcomponent Error Text: The method 'requestMethod' could not be found in component C:\inetpub\wwwroot\mysite.com\parser.cfc. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Getting the data time from an unfamiliar returned value
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 in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 Java Problem, Works on CF7
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 types, but not getID] Parent Class Class Name: AbstractDecorator Methods: [list of methods and return types, including *getID*] Is there something different I need/can do w/CF8 to get to the method getID on the Parent Class? --- Skeleton Class Definitions --- public final class Outer { Inner inner; public Inner getInner() { return inner; } public final class Inner extends AbstractDecorator { } } abstract class AbstractDecorator extends Wrapped { private Wrapped _wrapped; public int getID() { return _wrapped.getID(); } } class Wrapped { int ID; public int getID() { return ID; } } ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
sql and order by ?
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 you sort by the serial and asc 1950101 would come before 19509 which it shouldnt but mathematically is correct. Having the client add 0's to serial numbers isnt an option, there aren't very many like 20 but I would like them to be in order, is there anything in sql that can do this? btw~ using mysql the relevant sql order by serial asc this is what some of the current list looks like. 193932 19399 1948148 194874 194878 194886 1949157 1949160 ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql and order by ?
-- 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 your current state select *, Cast(sYear as char(4)) +''+ Cast(sNum as char(3)) as serialNum from #tmp order by serialNum -- try this select *, Cast(sYear as char(4)) +''+ Cast(sNum as char(3)) as serialNum from #tmp order by sYear, sNum 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 you sort by the serial and asc 1950101 would come before 19509 which it shouldnt but mathematically is correct. Having the client add 0's to serial numbers isnt an option, there aren't very many like 20 but I would like them to be in order, is there anything in sql that can do this? btw~ using mysql the relevant sql order by serial asc this is what some of the current list looks like. 193932 19399 1948148 194874 194878 194886 1949157 1949160 ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql and order by ?
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 Sabai-dee.com http://www.sabai-dee.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql and order by ?
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 ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql and order by ?
@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 latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql and order by ?
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. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql and order by ?
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. ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
detecting pdas and redirecting them
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 the only one that wants to do this? So far I have these two sites: http://www.andymoore.info/php-to-detect-mobile-phones/ http://www.webmasterworld.com/forum21/9507.htm I hope I don't have to have a huge if-else (or switch-case) thx ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: CF8 Java Problem, Works on CF7
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 which includes the details of the Wrapped class, are you seeing this as well? ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql and order by ?
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. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: Re: sql and order by ?
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, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql and order by ?
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] wrote: @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 ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDocument: 3x2 document but only uses 3/4 of it
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 http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Getting the data time from an unfamiliar returned value
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 delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql and order by ?
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 sYear, sNum? Been a while since I've worked in mysql, but several of the suggestions here look like they should be working. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLayout and Spry
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 implemented such a scenario that could offer any pointers? Thanks Steve --- --- ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLayout and Spry
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 with cfhtmlhead. 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 implemented such a scenario that could offer any pointers? Thanks Steve --- --- ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Open Source Ticket Software
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 around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open Source Ticket Software
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 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conceptual Search against Database(s)
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. James, Yes, it would cost money but not expensive... It has nothing to do with Verity nor Google. What's your email address? We could discuss more offline. Don dl, I was the one who posted about Verity. Sadly, I didnt understand your email or find any more information on your website. ... What exactly is your approach? How would I implement it on my site? Is it proprietary? Does it build on verity? Does it cost money? Greetings to all, P.S. I think there's a recent thread on Verity, customerizable parameter weighting something,yes, that would be doable with my approach... ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Conceptual Search against Database(s)
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 everyone else that they have to be bothered with non-public business. James. James, Yes, it would cost money but not expensive... It has nothing to do with Verity nor Google. What's your email address? We could discuss more offline. Don dl, I was the one who posted about Verity. Sadly, I didnt understand your email or find any more information on your website. ... What exactly is your approach? How would I implement it on my site? Is it proprietary? Does it build on verity? Does it cost money? Greetings to all, P.S. I think there's a recent thread on Verity, customerizable parameter weighting something,yes, that would be doable with my approach... ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4