Re: Struct Insert
>Isn't that what the Allow Overwrite is for? >To overwrite the key if it exists? > >Ricardo. > > >Douglas Knudsen wrote: > >> I think you need to change it to "true" instead of "false" to allow the key to be overwritten (I'm not 100% sure on this but it would be easy to set up a test template to try it out). As I understand it the default value is false which prevents overwriting the key. Alternatively do a StructKeyExists and if it does use StructUpdate(structure, key, value) to update its value. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Struct Insert
Yes, but you have to set it to true. If you set it to false, it will throw an error if the key already exists. If you don't care, set it to true. Personally I always use: (if I want to insert if it exists or not) OR Or value="#tmpFieldList.defaultvalue#"> (if I only want to insert if it doesn't exist) Pascal > -Original Message- > From: Ricardo Russon [mailto:[EMAIL PROTECTED] > Sent: 15 September 2004 07:28 > To: CF-Talk > Subject: Re: Struct Insert > > Isn't that what the Allow Overwrite is for? > To overwrite the key if it exists? > > Ricardo. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Struct Insert
Isn't that what the Allow Overwrite is for? To overwrite the key if it exists? Ricardo. Douglas Knudsen wrote: > keys must be unique. Does show a > unique list of ids? > > Doug > > - Original Message - > From: Ricardo Russon <[EMAIL PROTECTED]> > Date: Wed, 15 Sep 2004 09:49:55 +1000 > Subject: Re: Struct Insert > To: CF-Talk <[EMAIL PROTECTED]> > > Ok, now i have the try catch working again. dunno what > happened, but i am using the exact same code. > > but that is a very slow process. why can't i use the structInsert ? > > Thanks > Ricardo. > > Ricardo Russon wrote: > > > this is weird, on my dev box this code works > > > > > > tmpFieldList.defaultvalue, false)> > > > > but on the production box, it tells me : > > > > "Cannot insert item with key 1. This key already exists. " > > > > This happens from time to time, i don't know why, but when it does > > i usually put a around it. > > > > > > > > > > > > tmpFieldList.defaultvalue, false)> > > > > > > > > but it is still giving me the same error. wtf?? > > > > I know that cf has troubles with variable names that start with numbers. > > but up > > until a few weeks ago it didn't seem to care to much. > > > > TIA > > Ricardo. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [solved] flash remoting on osx
The problem was that I set my cfmx context path to /, and I had JRun's flash remoting installed, this caused a conflict between cf flash remoting and jrun flash remoting! __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Read directory
I think I resolved it. select UPPER(name) as fsort, * from eng1 where eng1.name in ('#replace(valuelist(fre1.name), ",", "','","all")#') ORDER by fsort ASC is that right? > one more thing I have to resove in this issue is I need those filename > sorted alphabetically. > > I try to use the ORDER BY eng1.name ASC > > but in the middle of the page somewhere its finished on 'Z' and then > start again from 'A' (that start is unique, i.e. not repeating). > > I don't know where I am doing wrong, also could you please mentioned > that which query should I output to get the filenames which are in > both directory? > > > > > > > sort="name"> > > sort="name"> > > > select * from eng1, fre1 > where fre1.name = eng1.name > > > select * from eng1 > where eng1.name in ('#replace(valuelist(fre1.name), ",", "','", > "all")#') > ORDER by eng1.name ASC > > > > select * from fre1 > where fre1.name in ('#replace(valuelist(eng1.name), ",", "','", > "all")#') > ORDER by fre1.name ASC > > > and then I output the query "f_notin_e" ( I've dump both and it looks > both are generating the same output i.e. "f_notin_e" & "e_notin_f" > > please advise that which query should I output and the filenames are > not sorted. > > thanks > > > > > > Thank alot for help. > > it was a map drive and I was trying to access that directory from my > > > local machine, in that case the structure was empty. > > When I put the codes on server(then it becomes a local drive) and it > > > gave me the required output. > > > > thanks once again. > > - Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: any java cf'ers online?
Yep, Did you have a particular question or were you running a poll ;) Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Lori >Sent: Tuesday, September 14, 2004 8:17 PM >To: CF-Talk >Subject: Fw: any java cf'ers online? > >Anyone out there right now that uses java with cf? > >-Lori > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fw: any java cf'ers online?
Yes. Any particular question? Dave Jones NetEffect At 08:17 PM 9/14/04, you wrote: >Anyone out there right now that uses java with cf? > >-Lori > >-- >[Todays >Threads] >[This >Message] >[Subscription] >[Fast >Unsubscribe] [User >Settings] >[Donations >and Support] > >-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fw: any java cf'ers online?
I am currently writing a mail client using javamail. ?? Ricardo. Lori wrote: > Anyone out there right now that uses java with cf? > > -Lori > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: any java cf'ers online?
If you check out cflib.org you'll find many UDFs that use Java for their work. > Anyone out there right now that uses java with cf? > > -Lori > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cffile write question, sending but not parsing cf code
I'm using cffile to allow a magazine site to publish articles and not have a db call everytime an article is selected. Is there anyway (aside from includes) that I can use send up cf code such as CGI.path_info without it being parsed when the cffile is being written? Example: For example /admin/createFile.cfm creates a file called /stories/2004-1234.cfm I would like CGI.path_info to display /stories/2004-1234.cfm not /admin/createFile.cfm I also would like to be able to have etc... processed when the article is requested by the user and not when the CFFILE is executed. thx, hope this is understandable Gil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Read directory
one more thing I have to resove in this issue is I need those filename sorted alphabetically. I try to use the ORDER BY eng1.name ASC but in the middle of the page somewhere its finished on 'Z' and then start again from 'A' (that start is unique, i.e. not repeating). I don't know where I am doing wrong, also could you please mentioned that which query should I output to get the filenames which are in both directory? select * from eng1, fre1 where fre1.name = eng1.name select * from eng1 where eng1.name in ('#replace(valuelist(fre1.name), ",", "','","all")#') ORDER by eng1.name ASC select * from fre1 where fre1.name in ('#replace(valuelist(eng1.name), ",", "','","all")#') ORDER by fre1.name ASC and then I output the query "f_notin_e" ( I've dump both and it looks both are generating the same output i.e. "f_notin_e" & "e_notin_f" please advise that which query should I output and the filenames are not sorted. thanks > Thank alot for help. > it was a map drive and I was trying to access that directory from my > local machine, in that case the structure was empty. > When I put the codes on server(then it becomes a local drive) and it > gave me the required output. > > thanks once again. > - Asim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
I dont see anything about the Browse button for a file type form field on there. Any other button is pretty easy to set styles or use images for. Any elements onclick could SUBMIT a form. _ From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 5:35 PM To: CF-Talk Subject: RE: SOT: How to apply a style sheet to a file upload bottom. i guess u could try this http://dreamweaverfever.com/grow/ Form Button Fever! This behavior will make any object a Submit or Reset button for your form. It allows you to easily use a rollover image as a form button over even just a text link. It was created especially for those Drumbeat users moving over to UltraDev. I got bored of answering the question "how do I make such-and-such a submit button" so I got busy with a behavior. -- Original Message -- From: "Ciliotta, Mario" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 22:24:45 +0100 >Dave, > >It is sort of what I am trying to do but I need to change the color of the >button to match the rest of the buttons on the site. The users want the >buttons to be a form of blue and when you the file upload dialogue the problem >is that you get a gray browse button by default. > >Mario >-Original Message- >From: dave [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 14, 2004 5:16 PM >To: CF-Talk >Subject: Re: SOT: How to apply a style sheet to a file upload bottom. > > >i missed most of this as well but are u talking about doing this? >http://www.yockeys.com/test/b.cfm >only works in ie though >also there is an extention that turns images into submit buttons called submit >form fever (i think) > >-- Original Message -- >From: "Bryan Stevenson" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >Date: Tue, 14 Sep 2004 13:31:20 -0700 > >>Sorry...late to this thread...but AFAIK there is no way (I've tried hard in >the past) to change the style of the BROWSE button that is produced using an >input of type "file" >> >>If there is a way of changing it...I'm all ears ;-) >> >>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 >> >> > _ > > > > _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:178394"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=11" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Fw: any java cf'ers online?
do you have any specific question in mind? I have developed some small application using Java within CF. Thanks - Original Message - From: Lori <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 23:17:14 -0400 Subject: Fw: any java cf'ers online? To: CF-Talk <[EMAIL PROTECTED]> Anyone out there right now that uses java with cf? -Lori [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Fw: any java cf'ers online?
Anyone out there right now that uses java with cf? -Lori [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Turn relative links to absolute links
For anyone that's interested, this is what I came up with. This might be handy if you want to use CFINCLUDEs using absolute paths instead of relative paths. It gives the application more directory path independence, allowing you to relocate the directory that the application resides in without changing any code. Example: /* * Return a relative path from the current page to an * absolute URL on the same site. */ function PathTo(t) { var fa = ListToArray(cgi.script_name, '/\'); var ta = ListToArray(t, '/\'); var flen = ArrayLen(fa); var tlen = ArrayLen(ta); var rpath = ''; var i = 0; var j = 0; // Find common branch point in paths for (i=1; i lte Min(flen, tlen); i=i+1) if (fa[i] is not ta[i]) break; // Path back to branch rpath = RepeatString('../', flen - i); // Append remainder of path to target for (j=i; j lte tlen; j=j+1) rpath = rpath & IIf(j neq i, DE('/'), DE('')) & ta[j]; return rpath; } - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 13, 2004 1:17 PM Subject: Turn relative links to absolute links > I'm in the process of restructuring a fairly complex Intranet site - > moving applications, directories, content, and menus around to give the > site a bit more of a logical organization. > > The CF files and tags which use relative addressing are causing the most > work, especially if I decide re-reorganize and move something for a > second > time. > > Simple stuff like: > > > > I believe I've seen techniques (or UDFs?) posted on how to reform the > tag > using an absolute address. Assuming that the 'include' directory is > hanging off of the site root and that I have a template in an arbitrary > directory, as show below, how would this be done? > > / > ../include/header.cfm > ../applications/myapp/index.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Struct Insert
keys must be unique. Does show a unique list of ids? Doug - Original Message - From: Ricardo Russon <[EMAIL PROTECTED]> Date: Wed, 15 Sep 2004 09:49:55 +1000 Subject: Re: Struct Insert To: CF-Talk <[EMAIL PROTECTED]> Ok, now i have the try catch working again. dunno what happened, but i am using the exact same code. but that is a very slow process. why can't i use the structInsert ? Thanks Ricardo. Ricardo Russon wrote: > this is weird, on my dev box this code works > > > tmpFieldList.defaultvalue, false)> > > but on the production box, it tells me : > > "Cannot insert item with key 1. This key already exists. " > > This happens from time to time, i don't know why, but when it does > i usually put a around it. > > > > > > tmpFieldList.defaultvalue, false)> > > > > but it is still giving me the same error. wtf?? > > I know that cf has troubles with variable names that start with numbers. > but up > until a few weeks ago it didn't seem to care to much. > > TIA > Ricardo. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Question
I think I solved it Join the document table in twice and in the join clause added the condition SELECT R.TEAMING_AGREEMENT_ID, R.ROUTE_GROUP_ID, B.BUSINESS_NAME, T.OPPORTUNITY_ID, D.DOCUMENT_NAME AS TEAMING_AGREEMENT_DOCUMENT, D.DOCUMENT_EXTENSION AS TEAMING_AGREEMENT_DOCUMENT_EXTENSION , D.DOCUMENT_TYPE_ID AS TEAMING_AGREEMENT_DOCUMENT_ID, D2.DOCUMENT_NAME AS ATTACHMENT_A_DOCUMENT, D2.DOCUMENT_EXTENSION AS ATTACHMENT_A_DOCUMENT_EXTENSION, D2.DOCUMENT_TYPE_ID AS ATTACHMENT_A_DOCUMENT_ID, FROM TEAMING_AGREEMENT_ROUTING R INNER JOIN TEAMING_AGREEMENT T ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID) INNER JOIN COMMUNITY_BUSINESS B ON (T.COMMUNITY_BUSINESS_ID = B.COMMUNITY_BUSINESS_ID) INNER JOIN TEAMING_AGREEMENT_TYPE TAT ON (T.TEAMING_AGREEMENT_TYPE_ID = TAT.TEAMING_AGREEMENT_TYPE_ID) INNER JOIN TEAMING_AGREEMENT_DOCUMENT D ON (T.TEAMING_AGREEMENT_ID = D.TEAMING_AGREEMENT_ID AND D.DOCUMENT_TYPE_ID = 1) INNER JOIN TEAMING_AGREEMENT_DOCUMENT D2 ON (T.TEAMING_AGREEMENT_ID = D2.TEAMING_AGREEMENT_ID AND D2.DOCUMENT_TYPE_ID = 2) WHERE T.OPPORTUNITY_ID = 33 GROUP BY B.BUSINESS_NAME, R.TEAMING_AGREEMENT_ID, R.ROUTE_GROUP_ID, T.OPPORTUNITY_ID, D.DOCUMENT_NAME, D.DOCUMENT_EXTENSION, D.DOCUMENT_TYPE_ID, D2.DOCUMENT_NAME, D2.DOCUMENT_EXTENSION, D2.DOCUMENT_TYPE_ID Mike > Given the following: > > SELECT > R.TEAMING_AGREEMENT_ID, > R.ROUTE_GROUP_ID, > B.BUSINESS_NAME, > T.OPPORTUNITY_ID, > D.DOCUMENT_NAME, > D.DOCUMENT_EXTENSION > FROM > TEAMING_AGREEMENT_ROUTING R > INNER JOIN TEAMING_AGREEMENT T > ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID) INNER > JOIN COMMUNITY_BUSINESS B > ON (T.COMMUNITY_BUSINESS_ID = B.COMMUNITY_BUSINESS_ID) > INNER JOIN TEAMING_AGREEMENT_TYPE TAT > ON (T.TEAMING_AGREEMENT_TYPE_ID = > TAT.TEAMING_AGREEMENT_TYPE_ID) INNER JOIN > TEAMING_AGREEMENT_DOCUMENT D > ON (T.TEAMING_AGREEMENT_ID = D.TEAMING_AGREEMENT_ID) WHERE > T.OPPORTUNITY_ID = 33 GROUP BY B.BUSINESS_NAME, > R.TEAMING_AGREEMENT_ID, R.ROUTE_GROUP_ID, T.OPPORTUNITY_ID, > D.DOCUMENT_NAME, D.DOCUMENT_EXTENSION > > If I need to get two of documents from the > TEAMING_AGREEMENT_DOCUMENT table (different types: DOC_TYPE = > 1 and DOC_TYPE =2), how can I do this and get the desired > number of records returned. If I remove the joined in > TEAMING_AGREEMENT_DOCUMENT table I return 5 records, which is > correct, but when I try and get the two documents associated > I return 10 records. Is there anyway to qualify the selection > of the documents? I hope this makes sense grouping? sub query? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
When this part of the JSP runs for (int i=0;i out.println("i: " + i + ""); try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println(endPoint.getServerName() + endPoint.getRequestURI() + ""); } catch (Exception e) { } } I get i:1 i:2 . . . that's it. The try/catch is catching an exception. When I remove the try/catch I get this in the cfusion-event log java.lang.ClassCastException at jrun__admintools__cfthreads2ejsp19._jspService(jrun__admintools__cfthreads2ejsp19.java:59) at jrun.jsp.runtime.HttpJSPServlet.service(HttpJSPServlet.java:43) at jrun.jsp.JSPServlet.service(JSPServlet.java:119) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:447) at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:417) at jrun.servlet.JRunNamedDispatcher.forward(JRunNamedDispatcher.java:61) at coldfusion.license.JspLicenseServlet.service(JspLicenseServlet.java:31) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:249) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) looks like its this line that is having issue with the caste jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; Doug - Original Message - From: Lee Howard <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 18:26:04 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> If you are using jrun for your J2EE server I don't know what the problem could be. What kind of error message are you getting? Can you compile the code I posted? - Original Message - From: Douglas Knudsen <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 16:12:23 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> hmmm, I am using the enterprise version, J2EE install, and I can not see the script names. This part bombs. jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); maybe there is something missing in my classpath or maybe a differnet JVM Doug - Original Message - From: Lee Howard <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 15:24:51 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> I like that. It worked great for me, but if you are not using enterprise it will not work. For those people you can also do the same thing with a servlet. Here is the java code. import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class threads extends HttpServlet{ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println("i: " + i + ": "); out.println(endPoint.getServerName() + endPoint.getRequestURI() + " :" + endPoint.getRemoteHost() + ""); } catch (Exception e) { } } } } compile and put in the WEB-INF/classes folder. I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar call it using http://webserver.com/servlet/thread - Original Message - From: Douglas Knudsen <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 11:54:05 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> there was some JSP code for this floating around abit ago. IIRC, credit goes to Pete Frietag. I never got this to work for me though. Some sort of caste error and I'm far from a Java guru. Anyone get this to work? <% Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i out.println("i: " + i + ""); try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servl
New custom tag
Hi, I just released a new custom tag that generates colored maps from a GIF template and according to data in a database. see http://www.contentbox.com/claude/customtags/mapData/viewmapData.cfm?p=md -- ___ 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: Data Visualization
>>Has anyone worked on data visualization technique(s) with CF/CFMX? Hi, just released a new tag today, and I think it falls in this category. See CFX_mapData here: http://www.contentbox.com/claude/customtags/mapData/viewmapData.cfm?p=hf -- ___ 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]
SOT: SQL Question
Given the following: SELECT R.TEAMING_AGREEMENT_ID, R.ROUTE_GROUP_ID, B.BUSINESS_NAME, T.OPPORTUNITY_ID, D.DOCUMENT_NAME, D.DOCUMENT_EXTENSION FROM TEAMING_AGREEMENT_ROUTING R INNER JOIN TEAMING_AGREEMENT T ON (R.TEAMING_AGREEMENT_ID = T.TEAMING_AGREEMENT_ID) INNER JOIN COMMUNITY_BUSINESS B ON (T.COMMUNITY_BUSINESS_ID = B.COMMUNITY_BUSINESS_ID) INNER JOIN TEAMING_AGREEMENT_TYPE TAT ON (T.TEAMING_AGREEMENT_TYPE_ID = TAT.TEAMING_AGREEMENT_TYPE_ID) INNER JOIN TEAMING_AGREEMENT_DOCUMENT D ON (T.TEAMING_AGREEMENT_ID = D.TEAMING_AGREEMENT_ID) WHERE T.OPPORTUNITY_ID = 33 GROUP BY B.BUSINESS_NAME, R.TEAMING_AGREEMENT_ID, R.ROUTE_GROUP_ID, T.OPPORTUNITY_ID, D.DOCUMENT_NAME, D.DOCUMENT_EXTENSION If I need to get two of documents from the TEAMING_AGREEMENT_DOCUMENT table (different types: DOC_TYPE = 1 and DOC_TYPE =2), how can I do this and get the desired number of records returned. If I remove the joined in TEAMING_AGREEMENT_DOCUMENT table I return 5 records, which is correct, but when I try and get the two documents associated I return 10 records. Is there anyway to qualify the selection of the documents? I hope this makes sense grouping? sub query? Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Intel HyperThreading
Thanks Jim, I am now considering dual processors - just not sure and want to get as much feedback as possible before diving into putting the new system together. I am hoping to order parts Thursday and build this weekend. If anyone has ANY comments on their system and what kind of performance you get please feel free to post - or email me off list. Thanks again, Donna - Original Message - From: Jim Davis <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 19:04:07 -0400 Subject: RE: Intel HyperThreading To: CF-Talk <[EMAIL PROTECTED]> I like it - it definitely improves performance response time when using multiple applications. But really only for those applications tuned to multi-processor performance to begin with. CF won't benefit nearly as much as it will from dual CPUs (a dual PIII 1000 would I think give a single P4 3Gh HT at least a run for it's money if not beat it outright under load - and probably costs about the same), but it will definitely benefit. My workstation is a P4 3.06 GHz with HT enabled and my development server is a Dual PIII 1000 (running at 1100). This doesn't really have anything to do with memory however - just performance. HT won't do anything to help a memory hog - only more memory will do that. If it's a choice for CF always go with with more memory rather than a faster processor (in general). Jim Davis From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 6:20 PM To: CF-Talk Subject: OT: Intel HyperThreading Okay - I fried my motherboard last weekend and have decided to build a new system instead of replacing the old one. I've been running a 950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some speed now. I had in mind to build a P4 3.0GHz and have been looking at the HyperThreading technology. Heard it's great for memory hawgs like CFMX and the like. Anyone else using Intel HT technology? Any comments/suggestions welcome. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
Yes, please do show any cross-browser solution you might have :-) Ive came extremely close, but never close enough to even consider using it live on user end _ From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 12:48 PM To: CF-Talk Subject: RE: SOT: How to apply a style sheet to a file upload bottom. Asim, How do you actually do that? I have tried it before and it did not work. The code was unable to actually do the upload. I am assuming that you need to write a _javascript_ routine to do that? Is it possible to post an example? Thanks Mario -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 12:43 PM To: CF-Talk Subject: Re: SOT: How to apply a style sheet to a file upload bottom. I would recommend that you use your own graphics for the buttons. I usually use my own graphics button in place of the browse button. >All that does is turn the background of the field a color. CSS limitation, >this can't be done currently. > >-Original Message- >From: Asim Manzur [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 14, 2004 11:33 AM >To: CF-Talk >Subject: Re: SOT: How to apply a style sheet to a file upload bottom. > > > > >Untitled >
>.buttoncolor { color:#FF; background: #557799; FONT-FAMILY: Arial,
>sans-serif; FONT-SIZE: 8pt; font-weight: bold;}
> > > > > > >enctype="multipart/form-data"> > >It also needs to have a file selection control: > > > > > >>Hi, >> >>I am in the process of creating a page for my endusers to upload files and >>the first thing that they complained about is that the button is not the >same >>style as the rest of the buttons in the applications. All of the buttons >are >>usually a form of blue (We use IE6.0 only - internal), but the BROWSE >button > _ _ _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:178331"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.759 / Virus Database: 508 - Release Date: 9/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Struct Insert
Ok, now i have the try catch working again. dunno what happened, but i am using the exact same code. but that is a very slow process. why can't i use the structInsert ? Thanks Ricardo. Ricardo Russon wrote: > this is weird, on my dev box this code works > > > tmpFieldList.defaultvalue, false)> > > but on the production box, it tells me : > > "Cannot insert item with key 1. This key already exists. " > > This happens from time to time, i don't know why, but when it does > i usually put a around it. > > > > > > tmpFieldList.defaultvalue, false)> > > > > but it is still giving me the same error. wtf?? > > I know that cf has troubles with variable names that start with numbers. > but up > until a few weeks ago it didn't seem to care to much. > > TIA > Ricardo. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Variable names stored in database
Store this block in the database div.template1 { width: [**divtemplateWidth**]; height: [**divtemplateHeight**]; border: 1px solid black; background-color : [**divTempalteBgColor**]; } Also store your divTemplateBGColor, divTemplateWidth, divTemplateHeight in the database Query for your style blocks Then query for all of your values Now replace the key strings in the Style block with the values ValueQuery.divTemplateWidth, ALL)> ValueQuery.divTemplateHeight, ALL)> [**divTemplateBgColor**], ValueQuery.divTemplateBgColor, ALL)>
#SyleBlockFinal#
I havent used this but Ive been kicking around the idea for a skinned message board I have. Right now Im just storing the directory names in the database Each directory has a style.css in it. The style being used for the skin depends on an ACTIVE status in the database Each of the directories also has an images directory with the buttons for that skin. Id like to hear others thoughts on dynamic skins and styles myself. In my case, the above example (style code in the database) could get rather large and probably way too much overhead for a skin feature. _ From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:19 AM To: CF-Talk Subject: Variable names stored in database I would like to store style sheet information in a database but need to be able to change some of the parameters on the fly. If a straight file doing the variable substitutions is no big deal. SELECT color FROM spec_table WHERE customer = 42
div.template1{
width: 300;
height: 250;
border: 1px solid black;
background-color : #variables.bgcolor#;
}
Yes I know I don't need to use the extra step in this case but if it is stored in a DB I need constant names in string. So is it possible to store the style block in a DB and then do the variable replacement? Shawn McKee Mgr., Web Development http://www.newsstand.com _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:178273"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=34" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Struct Insert
this is weird, on my dev box this code works tmpFieldList.defaultvalue, false)> but on the production box, it tells me : "Cannot insert item with key 1. This key already exists. " This happens from time to time, i don't know why, but when it does i usually put a around it. tmpFieldList.defaultvalue, false)> but it is still giving me the same error. wtf?? I know that cf has troubles with variable names that start with numbers. but up until a few weeks ago it didn't seem to care to much. TIA Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Data Visualization
Thank you very much, it looks interesting, I'll take a better look later. >you might want to get in touch with this guy, he seems to read the >list and does some REALLY amazing stuff > >http://marcosweskamp.marumushi.com/ > >Regards > >Mark Drew > > >On Tue, 14 Sep 2004 16:03:59 -0400, Don Chunshen Li ><[EMAIL PROTECTED]> wrote: >> Not line/bar chart type with cfgraph or cfchart, ah, it's a futile question. >> >> >Has anyone worked on data visualization technique(s) with CF/CFMX? >> >If so, pls share your experience. >> >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 updater
> I didn't have any luck applying the updater to an expanded > ear. I had to apply it to a archived one before it agreeded I > was 'valid'. That's odd. I didn't have any trouble applying it to existing expanded EARs on JRun. Is there anything unusual about your configuration? 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: Quad Character Unicode?
Jochem van Dieten wrote: > Jeff Chastain wrote: >> >> I have an encoded text string that I am needing to decode. The string is in >> the format ... >> >> http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom >> >> which I am being told is called Quad Character Unicode. I have played >> with all of the different character sets in CFMX and I cannot get this >> string to decode properly. Does anybody have any suggestions? > > It is just hex with a weird delimiter (% instead of /). The quick > and dirty fix is to use: > URLDecode(REReplaceNoCase(string,"%(u00)[0-7][0-9a-z]","","ALL")) I messed up that regex. The intention is to transform %u003A to %3A, for which the following will work better: URLDecode(REReplaceNoCase(string,"%u00([0-7][0-9a-z])","%\1","ALL")) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Intel HyperThreading
I like it - it definitely improves performance response time when using multiple applications. But really only for those applications tuned to multi-processor performance to begin with. CF won't benefit nearly as much as it will from dual CPUs (a dual PIII 1000 would I think give a single P4 3Gh HT at least a run for it's money if not beat it outright under load - and probably costs about the same), but it will definitely benefit. My workstation is a P4 3.06 GHz with HT enabled and my development server is a Dual PIII 1000 (running at 1100). This doesn't really have anything to do with memory however - just performance. HT won't do anything to help a memory hog - only more memory will do that. If it's a choice for CF always go with with more memory rather than a faster processor (in general). Jim Davis From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 6:20 PM To: CF-Talk Subject: OT: Intel HyperThreading Okay - I fried my motherboard last weekend and have decided to build a new system instead of replacing the old one. I've been running a 950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some speed now. I had in mind to build a P4 3.0GHz and have been looking at the HyperThreading technology. Heard it's great for memory hawgs like CFMX and the like. Anyone else using Intel HT technology? Any comments/suggestions welcome. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Intel HyperThreading
Personal experience, enabled or disabled, HyperThreading had no real effect on my server. -nathan strutz http://www.dopefly.com/ Donna French wrote: > Okay - I fried my motherboard last weekend and have decided to build a > new system instead of replacing the old one. I've been running a > 950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some > speed now. > > I had in mind to build a P4 3.0GHz and have been looking at the > HyperThreading technology. Heard it's great for memory hawgs like CFMX > and the like. > > Anyone else using Intel HT technology? Any comments/suggestions welcome. > > Thanks, > Donna > > -- > > Donna French > [EMAIL PROTECTED] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Quad Character Unicode?
Jeff Chastain wrote: > I have an encoded text string that I am needing to decode. The string is in > the format ... > > http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom > > which I am being told is called Quad Character Unicode. I have played > with all of the different character sets in CFMX and I cannot get this > string to decode properly. Does anybody have any suggestions? It is just hex with a weird delimiter (% instead of /). The quick and dirty fix is to use: URLDecode(REReplaceNoCase(string,"%(u00)[0-7][0-9a-z]","","ALL")) If the string has characters that are not in 7-bit ASCII this will fail and you will have to do a proper conversion. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX 6.1 updater
I didn't have any luck applying the updater to an expanded ear. I had to apply it to a archived one before it agreeded I was 'valid'. -Adam - Original Message - From: Dave Watts <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 18:24:32 -0400 Subject: RE: CFMX 6.1 updater To: CF-Talk <[EMAIL PROTECTED]> > We are running the updater on our dev box and when it comes > down to selecting the CFIDE directory, it states it is an > invalid directory. > > Our directory is: > > d:\Jrun4\servers\cfusion\cfusion-ear\cfusion-war\ > > here you will find both the CFIDE and the WEB-INF directory. > > I have tried to specify the directory above with and without > the \CFIDE folder and both yield the same results. > > Suggestions? > BTW: This is a J2EE Configuration with CFMX and JRUN You do need to specify the CFIDE directory. However, since you've tried that, that's probably not the problem. Are you sure that the user account you're using to run the installer has the appropriate permissions to the CFIDE directory? 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: Setting up Oracle datasource in MX
When oracle is installed you define a service name / SID for the database. It would be the same value you put into your TNS file. -Adam - Original Message - From: Bob Flynn <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 17:36:56 -0500 Subject: Setting up Oracle datasource in MX To: CF-Talk <[EMAIL PROTECTED]> I understand that you can set up an Oracle datasource on CFMX6.1 without having the Oracle client tools installed on the server. I'm not CF server admin, but am trying to walk my admins through it. It is much easier to get them to add a datasource than it is to get them to download a package like that and install it on the server. The Oracle datasource screen in CF Admin asks for the SID name. Normally I would point to the alias in my tsnames.ora file. If that file does not exist, what do I fill in there? Guidance and online resources appreciated. Regards, Bob -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Setting up Oracle datasource in MX
Bob, Just use the value that you would find in the tnsnames.ora file if you had one on the machine. Make sense? Scott -Original Message- From: Bob Flynn [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 5:37 PM To: CF-Talk Subject: Setting up Oracle datasource in MX I understand that you can set up an Oracle datasource on CFMX6.1 without having the Oracle client tools installed on the server. I'm not CF server admin, but am trying to walk my admins through it. It is much easier to get them to add a datasource than it is to get them to download a package like that and install it on the server. The Oracle datasource screen in CF Admin asks for the SID name. Normally I would point to the alias in my tsnames.ora file. If that file does not exist, what do I fill in there? Guidance and online resources appreciated. Regards, Bob -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: new to CFMX, can't default attributes scope variables
My bad, I had a typo. I had double checked it, too... Sorry! -Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Quad Character Unicode?
I have an encoded text string that I am needing to decode. The string is in the format ... http%u003A%u002F%u002Fwww%u002Egoogle%u002Ecom which I am being told is called Quad Character Unicode. I have played with all of the different character sets in CFMX and I cannot get this string to decode properly. Does anybody have any suggestions? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: .net remoting
Thanks! That did the trick! >Alvin, > >Can you call the cfstart bat file to start cf? >It calls > >@Echo off >setlocal >cd ..\runtime\bin >jrun -start default >endlocal > >so it looks like you you need to call jrun not the java. > >HTH >Ricardo > > >Alvin Hom wrote: > >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
new to CFMX, can't default attributes scope variables
I'm new to CFMX, and I'm running into some problems. I used to be able to default a variable like "Attributes.myvar" to something with this tag: But that doesn't work now. The reason I am setting a variable in the attributes scope is because we build things using fusebox (version 1), which uses the attributes scope for anything (so code works with data passed in from a form or on the URL). Thanks for any help. -Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Setting up Oracle datasource in MX
I understand that you can set up an Oracle datasource on CFMX6.1 without having the Oracle client tools installed on the server. I'm not CF server admin, but am trying to walk my admins through it. It is much easier to get them to add a datasource than it is to get them to download a package like that and install it on the server. The Oracle datasource screen in CF Admin asks for the SID name. Normally I would point to the alias in my tsnames.ora file. If that file does not exist, what do I fill in there? Guidance and online resources appreciated. Regards, Bob -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 updater
> We are running the updater on our dev box and when it comes > down to selecting the CFIDE directory, it states it is an > invalid directory. > > Our directory is: > > d:\Jrun4\servers\cfusion\cfusion-ear\cfusion-war\ > > here you will find both the CFIDE and the WEB-INF directory. > > I have tried to specify the directory above with and without > the \CFIDE folder and both yield the same results. > > Suggestions? > BTW: This is a J2EE Configuration with CFMX and JRUN You do need to specify the CFIDE directory. However, since you've tried that, that's probably not the problem. Are you sure that the user account you're using to run the installer has the appropriate permissions to the CFIDE directory? 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]
Trouble with Two Table Query - Doh!
Here's a two table query (SQL Server) that's giving me a problem... Table 1: Articles (Couple hundred of these) --- id article_title article_date indus_id (each article is associated with an industry) Table 2: Industry (and there's maybe 60 industries in the table) industry_id indus_name Now, I've got no problem finding the associated articles and industries on an individual basis, but the client wants a single index page of articles grouped by industry, sorted alpha and then by article date like: AUTOMOTIVE article #1 - May, 1994 article #2 - April, 1994 article #3 - March, 1994 HOUSING AND DEVELOPMENT article #1 - Jan, 1994 article #2 - Dec, 1993 MEDICINE article #1 - June, 1993 article #2 - May, 1992 I keep coming up with convoluted ways of maybe doing this, but none seem to work properly. Pointers please? -- Les Mizzell [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
If you are using jrun for your J2EE server I don't know what the problem could be. What kind of error message are you getting? Can you compile the code I posted? - Original Message - From: Douglas Knudsen <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 16:12:23 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> hmmm, I am using the enterprise version, J2EE install, and I can not see the script names. This part bombs. jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); maybe there is something missing in my classpath or maybe a differnet JVM Doug - Original Message - From: Lee Howard <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 15:24:51 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> I like that. It worked great for me, but if you are not using enterprise it will not work. For those people you can also do the same thing with a servlet. Here is the java code. import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class threads extends HttpServlet{ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println("i: " + i + ": "); out.println(endPoint.getServerName() + endPoint.getRequestURI() + " :" + endPoint.getRemoteHost() + ""); } catch (Exception e) { } } } } compile and put in the WEB-INF/classes folder. I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar call it using http://webserver.com/servlet/thread - Original Message - From: Douglas Knudsen <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 11:54:05 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> there was some JSP code for this floating around abit ago. IIRC, credit goes to Pete Frietag. I never got this to work for me though. Some sort of caste error and I'm far from a Java guru. Anyone get this to work? <% Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i out.println("i: " + i + ""); try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println(endPoint.getServerName() + endPoint.getRequestURI() + ""); } catch (Exception e) { } } %> - Original Message - From: Adrocknaphobia <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 09:34:27 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> Well I've found the stack trace invaluable in terms of information. But the fact that you have to have your server running through command prompt makes its pretty useless. For example in a production app, you have to shut down the server. (not cool) Then restart it in a command window (not cool), then you cannot log off! (not cool) Although I'm told this is a windows only issue. Still, its great insight into problems... but you cant really get it when you need it. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 14:26:01 +0100 Subject: RE: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> And its nigh on useless in my opinion. _ From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 14:23 To: CF-Talk Subject: RE: Currently running page requests > Is there any way to get a list of currently running > page requests on the server so I can keep track or them? You can perform a dump of the current stack trace, which will list (amongst a big pile of other stuff) what's requests are currently being processed by CF. See the MM technote about it: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may co
OT: Intel HyperThreading
Okay - I fried my motherboard last weekend and have decided to build a new system instead of replacing the old one. I've been running a 950MHz with 1 Gig of RAM for a WHILE now, and I am READY for some speed now. I had in mind to build a P4 3.0GHz and have been looking at the HyperThreading technology. Heard it's great for memory hawgs like CFMX and the like. Anyone else using Intel HT technology? Any comments/suggestions welcome. Thanks, Donna -- Donna French [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
i guess u could try this http://dreamweaverfever.com/grow/ Form Button Fever! This behavior will make any object a Submit or Reset button for your form. It allows you to easily use a rollover image as a form button over even just a text link. It was created especially for those Drumbeat users moving over to UltraDev. I got bored of answering the question "how do I make such-and-such a submit button" so I got busy with a behavior. -- Original Message -- From: "Ciliotta, Mario" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 22:24:45 +0100 >Dave, > >It is sort of what I am trying to do but I need to change the color of the >button to match the rest of the buttons on the site. The users want the >buttons to be a form of blue and when you the file upload dialogue the problem >is that you get a gray browse button by default. > >Mario >-Original Message- >From: dave [mailto:[EMAIL PROTECTED] >Sent: Tuesday, September 14, 2004 5:16 PM >To: CF-Talk >Subject: Re: SOT: How to apply a style sheet to a file upload bottom. > > >i missed most of this as well but are u talking about doing this? >http://www.yockeys.com/test/b.cfm >only works in ie though >also there is an extention that turns images into submit buttons called submit >form fever (i think) > >-- Original Message -- >From: "Bryan Stevenson" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >Date: Tue, 14 Sep 2004 13:31:20 -0700 > >>Sorry...late to this thread...but AFAIK there is no way (I've tried hard in >the past) to change the style of the BROWSE button that is produced using an >input of type "file" >> >>If there is a way of changing it...I'm all ears ;-) >> >>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: 6.1 updater breaks cfdumping cfcatch, but this may help
Adam Churvis wrote: >Unfortunately, I just found out while training the MX Master Class that the ColdFusion MX 6.1 Updater broke dumping CFCATCH, > So it wasn't just me! It works if you do but not , in the latter case it gives a blank value for cfcatch. -- *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: Dynamically creating text docs
When I'm building text content, I usually use a Java StringBuffer. It's really simple: ... Do it this way and you can embed arbitrary logical constructs in your code with no problem. If you don't want to use the StringBuffer (or you can't, because you're on CF5 or less, and don't have a JVM installed), you can do the same type of thing with string concatenation. Just break it up wherever you need to add logic: The StringBuffer method will give you better performance to some degree, most notably where you have either a lot of separate concatenation operations (count the ampersands, not the CFSET tags), a lot of content, or both. cheers, barneyb On Tue, 14 Sep 2004 14:17:35 -0700, Rebecca Wells <[EMAIL PROTECTED]> wrote: > A CF application I'm building needs a feature that will create documents > using a form letter and data from a database, merging the form and the > data similar to a MailMerge operation. The only way I've been able to > get any results is by using cffile to read the form, then cfset ThisLtr > = Evaluate(formLtr), then use cfoutput and pre to output the result. > Constructing the form letter is a royal PITA because you have to asci > encode everything like this: > > #Ownername# & #chr(13)# & #chr(10)# & > #Attnline# & #chr(13)# & #chr(10)# & > #Addrline# & #chr(13)# & #chr(10)# & > #trim(CityState)# & " " & #ZipCode# > > And doing it that way, I can't get any cf conditional logic to work, > such as a cfif statement to not use the line for the Attnline if it's > blank. > > Any suggestions for a better approach? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT: How to apply a style sheet to a file upload bottom.
Dave, It is sort of what I am trying to do but I need to change the color of the button to match the rest of the buttons on the site. The users want the buttons to be a form of blue and when you the file upload dialogue the problem is that you get a gray browse button by default. Mario -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 5:16 PM To: CF-Talk Subject: Re: SOT: How to apply a style sheet to a file upload bottom. i missed most of this as well but are u talking about doing this? http://www.yockeys.com/test/b.cfm only works in ie though also there is an extention that turns images into submit buttons called submit form fever (i think) -- Original Message -- From: "Bryan Stevenson" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 13:31:20 -0700 >Sorry...late to this thread...but AFAIK there is no way (I've tried hard in the past) to change the style of the BROWSE button that is produced using an input of type "file" > >If there is a way of changing it...I'm all ears ;-) > >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]
Dynamically creating text docs
A CF application I'm building needs a feature that will create documents using a form letter and data from a database, merging the form and the data similar to a MailMerge operation. The only way I've been able to get any results is by using cffile to read the form, then cfset ThisLtr = Evaluate(formLtr), then use cfoutput and pre to output the result. Constructing the form letter is a royal PITA because you have to asci encode everything like this: #Ownername# & #chr(13)# & #chr(10)# & #Attnline# & #chr(13)# & #chr(10)# & #Addrline# & #chr(13)# & #chr(10)# & #trim(CityState)# & " " & #ZipCode# And doing it that way, I can't get any cf conditional logic to work, such as a cfif statement to not use the line for the Attnline if it's blank. Any suggestions for a better approach? This message has been scanned by the City of Renton's filtering gateway. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
i missed most of this as well but are u talking about doing this? http://www.yockeys.com/test/b.cfm only works in ie though also there is an extention that turns images into submit buttons called submit form fever (i think) -- Original Message -- From: "Bryan Stevenson" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 13:31:20 -0700 >Sorry...late to this thread...but AFAIK there is no way (I've tried hard in the past) to change the style of the BROWSE button that is produced using an input of type "file" > >If there is a way of changing it...I'm all ears ;-) > >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: Determining the size of a remote image
> So I could do it when validating the form onsubmit.. interesting .. I > didn't know _javascript_ could do that. I'll have to google for sample > code... (unless anyone would like to provide sample code before I get a > chance to do that tomorrow!) I am going to bed, but this should at least get you started: http://www.massimocorner.com/beta/img_reader.htm Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOLVED: cfexecute doesn't
The executable 'html2ps' is a perl script so I used the following as a test: arguments="/home/mike/bin/html2ps --output /home/mike/test.ps /home/mike/html2ps/html2ps.html"> And darn if it didn't work. Doug Doug James wrote: >Help! My cfexecute call does not execute! I have the appropriate >permissions set. > >Here is my code: > >arguments="-h"> >I should get something like below in my file '/home/mike/test': >Usage: > html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding] > [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num] > [-o file] [-r path] [-s num] [-S string] [-W string] [-x num] > [file|URL [file|URL [...]]] > >The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html > >What I actually get is this:'' (yes, there is nothing there). > >I am running CFMX (6,0,0,58500) on RedHat 6. > >Any suggestions on how to get this to work? > >Thanks! > >Doug > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
Sorry...late to this thread...but AFAIK there is no way (I've tried hard in the past) to change the style of the BROWSE button that is produced using an input of type "file" If there is a way of changing it...I'm all ears ;-) 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: SOT: How to apply a style sheet to a file upload bottom.
Asim, I tried the code and I get a cf error - unable to open file - java i/o error. I changed your code to display the browse button and file dialogue box along with your css-styled button and if I use the form by clicking your button, the file dialogue box will appear, I pick the file I want to upload, hit submit and get an error. But if I use the browser file dialogue and hit submit the file is uploaded with out any problem exceot that the button is not styled with CSS. Here is the code as I changed it. I cannot figure out what I did wrong. Again, thanks for all the help. Mario [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Data Visualization
you might want to get in touch with this guy, he seems to read the list and does some REALLY amazing stuff http://marcosweskamp.marumushi.com/ Regards Mark Drew On Tue, 14 Sep 2004 16:03:59 -0400, Don Chunshen Li <[EMAIL PROTECTED]> wrote: > Not line/bar chart type with cfgraph or cfchart, ah, it's a futile question. > > >Has anyone worked on data visualization technique(s) with CF/CFMX? > >If so, pls share your experience. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
hmmm, I am using the enterprise version, J2EE install, and I can not see the script names. This part bombs. jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); maybe there is something missing in my classpath or maybe a differnet JVM Doug - Original Message - From: Lee Howard <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 15:24:51 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> I like that. It worked great for me, but if you are not using enterprise it will not work. For those people you can also do the same thing with a servlet. Here is the java code. import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class threads extends HttpServlet{ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println("i: " + i + ": "); out.println(endPoint.getServerName() + endPoint.getRequestURI() + " :" + endPoint.getRemoteHost() + ""); } catch (Exception e) { } } } } compile and put in the WEB-INF/classes folder. I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar call it using http://webserver.com/servlet/thread - Original Message - From: Douglas Knudsen <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 11:54:05 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> there was some JSP code for this floating around abit ago. IIRC, credit goes to Pete Frietag. I never got this to work for me though. Some sort of caste error and I'm far from a Java guru. Anyone get this to work? <% Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i out.println("i: " + i + ""); try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println(endPoint.getServerName() + endPoint.getRequestURI() + ""); } catch (Exception e) { } } %> - Original Message - From: Adrocknaphobia <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 09:34:27 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> Well I've found the stack trace invaluable in terms of information. But the fact that you have to have your server running through command prompt makes its pretty useless. For example in a production app, you have to shut down the server. (not cool) Then restart it in a command window (not cool), then you cannot log off! (not cool) Although I'm told this is a windows only issue. Still, its great insight into problems... but you cant really get it when you need it. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 14:26:01 +0100 Subject: RE: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> And its nigh on useless in my opinion. _ From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 14:23 To: CF-Talk Subject: RE: Currently running page requests > Is there any way to get a list of currently running > page requests on the server so I can keep track or them? You can perform a dump of the current stack trace, which will list (amongst a big pile of other stuff) what's requests are currently being processed by CF. See the MM technote about it: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message
flash remoting on osx
Hey Folks, I'm trying to get Flash remoting to work on OS X. Running CFMX 6.1 on top of JRun. The flash remoting can't find the components, even though I can invoke them using the same name from CF. Here's the exception its throwing: Service threw an exception during method invocation: No service named folder.ComponentName is known to Flash Remoting. (stack trace) I have set DISABLE_CFWS_ADAPTERS to false in my web.xml file. A flash.log file was not generated, and there is nothing in the logs that point to where Flash remoting might be looking. The code works fine on windows. __ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Data Visualization
Not line/bar chart type with cfgraph or cfchart, ah, it's a futile question. >Has anyone worked on data visualization technique(s) with CF/CFMX? >If so, pls share your experience. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfexecute doesn't
Thanks for the suggestion but I have successfully gotten other things to run. outputfile="/home/mike/ls.txt"> Returns the appropriate information. Doug Barney Boisvert wrote: >The proggy might output the usage info to the STDERR rather than >STDOUT, so it's not going to your file. That's just a shot in the >dark though. > >Did you try a simple shell script that outputs a line of text (with >echo) and see if that runs properly? > >cheers, >barneyb > > >On Tue, 14 Sep 2004 15:29:13 -0400, Doug James <[EMAIL PROTECTED]> wrote: > > >>Help! My cfexecute call does not execute! I have the appropriate >>permissions set. >> >>Here is my code: >> >>arguments="-h"> >>I should get something like below in my file '/home/mike/test': >>Usage: >>html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding] >> [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num] >> [-o file] [-r path] [-s num] [-S string] [-W string] [-x num] >> [file|URL [file|URL [...]]] >> >>The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html >> >>What I actually get is this:'' (yes, there is nothing there). >> >>I am running CFMX (6,0,0,58500) on RedHat 6. >> >>Any suggestions on how to get this to work? >> >>Thanks! >> >>Doug >> >> >> > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Determining the size of a remote image
Massimo Foti wrote: > > I want to restrict the size, so that when people enter a remote URL to an > > image, it can't be any bigger than 100x100... > > Have you considered using _javascript_ for the job? You can create a new image > object out of the url entered by the user, then you read the dimensions out > of it So I could do it when validating the form onsubmit.. interesting .. I didn't know _javascript_ could do that. I'll have to google for sample code... (unless anyone would like to provide sample code before I get a chance to do that tomorrow!) - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX 6.1 updater
We are running the updater on our dev box and when it comes down to selecting the CFIDE directory, it states it is an invalid directory. Our directory is: d:\Jrun4\servers\cfusion\cfusion-ear\cfusion-war\ here you will find both the CFIDE and the WEB-INF directory. I have tried to specify the directory above with and without the \CFIDE folder and both yield the same results. Suggestions? BTW: This is a J2EE Configuration with CFMX and JRUN [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Determining the size of a remote image
You can load an image into a BufferedImage (the Java class that undoubtedly backs the image.cfc you mentioned) from an arbitrary URL. Not sure the exact syntax, but a glimpse inside image.cfc and a browser with javadocs should get you started. cheers, barneyb On Tue, 14 Sep 2004 15:43:50 -0400, Rick Root <[EMAIL PROTECTED]> wrote: > So, I've seen the image cfc that allows you to determine image size > (among other things), but those images have to be local files. > > Is there anyway to retrieve an image via a URL and determine it's size > WITHOUT reading the file in from the local file system? I would just > like to avoid a bunch of file IO, but I want to restrict the size, so > that when people enter a remote URL to an image, it can't be any bigger > than 100x100... > > Trying to avoid file I/O. > > - Rick > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Determining the size of a remote image
> I want to restrict the size, so that when people enter a remote URL to an > image, it can't be any bigger than 100x100... Have you considered using _javascript_ for the job? You can create a new image object out of the url entered by the user, then you read the dimensions out of it Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Determining the size of a remote image
You can get the physical size of the file from the web server without downloading it but not the height/width of the image. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion applications >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Rick Root To: CF-Talk Sent: Tuesday, September 14, 2004 3:43 PM Subject: Determining the size of a remote image So, I've seen the image cfc that allows you to determine image size (among other things), but those images have to be local files. Is there anyway to retrieve an image via a URL and determine it's size WITHOUT reading the file in from the local file system? I would just like to avoid a bunch of file IO, but I want to restrict the size, so that when people enter a remote URL to an image, it can't be any bigger than 100x100... Trying to avoid file I/O. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
> This site is work-safe ;) BOOoo! Hi! :-) --Matt-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Determining the size of a remote image
> I want to restrict the size, so that when people enter a remote URL to an > image, it can't be any bigger than 100x100... Have you considered using _javascript_ for the job? You can create a new image object out of the url entered by the user, then you read the dimensions out of it Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Help Macromedia! MX service is crashing constantly!
Chad, In case you are subscribed to this posting... did you find a specific cause or solution? We are running into the same problem. >We have run into a major problem with MX. It will not stay running. The >service shuts down then restarts under load. > >Im not sure if this is access database related, but we are getting a REALLY >bad error. If the pages are hit repeatedly i can replicate this >error. This also happens for all of our web sites. It is not code related. > >The web page sits and spins and displays this error: > >Server Error >The server encountered an internal error and was unable to complete your >request. > >Then i check the server event viewer and see this error: >The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) >cannot be found. The local computer may not have the necessary registry >information or message DLL files to display messages from a remote >computer. The following information is part of the event: ColdFusion MX >ODBC [EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset >by peer. > >Then the service restarts with this error! > >The ColdFusion MX Application Server service for the "default" server is >restarting. > >The ColdFusion MX Application Server service for the "default" server was >started. PID is 1784. > > >I can get the service to shut down and restart with a MySQL database also. > >I get this error: >The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) >cannot be found. The local computer may not have the necessary registry >information or message DLL files to display messages from a remote >computer. You may be able to use the /AUXSOURCE= flag to retrieve this >description; see Help and Support for details. The following information is >part of the event: ColdFusion MX ODBC >[EMAIL PROTECTED],ErrorCode=2310,ErrorMessage=TCP/IP, connection reset by peer. > > >These errors are happening on two of our development servers. Im not >taking MX on to a production server until i feel a heck of a lot more >comfortable. > >We upgraded from 4.5.1 to MX. One box we upgraded then un-installed so we >could do a "Fresh" install of MX, not an upgrade. This did not help > >here are some server details: >P3 800 >500megs ram >Win 2k Server >IIS5 > >If more detail is need i will be happy to provide it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfexecute doesn't
The proggy might output the usage info to the STDERR rather than STDOUT, so it's not going to your file. That's just a shot in the dark though. Did you try a simple shell script that outputs a line of text (with echo) and see if that runs properly? cheers, barneyb On Tue, 14 Sep 2004 15:29:13 -0400, Doug James <[EMAIL PROTECTED]> wrote: > Help! My cfexecute call does not execute! I have the appropriate > permissions set. > > Here is my code: > > arguments="-h"> > I should get something like below in my file '/home/mike/test': > Usage: > html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding] > [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num] > [-o file] [-r path] [-s num] [-S string] [-W string] [-x num] > [file|URL [file|URL [...]]] > > The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html > > What I actually get is this:'' (yes, there is nothing there). > > I am running CFMX (6,0,0,58500) on RedHat 6. > > Any suggestions on how to get this to work? > > Thanks! > > Doug > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Determining the size of a remote image
So, I've seen the image cfc that allows you to determine image size (among other things), but those images have to be local files. Is there anyway to retrieve an image via a URL and determine it's size WITHOUT reading the file in from the local file system? I would just like to avoid a bunch of file IO, but I want to restrict the size, so that when people enter a remote URL to an image, it can't be any bigger than 100x100... Trying to avoid file I/O. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Adam, I am thinking you may be right based on my last post regarding the EXECUTE privilege. Running it from SQL*PLUS has the same results: SQL> exec test01.testpckg; BEGIN test01.testpckg; END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TESTPCKG' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Scott -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 1:05 PM To: CF-Talk Subject: Re: Oracle Stored Procedures No, by default this package will be created under the user who compiles it (the schema owner). Janet what are you thoughts on the variable type? I haven't been able to return a ref cursour when its specified as just OUT. I still think the account they are giving you isnt kosher. Atleast if you test it as the schema owner, it can rule that out. -Adam _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
6.1 updater breaks cfdumping cfcatch, but this may help
Folks, Unfortunately, I just found out while training the MX Master Class that the ColdFusion MX 6.1 Updater broke dumping CFCATCH, which was a great help during development when incorporating structured exception handling into your code. There is also a new problem introduced where at least some type="Object" exceptions are no longer published as such, so they slip by all CFCATCHes -- even type="Any". To help people out, I have created a little Zip file containing HTML files that display the details of CFDUMPs of the CFCATCH structures published by each type of exception (except Object, which I can't seem to catch anymore). You can use these during development to help you remember where keys and subkeys are and what they contain so you can granularly test for them inside your CFCATCH blocks. I also included a note about the problem with type="Object". You can download it from http://www.ProductivityEnhancement.com. I hope this helps. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive Training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Deanna, It is not one of my DBA's, it's an outside vendor so I do not want to post the code. I have actually been changing the package name as well for that reason in my posts. They can run it on their side with no issue using pl/sql developer. I can also run the qry that the procedure executes using a regular cfquery call as well. It is only when I try to run their procedure using CF that the issue arises. Thanks, Scott -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 1:48 PM To: CF-Talk Subject: Re: Oracle Stored Procedures Scott, Are you sure that it's actually returning a ref cursor? You'll get this error if you say that you are returning one, but for some reason one is not returned. For example, if you have error trapping in your procedure and the cursor never gets opened. Therefore, if I'm returning a cursor, I always make sure that if I've trapped errors and not opened the intended cursor, that I open a "dummy" cursor and return that. (This would probably be easier to debug if your DBA's would give you the code to the cursor. Based on the name, it looks like it's not "real" code anyway. Think you could talk them into it?) > >Janet, > >I have the snippet now from them. This is how it's currently defined > >(which looks like it's in line with what you posted aside from In Out): > > > >Type ReturnSet is ref cursor; > >Procedure testpckg(curReturnSet Out Returnset); > > > >They had switched it before to be In Out for me and I still had the same > >error. The one thing I did notice is they do not have it defined with a > >schema name, they just have: > > > >package Test01 is > > > >Type ReturnSet is ref cursor; > > > >Procedure testpckg(curReturnSet Out Returnset); > > > >Could that possible cause a permissions issue as Adam had alluded too? > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfexecute doesn't
Help! My cfexecute call does not execute! I have the appropriate permissions set. Here is my code: arguments="-h"> I should get something like below in my file '/home/mike/test': Usage: html2ps [-2cdDFghHLnORtTuUv] [-b URL] [-C string] [-e encoding] [-f file[:file[:...]]] [-i num] [-k file] [-l lang] [-m num] [-N num] [-o file] [-r path] [-s num] [-S string] [-W string] [-x num] [file|URL [file|URL [...]]] The html2ps users guide is available as /home/mike/lib/html2ps/html2ps.html What I actually get is this:'' (yes, there is nothing there). I am running CFMX (6,0,0,58500) on RedHat 6. Any suggestions on how to get this to work? Thanks! Doug [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Data Visualization
Has anyone worked on data visualization technique(s) with CF/CFMX? If so, pls share your experience. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Janet/Adam, First off thank you guys for all your help thus far, it is greatly appreciated. They did switch it to IN OUT this morning for me and I had the same results. I checked the permissions using the queries Janet supplied: For roles my user has CONNECT and CTXAPP. For table privileges I ran select * from user_tab_privs where privilege = 'EXECUTE' and the none of the results had the package or procedure name in the TABLE_NAME field (which is where I assumed i'd see it). None of the TABLE_NAME's where the table I know the procedure runs against either. Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 1:14 PM To: CF-Talk Subject: RE: Oracle Stored Procedures Scott - I think you need the IN OUT that Adam mentioned. When you connect via SQL*Plus and successfully run the procedure, are you using the same username and password that is defined in the CF data source? If so, then I do not think it is a permissions problem but I could be wrong. If not, it might be a permissions problem. You could test this by changing your CF code to specify the username and password in the stored procedure call that you use when you successfully run the procedure in SQL*Plus. I think this will override what is stored in the CF data source definition (but I am not sure). The only permission you need is EXECUTE on the package in Oracle. If you can connect to Oracle via SQL*Plus as the user running the stored procedure, you can execute 'select * from user_tab_privs' to see what privileges that user is granted. If the user is granted execute directly on the package, you will see an entry in that table. If the user is granted execute via role, it is harder to figure out because you need to look at the roles granted to the user (select * from user_role_privs) and then what object privileges are granted to the roles (not a single SQL statement). HTH. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Currently running page requests
I like that. It worked great for me, but if you are not using enterprise it will not work. For those people you can also do the same thing with a servlet. Here is the java code. import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class threads extends HttpServlet{ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ resp.setContentType("text/html"); PrintWriter out = resp.getWriter(); Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println("i: " + i + ": "); out.println(endPoint.getServerName() + endPoint.getRequestURI() + " :" + endPoint.getRemoteHost() + ""); } catch (Exception e) { } } } } compile and put in the WEB-INF/classes folder. I compiled using javac thread.java -classpath c:\cfusionmx\runtime\lib\jrun.jar call it using http://webserver.com/servlet/thread - Original Message - From: Douglas Knudsen <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 11:54:05 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> there was some JSP code for this floating around abit ago. IIRC, credit goes to Pete Frietag. I never got this to work for me though. Some sort of caste error and I'm far from a Java guru. Anyone get this to work? <% Thread thread = Thread.currentThread(); ThreadGroup threadGroup = thread.getThreadGroup(); int count = threadGroup.activeCount(); Thread[] threads = new Thread[count]; count = threadGroup.enumerate(threads); out.println("Thread Count: " + count + ""); for (int i=0;i out.println("i: " + i + ""); try { jrunx.scheduler.WorkerThread t = (jrunx.scheduler.WorkerThread)threads[i]; jrun.servlet.http.WebEndpoint endPoint = (jrun.servlet.http.WebEndpoint)t.getServletRequest(); out.println(endPoint.getServerName() + endPoint.getRequestURI() + ""); } catch (Exception e) { } } %> - Original Message - From: Adrocknaphobia <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 09:34:27 -0400 Subject: Re: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> Well I've found the stack trace invaluable in terms of information. But the fact that you have to have your server running through command prompt makes its pretty useless. For example in a production app, you have to shut down the server. (not cool) Then restart it in a command window (not cool), then you cannot log off! (not cool) Although I'm told this is a windows only issue. Still, its great insight into problems... but you cant really get it when you need it. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 14:26:01 +0100 Subject: RE: Currently running page requests To: CF-Talk <[EMAIL PROTECTED]> And its nigh on useless in my opinion. _ From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 14 September 2004 14:23 To: CF-Talk Subject: RE: Currently running page requests > Is there any way to get a list of currently running > page requests on the server so I can keep track or them? You can perform a dump of the current stack trace, which will list (amongst a big pile of other stuff) what's requests are currently being processed by CF. See the MM technote about it: http://www.macromedia.com/support/coldfusion/ts/documents/tn18339.htm Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: To lock or not to lock
Thanks for sharing your thought. I don't know how others do their coding, in my practice, I usually set application variables at the application.cfm template level, it's really global variables, rarely changed. > In CF5 you're supposed to lock ALL shared scope access to avoid > memory > corruption. With CFMX you only have to lock for avoidance of race > conditions, because the underlying java runtime deals the memory > issues. > > Clustered environment doesn't matter, because CFLOCK is local to the > machine in question, not the cluster. > > If application variables (including instance variables of any > application-scope CFCs) are set to a value and never change > (exceedingly rare), then yes, you can skip locking. However, you may > as well just set them into the request scope, since they're going to > be set every request. You can use CFLOCK in this situation to only > load the variables once and improve performace. If you're > instantiating large CFCs, the performance increase can be huge. > > cheers, > barneyb > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF Temp Files
I know there was a bug in CFMX where temp files generated by CFFILE action="" weren't ever cleaned up. It was resolved with a hotfix. What about temp files that are created by your application (using getTempFile(getTempDirectory(), "pref")))? Do those ever get cleaned up automatically? I can't seem to find any info on this either way. thanks, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[SOLVED] Timeout on files over 2mb using CFFILE
FYI, I found the solution to this problem. URL Scan was installed on the server and it had a file upload size limit set to 2 MB. I figured I'd let everyone know the problem for future reference and for the archives. Thanks. John Burns -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 12:54 PM To: CF-Talk Subject: Timeout on files over 2mb using CFFILE I have a situation where a server (on a military base that we don't have control over) will upload files fine that are under 2MB. As soon as you try uploading a file larger than 2MB the page thinks for about a second and goes immediately to a page not found error. We can do files that are 1.9MB and they work fine, it seems to be something with going over 2MB. The server is Windows 2000 Server with IIS as the web server and it was recently upgraded to MX 6.1 and then this problem was noticed. Is there some setting in CF that would effect the size of the upload allowed? Any suggestions or info to point me in the right direction would be great. Thanks! John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Null null error ARGHHH!
Just to update the list. Looks like there are two bugs that MM has confirmed that will cause a Null Null error. (per http://www.talkingtree.com/blog/index.cfm?data=""> Bug numbers 51579 and 45343. ColdFusion MX 6.1 Updater may contain one fixfor the (45343) NULL NULL error. Bug 45343: "The cfapplication tag generated exceptions if the browser sent an incomplete CFID/CFTOKEN pair." This description seems to describe what I am seeing. Guess it is time to install the ColdFusion MX 6.1 Updater. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 From: Al Everett [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 12:38 PM To: CF-Talk Subject: Re: Null null error ARGHHH! See: http://www.talkingtree.com/blog/index.cfm?data=""> --- Alisa Thomson <[EMAIL PROTECTED]> wrote: > I am getting the same error except mine is pointing to a CFQUERY. I am > running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect > 5.5. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- NEWS - cfcertification.com
>Did anyone recently visit >http://www.cfcertification.com/ Just as an FYI to all: This website USED to be ColdFusion related. I believe it was run by several ColdFusioners. They had a PDF file as study material for the ColdFusion 4.5 exam. I don't think they ever updated their material for CF 5.0 and know for a fact they didn't update it for CFMX. Basically, the site owners let the site die and didn't renew/keep the domain name. Some spammer realized that the website ranked well in Google and had a large page linkage presence thru-out the Net, and they scooped up the domain name and put up their p0rn0 site in its place. Happens all the time. That being said, if you're looking ColdFusion Certification prep materials, check CFMX Exam Buster at: http://centrasoft.com This site is work-safe ;) Thanks, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate ColdFusion MX Certification Exam testing tool: Check out CFMX Exam Buster at: http://www.centrasoft.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Variable names stored in database - SOLVED
135px;font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;font-size: 10px;text-align: left;padding: 5 5 5 5;color : #variables.txtcolor##")> SELECT * FROM FRED #Evaluate(DE(chris.text))# -Original Message- From: Shawn McKee [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 9:19 AM To: CF-Talk Subject: Variable names stored in database I would like to store style sheet information in a database but need to be able to change some of the parameters on the fly. If a straight file doing the variable substitutions is no big deal. SELECT color FROM spec_table WHERE customer = 42
div.template1{
width: 300;
height: 250;
border: 1px solid black;
background-color : #variables.bgcolor#;
}
Yes I know I don't need to use the extra step in this case but if it is stored in a DB I need constant names in string. So is it possible to store the style block in a DB and then do the variable replacement? Shawn McKee Mgr., Web Development http://www.newsstand.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: To lock or not to lock
In CF5 you're supposed to lock ALL shared scope access to avoid memory corruption. With CFMX you only have to lock for avoidance of race conditions, because the underlying java runtime deals the memory issues. Clustered environment doesn't matter, because CFLOCK is local to the machine in question, not the cluster. If application variables (including instance variables of any application-scope CFCs) are set to a value and never change (exceedingly rare), then yes, you can skip locking. However, you may as well just set them into the request scope, since they're going to be set every request. You can use CFLOCK in this situation to only load the variables once and improve performace. If you're instantiating large CFCs, the performance increase can be huge. cheers, barneyb On Tue, 14 Sep 2004 14:40:25 -0400, Don Chunshen Li <[EMAIL PROTECTED]> wrote: > This seems to be a timeless question of possible confusion. This is my understanding of cf5.x and cf6.x, for a single cf server (not clustered) environment, application and server variables do not need to be locked when none of them needs to be modified in the course of applications execution, why? they are always the same for all users, so why lock them? > while session variables is totally different. Any one disagree? > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle Stored Procedures
Scott, Are you sure that it's actually returning a ref cursor? You'll get this error if you say that you are returning one, but for some reason one is not returned. For example, if you have error trapping in your procedure and the cursor never gets opened. Therefore, if I'm returning a cursor, I always make sure that if I've trapped errors and not opened the intended cursor, that I open a "dummy" cursor and return that. (This would probably be easier to debug if your DBA's would give you the code to the cursor. Based on the name, it looks like it's not "real" code anyway. Think you could talk them into it?) > >Janet, > >I have the snippet now from them. This is how it's currently defined > >(which looks like it's in line with what you posted aside from In Out): > > > >Type ReturnSet is ref cursor; > >Procedure testpckg(curReturnSet Out Returnset); > > > >They had switched it before to be In Out for me and I still had the same > >error. The one thing I did notice is they do not have it defined with a > >schema name, they just have: > > > >package Test01 is > > > >Type ReturnSet is ref cursor; > > > >Procedure testpckg(curReturnSet Out Returnset); > > > >Could that possible cause a permissions issue as Adam had alluded too? > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
To lock or not to lock
This seems to be a timeless question of possible confusion. This is my understanding of cf5.x and cf6.x, for a single cf server (not clustered) environment, application and server variables do not need to be locked when none of them needs to be modified in the course of applications execution, why? they are always the same for all users, so why lock them? while session variables is totally different. Any one disagree? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
Revised Code - style="font-style:veranda; font-size:12px; font-weight:bold;text-transform:lowercase;color:white;background-color:#557799;height:22px;border-style:ridge;text-align:center;" value="Select a File..."> value="Submit The Form Now!" style="font-style:veranda; font-size:12px;"> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
The below is the code which swap the button to a graphic image. but thats not the solution, its not uploading the file. Bob, The article I was talking about, that girl actually explained it that how it could possible. Anyway, I will go home and check my notes again to find out that URL and will post later sometime this week. - Asim style="font-style:veranda; font-size:12px; font-weight:bold;text-transform:lowercase;color:white;background-color:#557799;height:22px;border-style:ridge;text-align:center;" value="Select a File..."> value="Submit The Form Now!" style="font-style:veranda; font-size:12px;"> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SuSE Linux Enterprise Server 9 anyone?
thank you. >>> [EMAIL PROTECTED] 9/14/2004 11:16:32 AM >>> Lawrence Ng wrote: > Thanks Jordan... > > do u have the url to blue dragon for more info? Sure. =) http://www.newatlanta.com/products/bluedragon/index.cfm -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle Stored Procedures
At 02:04 PM 9/14/2004 -0400, you wrote: >No, by default this package will be created under the user who >compiles it (the schema owner). Janet what are you thoughts on the >variable type? I haven't been able to return a ref cursour when its >specified as just OUT. Adam - You are correct. The package is owned by the user who creates it and they are the only ones who can execute a procedure in the package until they 'grant execute on the package' to the user executing it or to a role granted to the user or to public (which most DBA's will frown upon). I also think the variable type needs to be of type IN OUT as mentioned previously. Janet. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SuSE Linux Enterprise Server 9 anyone?
Lawrence Ng wrote: > Thanks Jordan... > > do u have the url to blue dragon for more info? Sure. =) http://www.newatlanta.com/products/bluedragon/index.cfm -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Scott - I think you need the IN OUT that Adam mentioned. When you connect via SQL*Plus and successfully run the procedure, are you using the same username and password that is defined in the CF data source? If so, then I do not think it is a permissions problem but I could be wrong. If not, it might be a permissions problem. You could test this by changing your CF code to specify the username and password in the stored procedure call that you use when you successfully run the procedure in SQL*Plus. I think this will override what is stored in the CF data source definition (but I am not sure). The only permission you need is EXECUTE on the package in Oracle. If you can connect to Oracle via SQL*Plus as the user running the stored procedure, you can execute 'select * from user_tab_privs' to see what privileges that user is granted. If the user is granted execute directly on the package, you will see an entry in that table. If the user is granted execute via role, it is harder to figure out because you need to look at the roles granted to the user (select * from user_role_privs) and then what object privileges are granted to the roles (not a single SQL statement). HTH. Janet. At 01:49 PM 9/14/2004 -0400, you wrote: >Janet, >I have the snippet now from them. This is how it's currently defined >(which looks like it's in line with what you posted aside from In Out): > >Type ReturnSet is ref cursor; >Procedure testpckg(curReturnSet Out Returnset); > >They had switched it before to be In Out for me and I still had the same >error. The one thing I did notice is they do not have it defined with a >schema name, they just have: > >package Test01 is > >Type ReturnSet is ref cursor; > >Procedure testpckg(curReturnSet Out Returnset); > >Could that possible cause a permissions issue as Adam had alluded too? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle Stored Procedures
No, by default this package will be created under the user who compiles it (the schema owner). Janet what are you thoughts on the variable type? I haven't been able to return a ref cursour when its specified as just OUT. I still think the account they are giving you isnt kosher. Atleast if you test it as the schema owner, it can rule that out. -Adam - Original Message - From: Scott Mulholland <[EMAIL PROTECTED]> Date: Tue, 14 Sep 2004 13:49:52 -0400 Subject: RE: Oracle Stored Procedures To: CF-Talk <[EMAIL PROTECTED]> Janet, I have the snippet now from them. This is how it's currently defined (which looks like it's in line with what you posted aside from In Out): Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); They had switched it before to be In Out for me and I still had the same error. The one thing I did notice is they do not have it defined with a schema name, they just have: package Test01 is Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); Could that possible cause a permissions issue as Adam had alluded too? Thanks, Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:11 AM To: CF-Talk Subject: RE: Oracle Stored Procedures It might be something to do with the way the refcursor is defined in the package. Would they be willing to change the package so the refcursor is defined like this? CREATE OR REPLACE PACKAGE schemaname.testpckg IS TYPE curreturnset_type_ref_cursor IS REF CURSOR; PROCEDURE testpckg( curreturnset IN OUT curreturnset_type_ref_cursor); END; At 10:57 AM 9/14/2004 -0400, you wrote: >Here is the new specification: > > PROCEDURE TESTPCKG > Argument NameType IN/OUT >Default? > > > CURRETURNSET REF CURSOR IN/OUT > > >The code I'm using to call it is: > > > > dataSource = "#ds#"> > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SuSE Linux Enterprise Server 9 anyone?
Thanks Jordan... do u have the url to blue dragon for more info? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SuSE Linux Enterprise Server 9 anyone?
Lawrence Ng wrote: > hello all, > > Are/Have any of you installed SuSE Linux Enterprise Server 9 which was > just released last month and see how it is with MX? > > We are still deciding if we want to install version 9 or current > version 8. > > The key is the verity search tool for files which currently does not > work under our Nix platform. Hopefully Blackstone would improve on > things even under version 9. > > feedbacks appreciated. The Blue Dragon CFML engine uses Lucene, which is from the apache foundation and is written entirely in java. So, it's pretty safe to say that it works in *nix environments. Also, while SuSE isn't an officially supported OS of Blue Dragon, I've had great success getting it to run smoothly on SuSE 8.2 Professional. (I have plans to try it on 9.1, just haven't gotten around to it yet) At any rate, I believe it's a viable option if you're looking to run a CF-Based search enginein a *nix environment. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
Janet, I have the snippet now from them. This is how it's currently defined (which looks like it's in line with what you posted aside from In Out): Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); They had switched it before to be In Out for me and I still had the same error. The one thing I did notice is they do not have it defined with a schema name, they just have: package Test01 is Type ReturnSet is ref cursor; Procedure testpckg(curReturnSet Out Returnset); Could that possible cause a permissions issue as Adam had alluded too? Thanks, Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:11 AM To: CF-Talk Subject: RE: Oracle Stored Procedures It might be something to do with the way the refcursor is defined in the package. Would they be willing to change the package so the refcursor is defined like this? CREATE OR REPLACE PACKAGE schemaname.testpckg IS TYPE curreturnset_type_ref_cursor IS REF CURSOR; PROCEDURE testpckg( curreturnset IN OUT curreturnset_type_ref_cursor); END; At 10:57 AM 9/14/2004 -0400, you wrote: >Here is the new specification: > > PROCEDURE TESTPCKG > Argument NameType IN/OUT >Default? > > > CURRETURNSET REF CURSOR IN/OUT > > >The code I'm using to call it is: > > > > dataSource = "#ds#"> > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Null null error ARGHHH!
See: http://www.talkingtree.com/blog/index.cfm?data=""> --- Alisa Thomson <[EMAIL PROTECTED]> wrote: > I am getting the same error except mine is pointing to a CFQUERY. I am > running CFMX 6.1 Updater 3 on Solaris with Sybase 12.5 and jConnect > 5.5. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Spam?] Re: Regex help
I think you are missing a ] REReplace(ThisTag.GeneratedContent, "\[[^\]]*\]", "", "All") Or maybe even "\[[^]]*\]" On cfmx, you could use non-greedy matches: "\[.*?\]" Pascal > -Original Message- > From: Dirk De Bock - Listclient [mailto:[EMAIL PROTECTED] > Sent: 14 September 2004 19:14 > To: CF-Talk > Subject: [Spam?] Re: Regex help > > This is working ok in CF5 but apparently not in CFMX > > Malformed regular _expression_ "\[[^\]*\]". > Reason: Unmatched [] in _expression_.. > > REReplace(ThisTag.GeneratedContent, "\[[^\]*\]", "", "All") > > it's supposed to strip all [] with everyting inbetween the brackets > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle Stored Procedures
We are using the Oracle drivers that ship with MX Enterprise so according to that technote we should be ok with ref cursors. Thanks for the info Janet, I'm currently looking into having the cursor defined along the lines of your last post. Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:21 AM To: CF-Talk Subject: RE: Oracle Stored Procedures Scott - The other thing you might want to look at is what Oracle drivers are being used. I know there are issues with some of the drivers and Oracle stored procedures. Here is a technote regarding one Oracle driver that mentions support for Oracle refcursors: http://www.macromedia.com/support/coldfusion/ts/documents/tn18344.htm Janet. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Question about processing a CSV file.
I have done a lot of work with file imports, you can check out cfx_text2query: http://www.emerle.net/programming/display.cfm/t/cfx_text2query Though, your CSV seems simple enough to parse as a list, without anything fancy.. unless that file is huge.. -R On Mon, 13 Sep 2004 22:36:19 +0100, Ciliotta, Mario <[EMAIL PROTECTED]> wrote: > > Hi, > > I was wondering if anyone could help me out as I am stuck on this part. I > have a csv file that I would like to read and then issue an update query based > on the contents. > > Basically I would like to read the file and then loop over the file and issue > and update query for each line (maybe I could convert it to stored procedure > later). > > The file looks like this: > > "5388120","12345678IL" > "5388150","FDX123FD45" > "5388165","RT6789" > "5388198","12345HY890" > "5388204","123SEDFRT" > "5388205","1ASEFFBH6" > "5388209","12890HFS23" > "5388212","124300HGFS" > "5388231","123567UHJK" > "5388235","12WWE4DD45" > "5388281","1234RFGT76" > "5388284","313SFFS67" > "5388361","23DS45" > "5388366","4422442242" > "5388372","42242FDFSF" > "5388403","FDXUPSDELD" > "5388409","1234567890" > "5388414","ASWDERF455" > "5388415","123EDCVBH6" > "5388417","12WSED56YH" > "5388424","12WSC56HBN" > "5388428","123WSE456H" > "5388510","313DADDADA" > "5388511","HFH678947S" > "5388597","3131ADADAD" > "5388654","ADA5DFA5RD" > "5388655","AD4242DDAA" > "5388661","1331XSSA4D" > > And what I want to do is loop over it and issue an update: > PUSEDOCODE: > > > update table >set track_nbr = '2345678il' > where header_id = 5388120 > > > What is the best way to do this. I can process the file but I am lost as to > what to do. > > This is what I have so far: > > > > > > variable = "Variables.SourceFile"> > > > delimiters="#RecordDelimiter#"> > > > > > > > Thanks > Mario > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: How to apply a style sheet to a file upload bottom.
I couldn't find that link yet, but I still had an idea that what was mentioned in that article. I have posted the link for you guys to review and advise. in this link, i have play with a trick to swap the browse button, and then post it to the .cfm file, through _javascript_ I am putting the value in the field. Let me know if that make sense so, I will post the codes on my next thread. http://www.logikzone.com/temp/upload.cfm Thanks >> I have seen that trick somewhere on web awhile ago, >> I am trying to find the link and will post. > >You can do the "trick" using CSS and _javascript_ and the GUI can be >stylized as you want. The file upload function however won't work -- a >0 bit file is what's uploaded. That's due to a security measure built >into the browser. > >I've gone down this road before as have others. It's been a while >though. If you find a solution, which doesn't break the upload >functionality, please post. I'd be interested to see it. Thanks. > > >- >Regards, >Bob Haroche >O n P o i n t S o l u t i o n s >www.OnPointSolutions.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]