Re: Linux OS authentication
Christopher Farino wrote: I need to create a connection between ColdFusion and an LDAP server.Our Unix administrator has set up Linux to authenticate with the LDAP server and wants ColdFusion to authenticate with the LDAP server through the OS and not directly from the LDAP server.Does that make any sense? The question makes sense. I'm not so sure about the position of your Unix admin :-) If you just need to authenticate users, it might be easier to tie your Apache directly into PAM using the auth-pam module. That is pretty much the equivalent of the way WIndows Authentication works with domain accounts and IIS. If you need to retrieve details like the groupname from the user, you will have to write something to interface directly with PAM. Have you checked the Developers Exchange? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: IIS considers blah.com directories to be executable?
Damien McKenna wrote: On Jul 9, 2004, at 7:28 PM, Dave Watts wrote: I think I'll be able to come up with some good reasons, e.g. we wouldn't have been hacked in April if we weren't using IIS (!). If you were hacked in April, it might have been because you didn't configure IIS properly, not just because you were using IIS. We were hacked because of a vulnerability that wasn't patched until the day _after_ we were hacked. You were hacked through the SSL exploits before te patch came out? Of course we didn't discover it for a while... How did you trace it back to a particular exploit? If you didn't discover it for a while, they had quite a while to cover their tracks. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Linux OS authentication
Christopher Farino wrote: His position is that he doesn't want to duplicate all the work he did to get Linux to authenticate from LDAP and that if something more complicated is done at the OS level CF will benefit from it. But is something more complicated done at the OS level? And do you need just authentication, or do you want to look up details about the user based on their username. I found 2 custom tags that authenticate Linux users on the CF server, but they're not available for download.What is PAM? Pluggable Authentication Module. See man pam. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Mail Transaction Failed
laTE Ssµ|¦TmSI¾#¢bL} i- ¶0©¢¼º ÐTB.¯kµ²koI7 1.Uv¾2,«saK°qajU2¤¿G§qg¨bªdyNGPD2½k_¡L¡kN7«mjУ½¥¶Ooµf±Y!2[®RYy ÷QX-\\(¦¹u]B³z#!, HIµlS¯£§c{4*^U²n¦wµ:O4^²By-¤B[WNaagJ¡dG7°rºY5MC²)w²'?L»÷º/÷SMu3 |\#n± l9e¿´ Ice¶i§¼\£°MSQI¶W× qZ)2¤±Pi °p´$ªK°f|O¼hmC3n©bTNIm26 U8P`/i½$g{a{ap°CnB)k©xs2fY§}lHK¤¤$I$©UJ6.1j *¯ YIJ¤ ¡T;S«³#Z5.G½!`TtJb,¶D º×¡tu´ft£÷Jci÷µÐn¯!_©¡ 9s?-^nf#MZ5w m x!°yM\L-rBlILl3D¸Ag2¯}*\BЩµn¨EM ½n¢([½Wg bпz-§Z;A¿»_±±½md£0*N/e0¡;¾DMw#§¢¿4© [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JS question / DOM hiding all elements in square area
webguy wrote: I want to hide all elements in a region (ie5+, nn6+) So I have these pixel values for the region left,top,weight,height What the easiest way to do this ? Create an empty div and apply a style to give it the right size, position and z-index. 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: JS question / DOM hiding all elements in square area
Michael Tangorre wrote: using style sheets and JS events if needed change the visibility property. I forget the list of elements you can apply this to, but I am sure the table, tr, td, div, span work. visibility: hidden; That is the easy part. But unless you have hardcoded window size, font size, and positioned all elements using absolute positioning, you need to determine on the fly which elements are in the 'invisible' area. And it seems to me that would be tricky. 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: CFMX cannot handle charset for URL variables
Quoting Murat Demirci [EMAIL PROTECTED]: Do you know CF MX has still problems with Unicode and other charsets. When I use setEncoding(url,utf-8), CF MX displays some double-byte (the unicode number over than 255) as nothing. It displays nothing. Which characters? Can you give some example code of a page with both form and url variables that shows that a form works but URL variables not? What happens if you use the builtin webserver? 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: Unresponsive Threads
Quoting Jim Watkins [EMAIL PROTECTED]: My CF 5 server running on NT 2000 and using Oracle 7 ver 2.5 with 2.05.03.01 driver consistently must restart every 7 or 8 minutes because of this unresponsive thread problem. What is going on here? Check your logfiles to see which templates cause this problem (you may need to turn on more logging/timeout options). 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: Documentation examples
Quoting Everett, Al [EMAIL PROTECTED]: Documentation is the worst part of development. Does anybody have any documentation for CFCs/CustomTags/Modules/Functions ? Specifically a document which shows attributes/parameters, output values, etc. I could probably roll my own but if there's a widely accepted standard I'd like to use that. I wouldn't know of any such standard, but it is an issue I have encountered as well. What I was wondering is if there would be any interest in defining an XML schema for documentation and write some tools to create several derivative forms, such as human readable documentation that resembles (to the extend allowed) the official CF documentation, some form that can be imported in CF Studio Tag Completion, something readable by UDFDoc etc. Probably not something for you if you need to have your docs finished yesterday, but just wondering if there is any interest. 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: IE for PPC
Quoting Shahzad.Butt [EMAIL PROTECTED]: I can compare this string but in future we will have different devices then i've to change the code and put another IF. Is it only option i've got? It depends on *why* you want to know if the device is a handheld. If it is just for reasons of output formatting, using the media attribute of your stylesheets may be much easier. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... Just generate enough and you will get duplicates. But the problem is more with the following: In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. Apart from using Left() instead of Mid() :-), just because the UUID is unique does not mean the first 4 characters are unique. With 4 ASCII characters you can have only 4 billion different combinations anyway, and with 4 HEX characters only 65536 different combinations. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: big database (need to modify columns)
Quoting Tony Weeg [EMAIL PROTECTED]: has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? ALTER TABLE table ADD COLUMN column datatype; Never done it on something larger as 8 million rows and it takes some time, but it is not something that ought to break anything. Just remember that this will most likely exclusively lock your table, and that CF (or any other web language) is not the right tool for it, but you need the native DB management tools. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using createUUID()
Quoting Jason Lees (National Express) [EMAIL PROTECTED]: http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. And although MAC addresses are officially unique, they are not in reality. Many OS'es allow you to change it and vendors of cheaper NICs (Realtek) use duplicates themselves. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Updating Multiple Records
Quoting Russ [EMAIL PROTECTED]: Care to elaborate at all? That would be an unrealistic expectation ;-) Using cfqueryparam forces you to specify the datatype. It is something I find usefull when debugging, because it both forces you to think about what you are doing and tells you which variables are the problem. The error #Evaluate(FORM.commentID#i#)# is not of the type integer tells you more as Syntax error It is just a debugging tool. 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: migrate data stored by cf 4.5 to cfmx (unicode problem?)
Quoting Toby Tremayne [EMAIL PROTECTED]: I've been searching through the online forums and docs but can't find anything that actually tells me how to do this. I have a database (msaccess) full of data stored by a cf application being run under 4.5 for most of it's life then cf 5.0 for a while. What charset is this data using? When I transport the data from the access DB to my new postgres DB on a linux server I use a CF script, as the table structure has changed - that script is run on the windows machine. All runs fine, but when I go to view the application from the new installation it's full of junk characters (square symbols and questrion marks). I'm assuming this is something to do with the fact that earlier versions of cf screwed up the unicode encoding and cfmx apparently has gotten it right - but I can't find anything on a method for fixing this! If the data in Access is visible correctly when using Access it self it is not a normal unicode issue. Which CF version did you use to move the data? Which client_encoding did you set in PostgreSQL during the migration? Did you set up the PostgreSQL database to use unicode (WITH ENCODING 'UNICODE')? Can't you use the pgAdmin database migration wizard to move the data from Access to PostreSQL and then use built-in functionality to transform the data? 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: Create DSNless connection to mySQL
Quoting Peter Mayer [EMAIL PROTECTED]: Is there a solution for the other way (create a datasource from my coldfusion code)? http://spike.oli.tudelft.nl/jochemd/index.cfm?pageID=12 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Database Options
Quoting paul smith [EMAIL PROTECTED]: For some time, I have run the main listing database at www.SMARTERyellowpages.com as read-only, being more than a little paranoid about it. Obviously, this means the queries are read only. How have you set the database to read-only? But this complicates updating the database, which I do every 24 hours. Since so many queries are cached, CFQUERYPARAM is of no help in preventing SQL Injection. The vast majority of these are amenable to using VAL to prevent SQL Injection. What are your thoughts on not having the database read-only, or any other related issues, and (me, not users) being able to update a running database? Just some thoughts: - query caching does not necessarily have to happen through the cfquery tag - you could use multiple logins to the database, a readonly login and a normal one for instance - use something not CF to update the database Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Making CFObject secure on a Shared host?
Quoting Oliver Cookson [EMAIL PROTECTED]: Is it possible to use CFOBJECT securely on a shared host. (I.e.not being able to view the service factory) Don't focus on the servicefactory. Not being able to access the servicefactory does not mean it is secure. You could for instance use java.io.* to get filesystem access and change the XML files from which CF reads startup settings. All you need then is to force a server reload. On the other hand, having access to the servicefactory is not completely insecure either. In a properly set up sandbox you would still lack permissions to write the XML files with the new settings to disk. Seems a shame that everyone on a shared host loses ALOT of functionality! If the problem is that big you should either get a customtag installed, move to a dedicated server or find some host that runs different customers under different instances (which will most likely not be a cheap account). Or rethink why you need cfobject access. Do you think there plans to make CFOBJECT more useable on shared hosts? I don't see how it could be more useable without sacrificing security. The whole point of cfobject is the ability to access arbitrary classes. You can't know what arbitrary classes do nor whether they integrate into the CF MX security framework. Even though they might be secure, you can't guarantee that. Jochem PS I hope to be wrong, I still haven't got my head around all the issues. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Goodbye cruel world
Quoting Thomas Chiverton [EMAIL PROTECTED]: Correct, but if you go through the process of removing IE (is it possable on Win2K any more ?), I suspect MS will no longer support your server. I find that an interesting argument because I hear it all the time, yet I hear from very few people that they have actually contacted MS for support even when they have serious issues. Let alone MS support was able to help them and/or not being billed. How often do you contact MS support and get something back from it? As to leaving IE on, but not trusting it, how many times have you used a local web browser to confirm something is working or not, particularly when chasing down network issues ? I use telnet, gives me control over HTTP headers. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: but I still fail to see how a machine with a Sofware Firewall which blocks all inbound traffic unless user allowed is insecure... Simple. I sent you a virus with some malware, you double click and the malware connects to me and I start giving commands. Firewalls only look at who is initiating the connection, once it is established anything goes. As for email : I never open email up unless it is from a user or list I recognise - and my AV progs simply delete or detect malicious ones anyway We have received malware through this list as well (granted, incapacitated by the mailserver). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: Erm, if I was stupid enough to double-click an attachment without [a] virus checking it (which my apps do anyway) then I know its time to pack up and move on.. Would an IRC client be caught by a virusscanner? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Goodbye cruel world
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: I fail to see how it can be exploited?My AV software will capture the bad things, my firewall will block ALL types of traffic coming into my machine by default. All uncessary ports have been disbled from listening and the only ones I have open are the ones I know I require. I do not see how one unfiltered URL data in a CFML page can exploit the machine? What if the URL data causes some MS SQL Server stored procedure to be executed which does an HTTP request (outbound, so not filtered), and retreives a modified IRC client. The next malfomed URL data causes the IRC client to be executed, through MS SQL Server again, upon which the IRC client establishes a connection to some remote host (outbound, so not filtered) and reports back a 'ready to accept commands' message. Firewalls set to refuse inbound traffic on unknown ports actually provide little security. An even easier example; what if you didn't follow the recommended procedures and you are running an old CF version with the documentation installed? Gives you file system access through the cffile examples so you can upload whatever you want and then use cfexecute to run it. Would your firewall refuse that traffic? Statefull firewalls that monitor both in- and outbound traffic are a little better, they would stop the first example, but in the end security is an all out effort. You need to implement it at every level, not just at the gate. 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: Goodbye cruel world
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: Yes, both of the apps running have found mIRC clients on the machine before I invested in a Firewall! :-) I am not talking about some standard IRC client, but about those custom made to run as a trojan, or worse, those designed to replace executables from legitimate IRC clients with executables with 'added capabilities'. 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: CFMX ServiceFacotry ?s
Quoting Tyler Silcox [EMAIL PROTECTED]: Is it possible to add your own mappings through the CF ServiceFactory? http://spike.oli.tudelft.nl/jochemd/ Does anyone happen to have a website or any documentation on what all the ServiceFactory is capable of, drawbacks, or shared hosting problems, etc...hmmm? There is some more info on various options, but it is far from complete. And as for shared hosting, users shouldn't even be allowed to access the ServiceFactory. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: WOT: MySQL in the Enterprise
Quoting John Paul Ashenfelter [EMAIL PROTECTED]: Not to mention the fact that *management tools* are a key feature of databases. Spend a lot of time using osql in MSSQL? How often do you schedule jobs using the sp_addjob (know how to figure out the int for @frequency?). That is just because MS SQL doesn't have an interval datatype :-) I'm all for the command line, but just getting a taste of the MySQL Control Center made me realize how much a front-end tool contributes to usability. I always use the command line for management. There might be some tools for visualization I use simultaneously, but in the end it will be some ALTER TABLE because that ends up in a log and can be reproduced easily, and often even be ran against a different RDBMS. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join - Help!
Quoting Bosky, Dave [EMAIL PROTECTED]: I'm trying to look up the department name and group description using their ID's. But it only returns the records where it finds both department and group descriptions. Some records don't have a group description or department name. I believe I'm using the wrong type of join but I'm stumped. Any ideas or better ways of accomplishing this query. SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A INNER JOIN Dept B ON A.DepartmentID = B.DepartmentID INNER JOIN DeptGroups C ON A.GroupID = C.GroupID SELECT A.DepartmentID, A.AdminName, A.GroupID, B.DepartmentName, C.Description FROM DeptAdmin A LEFT JOIN Dept B ON A.DepartmentID = B.DepartmentID LEFT JOIN DeptGroups C ON A.GroupID = C.GroupID 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: Apostrophes become boxes and other odd characters in CFMX?
Quoting Cameron Childress [EMAIL PROTECTED]: After upgrading an application from CF5 to CFMX, I have run into a situation where some apostrophes and quote marks are being transformed into weird boxes and other strange characters. This only seems to happen when users cut/paste text from word, and not when they type it directly into the text form fields. I have a feeling that this has something to do with the JDBC drivers, but wanted to ask the list first in case anyone else has run into this problem. I have a feeling it has to do with charsets. Are you explicitly specifying the charset everywhere? Have you taken advantage of the upgrade and switched to unicode in the process? 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: stupid newbie tricks
Quoting Bill Grover [EMAIL PROTECTED]: !--- Needed for when the session times out but CFMX thinks the login still active --- cfif NOT IsDefined(SESSION.nUserID) cflogout /cfif cflogin snipage There used to be an issue with cflogin and cflogout where you needed to put the cflogout after the cflogin or users would get mixed up when they logged out and back in again (I think). Not sure if it is resolved yet? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: increment a count in a db
Quoting Cutter (CF_Talk) [EMAIL PROTECTED]: Table:tblSubscribe int:intChoiceID str:strChoice int:intCount Update intCount for selected strChoice as intCount + 1 UPDATE tblSubscribe SETintCount = intCount + 1 WHERE strChoice = cfqueryparam cfsqltype=cf_sql_varchar value=#value# Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: stupid newbie tricks
As for the rest, you are long overdue on removing the words stupid and newbie from the subject line :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 5 week rotation
Quoting Kennerly, Rick H CIV [EMAIL PROTECTED]: I have 5 fixed-text items in a database that need to rotate display on a weekly basis, rotating weekly on Monday (week one: item one; week two, item two). Obviously the purpose of having 5 items is so that the same piece is not displayed on the same week of the month every month (they rotate forward one week each month). It's not an ad, it's a lunch menu. I can't work out an query that will work. Any elegant query ideas? If they have ID's 1 to 5 it would be something like: SELECT * FROM table WHERE ID = Floor((EXTRACT(DAY FROM (CURRENT_DATE - 'startdate')) % 35)/7) + 1 With startdate some arbitrary startdate. (The extensive math is to prevent a quick repeat at the end of the year, the number of weeks in a year is not a multiple of 5.) Okay, any ideas at all? More diet variation? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4