Re: Text searching in Oracle
On Saturday 15 Mar 2003 19:33 pm, Matt Robertson wrote: Can this be done with CF and one of the other long types, assuming CF 4.5? MX? Maybe you need to redefine the problem. Why are you trying to do a 'like' on a number ? I ask because http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements2a.htm#45887 says LONG columns cannot appear in WHERE clauses -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Text searching in Oracle
CF_SQL_LONGVARCHAR has nothing to do with the numeric type long. It is used to describe text fields with a very large number of characters. As he is using Oracle, it will probably be a field of type CLOB (or maybe LONG and then he should switch to CLOB). -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: maandag 17 maart 2003 11:50 To: CF-Talk Subject: Re: Text searching in Oracle On Saturday 15 Mar 2003 19:33 pm, Matt Robertson wrote: Can this be done with CF and one of the other long types, assuming CF 4.5? MX? Maybe you need to redefine the problem. Why are you trying to do a 'like' on a number ? I ask because http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server .920/a96540/sql_elements2a.htm#45887 says LONG columns cannot appear in WHERE clauses -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IE for PPC
Hello At the beggining of my application I want to make a check if user is coming from Hand Held device (Palm top etc with pocket pc) then CFLocation. What is best way to check if user is using pocket pc? Using CGI variable i am getting following string from my handheld device. cfoutput#cgi.HTTP_USER_AGENT#/cfoutput=Mozilla/2.0 (compatible; MSIE 3.02; Windows CE; PPC; 240*320) I can compare this string but in future we will have different devices then i've to change the code and put another IF. Is it only option i've got? Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IE for PPC
wont a list check for PPC do it? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 11:24 To: CF-Talk Subject: IE for PPC Hello At the beggining of my application I want to make a check if user is coming from Hand Held device (Palm top etc with pocket pc) then CFLocation. What is best way to check if user is using pocket pc? Using CGI variable i am getting following string from my handheld device. cfoutput#cgi.HTTP_USER_AGENT#/cfoutput=Mozilla/2.0 (compatible; MSIE 3.02; Windows CE; PPC; 240*320) I can compare this string but in future we will have different devices then i've to change the code and put another IF. Is it only option i've got? Thanks Shahzad Butt (Development Engineer) JJ FastFood Distribution Ltd. Office: +44 (0) 1992 701 722 Mobile: +44 (0) 7803 584 873 Fax: +44 (0) 1992 701 604 7 Solar Way, Innova Park, Enfield, London, EN3 7XY ![EMAIL PROTECTED]@APOLLO! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IE for PPC
Quoting Shahzad.Butt [EMAIL PROTECTED]: I can compare this string but in future we will have different devices then i've to change the code and put another IF. Is it only option i've got? It depends on *why* you want to know if the device is a handheld. If it is just for reasons of output formatting, using the media attribute of your stylesheets may be much easier. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Using createUUID()
Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Text searching in Oracle
I ran into this with some short news type items that were displayed on our web site with FileMaker/Lasso. FileMaker, Access, 4D and some other smaller db's have text or memo fields that hold 32k or more. The similar data type in Oracle 8 is varchar2(4000). So I put the body of the news record in a related child table. Items greater than 4k get spread across multiple records and I overlap what is saved by 100 characters so that if someone is searching text, phrases won't get cut up. Everything gets pasted back together for display. It's very fast. But we don't have a lot of news records and for many, the text is less than 4k. Duncan Hays http://www.peacecorps.gov/news/index.cfm -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 1:34 PM To: CF-Talk Subject: Text searching in Oracle I have this code, that works great in Access and mySQL (see below). I can't seem to get this to work in Oracle no matter what I do. It doesn't like me searching on the PageText (type=long) field. Error is [Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes: expected NUMBER got LONG I'm stuck with the long field type, and I can't use anything but a simple query. How can I search on a long text field in Oracle? cfquery datasource=#request.SiteDSN# name=Show SELECT filename.ID, filemane.Title FROM filename WHERE ( filename.Title LIKE cfqueryparam cfsqltype=CF_SQL_VARCHAR value=%#form.SearchText#% OR filename.PageText LIKE cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=%#form.SearchText#% ) /cfquery Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Matrix problem
I'm not very experienced at this, but I need to create a report that creates a matrix (the number of times where, say, column f intersects the row 5). I see how I can work the query (a kind of Where F AND 5 statement--other approaches appreciated). But I'm at a loss about how to output it so that it counts the total number instead of lists each incident. Is it done in the query or in the output? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
But that would not make it unique I would not think. However if you have a DB, simply have a table and increment the field by one each time you need a unique ID. Field 1: ID (Autonumber) (seed 1000) Field 2: Prefix (text) example CT Then use #Prefix#-#Numberformat(ID,00)# Something like that anyway [EMAIL PROTECTED] 03/17/03 08:18AM if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
ran this, and got those, not too unique using the first four...maybe he could mid() some part of it, towards the end of a uuid, that looks to be unique... cfloop from=1 to=10 index=i cfoutput #createUUID()# BR /cfoutput /cfloop FC3323FA-B0D0-3EE0-80B37FBF22E75C14 FC332409-B0D0-3EE0-80B85DDA31714729 FC332419-B0D0-3EE0-80FFB7B79097DECF FC332429-B0D0-3EE0-80D1687860F7CD14 FC332438-B0D0-3EE0-8057B4F140B6DC85 FC332448-B0D0-3EE0-803695377137647C FC332458-B0D0-3EE0-80CAD77B2CBF4BC6 FC332467-B0D0-3EE0-80051B3A5F91255B FC332477-B0D0-3EE0-801B9143334C9271 FC332486-B0D0-3EE0-804ACCD036880B5A ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
have done/been doing for weeks now with no probs :-) -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
The point of a UUID is not to use the first four characters, but to use the whole ID Jason Lees Development Team Leader National Express Systems. -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can someone walk me thru changing my ALT-3 shortcut?
OK, I've tried following those same steps, and the shortcuts just don't take. So far I've: 1. Created a copy 2. Navigated to the Surround With Comment option 3. Typed CTRL+3 4. Clicked Changed 5. Confirmed the override 6. Clicked OK twice 7. Restarted DWMX Nothing. To compound the issue, all of of options within the Tabs on the insert Panel are grayed out and unusable. Any ideas on what's going on? I'm using DWMX 6.1. Regards, Dave. That's so weird. Those steps worked *perfectly* for me, and I'm on DWMX 6.1 too. I can type anything and select it, and hit ctrl-3 and it's all surrounded by poundsigns... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... Just generate enough and you will get duplicates. But the problem is more with the following: In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. Apart from using Left() instead of Mid() :-), just because the UUID is unique does not mean the first 4 characters are unique. With 4 ASCII characters you can have only 4 billion different combinations anyway, and with 4 HEX characters only 65536 different combinations. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
yep, that would do it, -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:38 To: CF-Talk Subject: RE: Using createUUID() ran this, and got those, not too unique using the first four...maybe he could mid() some part of it, towards the end of a uuid, that looks to be unique... cfloop from=1 to=10 index=i cfoutput #createUUID()# BR /cfoutput /cfloop FC3323FA-B0D0-3EE0-80B37FBF22E75C14 FC332409-B0D0-3EE0-80B85DDA31714729 FC332419-B0D0-3EE0-80FFB7B79097DECF FC332429-B0D0-3EE0-80D1687860F7CD14 FC332438-B0D0-3EE0-8057B4F140B6DC85 FC332448-B0D0-3EE0-803695377137647C FC332458-B0D0-3EE0-80CAD77B2CBF4BC6 FC332467-B0D0-3EE0-80051B3A5F91255B FC332477-B0D0-3EE0-801B9143334C9271 FC332486-B0D0-3EE0-804ACCD036880B5A ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
I dont think that is the point per say, but I do see the point of potential conflicts -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:41 To: CF-Talk Subject: RE: Using createUUID() The point of a UUID is not to use the first four characters, but to use the whole ID Jason Lees Development Team Leader National Express Systems. -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
yep, as noted in another post, if it fits your development, then you can still use it; back on track : does and will mySQL support newid() -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one machine Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
MySQL has an AUTO_INCREMENT column type (well it used to). It depends what scope of uniqueness you need for the ID - if unique at the table level is sufficient then this will do, though it does tie your code down to MySQL. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() yep, as noted in another post, if it fits your development, then you can still use it; back on track : does and will mySQL support newid() -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
big database (need to modify columns)
hey all, has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? everytime I try it times the F**K out. and its driving me crazy thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Heres a URL on how the UUID is defined http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. there are 3.4028236692093846346337460743177e+38 combinations (2^128). Jason Lees Development Team Leader National Express Systems. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: big database (need to modify columns)
what do you need to doand what DB? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 14:00 To: CF-Talk Subject: big database (need to modify columns) hey all, has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? everytime I try it times the F**K out. and its driving me crazy thanks. ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually insert the form fields into my database? input class=uuid type=text value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumber size=38 onfocus=this.blur(); input type=hidden value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumberr On Mon, 17 Mar 2003 07:55:49 -0600, Larry Juncker wrote: Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one machine Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
The UUID will ALWAYS be unique - thats the whole point, and why you can define a row id with one of course like people have stated, reducing the amount of chars may increase the chance of a dupe with that block, but in essense the UUID will always be unique, if CF does not produce a unique UUID everytime then its a bug. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 14:00 To: CF-Talk Subject: RE: Using createUUID() Heres a URL on how the UUID is defined http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. there are 3.4028236692093846346337460743177e+38 combinations (2^128). Jason Lees Development Team Leader National Express Systems. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get
Remoting...
Evening all, When you make a call to createGatewayConnection() from within the Action Script, what happens? What I mean is, does Flash make a call to the CFC purely to check if it exists and then discards anything, or does it hold a reference to the new instance? What we'd like to do is PUSH data to the flash component, rather than PULL it from the server... We could set up a timer on the component to re-cal la function in a CFC every x seconds, but what we'd rather do is (somehow) have the CFC inform flash that an update has happened. As far as I can work out, it's not possible. Am I right in this thinking? Alternatively, is there a way around it? Say having flash call the CFC straight away (once) and the CFC will wait until an update has occurred, then return the new data to Flash, whereupon Flash will update and call the CFC again, which will wait etc etc etc... How about creating an instance of a java class on the CFC call and storing that in a global scope somewhere, which does nothing but wait() until an update has occurred, whereupon CF will call a method on that java object to break out of the wait statement, so the initial CFC call will then complete etc... Would that work? I sure there must be an easier way... Pah, what a thing to be doing on a Monday. Cheers, Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using createUUID()
It all depends on your OS. CF on some OSs will return consecutive numbers not random numbers using UUID. On some OSs your code would return the same four numbers everytime for quite a while before it changed. Regards Stephen CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:34 PM Subject: RE: Using createUUID() have done/been doing for weeks now with no probs :-) -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: big database (need to modify columns)
Quoting Tony Weeg [EMAIL PROTECTED]: has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? ALTER TABLE table ADD COLUMN column datatype; Never done it on something larger as 8 million rows and it takes some time, but it is not something that ought to break anything. Just remember that this will most likely exclusively lock your table, and that CF (or any other web language) is not the right tool for it, but you need the native DB management tools. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Quoting Jason Lees (National Express) [EMAIL PROTECTED]: http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. And although MAC addresses are officially unique, they are not in reality. Many OS'es allow you to change it and vendors of cheaper NICs (Realtek) use duplicates themselves. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
As long as you use this value when the form is initially loaded, then this value would insert into the database as well. I think I understand what you are asking. If you are wanting this to be a unique form ID number then I would recommend calling it something other than UUID, because once you save it as a ten digit number, it is no longer a UUID. Does that make sense? Hope this helps. Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:05 AM To: CF-Talk Subject: RE: Using createUUID() If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually insert the form fields into my database? input class=uuid type=text value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumber size=38 onfocus=this.blur(); input type=hidden value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumberr On Mon, 17 Mar 2003 07:55:49 -0600, Larry Juncker wrote: Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one machine Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Remoting...
I see what your trying to do do, but somewhere, something has to poll to see if an update has happenned. How does the CFC know if there was an update? Do you mean a DB update? BTW, it's a great question. Looking forward to other's responses. -Frank - Original Message - From: Tim Blair [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:05 AM Subject: Remoting... Evening all, When you make a call to createGatewayConnection() from within the Action Script, what happens? What I mean is, does Flash make a call to the CFC purely to check if it exists and then discards anything, or does it hold a reference to the new instance? What we'd like to do is PUSH data to the flash component, rather than PULL it from the server... We could set up a timer on the component to re-cal la function in a CFC every x seconds, but what we'd rather do is (somehow) have the CFC inform flash that an update has happened. As far as I can work out, it's not possible. Am I right in this thinking? Alternatively, is there a way around it? Say having flash call the CFC straight away (once) and the CFC will wait until an update has occurred, then return the new data to Flash, whereupon Flash will update and call the CFC again, which will wait etc etc etc... How about creating an instance of a java class on the CFC call and storing that in a global scope somewhere, which does nothing but wait() until an update has occurred, whereupon CF will call a method on that java object to break out of the wait statement, so the initial CFC call will then complete etc... Would that work? I sure there must be an easier way... Pah, what a thing to be doing on a Monday. Cheers, Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
As I understand it, createUUID returns a character string. I thought that record ID's should be numeric because of the improved performance on indexed look-ups. Do numeric indexes run significantly faster then character ones? Andy -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:03 AM To: CF-Talk Subject: RE: Using createUUID() The UUID will ALWAYS be unique - thats the whole point, and why you can define a row id with one of course like people have stated, reducing the amount of chars may increase the chance of a dupe with that block, but in essense the UUID will always be unique, if CF does not produce a unique UUID everytime then its a bug. -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 14:00 To: CF-Talk Subject: RE: Using createUUID() Heres a URL on how the UUID is defined http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. there are 3.4028236692093846346337460743177e+38 combinations (2^128). Jason Lees Development Team Leader National Express Systems. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision. André -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:34 To: CF-Talk Subject: RE: Using createUUID() not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding
Re: Can someone walk me thru changing my ALT-3 shortcut?
That's so weird. Those steps worked *perfectly* for me, and I'm on DWMX 6.1 too. I can type anything and select it, and hit ctrl-3 and it's all surrounded by poundsigns... Well, what's wierd is that I sent the post to cf-talk, but it didn't post for literally about 3 days. In that interim, I did a full uninstall/reinstall of DWMX and things are working now. Not sure why the initial install was corrupted (or why my post took 3 days to post), but I'm just happy to be up and running again, so I won't complain! Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
On Mon, 17 Mar 2003 08:19:44 -0600, Larry Juncker wrote: As long as you use this value when the form is initially loaded, then this value would insert into the database as well. I think I understand what you are asking. If you are wanting this to be a unique form ID number then I would recommend calling it something other than UUID, because once you save it as a ten digit number, it is no longer a UUID. Does that make sense? Yup. Hope this helps. Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:05 AM To: CF-Talk Subject: RE: Using createUUID() If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually insert the form fields into my database? input class=uuid type=text value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumber size=38 onfocus=this.blur(); input type=hidden value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumberr On Mon, 17 Mar 2003 07:55:49 -0600, Larry Juncker wrote: Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one machine Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the e-mail listed above. -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:56 AM To: CF-Talk Subject: Using createUUID() Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create PostScript file from dynamic pages or query outputs
I would look into GhostScript. If nothing else, you should be able to build the PDF in CF and convert it to PS. However, it strikes me as odd that whatever software they're using to create their PDFs can't use a PDF as input. -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Jason Miller [mailto:[EMAIL PROTECTED] : Sent: Friday, March 14, 2003 6:36 PM : To: CF-Talk : Subject: Re: Create PostScript file from dynamic pages or query outputs : : : Ironically - I believe it will be easier to simply make a PDF - : BUT - I need to create a postscript file so that I may pass of the ps : file to a process that needs to trigger a software that wil : create the pdf. : : Why? So we may put a - used by PlanetPress Watch tag on it. We are : showcasing their technology - but we wish to make it a bit more : impressive graphically - which is my end. Therefore if can ultimately : control the look, rip that to a postcsript file - I get to control all : the look and aesthetics and data - while their software handles the : fulfilment. At t heir software level it is doing other things - : conditionally gathering misc datasheets and creating a multi page PDF : document with custom variables. : : Make a bit more sense? : As for what you say below -it's pretty much on the money as I : would put it. : jay miller : : Ben Doom wrote: : : One of my bosses does prepress support, and I can ask about : further details : from him if you want, but here's my impression: just make a : PDF. There are : lots of utilities, drivers, print queuers, and RIPs that will take a PDF : just as easily as PS. Also, most devices that can take PS : directly can take : PDFs (at least at the high end). PDF is, after all, essentially : postscript : with much of the redundancy removed. Hence the term 'distiller' : for Adobe's : old ps-pdf product. : : At least that's my understanding. Don't take it as gospel. :-) : : -- Ben Doom : Programmer General Lackey : Moonbow Software, Inc : : : -Original Message- : : From: Jason Miller [mailto:[EMAIL PROTECTED] : : Sent: Friday, March 14, 2003 5:55 PM : : To: CF-Talk : : Subject: Create PostScript file from dynamic pages or query outputs : : : : : : Hello list - google search surprisingly didn't give me what I needed... : : I am probably asking or looking for the wrong things. : : The simple - cut and dry question is: : : Take graphics and variables - write all content to postscript and : : email it. : : : : What I am doing - : : I need to have a user fill out some options, collect his information, : : display a page - combination of his form and some queried content from : : an access database. All said and done - in the background I : need to take : : a well designed page with graphics and variables - write to a : postscript : : file and email as an attachment. I can create a temporary page as a cfm : : page and maybe do a print type function - but not sure ho to do this or : : where to start. it is on a virtual server at an ISP host - hopefully : : that doesn't limit me. : : : : I just thought of 1 thing - Maybe instead of emailing the postscript : : file I can do maybe a TCP/IP print - and have some process just catch : : the print stream? : : : : Any direction, samples, tutorials would be very helpful. I am not sure : : if I am overthinking this or not thinking of the right process. : : Thanks, : : Jason : : : : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Pet Market cfc's
While I can take the blame for the infamous jedimasterwhopper bug (sigh), I can't take the credit for Petmarket. : === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 7:25 PM To: CF-Talk Subject: Re: Pet Market cfc's This looks like the work of either Mike Nimer or Ray Camden... One of them, I can't remember which, is very fond of the cfparam-to-initialize-this-attributes idiom. I personally don't like it(!) because, to me, cfparam says I'm being passed some parameters and I'll validate their types and set defaults for omitted ones whereas for 'this.' attributes, you clearly are not being passed any parameters and, as you correctly observe, none of them will exist. I'd just use cfset instead. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using createUUID()
Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? If mySQL is case sensitive like Oracle, you could take the uName() function from TAPI to do this... cfset myid = request.tapi.uName(,10) (the order of the arguments may not be right here, this is from memory and I don't usually use the arguments. The function was originally created for the purpose of creating random strings to be used as names of temporary functions in JavaScript and as such generates a string of x random mixed case characters, discluding some commonly confused characters (0oOliI1) with a pre-defined prefix (to prevent the possibility of the string beginning with a number which would make it useless as a function name). You can set the prefix to an empty string and the number of characters to 10 (default is 35) to produce something slightly less structured and of course you can add back in the 0oOliI1 characters to increase your variance. Url in my sig below. Or you could use a non random string (guaranteed to be unique every time) like an autonumber/increment. Do this by exclusively locking around the function that generates the number (either from the db or from the file system), and then simply set your string with this number cfset myid = CT- numberformat(myautonumber,000) To get the number from mySQL just create a table for your autonumber id's and use a cftransaction isolation=serializeable around two queries -- one to retreive the current number and another to increment it by one. To get the number from the file system is similar -- just create a file to contain the number and use cflock name=#expandpath(myfilepath)# type=exclusive timeout=30cffile action=read file=#expandpath(myfilepath)# variable=myuniqueidcffile action=write file=#expandpath(myfilepath)# output=#incrementvalue(myuniqueid)#/cflock In CFMX you can create a UDF to perform this task using cffunction so you can create more unique id's if you need them and reduce the amount of typing to get them. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remoting...
I see what your trying to do do, but somewhere, something has to poll to see if an update has happenned. How does the CFC know if there was an update? Do you mean a DB update? Think of it in terms of a private messaging system: one user of the site sends another user a message which gets written to the database. Once the write has been performed, another function is called to say that an update has occurred, which should somehow push the new data to the flash client. I guess it's kinda like the view in a traditional MVC architecture: the view (flash component) is an observer of the model (database, CFCs) and needs to catch a model updated event so it knows a refresh is required... BTW, it's a great question. Looking forward to other's responses. Why thank you, me too... ;o) Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Matrix problem
I don't think I understood the question. And, given that there's been no response in the last hour and a half, I suspect no one else did, either. To me, a matrix is simply an n-dimensional array where n 1. In a 2-dimensional matrix, column f will intersect row 5 exactly once. Your query approach suggests that you are working with a matrix of n 2. So you are looking for a count of (f, 5, x) is populated where x is the third dimension. Am I anywhere near the mark? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Monday, March 17, 2003 8:13 AM : To: CF-Talk : Subject: Matrix problem : : : I'm not very experienced at this, but I need to create a report : that creates a matrix (the number of times where, say, column f : intersects the row 5). : : I see how I can work the query (a kind of Where F AND 5 : statement--other approaches appreciated). But I'm at a loss : about how to output it so that it counts the total number instead : of lists each incident. : : Is it done in the query or in the output? : : Rick : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: big database (need to modify columns)
but from query analyzer I should be ok? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:09 AM To: CF-Talk Subject: Re: big database (need to modify columns) Quoting Tony Weeg [EMAIL PROTECTED]: has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? ALTER TABLE table ADD COLUMN column datatype; Never done it on something larger as 8 million rows and it takes some time, but it is not something that ought to break anything. Just remember that this will most likely exclusively lock your table, and that CF (or any other web language) is not the right tool for it, but you need the native DB management tools. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remoting...
You can only push data on demand with Flash Remoting. You cannot control when you'll get the response from a remoting call... (you'll get the response as soon as the request is finished on the server). It is a request/response mechanism. If you need to be able to push data from a server to a Flash client in REAL TIME, you'll need to open a socket connection on your flash client (with XMLSocket() object). On the server side, you'll need a socket server to handle those connections (for example Unity from www.moock.org). But, you'll have to handle the interaction between the socket server and your CFCs. For example, you could write some java class that will call your CFCs and return XML formatted data to your Flash client. So, it is possible, but it requires quite a lot of coding... In fact, the easiest way to do it is to use Flash Communication Server MX and it's remote Shared Objects (more info : http://www.macromedia.com/devnet/mx/flashcom/articles/whiteboard_3.html). On the server side, you would write the Flash Remoting ActionScript that will call your CFCs and populate a remote Shared Object. All the interaction with your CFCs are on the server side, between FlashCom and ColdFusion. As soon as the remote shared objects is modified on FlashCom server, all the Flash clients connected to this shared object will be automatically notified (onSync event). FlashCom hides all the complexity of the socket connection and notification mechanism. It's really great! Benoit Hediard www.benorama.com -Message d'origine- De : Frank Mamone [mailto:[EMAIL PROTECTED] Envoyé : lundi 17 mars 2003 15:26 À : CF-Talk Objet : Re: Remoting... I see what your trying to do do, but somewhere, something has to poll to see if an update has happenned. How does the CFC know if there was an update? Do you mean a DB update? BTW, it's a great question. Looking forward to other's responses. -Frank - Original Message - From: Tim Blair [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:05 AM Subject: Remoting... Evening all, When you make a call to createGatewayConnection() from within the Action Script, what happens? What I mean is, does Flash make a call to the CFC purely to check if it exists and then discards anything, or does it hold a reference to the new instance? What we'd like to do is PUSH data to the flash component, rather than PULL it from the server... We could set up a timer on the component to re-cal la function in a CFC every x seconds, but what we'd rather do is (somehow) have the CFC inform flash that an update has happened. As far as I can work out, it's not possible. Am I right in this thinking? Alternatively, is there a way around it? Say having flash call the CFC straight away (once) and the CFC will wait until an update has occurred, then return the new data to Flash, whereupon Flash will update and call the CFC again, which will wait etc etc etc... How about creating an instance of a java class on the CFC call and storing that in a global scope somewhere, which does nothing but wait() until an update has occurred, whereupon CF will call a method on that java object to break out of the wait statement, so the initial CFC call will then complete etc... Would that work? I sure there must be an easier way... Pah, what a thing to be doing on a Monday. Cheers, Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:
RE: Using createUUID()
I got this from another CF developer I used to work with (I don't know if he is on the list). This tag creates a SQL formated GUID in variable you specify. !--- Place in a NewGUID.cfm file and place in Custom Tag Directory --- cfsetting enablecfoutputonly=Yes !--- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Application Security using cflogin and cfloginuser
I was reading the tutorial over on cfvault, and I noticed it wasn't using cflogin, or cfloginuser, or any of the newer MX security features, and I was wondering if anyone had a good url with a good introduction to application security using some of the newer CFMX features. I'm trying to wrap my brain around application security, and I'm having a hard time following the CFMX manual. In fact, I'm not even sure of what questions I'd even *ask* at this point, other than maybe, how on earth do I make this work? I mean, I fundamentally understand how this is all supposed to work, and I understand application.cfm and all that, but I'm just having a hard time determining little things...like what to put where, and so on. Also, if I use cfloginuser I'm limited to name, password, and roles, but the table is going to store more information than that, that I'd like access to, like first and last name for instance. I'd like to display that on each page, but I'm not sure how to get it for each logged in user. Etc.. Any help would be appreciated... ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: big database (need to modify columns)
yep -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 15:09 To: CF-Talk Subject: RE: big database (need to modify columns) but from query analyzer I should be ok? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:09 AM To: CF-Talk Subject: Re: big database (need to modify columns) Quoting Tony Weeg [EMAIL PROTECTED]: has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? ALTER TABLE table ADD COLUMN column datatype; Never done it on something larger as 8 million rows and it takes some time, but it is not something that ought to break anything. Just remember that this will most likely exclusively lock your table, and that CF (or any other web language) is not the right tool for it, but you need the native DB management tools. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Newbe SQL question
I have a basic MSSQL7 question - we have a table with no unique identifier (don't ask - I didn't design it) where, on an insert, we want to update a record if it exists and insert it if it doesn't. The record can be identified only by a combination of columns. For example - select a,b,c,d,e,f from sometable where ... In other words, selection based on 7 columns or so is the only way to uniquely identify a record. So, is it possible to have a trigger check for uniqueness and insert or update a record depending on whether the record was found? Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remoting...
FlashCom hides all the complexity of the socket connection and notification mechanism. It's really great! I agree that it's great in principle, but from all the swearing coming from one of our guys developing with FlashComm I'd say that the current release isn't up to scratch for a production server as of yet... Plus the fact that it's another license to shell out for etc... :o\ Tim. --- OUR NEW SITE IS NOW LIVE Visit our new website at http://www.rawnet.com/ and race around the beautiful Bracknell streets at http://xmas.rawnet.com/ --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
Also, if I use cfloginuser I'm limited to name, password, and roles, but the table is going to store more information than that, that I'd like access to, like first and last name for instance. I'd like to display that on each page, but I'm not sure how to get it for each logged in user. Etc.. The cflogin framework handles 2 basic things - authentication and authorization. User data would still need to be handled as it is now. For example, maybe on login you get info like the user's name and age. You could then store that into the session scope(*). The 'roles-based security' system is not concerned with stuff like that - it just handles the low level stuff like determining if you are logged in and what roles are you in (if any). * cflogin is NOT based on sessions. That means your cflogin authentication could expire and your session vars would still exist. Therefore, you kind of have to hack around it. This is a typical section of code from an Application.cfm file using cflogin. I've added comments to explain what I'm doing. Any XXX implies a string I changed for privacy reasons. I've put ** by the lines you really need to care about. cfsetting enableCFOutputOnly = true cfapplication name=XXX sessionManagement=true !--- Include App variables --- cfif not isDefined(application.init) cfinclude template=/intranet/includes/global_vars.cfm /cfif ** !--- Handles logging the user out. Also not how we detect an expired session. This way if the session expires before the cflogin scope, we force a logout as well. --- cfif isDefined(url.logout) or not isDefined(session.userid) cflogout /cfif !--- Include UDF library --- cfinclude template=/intranet/includes/udf.cfm cflogin cfset showForm = true ** !--- Again, the idea here is to keep Session/CFLOGIN in sync. --- cfset structClear(session) cfif isDefined(form.username) and len(trim(form.username)) and isDefined(form.password) and len(trim(form.password)) cfif application.user.authenticate(trim(form.username), trim(form.password)) cfloginuser name=#trim(form.username)# password=#trim(form.password)# roles=#application.user.getRoles(trim(form.username), trim(form.password))# ** !--- This is an example of how I store user info in the session scope. --- cfset structAppend(session,application.user.getUserInformation(trim(form.usern ame), trim(form.password))) cfset showForm = false /cfif /cfif cfif variables.showForm cfinclude template=//wwwroot/login.cfm cfabort /cfif /cflogin === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Remoting...
Alternatively, is there a way around it? Say having flash call the CFC straight away (once) and the CFC will wait until an update has occurred, then return the new data to Flash, whereupon Flash will update and call the CFC again, which will wait etc etc etc... How about creating an instance of a java class on the CFC call and storing that in a global scope somewhere, which does nothing but wait() until an update has occurred, whereupon CF will call a method on that java object to break out of the wait statement, so the initial CFC call will then complete etc... By the way, this method is definitely not recommanded because you'll get timeout problems. Moreover, each clients waiting for a request will eat one thread on your ColdFusion server. If several Flash clients connect at the same time, they will quickly eat all your threads and your ColdFusion server will be dead... In my opinion, the only answers to your problem are : - periodic calls from the client through Flash Remoting to see if an update has occured, Very easy to do, nearly real time (every 10 sec. for example), but it generates a lot of calls/traffic on the server... definitely not recommanded for large site with hundred of simultaneous clients. - socket connection More complex (requires a socket server), but real time and it reduces dramatically calls/traffic on ColdFusion Server. Benoit Hediard www.benorama.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Newbe SQL question
You could use a trigger, but better just to use a stored proc. Something along the lines of.. Create procedure someproc @a int, @b varchar // etc etc as If exists(select a,b,c,d,e,f from sometable where [EMAIL PROTECTED] and ..) begin // It does exist so do update end else begin // It doesn't exist so do insert end -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 15:13 To: CF-Talk Subject: Newbe SQL question I have a basic MSSQL7 question - we have a table with no unique identifier (don't ask - I didn't design it) where, on an insert, we want to update a record if it exists and insert it if it doesn't. The record can be identified only by a combination of columns. For example - select a,b,c,d,e,f from sometable where ... In other words, selection based on 7 columns or so is the only way to uniquely identify a record. So, is it possible to have a trigger check for uniqueness and insert or update a record depending on whether the record was found? Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Check if file on server is *read-only*
HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 10:23 AM, Raymond Camden at [EMAIL PROTECTED] wrote: The cflogin framework handles 2 basic things - authentication and authorization. User data would still need to be handled as it is now. For example, maybe on login you get info like the user's name and age. You could then store that into the session scope(*). The 'roles-based security' system is not concerned with stuff like that - it just handles the low level stuff like determining if you are logged in and what roles are you in (if any). * cflogin is NOT based on sessions. That means your cflogin authentication could expire and your session vars would still exist. Therefore, you kind of have to hack around it. This is a typical section of code from an Application.cfm file using cflogin. I've added comments to explain what I'm doing. Any XXX implies a string I changed for privacy reasons. I've put ** by the lines you really need to care about. Darn, that did more to confuse me than anything else... So lemme get this straight, I'm not going to be able to start my logic with does a session exist? because the cflogin tag isn't going to do anything with sessions? Like create one? What I'm looking for is basically the following: 1. Is the user logged in with a current session? (I would place this in the application.cfm of the directory I want to protect, so It's executed on every page in the directory, so people can't bookmark a page and come back to it without having to log back in) 2. If so, then display the page. If not, redirect them up one level to the home page, which has a link to the login popup. (should the login page itself, the one taking usernames and passwords reside in the lower, protected directory? Or should it sit up, outside of the directory with the application.cfm page and just pass successful logins to that directory?) My login is basically just a popup window that will refresh the parent and close itself upon successful login. In other words, you'd go to index.cfm, and click a link to popup login.cfm, and when you successfully logged in, the window would close and you'd be on the index page of the lower directory. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newbe SQL question
Howie Hamlin wrote: I have a basic MSSQL7 question - we have a table with no unique identifier (don't ask - I didn't design it) where, on an insert, we want to update a record if it exists and insert it if it doesn't. The record can be identified only by a combination of columns. For example - select a,b,c,d,e,f from sometable where ... Maybe it is time to create a composite primary key so you can enfore a unique identifier. Something like: ALTER TABLE sometable ADD CONSTRAINT sometable_pkey PRIMARY KEY (a,b,c,d,e,f) For the trigger, why not a stored procedure? I find instead of triggers quite a cludge. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
Darn, that did more to confuse me than anything else... So lemme get this straight, I'm not going to be able to start my logic with does a session exist? because the cflogin tag isn't going to do anything with sessions? Like create one? The cflogin tag has nothing to do with sessions. Period. As it stands, you 'create' a session when you put the cfapplication tag in your browser. I believe it exists even before you do your first cfset session.foo = 1. (Actually, I'm sure of this since you can cfdump session immediately.) You _can_ however set a session var on login. You will see in my code that after the users logs in correctly, I set various session values (I do it all at once by getting a struct of user data then appending it on the session scope.) What I'm looking for is basically the following: 1. Is the user logged in with a current session? (I would place this in the application.cfm of the directory I want to protect, so It's executed on every page in the directory, so people can't bookmark a page and come back to it without To determine if someone is logged on, you can do multiple things. 1) getAuthUser() will return if not logged in. See special note. 2) If anything inside the cflogin block is run, you are not logged in. So you could do: cflogin cfset request.ImAGuest = true /cflogin and request.ImAGuest will exist if the user isn't logged in. having to log back in) 2. If so, then display the page. If not, redirect them up one level to the home page, which has a link to the login popup. (should the login page itself, the one taking usernames and passwords reside in the lower, protected directory? Or should it sit up, outside of the directory with the application.cfm page and just pass successful logins to that directory?) It doesn't matter where it exists. If you want a popup, then it has to be in the web directory somewhere. If you cfinclude the code, you don't have to worry about Application.cfm blocking access to it (something I see cfnewbies do - protect all files using application.cfm and forget to make it possible to view the login page.) My login is basically just a popup window that will refresh the parent and close itself upon successful login. In other words, you'd go to index.cfm, and click a link to popup login.cfm, and when you successfully logged in, the window would close and you'd be on the index page of the lower directory. That can work. :) Special Note: If inside a cflogin block you log the user in, getAuthUser will STILL report . It will report until you exit the cflogin block. This is a known bug. http://www.camdenfamily.com/morpheus/blog/index.cfm?mode=entryentry=32 === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Newbe SQL question
In other words, selection based on 7 columns or so is the only way to uniquely identify a record. So, is it possible to have a trigger check for uniqueness and insert or update a record depending on whether the record was found? sql server triggers work after the insert--inserting then figuring out if there are two identitical rows would be a bit challenging. you'd probably be better off with an SP to handle this. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Forum System Recommendations
All: A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about $500) but doesn't have to be free. I checked out FuseTalk and the pricing is way too prohibitive. Can anyone make any other suggestions, preferably from personal experience? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check if file on server is *read-only*
On Windows systems, files that are read only will have an R in the attributes column when using cfdirectory. For *nix systems, you should be able to check the mode column. - Original Message - From: FlashGuy [EMAIL PROTECTED] Date: Monday, March 17, 2003 8:37 am Subject: Check if file on server is *read-only* HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Matrix problem
You're right. Matrix must be thowing folks off. But I'm afraid you've lost me, now. Let me try again. I'm working with a body of monthly 500 reports from which I need to distill certain information. For the report output (which will take the form of a matrix), assume column f is Brown_Eyes and assume row 5 is Big_Feet. I can easily imagine a query of the DB WHERE brown-eyes AND big_feet returns a list of 25 of the 500 db records. But what I want to do is ouput the COUNT, not a list of db records. Is this better? -- Rick I don't think I understood the question. And, given that there's been no response in the last hour and a half, I suspect no one else did, either. To me, a matrix is simply an n-dimensional array where n 1. In a 2-dimensional matrix, column f will intersect row 5 exactly once. Your query approach suggests that you are working with a matrix of n 2. So you are looking for a count of (f, 5, x) is populated where x is the third dimension. Am I anywhere near the mark? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Monday, March 17, 2003 8:13 AM : To: CF-Talk : Subject: Matrix problem : : : I'm not very experienced at this, but I need to create a report : that creates a matrix (the number of times where, say, column f : intersects the row 5). : : I see how I can work the query (a kind of Where F AND 5 : statement--other approaches appreciated). But I'm at a loss : about how to output it so that it counts the total number instead : of lists each incident. : : Is it done in the query or in the output? : : Rick : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forum System Recommendations
QD Forums is nice and is open source. From QuillDesigns, I am going to purchase it this week for a client. -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:51 AM To: CF-Talk Subject: Forum System Recommendations All: A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about $500) but doesn't have to be free. I checked out FuseTalk and the pricing is way too prohibitive. Can anyone make any other suggestions, preferably from personal experience? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forum System Recommendations
My friend developed one of the first forum apps for CF called CFBoards and his pricing (and feature set) is right in line with what you want: http://www.eruditionzone.com/index.cfm?fuseaction=cfboards I've seen it in use and I liked it a lot. Bill : -Original Message- : From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] : Sent: 3/17/03 8:51 AM : Subject: Forum System Recommendations : : All: : : A client of mine (small, non-profit) would like to quickly : add a discussion forum to their website. It needs to support : unlimited threads, topics, messages, etc. It needs to : support forum searches, user profiles, moderation, limited : HTML content. And, preferably, it should be cheap (about : $500) but doesn't have to be free. : : I checked out FuseTalk and the pricing is way too : prohibitive. Can anyone make any other suggestions, : preferably from personal experience? : : TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forum System Recommendations
Mosh, A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about $500) but doesn't have to be free. I checked out FuseTalk and the pricing is way too prohibitive. Can anyone make any other suggestions, preferably from personal experience? Talk to FuseTalk directly. Their teminology is a little weird and I suspect that what you actually need is very cheap ($250ish I believe), plus if its a NP/charitable organisation you might qualify for an educational discount. Regards Stephen CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Matrix problem
Select count(*) where WHERE f='brown-eyes' AND somecol='big_feet' I can only guess that's what you want to do. But if this isn't it, you should probably learn proper database lingo and re-ask the question. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:52 AM To: CF-Talk Subject: RE: Matrix problem You're right. Matrix must be thowing folks off. But I'm afraid you've lost me, now. Let me try again. I'm working with a body of monthly 500 reports from which I need to distill certain information. For the report output (which will take the form of a matrix), assume column f is Brown_Eyes and assume row 5 is Big_Feet. I can easily imagine a query of the DB WHERE brown-eyes AND big_feet returns a list of 25 of the 500 db records. But what I want to do is ouput the COUNT, not a list of db records. Is this better? -- Rick I don't think I understood the question. And, given that there's been no response in the last hour and a half, I suspect no one else did, either. To me, a matrix is simply an n-dimensional array where n 1. In a 2-dimensional matrix, column f will intersect row 5 exactly once. Your query approach suggests that you are working with a matrix of n 2. So you are looking for a count of (f, 5, x) is populated where x is the third dimension. Am I anywhere near the mark? -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] : Sent: Monday, March 17, 2003 8:13 AM : To: CF-Talk : Subject: Matrix problem : : : I'm not very experienced at this, but I need to create a report : that creates a matrix (the number of times where, say, column f : intersects the row 5). : : I see how I can work the query (a kind of Where F AND 5 : statement--other approaches appreciated). But I'm at a loss : about how to output it so that it counts the total number instead : of lists each incident. : : Is it done in the query or in the output? : : Rick : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: flash forms
Just put the beveled graphics behind the text box. mike chambers [EMAIL PROTECTED] - Original Message - From: Mahmut Basaran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 11:23 PM Subject: Re: flash forms Also, is there a way to make html style textboxes (that has depth) in flash ? at the moment, all I can do is black borders around text areas. - Original Message - From: Sean A Corfield [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 10:24 PM Subject: Re: flash forms On Sunday, Mar 16, 2003, at 03:52 US/Pacific, Mahmut Basaran wrote: I have 3 page html form that I want to build in flash. So far, I couldn't figure out how to put all of them into one .swf file. I tried making 3 different flash forms and calling them with loadMovie() and it worked fine. Anyway, is there a better way ? You could use a single movie and do either of the following: 1. Use (key)frames: have three different frame and have each form in a separate frame of the movie. Your ActionScript would then gotoAndStop(n) to navigate between the pages. 2. Use layers: have three different layers for the three different forms and make each one visible / invisible as needed. I've used the first method (because I haven't figured out the second one properly yet!). Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Matrix problem
Rick, I'm working with a body of monthly 500 reports from which I need to distill certain information. For the report output (which will take the form of a matrix), assume column f is Brown_Eyes and assume row 5 is Big_Feet. I can easily imagine a query of the DB WHERE brown-eyes AND big_feet returns a list of 25 of the 500 db records. But what I want to do is ouput the COUNT, not a list of db records. You need to be reading up on the GROUP BY clause and the COUNT() function. SELECT count(tblColumn) as resultcount FROM tblTable GROUP BY tblColumn Its not going to be right, but it gives you an idea of what you need to be reading up on and what you need to be doing with your query. Hope that helps Regards Stephen CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 10:46 AM, Raymond Camden at [EMAIL PROTECTED] wrote: The cflogin tag has nothing to do with sessions. Period. As it stands, you 'create' a session when you put the cfapplication tag in your browser. I believe it exists even before you do your first cfset session.foo = 1. (Actually, I'm sure of this since you can cfdump session immediately.) You _can_ however set a session var on login. You will see in my code that after the users logs in correctly, I set various session values (I do it all at once by getting a struct of user data then appending it on the session scope.) So I could, inside my cflogin, create an array to hold user info, then store that in the session scope? Is that ym approach? It doesn't matter where it exists. If you want a popup, then it has to be in the web directory somewhere. If you cfinclude the code, you don't have to worry about Application.cfm blocking access to it (something I see cfnewbies do - protect all files using application.cfm and forget to make it possible to view the login page.) This was my concern. So I could put the login popup in the root directory, and if the user successfully logs in, I pass them down one level to the protected directory. Am I thinking thru that correctly? So I want my login.cfm form to go to action=login_process.cfm and on this page, query the database, and if the user exists, and is a valid user, then I want to pass this down to the lower directory, and use the application.cfm of that directory to log that user in and set session variables? What would be my approach for passing that successful login information to the application.cfm without using something that can be seen? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forum System Recommendations
I use http://forum.snitz.com/ internally on our Intranet. Its an ASP app...I know...but its free and really easy to set up. Doug -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:51 AM To: CF-Talk Subject: Forum System Recommendations All: A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about $500) but doesn't have to be free. I checked out FuseTalk and the pricing is way too prohibitive. Can anyone make any other suggestions, preferably from personal experience? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check if file on server is *read-only*
Use the ATTRIBUTES parameter [EMAIL PROTECTED] 03/17/03 10:37AM HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Clearing Cached Pages
Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
on 3/17/03 10:46 AM, Raymond Camden at [EMAIL PROTECTED] wrote: The cflogin tag has nothing to do with sessions. Period. As it stands, you 'create' a session when you put the cfapplication tag in your browser. I believe it exists even before you do your first cfset session.foo = 1. (Actually, I'm sure of this since you can cfdump session immediately.) You _can_ however set a session var on login. You will see in my code that after the users logs in correctly, I set various session values (I do it all at once by getting a struct of user data then appending it on the session scope.) So I could, inside my cflogin, create an array to hold user info, then store that in the session scope? Is that ym approach? Well, if it's user data like age, name, rank, etc, a struct seems to make more sense, but use whatever is best for you. It doesn't matter where it exists. If you want a popup, then it has to be in the web directory somewhere. If you cfinclude the code, you don't have to worry about Application.cfm blocking access to it (something I see cfnewbies do - protect all files using application.cfm and forget to make it possible to view the login page.) This was my concern. So I could put the login popup in the root directory, and if the user successfully logs in, I pass them down one level to the protected directory. Am I thinking thru that correctly? That is one approach. So I want my login.cfm form to go to action=login_process.cfm and on this page, query the database, and if the user exists, and is a valid user, then I want to pass this down to the lower directory, and use the application.cfm of that directory to log that user in and set Why not just use one application.cfm in the root of your site? session variables? What would be my approach for passing that successful login information to the application.cfm without using something that can be seen? See above. Did you notice how my code looked for form variables to detect a login? There is no reason why your code couldn't do that. I'd have the popup simply output JavaScript code to 'push' the parent window to /lower, where /lower is the subdirectory of protected files. Note - you don't really need to use a whole other subdirectory. You could write your Application.cfm code so that the popups load. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Forum System Recommendations
Ah well now - if you're talking free - www.phpbb.com if you can run php applications on your server ;o) Stephen I use http://forum.snitz.com/ internally on our Intranet. Its an ASP app...I know...but its free and really easy to set up. Doug -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:51 AM To: CF-Talk Subject: Forum System Recommendations All: A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about $500) but doesn't have to be free. I checked out FuseTalk and the pricing is way too prohibitive. Can anyone make any other suggestions, preferably from personal experience? TIA -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clearing Cached Pages
if the server is cfmx, then its not the users cache, its most likely cfmx. other than that, they could try shift + refresh that forces the browser to snag a live copy... ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:15 AM To: CF-Talk Subject: Clearing Cached Pages Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Check if file on server is *read-only*
Thanks On Mon, 17 Mar 2003 08:51:45 -0700, [EMAIL PROTECTED] wrote: On Windows systems, files that are read only will have an R in the attributes column when using cfdirectory. For *nix systems, you should be able to check the mode column. - Original Message - From: FlashGuy [EMAIL PROTECTED] Date: Monday, March 17, 2003 8:37 am Subject: Check if file on server is *read-only* HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clearing Cached Pages
Hi Dave, Try This: CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Expires VALUE=Now() CFHEADER NAME=cache-control VALUE=no-cache, no-store, must-revalidate Eric -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:15 AM To: CF-Talk Subject: Clearing Cached Pages Importance: Low Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clearing Cached Pages
!--- prevent the pages from caching --- CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, no-store, must-revalidate -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: maandag 17 maart 2003 17:15 To: CF-Talk Subject: Clearing Cached Pages Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clearing Cached Pages
Dave, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated To stop a page from being cached by a users browser you need to use the following HTML meta tags in your pages : META http-equiv='expire' content='0' META http-equiv='pragma' content='no-cache' I suspect that if the user has set their internet options to never check for page changes then you will be a bit stuck, but any of the other settings should pick up the addition of these tags and clear their cache or at least force their browser to load a new copy of the page. Regards Stephen == CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Dropdown Question
Hi, I was wondering if anyone has an example or maybe a custom tag that I could use that would allow me to have a dropdown box on a page that if the option for the user to select is not there then the user can type something in the field. I tried to leave a blank option out there but the blank option is selectable but not editable. I have tried to search on Developer Exchange but I cannot find any. I am sure there is one out there but I must be using the wrong search word. Thanks Mario This message is for the named person's use only. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal written confirmation. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 11:14 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Well, if it's user data like age, name, rank, etc, a struct seems to make more sense, but use whatever is best for you. Actually, a struct makes a LOT of sense, and I see what you're saying now. Why not just use one application.cfm in the root of your site? I think I came to this realization at about the same time you hit send on this email. So now, let me see if I understand this correctly. 1. Login.cfm will reside in the root and will take username and password 2. Login_process will ALSO reside in the root, and if the user successfully logs in, it sets a session, cfset session.LoggedIn=1 refreshes the parent window, then closes itself. 3. If not a success, then that page stays up and gives the user the opportunity to try again, or close the window. Once the user successfully logs in: Place a line of code on each page in that protected directory that will check for the existence of session.logged in, if not present, redirect to the index page of the root, which has a link to the login popup. This being safe because, as long as no other pages in the site are checking for the existence of session.loggedin they should display just fine. See above. Did you notice how my code looked for form variables to detect a login? There is no reason why your code couldn't do that. I'd have the popup simply output JavaScript code to 'push' the parent window to /lower, where /lower is the subdirectory of protected files. Note - you don't really need to use a whole other subdirectory. You could write your Application.cfm code so that the popups load. Well, that subdirectory will be further broken down by roles (if I understand roles correctly) so that a user will only be able to access subdirectories if their roles match, and if they don't they'll see an error message. EX: /lower/user1 where role=user1. I was going to use their role to limit them to access to only their directory. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: canadian database
God I love this list! On my way to work this morning I was wondering how I was going to source this very thing. Thanks! - Original Message - From: Erik Yowell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 1:41 PM Subject: RE: canadian database Perhaps this may suit your needs: http://www.zipinfo.com/products/zcg/zcg.htm Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com -Original Message- From: Carol Thomas [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 11:30 AM To: CF-Talk Subject: canadian database I am looking for an access database with longitude and latitude for a dealer locator for Canada. I have not been able to find anything in that I can use with cold fusion. At least nothing below $1800. I use access 2000, cf 4.0, windows nt 4.0 thanks in advance for any help. Carol ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Dropdown Question
-- Original Message -- From: Ciliotta, Mario [EMAIL PROTECTED] I was wondering if anyone has an example or maybe a custom tag that I could use that would allow me to have a dropdown box on a page that if the option for the user to select is not there then the user can type something in the field. I tried to leave a blank option out there but the blank option is selectable but not editable. I have tried to search on Developer Exchange but I cannot find any. I am sure there is one out there but I must be using the wrong search word. Try a search in the developer's exchange for combobox since that I believe is the term for what you're looking for. You'll get several hits for that, so maybe one will work for you. Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:42 AM To: CF-Talk Subject: Re: Application Security using cflogin and cfloginuser on 3/17/03 11:14 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Well, if it's user data like age, name, rank, etc, a struct seems to make more sense, but use whatever is best for you. Actually, a struct makes a LOT of sense, and I see what you're saying now. Why not just use one application.cfm in the root of your site? I think I came to this realization at about the same time you hit send on this email. So now, let me see if I understand this correctly. 1. Login.cfm will reside in the root and will take username and password 2. Login_process will ALSO reside in the root, and if the user successfully logs in, it sets a session, cfset session.LoggedIn=1 refreshes the parent window, then closes itself. 3. If not a success, then that page stays up and gives the user the opportunity to try again, or close the window. Once the user successfully logs in: Place a line of code on each page in that protected directory that will check for the existence of session.logged in, if not present, redirect to the index page of the root, which has a link to the login popup. no need to place this check in every page...that's what application.cfm is for. Doug This being safe because, as long as no other pages in the site are checking for the existence of session.loggedin they should display just fine. See above. Did you notice how my code looked for form variables to detect a login? There is no reason why your code couldn't do that. I'd have the popup simply output JavaScript code to 'push' the parent window to /lower, where /lower is the subdirectory of protected files. Note - you don't really need to use a whole other subdirectory. You could write your Application.cfm code so that the popups load. Well, that subdirectory will be further broken down by roles (if I understand roles correctly) so that a user will only be able to access subdirectories if their roles match, and if they don't they'll see an error message. EX: /lower/user1 where role=user1. I was going to use their role to limit them to access to only their directory. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Postal Code lookup / ZIP Code lookup
Paul: Thanks for this. Would have replied sooner but was away from the office. Also, FYI, found this on another thread this morning. http://www.zipinfo.com/ Best, David - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 2:44 PM Subject: Re: Postal Code lookup / ZIP Code lookup David, I've done it w/ US zipcodes but should be straightforward for Canada as well. The prerequisite is that you need a database that maps postal codes to latitude/longitude values. The US Census produces a free one every 10 years, and there are plenty of commercial ones. The code is all in this article (that I wrote :) http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci523000,00.html Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: David K [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 3:38 PM Subject: SOT: Postal Code lookup / ZIP Code lookup Hi List: Client wants a Dealer Locator widget that finds a dealer based on a Postal Code lookup / ZIP Code lookup. User would enter a Postal Code and the app would return the nearest dealer. Here's an example; http://www.ford.ca/focudl/default.asp?Language=EN I'm a bit stumped on the program logic required to do this. For example, if the user entered T9X-1P4 (an Alberta postal code) and the nearest dealer is in the V0B-2G0 (A British Columbia postal code) how could this be coded? Wondering if anyone has had any experience they would be willing to share. TIA. --David ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
1. Login.cfm will reside in the root and will take username and password 2. Login_process will ALSO reside in the root, and if the user successfully logs in, it sets a session, cfset session.LoggedIn=1 refreshes the parent window, then Correct, although I normally recommend using self-posting forms. It makes updates _much_ easier. closes itself. 3. If not a success, then that page stays up and gives the user the opportunity to try again, or close the window. Once the user successfully logs in: Place a line of code on each page in that protected directory that will check for the existence of session.logged in, if not present, redirect to the index page of the root, which has a link to the login popup. Ack! No. Again, look at my code. Notice how I use cfabort. This is what you would need to do. It is MUCH better to protect all files in application.cfm then add a check to each file. It is too easy to forget a file that way. This being safe because, as long as no other pages in the site are checking for the existence of session.loggedin they should display just fine. Or just don't do that. Check for getAuthUser() See above. Did you notice how my code looked for form variables to detect a login? There is no reason why your code couldn't do that. I'd have the popup simply output JavaScript code to 'push' the parent window to /lower, where /lower is the subdirectory of protected files. Note - you don't really need to use a whole other subdirectory. You could write your Application.cfm code so that the popups load. Well, that subdirectory will be further broken down by roles (if I understand roles correctly) so that a user will only be able to access subdirectories if their roles match, and if they don't they'll see an error message. Ah, then I'd use an application.cfm in each subfolder. Make it cfinclude the parent application.cfm. Then do a simple, if(isUserInRole(foo)) to protect the folder. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 11:49 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: no need to place this check in every page...that's what application.cfm is for. Doug Arrrgh...But I thought that any code in the application.cfm page was run when every page was requested. If I put that code in my application.cfm, and any page requests it, won't it redirect you to the index page, thereby making the whole SITE protected? Or are you saying to place that code in an application.cfm file in that LOWER directory? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: force a download - .txt file
This method forces the download, but names the file index.cfm instead of the actual filename that you are downloading. Anyone know how to name it properly? Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 5:18 PM To: CF-Talk Subject: Re: force a download - .txt file You could just do: CFHEADER NAME=content-disposition VALUE=attachment;filename=#YourFile# - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 4:57 PM Subject: Re: force a download - .txt file CFHEADER NAME=content-disposition VALUE=inline; filename=#YourFile# cfcontent type=unknown file=#AbsoluteFilePath# deleteFile=Yes ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 11:53 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Correct, although I normally recommend using self-posting forms. It makes updates _much_ easier. Self posting forms, like the type that DreamweaverMX makes? Once the user successfully logs in: Place a line of code on each page in that protected directory that will check for the existence of session.logged in, if not present, redirect to the index page of the root, which has a link to the login popup. Ack! No. Again, look at my code. Notice how I use cfabort. This is what you would need to do. It is MUCH better to protect all files in application.cfm then add a check to each file. It is too easy to forget a file that way. Ahh, so I'd use Application.cfm in the root to SET session variables, and an application.cfm in the lower directory to CHECK for and manage those session variables that are passed from application.cfm from above? This being safe because, as long as no other pages in the site are checking for the existence of session.loggedin they should display just fine. Or just don't do that. Check for getAuthUser() In that lower Application.cfm? The one that will manage the sessions and logins for that lower, protected directory? I think I'm starting to see it now. Well, that subdirectory will be further broken down by roles (if I understand roles correctly) so that a user will only be able to access subdirectories if their roles match, and if they don't they'll see an error message. Ah, then I'd use an application.cfm in each subfolder. Make it cfinclude the parent application.cfm. Then do a simple, if(isUserInRole(foo)) to protect the folder. Is this because, when a page is requested, once it FINDS an application.cfm it stops ALL looking for an application.cfm? So you place an application.cfm in the lower, individual directories and INCLUDE the Application.cfm from above? (in the root of the protected directory)? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Access SQL question
Hi: thanks, but it did not work. I tried to make changes to it for Access 2000 (tried ltrim for reverse, could not find function for charindex (tried locate, instr)) and could not get it to work. Any other trys? thanks Sandy Subject: Access SQL question From: Mahmut Basaran [EMAIL PROTECTED] Date: Sun, 16 Mar 2003 20:29:38 -0800 Thread: http://www.houseoffusion.com/cf_lists/index.cfm?method=messages; threadid=22424forumid=4#113155 This one works fine in sql server, but you need to test it with ms access. SELECT RIGHT(emailAddress, CHARINDEX('@', REVERSE(emailAddress))-1) AS [domainName] FROM dbo.customers GROUP BY RIGHT(emailAddress, CHARINDEX('@', REVERSE(emailAddress))-1) ORDER BY [domainName] - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 9:29 AM Subject: Access SQL question Hi all: I have an Access 2000 database with an email field in it. I would like to have an SQL query that gives me a count of the ISPs in the email field. For example: take the following records: 1. [EMAIL PROTECTED] 2. [EMAIL PROTECTED] 3. [EMAIL PROTECTED] 4. [EMAIL PROTECTED] 5. [EMAIL PROTECTED] I would like a query to give me: 1. aol.com 2 2. hotmail.com 3 I have tried many ways, but can't get it to work. any suggestions? thanks Sandy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clearing Cached Pages
Thanks Tony, Unfortunately, I am still on CF 5 Pro. I plan to upgrade in the near future to CFMX (guess I better accelerate my upgrade process). I can not ask the users to do a shift + refresh, because the fix was for a security issue, and There is no guarantee they would do it. This program also has a fairly large target audience Dave -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:22 AM To: CF-Talk Subject: RE: Clearing Cached Pages if the server is cfmx, then its not the users cache, its most likely cfmx. other than that, they could try shift + refresh that forces the browser to snag a live copy... ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:15 AM To: CF-Talk Subject: Clearing Cached Pages Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated Thanks Dave Sueltenfuss Application Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
depends...I know vague frustration going on here...but it does depend on how you set it up. I usually use a two dir system myself with a dir /login with its own application.cfm file that does no login check and an application.cfm file in my / dir that does the check for every file below / including sub-dirs, except for the /login dir of course. You can do it in one dir...just check for existence of session.login, or whatever you call it. If it doesn't exist, do the login thing, otherwise just continue. The important thing is to step back a minute or two and understand just how application.cfm works. Once you got htat under your belt, its cake dude. play around with some code you create and experiment, best way to learn this stuff IMHO. Doug -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:10 PM To: CF-Talk Subject: Re: Application Security using cflogin and cfloginuser on 3/17/03 11:49 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: no need to place this check in every page...that's what application.cfm is for. Doug Arrrgh...But I thought that any code in the application.cfm page was run when every page was requested. If I put that code in my application.cfm, and any page requests it, won't it redirect you to the index page, thereby making the whole SITE protected? Or are you saying to place that code in an application.cfm file in that LOWER directory? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
on 3/17/03 11:53 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Correct, although I normally recommend using self-posting forms. It makes updates _much_ easier. Self posting forms, like the type that DreamweaverMX makes? I wouldn't know - I use HomeSite+. Once the user successfully logs in: Place a line of code on each page in that protected directory that will check for the existence of session.logged in, if not present, redirect to the index page of the root, which has a link to the login popup. Ack! No. Again, look at my code. Notice how I use cfabort. This is what you would need to do. It is MUCH better to protect all files in application.cfm then add a check to each file. It is too easy to forget a file that way. Ahh, so I'd use Application.cfm in the root to SET session variables, and an application.cfm in the lower directory to CHECK for and manage those session variables that are passed from application.cfm from above? Well... it depends. In general, if you want to protect a set of pages, you would use application.cfm since it is run before any file in the folder. So, if you wanted to see if session.name = ray before allowing any file to run, you would do your check in application.cfm, not the sub pages. Does the distinction make sense? You CAN check in every file. However, if your logic is, Do X before any file in the folder is run, then it is better to use Application.cfm. This being safe because, as long as no other pages in the site are checking for the existence of session.loggedin they should display just fine. Or just don't do that. Check for getAuthUser() In that lower Application.cfm? The one that will manage the sessions and logins for that lower, protected directory? As soon as the cflogin block is run, getAuthUser will return a value IF you are logged in of course. I think I'm starting to see it now. Well, that subdirectory will be further broken down by roles (if I understand roles correctly) so that a user will only be able to access subdirectories if their roles match, and if they don't they'll see an error message. Ah, then I'd use an application.cfm in each subfolder. Make it cfinclude the parent application.cfm. Then do a simple, if(isUserInRole(foo)) to protect the folder. Is this because, when a page is requested, once it FINDS an application.cfm it stops ALL looking for an Correct. application.cfm? So you place an application.cfm in the lower, individual directories and INCLUDE the Application.cfm from above? (in the root of the protected directory)? Correct, becuase my 'core' Application.cfm will contain site-wide logic, but I have a specific need for this particular subfolder. So, unlike most Application.cfm files, you won't see a cfapplication tag in it. We aren't defining a new application, just some logic to run for one particular folder. Hope this makes sense. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 12:23 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: depends...I know vague frustration going on here...but it does depend on how you set it up. I usually use a two dir system myself with a dir /login with its own application.cfm file that does no login check and an application.cfm file in my / dir that does the check for every file below / including sub-dirs, except for the /login dir of course. You can do it in one dir...just check for existence of session.login, or whatever you call it. If it doesn't exist, do the login thing, otherwise just continue. The important thing is to step back a minute or two and understand just how application.cfm works. Once you got htat under your belt, its cake dude. play around with some code you create and experiment, best way to learn this stuff IMHO. Doug That's exactly what I'm doing. I've found that MOST of the tutorials online have great detail, but it's all CF5 detail and NOTHING I've seen online has details about how to utilize CFLOGIN and the new CF session management feature. I know that starting with MX, you don't have to lock things in the session scope, etc, and I'm looking to create something that's largely MX based, and I'm having a devil of a time finding anything useful online. I just recently finished Fast Track to coldfusion, which contained detailed information on the last chapter about cflogin, and stuff, but I'm doing it moderately different than the example in the class and I'm running into where do I stick my code questions, more than anything else. But I think I'm getting it. I was heading in the direction you just described above almost by myself. It seems like I'm about 5 minutes ahead of you guys and are seeming to have the same revelations at about the same time. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Forum System Recommendations
Thanks to those that replied. I'm researching the options you suggested. Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:05 AM To: CF-Talk Subject: Re: Forum System Recommendations Mosh, A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about $500) but doesn't have to be free. I checked out FuseTalk and the pricing is way too prohibitive. Can anyone make any other suggestions, preferably from personal experience? Talk to FuseTalk directly. Their teminology is a little weird and I suspect that what you actually need is very cheap ($250ish I believe), plus if its a NP/charitable organisation you might qualify for an educational discount. Regards Stephen CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Application Security using cflogin and cfloginuser
on 3/17/03 12:27 PM, Raymond Camden at [EMAIL PROTECTED] wrote: Correct, becuase my 'core' Application.cfm will contain site-wide logic, but I have a specific need for this particular subfolder. So, unlike most Application.cfm files, you won't see a cfapplication tag in it. We aren't defining a new application, just some logic to run for one particular folder. Hope this makes sense. It's starting to make perfect sense. If I have a subdirectory in the root that I want to protect, and I want code to run every time a page in that subdirectory is accessed, then I want to stick that code in an application.cfm. I can pass session information from the root application.cfm, to the lower application.cfm, so I can use the root application to process login information, and set the sessions, and use the lower application.cfm to check for the existence (getAuthUser()) of a logged in user and if that doesn't exist, then pass them back up to the index.cfm of the root directory... Am I heading in the right direction? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
Under normal circumstance, I'd cfinclude the file that contained the login form. When you cfinclude a cfm, you do NOT rerun the Application.cfm. In your case, it's a bit more complicated because you are launching a subwindow via javascript. I hate to say 'Add a hack', but in your case you kind of need to in order for the popup to work. I'd probably suggest, since this is kind of new to you, NOT doing a popup at first. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:10 AM To: CF-Talk Subject: Re: Application Security using cflogin and cfloginuser on 3/17/03 11:49 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: no need to place this check in every page...that's what application.cfm is for. Doug Arrrgh...But I thought that any code in the application.cfm page was run when every page was requested. If I put that code in my application.cfm, and any page requests it, won't it redirect you to the index page, thereby making the whole SITE protected? Or are you saying to place that code in an application.cfm file in that LOWER directory? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4