CAR file deployment Issue
Hi We are planning to migrate from Coldfusion Mx 6.1 to Coldfusion 8 While we deploying the CAR file created from MX 6.1 into Coldfusion , None of the SQL datasource is working . Log file containts the below erorr message Error occurred while updating datasources:tedy" "Error","jrpp-10","08/20/08","13:49:36",,"An error occurred while trying to encrypt or decrypt your input string: com.rsa.jsafe.crypto.dr: Could not perform unpadding: invalid pad byte.. " After adding this in JVM config below error occurs -Dcoldfusion.disablejsafe=true Complete JVM Args java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/flex/jars,{application.home}/../wwwroot/WEB-INF/cfform/jars -Dcoldfusion.libPath={application.home}/../lib -Dcoldfusion.disablejsafe=true An error occurred while trying to encrypt or decrypt your input string: Given final block not properly padded. " ~| 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:311299 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
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" 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: 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: http://your own version of the.wsdl" method="doBarCodes" returnvariable="doBarCodesRet" > #toString(ToBinary(doBarCodesRet))# 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. > > > > > > > > > > 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
Look at the WSDL. That method is expecting 4 parameters. You are only supplying two. 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
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: 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" 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
This web service works but not the below Working File http://www.webservicex.com/barcode.asmx?WSDL"; method="Code39" returnvariable="retVal"> Not working http://www.flash-db.com/services/ws/barCodes.wsdl"; method="doBarCodes" returnvariable="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
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: 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
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: 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: 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: CFC Best Practices
For MSSQL there's a native function to give you the id. In a CFQuery tag it works like this: SET NOCOUNT ON INSERT into Tablename ( email, firstname, lastname ) VALUES ( , , ) SELECT Ident_Current('Tablename') as RecordID SET NOCOUNT OFF 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 > > 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?
>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: 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: 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" 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?
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: 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" > 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?
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
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: INSERT INTO content (content_name, content_type, content_parent_id, owner_contact_id, summary_text, allow_comments) VALUES ('image.jpg', 'B', 0, 29367, '', 0) 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?
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
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: 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" 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?
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" 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: 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: 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
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: 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 > > >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
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
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 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: 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
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... INSERT INTO tblLocations ( address1, address2, address3, town ) VALUES ( , , , , ) SELECT @@IDENTITY AS locationID #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 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
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: 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: 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: CFC Best Practices
Rob, if you are using MSSQL why don't you use @@IDENTITY? e.g. this crappy example... INSERT INTO tblLocations ( address1, address2, address3, town ) VALUES ( , , , , ) SELECT @@IDENTITY AS locationID #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 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: 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 > > 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
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 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
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
" 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 & 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
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 & 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: 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 > >select state, id from states > > >Loop through the query... > > >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: 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: 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: > Textbooks? What are those? > > -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: 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: (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?
Textbooks? What are those? -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
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 & 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: (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
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: 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: (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: 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
(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
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
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 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 tag and your queryname and column names with # signs like this: Welcome to #qMyQuery.state_name 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
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: your cfhttpparam tags, if needed 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: 2. If you want to display the file, and it is not in your web root: (can't remember the parameters right now, but you can check the docs) 3. If you want to move the file somewhere, then use: 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: 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: 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?
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: 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 ~| 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?
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