Re: Details on CF9's free for academic licensing?
If you're after a free CF engine, why not use Open Blue Dragon. It has everything you need to teach your students web programming. They have a Ready2Run download which is preconfigured and only 20Mb. http://www.openbluedragon.org/download.cfm Advantage of this is your students can also use it at home or on their laptops with no licensing problems. Get them using the free CFeclipse IDE hopefully you'll get them hooked on CFML :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Developing cross-RDBMS CF apps, second in an irregular series of Eureka! moments
There's also Reactor http://reactorframework.com/ Which would certainly clean up those functions. All those case statement will make for some really big unweildy functions. If you didn't want to use an ORM, you could break your queries out into seperate includes for each dbms. This makes maintanence and adding support for other dbms's simple, it also cleans up your function so you can see whats going on cffunction namegetFoo cfset var dbms = getDbmsTypeFromSomewhere() / cfquery name=qGetFoo datasource=whatever cfinclude template=queries/#dbms#/qGetFoo.cfm / /cfquery /cffunction ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
The students can also use CF Developer edition for free at home or on their laptops with no licensing problems. On Tue, Aug 19, 2008 at 3:33 PM, Chris Blackwell [EMAIL PROTECTED] wrote: If you're after a free CF engine, why not use Open Blue Dragon. It has everything you need to teach your students web programming. They have a Ready2Run download which is preconfigured and only 20Mb. http://www.openbluedragon.org/download.cfm Advantage of this is your students can also use it at home or on their laptops with no licensing problems. Get them using the free CFeclipse IDE hopefully you'll get them hooked on CFML :) -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
Railo also has a free community edition, it has some limitations but I am sure if you contact them and indicate that you would like to use it in a teaching environment they may give you a version upgrade. You can see the details at http://www.railo-technologies.com/en/index.cfm?treeID=148 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
Pete, as of Railo 3.0 which will be available in the next couple of weeks, Railo Professional and Railo Community will melt into one product and be available for free. We will open source Railo in November this year, so you don't have to deal with any costs whatsoever for your projects. If you need any additional information, just drop me a line... Greetings from Switzerland Gert Franz Railo Technologies GmbH [EMAIL PROTECTED] www.railo.ch Join our Mailing List german:http://de.groups.yahoo.com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 gary gilbert schrieb: Railo also has a free community edition, it has some limitations but I am sure if you contact them and indicate that you would like to use it in a teaching environment they may give you a version upgrade. You can see the details at http://www.railo-technologies.com/en/index.cfm?treeID=148 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Service Issue , pls help
Vishnu, Do you already have any current code that you are using? Your request is not completely clear, but based on what I am 'assuming', you want to know how you can invoke the java web service and retrieve the attachment from the soap response. I *think* you could do this with CFHTTP. CFHTTP can retrieve binary data by specifying getAsBinary=yes in the CFHTTP call. So your call might look something like this: cfhttp url={url to web service here} getAsBinary=yes path={path to folder where you want to store binary file here} filename={filename you want for image} ...any other attributes you need your cfhttpparam tags, if needed /cfhttp After you do that, you should then be able to retrieve the file a number of ways: 1. if you just want to display the file, and it is in your web root: img src={path and filename of the image you retrieved} 2. If you want to display the file, and it is not in your web root: cfcontent ... (can't remember the parameters right now, but you can check the docs) 3. If you want to move the file somewhere, then use: cffile action=move source={path and filename of image you retrieved} destination={new destination} If this is not what you are looking for, please describe in more detail exactly what you are trying to do with the data returned from the web service and post any code you may already be using. Sincerely, Dave Phillips -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 9:01 PM To: CF-Talk Subject: Re: Web Service Issue , pls help how to get the attachment from soap response and use it in coldfusion Could you please provide with a code snippet? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a database with repeated information
Another option, which makes ColdFusion even better. Is one page acting as a template, then you could write a custom tag to reformat the data the way you want. If that manes loading a template to designate a layout as well. It can be refactored to minimal code. Agreed Melissa if you are new, try googling as well. The reason being is that you just may luck out, and find someone who may have blogged something similar. But Ben's books are almost a must when you learning the way you can do one thing so many ways:-) Hope that helps. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, 18 August 2008 11:37 PM To: CF-Talk Subject: RE: Creating a database with repeated information Melissa, This is exactly what ColdFusion is designed to do. You will have ten separate .cfm files and each of the files represents one of your 10 pages. Whatever information is 'static' for each page (in other words, whatever information stays the same for every state) can be hardcoded into the .cfm file. Anything that is dynamic (can be different for each state) should be referenced in the database. There are a number of ways to accomplish this (as just about anything in ColdFusion can be done different ways) so you might get different ideas on here from other people, but you can simply pass a 'url' parameter called 'state_id' or something like that that references a unique column in your database and that represents the state. Then you will have a cfquery tag at the top of each of your .cfm pages that pulls the necessary 'dynamic' information from your database for each state. Finally, when you want to display dynamic information from the query, surround your output with a cfoutput tag and your queryname and column names with # signs like this: Welcome to cfoutput#qMyQuery.state_name/cfoutput Something like that. I recommend starting simple, with just creating your first page that displays the dynamic 'welcome to' message and then you can build it up from there. Dave -Original Message- From: Melissa Cope [mailto:[EMAIL PROTECTED] Sent: Monday, August 18, 2008 8:25 AM To: CF-Talk Subject: Creating a database with repeated information Let's say you're making a MySQL database-driven website for states and each state will originally be set up with the same ten pages worth of information. (All states will have a home page saying Welcome to our state, all will have a contact page saying Contact our state, etc.) Obviously each state will want to personalize their pages through a self-administration interface (being able to change their home page to Welcome to Rhode Island and adding information about historic sites, for example) so each state will have to have its own entries in the database for each page. Which means you're looking at 500 entries to set up. Is there a way to create the original ten entries, then somehow loop through the next 49? I certainly hope so. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
onTap Framework FAST Installation videos
Just published two new videos on the onTap Framework's new official site http://on.tapogee.com showing the framework's drop-in architecture and the plugin store. These two things are very similar to announcements made by Gert Franz from Railo about their plans for an appstore and Ray Camden's comments about working on a drop-in architecture for Broadchoice, the company that's been hiring so many well-known advanced CF programmers like Sean Corfield and Joe Rinehart recently. Have the onTap framework plus ORM and other plugins installed and running inside of 5 minutes, with no coding. And no webserver mapping (re: FarCry). Sorry for the video quality -- this is my first time publishing my own video. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 781.769.0723 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(ot) SQL question...
Hello all. I'm looking to output the total number of entries, grouped by source from 3 tables. I'd like to modify the sql below so that each source shows up only once, yet tablulates the totals from all of the tables. Any ideas. Thanks, Che. --- select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source order by total desc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SVN in Production
Took me to literal.. too literally ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) SQL question...
Che, Try this: SELECT count(total) as sourcetotal, source FROM ( select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source ) GROUP BY source ORDER BY source DESC Sincerely, Dave Phillips http://www.dave-phillips.com -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 9:11 AM To: CF-Talk Subject: (ot) SQL question... Hello all. I'm looking to output the total number of entries, grouped by source from 3 tables. I'd like to modify the sql below so that each source shows up only once, yet tablulates the totals from all of the tables. Any ideas. Thanks, Che. --- select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source order by total desc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
Out of curiosity what do you plan on using for textbooks? On Mon, Aug 18, 2008 at 2:49 PM, Pete Ruckelshaus [EMAIL PROTECTED]wrote: I teach High School computer science at a public high school in Southeastern Pennsylvania. I was able to get a section of Web Programming added as a new class in addition to the Web Design and Computer Science (mainly Java with some SQL). Unfortunately, I wasn't able to see if the change was official until I got my class schedule late last week; first day of classes is next Monday. Anyway, I was planning on teaching ColdFusion fro my web programming class; it's a logical choice (to me) and a great way to acquaint students with programming fundamentals...and also create as many CF converts as possible :P I talked district IT into giving me my own server for my web design and web programming classes, and now I need a (free) CF engine; desktop security policy would make it difficult to run IIS and CF Dev Edition on the student desktops. Does anyone know what the policy will be for the free for academic licensing for CF9? Is it limited to colleges and universities, or can primary and secondary schools use that licensing scheme as well? How will one apply for such a license? And, finally, does Adobe have any such program for CF8? I'll install BlueDragon if I have to, but would prefer to run with CF8 until CF9 becomes available. If someone from Adobe wants to contact me directly, feel free to do so. I also realize that some of this info might be covered by NDA, and I don't want to get anyone in trouble. Thanks, Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SVN in Production
Andrew, A statement like this means you are not very good at your job. Brian's quite good at his job. I work with him. its a manual process to update and merge changes. Manual within the development branch - there shouldn't be any outstanding conflicts in anything tagged for QA, staging, or production. Brian, if you have been developing and using SVN heavily and making minor changes to websites as explained there is no way in hell I would employ you if you told me what you said below. I'm late showing up here - are you arguing that eyeballing a diff in a desktop tool (Beyond Compare?) is a superior deployment method to the near-industry-standard process of tagging, using Ant to build a production tag then deploy? You'd rather introduce a manual process that can't be auditing, doesn't produce verifiable results, and can be re-run? -Joe ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) SQL question...
Che, Well you could it inline... something like Select sum(t.total) as total, t.source FROM ( select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source ) t Group by t.source Order by total ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFC Best Practices
This is more of a how would you do it question. I have a simple set of queries that are currently inside an cfif statement, the if block inserts a record, grabs the id of the just inserted record, and there's an optional update that runs if some one else is entering there record. I know I can just dump the queries into a function and it'll work... But would I be better served by creating separate functions and call the last two from inside the insert function? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Details on CF9's free for academic licensing?
blank_stareTextbooks? What are those?/blank_stare -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 9:17 AM To: CF-Talk Subject: Re: Details on CF9's free for academic licensing? Out of curiosity what do you plan on using for textbooks? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) SQL question...
Mark/Dave... thanks so much. That worked perfectly! -Original Message- From: Mark Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 10:19 AM To: CF-Talk Subject: RE: (ot) SQL question... Che, Well you could it inline... something like Select sum(t.total) as total, t.source FROM ( select count(*) as total, source from listings group by source union all select count(*) as total, source from speclistings group by source union all select count(*) as total, source from psportlistings group by source ) t Group by t.source Order by total ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
Good afternoon everyone, And how about non-profit organizations that host education-related Web sites on their servers. Our group is preparing to upgrade our hardware to support additional Web development tools. I've been talking to the Sysop about adding ColdFusion. I mentioned that CF8.0 is the latest version he could make available to developers wishing to use it. Thanks for any feedback. Peter Donahue Peter, I used to work for a non-profit as well. According to Adobe it was considered an educational institution. Chances are your organization would be considered to be the same. Also you may want to look at some of the open source CF engines. That may provide an alternative if funding is tight. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
Those things students lug around in backpacks. I just wondered how one goes about teaching CF in a school, if they make up the entire curriculum or if something actually exists for the schools to use. On Tue, Aug 19, 2008 at 9:23 AM, Andy Matthews [EMAIL PROTECTED]wrote: blank_stareTextbooks? What are those?/blank_stare -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 9:17 AM To: CF-Talk Subject: Re: Details on CF9's free for academic licensing? Out of curiosity what do you plan on using for textbooks? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311256 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 injection attack on House of Fusion
Hello folks: I am sorry about the thread jump here, but any ASP gurus out there on this discussion list? In the past week, I have been fanatically patching our old CF code and applying CFQUERYPARAM wherever it applies. Additionally, I also implemented the SQL Injection Blocker written by Gabriel and Mary Jo. It is extremely helpful. However, a big chunk of our old application is written in ASP. It was an off-the-shelf content-mangement-system which we plan to replace soon. I have no experience with ASP, but from the database being hit, it is pretty certain that the injection must have come through the ASP code. Is there a quick-and-dirty fix for ASP code regarding this sql injection? Has anybody written the SQL injection blocker function in ASP? What is the ASP equivalent of CFQUERYPARAM? BTW, I know that another effective method would be to install a Web Server injection filter--but that is not within my control and the only thing I can do now is on the code side. Thanks and any help will be most appreciated! Qing Xia On Sun, Aug 17, 2008 at 12:43 PM, Jochem van Dieten [EMAIL PROTECTED]wrote: denstar wrote: On Sun, Aug 17, 2008 at 2:08 AM, Jochem van Dieten wrote: denstar wrote: On Sat, Aug 16, 2008 at 6:15 AM, Jochem van Dieten wrote: I haven't mentioned this before because I do believe that filtering request URLs is the wrong approach Care to elaborate on this? Filtering means allow unless it matches. A security measure should be deny unless it matches. Or maybe you've got a simple solution, to how one would limit URL requests to only allowable values? I don't think simple solutions exist. The closest I have seen that still was simple yet appeared to be somewhat effective was a company that did something akin to hungarian notation. They had all their variables typed like user_uuid and article_int and they did type / bounds checking in the webserver, throwing security errors on every type mismatch or occurence of a variable without the type declared. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating a database with repeated information
Perfect, that part with the getstates query is exactly what I was looking for! We already had a table with states and abbreviations made, so it saved having to do a 50-item cfswitch. Thank you all so much for your help! Ok so basically this is a query you want to run ONE time to get the initial data set into the database? I'm assuming you'd be putting the page content and title in later? I would do something as basic as... Select the states cfquery name=getstates select state, id from states /cfquery Loop through the query... cfloop query=getstates If you have 10 pages i would insert each here w/ in the query statement, which then will loop through all 50 states and add 10 pages for each. I'm going to assume you would later go back and add the content, page title etc. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311258 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 Best Practices
Separate methods might make sense if you need to do this from more than one method. If it is specific to that method it might not be worth breaking it up. Be aware though that inserting a record and then selecting the MAX id can result in an incorrect ID if more than one thread runs this code at the same time. You'd probably be better off getting the last inserted ID from the cfquery itself if you are on CF8, or looking at using a native database function like scope_identity() (the actual function varies across platforms). A bit more can be found here: http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values On Tue, Aug 19, 2008 at 10:22 AM, Scott Stewart [EMAIL PROTECTED]wrote: This is more of a how would you do it question. I have a simple set of queries that are currently inside an cfif statement, the if block inserts a record, grabs the id of the just inserted record, and there's an optional update that runs if some one else is entering there record. I know I can just dump the queries into a function and it'll work... But would I be better served by creating separate functions and call the last two from inside the insert function? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311259 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 Best Practices
Be aware though that inserting a record and then selecting the MAX id can result in an incorrect ID if more than one thread runs this code at the same time. You'd probably be better off getting the last inserted ID from the cfquery itself if you are on CF8, or looking at using a native database function like scope_identity() (the actual function varies across platforms). Good point to ponder... Brian Kotek wrote: Separate methods might make sense if you need to do this from more than one method. If it is specific to that method it might not be worth breaking it up. Be aware though that inserting a record and then selecting the MAX id can result in an incorrect ID if more than one thread runs this code at the same time. You'd probably be better off getting the last inserted ID from the cfquery itself if you are on CF8, or looking at using a native database function like scope_identity() (the actual function varies across platforms). A bit more can be found here: http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values On Tue, Aug 19, 2008 at 10:22 AM, Scott Stewart [EMAIL PROTECTED]wrote: This is more of a how would you do it question. I have a simple set of queries that are currently inside an cfif statement, the if block inserts a record, grabs the id of the just inserted record, and there's an optional update that runs if some one else is entering there record. I know I can just dump the queries into a function and it'll work... But would I be better served by creating separate functions and call the last two from inside the insert function? -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research amp; Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311260 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 Best Practices
You can generally avoid the problem with a cftransaction tag if you're doing the MAX(id) thing, but the other solutions are better (especially the new CF8 goodies which, for example, are a life saver for Oracle). On Tue, Aug 19, 2008 at 11:12 PM, Scott Stewart [EMAIL PROTECTED] wrote: Be aware though that inserting a record and then selecting the MAX id can result in an incorrect ID if more than one thread runs this code at the same time. You'd probably be better off getting the last inserted ID from the cfquery itself if you are on CF8, or looking at using a native database function like scope_identity() (the actual function varies across platforms). Good point to ponder... -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311261 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 Best Practices
James Holmes wrote: You can generally avoid the problem with a cftransaction tag if you're doing the MAX(id) thing, but the other solutions are better (especially the new CF8 goodies which, for example, are a life saver for Oracle). I've tried using the result.identitycol trick with CF8 and MSSQL and for me, it doesn't work. I just get an error. So what I've stuck to is this... Before the first insert, I do cfset now = Now() Then in the insert, for my date_added value, I use #now#. Then after that, when I do my select MAX(id), I also add where date_added = '#now#' AND I also wrap the whole thing in a cftransaction... Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311262 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 Best Practices
While it probably won't happen often, depending on load, even the Now() logic can result in two records with the same value if they come in at the same time. And cftransaction will only work if you go all the way to serializable for isolation level, which essentially single-threads access and, again depending on how often the query is run, can be a performance issue. If this query isn't hit a lot by multiple threads none of this may be an issue, but it is definitely something that must be kept in mind. On Tue, Aug 19, 2008 at 11:26 AM, RobG [EMAIL PROTECTED] wrote: James Holmes wrote: You can generally avoid the problem with a cftransaction tag if you're doing the MAX(id) thing, but the other solutions are better (especially the new CF8 goodies which, for example, are a life saver for Oracle). I've tried using the result.identitycol trick with CF8 and MSSQL and for me, it doesn't work. I just get an error. So what I've stuck to is this... Before the first insert, I do cfset now = Now() Then in the insert, for my date_added value, I use #now#. Then after that, when I do my select MAX(id), I also add where date_added = '#now#' AND I also wrap the whole thing in a cftransaction... Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311263 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 Best Practices
Rob, if you are using MSSQL why don't you use @@IDENTITY? e.g. this crappy example... cfquery name=insertLocation datasource=#mydsn# INSERT INTO tblLocations ( address1, address2, address3, town ) VALUES ( cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.address1)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.address2)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.address3)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.town)#, ) SELECT @@IDENTITY AS locationID /cfquery #insertLocation.locationID# is then your last inserted item. (assuming tblLocations has an identity column that is) Cheers, Craig. -Original Message- From: RobG [mailto:[EMAIL PROTECTED] Sent: 19 August 2008 16:26 To: CF-Talk Subject: Re: CFC Best Practices James Holmes wrote: You can generally avoid the problem with a cftransaction tag if you're doing the MAX(id) thing, but the other solutions are better (especially the new CF8 goodies which, for example, are a life saver for Oracle). I've tried using the result.identitycol trick with CF8 and MSSQL and for me, it doesn't work. I just get an error. So what I've stuck to is this... Before the first insert, I do cfset now = Now() Then in the insert, for my date_added value, I use #now#. Then after that, when I do my select MAX(id), I also add where date_added = '#now#' AND I also wrap the whole thing in a cftransaction... Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311264 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 injection attack on House of Fusion
What is the ASP equivalent of CFQUERYPARAM? http://prepared-statement.blogspot.com/ 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SVN in Production
You'd rather introduce a manual process that can't be auditing, doesn't produce verifiable results, and can be re-run? Perhaps he's a contractor. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311266 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 Best Practices
On Tue, Aug 19, 2008 at 10:44 AM, Craig Dudley [EMAIL PROTECTED] wrote: Rob, if you are using MSSQL why don't you use @@IDENTITY? Just to be clear, @@identity returns the most recent inserted id of all tables. So if you had a trigger that when a table gets an insert, another table also gets an insert, @@identity would return the triggered table ID. For SQL 2000 +, look at SELECT SCOPE_IDENTITY() or SELECT IDENT_CURRENT('tablename'). http://www.sqlteam.com/article/alternatives-to-identity-in-sql-server-2000 I've seen other good blog entries / articles about this, but couldn't locate them at the moment. -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311267 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 Best Practices
Actually if you are using MSSQL 2000 or 2005 or up, you should be using VALUES(); SELECT SCOPE_IDENTITY() AS id -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2008 11:45 AM To: CF-Talk Subject: RE: CFC Best Practices Rob, if you are using MSSQL why don't you use @@IDENTITY? e.g. this crappy example... cfquery name=insertLocation datasource=#mydsn# INSERT INTO tblLocations ( address1, address2, address3, town ) VALUES ( cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.address1)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.address2)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.address3)#, cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#trim(form.town)#, ) SELECT @@IDENTITY AS locationID /cfquery #insertLocation.locationID# is then your last inserted item. (assuming tblLocations has an identity column that is) Cheers, Craig. -Original Message- From: RobG [mailto:[EMAIL PROTECTED] Sent: 19 August 2008 16:26 To: CF-Talk Subject: Re: CFC Best Practices James Holmes wrote: You can generally avoid the problem with a cftransaction tag if you're doing the MAX(id) thing, but the other solutions are better (especially the new CF8 goodies which, for example, are a life saver for Oracle). I've tried using the result.identitycol trick with CF8 and MSSQL and for me, it doesn't work. I just get an error. So what I've stuck to is this... Before the first insert, I do cfset now = Now() Then in the insert, for my date_added value, I use #now#. Then after that, when I do my select MAX(id), I also add where date_added = '#now#' AND I also wrap the whole thing in a cftransaction... Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311268 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 Best Practices
Interesting, never had a problem with @@IDENTITY though. It seems to me that unless you're using triggers, it's pretty much impossible for it to return the wrong value in a query like the example below. SCOPE_IDENTITY() certainly looks a little safer but I'm not worried about all my old code. Craig. -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: 19 August 2008 16:57 To: CF-Talk Subject: Re: CFC Best Practices On Tue, Aug 19, 2008 at 10:44 AM, Craig Dudley [EMAIL PROTECTED] wrote: Rob, if you are using MSSQL why don't you use @@IDENTITY? Just to be clear, @@identity returns the most recent inserted id of all tables. So if you had a trigger that when a table gets an insert, another table also gets an insert, @@identity would return the triggered table ID. For SQL 2000 +, look at SELECT SCOPE_IDENTITY() or SELECT IDENT_CURRENT('tablename'). http://www.sqlteam.com/article/alternatives-to-identity-in-sql-server-2000 I've seen other good blog entries / articles about this, but couldn't locate them at the moment. -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311269 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 Best Practices
Sandra Clark wrote: Actually if you are using MSSQL 2000 or 2005 or up, you should be using VALUES(); SELECT SCOPE_IDENTITY() AS id Okay, I just added this to my insert function, and got this: [Macromedia][SQLServer JDBC Driver][SQLServer]'SCOPY_IDENTITY' is not a recognized built-in function name. Here's the exact line: ); select SCOPY_IDENTITY() as newuserid /cfquery Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311270 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 injection attack on House of Fusion
Neat! Thanks Dave. On Tue, Aug 19, 2008 at 11:54 AM, Dave Watts [EMAIL PROTECTED] wrote: What is the ASP equivalent of CFQUERYPARAM? http://prepared-statement.blogspot.com/ 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311271 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 Best Practices
Try SCOPE_IDENTITY() instead of SCOPY_IDENTITY() Sandra Clark wrote: Actually if you are using MSSQL 2000 or 2005 or up, you should be using VALUES(); SELECT SCOPE_IDENTITY() AS id Okay, I just added this to my insert function, and got this: [Macromedia][SQLServer JDBC Driver][SQLServer]'SCOPY_IDENTITY' is not a recognized built-in function name. Here's the exact line: ); select SCOPY_IDENTITY() as newuserid /cfquery Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flash Site Links Sanity Check
Hi all, We're having reports of links not being clickable in a site: Take a look at this URL (which has been live for 3 years): http://www.mypersonalbrilliance.com Also, look at this URL (also live for 3 years): http://blog.mypersonalbrilliance.com For both sites, click a few of the links in the black bar at top, and the four floating links in the lights area at top. Clickable with redirection? Any problems? I've rechecked the crossdomain.xml file and inserted the eolas js fix from adobe (for the double click problem in IE). I can't find any issues (nor recreate the problem), but my client is having intermittent problems. We've tried it here and remotely on several machines, using WinXP - FF2, FF3, IE6 and IE7. Thank for your help. Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flash Site Links Sanity Check
Links work (IE 7 on WinXP SP3) but I could see how someone would want to click on the lights instead of clicking on the words beneath the lights. it's not as intuitive as it could be. Mark Leder wrote: Hi all, We're having reports of links not being clickable in a site: Take a look at this URL (which has been live for 3 years): http://www.mypersonalbrilliance.com Also, look at this URL (also live for 3 years): http://blog.mypersonalbrilliance.com For both sites, click a few of the links in the black bar at top, and the four floating links in the lights area at top. Clickable with redirection? Any problems? I've rechecked the crossdomain.xml file and inserted the eolas js fix from adobe (for the double click problem in IE). I can't find any issues (nor recreate the problem), but my client is having intermittent problems. We've tried it here and remotely on several machines, using WinXP - FF2, FF3, IE6 and IE7. Thank for your help. Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311274 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 Best Practices
William Seiter wrote: Try SCOPE_IDENTITY() instead of SCOPY_IDENTITY() D'OH! Man and I even went over it to be absolutely certain it wasn't something stupid. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
Ben Forta's original blog on this subject said that Adobe was planning on producing some curriculum. Later, he stated that might not happen after all. If Adobe isn't going to produce some workbooks or whatever, there has to be something the community can help put together. Any class room material we could get in print somewhere has to make teaching CF a more viable option in the eyes of the school. Minimally, we would want an outline for the course (say a semester worth), tests, code samples, etc. ~Brad - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 19, 2008 9:29 AM Subject: Re: Details on CF9's free for academic licensing? Those things students lug around in backpacks. I just wondered how one goes about teaching CF in a school, if they make up the entire curriculum or if something actually exists for the schools to use. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311276 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 injection attack on House of Fusion
Qing, when you use cfquery with cfqueryparam, a prepared statement is generated. So basically, you will be making ASP do the same thing CF does. CF just makes it easier. :) ~Brad - Original Message - From: Qing Xia [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 19, 2008 11:33 AM Subject: Re: SQL injection attack on House of Fusion Neat! Thanks Dave. On Tue, Aug 19, 2008 at 11:54 AM, Dave Watts [EMAIL PROTECTED] wrote: What is the ASP equivalent of CFQUERYPARAM? http://prepared-statement.blogspot.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
I generally create all of my own course materials, and refine them from class to class. I then publish them as PDF's that I have on my network drive at school (which students have read access to a portion of) and also publish them to my teacher web site via the school's web site publishing system. For my web programming class, I plan on having 2-3 weeks of condensed XHTML/CSS refresher (web design is a prerequisite), then cover JavaScript fundamentals for about a month, then a week or so of SQL, followed by basic server admin stuff and then the rest of the semester will be CF. Pete On Tue, Aug 19, 2008 at 10:16 AM, Aaron Rouse [EMAIL PROTECTED] wrote: Out of curiosity what do you plan on using for textbooks? On Mon, Aug 18, 2008 at 2:49 PM, Pete Ruckelshaus [EMAIL PROTECTED] wrote: I teach High School computer science at a public high school in Southeastern Pennsylvania. I was able to get a section of Web Programming added as a new class in addition to the Web Design and Computer Science (mainly Java with some SQL). Unfortunately, I wasn't able to see if the change was official until I got my class schedule late last week; first day of classes is next Monday. Anyway, I was planning on teaching ColdFusion fro my web programming class; it's a logical choice (to me) and a great way to acquaint students with programming fundamentals...and also create as many CF converts as possible :P I talked district IT into giving me my own server for my web design and web programming classes, and now I need a (free) CF engine; desktop security policy would make it difficult to run IIS and CF Dev Edition on the student desktops. Does anyone know what the policy will be for the free for academic licensing for CF9? Is it limited to colleges and universities, or can primary and secondary schools use that licensing scheme as well? How will one apply for such a license? And, finally, does Adobe have any such program for CF8? I'll install BlueDragon if I have to, but would prefer to run with CF8 until CF9 becomes available. If someone from Adobe wants to contact me directly, feel free to do so. I also realize that some of this info might be covered by NDA, and I don't want to get anyone in trouble. Thanks, Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
I'd be willing (and able) to play a role in this, and am willing to share my web design curriculum also (and take feedback on it). Anyone else who's interested, contact me off-list. I'm actually in the midst of writing a lesson-sharing document management system, have the domain and everything, but got sidetracked. Pete On Tue, Aug 19, 2008 at 1:11 PM, Brad Wood [EMAIL PROTECTED] wrote: Ben Forta's original blog on this subject said that Adobe was planning on producing some curriculum. Later, he stated that might not happen after all. If Adobe isn't going to produce some workbooks or whatever, there has to be something the community can help put together. Any class room material we could get in print somewhere has to make teaching CF a more viable option in the eyes of the school. Minimally, we would want an outline for the course (say a semester worth), tests, code samples, etc. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Database triggers stopped working in CF8
After upgrading to CF8, my insert triggers are no longer returning results to cfquery. I've tried the solution listed at http://www.adobe.com/go/kb402302, but my insert trigger still isn't returning any results to cfquery. This worked fine (and still does) with CF7, but doesn't work on our new ColdFusion 8 server. We're running CF 8.0.1.195765 and MS SQL Server 2005. The insert trigger is SELECT * FROM inserted Our CFML query code is: cfquery name=addContent datasource=cms result=qresult INSERT INTO content (content_name, content_type, content_parent_id, owner_contact_id, summary_text, allow_comments) VALUES ('image.jpg', 'B', 0, 29367, '', 0) /cfquery cfdump var=#qresult# cfdump var=#addContent# The qresult variable is set correctly, but addContent is undefined after the query executes (it should contain the record returned by the database trigger). Does anyone have any ideas why AlwaysReportTriggerResults=true isn't working or how I can get it to work? Thanks in advance for any help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
Awesome. Must be nice to have en entire semester! Since the classes I've been teaching are quarterly, I only provide for a week of basic HTML, and dive into CFML right away after that. The idea is to get the basics of CFML hammered in so that they can create basic web apps and also provide them with enough knowledge to expand and learn more on their own after the class is over. The final project for the class I teach is a web applications of their choice that contains form processing, session variables, and database integration of some sort. If they know those fundamentals, they can easily expand on it in any direction of their (or their employers) choosing. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Pete Ruckelshaus wrote: I generally create all of my own course materials, and refine them from class to class. I then publish them as PDF's that I have on my network drive at school (which students have read access to a portion of) and also publish them to my teacher web site via the school's web site publishing system. For my web programming class, I plan on having 2-3 weeks of condensed XHTML/CSS refresher (web design is a prerequisite), then cover JavaScript fundamentals for about a month, then a week or so of SQL, followed by basic server admin stuff and then the rest of the semester will be CF. Pete On Tue, Aug 19, 2008 at 10:16 AM, Aaron Rouse [EMAIL PROTECTED] wrote: Out of curiosity what do you plan on using for textbooks? On Mon, Aug 18, 2008 at 2:49 PM, Pete Ruckelshaus [EMAIL PROTECTED] wrote: I teach High School computer science at a public high school in Southeastern Pennsylvania. I was able to get a section of Web Programming added as a new class in addition to the Web Design and Computer Science (mainly Java with some SQL). Unfortunately, I wasn't able to see if the change was official until I got my class schedule late last week; first day of classes is next Monday. Anyway, I was planning on teaching ColdFusion fro my web programming class; it's a logical choice (to me) and a great way to acquaint students with programming fundamentals...and also create as many CF converts as possible :P I talked district IT into giving me my own server for my web design and web programming classes, and now I need a (free) CF engine; desktop security policy would make it difficult to run IIS and CF Dev Edition on the student desktops. Does anyone know what the policy will be for the free for academic licensing for CF9? Is it limited to colleges and universities, or can primary and secondary schools use that licensing scheme as well? How will one apply for such a license? And, finally, does Adobe have any such program for CF8? I'll install BlueDragon if I have to, but would prefer to run with CF8 until CF9 becomes available. If someone from Adobe wants to contact me directly, feel free to do so. I also realize that some of this info might be covered by NDA, and I don't want to get anyone in trouble. Thanks, Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
I've been teaching a CFML class at our local Community College here for the past couple years which I developed my own curriculum for. I set up a VPS with CF7/CF8 on it here at the Vivio Data Center and have the students FTP into it to do their course work. It's worked pretty well so far. I also talked with a few of the folks at Adobe at CFUnited (when they made this particular announcement) and offered to donate my curriculum to the cause if they needed. So far I haven't heard anything back from them about it - and I've emailed them a couple times since CFUnited. Perhaps I'm just not emailing the right person, I'm not sure. It's understandable if folks create their own curriculum, but an existing set would make for a nice starting point IMHO. If nothing else, I can wrap it up into a nice little package and offer it to the community as well. We'll see. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Brad Wood wrote: Ben Forta's original blog on this subject said that Adobe was planning on producing some curriculum. Later, he stated that might not happen after all. If Adobe isn't going to produce some workbooks or whatever, there has to be something the community can help put together. Any class room material we could get in print somewhere has to make teaching CF a more viable option in the eyes of the school. Minimally, we would want an outline for the course (say a semester worth), tests, code samples, etc. ~Brad - Original Message - From: Aaron Rouse [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 19, 2008 9:29 AM Subject: Re: Details on CF9's free for academic licensing? Those things students lug around in backpacks. I just wondered how one goes about teaching CF in a school, if they make up the entire curriculum or if something actually exists for the schools to use. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
I'd love to be a part of that. Teaching CFML to students is one of the primary keys to keeping the CFML alive, healthy, and growing - in my opinion. I was delighted with the announcement from Adobe about this effort, and let my contacts in the education industry know as soon as I could! It would be nice if Adobe had something official about this, but I guess Ben's blog is the next best thing eh? =P Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Pete Ruckelshaus wrote: I'd be willing (and able) to play a role in this, and am willing to share my web design curriculum also (and take feedback on it). Anyone else who's interested, contact me off-list. I'm actually in the midst of writing a lesson-sharing document management system, have the domain and everything, but got sidetracked. Pete On Tue, Aug 19, 2008 at 1:11 PM, Brad Wood [EMAIL PROTECTED] wrote: Ben Forta's original blog on this subject said that Adobe was planning on producing some curriculum. Later, he stated that might not happen after all. If Adobe isn't going to produce some workbooks or whatever, there has to be something the community can help put together. Any class room material we could get in print somewhere has to make teaching CF a more viable option in the eyes of the school. Minimally, we would want an outline for the course (say a semester worth), tests, code samples, etc. ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311281 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 Best Practices
;) William Seiter (mobile) Have you ever read a book that changed your life? go to: http://www.winninginthemargins.com and use passcode: GoldenGrove -Original Message- From: RobG [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: 8/19/2008 9:55 AM Subject: Re: CFC Best Practices William Seiter wrote: Try SCOPE_IDENTITY() instead of SCOPY_IDENTITY() D'OH! Man and I even went over it to be absolutely certain it wasn't something stupid. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
For anyone who's interested, I've created a Google group for ColdFusion Educators. The group can be found here http://groups.google.com/group/coldfusion-educators?hl=en If you're interested, feel free to request a group membership; this is the first group I've created and don't know what all of the optimal settings are, so for now I'll keep security a little tighter until I get the hang of things. Thanks, Pete ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Details on CF9's free for academic licensing?
Out of curiosity what do you plan on using for textbooks? On Mon, Aug 18, 2008 at 2:49 PM, Pete Ruckelshaus [EMAIL PROTECTED]wrote: How about issues of FAQU? They're much lighter than most textbooks and they give lots of practical information. :) Contact me... We may be able to work something out. Judith Dinowitz Editor-in-Chief Fusion Authority Quarterly Update ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311286 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 Best Practices
For MSSQL there's a native function to give you the id. In a CFQuery tag it works like this: cfquery name=Insert datasource=#variables.dsn# SET NOCOUNT ON INSERT into Tablename ( email, firstname, lastname ) VALUES ( cfqueryparam value=#email# cfsqltype=cf_sql_varchar/, cfqueryparam value=#firstname# cfsqltype=cf_sql_varchar/, cfqueryparam value=#lastname# cfsqltype=cf_sql_varchar/ ) SELECT Ident_Current('Tablename') as RecordID SET NOCOUNT OFF /cfquery The NOCOUNT thing prevents MSSQL returning messages that might cause the query to abort. The Ident_Current('tablename') gives you the ident of the latest insert in the current tablename. Because it's all done in a single CFQUERY, I do believe the table is automatically locked This is only a MSSQL solution but i've never had a problem with getting the ID this way, even on my highest volume sites. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Aug 20, 2008 at 1:26 AM, RobG [EMAIL PROTECTED] wrote: I've tried using the result.identitycol trick with CF8 and MSSQL and for me, it doesn't work. I just get an error. So what I've stuck to is this... Before the first insert, I do cfset now = Now() Then in the insert, for my date_added value, I use #now#. Then after that, when I do my select MAX(id), I also add where date_added = '#now#' AND I also wrap the whole thing in a cftransaction... Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's free for academic licensing?
I was asking more in regards of seeing if there was something pre-existing to put into a proposal to a professor to see if they would offer a class on it. I know some that do classes pretty much on Dreamweaver others on a PHP and so on. I do not think any of them would want to create an entire curriculeum though. On Tue, Aug 19, 2008 at 4:30 PM, Judith Dinowitz [EMAIL PROTECTED] wrote: Out of curiosity what do you plan on using for textbooks? On Mon, Aug 18, 2008 at 2:49 PM, Pete Ruckelshaus [EMAIL PROTECTED] wrote: How about issues of FAQU? They're much lighter than most textbooks and they give lots of practical information. :) Contact me... We may be able to work something out. Judith Dinowitz Editor-in-Chief Fusion Authority Quarterly Update ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web Service Issue , pls help
Hi Dave I dont have a web service code , i tried to access the public web serive from xmethod which return the image , but somehow its not working This is the web service http://www.xmethods.net/ve2/ViewListing.po?key=uuid:861CB6D3-1E2A-BA27-BDDE-E9FEF283E518 You may be able to cfcontent it directly - or you may need to store it as a file of the correct type and extension. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com Hi We have a java webservice which will return the image as a soap attachment and another web service which will return the image as a binary data How can we use the image return by the web service in coldfusion? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Service Issue , pls help
It would be a lot easier to respond if you provided some details. What is not working? Post some code. Do you get an error? If so, what does the error say? On Wed, Aug 20, 2008 at 9:50 AM, vishnu prasad [EMAIL PROTECTED] wrote: Hi Dave I dont have a web service code , i tried to access the public web serive from xmethod which return the image , but somehow its not working This is the web service http://www.xmethods.net/ve2/ViewListing.po?key=uuid:861CB6D3-1E2A-BA27-BDDE-E9FEF283E518 -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311290 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 Best Practices
To what CF8 goodies do you refer? I do everything in ORACLE (mostly using stored procs) but I haven't had a chance to do a deep dive into CF8 yet... Thanks! Warren Koch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Service Issue , pls help
Dude, Read the top right of the page. The domain is expired! flash-db.com expired on 07/26/2008 and is pending renewal or deletion Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: August-19-08 10:50 PM To: CF-Talk Subject: Re: Web Service Issue , pls help Hi Dave I dont have a web service code , i tried to access the public web serive from xmethod which return the image , but somehow its not working This is the web service http://www.xmethods.net/ve2/ViewListing.po?key=uuid:861CB6D3-1E2A-BA27-BDDE- E9FEF283E518 You may be able to cfcontent it directly - or you may need to store it as a file of the correct type and extension. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com Hi We have a java webservice which will return the image as a soap attachment and another web service which will return the image as a binary data How can we use the image return by the web service in coldfusion? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Service Issue , pls help
This web service works but not the below Working File cfset code = 0 cfset BarSize = 15 cfset ShowCodeString = true cfset Title = PrasadVishnu cfinvoke webservice=http://www.webservicex.com/barcode.asmx?WSDL; method=Code39 returnvariable=retVal cfinvokeargument name=code value=#code# cfinvokeargument name=BarSize value=#BarSize# cfinvokeargument name=ShowCodeString value=#ShowCodeString# cfinvokeargument name=Title value=#Title# /cfinvoke cffile action=write file=c:\Vishnufile.jpg output=#retVal# / Not working cffile action=write file=c:\Vishnufile.jpg output=#retVal# / cfset Mynumber = 0123 cfset ImageType = PNG cfinvoke webservice=http://www.flash-db.com/services/ws/barCodes.wsdl; method=doBarCodes returnvariable=retVal cfinvokeargument name=num value=#Mynumber# cfinvokeargument name=imgtype value=#ImageType# /cfinvoke cffile action=write file=c:\Vishnufile1.jpg output=#retVal# / Error Web service operation doBarCodes with parameters {imgtype={PNG},num={0123}} cannot be found. Thanks Vishnu It would be a lot easier to respond if you provided some details. What is not working? Post some code. Do you get an error? If so, what does the error say? On Wed, Aug 20, 2008 at 9:50 AM, vishnu prasad [EMAIL PROTECTED] wrote: Hi Dave I dont have a web service code , i tried to access the public web serive from xmethod which return the image , but somehow its not working This is the web service http://www.xmethods.net/ve2/ViewListing. po?key=uuid:861CB6D3-1E2A-BA27-BDDE-E9FEF283E518 -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com. au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web Service Issue , pls help
I believe this is the important piece of information: The image is base64 encoded so that it can easily travel via Soap. The user is required to decode it back to binary for display. You will probably need to ToBinary() the result to to turn the base64 back to a binary object. I would create an example call, but the webservice appears to require a username and password. I'm guess that the call to the web service will probably look something like this: cfset ws_response = createobject(webservice,http://www.flash-db.com/services/ws/barCodes.wsdl;).doBarCodes(username,password,123,JPG) ~Brad - Original Message - From: vishnu prasad [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 19, 2008 8:50 PM Subject: Re: Web Service Issue , pls help Hi Dave I dont have a web service code , i tried to access the public web serive from xmethod which return the image , but somehow its not working This is the web service http://www.xmethods.net/ve2/ViewListing.po?key=uuid:861CB6D3-1E2A-BA27-BDDE-E9FEF283E518 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Service Issue , pls help
Look at the WSDL. That method is expecting 4 parameters. You are only supplying two. message name=doBarCodes part name=usernametype=xsd:string/ part name=passwordtype=xsd:string/ part name=num type=xsd:string/ part name=imgtype type=xsd:string/ /message Error Web service operation doBarCodes with parameters {imgtype={PNG},num={0123}} cannot be found. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Service Issue , pls help
Yeah I've been messing with this and I have it working but only after writing my own WSDL to get around this error: org.xml.sax.SAXException: Found character data inside an array element while deserializing Anyway, use a username of any and password of any as per their PHP example. The change I made to the wsdl was to replace xsd:base64Binary with xsd:anyType and it works. The way to output the result to the user then becomes: cfinvoke webservice=http://your own version of the.wsdl method=doBarCodes returnvariable=doBarCodesRet cfinvokeargument name=username value=any/ cfinvokeargument name=password value=any/ cfinvokeargument name=num value=123456/ cfinvokeargument name=imgtype value=jpg/ /cfinvoke cfcontent type=image/jpegcfoutput#toString(ToBinary(doBarCodesRet))#/cfoutput On Wed, Aug 20, 2008 at 10:54 AM, Brad Wood [EMAIL PROTECTED] wrote: Look at the WSDL. That method is expecting 4 parameters. You are only supplying two. message name=doBarCodes part name=usernametype=xsd:string/ part name=passwordtype=xsd:string/ part name=num type=xsd:string/ part name=imgtype type=xsd:string/ /message Error Web service operation doBarCodes with parameters {imgtype={PNG},num={0123}} cannot be found. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Web Service Issue , pls help
Yeah, I received the same error trying dummy info but I hoped it was just an error related to having the wrong login info. That could be problematic if their WSDL isn't correct. ~Brad - Original Message - From: James Holmes [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, August 19, 2008 10:07 PM Subject: Re: Web Service Issue , pls help Yeah I've been messing with this and I have it working but only after writing my own WSDL to get around this error: org.xml.sax.SAXException: Found character data inside an array element while deserializing Anyway, use a username of any and password of any as per their PHP example. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311297 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 Best Practices
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_17.html result_name.ROWID; Oracle only. The ID of an inserted row. This is not the primary key of the row, although you can retrieve rows based on this ID. This means we can now insert a row and then query the DB on the ROWID to get the new PK (useful if the PK came from a trigger that incremented a sequence). Even works without a transaction. If you're using stored procs you have the RETURNING INTO clause at your disposal, so it may be less useful for you. On Wed, Aug 20, 2008 at 10:31 AM, Craigsell wrote: To what CF8 goodies do you refer? I do everything in ORACLE (mostly using stored procs) but I haven't had a chance to do a deep dive into CF8 yet... -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4