Re: any free Oracle IDE
On 10/11/05, Robert Everland III [EMAIL PROTECTED] wrote: I am using TOAD for Oracle, but does anyone have any Win32 applications that are free that can interface to Oracle? I have also tried jdeveloper. I was less than impressed with that. Some useful links for you: http://awads.net/wp/2005/08/19/your-sql-tool/ http://awads.net/wp/2005/10/12/your-sql-tool-part-ii/ http://www.freelists.org/archives/oradev/08-2005/msg9.html HTH -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Make a loop repeat and control timing?
On 10/4/05, Taco Fleur [EMAIL PROTECTED] wrote: Or if on a lower version of CF you could use the WAITFOR command in SQL within a cfquery tag.. That would be in MS SQL Server, right? -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Make a loop repeat and control timing?
On 10/4/05, Taco Fleur [EMAIL PROTECTED] wrote: Correct. Not sure if it works with anything else. I can tell you for sure that WAITFOR does not exist in Oracle. However, there is a similar procedure: DBMS_LOCK.SLEEP (seconds IN NUMBER). It suspends the session for a given number of seconds. -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220086 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Query Question...[hopefully]
Database? version? table structure? sample data? ... -- Eddie Awad. http://awads.net/ On 8/25/05, Che Vilnonis [EMAIL PROTECTED] wrote: If have a query that returns a 24 hour breakdown of orders by the hour on a monthly basis. (see below). As you can see, Hour 5 6 are missing because there are no values to return. What would be the easiest way to add Hour 5 and Hour 6 to the query's recordset with a corresponding value of zero for each hour? The trick is, from month to month, the hours that have no values might change. Any idee-ers? Thanks, Che. HOURTOTALORDERSPERHOUR 0 5 1 5 2 4 3 2 4 2 7 3 8 2 9 10 10 7 11 7 12 3 13 5 14 11 15 10 16 6 17 13 18 7 19 13 20 9 21 16 22 11 23 14 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216430 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Newsletter Manager Suggestions
On 8/24/05, Emmet McGovern [EMAIL PROTECTED] wrote: Does anyone have any experiences with the various mailing list managers out there? We need to get one and was hoping for some recommendations. If you do not want to host the mailing lists on your server, FreeLists.org is an excellent (and free) mailing lists service that can do it for you. However, the lists are all Internet and technology-related. Check it out at http://www.freelists.org/ In fact, I have created a mailing list there for Oracle developers: http://www.freelists.org/webpage/oradev Cheers -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL/Oracle Indexing a temporary view.
Can you create an index to a view created with SQL? In Oracle, a view is nothing but a stored select statement. Tables store data, views do not (unless they are materilized views). So, you do not index views, but you index the tables that the views select from. -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: boolean cfsqltype
On 8/23/05, Deanna Schneider [EMAIL PROTECTED] wrote: So, I just noticed that there isn't a documented cf_sql_boolean type for use with stored procedures. If you use it, though, it doesn't fail to compile, and it converts it to a cf_sql_char. But, with my stored proc in Oracle 10g - it's not going in as a boolean. (I get the error about wrong number or type of paramaters.) Does anyone know if there's a workaround that will really send a boolean to the stored proc, or do I need to alter my stored proc to not expect a boolean? Oracle's PL/SQL Boolean data type does not have an equivalent in ColdFusion, I think this may be because Boolean is not a native SQL data type. So, what I usually end up doing is to change the data type of the Boolean argument in my stored procedure to something like varchar2(1), accepting values of Y/N or T/F. -- Eddie Awad. http://awads.net/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: folder query to XML?
On 8/23/05, Paul Hastings [EMAIL PROTECTED] wrote: well i think i can figure depth from the folder's full name (INBOX.test.testDir, counting the number of folder separators in the name) so this looks close. thanks i'll give it a whirl. If you use Oracle DB then you can use the LEVEL, CONNECT BY and START WITH in your query. The LEVEL would be equivalent to the depth. Something like (untested): SELECT name,fullname,parentFolder,totalMessages, LEVEL FROM results.folders CONNECT BY parentFolder = PRIOR fullname START WITH parentFolder = ...your parent folder name here... -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216102 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: boolean cfsqltype
On 8/23/05, Jochem van Dieten [EMAIL PROTECTED] wrote: Boolean is a native SQL datatype. In Oracle, Boolean is not a native SQL datatype. It is a PL/SQL datatype. In other words, you cannot create a database table having a column with a boolean datatype: H:\SQLplussqlplus scott/tiger SQL*Plus: Release 9.2.0.1.0 - Production on Tue Aug 23 15:03:57 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production [EMAIL PROTECTED] create table t (mycol boolean); create table t (mycol boolean) * ERROR at line 1: ORA-00902: invalid datatype [EMAIL PROTECTED] create table t (mycol varchar2(1)); Table created. Related Oracle documentation: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c13datyp.htm http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216109 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: boolean cfsqltype
On 8/23/05, Jochem van Dieten [EMAIL PROTECTED] wrote: I think you are reading me wrong. When I write that boolean is a native SQL datatype I am not refering to some implementation, I am refering to the SQL standard. See ISO/IEC 9075-2:2003 4.1.2 Jochem, I think we misunderstood each other. I was referring to Oracle's implementation. No harm done :) -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216114 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: URL string not working... HELP!
On 8/23/05, Sharon Creese [EMAIL PROTECTED] wrote: it will work for product ids of : ABCD1 12-1234 AB-123 123-A23-123 But not for 12-34-17 I'm guessing here, but I'm noticing a pattern. maybe the string is being mistakenly treated as a date: mm-dd-yy 1-1-12 12-34-17 (but 34 is not a valid day??) All the strings that work for you do not fall into this format. Again, it's just an observation. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216144 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Working with OPC (Other People's Code)
On 7/22/05, Douglas Knudsen [EMAIL PROTECTED] wrote: I blogged about my fav here http://www.cubicleman.com/?id=51#comments This one wins the award for sure. Ever hear of MonthAsString()? doh! Who is the poor guy who inherited this code: http://www.mschopman.demon.nl/horror.txt? -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Looping over query assistance
On 7/21/05, Merrill, Jason [EMAIL PROTECTED] wrote: I want to get all the fields matching the userid and return and array of the matching values. ... #getCourses.title# It works, I can get the first title that matches the userid in the query, but if I do the loop like that, and I just return #courses# then it returns an empty array. What am I doing wrong? use listToArray(valueList(getCourses.title)) -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic Thumbnails
On 7/21/05, Greg Johnson [EMAIL PROTECTED] wrote: Is there a way in Cold Fusion MX to automaticly create a tumbnail of a bigger image for a inhouse photo catalog? Img size, rez, info etc as well? You can accomplish this using Java in your ColdFusion template. Here is a link that shows you how to get the image dimensions: http://awads.net/wp/2005/06/16/get-image-dimensions/. You can modify it to use img.getScaledInstance() to resize the image. I have not tested this but it is something you may want to explore further. HTH. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212446 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Formatting text in Report Builder
I'm using Report Builder to display the following information. How would I display the following results on three separate lines. This: FORM.address FORM.city FORM.phone Is currently reading like this: 1212 North StreetChicago232-234-3455 I need it to look like this: 1212 North Street Chicago 232-234-3455 Anyone have any ideas on how to get the line breaks in there? Have you tried appending a carriage return/line feed to the end of each line? like this: FORM.address CHR(13) CHR(10) FORM.city CHR(13) CHR(10) FORM.phone -- Eddie Awad. http://awads.net/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: retrieve ID from db insert
I don't know SPs yet, but that's an interesting idea. I'll have to look into that when I get time. Well, it's simple. Here is a working example of how you would do it in Oracle using a stored procedure: create table t (id number, colname varchar2(50)) / create sequence t_seq start with 1 increment by 1 minvalue 1 maxvalue / create or replace procedure insert_into_t (colname_in in t.colname%type, id_out out t.id%type) as begin insert into t (id, colname) values (t_seq.nextval, colname_in) returning id into id_out; end; / Then in ColdFusion: cfstoredproc datasource=dev8native procedure=insert_into_t cfprocparam type=in cfsqltype=CF_SQL_VARCHAR value=hi there cfprocparam type=out cfsqltype=CF_SQL_INTEGER variable=id_out /cfstoredproc cfoutput#id_out#/cfoutput Of course, you could also just create a when-insert trigger on the table to automatically populate the id column so you do not have to worry about it in your insert statements. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: retrieve ID from db insert
On 7/11/05, Aaron Rouse [EMAIL PROTECTED] wrote: I always just use triggers for when inserting, but it seemed like the worry here was to know the ID after the insert to I'd guess display to the user. How would a trigger help for that need? The trigger won't help for that need. I was just stating an idea because that's how I would do it. And by the way, I forgot to put a commit after the insert in the example procedure in my previous e-mail. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Depth of a tree?
I have a hierarchical set of data stored in tree format. The tree may or may not be a binary tree ... i.e. each node could have 0 thru N sub-nodes. Now, I need to calculate the length of the longest branch, or otherwise, the depth of the tree. My comp. sci. days are a long way behind me, so does anybody know how this would be calculated? Here is an example of how I would do it in Oracle (assuming you have the tree stored in a table in an Oracle database): create table t ( parent varchar2(20) ,title varchar2(20) ,left number ,right number ) / insert into t values ( null, 'Food', 1, 18 ); insert into t values ( 'Food', 'Fruit', 2, 11 ); insert into t values ( 'Fruit', 'Red', 3, 6 ); insert into t values ( 'Red', 'Cherry', 4, 5 ); insert into t values ( 'Fruit', 'Yellow', 7, 10 ); insert into t values ( 'Yellow', 'Banana', 8, 9 ); insert into t values ( 'Food','Meat', 12, 17 ); insert into t values ( 'Meat' , 'Beef', 13, 14 ); insert into t values ( 'Meat' , 'Pork', 15 , 16 ); select max(depth) from ( select level as depth from t connect by parent = prior title start with parent is null ) The above query returns 4. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211562 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: query sum or group by
SELECT p.si_id,s.food_store_id,s.gs_price, SUM(s.gs_price) AS total_price FROM fsnep_food_store_purchases p, fsnep_food_store s,fsnep_food_store_game_info g WHERE p.food_store_id = s.food_store_id AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id# GROUP BY p.si_id,s.food_store_id,s.gs_price Remove the s.gs_price from the select clause and the group by clause if you want a sum on this column: SELECT p.si_id,s.food_store_id, SUM(s.gs_price) AS total_price FROM fsnep_food_store_purchases p, fsnep_food_store s,fsnep_food_store_game_info g WHERE p.food_store_id = s.food_store_id AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id# GROUP BY p.si_id,s.food_store_id -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Including App.cfc in App.cfc
On 7/8/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: The Application.cfc in the nested directory will omit the Application.cfc code in the parent directory... this means that much of the code to set these variables would need to be duplicated in both cfc's. What I read (and I could be misinterpreting) is that he wanted a way to eliminate the need to duplicate that code. Why not make the Application.cfc in the subfolder inherit (extend) the Application.cfc in the root folder? This will eliminate duplication. Here is a quote from a CF technote about extending the ColdFusion MX 7 application framework: You can set/implement everything that applies to all your applications at the top level, and then inherit from it as many levels deep as you need to. If you need to override something in a lower level Application.cfc, you have that ability as well. Read the whole technote here: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=9ce734f4 -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211442 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML problem
On 7/8/05, Rebecca Wells [EMAIL PROTECTED] wrote: How do you parse out this kind of XML string? I need to find the value of aAccountNumber and bAddress: Parameter ParameterNameaAccountNumber/ParameterName ParameterValueX/ParameterValue /Parameter Parameter ParameterNamebAddress/ParameterName ParameterValueX/ParameterValue /Parameter xPath to the rescue: cfxml variable=myDOM doc Parameter ParameterNameaAccountNumber/ParameterName ParameterValue12345/ParameterValue /Parameter Parameter ParameterNamebAddress/ParameterName ParameterValueUSA/ParameterValue /Parameter /doc /cfxml cfset accountNumber = xmlSearch(myDOM,doc/Parameter[./ParameterName='aAccountNumber']/ParameterValue) cfset address = xmlSearch(myDOM,doc/Parameter[./ParameterName='bAddress']/ParameterValue) cfoutput Account Number: #accountNumber[1].xmlText#br Address: #address[1].xmlText#br /cfoutput If you have multiple account number nodes, you would need to loop over the array accountNumber[]. Same applies to the array address[]. HTH -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211446 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Poor performing Oracle Query
The query that was performing poorly at 18 minutes was being run against the production server where the data is very active. Apparently every time data was being added to the main tables, this query would be started over. So depending on the traffic sometime it performs relatively well other times it performs very poorly. Sounds like some SQL tuning may be required here! Ya all have a good weekend ... -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Parsing XML problem
Thank you, Eddie. That helped me figure it out, but it turned out that I didn't need to use cfxml as I was already using xmlparse, but the rest of your code was spot on. Have a good weekend, if you haven't already started. I used cfxml only to test my code. I'm glad it was helpful. Have a nice weekend. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211471 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Poor performing Oracle Query
Does oracle have something similar to with (nolock) that SQL server has? This would just run the query and not wait if it can get a lock on all the tables.. In Oracle, If you're just selecting rows from tables, there should not be any locks issued on the rows unless you explicitly say for update of followed by a list of columns. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What breaks during upgrade from 6.1 to 7?
On 7/6/05, Claremont, Timothy [EMAIL PROTECTED] wrote: I am going to install CF7 standard on my 6.1 test server today. I will then be going over the site to see that everything is working as it should. If all goes well I will repeat the process on my production server. For due dilligence I need to visit virtually every part of the site to confirm functionality, but what functions are MOST likely to cause me grief, so I can approach those areas first? Here is what I ran into: http://awads.net/wp/2005/06/29/cflocation-behavior-change-in-cfmx7/ Other than that, nothing broke. In fact, because CFMX7 has some nice new features, I have spent more time modifying pages to take advantage of the new version's capabilities than to fix things. -- Eddie Awad. http://awads.net/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: XML question
On 7/6/05, Rebecca Wells [EMAIL PROTECTED] wrote: First, how do I access the XML document that will be posted to my web app (via HTTPS POST)? http://awads.net/wp/2005/07/06/read-xml-from-an-http-post/ Second, is there any easier way to refer to an particular XML element as a simple value as I am attempting to do here with #variable.myXMLName[1].XmlText#? Don't know what you mean. -- Eddie Awad. http://awads.net/ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: XML question
On 7/6/05, Anthony Prato [EMAIL PROTECTED] wrote: Now I'm wondering how to use coldfusion to post xml cfhttp url=url_to_post_to method=post cfhttpparam type=XML name=XmlDoc value=#your_xml# /cfhttp -- Eddie Awad. http://awads.net/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54