Query to find Primary key?
Is it possible to find the column name of the primary key in a table from a query? Select getPrimarykey() as Pkey >From table FYI I'm running MS SQL2000 Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: "FREE" BD vs. "$$$$" CF
$100+ do exist. And I am sure that holding one of these makes all problems solvable with hammering. $174.99 15-Ounce Titanium Hammer http://www.amazon.com/exec/obidos/tg/detail/-/B6K158/qid=1082644930/sr=1 -2/ref=sr_1_2_etk-tools/102-3185839-9957746?v=glance&s=hi&n=228013 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 9:38 PM To: CF-Talk Subject: RE: "FREE" BD vs. "" CF Expecially if that's a $100 hammer. Paul Kenney [EMAIL PROTECTED] 916-212-4359 > -Original Message- > From: Nathan C. Smith [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 7:24 PM > To: CF-Talk > Subject: RE: "FREE" BD vs. "" CF > > > When the only tool you have is a hammer you tend to see the > problem as a > nail. > > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 7:48 PM > To: CF-Talk > Subject: RE: "FREE" BD vs. "" CF > > > Actually we use CICS on our mainframe. I've just started a > project where I > need to deal with it for the first time. > > Also, just to round this out, it was IBM Consulting Services that > "recommended" WebSphere as the obvious solution for the > enterprise. The > management hired them to examine our then-current > applications (written for > our part in CF) and determine our future course of action. > > How surprised were we when they settled on WebSphere on AIX? > Not very. ;^) > > Jim Davis > > _ > > From: Dick Applebaum [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 11:20 AM > To: CF-Talk > Subject: Re: "FREE" BD vs. "" CF > > On Apr 21, 2004, at 7:48 AM, Jim Davis wrote: > > > This isn't all that odd. in my case the problem is similar, > but comes > > from > > another end. My (very large) company won't consider > either product > > because > > their both too cheap - and so (goes the management > opinion) are not > > fit for > > enterprise use. > > > > > > I used to work for IBM Data Processing Division and many IBM products > were (rumored to be) priced this way (high) because they had a > "perceived" greater worth. > > One specific product comes to mind, CICS. > > This was a back-end terminal to MaimFrame CPU (no network) > information > system. > > It was a good system, but nowhere near the capability, power, > ease-of-use, etc. of CFMX. > > Work was essentially completed on the product in the 1980's > and it went > into maintenance mode (no new development) > > The last I heard the number of users of the CICS (MaimFrame DOS) > version was over 30,000 users. > > The average cost to IBM customers was $3,000 > > per month > > You do the math! > > Dick > > _ > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: A lesson in security by obscurity...
One last note on this topic It seems that there is a problem with number 8 according to root of the site http://www.academy.dyndns.org/ "THE TRAFFIC PROBLEM IN LEVEL 8 WILL BE FIXED THURSDAY" Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 22, 2004 9:05 AM To: CF-Talk Subject: RE: A lesson in security by obscurity... Nope, Firefoxbtw, this thread is continuing in CF-community. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com > -Original Message- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 9:02 AM > To: CF-Talk > Subject: RE: A lesson in security by obscurity... > > Marlon, > > Are you using IE 6? I disabled Active Scripting in Security and the > tags aren't showing up. This is driving me nuts. > > John > > -Original Message- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 9:44 AM > To: CF-Talk > Subject: RE: A lesson in security by obscurity... > > answer at bottom. > > -- > Marlon Moyer, Sr. Internet Developer > American Contractors Insurance Group > phone: 972.687.9445 > fax: 972.687.0607 > mailto:[EMAIL PROTECTED] > www.acig.com > > > > -Original Message- > > From: Burns, John D [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 22, 2004 8:39 AM > > To: CF-Talk > > Subject: RE: A lesson in security by obscurity... > > > > Marlon, > > > > I'm not sure what you mean. I tried selecting everything on the page > > before the _javascript_ prompt and the _javascript_ prompt page. I'm > > confused. Any more help? What am I looking for? > > > > John > > > > -Original Message- > > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, April 21, 2004 10:23 PM > > To: CF-Talk > > Subject: RE: A lesson in security by obscurity... > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED] > > Sent: Wed 4/21/2004 8:14 PM > > To: CF-Talk > > Cc: > > Subject: RE: A lesson in security by obscurity... > > dude its killing me, ive typed everything in I can think of for that > > page, must you be a mindreader or something here...WTF??? > > > > and funny how all of us, well most of us tripped up on this one... > > > > > > spoiler space.. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > .. > > > > select all of the contents on the page with the mouse. > > > > > > I didn't realize it the first time, but you need to disable _javascript_, > otherwise, you'll have to view the source and remove all of the font > tags. If you disable _javascript_, the tags will print out > black characters on a black background. Select them and you have the > clue. > > > > > > > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: best CF host for 20 dollars a month
I don't think they do multi domain hosting but, you can always ask. $7.95/month Mysql CF5 http://www.cheapesthosting.com/ I have few "brochure ware" sites hosted there for my after hours clients. They seem to be a fair hosting provider. I don't think I would do a large ecom site with them. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Wurst, Keith D. [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 10:36 AM To: CF-Talk Subject: best CF host for 20 dollars a month who does everyone think is the best CF host for 20 dollars a month. im hoping to get sql server access as well as host multiple domains (and create sub domains). thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Windows Server 2003
I am *guessing* that CF5 will run on W2k3 server but, I know that it will not install correctly and register the ISAPIs for .cfm in IIS 6. I would highly advise upgrading to CFMX 6.1 if CF5 is not officially supported on W2k3 server, if this is a production server. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 4:39 PM To: CF-Talk Subject: Re: Windows Server 2003 Is CF5 even supported on Win2k3? I would imagine it's not since it didnt exist when CF5 was out. -adam > -Original Message- > From: David Koehler [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 20, 2004 09:37 PM > To: 'CF-Talk' > Subject: Windows Server 2003 > > Ok, our old Dell server needs replacing so we bought a new beast with Windows Server 2003. I installed our CF Server 4.5.1 and then the CF 5 Server update, which had problems finishing. Are there some compatibility issues? Is CF 6.2 something I can download and use instead. Any help is appreciated. > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is it a bug or not a bug?
I am curious on how one would go about using this in "real life". If you're looking for a boolean result then why would you use 5*4 in an _expression_? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 3:24 PM To: CF-Talk Subject: Re: Is it a bug or not a bug? >>it'll return the last value evaluated in the _expression_. This IS the bug: it should return the type implied by the operator in the _expression_. in true and 4*5, CF has a boolean and a boolean operator, It thus has to evaluate 4*5, THEN convert it to a boolean in order to complete the boolean operation. Finally it has to evaluate (true AND true) and return the result true, not 20. There is loosely and too loosely, and too loosely is lousy ;-) ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is it a bug or not a bug?
I thought I had seen someone on this list, when MX came out, warning everyone to not use it due to it broke a convention (or something like that) and it may not be supported in the future versions due to MM did not officially acknowledge it as a feature. So thus I tried to not use it, but I did find it real handy at times. I guess I should read MM docs and not believe everything I read on this list. :-) Does this method of mathematical calculations have an official name? Other then "performing mathematical calculations between # signs". Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 3:32 PM To: CF-Talk Subject: Re: Is it a bug or not a bug? Yes I'm sure they do. I don't know about good or bad, I really haven't thought about it. It does work. Mark W. Breneman wrote: > Does MM officially support performing mathematical calculations between # > signs? I was sorta under the impression that this was considered not a good > practice. Regardless it is handy. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Is it a bug or not a bug?
Does MM officially support performing mathematical calculations between # signs? I was sorta under the impression that this was considered not a good practice. Regardless it is handy. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 2:03 PM To: CF-Talk Subject: RE: Is it a bug or not a bug? >#(true and 4*5)# returns 20. >#(false and 4*5)# returns false. >#(4*5 and false)# returns false. >#(4*5 and true)# returns true. > >Is it a bug or it is using some sort of _expression_ evaluation that I am not >aware of. > CF uses short-circuit boolean evaluation. So it'll either stop the moment it hits a false condition or it'll go to completion. Further, any non-zero value evaluates to true, so 4*5 (20) will always evaluate to true. Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [OT] Dreamweaver nightmare
Right you are! But, I don't want to use the templates as a dream weaver template (that is what CFincludes do for me). I just want to control what contribute users can edit. As far as I know using the templates is the only way I can do that. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 1:18 PM To: CF-Talk Subject: RE: [OT] Dreamweaver nightmare I thought the whole point of templates was that it is a "template" that will be replicated on each of the pages that uses that template. So, if you need to add something to a non-editable region, you would edit the template file and then have the changes cascade to the pages. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com > -Original Message----- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > Sent: Monday, April 19, 2004 1:09 PM > To: CF-Talk > Subject: RE: [OT] Dreamweaver nightmare > > On the same note. Is there a way to over ride the non editable regions? > We > are building contribute templates with DW and the frustrating this is that > I > need to open them in a text editor to make changes to them after adding > non > editable regions. > > > > Maybe some thing like a command line switch when DW loads? > Dreamweaver.exe > /ignorenonedit > > > > I assume that answer is to use homesite that comes with DW. Although, I am > a > big homesite / CFS fan, but I have made the switch to DW. (To be > consistent > with what the rest of the office is using) I don't like switching IDEs mid > stream. Both apps complain that the file has been edited and want to > reload > it. > > > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > _ > > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Monday, April 19, 2004 1:01 PM > To: CF-Talk > Subject: RE: [OT] Dreamweaver nightmare > > > > > We do the combo of the three (CF, DW Templates, and > > Contribute). But, we've found that we must include the html, > > head, and body tags in all our templates, only using > > cfinclude for things like navigation and design elements. > > It's definitely more of a PITA. But, it's the only we've been > > able to make it work. > > I've occasionally been able to get DWMX templates to work without basic > HTML > tags within the page, but typically to do this I have to directly edit the > HTML comments that Dreamweaver uses to define template regions, which is > suboptimal to say the least. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [OT] Dreamweaver nightmare
On the same note. Is there a way to over ride the non editable regions? We are building contribute templates with DW and the frustrating this is that I need to open them in a text editor to make changes to them after adding non editable regions. Maybe some thing like a command line switch when DW loads? Dreamweaver.exe /ignorenonedit I assume that answer is to use homesite that comes with DW. Although, I am a big homesite / CFS fan, but I have made the switch to DW. (To be consistent with what the rest of the office is using) I don't like switching IDEs mid stream. Both apps complain that the file has been edited and want to reload it. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 1:01 PM To: CF-Talk Subject: RE: [OT] Dreamweaver nightmare > We do the combo of the three (CF, DW Templates, and > Contribute). But, we've found that we must include the html, > head, and body tags in all our templates, only using > cfinclude for things like navigation and design elements. > It's definitely more of a PITA. But, it's the only we've been > able to make it work. I've occasionally been able to get DWMX templates to work without basic HTML tags within the page, but typically to do this I have to directly edit the HTML comments that Dreamweaver uses to define template regions, which is suboptimal to say the least. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfloop
I guess the question I was asking is, is there a difference in execution time between tag and script based loops in CF. Would I be better off (shorter execution time) writing a cfscript for a chunk of code that will loop say 1000 times? Or is the difference too small to worry about. It is good to know that they work differently under the hood. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 1:21 PM To: CF-Talk Subject: RE: cfloop Actually, it's both a very useful technique, and only a problem if you're using CFLOOP. Say you want to remove duplicate elements from a list. If you remove anything, you'll just get an "invalid list index" error, but if you use CFSCRIPT you'll be just fine. Here's code for the two different methods. The script call returns "1,2,3,4,5", just as it's supposed to, but the tag call throws an "Invalid list index 6." error. function dedupeListScript(list) { var map = structNew(); var i = ""; for (i = 1; i LT listLen(list); i = i + 1) { if (structKeyExists(map, listGetAt(list, i))) { list = listDeleteAt(list, i); i = i - 1; } else { map[listGetAt(list, i)] = ""; } } return list; } #dedupeListScript(myList)# #dedupeListTag(myList)# > -Original Message- > From: Philip Arnold [mailto:[EMAIL PROTECTED] > Sent: Friday, April 16, 2004 11:05 AM > To: CF-Talk > Subject: RE: cfloop > > > From: Barney Boisvert > > > > > > > > > > > > > > #i#-#arrayLen(a)# > > But why would you do this in the first place? > > Looping over an array that you're changing the size of within the loop > is just asking for trouble > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfloop
On the same note. Is a loop using cfscript or faster, slower or the same on a CFMX server? My guess is that they both compile to the same java byte code. It that correct? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 12:26 PM To: CF-Talk Subject: RE: cfloop Nope, the commas were causing it to stop - interestingly enough, it was pointed out that int(10,000,000) gave up 36,799. At 01:19 PM 4/16/2004, Jim Davis wrote: >Are you sure that you're just not hitting the page timeout? > > > >Jim Davis > > > > _ > >From: Ray Champagne [mailto:[EMAIL PROTECTED] >Sent: Friday, April 16, 2004 11:42 AM >To: CF-Talk >Subject: Re: cfloop > > > >Well, I just did a quick one (index loop) that tried to loop 10 million >times, and it looks like it consistently stops at 36,799 and goes no >further. That help? > > >#i# > > >Ray > >At 11:34 AM 4/16/2004, Tony Weeg wrote: > >hey there. > > > >whats the max number of iterations I can expect cfloop to handle before it > >craps out? > > > >1 million, 2 million? > >any number that anyone knows of? > > > >thanks! > > > >...tony > > > >tony weeg > >senior web applications architect > >navtrak, inc. > >www.navtrak.net > >[EMAIL PROTECTED] > >410.548.2337 > > > > > > > > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRun eating RAM
What is your query cache and template cache set to? If these values are set high then jrun taking 200Mb is more or less normal. Try setting these values lower and see if the server still does that. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 4:25 PM To: CF-Talk Subject: JRun eating RAM Hey All, We've had an odd issue that up until now I was living with...now it's time to fight back!! ;-) We've seen this on CF MX 6.1 on Windows 2000 Advanceed Server 1) A parsing error occurs (i.e. ">") 2) No error is displayed immeadiately 3) JRun starts eating RAM (I've seen it get up to almost 20K before I reboot the server) 4) A minute or more later a fairly non-descriptive CF error shows in the browser 5) JRun never lets go of the memory so I always end up rebooting Now in Dev this is a PIA, but in Prod it's totally unacceptable (but unlikely to happen as we have tested before sending to Prod). I've read up on the few hotfixes and patches for CF MX 6.1, but none seem to apply to this issue. Any idea folks??? TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bread Crumb Trail with CFMX
One thing we have done in the past is to use the file name as a list for the bread Crumb. home_section_subsection_page cfm = Home >> Section >> Subsection >> Page We have done variations based on aberrations that relate to full bread Crumb titles in a database. hm_sec_sub_pg.cfm = Home >> Section >> Subsection >> Page If your nav is totally database driven then it is real simple to build bread Crumbs. All you have to do is to look up the parent of the current page then check to see if that page has a parent .. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 2:34 PM To: CF-Talk Subject: RE: Bread Crumb Trail with CFMX What are you trying to accomplish? Setting up the navigation or storing the results? The simple breadcrumb trail is completely determined by the author-defined hierarchy of pages. You define "this page is in this sub-section which is in this section" and create three links to represent that. Something like: Home >> Section >> Subsection >> Page You can drive this solely by directory structure if you're set up that way, by page-level parameters if your pages are distinct, by template level parameters if you're content is parametized, etc - it really depends on your site structure and the detail of your definition. _javascript_ isn't be as nice an option, I think, since this really is a server-side decision. (That being said I just finished a _javascript_ implementation of a breadcrumb trail/navigation scheme for the office.) Now the other style of breadcrumbs which is rarely seen (but ironically matches the "breadcrumb" metaphor much better) is the clickstream. In this case you display the specific users path the current information, regardless of how you (the author) have organized things. This is as simple as creating a session-scoped array. You just place each page visiting into the array and then, on demand, display the links. I do something like this at www.depressedpress.com (visit a few pages and then choose "Your Clickstream" from the left). I do this mostly for myself (I store the clickstream in the database at the end of the session) but also make it available to the end user. In the end this really isn't something that can be "tacked on" using a pre-canned thing but rather something that's pretty much determined by how you've set up your site. Give us details on that and we should be able to point you in the right direction. Jim Davis _ From: Merritt Chapman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 2:29 PM To: CF-Talk Subject: Bread Crumb Trail with CFMX Does anyone know where I can find a good example of a cf driven bread crumb trail? Maybe a _javascript_ version? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX6.1 updater
I thought I heard about a new service pack for CF too, but a few weeks about Ben had this to say, "The next planned version of ColdFusion is codenamed "Blackstone", and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX any time soon. CFMX needed updates, which is why we released service packs and then v6.1, But 6.1 has proven to be reliable and solid and arguably one of the best ColdFusion's ever, and so a maintenance release is unlikely. Bottom line, use 6.1 now, and stay tuned for announcements from MM." - Ben Forta February 23 CF-Talk - Subject: Re: Question regarding CFMX 6.2 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 3:37 PM To: CF-Talk Subject: Re: CFMX6.1 updater AIT said: > Hey does anyone have any idea when an updater for CFMX6.1 might be > out? I seem to recall somebody commenting that an updater was 'under consideration'. Probably your best bet is http://www.macromedia.com/go/wish/ Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Null Pointer from CFQUERY
Is it the double dots in etrade..Bank that is causing your problem? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Alisa Thomson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 12:25 PM To: CF-Talk Subject: Null Pointer from CFQUERY I am testing out an application that we want to migrate to CFMX (currently CF5). I am getting a NullPointerException from one of my queries when I use jConnect 5.5 (Sybase 12.5) instead of the Sybase driver that ships with CFMX. We want to use jConnect because all of our Java apps use that and we ran into other issues with the driver that ships with CFMX. Here is the query: SELECT FirstNme FROM etrade..Bank WHERE BankId = 'WF' As you can see, there are no variables in the query so the NullPointerException is not caused by an undefined var. The FROM clause is referencing a view that actually references another view in another database. We have other queries set up this same way that work fine under jConnect 5.5. The stacktrace just says: java.lang.NullPointerException no other information. Anyone have any ideas? Thanks in advance. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
If you find that the page is being run by something other than CFSCHEDULE try something like this Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 11:29 AM To: CF-Talk Subject: RE: MX: Scheduler firing off too often At 09:35 AM 4/13/2004, you wrote: >In that email, that you are sending to your self, you may also want to add a >few CGI vars to see where and what is calling that cfm page. One time >Google some how found a .cfm page that I had scheduler set to run once a >week and every time Google spidered the site it would run that page. That's a damn fine idea. Thanks! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX: Scheduler firing off too often
In that email, that you are sending to your self, you may also want to add a few CGI vars to see where and what is calling that cfm page. One time Google some how found a .cfm page that I had scheduler set to run once a week and every time Google spidered the site it would run that page. HTTP_REFERER: #CGI.HTTP_REFERER# HTTP_USER_AGENT: #CGI.HTTP_USER_AGENT# REMOTE_ADDR: #CGI.REMOTE_ADDR# Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 13, 2004 9:48 AM To: CF-Talk Subject: Re: MX: Scheduler firing off too often Ack, should have said "Linux" instead of "Windows" there. At 08:45 AM 4/13/2004, you wrote: >Hey folks - > >I've got an MX box (Windows) with a oddly behaving scheduler. I've got a >single task in the list, that fires off once every three minutes. I've got >the task aborting early, but not before it sends me a quickie time-stamped >email. Every once in a while, I'll get two or three emails with the same >time (sans seconds) on it. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Configuring New CFMX Box
That Is a big question... For starters. 200 - 300 is a lot of sites for one server unless they are low traffic sites. How much traffic do you expect? For this config I might look into clustering two or more CF servers And, running a tool like folder mirror to sync the files on the servers. And, maybe even an extra server for stand a long SQL server. All of my servers have an OS partition, a data base file partition, web file partition and a scratch file partition (raid 0). It may also be a good idea to make an Apps partition depending on what you will be running on the server(s). If you need to supply stats and or keep IIS log files (Like I do) you may even need to have a server for just log files or a large partition. One of my clients have a large conference every three years and during the conference the standard IIS log files will be about 200MB per day. As far as securing IIS : http://www.iisanswers.com/ You will be in fair shape if you use the "Security Operations Guide for Windows 2000" http://www.microsoft.com/downloads/details.aspx?FamilyID=f0b7b4ee-201a-4b40- a0d2-cdd9775aeff8 -a0d2-cdd9775aeff8&displaylang=en> &displaylang=en Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 10:36 AM To: CF-Talk Subject: Configuring New CFMX Box I have and Windows 2000 server that I'm going to configure to host about 200 - 300 CFMX / SQL Server and Access websites. Each site will have its own set of templates (View and Controller templates) but they will all share a set of templates (Model templates). I have never had to worry about the server / administrative end of CFMX and I'm looking for some suggestions on how should I configure the server: 1). for optimal performance, 2). to ensure backup, 3). to secure the application, 4). to facilitate code maintenance and 5). to monitor the performance of the individual sites. I looking for suggestion as it relates to partitioning the drive, patching OS, removing example files, what should go in wwwroot and maybe what should not, what supporting software should I look into. Dwayne Cole, MS in MIS, MBA Florida A&M University Certified Advanced ColdFusion Developer 850-591-0212 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Determining if a value exists in a query result
That is very similar to the way I do it. I think you can skip the query loop by using valuelist(): feature_id)> Note you can simplify that cfif statement in the checkbox down to: The above code *should* work the same as your code just a little simpler. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Austin Govella [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:26 PM To: CF-Talk Subject: Re: Determining if a value exists in a query result Austin Govella wrote: > I have a list of generic features. > > And I have a list of features assigned to a specific item. > > I want to print out the generic features with checkboxes > next to them. > > If the item in question has been assigned one of the > features, I would like the checkbox for that feature to be > checked. > > In the input tag for the checkbox, what function should I be > using to compare the feature_id to the query results? This has taken me all day, but I think the break at lunch helped clear things up for me. After querying the selected features, create an empty variable (it will eventually hold the list of features): Using cfoutput, add each of the selected features to the list: listappend(variables.selected_features,#q_selected_features.feature_id#)> If you output variables.selected_features, you'll see a comma delimited list of feature id's. While ouputting the complete list of possible features, you add a cfif statement to the checkboxes: name="footnote" type="checkbox" value="" IS NOT "0"> checked="checked" /> variables.selected_features is our list of currently selected features. feature_id comes from the full list of possible features. This *is* the easy way to solve this, right? -- Austin _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Tax on shipping OR billing address
That is what I thought. Or at lease what I hoped. Other wise I would have to recode several sites.:-( Thanks! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 08, 2004 11:56 AM To: CF-Talk Subject: RE: OT Tax on shipping OR billing address Nope. Tax is based on destination, and OR doesn't have sales tax, so whether you have ot or not, there isn't any to charge. If there were (in any other state except vermont, I believe), I'm pretty sure you only have to change it if you (the company) actually have a physical presence in the state. Cheers, barneyb > -Original Message----- > From: Mark W. Breneman [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 08, 2004 9:45 AM > To: CF-Talk > Subject: OT Tax on shipping OR billing address > > First off sorry for the off topic. But, no one in the office > can agree on > this.. > > > > While building an ecom site, the debate arose if tax gets > charged based on > the shipping address OR the billing address. > > > > Anyone have an answer to that? Thanks > > > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > > > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT Tax on shipping OR billing address
First off sorry for the off topic. But, no one in the office can agree on this.. While building an ecom site, the debate arose if tax gets charged based on the shipping address OR the billing address. Anyone have an answer to that? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRUN Error: No disk in drive A?
I really wish that I could reproduce this problem on one of my dev servers. Since I see this problem on one of my clients production servers I can't really play with It and try to resolve it. I have a few guesses on what may cause the problem. Check your system path, see if a:\ is in the system path (Go to a command prompt and type "path") Check your CF logs. CFusionMX\logs. See if there is some clue in there. Try disabling RDS if you can Any chance you have a database mapped to the A: drive? You may want to take a peak at the neo-query.xml file. I know that windows has a registry value for the "install path". I wonder if CFMX has something similar. Anyone? Seems like this is something that MAY be able to be tweaked in one of the XML jrun or neo config files. But, I'm not officially suggesting that you go out and start editing those files. ;-) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 10:20 AM To: CF-Talk Subject: RE: JRUN Error: No disk in drive A? Nope, this is just a pure web server. All we have is IIS and CFMX installed. We got the error when restarting the server, not when RDSing. Very odd. If anyone from MM has some insight, please share. John Burns -----Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 10:45 AM To: CF-Talk Subject: RE: JRUN Error: No disk in drive A? I was one of the people looking for a fix for this a few months ago. I see this error when I try to RDS to a client's server. Not sure if this is the same issue. I can't say for sure but, it looks like the RDS call does not time out. So, if you have your Max number of connections set to 2 and you attempt to connect via RDS twice you have no available "connections" and the server is "dead" until someone dismisses the pop up messages. I don't have access to this server so most of this is second hand from the client and thus can not test this theory. I am not aware of any current fix for this. I have heard of a rumor that there is a CFMX 6.1 service pack / hot fix roll up / point upgrade (not sure what it will be officially be called) in the works and that issues like this should be address by it. Just out of curiosity do you have the Novell client installed on the server? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 9:21 AM To: CF-Talk Subject: JRUN Error: No disk in drive A? Anyone know why a server wouldn't restart while giving a JRUN error saying there is no disk in Drive A? I remember this coming up before, but since the search is disabled on the archives, I can't seem to find info on it. Any ideas? John Burns _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRUN Error: No disk in drive A?
I was one of the people looking for a fix for this a few months ago. I see this error when I try to RDS to a client's server. Not sure if this is the same issue. I can't say for sure but, it looks like the RDS call does not time out. So, if you have your Max number of connections set to 2 and you attempt to connect via RDS twice you have no available "connections" and the server is "dead" until someone dismisses the pop up messages. I don't have access to this server so most of this is second hand from the client and thus can not test this theory. I am not aware of any current fix for this. I have heard of a rumor that there is a CFMX 6.1 service pack / hot fix roll up / point upgrade (not sure what it will be officially be called) in the works and that issues like this should be address by it. Just out of curiosity do you have the Novell client installed on the server? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 9:21 AM To: CF-Talk Subject: JRUN Error: No disk in drive A? Anyone know why a server wouldn't restart while giving a JRUN error saying there is no disk in Drive A? I remember this coming up before, but since the search is disabled on the archives, I can't seem to find info on it. Any ideas? John Burns _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Quit Working
Have any security patches been applied? I would check to see if the ISAPI for ..cfm is mapped -Goto your Master website properties. -Click Home Directory -Click Configuration - the application mappings will be displayed. Hope that helps. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 3:04 PM To: CF-Talk Subject: CF Quit Working CF 4.5 on XP Pro (IIS), test machine Came back from vacation and CF pages no longer get served. HTM pages serve correctly. Can't open administrator, naturally. I get the "The Page Cannot Be Displayed" error message. Removal and reinstallation of CF changes nothing. Any suggestions? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
Ok, sureThe code I posted was one part of my "system" that I use for building admin pages or order forms. I originally build this to speed up building admin pages but found that I could use it for any form. Forgive if I over simplify this. Let me start on defining the problem this solves. I build lots of admin type pages and one thing that most admin pages do is to read data from a database and allow you to edit the data. Then you also have the admin pages that you use to add a new record to the database. Some times these add or edit pages need to have required fields. So I all of my admin pages submit the form data to themselves and do some processing to make sure that the required fields are filled and if all required fields are filled it inserts the data into the database. If the required fields are not filled in then the page does not insert the data, and loads the form with a required message next to the missing fields. So what my UDF does is it looks for the value of the input, first in a form var, then in a query var. If neither the form OR query contain a value for the input box then it is just blank. Also, since the form submits to its self then it will pull the value from the form and not the query after you submit the page. Does that help explain what this does? Example: function smartvarText(var1) { if (IsDefined("form.#var1#")) { return #form[var1]#; } else if(IsDefined(queryname &'.'& var1)) { return Evaluate(queryname &'.'& var1); } return ""; } href="" var Query: Form: action=""> t>" method="post"> First Name: value="#smartvarText(variables.var)#" size="35" maxlength="255"> Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 1:24 PM To: CF-Talk Subject: RE: CFIF within input mark, im a bit interested however, im not following what ur saying... can ya explain a bit more..? thanks tonyS -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 1:53 PM To: CF-Talk Subject: RE: CFIF within input I spend way too much time building forms, so I devised a better more flexible way to work with inputs. (IMHO) :-) This is function will look for a form value named "Yellow", then a query value named "Yellow" if it does not find either, it will be blank. This UDF lends its self very well for adding required fields and "add / edit" admin pages.. value="#smartvarText(variables.var)#" size="35" maxlength="255" > All of the outputs are and the cfset out side of the input tag to keep Dream weaver (users) happy. UDF: function smartvarText(var1) { if (IsDefined("form.#var1#")) { return #form[var1]#; } else if(IsDefined(queryname &'.'& var1)) { return Evaluate(queryname &'.'& var1); } return ""; } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Tipton, Joshua [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 10:46 AM To: CF-Talk Subject: RE: CFIF within input _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:34 AM To: CF-Talk Subject: RE: CFIF within input Tony, When I try this I get this error: Parameter 1 of function IsDefined which is now "text" must be a syntactically valid variable name RO -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:32 AM To: CF-Talk Subject: RE: CFIF within input but at the same time...i would... value="#trim(side_1_comments)#" maxlength="100"> just to double check, and its more read-able :) hth tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFIF within input
I spend way too much time building forms, so I devised a better more flexible way to work with inputs. (IMHO) :-) This is function will look for a form value named "Yellow", then a query value named "Yellow" if it does not find either, it will be blank. This UDF lends its self very well for adding required fields and "add / edit" admin pages.. value="#smartvarText(variables.var)#" size="35" maxlength="255" > All of the outputs are and the cfset out side of the input tag to keep Dream weaver (users) happy. UDF: function smartvarText(var1) { if (IsDefined("form.#var1#")) { return #form[var1]#; } else if(IsDefined(queryname &'.'& var1)) { return Evaluate(queryname &'.'& var1); } return ""; } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Tipton, Joshua [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 10:46 AM To: CF-Talk Subject: RE: CFIF within input _ From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:34 AM To: CF-Talk Subject: RE: CFIF within input Tony, When I try this I get this error: Parameter 1 of function IsDefined which is now "text" must be a syntactically valid variable name RO -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:32 AM To: CF-Talk Subject: RE: CFIF within input but at the same time...i would... value="#trim(side_1_comments)#" maxlength="100"> just to double check, and its more read-able :) hth tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:28 AM To: CF-Talk Subject: RE: CFIF within input ur missing a ">" trim(side_1_comments) NEQ ""> value="#trim(side_1_comments)#"> try that. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 06, 2004 11:21 AM To: CF-Talk Subject: CFIF within input I want to display text in a input box's value field if there is any info in the database. The code I'm trying is: trim(side_1_comments) NEQ "" value="#trim(side_1_comments)#"> But I get an error. It seems simple, but I must be missing something I can't see. Any suggestion please? Thanks. Robert O. HWW _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Managment
My $.02. I would use servers alive, then use CFhttp to get the data from Servers alive status webpage to build a pretty CF page. Advice is sometimes worth what you pay for it.. :-) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Tipton, Joshua [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 9:27 AM To: CF-Talk Subject: RE: Managment This is true but I am wanting to do it as a cf page so that the results can be displayed on a web page in a nice way. Josh _ From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, April 02, 2004 10:18 AM To: CF-Talk Subject: RE: Managment Well, I am sure there are loads of DLL's which do that (not specific for CF and probably reside with Windows already) _ From: Joshua Tipton [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 15:20 To: CF-Talk Subject: Managment Does anyone know of a component or dll built for cf that would allow one to monitor services on network servers? _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I really don't know why I care anymore...
After running the updater is the only time I have been able to get the snippet shortcuts to work in DWMX04. I too found that all of my keyboard shortcuts were missing. Then I found that DW had defaulted back to the standard shortcuts. I found my set still in DW just not selected. Now I am as happy as a clam. I still miss several things that CFS did for me. MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 2:13 PM To: CF-Talk Subject: I really don't know why I care anymore... I just ran the glorious updater for DWMX 2K4 and I lost all my precious snippet shortcuts...arrr! All I have to say at this point is that the DWMX developers better have some good solid code lined up in this updater and in the next release or I am jumping ship and never, ever, ever, ever looking back. -Testy in Tampa _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Website hijacking
You may want to check to see if some how a proxy server is being used on your PC. Go to "Internet Properties" in your control Panel and click on the "Connections" tab then click the "LAN Settings." button. And make sure everything is unchecked. (I am assuming you are using some form of router to access the internet.) OR You can go to "Internet Properties" in your control Panel and click on the "Connections" tab then click the "Setup." Button and answer the questions the wizard asks. Setting up a proxy server is a sneaky trick that some spy ware may try to track your browsing. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 12:23 PM To: CF-Talk Subject: OT: Website hijacking Got a question. I just noticed that when I bring up a browser and type. www.houseoffusion.com in the address bar and submit. It first goes to http://list2004.com/p/www.houseoffusion.com before going to http://www.houseoffusion.com Does anyone know how to get rid of this? I can not find it on my PC at all. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL custom Order by
I doubt this is possible, but is there a way to do a custom order by based on the order I provide? I need the SQL results to be in a specific order based on the "catID", but not in ascending or descending order. The order that I want them in is 10,3,5,1,7,4,9,2,6,8. Example Select * >From table Order by catID values(10,3,5,1,7,4,9,2,6,8) I am using MS SQL 2000. Thanks for the help. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT:CF 6.1 files and DW MX 2004 - anyone see this before
I just saw something that is very scary.. One of my co-workers just installed upgraded from DW MX to DW MX 2004. Then he opened a file named home.cfm for one client and left the file open most of the day. Then later, he opened a file named home.cfm for a different client. When he opened the first home.cfm file in a text editor he got the contents of the second home.cfm file. The odd thing is that the file had been "rendered" by CF and saved. It looked just like someone had opened the file in a browser and clicked save. I know no one in the office would have done that. There are only three of us in the office today. All of us know way better then to do that. I rebooted the server after checking it out to make sure it was in good running order. So far so good. Anyone ever see anything like this before? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Jochem van Dieten said: "It should not be that hard to write your own cfinsert and cfupdate if you ever feel the need to abandon them." Yes, I have started several times to plan out just what my Cfupdate any Cfinsert would do based on how we use it, but then I realize that 98% of that is already done by the current Cfupdate and Cfinsert. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 10:26 AM To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) Mark W. Breneman said: > Will that fieldname "date" come back to bite him later? It will probably continue to cause inconvenience, but nothing major. It is just not something you would want a prospective employer to see. > Ha, It must be the masochist in me but I still use Cfupdate and > insert even after CFMX issues and 5+ years of CF programming. Go > figure.. It should not be that hard to write your own cfinsert and cfupdate if you ever feel the need to abandon them. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Will that fieldname "date" come back to bite him later? Seems like I changed a database or two due to other issues related to using the field name "date". Can't remember right now.. Maybe it was just to not use the reserved word.. Thoughts??? Yes using a real SQL statement is the better way to go then to use Cfinsert or Cfupdate. Ha, It must be the masochist in me but I still use Cfupdate and insert even after CFMX issues and 5+ years of CF programming. Go figure.. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 10:05 AM To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) > From: Mark W. Breneman > > I believe that "date" is reserved keyword. Try changing that > field name. Or switch to CFQUERY and put square brackets around the field names _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
I believe that "date" is reserved keyword. Try changing that field name. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:46 AM To: CF-Talk Subject: RE: CFINSERT on CFMX (newbe question) Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred in D:\websites\clients.cfm: line 34 32 : tablename="clients"> 33 : 34 : tablename="clients"> 35 : 36 : SQL insert into clients (COMPANY,DATE) values ( (param 1) , (param 2) ) DATASOURCE devchat VENDORERRORCODE -3502 SQLSTATE 42000 Please try the following: At 10:36 AM 2/24/2004, you wrote: >Marlon Moyer said: > > Has anyone else noticed how handy cfinsert would be if you could get > > the inserted identity back? > >That might be a future possibility once we move to JDBC 3: >http://www.macromedia.com/go/wish/ > >Jochem > >-- >[ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFINSERT on CFMX (newbe question)
Can you give us a code example? I can think of lots of reasons. Is one of your field names a reserved keyword? Like "date"? Are your field names named like "Address", "Address2", "Address3"? See http://www.macromedia.com/support/coldfusion/ts/documents/cfinsert_hotfi x.htm . Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Steven Sharko [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 9:13 AM To: CF-Talk Subject: CFINSERT on CFMX (newbe question) I took an old application that seemed to work fine in CF5 but now on CFMX I get errors with all my cfinsert, Why? Is there a quick fix? Do I have to edit all of them one by one? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question regarding CFMX 6.2
I have been a part of the last two CF server beta programs but, I was way to busy to do any real testing. Unfortunately I found several issue after CFMX 6.0 and 6.1 had been officially released. One such issue caused us to have to tweak a line of code or two for almost all of our clients. So this time I plan to be very active in the beta. Has there been an official beta program set up for black stone? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: David Delbridge [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 3:22 PM To: CF-Talk Subject: Re: Question regarding CFMX 6.2 > I should maybe get in that program and see if I can get some of these > issues addressed, if they have not been yet. An excellent idea, though participation isn't guaranteed. I had to raise a fuss in order to get in on the MX beta, despite being a Macromedia Partner and having participated in previous betas. [?!] That said, there is NO BETTER way to affect positive change than to participate in the beta. If you really, really want to see a particular component of CF working perfectly -- as I did with Advanced Security -- this is your opportunity to throw everything at it you can and see Macromedia trip over themselves to provide prompt fixes. It's a truly wonderful thing to behold. I hope to see you there! Dave -- David M. Delbridge Circa 3000 ColdFusion Hosting http://www.circa3k.com 866-CIRCA3K (247-2235) Outside U.S: +1.775-832-2445 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question regarding CFMX 6.2
No planned maintenance release anytime soon? Sigh, that is too bad, I was hoping some of the minor "issues" would be addressed in CFMX 6.1 soon. But, more than likely this issues that bug me and my clients are minor enough and affect only a few people I can understand how they be temporarily ignored. Has black stone entered Beta testing yet? I should maybe get in that program and see if I can get some of these issues addressed, if they have not been yet. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:57 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Right now we are aggressively working on Blackstone. That is not to say that there'll not be a release between now and then, but I am unaware of any planned maintenance release at this point. If one becomes critical and necessary, then I am sure that one will be released (if hot fixes are not an option). --- Ben _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:50 PM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 Ben Correct me if I'm wrong but aren't there still bugs and known issues with 6.1. Are you suggesting that there are no immediate plans to address these? Thanks Kola -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 23 February 2004 16:29 To: CF-Talk Subject: RE: Question regarding CFMX 6.2 CFMX 6.2? I don't believe that version numbers and editions have been discussed at all, actually. Generally, maintenance releases have been free upgrades (as 6.1 was) whereas full product releases have been paid upgrades (and included in subscriptions, of course). The next planned version of ColdFusion is codenamed "Blackstone", and version numbers, pricing, etc., have yet to be discussed at all. But, and this is my own opinion here, I doubt that there will be another maintenance release for CFMX any time soon. CFMX needed updates, which is why we released service packs and then v6.1, But 6.1 has proven to be reliable and solid and arguably one of the best ColdFusion's ever, and so a maintenance release is unlikely. Bottom line, use 6.1 now, and stay tuned for announcements from MM. --- Ben _ From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:16 AM To: CF-Talk Subject: RE: Question regarding CFMX 6.2 I am wondering, will CF 6.2 be a free upgrade from 6.1 or will MM want us to pay for it? And if $$$ is involved, how much? TK -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 10:21 AM To: CF-Talk Subject: Re: Question regarding CFMX 6.2 On Monday 23 Feb 2004 09:21 am, Jochem van Dieten wrote: > Macromedia is thinking about: > http://mxeurope.org/go/objectid/CAAA4C2A-50DA-4D01-876C3488A0F5D98A "simpler ways to create compelling UIs, " Does that sound like shiping some sort of cut-down Flex to anyone else ? In the same way they implemented cfchart by shipping a cut down version of their own stand alone graphing app ? "Increasing productivity" Could be anything ! "new ways for deploying your apps" As MX is a J2EE system, I hope that means jar/ear/war type stuff :-) "source code protection." Intresting. Just a better front end to cfencrypt, or something more industrial ? When is pricing etc. info for MAXEurpoe going to be announced ? Is there an annoucements mailing list for it yet ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DW2004 Snippet madness
Yes, you are correct. I am simply using the # snippet as an example. I have other snippets, more complex, that I need to be able to use. But, for now I am doing just what you suggested. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 12:31 PM To: CF-Talk Subject: Re: DW2004 Snippet madness "Let me rephrase my problem, I can assign a keyboard shortcut to a snippet, via the shortcuts GUI, but I have yet to get one to work. When I use the shortcuts GUI I am trying to assign Ctrl+3 to a snippet that will wrap the selected text in #s." I'm not sure why you're doing this. You can just reassign the Ctrl-3 keyboard shortcut to override the current Ctrl-3 which is H3. I've been doing this in DWMX and DWMX2004 for ages. You don't have to remap it to a snippet, you can just change what it's currently mapped to by creating a duplicate keyboard shortcut set, then changing it to your heart's content. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DW2004 Snippet madness
I wish it was that easy. :-) I assume by your responses that this issue may be related to my PC although my laptop seems to do the same thing. Let me rephrase my problem, I can assign a keyboard shortcut to a snippet, via the shortcuts GUI, but I have yet to get one to work. When I use the shortcuts GUI I am trying to assign Ctrl+3 to a snippet that will wrap the selected text in #s. After I assign Ctrl+3 to my snippet, I can see that Ctrl+3 looks like it has been correctly assigned to the snippet but, after I close the shortcuts GUI the shortcut does not work and when I open the shortcuts GUI, Ctrl+3 defaults back to H3. I have no problem assigning Ctrl+3 to another command like "select all", the problem only comes in when I try to assign it to a snippet. Is it possible that I had a bad previous install of DW MX (non 2004)? I have tried uninstalling all DWs and only reinstalling MX2004 but, I seem to have the same problem Thank for the help. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 11:17 AM To: CF-Talk Subject: Re: DW2004 Snippet madness > I have the trial of DW MX 2004 installed and I can not assign any > snippets to keyboard shortcuts. I need these short cuts or else DW is > useless to me. Yes, I have duplicated the "MM Standard set" and I can > assign other types of commands to keyboard short cuts, just not > snippets. Select "Snippets" from the "Commands" drop-down inside the Keyboard shortcuts GUI. > Also where does DW store the user snippets? I would have expected it to > store them in the Configuration\Snippets but only the default ones are > in there. Is it possible to edit the keyboard short cut config file > directly? If so where is that stored? http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: DW2004 Snippet madness
First off sorry for the off topic, but this is driving me mad and I know some out there will have the answer. I mostly hate dream weaver, but I am trying to give it a fair try. I have the trial of DW MX 2004 installed and I can not assign any snippets to keyboard shortcuts. I need these short cuts or else DW is useless to me. Yes, I have duplicated the "MM Standard set" and I can assign other types of commands to keyboard short cuts, just not snippets. Any ideas? Also where does DW store the user snippets? I would have expected it to store them in the Configuration\Snippets but only the default ones are in there. Is it possible to edit the keyboard short cut config file directly? If so where is that stored? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX looking for disk in A: Drive when RDSing???
CFfile. interesting. Is this a problem everyone is having? This client's server is the only one that I have seen this problem with. Can you clarify "next release"? Are we talking Black stone or something like CFMX 6.2? Does anyone know of any un-official work arounds for this? Is there any way to direct RDS to not look at the A drive? Or anyway to make the root of the RDS server the "D:" drive? Thank you so much for this info, Christine. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 4:27 PM To: CF-Talk Subject: RE: CFMX looking for disk in A: Drive when RDSing??? Hi Mark, Using ftp has been the workaround, maybe you could use cffile? It's not on our list of known issues as we don't have every bug published there. I've added your vote to our bugtracking system for a fix, it is currently targeted for the next release. Best Regards, Christine -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 3:29 PM To: CF-Talk Subject: RE: CFMX looking for disk in A: Drive when RDSing??? Thanks for the info FTP is not an option in this case. This client will not open up the firewall for anything other than POP SMTP, HTTP and HTTPS. Any chance there is a tweak for this or a hot fix in the works? The other option is for me to email the files and wait for the IT person to get around to putting them on the server. Is 49148 an official known issue number? I am not able to find it on the MM website, Forums or google. Thanks Christine! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:56 PM To: CF-Talk Subject: RE: CFMX looking for disk in A: Drive when RDSing??? This is bug 49148, I'd suggest you use ftp instead and disable RDS per our documentation: http://livedocs.macromedia.com/coldfusion/6/Installing_ColdFusion_MX/con n> figu ring6.htm nfig uring6.htm> Best Regards, Lawson Macromedia Technical Support -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:27 PM To: CF-Talk Subject: CFMX looking for disk in A: Drive when RDSing??? Hey All, We have a client, that just upgraded to CFMX, that claims that every time we connect to their CFMX 6.1 server with RDS, a message pops with an error message something like "Jrun.exe Error: No disk in Drive A:". Needless to say this makes the client really nervous. (Especially when they think RDS is some form of magic anyway ;-) Has anyone seen anything like this? It seems that I can not make a RDS connection until the client dismisses the error. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX looking for disk in A: Drive when RDSing???
Thanks for the info FTP is not an option in this case. This client will not open up the firewall for anything other than POP SMTP, HTTP and HTTPS. Any chance there is a tweak for this or a hot fix in the works? The other option is for me to email the files and wait for the IT person to get around to putting them on the server. Is 49148 an official known issue number? I am not able to find it on the MM website, Forums or google. Thanks Christine! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:56 PM To: CF-Talk Subject: RE: CFMX looking for disk in A: Drive when RDSing??? This is bug 49148, I'd suggest you use ftp instead and disable RDS per our documentation: http://livedocs.macromedia.com/coldfusion/6/Installing_ColdFusion_MX/con figu ring6.htm nfig uring6.htm> Best Regards, Lawson Macromedia Technical Support -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 1:27 PM To: CF-Talk Subject: CFMX looking for disk in A: Drive when RDSing??? Hey All, We have a client, that just upgraded to CFMX, that claims that every time we connect to their CFMX 6.1 server with RDS, a message pops with an error message something like "Jrun.exe Error: No disk in Drive A:". Needless to say this makes the client really nervous. (Especially when they think RDS is some form of magic anyway ;-) Has anyone seen anything like this? It seems that I can not make a RDS connection until the client dismisses the error. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX looking for disk in A: Drive when RDSing???
Hey All, We have a client, that just upgraded to CFMX, that claims that every time we connect to their CFMX 6.1 server with RDS, a message pops with an error message something like "Jrun.exe Error: No disk in Drive A:". Needless to say this makes the client really nervous. (Especially when they think RDS is some form of magic anyway ;-) Has anyone seen anything like this? It seems that I can not make a RDS connection until the client dismisses the error. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import snippets into Dreamweaver MX 2004?
Ok, I feel dumb. It worked. I could have sworn that I tried the exact same thing and it failed the first time. Thanks Massimo! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 9:44 AM To: CF-Talk Subject: Re: Import snippets into Dreamweaver MX 2004? > when i make a snippet i just make it in homesite and save it and when i > open up dwmx there it is. so i'd assume u can do the same HS 5.5 stores snippets using the same XML based format used by DW. In order to convert snippets from older versions of Homesite/CF Studio you can use: http://www.dwfaq.com/Snippets/converter.asp Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Import snippets into Dreamweaver MX 2004?
Is there any way to import snippets from Coldfusion Studio 5 into of Dreamweaver MX 2004? Looks like Massimo Foti awesome snippet converter only works for MX and not 2004. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RDS looking for disk in A: Drive???
Hey All, I have a client, that just upgraded to CFMX, that claims that every time we connect to their CFMX 6.1 server with RDS, a message pops with an error message something like "Jrun.exe Error: No disk in Drive A:". Has anyone seen anything like this? It seems that I can not make a RDS connection until the client dismisses the error. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: flusing the trusted cache
I was going to ask this a MAX but never got to. Is there anyway to send a command (java? or other ) to flush the trusted cache? If not can that be a new feature of black stone? I have several times that I would love to turn on trusted cache but, I can't reset the server to make updates. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 2:51 PM To: CF-Talk Subject: RE: flusing the trusted cache Have to cycle the server. That's the point of the trusted cache, it never has to hit the filesystem except on startup. barneyb > -Original Message- > From: walker [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 23, 2003 12:44 PM > To: CF-Talk > Subject: flusing the trusted cache > > We just turned on the "trusted cache" in the cf administrator > (CF5.0 on > Solaris), and now I can't seem to flush it when small changes > are made. The > old pages still show. > > Anyone got any tricks for cleaning the trusted cache out? > > thanks in advance. > > > > > _ > walker fenton > [EMAIL PROTECTED] > 303.722.5473 > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Scsi hd
Robert, Do you have the driver disk (probably a floppy) that came with the Adaptec card? I am thinking that you will need to specify an additional driver for the Adaptec card when you do the windows 2000 install. (Hit F6 during the install when it tells you to.) I seem to remember a server of mine momentary, when doing an install, flashing to a BSOD (Blue Screen Of Death), then rebooting, if I did not load the driver for my Adaptec card. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:03 PM To: CF-Talk Subject: OT - Scsi hd Sorry this is OT, but it's only one of the few times I've asked. I need to upgrade my server running CF. I have SCSI HD's and an Adaptec Array adapter. I installed the new HD and then one of the older larger HD's which I will put the OS (windows 200) on it. I setup the cd-rom as the boot and put the 2000 cd in it. However, the system boots, recognizes the HDs, the light comes on the cd but it then reboots and does not start the Server 2000 setup. Did I explain enough or is there more to this than meets the eye? Thanks as always and excuse the OT on this please. Robert Orlini HW Wilson 718-588-8400 x2656 ô¿ô _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Win 2003 SBS
Dan what is considered "Loaded with RAM" in the context of a server with Win, CF and SQL? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 10:58 AM To: CF-Talk Subject: RE: Win 2003 SBS We have a few clients running dedicated servers with this setup. No problems to report so far (that they have made me aware of anyway). Careful running Win, CF, and SQL on the same box though. Load it up with RAM and keep an eye on traffic. Dan Phillips www.CFXHosting.com 1-866-239-4678 x105 [EMAIL PROTECTED] -Original Message- From: Jeffrey Pratte [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 10:46 AM To: CF-Talk Subject: Win 2003 SBS I am buying a new box to use as a Cold Fusion server. I was thinking about buying the Microsoft Windows Small Business Server 2003 premium edition ($1499), since it comes with Win 2003, and SQL Server. Does anyone have experience with this? Is it a good choice? Thanks, jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: REPOST: CFMX and variables available on error
On the same note, I am looking to beef up my error handlers. In an effort to cut my trouble shooting time, is there anyway to get a list and SQL code for all queries ran, session vars, form vars, etc from the page that threw the error? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, October 31, 2003 11:08 AM To: CF-Talk Subject: RE: REPOST: CFMX and varaiables available on error > Thanks Dave...but what should I dump?? ;-) Dump the Error or CFCATCH scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How To Force Landscape Oriented Printing
Hey, I got a client clamoring for that too. The client claims that they have seen it done. The only way I found to do it was with an active X control. Active X would not be a good solution for this client due to the wide diversity of browsers that visit the site that do not support active x. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Kumar, Senthil [CC] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 2:38 PM To: CF-Talk Subject: How To Force Landscape Oriented Printing Not Exactly CF Talk - MayBe HTML Talk or CSS Talk. How would I force a Report to be printed always in a landscape format. The following code, did not work. New Document <br> <br> @media print{<br> <br> BODY {<br> <br> Size: landscape;<br> <br> }<br> <br> }<br> <br> hi _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 Session problems - help
Ok, from what I am hearing, it seems that my code may be the problem, not the session ID "jumping" problem. Is that Correct? Can anyone confirm that they have no problems with session vars in CFMX? I will be very happy if it is just my code. That is something I can fix. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:41 PM To: CF-Talk Subject: RE: CFMX 6.1 Session problems - help > Don't CFLOGIN and CFLOGOUT also rely on session vars to track > the user? > Not by default. You can turn it on using loginStorage="session" in the cfapplication tag, but only using MX 6.1. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 Session problems - help
Nope, I am not using URL vars for session storage. Don't CFLOGIN and CFLOGOUT also rely on session vars to track the user? MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 10:58 AM To: CF-Talk Subject: RE: CFMX 6.1 Session problems - help I thought CFMX fix the session "jumping" problems that CF 5 had and thus did away with the need to lock session vars, other then in race conditions. Is this true? Is it possible that locking causes a problem if CFMX? [Tom Kitta] As far as Macromedia is disclosing, there is no need for shared variable locking if no race conditions are to occur. If you don't lock you shared variables no memory corruption will occur in CFMX and above. However, you still need to lock if race conditions might occur. There is a tech note about that on MM site which I have read a while ago. As for users seeing each other's sessions - do you maybe use url variables for session storage? It was and is a common problem in session sharing. Other than that, consider using security based solely on CF model without any session.userID stuff. In other words use CFLOGIN and CFLOGOUT. TK Thoughts? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query-past protection?
I guess I sorta see it as fixing an inconsistency. If you run a query like this in CF 5: Select name from table where 0=1 (This query will not return a record set) And then try outputting the value of name: #getname.name# You do not get an error. But if you tried to output : #getname.name[1]# You would get an error in CF 5. Now in CFMX they both work the same. But, yes this should be documented. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 11:40 AM To: CF-Talk Subject: Re: Query-past protection? If its a feature rather than an oversight then it should be clearly notes. I expected an error and when I didn't get it, I was concerned. Don't get me wrong, it's nice but it worries me when an expected error based on code logic does not exist. If it is a feature, I wonder how many other 'anti-error' features have been included. > Michael, > > > > I think this is an "improvement" in CFMX. I know in CF 5 if you try to > access a query element that does not exist, you would get an error. > But, in CFMX it seems to gracefully handle this. > > > > Can anyone confirm this? > > > > MB > > > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED] > Sent: Monday, October 27, 2003 11:13 AM > To: CF-Talk > Subject: Query-past protection? > > > > OK, here's a strange one that I need others to test out. Run a query, > then > try to access an element past the amount in the query. > > select top 1 columnname from table > > #queryname.columnname[1000]# > What should happen is an error message saying your trying to access a > query > element outside the range of the query results. What I'm getting is a > blank > value. If others get the same thing then it's an interesting 'feature' > that > should be noted, despite it being technically wrong. > > > > _ > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query-past protection?
Michael, I think this is an "improvement" in CFMX. I know in CF 5 if you try to access a query element that does not exist, you would get an error. But, in CFMX it seems to gracefully handle this. Can anyone confirm this? MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 11:13 AM To: CF-Talk Subject: Query-past protection? OK, here's a strange one that I need others to test out. Run a query, then try to access an element past the amount in the query. select top 1 columnname from table #queryname.columnname[1000]# What should happen is an error message saying your trying to access a query element outside the range of the query results. What I'm getting is a blank value. If others get the same thing then it's an interesting 'feature' that should be noted, despite it being technically wrong. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 Session problems - help
I have a site that seems to have problems with confusing users with each other. This only happens to about 1% or less of the users. A user will sign in and the person next to them will sign in and they may get each others data. The site uses session.userid as the identifier. The only place session.userid is set is on the login page. After the session.userid is set the user is then forwarded to the main page. This site was written for CF 5 so it does have lock tags around all writes to session vars. I don't think all of the reads are locked any more. I have made changes to some of the code since upgrading to CFMX I thought CFMX fix the session "jumping" problems that CF 5 had and thus did away with the need to lock session vars, other then in race conditions. Is this true? Is it possible that locking causes a problem if CFMX? Thoughts? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Credit Card processing- Address Verification (AVS) w/ Verisign
Hello Jann, I am looking to maybe upgrade to cfx_payflowpro from CFX_paymentnet. What did you have to do to get cfx_payflowpro to work with CFMX? Are you using MX? The instructions I read through seemed to indicate that I needed to replace the version of java that CF runs to use cfx_payflowpro. Is that correct? Looking back on when I read the instructions, that may have been the instructions to installing cfx_payflowpro for CF 5. Can you shed some light on this? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: J E VanOver [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:27 AM To: CF-Talk Subject: Credit Card processing- Address Verification (AVS) w/ Verisign Repost with subject heading changed -- I'll have to implement something today whether I get advice or not -- I'll do option 4) unless I get better advice. I have asked VeriSign customer service the same question and if anyone else is interested will pass on their advice. --- Here's the original question: I'm doing my first DEEP foray into Verisign and credit card processing - maintaining an existing system. Already working well with cfx_payflowpro (VERY easy to use, btw). I'm adding AVS (Address Verification) and want to know how others are handling it. To use AVS, you must either: 1) request authorization (A), and then, if it's good, Capture (D) the charge, if it's not good, Void(V) the charge. But VSign doesn't let you void an Authorization so you have to Capture it anyway before voiding. 2) Same as #1, but Credit (C) instead of Void (V). Apparently, this releases the funds within 48 hours where a Void may take up to 30 days to release the funds. But a Credit (C) shows up on the customer's credit card statement. 3) Request Sale (S), then if it's good, do nothing. If it's not good, request Void (V). ?? Would this Void show up on customer's statement? 4) Same as #3, but Credit (C) instead of Void (V). With a Credit (C) shows up on the customer's credit card statement. PLEASE let me know what YOU are doing in similar situations! Thanks Jann _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_PAYMENTNET and verisign Problems?
Is there anyone out there using CFX_PAYMENTNET and verisign having problems in the last 12 hours when attempting to charge cards? All transaction seem to get and result code of RESULT=-9&RESPMSG=SSL_Read() incorrect length received. The error relates to a SSL comm. failure. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
Dave, as always, true. Maybe I should be asking if there is worm scanning software out there that has auto-up-dating worm defs. And maybe I should do my homework and 2x check that Norton Anti Virus does scan and prevent worms from infecting a computer. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:38 AM To: CF-Talk Subject: RE: Antivirus software on web server > The question was brought up, that how would you ever know > if your server was infected without some software scanning. > My argument to that was if the server is correctly secured > that should never be an issue, but, with new exploits being > discovered each month the chances go up that the server > could be compromised before the patch is applied. If you're concerned about server exploits, a virus scanner probably isn't going to help you very much, if at all. You're much better off using a host-based firewall to limit inbound and outbound traffic appropriately, and use something wherever possible to examine that traffic (stateful packet inspection at your host-based firewall, or a web server input filter, for example). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
Adam, If I install NAV, I'll be glad to post back to the list the results. I am not planning on running scheduled system scans. I am not too worried about file based viruses (boot sector, Trojan or email/scr), what I am hoping to prevent is worms that prey on security holes like slammer, blaster or Code Red. I am 99% sure that my servers are secure, my software firewall and hardware firewall are configed correctly and all relevant patches are applied, but if I miss one, I could spend my weekend rebuilding a server. It would be nice if there was a web server version of NAV. Or something that is ultra light on CPU time and system resources. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 10:50 AM To: CF-Talk Subject: RE: Antivirus software on web server Mark, Once get your anti-virus software installed and running on you web server, would you mind sharing with the list what kind of performance impact it creates. Are you planning to run scheduled system scans? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 11:45 AM To: CF-Talk Subject: RE: Antivirus software on web server True it probably would show in the task or process lists, but if I were to write a worm/Trojan, I would make it show up in the task list as SVCHOST.exe, the generic name of a DLL process. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 9:41 AM To: CF-Talk Subject: Re: Antivirus software on web server Mark W. Breneman wrote: > > As much as I am opposed to the idea, I am leaning towards installing > Norton Antivirus Corporate on all of my web servers. > > The question was brought up, that how would you ever know if your server > was infected without some software scanning. You see it in the task list. And if it does anything besides being there (like trying to spread), you see that in your network traffic. Jochem _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
Hey that is kinda handy. tlist I learn something each day. (Now that I have learned it, too bad I can't go back to bed :-) Thanks! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 10:45 AM To: CF-Talk Subject: Re: Antivirus software on web server Mark W. Breneman wrote: > True it probably would show in the task or process lists, but if I were > to write a worm/Trojan, I would make it show up in the task list as > SVCHOST.exe, the generic name of a DLL process. 1. You know how many of those you have on your server. 2. tlist will show the application names behind svchost.exe Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
True it probably would show in the task or process lists, but if I were to write a worm/Trojan, I would make it show up in the task list as SVCHOST.exe, the generic name of a DLL process. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 9:41 AM To: CF-Talk Subject: Re: Antivirus software on web server Mark W. Breneman wrote: > > As much as I am opposed to the idea, I am leaning towards installing > Norton Antivirus Corporate on all of my web servers. > > The question was brought up, that how would you ever know if your server > was infected without some software scanning. You see it in the task list. And if it does anything besides being there (like trying to spread), you see that in your network traffic. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Antivirus software on web server
Thanks everyone . As much as I am opposed to the idea, I am leaning towards installing Norton Antivirus Corporate on all of my web servers. The question was brought up, that how would you ever know if your server was infected without some software scanning. My argument to that was if the server is correctly secured that should never be an issue, but, with new exploits being discovered each month the chances go up that the server could be compromised before the patch is applied. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: NATHAN C. SMITH [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 4:44 PM To: CF-Talk Subject: RE: Antivirus software on web server I think it is a necessary evil. People are finding too many neat ways for things to creep across networks. -Nate -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 12:23 PM To: CF-Talk Subject: SOT: Antivirus software on web server I can remember this topic has been hashed over a few different times here, over the years. Has the opinions changed over the last year or so? Do YOU have antivirus software on your servers? Do you recommend it on web servers? If so, what software? I have in the past been on the side of not needing AV software on the server. Now I am, and have been for a few months, sitting on the fence. A few years ago, as a computer tech, I said that AV software is very good to have at home / office but not nessicry. Now, I highly recommend AV software on any computer that is connected to the net in the home / office environment. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF controlled security for downloading doc xls etc. files.
We are about to start working on a feature for a client that would allow a user that is logged in to down one several different types of files. The idea is to have CF list the files that the user has access to and be able to download them by clicking on the link. The one trick it that these files should not be accessible to anyone else even if they have the path to where the file is. I just thought I would ask the lists' wisdom on these two ideas: One idea was to use cffile and cfcontent to force a download. Has anyone tried this? I can see it working for txt files but what about pdf and zip files? Idea two was to have CF make a folder name based on a UUID (universal unique ID) and have CF copy the file from a non shared drive to this folder. Then delete it a few mins later. Any thoughts / comments? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Antivirus software on web server
I can remember this topic has been hashed over a few different times here, over the years. Has the opinions changed over the last year or so? Do YOU have antivirus software on your servers? Do you recommend it on web servers? If so, what software? I have in the past been on the side of not needing AV software on the server. Now I am, and have been for a few months, sitting on the fence. A few years ago, as a computer tech, I said that AV software is very good to have at home / office but not nessicry. Now, I highly recommend AV software on any computer that is connected to the net in the home / office environment. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ok, I give up UDF error
Thank you so much for your help. I had assumed that there was something wrong with my UDF coding. Looks like it may well be a problem with the values the UDF returns. Thanks!!! Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 4:47 PM To: CF-Talk Subject: RE: Ok, I give up UDF error Mark, I can put TID=1 to 10 in there and it works as well (both encode and decode). (as query string) Here's your specified input endocded and decoded http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm For me - this works. There must be something in that string you are keeping from me (ha). output each character code in the qencode function like this: for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr + 3); //writeoutput("asci code IS : " & tempstr & " and new character looks like " & chr(tempstr + 3) & ""); } Then take a look at the list of characters - see if anything pops out at you (like invisible characters for example... -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 4:14 PM To: CF-Talk Subject: RE: Ok, I give up UDF error Good theory, but. See my last posting where I have included both the qencode and the qdecode function. The qencode may indeed wrap through the ascii code table but, where I am running the left function the values have already been decoded (de-shifted). All I am trying to do is to get rid of the random number on the end. The values I am inputting is: Input Encoded Output TID=1 WLG%286G45 TID=1 TID=2 WLG%286G5%3A TID=2 TID=3 WLG%286G63 TID=3 TID=4 WLG%286G73 TID=4 TID=5 WLG%286G84 TID=5 TID=6 WLG%286G93 TID=6 TID=7 WLG%286G%3A6 TID=7 TID=8 WLG%286G%3B9 TID=8 TID=9 WLG%286G%3C3 TID=9 TID=10 WLG%286G437 TID=10 #qencode('TID=1')# should return "WLG%286G45" then #qdecode('WLG%286G45')# should return the starting value of "TID=1". Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:50 PM To: CF-Talk Subject: RE: Ok, I give up UDF error Actually, I tried this function and it works fine for me. What are you passing into the function? what's the purpose? Here's a test that passes in cgi.query_string gives a cryptic strring as a return. http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?object=true Throws an error: http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm Throws an error: http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?o If the string is less than 1 character long it throws an error. I can only assume that something is crazy about the value being passed IN to the function. This function appears to take items and shift the ascii character code value 3 to the left. I'm guessing that the ascii character code in some cases is less than 3 causing some sort of end marker to be placed and thus befuddling your "len( )". I would do something like: if(tempStr LT 4) tempStr = tempStr + 254; Then your values would "wrap" through the ascii code table. -Mark -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:16 PM To: CF-Talk Subject: Re: Ok, I give up UDF error What does this do for you? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } strReturn = 'Too Short:' & newstr & ':end'; if (len(newstr)+1) strReturn = left(newstr,len(newstr)-1); } - Calvin - Original Message - From: Mark W. Breneman To: CF-Talk Sent: Wednesday, October 08, 2003 3:52 PM Subject: RE: Ok, I give up UDF error Good question, but no, I have ran the output sever
RE: Bots / spiders finding unlinked pages... SOVLED!
Thanks for all of your help. The mystery has been solved. We recently gave the client a copy of the full log files from the past three years. It sounds like they loaded the log files into NetTracker/6.0 Enterprise and hit "GO". Lucky thing that the admin pages are coded to require a user to be login via a session var in order to access the admin pages. It would not have been fun to restore form back up all of the data that could be deleted from the admin pages. (130ish admin pages that control the site content) We promptly told them to stop. Any data that they would get form 3 years of log file spidering would be very inaccurate. So many of the pages have been renamed , moved .etc. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 4:42 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? Also, I'd look in your logs. I'd find the reference relating to your search engine and the hidden page. It should tell you the name of the program that requested it. Then look for references just before it. One of those pages might have told the engine about your hidden page. DRE -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:22 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? does the program tell you the refering pages? On google you can find out how many sites have links to yours. Also, you might want to check that none of your hidden files are the folder default files as well. DRE -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 1:55 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? Another way, I've heard of "hidden" files being found is by user's browsing. If a user was looking at one of these non-linked files, then moved onto another page. The URL of the hidden file is available as "HTTP-Referrer" This could then be followed back to the original file. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 12:06 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? One possible way is if you have a search feature built into your site. Internal search engines index files not by URL but by directory/file and would therefore find "hidden" documents. If the spider can somehow access a search results page (submit a blank form maybe?) those files might show up. Regardless, never assume that a file is safely hidden on your website simply because it is not linked to. There have been several high profile "finds" of "hidden" files ranging from obituaries for people who were not dead to sensitive internal documents. As a rule, don't put anything on a web server unless you're willing to let people see it. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 12:42 PM To: CF-Talk Subject: OT:Bots / spiders finding unlinked pages... How? One of our clients' IS department just got NetTracker/6.0 Enterprise and has set it loose on the site. It has found several pages that are not linked from any where. I do not have directory browsing turned on and I know these pages are not linked from any page.. How is it possible that it found these unlinked pages? Can other Bots / spiders also find unlinked pages? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Bots / spiders finding unlinked pages... How?
We the developer do not have access as of yet to the NetTracker/6.0 Enterprise results. I am assuming we will get a copy of it in a report of stuff we need to fix. BTW it looks like NetTracker/6.0 Enterprise calls the pages with any url vars. Can't wait to see the report on that. None of the pages that NetTracker/6.0 Enterprise is finding are default files. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 4:22 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? does the program tell you the refering pages? On google you can find out how many sites have links to yours. Also, you might want to check that none of your hidden files are the folder default files as well. DRE -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 1:55 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? Another way, I've heard of "hidden" files being found is by user's browsing. If a user was looking at one of these non-linked files, then moved onto another page. The URL of the hidden file is available as "HTTP-Referrer" This could then be followed back to the original file. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 12:06 PM To: CF-Talk Subject: RE: Bots / spiders finding unlinked pages... How? One possible way is if you have a search feature built into your site. Internal search engines index files not by URL but by directory/file and would therefore find "hidden" documents. If the spider can somehow access a search results page (submit a blank form maybe?) those files might show up. Regardless, never assume that a file is safely hidden on your website simply because it is not linked to. There have been several high profile "finds" of "hidden" files ranging from obituaries for people who were not dead to sensitive internal documents. As a rule, don't put anything on a web server unless you're willing to let people see it. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 12:42 PM To: CF-Talk Subject: OT:Bots / spiders finding unlinked pages... How? One of our clients' IS department just got NetTracker/6.0 Enterprise and has set it loose on the site. It has found several pages that are not linked from any where. I do not have directory browsing turned on and I know these pages are not linked from any page.. How is it possible that it found these unlinked pages? Can other Bots / spiders also find unlinked pages? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ok, I give up UDF error
Good theory, but. See my last posting where I have included both the qencode and the qdecode function. The qencode may indeed wrap through the ascii code table but, where I am running the left function the values have already been decoded (de-shifted). All I am trying to do is to get rid of the random number on the end. The values I am inputting is: Input Encoded Output TID=1 WLG%286G45 TID=1 TID=2 WLG%286G5%3A TID=2 TID=3 WLG%286G63 TID=3 TID=4 WLG%286G73 TID=4 TID=5 WLG%286G84 TID=5 TID=6 WLG%286G93 TID=6 TID=7 WLG%286G%3A6 TID=7 TID=8 WLG%286G%3B9 TID=8 TID=9 WLG%286G%3C3 TID=9 TID=10 WLG%286G437 TID=10 #qencode('TID=1')# should return "WLG%286G45" then #qdecode('WLG%286G45')# should return the starting value of "TID=1". Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:50 PM To: CF-Talk Subject: RE: Ok, I give up UDF error Actually, I tried this function and it works fine for me. What are you passing into the function? what's the purpose? Here's a test that passes in cgi.query_string gives a cryptic strring as a return. http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?object=true Throws an error: http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm Throws an error: http://dev.mxconsulting.com/sergv2/testSTringUdf.cfm?o If the string is less than 1 character long it throws an error. I can only assume that something is crazy about the value being passed IN to the function. This function appears to take items and shift the ascii character code value 3 to the left. I'm guessing that the ascii character code in some cases is less than 3 causing some sort of end marker to be placed and thus befuddling your "len( )". I would do something like: if(tempStr LT 4) tempStr = tempStr + 254; Then your values would "wrap" through the ascii code table. -Mark -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:16 PM To: CF-Talk Subject: Re: Ok, I give up UDF error What does this do for you? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } strReturn = 'Too Short:' & newstr & ':end'; if (len(newstr)+1) strReturn = left(newstr,len(newstr)-1); } - Calvin - Original Message - From: Mark W. Breneman To: CF-Talk Sent: Wednesday, October 08, 2003 3:52 PM Subject: RE: Ok, I give up UDF error Good question, but no, I have ran the output several times and checked all values none are blank. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:44 PM To: CF-Talk Subject: Re: Ok, I give up UDF error Is your input string empty? - Original Message - From: Mark W. Breneman To: CF-Talk Sent: Thursday, October 09, 2003 8:37 AM Subject: Ok, I give up UDF error This seems so simple. All I want to do is to trim the last char from the return string. I keep getting this error "Parameter 2 of function Left which is now -1 must be a positive integer" If I hard code a value in the UDF works with out a problem. But when I put in the len(newstr)-1 into the "left" function it seems to evaluate to 0. Can anyone help me out? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } return left(newstr,len(newstr)-1); } Mark W. Breneman -Cold Fusion Developer
RE: Ok, I give up UDF error
The still get the same error "Parameter 2 of function Left which is now -1 must be a positive integer" OK here is the pair of UDFs if anyone cares to play with them. All they are meant to do is to encode a value to a short non readable string. I plan to use to encode url vars when security is not major issue. Simply this is meant to be generate a short sneaky, not secure encoded string. As you can see buy the qencode function a random number is added to the end of the sting just to make it look non-sequestional when a list of the code are viewed. All I am trying to do is to trim that last number off on the qdecode output. Thanks for your help. function qencode(urlvars){ var tempurlvars = URLEncodedFormat(urlvars & RandRange(0, 9)); var strlen = len(tempurlvars); var newstr = ""; var tempstr = ""; var i = 1; var key = 65; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr + 3); } return URLEncodedFormat(newstr); } function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var newstr = ""; var tempstr = ""; var i = 1; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } strReturn = 'Too Short:' & newstr & ':end'; if (len(newstr)+1) strReturn = left(newstr,len(newstr)-1); return strReturn; } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 3:16 PM To: CF-Talk Subject: Re: Ok, I give up UDF error What does this do for you? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } strReturn = 'Too Short:' & newstr & ':end'; if (len(newstr)+1) strReturn = left(newstr,len(newstr)-1); } - Calvin - Original Message - From: Mark W. Breneman To: CF-Talk Sent: Wednesday, October 08, 2003 3:52 PM Subject: RE: Ok, I give up UDF error Good question, but no, I have ran the output several times and checked all values none are blank. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:44 PM To: CF-Talk Subject: Re: Ok, I give up UDF error Is your input string empty? - Original Message - From: Mark W. Breneman To: CF-Talk Sent: Thursday, October 09, 2003 8:37 AM Subject: Ok, I give up UDF error This seems so simple. All I want to do is to trim the last char from the return string. I keep getting this error "Parameter 2 of function Left which is now -1 must be a positive integer" If I hard code a value in the UDF works with out a problem. But when I put in the len(newstr)-1 into the "left" function it seems to evaluate to 0. Can anyone help me out? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } return left(newstr,len(newstr)-1); } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ok, I give up UDF error
Sorry, I should have included that info. I was assuming the problem was a syntax error on my part. All values of newstr are at least 9 chars in length. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:48 PM To: CF-Talk Subject: RE: Ok, I give up UDF error If the variable newstr is only 1 char (or a zero length string) - this is the error you will get. Output the value of "len(newstr) and see what you get. -Mark -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:38 PM To: CF-Talk Subject: Ok, I give up UDF error This seems so simple. All I want to do is to trim the last char from the return string. I keep getting this error "Parameter 2 of function Left which is now -1 must be a positive integer" If I hard code a value in the UDF works with out a problem. But when I put in the len(newstr)-1 into the "left" function it seems to evaluate to 0. Can anyone help me out? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } return left(newstr,len(newstr)-1); } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ok, I give up UDF error
Good question, but no, I have ran the output several times and checked all values none are blank. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:44 PM To: CF-Talk Subject: Re: Ok, I give up UDF error Is your input string empty? - Original Message - From: Mark W. Breneman To: CF-Talk Sent: Thursday, October 09, 2003 8:37 AM Subject: Ok, I give up UDF error This seems so simple. All I want to do is to trim the last char from the return string. I keep getting this error "Parameter 2 of function Left which is now -1 must be a positive integer" If I hard code a value in the UDF works with out a problem. But when I put in the len(newstr)-1 into the "left" function it seems to evaluate to 0. Can anyone help me out? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } return left(newstr,len(newstr)-1); } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Ok, I give up UDF error
This seems so simple. All I want to do is to trim the last char from the return string. I keep getting this error "Parameter 2 of function Left which is now -1 must be a positive integer" If I hard code a value in the UDF works with out a problem. But when I put in the len(newstr)-1 into the "left" function it seems to evaluate to 0. Can anyone help me out? function qdecode(urlvars){ var tempurlvars = URLDecode(urlvars); var strlen = len(tempurlvars); var tempstr = ""; var i = 1; var newstr = ""; for(i=1;i lte strlen;i=i+1) { tempstr = Asc(Mid(tempurlvars, i, 1)); newstr = newstr & Chr(tempstr - 3); } return left(newstr,len(newstr)-1); } Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT:Bots / spiders finding unlinked pages... How?
One of our clients' IS department just got NetTracker/6.0 Enterprise and has set it loose on the site. It has found several pages that are not linked from any where. I do not have directory browsing turned on and I know these pages are not linked from any page.. How is it possible that it found these unlinked pages? Can other Bots / spiders also find unlinked pages? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Regular Expression find end of line / carriage return and replace
That is embarssing!!!Guess I assumed that it could not be that EZ and that you needed to usea Regular _expression_.Oh well, that was my one way too simple question for the year. Too bad Iam way over my limit on those. :-) Must be late Friday.Thanks!Mark W. Breneman-Cold Fusion Developer-Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770-Original Message-From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:52 PMTo: CF-TalkSubject: RE: Regular _expression_ find end of line / carriage return andreplaceHi Mark,No need for a regex unless I completely misread your question.In CFS, go to Search-->Extended Replacein the 'Find What' field, literally hit the enter keypop a comma in the 'replace with' fieldlet 'er rip.umm... make sure "current document" is selected :)-----Original Message-From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 4:26 PMTo: CF-TalkSubject: Regular _expression_ find end of line / carriage return andreplaceOk, I finally broke down and I have to ask this question.How do you do a simple find end of line / carriage return and replacewith a "," in CF studio?I have tried to look this up several times and found myself using ultraedit just to get it done, a few mins later. Thanks.Mark W. Breneman-Cold Fusion Developer-Network AdministratorVivid Media[EMAIL PROTECTED]www.vividmedia.com608.270.9770 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX6.1 admin left menu does not load then CF hangs
Thank you! Mark W. Breneman-Cold Fusion Developer-Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770-Original Message-From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:05 AMTo: CF-TalkSubject: RE: CFMX6.1 admin left menu does not load then CF hangs If ur accessing under SSL there's a hot fix for CF that addressesthis...there's a static cfhttp call in the menu that uses http.Stace _____ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: September 26, 2003 11:58 AMTo: CF-TalkSubject: CFMX6.1 admin left menu does not load then CF hangsJust a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting. When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service. Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line.Has anyone seen this? Or know of a fix?Thanks Mark W. Breneman-Cold Fusion Developer-Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Regular Expression find end of line / carriage return and replace
Ok, I finally broke down and I have to ask this question.How do you do a simple find end of line / carriage return and replacewith a "," in CF studio?I have tried to look this up several times and found myself using ultraedit just to get it done, a few mins later. Thanks.Mark W. Breneman-Cold Fusion Developer-Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX6.1 admin left menu does not load then CF hangs
Just a week ago I started seeing one of my production servers startacting strange when I went into the cfadmin to change a setting. When Ilogged in the main body frame loaded but the left nav menu did not load.I found that if I hit reload several times CFMX no longer responded andI needed to reset the service. Currently I am logging into the cfadmin on another box and copy - pastethe page I am trying to get to into the URL line. Has anyone seen this? Or know of a fix? Thanks Mark W. Breneman-Cold Fusion Developer-Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Auto Pinging Script?
WOW! That is really aggressive, if that is fully automated. I would hate to guess how many emails to ISPs and Law Enforcement my server would be generating, if I used you system. My software firewall logs all pings, and there are lots of them, on the 15-20 IPs I have on the server. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 1:19 PM To: CF-Talk Subject: Re: Auto Pinging Script? You do this on my domain(s) and on the sixth ping you would be locked out of access to the system, and on the 15th ping, you would be reported to your ISP in the hopes of getting your service terminated, with additional reports to your ISP periodically thereafter, and then followed by a complaint filed with appropriate Law Enforcement. You see, there are much better ways of evaluating a service provider than what could be considered a DDOS or intrusion attempt. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Nick Baker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 10:10 AM Subject: Auto Pinging Script? | We need to evaluate the performance of some CF hosting services. One angle | I would like to try is to setup an automatic pinging script and ping sample | domains hosted by the hosting services at intervals over a period. Note: I | am aware that pinging is often used for denial of service, but that is not | what this is about. | | Any ideas or suggestions? Maybe a script or a Web site that provides this | service? | | Thanks, | | Nick | | ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138351 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
RE: Help: CF5 is making access file grow to 2GB
Yes please, it may be a good short term fix. Or long term... You can mail it to: [EMAIL PROTECTED] -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:42 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB I had a similar issue, but quite as bad, but an MS access db would grow to 2GB in about a week or less depending on the activity. I solved (if you call it that) the issue by doing an automatice compression of the db everynight. Let me know and I will email you the code off list. I got the origanal code from Jochem, so he might have a more updated version as well. -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137401 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
CF5 (as in the subject :-)) I've had a long day too. MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:18 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are you are on CF5 or MX? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 5:18 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB I am sorry! The site uses menu monger pro and MM pro does use client vars. So yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think that is on the low side) it would only be 20 hours till it built the 2 GB file. Thanks MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137397 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Help: CF5 is making access file grow to 2GB
I am sorry! The site uses menu monger pro and MM pro does use client vars. So yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think that is on the low side) it would only be 20 hours till it built the 2 GB file. Thanks MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137393 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
Dan, Nothing out of the ordinary. I have RDS access the client's server. I am downloading a back up of the file I made a few min ago. I'll take a 2nd look. Thanks. MB -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:53 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Hm...did you see anything in the DB when you had it open? -Original Message----- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:49 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message----- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137389 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3:45 PM To: CF-Talk Subject: RE: Help: CF5 is making access file grow to 2GB Are they storing client variables in the DB? Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137381 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Help: CF5 is making access file grow to 2GB
I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137376 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: [OT] xxxxxxCode.Com (Launched new site last night, feedback please!)
We do something sorta like that, I have a chunk of code that looks for a "debug cookie". If you have the cookie and the value is set to debug =on via a URL var, you can see all of the diagnostic code, all of the server debug code and allows us to see any errors rather then the "An error has occurred, the webadmin has been notified" message. Kinda handy, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Darron J. Schall [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 3:10 PM To: CF-Talk Subject: Re: [OT] .Com (Launched new site last night, feedback please!) Same deal here: We have xxx1.my.com for development, xxx2.my.com for staging, and www.my.com for production. We wrote a UDF that returns the sub domain based on the ip address. debugging output here! It's also useful in changing from http to https and ensure that the domain is right.. https://#getSubDomain()#.my.com Nothing is worse than having the live site link to stuff on your development server.. -d - Original Message - From: "Deanna Schneider" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 3:18 PM Subject: Re: [OT] .Com (Launched new site last night, feedback please!) > Pablo, > We avoid the issue of "uncommenting" our error tags for production by > wrapping them in an if statement that looks at the cgi.server_name > var. I'm > sure there's multiple ways to handle this, but we've found it's way > easier to do if you're not relying on remembering to change that one > little thing before going live. -d > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Change NT password
Does anyone know if it is possible to change passwords via LDAP? I thought I had seen somewhere that this could be done. You could use CFEXECUTE and "net user user_name new_password" The only trick is that you have to be logged as Admin. Not a good idea from a security stand point to run CF as admin. http://support.microsoft.com/?kbid=149427 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:07 PM To: CF-Talk Subject: Change NT password Does anyone have a means of allowing an NT4 (or Win2k AD) domain user to change his password from a ColdFusion (CF5 on IIS5) app? The following explains how to do it using ASP, but we don't want to run ASP on the server: http://support.microsoft.com/?id=331834 Thanks, Jim ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: DWMX 2004 - Whats new for us?
I was wondering when you (Ben) would get involved in this thread. Good to hear from you and good to hear your points. I think (I can only speak for myself) people want to "vote with their money" to send a message to MM that they would be willing to buy HomeSite+ alone to reinforce that there is a community of CF developers that want a tool like homesite+. Maybe it is based on a fear that MM will drop HomeSite+ since it is kinda a "freebie" and freebies don't make company money. (I know it is not really a freebie) Now don't get me wrong! I like that DWMX is only $199 and HomeSite+ is included in the deal. I use both DWMX and HS+. I personally would like to see this synergy of the two products continue Or for DWMX to be made into the UBER tool that I have been dreaming of. Just my $0.02 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 2:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? I've been watching this thread with interest, and have also been forwarding the juicy bits to all sorts of folks within Macromedia. I've stayed out of the discussion thus far, but ... I use Dreamweaver. I also use HomeSite. I also use CodeWrite (which I migrated to after Sage which I migrated to after Brief). I'd love one editor that did it all, it does not exist yet, so I use multiple. It seems that many of you do the same. And no, I do not have to use Dreamweaver, I don't even have to like Dreamweaver, no one (not even my employer) gets to tell me what editor I should use or like. (Anyone who thinks otherwise does not know me). I have been a semi-advocate of Dreamweaver since DWMX (I had been a vocal critic of Dreamweaver prior to that), I have been on the backs of the Dreamweaver team to improve CF support for a long time and continue to do so, I publicly acknowledge what I like about Dreamweaver, and have no qualms about stating what it is that I don't like. I have been very honest in discussing Dreamweaver, and have never positioned it as a CF Studio replacement, and always positioned it as "another tool in the tool box" while stating that the Dreamweaver team had expressed a commitment to continue to improve ColdFusion integration. It's that last point that seems to be the crux of this all. And for those of you who have complained that Dreamweaver MX 2004 does not do enough for ColdFusion developers, well, I agree. It has improved, and some of the biggest complaints from ColdFusion users (including the speed and needing to always define sites) have been addressed. I would really have liked to have seen more, and as much as I don't like the fact that the Dreamweaver team dedicated resources to improving support for ASP.NET and PHP I also understand the economics. This is a business, Macromedia needs to continue to sell lots of Dreamweaver. The product has 2,000,000+ users (or something like that) most of whom do not use ColdFusion, the static page market is saturated and they need to go after where the big bucks are, targeting PHP and ASP.NET users make sense. (Whether or not those users will buy the story remains to be seen, but the Dreamweaver team had to make that effort). It is less "we don't care about CF" and more "we care lots about those massive user bases". Context. I have a laundry list of stuff I want in Dreamweaver (or HomeSite, or any editor). Many of the items are my own wants, others are user suggestions, all are shared by the wider community. I want data awareness in the IDE, I want right click introspection everywhere and anywhere, I want IntelliJ type intelligence so that when I change a CFC method I can keep all invocations in synch, I want speed, I want decent DB integration tools, I want a real debugger, I could go on and on and on ... I'll keep pushing and nagging. So is the new Dreamweaver the ColdFusion aware IDE I wanted? Nope. Is it a useful tool? Yes. It is an improvement over Dreamweaver MX, even for us CFers? Yes. Is it good enough to be the exclusive editor for ColdFusion developers? I'd say that depends on the developer, for experienced developers I'd say no. Is it compelling enough for Studio and HomeSite users to abandon those tools entirely for it? No. Does it have any value at all for ColdFusion developers? Absolutely. I am at least thankful that HomeSite has been given a new lease on life. HomeSite 5.5 is not a major upgrade, but it does add some important enhancements some of which I may want to use. Some of you complained about having to buy Dreamweaver to get HomeSite+, and that one irked me a bit. We seem to have forgotten that CF Studio used to sell for, what was it? $300? $400? I forget. Paying $199 for Dreamweaver + HomeSite+ is less than you paid
MX timeout regardless of how long I set request time out.
I have an extremely long running not publicly accessible CF page. The problem I run into from time to time is that CFMX seems to time out OR is it Jrun that times out? CFMX seems to reset itself and for a few seconds I get "Server Error The server encountered an internal error and was unable to complete your request. Could not connect to JRun Server." when ever I run this page. I have tried . And I still get the same error. Is there a .xlm file I need to tweak? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: DWMX 2004 - Whats new for us?
I hate to do a "me too" but I keep Ultraedit 32 on my computer just for that Vertical select feature. I use it at least 2-5 a week. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jerry Barnes [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 2:27 PM To: CF-Talk Subject: RE: DWMX 2004 - Whats new for us? Vertical select would be a nice feature. Also allowing the user to insert spaces for tabs and indicating the cursor column position in code view would make good additions. J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 2:32 PM To: CF-Talk Subject: Re: DWMX 2004 - Whats new for us? What I'd like to know is if they've finally added the ability to mark a column of text in "code view" mode just like UltraEdit32 can. Until I see that feature added, UltraEdit will probably remain my editor of choice. That's not to say that I don't used DWMX at all. I just find myself using UltraEdit more than DWMX. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Return Subquery as text string? MSSQL
>From the little research I have done, I have not been able to confirm that MSSQL has UDF for aggregates. Can anyone confirm this? Seems that is a some what common task, to generate a list of items for a report. Maybe not. Thanks MB -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 4:12 PM To: CF-Talk Subject: Re: Return Subquery as text string? MSSQL Mark W. Breneman wrote: > Is there any way to do this in MSSQL? Normally you can not return more > then one value with type of subquery. > > Here is what I would like to do: > Select UserID, Name, (select orderNo from orders where OrderID=UserID) > as Orders > From Users > > Result: > > "1", "BOB", "12,63,192" > "2", "Ed", "34,45,233" We should put this in a FAQ, it pops up every other week :-) You can do this in every DBMS that allows you to create your own functions for aggregates. For a PostgreSQL based example, see http://www.zope.org/Members/pupq/pg_in_aggregates Jochem ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Return Subquery as text string? MSSQL
Is there any way to do this in MSSQL? Normally you can not return more then one value with type of subquery. Here is what I would like to do: Select UserID, Name, (select orderNo from orders where OrderID=UserID) as Orders >From Users Result: "1", "BOB", "12,63,192" "2", "Ed", "34,45,233" Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: null null errors
Null null ... joy. I too have tried to fight the null null problem. We found that updater 3 reduces the problems, but does not eliminate it. We still get about 5-12 users a month that get the null null error. There has been postings on this list the null null problem is related to client vars. It seems that the error will "happen" one user and all pages that user tries to view with throw the null null error. I have only been able to see it once myself. Does anyone know if this issue is being addressed by MM. Does 6.1 have the null null issue? Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 4:55 PM To: CF-Talk Subject: null null errors Anyone have any ideas as to what a "null null" error is? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Redsky-Still issues with CFINSERT and CFUPDATE.
Hey IF a patch is written for 6.1 to fix this "password / Access" issue on cfupdate and cfinsert could the "Primary Key / cfupdate" issue also be address? Error message: The field "ID," was not found in the Form input. This field is required in order to do an UPDATE because it is part of the primary key for the "tablename" table. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3 <http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=3&thre adid=380672> &threadid=380672 When using the formfields attribute in the cfupdate tag the primary key must also be listed in the formfields attribute or else error will be generated. This issue was introduced in CF MX. CF 5 and earlier had no problems. I think it is a poor practice to update the primary key even, if it is with the same value. Code Example: Result error: Primary key field "RECORDID," not found. The field "RECORDID," was not found in the Form input. This field is required in order to do an UPDATE because it is part of the primary key for the "MailListLog" table. Work around code: Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com <http://www.vividmedia.com/> 608.270.9770 -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 9:59 AM To: CF-Talk Subject: RE: Redsky-Still issues with CFINSERT and CFUPDATE. I was reading through this thread but I don't see the error message. Can someone post sample code (against cfsnippets) that produces the error and the actual error text? Thanks! Christine -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 10:21 AM To: CF-Talk Subject: RE: Redsky-Still issues with CFINSERT and CFUPDATE. Yes I do. With Ablecommerce as well. I think there is a workaround for Able, but I'm having trouble accessing their support site. I don't know if the workaround would help with my CFINSERT and CFUPDATE issues. I am going through one particular application and manually changing the insert/update statements now though. -Angel -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED] Are you still have the same issues, Angel? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Redsky-Still issues with CFINSERT and CFUPDATE.
Is it a BUG??? Bug: A defect or difficulty, as in a system or design. A defect in the code or routine of a program. Well, it is an inconsistency at very least between cf5 and MX that cost us about 16 hours of development time to fix the problem on 50 - 70 sites when we moved to MX. This issue is not address in the MX docs other then a live doc rant about the issue 'er ah "bug". I guess I will call it a BUG until it is fixed or someone bigger then me tells me other wise. :-) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 1:14 PM To: CF-Talk Subject: Redsky-Still issues with CFINSERT and CFUPDATE. Mark W. Breneman wrote: >Hey IF a patch is written for 6.1 to fix this "password / Access" issue >on cfupdate and cfinsert could the "Primary Key / cfupdate" issue also >be address? I can't speak for Macromedia -- I'm doing my best to document and explain the issue to them. I doubt that the primary key issue is considered a "bug" per se... ...D ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Redsky-Still issues with CFINSERT and CFUPDATE.
Can anyone shed some light on what the 'problems' are with cfinsert and cfupdate not working with 6.1? I must be missing an email or two. Is anyone having problems with MS SQL 2000 and 6.1 cfupdate and cfinsert? Other then the problem that CF 6.0 introduced with cfupdate, requiring the key field to be required in the list of fields to up date. (Dumb problem) I knew I should have tested the beta of red sky. I had it sitting on my desk but, no time to test the cfupdate and inserts. Drat. Recoding 70-90 sites that we have written over the past 5 years using cfupdate and cfinsert, is not an option at this time. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Concatenate results of subquery in select
Yes, I know this is not standard practice but, I am working on a report and I would like all of the buildings this teacher teaches at to be in a single CF query column. I hope to get query results like: TeacherName Buildings Bob High School, Middle School, EMC Sue ELC, Middle School Here is basically what I am trying to do: SELECT TeacherName, (select buildingname from location where teacherID = 1) as Buildings FROM Teachers But you can not run a subquery that returns more then one value. Any Ideas on how to work around this? Tables look like Teachers table: teacherID TeacherName 1 Bob 2 Sue Location table: buildingnameteacherID High School 1 Middle School 1 EMC 1 ELC 2 Middle School 2 I am running: MS SQL server 2000 CFMX Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 records with cftags in them do not render -help
That makes me laugh or cry not sure what I will do. I have been working with CF for 5 years and I was aware that you could not put tags and functions into a var, or in this case a database, but, I assumed that there was a work around for that. I have a cf driven photo gallery module that I would like to include into a database record using a cfinclude. guess I will go back to the drawing board. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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 records with cftags in them do not render -help
There has got to be a better way of doing this. Isn't there? Jochem - Maybe I don't understand what you are saying. The problem I am having is that I can not "run" a cfinclude that is in a database record. Are you suggesting that I write 1000s of database records to files? Seems to kinda defeat the reason we made it a contentment management system in the first place. Or am I not understanding you correctly. :-) I think this is the equivalent of what I am trying to do: I have a var that holds text and 1 cf include. #foo# Mark W. Breneman >Mark W. Breneman wrote: >> I have a database table that holds the "body" contents of a page. (simple >> contentment management system) I just tried to put a cfinclude in a db >> record and found that CFMX does not evaluate the code. CFMX will just send >> the cfinclude tag to the browser, as unrendered source code, just like any >> other normal html tag. Is there a way I can make CFMX render CFtags that >> are stored in a db record? >Write them to a file and cfinclude the file. >> Seems like there should be an EZ way to do this. >http://www.macromedia.com/support/email/wishform/?6213=3 >Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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