RE: Intermittent CFMX error - bug?
Brook, I have been encountering this same error. If you could post the offending code, and what you did to fix it, I would really appreciate it. I've been scratching my head for several weeks over this problem... Thanks, Mike Wolfe -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:29 PM To: CF-Talk Subject: Re: Intermittent CFMX error - bug? Please disregard my previous post - I may have found the answer and it IS a coding error NOT a MX bug of course :) Still tracking it down. sorry Brook ~| 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: rds error
This may be a shot in the dark but we recently saw this error when we had issues with the proxy server. Has anything on your network changed? Kola -Original Message- From: Heald, Tim [mailto:[EMAIL PROTECTED] Sent: 25 July 2003 16:53 To: CF-Talk Subject: rds error I am suddenly getting a 405 error when trying to browse my dev box with CF Studio 5 RDS. Anyone seen this? I checked and the servlet mapping is still in web.xml, and the path is what the mm site says it should be, only /cfide/main/ide.cfm doesn't exist. This is after installing updater 3 a few days ago. Any ideas? Timothy Heald Information Systems Specialist Overseas Security Advisory Council U.S. Department of State 571.345.2235 ~| 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: all caps in CF-Studio
That's the one - Thanks! Kola -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 17:50 To: CF-Talk Subject: RE: all caps in CF-Studio Options-setings-markup languages-lowercase all inserted tags ??? -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 17:48 To: CF-Talk Subject: RE: all caps in CF-Studio Hi Sorry to piggy back on someone else's thread but my question is slightly related. I can't find the setting which turns the automatic capitlization of tags off in CFstudio. Can anyone remember? Thanks Kola -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 17:18 To: CF-Talk Subject: Re: all caps in CF-Studio I was upset to see this excluded from DW. :( Or at least I never found the option... While I agree with you, there are DW extensions for this. Try: http://www.bellavite.com/web/dreamweaver.cfm Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.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 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: Dynamic CFMs timing out
Mike, For those search results pages you mentioned, any possibility that they could be written as static .html? Then you could either cffile action=read them Ah, excellent suggestion. I've just had a look at what gets outputted to the files and it is indeed nothing more than static HTML so your suggestion, if not solving the problem, will certainly speed up search results whatever happens! (1) Are your config filesable to run standalone, or at least in the bare essentials of your application's environment? (2) Does the user not need the config file the instant it is created? (3) Is the config file moderately permanent? In answer to these, yes, yes and yes. :) The config files are written the first time the user logs in to the site and are only updated/recreated if and when: A: the user modifies their profile B: an admin modifies the member profile C: for some reason the config files doesn't exist There would be no benefit in running a compilation script because as stated, the user requires the use of the config file immediately (well, the next page request) after it has been written. But thanks for the idea of the static search results -- should have spotted that one earlier! :) Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- 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 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: CFRETURN has incorrect documentation
Sean Speaking of docs... I'll mention it to the doc team and see if we can get that fixed for the online version of the Red Sky docs... Sean A Corfield -- http://www.corfield.org/blog/ Will there be a paper based version of the Red Sky docs? Kola ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cflogout bug??
Two things: 1) Are you 100% sure the old password and role stil doesn't exist in the db? 2) This does sound vaguely familiar. Are you running the most up to date updater? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) 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: PS Fong [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:39 PM To: CF-Talk Subject: cflogout bug?? Dear fellows, I have a problem using cflogin and wish if someone can help clear my blue... The scenario: I logged in as Admin and have change the admin role from 'user' to 'administrator'; change the old password to new password. After logout (using cflogout) and I try to login again with the old password, it still work (new password can login also), and the system will verify the Admin roles as 'user' although the database has kept the latest changes which is myrole='administrator'. here is the code in Application.cfm file: -- cfif IsDefined(Form.Logout) cflogout /cfif cflogin cfif NOT IsDefined(cflogin) cfinclude template=loginform.cfm cfabort cfelse cfif cflogin.name IS OR cflogin.password IS cfoutput H2You must enter text in both the User Name and Password fields/H2 /cfoutput cfinclude template=loginform.cfm cfabort cfelse ... run query ... cfif Query.myrole NEQ cfloginuser name=#cflogin.name# Password = #cflogin.password# roles=#Query.myrole# cfelse Error message cfinclude template=loginform.cfm cfabort /cfif /cfif /cfif /cflogin -- Help~! ~| 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: Project for a web-based document archival retrieval system
Hi, I have the opportunity to develop a web-based document archival retrieval system which would provide air, truck, rail, ocean carriers and third party logistics providers proof of delivery. Currently alot of system carriers provide proof of delivery through a paper filing system. I don't want to get in over my head. How difficult would it bee to put something like this together? Below are just some specs (Solution A B). Any thoughts on the points below would be greatly appreciated. I need to pick your brains! ;-D Thanks Uploading --- The POD is scanned using a high speed scanner. The scanned documents are now in a digital format. It is this format that we use on the website. Upload the documents using the upload form on the website. (note: the form should have the capability of uploading more than one image at a time.) Where on the website do these documents go? A specific folder? Do they need to be kept separate from the archived documents? Indexing -- Once the images are uploaded we need to assign search tags to the image. The search tags must be flexible enough so we can name the fields anything we want and enter any type of data. (eg make all entry fields alpha numeric) The standard search tags will be as indicated in the above numbered list. The search tags will consist of four fields. Viewing -- This section will enable the customer to search, view, print and email documents. We may need to establish several passwords for this section. Customers may wish to enable entry by several CSR's or even their customers. Searching As indicated earlier, there will be four criteria to search by. Therefore, we will need search functionality to use one, two, three or all fields for the search criteria. Additionally, each field should have the capability of entering wild cards to find like information. Viewing the results --- After the results of your search are displayed you may click on any one of the listed items to view the actual document image. Once the image is displayed we will need to have the capability to zoom and reduce the image at the click of a button as well as rotating the image may be helpful. A next and previous button will help to scroll through the other documents found in your search. A toolbar may be ideal for all this functionality. Printing and emailing -- The toolbar noted above should also include buttons for printing and one for emailing. These should allow the user to email or print the current document only. Management --- Develop a tool we can use to monitor the transactions so we can provide accurate billing. The transaction would be the number of new entries in the database by customer and or the number of new uploads by customer. We should be able to create a monthly report to create invoices from. ~| 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
Web Server Error 500 with Oracle 9i and ColdFusion MX
We are currently migrating from MS SQL-Server to Oracle 9i. So now the ColdFusion Pages sometimes(!) are coming with an Web Server Error 500 (Internal Server Error). On the same machine with SQL Server this error never occurs. It took me much time till now to find a solution for this problem - but I didn't find one. It might have to do with the ODBC-Connection using the Oracle Native Driver. Or there is something between ColdFusion MX, Oracle-ODBC and the WebServer which causes that error (as I already said: it occurs only sometimes, but it's too often). Who is also running Oracle 9i together with ColdFusion MX and knows how to make that combination run properly? Thanks in advance. Thomas ~| 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: Web Server Error 500 with Oracle 9i and ColdFusion MX
Most people seem to have better luck using the jdbc thin client driver. It might already be installed on your machine, or else you can get if from the Oracle website. - Original Message - From: Eppler Thomas (XHS 98) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:43 PM Subject: Web Server Error 500 with Oracle 9i and ColdFusion MX We are currently migrating from MS SQL-Server to Oracle 9i. So now the ColdFusion Pages sometimes(!) are coming with an Web Server Error 500 (Internal Server Error). On the same machine with SQL Server this error never occurs. ~| 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
CFMX .Net Remoting
All, Has anyone used .Net remoting with CFMX, and is it possible? If you have any experience can you pass on any helpfull tips for accessing and creating the objects TIA Jason Lees Development Team Leader National Express. ~| 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
DRK4 - pollster
oi CF-Talk,!! two issues. server 1: installed, run admin logged in fine, created a poll, but when it goes to show the poll on the left hand side of the page it goes for a bit (like it's retrieving data...) then shows: We are sorry. An Error occurred and the poll will not be able to continue. I have no clue what is wrong server 2: installed files. went to login to admin, but everytime I login to the challenge/response dialogit just keeps popping up like i have entered the wrong info. any ideas? Crit --- [This E-mail scanned for viruses by Declude Virus] ~| 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
Inserting flash into a CF page
I['m trying to insert a flash movie into a CF page, and I used the code I found on the Macromedia website, OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0WIDTH=550; HEIGHT=400 id=myMovieNamePARAM NAME=movie VALUE=myFlashMovie.swf PARAM NAME=quality VALUE=high PARAM NAME=bgcolor VALUE=#FF EMBED src=myFlashMovie.swf quality=high bgcolor=#FF WIDTH=550 HEIGHT=400 NAME=myMovieName ALIGN= TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/go/getflashplayer;/EMBED /OBJECT but I get this error: Invalid parser construct found on line 11 at position 95. ColdFusion was looking at the following text:XMP=/XMPInvalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (4:44) to (11:86). What is the correct code to embad a flash movie in a CF page? T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DRK4 - pollster
oi CF-Talk,!! two issues. server 1: installed, run admin logged in fine, created a poll, but when it goes to show the poll on the left hand side of the page it goes for a bit (like it's retrieving data...) then shows: We are sorry. An Error occurred and the poll will not be able to continue. I have no clue what is wrong server 2: installed files. went to login to admin, but everytime I login to the challenge/response dialogit just keeps popping up like i have entered the wrong info. any ideas? I don't have DRK4, but somebody posted here yesterday that several of the apps that come with DRK4 require Red Sky to work. Have you checked any of the Release Notes to see if the pollster is one of them? Regards, Dave. _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus ~| 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: Inserting flash into a CF page
Without double checking the code... My first thoughts are that this appears somewhere within a CFOUTPUT block so you need to double up all # to treat them as literal # instead of the beginning of a variable HTH -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 14:37 To: CF-Talk Subject: Inserting flash into a CF page I['m trying to insert a flash movie into a CF page, and I used the code I found on the Macromedia website, OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354codebase=http://downloa d.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0WIDTH =550 HEIGHT=400 id=myMovieNamePARAM NAME=movie VALUE=myFlashMovie.swf PARAM NAME=quality VALUE=high PARAM NAME=bgcolor VALUE=#FF EMBED src=myFlashMovie.swf quality=high bgcolor=#FF WIDTH=550 HEIGHT=400 NAME=myMovieName ALIGN= TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/go/getflashplayer;/EMBED /OBJECT but I get this error: Invalid parser construct found on line 11 at position 95. ColdFusion was looking at the following text:XMP=/XMPInvalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (4:44) to (11:86). What is the correct code to embad a flash movie in a CF page? T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| 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: Inserting flash into a CF page
It's probably within cfoutput tags so cf gets upset about the # in the color parameter replace #FF with White and all should be well - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:37 PM Subject: Inserting flash into a CF page I['m trying to insert a flash movie into a CF page, and I used the code I found on the Macromedia website, OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354codebase=http://downloa d.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0WIDTH =550 HEIGHT=400 id=myMovieNamePARAM NAME=movie VALUE=myFlashMovie.swf PARAM NAME=quality VALUE=high PARAM NAME=bgcolor VALUE=#FF EMBED src=myFlashMovie.swf quality=high bgcolor=#FF WIDTH=550 HEIGHT=400 NAME=myMovieName ALIGN= TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/go/getflashplayer;/EMBED /OBJECT but I get this error: Invalid parser construct found on line 11 at position 95. ColdFusion was looking at the following text:XMP=/XMPInvalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (4:44) to (11:86). What is the correct code to embad a flash movie in a CF page? T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| 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: Inserting flash into a CF page
Are you using Dreamweaver? If so, you can easily insert a swf into the page using Insert--Media---Flash object classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0; width=682 height=158 param name=movie value=testing.swf param name=quality value=high embed src=testing.swf quality=high pluginspage=http://www.macromedia.com/go/getflashplayer; type=application/x-shockwave-flash width=682 height=158/embed /object Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [EMAIL PROTECTED] 7/29/2003 9:37:15 AM I['m trying to insert a flash movie into a CF page, and I used the code I found on the Macromedia website, OBJECT classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0WIDTH=550; HEIGHT=400 id=myMovieNamePARAM NAME=movie VALUE=myFlashMovie.swf PARAM NAME=quality VALUE=high PARAM NAME=bgcolor VALUE=#FF EMBED src=myFlashMovie.swf quality=high bgcolor=#FF WIDTH=550 HEIGHT=400 NAME=myMovieName ALIGN= TYPE=application/x-shockwave-flash PLUGINSPAGE=http://www.macromedia.com/go/getflashplayer;/EMBED /OBJECT but I get this error: Invalid parser construct found on line 11 at position 95. ColdFusion was looking at the following text:XMP=/XMPInvalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was static text occupying document position (4:44) to (11:86). What is the correct code to embad a flash movie in a CF page? T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| 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: DRK4 - pollster
oi Dave!! doesn't seem to be RS specific... only on *nix systems due toe filename case.. Tuesday, July 29, 2003, 9:34:20 AM, you wrote: oi CF-Talk,!! two issues. server 1: installed, run admin logged in fine, created a poll, but when it goes to show the poll on the left hand side of the page it goes for a bit (like it's retrieving data...) then shows: We are sorry. An Error occurred and the poll will not be able to continue. I have no clue what is wrong server 2: installed files. went to login to admin, but everytime I login to the challenge/response dialogit just keeps popping up like i have entered the wrong info. any ideas? DC I don't have DRK4, but somebody posted here yesterday that several of the DC apps that come with DRK4 require Red Sky to work. Have you checked any of DC the Release Notes to see if the pollster is one of them? DC Regards, DC Dave. DC _ DC MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. DC http://join.msn.com/?page=features/virus DC ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Non blocking custom tag?
Say I have a custom tag called CF_doSomething. The tag takes 3 seconds to run. Is there some way to tell ColdFusion to run it in a nonblocking mode so the user doesn't have to wait for the 3 seconds? I don't want to use CFHTTP to create another page. It would be nice to say something like CF_doSomething timeout=0 and have it just work. -Jon ~| 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
Project for a web-based document archival retrieval system
Very doable. Functionally, why do you need Printing and Emailing since they are built-in with IE and Netscape browsers already? What DBMS do you have in mind? DL http://68.32.61.40/datadata/dataman.cfm Hi, I have the opportunity to develop a web-based document archival retrieval system which would provide air, truck, rail, ocean carriers and third party logistics providers proof of delivery. Currently alot of system carriers provide proof of delivery through a paper filing system. I don't want to get in over my head. How difficult would it bee to put something like this together? Below are just some specs (Solution A B). Any thoughts on the points below would be greatly appreciated. I need to pick your brains! ;-D Thanks Uploading --- The POD is scanned using a high speed scanner. The scanned documents are now in a digital format. It is this format that we use on the website. Upload the documents using the upload form on the website. (note: the form should have the capability of uploading more than one image at a time.) Where on the website do these documents go? A specific folder? Do they need to be kept separate from the archived documents? Indexing -- Once the images are uploaded we need to assign search tags to the image. The search tags must be flexible enough so we can name the fields anything we want and enter any type of data. (eg make all entry fields alpha numeric) The standard search tags will be as indicated in the above numbered list. The search tags will consist of four fields. Viewing -- This section will enable the customer to search, view, print and email documents. We may need to establish several passwords for this section. Customers may wish to enable entry by several CSR's or even their customers. Searching As indicated earlier, there will be four criteria to search by. Therefore, we will need search functionality to use one, two, three or all fields for the search criteria. Additionally, each field should have the capability of entering wild cards to find like information. Viewing the results --- After the results of your search are displayed you may click on any one of the listed items to view the actual document image. Once the image is displayed we will need to have the capability to zoom and reduce the image at the click of a button as well as rotating the image may be helpful. A next and previous button will help to scroll through the other documents found in your search. A toolbar may be ideal for all this functionality. Printing and emailing -- The toolbar noted above should also include buttons for printing and one for emailing. These should allow the user to email or print the current document only. Management --- Develop a tool we can use to monitor the transactions so we can provide accurate billing. The transaction would be the number of new entries in the database by customer and or the number of new uploads by customer. We should be able to create a monthly report to create invoices from. ~| 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: DRK4 - pollster
- Original Message - From: Critz [EMAIL PROTECTED] server 2: installed files. went to login to admin, but everytime I login to the challenge/response dialogit just keeps popping up like i have entered the wrong info. any ideas? What browser / OS are you using? Make sure that you use an absolute path to specify the Flash Remoting gateway (which is set in the Application.cfm) file. Does that help? mike chambers [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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Attention Regex guru's
I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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
wikipedia
A Perl-writing friend is obsessed over his personal wikipedia. He gave me many links about downloading and running a perl wiki knowledge base, but it would be so much easier to run a CF one. Couldn't find one on the Exchange. Does anyone here know of a freeware knowledge base in CF? Don ~| 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: Attention Regex guru's
ReFindNoCase(img [^]*src=[']?##imagefilename##[^]*,yourString) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: dinsdag 29 juli 2003 19:28 To: CF-Talk Subject: Attention Regex guru's I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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: DRK4 - pollster
On Tuesday, July 29, 2003, at 09:06 AM, Critz wrote: server 1: installed, run admin logged in fine, created a poll, but when it goes to show the poll on the left hand side of the page it goes for a bit (like it's retrieving data...) then shows: We are sorry. An Error occurred and the poll will not be able to continue. I have no clue what is wrong Pollster uses Flash Remoting to communicate between the client and the server, so check your flash.log log file (in the same directory as the rest of your log files).You may have a more meaningful error message there. If there's nothing in the flash.log file, perhaps Flash Remoting isn't working at all on your server. Have you used Flash Remoting since Updater 3? I seem to remember Updater 3 turning Flash Remoting off by default, at least for the J2EE version of CFMX. server 2: installed files. went to login to admin, but everytime I login to the challenge/response dialogit just keeps popping up like i have entered the wrong info. any ideas? What client/server? Do you have cookies enabled? The admin interface just uses simple HTTP authentication, so if HTTP authentication works with other sites (does it?), then it should work with Pollster. Raymod Camden uncovered some issues with Pollster on IIS yesterday because of the way IIS works (or doesn't work) with HTTP authentication, so you might want to dig that up from the archives and see if that helps. Let me know if you're still having problems. We'll get it worked out. Christian ~| 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: DRK4 - pollster
Have you used Flash Remoting since Updater 3? I seem to remember Updater 3 turning Flash Remoting off by default, at least for the J2EE version of CFMX. Yes, check ID 49829 here: http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx _updater01.html Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.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: Attention Regex guru's
This gives it a try. I haven't thought out all the things that might make it break. cfset str=dkl gljk img slkgaj ljk img border=0 src=jj.gif title= sklgj jl img src=jj.gif border=0 slgkj img src=jjj.gifsldk jgljks d cfset imgfilename=jj.gif cfset bb=rereplacenocase(str,img[^]+src=*#imgfilename#*[^]*,IMG,ALL) hr cfoutput#str#/cfoutput hr cfoutput#bb#/cfoutput hr Jerry Johnson [EMAIL PROTECTED] 07/29/03 01:28PM I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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
SOT: DB Design
I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Attention Regex guru's
The previous response is much better (since I read your question partly wrong) It only allows 0 or 1 quotes after src= (mine allowed for more for no good reason) It looks for the #imgfilename# string (mine looked for an actual filename set by imgfilename) It doesn't bother finding the quotes after the src= (since it is not important) Jerry Johnson [EMAIL PROTECTED] 07/29/03 10:44AM snip Jerry Johnson [EMAIL PROTECTED] 07/29/03 01:28PM I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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: DB Design
Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: wikipedia
http://www.seedwiki.com http://www.seedwiki.com/page.cfm?doc=theseedwikibookwikiid=90 Requires SQL Server, as the installation is a detached SQL databse, and all data access is done through stored procedures. I've corresponded with the author on many occasions - he's very good at anyswering email, and very good at implementing feature requests and bug fixes. -d ~| 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: DRK4 - pollster
On Tuesday, July 29, 2003, at 10:42 AM, Massimo Foti wrote: Have you used Flash Remoting since Updater 3? I seem to remember Updater 3 turning Flash Remoting off by default, at least for the J2EE version of CFMX. Yes, check ID 49829 here: http://www.macromedia.com/support/coldfusion/releasenotes/mx/ releasenotes_mx _updater01.html I should have checked before posting. Thanks, Massimo. Only webservices through Flash Remoting are disabled, not Flash Remoting in its entirety. Christian ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
id love to know the outcome of this onesince we use Identity PK's like they are going out of style :) tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
I find the main reason for using identity PKs is that the urls generated are much shorter and easier for the user, especially if they have to type them in from a printed url... eg: http://www.mydomain.com/index.cfm?id=12345 or http://www.mydomain.com/index.cfm?id=E5460D40-2163-4C10-95EC-A4ADB319A126 Alex -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 15:56 To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB ~| 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: DB Design
I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
Yup I agree Ian - but sometimes I am a little uneasy about using a combination of character fields to uniquely define a record. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:12 To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
For me, I always use a natural PK if possible... where it trips me up is when there is a natural Composite Key I've found that using natural (composite) keys tends to bite you in the ass at a later date. All your query look ups become difficult, your URL's end up being massive You are passing loads of values between things Plus I have wrote a lot of UDF's that work on a identity PK to create SQL, create Forms, populate with Values, make a content management system behave in generic way (ie all elements had a identity PK that standardised the way to access the 20 plus elements that the user could use) What harm can a identity PK do in these cases to replace a Natural Composite key? But then again, I aint a DBA l've had a few arguments with the DBA's over this and no-one can come up with the definitive answer... other than that the data is not fully normalised at the point of adding in the (extra) identity PK rather than using a composite natural key I reckon that argument is for the purists tho g -Original Message- From: Ian Skinner Sent: 29 July 2003 16:12 To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DB Design
here are a few things to ponder identity is not a SQL standard (SQL-92 -- not sql server) identity does not exist in Oracle, sybase, informix, db2, or any other large db platform. identity breaks one of the 4 basic rules of a relational db --you cannot update the unique and independent keys --can't update an identity column I just have to take the next value in line also, there are problems with replication using Identities... there are work-arounds, but they are a pain Just a few things I have come across from different people. Mike - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:05 AM Subject: RE: DB Design id love to know the outcome of this onesince we use Identity PK's like they are going out of style :) tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
Typing them into code for testing. Knowing when to use the brackets and when not to. Easily indentifying them. Typing them into query analyzer. The list goes on DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
why tho? isnt an integer field much easier to index, search on, quicker? I mean its just such a thin way to work...if I had to search on an email field, that wouldn't be very efficient would it? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:12 AM To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: OT: Hurricane in Houston?
Just to play devil advocate. We're not mixing up a hurricane with a tornado are we? Especially since hurricanes can generate tornados, if one didn't occur on it's own. Just a possibility? -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 1:18 AM To: CF-Talk Subject: Re: OT: Hurricane in Houston? It's BOGUS. The hurricane didn't hit Texas til TUESDAY the 15th. If a DEADLINE was for the 13th, that means they had to have completed what they were to do TWO DAYS before the hurricane hit. FROM NASA: http://www.gsfc.nasa.gov/topstory/2003/0715claudette.html Category 1 Hurricane Claudette, the first Atlantic hurricane of 2003, made landfall on the middle of the Texas coast midday Tuesday, according to the National Hurricane Center. With maximum winds still at 80 mph, the NHC predicts five to eight inches of rain will fall due to Claudette. These images from the Moderate-resolution Imaging Spectroradiometer (MODIS) aboard the Terra satellite capture the eye just passing over the coastline at 1:00 PM EDT today, July 15, 2003. Credit: Image courtesy Courtesy NASA and Space Science and Engineering Center, University of Wisconsin-Madison En At 01:48 AM 7/28/03, you wrote: Sorry to take up bandwidth on non-technical issues, but it does relate to ColdFusion services and development in an obtuse kind of way ... A supplier of services has claimed that the reason they didn't meet a deadline on Sunday 13 July was because there was a severe hurricane in Houston TX and damaged their datacenter, so they didn't have access to their server equipment for two days. Can anyone verify (or otherwise) that there was a hurricane in the Houston area that day please? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| 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: DB Design
The debate on primary keys is a long long long one. Some arguments are a) you shouldn't add columns to a table that are meaningless So why do you need a UserID column when you could use Username But what happens if a user changes his username,? you going to update all relation tables? b) using a auto ID in a db, means you are stuck with that db. (tightly coupled) This is a far argument in general. Many J2ee applications specify a DB independent key generating class. The method for generating this id is also source of many differing options, including : 1) use a UUID 2) use a table like objectname | nextid customers | 12003 order | 50031 So you go get me the next customer id... 3) use high/low key generator http://castor.exolab.org/key-generator.html 4) use a mixture. B-4 is pretty good mention in my opinion, and which what I generally us in j2ee/Jboss, for example. Sometime in CF I just delegate this task to the DB. After that there are other issues such as the speed of indexing and searching by primary key, but these depend on DB server and datatypes... E.g. a int field lookup might be quicker than a varchar lookup.. A lot of people have opinions on this. Your best course of action is to know what the arguments are make your own choices for your app. A good place to find the discussions are in the Java/J2ee community, especially around the various persistance layers (CMP, castor, JDO and other Object-Relational mapping layers e.g. http://www.agiledata.org) due to their requirements of being DB independent. Some OO knowledge is helpful. my 2 cents. WG -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 15:48 To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
Not that I disagree with you, but I would like to here what makes you uneasy about using character fields to define a record. I'm a fairly novice DBA, and I would really like to strengthen my understanding of best practices. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:21 AM To: CF-Talk Subject: RE: DB Design Yup I agree Ian - but sometimes I am a little uneasy about using a combination of character fields to uniquely define a record. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:12 To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: SOT: DB Design
Michael T. Tangorre wrote: Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? I have a preference for trigger/sequence based mechanisms. They are more flexible in generating unique number primary keys and sequences will be in SQL:200x. On the other hand, I don't think identity primary keys are evil per se. It just depends on how you use them. 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: ColdFusion on Linux
Are there any issues using a MS Access DB with ColdFusion on a Linux box? David K. ~| 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
calling an xml file within flash
Greetings, I am calling an xml file inside a flash movie and embeding it within a htm page, I am doing a simple output to text field. This works fine, but when I save it as a cfm page the xml content does not load into the field, the embedded code is, object codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.ca b#version=4,0,2,0 width=748 height=304 style=z-index:0; classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 param name=movie value=http://devserver/websites/AndronicsLTD/flash/mainStage.swf; param name=quality value=high embed src=http://devserver/websites/AndronicsLTD/flash/mainStage.swf; quality=high pluginspage=http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_ Version=ShockwaveFlash type=application/x-shockwave-flash width=748 height=304/embed /object and the action script which loads the xml file is, //creat a xml object thisXML = new XML(); thisXML.ignoreWhite = true; thisXML.onLoad = LoadXMLvariables; thisXML.load(newsItems.xml); any ideas out there, j ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Attention Regex guru's
Don't forget to adjust it slightly to take account of leading whitespace between the opening tag and img. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 15:53 To: CF-Talk Subject: Re: Attention Regex guru's The previous response is much better (since I read your question partly wrong) It only allows 0 or 1 quotes after src= (mine allowed for more for no good reason) It looks for the #imgfilename# string (mine looked for an actual filename set by imgfilename) It doesn't bother finding the quotes after the src= (since it is not important) Jerry Johnson [EMAIL PROTECTED] 07/29/03 10:44AM snip Jerry Johnson [EMAIL PROTECTED] 07/29/03 01:28PM I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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: DB Design
I'm not sure, I'm trying to get a better understanding of this myself. But It's my current understanding that if an email field (other other text field) is designated as the KEY, then it will be fully indexed. meaning that the database can find an value very quickly. I would like to know more about how this works if anybody would care to share. I would also like to know more about creating other indexes in a table. When you would want too? What are the benefits? Best practices? ect? -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:15 AM To: CF-Talk Subject: RE: DB Design why tho? isnt an integer field much easier to index, search on, quicker? I mean its just such a thin way to work...if I had to search on an email field, that wouldn't be very efficient would it? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:12 AM To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: DB Design
Been waiting to hear what you had to say on this Jochem :-) Any pointers for where you WOULDN'T use them? i would tend to use them to replace natural composite keys... is this an evil? -Original Message- From: Jochem van Dieten Sent: 29 July 2003 16:29 To: CF-Talk Subject: Re: DB Design Michael T. Tangorre wrote: Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? I have a preference for trigger/sequence based mechanisms. They are more flexible in generating unique number primary keys and sequences will be in SQL:200x. On the other hand, I don't think identity primary keys are evil per se. It just depends on how you use them. 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 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: DB Design
IDENTITY INSERT ON IDENTITY INSERT OFF That's always let me get around what few problems I've had dealing with systems using identity PK's. Sometimes not ideal, sometimes a couple extra steps do get what you need to get done. I've always looked at identity as an auto sequence generator, and use the above commands to turn the sequence on and off as needed. Now, IMHO, an application should never need to break a sequence. I've never seen a rational reason why it should happen in an application (which is the scope of this forum?). As a sql dba, I have several easy means of breaking that identity / auto-sequence to migrate, reinstate, or repair a data problem. In the end, I make the effort to do what is easiest for the developers, and in most of our projects (10-30 tables with not more than 10k records expected) I use identity FK's, a few apps I insist otherwise, but if I use a GUID PK its only for binding the PK to FK constraints uniquely. _Most importantly_, I still include an identity not in the key as a row counter in addition to the GUID. Typically, in your app code, it's just easier to deal with a logical sequence in a result set. $0.02 Trey Rouse Data Application Architect Web Services - Rice University -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:16 AM To: CF-Talk Subject: Re: DB Design here are a few things to ponder identity is not a SQL standard (SQL-92 -- not sql server) identity does not exist in Oracle, sybase, informix, db2, or any other large db platform. identity breaks one of the 4 basic rules of a relational db --you cannot update the unique and independent keys --can't update an identity column I just have to take the next value in line also, there are problems with replication using Identities... there are work-arounds, but they are a pain Just a few things I have come across from different people. Mike - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:05 AM Subject: RE: DB Design id love to know the outcome of this onesince we use Identity PK's like they are going out of style :) tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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
cfc's and application design help
i am looking for some advice/best practice about using cfc's in an application. I have just finished creating my first cfc application. I have found that they work pretty well despite some of their drawbacks. The advice/help I am seeking is that this application is quite usefull and would like to add it to some other applications that I currently have. What would be the best way of doing this? What I was thinking was that I would create a wrapper cfc hidding all the complex stuff with a simple public api and that the wrapper would take care of all the controll/flow of the application. I think that this would hold fairly close to MVC with the application cfc's being the model, the wrapper cfc being the controller and the application calling the cfc being the view. How have others accomplished this? Or am I missing some fundamental design problem? tia, jason __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The death of a session variable?
This is an odd one. We're running CFMX on top of JRun on a Solaris 9 server, all of the most recent patches, server upgrades, software updaters, etc., applied. Our application makes heavy use of session variables to track our users. Recently, we've discovered that if someone logs in to our website in IE, then goes ahead and clears out their cache and cookies while logged in, they will never again be able to log in to our website. I'm pretty sure that this has something to do with the way that we use our session variables to track students, but I'm not sure. I've tried looking at the error logs for Apache, for JRun, and for Cold Fusion but I can't find any error messages that seem related to this issue. If anyone has any ideas, please let me know. Richard ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Attention Regex guru's
that wont replace the following occurence img src=somwhere/images/image.gif alt=im alt text width=100 height=100 - Original Message - From: Pascal Peters [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:38 AM Subject: RE: Attention Regex guru's ReFindNoCase(img [^]*src=[']?##imagefilename##[^]*,yourString) -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: dinsdag 29 juli 2003 19:28 To: CF-Talk Subject: Attention Regex guru's I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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: DB Design
At 16 bytes a pop, they are one of the largest datatypes in SQL Server. Indexes built on GUIDs are going to be larger and slower than indexes built on IDENTITY columns, which are usually ints (4 bytes). But SQL server is very fast and would you really notice the performance hit? I remember reading somewhere that the performance hit does not become that noticeable until close to a terabyte of data keeping in mind a terabyte is 2 to the 40th power or approximately a thousand billion bytes (that is, a thousand gigabytes). I am no DBA and no SQL tuning expert, I just thought it would be an informative topic of conversation as I try and piece together mountains of information I am taking in on the topic. I personally use UUIDs/GUIDs over identities... Mike - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:15 AM Subject: RE: DB Design why tho? isnt an integer field much easier to index, search on, quicker? I mean its just such a thin way to work...if I had to search on an email field, that wouldn't be very efficient would it? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:12 AM To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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: SOT: ColdFusion on Linux
David K wrote: Are there any issues using a MS Access DB with ColdFusion on a Linux box? Think you'd need to dig out a JDBC driver to access it. In my brief search I discovered that these generally cost money. As it was only going to be for a temporary measure I didn't bother, and just used MySQL as usual. David K. ~| 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
Tonight is the first meeting for the West Virginia Macromedia Users Group!
All: This is just a reminder that tonight is the first meeting of the West Virginia Macromedia Users Group (WVMUG). 6:30-8:30pm Kanawha County Public Library 123 Capitol Street, Charleston, WV 3rd Floor - John V. Ray Room (across from the elevator) Doors open at 6pm. The meeting will be starting at 6:30 sharp! If you are interested in web design and development, you will find the group of interest to you. Our speakers tonight are John Cummings of Macromedia and Neil Ross of Automation Creations. Both will be speaking about CFMX. You can find out more by going to: http://www.wvmug.org There will be pop, water, veggie and cheese/cold cut trays for attendees. If you are attending tonight's meeting, I would appreciate an e-mail confirming you are coming. Sincerely, Brian Meloche, 4th Floor, ITO - 414 CSS (304) 759-0585 x448 Macromedia Certified Advanced ColdFusion 5.0 Developer 130 pounds lost and counting! ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfc's and application design help
Have you looked at mach-ii? take a peak... www.mach-ii.com Mike - Original Message - From: Jason Wagstaff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:37 AM Subject: cfc's and application design help i am looking for some advice/best practice about using cfc's in an application. I have just finished creating my first cfc application. I have found that they work pretty well despite some of their drawbacks. The advice/help I am seeking is that this application is quite usefull and would like to add it to some other applications that I currently have. What would be the best way of doing this? What I was thinking was that I would create a wrapper cfc hidding all the complex stuff with a simple public api and that the wrapper would take care of all the controll/flow of the application. I think that this would hold fairly close to MVC with the application cfc's being the model, the wrapper cfc being the controller and the application calling the cfc being the view. How have others accomplished this? Or am I missing some fundamental design problem? tia, jason __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.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: DB Design
Ian, For example for users, you might use e-mail, for employees you might use SSN, ect. Would you use a users email as a foreign key? What do you do if someone changes their email address? WG ~| 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: DB Design
Ian Skinner wrote: I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. The problem is finding fields that qualify as natural keys. In the end, probably the only fields that qualify are somebody elses artificial ID fields that identify the exact same entity as you wish to identify. Fields that may appear safe at first sight can burn your database model when they turn out not to be safe. For instance, email addresses, chamber-of-commerce registration numbers, bank account numbers etc change hands when a company is being taken over or broken up. An email address identifies a mailbox, not a person. What happens if the domain expires accidentally? http://www.cyberangels.nl/ A SSN might qualify to identify a person, but depending on how how they are issued they can also refer to an underaged child (depends on country). An IRS identification number might actually refer to both a company and its subsidiaries (at least with the Dutch IRS or Belastingdienst). Using artificial ID fields is a convenient way to bypass the problem of identifying the fields that qualify as natural keys. 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
RE: DB Design
yeah, that's what im saying, using something that could change as the relater (if that's a word) is kinda scary, which is why we always use identity fields as our pk, because you always have a nice thin number that lends it self to seeking/sorting/searching faster...arent servers/computers all 1's and 0's, and wouldn't you imagine that int fields are all stored in binary anyway (low-level) so searches made on those numbers would be exponentially faster? tw tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:51 AM To: CF-Talk Subject: RE: DB Design Ian, For example for users, you might use e-mail, for employees you might use SSN, ect. Would you use a users email as a foreign key? What do you do if someone changes their email address? WG ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
well I reckon it's always more robust I feel to join tables on numeric datatypes as opposed to strings. As for genreal indexing - this is a world of fun. You need to balance off the positives you gain from indexing (quicker selects etc) to the disadvantages (slower inserts/updates/deletes). As for selects experiment as to what combination of fields gives you the quickest response. SQL Server chooses which index to use based on your select statement as opposed to older db's where you actually manually selected the index. A good point to start would be to index on the columns you use in your where clause in the order they appear - add/remove them until you get optimal performance. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:20 To: CF-Talk Subject: RE: DB Design Not that I disagree with you, but I would like to here what makes you uneasy about using character fields to define a record. I'm a fairly novice DBA, and I would really like to strengthen my understanding of best practices. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:21 AM To: CF-Talk Subject: RE: DB Design Yup I agree Ian - but sometimes I am a little uneasy about using a combination of character fields to uniquely define a record. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:12 To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
billion was RE: DB Design
thousand billion bytes Note a billion in the US and EU are different. A billion is 1,000,000,000 US and 1,000,000,000,000 in the EU. Better off with 10^9 and 10^12 to avoid confusion :-) You know that NASA and the Russia Space angency had a joint project together where the US was using inches and russians used CM ? Hoston we have a problem. Lol. WG ~| 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: DB Design
You would change the address in the appropriate record. If it is a foreign key, and the DB is designed to CASCADE UPDATE then tables linked to the primary table will change also change. This is apparently a reason purists say one shouldn't use identities is so that you can change the value of the key when necessary. Don't know enough to argue the pros and cons, would like to learn more about it myself. But I know it's possible. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:51 AM To: CF-Talk Subject: RE: DB Design Ian, For example for users, you might use e-mail, for employees you might use SSN, ect. Would you use a users email as a foreign key? What do you do if someone changes their email address? WG ~| 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: ColdFusion on Linux
BTW, we're talking CF version 5 on this... - Original Message - From: David K [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:30 AM Subject: SOT: ColdFusion on Linux Are there any issues using a MS Access DB with ColdFusion on a Linux box? David K. ~| 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: Attention Regex guru's
mail must be wiggin out again... i havent seen another response from jerry... ok I dont think i explained it too well... basically we made the mistake that alot of people have, giving a client a textarea in an admin tool to edit the main body of a certain page. Now we also gave a pretty descent dynamic image placement feature so they can place an image where ever they want in the body. Well, they decided (for some reason or another) to not use the image placement tool and put in their own image tags. This all works fine as long as the put it in right until... they go into the image management tools and delete an image they have put in manually. THen they are left with a broken image unless they go to that admin tool as well and remove the no longer valid image tag. so... what im trying to do is this... when they go to the image manger tool for say the news section... and delete an image I want to search the news table's body content filed and remove any image tag that has the image that is being deleted in it so i might be looking for img src=somwhere/images/image.gif alt=im alt text width=100 height=100 or img src=image.gif or img src=http://site.com/images/image.gif; alt=im alt text width=100 height=100 or as Kola pointed out.. img src=somwhere/images/image.gif alt=im alt text width=100 height=100 all of these may or may not have double quotes or single quotes the only thing known for certain going in is that it is going to START with a CONTAIN somewhere within a img and the name of the image image.gif END with a so i need to match (somehow) + possibletext + img + possibletextandslashes + #imagename# + more possibletext + hope this all makes sense : ) - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:52 AM Subject: Re: Attention Regex guru's The previous response is much better (since I read your question partly wrong) It only allows 0 or 1 quotes after src= (mine allowed for more for no good reason) It looks for the #imgfilename# string (mine looked for an actual filename set by imgfilename) It doesn't bother finding the quotes after the src= (since it is not important) Jerry Johnson [EMAIL PROTECTED] 07/29/03 10:44AM snip Jerry Johnson [EMAIL PROTECTED] 07/29/03 01:28PM I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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: billion was RE: DB Design
This might be a stupid question, but why is it different from the us to the eu? I know that there's different units of measure, but counting I thought was consisitent... What's the equivalent of a (US) billion in EU? Scott -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:00 PM To: CF-Talk Subject: billion was RE: DB Design thousand billion bytes Note a billion in the US and EU are different. A billion is 1,000,000,000 US and 1,000,000,000,000 in the EU. Better off with 10^9 and 10^12 to avoid confusion :-) You know that NASA and the Russia Space angency had a joint project together where the US was using inches and russians used CM ? Hoston we have a problem. Lol. WG ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: billion was RE: DB Design
Drifting even more off topic. YUP, that's why a recent mars probe was lost. One agency was using English(American) measurements and another was using Metric measurements. And in the confusion the multi-hundreds million dollar research probe burned up in the mars atmosphere. OPS -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 9:00 AM To: CF-Talk Subject: billion was RE: DB Design thousand billion bytes Note a billion in the US and EU are different. A billion is 1,000,000,000 US and 1,000,000,000,000 in the EU. Better off with 10^9 and 10^12 to avoid confusion :-) You know that NASA and the Russia Space angency had a joint project together where the US was using inches and russians used CM ? Hoston we have a problem. Lol. WG ~| 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: billion was RE: DB Design
not speaking of dollars or euros is there a difference between the two 1 billion = 1,000,000,000 1 million = 1,000,000 1 hundred thousand = 100,000 1 thousand = 1,000 whats the difference? not monetary, just numerically? 1 bullion = what we have a lot of in fort knox? help...ive forgotten everything from 3rd grade tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:00 PM To: CF-Talk Subject: RE: billion was RE: DB Design This might be a stupid question, but why is it different from the us to the eu? I know that there's different units of measure, but counting I thought was consisitent... What's the equivalent of a (US) billion in EU? Scott -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:00 PM To: CF-Talk Subject: billion was RE: DB Design thousand billion bytes Note a billion in the US and EU are different. A billion is 1,000,000,000 US and 1,000,000,000,000 in the EU. Better off with 10^9 and 10^12 to avoid confusion :-) You know that NASA and the Russia Space angency had a joint project together where the US was using inches and russians used CM ? Hoston we have a problem. Lol. WG ~| 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: DB Design
David Collie (itndac) wrote: Been waiting to hear what you had to say on this Jochem :-) Any pointers for where you WOULDN'T use them? When you can easily identify a good alternative, when using replication and when you want multiple tables to have primary keys that don't overlap (inheritance). i would tend to use them to replace natural composite keys... is this an evil? No. 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
RE: billion was RE: DB Design
Not an expert but I know the difference exists. It's mostly cultural I believe. In America, we change the name of a number every three digits. 1,000 = thousands 1,000,000 = millions 1,000,000,000 = billions 1,000,000,000,000 = trillions In England, they used to take a different look (the American version is apparently spreading, yet another cultural export of ours. 1,000 = thousands 1,000 * 1,000 = 1,000,000 = millions 1,000,000 * 1,000,000 = 1,000,000,000,000 = billions So, the US deficit is really huge to the over the pond audience. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 9:00 AM To: CF-Talk Subject: RE: billion was RE: DB Design This might be a stupid question, but why is it different from the us to the eu? I know that there's different units of measure, but counting I thought was consisitent... What's the equivalent of a (US) billion in EU? Scott -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:00 PM To: CF-Talk Subject: billion was RE: DB Design thousand billion bytes Note a billion in the US and EU are different. A billion is 1,000,000,000 US and 1,000,000,000,000 in the EU. Better off with 10^9 and 10^12 to avoid confusion :-) You know that NASA and the Russia Space angency had a joint project together where the US was using inches and russians used CM ? Hoston we have a problem. Lol. WG ~| 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: Attention Regex guru's
cfset str=dkl gljk img slkgaj ljk img border=0 src=jj.gif title= sklgj jl img src=jj.gif border=0 slgkj img src=jjj.gifsldk jgljks d img src=somwhere/images/image.gif alt=im alt text width=100 height=100 sfg as g or img src=image.gif or img src=http://site.com/images/image.gif; alt=im alt text width=100 height=100 or as Kola pointed out.. img src=somwhere/images/image.gif alt=im alt text width=100 height=100 cfset imgfilename=image.gif cfset bb=rereplacenocase(str,[^]*img[^]+src=?[^ ]*#imgfilename#?[^]*,IMG,ALL) hr cfoutput#str#/cfoutput hr cfoutput#bb#/cfoutput hr This handles all the cases you included. REFindNoCase should be the same regex. Does this help? Am I still missing it? Jerry Johnson [EMAIL PROTECTED] 07/29/03 02:56PM mail must be wiggin out again... i havent seen another response from jerry... ok I dont think i explained it too well... basically we made the mistake that alot of people have, giving a client a textarea in an admin tool to edit the main body of a certain page. Now we also gave a pretty descent dynamic image placement feature so they can place an image where ever they want in the body. Well, they decided (for some reason or another) to not use the image placement tool and put in their own image tags. This all works fine as long as the put it in right until... they go into the image management tools and delete an image they have put in manually. THen they are left with a broken image unless they go to that admin tool as well and remove the no longer valid image tag. so... what im trying to do is this... when they go to the image manger tool for say the news section... and delete an image I want to search the news table's body content filed and remove any image tag that has the image that is being deleted in it so i might be looking for img src=somwhere/images/image.gif alt=im alt text width=100 height=100 or img src=image.gif or img src=http://site.com/images/image.gif; alt=im alt text width=100 height=100 or as Kola pointed out.. img src=somwhere/images/image.gif alt=im alt text width=100 height=100 all of these may or may not have double quotes or single quotes the only thing known for certain going in is that it is going to START with a CONTAIN somewhere within a img and the name of the image image.gif END with a so i need to match (somehow) + possibletext + img + possibletextandslashes + #imagename# + more possibletext + hope this all makes sense : ) - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:52 AM Subject: Re: Attention Regex guru's The previous response is much better (since I read your question partly wrong) It only allows 0 or 1 quotes after src= (mine allowed for more for no good reason) It looks for the #imgfilename# string (mine looked for an actual filename set by imgfilename) It doesn't bother finding the quotes after the src= (since it is not important) Jerry Johnson [EMAIL PROTECTED] 07/29/03 10:44AM snip Jerry Johnson [EMAIL PROTECTED] 07/29/03 01:28PM I've come to the conclusion that ...I suck at Regular axpressions. I've been trying to get a regex to match all instances of start somewhere in there end img= #imagefilename# since there can be width, height, alt, etc... I need everything that starts with img and ends with and has #imagefilename# name inbetween. Make sense? i figured id go with #imagefilename# rather than src=#imgfilename# since ive seen some with quotes and some without any help greatly appreciated thanks ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Mach II
Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Neil ~| 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: DRK4 - pollster
oi Christian!! no flash.log present.. i double checked my gateway, that seems configured correctly and another application that I have that uses FR seems to be working fine. server 1 config is the built in webserver Crit Tuesday, July 29, 2003, 10:40:57 AM, you wrote: CC On Tuesday, July 29, 2003, at 09:06 AM, Critz wrote: server 1: installed, run admin logged in fine, created a poll, but when it goes to show the poll on the left hand side of the page it goes for a bit (like it's retrieving data...) then shows: We are sorry. An Error occurred and the poll will not be able to continue. I have no clue what is wrong CC Pollster uses Flash Remoting to communicate between the client and the CC server, so check your flash.log log file (in the same directory as the CC rest of your log files).You may have a more meaningful error CC message there. If there's nothing in the flash.log file, perhaps Flash CC Remoting isn't working at all on your server. Have you used Flash CC Remoting since Updater 3? I seem to remember Updater 3 turning Flash CC Remoting off by default, at least for the J2EE version of CFMX. server 2: installed files. went to login to admin, but everytime I login to the challenge/response dialogit just keeps popping up like i have entered the wrong info. any ideas? CC What client/server? Do you have cookies enabled? The admin interface CC just uses simple HTTP authentication, so if HTTP authentication works CC with other sites (does it?), then it should work with Pollster. Raymod CC Camden uncovered some issues with Pollster on IIS yesterday because of CC the way IIS works (or doesn't work) with HTTP authentication, so you CC might want to dig that up from the archives and see if that helps. CC Let me know if you're still having problems. We'll get it worked out. CC Christian CC ~| 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: Inserting flash into a CF page - RESOLVED.
At 02:40 PM 7/29/03 +0100, Mike Townend wrote: Without double checking the code... My first thoughts are that this appears somewhere within a CFOUTPUT block so you need to double up all # to treat them as literal # instead of the beginning of a variable Thanks. That was it. T Tired of your bookmarks/favourites being limited to one computer? Move them to the Net! www.stuffbythane.com/webfavourites makes it easy to keep all your favourites in one place and access them from any computer that's attached to the Internet. ~| 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: Mach II
httpp://beta.fusebox.org Mike - Original Message - From: Neil Middleton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:09 PM Subject: Mach II Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Neil ~| 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: DRK4 - pollster
oi Mike!! ie/win2k/iis the path is correct, but I don't think it even gets to any point where it is using the FR, it's stuck in the login section crit Tuesday, July 29, 2003, 10:25:34 AM, you wrote: MC - Original Message - MC From: Critz [EMAIL PROTECTED] server 2: installed files. went to login to admin, but everytime I login MC to the challenge/response dialogit just keeps popping up like i have entered the wrong MC info. any ideas? MC What browser / OS are you using? MC Make sure that you use an absolute path to specify the Flash Remoting MC gateway (which is set in the Application.cfm) file. MC Does that help? MC mike chambers MC [EMAIL PROTECTED] MC ~| 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: flash comm server ?
my host downloaded the trial version of the flash comm server and for the life of us we cant get it to work right. any no Stephanie im not gunna bother u anymore, lol does anyone know of any good documentation on setting this up? the included doc aren't much help and all the tutorials i have looked at only set it up locally. seems like it would be simple but its fricking driving me crazy! If you are the lucky one who can show me the dam light I will send u a copy of my prized live Randy Rhoads 3 disk set that is very rare (if you are old enough to know who that is) ty ~| 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
SQL Server date problem
I have a site that is suddenly throwing all sorts of date related errors for
no apparent reason. The errors happen anywhere a CF date variable is
compared to a date in a SQL server table.
The error I get is this:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Syntax error at token {ts, line 0
offset 0.
The queries are all similar to this:
SELECT *
FROM View_Support
WHERE RIsDelete=0 AND categoryid=3 AND senddate =
#createODBCDateTime(myDate)#
ORDER BY trackingnumber DESC, senddate ASC
*Note: createODBCDateTime(myDate) returns this: {ts '2003-07-24 12:00:55'}
This code has all worked fine for about the past year and suddenly is
failing everywhere. Nothing has been changed in the code and the ISP claims
nothing has been updated on the servers. Any insight into this would be
greatly appreciated.
Thanks,
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: Mach II
Neil Middleton wrote: Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Try here: http://beta.fusebox.org/ Down in the bottom left-hand corner should be Mach-II specific stuff. -- Oliver Tupman Key Systems Geotechnical ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
Hi Ian, You would change the address in the appropriate record. If it is a foreign key, and the DB is designed to CASCADE UPDATE then tables linked to the primary table will change also change. Again this is requires the DB to have CASCADE update. Lots of db don't have cascading settings. J2ee CMP 2.+ does. This is apparently a reason purists say one shouldn't use identities is so that you can change the value of the key when necessary. Yes I know they do. I don't fully buy that part of the argument. It's a little TOO theorical. A bridge to far. It is like 5th normalised form or something. Even DB gurus can't tell if a DB normalised to it... Don't know enough to argue the pros and cons, would like to learn more about it myself. But I know it's possible. Agreed. There is no 100% right way. WG ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? As Jochem and others have mentioned, there's nothing wrong with surrogate keys (keys with an arbitrary relation to the data they represent) in general. Purists prefer natural keys, but it's difficult to ensure that a chosen natural key candidate will always represent a unique value over time. Practical database programmers generally realize the value of surrogate keys. Within SQL Server, though, there have historically been version-specific problems with the IDENTITY datatype; in SQL Server 6.5, for example, the database would often lose track of what the next identity value should be, so you'd get an error when inserting a record! Those problems no longer exist, though, so if you don't need the functionality that a sequence or GUID will give you, feel free to use IDENTITY. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| 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: RE: DB Design
Say, to go off topic, how is CMP 2 coming along? CMP 1 sucked balls. - Original Message - From: webguy [EMAIL PROTECTED] Date: Tuesday, July 29, 2003 10:29 am Subject: RE: DB Design Hi Ian, You would change the address in the appropriate record. If it is a foreign key, and the DB is designed to CASCADE UPDATE then tables linked to the primary table will change also change. Again this is requires the DB to have CASCADE update. Lots of db don't have cascading settings. J2ee CMP 2.+ does. This is apparently a reason purists say one shouldn't use identities is so that you can change the value of the key when necessary. Yes I know they do. I don't fully buy that part of the argument. It's a little TOO theorical. A bridge to far. It is like 5th normalised form or something. Even DB gurus can't tell if a DB normalised to it... Don't know enough to argue the pros and cons, would like to learn more about it myself. But I know it's possible. Agreed. There is no 100% right way. WG ~| 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: RE: DB Design
Although this is possible, in practical terms, it could be a maintenance nightmare. Concievably millions of rows could be affected. Surrogate keys are good. There's nothing wrong with them. One can always set up a constraint/unique index on the natural key if need be. I generally don't use surrogate keys for lookup tables - it saves a join. - Original Message - From: Ian Skinner [EMAIL PROTECTED] Date: Tuesday, July 29, 2003 9:55 am Subject: RE: DB Design You would change the address in the appropriate record. If it is a foreign key, and the DB is designed to CASCADE UPDATE then tables linked to the primary table will change also change. This is apparently a reason purists say one shouldn't use identities is so that you can change the value of the key when necessary. Don't know enough to argue the pros and cons, would like to learn more about it myself. But I know it's possible. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: webguy [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:51 AM To: CF-Talk Subject: RE: DB Design Ian, For example for users, you might use e-mail, for employees you might use SSN, ect. Would you use a users email as a foreign key? What do you do if someonechanges their email address? WG ~| 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: SQL Server date problem
Rick Mason wrote:
I have a site that is suddenly throwing all sorts of date related errors for
no apparent reason. The errors happen anywhere a CF date variable is
compared to a date in a SQL server table.
The error I get is this:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Syntax error at token {ts, line 0
offset 0.
The queries are all similar to this:
SELECT *
FROM View_Support
WHERE RIsDelete=0 AND categoryid=3 AND senddate =
#createODBCDateTime(myDate)#
ORDER BY trackingnumber DESC, senddate ASC
Use cfqueryparam.
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.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: wikipedia
A Perl-writing friend is obsessed over his personal wikipedia. He gave me many links about downloading and running a perl wiki knowledge base, but it would be so much easier to run a CF one. Couldn't find one on the Exchange. Does anyone here know of a freeware knowledge base in CF? Someone's already pointed out seedwiki, so there you go. But keep in mind that a wiki has some peculiar limitations - typically, anyone can edit anything, so it only works within a relatively tightly-knit group with no members willing to soil the commons, so to speak. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| 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: Mach II
http://www.mach-ii.com/ It's the best a man can get. - Original Message - From: Neil Middleton [EMAIL PROTECTED] Date: Tuesday, July 29, 2003 10:09 am Subject: Mach II Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Neil ~| 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: Non blocking custom tag?
Say I have a custom tag called CF_doSomething. The tag takes 3 seconds to run. Is there some way to tell ColdFusion to run it in a nonblocking mode so the user doesn't have to wait for the 3 seconds? I don't want to use CFHTTP to create another page. It would be nice to say something like CF_doSomething timeout=0 and have it just work. No, you can't run CFML custom tags asynchronously. If you need asynchronous processing, you'll need to handle that outside of CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| 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
Cascading Updates was RE: RE: DB Design
For example for users, you might use e-mail, for employees you might use SSN, ect. Would you use a users email as a foreign key? What do you do if someone changes their email address? Or enter the witness protection program and change their ssn. ;P I'd expect one of two things from cascading updates or updateable views (not speaking from experience). The one is that the potential exists that you wouldn't be able to use them if you applied a constraint to the primary and foreign key columns. I realize it likely sounds like well gee, it's an internal process, you'd think the server would know how to handle that -- but it could be like the trigger on a table that causes an update of multiple records to fail because the trigger expects only a single record update. The second thing I'd expect is the possiblity that the updateable view might not work quite the way you'd expect or produce strange anomolies. For instance: a view can create relationships without necessarily being drawn on a primary key -- how does an updateable view handle the difference between inner joins and outer joins or joins on non-primary key columns (two foreign-key columns which reference the same primary key in a third table not in the view for instance)... The argument for being able to change the value of the primary key column in a table when necessary has (afaik) largely to do with migrating data between databases or more to the point merging databases. If you want to merge the data in 2 db's and they both have an employees table with the same structure (implementations of the same software for 2 companies that are going through a merger and they want to consolidate their database), a sybase or sql server identity column will prevent you being able to for instance add +1000 to all the employeeid's of employees in one company to ensure that there aren't any conflicting id's (because the other company's highest employeeid is 900 prior to the merger). Now if you used something other than an identity like an oracle sequence or a similar custom grown solution, you'd be able to do that, which would make the merger a lot easier (note -- not easy, just easier). Using UUID's should nearly if not guarantee that there would be no need even for modifying the employeeid's. And then you have human-generated primary keys which are probably the most difficult to deal with -- jsmith or [EMAIL PROTECTED] for instance. In this case, somebody in the office has to go through each individual conflicting primary key and figure out how to rename one or the other and update all their associated records in other tables. My preference obviously(?) is for UUID's and Oracle sequences or some similar homegrown feature. In sql server I use an additional table and a stored procedure to produce results similar to an Oracle sequence. Imho the Oracle sequence is so well thought out that it should be a widely supported sql standard -- but I suppose the old saw is appropriate -- the nice thing about standards is you have so many to choose from. :) Isaac Original Message --- You would change the address in the appropriate record. If it is a foreign key, and the DB is designed to CASCADE UPDATE then tables linked to the primary table will change also change. This is apparently a reason purists say one shouldn't use identities is so that you can change the value of the key when necessary. Don't know enough to argue the pros and cons, would like to learn more about it myself. But I know it's possible. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:51 AM To: CF-Talk Subject: RE: DB Design ~| 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: Mach II
Neil, I think you will have to wait till August 1st which is when I think Mach-II will be out of beta. I could be wrong on the date. I think they will be releasing docs for it at that time. For now I think all you can really do to familiarize yourself with it is to go through the code and try and figure out what does what. Ben - Original Message - From: Neil Middleton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:09 PM Subject: Mach II Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Neil ~| 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
CFMX Domain Misdirection
Heres the problem: Working in a shared hosting environment, CFMX is running with IIS5. All domains added to IIS have content stored remotely, and accessed via SMB/CIFS. Two domains in particular, when accessed, and refreshed repeatedly, return the other domain's index.cfm. They are not both using the same remote UNC path, as about 90% of the time they display their correct content. Otherwise, I assure you they -are- setup correctly, and they are the only two domains on the server experiencing these problems. I've tried removing/readding the domains in IIS, rebooting, etc, the problem persists. So what I wanted to know is, has this been seen anywhere else? Anything to do with caching, a strange bug perhaps fixed in an updater? If not, then I guess the problem isnt with CFMX at all, and I need to look elsewhere for a solution. Also, the pages are not identical, completely different filesizes, no references anywhere in their code to the other domains. Thanks for any help. -Erik ~| 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: CFMX Domain Misdirection
Have to make update in jrun.xml file check this out: http://www.macromedia.com/support/coldfusion/ts/documents/tn18307.htm -Original Message- From: Erik Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:35 PM To: CF-Talk Subject: CFMX Domain Misdirection Heres the problem: Working in a shared hosting environment, CFMX is running with IIS5. All domains added to IIS have content stored remotely, and accessed via SMB/CIFS. Two domains in particular, when accessed, and refreshed repeatedly, return the other domain's index.cfm. They are not both using the same remote UNC path, as about 90% of the time they display their correct content. Otherwise, I assure you they -are- setup correctly, and they are the only two domains on the server experiencing these problems. I've tried removing/readding the domains in IIS, rebooting, etc, the problem persists. So what I wanted to know is, has this been seen anywhere else? Anything to do with caching, a strange bug perhaps fixed in an updater? If not, then I guess the problem isnt with CFMX at all, and I need to look elsewhere for a solution. Also, the pages are not identical, completely different filesizes, no references anywhere in their code to the other domains. Thanks for any help. -Erik ~| 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
CF 5 Install Issues
Had MX installed locally.. removed it. Removed the CFusionMX folder from = c:\ as well. Rebooted... Installed CF 5 locally Services started ok. No CFM pages will come up including the administrator. I think I need to tweak IIS.. any ideas? Thanks, Mike ~| 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: Cascading Updates was RE: RE: DB Design
In sql server I use an additional table and a stored procedure to produce results similar to an Oracle sequence. Oh ikk. What's wrong with using scope_identity() in sql server 2000 and never using triggers in sql server 7? :) ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Domain Misdirection
Better yet here http://www.macromedia.com/support/coldfusion/ts/documents/tn18258.htm -Original Message- From: Erik Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:35 PM To: CF-Talk Subject: CFMX Domain Misdirection Heres the problem: Working in a shared hosting environment, CFMX is running with IIS5. All domains added to IIS have content stored remotely, and accessed via SMB/CIFS. Two domains in particular, when accessed, and refreshed repeatedly, return the other domain's index.cfm. They are not both using the same remote UNC path, as about 90% of the time they display their correct content. Otherwise, I assure you they -are- setup correctly, and they are the only two domains on the server experiencing these problems. I've tried removing/readding the domains in IIS, rebooting, etc, the problem persists. So what I wanted to know is, has this been seen anywhere else? Anything to do with caching, a strange bug perhaps fixed in an updater? If not, then I guess the problem isnt with CFMX at all, and I need to look elsewhere for a solution. Also, the pages are not identical, completely different filesizes, no references anywhere in their code to the other domains. Thanks for any help. -Erik ~| 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
Session timeouts too early
I am having a problem with Coldfusion sessions timing out too early. The session timeout in the cfapplication is set to 2 hours. The CF Administrator is set to a default of 20 minutes and a maximum of 2 hours. Users randomly get timed out in as little as 15 minutes or as much as the full 2 hours. These timeouts are 15 minutes FROM WHEN THE SESSION STARTED, not 15 minutes of idle time since the last page load. The user can be clicking like crazy and BAM the session is gone. I set my browser to 'prompt' all cookies, and I am getting a CFID and CFTOKEN with an expiration date many years in the future. When I close my browser, they get written to cookies.txt so I don't think there is a problem with the CFID/CFTOKEN session tracking cookies. For some reason the Coldfusion server (CF5) is expiring the session or forgetting it. This is on a shared server, so I suspected the server was being reset. But I tested four computers running sessions and they timed out at different times. If the server was being reset they would have all lost their sessions at the same time. Is there any way I can view the current in-memory database of CFID/CFTOKEN sessions? Can I write code to dump the values to a page so I can see what is really going on? (please don't say to view the #session# structure because when the session times out the #session# structure is lost completely.) -Peter ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Domain Misdirection
Known issue, there is an XML setting that needs to be changed (it'll be an option in CF Admin in Red Sky). See this blog entry: http://www.forta.com/blog/index.cfm?mode=eentry=642 --- Ben -Original Message- From: Erik Harrison [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:35 PM To: CF-Talk Subject: CFMX Domain Misdirection Heres the problem: Working in a shared hosting environment, CFMX is running with IIS5. All domains added to IIS have content stored remotely, and accessed via SMB/CIFS. Two domains in particular, when accessed, and refreshed repeatedly, return the other domain's index.cfm. They are not both using the same remote UNC path, as about 90% of the time they display their correct content. Otherwise, I assure you they -are- setup correctly, and they are the only two domains on the server experiencing these problems. I've tried removing/readding the domains in IIS, rebooting, etc, the problem persists. So what I wanted to know is, has this been seen anywhere else? Anything to do with caching, a strange bug perhaps fixed in an updater? If not, then I guess the problem isnt with CFMX at all, and I need to look elsewhere for a solution. Also, the pages are not identical, completely different filesizes, no references anywhere in their code to the other domains. Thanks for any help. -Erik ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mach II
I've jus been looking at the sample contact manager. For what it does, it comes across as hideously complicated. Then again, I haven't really looked into it properly yet so I may be completly wrong Neil -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 17:36 To: CF-Talk Subject: Re: Mach II Neil, I think you will have to wait till August 1st which is when I think Mach-II will be out of beta. I could be wrong on the date. I think they will be releasing docs for it at that time. For now I think all you can really do to familiarize yourself with it is to go through the code and try and figure out what does what. Ben - Original Message - From: Neil Middleton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:09 PM Subject: Mach II Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Neil ~| 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: Re: Mach II
I think the general idea was that he found the info on that site confusing -- which is why he was asking for an idiot's guide... I don't find it surprising... the verbiage is rather weighty... For instance: This headline: Event-Based, Implicit Invocation Architecture on this page: http://beta.fusebox.org/index.cfm?method=FuseboxMX.basicConcepts Note that the method is labelled basicConcepts ... but the verbiage isn't very basic... I think the average new person attacking that site is probably looking for something much more accessible... Unfortunately I don't have any good alternative verbiage off the top of my head. Original Message --- httpp://beta.fusebox.org Mike - Original Message - From: Neil Middleton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:09 PM Subject: Mach II Can anyone provide me or point me to an idiots guide to Mach II. I am basically trying to figure out what it does, roughly how it works and what beneifts it has. Call me stupid, but terms like implicit invocation architecture mean very little to me... Neil ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Session Variables Breaking in IE
Related to my earlier problem, where sessions seem to bust completely if the user clears their cache and all of their cookies while logged in to our site. I've gotten this error: Parameter 1 of function IsDefined, which is now quot;session.applicationSE2018d699256ad75a766-AB200671-BABB-F493-AA9D173CA2BC5D9Fquot;, must be a syntactically valid variable name. I'm afraid that I have no idea to how interpret this error or how to fix it. I think that what's happening is that IE still hangs on to some session value somewhere that can't be cleared, but I don't know for sure. I've thought about deleting the cfclasses cache under my JRun directory, but I don't know if this will be safe; I've messed things up with that tactic before. ~| 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: billion was RE: DB Design
In England, Hey, what about Ireland :-) Why the difference??? Its a historical oddity. Nothing specific made it that way. Unlike other languages. So thousand million (10^9) is called a milliard in the European style etc.. The American system was actually based on a French system which they then gave up and switched to the ENGLISH (or European system...). Some counting systems are based on interesting (ok interesting to me:-) ) basis... In French, 80 = quatre-vingts which means 4 X 20. Why? Because most people have 10 fingers and 10 toes, so the number system was 20 based (which is called visegle or something I forget ) And of course we call numbers digits for similar reasons. (but left out the feet because its too cold :-0 ) One last thing, recently, its been theorised, that the Incas had a binary counting system were they used know in string/rope etc, to represent numbers!!! WG ~| 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
