RE: CF Extensions for eclipse
Thanks Ray, I think my Eclipse install is hosed up. I was playing with the all in one install of Eclipse http://www.eclipse.org/downloads/download.php?file=/webtools/downloads/drops/R2.0/R-2.0-200706260303/wtp-all-in-one-sdk-R-2.0-200706260303-win32.zip (trying to get CSS to autocomplete) and selected the same workspace as my other install and since then things have been acting strange. I never have gotten eclipse to autocomplete CSS. I have to load Aptana to get CSS to autocomplete. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, August 20, 2007 12:34 PM To: CF-Talk Subject: Re: CF Extensions for eclipse I spoke to Dean about this. This is his response: We don't have any dependencies on that plugin, that's an error from eclipse that has nothing to do with our stuff. End Dean's response. So you may want to maybe double check that you don't have something else wrong. Perhaps uninstall/reinstall the plugin. On 8/20/07, Chad Gray [EMAIL PROTECTED] wrote: I am trying to install the new CF Extensions that Dean posted http://www.cfreport.org/index.cfm/2007/8/17/Eclipse-33-and-the-ColdFusion-Extensions-for-Eclipse and I get this error: Eclipse XML Editors and Tools (2.0.0.v200706182145-7A1ECBCnbckz0bZu9wHqAKN3mYpZ) requires plug-in org.eclipse.emf.common (2.2.0), or compatible. Is this only good with 3.3? I have 3.2.2. ~| 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:286612 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
list of new stuff in CF8
Anyone know where I can find a list of new Tags and Functions in CF8? I keep finding tags/fucntions that I had no idea existed. Chad ~| 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:286242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: list of new stuff in CF8
Thanks Ray! Are there any tags/functions that are only available in Enterprise? p.s. It took me 5 seconds to post the original message, Crow 3 seconds to search google and 3 seconds to post the result to CF-Talk, then you took 5 seconds to post your answer and another 20 seconds to find the flaw in the Crow's answer and now another 5 seconds for me to post this follow up question. We are not going to get anything done today at this rate. ;) -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 15, 2007 9:19 AM To: CF-Talk Subject: Re: list of new stuff in CF8 Go to the PDFs - in the Reference, under tags and functions, you will find a list of changes since CF5. I bet you will find stuff added to CF7 you didn't know about either! :) On 8/15/07, Chad Gray [EMAIL PROTECTED] wrote: Anyone know where I can find a list of new Tags and Functions in CF8? I keep finding tags/fucntions that I had no idea existed. Chad ~| 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:286249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 and XMP
I saw a recent post about images and IPTC and EXIF and CF8 able to access the embedded data. What about XMP? Maybe I am mistaken but im pretty sure XMP data can be stored in images. Can CF8 access XMP data on a file? Thanks! ~| 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:286190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL front end...
heidiSQL formerly MySQL Front. http://www.heidisql.com/ -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 9:17 AM To: CF-Talk Subject: MySQL front end... Besides Aqua Data Studio, what else is out there that is free and runs on Windows. Thanks, Che ~| 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:285876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse/CFEclispe
It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303/ It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton 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 Law Society. 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 8008. 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:285696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Eclipse/CFEclispe
I tried aptana, but then I lost the ability to autocomplete CF tags... it was like I had to choose one or the other. CSS or CF.. I could not get autocomplete to work for each language at the same time. Is there anyway for me to upgrade my eclipse so I get this WTP all in one package features??? Or do I have to re-install and loose all my custom keys and plugins? -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:44 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe Look at Aptana. Best CSS and JS plugin around far as I am concerned. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re: Eclipse/CFEclispe On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303 / It has a few extra bits like CSS and HTML editing and CFEclipse will drop right in. -- Tom Chiverton 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 Law Society. 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 8008. For more information about Halliwells LLP visit www.halliwells.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:285699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF / Alagad / Photography Questions
ImageCR works great. We use it for our photography studio's proofing web sites that I built. It can handle the large images you are talking about and caches the resized image so it does not have to be processed every time the page is requested. It also has a sharpen setting if you find that the images are bit soft. Any time you take large images and reduce them you are tossing out a lot of pixels and you will need to add some sharpening to them. This is true with any image resizing program. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 5:21 PM To: CF-Talk Subject: RE: CF / Alagad / Photography Questions What kind of resolution (crisp look) can you obtain using ImageCR3 for a 19MEG file? If it can keep a sharp look for the resizing of the image, then it will be great! I am downloading/installing and testing it now as well. -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 4:55 PM To: CF-Talk Subject: RE: CF / Alagad / Photography Questions 2. If you convert the photo for the client do you use Alagad, another web graphics tag, or do you use Adobe Fireworks/Photoshop and convert I have used CFX_ImageCR from Efflare (version 3) in the past with excellent results. See www.efflare.com. -Justin Scott ~| 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:285565 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF / Alagad / Photography Questions
Another option is not to upload such large files. Prep them first with a photoshop action. Have the customer take the images from the CD and run them through a photoshop action to resize them to the max size used on the web site. You will have to apply some sharpening in photoshop also so plan to use the un-sharp mask filter in the photoshop action. Then upload the images to your app. You will have to explain to your client what is going on... no software can take large images and reduce them without some tweaks (sharpening) to make them look good. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 9:46 AM To: CF-Talk Subject: RE: CF / Alagad / Photography Questions Thanks for the comments. I will see if Alagad has a sharpening option. If not, I may have to change to ImageCR. Just have to see if the hosting provider will install it. If not, may have to change to a new provider. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 9:42 AM To: CF-Talk Subject: RE: CF / Alagad / Photography Questions ImageCR works great. We use it for our photography studio's proofing web sites that I built. It can handle the large images you are talking about and caches the resized image so it does not have to be processed every time the page is requested. It also has a sharpen setting if you find that the images are bit soft. Any time you take large images and reduce them you are tossing out a lot of pixels and you will need to add some sharpening to them. This is true with any image resizing program. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 5:21 PM To: CF-Talk Subject: RE: CF / Alagad / Photography Questions What kind of resolution (crisp look) can you obtain using ImageCR3 for a 19MEG file? If it can keep a sharp look for the resizing of the image, then it will be great! I am downloading/installing and testing it now as well. -Original Message- From: Justin Scott [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 4:55 PM To: CF-Talk Subject: RE: CF / Alagad / Photography Questions 2. If you convert the photo for the client do you use Alagad, another web graphics tag, or do you use Adobe Fireworks/Photoshop and convert I have used CFX_ImageCR from Efflare (version 3) in the past with excellent results. See www.efflare.com. -Justin Scott ~| 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:285567 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 issues.
I have had problems in the past where cfdocument would not pull in an image.
I figured out that because the directory had NTFS permissions on it that the
IUSR (anonymous) user was not allowed to load the image cfdocument could not
load the image.
Maybe you are running into the same thing that the CSS cannot be loaded because
of user permissions where the CSS file is
I solved it by placing the image out in a public folder, then cfdocument could
load the image into the PDF.
-Original Message-
From: Troy Montour [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 12:15 PM
To: CF-Talk
Subject: cfdocument issues.
I'm having an issue with cfdocument not loading my style sheets.
here is my cfm page took the tag bracket off so it would show.
I've tried linking to the style sheet but that didn't work either.
If I change the class= to inline styles it works fine but this would be a pain
since we have a few reports that I was trying to make sure the layout would be
the same.
cfoutput
cfdocument
format=pdf
filename='c:\inetpub\wwwroot\dds\Troys\test.pdf'
pagetype = letter
overwrite=yes
style type=text/css
@import url(./dds/css/metrics2.css);
/style
table class=ReportTable2
tr
td class=ReportHeaderCell2 Test /td
/tr
/table
/cfdocument
/cfoutput
here is the css file
td.ReportHeaderCell2 {
border-bottom:1px solid #00;
border-right:1px solid #00;
background-color:#FF;
font-family:Verdana;
font-size:11px;
color:#FF;
text-align:center;
vertical-align:middle;
font-weight:bold;
padding:2px 2px 2px 2px;
}
table.ReportTable2 {
border:1px solid #00;
margin:0 5px 10px 5px;
}
if I load this with out the cfdocument tag it load fine with red background and
a black border. but as soon as I create the pdf the formating disappears.
we are using CF7
any help on this would be great.. Thank you in advance.
Thank You
Troy Montour
~|
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:285596
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFILE Makes No Sense - the file is there
The file name cannot have a space on the front of the file name in a windows environment. Of course you can on Mac so if you are using Mac file services on your PC server and a Mac made the file on the windows machine this would be possible, but windows file system will not like it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 10:08 AM To: CF-Talk Subject: CFFILE Makes No Sense - the file is there WHy is CFFILE doing this? I'm getting an error that says it can't find the file and I've checked several times, the file is there, on the server in the correct folder with the exact file name!!! The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request An exception occurred when performing a file operation COPY on files D:\Inetpub\wwwroot\baby\ 38035273713000.jpg and D:\Inetpub\wwwroot\baby\images\babycontest\2007\picture_people\Tina_Nicorette_CHARLOTTE_0806_ 38035273713000_pp.jpg. The cause of this exception was: java.io.FileNotFoundException: D:\Inetpub\wwwroot\Yobaby\ 38035273713000.jpg (The system cannot find the file specified). ~| 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:285484 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_injection_hack?
I also like to use val() on any integer like your ProdID appears to be an integer. This way val() will take text and convert it to 0. But yes use your CFQueryParams! This is the best line of defense. -Original Message- From: Rick King [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 11:56 AM To: CF-Talk Subject: SQL injection hack? Hey all, I just received this email that is generated when there is an error on a site I built (www.woreitonce.com) ---E-MAIL Invalid data 1 and 1=convert(int,(select top 1 char(97)+admin_password from tbl_adminusers)) for CFSQLTYPE CF_SQL_INTEGER. brThe error occurred on line 30. Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6 81.10.46.130 /Details.cfm ProdID=1%20and%201=convert(int,(select%20top%201%20char(97)%2badmin_password%20from%20tbl_adminusers)) -E-MAIL Is this a SQL injection attack? Anything I can do? Thanks Rick ~| 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:285492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:_homesite_for_CF8?
Ray blogged a link to the downloads. http://www.coldfusionjedi.com/index.cfm/2007/7/30/ColdFusion-8-Eclipse-Extensions-now-available-separately http://www.adobe.com/support/coldfusion/downloads.html -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Friday, August 03, 2007 11:16 AM To: CF-Talk Subject: homesite for CF8? Anyone have any idea what Adobe plans regarding Homesite? Will something be created for CF8? Anyone have Dreamweaver CS3 and know if it's on there? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| 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:285339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with Google Adwords API SOAP Request
I have a feeling you did not get a response because the email side of CFTalk seems to be really hit and miss for the last week. I had to go to the web site to see any of your thread on this subject. CF has great documentation on web service usage. http://livedocs.adobe.com/coldfusion/7/ Look in the ColdFusion MX Developer's Guide section under Using Web Services. -Original Message- From: Al Zan [mailto:[EMAIL PROTECTED] Sent: Friday, August 03, 2007 10:35 AM To: CF-Talk Subject: Re: Help with Google Adwords API SOAP Request Really!!! Is it possible nobody is working with Google Adwords API in CF? That amazes me. I guess it's time to learn PHP... It's sad, after 9 years with CF. ~| 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:285336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFCs question
Is there a best practice when creating an object? Do you store your objects in the session or application scope so you can use it through out the application? Or do you create your objects only when you need to? I suppose it is a case by case decision. Is there an application out there that uses CFCs really well and I should look at how that application is written? ~| 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:285046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF error
I am cleaning up my CFC code adding cfset var foo = and hit this error What does it mean? Local variable i on line 33 must be grouped at the top of the function body. ~| 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:285054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery error, help please.
With query of query you don't have database functions like LEFT() because you are not running your query on a database engine like MS SQL or MySQL. Do a CF left() function when you output your data. -Original Message- From: Dae [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 1:17 PM To: CF-Talk Subject: cfquery error, help please. What's wrong with my SQL statement? cfquery dbtype=query name=calander SELECT LEFT(filename,3) as mnth, filename FROM dir_data where filename like '%calendar%' /cfquery This the LEFT is causing an error. Anyone know what might be the fix or problem? The error itself is: *Query Of Queries syntax error.* Encountered LEFT. Incorrect Select List, Incorrect select column, BTW, what I'm doing is trying to grab the latest file based on the month in the file name. The naming convention for the files are Jan07Calander.doc I can't just take the max because when a file like Aug07Calander.doc is placed in the directory, it won't pick it up. Thanks.. ~| 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:285081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
application.cfc and var
Ok now that I have learned about declaring variables in CFCs so you don't run into race conditions and problems. How about application.cfc? Do I need to use cfset var foo = in application.cfc? ~| 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:285096 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 Help
You might want to look at using iText. Here is a CFC that shows some code that uses iText to place images. http://www.reactivevision.com/coldPDF.txt I have not experimented very much with CFDocument and exact placement of items, but the results I have seen are very inconsistent. I think mainly because you are taking HTML and CFdocument it converting it to PDF. So there is some fudge factor. Have you tried using CSS instead of HTML? With CSS you might get better results because you can position thinks absolute. div style=position: absolute; top: 96px; left: 20px; border: 2px solid #00; /div I have also used PDFToolKit from Active pdf in a .Net application to create PDFs. I suppose with CF8 I will be able to use this .net dll... could be interesting. http://www.activepdf.com/ -Original Message- From: Arthur.Frey [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 31, 2007 1:43 PM To: CF-Talk Subject: CFDocument Help I am trying to create a 2 page document with a custom page size (17x11 inches). The basics of the document are a table that should fill 100% of the document in two columns. Example: Create a new cf page and paste the following code: cfdocument name=MyPDF filename=MyPDF.pdf format=PDF pagetype=custom pageheight=11 pagewidth=17 margintop=0 marginbottom=0 marginright=0 marginleft=0 orientation=portrait unit=in backgroundvisible=yes overwrite=yes fontembed=no cfdocumentsection margintop=0 marginbottom=0 marginright=0 marginleft=0 table width=1650 border=0 cellpadding=0 cellspacing=0 bgcolor=#00 tr td width=825 height=1050 style=color:#FFpage 1, column 1/td td width=825 height=1050 style=color:#FFpage 1, column 2/td /tr /table /cfdocumentsection cfdocumentsection margintop=0 marginbottom=0 marginright=0 marginleft=0 table width=1650 border=0 cellpadding=0 cellspacing=0 bgcolor=#00 tr td width=825 height=1050 style=color:#FFpage 2, column 1/td td width=825 height=1050 style=color:#FFpage 2, column 2/td /tr /table /cfdocumentsection /cfdocument a href=MyPDF.pdf target=_blankMyPDF.pdf/a When you click on the link you will see a pdf generated that is 2 pages long. I need one page. I am going to be filling these two columns with images and text generated from a database, but this basic framework is the key. I have no idea how to build this so it fills in 100% of the page and not overflow onto an extra page. Any help would be greatly appreciated. Even if you can help me learn the height and width of the anticipated PDF at 17x11inches I would be thrilled. I would be happy to send you the origional pdf is that would help anything. ~| 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:284967 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 Help
I started playing more with cfdocument. The below code fit a div with a 1px border exactly onto a 8.5x11 document. You move it 1px in any direction and it gets funky... there is definitely some translation when going from HTML to PDF when using CFDocument. cfdocument format=pdf pagetype=letter margintop=0 marginbottom=0 marginleft=0 marginright=0 div style=border: 1px solid #00; width: 613px; height: 795.5px; position: absolute; /div /cfdocument -Original Message- From: Arthur.Frey [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 31, 2007 1:43 PM To: CF-Talk Subject: CFDocument Help I am trying to create a 2 page document with a custom page size (17x11 inches). The basics of the document are a table that should fill 100% of the document in two columns. Example: Create a new cf page and paste the following code: cfdocument name=MyPDF filename=MyPDF.pdf format=PDF pagetype=custom pageheight=11 pagewidth=17 margintop=0 marginbottom=0 marginright=0 marginleft=0 orientation=portrait unit=in backgroundvisible=yes overwrite=yes fontembed=no cfdocumentsection margintop=0 marginbottom=0 marginright=0 marginleft=0 table width=1650 border=0 cellpadding=0 cellspacing=0 bgcolor=#00 tr td width=825 height=1050 style=color:#FFpage 1, column 1/td td width=825 height=1050 style=color:#FFpage 1, column 2/td /tr /table /cfdocumentsection cfdocumentsection margintop=0 marginbottom=0 marginright=0 marginleft=0 table width=1650 border=0 cellpadding=0 cellspacing=0 bgcolor=#00 tr td width=825 height=1050 style=color:#FFpage 2, column 1/td td width=825 height=1050 style=color:#FFpage 2, column 2/td /tr /table /cfdocumentsection /cfdocument a href=MyPDF.pdf target=_blankMyPDF.pdf/a When you click on the link you will see a pdf generated that is 2 pages long. I need one page. I am going to be filling these two columns with images and text generated from a database, but this basic framework is the key. I have no idea how to build this so it fills in 100% of the page and not overflow onto an extra page. Any help would be greatly appreciated. Even if you can help me learn the height and width of the anticipated PDF at 17x11inches I would be thrilled. I would be happy to send you the origional pdf is that would help anything. ~| 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:284969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC defining vars
I have noticed in a lot of people's code for CFCs they set all of the variables being used in the CFC like this: cfset var foo = Why? Is this just good programming practice? Also what scope are these variables in? variables.foo? ~| 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:284797 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dreamweaver CF8 help
I installed the CF8 Dreamweaver updater and the help files are not local they go to livedocs... and the URL doesn't even work. http://www.adobe.com/go/livedocs_cf8docs What good are help files if I have to be online to get to them? Adobe really seems to be pushing Eclipse... are they trying to kill Dreamweaver? I would use Eclipse if I could find a way to auto complete CSS while coding in CF with auto complete. Dreamweaver I get auto complete for CSS and CF. ~| 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:284828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 and CFZip
Hey Ben Forta, I want my money back. CFZip is built into CF8 and I purchased it many o' years ago from you! Just joking of course! :) I have gotten my money's worth out of it that is for sure. I just thought it was funny to see the tag in CF8. ~| 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:284825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC defining vars
REALLY?
Oh boy, I have some code to fix. :)
Glad I just started using CFCs... not much code to fix.
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 11:00 AM
To: CF-Talk
Subject: RE: CFC defining vars
That makes the variable exist only for the duration of that method call.
For instance, you have a CFC which is persisted in the application
scope.
cfset application.my_cfc = CreateObject('component','CFC.foo')
It has a method called helloWorld() which queries their name out of the
database a returns it.
cfquery name=qry_your_name
Select etc.
/cfquery
cfreturn qry_your_name.full_name
Now, let's say two different people in the same app call that method at
the same time. Right now, qry_your_name will exist in variables, which
is global to the entire CFC.
Here we just created a race condition. User one's query runs, and then
user two's query overwrites. Then the cfreturn hands back the same data
to both users.
The solution:
cfset var qry_your_name =
cfquery name=qry_your_name
Select etc.
/cfquery
cfreturn qry_your_name.full_name
Now EACH call to that method has its own qry_your_name variable which
can not be overwritten by concurrent usage of the CFC
Print this out and place it on your cube wall. I did. :)
http://www.coldfusionjedi.com/downloads/cfcscopes.pdf
~Brad
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, July 30, 2007 8:46 AM
To: CF-Talk
Subject: CFC defining vars
I have noticed in a lot of people's code for CFCs they set all of the
variables being used in the CFC like this:
cfset var foo =
Why? Is this just good programming practice?
Also what scope are these variables in? variables.foo?
~|
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:284833
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC defining vars
Thanks for all of the info on this subject. I have fixed most of my existing code. One question I have is what happens if I don't declare a name= attribute for a cfquery? IE: cfquery datasource=#application.dsn# Lots of sql here /cfquery I tend to do this on updates or inserts of a database records when I don't care what the query returns. Is this bad? Should I always use a name so I can create a Var scope and define it? Chad ~| 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:284847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF page calling a Webservice that returns a complex structure
You say that the web service returns XML, why don't you work the XML with CF's XML functions? Do a CFDump on what they send and see what it is. If it is XML you will probably need to run XMLParse() on it to turn it into a CF XML object. Then run CFDump on it. The CF documentation has some great examples of how to work with XML. http://livedocs.adobe.com/coldfusion/7/htmldocs/1505.htm#1158596 -Original Message- From: Archie Campbell [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 11:07 AM To: CF-Talk Subject: Re: CF page calling a Webservice that returns a complex structure Maybe I am posting on the wrong forum. Is that a better one to use? Thanks Archie Archie Campbell wrote: I am finding this task uncharacteristically difficult to do with Cold Fusion. I suspect there is an easier way, I just cant think of it. Here is the situation. There is an external Webservice that returns XML containing information on all unpaid invoices for a customer. The XML document contains 1 or many invoices each having 1 or many invoice detail lines. The CF program I am writing is supposed to: . call the webservice . get the XML info and either: A. save it in an XML text file for further processing by Excel or Access or another CF program or ... B. convert it to a struct, process it a bit, like total fields, rename fields producing a new struct which is then saved to an XML text file The external (non CF) webservice returns a complex structure like: InvoiceCollection . countOfInvoices . totalAmount . Invoices: (repeating multiple times) . invoiceNumber . invoiceDate . invoiceAmount . countOfInvoiceLines . InvoiceLines (repeating multiple times) . lineNumber . description . amount I have successfully accepted the webservice return object and produced a CF struct from it. It was a bit tedious, but I have it done. After I had the struct I thought I could use the data conversion routine StructToXml from cflib.org to produce a string that I would write to a file with cffile. It was missing the arrayOfStructs. Not much there. Then I read the fine print on StructToXml and noted that it says it converts simple structs. A struct whose elements include an array of stucts is not included in the definition of simple. Darn I said. Basically, right now, I have my struct and I am stuck. What I originally thought to be a simple task for Cold Fusion (CF nicely takes many otherwise complex tasks and makes them simple) has got me stuck. Any thoughts would be appreciated. Thanks Archie Campbell ~| 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:284713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 and iText
Anyone know if iText is still being used in CF8 for PDF manipulation? ~| 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:284628 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Connection Flex to CF Error
If you go to the endpoint do you get a blank page? You should.
IE when I go here: http://demo.dev/flex2gateway/
The last time I played with Flex I put the endpoint in the RemoteObject. There
are probably a lot of ways to set it up though.
mx:RemoteObject
id=roServalent
destination=ColdFusion
source=local.careycolor.servalent.login
endpoint=http://demo.dev/flex2gateway/;
result=letUserIn()
mx:method name=authUser
mx:arguments
login{login.text}/login
pwd{pwd.text}/pwd
/mx:arguments
/mx:method
/mx:RemoteObject
-Original Message-
From: Bill Betournay [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 25, 2007 12:14 PM
To: CF-Talk
Subject: RE: Connection Flex to CF Error
Hi Tom
Yes, it's running. An app I've been working on was running fine until this
morning when I started getting this error. Here's the code for a simple CF
call.
mx:RemoteObject id=testcfService destination=ColdFusion
source=CW_BuyVouchers.buyonline.flexStore.CFCs.SecureService
mx:method name=loginSuccess result=testResultHandler(event)/
/mx:RemoteObject
[Bindable]
private var thisTest:String = ;
private function testResultHandler(event:ResultEvent):void
{
thisTest = testcfService.loginSuccess.lastResult;
}
mx:Button id=test click=testcfService.loginSuccess()/
mx:Label text={thisTest}/
And the function in the CFC is
cffunction name=loginSuccess access=remote returntype=string
!--- cfset returnValue = mx:Label width=100% text=Welcome
Back #Client.firstName# ! styleName=sectionHeader/ / ---
cfreturn Welcome Back!!---#Client.firstName# ---
/cffunction
Yes, the path to the CFC is correct.
Bill
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: 25 July 2007 06:52
To: CF-Talk
Subject: Re: Connection Flex to CF Error
On Wednesday 25 Jul 2007, [EMAIL PROTECTED] wrote:
Can anyone tell me what this error usually means?? Obviously it can't
connect to CF but I don't understand why.
Is CF running ? What is your endpoint URL ?
--
Tom Chiverton
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 Law Society.
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 8008.
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:284537
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 and pdfs
Anyone know if you can place an image in a PDF in CF8? Thanks, Chad ~| 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:284569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML Insert Problem
I think I typed this out right... might be some typos. Basically use XmlElemNew to create the new node then assign it's XmlAttributes and XmlText to what you want. cfset xml = XMLParse(#XMLgoesHere#) cfset xml.BackgroundCheck.BackgroundSearchPackage.Screenings.ClientReferences.XmlChildren[2] = XmlElemNew(xml, IdValue) cfset xml.BackgroundCheck.BackgroundSearchPackage.Screenings.ClientReferences.IdValue[2].XmlAttributes.name = ClientReferenceField2_Value cfset xml.BackgroundCheck.BackgroundSearchPackage.Screenings.ClientReferences.IdValue[2].XmlText = crf2 -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 25, 2007 10:24 AM To: CF-Talk Subject: XML Insert Problem We are having trouble inserting a line into XML when using straight string manipulation it blows up on XML Search. We are guessing that there is a better way to insert the line. Details below. The existing XML structure shows (partial XML is noted in the examples below and does not represent the entire xml document): ClientReferences IdValue name=ClientReferenceField2_Valuecrf2/IdValue /ClientReferences We wish to add another IdValue node before the ClientReferenceField2_Value attribute as follows: IdValue name=ClientReferenceField1_Valuecrf1/IdValue The resulting XML structure would show: ClientReferences IdValue name=ClientReferenceField1_Valuecrf1/IdValue IdValue name=ClientReferenceField2_Valuecrf2/IdValue /ClientReferences The full Xpath to ClientReferences is as follows: /BackgroundCheck/BackgroundSearchPackage/Screenings/ClientReferences Notes: - Assume the existing XML document is in a ColdFusion structure through the use of XmlParse() - The resulting XML should be maintained as a ColdFusion structure that will allow Xpath searches using XMLSearch() ~| 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:284561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfcontent
I want cfcontent to take xml data from a query and force the user to download it as an XML file. Any tips? I keep getting a CF Error if I put the xml in the variable attribute of cfcontent. java.lang.String is not a supported variable type. The variable is expected to contain binary data. ~| 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:284464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfcontent
Thanks Ian and Ben, I got is working now. Next question. Firefox does not like the fact that the file name has spaces in it. With the below code the file that is saved is test With IE it replaces the space with an underscore. test_1234.xml cfheader name=Content-Disposition value=attachment; filename=test 1234.xml cfcontent type=application/xml cfoutput#getZJF.ZJF#/cfoutput /cfcontent How do I get firefox and IE to write out the correct file name? Thanks again! Chad -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 5:12 PM To: CF-Talk Subject: Re: cfcontent You don't put it in the variable paramter, but rather between the tags. cfcontent#myXMLString/cfcontent You will probably want to provide the proper content headers with cfheader... tags before this. ~| 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:284470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfcontent
Hah! Brilliant! Thanks Ben! -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 5:29 PM To: CF-Talk Subject: RE: cfcontent No worries: cfheader name=Content-Disposition value=attachment; filename=test 1234.xml Wrap file name in double quotes (NO single quotes)... Just remember to escape them . ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 5:26 PM To: CF-Talk Subject: RE: cfcontent Thanks Ian and Ben, I got is working now. Next question. Firefox does not like the fact that the file name has spaces in it. With the below code the file that is saved is test With IE it replaces the space with an underscore. test_1234.xml cfheader name=Content-Disposition value=attachment; filename=test 1234.xml cfcontent type=application/xml cfoutput#getZJF.ZJF#/cfoutput /cfcontent How do I get firefox and IE to write out the correct file name? Thanks again! Chad ~| 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:284472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfcontent
Ya I tried that, but you get the literal %20 in the name... Ben's surrounding with double quotes fixed firefox to have the proper name, but IE still replaces the blanks with underscores. That is not too bad I would like IE to get the name absolutely right. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 5:40 PM To: CF-Talk Subject: Re: cfcontent Use the URL encoding for a space [%20] perhaps? cfheader name=Content-Disposition value=attachment; filename=test%201234.xml But spaces in file names should usually be avoided when possible in web applications. ~| ColdFusion 8 beta - 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:284476 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CDDocument Image problem
I am trying to use CFDocument to make a PDF of a web page. I have an image that produces what kinds of looks like a missing image icon in the PDF. When I click on thing in Acrobat it says There was an error processing an annotation or link. There was a problem reading this document (14). http://chadgray.info/Untitled-1.jpg Now this code works fine on our development server. Only on the production server do I get the problem. My code to place the image is simple enough. The page and image are in the same folder. The PDF is saved into a sub-folder. td width=352 height=59 valign=top align=center img src=invoicelogoNEW.jpg border=0 /td My code to make the pdf and save it is: cfdocument format=pdf pagetype=letter name=invoice overwrite=yes cffile action=write file=#application.invoicePDFPath##fileName# output=#invoice# H now that I think more about this. The area that this code is running from does have NTFS permissions on it so users have to login to use the web site. Does CFDocument need permissions to grab the image and use it in the PDF ~| 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:284354 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CDDocument Image problem
Ya, I put the images in a public folder and chaged my image path to: img src=http://websitename/images/invoicelogoNEW.jpg border=0 Now the image shows up in the PDF. So what permissions does CFDocument need on images to place them into the PDF??? Right now SYSTEM has full permissions, and IIS_WPG has Read/Execute and list folders. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 9:27 AM To: CF-Talk Subject: CDDocument Image problem I am trying to use CFDocument to make a PDF of a web page. I have an image that produces what kinds of looks like a missing image icon in the PDF. When I click on thing in Acrobat it says There was an error processing an annotation or link. There was a problem reading this document (14). http://chadgray.info/Untitled-1.jpg Now this code works fine on our development server. Only on the production server do I get the problem. My code to place the image is simple enough. The page and image are in the same folder. The PDF is saved into a sub-folder. td width=352 height=59 valign=top align=center img src=invoicelogoNEW.jpg border=0 /td My code to make the pdf and save it is: cfdocument format=pdf pagetype=letter name=invoice overwrite=yes cffile action=write file=#application.invoicePDFPath##fileName# output=#invoice# H now that I think more about this. The area that this code is running from does have NTFS permissions on it so users have to login to use the web site. Does CFDocument need permissions to grab the image and use it in the PDF ~| 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:284355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MySQL Client
I like HeidiSQL formerly known as MySQL-Front. http://www.heidisql.com/ -Original Message- From: OÄuz_Demirkapı [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 12:29 PM To: CF-Talk Subject: MySQL Client Hi all, I am using Navicat (navicat.com) as MySQL client now but I would like to hear what you have. Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. Thanks in advance for your suggestions. Sincerely, OÄuz Demirkapı Sr. Developer | TeraTech http://www.teratech.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:284380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfc question
I have a CRUD CFC that has this function and I load the CFC into the application scope: cffunction name=readZJF access=public returntype=query cfargument name=criteria type=string required=yes cfquery datasource=dsn name=readZJF SELECT * FROM FlexoDirectConfigFiles WHERE #arguments.criteria# /cfquery cfreturn readZJF /cffunction I want to be able to pass in the WHERE statement into it. So it could be: FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01 PM' So I run something like this to call the function: cfset DoesFileAlreadyExist = application.ZJF.readZJF(FileName = '#getZJF_files.name#' AND FileModificationDate = '#getZJF_files.dateLastModified#') What I get back is an error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'PLATES.zjf'. Then I look at the SQL that was run in debugging. SELECT * FROM FlexoDirectConfigFiles WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005 12:34:01 PM'' Why did it take my single quotes and add another single quote? Is it trying to escape the single quote? How do I keep it from doing this? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfc question
Thank Matt, Jim and Dan. I see where you guys are going with this. As far as security im not sure how using the array is any better. I suppose once things are broken out using the array I could then validate the data coming in with cfqueryparam. This would keep people from tacking on sub-queries and injecting their own SQL statements. Thanks for the help! Chad -Original Message- From: Matt Quackenbush [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 11:25 AM To: CF-Talk Subject: Re: cfc question Chad, cfquery is indeed escaping your single quotes. You can get around this in a couple of ways. The first is to use preserveSingleQuotes() in your function, like so: WHERE #preserveSingleQuotes(arguments.criteria)# While that is a very easy solution, you will be opening yourself up to all sorts of security risks. Therefore, I would strongly urge that you do *not* use this solution. Another solution would be to add an argument that would accept an array, or an array of structs that would hold your criteria. Here is a quick example of what I mean. !--- calling page --- cfscript myArray = arrayNew(1); myArray[1] = structNew(); myArray[1].field = FileName; myArray[1].value = PLATES.zjf; myArray[1].quote = true; myArray[2].field = FileModificationDate; myArray[2].value = 09/30/2005 12:34:01 PM; myArray[2].quote = true; /cfscript !--- function --- cfargument name=criteria type=array / cfquery WHERE 0 = 0 cfloop from=1 to=#arrayLen(arguments.criteria)# index=i AND #arguments.criteria[i].field# = cfif arguments.criteria[i].quote '#arguments.criteria[i].value#' cfelse #arguments.criteria[i].value# /cfif /cfloop /cfquery Hope that helps. Matt I have a CRUD CFC that has this function and I load the CFC into the application scope: cffunction name=readZJF access=public returntype=query cfargument name=criteria type=string required=yes cfquery datasource=dsn name=readZJF SELECT * FROM FlexoDirectConfigFiles WHERE #arguments.criteria# /cfquery cfreturn readZJF /cffunction I want to be able to pass in the WHERE statement into it. So it could be: FileName = 'PLATES.zjf' AND FileModificationDate = '09/30/2005 12:34:01 PM' So I run something like this to call the function: cfset DoesFileAlreadyExist = application.ZJF.readZJF(FileName = '#getZJF_files.name#' AND FileModificationDate = '#getZJF_files.dateLastModified#') What I get back is an error: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ' PLATES.zjf'. Then I look at the SQL that was run in debugging. SELECT * FROM FlexoDirectConfigFiles WHERE FileName = ''PLATES.zjf'' AND FileModificationDate = ''09/30/2005 12:34:01 PM'' Why did it take my single quotes and add another single quote? Is it trying to escape the single quote? How do I keep it from doing this? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284000 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: preserving session for web services
Ya... I was experimenting with an AIR app a while back and it connected to a Coldfusion CFC. The session was created when the AIR app hit the CFC and the session expired at the predetermined time. You might have to build a cfc for the distributors web service calls to create your session objects, but once created then the future webservice calls will be able to access the session objects. Like Brad said... IF it can accept a cookie. Setup a test application.cfm and cfc with session stuff in it and with access=remote on the functions and have them hit the CFC WSDL and see what happens. http://demo.dev/login.cfc?WSDL -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 12:04 PM To: CF-Talk Subject: RE: preserving session for web services As long as your distributors program can accept cookies, then you can use session management just like you would with a browser. ~Brad -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 10:23 AM To: CF-Talk Subject: preserving session for web services Greetings, I have a question for the list. A distributor wants to connect to our ecommerce system, which is an OO setup using cfc's. Their site however is an asp.net site. What we are looking at is using web services to send the results back to the browser on the distributor's site. However our ecommerce system uses session variables to hold various objects, like a user object, a shopping cart object etc. This obviously may be a problem. So how do we maintain session between the different web service calls to our site? Any help or suggestions on this is most appreciated. thx, larry ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfqueryparam and XML
I am writing a create database record function in my CFC. Now one argument that is being passed in is data type of XML. So I use cfargument and set the type to XML. Now when I am doing my INSERT into the database I am using cfqueryparam and noticed there is no cfsqltype of XML. What should I do? Now I don't HAVE to pass in a CF XML object. I could leave it the raw text from when I read the XML file with CFFile and pass that in to the CFC function. Honestly I don't know if when I do the insert if MS SQL is going to like me passing in a CF XML object. I have not tried it yet. The datatype in the MS SQL table is XML. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfqueryparam and XML
Ya... sorry I should have said MS SQL 2005 and the datatype is XML. I experimented and used cf_sql_varchar with both a CF XML object and plain old text and both worked fine. The CF XML object must be pretty close to plain old text. I wonder if CF8 will have an XML type to support MS SQL 2005. -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 17, 2007 4:44 PM To: CF-Talk Subject: Re: cfqueryparam and XML The CFQUERYPARAM type is supposed to match the type of column you are inserting into. Typically, dumping XML into a standard MSSQL database I would assume your column type is either text or ntext. If you are using MS SQL 2005... Which has an XML type for the columns... hmm I'd still use the text type. -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Make PDF from page then email PDF
I have a form that people fill out. When they hit submit I want to make a PDF of data they submitted then pop open an email in outlook with the PDF attached to it. Then all the user has to do is fill in the email to send the PDF to and hit submit. Any suggestions on how to do this? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Make PDF from page then email PDF
How would you use CFDocument and CFMail together? I donât see a way to take the PDF that CFDocument makes and save it to the file system, or pass it as a variable to CFMailParam. You know I though that Acrobat Reader would allow you to email the PDF once opened in your browser, but I donât see this option in acrobat reader. The closest I see is a button called send to fedex kinkos and that is not what I want. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 10, 2007 3:50 PM To: CF-Talk Subject: RE: Make PDF from page then email PDF This wouldn't involve outlook, but I don't think you need it. Use cfdocument to create the pdf and cfmail to send the E-mail attaching the pdf to it. Let the user type into a text area whatever they wish to be included in the body of the E-mail. ~Brad -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 10, 2007 2:37 PM To: CF-Talk Subject: Make PDF from page then email PDF I have a form that people fill out. When they hit submit I want to make a PDF of data they submitted then pop open an email in outlook with the PDF attached to it. Then all the user has to do is fill in the email to send the PDF to and hit submit. Any suggestions on how to do this? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Dreamweaver and Vista
I am running fine with DW8 and Vista. No crashes. I did upgrade from XP to Vista. So DW8 was already installed then I did an upgrade from XP to Vista. Maybe that makes a difference. -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 11:35 AM To: CF-Talk Subject: Dreamweaver and Vista A word of warning. Dreamweaver does not run at all well on Windows Vista. I am running DW 8 with the patch. It crashes frequently when: a.. browsing for files b.. performing links to databases c.. synch'ing d.. when it feels it hasn't crashed for a while e.. on days with a Y in them General feedback on Vista - don't bother. We are Microsoft's beta testers, once again! Jennifer Gavin-Wear Fast Track Online Tel: +44 (0)1262 602013 http://www.fasttrackonline.co.uk/ ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282581 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MS SQL XML Datatype
So is there any advantage or reason I should be storing XML data in a XML field vs. varchar?? ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
argumentcollection
When using argumentcollection can you dump in a query? I have done argumentCollection=form in the past to take the form structure from a page and dump it in, but what about a query? This returns a query with data from a database cfinvoke component=com.mySite method=readRecord returnVariable=qry cfinvokeargument name=ID value=#variables.ID# /cfinvoke I want to dump the query from above into this function that does a database insert. cfset create = CreateObject(component,com.mySite) / cfset create.createRecord(argumentCollection=qry) / If not, is there a way to convert my query into a structure that I can dump into it? ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFTP
Does any one have code or suggestions on using CFFTP to check an FTP server to see if a file exists on the FTP server? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282408 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
invoking a cfc function with minimal typing
I have a function in a CFC that does an update on a database table. cffunction name=updateTable access=public cfargument name=id type=numeric required=yes cfargument name=Feild1 type=string required=no cfargument name=Field2 type=string required=no cfquery datasource=#variables.dataSource# UPDATE table SET Field1='#arguments.Field1#', Field2='#arguments.Field2#' WHERE id = #arguments.id# /cfquery /cffunction I can use cfinvoke with cfinvokearguments tags for each field, but that is a lot of typing. What is best way to send the arguments to the function with the least amount of typing? I suppose is my real question is how do you use cfscript to send the data? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: invoking a cfc function with minimal typing
Oh wow.. that looks powerful. They are form fields. I get this error Variable COM is undefined. when trying it. I must have my cfc's not configured right. cfset com.mysite.ticketdata.updateTable(argumentcollection=form) / If I use cfinvoke I format my component with dots cfinvoke component=com.mysite.ticketdata method=updateTable What do I need to do to use cfset with my cfc? Thanks! Chad -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 11:38 AM To: CF-Talk Subject: Re: invoking a cfc function with minimal typing if you're sending form fields... cfset myInstance.updateTable(argumentcollection=form) / you can send an array, you can send a struct... you can send any number of simple variables wrapped up in a single complex var. On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote: I have a function in a CFC that does an update on a database table. cffunction name=updateTable access=public cfargument name=id type=numeric required=yes cfargument name=Feild1 type=string required=no cfargument name=Field2 type=string required=no cfquery datasource=#variables.dataSource# UPDATE table SET Field1='#arguments.Field1#', Field2='#arguments.Field2#' WHERE id = #arguments.id# /cfquery /cffunction I can use cfinvoke with cfinvokearguments tags for each field, but that is a lot of typing. What is best way to send the arguments to the function with the least amount of typing? I suppose is my real question is how do you use cfscript to send the data? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: invoking a cfc function with minimal typing
Thanks Dave! Now here is my code cfinvoke component=com.mysite.ticketdata method=updateTable returnVariable=update cfset update(argumentcollection=form) / I get an error: The parameter ID to function updateTable is required but was not passed in. If I look at my cf debugging the form field ID is defined. Form Fields: ID=75 FIELD1=test FIELD2=test -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 11:48 AM To: CF-Talk Subject: RE: invoking a cfc function with minimal typing Oh wow.. that looks powerful. They are form fields. I get this error Variable COM is undefined. when trying it. I must have my cfc's not configured right. cfset com.mysite.ticketdata.updateTable(argumentcollection=form) / If I use cfinvoke I format my component with dots cfinvoke component=com.mysite.ticketdata method=updateTable What do I need to do to use cfset with my cfc? Thanks! Chad -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 11:38 AM To: CF-Talk Subject: Re: invoking a cfc function with minimal typing if you're sending form fields... cfset myInstance.updateTable(argumentcollection=form) / you can send an array, you can send a struct... you can send any number of simple variables wrapped up in a single complex var. On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote: I have a function in a CFC that does an update on a database table. cffunction name=updateTable access=public cfargument name=id type=numeric required=yes cfargument name=Feild1 type=string required=no cfargument name=Field2 type=string required=no cfquery datasource=#variables.dataSource# UPDATE table SET Field1='#arguments.Field1#', Field2='#arguments.Field2#' WHERE id = #arguments.id# /cfquery /cffunction I can use cfinvoke with cfinvokearguments tags for each field, but that is a lot of typing. What is best way to send the arguments to the function with the least amount of typing? I suppose is my real question is how do you use cfscript to send the data? ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: invoking a cfc function with minimal typing
Ah! Thanks Charlie!
This makes sense now. I was not using the createObject function right in my
last try.
Thanks again!
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 12:09 PM
To: CF-Talk
Subject: Re: invoking a cfc function with minimal typing
On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote:
Oh wow.. that looks powerful. They are form fields.
I get this error Variable COM is undefined. when trying it. I must have my
cfc's not configured right.
cfset com.mysite.ticketdata.updateTable(argumentcollection=form) /
If I use cfinvoke I format my component with dots
cfinvoke component=com.mysite.ticketdata method=updateTable
What do I need to do to use cfset with my cfc?
cfset myInstanceName = createObject('component', 'com.mysite.ticketdata') /
cfset myInstanceName.updateTable(argumentcollection=form) /
obviously, 'myInstanceName' can be any variable name.
bear in mind that createObject() is a relatively expensive process.
if the component has methods that will be called frequently throughout
the application, it might be a good idea to instantiate it into the
application scope. this way you're just doing a createObject() once,
but can refer to the methods within the component as many times as
needed within the application.
for example... wherever you'd normally set your session/application variables:
cfset application.myComponent = createObject('component',
'com.mysite.ticketdata') /
then on your form's action page:
cfset application.myComponent.updateTable(argumentcollection=form) /
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 07, 2007 11:38 AM
To: CF-Talk
Subject: Re: invoking a cfc function with minimal typing
if you're sending form fields...
cfset myInstance.updateTable(argumentcollection=form) /
you can send an array, you can send a struct... you can send any
number of simple variables wrapped up in a single complex var.
On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote:
I have a function in a CFC that does an update on a database table.
cffunction name=updateTable access=public
cfargument name=id type=numeric required=yes
cfargument name=Feild1 type=string required=no
cfargument name=Field2 type=string required=no
cfquery datasource=#variables.dataSource#
UPDATE table SET
Field1='#arguments.Field1#',
Field2='#arguments.Field2#'
WHERE id = #arguments.id#
/cfquery
/cffunction
I can use cfinvoke with cfinvokearguments tags for each field, but that
is a lot of typing.
What is best way to send the arguments to the function with the least
amount of typing?
I suppose is my real question is how do you use cfscript to send the data?
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: invoking a cfc function with minimal typing
Wow... that is really great! Talk about minimal typing! This use of argumentcollection=form. What are the dangers? It seems too easy to use. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 11:38 AM To: CF-Talk Subject: Re: invoking a cfc function with minimal typing if you're sending form fields... cfset myInstance.updateTable(argumentcollection=form) / you can send an array, you can send a struct... you can send any number of simple variables wrapped up in a single complex var. On 6/7/07, Chad Gray [EMAIL PROTECTED] wrote: I have a function in a CFC that does an update on a database table. cffunction name=updateTable access=public cfargument name=id type=numeric required=yes cfargument name=Feild1 type=string required=no cfargument name=Field2 type=string required=no cfquery datasource=#variables.dataSource# UPDATE table SET Field1='#arguments.Field1#', Field2='#arguments.Field2#' WHERE id = #arguments.id# /cfquery /cffunction I can use cfinvoke with cfinvokearguments tags for each field, but that is a lot of typing. What is best way to send the arguments to the function with the least amount of typing? I suppose is my real question is how do you use cfscript to send the data? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Finding current queries
Not quite sure what you mean, but if I understand right I would look at the database for currently active or running queries. I would not look to do this through Coldfusion. MS SQL has a tool called the SQL Server Profiler. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, June 07, 2007 1:57 PM To: CF-Talk Subject: Finding current queries Hi, Beside declaring them in the session scope, is there any mean to find all currently active queries in an application? Both in CFMX and CF 5 ? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280407 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfhttp
Does CFHTTP show up as a browser type that could be blocked? I cannot download my Calvin and Hobbes comics anymore with the following. cfhttp method=GET url=http://images.ucomics.com/comics/ch/2007/ch070605.gif; path=#variables.path# file=calvin#day#.gif If I hit the URL: http://images.ucomics.com/comics/ch/2007/ch070605.gif I get the comic, but if I use CFHttp it fails. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfhttp
Hmmm actually never mind. It works on one of my computers but not another so I need to dig into why one computer it works and the other it does not. Thanks anyways! -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 5:35 PM To: CF-Talk Subject: cfhttp Does CFHTTP show up as a browser type that could be blocked? I cannot download my Calvin and Hobbes comics anymore with the following. cfhttp method=GET url=http://images.ucomics.com/comics/ch/2007/ch070605.gif; path=#variables.path# file=calvin#day#.gif If I hit the URL: http://images.ucomics.com/comics/ch/2007/ch070605.gif I get the comic, but if I use CFHttp it fails. ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
javascript question
I thought this would be an easy one but I cant get it to work.
I want a text input to change value when an option in a select box is changed.
I am looping over my options in the select with database information. Do I
need to use something other then onChange?
script
function displayStockLevels(ID) {
document.frmDryOffset.stockLevels.value = ID;
}
/script
input type=text id=stockLevels /
select name=NEW_Plate_to_make
cfloop query=getPlates
option
onchange=displayStockLevels(#getPlates.ID#);#getPlates.Name#/option
/cfloop
/select
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279860
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: javascript question
Oh... duh! Thanks for the help Charlie that works great!
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, June 01, 2007 3:39 PM
To: CF-Talk
Subject: Re: javascript question
the onchange() goes into the select element.
select name=NEW_Plate_to_make
onchange=displayStockLevels(this.options[this.selectedIndex].value);
cfloop query=getPlates
option value=#getPlates.ID##getPlates.Name#/option
/cfloop
/select
On 6/1/07, Chad Gray [EMAIL PROTECTED] wrote:
I thought this would be an easy one but I cant get it to work.
I want a text input to change value when an option in a select box is changed.
I am looping over my options in the select with database information. Do I
need to use something other then onChange?
script
function displayStockLevels(ID) {
document.frmDryOffset.stockLevels.value = ID;
}
/script
input type=text id=stockLevels /
select name=NEW_Plate_to_make
cfloop query=getPlates
option
onchange=displayStockLevels(#getPlates.ID#);#getPlates.Name#/option
/cfloop
/select
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279863
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: javascript
I want to write a javascript function that I can use on all of my forms and
inputs to disable a text input. So I want to pass to the function the form's
ID and the text input's ID to be disabled.
How do I append the functions attributes to my document command?
My javascript below does not work.
Function disabler(formID,textInputID) {
document.formID.textInputID.disabled=true;
}
form id=foo
input type=text id=moo
input type=button onClick=disabler('foo','moo');
/form
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278435
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dump http hit
I am working with a program that is going to send a chunk of XML to a web page. I don't know how the XML is formatted from this program. Is there any way to dump all data that is submitted to page.cfm and load it up in an email to send to me? I don't know if it is going to be a POST or GET either. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dump http hit
Yes data is being posted to my cfm page and I want to dump any data that is posted to it in a email. Id don't quite follow your example. What do you mean cfhttp call? Thanks for the help! -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 12:05 PM To: CF-Talk Subject: RE: dump http hit Ooooh. Maybe I misunderstood. My example assumes that data is being posted TO you. Andy's assumes that data is PULLED BY you. Both good examples. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 02, 2007 12:03 PM To: CF-Talk Subject: RE: dump http hit cfhttp call cfdump var=cfhttp Or if you're dumping the results into a variable: cfdump var=myResult.filecontent ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
making a page use cfdocument or not
I would like to make a page that will either be displayed as a PDF using CFDocument or as plan old HTML. I cant seem to do the below I get the error: The end tag /cfdocument encoutered on line 6 at column 11 requires a matching start tag. cfif URL.Format EQ PDF cfdocument format=pdf /cfif blah blah blah cfif URL.Format EQ PDF /cfdocument /cfif What is the best way to make the page display in either PDF or HTML? Thanks! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF/Flex SendGatewayMessage()
I just watched one of Ben Fortas examples of using the CF function sendGatewayMessage() to send data to a Flex app that was listening with mx:Consumer. If I heard right in his presentation this only possible with CF Enterprise right? I don't see a way to make a gateway in CF Admin (standard edition). So this must be an enterprise thing. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL question
I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274409 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 question
I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274412 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 question
I tried that too and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:09 AM To: CF-Talk Subject: RE: SQL question How about using... WHERE dateCreated LIKE '%4/2/2007%' -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:05 AM To: CF-Talk Subject: RE: SQL question I tried that also and no records are returned. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:01 AM To: CF-Talk Subject: RE: SQL question How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose the padding zeros. ~Che -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 9:59 AM To: CF-Talk Subject: SQL question I am using MS SQL and have a field with data type DateTime. I want to find all records with the day 4/2/2007? If I do WHERE dateCreated = '04/02/2007' I get no records and I have lots of records like this in the database: 4/2/2007 9:57:57 AM 4/2/2007 10:57:57 AM 4/2/2007 5:57:57 AM 4/2/2007 2:57:57 AM I want to keep the time in my data so I don't want to modify the data type. How do I write my query to find all records on the day 4/2/2007? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274416 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 question
AH! This works! Thanks! -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:10 AM To: CF-Talk Subject: Re: SQL question Chad Gray wrote: I want to find all records with the day 4/2/2007? WHERE DATEDIFF(day, dateCreated,'4/3/2007')=0 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274421 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 question
On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274432 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 question
I just tried this and I get no records. dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1) Is this method compatible with MS SQL? -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:41 AM To: CF-Talk Subject: RE: SQL question On the (@date + 1) how do you know it is adding one day? Out of curiosity how do you add one year? Thanks for the clean elegant solution. I will try it out. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 10:26 AM To: CF-Talk Subject: RE: SQL question People people people :) I have seen casting, converting, date-diffing, LIKE'ing, MONTH()/Day()/Year()'ing Please do not run functions on your date/time fields. Running a function on a column in general is extremely slow. Date/time stamps can be used quite nicely with out them: DECLARE @date DATETIME; SET @date = '04/14/2006'; SELECT * FROM [TABLE] WHERE date_created = @date AND date_created (@date + 1) Notice that I comparing the date_created to the set date and also that it is LESS than the set date PLUS one (the next day). This is going to perform a 100 times better than any function you call on the date column. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274434 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 question
Thanks Ben, and Joe here is what finally worked for me.
dateCreated = '04/03/2007' AND dateCreated DATEADD(DAY, 1, '04/03/2007')
With
dateCreated = '04/03/2007' AND dateCreated ('04/03/2007' + 1)
I get this error:
Conversion failed when converting the varchar value '04/03/2007' to data type
int.
So I probably have to cast as a date in order to get this to work.
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:48 AM
To: CF-Talk
Subject: Re: SQL question
Chad,
Try
WHERE
dateCreated = @someDate AND dateCreated DATEADD(DAY, 1, @someDate)
-Joe
On Apr 3, 2007, at 10:45 AM, Chad Gray wrote:
I just tried this and I get no records.
dateCreated = 04/02/2007 AND dateCreated (04/02/2007 + 1)
Is this method compatible with MS SQL?
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:41 AM
To: CF-Talk
Subject: RE: SQL question
On the (@date + 1) how do you know it is adding one day?
Out of curiosity how do you add one year?
Thanks for the clean elegant solution. I will try it out.
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:26 AM
To: CF-Talk
Subject: RE: SQL question
People people people :)
I have seen casting, converting, date-diffing, LIKE'ing,
MONTH()/Day()/Year()'ing Please do not run functions on your
date/time fields. Running a function on a column in general is
extremely
slow. Date/time stamps can be used quite nicely with out them:
DECLARE @date DATETIME;
SET @date = '04/14/2006';
SELECT *
FROM [TABLE]
WHERE
date_created = @date
AND
date_created (@date + 1)
Notice that I comparing the date_created to the set date and also
that
it is LESS than the set date PLUS one (the next day). This is going to
perform a 100 times better than any function you call on the date
column.
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274439
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
livedocs.adobe.com
http://livedocs.adobe.com/coldfusion/7/htmldocs/1477.htm Is this up to date for 7.0.2? I does not read like it is. I am getting into Apollo and would like to connect my Apollo app to Flash/Flex Remoting on my CF server. I hear it is faster then soap. Chad ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:_Is_there_an_Apollo_developer's_mailing_list ?
There is a Flex and Apollo yahoo group, but I have found them to be extremely slow and I think it is moderated heavily. I found for best results you need to post via the yahoo web site not your email program. I waited 4 hours for a message to post. http://tech.groups.yahoo.com/group/flexcoders/ http://tech.groups.yahoo.com/group/apollocoders/ -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 12:39 PM To: CF-Talk Subject: Re: Is there an Apollo developer's mailing list? I'll have one up today. I couldn't spot one apart from the Adobe forums? MD ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfc and wsdl
Hello,
I am playing with cfcs and what I am reading so far I should be able to hit the
cfc with ?wsdl on the end and get WSDL.
Here is my test cfc right out of the help files:
cfcomponent
cffunction name = echoString returnType = string output = no access =
remote
cfargument name = input type = string
cfreturn #arguments.input#
/cffunction
/cfcomponent
I get the following:
AXIS error
Sorry, something seems to have gone wrong... here are the details:
Fault - Error attempting to create Java skeleton for CFC web service; nested
exception is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could
not resolve CFC datatype: /lib/cfc/utils.cfc]
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
faultSubcode:
faultString: Error attempting to create Java skeleton for CFC web service;
nested exception is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException : Could
not resolve CFC datatype: /lib/cfc/utils.cfc]
~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272984
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc and wsdl
It is set to remote. I just copied the cfc to our production server and it
works fine. I get good WSDL.
It has something to do with out development server. They are the same server
versions.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 10:13 AM
To: CF-Talk
Subject: RE: cfc and wsdl
Your CFC has to be set to remote.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 9:07 AM
To: CF-Talk
Subject: cfc and wsdl
Hello,
I am playing with cfcs and what I am reading so far I should be able to hit
the cfc with ?wsdl on the end and get WSDL.
Here is my test cfc right out of the help files:
cfcomponent
cffunction name = echoString returnType = string output = no access =
remote
cfargument name = input type = string
cfreturn #arguments.input#
/cffunction
/cfcomponent
I get the following:
AXIS error
Sorry, something seems to have gone wrong... here are the details:
Fault - Error attempting to create Java skeleton for CFC web service; nested
exception is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault
faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
faultSubcode:
faultString: Error attempting to create Java skeleton for CFC web service;
nested exception is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: /lib/cfc/utils.cfc]
~|
ColdFusion MX7 and Flex 2
Build sales marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272986
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc and wsdl
Oh... yes the development server has this mapping:
/ C:\CFusionMX7\wwwroot
The production server does not have this mapping.
Should I remove this mapping? One of the other developers must have made it
and I will need to find out why.
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 10:36 AM
To: CF-Talk
Subject: Re: cfc and wsdl
Check to see if either server has a root mapping (i.e. / is mapped to
something) and if there are any other differences between the mappings
on the boxes.
On 3/19/07, Chad Gray [EMAIL PROTECTED] wrote:
It is set to remote. I just copied the cfc to our production server and it
works fine. I get good WSDL.
It has something to do with out development server. They are the same server
versions.
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 10:13 AM
To: CF-Talk
Subject: RE: cfc and wsdl
Your CFC has to be set to remote.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, March 19, 2007 9:07 AM
To: CF-Talk
Subject: cfc and wsdl
Hello,
I am playing with cfcs and what I am reading so far I should be able to hit
the cfc with ?wsdl on the end and get WSDL.
Here is my test cfc right out of the help files:
cfcomponent
cffunction name = echoString returnType = string output = no access =
remote
cfargument name = input type = string
cfreturn #arguments.input#
/cffunction
/cfcomponent
I get the following:
AXIS error
Sorry, something seems to have gone wrong... here are the details:
Fault - Error attempting to create Java skeleton for CFC web service; nested
exception is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: /lib/cfc/utils.cfc] AxisFault
faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
faultSubcode:
faultString: Error attempting to create Java skeleton for CFC web service;
nested exception is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: /lib/cfc/utils.cfc]
~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272989
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: TIFF image converstion (cfc)
They are not a CFCs, but CFXs and work great! http://efflare.com/ ImageCR and ImageFlare are powerful tools and I have been using them for years with millions of images with no problems. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:41 AM To: CF-Talk Subject: TIFF image converstion (cfc) Hello, I would like to know if anyone knows of an coldfusion compatible cfc/tag that converts tiff files to jpeg and can manipulate them on the fly. Be great if you have actual experience with it. Currently, I'm using something called ACDSee to convert them periodically, but it's a pain to have to remember to do that all the time. Was looking into something called 'jimg', but it's not available anymore. We have Coldfusion 6.1 JRun 4 updater 6, and jvm 1.4.2_12 Thanks, Doug p.s. Hope all it well with everyone, long time no post. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE:_Debugging?
cfsetting showdebugoutput=no If you want it to be site wide stick it in your application.cfm -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:30 AM To: CF-Talk Subject: Debugging? Is there a way to have Debugging turned OFF for one site but on for everything else? I am building an internal application and would like the Debugging on that site off. Since developers are using the same server for other applications, the debugging (CF Admin settings) is turned on. TIA! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: TC's and Privacy Policy
Here are some templates I have used in the past. Fill in the [blanks]. Web Site Terms and Conditions of Use 1. Terms By accessing this web site, you are agreeing to be bound by these web site Terms and Conditions of Use, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this site. The materials contained in this web site are protected by applicable copyright and trade mark law. 2. Use License (a) Permission is granted to temporarily download one copy of the materials (information or software) on [Web Site Name]'s web site for personal, non-commercial transitory viewing only. This is the grant of a license, not a transfer of title, and under this license you may not: (i) modify or copy the materials; (ii) use the materials for any commercial purpose, or for any public display (commercial or non-commercial); (iii) attempt to decompile or reverse engineer any software contained on [Web Site Name]'s web site; (iv) remove any copyright or other proprietary notations from the materials; or (v) transfer the materials to another person or mirror the materials on any other server. (b) This license shall automatically terminate if you violate any of these restrictions and may be terminated by [Web Site Name] at any time. Upon terminating your viewing of these materials or upon the termination of this license, you must destroy any downloaded materials in your possession whether in electronic or printed format. 3. Disclaimer (a) The materials on [Web Site Name]'s web site are provided as is. [Web Site Name] makes no warranties, expressed or implied, and hereby disclaims and negates all other warranties, including without limitation, implied warranties or conditions of merchantability, fitness for a particular purpose, or non-infringement of intellectual property or other violation of rights. Further, [Web Site Name] does not warrant or make any representations concerning the accuracy, likely results, or reliability of the use of the materials on its Internet web site or otherwise relating to such materials or on any sites linked to this site. 4. Limitations In no event shall [Web Site Name] or its suppliers be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption,) arising out of the use or inability to use the materials on [Web Site Name]'s Internet site, even if [Web Site Name] or a [Web Site Name] authorized representative has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you. 5. Revisions and Errata The materials appearing on [Web Site Name]'s web site could include technical, typographical, or photographic errors. [Web Site Name] does not warrant that any of the materials on its web site are accurate, complete, or current. [Web Site Name] may make changes to the materials contained on its web site at any time without notice. [Web Site Name] does not, however, make any commitment to update the materials. 6. Links [Web Site Name] has not reviewed all of the sites linked to its Internet web site and is not responsible for the contents of any such linked site. The inclusion of any link does not imply endorsement by [Web Site Name] of the site. Use of any such linked web site is at the user's own risk. 7. Site Terms of Use Modifications [Web Site Name] may revise these terms of use for its web site at any time without notice. By using this web site you are agreeing to be bound by the then current version of these Terms and Conditions of Use. 8. Governing Law Any claim relating to [Web Site Name]'s web site shall be governed by the laws of the State of [State (ie. California)] without regard to its conflict of law provisions. General Terms and Conditions applicable to Use of a Web Site. - 2 - Privacy Policy Your privacy is very important to us. Accordingly, we have developed this Policy in order for you to understand how we collect, use, communicate and disclose and make use of personal information. The following outlines our privacy policy. * Before or at the time of collecting personal information, we will identify the purposes for which information is being collected. * We will collect and use of personal information solely with the objective of fulfilling those purposes specified by us and for other compatible purposes, unless we obtain the consent of the individual concerned or as required by law. * We will only retain personal information as long as necessary for the fulfillment of those purposes. * We will collect personal information by lawful and fair means and, where appropriate, with the knowledge or consent of the
CFCs and Best Practices
I have doing spaghetti CF sites for a few years now and have started to understand the importance of separating your display code from your logic code. Is there a best practice for using CFCs and CF? I read the documentation on CFCs and there are lots of ways to use them. You can use CFinvoke, CFScript you can make a mapping to your CFCs or you can keep them local to the CFM pages. You can use CFInvokeArgurments or just place arguments in CFInvoke. Inheritance and persistence confuses me some.. when should you use them? I found the book 'Discovering CFCs: ColdFusion MX Components' but it got rough reviews on amazon.com. Thanks, Chad ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFCs and Best Practices
Michael, thanks for the links. Do you take amex? My company CC is amex I would like to subscribe. Feel free to reply to my email and take this off CFTalk. Chad -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 5:26 PM To: CF-Talk Subject: Re: CFCs and Best Practices You can always order the second issue of the Fusion Authority Quarterly Update which covers a lot of this. :) http://www.fusionauthority.com/quarterly/ There are a LOT of best practices for using CFCs and some of them contradict each other. You can start with the ColdFusion MX Coding Guidelines (http://livedocs.adobe.com/wtg/public/coding_standards/contents.html), hit Nathan Dintenfass's best practices page(http://www.dintenfass.com/cfcbestpractices/), Ray's CFC scope reference (http://ray.camdenfamily.com/downloads/cfcscopes.pdf), and then do a search for CFC best practices on the ColdFusion Community Search at the top of every House of Fusion page. Michael Dinowitz President: House of Fusion(http://www.houseoffusion.com) Publisher: Fusion Authority(http://www.fusionauthority.com) Adobe Community Expert / Advanced Certified ColdFusion Professional I have doing spaghetti CF sites for a few years now and have started to understand the importance of separating your display code from your logic code. Is there a best practice for using CFCs and CF? I read the documentation on CFCs and there are lots of ways to use them. You can use CFinvoke, CFScript you can make a mapping to your CFCs or you can keep them local to the CFM pages. You can use CFInvokeArgurments or just place arguments in CFInvoke. Inheritance and persistence confuses me some.. when should you use them? I found the book 'Discovering CFCs: ColdFusion MX Components' but it got rough reviews on amazon.com. Thanks, Chad ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCs and Best Practices
Your paypal page does not have amex in the drop down. http://www.fusionauthority.com/quarterly/ I clicked on the first link and that uses google, so I am set. Thanks! Chad -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 7:32 PM To: CF-Talk Subject: Re: CFCs and Best Practices If Google Checkout takes it, we take it. We also take paypal but the paypal page is not up due to me being a bit bogged down (Judith will be giving birth in the next few days). If you want to use paypal, email me off list and I'll set you up. Michael, thanks for the links. Do you take amex? My company CC is amex I would like to subscribe. Feel free to reply to my email and take this off CFTalk. Chad ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272952 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCs and Best Practices
Whoops I mean to paste this address: https://secure.houseoffusion.com/paypal.cfm -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 7:49 PM To: CF-Talk Subject: RE: CFCs and Best Practices Your paypal page does not have amex in the drop down. http://www.fusionauthority.com/quarterly/ I clicked on the first link and that uses google, so I am set. Thanks! Chad ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFCs and Best Practices
Thanks Dave, I think you are right that I need to pick up on OO concepts. I have been picking at the head first object-oriented analysis and design book, but kind of get lost in the java language since I truly don't know it. I will keep reading and learning, thanks for your awesome response, it answers a lot of questions! My problems with persistence is the cflocking thing that the documentation mentions. Im not sure when I would have to lock thinks. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, March 18, 2007 8:38 PM To: CF-Talk Subject: RE: CFCs and Best Practices Is there a best practice for using CFCs and CF? Yes, there are best practices for using CFCs, and most of them are largely drawn from best practices in any other class-based OO programming language, such as Java. Your best bet for understanding these best practices is to learn general OO programming concepts, which can then be applied pretty easily to CF in many cases. I read the documentation on CFCs and there are lots of ways to use them. You can use CFinvoke, CFScript you can make a mapping to your CFCs or you can keep them local to the CFM pages. You can use CFInvokeArgurments or just place arguments in CFInvoke. There's nothing wrong with any of these approaches, actually. There are places where it may make more sense to use one than another, but the differences are pretty minor. In general, it's pretty common to use CFINVOKE when using a CFC as a static class, and to use CFSET or CFSCRIPT along with CreateObject when using a CFC as a class template from which you want to create instances. But the differences between one and the other are more a matter of personal preference than best practice. Inheritance and persistence confuses me some.. when should you use them? Persistence doesn't really have anything to do with CFCs. You persist CFC instances just like you'd persist any other variable in CF. If, for example, it makes sense to store something in the user's session, it doesn't matter whether it's an object instance or an array or structure or whatever. Inheritance (and composition, and a bunch of other things) are part of OO, and you should use them when it makes sense to use them. That's pretty much a non-answer, but an actual answer would require a lot more explanation, and you're going to have to learn OO programming anyway. But, for a quick example, let's say you have people in general that you want to represent in your program, and they all share common characteristics. So, you might write a Person CFC that you will use to create Person objects. You might also have different types of people, who have their own characteristics in addition to those common characteristics, say Customers and Employees. It would make sense in this case to have Customer and Employee CFCs that extend Person, to add those type-specific characteristics. That's inheritance. A customer is a person; inheritance is an is a relationship. The other common relationship, composition, is a has a relationship. For example, people might have addresses, or roles, or whatever, that might be represented by their own CFCs. I found the book 'Discovering CFCs: ColdFusion MX Components' but it got rough reviews on amazon.com. I think it's actually a pretty good book, it was just written at a very bad time. When CFMX first came out, CFCs had lots of problems and limitations, and this book spends a significant amount of time covering workarounds for those limitations. Since then, newer versions of CF have removed many of those limitations, making the workarounds unnecessary. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272957 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
webservice newbie question
Hello I am hitting a web service with cfinvoke. cfinvoke webservice=http://localhost/CumulusWS/services/Cumulus?wsdl; method=getServerCatalogs returnvariable=aServerCatalogList cfinvokeargument name=connection value=#aConnection#/ /cfinvoke cfdump var=#aServerCatalogList# When I dump I get the following. How do I use these methods that are returned? Methods hashCode (returns int) equals (returns boolean) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getServerCatalog (returns com.canto.www._2005.cumulus.ws.types.ServerCatalog) getServerCatalog (returns [Lcom.canto.www._2005.cumulus.ws.types.ServerCatalog;) setServerCatalog (returns void) setServerCatalog (returns void) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: webservice newbie question
Oh, I did not paste the complete dump. I forgot to include the object. object of com.canto.www._2005.cumulus.ws.types.ServerCatalogList Methods hashCode (returns int) equals (returns boolean) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getServerCatalog (returns com.canto.www._2005.cumulus.ws.types.ServerCatalog) getServerCatalog (returns [Lcom.canto.www._2005.cumulus.ws.types.ServerCatalog;) setServerCatalog (returns void) setServerCatalog (returns void) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 9:15 AM To: CF-Talk Subject: webservice newbie question Hello I am hitting a web service with cfinvoke. cfinvoke webservice=http://localhost/CumulusWS/services/Cumulus?wsdl; method=getServerCatalogs returnvariable=aServerCatalogList cfinvokeargument name=connection value=#aConnection#/ /cfinvoke cfdump var=#aServerCatalogList# When I dump I get the following. How do I use these methods that are returned? Methods hashCode (returns int) equals (returns boolean) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getServerCatalog (returns com.canto.www._2005.cumulus.ws.types.ServerCatalog) getServerCatalog (returns [Lcom.canto.www._2005.cumulus.ws.types.ServerCatalog;) setServerCatalog (returns void) setServerCatalog (returns void) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: webservice newbie question
Thanks Phil, I did the dump and it returned an array. cfdump var=#aServerCatalogList.getServerCatalog()# I do have the API so I will read some more. array 1 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) 2 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: webservice newbie question
Ah.. now I am starting to see where this goes. I drop a number into it cfdump var=#aServerCatalogList.getServerCatalog(2)# Now I get another object object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) Now I do cfdump var=#aServerCatalogList.getServerCatalog(2).getName()# And I get the name of the catalog. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 9:46 AM To: CF-Talk Subject: RE: webservice newbie question Thanks Phil, I did the dump and it returned an array. cfdump var=#aServerCatalogList.getServerCatalog()# I do have the API so I will read some more. array 1 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) 2 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272805 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: webservice newbie question
H thought I would get fancy and loop over it and output 4 catalog names and I get this error: The selected method getServerCatalog was not found. Either there are no methods with the specified method name and argument types, or the method getServerCatalog is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. I tried javaCast and get the same error. cfloop index=i from=1 to=4 cfoutput #javacast(string, aServerCatalogList.getServerCatalog(i).getName())#br / /cfoutput /cfloop If I manually number them then I am fine. #javacast(string, aServerCatalogList.getServerCatalog(1).getName())#br / #javacast(string, aServerCatalogList.getServerCatalog(2).getName())#br / #javacast(string, aServerCatalogList.getServerCatalog(3).getName())#br / #javacast(string, aServerCatalogList.getServerCatalog(4).getName())#br / -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 9:56 AM To: CF-Talk Subject: RE: webservice newbie question Ah.. now I am starting to see where this goes. I drop a number into it cfdump var=#aServerCatalogList.getServerCatalog(2)# Now I get another object object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) Now I do cfdump var=#aServerCatalogList.getServerCatalog(2).getName()# And I get the name of the catalog. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 9:46 AM To: CF-Talk Subject: RE: webservice newbie question Thanks Phil, I did the dump and it returned an array. cfdump var=#aServerCatalogList.getServerCatalog()# I do have the API so I will read some more. array 1 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) 2 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: webservice newbie question
Hey that worked! Thanks Phil! I was not thinking in that direction. Chad -Original Message- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 1:30 PM To: CF-Talk Subject: RE: webservice newbie question Chad what if your loop looked like: cfloop index=i from=1 to=4 cfoutput #aServerCatalogList.getServerCatalog(javacast(int,i).getName())#br / /cfoutput /cfloop 'i' might be treated as a string there instead of a number, Phil -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 10:20 AM To: CF-Talk Subject: RE: webservice newbie question H thought I would get fancy and loop over it and output 4 catalog names and I get this error: The selected method getServerCatalog was not found. Either there are no methods with the specified method name and argument types, or the method getServerCatalog is overloaded with arguments types that ColdFusion can't decipher reliably. If this is a Java object and you verified that the method exists, you may need to use the javacast function to reduce ambiguity. I tried javaCast and get the same error. cfloop index=i from=1 to=4 cfoutput #javacast(string, aServerCatalogList.getServerCatalog(i).getName())#br / /cfoutput /cfloop If I manually number them then I am fine. #javacast(string, aServerCatalogList.getServerCatalog(1).getName())#br / #javacast(string, aServerCatalogList.getServerCatalog(2).getName())#br / #javacast(string, aServerCatalogList.getServerCatalog(3).getName())#br / #javacast(string, aServerCatalogList.getServerCatalog(4).getName())#br / -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 9:56 AM To: CF-Talk Subject: RE: webservice newbie question Ah.. now I am starting to see where this goes. I drop a number into it cfdump var=#aServerCatalogList.getServerCatalog(2)# Now I get another object object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) Now I do cfdump var=#aServerCatalogList.getServerCatalog(2).getName()# And I get the name of the catalog. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, March 16, 2007 9:46 AM To: CF-Talk Subject: RE: webservice newbie question Thanks Phil, I did the dump and it returned an array. cfdump var=#aServerCatalogList.getServerCatalog()# I do have the API so I will read some more. array 1 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) 2 object of com.canto.www._2005.cumulus.ws.types.ServerCatalog Methods hashCode (returns int) equals (returns boolean) getName (returns java.lang.String) setName (returns void) getId (returns int) setId (returns void) getSerializer (returns interface org.apache.axis.encoding.Serializer) getDeserializer (returns interface org.apache.axis.encoding.Deserializer) getTypeDesc (returns org.apache.axis.description.TypeDesc) getClass (returns java.lang.Class) wait (returns void) wait (returns void) wait (returns void) notify (returns void) notifyAll (returns void) toString (returns java.lang.String) ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
webservice newbie
I need to send and receive data from a web service. Can someone help me with how to send and receive data? What tags should I use? I see one called CFInvoke. Here is a section of the wsdl that I would like to try first. It is to make a basic connection to the service. - xsd:complexType name=Connection - xsd:annotation xsd:documentationInformation used to connect to a Server./xsd:documentation /xsd:annotation - xsd:sequence - xsd:element name=server type=xsd:string - xsd:annotation xsd:documentationThe server's address./xsd:documentation /xsd:annotation /xsd:element - xsd:element name=user type=xsd:string - xsd:annotation xsd:documentationThe user name./xsd:documentation /xsd:annotation /xsd:element - xsd:element name=password type=xsd:string - xsd:annotation xsd:documentationThe user password./xsd:documentation /xsd:annotation /xsd:element - xsd:element maxOccurs=1 minOccurs=0 name=serialNumber type=xsd:string - xsd:annotation xsd:documentationAn optional serial number to use for connecting./xsd:documentation /xsd:annotation /xsd:element /xsd:sequence /xsd:complexType ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HELP
One of our clients had the idea to clean up their web server and now the CF service wont start. I found this error in this log file: C:\CFusionMX\runtime\logs\default-err.log Error: no `server' JVM at `C:\Program Files\Java\j2sdk1.4.2_09\jre\bin\server\jvm.dll'. Error: no `server' JVM at `C:\Program Files\Java\j2sdk1.4.2_09\jre\bin\server\jvm.dll'. Any tips on getting CF to run again? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: HELP
Is that an option in CF installer? I will load the disk and see. Thanks! -Original Message- From: Webdevotion [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 10:56 AM To: CF-Talk Subject: Re: HELP Can't you try a reinstall ? In stead of remove, choose repair ? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL order by
When you use ORDER BY in SQL on a text field it sorts the data like this: 1 11 12 13 2 21 22 Where I want 1 2 11 12 13 21 22 I cannot switch it to an integer field because there will be some text also. Any way to accomplish this? Thanks! Chad ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267594 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 order by
Thanks Andy, I am using MS SQL and don't have substring_index. Is there a MS SQL function similar? -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 9:22 AM To: CF-Talk Subject: RE: SQL order by cfquery name=queryName SELECT yourcolumn, 0+REPLACE(SUBSTRING_INDEX(yourcolumn,' ',1),',','') AS sort FROM yourtable ORDER BY sort /cfquery -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 8:13 AM To: CF-Talk Subject: SQL order by When you use ORDER BY in SQL on a text field it sorts the data like this: 1 11 12 13 2 21 22 Where I want 1 2 11 12 13 21 22 I cannot switch it to an integer field because there will be some text also. Any way to accomplish this? Thanks! Chad ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267605 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 order by
Thanks Jim! That works great for me! I will have to look up CASE, I am not familiar with that function. Thanks again! -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 9:26 AM To: CF-Talk Subject: Re: SQL order by Chad Gray wrote: I cannot switch it to an integer field because there will be some text also. Any way to accomplish this? maybe something like... SELECT thefield FROM foo ORDER BY CASE WHEN IsNumeric(thefield)=1 THEN CAST(thefield AS INT) ELSE 0 END,thefield That should put the text fields at the beginning, sorted alphabetically, and the numeric fields at the end, sorted numerically. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267607 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 order by
Ok.. So basically your statement is re-defining thefield as an integer if isNumeric returns 1. Else 0 returning thefield as it's original data type. ORDER BY CASE WHEN IsNumeric(thefield)=1 THEN CAST(thefield AS INT) ELSE 0 END,thefield Very cool! Thanks for the lesson, I have never used WHEN, THEN, ELSE, END in SQL. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 9:51 AM To: CF-Talk Subject: RE: SQL order by Case isn't a function. It's a flow control statement. Just like doing a cfswitch statement in CF. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 8:52 AM To: CF-Talk Subject: RE: SQL order by Thanks Jim! That works great for me! I will have to look up CASE, I am not familiar with that function. Thanks again! -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 9:26 AM To: CF-Talk Subject: Re: SQL order by Chad Gray wrote: I cannot switch it to an integer field because there will be some text also. Any way to accomplish this? maybe something like... SELECT thefield FROM foo ORDER BY CASE WHEN IsNumeric(thefield)=1 THEN CAST(thefield AS INT) ELSE 0 END,thefield That should put the text fields at the beginning, sorted alphabetically, and the numeric fields at the end, sorted numerically. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick CFEclipse question
I just got done installing Homesite on my new computer along side of CFEclipse and Dreamweaver because I missed Homesites searching and replacing so much. Homesite can search for carriage returns and replace them with commas... I love that! I can quickly take comma delimited data and replace the comma with a carriage return... I can search for tab and replace it with a comma etc... Homesite's searching and replacing just rocks! In the past I have created my forms. Then submit to an empty action page. I grab from the debugging all of the form vars that were submitted: FIELDNAMES=TYPE,CATALOGID,ELEMENTID,SKU,ELEMENTDESCRIPTION,PAGE,ELEMENTTYPE,TYPEOFSHOT,SIMPLEORADVANCED,PROPS,OUTLINETYPE,JID,NOTES,CAREYNOTES Now I use home site to find the comma and replace with this: ,cfparam name=FORM. Now I have: TYPE,cfparam name=FORM.CATALOGID,cfparam name=FORM.ELEMENTID,cfparam name=FORM.SKU,cfparam name=FORM.ELEMENTDESCRIPTION,cfparam name=FORM.PAGE,cfparam name=FORM.ELEMENTTYPE,cfparam name=FORM.TYPEOFSHOT,cfparam name=FORM.SIMPLEORADVANCED,cfparam name=FORM.PROPS,cfparam name=FORM.OUTLINETYPE,cfparam name=FORM.JID,cfparam name=FORM.NOTES,cfparam name=FORM.CAREYNOTES Now I do another extended replace on comma (the cr represents a carriage return): default= cr Now my results are this: TYPE default= cfparam name=FORM.CATALOGID default= cfparam name=FORM.ELEMENTID default= cfparam name=FORM.SKU default= cfparam name=FORM.ELEMENTDESCRIPTION default= cfparam name=FORM.PAGE default= cfparam name=FORM.ELEMENTTYPE default= cfparam name=FORM.TYPEOFSHOT default= cfparam name=FORM.SIMPLEORADVANCED default= cfparam name=FORM.PROPS default= cfparam name=FORM.OUTLINETYPE default= cfparam name=FORM.JID default= cfparam name=FORM.NOTES default= cfparam name=FORM.CAREYNOTES I clean up the last bit of it and now I have in less then 30 seconds all of the cfparam tags I could ever need for this form submission. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267618 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 order by
You got me pointed in a great new direction. I will figure out the details and
if there is a better function then isNumeric for the data I am dealing with.
Thanks!
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 10:18 AM
To: CF-Talk
Subject: Re: SQL order by
Jim Wright wrote:
I should point out one issue with the way I did it...the isnumeric
function is not perfect, and will resolve to true things that can't be
converted to INT...case in point...
IsNumeric('1,0.') = 1
CAST('1,0.' AS INT) throws an error
and further, you need to look at the numeric data you are
converting...is it all ints...you may need to convert to something
else...also, you can google on isreallynumeric and
isreallyinteger...those are some custom functions I've used in the past.
sorry about the multiple posts...headache...not thinking clearly.
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267620
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Quick CFEclipse question
I cant get it to work in Dreamweaver. Everytime I try to type a carriage return in it executes the search. How do you do it in dreamweaver? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 12:58 PM To: CF-Talk Subject: RE: Quick CFEclipse question Homesite can search for carriage returns and replace them with commas... I love that! You know, you can do that from within Dreamweaver too, right? 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 Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image size
Efflare.com has ImageCR that can do what you want. I use them all the time and they are rock solid applications. Chad -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 12:26 PM To: CF-Talk Subject: Image size I am on CF5.0. Is there anything out there that lets me determine an image's width, height and filesize? TIA, Dave ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
