Re: check validity of zip file with cfzip
Seamus, after several problems regarding open corrupted zip files I'm using this code to validate before open that: cfscript var local = {}; local.pathZip = arguments.pathZip; local.pathEXE = application.dir_exe '7z '; /cfscript cfset local.command = 'cmd /c ' local.pathEXE ' t ' local.pathZip cfset resposta = application.SystemCommand.execute( local.command ) cfif Len( Trim( resposta.errorOutput ) ) OR Len( Trim( resposta.executeError ) ) OR NOT Len( Trim( resposta.standardOutput ) ) cfreturn false /cfif cfif StructKeyExists( resposta, 'standardOutput' ) AND Len( resposta.standardOutput ) AND FindNoCase( 'Everything is Ok',resposta.standardOutput ) cfreturn true cfelse cfreturn false /cfif Do you need the 7-zip application installed in your server and SystemCommand CFC. Cheers Marco Antonio On Tue, Nov 20, 2012 at 9:12 PM, Seamus Campbell coldfus...@boldacious.comwrote: Is there any to check the validity of a zip file with cfzip. I can't see anything in the docs. The only way I could see was to do a cftry, but that seemed cumbersome. My problem is that I receive a zipped file from an external source, so need to be able to verify that it is a valid zip file Many thanks Seamus ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Reading a certain range of a file
cfflush(ie. interval=500) can't do that? On Wed, Mar 7, 2012 at 8:56 AM, Chad Baloga cbal...@gmail.com wrote: Does anyone know how I can read a certain byte range of a file. I am basically trying to read 1-500 bytes, 501-1000 bytes, etc then output each chunk with cfcontent. I have the cfheader code written for the content length but just need to figure out how to read a certain range of the file. Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Web Service Over SSL
Certman is your friend: http://certman.riaforge.org/ Cheers Marco Antonio On Wed, Mar 9, 2011 at 11:48 AM, Brian Polackoff bpolack...@gmx.com wrote: Hey everyone. I have run into the age old issue that Coldfusion JRE does not have included a ssl certificate (from GoDaddy) used on a remote CF system I have setup. I have read how to import the SSL into the JRE using keytool, however it requires restarting CF services which I do not want to have to do over and over again as I bring on more remote servers using SSL web services. Does anyone know of a SSL provider (verisign, thawt, entrust, etc.) that Coldfusion already has included with the JRE that comes with Coldfusion out of the box? Thanks! Brian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Web Service Over SSL
Yes Bobby. Another very good application is KeyTool GUI 1.7. With that is possible to insert a certificate in CF keystore without restart it. Google can help you to download that free application. Cheers Marco Antonio On Wed, Mar 9, 2011 at 1:48 PM, Bobby Hartsfield bo...@acoderslife.comwrote: Are you saying it allows you to add certs to the keystore without restarting CF? I don't see that anywhere. If that IS the case, it sure would save me a lot of trouble as well. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Marco Antonio C. Santos [mailto:marcoacsan...@gmail.com] Sent: Wednesday, March 09, 2011 11:44 AM To: cf-talk Subject: Re: Web Service Over SSL Certman is your friend: http://certman.riaforge.org/ Cheers Marco Antonio On Wed, Mar 9, 2011 at 11:48 AM, Brian Polackoff bpolack...@gmx.com wrote: Hey everyone. I have run into the age old issue that Coldfusion JRE does not have included a ssl certificate (from GoDaddy) used on a remote CF system I have setup. I have read how to import the SSL into the JRE using keytool, however it requires restarting CF services which I do not want to have to do over and over again as I bring on more remote servers using SSL web services. Does anyone know of a SSL provider (verisign, thawt, entrust, etc.) that Coldfusion already has included with the JRE that comes with Coldfusion out of the box? Thanks! Brian ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
In our company I found a solution to parse big XML files in ColdFusion applications: 1) using xml2csv(http://www.a7soft.com/xml2csv.html), a very fast application to convert XML to csv file; 2) with SQL Server BULK INSERT to insert in our database Using this approach reduced time in 100 times. Very fast. Cheers Marco Antonio On Thu, Feb 17, 2011 at 1:30 PM, Rick Faircloth r...@whitestonemedia.comwrote: No problem... I haven't done much with XML, myself, so I thought this presented a good opportunity to learn something new, too. Let us know how the solution you're working on pans out. -Original Message- From: Matt Robertson [mailto:websitema...@gmail.com] Sent: Thursday, February 17, 2011 9:42 AM To: cf-talk Subject: Re: Big XML files processing Really s-l-o-w. Solution? On Wed, Feb 16, 2011 at 8:08 PM, Rick Faircloth wrote: Perhaps this will be of some help. Thanks Rick, Interesting stuff. I don't work with xml so much so a lot of this is new, and I hate new :-). I haven't been a full-time programmer for a few years now so I haven't kept up with everything like I would have otherwise. I have a business trip today so I have to set this aside but I'm going to run Jochem's solution - which is presented darn near turnkey - as soon as I can tomorrow and see what happens. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342382 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: iText PDF signature
We're using iText-2.0.7.jar + javaLoader + CF 7 Std with success. Please take a look this code to insert an image and a description in your PDF signed: cffunction name=signPDF cfargument name=pathPDF required=yes cfargument name=pathPDFSigned required=yes cfargument name=pathArqPFX required=yes cfset var local = StructNew() cfset local.pathPDF = arguments.pathPDF cfset local.pathPDFSigned = arguments.pathPDFSigned cfset local.pathArqPFX = arguments.pathArqPFX cfif NOT CompareNoCase(local.pathPDF,local.pathPDFSigned) cfreturn false /cfif cfscript setReason='ACME Corporation'; setPassword='yourPFXPassword'; setLocation='Your City-State'; fullPathToPFXFile = local.pathArqPFX; fullPathToOriginalFile = local.pathPDF; fullPathToSignedFile = local.pathPDFSigned; string = createObject(java,java.lang.String); passwordSign = string.init(setPassword); keyStore = createObject(java,java.security.KeyStore).getInstance(pkcs12); privateKey = createObject(java,java.security.PrivateKey); inputStream = createObject(java,java.io.FileInputStream).init(fullPathToPFXFile); keyStore.load(inputStream, passwordSign.toCharArray()); keyStoreAlias = keyStore.aliases().nextElement(); privateKey = keyStore.getKey(keyStoreAlias, passwordSign.toCharArray()); chainArray = keyStore.getCertificateChain(keyStoreAlias); pdfReader = server[application.javaLoaderInit].create(com.lowagie.text.pdf.PdfReader).init(fullPathToOriginalFile); outStream = createObject(java,java.io.FileOutputStream).init(fullPathToSignedFile); pdfStamper = server[application.javaLoaderInit].create(com.lowagie.text.pdf.PdfStamper); pdfVersion = string.init(URLDecode('%00')).charAt(0); stamper = pdfStamper.createSignature(pdfReader, outStream, pdfVersion); signatureAppearance = stamper.getSignatureAppearance(); PdfSignatureAppearance = server[application.javaLoaderInit].create(com.lowagie.text.pdf.PdfSignatureAppearance); signatureAppearance.setCrypto( privateKey, chainArray, javacast(null, 0),PdfSignatureAppearance.WINCER_SIGNED); signatureAppearance.setReason(setReason); signatureAppearance.setLocation(setLocation); rectangle = server[application.javaLoaderInit].create(com.lowagie.text.Rectangle).init( javacast(float, 100), javacast(float, 100), javacast(float, 200), javacast(float, 200) ); signatureAppearance.setVisibleSignature( rectangle, javacast(int, 1), javacast(null, ) ); signatureAppearance.setCertificationLevel(signatureAppearance.CERTIFIED_NO_CHANGES_ALLOWED); stamper.close(); inputStream.close(); pdfReader.close(); outStream.close(); return true; /cfscript /cffunction Cheers Marco Antonio On Thu, Mar 11, 2010 at 7:12 PM, Chad Gray cg...@careyweb.com wrote: Hello, I am working with iText that comes with CF8 and I dont see these methods in com.lowagie.text.pdf.PdfSignatureAppearance setRenderMode setSignatureGraphic I want to create a signature in a PDF that has an image like this example code is doing: http://itextpdf.com/examples/index.php?page=exampleid=221 Anyone figured out how to get an image and description into a PDF signature? If I use the method setImage that is in the CF8 class the image is laid on top of the description and you cannot read it. Thanks, Cha ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best way to create an .xls file from a page
Another good option is jExcel integration: http://www.cfinsider.com/index.cfm/2008/1/3/Modify-Excel-Spreadsheets-with-ColdFusion-the-easy-way Cheers Marco Antonio On Tue, Oct 28, 2008 at 5:37 AM, Stephane Vantroyen [EMAIL PROTECTED] wrote: Hi, another possibility is to use the POI Utility you can find on Ben Nadel's page : http://www.bennadel.com/blog/865-POIUtility-cfc-Examples-For-Reading-And-Writing-Excel-Files-In-ColdFusion.htm Greets Stéphane I wouldn't say it is the *best* way but this will maintain table layouts: http://mgt.pastebin.com/f27bd1c5a Another way to do it is what Mike Chabot suggested. Yet another way: Create a spreadsheet and fill the places where you want your data to go with CF vars #.yourQury.yourVar# and then save as XML or HTML (I forget) and use the above method to populated it and force it to the browser. HTH ~G~ On Mon, Oct 27, 2008 at 3:14 PM, Brian Yager [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Execute a Perl script.
Ian, do you can try with systemcommand.cfc: http://systemcommand.riaforge.org/ It's a very good application when do you need to execute bat files. Cheers Marco Antonio On Mon, Oct 6, 2008 at 1:49 PM, Ian Skinner [EMAIL PROTECTED] wrote: Yeah I see now... I wasn't paying enough attention. Sorry I would try this. It has worked for me in the past... when I needed to pass custom vars to an executable I would write the bat file on the fly, save it and then run the bat file with CFexecute. HTH G Thanks, it looks like this idea will be workable. I was able to create a bat file and run it with cfexecute. So it looks like I may be up and running. I'll just have to get CF create this bat file. Now I just need to test what happens when I run multiple versions of this Perl script from multiple bat files. But I am still getting no results from the cfexecute... tag. The PERL script generates a ton of output. When I first ran my prototype bat file, it generated output. But I am getting none of this output out of the cfexectue... call? P.S. I am using the HOF web interface because I am getting almost none of my HOF content in my email!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Another open source CF CMS
Looks like very interesting: http://www.gosava.com/sava/ Cheers Marco Antonio ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: problems with cflocation and redirect will never complete.
Casey, my suggestion is to change your cflocation with Java redirect routine. Please try this: cfscript getPageContext().getResponse().sendRedirect(local.YourURL); /cfscript Cheers Marco Antonio On Fri, Apr 25, 2008 at 3:17 PM, Casey Dougall [EMAIL PROTECTED] wrote: Hi, I'm having troubles with a cflocation script. First Script finds the ID that it needs and then should perform a cflocation the the script that runs a process that generates an xml file. At that end of that script, it should do another cflocation back to the original script and find the next ID that needs and run through this process all over again. When I try running this in the browser, firefox returns the following. Firefox has detected that the server is redirecting the request for this address in a way that will never complete. I'm trying to select 1 ID at a time, run the process, then cflocation back to the original script and run again until it's finished but it only goes through 5 to 10 id's before I hit this error. Coldfusion Scheduled task didn't complete this as I had hoped either. Any ideas of how I can get around this issue. If you need to generate an XML file for 1000 ID's each may end up being 1 to 2 meg in size. This was the best way I could figure to get around script timeouts. Now I get Firefox has detected that the server is redirecting the request for this address in a way that will never complete. -- Casey ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AutoSuggest from a database query
Ali I'll suggest you to use jQuery. This javascript library haves very nice autocomplete examples: http://jquery.bassistance.de/autocomplete/ http://www.dyve.net/jquery/?autocomplete Dan G. Switzer creates this(with ColdFusion in server side): http://blog.pengoworks.com/index.cfm/2007/1/12/My-jQuery-Autocomplete-Mod Cheers Marco Antonio On Feb 16, 2008 7:53 AM, Ali [EMAIL PROTECTED] wrote: Hi: I know about CF autosuggest ability in a cfinput tag but I need to use an autosuggest in normal input tag (not cftinput) and I want to read the suggestion list from a database query. As a matter of fact I want to have something like the following code but with FORM/INPUT not CFFOMR/CFINPUT. What do you suggest? Something easy please. I am a newbie. Thanks Ali cfquery name=User datasource=#Request.DSN# SELECT * FROM Tbl_Users WHERE UserName LIKE '%#FORM.Search#%' /cfquery cfform name=form1 method=post action= div align=center cfinput type=text size=20 name=Search class=registrationForm_SRTL autosuggest=#ValueList(User.UserName)# br cfinput name=Submit type=submit class=registrationForm_SRTL value=ÌÓÊÌæ /div /cfform ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading Excel..
I like jExcel. You could try this simple script with jExcel(instantiated with javaLoader): !--- path to Excel sheet --- cfset filepath = C:\Inetpub\wwwroot2\tryExcel_CF.xls cfscript wfile = createObject(java,java.io.File).init(filepath); workbookPai = server.javaLoader.create(jxl.Workbook); wworkbook = server.javaLoader.create(jxl.write.WritableWorkbook); wworkbook = workbookPai.getWorkbook(wfile); sheetPai = server.javaLoader.create(jxl.write.WritableSheet); //get sheet named cf_xl_integration - change to the name in your workbook sheet = wworkbook.getSheet(cf_xl_integration); /cfscript cfset rowslen = sheet.getRows() cfset columnslen = sheet.getColumns() cfoutput cfloop from=0 to=#columnslen-1# index=c #sheet.getCell(javacast('int',c),0).getContents()# br / /cfloop /cfoutput Will need to download jExcel.jar and include in your directory for this script. Cheers Marco Antonio On Wed, Feb 13, 2008 at 10:54 PM, Jaime Metcher [EMAIL PROTECTED] wrote: Brian, I would also recommend POI with Ben Nadel's POIUtility, but if you want to stick with a DSN, the following includes a way to unlock the datasource: http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9 004033E03EF9http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9 No idea if it still works in CFMX 6/7/8. Jaime Metcher -Original Message- From: Brian Dumbledore [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 February 2008 2:05 AM To: CF-Talk Subject: Reading Excel.. I made the subject look easy so I can have more viewers ;) But here is my problem.. After having trouble with working cfx_Excel2Query ( I finally reverted to it in the end and got it working), I thought why not do this: 1) Create a odbc dsn to a excel file 2) Create a cf dsn to this odbc dsn 3) User uploads his file, I copy it as the file to which the dsn si specified. 4) I query the file using [sheet$1] as the table, and so on. This method works fine, however, sometimes (most of the times), it appears the file being used as the dsn gets 'locked'. I cann't delete, rename etc, 'next' upload of file fails to overwrite this file because it is locked. Basically this method is too inconsistent. My question is, is there anything I need to do to make sure the file is 'released' after the query has run? If this one thing is solved, I no longer have to use third party solutions, I can just create a dsn to the file and keep overwriting the file with the new file whenever. Any suggestions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using JavaLoader with UJAC creates memory leak
Tom, may be an OT but Mark Mandel recommends instantiate javaLoader in server scope. Please look this link: http://www.compoundtheory.com/?action=displayPostID=212 Cheers Marco Antonio On Feb 8, 2008 12:32 PM, Tom Chiverton [EMAIL PROTECTED] wrote: I am using JavaLoader to load the UJAC pdf generator: documentProperties=createObject('java','java.util.HashMap').init(); templateStream=createObject('java','java.io.FileInputStream ').init(generatedTemplate); documentPrinter=variables.loader.create('org.ujac.print.DocumentPrinter ').init(templateStream,documentProperties); resourceLoader=variables.loader.create(' org.ujac.util.io.FileResourceLoader').init(arguments.resPath); documentPrinter.setResourceLoader(resourceLoader); pdfStream=createObject('java','java.io.FileOutputStream').init(pdfPath); documentPrinter.printDocument(pdfStream,true); I can only run this template a dozen or so times before the CF8 server monitor siezes, having shown all memory exhausted, and the template starts returning 'GC overhead limit exceeded' errors. Doubling the max. JVM heap size in the CF template allows roughly twice the iterations before the same error. Copying the same .jar's to $cf_root/lib/ and using createObject('java',...) instead of JavaLoader has no such problems. Has anyone else seen this ? The URL for the issue at RIAForge is http://javaloader.riaforge.org/index.cfm?event=page.issueissueid=F96BA98D-EE10-66FB-3ED24750D78A87CE -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excel to Query
Richard, this is the link to download that scripts: http://bennadel.com/index.cfm?dax=blog:474.downloadcodezip Cheers Marco Antonio On Jan 31, 2008 12:23 PM, Richard White [EMAIL PROTECTED] wrote: hi marco have you or anyone else used this, this does look very interesting? thanks do you also know how we download it, thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excel to Query
Richard I'm using jExcel with CF. Running an example with column formatted works fine. Please look this text from an Excel spreadsheet: MATRIC NAME LOT VALUE 8545558 JUNIOR VARGAS RIO LUZ 1.522,25 (Brazilian values have a comma to hundred and point to thousand, ok?) This is the result after invoke jExcel(from CF): 8545558 | JUNIOR VARGAS | RIO LUZ | 1.522,25 In resume: jExcel maintains the same format. If you need more help I can send my simple code integrating CF with jExcel. Cheers Marco Antonio On Jan 31, 2008 1:13 PM, Richard White [EMAIL PROTECTED] wrote: thanks marco, will look at it now richard Richard, this is the link to download that scripts: http://bennadel.com/index.cfm?dax=blog:474.downloadcodezip Cheers Marco Antonio On Jan 31, 2008 12:23 PM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excel to Query
Richard, my jExcel integration with CF haves 1 year! I tried to send my code for you( [EMAIL PROTECTED]) but mail returns an error. Do you have another mail account? Cheers Marco Antonio On Jan 31, 2008 2:39 PM, Richard White [EMAIL PROTECTED] wrote: hi marco, thanks for this, it sounds good. just wondering if you are also using bens work or whether you have decided to use jexcel without his work and why, if you dont mind!!! just need to understand what you think seeing as you know both sides :) thanks a snip bit of code would be really useful if you could, thanks again for the help marco richard Marco Antonio On Jan 31, 2008 1:13 PM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excel to Query
Ben Nadel created a very nice cfc called POIUtility.cfc. This ColdFusion component works with POI to read/write excel spreadsheets. Please look this link: http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm Cheers Marco Antonio On Jan 28, 2008 6:56 AM, Richard White [EMAIL PROTECTED] wrote: Hi, we purchased a cfx called excel2query as we are developing an import facility that allows users to import data out of an excel document into the mysql database. we have to do it into a query as then we run various verifications on the data. however we have noticed that it gets the data that ms excel stores and not what it displays. for example, in excel someone may put integer values 1,2,3 etc... in a column then they use the format cell to display it how they want, e.g. they may format these integers to a number with 1 decimal point. we need to get these formatted values and not just what they entered first. does anyone know of anyway we can get ms excel to store the values it has formated or any other tag that converts ms excel data to a query and gets the actual displays value after formatting? thanks very much for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfprint... in CF7... exists?
Thanks Janet. This UDF is for CF8. That another suggestion(print.exe) could be a great start point. Cheers Marco Antonio On Jan 11, 2008 1:15 AM, Janet MacKay [EMAIL PROTECTED] wrote: Here is one suggestion Geez. I need to learn to read. I think this is closer to the mark. http://www.cflib.org/udf.cfm?ID=1782 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfprint... in CF7... exists?
CF8 haves a nice feature called cfprint. I'm using CF7 and looking for any routine porting cfprint(how to know printers in a network) to use in CF7. Anyone knows? Cheers Marco Antonio ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT sql question
Mark, I'll like to suggest you to use DataMgr. DataMgr is a great time saver tool and could be the answer to your needs. http://datamgr.riaforge.org/ Cheers Marco Antonio C. Santos On Jan 9, 2008 2:56 PM, Mark Fuqua [EMAIL PROTECTED] wrote: I think I need to be using 'IN' within my WHERE clause but I can't seem to get it to work. I have a column with a comma delimited list. This is the latest attempt and it craps out too. SELECT.. ...WHERE JobFileJob = #session.jobId# AND '#session.UserRole#' IN (JobFileAccessLevel) JobFileAccessLevel is a field in the database table that contains a comma delimited list of access levels. Maybe I'm barking up the wrong tree entirely. What I'm trying to do is. ..WHERE jobFileJob=#session.jobId# and jobFileAccessLevel CONTAINS '#session.UserRole#' But I don't think 'contains' exists. Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296275 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, Custom tag, or something for tedious SQL Queries?
George, I'll like to suggest you to use DataMgr. DataMgr is a great time saver tool and could be the answer to your needs. In your case just name your form fields with the same name in database and DataMgr will do the heavy work for you. http://datamgr.riaforge.org/ Cheers Marco Antonio C. Santos On Jan 9, 2008 3:33 PM, Jerry Guido [EMAIL PROTECTED] wrote: I use SQL.cfc. http://sqlcfc.riaforge.org/ It is MSSQL Server only. I ported it to MySQL... well sorta. It is CF8 only (CFDbinfo) at the moment, I haven't had the time to make it a pure SQL version nor has it been tested in a production environment. Let me know if you are interested and I can send you a copy. I also have a helper CFC that will combine form and URL vars (cookies and session vars too) into a single struct (takes a lot of the grunt work out of using SQL.cfc. I use transfer too but with SQL.cfc you can do all your Crud functions with one line of code. I used Squid head as well for quick cruds. Jerry Guido Programmer MGT of America, Inc. [EMAIL PROTECTED] The information contained in this electronic communication is intended only for the use of the addressee, and may be a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 12:13 PM To: CF-Talk Subject: Re: CFC, Custom tag, or something for tedious SQL Queries? Break up the form into forms? On Jan 9, 2008 11:56 AM, George Linderman wrote: Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE etc. However, many times the forms I develop are insanely long...so writing down all of the field names, and then their values every time I want to INSERT or UPDATE is a large source of pain for me. Do you know of any faster way of doing this? Perhaps with a CFC or something else? Or maybe there are some functions in coldfusion that do this faster? or should I just stop complaining and keep coding :) Thanks, George C. Linderman -- ~Todd Rafferty http://www.web-rat.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML Signature and CF
Taco, do you can send that class to sign XML to me? Cheers Marco Antonio Taco can you pass that class along I also have a requirement for this now on a single signon project. Thanks, Blaine Boyland Have you got a key that you need to sign with etc.? I should have a java class somewhere that allows you to create signatures. You can easily call it from CF or wrap it in a CFC. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF locks a file after read it using java.io.FileReader
Works fine now. Solution: After read that file I needed to close that connection: cfset fileReader.close() Cheers On 8/2/07, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: Hi all. This could be a CF 7 bug? After read a file using cfset fileReader = CreateObject(java, java.io.FileReader) cfset fileReader.init(arguments.pathToFile) I'll need to delete that file and recreate it with new content. But CF locks that file and doesn't allow to delete it. Any suggestions? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF locks a file after read it using java.io.FileReader
Hi all. This could be a CF 7 bug? After read a file using cfset fileReader = CreateObject(java, java.io.FileReader) cfset fileReader.init(arguments.pathToFile) I'll need to delete that file and recreate it with new content. But CF locks that file and doesn't allow to delete it. Any suggestions? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using CFFTP under proxy - proxy password missing
Hi all. How can I access a FTP server under a proxy. OK, ok: using proxyserver attribute, right? But where proxypassword enters? Whitout proxypassword is impossible to access a remote ftp server inside our intranet. Cheers ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC DAO/Bean Generator
Anyone know a good CFC DAO and Bean generator other than CFCCreator? Cheers ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using CFIF inside CFReport Builder
Thanks Dave. On 5/16/05, Dave Watts [EMAIL PROTECTED] wrote: it's possible to use CFIF statements inside CF Report Builder? I need to use CFIF's for control titles and display selected informations. It's possible? How to? You can use the IIf function instead of CFIF. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: right click submit options
I'll suggest to use Flash Forms with CFMX 7. Could be that very very easy. Cheers Marco On Tue, 8 Feb 2005 10:28:56 -0800, Tim Do [EMAIL PROTECTED] wrote: Hi All, I was wondering if its possible to right click a row and have multiple form submit options. I have a form which has many records being outputted. Each record has a radio button and the form has multiple submit buttons. Since the submit buttons are on top and bottom.. users have to scroll down and select the record they want and scroll up or down to submit. Is there a way to right click the row and have the submit options come up? Thanks, Tim ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193719 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Outsourced support to India?
MM helps the third world people with that. ;-) Cheers Marco On Tue, 8 Feb 2005 13:58:02 -0600, Ryan Kime [EMAIL PROTECTED] wrote: India? All joking aside, there are places in America where you can save labor costs. True, you won't get a PhD for $3.00/hr, but I digress. I have been waiting for an article like this to prove my point... Made in lower-cost America http://techrepublic.com.com/5100-10594_11-5567438.html?part=rsstag=feedsub j=tr# -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 11:46 AM To: CF-Talk Subject: RE: Outsourced support to India? Then you'll need to put an office in Jacksonville, Florida immediately! :P -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 10:01 AM To: CF-Talk Subject: Re: Outsourced support to India? Yes, I'm director of engineering for CF (development staff, QA staff, program management and engineering management). Like the Newton SF offices, the Bangalore office is no different...we have various positions in all the offices on various teams. It's all good...we have offices where the some of the world's best talent is at. Damon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
Hi Chuck Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are a good option for embeddable apps. And yes we're using PG for big apps and MySQL for smaller... PG is very very nice... Cheers Marco On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason [EMAIL PROTECTED] wrote: Robert - Do you use PostgreSQL as the database for any of your CF apps? If yes, how do you like it? I'm keeping my eyes open for a good portable database to use with CFEverywhere (http://www.sys-con.com/story/?storyid=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. Bob Everland ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191664 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Cloudscape/Derby
Hi Dave. Not. Yet!!! I'm waiting the 2nd part of Phil Cruz and Dick Applebaum article... ;-) Cheers Marco On Tue, 25 Jan 2005 05:55:54 -0500, Dave Merrill [EMAIL PROTECTED] wrote: Marco, do you have any experience using Cloudscape? With CF? If so, any comments on performance, features, stability? Setup hints for connecting w CFMX61? Thanks, Dave Merrill Portable? Or Embeddable? Postgre(30MB RAM space) and MySQL(50MB RAM space) may be Portable but Cloudscape(2MB RAM space), HSQLDB, etc are a good option for embeddable apps. And yes we're using PG for big apps and MySQL for smaller... PG is very very nice... Cheers Marco On Mon, 24 Jan 2005 17:14:27 -0600, Chuck Mason wrote: Robert - Do you use PostgreSQL as the database for any of your CF apps? If yes, how do you like it? I'm keeping my eyes open for a good portable database to use with CFEverywhere (http://www.sys-con.com/story/?storyid=47827DE=1) and intend on playing with Cloudscape a bit more (Cloudscape isn't something you jump right into without having reviewed the docs). Cheers! Chuck Robert Everland III wrote: What about PostgreSQL http://www.postgresql.org/ftp/ they just came out with a native win32 version. They have integrated stored procedures unlike MYSQL. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + MySQL Query Problem
GROUP_CONCAT works only for 4.1+ MySQL versions... http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html Cheers Marco On Tue, 14 Dec 2004 22:25:14 -0400, Jamie Price [EMAIL PROTECTED] wrote: Jamie Price wrote: SELECT o.UserID, GROUP_CONCAT(o.CardID) FROM mycards t INNER JOIN mycards o ON t.cardid = o.cardid WHEREt.trade = 1 AND o.own = 1 AND t.UserID = cfqueryparam value=#cUserID# cfsqltype=cf_sql_integer GROUP BY o.UserID Jochem I tried replacing my 2nd query with that code (the qGetMatches query) and got the following error: Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near apos;(o.CardID) FROM mycards t INNER JOIN mycards o ON t. The error occurred in C:\Websites\mtgotradingpos\traders\match3.cfm: line 43 41 : o.own = 1 42 : AND 43 : t.UserID = cfqueryparam value=#cUserID# cfsqltype=cf_sql_integer 44 : GROUP BY o.UserID 45 : /cfquery Keep in mind I'm using MySQL v4.0.18 as my database solution - would your code be compatible with that? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + MySQL Query Problem
OK Jamie you could migrate to PostgreSQL? Do that... Cheers Marco On Wed, 15 Dec 2004 09:46:18 -0400, Jamie Price [EMAIL PROTECTED] wrote: Simon - Here's the dumps - the GetMatches dump has never returned results for me (though it seems like it is doing something since it's outputting results) GetWantedCards Query - query CARDID USERID 1 41001101 7 2 41001102 7 3 41001151 7 4 41001152 7 5 41001153 7 GetMatches Query - query CARDID USERID If this is too confusing, you can see this 'live' by going here: http://www.mtgotradingpost.com/users/login.cfm username: yourmom password: yourmom Then goto Trading-Match (http://www.mtgotradingpost.com/traders/match.cfm) Thanks Marco for the MySQL info - if I hear one more report of you can't do that in 4.0, but 4.1 supports it I swear to God I will shoot myself. We don't have a 4.1 server up yet since there's not enough call for it (and no one wants to attempt a conversion) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Limiting SQL Results
SELECT blablabla FROM blabla GROUP BY ID Try... Cheers Marco On Mon, 13 Dec 2004 13:59:34 -, James Smith [EMAIL PROTECTED] wrote: Ok, heres the thing. I have a table (actually multiple tables joined but for simplicity here we will call it one table) that looks something like... ID ISBN -- 1 1 2 1 3 1 4 1 5 2 6 2 7 2 8 3 9 4 10 4 11 4 12 1 13 5 In the results I need no more than 2 of any ISBN, so for the above data I need the results of the query to look like... ID ISBN -- 1 1 2 1 5 2 6 2 8 3 9 4 10 4 13 5 The rest of thae data is irelevent, I don't care which two are returned. I am using MySQL on 2k3 server. Any help on the SQL here? -- Jay ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187408 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMX + MySQL Query Problem
Jamie what you need? Cheers Marco On Sat, 11 Dec 2004 21:25:39 -0400, Jamie Price [EMAIL PROTECTED] wrote: I know that this sounds like a pretty wild problem, but I would REALLY appreciate any help you guys could give - I've been putting my head through a wall for about two weeks trying to get this function right. If you need clarification on anything, just let me know. Thanks! ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFM almost finished
Thanks Rick for that very nice CF application. Integration with FCK will be very good. Best regards Marco On Thu, 9 Dec 2004 16:59:48 -0700, Paul [EMAIL PROTECTED] wrote: So Rick were you going to elaborate on integrating your CFFM with FCKEditor? I think several of us would be interested in how to do that... -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 4:51 PM To: CF-Talk Subject: Re: CFFM almost finished Marco Antonio C. Santos wrote: your page(http://www.webworksllc.com/cffm) give us 500 Error. It's possible to download CFFM once more? Bluedragon didn't come up automatically when I had my server rebooted this afternoon, and I didn't notice right away. It's all good now. - Rick ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: passing many variables between pages
Using SESSION structure could be the best answer for Tim questions... Best regards Marco On Fri, 10 Dec 2004 10:41:17 -0600, Aaron Rouse [EMAIL PROTECTED] wrote: One of our systems just creates a structure, with keys being the hidden field names and then they have their values. That is assigned to a session variable and then referenced by the pages you are navigating through. On Fri, 10 Dec 2004 16:23:52 +, Keith Gaughan [EMAIL PROTECTED] wrote: Mark Drew wrote: Serialise it into wddx, encode it to base 64, put it in hidden var cfwddx action=CFML2WDDX input=#FORM# output=theform cfset hiddenValue = ToBase64(theform) input type=hidden name=passthroughvals value=#hiddenValue# But then you have the awkward problem of deserialising it later on each page. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187033 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion security framework
http://tutorial67.easycfm.com/ Cheers Marco On Thu, 09 Dec 2004 20:11:19 +0100, The Wolf [EMAIL PROTECTED] wrote: Hi all, does anyone know any good ColdFusion security framework for implementing authentication and authorization (roles, permissions, etc.) available for download and customization? I found this article: Rethinking Roles-based Security http://www.halhelms.com/index.cfm?fuseaction=newsletters.showissue=052203_rolesBasedSecurity Unfortunately there is no sample code or database schema ... Thanks. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186884 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] Show number lines in Eclipse
Sorry by SOT. How to show line numbers in Eclipse Java Editor like Homesite or CF Studio? Cheers Marco ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186885 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: [SOT] Show number lines in Eclipse
Thanx Rob. Works fine now. Cheers Marco On Thu, 9 Dec 2004 11:39:07 -0800, Rob [EMAIL PROTECTED] wrote: WindowsPreferencesJavaEditor show line numbers check box. On Thu, 9 Dec 2004 17:31:24 -0200, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: Sorry by SOT. How to show line numbers in Eclipse Java Editor like Homesite or CF Studio? Cheers Marco -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFM almost finished
Rick your page(http://www.webworksllc.com/cffm) give us 500 Error. It's possible to download CFFM once more? Cheers Marco On Wed, 08 Dec 2004 09:13:38 -0500, Rick Root [EMAIL PROTECTED] wrote: Pascal Peters wrote: You can do it with a single regexp if you want: (^|[/\\])\s*\.+\s*($|[/\\]) I am assuming that for the last one, you actually wanted \.+$. If you really wanted \.+, you can just drop the first three. I also added \s* to make sure there wasn't a dot and a space, because I didn't know how you treated it later. Actually, the last one should've been ^\.+$ I was trying to match . and .. (and technically ..., , etc) I think I'm gonna leave it as the separate regex's for now... they're hard enough to read as it is :) - Rick ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186901 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT JavaScript and Firefox
Hi Fusetalk Forums uses dynarch calendar in your search form. Look this: http://www.macromedia.com/cfusion/webforums/forum/search.cfm and choose Start Date icon. Will open a very cool dhtml calendar. Cheers Marco On Tue, 7 Dec 2004 16:16:38 -0800, Rob [EMAIL PROTECTED] wrote: here is the coolest dhtml calendar (talked about many times on the list - very nice too) http://www.dynarch.com/projects/calendar/ heres the demo http://www.dynarch.com/demos/jscalendar/ Supported browsers » Internet Explorer 5.0+ for Windows » Mozilla, Netscape 7.x, Mozilla FireFox (any platform) » Other Gecko-based browsers (any platform) » Konqueror 3.2+ for Linux and Apple Safari for Macintosh » Opera 7+ (any platform) On Tue, 7 Dec 2004 14:39:51 -0800, Ian Skinner [EMAIL PROTECTED] wrote: ToolsJavaScript console - actually helpful JavaScript errors :-D (unless you like object expected) is onloadFunctions a function() or a variable? Well, both or course so that is the correct syntax. But you are correct, FF JavaScript debugger is very helpful, I really should remember it first! It showed me that another function being defined in the header of the page was malfunctioning in FF and aborting JS processing before the window.onload was reached. Now I just need a good Pop-up Calendar Date Picking Form Field Completion Aid that is not IE only!!! -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFFM almost finished
Beautyfull... Great Job Rick... congratulations!!! Cheers Marco On Tue, 07 Dec 2004 14:09:43 -0500, Rick Root [EMAIL PROTECTED] wrote: Okay, i think I'm almost done with CFFM - the Coldfusion File Manager I've added just about all the features I've seen suggested cleaned and organized the code, etc... I've added image manipulation (flip, flop, resize, scale), unzip / view zip, the ability to upload multiple files, file move, file copy, file delete, directory move, directory copy, directory delete (including non-empty directories). You can disallow certain extensions, and if you do, you can't create or upload files with those extensions, and files with those extensions will not be extracted from zip files. And it's all totally cross-platform compatible... at least, I've tested it on CFMX 6.1 on Windows and Bluedragon 6.1 on Linux. I'd love for anyone interested to attempt to compromise its security. http://www.webworksllc.com/cffm Thanks to all who contributed, knowingly and unknowingly :) I will certainly find this useful =) - Rick ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Mambo CMS server
Hi Aaron Mambo is a very good PHP open source CMS. We build an application using Mambo menu model with CF. Works fine with users/groups roles like Mambo. Only this. Cheers Marco On Wed, 8 Dec 2004 08:31:46 +1100, Aaron DC [EMAIL PROTECTED] wrote: Has anyone had any experience extending / embedding CF or PHP in Mambo? Wondering really if it's possible to do so. I'll look at the site but if someone already has some experience... Thanks Aaron Atomic Software http://www.atomic-software.com.au phone: +61 409 430 231 email: [EMAIL PROTECTED] ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186564 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OpenSource Calendar
Hi Mickael maybe this is the best web calendar on the web: http://dynarch.com/mishoo/calendar.epl Open source... Cheers Marco On Fri, 3 Dec 2004 07:50:37 -0500, Mickael [EMAIL PROTECTED] wrote: Hello All, I am donating some time to a charitable organization. They need a web calendar like the monthly view in Outlook. Were the day is broken down in 1 hour increments and those one hour slots can be booked. Is there something like that in CF available in opensource or something that is close that I can modify slightly to get working. Trying not to make this a big project so that it will not cost them anything. Thanks Mike ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WYSIWIG web editor for CF (FREE)
Russel www.fckeditor.NET rocks Cheers Marco On Fri, 3 Dec 2004 11:25:20 -0600, Russell Patterson [EMAIL PROTECTED] wrote: I am using fckEditor at several client sites. I am extremely please with it and so are my clients. I have customized it to fit their needs. I highly recommend it. The latest version appears to be even better, but I have not converted to that version yet. www.fckeditor.com Russell ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186129 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: HTM vs CFM Pages
Dave that speed penalty only occurs in the firts load page right? After that the compiled class file will load very fast... right? Cheers Marco On Thu, 2 Dec 2004 12:37:31 -0500, Dave Watts [EMAIL PROTECTED] wrote: When developing an entire website, I occasionally develop a page with no CF-specific content whatsoever (although it happens remarkably rarely). Is there any advantage or disadvantage to naming these pages with a HTM extension rather than a CFM extension? Is there a speed penalty? Yes, there is a speed penalty for CFM pages. Static files are much faster than CFM files, even if those CFM files don't actually contain program commands. If you don't want to incorporate some CF functionality into those pages, such as controlling access via Application.cfm, you're better off using a static file extension. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using COMMIT inside cfquery with MySQL give error
Hi all after insert a user record I need to show that same record to that user. But using SELECT statement in other cfquery don't show that user record. Please look this simple example: cfquery datasource=#application.dsn# name=insertuser INSERT INTO resourcebank ( userID,corpID,statusID,age1 ) VALUES (8EFACE46-795D-1267-34CB31AA6276B84F,17 ,1,37 ) /cfquery Insert works fine. By now I need to show user info: cfquery datasource=#application.dsn# name=getuserinfo SELECT userID,statusID FROM resourcebank WHERE userID = 8EFACE46-795D-1267-34CB31AA6276B84F /cfquery This query returns ZERO records inserting COMMIT after INSERT query don't work. How to refresh that connection to work like a charm? Cheers Marco ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Slideshow like on news.bbc.co.uk
Stuart please look this site: http://www.renatoimoveis.com/venda_detalhes.cfm?imovID=E117DE64-3472-FB8F-9FBE84A746D5F0D1 in the footer you could see a very nice slide show built with js and populate from CF. Click in iniciar to start the slide show. parar will stop, avançar and so on... If you need fast access to any image you could click in the select field located at the right side in slide show. Clicking in any image will open an new window with big image. If looks nice I could send that script to you. Cheers On Tue, 30 Nov 2004 06:23:44 -0500, Stuart Kidd [EMAIL PROTECTED] wrote: Dave, I looked into Flash Remoting for Coldfusion. There is an article at: http://www.macromedia.com/devnet/mx/coldfusion/articles/slideshow/slideshow.html I managed to get the first example to work but where it really counted, the one that also had descriptions could not for some bizarre reason. It just comes up blank. I'm hosted on a shared server and have been told that the component is installed. Should it be this hard or am i doing something wrong? Thanks, Stu From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 20:36:56 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Slideshow like on news.bbc.co.uk easy to do in java just look up free java slideshow on google then use your cfm output query as the images in the java personally its much easier to just do it in flash -- Original Message -- From: Stuart Kidd [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 28 Nov 2004 18:49:16 + Hi guys, I'm trying to make a slideshow, I was going to do it with an iframe but then I came across some problems with iframes how I needed to put a query not only on my main page, but also in my iframe as I realised that the iframe being another page isn't like an include. I'm not thinking that an iframe isn't the best way to go. On the bbc news website (http://news.bbc.co.uk/1/hi/in_pictures/4049765.stm) they have a good little system which works with javascript. Is there any easy way to do this with CF or will I need something client side? First I run a query and collect all the photoID's (from my photo table) which correspond to a particular article. Then I check to see if there is only one photo then I just output that, but if there is more than 1 then I put it into a slideshow. Any help would be appreciated. Thanks, Saturday ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185644 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Creating zip files on the fly without CreateObject
Hi all how to create zip files on the fly with CF and without use CreateObject statement? CFX_Zip could be an option but your price is proibitive... what you suggest? Cheers Win2K3 CFMX 6.1 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Backup MySQL DB... and restore ;-(
Hi all I want to backup my database to a file that is just like a SQL dump. With mysqldump I can do that. Easy. Then, I just want to be able to execute that .sql file when I need to restore my database... with CF... What do you think about? Cheers Marco ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: ERD for MySQL
Mark do you can test dbdesigner4, a open source MySQL modelling tool... http://www.fabforce.net/dbdesigner4/ Cheers Marco On Mon, 15 Nov 2004 10:23:42 +, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Mark Drew wrote: Does anybody use any fornt ends to mysql that allow you to do ERD's in the way the MS SQL Enterprise Manager works? Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data Studio et al), but something that I can visually design the tables and relationships with . If its for OS X the better! I use Charonware's CASE Studio. (http://www.casestudio.com) Its not the worlds greatest ERD modelling tool, but for your money it does the job nicely and has reverse engineering tools as a bonus. Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Plum Pre-Testers Needed
How to qualify Adam? Marco On Thu, 11 Nov 2004 20:33:21 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: I know...I know...prehistoric...it's true. I'm just so busy trying to make money with what I already know. I'm a freelancer, you know...no salary here... I noticed, too, that Plum doesn't support MySQL, which is what I use now...so that, too, knocks me out of the beta (or alpha...whatever...) Rick -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 8:19 PM To: CF-Talk Subject: RE: Plum Pre-Testers Needed rick throw whatever u currently think about automated app development out the window plum flat at kicks azz!! But u will need cfmx (i believe) but come on its 2004 almost 2005 cfml is a completely different animal now then it was in prehistoric 4.5 (thats older than i am!) get with the program my friend! ;) i would certainly go back and use plum again if and when they decide to add additional dbs like mysql -- Original Message -- From: Rick Faircloth [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 11 Nov 2004 19:54:38 -0500 I was a little ahead of you...I searched the HouseofFusion archives and found that link...looks interesting...and very involved... Hmmm...automated app development... Rick -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 7:43 PM To: CF-Talk Subject: Re: Plum Pre-Testers Needed Sorry... Look at this: http://www.productivityenhancement.com/plum/WhatPlumCanDo.cfm There's a demo link at the bottom of the page. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 11, 2004 7:41 PM Subject: RE: Plum Pre-Testers Needed Now...what did you say Plum is? Do I qualify? ;o) Rick -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 7:32 PM To: CF-Talk Subject: Plum Pre-Testers Needed We could use a couple of dedicated folks who haven't used an earlier Alpha or Beta release of Plum to run it through its tutorials before we release the Plum Public Beta. We need feedback from virgin users. Okay -- maybe not virgins. Make that people who have not been smitten with the wanton evil that Plum doth do. Anyway, we need you. If you're crazy enough to do this then please contact me offlist at [EMAIL PROTECTED] so we can discuss what's involved. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net
Re: Plum Pre-Testers Needed
Demo link? Yes, flash presentation. It's possible to download demo version? Cheers Marco On Thu, 11 Nov 2004 19:42:55 -0500, Adam Churvis [EMAIL PROTECTED] wrote: Sorry... Look at this: http://www.productivityenhancement.com/plum/WhatPlumCanDo.cfm There's a demo link at the bottom of the page. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Rick Faircloth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 11, 2004 7:41 PM Subject: RE: Plum Pre-Testers Needed Now...what did you say Plum is? Do I qualify? ;o) Rick -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 7:32 PM To: CF-Talk Subject: Plum Pre-Testers Needed We could use a couple of dedicated folks who haven't used an earlier Alpha or Beta release of Plum to run it through its tutorials before we release the Plum Public Beta. We need feedback from virgin users. Okay -- maybe not virgins. Make that people who have not been smitten with the wanton evil that Plum doth do. Anyway, we need you. If you're crazy enough to do this then please contact me offlist at [EMAIL PROTECTED] so we can discuss what's involved. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184072 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.2.1 - Release Date: 11/10/2004 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.2.1 - Release Date: 11/10/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[OT] Right Click Context Menu
Hi sorry by OT. Anyone has build applications with CF using right click context menu? It's possible to show howt to do that? Usability, client view, ... Thanx Marco ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
[SOT] DOS-like web application
Hi all I'm looking for examples about how to develop web applications when users will use only(first choice) keyboard like old Clipper/DOS applications. What's the pro's? And con's? Thanks Marco ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Where're PLUM????
How are the development state for PLUM? Beta, Alpha? We're anxious to take it in our hands!!! ;-) Cheers Marco ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cflogin - whats happened
Thanks Raymond sorry for the code... post only the needed for my question Please looks once more... !---application.cfm BEGIN --- CFAPPLICATION name=life sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,1,0,0)# applicationtimeout=#CreateTimeSpan(0,1,0,0)# clientmanagement=yes loginstorage=Session cflogin CFIF NOT IsDefined(cflogin) cfif (listlast(cgi.script_name,'/') neq 'loginform.cfm') AND (listlast(cgi.script_name,'/') neq 'lostpass.cfm') AND (listlast(cgi.script_name,'/') neq 'logincheck.cfm') AND (listlast(cgi.script_name,'/') neq 'show_attribs.cfm') CFHEADER name=window-target value=_top / cflocation url=#Application.url_begin#/loginform.cfm addtoken=no / cfabort / /cfif /CFIF /cflogin !---application.cfm END --- !---logincheck.cfm - loginform.cfm target BEGIN--- !---checks for login and pass--- !---login and pass OK--- !--sets Session.Vars--- /CFLOGINUSER HERE// /CFLOGINUSER HERE// /CFLOGINUSER HERE// cfloginuser name=#getPass.strUsersLogin# password=#getPass.strUsersPass# roles=#getPass.rolesID# /CFLOGINUSER HERE// /CFLOGINUSER HERE// /CFLOGINUSER HERE// /cflogin !---logincheck.cfm - loginform.cfm target END--- Thank you for your help. p.s.: using getAuthUser() show me the same error - var UNDEFINED ;-( On Sat, 30 Oct 2004 12:49:48 -0500, Raymond Camden [EMAIL PROTECTED] wrote: Your code is a bit hard to read, but it looks like you have two closing /cflogin tags. Also, you try to dump cfloginuser, but that isn't made anywhere from what I can see. If you want the current user, you run getAuthUser(). On Sat, 30 Oct 2004 12:43:44 -0200, Web Specialist [EMAIL PROTECTED] wrote: Hi all why my cflogin framework don't work? Please look my script: !---application.cfm BEGIN --- CFAPPLICATION name=life sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,1,0,0)# applicationtimeout=#CreateTimeSpan(0,1,0,0)# clientmanagement=yes loginstorage=Session cflogin CFIF NOT IsDefined(cflogin) cfif (listlast(cgi.script_name,'/') neq 'loginform.cfm') AND (listlast(cgi.script_name,'/') neq 'lostpass.cfm') AND (listlast(cgi.script_name,'/') neq 'logincheck.cfm') AND (listlast(cgi.script_name,'/') neq 'show_attribs.cfm') CFHEADER name=window-target value=_top / cflocation url=#Application.url_begin#/loginform.cfm addtoken=no / cfabort / /cfif /CFIF /cflogin !---application.cfm END --- !---logincheck.cfm - loginform.cfm target BEGIN--- !---checks for login and pass--- !---login and pass OK--- !--sets Session.Vars--- cfloginuser name=#getPass.strUsersLogin# password=#getPass.strUsersPass# roles=#getPass.rolesID# /cflogin !---logincheck.cfm - loginform.cfm target END--- Dumping cfdump var=#cfloginuser# gives me error: Variable CFLOGINUSER is undefined. What's happened? Looks all right... Thanx for your time. Web Specialist ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183000 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: synching local database with web
Good look Joe but how to 'sync that 2 DB using MM Central? Cheers Marco On Thu, 28 Oct 2004 15:50:01 -0400, Joe Rinehart [EMAIL PROTECTED] wrote: One thing you may want to look at doing is developing the salesperson app in Macromedia Central. It's made to do occaisionally connected apps like this. Cheers, Joe ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182915 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Survey Creation Application
Do you can show that survey tool? Maybe a link? Cheers Marco On Wed, 27 Oct 2004 18:37:51 -0400, Nick Cabell [EMAIL PROTECTED] wrote: I built a survey creation system for a non-profit using CF. It is fairly customized and has been very difficult. It allows a variety of clients to create their own surveys from a selection of questions, plus request additional questions. They can schedule release of the survey to end users on a weekly, biweekly or monthly basis. The results can be viewed graphically using CFCHART or individually by respondent. The clients are very excited to have this tool. I'd be happy to share experiences if that is any help to you. Nick Cabell 451 Learning Systems We're looking to make our own application that lets people create surveys - similar to Zoomerang (ww.zoomerang.com). We've played around with possible DB schemas and it just seems to get more and more complicated. I was wondering if any of you have tried implementing such an application, or if you would otherwise have any insight into the matter. It would need to let people do stuff like: - Add, edit, delete, move questions - Allow lots of different types of questions (ex: multiple choice, open ended, rating) - Arrange the questions across pages - Distribute the survey via links in emails, and track which response came from which email address - Generate reports based on the data collected We currently use Zoomerang - and think it works pretty well. We are looking for an alternative in-house solution so that we can put surveys into existing webpage templates. Thanks. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182860 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Application framework - examples
I'm looking for application frameworks for our CF application. Don't talk about CF application.cfm but models to construct navigations, menus like Farcry Admin, SmartCMS Admin, BlueShoes PHP framework, etc. Any examples? Thanx Marco ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182768 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Application framework - examples
Thanx Damien but I'm looking for application framework - design side - and don't CF application.cfm framework... More design side, like contract menu, Admin framework Do you know Farcry? Farcry haves a good application framework... Thanx. Marco On Wed, 27 Oct 2004 17:40:36 -0400, Damien McKenna [EMAIL PROTECTED] wrote: Marco Antonio C. Santos wrote: I'm looking for application frameworks for our CF application. Don't talk about CF application.cfm but models to construct navigations, menus like Farcry Admin, SmartCMS Admin, BlueShoes PHP framework, etc. What are your requirements? There are architectural frameworks like Fusebox, Mach-II which give you a loose structure to your code architecture, then there are some that also wrap content management into the equation, like some of the ones you mention. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
HTMLDOC - I'm looking for...
Yesterday open source, HTMLDOC now is paid. Anyone have ghtmldoc.exe previous version(1.8.23) to send for me? Thanx ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182071 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: HTMLDOC - I'm looking for...
Thanx Umer but htmldoc.org haves only source code files and I don't have C++ to compile that... htmldoc.exe 1.8.23 previous version was open source. But now moved to paid services. Cheers Marco On Wed, 20 Oct 2004 15:20:50 -0400, Umer Farooq [EMAIL PROTECTED] wrote: http://www.htmldoc.org/ Marco Antonio C. Santos wrote: Yesterday open source, HTMLDOC now is paid. Anyone have ghtmldoc.exe previous version(1.8.23) to send for me? Thanx ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182075 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: HTMLDOC - I'm looking for...
Great idea Marco On Wed, 20 Oct 2004 12:36:07 -0700, Bryan Stevenson [EMAIL PROTECTED] wrote: Try the Developer's Exchange at Macromedia...there are LOTS of tags that have bundled HTMLDoc.exe with them Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182077 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfm flash blog update
Great!!! Congratulations for that job... Impressive! Could be open source? Cheers Marco On Wed, 13 Oct 2004 04:16:04 -0400, dave [EMAIL PROTECTED] wrote: well its coming along thanks to Robert munn for all his hard work! michael, do you have a good logo we can throw on there? the basics are working, see at http://www.jamwerx.com/flashblog/cfmblog2/index.cfm roberts been converting all the php and i been tweakin the flash, css and gunna make it css xhtml valid. I been trying to convert all the queries to cfc's but Im sure one of u could do it better, if someone wants that part let me know :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating E-commerce application with CF
Look http://www.oscommerce.com/ - an PHP open source ecommerce application. Looks very handful, free and full featured... Cheers On Fri, 1 Oct 2004 17:20:46 -0500, Paul Giesenhagen [EMAIL PROTECTED] wrote: Consider purchasing a canned application and then customizing your required features in it. It is completely possible and depending on it's depth easy ... but you can save time if you go with a pre-built system. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Web Specialist To: CF-Talk Sent: Friday, October 01, 2004 5:13 PM Subject: Creating E-commerce application with CF Hi all this is my first ecommerce application with CF. What I need to build that app? How to build that app? SSL? Security, Credit Card processing. Thanx for any help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Change .cfm to .xxx - Legal or not?
Hi it's possible to change the CF extensions(.cfm) to .anything??? It's legal or not? What's the law point of view? And MM? Thanx Marco [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Change .cfm to .xxx - Legal or not?
Thanx Jim We're using W2K3 Server/IIS 6/CFMX 6.1 This link by Ben Forta is very cool http://forta.com/blog/index.cfm?mode=eentry=681 Thanx all Marco On Thu, 23 Sep 2004 19:54:28 -0400, Jim Davis [EMAIL PROTECTED] wrote: There is no legalities concerning this at all - you can change the extension to whatever you like. You would do this in the web server (not CF) - let us know what server you're using and somebody should be able to tell you how to change it.I've got an old article detailing how to do this in IIS 5 (and some reasons why you might want to) that I think is applicable to later versions of IIS (no promises): http://www.depressedpress.com/depressedpress/Content/Development/ColdFusion/ Articles/MultipleExtensions/Index.cfm Jim Davis _ From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 7:41 PM To: CF-Talk Subject: Change .cfm to .xxx - Legal or not? Hi it's possible to change the CF extensions(.cfm) to .anything??? It's legal or not? What's the law point of view? And MM? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CMS
Hard Farcry is very hard to install for beginners CFers... You need to learn before this is my impression... Cheers On Tue, 21 Sep 2004 10:00:53 -0500, Phill B [EMAIL PROTECTED] wrote: I'm taking a look at Farcry and it looks pretty cool. One question. How easy is it to implement Farcry in small portions on a web site? Phillip B [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion Calendar
Thanx Kristopher... Nothing yet... Only Calendars for MSSQL, Oracle, Access DB support and our site runs in MySQL... ;-( Do you have more details about your High School Courses Calendar? Marco On Mon, 20 Sep 2004 10:03:01 -0400, Kristopher Pilles [EMAIL PROTECTED] wrote: Did you find anything, I have a similar project coming up quite soon. KP -Original Message- From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 5:25 PM To: CF-Talk Subject: ColdFusion Calendar Is there an open souce Calender component available for ColdFusion MX? I'm looking for a CF Calendar for our Management High School Courses Application... Cheers Marco [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion Calendar
The problem is subselects, SP, triggers don't supported by our MySQL 4.0.13 version... Marco On Mon, 20 Sep 2004 13:09:02 -0400, Damien McKenna [EMAIL PROTECTED] wrote: Marco Antonio C. Santos wrote: Thanx Kristopher... Nothing yet... Only Calendars for MSSQL, Oracle, Access DB support and our site runs in MySQL... ;-( If the software is in source format just rewrite the database calls. .. one reason why I like PHP is the database abstraction layer ADOdb... -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion Calendar
;-))) All right Multiple queries is the easy kinda... SP, triggers... h... with MySQL On Mon, 20 Sep 2004 13:18:10 -0400, Damien McKenna [EMAIL PROTECTED] wrote: Marco Antonio C. Santos wrote: The problem is subselects, SP, triggers don't supported by our MySQL 4.0.13 version... Subselects - do multiple queries.The rest, yeah, kinda tricky.See if there are any that don't use those, that just use the database as a basic data store.. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion Calendar
Thanx Jordan great application Yes, we're have access to PG DB... How to get it? 'haves users restriction? Cheers Marco On Mon, 20 Sep 2004 10:26:13 -0700, Jordan Michaels [EMAIL PROTECTED] wrote: Do you have access to a PostgreSQL database? I can give you a free, 1-calendar copy of our own calendar software: http://calendar.viviotech.net/ It runs on a postgresql database and works with the free version of Blue Dragon. There are also a few things we have left to develop, but they are few. When it's complete, we are planning on giving away free versions of the software that only allow for one calendar to get created. Normally the software allows for an unlimited number of calendars, but hey, we have to get paid somehow right? =P Feel free to sign up and try it out. It could use some extra beta-testing. Let me know if you're interested. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] Marco Antonio C. Santos wrote: The problem is subselects, SP, triggers don't supported by our MySQL 4.0.13 version... Marco On Mon, 20 Sep 2004 13:09:02 -0400, Damien McKenna [EMAIL PROTECTED] wrote: Marco Antonio C. Santos wrote: Thanx Kristopher... Nothing yet... Only Calendars for MSSQL, Oracle, Access DB support and our site runs in MySQL... ;-( If the software is in source format just rewrite the database calls. .. one reason why I like PHP is the database abstraction layer ADOdb... -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Application Development using Cold Fusion in a Team Environment (Draft)
How to download Plum for testing??? On Mon, 20 Sep 2004 13:44:09 -0400, Adam Churvis [EMAIL PROTECTED] wrote: Have you selected a price point for Plum?If so, could you share it? Free. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Application Development using Cold Fusion in a Team Environment (Draft)
Congratulations Success... Cheers Marco On Mon, 20 Sep 2004 14:43:12 -0400, Adam Churvis [EMAIL PROTECTED] wrote: We're finishing the final Private Beta cycle right now.The first Public Beta cycle will start soon, and the commencement announcement and download instructions will be published through Fusion Authority. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! - Original Message - From: Marco Antonio C. Santos [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 20, 2004 2:06 PM Subject: Re: Web Application Development using Cold Fusion in a Team Environment (Draft) How to download Plum for testing??? On Mon, 20 Sep 2004 13:44:09 -0400, Adam Churvis [EMAIL PROTECTED] wrote: Have you selected a price point for Plum?If so, could you share it? Free. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ColdFusion Calendar
Is there an open souce Calender component available for ColdFusion MX? I'm looking for a CF Calendar for our Management High School Courses Application... Cheers Marco [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion to PDF
iText and FOP works fine with CSS and HTML4...XSL-FOP too... Cheers On Mon, 13 Sep 2004 15:41:16 -0400, Larry Lyons [EMAIL PROTECTED] wrote: Before I knew about the tag that's on Macromedia's exchange, I also wrote a custom tag to use HTMLDOC. It's free to use and open source here: http://calendar.viviotech.net/CreatePDF.txt From what I can tell, the functionality is pretty much the same. Just in case you wanted a tag where you could adjust the source as needed. =) Warm regards, Jordan thx Jordan I'll have a look at it. If it doesn't violate the NDA does anyone know whether the pdf generator in Blackstone will accept HTML4and CSS? One of the biggest drawbacks to HTMLDoc is that it only accepts HTML 3.2. thx, larry larry Larry Lyons wrote: -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF application navigation
Farcry haves an very nice application navigation(menu collapsible, tabs and so on). How to do applications like that? Do you have examples for me? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SpeckCMS
I also know that Speck has been used by non-programmers for content management requirements (apparently www.fashion.ie was built in a weekend by someone who didn't know any CF when he started). ... www.fashion.ie looks like built in with fuseaction and static content An CF newbie don't have all that know how to do any site like that. in a weekend... What's happened? Marco On Thu, 09 Sep 2004 11:56:09 +0100, Mark Woods [EMAIL PROTECTED] wrote: Hi, I noticed that during a recent thread regarding Farcry and SpeckCMS, not many people had heard of SpeckCMS (www.speckcms.com). So, I thought I'd provide a wee bit more info... Speck is an object-based open-source content management framework that was initially developed by Robin Hilliard (www.builderau.com.au/askexperts/macromedia/). I got involved in the development almost immediately after he released a rough alpha version in May 2002. Speck has been designed to be OS, web server and database independent and has been tested on both Windows and Linux, with IIS and Apache and Access, SQL Server, Oracle, PostgreSQL, Firebird and MySQL (4.1 required). It can also be used with CF5, as it is built using custom tags rather than CFCs. It is a stable solution, which has been used in production for about 2 years. Geoff Bowers mentioned that Speck is more of a toolkit than Farcry, and that is true - Speck was conceived as a framework. However, it is distributed with an example CMS (SpeckCMS) that provides a set of out-of-the-box content management capabilities. Farcry definitely does provide more for the end user out-of-the-box, but from my limited experience with it and vast experience with Speck (read: I'm biased ;), I'd have to say that I think Speck is simpler to extend to provide custom functionality. Our development team is not made up of highly experienced software engineers and is probably typical of many CF development teams, yet everyone in the team is confident using and extending Speck and they have even learnt something about OO development in the process (ok, I did have to give a few slaps to get the copy 'n' paste merchants to use inheritance, but corporal punishment is sometimes necessary ;). I also know that Speck has been used by non-programmers for content management requirements (apparently www.fashion.ie was built in a weekend by someone who didn't know any CF when he started). For the end user, we have found SpeckCMS to be a great success. We deal with business people and medial professionals who tbh just see technology as a necessary evil (and fair enough, they're probably right). SpeckCMS allows content to be edited in-context, i.e. the user just browses to the page they want to edit and clicks on the relevant edit link embedded into the content. I'm not sure if Farcry also allows this, but I know many other systems don't and we've found it to be a huge benefit that not only saves us a small fortune on training and support but really impresses the customers (ok, they are easily impressed, but perception is important). Well, I've rattled on for long enough - hope this has been informative Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT - farcry CMS
Thanx Kevin and Geoff I'll be there... On Mon, 6 Sep 2004 16:09:18 +1000, Geoff Bowers [EMAIL PROTECTED] wrote: - Original Message - From: Marco Antonio C. Santos [EMAIL PROTECTED] sorry for SOT... Anybody know how to run multiple sites inside only one Farcry installation? Multiple sites for one farcry installation?This is the standard way FarCry works. Send an email to [EMAIL PROTECTED] to jump on the FarCry developers mailing list -- plenty of help to get you going there. -- geoff On the road via GMail. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT - farcry CMS
Hi sorry for SOT... Anybody know how to run multiple sites inside only one Farcry installation? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Entire keyboard-based CF application
Thanx Jim With XForms I can do that? How? Sorry but WHAT's XForms? On Mon, 30 Aug 2004 19:39:40 -0400, Jim Davis [EMAIL PROTECTED] wrote: In pure HTML you would use the accesskey and tabindex attributes of form elements to allow simplistic keyboard management of forms.I'm not sure what's available in XFORMs yet, but I have to assume it's more advanced. Using script you can take things to the next level.The event bubbling model in IE makes a lot of this stuff insanely simple. I'm not sure sure why you would want to kill mouse applications, but again using the event bubbling model (IE only, I beleive) you can assign all of the mouse action handlers at the body level to return void or somesuch - the event taking place anywhere on the page will bubble up to the body and get handled there. Jim Davis From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] Sent: Monday, August 30, 2004 1:23 PM To: CF-Talk Subject: Entire keyboard-based CF application Hi I'm looking for how to develop an entire CF application keyboard-based. Gmail haves funcionalities like that. What's the secret? JS? Any example? How to kill mouse applications??? ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
For S.Isaak - onTap SES
Hi S. Isaak it's possible to use OnTap framework works with SES procedures? Cheers [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Farcry x SpeckCMS: The best CMS is....
OK Micha but inexpensive, free, cheap maybe only Farcry and SpeckCMS On Thu, 26 Aug 2004 08:22:39 +0200, Micha Schopman [EMAIL PROTECTED] wrote: There are more CMS systems written with CFML, do not forget PaperThin. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Open Source Poll Tag
iPoll ColdFusion Poll System is cool... Look in dev exchange cheers On Thu, 26 Aug 2004 10:06:42 -0500, Jake [EMAIL PROTECTED] wrote: Does anyone know of a good open source poll tag? I spent some time downloading and setting up a number of them I found on the MM Exchange and via Google, and was shocked at how bad some of them were. Most didn't function at all. Any pointers to good stuff would be much appreciated. At minimum, I'm looking for something un-encrypted and free. The best case is a open source version that I can use to integrate poll functionality into a couple of commercial apps. Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
New CF compiler
Look this site: http://www.railo.ch/en/about/index.cfm Railo is an CF compiler with several options. My firt impression looks nice... and stable too cheers [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: New CF compiler
No... Swiss railo.ch(Swiss) On Thu, 26 Aug 2004 13:57:36 -0700, Bryan Stevenson [EMAIL PROTECTED] wrote: Ya...it's from Germany or Holland...thus the lingo issues ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: C. Hatton Humphrey To: CF-Talk Sent: Thursday, August 26, 2004 1:34 PM Subject: Re: New CF compiler http://www.railo.ch/en/about/index.cfm The concept seems strangely familiar.translate a cfm page into a java classh.where have I seen that before.. :) Well they need to proofread their site: It is a budged-priced alternative You can compare Railo at best with JSP. JSP uses an other syntax but the main functionality is almost the same. Because Railo obeys most of the JSP interfaces, it is highly compatible to JSP. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: New CF compiler
heh... ;- On Thu, 26 Aug 2004 17:08:10 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote: Ahh... my bad. :) My international knowledge is all kinds of rusty. :) No... Swiss railo.ch(Swiss) On Thu, 26 Aug 2004 13:57:36 -0700, Bryan Stevenson [EMAIL PROTECTED] wrote: Ya...it's from Germany or Holland...thus the lingo issues ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: C. Hatton Humphrey To: CF-Talk Sent: Thursday, August 26, 2004 1:34 PM Subject: Re: New CF compiler http://www.railo.ch/en/about/index.cfm The concept seems strangely familiar.translate a cfm page into a java classh.where have I seen that before.. :) Well they need to proofread their site: It is a budged-priced alternative You can compare Railo at best with JSP. JSP uses an other syntax but the main functionality is almost the same. Because Railo obeys most of the JSP interfaces, it is highly compatible to JSP. Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
MSDE datasource
Hi MSDE is an free(true!!) DBMS based in SQL Server... 1Giga space, 10 max connections how to use with CFMX? It's possible? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Farcry x SpeckCMS: The best CMS is....
Do you have the answer? Two great CMS... Only one choice... Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Using Struts with CF
Anybody here develops CF apps with Struts MVC pattern? What's your impressions? Marco [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Flex and CF
Hi looking by the CF developer view what I can do with Flex resources? How to integrate it with CF? When Flex can help me? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Automated Scripts?
Create your CF script(search users in database, format email, bla, bla) and after setting your CF Admin Scheduler Tasks... will run fine On Mon, 23 Aug 2004 09:39:27 -0700, Richard Crawford [EMAIL PROTECTED] wrote: I'm trying to figure out how to run some Cold Fusion scripts automatically. For example: our users have logins that expire every three months.I'd like to set up a script which would run each morning to scan all of the users in the database, and send an e-mail to those users whose logins will be expiring in a week. I've looked through the CF Admin page, and haven't found any settings or anything which would set this up. -- Richard S. Crawford Programmer III: Oracle/Solaris Wrangler UC Davis Extension Distance Education Group (http://unexdlc.ucdavis.edu) 2901 K Street, Suite 200C Sacramento, CA95816 (916)327-7793 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Converting XML to database(or query)
Hi all I'm have this XML format file from 3rd party survey application(don't uses DB): survey ip=127.0.0.1 browserId=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; (R1 1.5); .NET CLR 1.1.4322) _javascript_Enabled=1 section question inputComment / /question question!---choose born state--- inputTextlineCalifornia/inputTextline /question question!---question 1 - age with radio option (5 radios) - 3rd selected--- inputRadio option / option / option selected=1 / option / option / /inputRadio /question question!---question 2 - sex - M or F - Male selected--- inputRadio option selected=1 / option / /inputRadio /question question !---countries visited - 7 options - choose options 2, 3 and 5--- inputCheckbox option / option selected=1 / option selected=1 / option / option selected=1 / option / option / /inputCheckbox /question /section /survey and so on This is THE problem: how to know what/whats checkbox and radio options selected by clients/respondents? After how to store that clients choices to DB(MySQL) for statistics reports, filters? It's possible or I'm crazy??? ;-/\) Thanx in advance for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Gmail
Give me 1 please Thnx On Sat, 21 Aug 2004 13:27:09 -0400, Ewok [EMAIL PROTECTED] wrote: Id love to check it out if you have another... - Original Message - From: Matt Robertson To: CF-Talk Sent: Saturday, August 21, 2004 1:05 PM Subject: Gmail I got six more invites today, and took care of the 4 people who missed out on the last go-round.I have 2 left.Anyone?Send to me off-list so we don't clutter up here. Cheers, -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT_converting MS ACCESS or SQL2K to MySQL
Yes... looking for access2mysql... works very nice... cheers On Fri, 20 Aug 2004 08:52:19 -0500, Eric Creese [EMAIL PROTECTED] wrote: Any convertingtools out there?Pitfalls? What about datatypes and identity fields? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: 3 gmail invites
give me that... ;-) thanx On Thu, 19 Aug 2004 14:05:24 -0400, Adam Haskell [EMAIL PROTECTED] wrote: I have 1 available as well. On Thu, 19 Aug 2004 19:39:35 +0200, Mark Drew [EMAIL PROTECTED] wrote: You lucky SOB! Mine have dried up like my garden in summer On Thu, 19 Aug 2004 10:33:26 -0700, Matt Robertson [EMAIL PROTECTED] wrote: After a long drought I have 3 gmail invites available.Anyone want one? -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Pollster without flash gateway
Sorry :-) I know... it's impossible... but how to run Pollster Poll Application in our CF without Flash Gateway service(ISP)? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Olympics web site - anyone know anything about how it's built?
Looks like PHP... why? Looking source code show meUDMComment... Googling UDMComment gets: http://www.binoculars.com/brands/Collins_binoculars.html That site works with PHP... Maybe Cheers On Sun, 15 Aug 2004 09:43:45 -0400, Michael T. Tangorre [EMAIL PROTECTED] wrote: Running Microsoft/IIS 5.0 on LINUX?You sure about that one? :-) From: Qasim Rasheed [mailto:[EMAIL PROTECTED] http://uptime.netcraft.com/up/graph/?host=www.athens2004.com From: Michael Kear [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]