RE: Coldfusion Switch Error - Hex Characters
Thats an interesting bug! heres a sorta workaround:
cfscript
function Hex7toStr(Char){
var newchar = ;
var asciiChar = ;
var i=0;
for(i=1;i lte len(char);i=i+1){
asciiChar = asciiCharasc(mid(char,i,1));
}
switch (asciiChar)
{
case asc(0)asc(0):
newchar = NUL;
break;
case asc(0)asc(A):
newchar = LF;
break;
}
return newchar;
}
/cfscript
cfoutput
00:#Hex7toStr(00)#br
0A:#Hex7toStr(0A)#br
/cfoutput
-Original Message-
From: AFM [mailto:[EMAIL PROTECTED]
Sent: 08 July 2005 17:39
To: CF-Talk
Subject: Coldfusion Switch Error - Hex Characters
Hello,
I have an odd error with a piece of code I'm migrating from CF5 to
MX6.1. It is a simple switch statement that takes Hex7 values as a
string and spits out the ascii equivilent as a string.
Problem is, it is reading hex value '00' and '0A' as the same thing,
and returns a duplicate value error for 0.0. I've tried chr codes,
changing it to IF statements, and more. I was hoping an expert could
look at it and give me a hint to a fix. Below is a small snippet of
the overall code. Thanks.
cfscript
function Hex7toStr(Char){
switch (Char)
{
case 00:
newchar = NUL;
break;
case 0A:
newchar = LF;
break;
case 30:
newchar = 0;
break;
case 41:
newchar = A;
break;
case EB:
newchar = a;
break;
}
return Trim(newchar);
}
/cfscript
cfset hexChar1 = 00
cfset hexChar2 = 0A
cfset hexChar3 = 30
cfset hexChar4 = 41
cfset hexChar5 = E1
CFSET hexStr1 = #Hex7toStr(hexChar1)#
CFSET hexStr2 = #Hex7toStr(hexChar2)#
CFSET hexStr3 = #Hex7toStr(hexChar3)#
CFSET hexStr4 = #Hex7toStr(hexChar4)#
CFSET hexStr5 = #Hex7toStr(hexChar5)#
cfoutput
table
trtd#hexChar1#/tdtd#hexStr1#/td/tr
trtd#hexChar2#/tdtd#hexStr2#/td/tr
trtd#hexChar3#/tdtd#hexStr3#/td/tr
trtd#hexChar4#/tdtd#hexStr4#/td/tr
trtd#hexChar5#/tdtd#hexStr5#/td/tr
/table
/cfoutput
~|
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:211519
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: Using FSO with CF
Thank you S. Isaac... I'll be change our code to Java.io.File routines... Do you have any example about? Tutorials, how to use that Java classes? Thanks once more again. MD 2005/7/7, S. Isaac Dealey [EMAIL PROTECTED]: Thanks S. Isaac Dealey Yes. I need to use FSO with CF(CreateObject). But what I need to setup in our Win2003 Server. With Java I'll get best results? Thanx once more again. I would expect the java classes like java.io.File to be more efficient when using ColdFusion version 6.1 or later. (On version 5 the windows scripting object might be more efficient.) But asside from efficiency, the java classes are more portable since they can be used on any CF app platform, whether that's windows, linux, solaris or some unsupported JBoss instance on a SCO Unix machine. Reflection of the java classes when using ColdFusion 6.1 or later is amazingly efficient in and of itself when you're not relying on the CF native tags like cfdirectory which returns a bunch of information you may or may not need / want about the collection of files in your directory. Cfdirectory is great for the sake of simplicity, but if you really need performance, digging out the underlying java classes is the way to go. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:211520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Creating a breadcrumb trail
I was trying to think of a good way to create a breadcrumb trail for my users as they navigate through my app. The first thing that comes to mind is setting a session variable in onRequestStart in App.cfc. Then using that to create the links. Could someone expand on this? Or offer a better solution? I'm looking for somethin' simple. Remember, it's Will here. :) Thanks, Will Will there's a UDF at CFLib.org that does breadcrumb links http://www.cflib.org/udf.cfm?ID=1186 hth, larry ~| 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:211521 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: Using FSO with CF
Thank you S. Isaac... I'll be change our code to Java.io.File routines... Do you have any example about? Tutorials, how to use that Java classes? Thanks once more again. Welcome, I just read the API documentation on the sun site myself... http://java.sun.com/j2se/1.4.2/docs/api/java/io/package-summary.html java.io.File will handle basic file information (does it exist, is it a file, when was it modified, etc) ... to actually write files you need to use a couple other classes, in particular FileWriter and FileOutputStream -- you may also need an OutputStreamWriter. I'd expect you can probably come up with a tutorial or two by googling java.io.FileWriter or java.io.FileOutputStream. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:211522 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: Creating a breadcrumb trail
Do you mean a true breadcrumb trail (a clicktrace, or where the user has been) or do you mean a page heirarchy, or a drilldown path? (page heirarchy) Site: Section: Subsection: Page (drilldown path) Home: Books: Family Law: Probate and Family Court Handbook (clicktrace) Home: Top Stories: Home: Signup: Thanks for Subscribing (step list) Step 1 Basic Info | Step 2 Payment Info | [Step 3 Confirmation] On 7/11/05, Larry Lyons [EMAIL PROTECTED] wrote: I was trying to think of a good way to create a breadcrumb trail for my users as they navigate through my app. The first thing that comes to mind is setting a session variable in onRequestStart in App.cfc. Then using that to create the links. ~| 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:211523 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: CFMX7 Integration with J2EE - How complete is the integration?
CFMX *is* Java In fact, it's Sun-certified J2EE compliant. That's pretty pure. Chris Norloff -- Original Message -- From: Mosh Teitelbaum [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 30 Jun 2005 14:17:36 -0400 All: I have a client that, for reasons that much matter, wants to move one of their CF apps to a J2EE server (running BEA WebLogic). The server's administrator is adamant that only pure J2EE applications may be deployed on this server. My understanding of CFMX7's capabilities with this respect is that the EAR/WAR files it creates are pure. However, the admin says that CF still doesn't natively integrate with BEA's management console. So, what's the deal? Does CFMX7 offer true integration or just better integration that its predecessor? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| 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:211524 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: CFMX7 Integration with J2EE - How complete is the integration?
One possibility for using CFMX Admin is to not use the CFMX Admin GUI. You can edit the neo*.xml files then deploy them to configure CFMX, without using the CFMX Admin GUI. We did this on a WebSphere cluster because the CFMX Admin settings won't progagate across the cluster. However, a script can push the neo*.xml files out quite easily. Chris Norloff -- Original Message -- From: Mosh Teitelbaum [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Thu, 30 Jun 2005 16:43:51 -0400 All: Thanks for the replies. I don't think the admin is a CFMX hater, just someone who has enough on his hands managing their WebLogic boxes without having to learn another management interface (the CF Admin). And, as someone who wishes he had more free time on his hands, I can't find fault with that. While I get the distinction between pure Java and an appserver-specific extension, I think I had been expecting a bit more in terms of deploying CFMX7 apps on J2EE servers. I think it was back in February that BF wrote a CFDJ article basically saying that J2EE server admins would no longer have to jump through hoops to deploy CFMX7 apps. Having read the document at the URL that Robert provided, I'm not sure that's entirely accurate. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Robert Munn [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 2:42 PM To: CF-Talk Subject: CFMX7 Integration with J2EE - How complete is the integration? Technically, I believe your client's admin is correct. Take a look at this page on installing CFMX 7 in J2EE mode with WebLogic. http://www.macromedia.com/support/coldfusion/j2ee/cfmx7j2ee_weblog ic_deploy.html One component of ColdFusion is a J2EE servlet application that compiles CFML into JSP files and executes them. That part of ColdFusion could be called pure Java. ColdFusion also contains other components- the ODBC services and the Search service, for instance, which are not pure Java- they aren't even Java at all. My re-collection from a conversation a couple of years ago at MAX was that Macromedia was thinking about putting out a pure J2EE implementation of ColdFusion without the non-Java components- an edition that would deploy and run on any J2EE server on any platform. I don't know if that plan ever came to fruition; I don't see it listed as a product edition on the Macromedia site. Rob All: I have a client that, for reasons that much matter, wants to move one of their CF apps to a J2EE server (running BEA WebLogic). The server's administrator is adamant that only pure J2EE applications may be deployed on this server. My understanding of CFMX7's capabilities with this respect is that the EAR/WAR files it creates are pure. However, the admin says that CF still doesn't natively integrate with BEA's management console. So, what's the deal? Does CFMX7 offer true integration or just better integration that its predecessor? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| 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:211525 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: Using FSO with CF
Thanx S. Isaac Dealey... Sun... i'll be there... ;-) Cheers. MD 2005/7/11, S. Isaac Dealey [EMAIL PROTECTED]: Thank you S. Isaac... I'll be change our code to Java.io.File routines... Do you have any example about? Tutorials, how to use that Java classes? Thanks once more again. Welcome, I just read the API documentation on the sun site myself... http://java.sun.com/j2se/1.4.2/docs/api/java/io/package-summary.html java.io.File will handle basic file information (does it exist, is it a file, when was it modified, etc) ... to actually write files you need to use a couple other classes, in particular FileWriter and FileOutputStream -- you may also need an OutputStreamWriter. I'd expect you can probably come up with a tutorial or two by googling java.io.FileWriter or java.io.FileOutputStream. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:211526 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
Query Problem.
I have a problem I am sure is simple to solve but it has proved to be beyond me. Imagine I have the following data... StockID | Data1 | Data2 --- 1 | 1 | 2 2 | 3 | 4 3 | 5 | 6 And I want a query to return StockID | Data1 | Data2 --- 3 | 5 | 6 I am trying to use SELECT max(stockid) as stockid, data1, data2 FROM table HAVING data1 = 5 Unfortunately this is returning the following data StockID | Data1 | Data2 --- 3 | 5 | 2 Ie: the correct stockid and data1 but data2 from a diferent row! I have tried using a sub-query but it just crashes the server (trying to do WHERE StockID IN (over 7000 results from sub-query). I am using MySQL and the actual query in question is below for your ref... SELECTs.ItemID, s.ASIN, MAX(q.StockID) AS StockID, q.Condition, q.MaximumSalePrice, q.MinimumSalePrice, q.AddedToFile, q.CurrentAmazonPrice FROM stockitemdetails s JOIN stockquantities q ON (s.ItemID = q.ItemID) WHERE q.Quantity 0 AND s.ASIN != AND s.ASIN IS NOT NULL AND s.ASIN != N/A AND LEFT(s.ASIN,1) != GROUP BY s.ASIN HAVINGAddedToFile= 0 ORDER BY s.ItemID -- Jay ~| 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:211527 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
Hello, I've never heard of oracle restarting a query because the underlying data had changed. Oracle uses a multi-version view of data to show you results consistent with what the database looked like at the start of the query (at the very least - it can also do consistent with the start of the transaction): if a row has been changed since the query started then oracle will read the old value from rollback and use it in the query. If you are executing a long running select query and making lots of modifications to the underlying database at the same time, oracle will eventually need to read info from a rollback segment that has been flushed to disk and you will get the dreaded ORA 01555 error (snapshot too old)... but Oracle won't restart the query. Of course, you could have written your query in some kind of try-catch block (in either cf or pl/sql) that just repeats whenver this error comes up, but i assume you would have mentioned it. Step 0 (if possible): export your live schema and import it to your testing environment. You won't be able to recreate usage but you will have realistic data. The very first thing to do in investigating why this query takes so much more time to execute in production than in development is to make sure that you are comparing apples to apples: ie run the query using coldfusion against both databases, and run the query using sql*plus against both databases and check the results. In the past, i've seen queries that ran much slower in cf than in TOAD because cf needed all the results before it could return whereas TOAD only needed the first rows. If your query returns a lot of records this is something to check earlier rather than later. If you see that the same query run from the same client still takes a huge amount more time on the production database then the next step is to do an EXPLAIN PLAN on both databases and make sure that the results are identical. If they aren't, then ask yourself why not: different volumes of data, lack of table stats in one of the databases, user resource limitation, etc. Finally, if the plans are the same and the query is still taking waay more time in production, then you need to turn on tracing and use the tkprof utility to see exactly what is being done. This will slow down your live db even more but will give you the definitive answer as to what is happening in the db. /t -Original Message- Subject: Poor performing Oracle Query From: Dustin Tinney [EMAIL PROTECTED] Date: Sun, 10 Jul 2005 11:27:56 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=41091forumid=4#211507 Does your query select any clob or blob data? On 7/9/05, Jochem van Dieten [EMAIL PROTECTED] wrote: Ian Skinner wrote: Well we have more information on the problem. The query that was running fairly well at 30 seconds or so was being run against a validation database where the data is static. 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. That sounds rather vague. Does the DBA mean the database was running out of rollback segments and instead of just returning an error was somehow retrying the query? Jochem ~| 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:211528 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
retrieve ID from db insert
I create a new game and insert it into my Oracle database. From there I want to have the game ID and put it into a cookie. I've used NEXTVAL AND CURVAL for inserting the value into the db, but not for any external use, like my insert into a cookie. I guess I can do a CFLock and then do a query after the insert for the last inserted item, but is that the best way? Here's the insert: CFQUERY NAME=add_item DATASOURCE=esmart INSERT INTO fsnep_food_store_game_info ( gi_id,login_id, date_added,date_modified, grocery_list,budget, month,num_people, num_weeks ) VALUES ( unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#, SYSDATE,SYSDATE, cfqueryparam value=#form.g_list# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.budget# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_month# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.the_num_people# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_weeks# cfsqltype=cf_sql_varchar !--- cfcookie name=fsnep_bargain_hunt_gi_id value=#unique_food_store_game_info_s.CURVAL# --- ) /CFQUERY thanks for any help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:211529 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
search the archives, this has been discussed several times here. In short, do two queries. query 1, get the next val in your sequence. now you have your id in hand. query 2, do your insert using the id. do whatever you want with the id. DK On 7/11/05, Daniel Kessler [EMAIL PROTECTED] wrote: I create a new game and insert it into my Oracle database. From there I want to have the game ID and put it into a cookie. I've used NEXTVAL AND CURVAL for inserting the value into the db, but not for any external use, like my insert into a cookie. I guess I can do a CFLock and then do a query after the insert for the last inserted item, but is that the best way? Here's the insert: CFQUERY NAME=add_item DATASOURCE=esmart INSERT INTO fsnep_food_store_game_info ( gi_id,login_id, date_added,date_modified, grocery_list,budget, month,num_people, num_weeks ) VALUES ( unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#, SYSDATE,SYSDATE, cfqueryparam value=#form.g_list# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.budget# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_month# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.the_num_people# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_weeks# cfsqltype=cf_sql_varchar !--- cfcookie name=fsnep_bargain_hunt_gi_id value=#unique_food_store_game_info_s.CURVAL# --- ) /CFQUERY thanks for any help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu http://www.phi.umd.edu ~| 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:211530 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 Problem.
What RDBM are you using? Wouldn't this do it? -- MySQL SELECT * FROM table WHERE data1 = '5' ORDER BY DESC LIMIT 1 -- SQLServer SELECT Top 1 * FROM table WHERE data1 = '5' ORDER BY DESC - Original Message - From: James Smith [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, July 11, 2005 8:09 AM Subject: Query Problem. I have a problem I am sure is simple to solve but it has proved to be beyond me. Imagine I have the following data... StockID | Data1 | Data2 --- 1 | 1 | 2 2 | 3 | 4 3 | 5 | 6 And I want a query to return StockID | Data1 | Data2 --- 3 | 5 | 6 I am trying to use SELECT max(stockid) as stockid, data1, data2 FROM table HAVING data1 = 5 Unfortunately this is returning the following data StockID | Data1 | Data2 --- 3 | 5 | 2 Ie: the correct stockid and data1 but data2 from a diferent row! I have tried using a sub-query but it just crashes the server (trying to do WHERE StockID IN (over 7000 results from sub-query). I am using MySQL and the actual query in question is below for your ref... SELECTs.ItemID, s.ASIN, MAX(q.StockID) AS StockID, q.Condition, q.MaximumSalePrice, q.MinimumSalePrice, q.AddedToFile, q.CurrentAmazonPrice FROM stockitemdetails s JOIN stockquantities q ON (s.ItemID = q.ItemID) WHERE q.Quantity 0 AND s.ASIN != AND s.ASIN IS NOT NULL AND s.ASIN != N/A AND LEFT(s.ASIN,1) != GROUP BY s.ASIN HAVINGAddedToFile= 0 ORDER BY s.ItemID -- Jay ~| 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:211531 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: retrieve ID from db insert
In reference to the first email, you would do a CFTRANSACTION and not a CFLOCK. On 7/11/05, Douglas Knudsen [EMAIL PROTECTED] wrote: search the archives, this has been discussed several times here. In short, do two queries. query 1, get the next val in your sequence. now you have your id in hand. query 2, do your insert using the id. do whatever you want with the id. DK ~| 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:211532 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
Simple Directory Listing
I want to place a button on my form that brings up a directory listing. I am currently using the following method to merely open the directory on the end users machine: form action=\\Viahealth08\ILS\Shared\All Departments\HIM-IS\Utilization Data\Pharmacy Reports\ target=_new input type=submit value=Pharmacy Reports /FORM This works great, but the manager wants the ADDRESS BAR in the new window to be hidden, so the 'not-computer-savvy' end users cannot see the real file locations. I tried to make use of a javascript function that I found, but it does not seem to work without a http: address. I also tried a tree approach, but again, I must not be getting the syntax right for the directory. Using CF7 on Win2k3 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:211533 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-Talk: Digest every hour
Hello, 1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to insert and one to get the value of the new ID. 2) Write a stored procedure that returns the value of the inserted id (see the SQL guide for the syntax of RETURNING INTO clause) start with this: CREATE OR REPLACE PROCEDURE insert_game ( fsnep_login IN VARCHAR2, g_list IN VARCHAR2, budget IN VARCHAR2, the_monthIN VARCHAR2, the_num_people IN VARCHAR2, the_weeksIN VARCHAR2, newidOUT INT ) AS BEGIN INSERT INTO fsnep_food_store_game_info (gi_id, login_id, date_added, date_modified, grocery_list, budget, MONTH, num_people, num_weeks ) VALUES (unique_food_store_game_info_s.NEXTVAL, fsnep_login, SYSDATE, SYSDATE, g_list, budget, the_month, the_num_people, the_weeks ) RETURNING ID INTO newid; EXCEPTION WHEN OTHERS THEN ROLLBACK; RAISE; END; / call it like this: cfstoredproc procedure=insert_game datasource=[your_datasource_name] cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=fsnep_login value=#cookie.fsnep_login# null=No cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbvarname=g_list value=#form.g_list# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=budget value=#form.budget# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_month value=#form.the_month# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_num_people value=#form.the_num_people# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_weeks value=#form.the_weeks# null=No cfprocparam type=Out cfsqltype=CF_SQL_INTEGER dbvarname=newid variable=newid /cfstoredproc and then do: cfcookie name=fsnep_bargain_hunt_gi_id value=#newid# /t ps: none of the above is tested. -Original Message- Subject: retrieve ID from db insert From: Daniel Kessler [EMAIL PROTECTED] Date: Mon, 11 Jul 2005 10:47:21 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=41103forumid=4#211529 I create a new game and insert it into my Oracle database. From there I want to have the game ID and put it into a cookie. I've used NEXTVAL AND CURVAL for inserting the value into the db, but not for any external use, like my insert into a cookie. I guess I can do a CFLock and then do a query after the insert for the last inserted item, but is that the best way? Here's the insert: CFQUERY NAME=add_item DATASOURCE=esmart INSERT INTO fsnep_food_store_game_info ( gi_id,login_id, date_added,date_modified, grocery_list,budget, month,num_people, num_weeks ) VALUES ( unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#, SYSDATE,SYSDATE, cfqueryparam value=#form.g_list# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.budget# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_month# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.the_num_people# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_weeks# cfsqltype=cf_sql_varchar !--- cfcookie name=fsnep_bargain_hunt_gi_id value=#unique_food_store_game_info_s.CURVAL# --- ) /CFQUERY thanks for any help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:211534 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: retrieve ID from db insert
ok, this actually answers my question of how to assure that the 2nd query actually returns the correct id and not allow another to be inserted until I have it. That was my worry. Thanks! In reference to the first email, you would do a CFTRANSACTION and not a CFLOCK. ~| 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:211535 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
Or if you wanted to do it all in one tag you could just put it into a SP and run it that way. There are of course various views as to the added advantage of doing this, you can swearch through the list archives for all of those. :) On 7/11/05, daniel kessler [EMAIL PROTECTED] wrote: ok, this actually answers my question of how to assure that the 2nd query actually returns the correct id and not allow another to be inserted until I have it. That was my worry. Thanks! In reference to the first email, you would do a CFTRANSACTION and not a CFLOCK. ~| 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:211536 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: retrieve ID from db insert
thanks everyone for your help! search the archives, this has been discussed several times here. In short, do two queries. query 1, get the next val in your sequence. now you have your id in hand. query 2, do your insert using the id. do whatever you want with the id. ~| 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:211537 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
FW: CF-Talk: Digest every hour
first ooops: RETURNING ID INTO newid; should be RETURNING GI_ID INTO newid; (obviously) /t -Original Message- From: RADEMAKERS Tanguy Sent: Monday, July 11, 2005 5:19 PM To: 'cf-talk@houseoffusion.com' Subject: RE: CF-Talk: Digest every hour Hello, 1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to insert and one to get the value of the new ID. 2) Write a stored procedure that returns the value of the inserted id (see the SQL guide for the syntax of RETURNING INTO clause) start with this: CREATE OR REPLACE PROCEDURE insert_game ( fsnep_login IN VARCHAR2, g_list IN VARCHAR2, budget IN VARCHAR2, the_monthIN VARCHAR2, the_num_people IN VARCHAR2, the_weeksIN VARCHAR2, newidOUT INT ) AS BEGIN INSERT INTO fsnep_food_store_game_info (gi_id, login_id, date_added, date_modified, grocery_list, budget, MONTH, num_people, num_weeks ) VALUES (unique_food_store_game_info_s.NEXTVAL, fsnep_login, SYSDATE, SYSDATE, g_list, budget, the_month, the_num_people, the_weeks ) RETURNING ID INTO newid; EXCEPTION WHEN OTHERS THEN ROLLBACK; RAISE; END; / call it like this: cfstoredproc procedure=insert_game datasource=[your_datasource_name] cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=fsnep_login value=#cookie.fsnep_login# null=No cfprocparam type=In cfsqltype=CF_SQL_NUMERIC dbvarname=g_list value=#form.g_list# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=budget value=#form.budget# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_month value=#form.the_month# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_num_people value=#form.the_num_people# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=the_weeks value=#form.the_weeks# null=No cfprocparam type=Out cfsqltype=CF_SQL_INTEGER dbvarname=newid variable=newid /cfstoredproc and then do: cfcookie name=fsnep_bargain_hunt_gi_id value=#newid# /t ps: none of the above is tested. -Original Message- Subject: retrieve ID from db insert From: Daniel Kessler [EMAIL PROTECTED] Date: Mon, 11 Jul 2005 10:47:21 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=41103forumid=4#211529 I create a new game and insert it into my Oracle database. From there I want to have the game ID and put it into a cookie. I've used NEXTVAL AND CURVAL for inserting the value into the db, but not for any external use, like my insert into a cookie. I guess I can do a CFLock and then do a query after the insert for the last inserted item, but is that the best way? Here's the insert: CFQUERY NAME=add_item DATASOURCE=esmart INSERT INTO fsnep_food_store_game_info ( gi_id,login_id, date_added,date_modified, grocery_list,budget, month,num_people, num_weeks ) VALUES ( unique_food_store_game_info_s.NEXTVAL,#cookie.fsnep_login#, SYSDATE,SYSDATE, cfqueryparam value=#form.g_list# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.budget# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_month# cfsqltype=cf_sql_varchar,cfqueryparam value=#form.the_num_people# cfsqltype=cf_sql_varchar, cfqueryparam value=#form.the_weeks# cfsqltype=cf_sql_varchar !--- cfcookie name=fsnep_bargain_hunt_gi_id value=#unique_food_store_game_info_s.CURVAL# --- ) /CFQUERY thanks for any help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:211538 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: 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. Or if you wanted to do it all in one tag you could just put it into a SP and run it that way. There are of course various views as to the added advantage of doing this, you can swearch through the list archives for all of those. :) ~| 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:211539 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: Simple Directory Listing
Crude, but... form action=dirListing.cfm method=post target=_new input type=hidden name=folderURL value=\\Viahealth08\ILS\Shared\All Departments\HIM-IS\Utilization Data\Pharmacy Reports\ input type=submit value=Pharmacy Reports /form then make a dir_listing.cfm page cfparam name=folderURL default= cfhttp url=#folderURL# cfoutput#cfhttp.fileContent#/cfoutput Jerry Johnson On 7/11/05, Claremont, Timothy [EMAIL PROTECTED] wrote: I want to place a button on my form that brings up a directory listing. I am currently using the following method to merely open the directory on the end users machine: form action=\\Viahealth08\ILS\Shared\All Departments\HIM-IS\Utilization Data\Pharmacy Reports\ target=_new input type=submit value=Pharmacy Reports /FORM This works great, but the manager wants the ADDRESS BAR in the new window to be hidden, so the 'not-computer-savvy' end users cannot see the real file locations. I tried to make use of a javascript function that I found, but it does not seem to work without a http: address. I also tried a tree approach, but again, I must not be getting the syntax right for the directory. Using CF7 on Win2k3 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:211540 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
Why not just do something like this (sql server) Insert into table (cols) values (values) select @@IDENTITY as maxid -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 11:32 AM To: CF-Talk Subject: 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. Or if you wanted to do it all in one tag you could just put it into a SP and run it that way. There are of course various views as to the added advantage of doing this, you can swearch through the list archives for all of those. :) ~| 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:211541 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: retrieve ID from db insert
I have yet to see a way of doing this in Oracle/CFQUERY that works in all situations. Actually I have yet to see it work, but have heard of it working which is why I put situations On 7/11/05, Russ [EMAIL PROTECTED] wrote: Why not just do something like this (sql server) Insert into table (cols) values (values) select @@IDENTITY as maxid ~| 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:211542 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: Query Problem.
What RDBM are you using? Wouldn't this do it? -- MySQL SELECT * FROM table WHERE data1 = '5' ORDER BY DESC LIMIT 1 Unfortunately not. If you view the larger query you will get a better idea, and to explain the process... The query returns about 7500 records. AddedToFile is a flag that is set by this template from 0 (as shown in the query) to 1 (to indicate success). While this template is running other things may reset this flag to 0 to indicate a change to data, then once the program has finished it loops back to the top and performs this query again, this time it should only receive about 20-30 results (just the ones re-set). If the AddedToFile = 0 was moved from the HAVING section to the WHERE section it would change the rows that were returned. IE: if the data was such that the highest stockid had an addedtofile value of 1, using HAVING means it is left out of the result set, moving it toe the WHERE section would include the one below it instead which is not the desired result. Any other ideas? BTW: It is MySQL 4.1.11-nt -- Jay ~| 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:211543 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: Simple Directory Listing
Thanks, Jerry, I made a couple of syntax correction to your suggestion, but I get a Connection Failure on the result page. Note that if I merely copy and paste the URL into the browser it works just fine, so I know I can see the URL. Subject: Simple Directory Listing From: Jerry Johnson [EMAIL PROTECTED] Date: Mon, 11 Jul 2005 11:37:05 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =41104forumid=4#211540 Crude, but... form action=dirListing.cfm method=post target=_new input type=hidden name=folderURL value=\\Viahealth08\ILS\Shared\All Departments\HIM-IS\Utilization Data\Pharmacy Reports\ input type=submit value=Pharmacy Reports /form then make a dir_listing.cfm page cfparam name=folderURL default= cfhttp url=#folderURL# cfoutput#cfhttp.fileContent#/cfoutput Jerry Johnson ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:211544 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: Query Problem.
James Smith wrote: SELECT max(stockid) as stockid, data1, data2 FROM table HAVING data1 = 5 Unfortunately this is returning the following data StockID | Data1 | Data2 --- 3 | 5 | 2 Ie: the correct stockid and data1 but data2 from a diferent row! The MySQL manual warns against that: http://dev.mysql.com/doc/mysql/en/group-by-hidden-fields.html They also document how it should be done: http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html I have tried using a sub-query but it just crashes the server Did you file a bug? (trying to do WHERE StockID IN (over 7000 results from sub-query). SELECTs.ItemID, s.ASIN, MAX(q.StockID) AS StockID, q.Condition, q.MaximumSalePrice, q.MinimumSalePrice, q.AddedToFile, q.CurrentAmazonPrice FROM stockitemdetails s JOIN stockquantities q ON (s.ItemID = q.ItemID) WHERE q.Quantity 0 AND s.ASIN != AND s.ASIN IS NOT NULL AND s.ASIN != N/A AND LEFT(s.ASIN,1) != GROUP BY s.ASIN HAVINGAddedToFile= 0 ORDER BY s.ItemID Could you show us the query that would give the right results, but crashes your server? The result of this query is undetermined (which is why every database except MySQL will throw an error, MySQL will happily return the wrong answer) so it is a bit hard to suggest alternatives. Jochem ~| 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:211545 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
I'm not sure. As in the classic game of phone, I probably have this wrong. But as I understood the explanation, the DBA thought the query was being restarted when new data was added to the underlying tables. It seemed odd to me as well, but I'm just the web programmer. Any the plan currently is to create views of this data that are updated nightly during a slow period. Then use these views to create the summation data. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, July 09, 2005 1:44 AM To: CF-Talk Subject: Re: Poor performing Oracle Query Ian Skinner wrote: Well we have more information on the problem. The query that was running fairly well at 30 seconds or so was being run against a validation database where the data is static. 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. That sounds rather vague. Does the DBA mean the database was running out of rollback segments and instead of just returning an error was somehow retrying the query? Jochem ~| 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:211546 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: Simple Directory Listing
Right, so Im assuming the webserver does not have access to the directory and therefore you cant just use cfdirectory. Some ideas: Use frames Use javascript to popup a window with no address bar Setup a website with a home directory set to use that directory Setup a share on the server e.g. so that users cant see the real share. \\Viahealth08\Pharmacy\ -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 17:05 To: CF-Talk Subject: RE: Simple Directory Listing Thanks, Jerry, I made a couple of syntax correction to your suggestion, but I get a Connection Failure on the result page. Note that if I merely copy and paste the URL into the browser it works just fine, so I know I can see the URL. Subject: Simple Directory Listing From: Jerry Johnson [EMAIL PROTECTED] Date: Mon, 11 Jul 2005 11:37:05 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =41104forumid=4#211540 Crude, but... form action=dirListing.cfm method=post target=_new input type=hidden name=folderURL value=\\Viahealth08\ILS\Shared\All Departments\HIM-IS\Utilization Data\Pharmacy Reports\ input type=submit value=Pharmacy Reports /form then make a dir_listing.cfm page cfparam name=folderURL default= cfhttp url=#folderURL# cfoutput#cfhttp.fileContent#/cfoutput Jerry Johnson ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:211547 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
isLocked()
I've been looking through many of the classes inside the ColdFusion Java libraries trying to find something that would help me determine if the code is currently inside a scoped or named lock. Has anyone else run across anything that relates to inspecting or determining lock status? Basically, I want something like this. Please don't ask why I want this... you don't want to know. cfscript context = createObject(java, coldfusion.runtime.NeoPageContext); isLocked = context.getNamedLock(); /cfscript cfif isLocked eq cflock timeout=30 throwontimeout=Yes scope=SESSION /cfif put some code that meets a race condition here cfif isLocked eq /cflock /cfif ~| 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:211548 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
This does work properly in SQL Server, right? I mean we haven't seen any issues, but I'd hate to think that we have a bug in our code... Does the same syntax work in oracle? What kind of situations could cause this to not work properly? Russ -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 11:45 AM To: CF-Talk Subject: Re: retrieve ID from db insert I have yet to see a way of doing this in Oracle/CFQUERY that works in all situations. Actually I have yet to see it work, but have heard of it working which is why I put situations On 7/11/05, Russ [EMAIL PROTECTED] wrote: Why not just do something like this (sql server) Insert into table (cols) values (values) select @@IDENTITY as maxid ~| 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:211549 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
Like Doug suggested, I've found the best way to do this is 2 queries.. First cfquery name=foo datasource=#ds# select game_id.nextval as id from dual /cfquery Then store that value in a session variable or however you want to. Then you can use that to insert into different queries. On 7/11/05, Aaron Rouse [EMAIL PROTECTED] wrote: I have yet to see a way of doing this in Oracle/CFQUERY that works in all situations. Actually I have yet to see it work, but have heard of it working which is why I put situations On 7/11/05, Russ [EMAIL PROTECTED] wrote: Why not just do something like this (sql server) Insert into table (cols) values (values) select @@IDENTITY as maxid ~| 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:211551 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: Simple Directory Listing
My bet as well would be that the cold fusion service does not have access to those folders. If you give the user that the cf service uses the proper rights, you should be golden. You might also want to look into ldap for a longer-term solution. On 7/11/05, Claremont, Timothy [EMAIL PROTECTED] wrote: Thanks, Jerry, I made a couple of syntax correction to your suggestion, but I get a Connection Failure on the result page. ~| 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:211552 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
That syntax is invalid for Oracle. As far as SQL Server, I believe it is fine but I have watched a couple of debates on it via this mailing list so as with all things best to just research over taking someones word. :) On 7/11/05, Russ [EMAIL PROTECTED] wrote: This does work properly in SQL Server, right? I mean we haven't seen any issues, but I'd hate to think that we have a bug in our code... Does the same syntax work in oracle? What kind of situations could cause this to not work properly? Russ ~| 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:211553 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: retrieve ID from db insert
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? On 7/11/05, Eddie Awad [EMAIL PROTECTED] wrote: 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/ ~| 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:211554 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
Change AD password via LDAP/JNDI - HELP!!
Hello all-
I have spent many sleepless nights on this one and I feel like I am
getting close to the solution, but I will need some help as my Java
experience is *very* limited.
I found some Java code that resets the AD password via LDAP/SSL. The
code works successfully and the password is changed when I compile it
with javac.exe and then execute it with java.exe. However, when I run
the same code via ColdFusion, I get message that the password has been
changed, but in fact it remains unchanges.
The setpass.java file is below. Again, once compiled into .class run
from the command line using java -cp . setpass the password change
works. However, if I run the same code via ColdFusion, I get a
success message in coldfusion-out.log but the password does not
change.
Because it runs when executed via command line and doesn't seem to do
anything when called from ColdFusion, I am stumped. Can anyone please
help?
Execution code in ColdFusion,
=
cfobject action=CREATE type=JAVA name=x class=setpass
cfscript
zz = ArrayNew(1);
zz[1]=1;
zz[2]=2;
zz[3]=3;
x.main(zz);
/cfscript
setpass.java (placed in a classes path under CFMX7 tree)
import java.util.Hashtable;
import javax.naming.*;
import javax.naming.ldap.*;
import javax.naming.directory.*;
import java.io.*;
public class setpass
{
public static void main (String[] args)
{
Hashtable env = new Hashtable();
String adminName = CN=Cold Fusion AD
Manager,CN=Users,DC=subdomain,DC=domain,DC=domain;
String adminPassword = myADadminPassword;
String userName = CN=Test User To Have Password
Changes,OU=Test,DC=subdomain,DC=domain,DC=domain;
String newPassword = newPassword12345;
String keystore =
C:/CFusionMX7/runtime/jre/lib/security/cacerts;
System.setProperty(javax.net.ssl.trustStore,keystore);
env.put(Context.INITIAL_CONTEXT_FACTORY,com.sun.jndi.ldap.LdapCtxFactory);
//set security credentials, note using simple cleartext
authentication
env.put(Context.SECURITY_AUTHENTICATION,simple);
env.put(Context.SECURITY_PRINCIPAL,adminName);
env.put(Context.SECURITY_CREDENTIALS,adminPassword);
//specify use of ssl
env.put(Context.SECURITY_PROTOCOL,ssl);
//connect to my domain controller
String ldapURL = ldaps://law.georgetown.edu:636;
env.put(Context.PROVIDER_URL,ldapURL);
try {
// Create the initial directory context
LdapContext ctx = new InitialLdapContext(env,null);
//set password is a ldap modfy operation
ModificationItem[] mods = new ModificationItem[1];
//Replace the unicdodePwd attribute with a new value
//Password must be both Unicode and a quoted string
String newQuotedPassword = \ + newPassword + \;
byte[] newUnicodePassword =
newQuotedPassword.getBytes(UTF-16LE);
mods[0] = new
ModificationItem(DirContext.REPLACE_ATTRIBUTE, new
BasicAttribute(unicodePwd, newUnicodePassword));
// Perform the update
ctx.modifyAttributes(userName, mods);
System.out.println(Reset Password for: + userName);
ctx.close();
}
catch (NamingException e) {
System.out.println(Problem resetting password: + e);
}
catch (UnsupportedEncodingException e) {
System.out.println(Problem encoding password: + e);
}
}
}
~|
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:211555
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
Where is the web root stored?
There's an xml file that stores where the default web root is, right? I need to install a site-wide error handler and I'm confronted with a server admin who doesn't seem to know where that is. I know there's a way to pull it out but I haven't found it offhand. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| 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:211556 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: 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: retrieve ID from db insert
Sometimes you need to fiddle with the NOCOUNT setting to make it work reliably. It depends on how the SQL server is configured. SET NOCOUNT ON Insert into table (cols) values (values) select @@IDENTITY as maxid SET NOCOUNT OFF This is especially true if you are updating more than 1 statement inside the SQL block. -mk -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 12:07 PM To: CF-Talk Subject: Re: retrieve ID from db insert 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? On 7/11/05, Eddie Awad [EMAIL PROTECTED] wrote: 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:211558 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: isLocked()
Steve, cfscript context = createObject(java, coldfusion.runtime.NeoPageContext); isLocked = context.getNamedLock(); /cfscript cfif isLocked eq cflock timeout=30 throwontimeout=Yes scope=SESSION /cfif put some code that meets a race condition here cfif isLocked eq /cflock /cfif Even if you can figure out any locked statements, you wouldn't be able to use the syntax you had posted. You'd need to do: cfif isLocked eq cflock ... code ... /cflock cfelse ... same code ... /cfif My guess is if you dig deep enough, you could find where in memory the locks are stored, but I doubt it be worth the extra work to do whatever you're trying to do. -Dan ~| 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:211559 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
How would the NOCOUNT setting affect the @@IDENTITY being returned? Doesn't
seem like it from the sql docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
set-set_3ed0.asp
SET NOCOUNT
Stops the message indicating the number of rows affected by a Transact-SQL
statement from being returned as part of the results.
Syntax
SET NOCOUNT { ON | OFF }
Remarks
When SET NOCOUNT is ON, the count (indicating the number of rows affected by
a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the
count is returned.
The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.
SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client
for each statement in a stored procedure. When using the utilities provided
with MicrosoftR SQL ServerT to execute queries, the results prevent nn rows
affected from being displayed at the end Transact-SQL statements such as
SELECT, INSERT, UPDATE, and DELETE.
For stored procedures that contain several statements that do not return
much actual data, this can provide a significant performance boost because
network traffic is greatly reduced.
The setting of SET NOCOUNT is set at execute or run time and not at parse
time.
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 1:22 PM
To: CF-Talk
Subject: RE: retrieve ID from db insert
Sometimes you need to fiddle with the NOCOUNT setting to make it work
reliably. It depends on how the SQL server is configured.
SET NOCOUNT ON
Insert into table (cols) values (values)
select @@IDENTITY as maxid
SET NOCOUNT OFF
This is especially true if you are updating more than 1 statement inside the
SQL block.
-mk
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 12:07 PM
To: CF-Talk
Subject: Re: retrieve ID from db insert
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?
On 7/11/05, Eddie Awad [EMAIL PROTECTED] wrote:
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:211560
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: retrieve ID from db insert
and you do not need cftansaction either. once query 1 executes, you have the id in hand. if another request came in it would get a differnt id. simply based on the uniqueness of the sequence. DK On 7/11/05, Greg Morphis [EMAIL PROTECTED] wrote: Like Doug suggested, I've found the best way to do this is 2 queries.. First cfquery name=foo datasource=#ds# select game_id.nextval as id from dual /cfquery Then store that value in a session variable or however you want to. Then you can use that to insert into different queries. On 7/11/05, Aaron Rouse [EMAIL PROTECTED] wrote: I have yet to see a way of doing this in Oracle/CFQUERY that works in all situations. Actually I have yet to see it work, but have heard of it working which is why I put situations On 7/11/05, Russ [EMAIL PROTECTED] wrote: Why not just do something like this (sql server) Insert into table (cols) values (values) select @@IDENTITY as maxid ~| 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:211561 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: 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: retrieve ID from db insert
Is there a reason to want to avoid using cftransaction? On 7/11/05, Douglas Knudsen [EMAIL PROTECTED] wrote: and you do not need cftansaction either. once query 1 executes, you have the id in hand. if another request came in it would get a differnt id. simply based on the uniqueness of the sequence. DK ~| 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:211563 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
CF Scheduler - What if the server is down at the time of a scheduled event?
All: Quick question concerning the CF Scheduler... what happens if the server is down during the time when an event is scheduled to occur? Does the Scheduler just ignore the event and wait until the next recurrence or does it fire the event whenever the server is restarted? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| 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:211564 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
Another one for the RegEx-Gurus
Hi folks, i did already search the web and the archives but without any success. I'm trying to build a HTML-Email-Interface which runs on an old CF4.5. The input and some parts of the processing are running quite fine. But now I'm stuck on the img-tags, where I have to replace the relative image-URL with inline-attached images. The building of the attachments works but I've no clue how to replace (or better find) the src-attribute of the img-tags to extract and replace them with the proper inline reference. Hope that some of you can help me out with that one. Cheers, Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| 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:211565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Scheduler - What if the server is down at the time of a scheduled event?
The scheduled event would be missed entirely. -Mike Chabot On 7/11/05, Mosh Teitelbaum [EMAIL PROTECTED] wrote: All: Quick question concerning the CF Scheduler... what happens if the server is down during the time when an event is scheduled to occur? Does the Scheduler just ignore the event and wait until the next recurrence or does it fire the event whenever the server is restarted? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| 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:211566 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: Another one for the RegEx-Gurus
Finding the img tags should be easy. Replacing them with inline tags is, unfortunately, something I'm not familiar with. To find an img tag, you would look for something like this: img [^]*src=[^]+[^]* Hopefully, someone can help with the other half (9/10ths?) of the problem. --Ben Patric Stumpe wrote: Hi folks, i did already search the web and the archives but without any success. I'm trying to build a HTML-Email-Interface which runs on an old CF4.5. The input and some parts of the processing are running quite fine. But now I'm stuck on the img-tags, where I have to replace the relative image-URL with inline-attached images. The building of the attachments works but I've no clue how to replace (or better find) the src-attribute of the img-tags to extract and replace them with the proper inline reference. Hope that some of you can help me out with that one. Cheers, Patric ~| 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:211567 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: Where is the web root stored?
The location of the default web root depends on how you're set up. For instance, on Jboss, it's located in the file WEB-INF/jboss-web.xml. If you're running Jrun, it's in WEB-INF/jrun-web.xml. However, the error handlers are located in the WEB-INF/web.xml file. You need to add an error-page attribute after all of your servlet mappings. Here's an example error-page error-code403;14/error-code location/index.cfm?site=lost/location /error-page -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 1:15 PM To: CF-Talk Subject: Where is the web root stored? There's an xml file that stores where the default web root is, right? I need to install a site-wide error handler and I'm confronted with a server admin who doesn't seem to know where that is. I know there's a way to pull it out but I haven't found it offhand. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| 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:211568 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
Data Binding Question
I have a text box for client number and a drop down box for client name. Using data binding, when you choose a client name from the drop down box, the client number is populated. How can I make the drop down box move to the appropriate name when a clientnum is entered in the text box? To summarize, If you enter or select a value in one control, I want the other control to automatically update. It works in one direction, but not the other. TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:211569 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: Another one for the RegEx-Gurus
Hi Ben, thanks for the quick reply. Am I right that I could embrace the different parts of that regex for simple back-reference? I have to grab the complete URL of the src-attribute (need to work with that a bit) and replace it with a known string: e.g.: img src=/path/to/image.gif height=25 width=20 would lead to: img src=cid:inlineImage01; height=25 width=20 So something like that could work? (img [^]*src=)([^]+)([^]*) = \1cid:inlineImage01\3 Patric Finding the img tags should be easy. Replacing them with inline tags is, unfortunately, something I'm not familiar with. To find an img tag, you would look for something like this: img [^]*src=[^]+[^]* Hopefully, someone can help with the other half (9/10ths?) of the problem. --Ben -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| 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:211570 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: Another one for the RegEx-Gurus
FYI - Even if you replace the source with a CID you still need to encode the image into the email using that same CID as a reference. Regards, Howie --- On Monday, July 11, 2005 2:41 PM, Patric Stumpe scribed: --- Hi Ben, thanks for the quick reply. Am I right that I could embrace the different parts of that regex for simple back-reference? I have to grab the complete URL of the src-attribute (need to work with that a bit) and replace it with a known string: e.g.: img src=/path/to/image.gif height=25 width=20 would lead to: img src=cid:inlineImage01; height=25 width=20 So something like that could work? (img [^]*src=)([^]+)([^]*) = \1cid:inlineImage01\3 Patric ~| 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:211571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Scheduler - What if the server is down at the time of a scheduled event?
Thanks Mike. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ Mike Chabot wrote: The scheduled event would be missed entirely. Mosh Teitelbaum wrote: Quick question concerning the CF Scheduler... what happens if the server is down during the time when an event is scheduled to occur? Does the Scheduler just ignore the event and wait until the next recurrence or does it fire the event whenever the server is restarted? ~| 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:211572 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: Another one for the RegEx-Gurus
Hi Howie, I did already solve that part. Manually geneerated messages are properly sent. So now I (hopefully) only need to concentrate on that replacment for the WYSIWYG-submitted mailbody. Greets Patric FYI - Even if you replace the source with a CID you still need to encode the image into the email using that same CID as a reference. Regards, Howie -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| 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:211573 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: Another one for the RegEx-Gurus
More or less. I would probably skip the backreferences and rewrite the img tag from scratch, or specify which attributes I want to keep. But if you want to keep all additional attributes (style, alt, title, etc.) then you're right -- that'd be how to go about it. --Ben Patric Stumpe wrote: Hi Ben, thanks for the quick reply. Am I right that I could embrace the different parts of that regex for simple back-reference? I have to grab the complete URL of the src-attribute (need to work with that a bit) and replace it with a known string: e.g.: img src=/path/to/image.gif height=25 width=20 would lead to: img src=cid:inlineImage01; height=25 width=20 So something like that could work? (img [^]*src=)([^]+)([^]*) = \1cid:inlineImage01\3 Patric Finding the img tags should be easy. Replacing them with inline tags is, unfortunately, something I'm not familiar with. To find an img tag, you would look for something like this: img [^]*src=[^]+[^]* Hopefully, someone can help with the other half (9/10ths?) of the problem. --Ben ~| 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:211574 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
Query to text file.
What is the best way to dump a HUGE query to a text file. There used to be a CFX tag long ago called CFX_dumptext that did this. This doesn't work on MX6.1. I have rolled my own with little success on extremely large queries. Each works below on small queries just fine. In no particular order: I've written each line to a text file each loop through the query. I've written chunks of the query at a time. I've written one large variable using cfsavecontent. My problem is even with a JVM heap size of 1024 and my JVM arguments to -XX:MaxPermSize=256m I still get the java.lang.OutOfMemoryError on the write. Anyone have an enlightenment? Thanks, Jeff ~| 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:211575 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
how to.... Java Exception passed to CF struct
i've working on some CFX tags and could be if i can pass the Java Exception captured by try catch statement to CF using query or structs or something , but dont know how do it cause Exception getStackTrace() method return Throwable and i cant see that in CF only in console... but cant run this class in console cause implements CustomTag Any ideas?... ~| 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:211576 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
how to.... Java Exception passed to CF struct
i've working on some CFX tags and could be if i can pass the Java Exception captured by try catch statement to CF using query or structs or something , but dont know how do it cause Exception getStackTrace() method return Throwable and i cant see that in CF only in console... but cant run this class in console cause implements CustomTag Coldfusion version : 5 Any ideas?... ~| 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:211577 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 to text file.
Did you tried to pass the Query Object to CFX using request and then loop over the query using the Query object.. (both from com.allaire.cfx) -Mensaje original- De: Jeff Waris [mailto:[EMAIL PROTECTED] Enviado el: Monday, July 11, 2005 3:18 PM Para: CF-Talk Asunto: Query to text file. What is the best way to dump a HUGE query to a text file. There used to be a CFX tag long ago called CFX_dumptext that did this. This doesn't work on MX6.1. I have rolled my own with little success on extremely large queries. Each works below on small queries just fine. In no particular order: I've written each line to a text file each loop through the query. I've written chunks of the query at a time. I've written one large variable using cfsavecontent. My problem is even with a JVM heap size of 1024 and my JVM arguments to -XX:MaxPermSize=256m I still get the java.lang.OutOfMemoryError on the write. Anyone have an enlightenment? Thanks, Jeff ~| 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:211578 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: Another one for the RegEx-Gurus
Thanks Ben, it really seems to work. Now I have to crawl the source html backwards and have a look at what happens :) Thanks a lot! Patric More or less. I would probably skip the backreferences and rewrite the img tag from scratch, or specify which attributes I want to keep. But if you want to keep all additional attributes (style, alt, title, etc.) then you're right -- that'd be how to go about it. --Ben Patric Stumpe wrote: Hi Ben, thanks for the quick reply. Am I right that I could embrace the different parts of that regex for simple back-reference? I have to grab the complete URL of the src-attribute (need to work with that a bit) and replace it with a known string: e.g.: img src=/path/to/image.gif height=25 width=20 would lead to: img src=cid:inlineImage01; height=25 width=20 So something like that could work? (img [^]*src=)([^]+)([^]*) = \1cid:inlineImage01\3 Patric Finding the img tags should be easy. Replacing them with inline tags is, unfortunately, something I'm not familiar with. To find an img tag, you would look for something like this: img [^]*src=[^]+[^]* Hopefully, someone can help with the other half (9/10ths?) of the problem. --Ben ~| 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:211579 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: Query to text file.
What is the best way to dump a HUGE query to a text file. the db itself? ~| 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:211580 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 see no reason to use it in Daniels case. once you get the next value from a sequence in Oracle, no other request will get that id. Now, if Daniel needed to perform several inserts, updates, etc in one request based on this id, then yes, by all means use cftransaction. In his case he had only one. note a rollback does not effect sequences. DK On 7/11/05, Aaron Rouse [EMAIL PROTECTED] wrote: Is there a reason to want to avoid using cftransaction? On 7/11/05, Douglas Knudsen [EMAIL PROTECTED] wrote: and you do not need cftansaction either. once query 1 executes, you have the id in hand. if another request came in it would get a differnt id. simply based on the uniqueness of the sequence. DK ~| 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:211581 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 to text file.
I am running SQL7. I have actually thought about using DTS to a text file but I would run into other issues that I don't want to tackle for this project. DTS also seems like trying to kill a fly with a sledgehammer. So I was hoping a more simple solution could be found for a plain text file dump. Jeff -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 4:20 PM To: CF-Talk Subject: Re: Query to text file. What is the best way to dump a HUGE query to a text file. the db itself? ~| 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:211582 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: Change AD password via LDAP/JNDI - HELP!!
The first thing that comes to mind is permissions. When you run it
from the command line, what account are you using? Does this account
have permissions to change the password?
Then, what about ColdFusion? Are you running the CF service(s) with an
account that has permission to change the password?
What platform and what LDAP server are you using?
M!ke
-Original Message-
From: Dimo Michailov [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 12:12 PM
To: CF-Talk
Subject: Change AD password via LDAP/JNDI - HELP!!
Hello all-
I have spent many sleepless nights on this one and I feel like I am
getting close to the solution, but I will need some help as my Java
experience is *very* limited.
I found some Java code that resets the AD password via LDAP/SSL. The
code works successfully and the password is changed when I compile it
with javac.exe and then execute it with java.exe. However, when I run
the same code via ColdFusion, I get message that the password has been
changed, but in fact it remains unchanges.
The setpass.java file is below. Again, once compiled into .class run
from the command line using java -cp . setpass the password change
works. However, if I run the same code via ColdFusion, I get a success
message in coldfusion-out.log but the password does not change.
Because it runs when executed via command line and doesn't seem to do
anything when called from ColdFusion, I am stumped. Can anyone please
help?
Execution code in ColdFusion,
=
cfobject action=CREATE type=JAVA name=x class=setpass
cfscript
zz = ArrayNew(1);
zz[1]=1;
zz[2]=2;
zz[3]=3;
x.main(zz);
/cfscript
setpass.java (placed in a classes path under CFMX7 tree)
import java.util.Hashtable;
import javax.naming.*;
import javax.naming.ldap.*;
import javax.naming.directory.*;
import java.io.*;
public class setpass
{
public static void main (String[] args)
{
Hashtable env = new Hashtable();
String adminName = CN=Cold Fusion AD
Manager,CN=Users,DC=subdomain,DC=domain,DC=domain;
String adminPassword = myADadminPassword;
String userName = CN=Test User To Have Password
Changes,OU=Test,DC=subdomain,DC=domain,DC=domain;
String newPassword = newPassword12345;
String keystore =
C:/CFusionMX7/runtime/jre/lib/security/cacerts;
System.setProperty(javax.net.ssl.trustStore,keystore);
env.put(Context.INITIAL_CONTEXT_FACTORY,com.sun.jndi.ldap.LdapCtxFactor
y);
//set security credentials, note using simple cleartext
authentication
env.put(Context.SECURITY_AUTHENTICATION,simple);
env.put(Context.SECURITY_PRINCIPAL,adminName);
env.put(Context.SECURITY_CREDENTIALS,adminPassword);
//specify use of ssl
env.put(Context.SECURITY_PROTOCOL,ssl);
//connect to my domain controller
String ldapURL = ldaps://law.georgetown.edu:636;
env.put(Context.PROVIDER_URL,ldapURL);
try {
// Create the initial directory context
LdapContext ctx = new
InitialLdapContext(env,null);
//set password is a ldap modfy operation
ModificationItem[] mods = new
ModificationItem[1];
//Replace the unicdodePwd attribute with a new
value
//Password must be both Unicode and a quoted
string
String newQuotedPassword = \ + newPassword +
\;
byte[] newUnicodePassword =
newQuotedPassword.getBytes(UTF-16LE);
mods[0] = new
ModificationItem(DirContext.REPLACE_ATTRIBUTE, new
BasicAttribute(unicodePwd, newUnicodePassword));
// Perform the update
ctx.modifyAttributes(userName, mods);
System.out.println(Reset Password for: +
userName);
ctx.close();
}
catch (NamingException e) {
System.out.println(Problem resetting password:
+ e);
}
catch (UnsupportedEncodingException e) {
System.out.println(Problem encoding password:
+ e);
}
}
}
~|
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.
Re: retrieve ID from db insert
How many times would it really matter if it did? I have seen sometimes where a new app would start off at say ID value of 143 just because of all the testing and not resetting the sequence never seemed to be an issue though. Guess I just look at it differently, because the way I look at it is if the CFTRANSACTION is not going to hurt anything to be used then why the heck not use it around even something so simple as the basic insert vs lots of inserts/updates. Seems like the only difference is one way saves you from typing the opening/closing transaction tags. But if less typing were the goal then I'd say the SP would lead to the least amount of typing, at least within the CFM files. On 7/11/05, Douglas Knudsen [EMAIL PROTECTED] wrote: note a rollback does not effect sequences. DK ~| 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:211584 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: Query to text file.
Jeff Waris wrote: project. DTS also seems like trying to kill a fly with a sledgehammer. So I was hoping a more simple solution could be found for a plain text file dump. considering your fly is choking your server to death, i think you're looking at this the wrong way. ~| 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:211585 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 to text file.
Speaking of DTS, the DTS on the new SQL 2005 looks pretty cool. The sledgehammer beta is out. Lee Surma On Mon, 11 Jul 2005 16:16:37 -0400 Jeff Waris [EMAIL PROTECTED] wrote: I am running SQL7. I have actually thought about using DTS to a text file but I would run into other issues that I don't want to tackle for this project. DTS also seems like trying to kill a fly with a sledgehammer. So I was hoping a more simple solution could be found for a plain text file dump. Jeff -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 4:20 PM To: CF-Talk Subject: Re: Query to text file. What is the best way to dump a HUGE query to a text file. the db itself? ~| 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:211586 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: Another one for the RegEx-Gurus
No worries. Glad to be of service. If you want more help with RegEx, I suggest subscribing to the HoF regex list. It's very low-traffic, but if you post a question, it WILL get answered. Sometimes in more detail than you actually needed! And everyone on it is happy to help you learn. --Ben Patric Stumpe wrote: Thanks Ben, it really seems to work. Now I have to crawl the source html backwards and have a look at what happens :) Thanks a lot! ~| 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:211587 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: Query to text file.
Good point... Jeff -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 4:44 PM To: CF-Talk Subject: Re: Query to text file. Jeff Waris wrote: project. DTS also seems like trying to kill a fly with a sledgehammer. So I was hoping a more simple solution could be found for a plain text file dump. considering your fly is choking your server to death, i think you're looking at this the wrong way. ~| 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:211588 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
Well that's not the only reason to avoid cftransaction where it's not needed... You can't nest cftransactions, so if for some (who knows) reason you found yourself needing to cfinclude two separate templates within a cftransaction (or different method calls or whatever) you'd get an error if the included template (or method call) has its own cftransaction. Most of the time it's not an issue, and usually when it does it's not a large issue, but it's something to consider. How many times would it really matter if it did? I have seen sometimes where a new app would start off at say ID value of 143 just because of all the testing and not resetting the sequence never seemed to be an issue though. Guess I just look at it differently, because the way I look at it is if the CFTRANSACTION is not going to hurt anything to be used then why the heck not use it around even something so simple as the basic insert vs lots of inserts/updates. Seems like the only difference is one way saves you from typing the opening/closing transaction tags. But if less typing were the goal then I'd say the SP would lead to the least amount of typing, at least within the CFM files. On 7/11/05, Douglas Knudsen [EMAIL PROTECTED] wrote: note a rollback does not effect sequences. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:211589 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: Data Binding Question
If you are trying to select a value in your dropdown based on the
input box vsomething like this should do the trick:
funtion correctSelect(inputBoxValue,selectBoxObject)
{
var i=0;
for(i;iselectBoxObject.length;i++)
{
if(inputBox.value == selectBoxObject.options[i].value
selectBoxObject.selectedIndex = i;
}
}
Adam H
On 7/11/05, Claremont, Timothy [EMAIL PROTECTED] wrote:
I have a text box for client number and a drop down box for client name.
Using data binding, when you choose a client name from the drop down
box, the client number is populated.
How can I make the drop down box move to the appropriate name when a
clientnum is entered in the text box?
To summarize, If you enter or select a value in one control, I want the
other control to automatically update. It works in one direction, but
not the other.
TIA,
Tim
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from
your system.
This footnote also confirms that this email message has been swept for
the presence of computer viruses.
Thank You,
Viahealth
**
~|
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:211590
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: Change AD password via LDAP/JNDI - HELP!!
The first thing that comes to mind is permissions. When you run it from the command line, what account are you using? Does this account have permissions to change the password? Then, what about ColdFusion? Are you running the CF service(s) with an account that has permission to change the password? As a followup to these excellent suggestions, you might see if you can run your Java class from CF via CFEXECUTE. This might help you diagnose whether it's a permissions issue or something else. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:211591 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: Where is the web root stored?
Thanks. We wound up finding an admin with more permissions than the one I am working with and he squared us away. I didn't have access to the xml files, either. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| 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:211592 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
Java class called from CF errors
I have a Java class that runs fine as an application with main(), but
when I call it form CF it errors, I made sure the right constructor is
called - I just cannot figure out what the difference is and why it
errors.
The error is:
There was an error reading the Input Stream. The error is Connection has
been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found
Any help is greatly appreciated.
/* Author: Taco Fleur ([EMAIL PROTECTED]) */
package edge;
import java.io.*;
import java.net.UnknownHostException;
import java.security.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import javax.net.ssl.*;
public class CFSSLTransportLayer
{
final String host = edge.asic.gov.au;
final int port = 5608;
private static SSLSocket sslServerSocket;
static boolean debug = true;
final String keyStoreLocation =C:\\Documents and
Settings\\Administrator\\.keystore;
final String password = x;
final int socketTimeout = 6; // Set timeout to one
minute as per specs.
SSLSocketFactory factory;
PrintWriter pw;
BufferedReader in = null;
String error = ;
public CFSSLTransportLayer()
{
try
{
KeyStore myKeyStore =
KeyStore.getInstance( JKS );
myKeyStore.load( new
FileInputStream( keyStoreLocation ), password.toCharArray() );
TrustManagerFactory myTrustFactory =
TrustManagerFactory.getInstance( SunX509, SunJSSE );
myTrustFactory.init( myKeyStore );
TrustManager[] myTrustManager =
myTrustFactory.getTrustManagers();
SSLContext ctx =
SSLContext.getInstance( SSL );
ctx.init( null, myTrustManager, null
);
factory = ctx.getSocketFactory();
}
catch ( Exception e )
{
String myError = Error creating SSL
objects.;
System.err.println( myError );
setError( myError );
e.printStackTrace( System.out );
}
try
{
sslServerSocket = ( SSLSocket )
factory.createSocket( host, port );
// Set the timeout
sslServerSocket.setSoTimeout(
socketTimeout );
if ( debug )
{
System.out.println(
* );
System.out.println(
***Secure socket made );
System.out.println(
* );
System.out.println();
}
pw = new PrintWriter(
sslServerSocket.getOutputStream() );
}
catch ( UnknownHostException e )
{
String myError = Unknown host.;
System.err.println( myError );
setError( myError );
}
catch ( java.net.SocketTimeoutException e )
{
String myError = The Socket waited
+ socketTimeout / 1000 + seconds for a response.;
System.err.println( myError );
setError( myError );
}
catch ( IOException e )
{
String myError = I/O Exception.;
System.err.println( myError );
setError( myError );
}
catch ( Exception e )
{
String myError = An exception has occurred, error message:
+ e.getMessage();
System.err.println( myError );
setError( myError );
}
}
private void setError( String error )
{
this.error = this.error + error + \n;
}
private String getError()
{
return this.error;
}
Re: retrieve ID from db insert
On 7/11/05, Aaron Rouse [EMAIL PROTECTED] wrote: How many times would it really matter if it did? I have seen sometimes where a new app would start off at say ID value of 143 just because of all the testing and not resetting the sequence never seemed to be an issue though. I suppose if the seq value has some real meaning, yo umight need to fuss around with a way to ensure things are 'in sequence' so to speak. Typically I could care less, the sequence is usually a PK and has no real meaning to the end user/gui. IIRC, there is no guarantee a numerical sequence in Oracle is always one apart. You could get 1,2,3,4,10,11,20. That is what I've been told at least. Guess I just look at it differently, because the way I look at it is if the CFTRANSACTION is not going to hurt anything to be used then why the heck not use it around even something so simple as the basic insert vs lots of inserts/updates. Seems like the only difference is one way saves you from typing the opening/closing transaction tags. But if less typing were the goal then I'd say the SP would lead to the least amount of typing, at least within the CFM files. If your SQL has only one insert, why use a transaction? Vacuously its considered a transaction I suppose. Further, if a single SQL fails in CF, a commit is never issued for it. I have always understood transactions to be a group of SQL statements that you want to execute in concert. On 7/11/05, Douglas Knudsen [EMAIL PROTECTED] wrote: note a rollback does not effect sequences. DK ~| 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:211594 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, Douglas Knudsen [EMAIL PROTECTED] wrote: On 7/11/05, Aaron Rouse [EMAIL PROTECTED] wrote: How many times would it really matter if it did? I have seen sometimes where a new app would start off at say ID value of 143 just because of all the testing and not resetting the sequence never seemed to be an issue though. I suppose if the seq value has some real meaning, yo umight need to fuss around with a way to ensure things are 'in sequence' so to speak. Typically I could care less, the sequence is usually a PK and has no real meaning to the end user/gui. IIRC, there is no guarantee a numerical sequence in Oracle is always one apart. You could get 1,2,3,4,10,11,20. That is what I've been told at least. When I have noticed this happening it usually ended up the trigger was setup with some caching. That is not to say it may or does happen in other situations. I too could really care less what the ID value is, not sure how many people out there really would care since never ran into a customer who did but I am sure there are many out there that do. If your SQL has only one insert, why use a transaction? Vacuously its considered a transaction I suppose. Further, if a single SQL fails in CF, a commit is never issued for it. I have always understood transactions to be a group of SQL statements that you want to execute in concert. I was referring to a single insert statement followed by a single select statement to grad the ID of that inserted record, not just one insert and nothing more. ~| 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:211595 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
query sum or group by
I am trying to SUM a column in oracle. The query works fine until I add the SUM. It seems from the error, that I then have to have a GROUP BY. I guess I don't understand how to use the GROUP BY in this instance or choose which column to GROUP BY. I have googled around. 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 If I use all the columns listed in the SELECT, then I don't receive an error but it doesn't seem to be the type of SUM that I'm expecting. For 15 records listing their price I receive: 0.60 0.60 0.60 0.69 0.69 0.89 0.99 1.39 1.39 1.39 1.39 0.79 0.79 0.79 0.79 total price:0.60 ~| 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:211596 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
Newbie Question
Greetings, I am new to ColdFusion and just started to learn. Before I get set in my ways, I have read many posts about things like Fuse Builder and other module building blocks for creating applications. My question is which one would be the easiest to learn and is it a good practice to use one or would creating my own components and such would be just as good? Thanks, Kevin -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.12/46 - Release Date: 7/11/2005 ~| 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:211598 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
FW: CF-Talk: Digest every hour
I see, thanks. first ooops: RETURNING ID INTO newid; should be RETURNING GI_ID INTO newid; (obviously) /t ~| 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:211597 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: Newbie Question
Here's what I'd suggest... 1) Learn how to use CFCs properly. Place your business logic in CFCs and then build your display pages to call your CFCs. 2) Next learn how to write custom tags with start and end tags like this: container:box ...content... /container:box And use them to build layout elements such as boxes and columns (this might not be very useful depending what you are doing). The trick to this is understanding thisTag.executionMode and thisTag.generatedContent. 3) Run your entire site through one file (index.cfm) with a parameter passed in the URL that controls what happens. Place a big cfswitch in this file. That may be all the framework you need. If not, it's a good point to begin at. -Original Message- From: Kevin Rosenthal [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 July 2005 1:14 p.m. To: CF-Talk Subject: Newbie Question Greetings, I am new to ColdFusion and just started to learn. Before I get set in my ways, I have read many posts about things like Fuse Builder and other module building blocks for creating applications. My question is which one would be the easiest to learn and is it a good practice to use one or would creating my own components and such would be just as good? Thanks, Kevin -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.12/46 - Release Date: 7/11/2005 ~| 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:211599 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
cfbreak in cfswitch in CFMX 7?
Hi, CFbreak doesn't seem to work in cfswitch in CF 7 any more. What tag do you use to break out of cfswitch now? Johnny ~| 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:211601 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: cfbreak in cfswitch in CFMX 7?
Do you mean to stop each successive cfcase from executing? You don't need to do that in cfswitch, only in the cfscript switch(). -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Tuesday, 12 July 2005 2:12 p.m. To: CF-Talk Subject: cfbreak in cfswitch in CFMX 7? Hi, CFbreak doesn't seem to work in cfswitch in CF 7 any more. What tag do you use to break out of cfswitch now? Johnny ~| 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:211602 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: cfbreak in cfswitch in CFMX 7?
No, he means to abort the current case, without having to put the
remainder inside a conditional.
switch (myval) {
case one:
...
if (condition) break;
...
break;
case two:
...
}
cfswitch expression=#myval#
cfcase value=one
...
cfif condition
cfbreak /
/cfif
...
/cfcase
/cfswitch
cheers,
barneyb
On 7/11/05, Matthew Walker [EMAIL PROTECTED] wrote:
Do you mean to stop each successive cfcase from executing? You don't need to
do that in cfswitch, only in the cfscript switch().
-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 12 July 2005 2:12 p.m.
To: CF-Talk
Subject: cfbreak in cfswitch in CFMX 7?
Hi,
CFbreak doesn't seem to work in cfswitch in CF 7 any more. What tag do you
use to break out of cfswitch now?
Johnny
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 50 invites.
~|
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:211603
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: cfbreak in cfswitch in CFMX 7?
On 7/11/05, Johnny Le [EMAIL PROTECTED] wrote: CFbreak doesn't seem to work in cfswitch in CF 7 any more. Correct. Allowing it was a bug in CFMX 6.x. If you tried it in CF5, it was illegal. What tag do you use to break out of cfswitch now? You don't need a tag. cfcase ends at the /cfcase tag. I blogged about this - because it bit the Macromedia Web Team when we upgraded to CFMX 7... -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:211604 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
