Stephanie A Rabbitt/Contractors/Cummins is out of the office.
I will be out of the office from 07/08/2000 until 07/17/2000. I am out of the office for the next week. If you have any issues that need attention please look at the following list and direct your problem to the proper person. For issues with the Web site CCN please contact Melissa Timberlake For issues with the CCN Server please contact Doug Swetnam For issues with NetObjects please contact Rich Whitney or Melissa Timberlake. Thank you and I will reply to all other messages upon my return on the 17th of July. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Advanced Security
Anyone ever install CF Server, go into the administrator, click on the advanced security link and get this: Error Diagnostic Information Security Policy Administration Security Policy Administration is not available. I check the advanced security option on installation like usual. I have never gotten this error before -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (Admin) Re: List wierdness ... again
Thanks for the feedback. :) Hello Michael, I like to take the opportunity and thank you for your great work keeping this list up and running for the CF-Community. For my part I am really glad that this list exists and haven't really encountered a bit inconvenience. I hardly noticed that there are troubles now and then;-)) This comes with the enormous traffic this list has, and it is running, and running and running. Thanks to you! Birgit Sunday, July 09, 2000, 12:04:46 PM, you wrote: We had a really bad series of bouncebacks that caused some routing issues with the list. Rather than let the problem persist, I removed all the email from the spool and let it run 'fresh'. Last night I returned all the removed email so it wouldn't lose anything. The result was a few duplicate messages for some people and a delay for the messages in question. It's all fixed and working well now. Sorry for the inconvenience. I just love my e-mail program's feature: 'Kill duplicates' Wednesday, June 14, 2000, 2:43:20 PM, you wrote: I am starting to randomly recieve multiple copies of postings ... sometimes days apart. I have looked at the headers in all cases and the messages are exactly the same ... content, sender, date/time sent, everything. What the heck is going on? Is Mike running a 'proper' listserver or some homegrown CF app? Steve - - Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (Admin) Re: List wierdness ... again
Whoops. Thought that was going private. Thanks for the feedback. :) Hello Michael, I like to take the opportunity and thank you for your great work keeping this list up and running for the CF-Community. For my part I am really glad that this list exists and haven't really encountered a bit inconvenience. I hardly noticed that there are troubles now and then;-)) This comes with the enormous traffic this list has, and it is running, and running and running. Thanks to you! Birgit Sunday, July 09, 2000, 12:04:46 PM, you wrote: We had a really bad series of bouncebacks that caused some routing issues with the list. Rather than let the problem persist, I removed all the email from the spool and let it run 'fresh'. Last night I returned all the removed email so it wouldn't lose anything. The result was a few duplicate messages for some people and a delay for the messages in question. It's all fixed and working well now. Sorry for the inconvenience. I just love my e-mail program's feature: 'Kill duplicates' Wednesday, June 14, 2000, 2:43:20 PM, you wrote: I am starting to randomly recieve multiple copies of postings ... sometimes days apart. I have looked at the headers in all cases and the messages are exactly the same ... content, sender, date/time sent, everything. What the heck is going on? Is Mike running a 'proper' listserver or some homegrown CF app? Steve - - Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: sssssssssssssssssssssssssssssssssssssssssssssssssssssss
CFSET CutLength=30 CFSET MyString="sss" CFLOOP Condition="Len(MyString) GT CutLength" CFOUTPUT#Left(MYString,CutLength)#/CFOUTPUT CFSET MyString = Right(MyString,Len(MyString)-CutLength)) /CFLOOP Or something like that. This method won't be intelligent about words, but it will work. If you want it to look snazzy, then you'll want to mess about with checking when a word ends, and only put up to the end of the last full word. That's as long as it's a sentence and not just a lump of characters/numbers. I had some code to do this, but I'll have to dig it out - which may take some time (which I don't have much of these days) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: contained in a list
let's say.. mynumber = 2 ans mylist = 2,67,34,52 cfIf listFind(myList,'2') = 0 ... You were very, very close. :) cfIf listFind(myList,'2') IS 0 You were very, very close as well :D Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: contained in a list
Correct me if I'm wrong here people, but I believe that if the list contains actual numbers (like from a numeric data field) then this list function will work correctly, but if it's a text string it won't. It's been a while since I checked on this. ListContains looks to see if any entries in the list CONTAINS the item you're looking for Therefore; ListContains("1,2,4,5,13,18,23,30","3") will product a number, ListFind("1,2,4,5,13,18,23,30","3") won't. CF doesn't treat numbers different from string when you're running a non-numeric function on them. Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: sssssssssssssssssssssssssssssssssssssssssssssssssssssss
I assumed it was a single long string that needed broken. If you want to break up a sentence, try CF_WRAP from the Tag Gallery. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 6:40 AM To: [EMAIL PROTECTED] Subject: RE: sss CFSET CutLength=30 CFSET MyString="sss" CFLOOP Condition="Len(MyString) GT CutLength" CFOUTPUT#Left(MYString,CutLength)#/CFOUTPUT CFSET MyString = Right(MyString,Len(MyString)-CutLength)) /CFLOOP Or something like that. This method won't be intelligent about words, but it will work. If you want it to look snazzy, then you'll want to mess about with checking when a word ends, and only put up to the end of the last full word. That's as long as it's a sentence and not just a lump of characters/numbers. I had some code to do this, but I'll have to dig it out - which may take some time (which I don't have much of these days) Philip Arnold ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Advanced Security
Check to make sure the advanced security services are running. Theres two of them, SiteMinder Authorization and SiteMinder Authentication. === Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 2:45 AM To: [EMAIL PROTECTED] Subject: Advanced Security Anyone ever install CF Server, go into the administrator, click on the advanced security link and get this: Error Diagnostic Information Security Policy Administration Security Policy Administration is not available. I check the advanced security option on installation like usual. I have never gotten this error before -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: First and last day of Month
Try this to display the last day of the month: #monthasstring(month(now()))# #daysinmonth(now())#, #year(now())# Michael Baroody [EMAIL PROTECTED] http://roody.dyndns.org -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need to take several row query and make into one row.
What's the linkage to SomeOtherQuery? When you are about to display "#myquery.seminarsfor#", how do you know what you want to display (is it by MyKey, or something else)? You might be able to do it like this: cfquery name="variables.myquery" Select * from mytable /cfquery cfset variables.mykeys = valuelist(variables.myquery) cfoutput The value of field #variables.myquery.myvar[key_value]# is #variables.myquery.myvalue[key_value]#. cfoutput but this requires knowing what key_value you want where. -Original Message- From: Rick Moon [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 8:17 PM To: [EMAIL PROTECTED] Subject: Need to take several row query and make into one row. Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need to take several row query and make into one row.
Oops, I meant: cfoutput The value of field #variables.myquery.myvar[listfind(variables.mykeys, key_value)]# is #variables.myquery.myvalue[listfind(variables.mykeys, key_value)]#. cfoutput This would probably be faster with the list portion implemented as a structure, but I didn't take the time to think it out. Also, the query and list/structure could be kept as app or session vars if desired. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 8:41 AM To: [EMAIL PROTECTED] Subject: RE: Need to take several row query and make into one row. What's the linkage to SomeOtherQuery? When you are about to display "#myquery.seminarsfor#", how do you know what you want to display (is it by MyKey, or something else)? You might be able to do it like this: cfquery name="variables.myquery" Select * from mytable /cfquery cfset variables.mykeys = valuelist(variables.myquery) cfoutput The value of field #variables.myquery.myvar[key_value]# is #variables.myquery.myvalue[key_value]#. cfoutput but this requires knowing what key_value you want where. -Original Message- From: Rick Moon [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 8:17 PM To: [EMAIL PROTECTED] Subject: Need to take several row query and make into one row. Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Search on Allaire Site
On 7/9/00, Greg Creedon penned: Do they really have their website in the corporate offices? I didn't think too many people did that. Maybe I'm just spoiled, but all of the companies I've worked at since 96 have had their sites off site. Even so, how would a move affect the search capabilities?! -Original Message- From: David Sparkman [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 11:14 PM To: [EMAIL PROTECTED] Subject: RE: Search on Allaire Site It has been down all week. I think is a hold over from the Allaire Corporate Move. Heh. To be blunt, I've ever seen a site down as frequently as Allaire's. I'd like to think it has little to do with ColdFusion, but whatever the reason, it sure wouldn't bode well with me if I was looking to make a decision on what web application to use and went to their site and it was down. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFCONTENT
Hey, I had the same problem. I realized a simple work-around thou. Im using IIS, so i have the ability to specify a template as an error page( Say for 404 - Filenot found) on a per DIR basis. So what i did was create a template with code simlar to what you have. Then in a page i would link to the file i wanted (output.xsl) as if it were in the current directory. ie: http://blah.com/index.html it has a link to output.xls (thus looking like http://blah.com/output.xls ) But, output.xsl doesnt exist there ... it exists some place else (ie non accessable via the web). So i causes a 404 Error, and i told IIS to use a speical template, so as to when the 404 happends, it will fetch the file and CFCONTENT to the client as the content of the error page. But the client has no idea they caused a 404 ... And the file name (when they goto save) will be output.xls. the only downside might be an abundence of 404s in your server logs... David Scheiderich When using cfcontent as in: cfcontent type="application/msexcel" file="d:\templates\OUTPUT.XLS" deletefile="YES" the file comes back with a .cfm extension but in XLS format. What do I need to do to correct this? Jim Watkins -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: MySql ODBC Driver
Q1. Has anyone had experience with "manually" installing the CF server since it doesn't detect the Apache server in this configuration (i.e. not a service per se on a win 95 machine). I have it mostly working by coping the cfdocs and cfide stuff to my ../htdocs/ directory. What won't work is any file system "Browse" function (like in the ODBC/DSN config page where you might press the "browse" button to find the database for the DSN). If I hit the browse button it tries indefinitely, but dose not return (I can however press "cancel" and regain control). I can't help but think it is related to my "manual" installation procedure being deficient somehow. There isn't that much involved in setting up CF with Apache on Windows. All you have to do is add the line for the Apache module in httpd.conf (which it sounds like you've done) and put the CFIDE directory in the document root of your web server. I suspect your problem is a Java applet problem, unrelated to your install procedure. The browse functionality in CF Administrator is provided by the CFTREE Java applet. You might try it with another browser. Q2. Has anyone had experience with installing ODBC drivers? I installed the MyODBC drivers and tested fine. You can see it from the win95 control panel and such. However in the CF administrator page it is not displayed as an option in the drop down selection box. I looked in the registry to see if it got set up in there and that looks fine (and tests fine within the driver test program). Again I think it could be related to my manual install attempt. Is there any documentation out there on this? Again, I think your install is fine. I haven't worked with MyODBC on Windows, but I suspect that CF just can't work directly with creating and managing datasources using that driver. This isn't the end of the world - you should be able to create MyODBC datasources in the Control Panel, and still be able to use them. Try this, and let me know if it doesn't work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF triggering method in remote DCOM
Hi. I'm trying to trigger a method in a remote DCOM object over my network. has anyone done this from a CF script? ie from CF, send the DCOM object a command to print a message on the target systems screen, for example? Thnaks, Ben -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: When should I use CFLOCK?
After reading the Allaire KB article on locking, I put CFLOCK's around all instances of any session or server variables. The one place that seems a bit muddy is if the read is within a CFIF statement. I put the lock around the entire CFIF but is that required? I implied that it was from the KB article but I have never seen that specifc guidance anywhere. If you're doing something like this: cfif IsDefined("Session.Foo") then it should be locked. On the other hand, if you're just referencing a session variable within a CFIF: cfif Variables.Foo IS "bar" cfset Session.Foo = "baz" /cfif then you could put the CFLOCK within the CFIF. Lock 'em, Dano! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFMODULE
I can't find anything in the documentation, but I still haven't had my first cup of coffee yet. Does CFMODULE have a closing tag so it works the same as CF_ tags that require a closing tag? Thanks. Russel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Allaire Certification Program
From: "Mike Sheldon" [EMAIL PROTECTED] I would look for someone who *refused* to take it. you would likely end up like an acquaintence, who hired someone who claimed to 'know' coldfusion. So far, this person has had to be taught sql, html, coldfusion, program design, database design, debugging, ... and problems continue. Apparently the new employee's idea of 'knowing' coldfusion was that he read the word on the internet once... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Unless explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: JavaScript and CF
Steve DeWitt wrote: Javascript can run "server-side" but not on a CF server. Ever heard of server side javascript that runs on a web server? Of course I have. However, for purposes of keeping the explanation simple, I chose elucidate the difference between server-side Cold Fusion, and client-side JavaScript. I've seen very few implementations of server-side JavaScript to be honest with you. So I chose not to obfuscate my answer with server-side JavaScript. Perhaps it would have made things more clear had I jumped off on a rant about server-side JavaScript, what languages support it, and then go into a discussion about ASP, where you can run JScript (not JavaScript), VBScript, Perl, and if a programmer were creative enough to build an interface to CFScript, CFScript. -- Billy Cravens [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Browser Header Strings
http://www.uoguelph.ca/~gnasby/projects/web_browser_info/browser_mappings_list_big.html Does anyone know where there's a good complete list of browser header strings? I need to restrict access, as reliably as possible, to Win95/98/2000/NT4+ browsers. -- Billy Cravens [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFMODULE
No. In that case, you'll have to use a "normal" custom tag. -- Billy Cravens [EMAIL PROTECTED] Russel Madere wrote: I can't find anything in the documentation, but I still haven't had my first cup of coffee yet. Does CFMODULE have a closing tag so it works the same as CF_ tags that require a closing tag? Thanks. Russel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: When should I use CFLOCK?
Ok, what if you are using application variables as a part of the IF statement and session in the IF? e.g: CFIF Application.Foo CFSET Session.bar = 1 /CFIF Is it ok to nest different types of Locks (session and application). And what if Application.foo was actually session.foo? Would I need nested session lock-ing or will the outer Lock around the if statement lock all session variables with in? Ben -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 10 July 2000 14:36 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: When should I use CFLOCK? After reading the Allaire KB article on locking, I put CFLOCK's around all instances of any session or server variables. The one place that seems a bit muddy is if the read is within a CFIF statement. I put the lock around the entire CFIF but is that required? I implied that it was from the KB article but I have never seen that specifc guidance anywhere. If you're doing something like this: cfif IsDefined("Session.Foo") then it should be locked. On the other hand, if you're just referencing a session variable within a CFIF: cfif Variables.Foo IS "bar" cfset Session.Foo = "baz" /cfif then you could put the CFLOCK within the CFIF. Lock 'em, Dano! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: RDS password
The option to save the pw could have become unchecked. Right click on your RDS server, click Properties. Check the connection settings. -- Billy Cravens [EMAIL PROTECTED] "Parker, Kevin" wrote: I'm working locally and all of a sudden I keep getting asked for the RDS password. I've restarted the PC but it still keeps happening. Any clues please? Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFMODULE
Thanks. I need to get up earlier and make my coffee first thing :) Russel At 08:51 AM 7/10/2000 -0500, you wrote: No. In that case, you'll have to use a "normal" custom tag. -- Billy Cravens [EMAIL PROTECTED] Russel Madere wrote: I can't find anything in the documentation, but I still haven't had my first cup of coffee yet. Does CFMODULE have a closing tag so it works the same as CF_ tags that require a closing tag? Thanks. Russel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Know where I can find Chr(*) definitions?
TEXTAREA ROWS="20" CFOUTPUT CFLOOP INDEX="i" FROM="1" TO="255" #i# = #chr(i)# /CFLOOP /CFOUTPUT /TEXTAREA Bert -Original Message- From: GE [mailto:[EMAIL PROTECTED]] Sent: 07 July 2000 18:44 To: [EMAIL PROTECTED] Subject: Re: Know where I can find Chr(*) definitions? Hello Ric, What you are looking for is an ASCII table. A quick search should find one for you - or you could look it up in any refernce manual you have on programming (should be one in one of them). To be sure you have found what you are looking for just compare the table values of 10 and 13 to verify that you have a carraige return and a line feed. hth, Nelson Ric Smith wrote: Anyone know of anywhere I can find the definition for the Chr(*) stuff online? Only ones I know are Chr(10) and Chr(13). Just curious, thanks. Ric Smith -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Please Help me for my interview
I've found that most beginner developers (and non-beginners alike!) are very dependent upon CFStudio's wizards -- either the query builder, or just the buttons in Studio (ie they know what to click to get a cfinclude) However, during a job interview, you won't have studio in front of you -- you will need to know both CFML and SQL. Since CFStudio makes it easy to program (and program well if you can), you can do so without knowing the language. So I'd pick up the references and start reading (recommendations: CFML - language reference at the back of Forta's book, SQL - SQL for Dummies or Forta's Teach Yourself SQL in 10 Minutes. -- Billy Cravens [EMAIL PROTECTED] Shally Kon wrote: Hi! Every one out there I have 6 months experience on ColdFusion4.0. I have made a site like monsterboard.com for job placement. and am preparing for an interview which is my first interview on ColdFusion. I know there are great programmers here on this site . PLEASE TELL ME WHAT TYPE OF QUESTIONS ARE ASKED IN THE INTERVIEW IT WOULD BE GREAT HELP TO ME IF YOU CAN SEND ME SOME QUESTIONS AND IF POSSIBLE WITH ANSWERS. THANKS IN ADVANCE Shally -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMODULE
Does CFMODULE have a closing tag so it works the same as CF_ tags that require a closing tag? Sure: cfmodule name="foo" ... /cfmodule Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: strong authentication and CF
I haven't had any experience tying SecureID into CF but, I'm interested in your decision to implement SecureID over PKI. If you don't mind sharing, what were the major points driving this decision? I ask because I too am interested in SecureID as well as PKI. PKI seems more cost effective, easier to implement, and provides more security over the wire than SecureID. Of course, SecureID has its strong points too, like the two factor authentication. I am interested in hearing your experience. Thanks, Steve -Original Message- From: Bruce Altner [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 08, 2000 10:55 AM To: [EMAIL PROTECTED] Subject: strong authentication and CF Greetings: We're looking to build an application that will automate the process whereby people "sign off" at various stages of a work flow process. Security concerns dictate that we use some kind of digital signature/strong authentication methodology such as certificates (PKI), smartPass, etc. We're not ready for a PKI solution yet but are considering one which uses the SecurID token system (from Security Dynamics), which requires the user to input a number generated by the token, which changes with time. The user is authenticated by a SecurID server on one host (not a Web server) and we want to tie this to our CF app, running on another server. I think we'll need to get CF to talk to the other box through some API (TBD) via a CFX tag written in C++ or Java. Has anyone had success doing this kind of thing? Suggestions for tools, approaches would be welcome. Thanks, Bruce -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Know where I can find Chr(*) definitions?
That doesn't help much with Tab, ESC, or DLE (data link escape - CHR(16). It's a good reference for printable characters, though. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 10:04 AM To: '[EMAIL PROTECTED]' Subject: RE: Know where I can find Chr(*) definitions? TEXTAREA ROWS="20" CFOUTPUT CFLOOP INDEX="i" FROM="1" TO="255" #i# = #chr(i)# /CFLOOP /CFOUTPUT /TEXTAREA Bert -Original Message- From: GE [mailto:[EMAIL PROTECTED]] Sent: 07 July 2000 18:44 To: [EMAIL PROTECTED] Subject: Re: Know where I can find Chr(*) definitions? Hello Ric, What you are looking for is an ASCII table. A quick search should find one for you - or you could look it up in any refernce manual you have on programming (should be one in one of them). To be sure you have found what you are looking for just compare the table values of 10 and 13 to verify that you have a carraige return and a line feed. hth, Nelson Ric Smith wrote: Anyone know of anywhere I can find the definition for the Chr(*) stuff online? Only ones I know are Chr(10) and Chr(13). Just curious, thanks. Ric Smith -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using ReplaceNoCase with a quote in the string
Double your quotes : CFSET PAGE= REPLACENOCASE(CFHTTP.FILECONTENT, "A HREF=""http://www.blah.com", "go to A HREF=""http://www.blah.com", "all") It should work then -Original Message- From: cf kaizen [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 9:31 AM To: [EMAIL PROTECTED] Subject: Using ReplaceNoCase with a quote in the string Hi All, I am trying to replace some text that has a quote already in it. ReplaceNoCase trips up on the quote and throws an error. I've tried escaping the quote, or placing a "\" in front of it, but I must have the syntax wrong. Can this be done? My code is below. Thanks in advance for you help! CFSET PAGE= REPLACENOCASE(CFHTTP.FILECONTENT, "A HREF="http://www.blah.com", "go to A HREF="http://www.blah.com", "all") Regards, Andrew __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need to take several row query and make into one row.
Rick, You may want to take a look at a custom tag called CF_QueryToStruct. Basically it will take a query like yours and convert it to a struct that would look like this: MyQuery.MyVar.MyValue I've used this tag with great success in a situation something like yours. Find the tag at: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34740D-2830-11D4-AA 9700508B94F380method=Full (yep, the url probably wrapped - if you want, just search in the Developers Exchange for "QuerytoStruct") Kevin At 05:16 PM 7/9/00 -0700, you wrote: Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick -- Kevin Marshall Web Application Developer eCalton.com, Inc. Vero Beach, FL www.ecalton.com [EMAIL PROTECTED] 561.569.4500 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFMODULE
Um. It works exactly the same either way for me. i.e. CFMODULE TEMPLATE="foo.cfm" ... /CFMODULE works just like cf_foo ... /cf_foo -- Paul Wakefield Hanlon's Razor - Never attribute to malice that which can be adequately explained by stupidity. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 3:52 PM To: [EMAIL PROTECTED] Subject: Re: CFMODULE Thanks. I need to get up earlier and make my coffee first thing :) Russel At 08:51 AM 7/10/2000 -0500, you wrote: No. In that case, you'll have to use a "normal" custom tag. -- Billy Cravens [EMAIL PROTECTED] Russel Madere wrote: I can't find anything in the documentation, but I still haven't had my first cup of coffee yet. Does CFMODULE have a closing tag so it works the same as CF_ tags that require a closing tag? Thanks. Russel - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lis ts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: Need to take several row query and make into one row.
You might be able to use the DECODE function to do what you want. (If you're on Oracle) You'll have to refer to the documentation for a detailed explanation of that one... ;] J. -Original Message- From: Rick Moon [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 09, 2000 8:17 PM To: [EMAIL PROTECTED] Subject: Need to take several row query and make into one row. Hello, The "why" for the following is an email unto itself, so if possible any ideas on "how" would be greatly appreciate. The cfquery name="MyQuery" is selecting from the following db table: MyKey|MyVar| MyValue - 0001|ClientName |Rick 0002|SeminarsFor|aerospace 0003|RAMPrice|stable Now I need to write (without looping or cfifing or cfswitching) or (changing the the table itself) and (caching of some sort is desired): The name of your seminar is: #MyQuery.SeminarsFor# The state of CA is: #SomeOtherQuery.HighTaxes# The only way I've been able to do it so far is to rebuild the above table into: ClientName |SeminarsFor|RAMPrice Rick|aeospace| stable But this constant table manipulation isn't practical. Is the answer in sql? structures? arrays? or ? TIA, Rick __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: oracle timestamps
The oracle reserved word SYSDATE will achieve a current timestamp without all the hassle of formatting. INSERT INTO DATA_TABLE(NAME, DATE) VALUES ('#name#', SYSDATE) j. -Original Message- From: Stephen Garrett [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 1:57 PM To: [EMAIL PROTECTED] Subject: RE: oracle timestamps The default syntax of the Oracle TimeStamps is set by the DBA. I always use the TO_CHAR function on date stamps and format them the way I want for display. (used in the SQL statement) Steve At 08:32 AM 7/7/2000 -0400, [EMAIL PROTECTED] wrote: I would guess that the default Oracle date format on the two machines is set differently. Unfortunately a cursory search did not turn up info on how/where this is set. -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 6:56 PM To: Cf-Talk Subject: oracle timestamps does anyone know why oracle would not accept timestamps? when i try to insert Now() into a date/time field, oracle returns with the error "illegal character". FYI, Now() outputs a timestamp like: {ts '/mm/dd hh24/mi/ss'} stranger yet... all my queries work when i run the application locally on a workstation with an ODBC connection out to the database. however, the application refuses to work when i run the application locally on the database. the workstations are Win2000, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver the server is WinNT SP6a, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver ideas??? -mike --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT:Single Server vs. Cluster Comparison
OK. So what I've been trying to say is that couldn't CF be used to have application.cfm alternate datasources analogous to Round Robin in DNS? And the datasources could be on different SQL Server boxes? (Non Enterprise version). best, paul At 09:32 AM 7/10/00 -0400, you wrote: How would you cluster SQL Server servers? That is, what software/hardware would you use to do it? It depends on what exactly I was trying to do. However, what I'd probably end up with is using the clustering in SQL Server 7 Enterprise Edition, which allows you to create a cluster of two machines (which is enough for most purposes). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Developer Conference: Hotel Accommodations
I used Priceline for that e-commerce conf and got a room at the Marriot for about $50... Gene Kraybill James Brown wrote: Several people who went to the e-commerce meeting in Rockville a couple of months ago used priceline and got some pretty good deals on both flight and room ($80 a nite for the Rockville Marriot). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Getting the ID after insert...
I have a question about the code below. This was done by a colleague of mine, he is pretty handy with SQL coding. One of his observations was the time involved in writing stored procedures and then calling them with CFSTORPROC. I agree, that discouraged me somewhat in the past, but I knew of no other way. He put this transact-sql query together and it seems solid, works well. My question(s): Have any of you tried this? Any problems? Can anyone see a potential problem? Thanks. -Gary McNeel CFQUERY name="InsertLkpRec" datasource="#Application.DSN#" DECLARE @LookupID char(6) DECLARE @MembersID char(6) !--- Insert Member Lookup Record --- INSERT INTO tblMemberLkp (DBAName, ReferredBy ) VALUES ('#Form.DBAName#', '#Form.ReferredBy#') SELECT @LookupID = @@IDENTITY ! Members Record --- INSERT INTO Members (MemberLkpID) VALUES (@LookupID) SELECT @MembersID = @@IDENTITY !--- Insert Site Info record --- INSERT INTO tblSiteInfo (BusName, Website, RecStatusID, RecOriginID, MembersID, PartnerNumber, SourceID, ApplicationDate) VALUES ('#Form.BusName#', '#Lcase(Form.Website)#', 2, 1, @MembersID, '#Form.PartnerNumber#', '#Form.SourceID#', getdate()) /CFQUERY There isn't anything really wrong with that, from a general standpoint. ODBC 2 and later allow you to run SQL batches, and as long as your ODBC driver supports it (and the SQL Server one certainly does), you can write batches using T-SQL. However, I don't really think it takes any longer to write that as a stored procedure, which will give you better results generally. SQL Server can perform better optimization of stored procedures than it can with ODBC passthrough queries, usually. I've seen performance and reliability increases using stored procedures for INSERTs, believe it or not! Also, from a security standpoint, you'd generally want to lock down your ODBC datasources as much as possible; stored procedures give you an easy way to do this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: When should I use CFLOCK?
How should the timeout manifest itself if it is set to true? I set a cfloop inside a CFLOCK to force it to timeout, but I see no response... I expected a failure page -- I don't think cfcatch is required, is it? Matt -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire Certification Program
Hardly. I can spot fakers in a flat second, and I ALWAYS ask for samples of code (and make them explain why they did it that way). I just don't like working with sheep. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 06:44 To: [EMAIL PROTECTED] Subject: Re: Allaire Certification Program From: "Mike Sheldon" [EMAIL PROTECTED] I would look for someone who *refused* to take it. you would likely end up like an acquaintence, who hired someone who claimed to 'know' coldfusion. So far, this person has had to be taught sql, html, coldfusion, program design, database design, debugging, ... and problems continue. Apparently the new employee's idea of 'knowing' coldfusion was that he read the word on the internet once... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Unless explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: scheduler won't schedule
Stop and start the Cold Fusion Application Server (in the Windows' Control Panel; Services screen), after you save your scheduled task. Bruce Altner [EMAIL PROTECTED] on 07/08/2000 11:01:12 AM Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: scheduler won't schedule Hi: I'm having no luck getting my script to run periodically according to the schedule I set up in the CF administrator. The process just doesn't seem to kick off, and no entry appears in the scheduler.log file (which I had to create manually...it wasn't there by default). This if for CF 4.0.1 running on NT Workstation. Anyone else experience this? Thanks, Bruce -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Allaire Certification Program
I second that. Always ask to see some code. Even if they have to sanitize it to keep to current NDA agreements. We've had candidates who seemed to be perfection on paper and even held their own during the interview, but their code told the truth. Sharon At 08:39 AM 7/10/2000 -0700, Mike Sheldon wrote: Hardly. I can spot fakers in a flat second, and I ALWAYS ask for samples of code (and make them explain why they did it that way). I just don't like working with sheep. Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 06:44 To: [EMAIL PROTECTED] Subject: Re: Allaire Certification Program From: "Mike Sheldon" [EMAIL PROTECTED] I would look for someone who *refused* to take it. you would likely end up like an acquaintence, who hired someone who claimed to 'know' coldfusion. So far, this person has had to be taught sql, html, coldfusion, program design, database design, debugging, ... and problems continue. Apparently the new employee's idea of 'knowing' coldfusion was that he read the word on the internet once... -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Unless explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT UNIX QUESTION W/CFEXECUTE
I've running Sybase SQL (same as sql) on Linux We have 4.5 and i'm using CFEXECUTe to run a unix script to create a USER What i need to do is find a way to pass the %1(username) %2(password) to the script so i can say ok create user TESTUSER with password blah that way its automates it Any ideas -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
401.3 Error in a secured area
I secured and administrative section on my website, and to make it so netscape could get in there I did basic authentication using https. Now when I use Netscape I get this HTTP Error 401 401.3 Unauthorized: Unauthorized due to ACL on resource This error indicates that the credentials passed by the client do not have access to the particular resource on the server. This resource could be either the page or file listed in the address line of the client, or it could be another file on the server that is needed to process the file listed on the address line of the client. Please make a note of the entire address you were trying to access and then contact the Web server's administrator to verify that you have permission to access the requested resource. Anyone know how to resolve this? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: When should I use CFLOCK?
How should the timeout manifest itself if it is set to true? I set a cfloop inside a CFLOCK to force it to timeout, but I see no response... I expected a failure page -- I don't think cfcatch is required, is it? I believe that the TIMEOUT attribute of CFLOCK specifies how long CF should wait to acquire the lock itself, not a maximum execution time of the locked code. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: When should I use CFLOCK?
I hate to say this, but if ALL session reads and writes should be locked, why can't cold fusion just do it for us automatically. It's like a throwback to the old days when we had to worry about garbage collection and memory allocation.. if we wanted to do that we would write our web apps in c++. Al Musella a1webs.com If you're doing something like this: cfif IsDefined("Session.Foo") -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: verity and meta tags
I thought that only the material within title and body tags is indexed with the basic version of Verity available with CF. No? Is there a way to index META tags with CFindex? If you're indexing static pages, and those pages contain META tags, then you're indexing META tags. If you're dynamically generating the contents of META tags from a database query, you can index the contents of the pertinent database tables by building a query to retrieve all the tags, and indexing that query. If you want to ONLY index META tags, that's probably the route you'd take. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Another CFHTTP challenge
Can't quite figger this one out... I have a page that uses one CFHTTP POST to do an automatic login to another site, and a second CFHTTP POST on the same page to pass parameters and request a secure page. The login always succeeds but the second CFHTTP gets kicked right back to the login screen on the FIRST try -- if I've just restarted CF. On the second try, assuming I haven't restarted the CFServer, the login and page request BOTH work as desired. Seems it must have something to do with the passing of CFID/CFTOKEN via cookies, but I could use some suggestions for further diagnosis/correction... Thanks! Gene Kraybill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Testing Assignment
Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: When should I use CFLOCK?
You should use CFLOCK when you are setting session variables to insure that you maintain consistency throughout your code. Reading however, is not a problem. Unfortunately, under high-volume usage, this may not be the case. If you're reading a variable, and another request is changing it, your read might not work out too well. You'd think that unless an application uses frames this wouldn't be a problem, but you may run into odd problems with multi-threaded browser requests or CFLOCATION wackiness. The gist of this is that you should lock your reads with TYPE="READONLY". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. Something like this? cfSetting enableCFOutputOnly="yes" cfScript // 2 vars for tag: // ip = address to translate // variable = name of returned var // ex. cf_dip ip="192.168.100.1" variable="thisIP" // cfOutput#thisIP#/cfOutput ipArray = listToArray(attributes.ip,"."); returnVar = 'caller.' attributes.variable; returnIP = (ipArray[1]*16777216)+(ipArray[2]*65536)+(ipArray[3]*256)+ipArray[4]; '#returnVar#' = returnIP; /cfScript cfSetting enableCFOutputOnly="no" Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: 401.3 Error in a secured area
You need to make sure that passwords can be sent in clear text in order for your server to work with the Netscape browser. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 9:13 AM To: '[EMAIL PROTECTED]' Subject: 401.3 Error in a secured area I secured and administrative section on my website, and to make it so netscape could get in there I did basic authentication using https. Now when I use Netscape I get this HTTP Error 401 401.3 Unauthorized: Unauthorized due to ACL on resource This error indicates that the credentials passed by the client do not have access to the particular resource on the server. This resource could be either the page or file listed in the address line of the client, or it could be another file on the server that is needed to process the file listed on the address line of the client. Please make a note of the entire address you were trying to access and then contact the Web server's administrator to verify that you have permission to access the requested resource. Anyone know how to resolve this? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
I know thats not exactly what you asked but its one way to do dotless IP's :) I realize some are HEX and some are long binary. I got reply happy ;) - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 10, 2000 1:11 PM Subject: Testing Assignment Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: verity and meta tags
I thought that only the material within title and body tags is indexed with the basic version of Verity available with CF. No? You are correct! I didn't know that, until I just tried it out. I don't generally use it for static pages, and I made the assumption that it just indexed the entire file. That's what happens when I make an assumption. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
They're hex addresses as well? I didn't know that. My solution was: CFPARAM NAME="Attributes.IP" TYPE="String" CFPARAM NAME="Attributes.IPName" DEFAULT="IP" TYPE="String" CFSET SetVariable('caller.'attributes.ipname, (ListGetAt(Attributes.IP, 1, '.')*16777216)+(ListGetAt(Attributes.IP, 2, '.')*65536)+(ListGetAt(Attributes.IP, 3, '.')*256)+(ListGetAt(Attributes.IP, 4, '.'))) I'm going to write an extension to do hex returns as well. Thanks for the info. :) G Sure sure trick us into writing your tag for you lol :) I wrote something like that in perl in about 10 minutes :P They are HEX addresses. So typing 0xCF1F7A8D Pulss up 207.31.122.141 its pretty east use a CFLIST with a period for a delimiter convert each list member to hex. assemble your new address.. Viola :) Hope I did not spoil the fun :) Jeremy - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 10, 2000 1:11 PM Subject: Testing Assignment Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: 401.3 Error in a secured area
I did. It's using basic authentication which is why I put it under https so that the passwords would be encrypted to the server. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 1:16 PM To: [EMAIL PROTECTED] Subject: RE: 401.3 Error in a secured area You need to make sure that passwords can be sent in clear text in order for your server to work with the Netscape browser. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 9:13 AM To: '[EMAIL PROTECTED]' Subject: 401.3 Error in a secured area I secured and administrative section on my website, and to make it so netscape could get in there I did basic authentication using https. Now when I use Netscape I get this HTTP Error 401 401.3 Unauthorized: Unauthorized due to ACL on resource This error indicates that the credentials passed by the client do not have access to the particular resource on the server. This resource could be either the page or file listed in the address line of the client, or it could be another file on the server that is needed to process the file listed on the address line of the client. Please make a note of the entire address you were trying to access and then contact the Web server's administrator to verify that you have permission to access the requested resource. Anyone know how to resolve this? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Checking zip codes against USPS
Yes, there are several custom tags that you could probably use to do this. Or you could download the zip codes database from the UPSP and build something yourself. You're looking for the "Tiger/Zip" database which is updated each month by the USPS. If the USPS site wasn't so slow, I'd give you a link to the database. You can read about the Tiger/Zip database here: http://www.tpsnet.com/html/tigerzip-specs.html You don't HAVE to buy this database from anyone although you might find it more convenient to do so. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 11:53 AM To: [EMAIL PROTECTED] Subject: Checking zip codes against USPS I've got a database that receives new addresses/zip codes from a web form on a daily basis. I would like to eliminate addresses that have a non-existent zip code. Is there some way to automate a function that will verify the zip codes in the database against a USPS list of zip codes on a daily basis? Thank you for any suggestions. Paul Sinclair -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: FW: oracle timestamps
Yes, I agree completely. It also has the characteristic that the time is that of the database server, not the webserver. In this example, that may be a good or a bad thing if the person is updating/inserting other types of dates into their tables. We always use SP's for updates / inserts, and always reference the time to the database machine, so as to remain consistent. I actually prefer this method of encapsulation, but to each his/her own... Steve At 10:37 AM 7/10/2000 -0400, James Hancock wrote: The oracle reserved word SYSDATE will achieve a current timestamp without all the hassle of formatting. INSERT INTO DATA_TABLE(NAME, DATE) VALUES ('#name#', SYSDATE) j. -Original Message- From: Stephen Garrett [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 1:57 PM To: [EMAIL PROTECTED] Subject: RE: oracle timestamps The default syntax of the Oracle TimeStamps is set by the DBA. I always use the TO_CHAR function on date stamps and format them the way I want for display. (used in the SQL statement) Steve At 08:32 AM 7/7/2000 -0400, [EMAIL PROTECTED] wrote: I would guess that the default Oracle date format on the two machines is set differently. Unfortunately a cursory search did not turn up info on how/where this is set. -Original Message- From: Mike Amburn [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 6:56 PM To: Cf-Talk Subject: oracle timestamps does anyone know why oracle would not accept timestamps? when i try to insert Now() into a date/time field, oracle returns with the error "illegal character". FYI, Now() outputs a timestamp like: {ts '/mm/dd hh24/mi/ss'} stranger yet... all my queries work when i run the application locally on a workstation with an ODBC connection out to the database. however, the application refuses to work when i run the application locally on the database. the workstations are Win2000, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver the server is WinNT SP6a, CF 4.5.1 Ent, Oracle 8.1.6.0 ODBC driver ideas??? -mike --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFMODULE
I stand corrected. -- Billy Cravens [EMAIL PROTECTED] Dave Watts wrote: Does CFMODULE have a closing tag so it works the same as CF_ tags that require a closing tag? Sure: cfmodule name="foo" ... /cfmodule Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Checking zip codes against USPS
What is the address for those of us willing to wait. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 1:34 PM To: [EMAIL PROTECTED] Subject: RE: Checking zip codes against USPS Yes, there are several custom tags that you could probably use to do this. Or you could download the zip codes database from the UPSP and build something yourself. You're looking for the "Tiger/Zip" database which is updated each month by the USPS. If the USPS site wasn't so slow, I'd give you a link to the database. You can read about the Tiger/Zip database here: http://www.tpsnet.com/html/tigerzip-specs.html You don't HAVE to buy this database from anyone although you might find it more convenient to do so. ---mark -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-7289 Personal Email: [EMAIL PROTECTED] Personal URL: http://www.warrick.net Business Email: [EMAIL PROTECTED] Business URL: http://www.fusioneers.com ICQ: 346566 -- -Original Message- From: Paul Sinclair [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 11:53 AM To: [EMAIL PROTECTED] Subject: Checking zip codes against USPS I've got a database that receives new addresses/zip codes from a web form on a daily basis. I would like to eliminate addresses that have a non-existent zip code. Is there some way to automate a function that will verify the zip codes in the database against a USPS list of zip codes on a daily basis? Thank you for any suggestions. Paul Sinclair -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Testing Assignment
Short and sweet, since I had a couple of minutes: CFSET IP=Attributes.IP CFSET Dotless = 0 CFSET Octets = ListLen(IP,".") CFLOOP From="1" To="#Octets#" Index="i" CFSET Dotless=Dotless + (ListGetAt(IP,i,".") * (256 ^ (Octets-i))) /cfloop CFSET Caller.Dotless=Dotless Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 1:11 PM To: [EMAIL PROTECTED] Subject: Testing Assignment Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfregistry and basic security
In CF4.51 administrator, one can disable tags such as CFREGISTRY for security purposes. There is also a setting for "unsecured tags directory" where these imposed tag restrictions should not apply. Why then can I not run scheduled tasks when CFREGISTRY is disabled. From its behavior, it would seem that the "unsecured tags directory" is not recursive. I see mention of this issue in the support forums, but no explanation or resolution. Does anyone know why this must be, or if there is some workaround? You're correct; the only unsecured directory is the root directory of the CF Administrator. I tried adding multiple directories to the Registry, but this didn't work so well. I also tried moving the scheduler page into the same directory, and it's got some CFINCLUDEs with absolute paths, so that didn't work well either (and I was too lazy to dig further in that direction). However, if you want a workaround, there is a way to do it. It's an annoying way, but it'll work. You'll have to enable CFREGISTRY while you're scheduling your task, then disable it when you're done. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Testing Assignment
Well, if you want to hardcode it. You'll have to re-code for IPv6 :). Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Brandon Whitaker [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 1:18 PM To: [EMAIL PROTECTED] Subject: Re: Testing Assignment I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. Something like this? cfSetting enableCFOutputOnly="yes" cfScript // 2 vars for tag: // ip = address to translate // variable = name of returned var // ex. cf_dip ip="192.168.100.1" variable="thisIP" // cfOutput#thisIP#/cfOutput ipArray = listToArray(attributes.ip,"."); returnVar = 'caller.' attributes.variable; returnIP = (ipArray[1]*16777216)+(ipArray[2]*65536)+(ipArray[3]*256)+ipArray[4]; '#returnVar#' = returnIP; /cfScript cfSetting enableCFOutputOnly="no" Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
Here is a real quicky I put together over lunch: == Start Code == cfparam name="Attributes.IP" default="0.0.0.0" cfif ListLen(Attributes.IP, ".") NEQ 4 OR ListGetAt(Attributes.IP, "1", ".") EQ 0 !--- Error catching goes here. A long cfif goes above to catch possible errors in each octet of the IP address. The current catching is very rudimentary. --- cfset Error = "Bad IP address provided" cfelse cfscript DotlessIP = (ListGetAt(Attributes.IP, "1", ".") * (256 ^ 3)) + (ListGetAt(Attributes.IP, "2", ".") * (256 ^ 2)) + (ListGetAt(Attributes.IP, "3", ".") * 256) + ListGetAt(Attributes.IP, "4", "."); /cfscript /cfif cfif NOT isDefined("Error") cfset Caller.DotlessIP = DotlessIP cfelse cfset Caller.DotlessIP = Error /cfif == End Code === Not very elegant, but it works. Russel At 01:11 PM 7/10/2000 -0400, you wrote: [snip] I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Testing Assignment
Will IPv6 work with dotless IP addresses? I haven't stayed up on it. Russel At 01:57 PM 7/10/2000 -0400, you wrote: Well, if you want to hardcode it. You'll have to re-code for IPv6 :). Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Brandon Whitaker [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 1:18 PM To: [EMAIL PROTECTED] Subject: Re: Testing Assignment I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. Something like this? cfSetting enableCFOutputOnly="yes" cfScript // 2 vars for tag: // ip = address to translate // variable = name of returned var // ex. cf_dip ip="192.168.100.1" variable="thisIP" // cfOutput#thisIP#/cfOutput ipArray = listToArray(attributes.ip,"."); returnVar = 'caller.' attributes.variable; returnIP = (ipArray[1]*16777216)+(ipArray[2]*65536)+(ipArray[3]*256)+ipArray[4]; '#returnVar#' = returnIP; /cfScript cfSetting enableCFOutputOnly="no" Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
Please excuse the wrapping imposed by Eudora... At 12:52 PM 7/10/2000 -0500, you wrote: Here is a real quicky I put together over lunch: == Start Code == cfparam name="Attributes.IP" default="0.0.0.0" cfif ListLen(Attributes.IP, ".") NEQ 4 OR ListGetAt(Attributes.IP, "1", ".") EQ 0 !--- Error catching goes here. A long cfif goes above to catch possible errors in each octet of the IP address. The current catching is very rudimentary. --- cfset Error = "Bad IP address provided" cfelse cfscript DotlessIP = (ListGetAt(Attributes.IP, "1", ".") * (256 ^ 3)) + (ListGetAt(Attributes.IP, "2", ".") * (256 ^ 2)) + (ListGetAt(Attributes.IP, "3", ".") * 256) + ListGetAt(Attributes.IP, "4", "."); /cfscript /cfif cfif NOT isDefined("Error") cfset Caller.DotlessIP = DotlessIP cfelse cfset Caller.DotlessIP = Error /cfif == End Code === [snip] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Stored Procedure Help
This is my first time working with a stored procedure and I'm not sure that I'm doing it right. I can get the procedure to run but I can't get the values to display. What am I missing !-- cfcode -- CFSTOREDPROC PROCEDURE="p_pricing_pipeline" DATASOURCE="#application.datasource#" CFPROCPARAM TYPE="IN" VARIABLE="broker_id" DBVARNAME="@broker_id" VALUE="112" CFSQLTYPE="CF_SQL_INTEGER" CFPROCRESULT NAME="test" /cfstoredproc cfoutput !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#!br /cfoutput !--Stored Procedure-- SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO -- -- Given a broker, find data for its most recent 5 prequals. -- -- DateAuthor Change -- 07/07/00 D Noble Created. -- create procedure dbo.p_Pricing_Pipeline ( @broker_id int ) as set nocount on create table #prequal ( prequal_num int not null ,borrower_lastname varchar(96) null ) insert #prequal select top 5 prequal_num ,borrower_lastname from prequal where broker_id = @broker_id order by prequal_num desc create table #half_results ( prequal_num int not null ,borrower_lastname varchar(96) null ,loan_status_rank tinyint null ,number_of_comments int null ) insert #half_results select p.prequal_num ,p.borrower_lastname ,min(ls.loan_status_rank) --,sum(isnull(c.prequal_num,0)) ,sum( case when c.prequal_num is null then 0 else 1 end ) from #prequal p join scenario s on p.prequal_num = s.prequal_num join loanstatus ls on s.loan_status_id = ls.loan_status_id left join comment c on p.prequal_num = c.prequal_num group by p.prequal_num ,p.borrower_lastname select prequal_num as prequal_num ,borrower_lastname as borrower_lastname ,loan_status_rank as highest_status ,case number_of_comments when 0 then 0 else 1 end as comment_exists from #half_results drop table #prequal drop table #half_results return 0 GO SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO TIA, --K Katrina Chapman Consultant Ameriquest Mortgage -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Writing to .txt file
Hello, I'm writing a query to a text file using CFX_Dumptext. I am retrieving the file via CFCONTENT. Here is my quesion. When the file comes back to the browser as a downloadable, it comes back named script.cfm (script being the name of my script that is running) vs. file.txt (file being what I name the file). Why is this? TIA Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
IPv6 will ahve addresses like so 00:AA:BB:CC:DD:EE:FF 6 128Bit parts to it.. thus giving us some insane address space that is like ~150 Ip's / square foot on earth :) In a word yes these lil tricks should work :) but thats why we have DNS to abstract us from the entire IP layer of networking :) - Original Message - From: Russel Madere [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 10, 2000 1:54 PM Subject: RE: Testing Assignment Will IPv6 work with dotless IP addresses? I haven't stayed up on it. Russel At 01:57 PM 7/10/2000 -0400, you wrote: Well, if you want to hardcode it. You'll have to re-code for IPv6 :). Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Brandon Whitaker [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 1:18 PM To: [EMAIL PROTECTED] Subject: Re: Testing Assignment I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. Something like this? cfSetting enableCFOutputOnly="yes" cfScript // 2 vars for tag: // ip = address to translate // variable = name of returned var // ex. cf_dip ip="192.168.100.1" variable="thisIP" // cfOutput#thisIP#/cfOutput ipArray = listToArray(attributes.ip,"."); returnVar = 'caller.' attributes.variable; returnIP = (ipArray[1]*16777216)+(ipArray[2]*65536)+(ipArray[3]*256)+ipArray[4]; '#returnVar#' = returnIP; /cfScript cfSetting enableCFOutputOnly="no" Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "It makes you feel so welcome to have a greeter like Papa Dave at the door. Kind of like what Wal-Mart wishes it could do." - John Allred, on Dave Watts "The net interprets censorship as damage and routes around it." - John Gilmore --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Difference between v3.5 and v4.5
Looking for a list of differences between tags for Cold Fusion Server v3.5 and v4.5 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
rds
I had to set up a new nt box (win 2k) -- when trying to open or create projects in studio 4.5 instead of the rds in the location box coming up as rds:... bla... bla... it is just the final directory name. Any ideas? Thanks, je -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Spaces
-Original Message- From: Melanie Gann [mailto:[EMAIL PROTECTED]] Sent: Friday, July 07, 2000 3:22 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Spaces My case is slightly different but the same problem. The Novell server does not understand space chars and says "The server cannot understand the message you sent". So I'm trying to get rid of the spaces and out them back in another page. I've tried CFSET Title= #REPLACE(Title," ","_","ALL")# CFSET Title= #REPLACE(Title,"","_","ALL")# CFSET Title= #REPLACE(#Title#," ","_","ALL")# and numerous others too. What is the hex value for space? This seems too obvious to not work.but I'm having the same problem. Regards, Melanie At 08:31 AM 7/7/00 -0500, Chris Terrebonne wrote: Replace(CompanyName, " ", "", "ALL") Specify the space, then the null (""), then ALL. Chris -- Original Message From: "Larry Juncker"[EMAIL PROTECTED] Subject: RE: Spaces Date: Fri, 7 Jul 2000 07:41:01 -0500 Kevin; I believe that you have to type all inside your last pair of quotes in order to replace ALL of the spaces. Your code should like this: #Replace(CompanyName, " ", "ALL")# Hope this helps H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 06, 2000 8:36 PM To: CF Talk (E-mail) Subject: Spaces I'm trying to strip blank spaces from inside a string but am having no luck. I tried this but no joy. #Replace(CompanyName, " ", "")# Any clues please? Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 ** * * This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** * * -- - - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Melanie Gann Second Street Web Design www.second-street.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Force database connections to close....
Hello all, It looks like CF doesnt like to release the data brought down, which hogs up on the memory. Is there a way to force the database connection to close or to release memory as data is dumped to the client..??? some like connection.close() This would really be a powerful feature to have... Any ideas Thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Salt Lake City ColdFusion User Group July Meeting
Here is the information for our next meeting. Please RSVP to [EMAIL PROTECTED] so that we can get a correct count for refreshments. Our next meeting will take place on: Thursday, July 13, 2000 from 6:30 PM to 8:00 PM. Speaker: Kao Martin, Web Developer Company: Infovision Inc Phone: 801-825-6558 Email: [EMAIL PROTECTED] Topic: Implementing Session Management on a Clustered Environment Session management is crucial to personalized, interactive web sites, and E-commerce. However, most web server technologies do not support session management in a clustered multi-server environment. We will examine the use of WDDX to solve these session management problem. Location: GE Capital 4246 S. Riverboat Rd. Salt Lake City, UT 84123 Agenda: 6:30PM - 6:45PM Give users an opportunity to do some networking 6:45 - 7:45PM Lecture on Session Management in a Cluster 7:45PM - 8:00PM QA Refreshments will be provided by Infovision Inc. Thanks, Scott P. Heffron Email: [EMAIL PROTECTED] Web Site: http://www.infovisioninc.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Sort many tables Problem!
We have several tables containing articles for our Intranet. What we want to do is output one list with all the articles sorted by date regardless of what table they came from. Right now we are grouping them and adding a header on the display page for each group. We want to get rid of the headers and produce one list. Any ideas? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Know where I can find Chr(*) definitions?
That doesn't help much with Tab, ESC, or DLE (data link escape - CHR(16). No, I know.nevermind ;) This is quite handy for working out the other way round, though again it doesn't work with everything: TEXTAREA ONKEYPRESS="alert(event.keyCode)"hit a key/TEXTAREA (works on IE5, not sure what else...) Bert It's a good reference for printable characters, though. Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 10:04 AM To: '[EMAIL PROTECTED]' Subject: RE: Know where I can find Chr(*) definitions? TEXTAREA ROWS="20" CFOUTPUT CFLOOP INDEX="i" FROM="1" TO="255" #i# = #chr(i)# /CFLOOP /CFOUTPUT /TEXTAREA Bert -Original Message- From: GE [mailto:[EMAIL PROTECTED]] Sent: 07 July 2000 18:44 To: [EMAIL PROTECTED] Subject: Re: Know where I can find Chr(*) definitions? Hello Ric, What you are looking for is an ASCII table. A quick search should find one for you - or you could look it up in any refernce manual you have on programming (should be one in one of them). To be sure you have found what you are looking for just compare the table values of 10 and 13 to verify that you have a carraige return and a line feed. hth, Nelson Ric Smith wrote: Anyone know of anywhere I can find the definition for the Chr(*) stuff online? Only ones I know are Chr(10) and Chr(13). Just curious, thanks. Ric Smith -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stored Procedure Help
Just like a cfquery, you need to reference the query: cfoutput query="test" !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#!br /cfoutput or cfoutput !#test.prequal_num#! - !#test.borrower_lastname#! - !#test.highest_status#! - ! #test.comment_exists#!br /cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 2:07 PM To: [EMAIL PROTECTED] Subject: Stored Procedure Help This is my first time working with a stored procedure and I'm not sure that I'm doing it right. I can get the procedure to run but I can't get the values to display. What am I missing !-- cfcode -- CFSTOREDPROC PROCEDURE="p_pricing_pipeline" DATASOURCE="#application.datasource#" CFPROCPARAM TYPE="IN" VARIABLE="broker_id" DBVARNAME="@broker_id" VALUE="112" CFSQLTYPE="CF_SQL_INTEGER" CFPROCRESULT NAME="test" /cfstoredproc cfoutput !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#!br /cfoutput !--Stored Procedure-- SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO -- -- Given a broker, find data for its most recent 5 prequals. -- -- DateAuthor Change -- 07/07/00 D Noble Created. -- create procedure dbo.p_Pricing_Pipeline ( @broker_id int ) as set nocount on create table #prequal ( prequal_num int not null ,borrower_lastname varchar(96) null ) insert #prequal select top 5 prequal_num ,borrower_lastname from prequal where broker_id = @broker_id order by prequal_num desc create table #half_results ( prequal_num int not null ,borrower_lastname varchar(96) null ,loan_status_rank tinyint null ,number_of_comments int null ) insert #half_results select p.prequal_num ,p.borrower_lastname ,min(ls.loan_status_rank) --,sum(isnull(c.prequal_num,0)) ,sum( case when c.prequal_num is null then 0 else 1 end ) from #prequal p join scenario s on p.prequal_num = s.prequal_num join loanstatus ls on s.loan_status_id = ls.loan_status_id left join comment c on p.prequal_num = c.prequal_num group by p.prequal_num ,p.borrower_lastname select prequal_num as prequal_num ,borrower_lastname as borrower_lastname ,loan_status_rank as highest_status ,case number_of_comments when 0 then 0 else 1 end as comment_exists from #half_results drop table #prequal drop table #half_results return 0 GO SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO TIA, --K Katrina Chapman Consultant Ameriquest Mortgage -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Testing Assignment
Hey, that was more fun than work! Thoughts for future versions . . . reverse (dotless to dotted), octal addresses, hexadecimal addresses, combinations of hex, octal and dotted, masked ip addresses with multiples of 256 added to a dotted IP or multiples of 4294967296 added to dotless IPs. I didn't know any of these existed until now! I found out about it from http://www.nwi.net/~pchelp/obscure.htm. Wonder if the list is down? Or just quiet because everyone is working on this . . . haha. Dan -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 10:11 AM To: [EMAIL PROTECTED] Subject: Testing Assignment Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OLEDB Date type
Im trying to convert some existing access apps from using ODBC to OLEDB, only theres an issue with the ODBC date format ( {ts '2000-07-06 14:34:00} ). How do I properly escape/format a date/time value in an OLEDB query? Last year I did a ODBC to OLE conversion for an Access '97 database and posted some caveats to the list on my experience. This portion of the original post deals with the dates. I basically figured it out by trial and error. Dates with Access OLE - Since I couldn't pass ODBC dates, I used something like: cfset DateTimeStamp = DateFormat(now(), "MM/DD/") " " TimeFormat(now(), "h:mm:ss tt") To pass the variable in an SQL statement: Values(#widget_ID_number#, '#widget_name#', '#DateTimeStamp#') It was pointed out to me that you could also pass the date using the Access date() and time() functions in an SQL statement, so I now use: Values(#widget_ID_number#, '#widget_name#', Date() ' ' Time()) In Access you need to set the default for the field to "=now()". So, for easy date entry in Access 97 using OLE, simply use the date() function in your SQL statements. I think this also applies to SQL Server OLE using the getDate() function. To use a form date in an SQL query: cfif FORM.DateStart IS NOT "" cfset startDate = DateFormat(FORM.DateStart,'DD/MM/') AND (A.testCompDate = DateValue(#DE(startDate)#)) /cfif Using the date in SQL search queries I recall that Access was particluar about the date format, but I can't remember the details. The DD/MM/ format worked for me, so I'm guessing that perhaps it was the date format MM/DD/ that didn't work. Hope this helps. Mark Zukiwsky Edmonton, Canda -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
I think that we should take all the options that you and others have mentioned and make a single CF_IP that will have options for them all. Make it a 'group project' with myself or someone else as the primary caretaker (a la open source software). Hey, that was more fun than work! Thoughts for future versions . . . reverse (dotless to dotted), octal addresses, hexadecimal addresses, combinations of hex, octal and dotted, masked ip addresses with multiples of 256 added to a dotted IP or multiples of 4294967296 added to dotless IPs. I didn't know any of these existed until now! I found out about it from http://www.nwi.net/~pchelp/obscure.htm. Wonder if the list is down? Or just quiet because everyone is working on this . . . haha. Dan -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 10:11 AM To: [EMAIL PROTECTED] Subject: Testing Assignment Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFSCRIPT Question
Can I use cflocation in a cfscript or it onlu does if then else and loops. Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Sorting an Array
Hello All: Need help on sorting an query I have a query that has two fields field 1, field 2 field 1 is a varchar field 2 is a varchar field 1 however has numeric data i.e. 0 through 100 I must sort on field 1 and output on field 2 here is the current query CFQUERY NAME="CONS4" datasource="CLINKSTEST" SELECT t700_parallelprof.* FROM (t110_headerecseg LEFT JOIN t700_parallelprof ON t110_headerecseg.rqstid = t700_parallelprof.rqstid) WHERE (t110_headerecseg.rqstid = '#TEMP#') /CFQUERY !--- Declare the array --- CFSET aCONS4=ArrayNew(2) !--- Populate the array row by row --- CFLOOP QUERY="CONS4" CFSET aCONS4[CurrentRow][1]=val(CONS4.prevtableptr[CurrentRow]) CFSET aCONS4[CurrentRow][2]=CONS4.reporttext[CurrentRow] /CFLOOP !---loop to output the array contents --- CFSET Total_Records= CONS4.RecordCount CFLOOP INDEX="Counter" FROM=1 TO="#Total_Records#" CFOUTPUT #trim(aCONS4[Counter][1])# nbsp;nbsp; is this field numeric:: #isnumeric(aCONS4[Counter][1])# PRE #StripCR(aCONS4[Counter][1])#nbsp!--- ;nbsp;#StripCR(aCONS4[Counter][2])# --- /PRE /CFOUTPUT /CFLOOP Any help would be greatly appreciated winNT 4.0 CF 4.5.1 iis4 Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
good simple web board been done?
Hey everyone, I'm looking for a good, simple web bulletin board where users can post messages and replies that does not require users to create an account, and is not a "drill-down" type application. Client wants a greats topics and replies to be a great big list like the old cgi types (Mats Scripts). Thanks, Jeff -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFSCRIPT Question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You can't use any kind of tag in cfscript. 4.5 finally has support for creating objects in script instead of with CFObject, but that's about the best you can do so far. I do hope Allaire makes the rest of CF's functionality accessible from script soon! (I know Dixon isn't actually in Ticonderoga any more, but I grew up there. It's neat to see the name again...) Best regards, Zac Bedell -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 3:37 PM To: '[EMAIL PROTECTED]' Subject: CFSCRIPT Question Can I use cflocation in a cfscript or it only does if then else and loops. Robert Everland III Web Developer Dixon Ticonderoga -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOWooPwraVoMWBwRBEQJjZQCfTgVngfemtyF+htO1L08b+seBu9YAoL7K qpQjPmGtbZDvdW5dwVqhnlii =NbeT -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Advanced Security
Those services are not running. When I try to manually start them I get the following error. Could not start the SiteMinder Authorization Services on Local Computer The service did not return an error. This could be an internal Windows error or an internal service error Any guesses? - Original Message - From: "Raymond K. Camden" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 10, 2000 5:06 AM Subject: RE: Advanced Security Check to make sure the advanced security services are running. Theres two of them, SiteMinder Authorization and SiteMinder Authentication. === Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 2:45 AM To: [EMAIL PROTECTED] Subject: Advanced Security Anyone ever install CF Server, go into the administrator, click on the advanced security link and get this: Error Diagnostic Information Security Policy Administration Security Policy Administration is not available. I check the advanced security option on installation like usual. I have never gotten this error before -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(WOT): Visual Basic, Access, and opening a FileOpen dialog
I ain't no VB guy, as evidenced by this OT post. But I want to create a module that proppts the user for a file and performs a dataconversion process. I am using Access, but can't remember (don't think I ever knew) how to open a file browse dialog so the user can select the appropriate file. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: good simple web board been done?
I can give you code for a simple one if you want. It's written in fusebox. It was one of the first things I built so its not all that cool. but it sounds like what you are looking for. If nothing else it will give you an idea where to start and it would be free. I think my brother put it on the site he is starting to build for fun. you can check it out at www.benet.ws - Original Message - From: "Jeff Fongemie" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Monday, July 10, 2000 12:52 PM Subject: good simple web board been done? Hey everyone, I'm looking for a good, simple web bulletin board where users can post messages and replies that does not require users to create an account, and is not a "drill-down" type application. Client wants a greats topics and replies to be a great big list like the old cgi types (Mats Scripts). Thanks, Jeff -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IIf() and DE confusion
I know this can be done, but I'll be hanged if I can figure out the right combination of DE() and ## and quotes and whatever else might be needed. I'm trying to use IIf() in a SQL statement instead of the following: thedate = cfif IsDate(form.thedate)#CreateODBCDate(form.thedate)#cfelseNULL/cfif Thanks, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Testing Assignment
While you're at it some additional functions would be neat. For example, testing whether a given IP address is within a range. For example, is 123.123.123.123 in the set of *.1??.???.* Regards, Howie - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 10, 2000 3:42 PM Subject: Re: Testing Assignment I think that we should take all the options that you and others have mentioned and make a single CF_IP that will have options for them all. Make it a 'group project' with myself or someone else as the primary caretaker (a la open source software). Hey, that was more fun than work! Thoughts for future versions . . . reverse (dotless to dotted), octal addresses, hexadecimal addresses, combinations of hex, octal and dotted, masked ip addresses with multiples of 256 added to a dotted IP or multiples of 4294967296 added to dotless IPs. I didn't know any of these existed until now! I found out about it from http://www.nwi.net/~pchelp/obscure.htm. Wonder if the list is down? Or just quiet because everyone is working on this . . . haha. Dan -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 10:11 AM To: [EMAIL PROTECTED] Subject: Testing Assignment Just for fun and keeping on the topic of testing and such, I'm assigning a test to the CF community. Lets say you have an IP address. (207.31.122.141) This IP address can also be seen as a long binary number using dotless IP addressing (3474946701). The way the internet works, either address will work properly. Now using the search terms "dotless IP address binary decimal", find the information on how to convert from a standard Ip to a long binary IP. Once you have the information, write a module that takes an IP address and converts it. CF_DotlessIP IP="207.31.122.141" I'm holding back from posting my tag result to the gallery so I can see what others will try. If anyone wants the tag now without trying to do it themselves, contact me off list. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IIf() and DE confusion
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEAAC.DB4262B0 Content-Type: text/plain; charset="iso-8859-1" shouldn't this work?: iif(IsDate(form.thedate), DE(#CreateODBCDate(form.thedate)#), DE("")) --b p.s. if you ever think you have it badhere is an iif that took a few hours of my time and about 15 minutes of a colleagues: iif(query.red_flag[rowNbr], DE(caller.pqa '/redflag.gif'), iif(query.close_flag[rowNbr], ""DE(iif(query.won_flag[rowNbr], DE(caller.pqa '/thumbs_up.gif'), DE(caller.pqa '/thumbs_down.gif')))"", ""DE(caller.pqa '/transpix.gif')"")) Laterz. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 4:15 PM To: [EMAIL PROTECTED] Subject: IIf() and DE confusion I know this can be done, but I'll be hanged if I can figure out the right combination of DE() and ## and quotes and whatever else might be needed. I'm trying to use IIf() in a SQL statement instead of the following: thedate = cfif IsDate(form.thedate)#CreateODBCDate(form.thedate)#cfelseNULL/cfif Thanks, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_001_01BFEAAC.DB4262B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1" META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12" TITLERE: IIf() and DE confusion/TITLE /HEAD BODY PFONT SIZE=3D2shouldn't this work?:/FONT /P PFONT SIZE=3D2iif(IsDate(form.thedate), = DE(#CreateODBCDate(form.thedate)#), DE(quot;quot;))/FONT /P PFONT SIZE=3D2--b/FONT /P PFONT SIZE=3D2p.s.nbsp; if you ever think you have it badhere = is an iif that took a few hours of my time and about 15 minutes of a = colleagues:/FONT/P PFONT SIZE=3D2iif(query.red_flag[rowNbr], DE(caller.pqa amp; = '/redflag.gif'), iif(query.close_flag[rowNbr], = quot;quot;DE(iif(query.won_flag[rowNbr], DE(caller.pqa amp; = '/thumbs_up.gif'), DE(caller.pqa amp; = '/thumbs_down.gif')))quot;quot;, quot;quot;DE(caller.pqa amp; = '/transpix.gif')quot;quot;))/FONT/P PFONT SIZE=3D2Laterz./FONT /P PFONT SIZE=3D2/FONT BRFONT SIZE=3D2Bryan D. = Batcheldernbsp;nbsp;nbsp;nbsp;nbsp;nbsp; Work: = 813-935-7100/FONT BRFONT SIZE=3D2Palm/Internet Developernbsp;nbsp; Home: = 727-547-1322/FONT BRFONT SIZE=3D2/FONT BRFONT SIZE=3D2ConnectWise, Inc. (www.ConnectWise.com)/FONT BRFONT SIZE=3D22803 West Busch Blvd, Suite 204/FONT BRFONT SIZE=3D2Tampa, FL 33618/FONT BRFONT SIZE=3D2/FONT /P PFONT SIZE=3D2-Original Message-/FONT BRFONT SIZE=3D2From: Jim McAtee [A = HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]= /A]/FONT BRFONT SIZE=3D2Sent: Monday, July 10, 2000 4:15 PM/FONT BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT BRFONT SIZE=3D2Subject: IIf() and DE confusion/FONT /P BR PFONT SIZE=3D2I know this can be done, but I'll be hanged if I can = figure out the right/FONT BRFONT SIZE=3D2combination of DE() and ## and quotes and whatever = else might be needed./FONT BRFONT SIZE=3D2I'm trying to use IIf() in a SQL statement instead = of the following:/FONT /P PFONT SIZE=3D2thedate =3D lt;cfif/FONT BRFONT = SIZE=3D2IsDate(form.thedate)gt;#CreateODBCDate(form.thedate)#lt;cfels= egt;NULLlt;/cfifgt;/FONT /P PFONT SIZE=3D2Thanks,/FONT BRFONT SIZE=3D2Jim/FONT /P BR PFONT = SIZE=3D2---= ---/FONT BRFONT SIZE=3D2Archives: A = HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = TARGET=3D"_blank"http://www.mail-archive.com/cf-talk@houseoffusion.com/= /A/FONT BRFONT SIZE=3D2To Unsubscribe visit A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli= sts/cf_talk" = TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= body=3Dlists/cf_talk/A or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body./FONT/P /BODY /HTML --_=_NextPart_001_01BFEAAC.DB4262B0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To
RE: Stored Procedure Help
Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you!Thank you! I don't think I said that enough. --K Katrina Chapman Consultant Ameriquest Mortgage [EMAIL PROTECTED] tate.ky.usTo: [EMAIL PROTECTED] cc: 07/10/00 12:03Subject: RE: Stored Procedure Help PM Please respond to cf-talk Just like a cfquery, you need to reference the query: cfoutput query="test" !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#!br /cfoutput or cfoutput !#test.prequal_num#! - !#test.borrower_lastname#! - !#test.highest_status#! - ! #test.comment_exists#!br /cfoutput -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 2:07 PM To: [EMAIL PROTECTED] Subject: Stored Procedure Help This is my first time working with a stored procedure and I'm not sure that I'm doing it right. I can get the procedure to run but I can't get the values to display. What am I missing !-- cfcode -- CFSTOREDPROC PROCEDURE="p_pricing_pipeline" DATASOURCE="#application.datasource#" CFPROCPARAM TYPE="IN" VARIABLE="broker_id" DBVARNAME="@broker_id" VALUE="112" CFSQLTYPE="CF_SQL_INTEGER" CFPROCRESULT NAME="test" /cfstoredproc cfoutput !#prequal_num#! - !#borrower_lastname#! - !#highest_status#! - ! #comment_exists#!br /cfoutput !--Stored Procedure-- SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO -- -- Given a broker, find data for its most recent 5 prequals. -- -- DateAuthor Change -- 07/07/00 D Noble Created. -- create procedure dbo.p_Pricing_Pipeline ( @broker_id int ) as set nocount on create table #prequal ( prequal_num int not null ,borrower_lastname varchar(96) null ) insert #prequal select top 5 prequal_num ,borrower_lastname from prequal where broker_id = @broker_id order by prequal_num desc create table #half_results ( prequal_num int not null ,borrower_lastname varchar(96) null ,loan_status_rank tinyint null ,number_of_comments int null ) insert #half_results select p.prequal_num ,p.borrower_lastname ,min(ls.loan_status_rank) --,sum(isnull(c.prequal_num,0)) ,sum( case when c.prequal_num is null then 0 else 1 end ) from #prequal p join scenario s on p.prequal_num = s.prequal_num join loanstatus ls on s.loan_status_id = ls.loan_status_id left join comment c on p.prequal_num = c.prequal_num group by p.prequal_num ,p.borrower_lastname select prequal_num as prequal_num ,borrower_lastname as borrower_lastname ,loan_status_rank as highest_status ,case number_of_comments when 0 then 0 else 1 end as comment_exists from #half_results drop table #prequal drop table #half_results return 0 GO SET QUOTED_IDENTIFIER OFFSET ANSI_NULLS ON GO TIA, --K Katrina Chapman Consultant Ameriquest
Oracle CLOBs and Native Drivers
We are having some problems with ColdFusion's native drivers for Oracle. Connecting to Oracle 8i (8.1.6), we receive an error whenever attempting to read or write to a field of CLOB datatype. I saw an earlier reference to upgrading to ColdFusion 4.5.1. Does this fix the problem? Does this same problem exist using Oracle's ODBC drivers instead? -- Pete Miller GoTech, Inc. http://www.gotech.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: IIf() and DE confusion
Nope, if left blank, CF tries to evaluate CreateODBCDate() and generates an error: Error Diagnostic Information Parameter 1 of function CreateODBCDate which is now "" must be a date/time value Jim -Original Message- From: Bryan Batchelder [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Monday, July 10, 2000 2:25 PM Subject: RE: IIf() and DE confusion This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFEAAC.DB4262B0 Content-Type: text/plain; charset="iso-8859-1" shouldn't this work?: iif(IsDate(form.thedate), DE(#CreateODBCDate(form.thedate)#), DE("")) --b p.s. if you ever think you have it badhere is an iif that took a few hours of my time and about 15 minutes of a colleagues: iif(query.red_flag[rowNbr], DE(caller.pqa '/redflag.gif'), iif(query.close_flag[rowNbr], ""DE(iif(query.won_flag[rowNbr], DE(caller.pqa '/thumbs_up.gif'), DE(caller.pqa '/thumbs_down.gif')))"", ""DE(caller.pqa '/transpix.gif')"")) Laterz. Bryan D. Batchelder Work: 813-935-7100 Palm/Internet Developer Home: 727-547-1322 ConnectWise, Inc. (www.ConnectWise.com) 2803 West Busch Blvd, Suite 204 Tampa, FL 33618 -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Monday, July 10, 2000 4:15 PM To: [EMAIL PROTECTED] Subject: IIf() and DE confusion I know this can be done, but I'll be hanged if I can figure out the right combination of DE() and ## and quotes and whatever else might be needed. I'm trying to use IIf() in a SQL statement instead of the following: thedate = cfif IsDate(form.thedate)#CreateODBCDate(form.thedate)#cfelseNULL/cfif Thanks, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle CLOBs and Native Drivers
Pete, what kinda error? stas@ -Original Message- From: Pete Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 11, 2000 12:44 AM To: [EMAIL PROTECTED] Subject: Oracle CLOBs and Native Drivers We are having some problems with ColdFusion's native drivers for Oracle. Connecting to Oracle 8i (8.1.6), we receive an error whenever attempting to read or write to a field of CLOB datatype. I saw an earlier reference to upgrading to ColdFusion 4.5.1. Does this fix the problem? Does this same problem exist using Oracle's ODBC drivers instead? -- Pete Miller GoTech, Inc. http://www.gotech.net -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: good simple web board been done?
Check out coztech.com he has a cf bulletin board like the old Matt's Scripts board. Ric Smith - Original Message - From: "Jeff Fongemie" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Monday, July 10, 2000 3:52 PM Subject: good simple web board been done? Hey everyone, I'm looking for a good, simple web bulletin board where users can post messages and replies that does not require users to create an account, and is not a "drill-down" type application. Client wants a greats topics and replies to be a great big list like the old cgi types (Mats Scripts). Thanks, Jeff -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Know where I can find Chr(*) definitions?
Thanks for everyone's help, didn't know I'd get such a response. I like playing with ascii characters for little pointers exclaimations and such. Ric Smith -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Oracle CLOBs and Native Drivers
At 01:44 PM 7/10/00 -0700, you wrote: We are having some problems with ColdFusion's native drivers for Oracle. Connecting to Oracle 8i (8.1.6), we receive an error whenever attempting to read or write to a field of CLOB datatype. I saw an earlier reference to upgrading to ColdFusion 4.5.1. Does this fix the problem? Does this same problem exist using Oracle's ODBC drivers instead? What is the error message? What is the type of information going into the field? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: good simple web board been done?
okay there are some fuseaction bugs that I will address later. That's what you get for posting a "here go look at it " app. - Original Message - From: "Sean Renet" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 10, 2000 1:08 PM Subject: Re: good simple web board been done? I can give you code for a simple one if you want. It's written in fusebox. It was one of the first things I built so its not all that cool. but it sounds like what you are looking for. If nothing else it will give you an idea where to start and it would be free. I think my brother put it on the site he is starting to build for fun. you can check it out at www.benet.ws - Original Message - From: "Jeff Fongemie" [EMAIL PROTECTED] To: "Cf-Talk" [EMAIL PROTECTED] Sent: Monday, July 10, 2000 12:52 PM Subject: good simple web board been done? Hey everyone, I'm looking for a good, simple web bulletin board where users can post messages and replies that does not require users to create an account, and is not a "drill-down" type application. Client wants a greats topics and replies to be a great big list like the old cgi types (Mats Scripts). Thanks, Jeff -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Oracle CLOBs and Native Drivers
We are having some problems with ColdFusion's native drivers for Oracle. Connecting to Oracle 8i (8.1.6), we receive an error whenever attempting to read or write to a field of CLOB datatype. I saw an earlier reference to upgrading to ColdFusion 4.5.1. Does this fix the problem? Does this same problem exist using Oracle's ODBC drivers instead? You'll need to enable one of the "long text" options in the CF datasource settings: http://www.allaire.com/handlers/index.cfm?ID=16259Method=FullPageCall=/sup port/index.cfm Also, as a side note, I just learned that if you're using CF on Solaris with the Oracle 8.1.6 client, you'll want to upgrade: http://www.allaire.com/handlers/index.cfm?ID=16398Method=FullPageCall=/sup port/index.cfm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFTREE and CFGRID problems with IE
I'm very new to this list (started today), so please forgive me if this is an old topic: I am building some tools for a couple of clients which look very attractive with CFTREEs and CFGRIDs. However, I'm finding that in Internet Explorer (version 5 for sure...and I think version 4), the grids and trees (especially the trees) are missing sometimes if I leave the page and come back to it or if it goes out of focus for any reason. No amount of refreshing will bring them back...I generally have to kill the application and restart it in order to get these items to display again. Can anyone let me know what might be causing such behavior? Thanks in advance, Stephen L. McMahon [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.