Re: SQL trouble
Dave's right, you need a join to tblModel. Generally when you return some incredible amount of rows that you are not expecting from a query that is joining tables its because you are missing a join or two. One thing you might consider is using a View for this. Then all you would have to do is send preID into the view to get what you need. Views are cached virtual tables, they allow for abstraction, but they are really convenient when it comes to programming in that you can do this big work horse query of yours as a view database side and then your code would be a simple SELECT WHATEVER FROM V_CARS WHERE preID IN (#preID# ) This way if you ever change the logic of your tables, you only have to change the view and not the live code. I hate to type, so the less I do, the better is how I figure it. If you ever program in java, think of a view as a class that has incapsulated data and your little query above as one of its methods. You can do whatever you want to the tables as long as the things you want to query remain the same. On the abstraction side of things, if someone ever sees your code thru one of those .htr or ::data things they can DELETE * from V_CARS all they want and they go hungry a bow bow bow. At the rate business logic seems to change on the web, this kind of stuff makes programming the client tier a lot easier. - Original Message - From: "David Baskin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 1:27 PM Subject: SQL trouble > Hello all, i'm having trouble with a query and i was hoping someone could > help me find the solution to my problem. I run a query to get the ids of the > objects a customer has stored. in this case it's two ids. then i run another > query that gets all the details of these items and displays it. i run the > following query to get the details: > > > SELECT p.Year > , p.Series > , p.stockNum > // more and more columns... > FROM tblPreOwned p, tblMake m, tblWarranty w, tblModel mo > WHERE p.vehicleMakeID = m.makeID AND p.warrantyID = w.wID AND (preID=0 OR > > p.preID=#preID# OR > > p.preID = 00) > > > what happens though is that i end up getting back over 1300 records for the > details query. it returns the same two objects over and over again. i'm not > sure why this is happening and unfortunately my SQL skills are not the best. > If anyone can tell me how to better structure this query to return the > proper results i would greatly appreciate it. TIA. > > david > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems printing an output page
I have a user who has problems printing a page. The page has a large table of product profiles, created by CF from a query. But all she prints is a message saying "DATA MISSING - expired from the cache". I have the page set to not cache, because I dont want to get dozens of complaints that people have changed their responses to the questions on the previous page and didn't get a different table. Should I have left caching on? Or what else is it that's causing this user to be unable to print? Cheers, Mike Kear ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSouth notes
Yes, fla's are the source files for flash. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Paul Hastings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 12:57 AM Subject: Re: CFSouth notes > > Steve Drucker said Harpoon source code will be available, he specifically > > mentioned fla's will be available, and that's where the wddx parser would > > be. > > fla would be the source for the flash movie? yes, i squat about > flash. > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Update on my timeout problems
Well, just to update anyone who may be having problems with timeouts from Access dbs. A little over a week ago I was averaging around 150 timeout errors in my CF logs per day (yuk). I spent several days trying different approaches, and set up a Task to restart CF at 4 AM every day. These are my settings now after playing with them for a few days. Page Timeout=600, Buffer Size = 0 as Allaire recommends in my Access datasources. All my Access datasources were already set up like that with maximum 1 connection. Limit simultaneous requests to 35 (2 CPUs). Allaire recommends 5-7 per CPU, but I believe their example must be with a single datasource on the machine. Template Cache Size: 24 MB I have 1 GB of RAM, so that shouldn't be too much. It was at the default of 2 MB, so this really needed bumped up anyway. Anyway, I'm happy to report that as of midnight tonight it's been 1 full week without a single timeout error in my logs. Happy Happy Joy Joy Also, I've convinced my Colo provider to let me bring in a 1U rackmount at no additional monthly fee and am looking at a nice Dell 1550. Almost have enough saved to get me 512 K or 1 GB of RAM with a single 1GZ CPU so I only need one Processor license for SQL 2000 and an 18 GB RAID 1 setup. Be good to go soon. :-D -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSouth notes
> Steve Drucker said Harpoon source code will be available, he specifically > mentioned fla's will be available, and that's where the wddx parser would > be. fla would be the source for the flash movie? yes, i squat about flash. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSouth notes
Steve Drucker said Harpoon source code will be available, he specifically mentioned fla's will be available, and that's where the wddx parser would be. jon - Original Message - From: "Paul Hastings" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 12:43 AM Subject: Re: CFSouth notes > > Harpoon Features: > > Perhaps the coolest thing about Harpoon is that it uses WDDX to pass data > to > > Flash. Since all the source code for Harpoon is going to be available for > > free, we should now have a Flash 5 Actionscript WDDX parser! > > curious. what source code? cf? flash? and who said this? > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Network Scenario
I need some advice... I'd like to use Cold Fusion in the following way: - 8 people with laptops networked together. - One laptop acting as the Cold Fusion server. - All 8 people simultaneously querying/updating/editing the database on the server through their browsers. Is it possible? What restrictions would I have? What sort of problems should I expect? Thanks in advance for any input. Les ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFSouth notes
> Harpoon Features: > Perhaps the coolest thing about Harpoon is that it uses WDDX to pass data to > Flash. Since all the source code for Harpoon is going to be available for > free, we should now have a Flash 5 Actionscript WDDX parser! curious. what source code? cf? flash? and who said this? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: custom tag submission woes!!
lol .. yeah .. and crashed 20 times in 5 minutes too .. what a record. Finaly, something CF does better than MS ;) Todd Ashworth You wrote: - Original Message - From: "Michael Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 8:22 PM Subject: Re: custom tag submission woes!! > I think it's cos they're using ASP to run the dev centre on . > > Or perhaps their Studio crashed mid-upload of the upload template. > > Cheers, > Mike Kear > > > On Sun, 4 Feb 2001, CF wrote: > > > Due to the custom tag upload section only working 1 out of every 20 times, Allaire has managed to royally screwed up my custom tag submissions to the DevEx, resulting in the WRONG files being available for download (ones not even remotely associated with my tags), multiple listings of the same tag (with different files associated with each listing), and buggy versions of the tags that do have the 'correct' files. If anyone has downloaded either or and found that the files were corrupted, the tags were buggy, or you just aren't sure, please E-mail me at [EMAIL PROTECTED] and I will send you the most recent version. Also, if you wish to download these, don't use the Allaire DevEx forums since everything there is way screwed up. E-mail me and I will get you the correct copies. > > > > I hope to get this all straightened out soon. Sorry for the inconvenience. > > > > Todd Ashworth > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DNS error
You mean DNS or DSN? There is a BIG differance. Todd Ashworth You wrote: - Original Message - From: "Haryono ..." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 8:46 PM Subject: DNS error > Hallo everyone. > I use Personal web server and ColdFusion Server in my > Computer. > I have a problem because DNS is error. So I can't run > my application. > Why is DNS error frequently? > > Thank you. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: custom tag submission woes!!
I thought the download area was run from Spectra... jon - Original Message - From: "Michael Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 8:22 PM Subject: Re: custom tag submission woes!! > I think it's cos they're using ASP to run the dev centre on . > > Or perhaps their Studio crashed mid-upload of the upload template. > > Cheers, > Mike Kear > > > On Sun, 4 Feb 2001, CF wrote: > > > Due to the custom tag upload section only working 1 out of every 20 times, Allaire has managed to royally screwed up my custom tag submissions to the DevEx, resulting in the WRONG files being available for download (ones not even remotely associated with my tags), multiple listings of the same tag (with different files associated with each listing), and buggy versions of the tags that do have the 'correct' files. If anyone has downloaded either or and found that the files were corrupted, the tags were buggy, or you just aren't sure, please E-mail me at [EMAIL PROTECTED] and I will send you the most recent version. Also, if you wish to download these, don't use the Allaire DevEx forums since everything there is way screwed up. E-mail me and I will get you the correct copies. > > > > I hope to get this all straightened out soon. Sorry for the inconvenience. > > > > Todd Ashworth > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSouth notes
I just returned from CFSouth and wanted to share a couple of things that we learned about Harpoon, CF5, and Neo. CF5 Features: User Defined Functions Incremental Page Layout - Dont know what this is all about... Application Deployment - Apparently Allaire is developing a product called Harvest that will be rolled into CF. Harvest provides "Multi-server management and monitoring, application deployment capabilities and service level reporting." CFSQL - I asked an Allaire guy what the advantages of CFSQL were, I was told that a query could be application or session scoped and then you could essentially query an in memory database. I asked if the cfsql engine would be more efficient than looping over an app. or session scoped array. He responded that cfloop was the second slowest tag in CF, but didn't have a firm answer. Graphing and Reporting - Perhaps a reference to Harpoon? No details were given. SNMP MIB Interface! - This is really cool, but I didn't get a chance to ask any questions about this, and it wasn't elaborated on. Enhanced database drivers - hmmm Maybe they are just supporting more db's... Logfile analyzer - Sounds cool, there are quite a few 3rd party utils that provide this now. I wonder what Allaire's will do. That's about all that was said, no mentions of a new Studio to go along with CF5. Where there is smoke Also what wasn't metioned was if Harpoon would be included with CF5, unless I missed it. Harpoon Features: Perhaps the coolest thing about Harpoon is that it uses WDDX to pass data to Flash. Since all the source code for Harpoon is going to be available for free, we should now have a Flash 5 Actionscript WDDX parser! One of the overall goals of Harpoon was to replace a lot of the java applets that have been included in CF since 3.0 that we are familiar with. So many of the java appliets have been done in flash now. The tags that Steve Drucker went over were: Navigation Toolbar - There is a programmable top navigation toolbar, that looked pretty neat. We should be able to bang out a nice flash nav in a couple of minutes now. Calculator - The ever popular calulator app, can be presented to the user to calculate something then fill in a form field or whatever. Tree - This is the one I am most interested in. I think trees suck, but clients request them for som reason. The flash tree also uses a dynamic loading scheme that only loads the data requested. Grid - A working replacement for cfgrid, very nice looking. Lot's of new features. Dropdown - Some kind of flash dropdown menu or something. All of the different tags were gone over really quickly and I missed it if this one was elaborated on. A public beta will be available next week, so we can all check it out. Also keep in mind that the Harpoon objects are Flash 5 only, so users will probably need to install the plug-in. Steve also mentioned a couple of urls for Harpoon reference and general flash help: http://demo.figleaf.com http://flashlite.net http://flash.central.com http://chattyfig.figleaf.com The only things that were mentioned about Neo that I thought were interesting was that Neo will compile our current and future CF apps into Java servlets. That means they should be platform independant! That also means much increased performance. The server does not have to compile the page into pcode before executing. Just execute an already in memory servlet. What was nice to learn, was that all current CF applications, will run in Neo. Not to metion perform much better. Neo will also support Unicode finally (that is kind of assumed since it will be a java platform though), so we should finally have more international CF developers among us in the future. That is about it, it was great and I cant wait for the big conference this year coming to Orlando also. As far as extracurricular activities go, if you are coming to the Devcon later this year. Orange St. in Orlando is a great place to go and do just about anything. I was able to locate a kicking club called The Red Door by the locals because they cant decide on a name. It's right off Orange on Pine St. They had a good DJ on friday night and Chris Domingo was headlining on Saturday night! Not to mention a lot of single girls and guys for the single programmers out there (or just the out of town ones ). Pretty good for a town that almost banned techno music about 5 years ago. jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DNS error
Hallo everyone. I use Personal web server and ColdFusion Server in my Computer. I have a problem because DNS is error. So I can't run my application. Why is DNS error frequently? Thank you. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Database Connection Pooling
Hallo everyone. I get a problem when I was reading about ColdFusion's feature. One of Coldfusion feature is Database Connection Pooling. I don't understand about Database Connection Pooling. Can someone help me to explain about that(detail)? I want to ask something? What is the meaning of Page compilation and caching? Thank's for your answer. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cached queries? huh?
How do I define a cached query and then access it? Problem is that I have a menu built off a query, the pages built from those menu choices off other queries. Click too many menu items too quickly and poof! The CF service reboots. What would be the best way to handle this? Can I set a query to a variable? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: custom tag submission woes!!
I think it's cos they're using ASP to run the dev centre on . Or perhaps their Studio crashed mid-upload of the upload template. Cheers, Mike Kear On Sun, 4 Feb 2001, CF wrote: > Due to the custom tag upload section only working 1 out of every 20 times, Allaire >has managed to royally screwed up my custom tag submissions to the DevEx, resulting >in the WRONG files being available for download (ones not even remotely associated >with my tags), multiple listings of the same tag (with different files associated >with each listing), and buggy versions of the tags that do have the 'correct' files. >If anyone has downloaded either or and found >that the files were corrupted, the tags were buggy, or you just aren't sure, please >E-mail me at [EMAIL PROTECTED] and I will send you the most recent version. Also, if >you wish to download these, don't use the Allaire DevEx forums since everything there >is way screwed up. E-mail me and I will get you the correct copies. > > I hope to get this all straightened out soon. Sorry for the inconvenience. > > Todd Ashworth > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
custom tag submission woes!!
Due to the custom tag upload section only working 1 out of every 20 times, Allaire has managed to royally screwed up my custom tag submissions to the DevEx, resulting in the WRONG files being available for download (ones not even remotely associated with my tags), multiple listings of the same tag (with different files associated with each listing), and buggy versions of the tags that do have the 'correct' files. If anyone has downloaded either or and found that the files were corrupted, the tags were buggy, or you just aren't sure, please E-mail me at [EMAIL PROTECTED] and I will send you the most recent version. Also, if you wish to download these, don't use the Allaire DevEx forums since everything there is way screwed up. E-mail me and I will get you the correct copies. I hope to get this all straightened out soon. Sorry for the inconvenience. Todd Ashworth ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL trouble
Also, doing the output on the query inside the new query is kinda odd... you might look at using ValueList()... like WHERE PreID IN (#ValueList(getUsedIDs.preID)#,0,00) (the "0,00" on the end is there based on your query looking for those values - nothing to do with the ValueList() call) --Scott - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 2:34 PM Subject: RE: SQL trouble > > Hello all, i'm having trouble with a query and i was hoping > > someone could help me find the solution to my problem. I run > > a query to get the ids of the objects a customer has stored. > > in this case it's two ids. then i run another query that gets > > all the details of these items and displays it. i run the > > following query to get the details: > > > > > > SELECT p.Year > > , p.Series > > , p.stockNum > > // more and more columns... > > FROM tblPreOwned p, tblMake m, tblWarranty w, tblModel mo > > WHERE p.vehicleMakeID = m.makeID AND p.warrantyID = > > w.wID AND (preID=0 OR > > > > p.preID=#preID# OR > > > > p.preID = 00) > > > > > > what happens though is that i end up getting back over 1300 > > records for the details query. it returns the same two objects > > over and over again. i'm not sure why this is happening and > > unfortunately my SQL skills are not the best. If anyone can > > tell me how to better structure this query to return the > > proper results i would greatly appreciate it. TIA. > > Well, at first glance, it looks like you're using four tables, but you're > not joining all four tables. This will result in a cross join or Cartesian > product, in which every row from one table is matched against every row from > the other. I don't see a join condition for "tblModel mo". > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Best Practice for a persistent variable
Query strings, better known as url parameters would be the way to pass the parameter if you cant use a form or CF. On the html page use javascript to read the value of the passed hidden variable. Just append the hidden form field variable as a url parameter to the links on the html page. jon - Original Message - From: "paul smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, February 03, 2001 1:46 PM Subject: Re: Best Practice for a persistent variable > How do you pass a hidden form field using HTML-only without making each > page a form? > > How would you do it with 10 to 20 different links on a page? > > best, paul > > At 02:09 AM 2/3/01 -0700, you wrote: > > >The simplest way would be to pass a hidden form field with each page > >request (flash or html) to the server. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL trouble
> Hello all, i'm having trouble with a query and i was hoping > someone could help me find the solution to my problem. I run > a query to get the ids of the objects a customer has stored. > in this case it's two ids. then i run another query that gets > all the details of these items and displays it. i run the > following query to get the details: > > > SELECT p.Year > , p.Series > , p.stockNum > // more and more columns... > FROM tblPreOwned p, tblMake m, tblWarranty w, tblModel mo > WHERE p.vehicleMakeID = m.makeID AND p.warrantyID = > w.wID AND (preID=0 OR > > p.preID=#preID# OR > > p.preID = 00) > > > what happens though is that i end up getting back over 1300 > records for the details query. it returns the same two objects > over and over again. i'm not sure why this is happening and > unfortunately my SQL skills are not the best. If anyone can > tell me how to better structure this query to return the > proper results i would greatly appreciate it. TIA. Well, at first glance, it looks like you're using four tables, but you're not joining all four tables. This will result in a cross join or Cartesian product, in which every row from one table is matched against every row from the other. I don't see a join condition for "tblModel mo". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL trouble
Hello all, i'm having trouble with a query and i was hoping someone could help me find the solution to my problem. I run a query to get the ids of the objects a customer has stored. in this case it's two ids. then i run another query that gets all the details of these items and displays it. i run the following query to get the details: SELECT p.Year , p.Series , p.stockNum // more and more columns... FROM tblPreOwned p, tblMake m, tblWarranty w, tblModel mo WHERE p.vehicleMakeID = m.makeID AND p.warrantyID = w.wID AND (preID=0 OR p.preID=#preID# OR p.preID = 00) what happens though is that i end up getting back over 1300 records for the details query. it returns the same two objects over and over again. i'm not sure why this is happening and unfortunately my SQL skills are not the best. If anyone can tell me how to better structure this query to return the proper results i would greatly appreciate it. TIA. david Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-NT-Server hangs: no interaction possible
> *grabs the soapbox and runs off* Guess that's that then. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-NT-Server hangs: no interaction possible
Noit is a possibility, thus I offered it as such for the person to look into.I also suggested ways by which one might determine definitely if this is indeed the problem, or if it's something else. At no point did I say definitely that it was Cold Fusion server hanging, I said "I think CF is.." If some ninny decides to write that CF server locks up all the time they would lose credibility, since if this were the case no one would use the server to run their web business. I shan't temper my responses because of what some manager *may* think... if we all did that we'd spend hours writing each post making it Politically Correct ;-P . Feel free to point out when I say something incorrect, or to provide alternative suggestions to a problem I may attempt to help with. :-) *grabs the soapbox and runs off* Ciao, -Gel - Original Message - From: Cameron Childress <[EMAIL PROTECTED]> > > Such claims only serve to confuse newbies who may be watching this thread > and don't know any better. Next think you know, someone will be writing an > article in "Pointy Haired Manager Magazine" about how CF is not a good > solution because it locks servers up all the time, which we all know is not > the case. > > > > Thanks! > > -Cameron ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-NT-Server hangs: no interaction possible
One thing that really confused me recently was an exception within an error template, resulting in infinite loop.. and the server dying (on a Linux box) Quite confusing at first look though ... Justin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-NT-Server hangs: no interaction possible
> Hi list, we have a CF-NT-Server (NT 4 Server, SP5, with CF > Enterprise 4.5.1 SP2) that hangs every once in a while. > The bad thing is, that you can't get on the machine (with > PCAny or VNC remotely), because almost every service is > dead. The NIC is working fine. > > When locally coming to the machine everything is frozen. > But no blue screen. You cannot interact with the machine > via mouse or keyboard. You have to reboot the machine via > hard-reset. > > Looking in the logfiles doesn't give you any hint at all, > what process causes this. > > Any ideas what one might do in this kind of issue ? I've encountered this same problem with a server before. Once the problem occurred, you couldn't log on at the console, nor could you log on to shares, etc, via the LAN. The message that was given when a secondary login was attempted was, "Not enough server storage to process this command". Unfortunately, I don't have a good definite answer as to how to fix the problem. I'd seen this message when I'd run into a problem with certain machines before applying SP4. So, I took the server to SP6. I thought at the time that might have fixed it, so I stopped working on it, but it has recurred occasionally since then. I think that it had to do with a COM object installed on the server for a specific development project, but I'm sure it has to do with incorrect memory allocation in general. Given enough time and interest, here's how I'd try to track down the problem. First, there's a bunch of info on the MS support site (these URLs will definitely wrap): http://search.support.microsoft.com/kb/psssearch.asp?SPR=nts&T=B&KT=ALL&T1=7 d&LQ=%22Not+enough+server+storage+to+process+this+command%22&S=F&A=T&DU=C&FR =0&D=winnt%2Bor%2Bntrelease%2Bor%2Bcustserv%2Bor%2Bcrossnet&LPR=%22windows+n t+server%22&LNG=ENG&VR=http%3A%2F%2Fsupport.microsoft.com%2Fsupport%3Bhttp%3 A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%3Bhttp%3A%2F%2Fsuppor t.microsoft.com%2Fhighlights&CAT=Support&VRL=ENG&SA=GN&Go.x=34&Go.y=24 http://support.microsoft.com/support/kb/articles/Q126/4/01.asp?LN=EN-US&SD=g n&FR=0&qry=%26quot%3BNot%20enough%20server%20storage%20to%20process%20this%2 0command%26quot%3B&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=NTS Then, I'd use Performance Monitor to log what's going on in memory, and try to reproduce the problem. This kind of thing isn't fun or easy to deal with, but with enough time and effort, it can be done. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Politics RULE grrrrrrrrrrr
I don't think anyone covered the issue of responsibility. If I understand right, there are two contractors working independently. If they are competitors, how can one be turned into the traffic cop for both without some sort of contractual language to spell out the relationships, responsibilities, liabilities, and means of resolving conflicts, etc.? If this thing gets set up the way the other guy wants it, insist on a contract that will help everyone sort out the problems, once they (inevitably) happen. Without that, it will just be a shouting match, and the one who has the best connections within the organization will win. --John ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Linux Sybase drivers single-threaded?
My application was consistently crashing and generating core-files. I vaguely recall something about the Linux Sybase drivers NOT being thread safe, and I think the problem is related to this. I have just spent the last two hours searching the Allaire knowledge base (http://allaire.com, since http://www.allaire.com is not working today) for any reference to Sybase, Linux and single-threading, and I cannot find anything at all. Does anyone know anything about this topic? Or can anyone point me to a knowledge base article of some documentation about this? --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF-NT-Server hangs: no interaction possible
> Ehmm..I think CF is running amok and using all the CPU Cycles on your > machine. Unless you have a special 6th sense ability, I'd suggest using care before suggesting something like this. There is no way anyone could have come to this conclusion based on the amount of information given. It's one of many many possible causes of this problem. You don't even know what other software may be running on this machine. No reason to further muddy the waters by making the assertion that if your computer locks up, it's "got to be" CF "running amok". Such claims only serve to confuse newbies who may be watching this thread and don't know any better. Next think you know, someone will be writing an article in "Pointy Haired Manager Magazine" about how CF is not a good solution because it locks servers up all the time, which we all know is not the case. Thanks! -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: Angel Stewart [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 03, 2001 5:58 PM > To: CF-Talk > Subject: Re: CF-NT-Server hangs: no interaction possible > > > Ehmm..I think CF is running amok and using all the CPU Cycles on your > machine. Try leaving Task Manager running on the system tray, so that you > can see the CPU display and see if when it hangs this is filled green > (100%). > > This problem has been spoken about at length (if this is what is > happening), > and I've never seen a clear indication as to what causes the problem..or > what could be done to fix it. > > -Gel > > - Original Message - > From: cf-talk <[EMAIL PROTECTED]> > > > The problem is, when the machine freezes I can't interact with > the machine > > anymore. > > Since it is a shared server the admins are to be told to logout. When I > let > > task manager > > run I might do this, but I can't get it to get viewed anymore after > > freezing. Do you see what I mean ? > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Allaire.com down?
Edward: Thanks a million!! Regards,Ray. -Original Message- From: Edward Smith [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 04, 2001 9:37 AM To: CF-Talk Subject: Re: Allaire.com down? I don't know if you'll be able to download, but while 'http://www.allaire.com' is down, you can still reach 'http://allaire.com'. So, if you need knowledgebase, or other things, this should work. Here's a working link for CF Updates: http://allaire11.allaire.com/download/showfamily.cfm?DownloadType=Update&Fam ilyID=1953B558-7AC0-11D4-849E0010B547F60A Maybe I should bill Allaire for helping out. "Ramon E. Fernandez" wrote: > > Will: > > I am having the same problem. I need to download 4.5.2 update and I am not > able to access the site. Is the update anywhere else on the net? > > Regards,Ray. > > -Original Message- > From: W Luke [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 04, 2001 9:14 AM > To: CF-Talk > Subject: OT: Allaire.com down? > > Hi, > > Haven't been able to access Allaire's site for 3 days - I'm in the UK on > Demon. Is this a UK problem, or are others also having trouble? > > Will > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Allaire.com down?
I don't know if you'll be able to download, but while 'http://www.allaire.com' is down, you can still reach 'http://allaire.com'. So, if you need knowledgebase, or other things, this should work. Here's a working link for CF Updates: http://allaire11.allaire.com/download/showfamily.cfm?DownloadType=Update&FamilyID=1953B558-7AC0-11D4-849E0010B547F60A Maybe I should bill Allaire for helping out. "Ramon E. Fernandez" wrote: > > Will: > > I am having the same problem. I need to download 4.5.2 update and I am not > able to access the site. Is the update anywhere else on the net? > > Regards,Ray. > > -Original Message- > From: W Luke [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 04, 2001 9:14 AM > To: CF-Talk > Subject: OT: Allaire.com down? > > Hi, > > Haven't been able to access Allaire's site for 3 days - I'm in the UK on > Demon. Is this a UK problem, or are others also having trouble? > > Will > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Allaire.com down?
Can't get to it either from UK on BT Connect. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: 04 February 2001 14:14 To: CF-Talk Subject: OT: Allaire.com down? Hi, Haven't been able to access Allaire's site for 3 days - I'm in the UK on Demon. Is this a UK problem, or are others also having trouble? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Allaire.com down?
Will: I am having the same problem. I need to download 4.5.2 update and I am not able to access the site. Is the update anywhere else on the net? Regards,Ray. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 04, 2001 9:14 AM To: CF-Talk Subject: OT: Allaire.com down? Hi, Haven't been able to access Allaire's site for 3 days - I'm in the UK on Demon. Is this a UK problem, or are others also having trouble? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Allaire.com down?
In germany you can't get their server as well. Oops. Uwe - Original Message - From: "W Luke" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 3:13 PM Subject: OT: Allaire.com down? Hi, Haven't been able to access Allaire's site for 3 days - I'm in the UK on Demon. Is this a UK problem, or are others also having trouble? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Allaire.com down?
Hi, Haven't been able to access Allaire's site for 3 days - I'm in the UK on Demon. Is this a UK problem, or are others also having trouble? Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT-Access to server on NT
I am having a problem I hope someone here can help with. I have a client that I work for remotely. Currently for some reason I cannot access their website or connect via ftp, telnet, or as an rds from any of my NT based machines. 1: NT 4 SP 6 2: Win 2000 professional I have no trouble using my win 98 machine on the same network (DSL connection) to connect to the site in any fashion. Has anyone got any ideas? I hate trying to find anything on the MS site and knowledge base so I thought Id check here first. Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NT4 Question
I think you can demote PDC domain B, then leave domain B and join domain A. There is some clue as to this in MS Knowledge Base article Q139471. I've never tried it though, so good luck! John At 06:09 04/02/01 -0500, you wrote: > > I got myself a bit of a strange problem here. > > > > I have a Primary Domain Controller for Domain A. > > > > I'd like to bring another server to Domain A that's > > currently configured to be a Primary Domain > > Controller for Domain B, and make it a Backup > > Domain Controller for Domain A. > > > > Is there a way to do this without re-installing NT? > >There is a third-party product which allows you to change a server from PDC >to BDC or stand-alone, but other than that, you'd have to reinstall. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AW: CF-NT-Server hangs: no interaction possible
Gel thanks. I ran several CF-servers the last years. But this I haven't seen before. I the case you described the admin always have the chance to interact with the server. Even CPU is constantly 100 % you can interact (slowly but you can !) with the desktop. What you described happens usually when you have odbc/mdac problems. But what I describe is to my knowledge not really clear to connected to CF. It could also be a problem with Internet Information Server or the Mail server/FTP server running on the same machine. The only thing I can think of is monitoring the machine and do a logging of the most important services in a log-file. Or is there anything else what I could do ? Uwe -Ursprüngliche Nachricht- Von: Angel Stewart [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 3. Februar 2001 23:58 An: CF-Talk Betreff: Re: CF-NT-Server hangs: no interaction possible Ehmm..I think CF is running amok and using all the CPU Cycles on your machine. Try leaving Task Manager running on the system tray, so that you can see the CPU display and see if when it hangs this is filled green (100%). This problem has been spoken about at length (if this is what is happening), and I've never seen a clear indication as to what causes the problem..or what could be done to fix it. -Gel - Original Message - From: cf-talk <[EMAIL PROTECTED]> > The problem is, when the machine freezes I can't interact with the machine > anymore. > Since it is a shared server the admins are to be told to logout. When I let > task manager > run I might do this, but I can't get it to get viewed anymore after > freezing. Do you see what I mean ? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NT4 Question
> I got myself a bit of a strange problem here. > > I have a Primary Domain Controller for Domain A. > > I'd like to bring another server to Domain A that's > currently configured to be a Primary Domain > Controller for Domain B, and make it a Backup > Domain Controller for Domain A. > > Is there a way to do this without re-installing NT? There is a third-party product which allows you to change a server from PDC to BDC or stand-alone, but other than that, you'd have to reinstall. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: NT4 Question
I have not tried this myself. But if you demote the Primary controller on Domain B, try having that machine join Domain A as a backup controller. Should work. Frank -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 03, 2001 6:21 PM To: CF-Talk Subject: OT: NT4 Question I got myself a bit of a strange problem here. I have a Primary Domain Controller for Domain A. I'd like to bring another server to Domain A that's currently configured to be a Primary Domain Controller for Domain B, and make it a Backup Domain Controller for Domain A. Is there a way to do this without re-installing NT? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists