RE: Suggestion for Windows HTML editor
Hi Damien, I've been evaluating PrimalScript 3.1 and it looks like a winner. Sam Neff has mentioned it numerous times so I figured I'd check it out. It does all of what you are asking, and more. Also, the download is under 4MB, and it uses a little over 10MB on disk. I just slapped a bunch of help files in a separate directory (including CFMX ones from DWMX) and pointed PrimalScript at them; very easy. This gives you context help via the F1 key when you are within a CFMX tag or function. Also, "PrimalSense" is already configured to give you the CFMX tag-insight popups you've come to know and love. The only thing it lacks for me is CSS support, but I use TopStyle 3.1 for that and I love it. There are plenty of ways you can customize this tool. One I particularly like is being able to have one of your "open documents" be an actual web page, so you can keep a reference link on your toolbar handy to specific web references and whatnot. Another thing I like is you can have the icon associated with each file type you open display next to the tabbed filename, so it's easy to tell at a glance what file types are without looking at the extension. I like DWMX a lot more than I used to, but it's still a little quirky for me. One of the things Jim Davis pointed out is the file browser -- yech! I always mis-read what level I am on. Also, I've found that DWMX always freezes up for a minute every now and then when I work with a mapped drive off my local server. I know this to be the exact cause because I can work locally for hours on end and that never happens (this is with the 7.0.1 updater). One thing I WILL say about DWMX is that it encompasses all of these features and more, and I really like the built-in CSS support, but I still find myself gravitating away from it time and again. Andy -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 3:08 PM To: CF-Talk Subject: Suggestion for Windows HTML editor I'm looking for a HTML/CFML editor for Windows with the following requirements: 1. A projects system for easily managing a limited directory structure regarding an individual project. A simple file browser could suffice. 2. _Good_ syntax highlighting, i.e. able to highlight _javascript_ and HTML and CSS in the same file. 3. Good basic features, similar to EditPlus (http://www.editplus.com/). 4. Some sort of snippets / clip-book feature, for often-used code snippets. Ideally these should be programmable like NoteTab. 5. Small footprint as my laptop only has 64meg of RAM currently. 6. Code hinting, e.g. I enter attributes. I've gotten good enough with CFML and CSS that I really don't need Dreamweaver's WYSIWYG facilities any longer and would like something "light" enough to run on my new laptop at work (500Mhz P3). In effect I'm looking for a cross between EditPlus (for its wonderful basic functionality) and NotePad (for is programmability), with a few extras. Any suggestions? I'm not interested in Eclipse as it is too big for me, and a little OTT for basic text editing. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
generate print dialogue box
Just wondering if anyone knows how to automatically display the print box on a pdf I generate with cfx_pdf ? I basically generating a 100 - 200 page print job as a pdf with cfx_pdf ( don't know of any other way of doing it ) from CSV data. The app is going to be used to generate a daily backlog of pharmacy scripts. I am importing the csv through cfhttp, and adding the data to an access db ( just for testing ). I will then query the data based upon doctor logon, and then generate the pdf using a cfloop and the cfx_pdf UDF. I have thought about using a crystal report, but I think the pdf way of doing things is working ok. The main problem I have is, one of our more powerful doctors says that he has used a similar app, where he logs onto a web page, and presses ONE BUTTON and then print. So he too wants to only press one button and then hit print in the standard print dialogue box. I am assuming this is going to have to make use of some kind of _javascript_ ??? Any help is always appreciated. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Suggestion for Windows HTML editor
Well then, in that case he can use the money he would have spent on DreamWeaver and upgrade his memory so that he can run Dreamweaver! Wait. I see a conundrum. ;^) (As an aside: my vote is Homesite+ or CF Studio - still the best although I've forced myself to switch to Dreamweaver just to see how I'd like it. If the damn thing could just show me a normal file listing I'd be almost perfectly with it.) Jim Davis From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 7:02 PM To: CF-Talk Subject: RE: Suggestion for Windows HTML editor > I can't see where Dreamweaver wont do everything you want. > Just change to code view and you're home and hosed. Damian said his new laptop will only have 64 MB of RAM! In that case, I suspect he'd see sub-optimal performance with Dreamweaver. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Java+JSP 10 times faster than CF? And Other Ruminations.
You may want to drop Hal a line and ask, but I'm almost positive that's the same page he's been using for years - long before CFMX. CFMX runs almost identically to the way JSP runs: a high-level source file is compiled directly into Java Byte code - the file run on a request for both tools is pure, 100% no bones-about-it Java. Considering that it's hard to see how JSP could be definitively "10 times faster". In the CFMX vrs JSP world your only difference comes in the methods used by the tool developers to optimize the resulting code. Because of this different JSP implementations will have performance differences as will CF. However when taken as a whole the implementation seem to run about the same average. In other words you might see major differences in artificial tests, but when considering actual applications the differences tend to balance out. The engine itself also plays a major role. IBM would have you believe that WebSphere is much faster than JRun and that could be true. But all that means is that either your JSP OR your CFML, when run on WebSphere will be faster. CFMX still has some overhead that I would expect to slow it down some and there's definitely some new learning (some of the fastest things in CF 5.0 are some of the slowest things in CFMX and vice versa) but overall it seems like it's a wash. In the end however I think Hal was just using some poetic license to sell his class. I respect Hal greatly, but I wouldn't use this "statistic" in any argument until you got some clear foundational evidence for it. If you like I could tell you, with just as much evidence (meaning none) that CFMX runs 10 times faster than JSP AND increases breast size by one full cup over the course of only 30 days! It doesn't make it true however. ;^) Jim Davis From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 9:48 AM To: CF-Talk Subject: Java+JSP 10 times faster than CF? And Other Ruminations. 2) To quote Hal Helms: http://www.halhelms.com/index.cfm?fuseaction=writings.displayOnScreen&writin g=TenReasonsCompaniesLikeJava.htm "Java is a high-performance language. Java with JSP (similar to ColdFusion for presentation) is over 10 times faster than using ColdFusion. A single JSP server can handle 10 times the number of simultaneous requests that ColdFusion can." [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Yeah it is! In case you haven't seen it. http://www.macromedia.com/devnet/mx/coldfusion/articles/ben_forta_faster.htm l _ From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 4:26 p.m. To: CF-Talk Subject: RE: escaping " character OK great - I will give this a go, it seems a bit painstaking though Kind Regards, Brant Winter _ From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 1:54 PM To: CF-Talk Subject: RE: escaping " character VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
Worked beautifully ! Had to change name= to value= though :) _ From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 1:54 PM To: CF-Talk Subject: RE: escaping " character VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. _ From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 3:56 p.m. To: CF-Talk Subject: RE: escaping " character I am really lost here - I have read through the livedocs article on cfqueryparam and it seems that it is meant to go to the right of a where clause in a cfquery statement. I am really not sure how/why to use it. Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
OK great - I will give this a go, it seems a bit painstaking though Kind Regards, Brant Winter _ From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 1:54 PM To: CF-Talk Subject: RE: escaping " character VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,. Becomes something like VALUES ( , , ,. Looks a bit complex huh? But you get used to it. Watch for curly quotes in there. _ From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 3:56 p.m. To: CF-Talk Subject: RE: escaping " character I am really lost here - I have read through the livedocs article on cfqueryparam and it seems that it is meant to go to the right of a where clause in a cfquery statement. I am really not sure how/why to use it. Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping Question
Use your loop to build the list with listappend() then just use the listname in the preload > _ From: Jeffrey Fongemie [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 10:55 AM To: CF-Talk Subject: Looping Question Hi everyone, I'm using a query and loop to fill a statement for a _javascript_ image preload. So far I've got: endrow="#allphotos.recordcount#">'photoslarge/#filenamelarge#', foutput>)"> This works except that it puts a comma at the end of my list and that buggers up my _javascript_. I need it to loop through, adding a comma between each imagename but not at the end? For the life of me, I can't get this to work. I end up with: > large/St-Francis-de-Asis-Detail-.jpg',)"> I need: > large/St-Francis-de-Asis-Detail-.jpg')"> Any suggestions? -Jeff F. _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:177343"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=35" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.754 / Virus Database: 504 - Release Date: 9/6/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.754 / Virus Database: 504 - Release Date: 9/6/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping " character
I am really lost here - I have read through the livedocs article on cfqueryparam and it seems that it is meant to go to the right of a where clause in a cfquery statement. I am really not sure how/why to use it. Use !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal > -Original Message- > From: Brant Winter [mailto:[EMAIL PROTECTED] > Sent: 06 September 2004 13:26 > To: CF-Talk > Subject: RE: escaping " character > > What am i doing wrong here ? Sorry about the huge post, but I just cant > see > what I am missing now ? The error in line 57 refers to a different field > than the exception message showing an address "Syntax error (missing > operator) in query _expression_ '2 HOLBOURN CRES'." > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: web stats
SmarterStats at SmarterTools.com is free for a single domain and quite full featured (although it lacks some rather important features like exporting reports for offline use). It's a .NET application with a built in server so it's easy to set up and try. I used it to import the log files from www.firstnight.org (last December's log files totaled a little over 20 gigabytes) and although it took a whole weekend to do it, once imported the reports come up very quickly. Since it's free and easy you really can't go wrong just trying it out. ;^) Jim Davis From: Ricardo Russon [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 9:42 PM To: CF-Talk Subject: OT : web stats does anyone know of any good, free web stats apps that i can run on my windows 2003 / CF MX server? Or if there is any good webstat software that comes with either of the 2? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Error in JRun Log Files
I am conistently seeing the below error in "cfusion-event*.txt" files" One of the docs on MM suggests this might be related to database drivers, we are not using Data direct Database drivers. Any idea what this might be? Thanks, Joe Eugene 09/07 21:18:51 error Error in getRealPathFromConn java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124) at jrun.servlet.jrpp.ProxyEndpoint.getRealPathFromServer(ProxyEndpoint.java:487 ) at jrun.servlet.jrpp.ProxyEndpoint.access$000(ProxyEndpoint.java:38) at jrun.servlet.jrpp.ProxyEndpoint$1.fetch(ProxyEndpoint.java:477) at jrunx.util.Cache.get(Cache.java:116) at jrun.servlet.jrpp.ProxyEndpoint.getRealPath(ProxyEndpoint.java:514) at jrun.servlet.WebApplicationService.getResource(WebApplicationService.java:98 3) at jrun.servlet.JRunServletContext.getRealPath(JRunServletContext.java:132) at coldfusion.runtime.ServletContextWrapper.doGetRealPath(ServletContextWrapper .java:153) at coldfusion.runtime.ServletContextWrapper.getRealPath(ServletContextWrapper.j ava:114) at coldfusion.runtime.RuntimeServiceImpl.getRealPath(RuntimeServiceImpl.java:59 1) at coldfusion.filter.FusionContext.getRealPath(FusionContext.java:598) at coldfusion.filter.ExceptionFilter.runSiteWideHandler(ExceptionFilter.java:40 2) at coldfusion.filter.ExceptionFilter.handleException(ExceptionFilter.java:210) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:61) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:105) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29 4) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: web stats
I use Power phlogger that runs on php and mysql on a windows 2003 server and it is very good http://www.phpee.com/index.php?node=21 Patrick _ From: Ricardo Russon [mailto:[EMAIL PROTECTED] Sent: September 7, 2004 21:42 To: CF-Talk Subject: OT : web stats does anyone know of any good, free web stats apps that i can run on my windows 2003 / CF MX server? Or if there is any good webstat software that comes with either of the 2? TIA, Ricardo. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT : web stats
does anyone know of any good, free web stats apps that i can run on my windows 2003 / CF MX server? Or if there is any good webstat software that comes with either of the 2? TIA, Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
>>I get no images on any Mac browser Hi, Can you try again, I solved a little problem, and now it works on NT4.7 and NT7. I suppose (hope) it works also on Macs. I guess it should even work with Netscape 1.0, and may be even with Mosaic ! ;-) http://www.contentbox.com/claude/customtags/mapdata/mapdataDoc.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Error with CFCONTENT and DELETEFILE
>>I respectfully submit it's more viable than the (non-working) approach you're using now. Yeah, of course, it is just that this deletefile feature is not there for nothing and is supposed to work, and I want to make sure there is no way to have it working properly before I take another direction. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Error with CFCONTENT and DELETEFILE
> > Why not just delete them on a scheduled basis? > > Not really a viable solution for a commercial product ;-( I respectfully submit it's more viable than the (non-working) approach you're using now. There are plenty of ways to handle scheduling, and the transfer of work from runtime to some earlier or later time is a common approach to improving the performance of web applications. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Indexing on Linux systempermissions?
what is teh value of theResults.recordsSearched after ?? Doug - Original Message - From: vcc person <[EMAIL PROTECTED]> Date: Tue, 07 Sep 2004 16:21:59 -0400 Subject: Indexing on Linux systempermissions? To: CF-Talk <[EMAIL PROTECTED]> Hi everyone, I was able to do verity searching a db (Oracle) under SuSe Linux with CFMX 6.1 enterprise. My problem is that it is returning 0 results for PDFS, DOCs, TXT, XLS, etc. files even though I create a test file with the search word in it. Is this is Linux/Unix file permission configuration? here's a snippet of my coding ... path="/opt/coldfusionmx/verity/"> action=""> extensions=".txt, .pdf, .html, .htm, .txt, .xls, .doc" key="#IndexDir#" type="path" urlpath="htp://www.whatever.org/thepdfs" recurse="No" language="English"> The collection #IndexDir# has been indexed. then use a test search... for the string "computer" criteria="computer"> File: #Key# Document Title (if any): #Title# Score: #Score# Summary: #Summary# Result is 0 =( what is up with this? thanks, Larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Error with CFCONTENT and DELETEFILE
>>Why not just delete them on a scheduled basis? Not really a viable solution for a commercial product ;-( -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Help with Date Stuff
I think this is the function you need but I haven't tested it. function weekOfMonth(date, firstDOW) { var DOM = day(date); var m = month(date); var y = year(date); var firstDOM = dayOfWeek(createDate(y, m, 1)); var offset = ((firstDOM - firstDOW + 6) mod 7) + 1; var WOM = (DOM + offset - 1) \ 7 + 1; return WOM; } Do watch out for bugs. You give it the date and the number corresponding to the day you consider the first of the week (i.e. 1 for Sunday - this would be a constant for your). The function returns the week number of the month. Hopefully. Then you can either add a calculated column to your query and use cfoutput group="". or you could simply test the week number on each loop and display it only when it changes. _ From: Kelly Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 10:37 a.m. To: CF-Talk Subject: Re: Help with Date Stuff correct but the WEEK function brings back the week number for the YEAR not the MONTH. >The key is to figure out for each date what the week number is. Once you can >do that reliably it'll be easy. I take it that each weeks starts on a >Sunday, so that for September 2004 we're in week 2, and week 3 starts this >coming Sunday, right? > > > > _ > >From: Kelly Matthews [mailto:[EMAIL PROTECTED] >Sent: Wednesday, 8 September 2004 9:23 a.m. >To: CF-Talk >Subject: Help with Date Stuff > > > >Ok I have a weekly report I have to run. Basically it's run every Sunday >and brings back info for the previous week. If it's, as an example, the 3rd >sunday of hte month it will bring back info for the last 3 weeks of the >month (basically going back to the first). I have the report running fine >however he wants me to have the display broken out to say Week 1, Week 2, >Week 3, within the report and I cant figure out how to do that. > >Here is the code and where you see is where that would >need to display. > > > >default="#dateformat(Createdate(year,month,1),'mm/dd/yy')#"> > > > > > > > > > >width="600"> > > >exec sp_emailreports '#startdate#','#enddate#','OSI',#count# > > >OSI Single StepTwo Step >Phase 1Two Step Phase 2 > >Name >ID >Status >Type >Date > > > > > > > > > > > > > > > >#firstname# #lastname# >#ID# >#status# >#description# >#displaydate# > > > > > > > > > >ANy suggestions on how to do get it to group by Week 1, week 2 week 3? > > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Migrating from Movable Type to a CF-based blog?
Who has migrated a live, active blog from Movable Type to something like Ray's CF blog and preserved all entries and comments? That last part is real important. Now that corfield.org is running CFMX 6.1 (thanx to SmarterLinux, part of HostMySite), I can look at alternatives to MT but I want to bring across all of the content from my existing blog (it'll still sacrifice the first year of info since I lost my MT databases during an ISP upgrade in July 2003). Feel free to contact me off-list or, if you feel like sharing experiences with CF-based blogs, on-list! The story of my conversion from PHP to ColdFusion can be found here: http://www.corfield.org/index.cfm?event=php2cf -- Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Proposal
A little off topic, however can anyone share a proposal template with me for a website development proposal? I'd appreciate any direction Thanks Ryan Mannion [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ColdFusion MX Log Viewer
There was a great log viewer out there a few years back...it allowed you to delete entries, and do all kinds of things that the default cfmx administrator log viewer doesn't do. I was hoping it was updated for CF MX or something like it, but apparently not. Sincerely, Dave Phillips Co-Founder and Head Geek 94percent.com [EMAIL PROTECTED] 877-94PERCENT "Why do 100% of the work when you can have 94% of it done for you?" - http://DavePhillips.94percent.com _ From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 12:05 PM To: CF-Talk Subject: Re: ColdFusion MX Log Viewer CF Administrator log file viewer doesn't work for you? -nathan strutz http://www.dopefly.com/ Dave Phillips wrote: > Hi, > > Anyone know of a good replacement log viewer for CF MX ? All the ones I > find are for older versions of CF and don't take into account the complexity > of the exception.log. > > Thanks! > > Sincerely, > > Dave Phillips _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Comparing two records within the query
It's probably too late for this, but I'd have a table just for the movies themselves, and another table (one-to-many) where you match up the movies with the various formats (a row for movie 1 in VHS, another row for movie 1 in DVD, etc). In addition to making your work easier, when the next big format comes around, it's easy to take into account. Scott -- - Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Comparing two records within the query
How about ... A) query for all records B) create a new query object (adding some columns) C) loop through original query (and perhaps the new query, nested within it) and derive the result set you need to display your form to the user. maybe the new result set has a boolean to display/not display the radio buttons. Maybe you'd use a combination of both queries in your form to display and set the values of the choices. That's how i'd try and approach it. i'll let you think it through to the end. On Tue, 07 Sep 2004 17:35:24 -0500, B G <[EMAIL PROTECTED]> wrote: > That may be possible. Though it's not always up to me to get the marketing > dept and the DB people to do work so my life is easier. > > Nonetheless...The basic nature of this kind of compare is eluding me. Even > if I had two records, one with DVD and one with VHS in the MEDIA_TYPE field, > I'd still need to have some way to identify that while displaying the > records. > > >From: "Bryan Stevenson" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: Re: Comparing two records within the query > >Date: Tue, 7 Sep 2004 13:52:17 -0700 > > > >I'd strongly advise you add a column called Media_Type and use VHS or DVD > >as a media type codethat will make your life much easier ;-) > > > >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 > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Error with CFCONTENT and DELETEFILE
> I really need these files to be deleted, otherwise they > will fill up my server. Why not just delete them on a scheduled basis? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Suggestion for Windows HTML editor
> I can't see where Dreamweaver wont do everything you want. > Just change to code view and you're home and hosed. Damian said his new laptop will only have 64 MB of RAM! In that case, I suspect he'd see sub-optimal performance with Dreamweaver. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date picker
The site is really bad, but the calendar control is cool and you can customize it in many many ways: http://www.dynarch.com/mishoo/calendar.epl On Tue, 07 Sep 2004 18:17:02 -0400, Chris Musial <[EMAIL PROTECTED]> wrote: > does anyone have a link to one of the dynamic date pickers you would see on a travel site like orbitz, or carnival cruise lines? Im looking for something attractive for the cheapest possible without having to alter the way it is coded or the way it looks. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Date picker
Check the date-picker on www.mattkruse.com. It's good, flexible, and free. Shawn -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 4:45 PM To: CF-Talk Subject: Re: Date picker ummm ... have you tried pulling it out of the source at orbitz.com yet? On Tue, 07 Sep 2004 18:17:02 -0400, Chris Musial <[EMAIL PROTECTED]> wrote: > does anyone have a link to one of the dynamic date pickers you would see on a travel site like orbitz, or carnival cruise lines? Im looking for something attractive for the cheapest possible without having to alter the way it is coded or the way it looks. > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date picker
ummm ... have you tried pulling it out of the source at orbitz.com yet? On Tue, 07 Sep 2004 18:17:02 -0400, Chris Musial <[EMAIL PROTECTED]> wrote: > does anyone have a link to one of the dynamic date pickers you would see on a travel site like orbitz, or carnival cruise lines? Im looking for something attractive for the cheapest possible without having to alter the way it is coded or the way it looks. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Suggestion for Windows HTML editor
I can't see where Dreamweaver wont do everything you want. Just change to code view and you're home and hosed. If that's still not what you want, try UltraEdit. It has most of what you want. It's lightweight, fast, can handle files sizes as big as your hard drive, has syntax highlighting, an FTP inbuilt, can search and replace over entire directories or disks if you want. It's notepad on steroids, or Dreamweaver without the extras. If you want an all-purpose editor for a machine without a lot of RAM, UltraEdit's the way to go. (http://www.ultraedit.com) Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Damien McKenna <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 15:07:33 -0400 Subject: Suggestion for Windows HTML editor To: CF-Talk <[EMAIL PROTECTED]> I'm looking for a HTML/CFML editor for Windows with the following requirements: [snip] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Blog for CF 5?
http://www.riahsoftware.com/fuseblog/ fuseblog it's one - Original Message - From: Mark W. Breneman <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 11:25:42 -0500 Subject: CF Blog for CF 5? To: CF-Talk <[EMAIL PROTECTED]> My personal site it running on a server that is using CF 5. (Go figure I admin 4 servers all running CFMX) I don't have the time to write a Blogging app, so is there a CF 5 based Blog app that has RSS support? Maybe even free? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help with Date Stuff
correct but the WEEK function brings back the week number for the YEAR not the MONTH. >The key is to figure out for each date what the week number is. Once you can >do that reliably it'll be easy. I take it that each weeks starts on a >Sunday, so that for September 2004 we're in week 2, and week 3 starts this >coming Sunday, right? > > > > _ > >From: Kelly Matthews [mailto:[EMAIL PROTECTED] >Sent: Wednesday, 8 September 2004 9:23 a.m. >To: CF-Talk >Subject: Help with Date Stuff > > > >Ok I have a weekly report I have to run. Basically it's run every Sunday >and brings back info for the previous week. If it's, as an example, the 3rd >sunday of hte month it will bring back info for the last 3 weeks of the >month (basically going back to the first). I have the report running fine >however he wants me to have the display broken out to say Week 1, Week 2, >Week 3, within the report and I cant figure out how to do that. > >Here is the code and where you see is where that would >need to display. > > > >default="#dateformat(Createdate(year,month,1),'mm/dd/yy')#"> > > > > > > > > > >width="600"> > > >exec sp_emailreports '#startdate#','#enddate#','OSI',#count# > > >OSI Single StepTwo Step >Phase 1Two Step Phase 2 > >Name >ID >Status >Type >Date > > > > > > > > > > > > > > > >#firstname# #lastname# >#ID# >#status# >#description# >#displaydate# > > > > > > > > > >ANy suggestions on how to do get it to group by Week 1, week 2 week 3? > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Comparing two records within the query
That may be possible. Though it's not always up to me to get the marketing dept and the DB people to do work so my life is easier. Nonetheless...The basic nature of this kind of compare is eluding me. Even if I had two records, one with DVD and one with VHS in the MEDIA_TYPE field, I'd still need to have some way to identify that while displaying the records. >From: "Bryan Stevenson" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Comparing two records within the query >Date: Tue, 7 Sep 2004 13:52:17 -0700 > >I'd strongly advise you add a column called Media_Type and use VHS or DVD >as a media type codethat will make your life much easier ;-) > >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 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Suggestion for Windows HTML editor
At least some of the features you want, and the smallest foot print I think you will find. I believe the editor still fits on a single 3 ½ floppy disk! "Crimson Editor" http://www.crimsoneditor.com/ -- 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. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Date picker
does anyone have a link to one of the dynamic date pickers you would see on a travel site like orbitz, or carnival cruise lines? Im looking for something attractive for the cheapest possible without having to alter the way it is coded or the way it looks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Help with Date Stuff
The key is to figure out for each date what the week number is. Once you can do that reliably it'll be easy. I take it that each weeks starts on a Sunday, so that for September 2004 we're in week 2, and week 3 starts this coming Sunday, right? _ From: Kelly Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, 8 September 2004 9:23 a.m. To: CF-Talk Subject: Help with Date Stuff Ok I have a weekly report I have to run. Basically it's run every Sunday and brings back info for the previous week. If it's, as an example, the 3rd sunday of hte month it will bring back info for the last 3 weeks of the month (basically going back to the first). I have the report running fine however he wants me to have the display broken out to say Week 1, Week 2, Week 3, within the report and I cant figure out how to do that. Here is the code and where you see is where that would need to display. default="#dateformat(Createdate(year,month,1),'mm/dd/yy')#"> width="600"> exec sp_emailreports '#startdate#','#enddate#','OSI',#count# OSI Single StepTwo Step Phase 1Two Step Phase 2 Name ID Status Type Date #firstname# #lastname# #ID# #status# #description# #displaydate# ANy suggestions on how to do get it to group by Week 1, week 2 week 3? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMAIL not getting to some people.
Bruce, Are you able to check the mailsent logs and the unbelievable folder to see what actually went out. Mario -Original Message- From: Bruce H. Beinert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 5:17 PM To: CF-Talk Subject: CFMAIL not getting to some people. Hi All, I have a client who I built an email conatct manager for who is claiming that some of the contacts are not receiving the mail they send using the app. I get all emails sent using it and I am using multiple accounts with different spam and virus filters. Why would some people not be getting the mail? If it is because of a filter of some kind or because the mail looks auto-generated can I add something to the code that would make it look more friendly to filters?? Thanks to any and all help you can provide! -- Bruce H. Beinert p.808-637-0727<>m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com _ My Inbox is protected by SPAMfighter 11593 spam mails have been blocked so far. Download free SPAMfighter today! _ My Inbox is protected by SPAMfighter 11593 spam mails have been blocked so far. Download free SPAMfighter today! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Help with Date Stuff
Ok I have a weekly report I have to run. Basically it's run every Sunday and brings back info for the previous week. If it's, as an example, the 3rd sunday of hte month it will bring back info for the last 3 weeks of the month (basically going back to the first). I have the report running fine however he wants me to have the display broken out to say Week 1, Week 2, Week 3, within the report and I cant figure out how to do that. Here is the code and where you see is where that would need to display. exec sp_emailreports '#startdate#','#enddate#','OSI',#count# OSI Single StepTwo Step Phase 1Two Step Phase 2 Name ID Status Type Date #firstname# #lastname# #ID# #status# #description# #displaydate# ANy suggestions on how to do get it to group by Week 1, week 2 week 3? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT (was "Re: Comparing two records within the query")
On Sep 7, 2004, at 4:48 PM, B G wrote: > For example -01 = The Teletubbies meet Jason (VHS) -03 = The > Teletubbies meet Jason (DVD). Personally, I can't wait for the sequel, The Teletubbies vs Jason vs Santa Claus. -- Damien McKenna - Web Developer - [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]
CFMAIL not getting to some people.
Hi All, I have a client who I built an email conatct manager for who is claiming that some of the contacts are not receiving the mail they send using the app. I get all emails sent using it and I am using multiple accounts with different spam and virus filters. Why would some people not be getting the mail? If it is because of a filter of some kind or because the mail looks auto-generated can I add something to the code that would make it look more friendly to filters?? Thanks to any and all help you can provide! -- Bruce H. Beinert p.808-637-0727<>m.917-627-4035 Web Development and Consulting: http://www.siliconmaui.com Weblog: http://www.bruceandwende.com _ My Inbox is protected by SPAMfighter 11593 spam mails have been blocked so far. Download free SPAMfighter today! _ My Inbox is protected by SPAMfighter 11593 spam mails have been blocked so far. Download free SPAMfighter today! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT- SQL SERVER CONGFIGURATION
We currently have SQL Server 2000 Standard Edition running our production data for our websites. We have some issues with SQL loosing it's connection so we have to reboot. However this does not bode well with our users of course. An over zealous developer suggested we create a clustered environment for failover purposes. Now that would require changing the SQL from standard to Enterprise as well as additional hardware as well. Does anyone else have a suggestion to make this tighter? Does anyone know if I upgraded to Enterprise what if any impact that would have on my server is house that would be running the Standard Edition. Aside from reconfiguring all of my replication would there be any other impact? thoughts ideas [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Comparing two records within the query
I'd strongly advise you add a column called Media_Type and use VHS or DVD as a media type codethat will make your life much easier ;-) 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Comparing two records within the query
Here's the dilemna: I have a catalog of videos I want to list. The product ID's indicate whether the video is VHS or DVD. For example -01 = The Teletubbies meet Jason (VHS) -03 = The Teletubbies meet Jason (DVD). Two records for each title if available in both media. In the list I want only one record displayed, the user chooses via radio button VHS or DVD. But not all title are available in both formats. They could be either, or, or both. So the record would be displayed as: Title - Media (if only one) Choose media (if both) - $price In the query, how can I create a flag that indicates that an id number has a partner record which indicates a video is available in both formats? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Error with CFCONTENT and DELETEFILE
Hi, Still trying to have CFCONTENT do its job unde CF 5, here is the situation: 1. a temp file is created using 2. a CFX_tag is called and it writes an image on the file ok, yes, it closes the file! 3. a template is called from a 4. the template works perfectly, returns the image file using 5. The image is displayed ok in the browser, the only problem is that the file is not deleted by CFCONTENT as it is said it should. 6. each operation results in these two lines in the Server log file: "Error","308","09/07/04","16:22:50",,"Error number 232 occurred attempting to close connection to web server." "Error","308","09/07/04","16:22:50",,"Windows NT error number 232 occurred." Any idea ? I really need these files to be deleted, otherwise they will fill up my server. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Return Links (best practice)
>> the best methods to returning users back to where >> they came from after they log in. We approach this with the rule of thumb never trust the data the client is sending you So do not depend on referrer or cookie information unless you absolutely have to. On our simpler login sites we insist on cookies being turned on for session tracking and if the user times out or tries to access a protected page we direct him to the login page then to the after login page to start over again. Usually because they are 1 click away from the page they were at. On the more complex extranet sites we use session variables to track the user and refer him back to the page he needed to login to see. Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716 tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Web Service Troubles...
I am trying to return an XML string through a CFC. Here is my problem: I create an XML doc from my query. I call the var xmlObj. I want to turn this into a string, so I use ToString(xmlObj), but it returns an error. Any help on how to fix this would be great. function queryToXML(query){ var root = "query"; var row = "row"; var cols = listToArray(query.columnList); var nodeMode = "values"; var ii = 1; var rr = 1; var thisColumn = ""; var thisValue = ""; var xml = xmlNew(); if(structCount(arguments) GTE 2) root = arguments[2]; if(structCount(arguments) GTE 3) row = arguments[3]; if(structCount(arguments) GTE 4) nodeMode = arguments[4]; xml.xmlRoot = xmlElemNew(xml,root); xml[root].xmlAttributes["columns"] = arrayLen(cols); xml[root].xmlAttributes["rows"] = query.recordCount; for(rr = 1; rr LTE query.recordCount; rr = rr + 1){ arrayAppend(xml[root].xmlChildren,xmlElemNew(xml,row)); for(ii = 1; ii LTE arrayLen(cols); ii = ii + 1){ thisColumn = lcase(cols[ii]); thisValue = query[cols[ii]][rr]; switch(nodeMode){ case "rows": xml[root][row][rr].xmlAttributes[thisColumn] = thisValue; break; case "columns": arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn)); xml[root][row][rr][thisColumn].xmlAttributes["value"] = thisValue; break; default: arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn)); xml[root][row][rr][thisColumn].xmlText = thisValue; } } } return xml; } SELECT * FROM tblIncidents WHERE DateEntered BETWEEN #Stdate# AND #Enddate# q = RetrievedSingelDayData; xmlObj = queryToXML(q); xmlString = toString(xmlObj); [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Auto Sorting Problem
thanks to all that responded to my request for info. i didn't think there was a way to get the columns unsorted. I wasn't actually going to depend on the order for any critical formatting or anything. It's just aggrevating that MM would just asssume that everyone would want the columns pre-sorted. best to all, mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Auto Sorting Problem
Thank you barney for your input. I didn't think this was possible but just wanted to check. -mark >Nope sure isn't, and believe me, you don't want to be able to. Doing > so creates a dependancy on the order of the columns in your database > and/or SQL statement (depending on if you use SELECT * or not), which > is almost guarenteed to cause problems down the road when you > add/update/remove a column from either place. > > If you need to use the columns in a certain order, define a variable > with the column names, use that variable as your SELECT list, and > then > use it again in place of queryname.columnlist. That way you won't > have any cross dependancies. If that's impossible, just do the > second > part. It'll work almost as well, at fail explicitly (throw an > exception) if things change to break a dependancy, rather than the > non-exception failure if you just rely on the order the SQL server > throws back at you. > > cheers, > barneyb > > > On Fri, 03 Sep 2004 17:48:30 -0400, Mark Knox <[EMAIL PROTECTED]> wrote: > > I know I've seen this on a list before but couldn't remember where. > When displaying or using the cfquery.columnList variable, the columns > are automatically sorted in alphanumeric order. Is there any way to > retrieve the columnlist in the order it was returned by SQL-Server -- > which is the order as it is defined in the table to begin with? In > otherwords, is there a way to tell to NOT sort the > columnNames for the columnList variable? > > > > thanks in advance, > > > > mark > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb. com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Indexing on Linux systempermissions?
Hi everyone, I was able to do verity searching a db (Oracle) under SuSe Linux with CFMX 6.1 enterprise. My problem is that it is returning 0 results for PDFS, DOCs, TXT, XLS, etc. files even though I create a test file with the search word in it. Is this is Linux/Unix file permission configuration? here's a snippet of my coding ... action=""> extensions=".txt, .pdf, .html, .htm, .txt, .xls, .doc" key="#IndexDir#" type="path" urlpath="htp://www.whatever.org/thepdfs" recurse="No" language="English"> The collection #IndexDir# has been indexed. then use a test search... for the string "computer" File: #Key# Document Title (if any): #Title# Score: #Score# Summary: #Summary# Result is 0 =( what is up with this? thanks, Larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Suggestion for Windows HTML editor
OMG...Hot Dog From Sausage Software still exists??? I used that back in 95 when I started on the webback before Australia even had a T1 line in/out of it (software is from Aussie land) 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfx_getimage on CFMX / blob images with ASP
> I can use the cfx_getimage tag just fine on CF 5.0. But no luck with > it on CFMX. Anyone using this tag? > > As a backup plan I'm using ASP to retrieve and send to the browser but > I cannot seem to get it to write the file to disk. Anybody with ASP > experience that could help me out? > > FILE: show.asp > > > > FILE: getimage.asp > > <%@ LANGUAGE="VBSCRIPT" %> > <% > ' Clear out the existing HTTP header information > Response.Expires = 0 > Response.Buffer = TRUE > Response.Clear > > ' Change the HTTP header to reflect that an image is being passed. > Response.ContentType = "image/jpg" > > Set cn = Server.CreateObject("ADODB.Connection") > ' The following open line assumes you have set up a System DataSource > ' by the name of myDSN. > 'Remember to change the following connection string parameters to > reflect the correct values > 'for your SQL server. > > cn.Open "DSN=idx_ds1;UID=isfdvee;PWD=sdfsfved;DATABASE=MLSNHSQL" > > Set rs = cn.Execute("SELECT MEDIUM_PHOTO FROM dbo.idxmls" & Request. > QueryString("tbID") & " WHERE ID= " & Request.QueryString("ID")) > Response.BinaryWrite rs("MEDIUM_PHOTO") > > Response.End > %> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Suggestion for Windows HTML editor
OK, regarding Homesite, I've used it before but always found it a bit bloated for what it gave you, and was a dead-end product. HTML-Kit is very close to what I'm looking for, but its "workspace" system seems confused (why can't you set a local directory to map to an FTP site?). Very close though. There isn't much in the way of up-to-date CFMX plugins/addons, but that could be remedied. AceHTML, 1st Page, etc, the vast majority of web editors are trimmed-down versions of Dreamweaver, i.e. focused on the WYSIWYG aspects, which I don't care about. Also, many of them don't support CFML. Ones I'm going to investigate: - Sausage Software's HotDog. - Homesite 5.5, might aswell give it another spin seeing as I already have it. Personally I wish that the EditPlus author would add some sort of scripting support to his editor, then I'd probably be able to do lots of fun stuff with it... all for $30. -- Damien McKenna - Web Developer - [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: cfoutput -- group and maxrows problem
#publication_title# #author_name# But the maxrows attribute goes by the query record count, rather than the count of unique publication_titles. So instead of seeing 10 records per page, I may get 6 or 9 or 7--the system is counting each author row and thinks it's reached 10 before it actually has. Christy, I don't have a smart and elegant solution. Someone else is bound to post that moments after I post my kludgy solution, which is: Let your query pull more than 10 records (say, 50) and remove the maxrows attribute from your CFOUTPUT tag. Then, change your code to: #publication_title# #author_name# When you are done, you will have the list limited to ten publications. Further, you'll have the variable LastPubViewed that gives you the last ID you saw. You can use this last ID seen to help you show the next set. (I've always found moving to the next page of such lists tricky.) HTH, Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfoutput -- group and maxrows problem
I'm sure there are many ways to approach this. One way, remove the maxrows attribute and create your own counter. #publication_title# #author_name# Another way is to make sure you return only rows for your top 10 articles via SQL. Got a 'Jedi' Oracle DBA? Have them create a collate() function to collate columns into comma delimed lists. Then you can just use a sub select to build a column with all the authors listed. The slickest approach, eh? Doug - Original Message - From: Christy Wilkens <[EMAIL PROTECTED]> Date: Tue, 07 Sep 2004 14:52:45 -0400 Subject: cfoutput -- group and maxrows problem To: CF-Talk <[EMAIL PROTECTED]> Hi everyone, I'm new to the list, but was driven to subscribe by a problem that's been driving me mad for days. I have three tables: publications, authors, and pub_author. I designed it this way b/c pubs can have multiple authors, and I wanted a controlled list of authors. They're joined like so: SELECT p.publication_id, p.publication_title, a.author_name, a.author_id FROM publications p, publication_author pa, authors a WHERE p.publication_id = pa.pub_id AND pa.auth_id = a.author_id ORDER BY p.publication_title; ...which gives me multiple rows for publications with more than one author. So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3, Pub3-Auth4 = 4 rows for 3 records. My output uses grouped nested cfoutputs for display, essentially like this: #publication_title# #author_name# But the maxrows attribute goes by the query record count, rather than the count of unique publication_titles. So instead of seeing 10 records per page, I may get 6 or 9 or 7--the system is counting each author row and thinks it's reached 10 before it actually has. I've tried the custom tag cf_recordcount, and that counts correctly *outside* the record listing (e.g., "Found 22 results" instead of "Found 34"), but doesn't affect the way the cfoutput maxrows attribute works. Am I missing something totally obvious?? Thanks for any help. -c [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfoutput -- group and maxrows problem
> ...which gives me multiple rows for publications with more > than one author. So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3, > Pub3-Auth4 = 4 rows for 3 records. My output uses grouped > nested cfoutputs for display, essentially like this: > > maxrows="10"> > #publication_title# > > #author_name# > > > But the maxrows attribute goes by the query record count, > rather than the count of unique publication_titles. So > instead of seeing 10 records per page, I may get 6 or 9 or > 7--the system is counting each author row and thinks it's > reached 10 before it actually has. Hi Christy. Unfortunately the maxrows attribute wasn't really designed to work with grouped outputs like this, so in order to make this work the way you'd like, you'll have to create your own count of records... The good news is it's not difficult to do: #publication_title# #author_name# hth s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Suggestion for Windows HTML editor
sorry. I did not clarify my response earlier. I'm using Studio 5 not the Studio MX suite they have which includes Dreamweaver. I think it's not longer in production. I like it because u could connect to datasources with it and has a cleaner interface. I'm not a designer and that's why I like Studio 5. there use to be a free one called 1stPage but that was years ago which had the same homesite/studio look to it. >>> [EMAIL PROTECTED] 9/7/2004 12:07:33 PM >>> I'm looking for a HTML/CFML editor for Windows with the following requirements: 1. A projects system for easily managing a limited directory structure regarding an individual project. A simple file browser could suffice. 2. _Good_ syntax highlighting, i.e. able to highlight _javascript_ and HTML and CSS in the same file. 3. Good basic features, similar to EditPlus (http://www.editplus.com/). 4. Some sort of snippets / clip-book feature, for often-used code snippets. Ideally these should be programmable like NoteTab. 5. Small footprint as my laptop only has 64meg of RAM currently. 6. Code hinting, e.g. I enter attributes. I've gotten good enough with CFML and CSS that I really don't need Dreamweaver's WYSIWYG facilities any longer and would like something "light" enough to run on my new laptop at work (500Mhz P3). In effect I'm looking for a cross between EditPlus (for its wonderful basic functionality) and NotePad (for is programmability), with a few extras. Any suggestions? I'm not interested in Eclipse as it is too big for me, and a little OTT for basic text editing. -- Damien McKenna - Web Developer - [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: Suggestion for Windows HTML editor
Homesite+ 5.5? - Original Message - From: Damien McKenna <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 15:07:33 -0400 Subject: Suggestion for Windows HTML editor To: CF-Talk <[EMAIL PROTECTED]> I'm looking for a HTML/CFML editor for Windows with the following requirements: 1. A projects system for easily managing a limited directory structure regarding an individual project. A simple file browser could suffice. 2. _Good_ syntax highlighting, i.e. able to highlight _javascript_ and HTML and CSS in the same file. 3. Good basic features, similar to EditPlus (http://www.editplus.com/). 4. Some sort of snippets / clip-book feature, for often-used code snippets. Ideally these should be programmable like NoteTab. 5. Small footprint as my laptop only has 64meg of RAM currently. 6. Code hinting, e.g. I enter attributes. I've gotten good enough with CFML and CSS that I really don't need Dreamweaver's WYSIWYG facilities any longer and would like something "light" enough to run on my new laptop at work (500Mhz P3). In effect I'm looking for a cross between EditPlus (for its wonderful basic functionality) and NotePad (for is programmability), with a few extras. Any suggestions? I'm not interested in Eclipse as it is too big for me, and a little OTT for basic text editing. -- Damien McKenna - Web Developer - [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: Suggestion for Windows HTML editor
Homesite/Homesite+... if you have the dreamweaver CD you should find it on there Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Suggestion for Windows HTML editor
Anything wrong with CF Studio or HomeSite+ ?? 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Suggestion for Windows HTML editor
I'd stick with Studio.. using it for years and still do. >>> [EMAIL PROTECTED] 9/7/2004 12:07:33 PM >>> I'm looking for a HTML/CFML editor for Windows with the following requirements: 1. A projects system for easily managing a limited directory structure regarding an individual project. A simple file browser could suffice. 2. _Good_ syntax highlighting, i.e. able to highlight _javascript_ and HTML and CSS in the same file. 3. Good basic features, similar to EditPlus (http://www.editplus.com/). 4. Some sort of snippets / clip-book feature, for often-used code snippets. Ideally these should be programmable like NoteTab. 5. Small footprint as my laptop only has 64meg of RAM currently. 6. Code hinting, e.g. I enter attributes. I've gotten good enough with CFML and CSS that I really don't need Dreamweaver's WYSIWYG facilities any longer and would like something "light" enough to run on my new laptop at work (500Mhz P3). In effect I'm looking for a cross between EditPlus (for its wonderful basic functionality) and NotePad (for is programmability), with a few extras. Any suggestions? I'm not interested in Eclipse as it is too big for me, and a little OTT for basic text editing. -- Damien McKenna - Web Developer - [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: Any restriction in CFCONTENT?
>>if you try to delete a file so soon after creating it, you might have a problem there too, as it may well still be locked. I understand, but isn't CFCONTENT supposed to take care of this if 1. the file was created by CF itself, 2. CFCONTENT provides an attribute to delete the file after, I mean I'm not deleting the file myself. Now I used the same directory the template is, it works, I mean it returns the file, but the file is still not deleted. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Suggestion for Windows HTML editor
I'm looking for a HTML/CFML editor for Windows with the following requirements: 1. A projects system for easily managing a limited directory structure regarding an individual project. A simple file browser could suffice. 2. _Good_ syntax highlighting, i.e. able to highlight _javascript_ and HTML and CSS in the same file. 3. Good basic features, similar to EditPlus (http://www.editplus.com/). 4. Some sort of snippets / clip-book feature, for often-used code snippets. Ideally these should be programmable like NoteTab. 5. Small footprint as my laptop only has 64meg of RAM currently. 6. Code hinting, e.g. I enter attributes. I've gotten good enough with CFML and CSS that I really don't need Dreamweaver's WYSIWYG facilities any longer and would like something "light" enough to run on my new laptop at work (500Mhz P3). In effect I'm looking for a cross between EditPlus (for its wonderful basic functionality) and NotePad (for is programmability), with a few extras. Any suggestions? I'm not interested in Eclipse as it is too big for me, and a little OTT for basic text editing. -- Damien McKenna - Web Developer - [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: Any restriction in CFCONTENT?
> It is even weirder considering the file was in fact created by CF > itself using a call to GetTempFile ()... ;-/ I vaguely recall that the CFCONTENT tag runs within the security context of the web server, not the CF server itself. I don't know if this is still true with CFMX, but if so it could cause the problem you're encountering. In addition, if you try to delete a file so soon after creating it, you might have a problem there too, as it may well still be locked. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Java+JSP 10 times faster than CF? And Other Ruminations.
The first posting in this thread has a before every word, in the source it looks like this: Author: Sung Woo Short Link: http://www.houseoffusion.com/lists.cfm/link=m:4:35156:177328 I just came back from a weeklong training session with java/JSP programming and have a couple of things to discuss. FYI, I've [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfoutput -- group and maxrows problem
Hi everyone, I'm new to the list, but was driven to subscribe by a problem that's been driving me mad for days. I have three tables: publications, authors, and pub_author. I designed it this way b/c pubs can have multiple authors, and I wanted a controlled list of authors. They're joined like so: SELECT p.publication_id, p.publication_title, a.author_name, a.author_id FROM publications p, publication_author pa, authors a WHERE p.publication_id = pa.pub_id AND pa.auth_id = a.author_id ORDER BY p.publication_title; ...which gives me multiple rows for publications with more than one author. So Pub 1-Auth1, Pub1-Auth2, Pub2-Auth3, Pub3-Auth4 = 4 rows for 3 records. My output uses grouped nested cfoutputs for display, essentially like this: #publication_title# #author_name# But the maxrows attribute goes by the query record count, rather than the count of unique publication_titles. So instead of seeing 10 records per page, I may get 6 or 9 or 7--the system is counting each author row and thinks it's reached 10 before it actually has. I've tried the custom tag cf_recordcount, and that counts correctly *outside* the record listing (e.g., "Found 22 results" instead of "Found 34"), but doesn't affect the way the cfoutput maxrows attribute works. Am I missing something totally obvious?? Thanks for any help. -c [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fusebox
I can also recommend Jeff Peters book on Fusebox 4 and FLiP, published by Proton Arts: http://www.protonarts.com/ On Tue, 7 Sep 2004 11:21:17 -0400, Greg Luce <[EMAIL PROTECTED]> wrote: > Andrew, > The Code Rutters "Discovering Fusebox4 With ColdFusion" by John Quarto > Von Tividar explains it nicely. A must have! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Java+JSP 10 times faster than CF? And Other Ruminations.
I think the issue is because of the URL...I've seen this exhibited on some other messages. Here's my message again, without the link...should be easier to read. --- I just came back from a weeklong training session with java/JSP programming and have a couple of things to discuss. FYI, I've been a long-time CF programmer (first version of 3.1). I've dabbled in UNIX shell scripts, perl, ASP, VB, and Pascal (yes, Pascal!) in my past incarnations, and hands down, I have found CF to be the best for me. It is the most intuitive programming language I've encountered so far. That opinion hasn't changed after my intro to java/JSP. Anyway, here goes: 1) Since CFMX 6.1 is now running off of jrun, is it reasonable to see it as a huge and complicated set of JSP custom tags? JSP seems to behave very similarly to CF -- you write the code in a .jsp file and the compiler creates a .class file after the initial run. There are a ton of custom tags for JSP, and after sifting through them, it seems like CF can be seen as a large custom tag. 2) To quote Hal Helms: "Java is a high-performance language. Java with JSP (similar to ColdFusion for presentation) is over 10 times faster than using ColdFusion. A single JSP server can handle 10 times the number of simultaneous requests that ColdFusion can." I found this very disturbing, but I can see how this could be true. In JSP, the equivalent of a CFOUTPUT of a form field is as follows: <%= ${form_field} %> or <% request.getParameter("form_field") %> Either one will do the job, but when this code is run through the runtime compiler, you see two very different code -- the former is some form of an evaluate function (which, like Evaluate() in CF, will no doubt take more processing power) while the latter goes through unchanged, i.e., will be faster. So this got me thinking about CF in general. All the minute, annoying things that java requires help it run faster. In CF, you can simply declare a variable without regard for type -- statements. But let's think about that for a second. Since java requires that variables be typed, is it not plausible to think that CF code will run less lean, since there will now have to be extra code to sort this out? This is pure conjecture on my part; I have no idea. Since CF can be seen as a custom tag that generates code, who really knows how efficient this code-generating is? Is that why Hal says JSP is 10 times faster than CF? 3) I'm considering running MachII (after this class, I'm fairly convinced of the whole MVC thingy). Will running something like MachII make my applications faster? Or is it just a way to organize big projects so they don't get out of hand? 4) Is there a way to optimize CF code so it runs the fastest? I know, for example, that virtual Query function is dog-slow, and that structures are lightning fast. Are there any other tips? Should I be utilizing more CFSCRIPT throughout my code? No matter how much performance increase java/JSP offers, I find the whole language ridiculous. Then again, I find most computer languages ridiculous. Why shouldn't the parser be smart enough to know that a variable is a certain type without having me specify it? Why do I need to worry about case sensitivity? You may just call me lazy, but when I saw CF, I saw a language that was intelligent. It took the silliness out of programming and let me do what I really wanted to do. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Any restriction in CFCONTENT?
It is even weirder considering the file was in fact created by CF itself using a call to GetTempFile ()... ;-/ -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: E-Checks
Yeah, from googling I've found that Europeans have implimented a standard called IBAN that has potential for real-time validation. But it doesn't sound like the US is going to impliment it anytime soon. Greg - Original Message - From: joe velez <[EMAIL PROTECTED]> Date: Tue, 07 Sep 2004 13:12:29 -0400 Subject: Re: E-Checks To: CF-Talk <[EMAIL PROTECTED]> length ? don't you have a checkbook? hehe jk my routing is 9 and account is 10, but the first digit is 0 .. and i had to omit it on either paypal or my banks site for verification. so just 9 i'd say. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Any restriction in CFCONTENT?
>>If CF has no rights to delete the file, then it can't. I've also seen IIS put a stranglehold on file using this approach too. Hmmm so I better use another directory ;-/ But how come CF returns this directory in getTempDirectory() id it has no rights on it? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Any restriction in CFCONTENT?
If CF has no rights to delete the file, then it can't. I've also seen IIS put a stranglehold on file using this approach too. Doug - Original Message - From: Claude Schneegans <[EMAIL PROTECTED]> Date: Tue, 07 Sep 2004 13:50:55 -0400 Subject: Any restriction in CFCONTENT? To: CF-Talk <[EMAIL PROTECTED]> Hi, Is there any restriction about where the file return by CFCONTENT may be in the server? I return a gif file with something like: If the location of the file is in the HTTP server scope, it works, but if it is in C:\windows\temp... it won't... and the file is note deleted, but no error triggered by Am I missing something? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf_aebrowser - New Version Testing Help Required
checking for WML capable is fairly simple. in CF Now, what could be very valuable for some is what browser type the client is using on their PDA or Cell. Once you determine its WML capabe, there are only a few WML browsers to check for, yup a PITA. Google is not being kind to me today or I'd post a link of them. Manufacturer sites usually have a developers network where you can find such lists, for example http://www.motocoders.com/. I'd venture that much value would be added to this tag with a simlpe ISWML test. Doug - Original Message - From: Dawson, Michael <[EMAIL PROTECTED]> Date: Thu, 2 Sep 2004 14:13:55 -0500 Subject: RE: cf_aebrowser - New Version Testing Help Required To: CF-Talk <[EMAIL PROTECTED]> Andrew, I just viewed the page with my Treo 300 browsers. (Three of them, but I think one of them may have not gotten through all the way.) Yes, please check for WML- or WAP-capable browsers! Thanks From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 2:35 PM To: CF-Talk Subject: RE: cf_aebrowser - New Version Testing Help Required Hi Everyone. Firstly I would like to thank everyone who has helped so far, it has been good to get some real world testing of the tag and it has help find some problem and fixes. I would now like to ask for one final time for some help with testing. I think I have something that is pretty stable now and working well, but I need one last set of tests to confirm everything is ok. So anyone who would like to help please can you point all the browsers and operating system combinations you have at the following URL: http://www.andrewdixon.co.uk/aebrowser/test.cfm and if you would like to download a copy of the tag, please visit http://www.andrewdixon.co.uk/aebrowser/ Thanks once again. Best Regards >>> Andrew SpamNet - Stop spam immediately and help me too! www.cloudmark.com/spamnet Referral Code: 2tc4hl (use the code a get spamnet for $1.99 per month instead of $4.99!!!) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Any restriction in CFCONTENT?
Hi, Is there any restriction about where the file return by CFCONTENT may be in the server? I return a gif file with something like: If the location of the file is in the HTTP server scope, it works, but if it is in C:\windows\temp... it won't... and the file is note deleted, but no error triggered by Am I missing something? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone know what to do about this please? Error establishing socket
Mike Kear wrote: > We're getting the error as follows: > [Macromedia][SQLServer JDBC Driver]Error establishing socket. > Connection refused: connect > > I think this is to do with the hosting company - is there anything we > might do as site owners and developers to cause this? If you didn't set up the datasource you can't do anything about it. If you did set up the datasource, make sure you have the right address and portnumber. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Load Testing software
We use e-TEST Suite 7.0 in our load testing lab. It's an amazing product, but it's expensive. Regarding platform-specific tools, the main thing you're looking for is its ability to directly read and use metrics from the platform, which e-TEST Suite does quite well. 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: "Ben Frame" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 07, 2004 11:53 AM Subject: Load Testing software > Hi All, > > I've been working on Stress/Load testing some applications recently, > and wondered which, if any, testing tools work best for testing CF > applications? > > I've mostly used the general web stress test tools (Rational, MS Web > Application Stress Tool, etc...). However, it seems there are some > platform-specific testing tools available for J2EE, .NET, and PHP. > Are there technology-specific tools for ColdFusion? If using CFMX 6.1 > on JRUN, is there any value in using one of the J2EE specific tools > against JRUN? > > I'd be interested in any thoughts or experiences people might have on > this topic. > > Thanks! > > -Ben > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling a .Net control from ColdFusion
We actually looked into that as a way to embed ASP.NET controls in a CFML page--in fact, I gave a demo of some of our early efforts at CFUN-04. It turns out that what appears conceptually easy at the beginning is really very hard. In order to support the viewstate, postback, and event-driven environment that an ASP.NET control expects, you pretty much have to duplicate the full functionality of an ASP.NET, which is no minor task. So instead of embedding ASP.NET controls in CFML pages, we asked, "What if we could embed CFML code in ASP.NET pages?" Then we could mix CFML and ASP.NET controls and get the best of both worlds--pretty much the same effect we were looking for. Well, it turns out that we *can* do this (with BlueDragon.NET), and it's very cool. Look for more info when we release the BlueDragon 6.2 beta (including BlueDragon.NET) later this month. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 1:12 PM To: CF-Talk Subject: Re: Calling a .Net control from ColdFusion This is actually close to something I was throwing around... I was thinking, what if I had a tag library and use cfimport, and give it the the web form controls through a custom tag library. We could have the interesting control-style asp syntax right there in CF. Of course there are obviously forseeable problems, like obj.dataBind() doesn't work in the procedural CF language. bah. Anyway, just a thought. Not that I have enough time to implement it, but it would be cool. -nathan strutz Vince Bonfanti wrote: > Hi Josen, > > We might have another solution for you. What if you could use CFML tags > directly in ASP.NET pages? Put another way, what if you could turn any CFML > page into an ASP.NET page simply by changing the ".cfm" extension to > ".aspx"? > > Then you could mix .NET controls and CFML code in the same page, which is > what I think you really want, the only difference is they'd have the ".aspx" > extension instead of ".cfm". > > Is this something you'd be interested in? > > Vince Bonfanti [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cannot establish socket -
I was recently having this problem as well. After doing a little bit of searching I found an article, (might even have been an HoF Post) that suggested that setting up the db in window odbc, and then setting up the datasource to use an odbc connection would fix the problem. I set this up and havn't had the error in two weeks. I know this may not be an option to do directly through your hosting control panel, but you may be able to work with your host company to get it set up. Good Luck. simeon - Original Message - From: Ewok <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 10:17:54 -0400 Subject: RE: Cannot establish socket - To: CF-Talk <[EMAIL PROTECTED]> I can't think of anything (that definitely doesn't mean that there isn't something) code wise that would cause it other than your username and/or password being wrong. I think you're probably right about getting the hosting company to look into it since it was refused and at least get them to confirm your login information is correct. _ From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 07, 2004 8:06 AM To: CF-Talk Subject: Cannot establish socket - We're getting the error as follows: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect I think this is to do with the hosting company - is there anything we might do as site owners and developers to cause this? I think its something we're going to have to get WebCentral onto fixing, but is there anything else we can look at in our own code that might cause this error? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:177332"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=39" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.754 / Virus Database: 504 - Release Date: 9/6/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.754 / Virus Database: 504 - Release Date: 9/6/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Calling a .Net control from ColdFusion
This is actually close to something I was throwing around... I was thinking, what if I had a tag library and use cfimport, and give it the web form controls through a custom tag library. We could have the interesting control-style asp syntax right there in CF. Of course there are obviously forseeable problems, like obj.dataBind() doesn't work in the procedural CF language. bah. Anyway, just a thought. Not that I have enough time to implement it, but it would be cool. -nathan strutz Vince Bonfanti wrote: > Hi Josen, > > We might have another solution for you. What if you could use CFML tags > directly in ASP.NET pages? Put another way, what if you could turn any CFML > page into an ASP.NET page simply by changing the ".cfm" extension to > ".aspx"? > > Then you could mix .NET controls and CFML code in the same page, which is > what I think you really want, the only difference is they'd have the ".aspx" > extension instead of ".cfm". > > Is this something you'd be interested in? > > Vince Bonfanti [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: E-Checks
length ? don't you have a checkbook? hehe jk my routing is 9 and account is 10, but the first digit is 0 .. and i had to omit it on either paypal or my banks site for verification. so just 9 i'd say. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
>>That being said the "map" (or at least the venues) are indeed databased already. I have build a tool to define these mappings 100% the DHTML way on any image, presently mostly photos. For the time being only circles are used, but it could be squares, rectangles etc as well. Have a glance at http://diplomes.med.umontreal.ca select a year in the "Mosaïque" drop list, (ex: 1993) and pass the mouse over the image. The database contains presently about 8400 map areas, all defined online with a "few clicks". -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion MX Log Viewer
CF Administrator log file viewer doesn't work for you? -nathan strutz http://www.dopefly.com/ Dave Phillips wrote: > Hi, > > Anyone know of a good replacement log viewer for CF MX ? All the ones I > find are for older versions of CF and don't take into account the complexity > of the exception.log. > > Thanks! > > Sincerely, > > Dave Phillips [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: E-Checks
From personal experience I know that the routing number is uniform but IIRC the account number is not. Interestingly the associated links in my gMail pointed me to this page: http://www.abanumbers.com/solutions/webservices.asp HTH Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Java+JSP 10 times faster than CF? And Other Ruminations.
On Tuesday 07 Sep 2004 16:12 pm, Andrew Grosset wrote: > why is there a before every word in this thread..? makes it incredibly > hard to read. Not here there isn't. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
COTS Product
Hi everyone, Recently we were told we had to provide quite a few documents for SDLC (Systems Development Life-cycle), one month before a project deadline, for the COTS (Commercial-Off-the-Shelf) Product we are using for a government client. This product is CFMX 6.1. After installation testing on the dev and qas servers, the last two servers are now off-limits per the CIO until all of this documentation is provided. Initially all of these documents were deemed unnecessary as what we provided was considered adequate. There are roughly 30 documents listed, and we have been given samples and layouts, however this is going to take some time to complete and since we have limited resources, there is no way we are going to make the deadline of October 1st at this rate. My hands are tied as I am a sub-contractor for the company who actually HAS the contract. What I am looking for is, hopefully, someone or some company that has documented a lot of this information about CFMX already. The following link explains what is needed: http://www.usdoj.gov/jmd/irm/lifecycle/ch13.htm Near the end the page (section 13.3.7) is what we were provided via fax. If anyone can give me any insight, I'd appreciate it, since I am pretty lost here... Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Blog for CF 5?
My personal site it running on a server that is using CF 5. (Go figure I admin 4 servers all running CFMX) I don't have the time to write a Blogging app, so is there a CF 5 based Blog app that has RSS support? Maybe even free? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Java+JSP 10 times faster than CF? And Other Ruminations.
On Tue, 07 Sep 2004 11:12:15 -0400, Andrew Grosset <[EMAIL PROTECTED]> wrote: > why is there a before every word in this thread..? makes it incredibly hard to read. Not here. Short reply. Make easier for you. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: MX 6.1 W2K3 Installation Hangs
>You're saying that the install runs the web server configuration utility even if you choose the JRun web server during the installation? I've never seen that happen before. Hey, Dave, come on over to our place! You can watch it happening over and over again! ;D Anyway, Brandon Purcells tip about minimizing the ports which it scans seemed to do the trick, our server admin guy is happy once more. Thanks for your help guys Alistair [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Stopping Macromedia JRUN CFusion Server Services
Not sure if Dave was referring to stopping/starting the service, but I can also recommend starting/stopping your JRun/CFMX instance using (again from the command line): $ jrun -start cfusion So far I have never had any problems using this as opposed to using a windows service. Furthermore you can specify additional config files etc, and more importantly you can see what is going on as the server starts up and shuts down. My 2 pennies. Cheers G On Tue, 7 Sep 2004 10:36:03 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > Does anyone have any information as to why when stopping the CFusion > > Server Services, the following error would pop up but when clicking > > on OK the services would finally stop and I could restart them. > > > > Error when attempted to close Macromedia JRun CFusion Server service. > > > > Once I clicked "OK", the service did stop. > > I think you might get that if it takes a long time to stop the service. You > might try stopping it from the command line to see if you get more > information. You might also check your system event log. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Load Testing software
Hi All, I've been working on Stress/Load testing some applications recently, and wondered which, if any, testing tools work best for testing CF applications? I've mostly used the general web stress test tools (Rational, MS Web Application Stress Tool, etc...). However, it seems there are some platform-specific testing tools available for J2EE, .NET, and PHP. Are there technology-specific tools for ColdFusion? If using CFMX 6.1 on JRUN, is there any value in using one of the J2EE specific tools against JRUN? I'd be interested in any thoughts or experiences people might have on this topic. Thanks! -Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: More drag and drop
>> However, I can't seem to get it to work >> with text unless I select the text > not 100% surebut the text could be > in a div and the div could have somehting > along the lines of John, I'm not sure about the DIV tag that Bryan suggested. It may indeed work. The other way to do it is to wrap the text with an tag. That's how I did it. In my case, they were actually hyperlinks anyway, but I think that it works the same if you use the tag with only the name parameter. Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
I've found the best way to deal with this is to build in 'awareness' of a Lite version into the code from the start. Then you can just -- for example -- set a flag in Application.cfm and it will automatically shift into Lite mode. Then you encapsulate all of your Pro functionality into includes and tags. Don't include those in the Lite download. It only works if you start from scratch that way :-(. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfloop / cfquery and displaying results
Keith, Perhaps I am not understanding correctly, but it sounds like a query within which you group the results is the way to go. You can handle the grouping in a couple of different ways. I would start by reading the help on the CFOUTPUT tag, looking at the group parameter. HTH, Matthieu -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 3:28 PM To: CF-Talk Subject: cfloop / cfquery and displaying results hi everyone. i have a question concerning cfloop, cfquery and how to display information most effectively on a page. here is the situation. i have two queries. the first query gets all my main topics. the second query gets all my sub topics. my where clause in my second query uses an IN statement and utilizes the valuelist of the results of the first query. in the past what i have done is just performed the first query, and then placed the second query within a cfloop of the results of the first one to display all the sub topics. this time around i want to build a result set on the fly without having to put the second query within my cfloop tag. any suggestions are greatly appreciated. thanks so much. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping Question
On Tue, 7 Sep 2004 17:03:43 +0200, Pascal Peters wrote: > > query="allphotos">'photoslarge/#filenamelarge#' > allphotos.recordcount NEQ > allphotos.currentrow>,)"> > > Pascal > > Perfect. Thanks! makes perfect sense, and so simple. -Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping Question
Good catch Pascal. Personally I am not a fan of cluttering up tags with nested cftags inside them, so I'd go with the QuotedValueList() over the conditional logic in the body tag. Just a preference thing. Michael T. Tangorre > It would be QuotedValueList and this would only work if the > query was altered to include the path: > > SELECT > filenamelarge, 'photoslarge' + filenamelarge as filepath > > > > > filepath)# > )"> > > Pascal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fusebox
Andrew, The Code Rutters "Discovering Fusebox4 With ColdFusion" by John Quarto Von Tividar explains it nicely. A must have! Greg - Original Message - From: Andrew Dixon <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 15:06:58 +0100 Subject: Re: Fusebox To: CF-Talk <[EMAIL PROTECTED]> Hi. It is the airfair, hotel, etc... costs that stop me going to a conference in the US, but really I just need to get into doing some programming with Fusebox and this will happen soon as I've nearly finished my planning and we are all nearly agreed on what we doing. Nando, Thanks for the offer of help and I will be sure to take you up on it if needs be. Andrew. - Original Message - From: Nando <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 15:18:55 +0200 Subject: Re: Fusebox To: CF-Talk <[EMAIL PROTECTED]> As you can see, i have a lot to say on this issue ... Andrew - any questions you have about Fusebox, just go ahead and ask. If i know the answer and can manage to use an email interface properly, i'll reply. :) On Tue, 7 Sep 2004 15:05:58 +0200, Nando <[EMAIL PROTECTED]> wrote: > > > On Tue, 7 Sep 2004 08:45:33 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > > Come to the conference and check it out. $200 is well > > > worth it. And > > > the classes on Thursday and Friday are a great opportunity > > > to get up to > > > speed quickly. > > > > I think it was the international air-fare that was their cost issue. > > > > s. isaac dealey 954.927.5117 > > new epoch : isn't it time for a change? > > > > add features without fixtures with > > the onTap open source framework > > > > http://www.sys-con.com/story/?storyid=44477&DE=1 > > http://www.sys-con.com/story/?storyid=45569&DE=1 > > http://www.fusiontap.com > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Looping Question
How's this play? query="allphotos">'photoslarge/#filenamelarge#' allphotos.recordcount>,)"> Greg - Original Message - From: Jeffrey Fongemie <[EMAIL PROTECTED]> Date: Tue, 7 Sep 2004 10:55:26 -0400 Subject: Looping Question To: CF-Talk <[EMAIL PROTECTED]> Hi everyone, I'm using a query and loop to fill a statement for a _javascript_ image preload. So far I've got: endrow="#allphotos.recordcount#">'photoslarge/#filenamelarge#',)"> This works except that it puts a comma at the end of my list and that buggers up my _javascript_. I need it to loop through, adding a comma between each imagename but not at the end? For the life of me, I can't get this to work. I end up with: I need: Any suggestions? -Jeff F. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Java+JSP 10 times faster than CF? And Other Ruminations.
why is there a before every word in this thread..? makes it incredibly hard to read. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
E-Checks
Against my wishes our company is going to start processing E-Check payments. (We're doing this ourselves not through a service.) I've found info on validating the ABA routing numbers with js and CF. But is there any way to "validate" a checking account number without actually authorizing the transaction? I think there's a fee to even authorize, and probably they won't be done "real-time". Just batched later. Anyone have experience with E-Checks? Is the account number at least a certain number of digits? Thanks, Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping Question
It would be QuotedValueList and this would only work if the query was altered to include the path: SELECT filenamelarge, 'photoslarge' + filenamelarge as filepath > )"> Pascal > -Original Message- > From: Tangorre, Michael [mailto:[EMAIL PROTECTED] > Sent: 07 September 2004 17:05 > To: CF-Talk > Subject: RE: Looping Question > > ValueList() would work better for you here. > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca117.htm#wp11 > 14236 > > Mike > > > > > I'm using a query and loop to fill a statement > > for a _javascript_ image preload. > > > > So far I've got: > > > > > > startrow="1" > > endrow="#allphotos.recordcount#">'photoslarge/#filen > > amelarge#',)"> > > > > This works except that it puts a comma at the end of my list > > and that buggers up my _javascript_. I need it to loop through, > > adding a comma between each imagename but not at the end? > > > > For the life of me, I can't get this to work. > > > > I end up with: > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]