Re: i need help stripping :)
i have gotten it written to a file and read and here is the output using listLast not really giving me the last, maybe cause im writing tot a txt andnot a csv? http://www.rockymtanglers.com/flows/try.cfm code !--- retrieve info from USGS website --- cfhttp url="" method=get /cfhttp !--- place contents into a formated variable --- cfset page = #HTMLEditFormat(cfhttp.filecontent)# !--- write variable to text file --- cffile action="" addnewline=no file=c:/websites/sites/flows/flowData.txt output=#page# !--- read from just written text file --- cffile action="" file=c:/websites/sites/flows/flowData.txt variable=data !--- cfdump var=#data# --- !--- get last line from test file --- cfset line = listLast(data, chr(13)) cfoutput #Line# /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
i cant find anything grr -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 22 Jul 2004 22:31:44 -0500 i have talked to them and really have no friggin clue where are the feeds at? maybe i missed them but that would be SOO much better! i don't know off-hand, you said their xml output doesnt work which implies there was one. there seems to be an effort to move to xml there: http://search.usgs.gov/query.html?col=usgsoq=site%3Awater.usgs.govrq=1qt=xml http://water.usgs.gov/nwis_activities/XML/nwis_hml.htm http://water.usgs.gov/nwis_activities/XML/Documentation/HYDROML.html kind of hard for 'them' not to know about this, maybe you need to travel up the food chain? the quake stuff was buried pretty good http://earthquake.usgs.gov/recenteqsww/rss.html maybe the surface water is as well. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Caching CFC's
Is the constructor in a CFC always called in CFMX when you call a method in that CFC? That's seems a bit odd to me. In my imagination, I only call the init method once, when I create the object in the application scope. After that the init is not directly invoked by me. The second example does though, but that one was merely a test to see the difference in datetime. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Caching CFC's
Nevermind, I see what you mean, it was a bug in the second part. That line should only call init on the IOFactory in the variables scope. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
k now i have changed this line cfset line = listLast(data, chr(13)) to cfset line = listLast(data, USGS) and works to this point http://www.rockymtanglers.com/flows/try3.cfm but now im having troubles sereating them out -- Original Message -- From: dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 23 Jul 2004 02:22:54 -0400 i have gotten it written to a file and read and here is the output using listLast not really giving me the last, maybe cause im writing tot a txt andnot a csv? http://www.rockymtanglers.com/flows/try.cfm code !--- retrieve info from USGS website --- cfhttp url="" method=get /cfhttp !--- place contents into a formated variable --- cfset page = #HTMLEditFormat(cfhttp.filecontent)# !--- write variable to text file --- cffile action="" addnewline=no file=c:/websites/sites/flows/flowData.txt output=#page# !--- read from just written text file --- cffile action="" file=c:/websites/sites/flows/flowData.txt variable=data !--- cfdump var=#data# --- !--- get last line from test file --- cfset line = listLast(data, chr(13)) cfoutput #Line# /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
no need to write read a file. Just use the CFHTTP.FileContent prolly the reason listlast doesn't work is the new lines are 2 chars CR LF 1) rereplace all chr(13) with nothing 2) specify chr(10) as a delimiter in the listlast (last paraneter) HTH Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 22, 2004, at 11:22 PM, dave wrote: i have gotten it written to a file and read and here is the output using listLast not really giving me the last, maybe cause im writing tot a txt andnot a csv? http://www.rockymtanglers.com/flows/try.cfm code !--- retrieve info from USGS website --- cfhttp url="" dd_cd=01dd_cd=18format=rdbperiod=1site_no=090851_00060 method=get /cfhttp !--- place contents into a formated variable --- cfset page = #HTMLEditFormat(cfhttp.filecontent)# !--- write variable to text file --- cffile action=""> addnewline=no file=c:/websites/sites/flows/flowData.txt output=#page# !--- read from just written text file --- cffile action=""> file=c:/websites/sites/flows/flowData.txt variable=data !--- cfdump var=#data# --- !--- get last line from test file --- cfset line = listLast(data, chr(13)) cfoutput #Line# /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OO Coding Relational Databases
1: I think they call it brute force, where data access is in the business objects themselves (queries right in the classes). This is generally frowned upon. It's correct to say that many OO-pattern-bandwagon-jumpers frown on this. IMO it's also correct to say that for the majority ofapplications this is in fact an appropriate mechanism, unless your app is specifically targeting multiple physical storage platforms. The latter case is what the DAO pattern is actually for. Don't be persuaded that because an OO pattern sounds clever, it's actually appropriate for what you're trying to do. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: checking if variables are defined within invoke
Another way, not always appropriate but depending on your logic, you can give the argument a default in the CFC.That way if the variable isn't passed to the CFC, it wont cause an error.Mind you, if you use it in the wrong place you wont throw an error, you'll have wrong values in your function, so be careful where you use it. cffunction name=thisfunction cfargument name=foo default=thisvalue . stuff . /cffunction Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, 23 July 2004 9:43 AM To: CF-Talk Subject: RE: checking if variables are defined within invoke Is there a way to check if variables exist within a cfinvoke? cfif isdefined(foo)GOO = #foo#/cfif doesnt work Do you have to write a whole separate cfinvoke? You could use the Iif function, I guess, but you could also just check for the variable's existence before your CFINVOKE tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: A script to Prevent SQL Injection: feedback/suggestions?
AFAIK, it actually does more than validation and escaping Yup, that's right -- I was just simplifying things a bit...:) 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: i need help stripping :)
thanks 4 helping dick really this line does most of what i need cfset last = listLast(data, USGS) takes me right to the last entry without messing with the rest heres the code to get there cfhttp url="" method=get /cfhttp cfset data = ""> cfset last = listLast(data, USGS) which gives me an output of 09085000 2004-07-23 00:45 790 63.1 now all i need to do is take each piece and insert to db 09085000 = river code 2004-07-23 = date 00:45 = time 790 = river flow 63.1 = water temp the prob im having is peicing it out i tried what matthew suggested but threw errors i thought listGetat would work but it doesnt i been up 2 damn long lol -- Original Message -- From: Dick Applebaum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 22 Jul 2004 23:59:26 -0700 no need to write read a file. Just use the CFHTTP.FileContent prolly the reason listlast doesn't work is the new lines are 2 chars CR LF 1) rereplace all chr(13) with nothing 2) specify chr(10) as a delimiter in the listlast (last paraneter) HTH Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 22, 2004, at 11:22 PM, dave wrote: i have gotten it written to a file and read and here is the output using listLast not really giving me the last, maybe cause im writing tot a txt andnot a csv? http://www.rockymtanglers.com/flows/try.cfm code !--- retrieve info from USGS website --- cfhttp url="" dd_cd=01dd_cd=18format=rdbperiod=1site_no=090851_00060 method=get /cfhttp !--- place contents into a formated variable --- cfset page = #HTMLEditFormat(cfhttp.filecontent)# !--- write variable to text file --- cffile action=""> addnewline=no file=c:/websites/sites/flows/flowData.txt output=#page# !--- read from just written text file --- cffile action=""> file=c:/websites/sites/flows/flowData.txt variable=data !--- cfdump var=#data# --- !--- get last line from test file --- cfset line = listLast(data, chr(13)) cfoutput #Line# /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Urgent help needed Please
What is the error that is being returned? G On Thu, 22 Jul 2004 21:40:33 -0400, Sangeeta Karmokar [EMAIL PROTECTED] wrote: I am posting this question and no one is responding... Can anyone please respond. I think I am sounding dum in your world... Sangeeta Can anyone help me I am new to CF. we have backend as MySql and I am trying to insert into a database created in SQL using this query: cfquery name=add datasource=newmembers INSERT INTO members (name,email) VALUES ('#name#','#email#') /cfquery But it is not adding to the database, the submit is just going to the query page and we can see all these codes in browsers... I think the problem is, coldfusion server is not parsing code before handing it over to the webserver. we are working on Mac OS X with MySql. How to fix this problem... I really need help... Sangeeta [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
ok i think i found the problem here the code on the page im pulling in is wrapped with a pre/pre tag and quick thoughts on stripping that out? thats why chr(10) chr(13) arent working [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: session var problems with Mac uses?
At 09:26 PM 7/22/2004, you wrote: Craps out on a Mac.I've had a couple of Mac users try it, all see the same problem, I would be surprised if this was a Mac issue. Rather, it is probably IE on Mac, or Safari, or Firefox. The Mac OS itself does not have any typical settings which would affect a browser's ability to handle cookies. It doesn't look like the session vars are keeping their values.The form processing page stored the member id and name in 2 session vars, and the CFLOCATIONs back to the members-only home page.That page always checks to see if the user is logged in by checking for a non-zero member ID, and if the user is not logged in then puts up the logon screen.For some reason when Mac users do this, the session var values being set on the form processing page are not there when the home page CF script is processed. It helps to know versions of things. CF5 behaves differently than CFMX, and IE on Mac OS 9 behaves differently than IE under Mac OS X. I assume you are running CF5. Be careful using cflocation on pages that set cookies, because the cookies will not be set under CF5. Creating a session variable for the first time is the same as setting a cookie. So if you have a cflocation on the same page that sets the session variable for the first time, the session variable will not be retained to the next page because the cookie will not make it back to the browser. I belive this behavior was changed (fixed) under CFMX. So, experiment with the use of cflocation to see if that helps. The other tags to check are cfhtmlhead and cfheader. Using cfheader on the same page as cflocation can lead to problems. Most people do not use either of these tags. Good luck, Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Urgent help needed Please
If you can see the CFxxx markup tags when you view source, then that means that CF is not running on the server, or that it has associated .CFM file types with something other than CF.Here's a quick test: In your CF action page, enter this code before the CFQUERY tag: Hello! cfabort Hello Again! What is rendered on the screen?If you see the Hello Again then you know for sure CF is not running.If you dont' see the first Hello! then I don't think that your form is pointing to the action page that you think it is! Hope this helps, -reed Your method should be post. What's your action? The action should be a page address. _ From: Sangeeta Karmokar [mailto:[EMAIL PROTECTED] Sent: Friday, 23 July 2004 3:45 p.m. To: CF-Talk Subject: Re: Urgent help needed Please Hi Matthew, Thanks for responding. I can see the cf markup when I submit it to the action page. Action page does come up but instead of submitting the data to the database, it shows like a normal html with all the queries. My form action atribute is post. Regards Sangeeta _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: session var problems with Mac uses?
Thanks for the ideas, here are some answers to them: Session vars are already created before getting to the form processing page (where the CFLOCATION is used).They are created on the FORM page itself (actually the application.cfm will get them created via CFPARM). The versions of software on the Mac seems to vary.I think that one of the Mac users said that they tried Safari and it worked fine, so this may be an IE/Mac problem, but I cannot think of anything for them to check, since the usual suspect (cookies being disabled) is not the case, since the CF tokens being reported from the browser are the same from one page to the next, that would mean that cookies are ok. Server is running CFMX. I'm not doing anything with the headers. Thanks, need more ideas! -reed At 09:26 PM 7/22/2004, you wrote: Craps out on a Mac.I've had a couple of Mac users try it, all see the same problem, I would be surprised if this was a Mac issue. Rather, it is probably IE on Mac, or Safari, or Firefox. The Mac OS itself does not have any typical settings which would affect a browser's ability to handle cookies. It doesn't look like the session vars are keeping their values.The form processing page stored the member id and name in 2 session vars, and the CFLOCATIONs back to the members-only home page.That page always checks to see if the user is logged in by checking for a non-zero member ID, and if the user is not logged in then puts up the logon screen.For some reason when Mac users do this, the session var values being set on the form processing page are not there when the home page CF script is processed. It helps to know versions of things. CF5 behaves differently than CFMX, and IE on Mac OS 9 behaves differently than IE under Mac OS X. I assume you are running CF5. Be careful using cflocation on pages that set cookies, because the cookies will not be set under CF5. Creating a session variable for the first time is the same as setting a cookie. So if you have a cflocation on the same page that sets the session variable for the first time, the session variable will not be retained to the next page because the cookie will not make it back to the browser. I belive this behavior was changed (fixed) under CFMX. So, experiment with the use of cflocation to see if that helps. The other tags to check are cfhtmlhead and cfheader. Using cfheader on the same page as cflocation can lead to problems. Most people do not use either of these tags. Good luck, Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Urgent help needed Please
Sangeeta, Please provide more detail. Is the form sending this data a .cfm file? What's the name of the file with the SQL statement on it? In what scope are the variables name and email (url/form...)? --Ferg _ On Thu, 22 Jul 2004 21:40:33 -0400, Sangeeta Karmokar [EMAIL PROTECTED] wrote: I am posting this question and no one is responding... Can anyone please respond. I think I am sounding dum in your world... Sangeeta Can anyone help me I am new to CF. we have backend as MySql and I am trying to insert into a database created in SQL using this query: cfquery name=add datasource=newmembers INSERT INTO members (name,email) VALUES ('#name#','#email#') /cfquery But it is not adding to the database, the submit is just going to the query page and we can see all these codes in browsers... I think the problem is, coldfusion server is not parsing code before handing it over to the webserver. we are working on Mac OS X with MySql. How to fix this problem... I really need help... Sangeeta _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFC Design for Multiple Person Roles
This is starting to make sense now.I can imagine how I would create the CFCs. A couple questions, though; would there actually be anything in the base Roles CFC that would not already be in the main User CFC? If I wanted to know if a user was, for example, a student, would it be so simple as to checking for the existence of the Roles array element that holds the Student CFC instance?If so, I would see that as being either part of the User CFC or Roles CFC.Now that I think about it, Roles CFC may be the best place for that function. Thanks.Today will be a good day to play around with this idea and the code. M!ke _ From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 12:18 AM To: CF-Talk Subject: Re: CFC Design for Multiple Person Roles On Thu, 22 Jul 2004 19:39:17 -0500, Dawson, Michael [EMAIL PROTECTED] wrote: Sean, this sounds interesting, but I'm unsure how to implement it. User has-a Role array - so a User CFC has variables.roles which is an array of Role CFCs. User does not extend anything. Employee extends Role. Faculty extends Role. Student extends Role. Role does not extend anything. is-a means 'extends' (inheritance). has-a means variables.xxx (composition / aggregation). Inheritance should be rare in your programs - it should probably never be the first choice for the relationship between two classes. -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFC for dynamic menu?
I'm building a new site, and wanting to completely separate logic from database access from presentation code, and so I am building a CFC that (amongst other things) builds menus.(There wont be more than 3 levels of menu)It'll do all the queries on the database, looping over query objects to gather submenu items etc and creating an object to be passed back for sitemap, navigation menus, and some authority access functionality, depending on the context. What's the best method of passing this object back from the CFC?Should I create an xml object?Or a struct containing all the menu data and submenu data?Does it matter? Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFC Design for Multiple Person Roles
On Thu, 22 Jul 2004 18:28:56 -0400, Joe Rinehart [EMAIL PROTECTED] wrote: I've used this approach, but I've liked using structures of roles more than arrays.It lets me do a userIsInRole(string rolename) method that just returns structKeyExists(variables.instance.roles, employee).I was wondering what you thought of this approach? Well, that only allows a user to have one employee role and one faculty role and one student role (at a time). In my case, this would be the rule, I think. Walking the array and returning true if rolename is role[n].getRoleName() is more flexible. If I have three CFCs (Employee, Faculty, Student), each would have a Rolename attached to it.Basically, the role name would be Employee, Faculty, Student. If I created another instance of the Student CFC and added it to the Roles array, how would I then tell the two Student CFC instances from one another?Would I need to Init() each instance with a unique value? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
sql question
sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. thanks :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
On Friday 23 Jul 2004 14:30 pm, Tony Weeg wrote: is this possible in 1 query? If you can do sub querys in your DB: select * from table a where status=1 and not exists ( select id from table b where a.id=b.id and status is 0 ) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
Tony, I think you may over thinking this...It is as simple as you think you should be ;) select * from orderlines where orderno = 'xyz123' and status 0 I'm assuming here that you don't have an order status with negative numbers. Regards Stephen Tony Weeg wrote: sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
my first stab... select * from stgCRM_orders where (status = 1 and status 0) group by id, crmuuid, salesOrderId, status, adminTouch, masTouch, status having crmUUID = crmUUID -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Let me get this straight.You want to process only new orders that do not have an associated cancelled record, right? If so, you could use a self-join.A self-join is where you a table to itself.To do so, you must specify different table aliases (T1 and T2 in the code below). It would look something like this: SELECT T1.OrderNbr, T1.OrderThing FROM Orders T1 INNER JOIN Order T2 ON T1.OrderNbr = T2.OrderNbr WHERE T2.Status 0 M!ke _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 8:31 AM To: CF-Talk Subject: sql question sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. thanks :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
Hey Tony, Here's one approach: SELECT * FROM table t1 WHERE status = 1 AND NOT EXISTS ( SELECT 1 FROM table t2 WHERE t2.status = 0 AND t1.orderNumber = t2.orderNumber ) -joe - Original Message - From: Tony Weeg [EMAIL PROTECTED] Date: Fri, 23 Jul 2004 09:30:32 -0400 Subject: sql question To: CF-Talk [EMAIL PROTECTED] sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. thanks :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Select * from table where ordereid not in (select ordereid from table where status = 0) Is the absolute first thing that comes to mind. I'm sure some better and more efficient ideas will come through though. Ken Ferguson Fitz and Floyd http://www.fitzandfloyd.com http://www.exclusivelyfitz.com http://www.exclusivelyfitz.com/ http://stores.ebay.com/fitzandfloydscharmingtails _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 8:31 AM To: CF-Talk Subject: sql question sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. thanks :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
Youmean like this?: SELECT * FROM table WHERE status = 1 ANDorderid NOT IN (select orderid from table where status = 0) - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 23, 2004 8:30 AM Subject: sql question sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. thanks :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
if i already knew the order number, that would be easy, like you said, but its a blind look, im looking for every row, keyed off of the orderNo that doesnt have a matching row wiht the same orderNo, and a status of 0 make sense? i think thomas' idea will work...brb tw On Fri, 23 Jul 2004 14:34:01 +0100, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Tony, I think you may over thinking this...It is as simple as you think you should be ;) select * from orderlines where orderno = 'xyz123' and status 0 I'm assuming here that you don't have an order status with negative numbers. Regards Stephen Tony Weeg wrote: sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
thomas aquinas something or other, you are a GEM! thanks select * from stgCRM_Orders a where status = 1 and not exists ( select crmUUID from stgCRM_orders b where a.crmUUID=b.crmUUID and status = 0 ) was what i am finally using, and it works like a charm! thanks tony -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
thanks for the ideas all, thomas, and joe had the same thing, thomas was quick on the draw, thanks!all good. got it working. later, and btw, HAVE A GREAT! FRIDAY On Fri, 23 Jul 2004 09:47:28 -0400, Tony Weeg [EMAIL PROTECTED] wrote: thomas aquinas something or other, you are a GEM! thanks select * from stgCRM_Orders a where status = 1 and not exists ( select crmUUID from stgCRM_orders b where a.crmUUID=b.crmUUID and status = 0 ) was what i am finally using, and it works like a charm! thanks tony -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
Umm... Unless I'm mistaken select * from mytable where status 0 will automatically remove all the items with 0 as the status... where status = 1 will get you all the items with status 1, and so will also disclude status 0 (and any other non-1 status)... sql gurus...got a question. lets say i have a table, and in that table there could be 2 rows for one order coming from crm system.. the first row, has a status of 1, meaning new, and process it now.the second row, would match on a order number column, but a status of 0...meaning cancelled.i want to show all rows from the table that dont have a matching 0 status row. is this possible in 1 query? something like this.. select * from table where status = 1 and status 0 :) i know this is way off, but im not sure how to compare, where i have a matching column, but an opposing status of 0 with the same order id. thanks :) -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: js pop-up
I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) { newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); firsttime++; } else{ if (newWindow) {newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); newWindow.focus(); } else { newWindow.location.href="" newWindow.focus();} } } /script Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
Ohh... you only want records for orders that don't have any cancelled items in the order? ... yea, Tom's where not exists (...) syntax works nicely for SQL Server and Oracle -- don't know about access or mysql offhand. On Friday 23 Jul 2004 14:30 pm, Tony Weeg wrote: is this possible in 1 query? If you can do sub querys in your DB: select * from table a where status=1 and not exists ( select id from table b where a.id=b.id and status is 0 ) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Let me get this straight.You want to process only new orders that do not have an associated cancelled record, right? If so, you could use a self-join.A self-join is where you a table to itself.To do so, you must specify different table aliases (T1 and T2 in the code below). It would look something like this: SELECT T1.OrderNbr, T1.OrderThing FROM Orders T1 INNER JOIN Order T2 ON T1.OrderNbr = T2.OrderNbr WHERE T2.Status 0 M!ke That's going to produce a cartesian result set tho... Say there are 3 items in the order, and none of them are cancelled, the database will find table1.1 table2.1 table1.1 table2.2 table1.1 table2.3 table1.2 table2.1 table1.2 table2.2 table1.2 table2.3 table1.3 table2.1 table1.3 table2.2 table1.3 table2.3 So the number of records returned would be equal to the number of records in the order squared. It also will still return any not-cancelled records in an order that has cancelled records, so if item 3 were cancelled in the above example, he'd get 4 records for the remaining 2 items in that order... The cartesian could be eliminated through the use of either the distinct keyword or a group-by clause, although using a where exists() query if it's available will solve the original issue and also eliminate the query. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: sql question
Select * from table where ordereid not in (select ordereid from table where status = 0) Is the absolute first thing that comes to mind. I'm sure some better and more efficient ideas will come through though. Now that you mention it, this is a good point Ken. Yea, this works similarly to the where exists () subquery. The advantage of using where exists () is that it's more efficient. Where not in will scan the entire table regardless of the results, whereas the where not exists () will stop scanning the table when it finds an existing record and immediately throw the resultant row away. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFX and CFMX 6.1?
Can anyone enlighten me on how in the world will a CFX Tag still process when the name of the JAR file has been renamed, the the directory has been changed as far as Case-Sensitivity is concerned. There are no other CFX_JSpellCheck.jar files located on the server. Not on the C, D or F Drives. (E Drive is a CD ROM drive) I have bounced the services as well as bounce the box. Any suggestions We are trying to reproduce an error of: Page Can Not Be Displayed when calling the CFX_JSpellCheck but have not been able to reproduce the error. Any help is appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: js pop-up
I could be wrong, but I don't think spaces are legal between a function name and the parameters. ie window.open (bob) is wrong window.open(bob) is right. --Ben Robert Orlini wrote: I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) { newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); firsttime++; } else{ if (newWindow) {newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); newWindow.focus(); } else { newWindow.location.href="" newWindow.focus();} } } /script Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: js pop-up
Works just fine in FireFox and IE... On Fri, 23 Jul 2004 09:56:59 -0400, Robert Orlini [EMAIL PROTECTED] wrote: I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) { newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); firsttime++; } else{ if (newWindow) {newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); newWindow.focus(); } else { newWindow.location.href="" newWindow.focus();} } } /script Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
ur right ike.and thanks for the xplanation tek it easy mon! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: js pop-up
Seems to work now. Thx. RO -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 10:47 AM To: CF-Talk Subject: Re: OT: js pop-up I could be wrong, but I don't think spaces are legal between a function name and the parameters. ie window.open (bob) is wrong window.open(bob) is right. --Ben Robert Orlini wrote: I get an error on a _javascript_ pop-up code. Something about Expected ) Its either a ) or } I'm not sure. I'm not that good with _javascript_. Any ideas on the code below please? Thx. script LANGUAGE=_javascript_ var newWindow; var firsttime=0; function PopWindow(url) { if (firsttime==0) { newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); firsttime++; } else{ if (newWindow) {newWindow=window.open (url, newWindow, width=600,height=200,menubar=no,scrollbars=no,toolbar=no,location=no,directories=no,resizable=no); newWindow.focus(); } else { newWindow.location.href="" newWindow.focus();} } } /script Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC for dynamic menu?
What's the best method of passing this object back from the CFC?Should I create an xml object?Or a struct containing all the menu data and submenu data?Does it matter? I can't speak for everyone here, but I love structs. I pass structs in and out of my CFCs all the freakin' time and they work like a charm...or...charms, as the case may be... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Losing CFID/CFTOKEN From Session...
Have you found anything out about this Dan? My clients on Crystaltech servers seem to have the same issue, session.cfid does not exist, even though sessions are turned on. Does it have something to do with J2EE sessions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Oracle PL/SQL and CLOBS
This is somewhat off topic I guess...But if someone can help me out, I would be grateful. I have a stored procedure that exports data from a series of tables to a specific format. The file is fixed with and there is data layout for the mapping.Anyway.My question is... Each row contains about 40,000 columns and there are thousands of rows.I am building this row in a clob, I just keep concatenating it until the next row starts.Basic stuff.This is very slow, I am guessing because I am using clobs.In my testing with a varchar2(4000) the procedure is very fast. Obviously, when I test with the varchar, I have to limit the data that I retrieve to under 4000 chars.What I need to know is, is there a better way to handle this? My first thought is to create 10 varchar variables and spread the data across them and bring it together in the end.Or I could create a table with a varchar field and spread it across multiple rows and bring that together in the end. The clobs work fine when exporting just a few rows but when I try to export a few hundred; The program takes about an hour and temp table space grows by 768 megs. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Losing CFID/CFTOKEN From Session...
Have you found anything more out with this? I am seeing the same thing with clients running on Crystaltech servers, session.cfid does not exist, even though sessions are turned on. Would this have anything to do with J2EE sessions being turned on? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
i cant find anything grr If you are tired horsing around with Regular expressions, just try CF_REextract here: http://localhost/CustomTags/REextract/testingREextract.cfm - Select http for input mode, - enter RE1=[[:cntrl:]]+USGS[[:space:]]+ - enter RE2=USGS[[:space:]]+|$ - output mode = list - extract = last (you may also have them all in a query) -- ___ 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]
CF Jukebox redux
Yesterday I posted a URL for my cf based A/V Jukebox. http://67.124.145.42/cfusion/mymedia/ I got several comments that while it looked good, they couldn't get it to play. My bad!I didn't get the object embed tags right, so it wouldn't work on many (mostly win) browsers. Sorry if I wasted some people's time. I have fixed it (AFAIK) and it seems to work on the following: Win:IE 6. Mac: Safari 1.2.2 and Mozilla 1.6 Some things work on Mac FireFox, but it doesn't synch sometimes (skips large parts of songs). I used to use a big popup for the player so I could intermix video and songs.I moved the song player inboard removed the movies, for now. There is one button, Play Smil Playlistthat plays a script -- within the script you can display audio, movies, pictures, text, etc. This is a very quick and dirty way to put together a slide show -- it shows one of the things I want to do with this app -- An annotated A/V display of family members, etc -- kind of a living photo album. * If Smil works well, it will be a lot easier (and more flexible) than creating movies) I have attempted to make this look/work more like iTunes (at least for now). Some have suggested a Flash front end -- That may happen (certainly should. resolve browser compatibility problems). But, Flash adds some overhead -- downloading the swf and CPU cycles (even when nothing is going on). So, I have tried to make this version as lean as possible, because some family members have older computers and dialup or slow internet connections. * The Lovely Lucy pictured in the Smil script is my late wife -- I am putting together an online site to share memories of her with family members all over the globe. That's the reason for the app!I would also like to do a CFAnywhere version on a DVD. I plan to open-source it when it is a little further along. Any feedback on the site will be greatly appreciated. TIA Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
its all good, thomas' was perfect, and im using it now in production :) thanks! tw On Fri, 23 Jul 2004 10:02:00 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote: Ohh... you only want records for orders that don't have any cancelled items in the order? ... yea, Tom's where not exists (...) syntax works nicely for SQL Server and Oracle -- don't know about access or mysql offhand. On Friday 23 Jul 2004 14:30 pm, Tony Weeg wrote: is this possible in 1 query? If you can do sub querys in your DB: select * from table a where status=1 and not exists ( select id from table b where a.id=b.id and status is 0 ) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: i need help stripping :)
Ummm, your link is to localhost and that won't work for anyone but you. John -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:48 AM To: CF-Talk Subject: Re: i need help stripping :) i cant find anything grr If you are tired horsing around with Regular expressions, just try CF_REextract here: http://localhost/CustomTags/REextract/testingREextract.cfm - Select http for input mode, - enter RE1=[[:cntrl:]]+USGS[[:space:]]+ - enter RE2=USGS[[:space:]]+|$ - output mode = list - extract = last (you may also have them all in a query) -- ___ 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: CFMX Losing CFID/CFTOKEN From Session...
Have you found anything more out with this? I am seeing the same thing with clients running on Crystaltech servers, session.cfid does not exist, even though sessions are turned on. Would this have anything to do with J2EE sessions being turned on? Never mind, I figured it out. Now I just have to find a good way to write my code that will work in either situation! Darn hosting companies, they definitely don't make it easy for us! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX Losing CFID/CFTOKEN From Session...
Have you found anything more out with this? I am seeing the same thing with clients running on Crystaltech servers, session.cfid does not exist, even though sessions are turned on. Would this have anything to do with J2EE sessions being turned on? If you have J2EE sessions enabled, you won't have Session.CFID or Session.CFTOKEN. Instead, you'll have the J2EE session id. 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: CFC for dynamic menu?
What's the best method of passing this object back from the CFC?Should I create an xml object?Or a struct containing all the menu data and submenu data?Does it matter? Depends on what you're looking to do.Structs are probably going to be slighly faster, and they'll be more familiar as well (since you use them all the time).XML, on the other hand, will let you build the navigation with XSL, which can be very advantageous in certiain situations.In addition, you can use the XML document like a struct, though there are extra levels of nastiness in there (like xmlChildren and xmlAttributes). One of the neat things about using XSL for your transforms is that you can let your system's users write the XSL (rather than you the developer), without fear that they'll be able to hurt the application or the system it's running on (aside from infinite loops and such). That's impossible with structs, becuase in order to use structs, you have to write CF code.Not sure if that's relevant to your situation, but it's something to keep in mind. cheers, barneyb On Fri, 23 Jul 2004 23:13:16 +1000, Michael Kear [EMAIL PROTECTED] wrote: I'm building a new site, and wanting to completely separate logic from database access from presentation code, and so I am building a CFC that (amongst other things) builds menus.(There wont be more than 3 levels of menu)It'll do all the queries on the database, looping over query objects to gather submenu items etc and creating an object to be passed back for sitemap, navigation menus, and some authority access functionality, depending on the context. What's the best method of passing this object back from the CFC?Should I create an xml object?Or a struct containing all the menu data and submenu data?Does it matter? Cheers Mike Kear [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: SQL Create Table w/ Escaped Column Name
I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL , [increaselevel] [smallint] NULL , [lastincdate] [datetime] NULL , [countfromdate] [datetime] NULL , [createdate] [datetime] NULL , [noautoincs] [int] NULL , [isactive] [bit] NULL , [description] [ntext] NULL ) this query works in query analyzer with SQL 2000... in cf it produces the sql error incorrect syntax near the keyword 'trigger' So in a vain attempt to make this work the way it's supposed to, I tried executing the sp_executeSQL stored procedure with this string of sql code as the statement parameter only to discover that it won't work without a unicode argument and there's no way for me to pass a unicode value to it from ColdFusion (even though CF supports unicode). Don't ask me why - but it wouldn't accept cf_sql_varchar or cf_sql_longvarchar even after using cfprocessingdirective to make sure the character set was UTF-8 ... and ther aren't any cf_sql_nvarchar values as far as I know... are there? did I miss something? Anyway, so I create another stored procedure... create procedure p_createTable @tabledef varchar(4000) as declare @myvar nvarchar (4000); set @myvar = convert(nvarchar(4000),@tabledef); exec sp_executeSQL @myvar; go again, everything is hunky-dory when executed in query analyzer. When I execute the same procedure with the same argument in CF, SQL Server chews it up and spits it out again with the _same_ error incorrect syntax near keyword 'trigger' I'm at my wit's end... Any help would be greatly appreciated... s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC for dynamic menu?
Depends on what you're looking to do.Structs are probably going to be slighly faster, and they'll be more familiar as well (since you use them all the time).XML, on the other hand, will let you build the navigation with XSL, which can be very advantageous in certiain situations.In addition, you can use the XML document like a struct, though there are extra levels of nastiness in there (like xmlChildren and xmlAttributes). My approach in this situation would be to create a CFC that queries the Database, then another CFC to wrap the Query results in XML. Would that be a proper MVC approach? Couldn't you view the WrapInXML() CFC as a proper controller method? Just curious if I would be overthinking it, or approaching it in a nice, clean, best practices way. He's got one component that basically is his model component, and anything that would wrap his results for any kind of formatted output would be a controller component...is that right? So you could even do something like, WrapInXML(GetMenuItems())...couldn't you? One of the neat things about using XSL for your transforms is that you can let your system's users write the XSL (rather than you the developer), without fear that they'll be able to hurt the application or the system it's running on (aside from infinite loops and such). That's impossible with structs, becuase in order to use structs, you have to write CF code.Not sure if that's relevant to your situation, but it's something to keep in mind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Jukebox redux
Yesterday I posted a URL for my cf based A/V Jukebox. http://67.124.145.42/cfusion/mymedia/ Any feedback on the site will be greatly appreciated. I can't get the popup window to open on Windows/IE 5.5 using the Open Popup Window link. I get a JS error, line 1, char 2 Control.cfm Object doesn't support this property or method If I select a playlist and click Play Current Playlist, I show QT in the top frame playing something but I don't hear anything. If I click Play Smil Playlist I get a popup window and I hear the song QT is playing OK. Everything else seems to work, looks good! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle PL/SQL and CLOBS
Hi David, You've explained what you're trying to implement but not enough of why you've chosen to implement things this way. CLOBS are slow so you should try to avoid them unless necessary, but I don't have enough of an understanding of what problem you're trying to solve to say whether or not you CAN avoid them. Could you give an explanation of what problem you're trying to solve? --- [EMAIL PROTECTED] wrote: This is somewhat off topic I guess...But if someone can help me out, I would be grateful. I have a stored procedure that exports data from a series of tables to a specific format. The file is fixed with and there is data layout for the mapping. Anyway.My question is... Each row contains about 40,000 columns and there are thousands of rows.I am building this row in a clob, I just keep concatenating it until the next row starts.Basic stuff.This is very slow, I am guessing because I am using clobs.In my testing with a varchar2(4000) the procedure is very fast. Obviously, when I test with the varchar, I have to limit the data that I retrieve to under 4000 chars. What I need to know is, is there a better way to handle this? My first thought is to create 10 varchar variables and spread the data across them and bring it together in the end.Or I could create a table with a varchar field and spread it across multiple rows and bring that together in the end. The clobs work fine when exporting just a few rows but when I try to export a few hundred; The program takes about an hour and temp table space grows by 768 megs. Thanks, David = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Create Table w/ Escaped Column Name
Not that this should make a whole lot of difference I the context of your issue, but I try and steer clear of using reserved words (trigger,description) for column names. I doubt it has anything to do with your problem but just thought I would throw that in there. Mike I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL , [increaselevel] [smallint] NULL , [lastincdate] [datetime] NULL , [countfromdate] [datetime] NULL , [createdate] [datetime] NULL , [noautoincs] [int] NULL , [isactive] [bit] NULL , [description] [ntext] NULL ) this query works in query analyzer with SQL 2000... in cf it produces the sql error incorrect syntax near the keyword 'trigger' So in a vain attempt to make this work the way it's supposed to, I tried executing the sp_executeSQL stored procedure with this string of sql code as the statement parameter only to discover that it won't work without a unicode argument and there's no way for me to pass a unicode value to it from ColdFusion (even though CF supports unicode). Don't ask me why - but it wouldn't accept cf_sql_varchar or cf_sql_longvarchar even after using cfprocessingdirective to make sure the character set was UTF-8 ... and ther aren't any cf_sql_nvarchar values as far as I know... are there? did I miss something? Anyway, so I create another stored procedure... create procedure p_createTable @tabledef varchar(4000) as declare @myvar nvarchar (4000); set @myvar = convert(nvarchar(4000),@tabledef); exec sp_executeSQL @myvar; go again, everything is hunky-dory when executed in query analyzer. When I execute the same procedure with the same argument in CF, SQL Server chews it up and spits it out again with the _same_ error incorrect syntax near keyword 'trigger' I'm at my wit's end... Any help would be greatly appreciated... s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Jukebox redux - what browsers to support.
Thanks, Robert I didn't test on IE 5.5 You should hear some songs and see a brief slide show with Play Smil playlist. If you click on a song name the playlist will start at that song -- skipping any unchecked songs. Brings up a good question -- What browsers should I support especially on win? I have to setup a separate virtual machine for each version of IE unless someone knows how to install multiple IE version on a single OS (PITA). I meant to remove the popup window links. TIA Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 23, 2004, at 9:41 AM, Robert Munn wrote: Yesterday I posted a URL for my cf based A/V Jukebox. http://67.124.145.42/cfusion/mymedia/ Any feedback on the site will be greatly appreciated. I can't get the popup window to open on Windows/IE 5.5 using the Open Popup Window link. I get a JS error, line 1, char 2 Control.cfm Object doesn't support this property or method If I select a playlist and click Play Current Playlist, I show QT in the top frame playing something but I don't hear anything. If I click Play Smil Playlist I get a popup window and I hear the song QT is playing OK. Everything else seems to work, looks good! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC for dynamic menu?
My approach in this situation would be to create a CFC that queries the Database, then another CFC to wrap the Query results in XML. Would that be a proper MVC approach? Couldn't you view the WrapInXML() CFC as a proper controller method? If I needed multiple formats, I'd probably make a single CFC that has three methods, one to pull the raw menu query (probably delegatin gto a dedicated DAO), one to pull the menu as a structure, and one to pull the menu as XML.That's really a single job, so it makes sense to have it all in one CFC.then you controller can call whichever method it wants, to get the data in the format it needs. Your model provides data to the controller.Since XML is data (just a different format), i don't think it really belongs in the controller. THe controller's job is managing application flow, and is usually tied tightly to the UI.I wouldn't recommend mixing the DB code and the XML formatting code necessarily, but I'd say returning the data in XML format is part of the model's job (though at the top end of the functionality spectrum). cheers, barneyb On Fri, 23 Jul 2004 12:40:19 -0400, Jeff Small [EMAIL PROTECTED] wrote: Depends on what you're looking to do.Structs are probably going to be slighly faster, and they'll be more familiar as well (since you use them all the time).XML, on the other hand, will let you build the navigation with XSL, which can be very advantageous in certiain situations.In addition, you can use the XML document like a struct, though there are extra levels of nastiness in there (like xmlChildren and xmlAttributes). My approach in this situation would be to create a CFC that queries the Database, then another CFC to wrap the Query results in XML. Would that be a proper MVC approach? Couldn't you view the WrapInXML() CFC as a proper controller method? Just curious if I would be overthinking it, or approaching it in a nice, clean, best practices way. He's got one component that basically is his model component, and anything that would wrap his results for any kind of formatted output would be a controller component...is that right? So you could even do something like, WrapInXML(GetMenuItems())...couldn't you? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
Ummm, your link is to localhost and that won't work for anyone but you. Ooops, I cut'n paste the link from the wrong window :-( It is http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm Sorry about that. - Select http for input mode, - enter RE1=[[:cntrl:]]+USGS[[:space:]]+ - enter RE2=USGS[[:space:]]+|$ - output mode = list - extract = last (you may also have them all in a query) -- ___ 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]
Recurring scheduler-originating error from unscheduled task
Hey all, I've got an server issue that I can't seem to puzzle out. On one of my servers (I've got two, behind a load balancer), I've lately been getting a bunch of unacceptable email address type errors, at the top of the hour, every hour. The exception log labels them as from scheduler-1. Usually it appears there was a blank for the email - sometimes it has an email addy in the error that is obviously invalid. The trick is - I don't *have* a task in the scheduler that runs every hour on the hour. On other boxes in the past, specifically on a Linux box, I've had issues with modifying the scheduled tasks, and the old scheduler info not being properly nuked - i.e. changing a every-5-min task to every-10-min resulted in the old schedule sticking and the new schedule being added, so it would run once at 5 min and twice at 10 min. But regardless - the scheduler would reset properly when restarting the service or the server. In this case, that doesn't seem to make a difference - I'm still getting these errors every hour. Has anyone else encountered similar issues and solved them? --Scott [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFC for dynamic menu?
If I needed multiple formats, I'd probably make a single CFC that has three methods, one to pull the raw menu query (probably delegatin gto a dedicated DAO), one to pull the menu as a structure, and one to pull the menu as XML.That's really a single job, so it makes sense to have it all in one CFC.then you controller can call whichever method it wants, to get the data in the format it needs. Your model provides data to the controller.Since XML is data (just a different format), i don't think it really belongs in the controller. THe controller's job is managing application flow, and is usually tied tightly to the UI.I wouldn't recommend mixing the DB code and the XML formatting code necessarily, but I'd say returning the data in XML format is part of the model's job (though at the top end of the functionality spectrum). Okay, so the idea is that XML isn't considered formatted data it's just considered data. I can see that. I always viewed it as formatted if something else needs to be done with it after the query results are returned. So if the returned results weren't in a format that you needed...it had to be passed on to another controller to perform that formatting...But then again, Something like SQLServer could just return the results *AS* XML, couldn't it? So you could theoretically be querying AND returning the results as XML all in one handy query wrapped in a CFC...right? I'm sorry to jump into this thread, it's just that I'm neck deep in reading about methodologies and I'm trying to tie what I'm reading with real world examples to make sure I understand the whole, MVC thing completely. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Create Table w/ Escaped Column Name
well so do I, but I didn't develop this app or these db's unfortunately... of all the things that are wrong with this app, keywords is the least significant... of course, until I have to create a table with cf... Not that this should make a whole lot of difference I the context of your issue, but I try and steer clear of using reserved words (trigger,description) for column names. I doubt it has anything to do with your problem but just thought I would throw that in there. Mike I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL , [increaselevel] [smallint] NULL , [lastincdate] [datetime] NULL , [countfromdate] [datetime] NULL , [createdate] [datetime] NULL , [noautoincs] [int] NULL , [isactive] [bit] NULL , [description] [ntext] NULL ) this query works in query analyzer with SQL 2000... in cf it produces the sql error incorrect syntax near the keyword 'trigger' So in a vain attempt to make this work the way it's supposed to, I tried executing the sp_executeSQL stored procedure with this string of sql code as the statement parameter only to discover that it won't work without a unicode argument and there's no way for me to pass a unicode value to it from ColdFusion (even though CF supports unicode). Don't ask me why - but it wouldn't accept cf_sql_varchar or cf_sql_longvarchar even after using cfprocessingdirective to make sure the character set was UTF-8 ... and ther aren't any cf_sql_nvarchar values as far as I know... are there? did I miss something? Anyway, so I create another stored procedure... create procedure p_createTable @tabledef varchar(4000) as declare @myvar nvarchar (4000); set @myvar = convert(nvarchar(4000),@tabledef); exec sp_executeSQL @myvar; go again, everything is hunky-dory when executed in query analyzer. When I execute the same procedure with the same argument in CF, SQL Server chews it up and spits it out again with the _same_ error incorrect syntax near keyword 'trigger' I'm at my wit's end... Any help would be greatly appreciated... s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Create Table w/ Escaped Column Name
We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened to this: cfquery Create table dbo.t_testing([trigger] int NULL) /cfquery What's that give you??? -Ferg _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:59 AM To: CF-Talk Subject: RE: SQL Create Table w/ Escaped Column Name Not that this should make a whole lot of difference I the context of your issue, but I try and steer clear of using reserved words (trigger,description) for column names. I doubt it has anything to do with your problem but just thought I would throw that in there. Mike I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL , [increaselevel] [smallint] NULL , [lastincdate] [datetime] NULL , [countfromdate] [datetime] NULL , [createdate] [datetime] NULL , [noautoincs] [int] NULL , [isactive] [bit] NULL , [description] [ntext] NULL ) this query works in query analyzer with SQL 2000... in cf it produces the sql error incorrect syntax near the keyword 'trigger' So in a vain attempt to make this work the way it's supposed to, I tried executing the sp_executeSQL stored procedure with this string of sql code as the statement parameter only to discover that it won't work without a unicode argument and there's no way for me to pass a unicode value to it from ColdFusion (even though CF supports unicode). Don't ask me why - but it wouldn't accept cf_sql_varchar or cf_sql_longvarchar even after using cfprocessingdirective to make sure the character set was UTF-8 ... and ther aren't any cf_sql_nvarchar values as far as I know... are there? did I miss something? Anyway, so I create another stored procedure... create procedure p_createTable @tabledef varchar(4000) as declare @myvar nvarchar (4000); set @myvar = convert(nvarchar(4000),@tabledef); exec sp_executeSQL @myvar; go again, everything is hunky-dory when executed in query analyzer. When I execute the same procedure with the same argument in CF, SQL Server chews it up and spits it out again with the _same_ error incorrect syntax near keyword 'trigger' I'm at my wit's end... Any help would be greatly appreciated... s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: sql question
urvirulelkomein ur right ike.and thanks for the xplanation tek it easy mon! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Create Table w/ Escaped Column Name
We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened to this: cfquery Create table dbo.t_testing([trigger] int NULL) /cfquery What's that give you??? -Ferg _ I'm going to lose my hair... create table dbo.t_migrate ( [apid] [int] NULL , [artgroup] [nvarchar](10) NULL , [triggertype] [nvarchar](1) NULL , [trigger] [real] NULL , [span] [int] NULL , [increasetype] [nvarchar](1) NULL , [increaseamt] [real] NULL , [increasepercent] [real] NULL , [increaselevel] [smallint] NULL , [lastincdate] [datetime] NULL , [countfromdate] [datetime] NULL , [createdate] [datetime] NULL , [noautoincs] [int] NULL , [isactive] [bit] NULL , [description] [ntext] NULL ) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Oracle PL/SQL and CLOBS
I tried not to go into too much detail because the application is complicated and I was afraid that I would spend too much time explaining the application.I'm not looking for syntax, just an Idea. I have a string of data that can be more that 40,000 chars long and I am using a CLOB while building this string.I will be building thousands of these strings per fixed width export.I know that I can avoid excessive use of CLOBS by storing the data in multiple varchars and adding them to a CLOB at the end.I just dont know if this will be any faster.I cannot avoid the CLOB completely but what I can do is avoid concatenating the CLOB over and over again by spreading the data across many varchars.Basically, if you or anyone else had to build a string that was 40,000 chars long how would you all do it? Right now I build the entire sting in a CLOB then insert it into a table.Perhaps, it would be better to concatenate the data in the actual table and just keep adding to the field instead of maintaining a clob variable in PL/SQL? Thanks, David -Original message- From: I-Lin Kuo [EMAIL PROTECTED] Date: Fri, 23 Jul 2004 12:53:26 -0400 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Oracle PL/SQL and CLOBS Hi David, You've explained what you're trying to implement but not enough of why you've chosen to implement things this way. CLOBS are slow so you should try to avoid them unless necessary, but I don't have enough of an understanding of what problem you're trying to solve to say whether or not you CAN avoid them. Could you give an explanation of what problem you're trying to solve? --- [EMAIL PROTECTED] wrote: This is somewhat off topic I guess...But if someone can help me out, I would be grateful. I have a stored procedure that exports data from a series of tables to a specific format. The file is fixed with and there is data layout for the mapping. Anyway.My question is... Each row contains about 40,000 columns and there are thousands of rows.I am building this row in a clob, I just keep concatenating it until the next row starts.Basic stuff.This is very slow, I am guessing because I am using clobs.In my testing with a varchar2(4000) the procedure is very fast. Obviously, when I test with the varchar, I have to limit the data that I retrieve to under 4000 chars. What I need to know is, is there a better way to handle this? My first thought is to create 10 varchar variables and spread the data across them and bring it together in the end.Or I could create a table with a varchar field and spread it across multiple rows and bring that together in the end. The clobs work fine when exporting just a few rows but when I try to export a few hundred; The program takes about an hour and temp table space grows by 768 megs. Thanks, David = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL Create Table w/ Escaped Column Name
OK, try this as a test. It worked on Oracle, but who knows... !--- I guess you'll need to put the brackets back in place of the double quotes. --- cfquery name=ts datasource=#application.dsn# create table testing(apid int NULL , artgroup int NULL , triggertype int NULL , trigger int NULL , span int NULL , increasetype int NULL , increaseamt int NULL , increasepercent int NULL , increaselevel int NULL , lastincdate int NULL , countfromdate int NULL , createdate int NULL , noautoincs int NULL , isactive int NULL , description int NULL) /cfquery All I did here was to remove the (10)and (1) from some of your datatype defs and it worked. When I tried to run the exact query you provided (after changing from brackets to quotes) it failed with the error Missing right parenthesis. I thought that was odd so I removed them and it worked perfectly. Still looking into the why --Ferg _ From: Ken Ferguson Sent: Friday, July 23, 2004 1:06 PM To: CF-Talk Subject: RE: SQL Create Table w/ Escaped Column Name We all know Ike wouldn't do this of his own choosing. At least any of us who have worked with him do. What happens if, as a test, you try to do something likened to this: cfquery Create table dbo.t_testing([trigger] int NULL) /cfquery What's that give you??? -Ferg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Oracle PL/SQL and CLOBS
David, Assuming this is Oracle, if you're using the Macromedia drivers with a stored procedure that has an output parameter type of varchar2, then even though the varchar2 datatype can hold up to 32k the Macromedia Oracle driver will only return the first 4k.If you use the Oracle Thin Client instead, then you can retrieve all 32k. I just discovered a related bug this week where if the out parameter of a stored procedure is clob, and you use the Macromedia Oracle driver, then if the CF_SQL_TYPE for the out is set to clob you will get an array of characters rather than a contiguous string.Leaving the SP out parameter as clob but changing the CF_SQL_TYPE to varchar resolved the problem as the clob was returned as a string. My testing for these issues was done with CFMX 6.1, Macromedia driver version 3.3, Oracle 8.1.7. Hopefully, some of this may help. Steven Erat _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:39 AM To: CF-Talk Subject: Oracle PL/SQL and CLOBS This is somewhat off topic I guess...But if someone can help me out, I would be grateful. I have a stored procedure that exports data from a series of tables to a specific format. The file is fixed with and there is data layout for the mapping.Anyway.My question is... Each row contains about 40,000 columns and there are thousands of rows.I am building this row in a clob, I just keep concatenating it until the next row starts.Basic stuff.This is very slow, I am guessing because I am using clobs.In my testing with a varchar2(4000) the procedure is very fast. Obviously, when I test with the varchar, I have to limit the data that I retrieve to under 4000 chars.What I need to know is, is there a better way to handle this? My first thought is to create 10 varchar variables and spread the data across them and bring it together in the end.Or I could create a table with a varchar field and spread it across multiple rows and bring that together in the end. The clobs work fine when exporting just a few rows but when I try to export a few hundred; The program takes about an hour and temp table space grows by 768 megs. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Session-Based CFC Usage Across Clusters
I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Because of this, how many people have decided to stick with using session-based CFCs rather than deal with the issues related to clustering? If you decided to focus on clustering and not use session-bases CFCs, how did you implement your processes? I have been asked to support Windows 2003 Network Load Balancing, which CFMX 6.1 would support, however, I have my CFCs sitting in the session scope.I thought that an alternative would be to store a session-based structure that would hold all the data I would normally store in my CFC instance.Then, I would just call application-based functions that would normally be in the CFC instance as well. My fear is that I would then need to lock each call to the appliation-scope functions since many browser sessions could get mixed-up data. Any comments? Thanks M!chael A. Dawson Manager, Programming and Software Development Office of Technology Services University of Evansville 1800 Lincoln Avenue Evansville, IN 47722 812-479-2581 If you can read this, you are umop apisdn. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: RE: Oracle PL/SQL and CLOBS
I am using the Oracle 9i driver. Not sure if it's the thin client or not. Funny you should, say that.I think I am using varchar2 as the out parameter and not CLOB but only because I was using varchar2 before the CLOB and just never changed it.Thanks for the heads up. David -Original message- From: Steven Erat [EMAIL PROTECTED] Date: Fri, 23 Jul 2004 14:40:18 -0400 To: CF-Talk [EMAIL PROTECTED] Subject: RE: Oracle PL/SQL and CLOBS David, Assuming this is Oracle, if you're using the Macromedia drivers with a stored procedure that has an output parameter type of varchar2, then even though the varchar2 datatype can hold up to 32k the Macromedia Oracle driver will only return the first 4k.If you use the Oracle Thin Client instead, then you can retrieve all 32k. I just discovered a related bug this week where if the out parameter of a stored procedure is clob, and you use the Macromedia Oracle driver, then if the CF_SQL_TYPE for the out is set to clob you will get an array of characters rather than a contiguous string.Leaving the SP out parameter as clob but changing the CF_SQL_TYPE to varchar resolved the problem as the clob was returned as a string. My testing for these issues was done with CFMX 6.1, Macromedia driver version 3.3, Oracle 8.1.7. Hopefully, some of this may help. Steven Erat _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 11:39 AM To: CF-Talk Subject: Oracle PL/SQL and CLOBS This is somewhat off topic I guess...But if someone can help me out, I would be grateful. I have a stored procedure that exports data from a series of tables to a specific format. The file is fixed with and there is data layout for the mapping.Anyway.My question is... Each row contains about 40,000 columns and there are thousands of rows.I am building this row in a clob, I just keep concatenating it until the next row starts.Basic stuff.This is very slow, I am guessing because I am using clobs.In my testing with a varchar2(4000) the procedure is very fast. Obviously, when I test with the varchar, I have to limit the data that I retrieve to under 4000 chars.What I need to know is, is there a better way to handle this? My first thought is to create 10 varchar variables and spread the data across them and bring it together in the end.Or I could create a table with a varchar field and spread it across multiple rows and bring that together in the end. The clobs work fine when exporting just a few rows but when I try to export a few hundred; The program takes about an hour and temp table space grows by 768 megs. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX memory usage on specific page request
I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX memory usage on specific page request
Well Brook...as I've said before ;-) I've seen that happen where 1 page causes JRun to eat up memory.The difference is that it wouldn't stop and an error would eventually be thrown. This was due to really stupid parsing errors like: cfset MyVar = blah or cfinclude template=blah.cfm or cflocation url=""> You get the idea. I never found a way around this (other than fixing the obvious yet stupid coding errors). Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Original Message - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX memory usage on specific page request
Any chance of taking portions out of the form handler one at a time? Does debugging clue you in on anything? John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Bypassing wsconfig
I wanted to set up CFMX 6.1 to run along side CF5 on a production server, without disrupting the CF5 sites. CFMX 6.1 will respond to a single directory on the server and CF5 will respond to everything else. I could not easily use wsconfig for this because that would knock out the CF5 server temporarily. Below is what I did. Everything seems to work, but I am wondering if I missed anything? I do not know of any place that documents what wsconfig actually does. 1. Install CFMX in stand-alone mode and apply the hotfixes. 2. Copy the /cfusionmx/runtime/lib/wsconfig file to the production server from a similar server that has previously been set up with CFMX. 3. Change one line in wsconfig.properties to give it the correct server name 4. In jrun.xml, set the JrunProxyService deactivated attribute to false. 5. Set up all the obj.conf and magnus.conf files (for Sun ONE / iPlanet) so that .cfm and .cfc requests are passed off to CFMX if the files are in a specific directory. I compared the stand-alone install to the install on another server that had been attached to the Web server using wsconfig, and the only difference I noticed in files under /cfusionmx, was the wsconfig directory and the activation of the JrunProxyService. Does wsconfig do anything else? Thank you, Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session-Based CFC Usage Across Clusters
At 02:42 PM 7/23/2004, you wrote: I have read that session-based CFCs cannot be clustered (according to a livedoc comment). It depends on how you do the clustering. Our clustering is done by IP block, I believe just using the clustering ability built into Windows 2000 Advanced Server. One block of IP address always hits the same server. With this scenario, session CFCs should work with clustering, although I do not know how well this works with AOL. If you want to bring one server down to apply a service pack, however, everybody logged in to that one server would be booted, but the other server would pick up every new user. I suppose there is a small risk of one user bouncing to the other server picking up some other user's session because the token happens to be the same. -Mike Chabot [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Any Oracle ODBC driver that makes sense?
Hi, Is there anywhere an Oracle ODBC driver that makes sense? I mean, i'm testing 3 of them, and none will return reliable information about the same datasource: - Oracle ODBC driver version 10.01.0002 which comes with the last version 10g of the Oracle server: it returns only 20 Schema names and only 2 table types:TABLE VIEW although the list of all tables contains tables with types like SYSTEM TABLE, SYSTEM VIEWS, SYNONYM, etc. Lists 7531 tables all table types, and 2465 when only SYNONYM tables are requested List Schema names in Table list but no table description. - MERANT 03.70.0010 which comes with CF5, it returns only 24 Schema names and 4 table types Lists 5097 tables all table types, and 36 SYNONYM tables only Lists Schema names in Table list and table description ok. - last version of Microsoft's coming with MDAC 2.8: it returns 29 Schema names (all of them?) and all 5 table types, but many of informations asked through SQLGetInfo() cause an out of range error. Lists 7531 tables all table types, and 2465 when only SYNONYM tables are requested Lists some Schema names only in Table list but no table description. I mean, nor Oracle nor ODBC are really new stuff, no one is able to develop something complete? -- ___ 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: CFMX memory usage on specific page request
Yeah, I'm gonna have to go through template by template and add cfaborts. Test run the loop, check the ram usage and continue until I find the problem I guess.I'm just wondering if this is normal or not? Should memory usage increase like this when no new data is being stored in the application scope and nothing is being cached. Why does the memory increase? Or is this an indication of some sort of memory leak or bad coding somewhere leading to this climbing memory usage. Can anyone tell me before I start going through this thing template by template? Brook At 12:25 PM 7/23/2004, you wrote: Any chance of taking portions out of the form handler one at a time? Does debugging clue you in on anything? John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:171931This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 f1a9d74.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Session-Based CFC Usage Across Clusters
Currently, BlueDragon supports CFCs shared across clusters in the session scope. My understanding is that Blackstone will support this as well. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawson, Michael Sent: Friday, July 23, 2004 2:42 PM To: CF-Talk Subject: Session-Based CFC Usage Across Clusters I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Because of this, how many people have decided to stick with using session-based CFCs rather than deal with the issues related to clustering? If you decided to focus on clustering and not use session-bases CFCs, how did you implement your processes? I have been asked to support Windows 2003 Network Load Balancing, which CFMX 6.1 would support, however, I have my CFCs sitting in the session scope.I thought that an alternative would be to store a session-based structure that would hold all the data I would normally store in my CFC instance.Then, I would just call application-based functions that would normally be in the CFC instance as well. My fear is that I would then need to lock each call to the appliation-scope functions since many browser sessions could get mixed-up data. Any comments? Thanks M!chael A. Dawson Manager, Programming and Software Development Office of Technology Services University of Evansville 1800 Lincoln Avenue Evansville, IN 47722 812-479-2581 If you can read this, you are umop apisdn. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Dynamically Add Form Fields
Hey... I have a need to dynamically (using a button/link) add additional fields to a form.Does anybody have/know of a solution for this? (purchased or otherwise) -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session-Based CFC Usage Across Clusters
We skipped session variables in favor of custom client variables and traded session-scoped CFCs for something akin to a flyweight pattern implementation.Our client variables setup is almost identical to what CF provides, except that it allows complex values (because it's serialized using WDDX, rather than the lists that CF uses).What that lets us do is have a given client variable structure that would take the place of your session CFC.Where you'd call a method on your session-scoped CFC, we call a method on a shared CFC instance, passing in the client variable structure, which represents the state that your session CFC would have in instance variables.The operation does what it needs, possibly changing the instance data from the client variables, and then exits. Because the state and functionality are separate, we don't have to worry about serialization of the CFCs, or even tying them to specific users.It's not really what the flyweight pattern was designed for, but it works pretty well. cheers, barneyb On Fri, 23 Jul 2004 13:42:18 -0500, Dawson, Michael [EMAIL PROTECTED] wrote: I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Because of this, how many people have decided to stick with using session-based CFCs rather than deal with the issues related to clustering? If you decided to focus on clustering and not use session-bases CFCs, how did you implement your processes? I have been asked to support Windows 2003 Network Load Balancing, which CFMX 6.1 would support, however, I have my CFCs sitting in the session scope.I thought that an alternative would be to store a session-based structure that would hold all the data I would normally store in my CFC instance.Then, I would just call application-based functions that would normally be in the CFC instance as well. My fear is that I would then need to lock each call to the appliation-scope functions since many browser sessions could get mixed-up data. Any comments? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX memory usage on specific page request
Is it possible that each request is adding additional objects into application scope? (rather than invoking once and re-using that same instance) Aside form that it's tough to say without digging into the code... Cheers, Stace _ From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX memory usage on specific page request
Have you considered using the code analyzer in the administrator? At 01:04 PM 7/23/2004 -0700, you wrote: Yeah, I'm gonna have to go through template by template and add cfaborts. Test run the loop, check the ram usage and continue until I find the problem I guess.I'm just wondering if this is normal or not? Should memory usage increase like this when no new data is being stored in the application scope and nothing is being cached. Why does the memory increase? Or is this an indication of some sort of memory leak or bad coding somewhere leading to this climbing memory usage. Can anyone tell me before I start going through this thing template by template? Brook At 12:25 PM 7/23/2004, you wrote: Any chance of taking portions out of the form handler one at a time? Does debugging clue you in on anything? John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:171931This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusion business=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 f1a9d74.jpg -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:171935This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1499.1419.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=11 [] Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX memory usage on specific page request
Well, that's the million dollar question.It sounds like from the experience of other users that bad coding could cause that.Or maybe there is some weird thing you're doing that is storing something in RAM that you're not thinking of.Going piece by piece seems like the best chance of figuring it out John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:05 PM To: CF-Talk Subject: RE: CFMX memory usage on specific page request Yeah, I'm gonna have to go through template by template and add cfaborts. Test run the loop, check the ram usage and continue until I find the problem I guess.I'm just wondering if this is normal or not? Should memory usage increase like this when no new data is being stored in the application scope and nothing is being cached. Why does the memory increase? Or is this an indication of some sort of memory leak or bad coding somewhere leading to this climbing memory usage. Can anyone tell me before I start going through this thing template by template? Brook At 12:25 PM 7/23/2004, you wrote: Any chance of taking portions out of the form handler one at a time? Does debugging clue you in on anything? John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:171931This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4 Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusi onbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclic kDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 f1a9d74.jpg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX memory usage on specific page request
I'll go through it this weekend, template by template and see where the RAM spikes. Thanks guys! Brook At 01:32 PM 7/23/2004, you wrote: Well, that's the million dollar question.It sounds like from the experience of other users that bad coding could cause that.Or maybe there is some weird thing you're doing that is storing something in RAM that you're not thinking of.Going piece by piece seems like the best chance of figuring it out John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:05 PM To: CF-Talk Subject: RE: CFMX memory usage on specific page request Yeah, I'm gonna have to go through template by template and add cfaborts. Test run the loop, check the ram usage and continue until I find the problem I guess.I'm just wondering if this is normal or not? Should memory usage increase like this when no new data is being stored in the application scope and nothing is being cached. Why does the memory increase? Or is this an indication of some sort of memory leak or bad coding somewhere leading to this climbing memory usage. Can anyone tell me before I start going through this thing template by template? Brook At 12:25 PM 7/23/2004, you wrote: Any chance of taking portions out of the form handler one at a time? Does debugging clue you in on anything? John -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 3:09 PM To: CF-Talk Subject: CFMX memory usage on specific page request I run a web application that handles many form submissions through the same 'form handler' series of templates. My application quickly grows to 850 megs memory usage and I have been trying to figure out where that memory is being used. Yesterday, I put my form submission handler template in a loop to 100 and I watched the memory grow as soon as it finished by about 100 megs. I ran it again, for another 100, and it grew by another 100. What I want to know is, should this happen? The form submission handler does not cache any queries or add any data to the application scope. Why does it simply repeated use add to the ram usage? The series of templates executed includes a number of calls to application scopes CFC's and a couple that are not in the application scope. There is a custom tag and a call to the CFX_imsMail tag to send mail. A UDF library is also includes on each request. But I'm stumped as to why each time it runs it eats up more and more memory. Is this normal? Or is there something in this stack of templates that is misbehaving? Brook -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:171931This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4 Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusi onbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclic kDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=38 f1a9d74.jpg -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:171941This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=44 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dynamically Add Form Fields
I've seen solutions where the a placeholder div is insert into the original page content, and then you use _javascript_ to dynamically write new form fields into the div, as needed. Don't know where I saw it, but that's probably the first avenue I'd try. cheers, barneyb On Fri, 23 Jul 2004 14:15:23 -0600, Jillian Carroll [EMAIL PROTECTED] wrote: Hey... I have a need to dynamically (using a button/link) add additional fields to a form.Does anybody have/know of a solution for this? (purchased or otherwise) -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Session-Based CFC Usage Across Clusters
If you decided to focus on clustering and not use session-bases CFCs, how did you implement your processes? The general strategy for implementing across a cluster is to move data from the session scope to the client scope. There are limitations, one of which is that the client scope can't easily hold complex data, only simple values. You can get around this limitation by serializing your data before you push it into the client scope. I've never tried to load a CFC into the client scope, I suspect it would fail. I have been asked to support Windows 2003 Network Load Balancing, which CFMX 6.1 would support, however, I have my CFCs sitting in the session scope.I thought that an alternative would be to store a session-based structure that would hold all the data I would normally store in my CFC instance.Then, I would just call application-based functions that would normally be in the CFC instance as well. You would need to store the structure in the client scope, because the session scope would not span the servers unless they were sharing memory in a true cluster (e.g. Wolfpack) configuration. My fear is that I would then need to lock each call to the appliation-scope functions since many browser sessions could get mixed-up data. Indeed you would. One strategy is to duplicate() the application scope into the request scope for each request, but you take a performance hit when you do that. In my own anecdotal testing I have found the tradeoff is generally better than ending up with lock timeouts on the application scope. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dynamically Add Form Fields
Jillian, Go to www.pengoworks.com and check out qForms. It is a _javascript_ API that has some methods you are looking for. There is also a mailing list to ask qForms questions on, its over at yahoo. Anyway, check it out and good luck! Mike Hey... I have a need to dynamically (using a button/link) add additional fields to a form.Does anybody have/know of a solution for this? (purchased or otherwise) -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
it still gets me the same results as i had before 09085000 2004-07-23 12:30 800 59.9 which i cant seem to break into individual pieces to send to an array -- Original Message -- From: Claude Schneegans [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 23 Jul 2004 13:12:49 -0400 Ummm, your link is to localhost and that won't work for anyone but you. Ooops, I cut'n paste the link from the wrong window :-( It is http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm Sorry about that. - Select http for input mode, - enter RE1=[[:cntrl:]]+USGS[[:space:]]+ - enter RE2=USGS[[:space:]]+|$ - output mode = list - extract = last (you may also have them all in a query) -- ___ 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: Session-Based CFC Usage Across Clusters
On Fri, 23 Jul 2004 13:42:18 -0500, Dawson, Michael [EMAIL PROTECTED] wrote: I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Session-based CFCs cannot be replicated in CFMX 6.1 but you do not require session replication in order to build a cluster. macromedia.com is clustered and uses CFCs in session scope extensively. We use sticky-session (once your session is created you continue to talk to the same app server). -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Session-Based CFC Usage Across Clusters
Where you'd call a method on your session-scoped CFC, we call a method on a shared CFC instance, passing in the client variable structure, which represents the state that your session CFC would have in instance variables. Can you clarify what you mean by shared CFC instance?Do you mean in the application scope? If so, do you then lock each call to the shared CFC method? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: i need help stripping :)
it still gets me the same results as i had before 09085000 2004-07-23 12:30 800 59.9 which i cant seem to break into individual pieces to send to an array Ok, but now that you have the string, you can break it easily by treating it as a space delimited list, ie: CFQUERY... INSERT INTO myTable... rivercode = '#listGetAt(theString, 1, )#' date ='#listGetAt(theString, 2, )#' time ='#listGetAt(theString, 3, )#' riverFlow ='#listGetAt(theString, 4, )#' waterTemp ='#listGetAt(theString, 5, )#' (check for the type of columns, and do not use quotes for numerical types) .. -- ___ 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: i need help stripping :)
This is a tab-separated list so, use listgetat with a chr(9) delimiter. HTH Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 23, 2004, at 2:04 PM, dave wrote: it still gets me the same results as i had before 09085000 2004-07-23 12:30 800 59.9 which i cant seem to break into individual pieces to send to an array -- Original Message -- From: Claude Schneegans [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 23 Jul 2004 13:12:49 -0400 Ummm, your link is to localhost and that won't work for anyone but you. Ooops, I cut'n paste the link from the wrong window :-( It is http://www.contentbox.com/claude/customtags/REextract/ testingREextract.cfm Sorry about that. - Select http for input mode, - enter RE1=[[:cntrl:]]+USGS[[:space:]]+ - enter RE2=USGS[[:space:]]+|$ - output mode = list - extract = last (you may also have them all in a query) -- ___ 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: Dynamically Add Form Fields
_javascript_ can do this, have a look at: document.open document.write document.close HTH Dick The nice thing about standards is that there are so many of them to choose from. - Andrew S. Tanenbaum - On Jul 23, 2004, at 1:15 PM, Jillian Carroll wrote: Hey... I have a need to dynamically (using a button/link) add additional fields to a form. Does anybody have/know of a solution for this? (purchased or otherwise) -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Session-Based CFC Usage Across Clusters
So to keep from having to re-write my applications, I would need to ensure that Win2k3 NLB supports sticky sessions and that the feature enabled?I'm new to NLB, but I'll dig around this weekend. I would rather stay with session-based CFCs and take the small chance that the network connection or hardware connection will fail and cause the users to lose their session.However, I will consider the other options of client variables as well. Thanks for everyone's replies. _ From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:20 PM To: CF-Talk Subject: Re: Session-Based CFC Usage Across Clusters On Fri, 23 Jul 2004 13:42:18 -0500, Dawson, Michael [EMAIL PROTECTED] wrote: I have read that session-based CFCs cannot be clustered (according to a livedoc comment). Session-based CFCs cannot be replicated in CFMX 6.1 but you do not require session replication in order to build a cluster. macromedia.com is clustered and uses CFCs in session scope extensively. We use sticky-session (once your session is created you continue to talk to the same app server). -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Session-Based CFC Usage Across Clusters
So to keep from having to re-write my applications, I would need to ensure that Win2k3 NLB supports sticky sessions and that the feature enabled?I'm new to NLB, but I'll dig around this weekend. NLB in Windows Server 2003 supports sticky sessions, they're called single affinity within the interface if I recall correctly. 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]
cf_multirelatedselects
Has anyone been able to get the ONCLICK1 event to work with this tag? Absolutely nothing is happening when I change the first select box. I even tried alert('hi'); on the onclick2, nothing happened there. CF_MultiRelatedSelects SELECTBOXES = 2 QUERY=location_facility FORMNAME = laforma FIELDNAME1=c_locationid FIELDNAME2=c_facilityid DISPLAY1=location DISPLAY2=facility VALUE1=c_locationid VALUE2=c_facilityid HTMLAFTER1=/td/trtrtd class='datag'label for=''Facility:/label/tdtd this.options[this.options.selectedIndex].text,'newWin'); Greg Morphis Rapid Response Team Client Server Dev/Analyst I ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cf_multirelatedselects
Has anyone been able to get the ONCLICK1 event to work with this tag? ... this.options[this.options.selectedIndex].text,'newWin'); I don't know what that custom tag is doing exactly, but you probably don't want to use _javascript_: within an event handler. That's only for invoking _javascript_ within an HREF attribute, I think. 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: A script to Prevent SQL Injection: feedback/suggestions?
Hi Matt, I think it might have been me! no aplogies needed :) (just trying to keep this excellent thread alive) regards, Andrew. and CodeCleaner: http://www.antiwrap.com/?140 I use this in Application.cfm to scrub the url.Takes about 10ms. Got it from a thread here.Apologies to the author but I forget who it was:-( !--- scrub url and query string for shenanigans --- cfset variables.ThisURLVar=cgi.script_name urldecode(cgi.query_string) CF_CodeCleaner input=#variables.thisurlvar# cfset variables.Cleanurl=clean_code !--- Do the original and the cleaned copy still match? --- cfif CompareNoCase(variables.thisurlvar,variables.Cleanurl) !--- No.put out a mysterious 500 error, and rat out the offense --- ... blah blah blah ... cfabort /cfif -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cf_multirelatedselects
i suspect teh use of JAVASCTIPT:its not use in events, rather in none even instances such as HREF. Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 7:20 PM To: CF-Talk Subject: cf_multirelatedselects Has anyone been able to get the ONCLICK1 event to work with this tag? Absolutely nothing is happening when I change the first select box. I even tried alert('hi'); on the onclick2, nothing happened there. CF_MultiRelatedSelects SELECTBOXES = 2 QUERY=location_facility FORMNAME = laforma FIELDNAME1=c_locationid FIELDNAME2=c_facilityid DISPLAY1=location DISPLAY2=facility VALUE1=c_locationid VALUE2=c_facilityid HTMLAFTER1=/td/trtrtd class='datag'label for=''Facility:/label/tdtd > this.options[this.options.selectedIndex].text,'newWin'); Greg Morphis Rapid Response Team Client Server Dev/Analyst I ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Dynamically Add Form Fields
make use of the browsers DOM.Check out brainjar.com for examples.You can create any HTML element, tweak its attributes then append it to any other part of your document all on the fly. Doug -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:15 PM To: CF-Talk Subject: Dynamically Add Form Fields Hey... I have a need to dynamically (using a button/link) add additional fields to a form.Does anybody have/know of a solution for this? (purchased or otherwise) -- Jillian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]