RE: Future of Coldfusion
personally I think CF is the bomb. I have tried other languages and they don't stand up to the ease of CF. I have yet to make the jump to CFMX because of the bugs that are still being ironed out even today. Once MM gets the bugs ironed out and changes a couple of things, I think I'll make the switch. I believe that within the next 5 years CF will probably become the MS of the server side web programming languages. while ASP and PHP are good. they just aren't as easy to develope and maintain as CF is. don't even get me started with Perl. ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 12:59 PM To: CF-Talk Subject: RE: Future of Coldfusion As time goes on I think CF will always be at the cutting edge of providing the latest advanced features in an easy to use package. CFMX has raised the bar in that respect...The time from when advanced technologies are made available in native programming languages and when it's implemented will shrink as long as they provide substance to their customer base! Stace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 12:49 PM To: CF-Talk Subject: Re: Future of Coldfusion But all of that excitement kind of died down... *blinks*... With the release of CFMX, I'm wondering how you can even say that...? I think the presentation at Macromedia is probably one of the best examples of what's coming in the future: http://www.macromedia.com/software/mx/presentation/ Rich Clients -- Granted, Macromedia's taking about 3 steps forward here because they're forgetting that CFMX developers have to learn flash and Flash developers have to learn CFMX (or, at least, get those two developers talking to each other). The real world (least, where I work) Flash Developers want nothing to do with server side languages, etc.. It's going to take some time before we see real rich clients I think. I think we'll see more rich components first before we see rich clients imho. ~Todd p.s. The opinion stated above is _MINE_ and doesn't nessarily reflect Macromedia's PoV or Opinion. :P On Fri, 14 Jun 2002, Phoeun Pha wrote: Hey guys, where do you think coldfusion is headed? I mean, when 4.5 came out, it was like when AMD came out with their cheap and competitive Athlons! But all of that excitement kind of died down.well, at least for me anyways. But how about you guys? Maybe the Macromedia merge had something to do with it. What do you think? -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE
this is true. it is limited to the server memmory. that is why if you are trying to append a file with some more data, you use the cffile action=APPEND. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bruce, Rodney S HQISEC/SIGNAL [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:22 PM To: CF-Talk Subject: CFFILE Hello all I remember seeing about CFFILE always loading the complete file into memory, before it completes its action. So that this can limit the size of files being worked with. Is this the limit on the server side or the clients memory? and what are some ways of working around this limit? Thanks for any suggetions. Rodney __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
fusebox 3.0
alright, i will admit that i used to be a big fusebox fan. however after seeing that it took 400 milsecs to load a login page, i decided to drop it. and yes i did follow the methodology exactly. now i used the simple form / action methodology with a bunch of custom tags for reusability. what i'm wondering is if anyone out there has been using the new fusebox 3.0 methodology and how it is working out for you. is it faster in terms of speed of programming and execution. anything would help Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFILE
ok then. look like you're going to be using COM. ;) better reads up on FSO. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:49 PM To: CF-Talk Subject: RE: CFFILE We used APPEND, and still ran into the server memory limit. Allaire (at that time) told us that CFFILE reads the entire file into memory, appends the part you requested, then writes the entire file to disk. Bleah. Chris Norloff -- Original Message -- from: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Fri, 14 Jun 2002 14:41:08 -0400 this is true. it is limited to the server memmory. that is why if you are trying to append a file with some more data, you use the cffile action=APPEND. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bruce, Rodney S HQISEC/SIGNAL [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:22 PM To: CF-Talk Subject: CFFILE Hello all I remember seeing about CFFILE always loading the complete file into memory, before it completes its action. So that this can limit the size of files being worked with. Is this the limit on the server side or the clients memory? and what are some ways of working around this limit? Thanks for any suggetions. Rodney __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Apps You've Built
i got to stop doing that. every time i write an app, i always look back on it them when i'm between projects and try to tweak them here and there. call it obsession if you want. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 3:03 PM To: CF-Talk Subject: Re: Coldfusion Apps You've Built Yes, everything. Everyone looks back at their code and finds where you can improve. But you have deadlines to meet which pay your bills. This is real world code not academic code. On Fri, 14 Jun 2002, Phoeun Pha wrote: Hey guys, I'm 2 years in the CF game, and so far I've built a timesheet program, and events administration, countless shopping carts, pharmacy prescription app. But looking back at my code, it was verry bddd! Like I could think of a hundred places to do things differently, either form CF or from the database design. Obviously it was because of lack of experience Was there anything that you guys have built for past clients that you now know could have been coded better? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfflush
use a div and some javascript Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:39 AM To: CF-Talk Subject: cfflush The cfflush just works great for what I need it for but I'm using the cfflush to display Work in progress... while I'm executing a batch file with cfexecute and then display the results from the program to screen. Is there a way to have the Work in progress... disappear once the results from the cfexecute have appeared. Right now the progress text stays at the top of my page. p align=center style=Arial size=+1font color=#ffWork in progress.../font/p cfflush cfflush interval=1 cfexecute name=filename.bat outputfile=output.rlog timeOut=1000 /cfexecute cffile action=READ file=output.rlog variable=results table width=100% cellpadding=6 cellspacing=0 border=0 tr align=center td input type=button value=Close class=navlinks onClick=self.document.open(); /td /tr tr align=center td table cellpadding=6 cellspacing=0 border=0 tr td class=wdirlinks #replace(results,chr(10),br,all)# /td /tr /table /td /tr /table __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Shopping Carts
go to webmonkey.com and look in the coldfusion section. there is a tutorial on writing a shopping cart in coldfusion. I would suggest downloading the source code and poking through it. It is a great way to start writing your own shopping cart application. I would bet that after you've written your first one, it would take you all of 5 minutes to write your next one. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 7:20 AM To: CF-Talk Subject: Shopping Carts What shopping carts do people use at the moment? Please don't all say Able Commerce as it is WAY to expensive for what my client wants. -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hack Attempt?????
sure answer, yea it was an attempted hack. I see those alot on my server. personally you should never install the cfdocs on a production machine. just like you shouldn't install the IIS web admin on a production machine. another good thing to do, if you're running an ftp service, make sure that anonymous access is turned off. want even better ftp security? if you have a static IP and you know you will only be uploading from that IP, restrict FTP connection to that IP only. make sure that if you have SMTP services running that relay is only allowed from 127.0.0.1, not the ip address of the website. a great thing to do is to go to is to get the IIS security checklist. it has been updated for IIS 5.0. http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/ tools/chklist/iis5chk.asp have fun Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 9:14 AM To: CF-Talk Subject: RE: Hack Attempt? How much time was between hits? Did it look like a bot or a person trying to find something? These files have been known to open up some holes, and it is best to not install them. But on newer versions they set them to only be accessible from localhost (I think). -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 9:03 AM To: CF-Talk Subject: Hack Attempt? SOmeone was trying to call all these pages last night.I got the error in my notfound file.Do you think someone was just playen around, or trying to do something. /cfdocs/exampleapp/docs/sourcewindow.cfm /cfdocs/snippets/viewexample.cfm /cfdocs/snippets/fileexists.cfm /cfdocs/cfmlsyntaxcheck.cfm /CFDOCS/expeval/openfile.cfm /CFDOCS/expeval/exprcalc.cfm /CFDOCS/exprval/displayopenedfile.cfm thanks mike __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How do Client Var Behave
word to the wise. just be careful about what you put into the server scope if you are on a shared server. do not put any sensitive information in any of the variables as they can be read by any application on the server. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Brian Eckerman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 1:14 PM To: CF-Talk Subject: RE: How do Client Var Behave That are specific to a user..(Honestly this is really what client variables should do!!) -Original Message- From: Kreig Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 12:19 PM To: CF-Talk Subject: Re: How do Client Var Behave Use the SERVER scope. - Original Message - From: Brian Eckerman To: CF-Talk Sent: Tuesday, June 11, 2002 12:04 PM Subject: RE: How do Client Var Behave How would I declare a var that would span applications? -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 12:00 PM To: CF-Talk Subject: Re: How do Client Var Behave The client variables are unique to the application. Thus the client vars in APP1 are ONLY available to APP1 [EMAIL PROTECTED] 06/11/02 11:57AM Hello again. Got a problem. I declare an Application context(say APP1) with cfapplication. then I set some client variables... I then cflocation to anouther directory, with.. anouther declared Application context(say COOLAPP2) then I try to reference the client variables I set in APP1. --This Doesn't work-- :( My understanding is the whole point of Client varialbes is that they span application contexts. The above situation doesn't work...Is my understanding wrong? __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql server text datatype
anyone know how to pass in a text data type into sql server using cfstoredproc and cfprocparam? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
I personally always use uniqueidentifiers for primary keys, it's just a perference of mine. are they harder to work with? in my opinion, no, they are just as easy to work with as integers. do they add some extra overhead and extra access time to the application? if they do, i have never seen it and the day you can, I'll start calling you The Flash. UID, in my opinion, add little layer of extra security to your app. Anyone with a pea for a brain can edit the url or form fields that are passed and change the value of your variables. if you're using integers, you could easily start poking around in the app by change the variables. with UID it's a little more complex to guess. I'm no god when it comes to SQL server, so if you have been taught differently and are comfortable with the methods that you use, use them. don't just change the way you program because i do something different. there are probably some benefits / limitations on using UIDs as primary keys that you could find in groups.google.com. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:21 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. woah woahcall me dumb here, but by unique identifiers what do you mean? I ALWAYS though integers were the method of choice be cause of access time. please fill me in as ints were the way i was taught and if i should be doing something different, by all means stick my head to a monitor with a railroad spike! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:09 PM To: CF-Talk Subject: RE: Hacking a shared SQL server granted that that is true. however doesn't CF or any other programming language do the same thing. and if the way your getting at the data is by using form and url parameter, then it's very easy for me to do from the website and not even bother to try hack the database. using client variables and session variables make this a little harder but not impossible. Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:00 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Suppose you stored all your customer information in your database. Your application only used stored procedures to read and write data about these customers. I could just use those stored procedures to read your customer data and steal it. So the fact that I could only execute stored procedures doesn't stop me from accessing your data. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:52 AM To: CF-Talk Subject: RE: Hacking a shared SQL server elaborate Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:47 PM To: CF-Talk Subject: RE: Hacking a shared SQL server If I only have access to run your stored procedures then I could still access you data through the stored procedures. That IS a security problem. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: RE: Hacking a shared SQL server well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:25 PM
RE: Rumor of lay-offs
whoa. calm down there andrew. you might pop something. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: Re: Rumor of lay-offs Well said...and thanks for the guffa! ;-) Bryan Stevenson 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 - Original Message - From: Andrew Tyrone [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 7:29 PM Subject: RE: Rumor of lay-offs Yes, just like the story about Microsoft buying Macromedia and Macromedia dying, propagated by the f-word toting propeller heads who have nothing better to do than to talk trash, spread rumors and make unfounded, factless, baseless judgments on companies and their products. While the topics may have some truth to them, you could read 95% of the responses standing on your head after consuming 10 peyote buttons and get the same exact information out of them as if you were sitting at your desk with your head nailed to the monitor with a railroad spike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 11:02 AM To: CF-Talk Subject: RE: Rumor of lay-offs i have been visiting FC for well over two years now. I must say that they are right on the money about their stories. I have no idea where Pud gets his info, but it's right on target. I personally think you could sell stock based off the information on his site. Just because the news is bad news, doesn't make it trash. If you were working at MM right now, information like that would be priceless. you could start looking for a new job before everyone else. how is that trash? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
that's because you didn't secure your database like your suppose to. I'm actually doing a presentation tonight for our CFUG about securing your SQL database. In a nut shell what you should do is create a user for the database (let's say the DB name is TEST) and give them DENYDATAREADER and DENYDATAWRITER access to the database. yes that is correct, it isn't a mistype. Then what you do is with the sa account, create your tables and your stored procedures. you can use another account that has db owner previledges, you just have to make sure that the same user owns both the tables and the storedprocedures. You can use the stored procedure sp_changeobjectowner to change the owner of an object if need be. Then after you created your stored procedures for your database, you give the user only EXEC permissions for that stored procedure. Now even if they get the username and password, what can they access. nothing. they can't even see what tables you have. all they can do is execute the stored procedures that you allow them to. this is a very rough example. if your in the south florida area tonight (don't know where you are), go to the CFUG meeting at the Hillsboro Compusa in Deerfield beach at 7:30pm. I will go into detail about this tonight. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:33 PM To: CF-Talk Subject: RE: Hacking a shared SQL server let me know of any coldfusion hacks Hmmm, you acknowledge pulling data from a very desirable table on a site you don't manage and now you want us to send you CF hacks? :) But anyway, does your host not setup username/password on the databases? Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:11 PM To: CF-Talk Subject: Hacking a shared SQL server hey guys, i just thought about this, and it's making me feel uneasy about using shared SQL server. ok, i did a test hack on a live server. As you know in SQL Enterprise, you're able to see the database names of other people sharing the SQL server. and by looking at the names you can probably guess what they named their DSN. I got lucky, and nabbed one. I pulled out the table names from sysobjects. Then pulled out the field names from a very desirable table using columnlist, then was able to pull out data! I was appalled! Because my DSNs are named after my site and anyone could have just done with I've done, but with a different intent. But the only way they will get that far is if they know the DSN. And to prevent that would be to never us an obvious DSN. name it something like Hys72hs! I had that fear in my mind way from the beginning, but I had thought that the DSN only works if it is being requested from a certain site!!! and also, can someone tell me how many webHosts turn off the CFREGISTRY tag? Or if any host even have it on at all? I attempted to retrieve the DATAsource names from using that tag, but good thing this host turned it off. Also, please let me know of any coldfusion hacks you guys might know. This is, of course, so you and I can have better security! __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Cravens, Billy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:02 PM To: CF-Talk Subject: RE: Hacking a shared SQL server This has nothing to do with securing the database. It's a matter of how datasources are defined in the CF administrator. Usually, the username and password are defined and saved in the CF administrator, so the code only has to specify the datasource name. No matter how strong you lock down your SQL Server, when you save the username/password in the Administrator, it has the same effect as having no security (if someone can write code on the box and knows the datasource name). --- Billy Cravens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 12:50 PM To: CF-Talk Subject: RE: Hacking a shared SQL server that's because you didn't secure your database like your suppose to. I'm actually doing a presentation tonight for our CFUG about securing your SQL database. In a nut shell what you should do is create a user for the database (let's say the DB name is TEST) and give them DENYDATAREADER and DENYDATAWRITER access to the database. yes that is correct, it isn't a mistype. Then what you do is with the sa account, create your tables and your stored procedures. you can use another account that has db owner previledges, you just have to make sure that the same user owns both the tables and the storedprocedures. You can use the stored procedure sp_changeobjectowner to change the owner of an object if need be. Then after you created your stored procedures for your database, you give the user only EXEC permissions for that stored procedure. Now even if they get the username and password, what can they access. nothing. they can't even see what tables you have. all they can do is execute the stored procedures that you allow them to. this is a very rough example. if your in the south florida area tonight (don't know where you are), go to the CFUG meeting at the Hillsboro Compusa in Deerfield beach at 7:30pm. I will go into detail about this tonight. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:33 PM To: CF-Talk Subject: RE: Hacking a shared SQL server let me know of any coldfusion hacks Hmmm, you acknowledge pulling data from a very desirable table on a site you don't manage and now you want us to send you CF hacks? :) But anyway, does your host not setup username/password on the databases? Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:11 PM To: CF-Talk Subject: Hacking a shared SQL server hey guys, i just thought about this, and it's making me feel uneasy about using shared SQL server. ok, i did a test hack on a live server. As you know in SQL Enterprise, you're able to see the database names of other people sharing the SQL server. and by looking at the names you can probably guess what they named their DSN. I got lucky, and nabbed one. I pulled out the table names from sysobjects. Then pulled out the field names from a very desirable table using columnlist, then was able to pull out data! I was appalled! Because my DSNs are named after my site and anyone could have just done with I've done, but with a different intent. But the only way they will get that far is if they know the DSN. And to prevent that would be to never us an obvious DSN. name it something like Hys72hs! I had that fear in my mind way from the beginning, but I had thought that the DSN only works if it is being requested from a certain site!!! and also, can someone tell me how many webHosts turn off the CFREGISTRY tag? Or if any host even have it on at all? I attempted to retrieve the DATAsource names from using that tag, but good thing this host turned it off. Also, please let me know of any coldfusion hacks you guys might know. This is, of course, so you and I can have better security! __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:25 PM To: CF-Talk Subject: RE: Hacking a shared SQL server you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Either you're not trying very hard, or you misunderstood Billy's argument. Basically, if you've got a shared CF server, and the usernames and passwords for each individual datasource are stored persistently on that server, then the key to being able to access another database is to retrieve those usernames and passwords. By default, they're usually in the registry. So, if a developer can write code on the server, and that code can read the values from the registry, then they can gain the same level of access to the database that the other application can. Now, admittedly, by properly securing the SQL server you can limit what any CF applications can do (just calling the allowed stored procedures), but even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. By the way, you ought to post your SQL Server presentation on your CFUG's web site, so that others can enjoy it - that sort of stuff is good for people to know, and there are often questions on this list about those things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
elaborate Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:47 PM To: CF-Talk Subject: RE: Hacking a shared SQL server If I only have access to run your stored procedures then I could still access you data through the stored procedures. That IS a security problem. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: RE: Hacking a shared SQL server well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:25 PM To: CF-Talk Subject: RE: Hacking a shared SQL server you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Either you're not trying very hard, or you misunderstood Billy's argument. Basically, if you've got a shared CF server, and the usernames and passwords for each individual datasource are stored persistently on that server, then the key to being able to access another database is to retrieve those usernames and passwords. By default, they're usually in the registry. So, if a developer can write code on the server, and that code can read the values from the registry, then they can gain the same level of access to the database that the other application can. Now, admittedly, by properly securing the SQL server you can limit what any CF applications can do (just calling the allowed stored procedures), but even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. By the way, you ought to post your SQL Server presentation on your CFUG's web site, so that others can enjoy it - that sort of stuff is good for people to know, and there are often questions on this list about those things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
granted that that is true. however doesn't CF or any other programming language do the same thing. and if the way your getting at the data is by using form and url parameter, then it's very easy for me to do from the website and not even bother to try hack the database. using client variables and session variables make this a little harder but not impossible. Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:00 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Suppose you stored all your customer information in your database. Your application only used stored procedures to read and write data about these customers. I could just use those stored procedures to read your customer data and steal it. So the fact that I could only execute stored procedures doesn't stop me from accessing your data. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:52 AM To: CF-Talk Subject: RE: Hacking a shared SQL server elaborate Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:47 PM To: CF-Talk Subject: RE: Hacking a shared SQL server If I only have access to run your stored procedures then I could still access you data through the stored procedures. That IS a security problem. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: RE: Hacking a shared SQL server well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:25 PM To: CF-Talk Subject: RE: Hacking a shared SQL server you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Either you're not trying very hard, or you misunderstood Billy's argument. Basically, if you've got a shared CF server, and the usernames and passwords for each individual datasource are stored persistently on that server, then the key to being able to access another database is to retrieve those usernames and passwords. By default, they're usually in the registry. So, if a developer can write code on the server, and that code can read the values from the registry, then they can gain the same level of access to the database that the other application can. Now, admittedly, by properly securing the SQL server you can limit what any CF applications can do (just calling the allowed stored procedures), but even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. By the way, you ought to post your SQL Server presentation on your CFUG's web site, so that others can enjoy it - that sort of stuff is good for people to know, and there are often questions on this list about those things. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
RE: Hacking a shared SQL server
damn good example david, damn good. I stand corrected. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:13 PM To: CF-Talk Subject: RE: Hacking a shared SQL server well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. First, I realize you're not trying to start a fight. Neither am I, of course. I think that, at root, what we've got here is a pronoun problem. You're using I and they in your above statement differently than I am. That is, you're assuming there's this one group called they, who legitimately have equal access to the same set of stored procedures. In a shared CF hosting environment, where not only the database server but the CF server is shared, you may have several theys [sic] - you may have several developers, each of whom has different legitimate rights to databases on your shared database server. For example, I've got my site on there and Matt has his, and we don't like each other. That Matt bastard has been getting on my nerves with his DevX articles, while I annoy him to no end with nit-picky corrections (of course, he wouldn't acknowledge that I'm right in the first place, the bastard!) So, I'll show him - I'll grab the username and password for his database connection, and I'll add some, uh, embarrassing links to his table listing articles he's written. Maybe, I'll query his table that lists business leads he's received through the web site, and send them all slanderous notes. Now, despite the fact that you, the database administrator, have created a set of stored procedures to allow each of us to access only the things we should, I'll be able to use his stored procedures to do so, once I've figured out his username and password (something that is beyond the control of the database administrator, by the way). For his site to do anything useful in the first place, you'll have to have written the stored procedures that allow his legitimate access. Of course, this is just an example - I'm sure I annoy Matt more than he annoys me, and he'd never share a server with me. The final thing to note here is that, while proper security in your database server is very important, it's also very important to secure other layers of your application and its environment. In the case of a shared CF server, this is very, very difficult to do. I hesitate to say it's impossible - there are some very smart people - but I'm not smart enough to do it to a degree that I'd consider reliable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: msSQL/t-SQL BOTTOM
select top 100 from tablename order by pk DESC the ORDER BY whatever DESC is the key Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:46 PM To: CF-Talk Subject: OT: msSQL/t-SQL BOTTOM I know there is a TOP funcion i.e. SELECT TOP 100 * FROM tablename and i have heard there is also a way to get the bottom too, can anyone tell me what this might be. Tyler Clendenin GSL Solutions __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: simple right-justify dollar fields in tables?
check your code. the only thing that could do this is another piece of code,
like a p, that is set to align left in the td tag.
td align=right
p align=lefttext will go left/p
/td
td align=right
text will go right
/td
td align=right
div align=lefttext will go left/div
/td
also see if there any style sheets being called on the page
style type=text/css
td {text-align : left;}
/style
td align=right
text goes left
/td
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 05, 2002 8:46 AM
To: CF-Talk
Subject: Re: simple right-justify dollar fields in tables?
On 6/5/02, Ed Gordon penned:
I'm putting in TD ALIGN=RIGHT but the darn things are left-justified.
That's strange.
Any clue how to (easily) get decimal places in a column to line up nice?
Yes, TD ALIGN=RIGHT. :)
Are you sure you don't have valign=right or something?
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: storing session variables in DB
dude all you have to do is make sure that each app has it's own application name in the cfapplication tag. name of app1 cfapplication name=test name of app2 cfapplication name=test2 now the user's can't share session variables. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:06 AM To: CF-Talk Subject: storing session variables in DB I have a set of mirrored servers that are running off 1 SQL_server. I have to recode the apps that use session variables because a user could jump to a different server during a session. Is there a simple way to fix this? Can 2 different servers be aware of the same session? Can I store the session variables in the SQL-server DB? I am running Win2k, SQL-Server 2000, and (I know) CF%.0 Professional. There is no need to tell me that the Enterprise version will allow me to isolate a user to one server during a session. Thanks in advance, BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: storing session variables in DB
i think i read this wrong. you WANT people to be able to jump from one
server to the other during a session. Well then, client variables to the
rescue. you could probably mimic with session variables:
in your database create a table that has these columns
CDATA
--
cfidchar(100)
app char(64)
datatext ** note in msaccess, use memo
Application.cfm
===
cflock timeout=10 throwontimeout=No type=READONLY
cfset request.thissession = #session.cfid#:#session.cftoken#
cfset request.thisapp = application.applicationname
/cflock
cfquery name=GetSessionInfo
datasource=#request.dsn#
username=#request.username#
password=#request.password#
select
data
from cdata
where cfid = '#request.thissession#' and app = '#request.thisapp#'
/cfquery
cfset temp = request.session1 = StructNew()
cfif GetSessionInfo.RecordCount NEQ 0
cfloop index=i list=#GetSessionInfo.data# delimiters=##
cfif trim(i) NEQ
cfset a = ListGetAt(i, 1, =)
cfset b = ListGetAt(i, 2, =)
cfset temp = StructInsert(request.session1, a, b)
/cfif
/cfloop
cfelse
cfquery name=InsertSessionInfo
datasource=#request.dsn#
username=#request.username#
password=#request.password#
INSERT INTO CDATA
(cfid, app)
VALUES
('#request.thissession#', '#request.thisapp#')
/cfquery
/cfif
Onrequestend.cfm
cfset request.thisdata =
cfloop collection=#request.session1# item=i
cfset request.thisdata = request.thisdata i ##
/cfloop
cfquery name=UpdateSessionInfo
datasource=#request.dsn#
username=#request.username#
password=#request.password#
UPDATE CDATA
SET
data = '#request.thisdata#'
WHERE where cfid = '#request.thissession#' and app =
'#request.thisapp#'
/cfquery
** PLEAS READ**
Now understand that I don't use session variables at all in my apps and
never will. this is just a rough idea of what you would most likely do to
mimic client variables with session variables. Personally i would rewrite
the app to use client variables. But each to their own. You will probably
need to correct / rewrite some of this code. Hey I wrote it off a whime and
without testing :P.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 10:10 AM
To: CF-Talk
Subject: RE: storing session variables in DB
dude all you have to do is make sure that each app has it's own application
name in the cfapplication tag.
name of app1
cfapplication name=test
name of app2
cfapplication name=test2
now the user's can't share session variables.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 10:06 AM
To: CF-Talk
Subject: storing session variables in DB
I have a set of mirrored servers that are running off 1 SQL_server.
I have to recode the apps that use session variables because
a user could jump to a different server during a session. Is
there a simple way to fix this? Can 2 different servers be aware
of the same session? Can I store the session variables in the
SQL-server DB?
I am running Win2k, SQL-Server 2000, and (I know) CF%.0 Professional.
There is no need to tell me that the Enterprise version will
allow me to isolate a user to one server during a session.
Thanks in advance,
BJ
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: storing session variables in DB
see I found a mistake already :P.
cfset request.thissession = #session.cfid#:#session.cftoken#
should be
cfset request.thissession = #cfid#:#cftoken#
this way it would grab it if you passed the cfid and cftoken in the url or
in seperate cookies called cfid and cftoken (which is what I would do).
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 10:43 AM
To: CF-Talk
Subject: RE: storing session variables in DB
i think i read this wrong. you WANT people to be able to jump from one
server to the other during a session. Well then, client variables to the
rescue. you could probably mimic with session variables:
in your database create a table that has these columns
CDATA
--
cfidchar(100)
app char(64)
datatext ** note in msaccess, use memo
Application.cfm
===
cflock timeout=10 throwontimeout=No type=READONLY
cfset request.thissession = #session.cfid#:#session.cftoken#
cfset request.thisapp = application.applicationname
/cflock
cfquery name=GetSessionInfo
datasource=#request.dsn#
username=#request.username#
password=#request.password#
select
data
from cdata
where cfid = '#request.thissession#' and app = '#request.thisapp#'
/cfquery
cfset temp = request.session1 = StructNew()
cfif GetSessionInfo.RecordCount NEQ 0
cfloop index=i list=#GetSessionInfo.data# delimiters=##
cfif trim(i) NEQ
cfset a = ListGetAt(i, 1, =)
cfset b = ListGetAt(i, 2, =)
cfset temp = StructInsert(request.session1, a, b)
/cfif
/cfloop
cfelse
cfquery name=InsertSessionInfo
datasource=#request.dsn#
username=#request.username#
password=#request.password#
INSERT INTO CDATA
(cfid, app)
VALUES
('#request.thissession#', '#request.thisapp#')
/cfquery
/cfif
Onrequestend.cfm
cfset request.thisdata =
cfloop collection=#request.session1# item=i
cfset request.thisdata = request.thisdata i ##
/cfloop
cfquery name=UpdateSessionInfo
datasource=#request.dsn#
username=#request.username#
password=#request.password#
UPDATE CDATA
SET
data = '#request.thisdata#'
WHERE where cfid = '#request.thissession#' and app =
'#request.thisapp#'
/cfquery
** PLEAS READ**
Now understand that I don't use session variables at all in my apps and
never will. this is just a rough idea of what you would most likely do to
mimic client variables with session variables. Personally i would rewrite
the app to use client variables. But each to their own. You will probably
need to correct / rewrite some of this code. Hey I wrote it off a whime and
without testing :P.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 10:10 AM
To: CF-Talk
Subject: RE: storing session variables in DB
dude all you have to do is make sure that each app has it's own application
name in the cfapplication tag.
name of app1
cfapplication name=test
name of app2
cfapplication name=test2
now the user's can't share session variables.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 10:06 AM
To: CF-Talk
Subject: storing session variables in DB
I have a set of mirrored servers that are running off 1 SQL_server.
I have to recode the apps that use session variables because
a user could jump to a different server during a session. Is
there a simple way to fix this? Can 2 different servers be aware
of the same session? Can I store the session variables in the
SQL-server DB?
I am running Win2k, SQL-Server 2000, and (I know) CF%.0 Professional.
There is no need to tell me that the Enterprise version will
allow me to isolate a user to one server during a session.
Thanks in advance,
BJ
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: unscoped variables
all unscoped variables are part of the variables scoped. cfset temp = testing cfoutput#temp#/cfoutput is also cfoutput#variables.temp#/cfoutput this happens no matter what page it is set on, includeing the application.cfm. if you want a variables to be in the appliction scope, you have to deliberatly set it there: cfset application.temp = testing cfoutput#application.temp#/cfoutput Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:12 AM To: CF-Talk Subject: Re: unscoped variables If they are created in the Application.cfm page, they are application variables (application.whatever) Paul Giesenhagen QuillDesign - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:04 AM Subject: unscoped variables I'm trying to clean up some code on an old application. If there are currently unscoped variables defined using cfset on an application.cfm page, what scope are these created in? Thanks! __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Variable DB storage
we have a separate database for storing client variables. Strangely enough called cfclient :P. We do it because it becomes a hassle creating a client variables storage for every app. There is not good or bad reasons to have one for every database, just preference. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:32 AM To: CF-Talk Subject: Client Variable DB storage On page 549 of Forta's CF 5 book he outlines how to store client vars in a DB. Step 1 reads If you want, you can use an existing database, but we recommend hat you use a fresh, dedicated database for storing client variables. but it doesn't say why. I would think that if i have a dedicated DB for a certain app that I would want to store the client variables for that app in the same DB. thoughts? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: unscoped variables
I would just LOVE to see by how much. 001 ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Nate Nielsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:20 PM To: CF-Talk Subject: Re: unscoped variables An interesting thing that many developers overlook, or just don't know - is that there is actually a performance increase in SETTING your variables scope variables as well as reading them. We all know that #variables.myVar# is faster than #myVar# - It is slight, but yes - using cfset variables.myVar = foo is faster than cfset myVar = foo =) Nate Nielsen [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:36 AM Subject: RE: unscoped variables I thought the variables scope was local to an individual page. These variables (set unscoped in application.cfm) are used throughout the entire application. That's why I asked. Tony_Petruzzi@s heriff.org To: CF-Talk [EMAIL PROTECTED] cc: 06/04/2002 Subject: RE: unscoped variables 10:24 AM Please respond to cf-talk all unscoped variables are part of the variables scoped. cfset temp = testing cfoutput#temp#/cfoutput is also cfoutput#variables.temp#/cfoutput this happens no matter what page it is set on, includeing the application.cfm. if you want a variables to be in the appliction scope, you have to deliberatly set it there: cfset application.temp = testing cfoutput#application.temp#/cfoutput Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:12 AM To: CF-Talk Subject: Re: unscoped variables If they are created in the Application.cfm page, they are application variables (application.whatever) Paul Giesenhagen QuillDesign - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:04 AM Subject: unscoped variables I'm trying to clean up some code on an old application. If there are currently unscoped variables defined using cfset on an application.cfm page, what scope are these created in? Thanks! __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Is this possible to do?
just to throw a tidbit out there. Remember that if you use MSSQL server you
cannot use IN inside a stored procedure that you are passign the list in.
such that
Store Procedure
===
CREATE PROCEDURE ProcessList
@myList varchar(255)
As
SELECT *
FROM MyTable
WHERE myColumn IN (@myList)
cfset variables.mylist = me, myself, and i
cfstoredproc procedure=ProcessList
datasource=#request.dsn#
username=#request.username#
password=#request.password#
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@mylist value=#variables.mylist# maxlength=255 null=No
cfprocresult name=ProcessList
/cfstoredproc
This would fail. There are somework arounds. Use can use dynamic sql:
EXEC 'SELECT * FROM MyTable WHERE myColumn IN (' + @myList + ')'
this stinks because you have to give the user access to the table and not
just stored procedure access, so this is a little bit of a security risk in
your application.
OR
if you are using SQL Server 2000 you can write list functions.
http://www.xcreation.com/downloads/ListGetAt.sql
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 12:52 PM
To: CF-Talk
Subject: RE: Re[2]: Is this possible to do?
Critz and Gyrus,
I think I need more caffeine. I STUPIDLY forgot to do: WHERE ID IN
(#form.ID#). Yup, those damn parens do it all the time. ARGH!
*gets up, smashes head on monitor, and stomps off to get more coffee*
Thanks,
T
-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 11:58 AM
To: CF-Talk
Subject: Re[2]: Is this possible to do?
oi Tony!!
si Tony is correct. all you would need would be the one fieldname,
since if
there are more than one, their values are passed thru in a list. And
even if
there is only one. the [IN(#form.id#)] will still work
--
Critz
Certified Adv. ColdFusion Developer
Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion
Tuesday, June 4, 2002, 11:28:40 AM, you wrote:
TC But this would also include the form field SUBMIT which, obviously,
isn't
TC part of the DB. Right?
TC -Original Message-
TC From: Gyrus [mailto:[EMAIL PROTECTED]]
TC Sent: Tuesday, June 04, 2002 11:18 AM
TC To: CF-Talk
TC Subject: Re: Is this possible to do?
TC - Original Message -
TC From: Tony Carcieri [EMAIL PROTECTED]
TC --snip--
TC cfquery datasource=mydatasource name=deletethese
TCUPDATE mytable
TCSET IsDeleted = 1
TCcfloop query=deletethese
TCWHERE ID = '#form.ID#'
TC/cfloop
TC /cfquery
TC ---
TC You're submitting a form with one or more checkboxes checked to delete,
TC yeah?
TC Try using the 'form.fieldnames' value and the SQL 'IN' operator.
TC Form.fieldnames should contain a list of all form fields defined in the
TC submission. Checkboxes that aren't checked aren't even defined, so...
TC cfquery datasource=mydatasource name=deletethese
TC UPDATE mytable
TC SET IsDeleted = 1
TC WHERE ID IN (#form.fieldnames#)
TC /cfquery
TC HTH,
TC - Gyrus
TC
TC - [EMAIL PROTECTED]
TC work: http://www.tengai.co.uk
TC play: http://www.norlonto.net
TC - PGP key available
TC
TC
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client variable storage question
did you forgot to go into the cf admin on your laptop and setup the database as a client variable storage? :) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Richard Tugwell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 1:13 PM To: CF-Talk Subject: Client variable storage question Hi All I'm going a bit mad. I have a site - (CF5/SQL7/W2000) on my desktop. I have just copied it all to a new laptop to take and show a client (CF5/SQL2000/W2000). I scripted the SQL setup and it ran ok. The site uses client variables, stored in the database. I have configured client storage/users/logons/permissions etc identically on both machines, but when I try and run it through the laptop I get an ODBC error Base Table Not Found ... Invalid Object Name CGLOBAL etc etc. I thought CF configured these tables automatically as soon as it hit a cfapplication tag ? Everything runs ok apart from the client variable functions. If I disable this part of the site I get no errors and DB access runs unhindered Both versions of CF5 are single use developer configurations Any ideas would be appreciated. I'm probably just being stupid Cheers Richard FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Is this possible to do?
well sortof. when you pass in the value to the storedprocedure, MSSQL looks
at the string as a whole. to demostrate
mylist = me, myself, and I
to MSSQL, the string looks like:
'me, myself, and I'
even if you enclose each element in ' .
mylist = 'me', 'myself', 'and I'
MSSQL looks at it like
'''me'', ''myself'', ''and I'''
notice that it will escape the ' . Much like you doing
john''s book
this is actually a known limitation. there is alot more information on this
in the groups.google.com archives. probably better explaination to. :)
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: chad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 1:30 PM
To: CF-Talk
Subject: RE: Re[2]: Is this possible to do?
Isnt this because you need single quotes around your list items?
At 01:15 PM 6/4/2002 -0400, you wrote:
just to throw a tidbit out there. Remember that if you use MSSQL server you
cannot use IN inside a stored procedure that you are passign the list in.
such that
Store Procedure
===
CREATE PROCEDURE ProcessList
@myList varchar(255)
As
SELECT *
FROM MyTable
WHERE myColumn IN (@myList)
cfset variables.mylist = me, myself, and i
cfstoredproc procedure=ProcessList
datasource=#request.dsn#
username=#request.username#
password=#request.password#
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@mylist value=#variables.mylist# maxlength=255 null=No
cfprocresult name=ProcessList
/cfstoredproc
This would fail. There are somework arounds. Use can use dynamic sql:
EXEC 'SELECT * FROM MyTable WHERE myColumn IN (' + @myList + ')'
this stinks because you have to give the user access to the table and not
just stored procedure access, so this is a little bit of a security risk in
your application.
OR
if you are using SQL Server 2000 you can write list functions.
http://www.xcreation.com/downloads/ListGetAt.sql
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 12:52 PM
To: CF-Talk
Subject: RE: Re[2]: Is this possible to do?
Critz and Gyrus,
I think I need more caffeine. I STUPIDLY forgot to do: WHERE ID IN
(#form.ID#). Yup, those damn parens do it all the time. ARGH!
*gets up, smashes head on monitor, and stomps off to get more coffee*
Thanks,
T
-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 11:58 AM
To: CF-Talk
Subject: Re[2]: Is this possible to do?
oi Tony!!
si Tony is correct. all you would need would be the one fieldname,
since if
there are more than one, their values are passed thru in a list. And
even if
there is only one. the [IN(#form.id#)] will still work
--
Critz
Certified Adv. ColdFusion Developer
Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion
Tuesday, June 4, 2002, 11:28:40 AM, you wrote:
TC But this would also include the form field SUBMIT which, obviously,
isn't
TC part of the DB. Right?
TC -Original Message-
TC From: Gyrus [mailto:[EMAIL PROTECTED]]
TC Sent: Tuesday, June 04, 2002 11:18 AM
TC To: CF-Talk
TC Subject: Re: Is this possible to do?
TC - Original Message -
TC From: Tony Carcieri [EMAIL PROTECTED]
TC --snip--
TC cfquery datasource=mydatasource name=deletethese
TCUPDATE mytable
TCSET IsDeleted = 1
TCcfloop query=deletethese
TCWHERE ID = '#form.ID#'
TC/cfloop
TC /cfquery
TC ---
TC You're submitting a form with one or more checkboxes checked to delete,
TC yeah?
TC Try using the 'form.fieldnames' value and the SQL 'IN' operator.
TC Form.fieldnames should contain a list of all form fields defined in the
TC submission. Checkboxes that aren't checked aren't even defined, so...
TC cfquery datasource=mydatasource name=deletethese
TC UPDATE mytable
TC SET IsDeleted = 1
TC WHERE ID IN (#form.fieldnames#)
TC /cfquery
TC HTH,
TC - Gyrus
TC
TC - [EMAIL PROTECTED]
TC work: http://www.tengai.co.uk
TC play: http://www.norlonto.net
TC - PGP key available
TC
TC
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Querying a table for its columns
oh yeah. god forbid the table has 10,000 and more records in it. The query would take a while. Goto groups.google.com and do a search there. I have seen this posted for Access, mssql, and mysql before. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 3:41 PM To: CF-Talk Subject: RE: Querying a table for its columns one method, which would avoid system tables, or other vendor specific methods, would be to simply do a Select * From Table using CFQUERY, then using the ColumnList field in the result list - it's a comma delimited list of all the columns. On SQL Server you can query the system tables (I think it's sysobjects you want here). I'm not sure about the system tables or methods available to Oracle or MySQL. Hope that helps. Shawn Grover -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 1:15 PM To: CF-Talk Subject: Querying a table for its columns Querying a table for its columns I can't remember the syntax for querying a table for its columns. I think it is a mySQL table on CF 4.0x box. Eric __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rumor of lay-offs
i have been visiting FC for well over two years now. I must say that they are right on the money about their stories. I have no idea where Pud gets his info, but it's right on target. I personally think you could sell stock based off the information on his site. Just because the news is bad news, doesn't make it trash. If you were working at MM right now, information like that would be priceless. you could start looking for a new job before everyone else. how is that trash? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:51 AM To: CF-Talk Subject: RE: Rumor of lay-offs Guys why even bother with that board. Just trash talk. SY -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 10:31 AM To: CF-Talk Subject: RE: Rumor of lay-offs Yeah, it is true. Although, I think it was less than 20 people. Additionally, I believe they knew well in advance of the release. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 6:32 AM To: CF-Talk Subject: Rumor of lay-offs Can anyone confirm or deny this: http://comments.fuckedcompany.com/phpcomments/index.php?newsid=87356sid =1 pag e=1parentid=0crapfilter=1 BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
might be inserting the value yourself from a storedprocedure then. The default will only be used when the user hasn't specified a value. example: you are insert the datetime yourself DECLARE @mytime datetime, @title varchar(50) SET @mytime = getdate() SET @title = 'this is a test' INSERT INTO table1 (CreationDate, title) VALUES (@mytime, @title) SQL Server does it for you DECLARE @title varchar(50) SET @title = 'this is a test' INSERT INTO table1 (title) VALUES (@title) What you probably are doing is assigning the getdate() to a local variables. and then doing an insert using this variables. If this is what are you doing then you are correct. SQL Server will insert the exact time for all records in the insert. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:50 PM To: CF-Talk Subject: RE: datetime formatting Tony, Doesn't getDate() consistently return the same date/time no matter how many recs are inserted? I found that in SQL. If I used getdate() and I inserted 10 records, each had the same date/time even though I submitted them at different intervals. Just need a clarification on this. Thanks, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting I'm using mySQL with a datetime field. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:39 PM To: CF-Talk Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Members Only section
use client variables. cfif NOT Isdefined(client.deptid) OR NOT Isdefined(client.admin) cflocation url=../index.cfm addtoken=No /cfif cfif DateDiff( n, client.LastVisit, now() ) GTE 20 cflocation url=../index.cfm addtoken=No /cfif Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:10 PM To: CF-Talk Subject: Members Only section Whats the best way to handle security on a members section wouldsomthing like this work? Application.cfm w/cookies set to expire in1 hour, or some other means please advise. Here is what kind of box I have, Windows 2K SQL 2K CF5 1gig or ram 36 gig scsi dule PIII 933 Thanks in advanced Ernie Pena Atomicqube __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Webtrends alternative
http://www.123loganalyzer.com/ this thing is FAST and cheap too. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 4:36 PM To: CF-Talk Subject: Webtrends alternative I need to find a Webtrends alternative on Win2K. I don't even care if it runs off my desktop or on the server at this point. I just need to have some reports run. I tried the archive for this but it didn't seem to be working for me. Thanks all, Phillip Broussard Tracker Marine Group 417-873-5957 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug??
remove the #
background-color: 66
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 5:31 AM
To: CF-Talk
Subject: RE: IE 6.0 Bug??
I'll have some of that too :O)
[EMAIL PROTECTED]
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2002 04:34
To: CF-Talk
Subject: Re: IE 6.0 Bug??
I have the problem reduced to a simple .html file and a .css style sheet
that goes with it if someone want to take a crack at it... :-)
At 08:14 PM 5/30/02 -0700, you wrote:
Changing to ...-color: in the FORM .css file statement effects
no-change. it still renders the color and causes the text to not
display... unless I drag the scroll bar causing the browser to re-paint the
scrolled area of the page. Then the text becomes visible.
I don't want the entire page background to be #66 in color so I have
not used that approach..
It's maddening at the moment! Pulling the color statement out leaves the
Form white...
At 10:01 PM 5/30/02 -0400, you wrote:
2 suggestions
1 - move it into the body tag
body {
background-color: #66;
}
2 - background-color: #66;
one of those should do it - I recommend #1
jay miller
Brian Scandale wrote:
Just installed on a site that is exclusively IE 6.0 and suddenly some
very simple text is not displaying...
So I hit it with IE 5.5 and all is OK.
Next I pulled the View/Source output apart and everything looks OK.
Discovered that if I pull the background statement,(SeeBelow) out of the
css file then it displays properly... but that's a bummer because that
ruins the esthetics of the page.
Is there something wrong with my .css statement that anyone can tell?
FORM { font-size : 11px;
background : #66; ---theBadActor
border : thin outset;
}
Thanks for Looking at this.
~Brian
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: File selection...is this possible?
you could just put the files names into the select box and use the multiple parameter select name=selectfiles size=5 multiple option value=file1The file name/option option value=file2The file name/option option value=file3The file name/option option value=file4The file name/option /select Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 8:51 AM To: CF-Talk Subject: File selection...is this possible? Hi, I have an application where I'm listing multiple files and I require to select certain files in that list or all files. I had the idea of display radio buttons beside each filename and have the user select which files are required and pass all the filenames to another template for processing. I would *really* like to do is a Shift+Click and/or Cntl+Click to highlight selections (Like MS Explorer window) Is this possible? If so, how do I go about this? +--- + Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +--- -+ __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bulk email servers...
someone once wrote a way here how send emails directly to MS SMTP service using cffile instead of cfmail. using this method you could easily send out a million plus emails a day. best of all ms smtp service is free with windows. Personally I would take the technique that he uses and write a vb app that dumps the emails. I wouldn't want to have my CF service doing something that a simple app could do. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 12:07 PM To: CF-Talk Subject: Re: Bulk email servers... The HoF server sends out about a million messages a day (weekday). __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTRY/CFCATCH Database errors
uhhh, why not just do a cflocation to the temppage.cfm? Or rethrow the error on an Any and use cferror to catch the error information and email to you and then cflocation them to the temppage.cfm? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 9:45 AM To: CF-Talk Subject: Re: CFTRY/CFCATCH Database errors Strange, seems okay to me. We use this in CF 4.5 and it works okay catching if the Oracle database (using native drivers) goes down. I'd still like more granularity, so if the db is actually down (as opposed to merely erroring) I can put up a notice. If I were you, I'd break down what you have and see what's causing the problem. I'd remove the javascript and just go to an ordinary CF page and see if that's the problem. good luck, Chris Norloff -- Original Message -- from: Bosky, Dave [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Thu, 23 May 2002 16:17:27 -0400 If I've got a query and for some odd reason the database server goes down, of course my query will fail. How can I catch the error due to the server being down and display a static/temp page instead? My code is below and it appears to be correct but it will not catch the error and redirect. Any ideas... Thanks, Dave - cftry cfquery name=x datasource =x blah blah /cfquery cfcatch type=database script language=JavaScript alert (Database Server is down! Please click OK to continue.); self.location=TempPage.cfm; /script /cfcatch cfcatch type=any script language=JavaScript alert (Database Server is down! Please click OK to continue.); self.location=TempPage.cfm; /script /cfcatch /cftry __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MX training courses now available
I second that. Adam and David are the authority (respect it!) when it comes to CF training. If you get the chance to go, GO (plus the food is good). Also if they are offering their database class anytime soon, I would mortgage your house or sell off your first born to attend that class. I went to it and I walked away knowing more about SQL server from them than watching the Keystone Learning videos I spent a grand on. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 9:22 AM To: CF-Talk Subject: Re: MX training courses now available The classes are worth every penny, For several reasons you get the THOUghts and ideas of kick ass CF developers, you get the insite into some great ideas. You get to network with alot of kewl developers :) And the damn meals are worth it lol. Seriously if i had the cash on me i would go again becaus ei came away with alot of new ideas. Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:20 AM Subject: Re: MX training courses now available Would anybody (not associated with Productivity Enhancement, Inc.) who has taken any of their ColdFusion Master classes please contact me off list? [EMAIL PROTECTED] I'm interested in hearing what you thought, since this is not MM normal course line. Thanks, Dave - Original Message - From: Adam Churvis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 5:15 AM Subject: MX training courses now available Just a quick note that we finally posted info about our new MX courses on ColdFusionTraining.com. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion 5 Developer Productivity Enhancement, Inc. http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX in production?
before you do that, I would hope that you have put a copy of your website(s) on a test server with CFMX and ran some test. Remember that there are some depreciated tags, cfhttp screwup (mentioned earlier on the list), and other concerns that you might want take a look at. I would't just jump and upgrade a production server. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: chad [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:07 AM To: CF-Talk Subject: CF MX in production? Just wondering if anyone is using MX in a production environment under real loads? Any problems so far? We are getting ready to upgrade two of our production servers next week. Thanks NTMail K12 - the Mail Server for Education __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cffile parsing problem
cffile action=READ file=C:\Inetpub\wwwroot\test\test.txt variable=stuff cfloop index=i list=#stuff# delimiters=#chr(10)##chr(13)# cfset variables.part = trim(i) cfset variables.partlen = len(variables.part) cfset variables.newpart = left(variables.part, variables.partlen - 1) cfoutput#variables.newpart#br/cfoutput /cfloop Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 10:48 AM To: CF-Talk Subject: RE: cffile parsing problem You might want to start by replacing ,#Chr(10)##Chr(13)##Chr(10)##Chr(13)# with a pipe or something. Then you can just loop thru the pipe for each line. DRE -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 8:53 AM To: CF-Talk Subject: cffile parsing problem Hi all I have a txt file (I cannot change the format) which I want to insert/update into an access database online. I've been trying to read the file using CFFILE but cannot parse it properly This is the file: SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE DENSEY,23.95,1,TP,, SUS,CATTLE,0882660667,Family Cow,VAN LOON DIRK,29.95,2,PB,, SUS,CATTLE,0911311688,Natural Cattle Care ACRES USA ED,COLEBY PAT,49.50,0,TP,, SUS,COMPOS,0670904678,Australian Self Sufficiency Ha,SMITH KEITH,39.95,0,TP,1992, SUS,CONIFE,1876473312,Gardening With Conifers,BLOOM ADRIAN,42.90,0,HB,2001, SUS,COOKIN,0732265517,Best of Jackie French,FRENCH JACKIE,24.95,1,TP,, SUS,COWSMI,086417120X,Keeping a Cow,WILSON JIM,0,0,TP,1987, I don't know how to get rid of the last comma in each line, and then how to parse with a blank line between each record. I've tried this CFFILE action=READ file=D:\InetPub\wwwroot\_Candelo\database\candeloweb1603.txt variable=Candelo !--- Set a variable to hold the ascii values for a line break and a carriage return --- CFSET new_line=Chr(10) Chr(13) !--- Loop thru lines of text --- CFLOOP index=i list=Candelo delimiters=new_line cfoutput#Candelo#/cfoutputBR /CFLOOP and get this (but repeated three times!) SUS,BUTTER,1876334568,Attracting Butterflies to Your Garden,CLYNE DENSEY,23.95,1,TP,, SUS,CATTLE,0882660667,Family Cow,VAN LOON DIRK,29.95,2,PB,, SUS,CATTLE,0911311688,Natural Cattle Care ACRES USA ED,COLEBY PAT,49.50,0,TP,, SUS,COMPOS,0670904678,Australian Self Sufficiency Ha,SMITH KEITH,39.95,0,TP,1992, SUS,CONIFE,1876473312,Gardening With Conifers,BLOOM ADRIAN,42.90,0,HB,2001, SUS,COOKIN,0732265517,Best of Jackie French,FRENCH JACKIE,24.95,1,TP,, SUS,COWSMI,086417120X,Keeping a Cow,WILSON JIM,0,0,TP,1987, Can anyone give me some clues or help please Many thanks Seamus __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Quick question on custom tags
cfmodule template= Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Brian Eckerman [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:05 AM To: CF-Talk Subject: Quick question on custom tags Is it possible to call a custom tag that resides in a folder other than the current folder. I am using cf_cf_formurl2attributes but I would like to have one copy residing in a commonfiles folder at root. This would take something like ../cf_cf_formurl2attributes right? It doesn't seem to work. Any help is appreciated. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adult hosting
check out http://webhost.thelist.com/business/ check adult content allowed. or goto http://www.overture.com do some search for adult web hosting and the like Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 11:43 AM To: CF-Talk Subject: RE: Adult hosting Howdy i will be setting up a local CF server and sql server in a bit once i get Sprint to install my t1 line properly let me know what their budget/needs are. unless you found someone else Check on your contract, if it says you're not allowed to host adult content sites, then you're in voilation, and thus they can remove your line... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL server trouble
that's the first place to go whenever you have problem with a Microsoft product. Second is google groups. this list should be a last ditch effort. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 1:45 PM To: CF-Talk Subject: Re: SQL server trouble Thank you for your responses friends. I finally found the answer in www.microsoft.com in the troubleshouting section.Down here the article URL http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q293107 I have to work around it because it could happen again anytime I restart the machine. Thanks for your concern , thank you Rob and the others friends regards Mario - Original Message - From: Rob Baxter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 12:32 PM Subject: RE: SQL server trouble check to make sure your SQL server is listening on tcp port 1433 (unless you have changed the default port). You can either do a netstat -an from the sql box or from the client machine try telnet sql-server-ip 1433 If you get a response your traffic is getting through. If not you've either got something in the way (firewall) or a problem with your SQL network libraries. I actually just had this problem yesterday so if that is it I'll tell you what worked for me. Have you made any configuration changes to SQL recently? /rob -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 12:10 PM To: CF-Talk Subject: SQL server trouble Hi all friends: I got a coldfusion system with an SQL server . Today I came in here and I realize that I can't connect this SQL server from any other computer through ODBC . I could do that before , now none of my remotly ODBC connections are working This is the error I receive when I try to connect remotly: Connection failed SQLState:'01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver ][TCP/IP Sockets]ConnectionOpen(connect()). Connection failed: SQLState: '08001' SQL Server Error: 11 [Microsoft][ODBC SQL Server Driver]General network error. Check your network documentation. Any ideas will be more than appreciate. regards Mario __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL server trouble
just out curiosity. I wonder, if the next time this happens, if you viewed the services file, (c:\winnt\system32\drivers\etc\services) if it would tell you what is hooked on that port. if it does, then you know what app is the culprit. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 1:46 PM To: CF-Talk Subject: Re: SQL server trouble Thank you for your responses friends. I finally found the answer in www.microsoft.com in the troubleshouting section. The problem was that somehow one winsock service(as the port asiggment is dinamically on it) was steeling the 1433 port and SQL server could not listen in 1433 port. What I did was to stop all the services except the defaults, restart the SQL service and restart the others services again, in this way SQL server takes this port firts. I have to work around it because it could happen again anytime I restart the machine. Thanks for your concern regards Mario - Original Message - From: Rob Baxter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 12:32 PM Subject: RE: SQL server trouble check to make sure your SQL server is listening on tcp port 1433 (unless you have changed the default port). You can either do a netstat -an from the sql box or from the client machine try telnet sql-server-ip 1433 If you get a response your traffic is getting through. If not you've either got something in the way (firewall) or a problem with your SQL network libraries. I actually just had this problem yesterday so if that is it I'll tell you what worked for me. Have you made any configuration changes to SQL recently? /rob -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 12:10 PM To: CF-Talk Subject: SQL server trouble Hi all friends: I got a coldfusion system with an SQL server . Today I came in here and I realize that I can't connect this SQL server from any other computer through ODBC . I could do that before , now none of my remotly ODBC connections are working This is the error I receive when I try to connect remotly: Connection failed SQLState:'01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver ][TCP/IP Sockets]ConnectionOpen(connect()). Connection failed: SQLState: '08001' SQL Server Error: 11 [Microsoft][ODBC SQL Server Driver]General network error. Check your network documentation. Any ideas will be more than appreciate. regards Mario __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[4]: Preventing user from going back
why don't you tell us why you don't want people to be able to GO BACK. Depending on the situation you're facing, you might be beating your head against the wall for nothing. The only reason I can think of why you wouldn't want someone to be able to go back, is because of form submission, and personally well written code and a client variable takes care of this problem everytime. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 2:54 PM To: CF-Talk Subject: Re[4]: Preventing user from going back oi Mario!! well then I reckon you'd just have too much time on yer hands -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 2:38:07 PM, you wrote: MM What if I view the file source, erase all the java script code that is MM bothering me .Save the file into my local harddisk and run the browser over MM it MM and try to going back??? . MM regards MM Mario MM - Original Message - MM From: Critz [EMAIL PROTECTED] MM To: CF-Talk [EMAIL PROTECTED] MM Sent: Thursday, May 30, 2002 2:18 PM MM Subject: Re[2]: Preventing user from going back oi Alex!! then you could always do this noscriptmeta refresh../noscript seeing as how most of us develop web applications and not MM websitesif javascript is disabled, then they don't need to be there.. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 2:07:05 PM, you wrote: A What happens if I disable javascript? A On Thu, 30 May 2002, Critz wrote: oi Mark!! SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- window.history.forward(); file://-- /SCRIPT on the preceding page -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 1:19:09 PM, you wrote: MS Hey all, MS Does anyone have an easy way to prevent the user from going back to MM the MS previous page? MS -- MS Mark Smeets / stranger0 / ICQ: 1062196 MS [EMAIL PROTECTED] MS http://www.prowerks.com/stranger MS Life is a series of small victories - Gene Simmons MS FAQ: http://www.thenetprofits.co.uk/coldfusion/faq MS Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ MS Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists A MM __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDIRECTORY
http://www.xcreation.com/apps.cfm download the one called directory listing tag. Just drop it into the directory you want listed. Has built in security. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:05 PM To: CF-Talk Subject: Re: CFDIRECTORY oi Rodney!! if you are using CF5, you could always re-query the directory query based on your list using an [[IN]] statement -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 3:03:50 PM, you wrote: BRSHS Hello all BRSHS I am using CFDIRECTORY to grab file info. BRSHS but I only want to display info on files in a pre-chosen list. BRSHS I know you can loop through CFDIRECTORY like a query. BRSHS but how would I do something like this: BRSHS other info here BRSHS filefromlist (size) (date last modified) BRSHS filefromlist BRSHS filefromlist BRSHS more info BRSHS it would cumbersome to run the loop for each file, is there an BRSHS easier way: BRSHS CFLOOP filelist BRSHS CFDIRECTORY BRSHS CFIF CFDIR.filename = listfilename BRSHS display info BRSHS /CFIF BRSHS /CFDIRECOTRY BRSHS /CFLOOP BRSHS Thanks BRSHS Rodney BRSHS __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Preventing user from going back
and then all someone has to do is use a program to spoof the referrer information and their in. The only thing that you as a web programmer can do without beating your head against the wall is to make sure you qualify all variables passed to the page, check them to make sure they are of the length and type you want and then have error checking to test the values. If you do that, then it doesn't matter where the information is coming. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:54 PM To: CF-Talk Subject: RE: Re[2]: Preventing user from going back The only way I have seen to do this, and it was mentioned by someone earlier, is to only allow for a specific referer. You would use the url to the page that the user 'should' be coming from like this: cfif cgi.HTTP_REFERER is 'my url' Allow the template to process cfelse move them somewhere else either with cflocation or a script /cfif Tim Heald ACP/CCFD :) Application Development www.schoollink.net -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:18 PM To: CF-Talk Subject: Re: Re[2]: Preventing user from going back Interesting point. I took it upon myself to test out your question and found that you CAN go back. On Thu, 30 May 2002, Mario Martinez wrote: What if I view the file source, erase all the java script code that is bothering me .Save the file into my local harddisk and run the browser over it and try to going back??? . regards Mario - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 2:18 PM Subject: Re[2]: Preventing user from going back oi Alex!! then you could always do this noscriptmeta refresh../noscript seeing as how most of us develop web applications and not websitesif javascript is disabled, then they don't need to be there.. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 2:07:05 PM, you wrote: A What happens if I disable javascript? A On Thu, 30 May 2002, Critz wrote: oi Mark!! SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- window.history.forward(); file://-- /SCRIPT on the preceding page -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 1:19:09 PM, you wrote: MS Hey all, MS Does anyone have an easy way to prevent the user from going back to the MS previous page? MS -- MS Mark Smeets / stranger0 / ICQ: 1062196 MS [EMAIL PROTECTED] MS http://www.prowerks.com/stranger MS Life is a series of small victories - Gene Simmons MS FAQ: http://www.thenetprofits.co.uk/coldfusion/faq MS Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ MS Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists A __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Image Servers
how about something free like JGenerator http://www.flashgap.com/ the site even has a comparision between it and Macromedia Generator. Best of all, it's FREE! Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1:37 PM To: CF-Talk Subject: RE: Image Servers I'm investigating image servers for Win32. So far, I'm looking at... MGI/Roxio Zoom Server Adobe Altercast Macromedia Generator Can anyone suggest any other image servers that would serve well in an enterprise environment? I'll just add those to my research. Generator is a dead product, they dumped it even though it was pretty good... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Search Engines
check out http://www.rolist.com rotating search engine. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:05 PM To: CF-Talk Subject: OT: Search Engines Does anyone know of a list that has to do with search engine optimization? We are trying to get better rankings and I could use all the input I can get. Douglas Brown Email: [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Emergency: Authorize. net woos
Alright is there anyone out there that has successfully implemented the new Authorize. net referer security reqquirement? I have been trying for two days to do this with no aval. Dave watts posted something here a couple of days ago saying that you can pass a httpparam with the type of cgi, the name of referer and the value of the url. The problem is is that the url I pass it is in urlencodeformat for some reason and Authorize.net won't accept it. Has someone worked this out yet. I'm desperate here. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: page security using cfabort
the really bad thing about using cfabort is that EVERYTHING after it stops processing. So if you code like I do where I put my footer in the onrequestend.cfm file, well gues what, your footer doesn't process. Personally I just set a variable called variables.ErrorCode equal to 0. Then during error checking, if an error occurs, I set it to 1. Now all I have to do is use some cfifs to see what I want to execute. Plus my footer comes up. ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Seth Petry-Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 11:37 AM To: CF-Talk Subject: Re: page security using cfabort You could always put in the necessary closing tags before the CFABORT... The main drawback to doing this approach is that it leads to cluttered code, especially if there is complex HTML code contained in your page footer. Also, consider a situation where there needs to be more than one security check: CFIF NOT condition1 Sorry, you're not authorized for this. !-- closing HTML tags here -- CFABORT CFELSEIF NOT condition 2 Sorry, you're only authorized for this on Mondays. !-- closing HTML tags here -- CFABORT CFELSEIF NOT condition 3 Sorry, you're only authorized for this on Tuesdays. !-- closing HTML tags here -- CFABORT /CFIF This can become quite messy and is hard to maintain with closing tags scattered all around the page. Your best bet is to create a standard not authorized page and just do a CFLOCATION to it when needed. I usually add a CFABORT just after the CFLOCATION in case, for some reason, the browser ignores the client side redirect. It looks like this: CFIF NOT condition1 CFLOCATION URL=not_authorized.cfm CFABORT CFELSEIF NOT condition 2 CFLOCATION URL=not_authorized.cfm CFABORT CFELSEIF NOT condition 3 CFLOCATION URL=not_authorized.cfm CFABORT /CFIF Regards, Seth Petry-Johnson Argo Enterprise and Associates __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Making normalized tables from a single flat file.
you know, you might not have to do that much work after all. you could use MS Access to import the information into an access database. after that, you can cut and paste the information into different tables and create relationships. if you really want to get jiggy with it, you can then use the upsize wizard to smack the puppy into a SQL database. so you fear of this job being 4 weeks, turn into 4 hours. gotta love Microsoft (oops, did i say that). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:00 PM To: CF-Talk Subject: Re: OT: Making normalized tables from a single flat file. Well, I don't know how much cleverness is involved... its just drudgery, but the sooner you start the better off you'll be. Design your proper tables, write your queries (and no doubt toss in a few loops) and off you go. Do you have any specific questions on the process? --Matt-- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Don't leave stuff lying around
Personally I think this comes from not doing error checks in your code more than leaving stuff lying around. Don't get me wrong, I think that at least once month you should go through your production site and see if everything is in order. Actually you should do that with each update. However, the first lines of every page should be error checking: 1) check to make sure each variable that is passed to the page exists and has a default value. cfparam name=form.username default= cfparam name=form.password default= 2) qualify the variables passed and make sure that they meet your standard for length and characters allowed. you have no idea how many people think that just because they put a maxlength in a form field that they are safe. --- Username and password can only be alphanumeric and no more than 50 characters --- cfset variables.username = left(trim(ReReplaceNoCase(form.username, [^A-Za-z0-9], , ALL)), 50) cfset variables.password = left(trim(ReReplaceNoCase(form.password, [^A-Za-z0-9], , ALL)), 50) 3) finally make sure that you don't have an empty string cfif variables.username EQ OR variables.password EQ cflocation url=index.cfm addtoken=No /cfif Make sure that you also check numeric values cfparam name=url.id default=0 cfset variables.id = val(url.id) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 10:57 AM To: CF-Talk Subject: RE: Don't leave stuff lying around Another option to stop this happening is to have them have a form at the start - they won't do the work until the form has been submitted... Stops the search engines bumping into them or WebTrends re-running stuff Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] Sent: 22 May 2002 13:29 To: CF-Talk Subject: Don't leave stuff lying around This morning I got into work to discover 3000 error messages generated since 4:30 yesterday afternoon with more pouring in by the minute. I had something of a panic attack as the site has been running with no errors for months. As it turned out, I had inadvertently left an old one time CF script on the server which had rebuilt a stored proc to a now-redundant version and was easy enough to undo. What had done this? IP traces from the site's logs showed the request to this rogue script coming from inside the client's gateway. At first I suspected someone there who didn't know what they were doing had simply been fiddling with the site, but as it turned out, they were running a badly configured copy of webtrends which was itself requesting pages that appear in the logfiles. It seems that Webtrends decided to go and check it out by requesting it - probably to ascertain its status code, and in so doing invoked the stored procedure deletion / re-creation. Moral: Don't leave stuff lying around. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Don't leave stuff lying around
don't get what you mean. Tried some tests over here and all spaces were caught. please give an example. cfparam name=variable type=numeric will this automatically set the default value to 0 even though you aren't specifying it? should it be cfparam name=variable type=numeric default=0? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Cravens, Billy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 12:11 PM To: CF-Talk Subject: RE: Don't leave stuff lying around 3) finally make sure that you don't have an empty string cfif variables.username EQ OR variables.password EQ cflocation url=index.cfm addtoken=No /cfif Actually, spaces won't be caught - use trim(len(string)) instead Make sure that you also check numeric values cfparam name=url.id default=0 cfset variables.id = val(url.id) IMHO, it's easier to use CFParam to throw when an invalid datatype is passed: cfparam name=variable type=numeric --- Billy Cravens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 10:52 AM To: CF-Talk Subject: RE: Don't leave stuff lying around Personally I think this comes from not doing error checks in your code more than leaving stuff lying around. Don't get me wrong, I think that at least once month you should go through your production site and see if everything is in order. Actually you should do that with each update. However, the first lines of every page should be error checking: 1) check to make sure each variable that is passed to the page exists and has a default value. cfparam name=form.username default= cfparam name=form.password default= 2) qualify the variables passed and make sure that they meet your standard for length and characters allowed. you have no idea how many people think that just because they put a maxlength in a form field that they are safe. --- Username and password can only be alphanumeric and no more than 50 characters --- cfset variables.username = left(trim(ReReplaceNoCase(form.username, [^A-Za-z0-9], , ALL)), 50) cfset variables.password = left(trim(ReReplaceNoCase(form.password, [^A-Za-z0-9], , ALL)), 50) 3) finally make sure that you don't have an empty string cfif variables.username EQ OR variables.password EQ cflocation url=index.cfm addtoken=No /cfif Make sure that you also check numeric values cfparam name=url.id default=0 cfset variables.id = val(url.id) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 10:57 AM To: CF-Talk Subject: RE: Don't leave stuff lying around Another option to stop this happening is to have them have a form at the start - they won't do the work until the form has been submitted... Stops the search engines bumping into them or WebTrends re-running stuff Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] Sent: 22 May 2002 13:29 To: CF-Talk Subject: Don't leave stuff lying around This morning I got into work to discover 3000 error messages generated since 4:30 yesterday afternoon with more pouring in by the minute. I had something of a panic attack as the site has been running with no errors for months. As it turned out, I had inadvertently left an old one time CF script on the server which had rebuilt a stored proc to a now-redundant version and was easy enough to undo. What had done this? IP traces from the site's logs showed the request to this rogue script coming from inside the client's gateway. At first I suspected someone there who didn't know what they were doing had simply been fiddling with the site, but as it turned out, they were running a badly configured copy of webtrends which was itself requesting pages that appear in the logfiles. It seems that Webtrends decided to go and check it out by requesting it - probably to ascertain its status code, and in so doing invoked the stored procedure deletion / re-creation. Moral: Don't leave stuff lying around. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513
RE: Search engine safe
how do accomplish something like this? Never did this before. Would be a good thing know. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 12:24 PM To: CF-Talk Subject: RE: Search engine safe Would the following url be search engine safe? http://www.autopartsland.com/Cart.cfm?model_id=21make_id=4 Or would it need to be like so http://www.autopartsland.com/Cart.cfm/model_id/21/make_id/4/ It depends on the engine, but I'd tend to use the slashed version as all engines will like that Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail error question
have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail error question
forgot to mention this, but the first thing I did was go through my cf-talk
archives and try the code that writes directly to the pickup directory. get
the same results, immediatly I get badmail errors. I guess what I'm
basically looking for is not a cf solution but a windows error solution.
anyone ever tackle this problem.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: nagrom [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 10:07 AM
To: CF-Talk
Subject: Re: cfmail error question
cameron childress presented a similiar solution at cfnorth a couple of weeks
ago
(cameron, aren't you lurking here somewhere?)
he suggested that due to the nature of the spool folder (its constantly
being polled for new files) its best to write the files in batches in a
different folder, and then move them to the spooler.
nagrom
~
http://www.morgankelsey.com
- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 9:57 AM
Subject: RE: cfmail error question
Someone on the list posted the core of this code last week - I'll pass
it along in Tag format.
This basically bypasses CFMAIL and dumps mail straight into the mailroot
spooler.
Thanks to whomever that was that posted the CFFILE code, you're my new
best friend!
!---
===
Tag Syntax
===
CF_SMTP_MAIL
smtp_file=
smtp_mime=
smtp_date=
smtp_to=
smtp_from=
smtp_reply=
smtp_subject=
smtp_body=
===
Begin Tag
===
---
cfscript
// UDF
function cfparam(varname) {
var value = ;
if(arrayLen(Arguments) gt 1) value = Arguments[2];
if(not isDefined(varname)) setVariable(varname,value);
return evaluate(varname);
}
// Set Defaults
#cfparam(attributes.smtp_file,c:\inetpub\mailroot\pickup\#createuuid(
)#.txt)#;
#cfparam(attributes.smtp_mime,Content-type: text/plain)#;
#cfparam(attributes.smtp_date,#dateformat(now(), ddd, d mmm )#
#timeformat(now(), HH:mm:ss)# -0500)#;
#cfparam(attributes.smtp_to,[EMAIL PROTECTED])#;
#cfparam(attributes.smtp_from,[EMAIL PROTECTED])#;
#cfparam(attributes.smtp_reply,)#;
#cfparam(attributes.smtp_subject,SMTP Test)#;
#cfparam(attributes.smtp_body,This is a test of SMTP Mail Dump)#;
/cfscript
cffile action=write file=#attributes.smtp_file#
output=#attributes.smtp_mime#
Date: #attributes.smtp_date#
To: #attributes.smtp_to#
From: #attributes.smtp_from#
Reply-To: #attributes.smtp_reply#
Subject: #attributes.smtp_subject#
#attributes.smtp_body#
!---
===
End Tag
===
---
Joshua Miller
Web Development :: Programming
Eagle Web Development LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 19, 2002 6:21 PM
To: CF-Talk
Subject: cfmail error question
have I have no idea why this happened, but all of a sudden cfmail fails
every time it send out an email. I'm using the smtp service that comes
with IIS to send out mails. Seems that every time an email is sent it
goes right into the badmail directory. The error that is sent into the
badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the
event viewer. Just wondering if any of you have come across this problem
and how to fix it. I have been on google groups and
support.microsoft.com for two days and have yet to find an answer other
a format and reinstall.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: cfmail error question
From: Petruzzi, Tony Sent: Sunday, May 19, 2002 6:21 PM To: CF-Talk (E-mail) Subject: cfmail error question have I have no idea why this happened, but all of a sudden cfmail fails every time it send out an email. I'm using the smtp service that comes with IIS to send out mails. Seems that every time an email is sent it goes right into the badmail directory. The error that is sent into the badmail directory is 0xc00402ce. Also an eventid 4000 is logged in the event viewer. Just wondering if any of you have come across this problem and how to fix it. I have been on google groups and support.microsoft.com for two days and have yet to find an answer other a format and reinstall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cfif cfelse question
is there any other variables distinguishing between a new and an edit? if not you should try passing a type variable that does. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ben Covington [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:40 AM To: CF-Talk Subject: Cfif cfelse question Hello All, I'm trying to develop a way to differentiate between a new record or the editing of a previous entered record using a single template. The user clicks on the link which passes the variable ID to the template for the cfif new and cfelse edit - but can only get one portion of the template to show at a time? I've also tried cfswitch and cfcase to no avail. What else should I try? Any assistance or direction will be greatly appreciated. Best regards, Ben __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Annoying DB question
how do you have the table setup? what column and default are you using for your PK? if you are using the two columns to form a PK, then you would get this error because, like you said, the values aren't unique. personally i always use uniqueidentifiers as PK and set the default of the column to newid(). if this sounds confusing, post the CREATE TABLE statments for that table and let us take a look. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 1:20 PM To: CF-Talk Subject: Re: Annoying DB question Well the value is not unique becuase the key is on MEALID and MEALTIME which is like 1 = monday time = 1(breakfast) i just was reading about that serialize isoloation level and thought that should do the trick Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: Van Vliet, Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:50 AM Subject: RE: Annoying DB question The error you are getting suggests that your PK value is not unique for the row that you are inserting into tblBenefit. Are you using IDENTITY on the PK for that table, or are you inserting the value from the SP? -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 8:38 AM To: CF-Talk Subject: Annoying DB question I'm having an issue Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object 'tblBenefit'.PP SQL = sp_newmeal Heres whats happening we have 8 rows in the db that hold meal plans when we change them we remove the old plans and insert new plans sometimes if you hit refresh enough it causes a ERROR above to be thrown. What i did was put the enter thing into a transaction with SET TRANSACTION ISOLATION LEVEL SERIALIZABLE and it still throws the error when the SQL notes say it shouldnt happen like that any ideas? thanks Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Annoying DB question
could you please post the create table statement. BTW IF EXISTS(SELECT * FROM tblBenefit WHERE acctid = @acctid AND visitNum = @visitnum AND benefitType = 1 AND benefitCode = @tempMealCode1) begin update tblBenefit set benefitCode=@tempMealCode1, visitNum=@visitNum where acctId=@acctid and sequence=1 and benefitType='ML' end ELSE begin insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 1, @tempMealCode1) end I wouldn't trust the @@ROWCOUNT value. Also I have had several SQLDBA that this is more efficient. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 3:54 PM To: CF-Talk Subject: Re: Annoying DB question i do commit heres the transaction CREATE PROCEDURE sp_newmeal ( @acctid varchar(20), @visitnum int, @delvisit int, @tempMealCode1 varchar(6), @tempMealCode2 varchar(6), @tempMealCode3 varchar(6), @tempMealCode4 varchar(6), @tempMealCode5 varchar(6), @tempMealCode6 varchar(6), @tempMealCode7 varchar(6), @tempMealCode8 varchar(6), @tempMealCode9 varchar(6), @tempMealCode10 varchar(6), @tempMealCode11 varchar(6), @tempMealCode12 varchar(6), @tempMealCode13 varchar(6), @tempMealCode14 varchar(6), @tempMealCode15 varchar(6), @tempMealCode16 varchar(6), @tempMealCode17 varchar(6), @tempMealCode18 varchar(6), @tempMealCode19 varchar(6), @tempMealCode20 varchar(6), @tempMealCode21 varchar(6), @tempMealCode22 varchar(6), @tempMealCode23 varchar(6), @tempMealCode24 varchar(6), @tempMealCode25 varchar(6), @tempMealCode26 varchar(6), @tempMealCode27 varchar(6), @tempMealCode28 varchar(6) ) AS begin /* NOTES BY BILL W. Edited 4-26-2002 Removed orvisitnumber Because we just want to update the old rows we'll update the new rows or visitNum = @visitnum */ SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO BEGIN TRANSACTION delete from tblBenefit where acctid = @acctid and (visitNum @delvisit) and benefitType = 'ML' START SEGMENT --- update tblBenefit set benefitCode=@tempMealCode1, visitNum=@visitNum where acctId=@acctid and sequence=1 and benefitType='ML' -- Lets Check to see if the update hit something if not insert! IF @@ROWCOUNT = 0 insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 1, @tempMealCode1) END SEGMENT --- START SEGMENT --- update tblBenefit set benefitCode=@tempMealCode2, visitNum=@visitNum where acctId=@acctid and sequence=2 and benefitType='ML' -- Lets Check to see if the update hit something if not insert! IF @@ROWCOUNT = 0 insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 2, @tempMealCode2) END SEGMENT --- START SEGMENT --- update tblBenefit set benefitCode=@tempMealCode3, visitNum=@visitNum where acctId=@acctid and sequence=3 and benefitType='ML' -- Lets Check to see if the update hit something if not insert! IF @@ROWCOUNT = 0 insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 3, @tempMealCode3) END SEGMENT --- START SEGMENT --- update tblBenefit set benefitCode=@tempMealCode4, visitNum=@visitNum where acctId=@acctid and sequence=4 and benefitType='ML' -- Lets Check to see if the update hit something if not insert! IF @@ROWCOUNT = 0 insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 4, @tempMealCode4) END SEGMENT --- START SEGMENT --- update tblBenefit set benefitCode=@tempMealCode5, visitNum=@visitNum where acctId=@acctid and sequence=5 and benefitType='ML' -- Lets Check to see if the update hit something if not insert! IF @@ROWCOUNT = 0 insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 5, @tempMealCode5) END SEGMENT --- START SEGMENT --- update tblBenefit set benefitCode=@tempMealCode6, visitNum=@visitNum where acctId=@acctid and sequence=6 and benefitType='ML' -- Lets Check to see if the update hit something if not insert! IF @@ROWCOUNT = 0 insert into tblBenefit (acctId,visitNum,benefitType,sequence, benefitCode) VALUES(@acctid,@visitnum,'ML', 6, @tempMealCode6) END SEGMENT --- START SEGMENT --- update
linux CF IDE
anyone know of a linux ide for CF? i really want to make the switch to linux, but haven't found an ide that compares to cfstudio. I doubt I will, but there might be an ide that has promise. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: linux CF IDE
From: Petruzzi, Tony Sent: Friday, May 17, 2002 3:33 PM To: CF-Talk (E-mail) Subject: linux CF IDE anyone know of a linux ide for CF? i really want to make the switch to linux, but haven't found an ide that compares to cfstudio. I doubt I will, but there might be an ide that has promise. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: linux CF IDE
I think I got that wrong :P. I should of said a CF IDE for linux. yeah that's it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 3:33 PM To: CF-Talk Subject: linux CF IDE anyone know of a linux ide for CF? i really want to make the switch to linux, but haven't found an ide that compares to cfstudio. I doubt I will, but there might be an ide that has promise. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dynamic select boxes in netscape don't work
I'm writing an app that will use dynamic select boxes. you know, the ones where you select something in one box and it populate the other select box with the appropiate choices. the problems is that I'm trying to get this to work in netscape 4.79 for windows and it isn't working. works fine in ie6 of course but netscape won't execute the javascript. I searched google groups and someone said that netscape option array is read-only. another person said that after you execute the javascript to populate the options array, you have to use history.go(0) in order to refresh the page. anyone gotten this to work in netscape? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamic select boxes in netscape don't work
function ChangeSubCategories(obj){
cfloop query=GetCategories
cfstoredproc
procedure=WEBGetSubCategories
datasource=#request.dsn#
username=#request.username#
password=#request.password#
cfprocparam type=In
cfsqltype=CF_SQL_VARCHAR dbvarname=@FK_tblCategories
value=#GetCategories.FK_tblCategories# maxlength=20 null=No
cfprocresult
name=GetSubCategories
/cfstoredproc
if(obj.value ==
cfoutput#GetCategories.FK_tblCategories#/cfoutput){
document.form1.tblSubCategories_name.options.length =
cfoutput#GetSubCategories.RecordCount#/cfoutput;
cfoutput query=GetSubCategories
cfset i =
GetSubCategories.CurrentRow - 1
document.form1.tblSubCategories_name.options[#i#].text =
#GetSubCategories.Name#;
document.form1.tblSubCategories_name.options[#i#].value =
#GetSubCategories.Name#;
/cfoutput
}
/cfloop
if(obj.value == ){
document.form1.tblSubCategories_name.options.length
= 1;
document.form1.tblSubCategories_name.options[0].text
= Choose a category first;
document.form1.tblSubCategories_name.options[0].value = ;
}
}
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Donnie Bachan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 11:47 AM
To: CF-Talk
Subject: Re: dynamic select boxes in netscape don't work
what exactly is the problem you are having? I have done this in javascript
before and it works in netscape. How are you going about creating the
options for the second box? If you could post your code I may be able to
offer more help.
Best Regards,
Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
Nitendo Vinces - By Striving You Shall Conquer
==
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to detect timeout session??
cfif Datediff(n, client.LastVisit, now()) GTE 40 cflocation url=#request.serverroot# addtoken=No /cfif put this in your application.cfm. make sure to client variables enabled. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Margaret Fisk [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:23 PM To: CF-Talk Subject: RE: How to detect timeout session?? I do a similar check but at the top of the page so it also catches people who haven't logged in at all. If the session variables are not defined or don't have the correct values (clicking logout changes to invalid value) then it redirects to the login page. This is both security for direct calls to the individual page and manages session timeouts in one. Margaret -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:21 AM To: CF-Talk Subject: RE: How to detect timeout session?? put this in application.cfm cfif (logic to check timeout) cfset fuseAction = login // fusebox style OR cflocation url=login.cfm // be careful here that you don't end up in an endless loop since application.cfm will be called again when the location happens /cfif +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 8:50 AM To: CF-Talk Subject: How to detect timeout session?? Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client var problem
why don't you just drop the client variable database and then recreate it. see if that fixes the problem. why waste your time beating your head against the wall. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 10:43 AM To: CF-Talk Subject: RE: Client var problem Tell you what - if you'll pay for the bandwidth, we'll host it for free :) Seriously... -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 7:28 AM To: CF-Talk Subject: RE: Client var problem This error occurs when you fail to offer the services of your shiny sql server to list manager g. -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 9:10 AM To: CF-Talk Subject: Client var problem We've got a shiny new SQL 2000 server storing our client vars - we're periodically seeing this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'CDATA' with unique index 'id1'. Has anyone else seen this? Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: MS SQL vs MySQL WAS: [admin] List status
article here http://www.eweek.com/article/0,3658,s=708a=23115,00.asp also you have to take into account that they were using JDBC drivers and MSSQL had problems. Quoted: Due to its significant JDBC (Java Database Connectivity) driver problems, SQL Server was limited to about 200 pages per second for the entire test. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 1:25 PM To: CF-Talk Subject: MS SQL vs MySQL WAS: [admin] List status What about the recent comparison in eWeek between MySQL, Oracl9i and SQL2k? MySQL was neck and neck with Oracle in response time and throughput, both better than SQL2k? I know that MySQL cannot really stand up to MS SQL but when you are talking about the amount that MS SQL costs versus using MySQL, I would us MySQL unless someone just wanted to pay for MS SQL. -- Clint Tredway -- Through Him, anything is possible. Can you say crap. :) I am not a big fan of MySQL. I have to do some work in it and it pales in comparison. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 5:19 PM To: CF-Talk Subject: Re: [admin] List status Can you say MySQL? g - Original Message - From: Margaret Fisk [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 14, 2002 6:10 PM Subject: RE: [admin] List status Actually, we just priced this: It is about $5000 per cpu if you get SQL Server Standard edition and about 20,000 (not sure about this one) per cpu if you want Enterprise edition. The difference between the editions is failover and uptime tools. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Here is a strange one...
is the cfexec service logged on as a local system account or a particular user? if it is logged on as a particular user, does that user login have the right permissions? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:57 PM To: CF-Talk Subject: RE: Here is a strange one... Its a possible work around but try running it with AT, if it works just use CFEXECUTE to schedule the job in AT. There must be some specific advanced permissions that are required. Adrian -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] I wrote a bat that simply deletes the files in c:\temp directory. I even use the proper flag for quiet mode so it doesn't ask are you sure? I run it on the command line and it works. I run it in cfexecute and it doesn't seem to work. The CF Application server does have permissions because I login to the machine as that user its running as and run the bat. Any ideas? Neil __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Computer Professionals / Cold Fusion Programmer
god I wish! ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:31 PM To: CF-Talk Subject: Computer Professionals / Cold Fusion Programmer Does anyone know how the law works for salaried employees, regarding Computer Professionals? Is there a minimum salary? Computer Professionals - A new law provides for increased hourly minimum pay for exempt computer professionals. The minimum salary requirement for exempt computer professionals rose from $41 per hour in 2001 to $42.64 in 2002. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Tag Updater for Studio 5 and MX?
well if they don't, I'm sure it wouldn't be a problem to write them overselves. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 9:58 AM To: CF-Talk Subject: Tag Updater for Studio 5 and MX? OK, so I've posted this question 4 times in the beta forums and *still* have yet to get any sort of response, so I figured I'd ask here since this list is apparently what MM is reading. Will there be a tag updater for CF Studio 5 (or 4.5 for that matter) containing all of the MX tags like there was when CF 5 was released? I think that would quell 99% of the flames from people on the list. This way, if you want to upgrade, great; if not, you can still take advantage of the new features in MX. And please, don't tell me to get Homesite+ because I've been using the beta, and it's just CF Studio re-branded. I have yet to see any new features that would prompt me to pay for an upgrade. And even then, it still has some shortcomings. Can anybody from MM (or Team MM if you're in the know) comment? Regards, Dave. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SELECT TOP n vs MaxRows...
Tyler is right. Using TOP is way more efficient since you aren't bringing 1000 results throught the pipeline only to use 10 of them. The only thing about TOP is that you can't set it dynamically, as is TOP @maxrows. To do this, use the SET ROWCOUNT @maxrows. Just be sure that after your SQL statement you do SET ROWCOUNT 0 to reset it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 6:56 PM To: CF-Talk Subject: Re: SELECT TOP n vs MaxRows... I probably should of asked about the penalties, which I assume there aren't any? Order clause still work, etc. We develop mainly on MS-SQL so it'll work for at least the next couple of projects...thanks all- Tyler Silcox email | [EMAIL PROTECTED] - Original Message - From: Rob Baxter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 6:31 PM Subject: RE: SELECT TOP n vs MaxRows... It would seem that TOP is more efficient because you're dropping the extra rows on the sql side instead of the cf side, thereby saving yourself some resources on the recordset transfer. /rob -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 6:32 PM To: CF-Talk Subject: SELECT TOP n vs MaxRows... A quickie: Is there any benefit to using SELECT TOP n vs using the MaxRows attribute in cfquery? Tyler Silcox email | [EMAIL PROTECTED] __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SELECT TOP n vs MaxRows...
actually thats not the same. SET ROWCOUNT will stop processing when @MAXROWS is reached, it ignores ORDER BYs. a TOP will order first then truncate the resultset. are you sure about it ignoring ORDER BYs? I just ran a test with SQL Server 7.0 and it returned the correct results and I included an order by. here are the results select pk from table3 order by name DESC pk 040BDF21-CE4D-4FD6-9817-5DC3D668D7DD 9E7955EB-1E45-4009-911C-9506C5248293 5BE8F249-D16A-46F5-97B3-2808848748AE 0342D3EB-A354-4E67-939D-0675643C9F36 EACD64D0-8C56-4367-8BD3-D1D34CA6DEE6 E1B43558-23A1-4608-8069-A4FF8A478FD5 ED936953-93FA-4405-9BCE-BC35A095E72B 682C6DBF-64BD-44CF-80CB-4B6B5FF72A65 4B5C7470-D644-47DB-92B7-B300BEBA3F30 19B1B62B-96CA-4D2B-9367-576F9584EFC1 43FE78C0-CCD8-4E2A-870B-01155A2FC5F1 16CC9F15-962D-41C7-8AAD-07346B9BF05B 325090CD-2387-486D-B443-BDEBA050DEC3 0386D88A-4EE6-4E56-9252-CAB15C9C7657 9C56BCE3-80B7-46D6-9B50-3876C68C427D E7549832-EE78-4284-81E1-0C8D4A187326 A1C8D584-C0C3-49BF-B0DB-A9DED7AB76C9 29A6CA5F-C4DB-4405-8983-55FCD5378985 F6D183E2-F743-481E-B86B-5350FF66A10A 1F5783E4-4A92-4386-B2C5-54A0EBA1E8C3 0E0B559D-51AB-4C08-9DCD-7FB2BCB486F8 064AE841-45B3-432B-898F-D999B8FB4386 EE074E81-073C-4EBF-B42E-1B0A8DA3E244 F60B46B3-80E2-42C0-97D9-3A416CE6AEC3 A0921845-F4D3-4860-AFFD-A3FBB366A511 79F571C9-E8C1-42BD-ACBF-163E0578C831 472C6D79-4EA8-49F0-8BC8-B7F44510B892 606F2DCA-6EB8-4EFC-86BD-CECDA31E3B14 211EA2C1-7645-4767-AE8B-062B22789FDC FD784A0A-A10B-4CF4-A20E-0A33A9A0E4C5 CE11B251-08E6-4778-B4B7-21C6DD87BE07 C68D214C-4EDB-42AD-99B0-218EEBD746C3 B87AF4B4-4EFA-4523-8A95-6DAE21C791BC 15D968EC-1DE1-487B-992C-6DBA7F8FCF8F E1AFCD40-317E-41D6-BB60-5703A5938929 096F710F-71CA-4BBF-A14D-1BB6C80800DC E1D4DAFF-7DA9-449B-BF29-651694AA756E 49AF6EA8-C163-43C2-A91F-5ACD4F243EB5 DD102BFA-AB76-4057-8B5E-2563A3CA9F79 25FA065D-30A3-4A7D-AEEA-19FC0A3B0B89 C0B553D2-80F6-40ED-88E2-FF17BB566AC1 560989BD-B6E9-45FF-BA6C-351F38E11615 EF35EFE8-9475-40FE-AC6E-298AA9C07C52 D70C93CD-1B61-48CE-A0A7-E59D8CB0F36B 01FBCD3C-949E-47D5-8611-D8814FE2AC36 70CCA643-2291-4C29-8BF4-23E67A7AFB7E 3E1D788F-B4AB-4118-AE3A-B9C0B54B09F3 05664027-2E9F-44EC-9453-FDB6A74AADB8 0642A382-6352-4F02-8AB2-23077EF45AC4 58792375-6D8B-49A1-9D9B-2FCD2C543EE4 573FF8EF-524B-4398-995B-D9AEFB66F959 4D53FBBC-F9F6-41F8-AE95-E284C0722BFC 7AE32E5A-DEB1-4025-8723-8041B16D3553 4383EA6C-6DBD-4B87-A00D-E019A9E44257 A197B192-3347-404B-BDAD-02DB78A9818D 6EE26A6B-3D36-4FCC-A801-25B8640B5223 70F57CDF-69D6-4569-8FDA-BD5E76B2095D (57 row(s) affected) set rowcount 10 select pk from table3 order by name DESC set rowcount 0 pk 040BDF21-CE4D-4FD6-9817-5DC3D668D7DD 9E7955EB-1E45-4009-911C-9506C5248293 5BE8F249-D16A-46F5-97B3-2808848748AE 0342D3EB-A354-4E67-939D-0675643C9F36 EACD64D0-8C56-4367-8BD3-D1D34CA6DEE6 E1B43558-23A1-4608-8069-A4FF8A478FD5 ED936953-93FA-4405-9BCE-BC35A095E72B 682C6DBF-64BD-44CF-80CB-4B6B5FF72A65 4B5C7470-D644-47DB-92B7-B300BEBA3F30 19B1B62B-96CA-4D2B-9367-576F9584EFC1 (10 row(s) affected) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 9:15 AM To: CF-Talk Subject: Re: SELECT TOP n vs MaxRows... about TOP is that you can't set it dynamically, as is TOP @maxrows. To do this, use the SET ROWCOUNT @maxrows. Just be sure that after your SQL statement you do SET ROWCOUNT 0 to reset it. actually thats not the same. SET ROWCOUNT will stop processing when @MAXROWS is reached, it ignores ORDER BYs. a TOP will order first then truncate the resultset. __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session/browser problem??!!
i posted the answer to this question a while back. I have found the light http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316112 basically you can't have illegal characters in the domain name. in my case it was a _. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 6:11 AM To: CF-Talk Subject: session/browser problem??!! hihi.. i'm having some problem with the sessions. my codes works perfectly with IE 5, netscape 6 but not for IE 5.5 and IE 6. are there any known issues of session/cookies problem with the latter group?? seems like even i set all cookies and session enabled.. it still cant store my sessions... :( hmm.. probably.. theres some problem with the way i write my codes.. :( can u ppl help me to chk..? application.cfm: == CFAPPLICATION name=evehicle clientmanagement=Yes sessionmanagement=Yes setClientCookies = Yes sessiontimeout=#CreateTimeSpan(0,2,0,0)# applicationtimeout=#CreateTimeSpan(0,2,0,0)# clientstorage=evehicle setdomaincookies=Yes !--- enables closing of browser to kill session --- CFIF NOT IsDefined(cookie.CFID) CFLOCK SCOPE=session TYPE=readonly TIMEOUT=5 CFCOOKIE NAME=CFID VALUE=#session.CFID# CFCOOKIE NAME=CFTOKEN VALUE=#session.CFTOKEN# /CFLOCK /CFIF !--- end kill session --- cfsetting enablecfoutputonly=yes !--- Session-Tracker Code --- cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes !--- If Session-Tracker does not exist, generate it --- cfparam name=APPLICATION.SessionTracker default=#StructNew()# /cflock cfsetting enablecfoutputonly=no chklogin.cfm (to chk for valid login.. if true then set to session...) == .. blah.. cflock name=#APPLICATION.applicationName# type=Exclusive timeout=5 throwontimeout=Yes CFIF #StructKeyExists(APPLICATION.SessionTracker, cgi.REMOTE_ADDR)# eq YES cfset userexist= YES CFELSE !--- Log current user --- cfset userexist= No CFSET dummy = StructInsert(APPLICATION.SessionTracker, CGI.REMOTE_ADDR, Now(), true) /CFIF /cflock CFIF #userexist# eq YES SCRIPT LANGUAGE=JAVASCRIPT alert(Multiple Users Login at 1 machine is not allowed. Current Window will be closed.) self.close() /SCRIPT cfoutput query=checkusera href=main/dsp_logout.cfm?strUserName=#CHECKUSER.STRUSERNAME#Force Logout?/a/cfoutput CFELSE CFSET session.login = queryNew(strUserName, IntAccessGroupID, IntCompanyID, strSFID, dtmLastLogin, clientIP) CFSET tempValue = queryAddRow(session.login, 1) CFSET tempValue = querySetCell(session.login, strUserName, #trim(CHECKUSER.strUserName)#) CFSET tempValue = querySetCell(session.login, IntAccessGroupID, #trim(CHECKUSER.IntAccessGroupID)#) CFSET tempValue = querySetCell(session.login, IntCompanyID, #trim(CHECKUSER.IntCompanyID)#) CFSET tempValue = querySetCell(session.login, strSFID, #trim(CHECKUSER.strSFID)#) CFSET tempValue = querySetCell(session.login, dtmLastLogin, #trim(CHECKUSER.dtmLastLogin)#) CFSET tempValue = querySetCell(session.login, clientIP, #cgi.REMOTE_ADDR#) !-- If the user is logged in we transfer him/her to the homepage -- CFQUERY name=UpdateLogin datasource=#request.DSN# UPDATE tblUser SET dtmLastLogin = CURRENT_TIMESTAMP, blnloginStatus = 1 Where strUserName = '#session.login.strUserName#' /CFQUERY SCRIPT LANGUAGE=JavaScript self.location ='./Main'; /SCRIPT /CFIF main/index.cfm (my main page which using fusebox3.. ) cfif not IsDefined(session.login.strUserName) or session.login.strUserName eq CFLOCATION URL=../index.cfm?msg=4 ADDTOKEN=No !--- back to login page.--- /cfif .. .. .. . everytime i reach here.. i was re-routed to login page again. :( thank for yr help in advance.. Lost, han :( __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SELECT TOP n vs MaxRows...
the pk column is a primary key, so yeah. ;) well at least its something to keep in mind. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 10:41 AM To: CF-Talk Subject: Re: SELECT TOP n vs MaxRows... are you sure about it ignoring ORDER BYs? I just ran a test with SQL Server 7.0 and it returned the correct results and I included an order by. here are the results 100% sure, BoL my own misadventures. clustered/index on that column? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Server permission question
does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distributing self-contained CFMX apps
I would personally love this. right now I have to port all of the CF applications functionality to VBSCRIPT to achieve the same result. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 5:01 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps No, we've had this discussion on this list before... it's a great idea. - Matt Small -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 4:51 PM To: CF-Talk Subject: RE: Distributing self-contained CFMX apps On that note, I would think it'd be in MM's best interests to develop a method to do this - maybe the Developer Edition? with proper licensing? A version which is in single IP mode immediatly upon install?? I can't help but think how if a tool like this existed, it would get used in a large(er) number of places, thereby promoting sales of the Professional and Enterprise versions. After all, business folks would be caught by the wow factor, or I want to do that too phenomena, boosting interest (and indirectly, sales) in CF. My thoughts, but I closed my one man business cuz I realized I didn't have what it takes when it comes to marketing and accounting. So, maybe I'm blowing chunks with this idea Shawn Grover -Original Message- From: BILL BROWN [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:22 PM To: CF-Talk Subject: Re: Distributing self-contained CFMX apps I've thought about creating and distributing standalone apps like you describe using CF Express. If Macromedia were to do something like that (or even a nominal fee per license for mass installations), then I would totally agree with you. However, CF Express is feature-poor and Macromedia has not made any declarations about reduced licensing fees for purposes you've described. It's safe to say that you've got a great idea, but it's impractical at present (and probably future). Bill [EMAIL PROTECTED] 5/1/02 11:15 AM On Wednesday, May 1, 2002, at 10:25 AM, BILL BROWN wrote: The only downside being that the CFMX license will make the cost of the software prohibitive. Imagine tacking on thousands of dollars to the price of your development. It's possible, though not likely. Bill Maybe so, maybe no... could be a variant of the developer license: multiple, single-use installs. This could setup to abet rather than replace server-side installs of CF. MM (and others) will need to address this same issue with their server offerings.(JRun in MM's case). As I understand, with these you can develop Java Apps... presumably these could be Java server apps, Java rich-client Apps, or Java standalone apps where Swing (or somesuch) replaces the browser interface. The key to making all this profitable for MM, and MM's customers is to provide added value server-side with the consolidated interaction of function and information. a simple example: XYZ gifts mass mails a CD ala AOL (yech). This CD contains XYZ's catalog and an ordering app (simple shopping cart). The user can browse the catalog and build multiple orders off line. Once ready to order, the customer presses the Execute Order... connection is made to the server, The rich client sends it's order, an XML packet, to the server... the server returns any specials, substitutions, etc and processes the order. This type of application is practical for distributors placing orders, reporters filing stories, etc... or any of the applications where continuous connection to a server is not practical, necessary or desirable... for whatever reasons. Dick __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX
i tried installing this thing for 2 hours under XP Por and IIS. couldn't get it to work for nothing. Finally did the install and told it to use it's own stand alone server and it works fine. Can someone tell me why. I would love to know. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 10:39 AM To: CF-Talk Subject: RE: CFMX Hmmm... Ray Camden's exact words (from CFDJ List): Yep, the cat is out of the bag today, myself, and any other beta tester, can now answer any question at all. - Matt Small -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 10:19 AM To: CF-Talk Subject: RE: CFMX The cat isn't fully out of the bad as the preview release isn't feature complete. -Matt -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 7:22 AM To: CF-Talk Subject: RE: CFMX OK, now that the cat's out of the bag... is there, by chance, any support for printing, either local or across the internet? - Matt Small -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 10:12 AM To: CF-Talk Subject: RE: CFMX Question: Under web servers in the system requirements section, WebSite Pro is glaringly absent. How come? Will it run under WS? I don't know the definitive answer to this, but I think that the final version will support WebSite. I'm basing this on the fact that JRun 3.1 currently supports WebSite. Keep in mind that the CF MX preview may not be fully feature-complete; it's a preview. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX Breaking Hidden Field
why don't you use the urlencodedformat() before serializing the data. this will take care of any quotes, double quote, pound signs, or any other character that might cause a problem. then use the urldecode() to convert it back. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 10:27 AM To: CF-Talk Subject: Re: WDDX Breaking Hidden Field oi Brad!! um input type=hidden value='#wddx#' - single quote it? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Friday, April 26, 2002, 10:18:41 AM, you wrote: BR I know this has been asked before, but I can't find it anywhere. BR I have a textarea that allows users to type a bunch of text. When BR submitted, the form variables serialized to wddx and put in a hidden field BR for the next form. BR The problem is that if the user enters characters like double quotes, the BR browser thinks the hidden form field ends at the double quotes and displays BR the rest of the packet. BR What function do I need to use to make it safe while passing it in a BR hidden field and then make it normal when I input the info into the BR database? BR I've tried xmlFormat(), but it didn't work (I may not be using it BR correctly). BR -Brad BR __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: WDDX Breaking Hidden Field
why don't you use the urlencodedformat() before serializing the data. this will take care of any quotes, double quote, pound signs, or any other character that might cause a problem. then use the urldecode() to convert it back. second time Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 1:18 PM To: CF-Talk Subject: RE: WDDX Breaking Hidden Field XMLFormat() turns single quotes into apos;. Help? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 11:43 AM To: [EMAIL PROTECTED] Subject: RE: WDDX Breaking Hidden Field XMLFormat() = = = Original message = = = Thanks. Yeah, I've heard of it (and used it), I was just using it in the wrong place. I was trying to use it when serializing the data to wddx, not on the hidden field value, where it should've been. Another Related Question: I'm now getting errors Not well formed because of special characters like a registered mark ~. Is there a function to deal with these rather than using regex? If not, does anyone have a regex to replace all characters like this? I'm sure this isn't the only character that will cause problems. -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 10:42 AM To: CF-Talk Subject: RE: WDDX Breaking Hidden Field htmlEditFormat() the packet. input type=hidden name=hiddenfield value=#htmlEditFormat(myWDDXPacket)# Does absolutely no one know about this function? -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 8:19 AM To: CF-Talk Subject: WDDX Breaking Hidden Field I know this has been asked before, but I can't find it anywhere. I have a textarea that allows users to type a bunch of text. When submitted, the form variables serialized to wddx and put in a hidden field for the next form. The problem is that if the user enters characters like double quotes, the browser thinks the hidden form field ends at the double quotes and displays the rest of the packet. What function do I need to use to make it safe while passing it in a hidden field and then make it normal when I input the info into the database? I've tried xmlFormat(), but it didn't work (I may not be using it correctly). -Brad __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is there a CF open source shopping cart program
i bet that one of the shopping carts that alot of us looked at when we first got into CF is the How to write a shopping cart in CF at www.webmonkey.com It has the source and is a great way to start. once you get the foundation, you can write one yourself easily. you can also look at the developer exchange. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Pardeep [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 3:53 AM To: CF-Talk Subject: Is there a CF open source shopping cart program Does anyone know of an open source shopping cart program? I believe there is one that exists in Fusebox 3.0 format. Thanks. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia XML feed contest
just wondering but isn't wddx a form of XML? couldn't you use an XML parser to parse WDDX packets? if this is true, then why don't they just have a wddx packet. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 7:17 PM To: CF-Talk Subject: Re: Macromedia XML feed contest At 12:48 PM 4/24/2, Paul Giesenhagen wrote: I get the feeling that the developers of Cold Fusion, are liking raw XML better, thus the very real possibility of discarding WDDX in the future and well there ya have it ...I guess WDDX isn't cool enough :) WDDX is just an application of XML, optimized for data serialization. The application we're looking at here is describing news resources... if anything, RSS might be a closer match, but RSS didn't quite meet our needs for these feeds. At 1:43 PM 4/24/2, [EMAIL PROTECTED] wrote: It seems like it would be perfect for this. Would they consider creating a 2nd feed as WDDX? What advantage do you see in using a data-description format as a news-description format? (I'm not being contrary here, I'm just honestly curious how you see this as a good fit, thanks.) I'm *guessing* that the driver behind this conversation is that you have an easy ability to parse that particular WDDX flavor of XML document right now, and don't see an easy mechanism for yourself to handle other types of XML-formatted documents... is my guess here on-target...? At 2:03 PM 4/24/2, Mike Chambers wrote: WDDX wasn't really meant for this sort of data. What would be the advantage of putting it into WDDX? ah, Mike already said what I was gonna say, never mind ;-) At 2:08 PM 4/24/2, Kevin Schmidt wrote: By using WDDX it makes it much easier for those of us not using Flash MX to convert the information without having to use a third party tool, not all of us have access to install these third party tools. By simply using the CFWDDX tag we are able to convert the WDDX packet to a valid cf variable quickly and easily. Got it. Seems got a hammer, looks like nail situation? I know it's of no help today, but Neo makes general XML use as easy as what you see in special-case WDDX today. Until then you'd need to parse XML on the server through external means, true. jd John Dowdell, Macromedia Developer Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another mistery
this has happened to me before. i have no idea what causes it, but i think this might fix your problem since it did in my case. right click on your website from IIS manager and goto properties. click the home directory tab. at the bottom there is a drop down box called application protection. change it from medium to low. start and stop IIS. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:53 PM To: CF-Talk Subject: Another mistery I have a form for posting new products to a non-commerce based catalog site - it's used on six sites, and has been working perfectly for two years. One of the admins went to use it today, and got an HTTP 500 page can not be displayed error. First time it's ever happened. Didn't happen to her yesterday, or two days ago, or ever... I can't replicate the problem using the exact same test inputs. She's using IE 5.5, the site is on Win2K, CF 5, and it's an Access 2000 database The error she gets is listed here: http://www.stpweb.com/firstavenue/sites/firejewelry/ssl/shop/control/Product Entry.cfm?PID=jlr042002060309 The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Open the www.stpweb.com home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Macromedia XML feed contest
question: where to get it ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 9:20 AM To: CF-Talk Subject: RE: Macromedia XML feed contest If you guys are running CF5, Jeff Houser created a UDF that parses the XML feed. I have used it and its pretty cool. Clint -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 8:02 AM To: CF-Talk Subject: RE: Macromedia XML feed contest Does anyone know how o parse XML when you don't have access to the server? In a shared hosting enviornment wddx is the easiest option. = = = Original message = = = just wondering but isn't wddx a form of XML? couldn't you use an XML parser to parse WDDX packets? if this is true, then why don't they just have a wddx packet. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 7:17 PM To: CF-Talk Subject: Re: Macromedia XML feed contest At 12:48 PM 4/24/2, Paul Giesenhagen wrote: I get the feeling that the developers of Cold Fusion, are liking raw XML better, thus the very real possibility of discarding WDDX in the future and well there ya have it ...I guess WDDX isn't cool enough :) WDDX is just an application of XML, optimized for data serialization. The application we're looking at here is describing news resources... if anything, RSS might be a closer match, but RSS didn't quite meet our needs for these feeds. At 1:43 PM 4/24/2, [EMAIL PROTECTED] wrote: It seems like it would be perfect for this. Would they consider creating a 2nd feed as WDDX? What advantage do you see in using a data-description format as a news-description format? (I'm not being contrary here, I'm just honestly curious how you see this as a good fit, thanks.) I'm *guessing* that the driver behind this conversation is that you have an easy ability to parse that particular WDDX flavor of XML document right now, and don't see an easy mechanism for yourself to handle other types of XML-formatted documents... is my guess here on-target...? At 2:03 PM 4/24/2, Mike Chambers wrote: WDDX wasn't really meant for this sort of data. What would be the advantage of putting it into WDDX? ah, Mike already said what I was gonna say, never mind ;-) At 2:08 PM 4/24/2, Kevin Schmidt wrote: By using WDDX it makes it much easier for those of us not using Flash MX to convert the information without having to use a third party tool, not all of us have access to install these third party tools. By simply using the CFWDDX tag we are able to convert the WDDX packet to a valid cf variable quickly and easily. Got it. Seems got a hammer, looks like nail situation? I know it's of no help today, but Neo makes general XML use as easy as what you see in special-case WDDX today. Until then you'd need to parse XML on the server through external means, true. jd John Dowdell, Macromedia Developer Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hosting
I will second that! you guys are the best ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 3:27 PM To: CF-Talk Subject: Re: Hosting www.HostMySite.com If you register for a yearly account we give you the domain name for free. We also can do .biz and .info domains. Check out our Testimonials or ask here on the list if you need references. You can email me [EMAIL PROTECTED] if you have any questions Neil - Original Message - From: Ray Bujarski [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 3:03 PM Subject: Hosting Does anyone know of a good CFML hosting company that has CFFile enabled that I can register a domain through? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Keeping track of logged-in users...
client.lastvisit does the same thing and is handled by CF. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 5:12 AM To: CF-Talk Subject: Keeping track of logged-in users... Hi all- Got a best practices question for you. I've got a client site which uses client variables to track users' sessions for auto-logout. When a user logs on, a CLIENT.lastAccess variable is set to now(). In the application.cfm, a check is run to see if CLIENT.lastAccess is defined and if it's more recent than 20 minutes. If it is, then CLIENT.lastAccess is set to now() again, and processing continues. As long as the client hits a page before the 20 minute time limit runs out, works great. To log the user out, I delete certain client variables, especially lastAccess. Now my dimlemma. The client decided that he wants to track how many users are logged on (how many have accessed a page in the last 20 minutes and haven't yet been logged off. The only way I can see to do this is to ALSO write now() into a lastAccess field in the member database on each hit right after writing the client variable, so that the home page, which is supposed to display the number of users logged in, can run a query on members with a lastAccess field with a time less than 20 minutes ago. This just seems like a lot of DB access (one write when setting the CLIENT variable, and another when updating the member table), but I'm wondering if anyone has experience doing something like this, and whether that one extra update on each page hit will hurt that much. Assume a few thousand members hitting the site daily, spread out, most likely, but probably surfing around a fair bit (lots of articles, and a message board). Doing the CLIENT variable update seems to impact the site not at all, but I've not tested under really heavy load. Does anyone have a more elegant way of doing this, like parsing the Client DB for the CLIENT.lastAccess variable and getting a count of the ones with a value less than 20 minutes ago. Any suggestions would be most appreciated. Thanks... Kevin Langevin Flying Chimp Media 954-585-0999 [EMAIL PROTECTED] http://www.FlyingChimp.com -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 4:51 AM To: CF-Talk Subject: RE: CF's Most Wanted :: Hi Peoples Well, I can say, since its public knowledge in some circles that locking will no longer be required with Neo - the server will handle this side of things. CFMX has addressed the fact that failure to lock shared scope vairables will not cause memory corruption while a write operation is in progress. **However**, you will still have to lock for the legitimate use - to prevent synchronous activity ensuring that requests are requests are processed one at a time. For example, if I am about to reread a cached query I might decide that all requests that need this query should wait so as to ensure that they have the newer data. Hope this helps! Neil Team Macromedia http://www.macromedia.com/go/team __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A way to hide the CF source on a website?
I'll be honest, there is not way! yes you can encrypt it with cfencrypt and I can download a program that will unencrypt it. there is no way for someone to right-click in their browser to view your CF code.(NOTE: this is possible with the .htr and a bunch of other security flaws. are you up to date on all your security patches?) the only thing you can do is way until CFMX hits. if you happened to watch the presentation that they did for it at CFSOUTH, (can't remember which one, anyone know? they had this posted on MM site for awhile) supposedly you can now compile your CFM templates to JAVA CLASS files and delete the CFM templates from the server. Thus protecting your code. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:23 AM To: CF-Talk Subject: RE: A way to hide the CF source on a website? Depends on what you mean by hide and who you are wanting to hide it from. Ken -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:33 AM To: CF-Talk Subject: A way to hide the CF source on a website? Is there a way to do this? Thanks, Charles __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A way to hide the CF source on a website?
http://shrewm.net/cfd/ Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 11:28 AM To: CF-Talk Subject: Re: A way to hide the CF source on a website? Try the encryption utility. Or if you have the time, write a utility like py2exe (python's executable generator). On Tue, 23 Apr 2002, Charles Nahm wrote: Is there a way to do this? Thanks, Charles __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Archives
http://www.mail-archive.com/cf-talk@houseoffusion.com/ or Kevin L. gave me this idea. just save all the messages in outlook and use outlook find to search them. of course you have to be using outlook. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 23, 2002 1:34 PM To: CF-Talk Subject: Archives Is there a way I can search the cf-talk archives, etc? Preferably with a News Reader. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer - MCSE, OCP DBA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
where can we make announcements?
want to know where we can make announcements about CF projects (ie. tags, useful tools) we are developing? is it appropriate to announce them here? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DSNless connections
you don't have to pay $$$ for the hosting company to setup a DSN for you. ;) Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:29 PM To: CF-Talk Subject: RE: DSNless connections Here's just one advantage... I'd like to hear more too.. If you don't have the access to create or edit DSNs, then a DSNless connections are very useful. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:23 PM To: CF-Talk Subject: DSNless connections What are the advantages/disadvantages to using DSNless connections? T __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: manipulating a text file...
you can use cffile, the thing is how big is the file? if it is too big (like 100 meg) it might take awhile and might even crash the system if you don't have enough ram. might actually want to do this in VB if you know it. VB has some very simple fuctions for working with files. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:22 AM To: CF-Talk Subject: RE: manipulating a text file... Yeah, if I had more time, I could look into that, but of course this is due by end of day. Is there basically no way that this can be done with cffile? - gary -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 9:59 AM To: CF-Talk Subject: RE: manipulating a text file... ouch... well, if the file is structured you might try the text based ODBC driver. Personally, I think it would be easier to host the data in a database and export it OUT into a file when it's needed in a file format. Mark -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 8:53 AM To: CF-Talk Subject: manipulating a text file... I've just been tasked with updating a text file. There are 134,000 records or so in it, and at character postion 172, I need to insert a model number, which is the same for all of the records. Can anyone give me an idea of how to go about doing this and then resave the file with the new data? TIA, - Gary __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Logging Questions
seems like this problem has been around a while. since cf 2.0. http://groups.google.com/groups?q=%22Windows+NT+error+number+232+occurred%22 hl=enselm=60s8ds%24i7d%241%40wolfe.wimsey.comrnum=2 haven't seen anything on what causes it though. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:45 AM To: CF-Talk Subject: RE: CF Server Logging Questions Billy, I'm not using Access. I'm running SQL Server 7 w/ ODBC? Any body else have any idea what would be causing the log entries included in the below message? Has Macromedia addressed this issue? -mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 5:37 PM To: CF-Talk Subject: RE: CF Server Logging Questions Typically the result of using Access. See: http://www.macromedia.com/v1/handlers/index.cfm?ID=1540Method=Full --- Billy Cravens -Original Message- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:30 PM To: CF-Talk Subject: CF Server Logging Questions Hi, I've got a CF5 Server running on NT4 and it seems as though the CF service is causing the server to crash. Something is causing 100% processor tie-up, which hogs memory and eventually crashes the server. I've looked for endless loops and the such in my apps and haven't been able to find any. These are some entries that I'm concerned about from my SERVER.LOG and WEBSERVER.LOG log files. I don't really know what these errors mean or what's causing them, but I'm hoping that they're related to my problem. If anybody could shed some light on these log entries it would be appreciated, thanks. -mark kecko Server.LOG Error,461,04/18/02,14:19:31,,Windows NT error number 232 occurred. Error,702,04/18/02,14:19:32,,Error number 232 occurred while attempting to write the reply to the web server. Error,702,04/18/02,14:19:32,,Windows NT error number 232 occurred. Error,702,04/18/02,14:19:32,,Error number 232 occurred attempting to close connection to web server. Error,702,04/18/02,14:19:32,,Windows NT error number 232 occurred. Error,273,04/18/02,14:19:35,,Error number 232 occurred attempting to close connection to web server. Error,273,04/18/02,14:19:35,,Windows NT error number 232 occurred. Error,461,04/18/02,14:19:41,,Error number 232 occurred while attempting to write the reply to the web server. Error,461,04/18/02,14:19:41,,Windows NT error number 232 occurred. Error,461,04/18/02,14:19:41,,Error number 232 occurred attempting to close connection to web server. Error,461,04/18/02,14:19:41,,Windows NT error number 232 occurred. Error,273,04/18/02,14:20:03,,Error number 232 occurred attempting to close connection to web server. Error,273,04/18/02,14:20:03,,Windows NT error number 232 occurred. WebSERVER.LOG** Error,626,04/18/02,14:16:34,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) Error,563,04/18/02,14:16:35,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) Error,593,04/18/02,14:16:44,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) Error,607,04/18/02,14:17:17,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) Error,548,04/18/02,14:17:17,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) Error,659,04/18/02,14:17:17,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) Error,396,04/18/02,14:17:17,,Error attempting to write location redirection to web server (Windows NT error number 16389 occurred) __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
neo question
weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
sorry about that. i tried to logon into the forums and i forgot my password. i'm waiting to get a reply and i thought that i could ask the list. it won't happen again. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:05 AM To: CF-Talk Subject: RE: neo question Um - you _do_ know that this isn't the proper place to talk about Neo? Haven't we been over this already? -sigh- Please post your question to the Neo beta forums. Anyone on this list who _could_ help you is bound by NDA, and, if you have discovered a bug, the only way we can help you is if we _know_ about it. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RecordCount is 0 en Stored Procedure
from what i have been told, this is suppose to be faster and more efficient. i just like the fact that i don't have to declare variables. ;) IF NOT EXISTS( SELECT UserName FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux ) begin your TSQL code end Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:42 PM To: CF-Talk Subject: RE: RecordCount is 0 en Stored Procedure If it's SQL Server, you can do it like this: SELECT UserName FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux if @@RowCount = 0 begin ... do your action ... end Just keep in mind you have to check @@RowCount (and @@Error) immediately after the operation in question - the next command resets these values. Shawn Grover -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:31 AM To: CF-Talk Subject: RecordCount is 0 en Stored Procedure Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF @Count=0 BEGIN /*Here I write my action*/ END _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Purge cfVar db using SQL script
make sure you use truncate table cfdata truncate table cfglobal it's faster then DELETE FROM cfdata DELETE FROM cfglobal also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more about it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:49 PM To: CF-Talk Subject: RE: Purge cfVar db using SQL script Miles, I may be mistaken, but I think there is a custom tag or script on the gallery that can take care of this task for you. Mark -Original Message- From: Miles Fawcett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:31 AM To: CF-Talk Subject: Purge cfVar db using SQL script We are using CF5 in a clustered environment and would like to purge the cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am interested in anyone has a script they know works are has any insight into this approach. We would like to purge all records older than 30 days. Thanks, Miles Miles Fawcett, President Interactive Applications Group (iapps) tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271 Washington * New York * San Francisco * Boston __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
