Re: convert caps to small
Is there a tag that can instantly convert all the text that im outputting into all small letters .. Rather than some of them being in capitals ? Umm, yeah.. Lcase("INSERT YOUR CAPS STRING HERE") HTH Rob Keniger -- 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.
RE: Searchy thing
Thanks Paul - does anyone know if it is possible to extract the document title, subject, author etc contained in the pdf document's General Info using Verity and CF. The very good example provided by Paul only shows the file's name. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 June 2000 3:01:PM To: [EMAIL PROTECTED] Subject: Re: Searchy thing Go to http://www.cbee.org/search.html Enter the key word: safety The first doc is a PDF, the second et al is Word. best, paul At 02:16 PM 6/21/00 +0930, you wrote: Can anyone direct me to any sites that use CF and Verity as a search engine, particularly for indexing PDF and Word files, that I can have a look at. TIA! 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.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.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. 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.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.
Re: convert caps to small
doh!!! Thanks!!! When I'm in a hurry ..I tend to miss small things like these ! : ) thanks again. At 04:18 PM 6/21/00 +1000, you wrote: Is there a tag that can instantly convert all the text that im outputting into all small letters .. Rather than some of them being in capitals ? Umm, yeah.. Lcase("INSERT YOUR CAPS STRING HERE") HTH Rob Keniger -- 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.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.
[ANN] ACT ColdFusion User Group Meeting
A N N O U N C E M E N T ACT ColdFusion User Group Meeting This Month - our highest profile speaker ever, AND a visit from Firmware!!! When: 5:30-6:45PM, Thursday 13 July 2000 Where: Level 2 Training Centre Defence Housing Authority 26 Brisbane Avenue BARTON ACT 2600 Agenda: * Welcome * This month's topic: Allaire JRun 3.0 - Nick McNaughton, Director, Allaire Asia/Pacific * Open QA Chris Wood and the team from Firmware will also be at the meeting on the 13th to answer your questions and help in any other way they are able. Light refreshments will be provided. NOTE: Date and start time! RSVP: Stephen Collins ([EMAIL PROTECTED]) by replying to this message. Given this month's speaker and the potential for high interest and numbers, your response is ABSOLUTELY necessary to estimate catering requirements. Please circulate this message to your friends and workmates in the developer community. Stephen Collins | Stephen Collins| | Consultant - Australian Corporate Information Solutions| |GPO Box 2962 CANBERRA ACT 2601 Australia| | Ph +61 2 62822662 Fax +61 2 62824328 Cel +61 410 680722| | [EMAIL PROTECTED] [EMAIL PROTECTED] | | http://www.acis.com.au | |~~~oOo~~| | Before I got into triathlon, I was a normal person. | || -- 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.
RE: Support for NCLOB Datatype in Oracle
Can anyone tell me whether the native driver for Oracle that comes with Cold Fusion Enterprise 4.5 supports Oracle's NCLOB data type? I'm not 100% certain, but I don't think so - N' data types aren't ASCII, but Unicode, which CF doesn't understand. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.
RE: combining order by and cf group attribute
I'm joining a few tables and grouping them by their "package". It works great until I try to add an ORDER BY price statement to the sql. When I do that, it creates several groups. The pricing order takes precedence over the grouping done in CF. How can I order by price and stay within the groups? You're lucky it's working now - it's purely coincidental that the natural sort order matches what you're GROUPing by. You should always ORDER BY the field by which you want to GROUP in your CFOUTPUT. If you want to specify a secondary ordering, ORDER BY that field as well: ORDER BY Package, Price Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.
RE: This is a multi-part message in MIME format????
Why is it some messages get posted with this? This is a multi-part message in MIME format. A little more expansively (sp?), any non-Plain Text format; i.e. Rich Text, HTML, etc. Basically, it's the poster not choosing Plain Text in the formatting of the email messages, which is annoying on this list as it adds odd codes into the message 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.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.
RE: Need help with a SQL query
Sorry about the non-descriptive subject, but I'm tired and really couldn't think of a way to describe my question in one line g. I have a database table of product information and a database table of product category information. Each product may exist in more than one category, so I created a "mappings" table that simply contains ItemID-CategoryID pairs. This is all well and good. I am trying to write a product details query that includes a comma delimited list of the CategoryIDs that the product belongs to. Currently I run two queries: one for the data from the product table and another for the CategoryIDs from the mappings table. Then I create a list of the Category IDs and manually add the list to the query of other product data. Is there a way to get SQL to do this for me in one query? As far as I know subqueries are only useful when they return a single value, which won't quite work here. Any ideas? Right, I'm not gonna address the whole thing (no time at the moment), but a quick word about sub-queries They should be used in 2 ways - one to return a single result; select * from myTable where myValue=(select myValue from myOtherTable where...) Or to return multiple values select * from myTable where myValue in (select myValue from myOtherTable where...) The second is a lot more useful for what you're looking for Hope this gives you a push in the right direction If I get more time later, I'll expand, but quite busy at the moment... sorry. 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.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.
Re: MDAC 2.5 - i don't think so
On 6/20/00, Ric Smith penned: Just so you all know, I installed MDAC 2.5 on my production server (cf 4.5,nt4 sp6a) and access didn't like it one bit. I don't know if it's just my machine or what, but I reinstalled 2.1 and everything is happy again. The error I got was something like ODBC Access Error (unknown) Access loves it on mine. :) 4.1, NT4, sp5 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- 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.
Oracle vs SQL server
Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? I tend to say no just because everything is already working, including some stored procedures and triggers. Has anyone had to do this migration path? What are the Advantages of Oracle over SQL Server?I've read some great things about SQL server 2000 and wonder if any advantages Oracles has at the moment will be gone with SQL Server 2000 is released later this year. Any other thoughts? Thanks Tom Nunamaker, Maj, USAF USAFE AMOCC/SC Chief, Communications Branch Senior Web Developer Ramstein AB, Germany -- 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.
RE: Database Design Question
The standard way to take care of this is a self-referencing table, and a recursive function to bust them out. ID|Parent_ID Top levels have an id of 0, and the other rows work well with an autonumber in the id. If children can have multiple parents, as in a BOM(Bill of Materials) problem, you'll need two tables of course. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 6:42 PM To: [EMAIL PROTECTED] Subject: Database Design Question I have listings that look like: 1.0 foobars 1.1 foobars the revenge 1.1.2 foobars the revenge II 1.1.2.1 more foobar specials 2.0 brown foobars 3.0 green foobars etc.. What is the best DB design in terms of performance for a classification system like this? Thanks, Brook Davies MaracasMedia Inc. -- 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.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.
RE: Oracle vs SQL server
Tom, I have worked with both the databases and i think Sql server is "much more easier to set up and to work with". Sql server is much more flexible than oracle, Oracle might have some advantages for large databases, but i guess the latest Sql server version is equally powerful. Joe --- Original Message --- Tom Nunamaker [EMAIL PROTECTED] Wrote on Wed, 21 Jun 2000 13:18:43 +0200 -- Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? I tend to say no just because everything is already working, including some stored procedures and triggers. Has anyone had to do this migration path? What are the Advantages of Oracle over SQL Server?I've read some great things about SQL server 2000 and wonder if any advantages Oracles has at the moment will be gone with SQL Server 2000 is released later this year. Any other thoughts? Thanks Tom Nunamaker, Maj, USAF USAFE AMOCC/SC Chief, Communications Branch Senior Web Developer Ramstein AB, Germany -- 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. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- 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.
RE: How to escape a - in a form post
Well, since a FORM is essentially a struct, you can access you variable by referencing it this way : #FORM["E-Mail"]# I tested it with CFServer 4.5.1 on Solaris, but since this kind of reference can be made also on 4.0, it should work. -Original Message- From: Kevin Pechin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 6:35 PM To: [EMAIL PROTECTED] Subject: How to escape a "-" in a form post Hi, I have to make a general form that takes a user defined form element such as a text field and put it into an email. I have everything working except if a user creates a form with an input field named with a dash (-) cold fusion treats it as a subtraction and returns an error when i try to access the variable. I need to be able to reference the variable on the following page. For example i would normally reference a form variable such as a text box with the name "address" as #form.address# but if the user makes the name of the field "E-Mail" you would think that you would be able to reference it with #form.E-Mail# but cold fusion responds with the error: Invalid parser construct found on line 14 at position 17. ColdFusion was looking at the following text: - Invalid expression format. The usual cause is an error in the expression structure. I have tried escaping it with a "\" and even using the same character twice "--" but nothing works. Could anyone please tell me how to escape a dash from a form element. Thanks! Kevin -- 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.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.
Re: Need help with a SQL query
Right, I'm not gonna address the whole thing (no time at the moment), but a quick word about sub-queries They should be used in 2 ways - one to return a single result; select * from myTable where myValue=(select myValue from myOtherTable where...) Or to return multiple values select * from myTable where myValue in (select myValue from myOtherTable where...) The second is a lot more useful for what you're looking for Right, but I don't see how that helps me. Neither of those two uses of subqueries returns a LIST of values that can be used in a single field of the parent query. For example, if my mapping table looks like so: ItemIDCategoryID -- 11 12 14 22 24 I would like the details query for ItemID 1 to have the following fields: .Name - simply pulled from item table .Desc - simply pulled from item table .CategoryIDs - "1,2,4" I've looked through a couple of my SQL books and haven't found an answer, so maybe this isn't possible (using SQL 6.5, BTW). Its not THAT big of a deal to run two queries. Thanks for the help, Seth Petry-Johnson Argo Enterprise and Associates -- 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.
RE: OT: RE: Looking for junior-level CF developer
I actually agree with this post, because I have been programming for 20 years. In this time I have learnt a lot in the logic of programming, and this would give me the Senior Analyst Programmer status. As I have also been developing in Coldfusion for the last 3 years, I have found that it is the same as any other language. This means that anyone else with the same experience can rightfully claim senior status within weeks of using the language, because the programming logic flows from one language to the next. But for anyone learning programming at the same time as learning with Coldfusion, could also take 6 years to reach senior status. It would all really depend on your knowledge, ability to learn quickly or even how well you lateral think. Also it could take someone constantly working in the industry 3 years and someone who is learning in their spare time 10 years. It depends on the individual, and I for one don't like employers always labelling an individual by the number of years they have worked using a particular language. -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 June 2000 10:40 PM To: '[EMAIL PROTECTED]' Subject: RE: OT: RE: Looking for junior-level CF developer I did not state that I consider this senior. I thought his expectations of what a junior programmer would know to be excessive. In the UK, you are considered 'junior' if you have just come out of University after doing a 3 year Computer degree (and up to a year of industrial experience). A senior would need a minimum of 3 years industrial experience and probably be more like 5 years. Again this is conjecture, as I was working as a computer consultant within 1.5 years of leaving University. It comes down to ability (also your belief in your own abilities). You also have to look at the skill set he was requiring. Most people spend a long time just getting to know one database. Let alone three. I would say that a Junior would have had experience with one serious database (SQL Server or Oracle) and knows Access. Still it is only my honest opinion and in the end it is down to the individual to decide how good they are and run with that. Web development is an odd beast as it requires a broader range of knowledge than most computer programming skills. So in summary: It is up to you to decide if you are 'junior' or not. But if you had that skill set (SQL, Oracle, HTML, Javascript and CF) and where able to demonstrate these effectively with a good understanding of database design, a thorough understanding of CF, HTML and Javascript , and a good user interface design ability, then you can quite happily go become a consultant. Earnings in the South East UK should take you to around £100k a year (about $150k) assuming a 2000 hour year. If you look at my earlier post you will also see that I equated a junior position with having around 1.5 years experience, and even then I think that comes down to the individual. Some people are just natural born programmers :-) -- Archives: http://www.eGroups.com/list/cf-talk 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: How to escape a - in a form post
Well, since a FORM is essentially a struct, you can access you variable by referencing it this way : #FORM["E-Mail"]# I tested it with CFServer 4.5.1 on Solaris, but since this kind of reference can be made also on 4.0, it should work. This won't work in CF 4.01 or earlier. The FORM scope (along with URL and cookie scopes) was created as a structure starting in 4.5. Regards, Seth Petry-Johnson Argo Enterprise and Associates -- 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.
RE: CFMAIL MIMEATTACH
Actually it is very possible with CF 4.5.1 :-) -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 June 2000 1:20 PM To: [EMAIL PROTECTED] Subject: RE: CFMAIL MIMEATTACH It isn't possible to send multiple attachments using CFMAIL. If you need to send multiple attachments, there's a great tag in the Developer's Exchange called CFC_Mail2 which costs $45. It allows you to attach multiple attachments, send BCCs and a bunch of other things. The one thing I haven't gotten it to do yet is send HTML in the body :( However, if you can upgrade to 4.5, then CFMAIL takes a CFMAILPARAM tag inside of it that allows you to attach an attachment, and the CFMAIL tag takes multiple (supposedly unlimited) CFMAILPARAM tags. This is a better solution, but obviously more costly than the $45 for CFX_Mail2. :) CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: ABI Development [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 10:45 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: CFMAIL MIMEATTACH I am using MIMEATTACH with CFMAIL and its working fine. I'm now trying to send two files though and can't seem to get it to work. I've tried comma separating adding an additional MIMEATTACH but it fails. Any suggestions or guidelines for attaching multiple MIME attachments? Thanks, Kelly -- 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.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.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.
Re: Need help with a SQL query
Hi Seth, This book also has info on cross Tabulations which what you want Also there are scripts here http://www.swynk.com/sqlhome/6xlibrary.asp for doing this ... BTW It's an excellent site for SQL ~Justin Have a look at Joe Cleko's books SQL for Smarties . He has lots on these types of relationships IE trees. Also there are lots of SQL functions examples to answer questions like Path Enumeration Finding root and "Leaf " nodes Subtree deletetion etc IMO His books are a must have for "Real World SQL users" :-) Checkem' out at : .http://www.amazon.co.uk/exec/obidos/ASIN/1558604324/qid=961587236/sr=1-1/02 6 -2836789-6296449 http://www.amazon.co.uk/exec/obidos/ASIN/1558603239/qid=961587236/sr=1-3/026 -2836789-6296449 ~ JustinMacCarthy - Original Message - From: Seth Petry-Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 12:11 AM Subject: Need help with a SQL query Sorry about the non-descriptive subject, but I'm tired and really couldn't think of a way to describe my question in one line g. I have a database table of product information and a database table of product category information. Each product may exist in more than one category, so I created a "mappings" table that simply contains ItemID-CategoryID pairs. This is all well and good. I am trying to write a product details query that includes a comma delimited list of the CategoryIDs that the product belongs to. Currently I run two queries: one for the data from the product table and another for the CategoryIDs from the mappings table. Then I create a list of the Category IDs and manually add the list to the query of other product data. Is there a way to get SQL to do this for me in one query? As far as I know subqueries are only useful when they return a single value, which won't quite work here. Any ideas? Thanks in advance, Seth Petry-Johnson Argo Enterprise and Associates -- 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.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.
Re: Searchy thing
As far as I know, the only thing you can extract are the keywords. Here's what I use: CFSEARCH name = "GetResults" collection = "MyCollection" criteria = "FTS_Keywords contains #Form.Criteria#" maxRows = "#Evaluate(Form.MaxRows + 1)#" startRow = "#Form.StartRow#" Regards, Chris - Original Message - From: "Parker, Kevin" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 1:29 AM Subject: RE: Searchy thing Thanks Paul - does anyone know if it is possible to extract the document title, subject, author etc contained in the pdf document's General Info using Verity and CF. The very good example provided by Paul only shows the file's name. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 21 June 2000 3:01:PM To: [EMAIL PROTECTED] Subject: Re: Searchy thing Go to http://www.cbee.org/search.html Enter the key word: safety The first doc is a PDF, the second et al is Word. best, paul At 02:16 PM 6/21/00 +0930, you wrote: Can anyone direct me to any sites that use CF and Verity as a search engine, particularly for indexing PDF and Word files, that I can have a look at. TIA! 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.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.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. 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.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.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.
Re: Need help with a SQL query
Doh, I forgot to add all the where clauses in that last sql thing, but you get the idea where t1.itemid = t2.itemid andt1.itemid = 1 Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- 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.
RE: How to escape a - in a form post
It worked perfectly. Thank you so much Frédéric Frédéric LeMieux [EMAIL PROTECTED] 06/21/00 07:55AM Well, since a FORM is essentially a struct, you can access you variable by referencing it this way : #FORM["E-Mail"]# I tested it with CFServer 4.5.1 on Solaris, but since this kind of reference can be made also on 4.0, it should work. -Original Message- From: Kevin Pechin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 6:35 PM To: [EMAIL PROTECTED] Subject: How to escape a "-" in a form post Hi, I have to make a general form that takes a user defined form element such as a text field and put it into an email. I have everything working except if a user creates a form with an input field named with a dash (-) cold fusion treats it as a subtraction and returns an error when i try to access the variable. I need to be able to reference the variable on the following page. For example i would normally reference a form variable such as a text box with the name "address" as #form.address# but if the user makes the name of the field "E-Mail" you would think that you would be able to reference it with #form.E-Mail# but cold fusion responds with the error: Invalid parser construct found on line 14 at position 17. ColdFusion was looking at the following text: - Invalid expression format. The usual cause is an error in the expression structure. I have tried escaping it with a "\" and even using the same character twice "--" but nothing works. Could anyone please tell me how to escape a dash from a form element. Thanks! Kevin -- 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.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.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Streaming audio
Has anyone here ever made a CF site that involves on-demand streaming audio? If so, what streaming server did you use? Does CF have any effect on server choices, etc.? .Todd -- 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.
Re: images, cold fusion, and sql server
Chad, Do yourself a favour and don't store the image in the database. Its probably faster to just reference the image name and parameters (height and width). Put the images in a directory that is not on the web server. Then use CFFile and CFContent to get the path and to display the images. hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- chad wrote: i am creating an image database with cold fusion using sql server 7. does anyone know about the performance of using cold fusion to retrieve and display in a web browser images from inside a SQL database, or from an NT directory? i need to make a decision on what is faster, and more efficient.storing and retrieving the images from within the database or just referencing the file in the database and pointing it to a directory on the server. Security is also a concern. regards chad -- 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.
RE: Streaming audio
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone here ever made a CF site that involves on-demand streaming audio? If so, what streaming server did you use? Does CF have any effect on server choices, etc.? We're using Windows Media Services w/ CF. We chose WMS over (Un)RealServer for two reasons: 1) PRICE! and 2) Real has had some nasty security / DoS exploits in recent months (Check out the archives at NTBugTraq if you haven't seen them). Our authentication isn't as good as it could be, unfortunately. Currently members login, and their IP is added to the list of allowed video IPs on the video server via a call to CFRegistry. When their sessions expire, we have a garbage collection routine that removes the IPs from the registry. Not great, but functional... On our list of Things to Do, we would like to write an authentication filter for WMS that would authenticate each user when they connect to the video server. WMS allows you to write DLLs which handle all the auth work basically return 'Yea' or 'Nay' to the video server. We want to produce something that would grab the user's CFID CFTOKEN cookies, connect to our SQL Server, and see if those IDs were currently valid in the Client variable store. Shouldn't be too difficult, right?... We use our system for streaming video, but there's no reason the exact same system wouldn't support streaming audio for your needs. Best regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original message in any replies -- I get a lot of email every day, and I have a REALLY bad memory... So I don't always remember everything that was said. Thanks! -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVDHeAraVoMWBwRBEQJPZQCbB9Fg5XwkJf5n8pRmE051XiNXzMUAoNhw kMfZLdYFhyfWwKxfNMY6r/bv =iSJj -END PGP SIGNATURE- -- 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.
K12 school application
Anyone know of an application in cf for schools? K-12 would be good, but college would be useful too. I'm trying to help out a local school district. They have cold fusion, but are just getting started. I'm thinking about things like school calendar, classes, teachers, staff, organizations, cirriculum, class scheduling with things like homework assignments, requirements, and so on. It seems like such a thing should be available, but I haven't found one yet. The Michigan Department of Education seems to have a knowledge base written in cf, but so far I can't find a school admin system there. -- 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.
Re: Streaming audio
No information about any possible problems with Cf here but this article from developer.com may help a little if youre using iis http://developer.earthweb.com/journal/techworkshop/060900_stream.html - Original Message - From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 2:40 PM Subject: Streaming audio Has anyone here ever made a CF site that involves on-demand streaming audio? If so, what streaming server did you use? Does CF have any effect on server choices, etc.? .Todd -- 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.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.
RE: Database Design Question
Brook, I'd recommend buying SQL for Smarties by Joe Celko. There's a couple of chapter specifically on ways to handle hierarchy data w/different database systems. I really like the "Nested-Set Model." The nice thing about the Nested-Set model is that you can do all your tree parsing/order via SQL-no need to manipulate the data via CF (which you have to do when simply storing the parent ID.) -Dan -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 7:42 PM To: [EMAIL PROTECTED] Subject: Database Design Question I have listings that look like: 1.0 foobars 1.1 foobars the revenge 1.1.2 foobars the revenge II 1.1.2.1 more foobar specials 2.0 brown foobars 3.0 green foobars etc.. What is the best DB design in terms of performance for a classification system like this? Thanks, Brook Davies MaracasMedia Inc. -- 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.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.
Re: Database Design Question
Ben Forta wrote an SQL book last year - published by SAMS. I think it's Learn SQL in 10 Minutes. 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 - Original Message - From: Dan G. Switzer, II [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 10:04 AM Subject: RE: Database Design Question Brook, I'd recommend buying SQL for Smarties by Joe Celko. There's a couple of chapter specifically on ways to handle hierarchy data w/different database systems. I really like the "Nested-Set Model." The nice thing about the Nested-Set model is that you can do all your tree parsing/order via SQL-no need to manipulate the data via CF (which you have to do when simply storing the parent ID.) -Dan -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 7:42 PM To: [EMAIL PROTECTED] Subject: Database Design Question I have listings that look like: 1.0 foobars 1.1 foobars the revenge 1.1.2 foobars the revenge II 1.1.2.1 more foobar specials 2.0 brown foobars 3.0 green foobars etc.. What is the best DB design in terms of performance for a classification system like this? Thanks, Brook Davies MaracasMedia Inc. -- -- -- 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.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.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.
RE: MDAC 2.5 - i don't think so
Me too. I initially DID have problems with MDAC 2.5, when I first installed it. I wound up using the component checker from Microsoft to uninstall it ( see my article in Fusion Authority entitled "What to Do When You're Having Trouble with an MDAC Installation" http://www.fusionauthority.com/alert/index.cfm?alertid=21 ) My guess is that your installation might not have gone well. Although it isn't made clear in the install instructions, you really need to shut down all non-essential services on the server before installing an MDAC. As a precaution, I would also run the component checker after the installation just to make sure the right files made it in. Note: component checker always seems to come up with a few "false positives" for mismatched files. Be sure and see the docs for which ones of these are acceptable and which aren't. Hopefully, you don't have a need for MDAC 2.5 so that you don't have to bother with any of this. HTH, Eron -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 6:59 AM To: [EMAIL PROTECTED] Subject: Re: MDAC 2.5 - i don't think so On 6/20/00, Ric Smith penned: Just so you all know, I installed MDAC 2.5 on my production server (cf 4.5,nt4 sp6a) and access didn't like it one bit. I don't know if it's just my machine or what, but I reinstalled 2.1 and everything is happy again. The error I got was something like ODBC Access Error (unknown) Access loves it on mine. :) 4.1, NT4, sp5 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- 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.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.
Setting Fonts for CFTable
This is a multi-part message in MIME format. --=_NextPart_000_001A_01BFDB6A.0CA7C0C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, Is there a way to set fonts for CFTable? I don't see any examples in = the books. Do I have to use HTML table and if so how to format output? =20 Font size=3D2 CFTable. ?Font dosen't seem to work. TIA. Regards, Paige OutPut table code follows: CFOUTPUT Query=3D'GetData' MaxRows=3D1 !--- CFTable Query=3D'GetData' MaxRows=3D1 HTMLTable ColHeaders --- HR /HR #Cli_ID##Ins_ID# #Ins_First1# #Ins_Last1# #Ins_PropID# = #Status##Ins_MailCD#=20 HR /HR Font size=3D2 CFTable Query=3D'Getdata' HTMLTable=3D"Yes" Border ColHeaders=20 CFCOL Text=3D"#Ins_Type#" Header=3D"Type" CFCOL Text=3D"#Policy_No#" Header=3D"Policy No." CFCOL Text=3D#DateFormat(Issued_Dat, "mm/dd/")# = Header=3D"Issued" CFCOL Text=3D#DateFormat(Cancel_Dat, "mm/dd/")# = Header=3D"Canceled" CFCOL Text=3D#DateFormat(Expire_Dat, "mm/dd/")# = Header=3D"Expired" CFCOL Text=3D#NumberFormat(Req_Value1,"__,___,___")# Header=3D"Req1" CFCOL Text=3D#NumberFormat(Act_Value1,"__,___,___")# Header=3D"Act1" CFCOL Text=3D#NumberFormat(Req_Value2,"__,___,___")# Header=3D"Req2" CFCOL Text=3D#NumberFormat(Act_Value2,"__,___,___")# Header=3D"Act2" CFCOL Text=3D#NumberFormat(Req_Value3,"__,___,___")# Header=3D"Req3" CFCOL Text=3D#NumberFormat(Act_Value3,"__,___,___")# Header=3D"Act3" CFCOL Text=3D"#Pol_Status#" Header=3D"Status" /CFTABLE /Font /CFOUTPUT P ICENTERA HREF=3D'CVS3WP02.CFM'Submit Another = Search?/A/CENTER/I=20 --=_NextPart_000_001A_01BFDB6A.0CA7C0C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2Hi All,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Is there a way to set fonts for = CFTable?nbsp; I=20 don't see any examples in the books. Do I have to use HTML table and if = so how=20 to format output?nbsp; /FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2lt;Font size=3D2gt;/FONT/DIV DIVFONT face=3DArial size=3D2lt;CFTable./FONT/DIV DIVFONT face=3DArial size=3D2lt;?Fontgt;/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2dosen't seem to work. /FONTFONT = face=3DArial=20 size=3D2TIA./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Regards,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Paige/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2OutPut table code follows:/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2lt;CFOUTPUT Query=3D'GetData'=20 MaxRows=3D1gt;BRlt;!--- lt;CFTable Query=3D'GetData' MaxRows=3D1 = HTMLTable=20 ColHeadersgt; ---gt;BRlt;HRgt;=20 lt;/HRgt;BRnbsp;#Cli_ID#nbsp;nbsp;nbsp; = #Ins_ID#nbsp;nbsp;nbsp;nbsp;=20 #Ins_First1# #Ins_Last1#nbsp;nbsp;nbsp;nbsp; #Ins_PropID#nbsp;=20 #Status#nbsp;nbsp;nbsp; #Ins_MailCD# BRlt;HRgt; = lt;/HRgt;/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2lt;Font = size=3D2gt;BRnbsp;lt;CFTable=20 Query=3D'Getdata' HTMLTable=3D"Yes" Border ColHeadersgt; = BRnbsp;nbsp;lt;CFCOL=20 Text=3D"#Ins_Type#" Header=3D"Type"gt;BRnbsp;nbsp;lt;CFCOL = Text=3D"#Policy_No#"=20 Header=3D"Policy No."gt;BRnbsp;nbsp;lt;CFCOL = Text=3D#DateFormat(Issued_Dat,=20 "mm/dd/")# Header=3D"Issued"gt;BRnbsp; lt;CFCOL=20 Text=3D#DateFormat(Cancel_Dat, "mm/dd/")#=20 Header=3D"Canceled"gt;BRnbsp;nbsp;lt;CFCOL = Text=3D#DateFormat(Expire_Dat,=20 "mm/dd/")# Header=3D"Expired"gt;BRnbsp;nbsp;lt;CFCOL=20 Text=3D#NumberFormat(Req_Value1,"__,___,___")#=20 Header=3D"Req1"gt;BRnbsp;nbsp;lt;CFCOL=20 Text=3D#NumberFormat(Act_Value1,"__,___,___")#=20 Header=3D"Act1"gt;BRnbsp;nbsp;lt;CFCOL=20 Text=3D#NumberFormat(Req_Value2,"__,___,___")#=20 Header=3D"Req2"gt;BRnbsp;nbsp;lt;CFCOL=20 Text=3D#NumberFormat(Act_Value2,"__,___,___")#=20 Header=3D"Act2"gt;BRnbsp;nbsp;lt;CFCOL=20 Text=3D#NumberFormat(Req_Value3,"__,___,___")#=20 Header=3D"Req3"gt;BRnbsp;nbsp;lt;CFCOL=20 Text=3D#NumberFormat(Act_Value3,"__,___,___")#=20 Header=3D"Act3"gt;BRnbsp;nbsp;lt;CFCOL Text=3D"#Pol_Status#"=20 Header=3D"Status"gt;BRnbsp;lt;/CFTABLEgt;BRlt;/Fontgt;BRlt;/= CFOUTPUTgt;BRlt;Pgt;/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2lt;Igt;lt;CENTERgt;lt;A=20 HREF=3D'CVS3WP02.CFM'gt;Submit Another = Search?lt;/Agt;lt;/CENTERgt;lt;/Igt;=20 BR/FONT/DIV/BODY/HTML --=_NextPart_000_001A_01BFDB6A.0CA7C0C0-- -- 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.
RE: IIS sharing on IP address
with IIS, the three things that make up a "site's ID" are IP address, port, and host header. change any one of these, and it's a "new" site. however, host headers are a bit sticky. the client browser needs to know how to use them (essentially 3+ browsers here) and the client box has to "know" about the host header (which usually entails modifying the hosts file.) these are usually only a good idea for "internal" site separation. Chris Olive, DOEHRS Website Administrator -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 10:17 AM To: '[EMAIL PROTECTED]' Subject: OT: IIS sharing on IP address I have been looking through the help though I am not sure exactly what to search on. What i want to do is have as many domains as I want sharing on ip address, though i can't find out how to go about doing this. Anyone who knows how to do it would be greatly appreciated. Bob Everland -- 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.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.
Re: K12 school application
Dan- i am rod tosten from Gettysburg College and CNAV Systems. We have a system that i believe fullfills your needs. i feel uncomfortable "advertising" on this list, please contact me. thanks, -rod Rod Tosten Associate Professor of Computer Science Gettysburg College Programmer/Architect CNAV Systems, www.cnavsystems.com Gettysburg, PA 17325 [EMAIL PROTECTED] Phn: 717-337-8525 At 03:51 AM 06/21/2000 -0700, you wrote: Anyone know of an application in cf for schools? K-12 would be good, but college would be useful too. I'm trying to help out a local school district. They have cold fusion, but are just getting started. I'm thinking about things like school calendar, classes, teachers, staff, organizations, cirriculum, class scheduling with things like homework assignments, requirements, and so on. It seems like such a thing should be available, but I haven't found one yet. The Michigan Department of Education seems to have a knowledge base written in cf, but so far I can't find a school admin system there. -- 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.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.
RE: K12 school application
My sister has actually put something together at webassignment.com in Cold Fusion. It has a templates for interactive assignments (DHTML fill in the blanks, matching, concentration), database-driven homework submissions and retrieval, a school calendar, DHTML seating charts, automatic grading and student tracking, gradebooks, reporting features, assignment sharing, community features, and a bunch of other stuff. The front end doesn't looks so hot, and it needs an interface makeover, but the functionality is all there, and is already in use in a couple of classes at one school. There should be a sample login at the address. If you have any problems or questions, you can contact me off-list (my sister just had a kid two days ago, and is not checking email). Michael Caulfield -Original Message- From: Dan Schueler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 5:52 AM To: [EMAIL PROTECTED] Subject: K12 school application Anyone know of an application in cf for schools? K-12 would be good, but college would be useful too. I'm trying to help out a local school district. They have cold fusion, but are just getting started. I'm thinking about things like school calendar, classes, teachers, staff, organizations, cirriculum, class scheduling with things like homework assignments, requirements, and so on. It seems like such a thing should be available, but I haven't found one yet. The Michigan Department of Education seems to have a knowledge base written in cf, but so far I can't find a school admin system there. -- 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.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.
solaris
Hello everyone, Could someone please tell me how to configure ODBC from solaris 7(Sun) to Novell? The unix commands... Thanks, Nehal -- -- -- 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.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.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.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.
CF 404
Hi again, Does anyone know how does one go about making CF Server use a modified .cfm to replace the CF 404 Not Found error? Thanks, Nehal 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.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.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.
RE: Need help with a SQL query
Right, I'm not gonna address the whole thing (no time at the moment), but a quick word about sub-queries They should be used in 2 ways - one to return a single result; select * from myTable where myValue=(select myValue from myOtherTable where...) Or to return multiple values select * from myTable where myValue in (select myValue from myOtherTable where...) The second is a lot more useful for what you're looking for Right, but I don't see how that helps me. Neither of those two uses of subqueries returns a LIST of values that can be used in a single field of the parent query. For example, if my mapping table looks like so: ItemIDCategoryID -- 11 12 14 22 24 I would like the details query for ItemID 1 to have the following fields: .Name - simply pulled from item table .Desc - simply pulled from item table .CategoryIDs - "1,2,4" I've looked through a couple of my SQL books and haven't found an answer, so maybe this isn't possible (using SQL 6.5, BTW). Its not THAT big of a deal to run two queries. I must have mis-understood what you wanted - I had assumed that you wanted all select all categoried that were related to one product category - it'd probably be easier to run 2 queries (from what I see you want - again, I could be mis-understanding) BTW a sub query effectively makes a comma separated list if it returns more than one record, so the IN would work rather than the = 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.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.
Re: OT: IIS sharing on IP address
create a new web site. assign to the IP address. After created go into the properties, and add the header information for the domain. pretty simple. I think there is an "advanced" button next to IP address information (not in front of me, short attention span ...) easier to use on Win2K. HTH Eric From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 10:17:29 -0400 I have been looking through the help though I am not sure exactly what to search on. What i want to do is have as many domains as I want sharing on ip address, though i can't find out how to go about doing this. Anyone who knows how to do it would be greatly appreciated. Bob Everland -- 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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.
DDE in CF
Hi All, I'm new to Cold Fusion, so, please forgive me if this is a stupid question. I'm trying to do DDE or OLE in cold fusion (communicating with MS Word or Excel) Please let me know if this is possible in CF and if it is, where can I find info. about it. Thank you, Dmitry -- 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.
Re: K12 school application
You might want to check with the George Washington University. Their Prometheus system was developed in CF and does what you want. Its showcased at the allaire site in the case studies section. larry Dan Schueler wrote: Anyone know of an application in cf for schools? K-12 would be good, but college would be useful too. I'm trying to help out a local school district. They have cold fusion, but are just getting started. I'm thinking about things like school calendar, classes, teachers, staff, organizations, cirriculum, class scheduling with things like homework assignments, requirements, and so on. It seems like such a thing should be available, but I haven't found one yet. The Michigan Department of Education seems to have a knowledge base written in cf, but so far I can't find a school admin system there. -- 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. -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- -- 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.
Re: CF 404
Does anyone know how does one go about making CF Server use a modified .cfm to replace the CF 404 Not Found error? You can define Missing Template Handler (and Site-wide Error Handler) file in CF Administrator (version 4.5 and up). Erki -- 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.
CFX execution time
Hello. I have Delphi-built cfx that takes 2 integers and returns them to me multiplied with a status code. Is it normal for a simple cfx like that to take more than 2 seconds to process? Thing is, a more complex cfx which does a complex calculation involving a third-party dll and binary files holding data takes approx. the same time. Is there really an almost 2 s overhead for cfx tags? All this in NT4, CF 4.01, 512 Mb RAM, with no significant load on the machine and using the standard delphi framework as described in the Forta book. Michel Vuijlsteke Netpoint NV -- 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.
RE: COM object/Interface problems
I gave it a try, and it didn't work. The program runs, but nothing happens. Russel -Original Message- From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 5:26 AM To: [EMAIL PROTECTED] Subject: Re: COM object/Interface problems Try using cfx_spawn from Intrafoundation.com ~J - Original Message - From: Russel Madere [EMAIL PROTECTED] To: Cf Talk [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 2:59 AM Subject: COM object/Interface problems Does Cold Fusion implement COM objects/interfaces differently from the command line? I have a command line program that works fine. When I run the exact same program with the CFEXECUTE tag, and the same attributes, it does not work. When I look into the resulting files (shortcuts) there is a critical part missing that causes them not to work properly. Any help would be appreciated. Russel Madere -- 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.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.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.
RE: Nesting cfswitch possible?
Ya, a long time ago, but mine was about time penalty's in doing so. I was looking for any pro's or cons on the time it takes to execute LARGE switch statements. I have been using nested switch statements for some time. I just wanted to know if I should be doing it some other way and have since learned that I am doing it the best way. Thanks -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 20, 2000 2:28 PM To: [EMAIL PROTECTED] Subject: RE: Nesting cfswitch possible? didn't you have a question about nesting switches? -Original Message- From: Bill Killillay [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 11, 2000 1:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Nesting cfswitch possible? Yes! -Original Message- From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 08, 2000 1:06 PM To: Cf-Talk@Houseoffusion. Com Subject: Nesting cfswitch possible? Is it possible to nest cfswitch tags? Cyrill Vatomsky LinguaCom -- 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.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.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.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.
Re: Oracle vs SQL server
At 01:18 PM 6/21/2000 +0200, you wrote: Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? Just to be contrary, I'd put my vote in for Sybase. Great database, reasonably decent company to work with (especially compared to Microsoft and Oracle), and a good price point. Judah -- 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.
CFCONTENT Internet Explorer
Hello Everyone, I have a problem with CFCONTENT, whenever I retrieve a PDF file using CFCONTENT, my internet explorer thinks is a CFM page. I visited allaire's website and they have a workaround which is specifying my link as: http://www.website.com/file.cfm/file.pdf?docId=101010rev=G This seems to make it download, however my AdobeAcrobat reader does not launch, but some ActiveX square. If I call: http://www.website.com/files/doc1.pdf directly, then it launches ADobe plugins. Any suggestions? I want to use CFCOntent since it provides the Delete File option, which deletes the file as soon as it gets downloaded, as of now I'm using redirection in order to get the pdf file. BTW, I am running CF PRO 4.0.1 with NT4.0/SP4 Thank you all in advance. Percy E Perez -- 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.
Re: OT: IIS sharing on IP address
As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- 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.
äãéîòî ä÷éèñéèèñì úéæëøîä äëùìä
Is there a way to have CF store input to a form in another language besides english( like : Arabic, Japanese, chinese etc) in SQL Server database? Thanks A lot __ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/ -- 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.
Re: CFX execution time
Is the CFX set to remain loaded in memory? ~Justin - Original Message - From: Michel Vuijlsteke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 4:21 PM Subject: CFX execution time Hello. I have Delphi-built cfx that takes 2 integers and returns them to me multiplied with a status code. Is it normal for a simple cfx like that to take more than 2 seconds to process? Thing is, a more complex cfx which does a complex calculation involving a third-party dll and binary files holding data takes approx. the same time. Is there really an almost 2 s overhead for cfx tags? All this in NT4, CF 4.01, 512 Mb RAM, with no significant load on the machine and using the standard delphi framework as described in the Forta book. Michel Vuijlsteke Netpoint NV -- 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.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.
Re: äãéîòî ä÷éèñéèèñì úéæëøîä äëùìä
CF doesn't support Unicode at this time. However I believe the next release will. ~JustinMacCarthy - Original Message - From: jonathan hamner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 5:19 PM Subject: äãéîòî ä÷éèñéèèñì úéæëøîä äëùìä Is there a way to have CF store input to a form in another language besides english( like : Arabic, Japanese, chinese etc) in SQL Server database? Thanks A lot __ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/ -- 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.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.
RE: OT: IIS sharing on IP address
How do you go about writing the header information, do you put the url there, or do you put the folder. That's the only thing I can't figure out. It doesn't say specifically in the documentation on what to do. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- 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.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.
SQL convert
Getting an error message in a SQL statement...any help is appreciated. select CONVERT(decimal(5,2),base_1) as Price from product_price product_price.base_1 is varchar 255 gives this error message: Msg 8114, Level 16, State 2 Error converting type varchar to type numeric. Brian D. Horn Society of Financial Service Professionals Information Systems Group 610-526-2500 mailto:[EMAIL PROTECTED] -- 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.
Re:
Is there a way to have CF store input to a form in another language besides english( like : Arabic, Japanese, chinese etc) in SQL Server database? alphabet based languages in or out of unicode are pretty straightforward. multi-byte character ones like chinese japanese are another story. if you don't display these (these being alphabet based languages) all on the same page then should be no problem processing non-english text w/cf. -- 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.
RE: SQL convert
Perhaps a value in the base_1 field is not convertible to numeric? (non-digit) -Original Message- From: Brian Horn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:30 PM To: '[EMAIL PROTECTED]' Subject: SQL convert Getting an error message in a SQL statement...any help is appreciated. select CONVERT(decimal(5,2),base_1) as Price from product_price product_price.base_1 is varchar 255 gives this error message: Msg 8114, Level 16, State 2 Error converting type varchar to type numeric. Brian D. Horn Society of Financial Service Professionals Information Systems Group 610-526-2500 mailto:[EMAIL PROTECTED] -- 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.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.
CF updating values in database
This is a multi-part message in MIME format. --0744F58F5C26C4A7D1D9CDD6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello everyone - thanks for provind an interesting list to read. I have now summoned the courage to make a posting, here's my question: I have a web application where a user can enter information (mainly from their CV) into a form where it is then inserted into a table in my database. The user (plans are for a yearly update where it's a CV we're dealing with) can return to the web site anytime in the future and make additions to her/his data. I have accomplished this (using VALUE=, etc.) with my text input fields and text areas (still a little trouble showing a checked radio button from the query but that will come in time). My trouble is that while I want the user to add info to that info currently on file, I do not want to user to be able to edit the information currently on file - I simply want the new data appended to the top of the exisiting information (for example, there's a "publications" field - they could see the publications from previous years, and add this years' to the top of that textarea without being able to edit the old data). I'm sure that there is a simple and easy solution to this? this years' info + info currently on file = updated field in database Thanks in advance for any assistance offered. Jamie --0744F58F5C26C4A7D1D9CDD6 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Symonds, James A. Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: James A. Symonds n: Symonds;James A. org:CompTech Crdntr, StFX Students' Union; Intern w/Prof. Blackwell; Intern w/Acdmc Fndng Rsrch; TSG Lab Assistant adr:Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada email;internet: [EMAIL PROTECTED] title: Bachelor of Info Sys, Major (student) x-mozilla-cpt: ;0 x-mozilla-html: TRUE version:2.1 end:vcard --0744F58F5C26C4A7D1D9CDD6-- -- 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.
MAC error
I have an app with a self-posting template. There are 2 different ways it is submitted. Selecting an option from a select list and the onchange event, and a submit button. Both form object have a value associated with it. The template works fine in IE and NS WIN, but on the MAC, when I select an option from the select list, the submit button value is passed also, and consequently, takes the wrong logical path. Dan O'Keefe -- 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.
Looping through a structure
When I run the code below, the keys are outputted in alphabetic order, not the order that they are in the structure (which is of course what I am after). Can someone point me in the right direction ... *please*? And while we're at it ... is there a way I can output the name of the structure without using CFSET stSwatch.name="#qGetDetails.name#" or another CFLOOP? THANKS CFLOOP QUERY="qGetDetails" CFSET Swatch="#qGetDetails.name#" CFSET stSwatch=StructNew() CFSET stSwatch.name="#qGetDetails.name#" CFSET stSwatch.family="#qGetDetails.family#" CFSET stSwatch.style="#qGetDetails.style#" CFSET stSwatch.width="#qGetDetails.width#" CFSET stSwatch.linYd="#qGetDetails.linYd#" CFSET stSwatch.sqYd="#qGetDetails.sqYd#" CFSET stSwatch.content="#qGetDetails.content#" CFSET stSwatch.stretch="#qGetDetails.stretch#" CFSET stSwatch.increment="#qGetDetails.increment#" /CFLOOP CFLOOP COLLECTION="#stSwatch#" ITEM="key" CFOUTPUT #key#: BR /CFOUTPUT /CFLOOP -- Tim Bahlke, CIFO Graphica www.thinkcreate.com p.336.230.0575 f. 336.230.0083 -- 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.
Re: Streaming audio
Is there any way of controlling access to the realmedia server, like writing in a table what users do or do not have access ? Also can you control from CF what point in a file the player should jump to. That is : create a link in CF that will instruct the realuadio player to open a specific file and to start playing from 1 minute 43 seconds in that file for instance. - Original Message - From: "Nick Call" [EMAIL PROTECTED] Todd: I am buried up to my eyeballs in streaming A/V content right now, with access controlled by CF Long story shortened, go with Real Networks. -- 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.
RE: Oracle vs SQL server
Free on Linux even. ;-) -Original Message- From: Judah McAuley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:05 PM To: [EMAIL PROTECTED] Subject: Re: Oracle vs SQL server At 01:18 PM 6/21/2000 +0200, you wrote: Hi everyone. We're using SQL server 7.0 and it's working great. The DoD recently purchases a site license for the entire DoD for Oracle. My question is should I move my SQL server DB to Oracle? Just to be contrary, I'd put my vote in for Sybase. Great database, reasonably decent company to work with (especially compared to Microsoft and Oracle), and a good price point. Judah -- 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.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.
RE: OT: IIS sharing on IP address
if I understand correctly. you have to go in after creating the website in IIS and rightclick properties. on the first page, you'll have to hit an advanced button or something like that to get to where you can enter the header informtion. HTH From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 12:31:31 -0400 How do you go about writing the header information, do you put the url there, or do you put the folder. That's the only thing I can't figure out. It doesn't say specifically in the documentation on what to do. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- 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.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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.
Re: OT: IIS sharing on IP address
you need to specify the url (without the http://) ie mysite.com www.mysite.com -- Stephenie Hamilton ColdFusion Administrator Express Technologies, Inc. Want CF_Freedom? try CFXHosting.com - Original Message - From: Eric Dawson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 12:50 PM Subject: RE: OT: IIS sharing on IP address if I understand correctly. you have to go in after creating the website in IIS and rightclick properties. on the first page, you'll have to hit an advanced button or something like that to get to where you can enter the header informtion. HTH From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 12:31:31 -0400 How do you go about writing the header information, do you put the url there, or do you put the folder. That's the only thing I can't figure out. It doesn't say specifically in the documentation on what to do. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- -- -- 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.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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.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.
Re: Need help with a SQL query
If all you want is a comma seperated list of the categories for each item. Why not just add a "categories" field to the item table? Store the comma seperated list there. --K Katrina Chapman Consultant Ameriquest Mortgage "Seth Petry-Johnson" To: [EMAIL PROTECTED] seth@argoentercc: prise.com Subject: Re: Need help with a SQL query 06/21/00 05:48 AM Please respond to cf-talk Right, I'm not gonna address the whole thing (no time at the moment), but a quick word about sub-queries They should be used in 2 ways - one to return a single result; select * from myTable where myValue=(select myValue from myOtherTable where...) Or to return multiple values select * from myTable where myValue in (select myValue from myOtherTable where...) The second is a lot more useful for what you're looking for Right, but I don't see how that helps me. Neither of those two uses of subqueries returns a LIST of values that can be used in a single field of the parent query. For example, if my mapping table looks like so: ItemIDCategoryID -- 11 12 14 22 24 I would like the details query for ItemID 1 to have the following fields: .Name - simply pulled from item table .Desc - simply pulled from item table .CategoryIDs - "1,2,4" I've looked through a couple of my SQL books and haven't found an answer, so maybe this isn't possible (using SQL 6.5, BTW). Its not THAT big of a deal to run two queries. Thanks for the help, Seth Petry-Johnson Argo Enterprise and Associates -- 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.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.
ODBC User Directories
Greetings all, Has anyone had any luck creating an ODBC User Directory through the Advanced Security using Cold Fusion Server 4.0.1? I followed all the examples from the docs to the letter, and am now picking my brain to try other options to no avail. I've tried using Access and SQL databases, but I cannot see my user list when adding users to policies. Any help would be great! Thanks. David Brooks PC Pros, Inc. -- 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.
RE: OT: IIS sharing on IP address
What I'm asking is say I make it up the ip address is 192.168.0.2 the port is 80 and the header is www.here.com, what do I call the folder to keep the website in. Do I call it what I called my header, and do I make 2 headers, one for www.here.com and here.com or just have my DNS refer to it. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:51 PM To: [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address if I understand correctly. you have to go in after creating the website in IIS and rightclick properties. on the first page, you'll have to hit an advanced button or something like that to get to where you can enter the header informtion. HTH From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 12:31:31 -0400 How do you go about writing the header information, do you put the url there, or do you put the folder. That's the only thing I can't figure out. It doesn't say specifically in the documentation on what to do. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- 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.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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.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.
URL parameter and Frames
Is there a secret to accessing a URL parameter from a deeply nested frame? Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- 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.
RE: OT: IIS sharing on IP address
if I understand correctly. you have to go in after creating the website in IIS and rightclick properties. on the first page, you'll have to hit an advanced button or something like that to get to where you can enter the header informtion. That's just about right. The advanced button opens up a window that allows you to add and/or edit site identities (consisting of IP, Port, and Host Header combo.) You would edit the existing entry and specify www.site1.com in the host header field. By the way, it should be noted that SSL does not support host headers, so if you are using SSL, you need a distinct IP address for each site. - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http://www.dealstream.com http://www.mergernetwork.com -- 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.
Amazon Tags
Hey all, I've come across a few interesting tags for searching through Amazon's books and such but what I really need is something which allows me to actually select individual books and display those on the site. I was thinking, something where I could just enter the product id form Amazon, and the tag would go and fetch all the information from them on that book. Has anyone come up with an easy way to do this, or do you know of any custom tags that does this? Any help on this would be greatly appreciated. Stuart Duncan. -- 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.
RE: OT: IIS sharing on IP address
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What I'm asking is say I make it up the ip address is 192.168.0.2 the port is 80 and the header is www.here.com, what do I call the folder to keep the website in. Do I call it what I called my header, and do I make 2 headers, one for www.here.com and here.com or just have my DNS refer to it. Call it anything you want, just don't call ME late to dinner But seriously... (I'm assuming you're configuring IIS, not using the CFML trick that someone posted a few messages ago.) When you're using host headers w/ IIS, you will have entirely separate servers for each host you setup. You set the root directory of each of those servers to whatever you like. There's no "magic" to wory about w/ the directory naming. And I'm not sure, but I *think* you need to make two host header entries -- one with one without the 'www.'. Hope that's helpful. Do be careful using host headers, tho. They're far less reliable than using separate IPs. I'd consider them accessable for internal stuff or for personal sites, but I would NEVER rely on them for a publicly accessable site that might actually be accessed by paying customers... Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVD7EQraVoMWBwRBEQL0dgCgnrWy1gzvHuRHFyK7k19tbnUBVS8AnRGd dgeHVpqu9SSzp9FNZaHjGLQt =9VKH -END PGP SIGNATURE- -- 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.
RE: OT: IIS sharing on IP address
You setup one site and make sure you use the advanced properties in that v-server to specify the headers for that domain (www. , ww. ,ww3. etc...) Once that is configured, you just point all of the DNS to that IP. Kent Runyan Konnections, Inc. www.konnections.com -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 11:22 AM To: '[EMAIL PROTECTED]' Subject: RE: OT: IIS sharing on IP address What I'm asking is say I make it up the ip address is 192.168.0.2 the port is 80 and the header is www.here.com, what do I call the folder to keep the website in. Do I call it what I called my header, and do I make 2 headers, one for www.here.com and here.com or just have my DNS refer to it. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:51 PM To: [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address if I understand correctly. you have to go in after creating the website in IIS and rightclick properties. on the first page, you'll have to hit an advanced button or something like that to get to where you can enter the header informtion. HTH From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 12:31:31 -0400 How do you go about writing the header information, do you put the url there, or do you put the folder. That's the only thing I can't figure out. It doesn't say specifically in the documentation on what to do. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- -- -- 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.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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.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.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.
RE: OT: IIS sharing on IP address
At 01:27 PM 6/21/2000 -0400, Zac wrote: Hope that's helpful. Do be careful using host headers, tho. They're far less reliable than using separate IPs. I'd consider them accessable for internal stuff or for personal sites, but I would NEVER rely on them for a publicly accessable site that might actually be accessed by paying customers... Best regards, Zac Bedell I use host headers all the time. I have found them to be very reliable and easier to manage than hundreds of IP addresses. If I have to add a new IP address to my server, it requires a reboot. If I point a new domain at an existing address, no reboot and a simple IIS config. Do make sure to add entries for both mydomain.com and www.mydomain.com as I hate it as a user when mydomain.com doesn't work. Hope this helps. Judah -- 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.
Re: CFX execution time
I used to do a make shift execution time for some pseudo webtrends logging. I would set a time in the application.cfm and set a time in onendrequest and compare the two. It would have a small margin of error, but not much. Thanks, Neil - Original Message - From: "Michel Vuijlsteke" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 11:21 AM Subject: CFX execution time Hello. I have Delphi-built cfx that takes 2 integers and returns them to me multiplied with a status code. Is it normal for a simple cfx like that to take more than 2 seconds to process? Thing is, a more complex cfx which does a complex calculation involving a third-party dll and binary files holding data takes approx. the same time. Is there really an almost 2 s overhead for cfx tags? All this in NT4, CF 4.01, 512 Mb RAM, with no significant load on the machine and using the standard delphi framework as described in the Forta book. Michel Vuijlsteke Netpoint NV -- 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.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.
RE: OT: IIS sharing on IP address
AFAIK, you can not use SSL with host headers, as SSL requires binding to a specific IP address. -Original Message- From: Zachary Bedell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 1:28 PM To: '[EMAIL PROTECTED]' Subject: RE: OT: IIS sharing on IP address -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What I'm asking is say I make it up the ip address is 192.168.0.2 the port is 80 and the header is www.here.com, what do I call the folder to keep the website in. Do I call it what I called my header, and do I make 2 headers, one for www.here.com and here.com or just have my DNS refer to it. Call it anything you want, just don't call ME late to dinner But seriously... (I'm assuming you're configuring IIS, not using the CFML trick that someone posted a few messages ago.) When you're using host headers w/ IIS, you will have entirely separate servers for each host you setup. You set the root directory of each of those servers to whatever you like. There's no "magic" to wory about w/ the directory naming. And I'm not sure, but I *think* you need to make two host header entries -- one with one without the 'www.'. Hope that's helpful. Do be careful using host headers, tho. They're far less reliable than using separate IPs. I'd consider them accessable for internal stuff or for personal sites, but I would NEVER rely on them for a publicly accessable site that might actually be accessed by paying customers... Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVD7EQraVoMWBwRBEQL0dgCgnrWy1gzvHuRHFyK7k19tbnUBVS8AnRGd dgeHVpqu9SSzp9FNZaHjGLQt =9VKH -END PGP SIGNATURE- -- 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.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.
RE: OT: IIS sharing on IP address
when you create the website in IIS you will define the root directory of that site. So if you have the header, port and IP setup for the website, everything should work fine. Recap: call the folder whatever you like. Just make sure you map the website to that folder. I usually create two headers one for www.here.com and here.com. E From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 13:21:59 -0400 What I'm asking is say I make it up the ip address is 192.168.0.2 the port is 80 and the header is www.here.com, what do I call the folder to keep the website in. Do I call it what I called my header, and do I make 2 headers, one for www.here.com and here.com or just have my DNS refer to it. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:51 PM To: [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address if I understand correctly. you have to go in after creating the website in IIS and rightclick properties. on the first page, you'll have to hit an advanced button or something like that to get to where you can enter the header informtion. HTH From: Robert Everland [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 12:31:31 -0400 How do you go about writing the header information, do you put the url there, or do you put the folder. That's the only thing I can't figure out. It doesn't say specifically in the documentation on what to do. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 12:25 PM To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address As I recently learned from someone else in here, you *could* do it like this. In the default document of the root web at the IP address, put something like this: CFSWITCH EXPRESSION="#lcase(CGI.SERVER_NAME)#" CFCASE VALUE="www.site1.com, site1.com" CFLOCATION URL="/folder1/" /CFCASE CFCASE VALUE="www.site2.net, site2.net" CFLOCATION url="/folder2/bob.cfm /CFCASE CFDEFAULTCASE CFLOCATION URL="/index.cfm" /CFDEFAULTCASE /CFSWITCH Under these conditions, if someone typed www.site1.com, they would get redirected to www.site1.com/folder1/. www.site2.net would be www.site2.net/site2/bob.cfm. Anything else and they get sent to index.cfm in the root folder. It might not be 100% clean and pretty, but it works well, especially for 'simpler sites'. Besides, most people won't know the difference anyway. A couple of working examples would be www.campcheokee.org, or www.littlegoldangels.com [don't laugh, I didn't make these, I just set up the servers ;) ] Todd Ashworth Web Application Developer (803) 327-0137 [111] | I have been looking through the help though I am not sure exactly | what to search on. What i want to do is have as many domains as I want | sharing on ip address, though i can't find out how to go about doing this. | Anyone who knows how to do it would be greatly appreciated. | | Bob Everland -- 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.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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit
Re: OT: IIS sharing on IP address
So .. will all of this work with FTP as well? .Todd | when you create the website in IIS you will define the root directory of | that site. So if you have the header, port and IP setup for the website, | everything should work fine. | | Recap: call the folder whatever you like. Just make sure you map the website | to that folder. -- 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.
Crystal Reports question
The CF Web Application Construction Kit says in Ch. 16 that Allaire has "chosen it as the report writer to be bundled with their applications." That implies to me that it should be on their CD. I have looked on the CF Server 4.0 CD, the CF Studio 4.0 CD and the CF 4.5 Upgrade CD (all for Windows), and have seen nothing about Crystal Reports. I've looked for the crpe32.dll file, and have searched all files on all cds for the word "crystal." The only mention I saw was in the 4.0 Release Notes regarding possible problems that may occur regarding Crystal Reports. I can't locate my 4.0 User Guide to see what it says about it. Is this product supposed to be included or not? If so, has anyone else had a problem "finding" it? Am I missing something? I'm feeling rather obtuse... please help! Thanks, B. -- 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.
RE: Crystal Reports question
Crystal Reports was formerly bundled with CF, but no longer is... In fact there have been threads on cf-talk that Crystal Reports 8 and ColdFusion do not get along. -Original Message- From: B Lakeman [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 10:58 AM To: [EMAIL PROTECTED] Subject: Crystal Reports question The CF Web Application Construction Kit says in Ch. 16 that Allaire has "chosen it as the report writer to be bundled with their applications." That implies to me that it should be on their CD. I have looked on the CF Server 4.0 CD, the CF Studio 4.0 CD and the CF 4.5 Upgrade CD (all for Windows), and have seen nothing about Crystal Reports. I've looked for the crpe32.dll file, and have searched all files on all cds for the word "crystal." The only mention I saw was in the 4.0 Release Notes regarding possible problems that may occur regarding Crystal Reports. I can't locate my 4.0 User Guide to see what it says about it. Is this product supposed to be included or not? If so, has anyone else had a problem "finding" it? Am I missing something? I'm feeling rather obtuse... please help! Thanks, B. -- 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.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.
RE: Crystal Reports question
IT was included in version 3, they no longer support or include it. THough if you upgrade from 3.0 they have legacy support in it still. Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: B Lakeman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 1:58 PM To: [EMAIL PROTECTED] Subject: Crystal Reports question The CF Web Application Construction Kit says in Ch. 16 that Allaire has "chosen it as the report writer to be bundled with their applications." That implies to me that it should be on their CD. I have looked on the CF Server 4.0 CD, the CF Studio 4.0 CD and the CF 4.5 Upgrade CD (all for Windows), and have seen nothing about Crystal Reports. I've looked for the crpe32.dll file, and have searched all files on all cds for the word "crystal." The only mention I saw was in the 4.0 Release Notes regarding possible problems that may occur regarding Crystal Reports. I can't locate my 4.0 User Guide to see what it says about it. Is this product supposed to be included or not? If so, has anyone else had a problem "finding" it? Am I missing something? I'm feeling rather obtuse... please help! Thanks, B. -- 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.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.
CFMAIL running only once an hour
Since installing CF 4.5, my CFMAIL only processes sends mail just once an hour and I cannot find where to configure it to process it immediately. Any help on this would be greatly appreciated. DSJ -- 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.
OT: The Certified Internet Webmaster qualification
Hi, I've just come across a qualification I've never heard about before, and I'd like some information about it from the point of view of its usefulness. 1. How widely recognized is the Certified Internet Webmaster qualification? 2. How much of an advantage does its possession offer, in terms of having a better chance of getting web work? Sincerely, --- Hubert Earl ICQ#: 16199853 PhoneFree ID: 1841134 I develop maintain web sites internationally. I also build web applications using ColdFusion, JavaScript and CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/hfme/ (please remember to view this with a sense of humor!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- 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.
Native Drivers
Sorry to be flooding the list today ... but there's just so much gosh darn knowledge out there ... Can I use an Oracle native driver on Windows Professional? If so can someone direct me as to where I can find how to install and configure? Thanks again. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- 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.
OT: Bordercom International
Hi, Bordercom International is the only company I know of that offers training for the Certified Internet Webmaster qualification here in Jamaica. Because of this, I'd like some feedback from anyone with experience with it (as its name suggests, it operates world-wide). 1. If anyone reading this has taken any of its courses, how informative have they been? 2. How well taught are its courses? 3. Do any organizations offer online instruction for the same qualification? Sincerely, --- Hubert Earl ICQ#: 16199853 PhoneFree ID: 1841134 I develop maintain web sites internationally. I also build web applications using ColdFusion, JavaScript and CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/hfme/ (please remember to view this with a sense of humor!) **Business web page: http://home.talkcity.com/MigrationPath/hearl/ -- 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.
RE: OT: IIS sharing on IP address
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nope. Only with HTTP. Best regards, Zac Bedell So .. will all of this work with FTP as well? .Todd | when you create the website in IIS you will define the root directory of | that site. So if you have the header, port and IP setup for the website, | everything should work fine. | | Recap: call the folder whatever you like. Just make sure you map | the website | to that folder. -- Archives: http://www.eGroups.com/list/cf-talk 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. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.2 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOVEJ5graVoMWBwRBEQIb+gCg5QI30v2LWFJFUXJW76Nm3jFTyUkAnRTL 4jIKG363XAb/YmPELcmHMK4w =DmO7 -END PGP SIGNATURE- -- 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.
Verity book-like index idea...
Is there anyway to sort of reverse engineer Verity so that you could produce a book-like index of common words and phrases? Is there a specific place in verity where it stores the words it has indexed? I looked thru the collections directory and haven't found anything, can anyone give me an idea as to how I might be able to do this? Thanks, Scott -- 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.
Re: OT: IIS sharing on IP address
not that I've seen. I will play with it. I am thinking that the host will direct you to the IP, but you would have userid for one domain available in the next domain. ? E From: "Todd Ashworth" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: OT: IIS sharing on IP address Date: Wed, 21 Jun 2000 14:03:36 -0400 So .. will all of this work with FTP as well? .Todd | when you create the website in IIS you will define the root directory of | that site. So if you have the header, port and IP setup for the website, | everything should work fine. | | Recap: call the folder whatever you like. Just make sure you map the website | to that folder. -- 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. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- 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.
Personalization Algorythms
It is great to have the list back . Does anyone know of any CF-based personalization algorythms/tags? I am building an application for a company that requires that I learn about the level of sophistication of a User based on several factors and present different options based on these results. Thanks, Andy -- 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.
RE: CFMAIL running only once an hour
Since installing CF 4.5, my CFMAIL only processes sends mail just once an hour and I cannot find where to configure it to process it immediately. Any help on this would be greatly appreciated. I would highly recommend upgrading to 4.5.1 if you haven't already. There were a number of cfmail related problems in 4.5.0. If you already have 4.5.1, go to the admin page, click Mail under Miscelleneous, and change the "Spool Interval" to 15. It will then send spooled mail every 15 seconds. - Sean Sean Daniels Manager, Engineering Marketplace Technologies [EMAIL PROTECTED] tel: 207.439.6030 cel: 978.764.0779 http://www.dealforce.com http://www.dealstream.com http://www.mergernetwork.com -- 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.
com object
This is a multi-part message in MIME format. --=_NextPart_000_0010_01BFDB91.D4DB35A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Excuse any dups I have a JAVA application that works great from a dos prompt, but I need the same (virtually) functionality written to a COM object --- I have the open source available if it will help someone to write the COM object. Is there anyone out there that can, or knows someone else that would be able to write this COM object for me? Please contact me offlist to receive the code and/or inquire of more detail. Basically the JAVA app reads a file, and streams the information over an IP address, receives a reply, and writes it to a file. I want basically the same thing, except in variables rather than Files. The file information is plain text. Thank you, Jason Egan Konnections [EMAIL PROTECTED] --=_NextPart_000_0010_01BFDB91.D4DB35A0 Content-Type: image/gif; name="image001.gif" Content-Transfer-Encoding: base64 Content-ID: [EMAIL PROTECTED] R0lGODlh+gCbAHcAACH/C01TT0ZGSUNFOS4wGAxtc09QTVNPRkZJQ0U5LjAQAiDF3gAh/wtN U09GRklDRTkuMBgMY21QUEpDbXAwNzEyB09tt6UALAD6AJsAhP///ykpKXt7e4SE hN7e3v+MjP8hIefn77W1vWNja87O/3Nz/0JCvSkp/wAA/wECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwT/EMhJq7046827/2AojmRpnih4EMSavnAsz3Qd rrit73zv1y3W4UcsGo+1w7ByUDSeC8DiqahMGw5HlOJ8NiTXJaD7BD/FZO92slhktRavfA1Qs59Z etrcELPdeSF2e1JnVoBwSCQrLRJKLIgEDFl9LAR1b28LYoBYBwiUFJ0On6FslJpCmJlanKgOWFFD U1kIAAdYrJtgqKWwcaytHrQOtqO+XxS5mbuKKkE4lgRvDYgICEKTsIibSrjU363ey3253Uq5DdcL 1y3L1t4ACIjVC6rpK53cLeGw4ee39L1BEG8DvmngzMV7N7CgMw7QhAThpumaRU3WsB1ABAtUFksb /zOpewOSm8V2CjBSwsZvTEWWvrQQ8KgF0QBIImmCbKKyoyoNKfMQ4Djyo5ADPdX9fMiBkVMW6XIx GGCRwDIE6dpZZaaNHctlWrpqzUr1pDWpWpVkrJpRW7Gs18AuEAvzbBYGaTVklEuXhVusd/MybSqR Bc1MAxJfzDPgzdTFjnOVvcaKgeSTjhMrpnzXZtUVmSfTxDu68V2qpiNnmcyC2RvWfpg4RiCg8uV2 jj23iz3YAg5GBBRwvCtA87yBbo27vXu67HIH2qY6H6i5rM3qxbVyM358NYK/yak+j765dWgB2TVm 8AwWevN1rzUXL9uod4Yg0hBmYpAgQXpqqTHwX/8w7x1W2WbBNDBZJggkhl55W8HCXYTqpNZAbcQN gCGBj41FDXrz7ZZBVhsG0yFgtTg4IW/2TfAUTqz05x9V3Lg14wDatOdAejkGkx2OJi7Y3IOsISKd dZkl4JiNxfXISogsHcbfZupdYCSQsPioWGoLVAchiy1GIw2BAfSn2DIDpDPjaJUloJhjbWYH4IMW oakhlO38VZ6e6aRJyYxw7ucmVRKBBWV9F1wVYJtnxsediC1SEI2YQxEoY1lLOjZfJ8+Z2V0DnQ5q pAA3cgadZU+wNlNoQkKnYaYZ5hjqZKgeVp4SGCB1mqwxummqgF5UtVSkt+AHnCQJynhNcssMiiL/ MXfdqE0CYPE3aJ8gIrkaWu1gcx19njH7xqDaCFDtmp/aKpiV1El1bnbiQpcWmL0ZKw2b4w4I3YYC vikhWP3JWQsrZQ6aGakI/vmasPop2CBugfHLr4MD9Zqdfl2GxpIGB79mMVXUZHQUsUzYC6N70WaH iLn5ihdYry672qubbmWr7amU0OftG3huV3OzTZ4GM3y11EwfvT4LnYmnK+e4rg+/fQCNmLBCt2Y6 bk2Z2EAlWgtyLSUWLABNDSSgdVyBOuCrh7U8jE2ffjKXYWq0CeorhaMm1kYzwKT4WteeLmP0Om3Q 0FIF+Pl2+AXAGWmjswSqrXJgSo7r33eBLXfp/3MSQrYflAqUptiqgaUWY9CuVp5FwBCzUvZ8lLBI U5fkaQ55kDTeRW8JTpWMK+Iu3McIYoKvTRR/IS6ctafULT+jjqTtTI3XVSk6mfXLgUrkZc6DG2di 2hD0+wR25oK61caLdHZXt+wuQjSOiPnbJY+4D9w1Gsp46Ul3Bpwe/5oJWHks4iAZ/a9Bdxpgg0hl wPQYBoEPuxcEqQKiS1EJgYkRIKEsQRsH0QkUDPhNbGaCv+ogkIEheiB6/HOonbgPBBF5yoseAQ0N 3G+B+huUaOYzH9YA0ITYAOAK8bTAD5IQfwx0VhCP+KUjPgw1XhINAb2kFRJ60DjVkMb4ioU/CP9i kIrdwqASq7i4G/iBhvaaIUhq6CIxMIJ/FbzgF6nEwS5CUVg/fFQJexhGDxLxgW7TyAoISEggnsSO XixMCS94xGG9MZBShNADDZmfMn6gd8XiR2EKI8M1LqF3x1okJQ8pmns58ST5IeUhf7hKUaoKkJ+h YSu7yLBZzmuQtCQjSxaHS1seMpW53GV+XniBGOLHWJPiZESMCYBlnvKXQVylJ1M5Ey1KUJq+rGMw helEFsSvkrDkJjV3+clwgnNjkgqlKbt1lEcy7JiIEsExnaLGo2xSmaqglGFOWc1rurB94MwnGgFZ SWkq8pfn3Mk3JXIsLXqjoSC5xUKHWcktOiL/oMfKwUQj+lBcEZNx9pynNxRAUgUogaTt8wYngwe/ gErjAQ9wqEUlOgSP1vSmLiUATHcK05ucEZ45HdlN4zFUh9D0pu2TVPweelSm+iapSI2qI9rIVDdK dBHzbGcTSLq3BQinDSUN6xolUiwKuPQAMG3mJUbQUYi+9AEBiGtc1+qbR4izom39KAxqSrINJFOE Q/gqtMjRVXaYdKz0wqQE0gqAAQQApgmgXwJgGoABTAABk31AAsTX08cGQHzAgWn9JjAAuJb2ARJw LGWF0FnNEkSTUesrU1oiv3YGBA+Ro0QbYoFTLRbrp8FbLGpLK1e4AuCxbnqsZRFA2cc+gCA7/40r XJcJ04g2Fq7OHW5zp6vT7QYgjTOVbRHQ+KKwclVH2yjsbrdh0sNSNLhsFC4ASGULAKQVprY4QGKO +wDLXve7+F2BaGmIVp4a97G2OO18NyvgmHb3taKF7bDEewRNGmsebWDAVyPn1ZIGhB4dJmlDg3tR PzC2QQlwLgAya1r5TkC0A+5uQ5tbJgHYF7Uupo10Y1pgS8S4fuGlMBGUuVssNKCkxKjH3qqBhiRX o6QZxQBjb/zfxJxYAM4NAJVf/IAeK2HA0ajuT6acVuJqSMzV/TKP5xdPIRuhfsFRgFvAKgHheAHJ ha3CGK7AZ7B+wptSjukt7otjKseVy/z1L/9xC4yDCIfWwYBGsDwIzYgIi1nG8guym3sAnNBNAgp6 FgVYv3peLejZznbWrUnRSdXMSjcBN05uWifrJlpPWrPOhe6a0+wUGsfVynDdaawFsFMW8NrRD23z pqEmEeHoNsQuEuyovcpn8lWDsBKQRjpZkGLIDoEAnkXAY7nt3AQsAbOQ5WyX1QycBhvYso79bFrB bVoEd5e1627rst8chNB1oh5PnoBwBMtVsLrhyE0YDnu5CGiAOlV4HX2GSncS0ZnUNK1tXSls930E ODNCzug9cp1JXVNnA7wm0KIEqPd8E3vS068vV8FfwXmAyVYWuZnEKD80zXEdMLQF3SGQyOv/TOcm 4IHatLh25J5s51uO1oYjkzmQ3WoJVwvArX/VaM/HK6ZULz3UCQ9sOvCM3mBQmwHssKa+C9JRZXdA pTMfZm91DuStIyEaKBK6V5V6h0AQvezMqELo0jI1uP/O8HoFHpvvac2KTm3nibd7DFbg9a9XIKyF qIYVAE+JKjSBYcksPNw1CYLKKqG0GsEy1V86Vh4zNPIa4Ol3F7uBQjPB1f4dTHAwl1tYhPrvp9b8 5Tnve5MO8vURySyD9evZFmTXv8TWbAX8cwtiX50A/Wl8JSHNwfkFWcsiKLRjaR97DFC/mZWVAPg7 QO/ISiD6Nkb/dN9+sqXvnQsD9/zvpd17/1gMHfTJF1kHQCoE4FgEQSpo5QfjdwABcHWkZW7g5lhf NgD6tH1Z9XjhZXsfYHs4poEW4IHkJwG0EYIc4CaNBWvjd1yW9VnysH5Ql3cc9nv412GXt2TEZ2q3 ICzex31d5iZvxIDjs1k5GAC/o1MCloA6xQKeRYEzEW46ZWZH2F+mpQQ2V1r8hVrw92LEVV8vRlrx
RE: Native Drivers
Can I use an Oracle native driver on Windows Professional? If so can someone direct me as to where I can find how to install and configure? Yes, you can, if you have CF Enterprise Edition - I'm not sure what the "Professional" you've mentioned refers to: Windows or CF. You'll need to get the Net8 Client and install it. You'd need to do this to connect to Oracle via ODBC anyway. You should be able to ask your friendly Oracle administrator for the latest client. Once you've installed the client, you'll need to set up connection info for each Oracle instance (database) you want to connect to. You can do this using the Net8 configuration utilities. You'll need to know the IP address, database SID, username and password (assuming you're using IP to connect to Oracle). There are several different ways you can set up Oracle connections, but this should be a start. Once you've set up your Net8 connections, you can then set up the Oracle datasources in CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.
RE: com object
Why not use CFExecute if it runs off of a dos prompt? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 3:03 PM To: Cf-Talk Subject: com object This is a multi-part message in MIME format. --=_NextPart_000_0010_01BFDB91.D4DB35A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Excuse any dups - I have a JAVA application that works great from a dos prompt, but I need the same (virtually) functionality written to a COM object --- I have the open source available if it will help someone to write the COM object. Is there anyone out there that can, or knows someone else that would be able to write this COM object for me? Please contact me offlist to receive the code and/or inquire of more detail. Basically the JAVA app reads a file, and streams the information over an IP address, receives a reply, and writes it to a file. I want basically the same thing, except in variables rather than Files. The file information is plain text. Thank you, Jason Egan Konnections [EMAIL PROTECTED] --=_NextPart_000_0010_01BFDB91.D4DB35A0 Content-Type: image/gif; name="image001.gif" Content-Transfer-Encoding: base64 Content-ID: [EMAIL PROTECTED] R0lGODlh+gCbAHcAACH/C01TT0ZGSUNFOS4wGAxtc09QTVNPRkZJQ0U5LjAQAiDF3gAh/wtN U09GRklDRTkuMBgMY21QUEpDbXAwNzEyB09tt6UALAD6AJsAhP///ykpKXt7e4SE hN7e3v+MjP8hIefn77W1vWNja87O/3Nz/0JCvSkp/wAA/wECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwT/EMhJq7046827/2AojmRpnih4EMSavnAsz3Qd rrit73zv1y3W4UcsGo+1w7ByUDSeC8DiqahMGw5HlOJ8NiTXJaD7BD/FZO92slhktRavfA1Qs59Z etrcELPdeSF2e1JnVoBwSCQrLRJKLIgEDFl9LAR1b28LYoBYBwiUFJ0On6FslJpCmJlanKgOWFFD U1kIAAdYrJtgqKWwcaytHrQOtqO+XxS5mbuKKkE4lgRvDYgICEKTsIibSrjU363ey3253Uq5DdcL 1y3L1t4ACIjVC6rpK53cLeGw4ee39L1BEG8DvmngzMV7N7CgMw7QhAThpumaRU3WsB1ABAtUFksb /zOpewOSm8V2CjBSwsZvTEWWvrQQ8KgF0QBIImmCbKKyoyoNKfMQ4Djyo5ADPdX9fMiBkVMW6XIx GGCRwDIE6dpZZaaNHctlWrpqzUr1pDWpWpVkrJpRW7Gs18AuEAvzbBYGaTVklEuXhVusd/MybSqR Bc1MAxJfzDPgzdTFjnOVvcaKgeSTjhMrpnzXZtUVmSfTxDu68V2qpiNnmcyC2RvWfpg4RiCg8uV2 jj23iz3YAg5GBBRwvCtA87yBbo27vXu67HIH2qY6H6i5rM3qxbVyM358NYK/yak+j765dWgB2TVm 8AwWevN1rzUXL9uod4Yg0hBmYpAgQXpqqTHwX/8w7x1W2WbBNDBZJggkhl55W8HCXYTqpNZAbcQN gCGBj41FDXrz7ZZBVhsG0yFgtTg4IW/2TfAUTqz05x9V3Lg14wDatOdAejkGkx2OJi7Y3IOsISKd dZkl4JiNxfXISogsHcbfZupdYCSQsPioWGoLVAchiy1GIw2BAfSn2DIDpDPjaJUloJhjbWYH4IMW oakhlO38VZ6e6aRJyYxw7ucmVRKBBWV9F1wVYJtnxsediC1SEI2YQxEoY1lLOjZfJ8+Z2V0DnQ5q pAA3cgadZU+wNlNoQkKnYaYZ5hjqZKgeVp4SGCB1mqwxummqgF5UtVSkt+AHnCQJynhNcssMiiL/ MXfdqE0CYPE3aJ8gIrkaWu1gcx19njH7xqDaCFDtmp/aKpiV1El1bnbiQpcWmL0ZKw2b4w4I3YYC vikhWP3JWQsrZQ6aGakI/vmasPop2CBugfHLr4MD9Zqdfl2GxpIGB79mMVXUZHQUsUzYC6N70WaH iLn5ihdYry672qubbmWr7amU0OftG3huV3OzTZ4GM3y11EwfvT4LnYmnK+e4rg+/fQCNmLBCt2Y6 bk2Z2EAlWgtyLSUWLABNDSSgdVyBOuCrh7U8jE2ffjKXYWq0CeorhaMm1kYzwKT4WteeLmP0Om3Q 0FIF+Pl2+AXAGWmjswSqrXJgSo7r33eBLXfp/3MSQrYflAqUptiqgaUWY9CuVp5FwBCzUvZ8lLBI U5fkaQ55kDTeRW8JTpWMK+Iu3McIYoKvTRR/IS6ctafULT+jjqTtTI3XVSk6mfXLgUrkZc6DG2di 2hD0+wR25oK61caLdHZXt+wuQjSOiPnbJY+4D9w1Gsp46Ul3Bpwe/5oJWHks4iAZ/a9Bdxpgg0hl wPQYBoEPuxcEqQKiS1EJgYkRIKEsQRsH0QkUDPhNbGaCv+ogkIEheiB6/HOonbgPBBF5yoseAQ0N 3G+B+huUaOYzH9YA0ITYAOAK8bTAD5IQfwx0VhCP+KUjPgw1XhINAb2kFRJ60DjVkMb4ioU/CP9i kIrdwqASq7i4G/iBhvaaIUhq6CIxMIJ/FbzgF6nEwS5CUVg/fFQJexhGDxLxgW7TyAoISEggnsSO XixMCS94xGG9MZBShNADDZmfMn6gd8XiR2EKI8M1LqF3x1okJQ8pmns58ST5IeUhf7hKUaoKkJ+h YSu7yLBZzmuQtCQjSxaHS1seMpW53GV+XniBGOLHWJPiZESMCYBlnvKXQVylJ1M5Ey1KUJq+rGMw helEFsSvkrDkJjV3+clwgnNjkgqlKbt1lEcy7JiIEsExnaLGo2xSmaqglGFOWc1rurB94MwnGgFZ SWkq8pfn3Mk3JXIsLXqjoSC5xUKHWcktOiL/oMfKwUQj+lBcEZNx9pynNxRAUgUogaTt8wYngwe/ gErjAQ9wqEUlOgSP1vSmLiUATHcK05ucEZ45HdlN4zFUh9D0pu2TVPweelSm+iapSI2qI9rIVDdK dBHzbGcTSLq3BQinDSUN6xolUiwKuPQAMG3mJUbQUYi+9AEBiGtc1+qbR4izom39KAxqSrINJFOE Q/gqtMjRVXaYdKz0wqQE0gqAAQQApgmgXwJgGoABTAABk31AAsTX08cGQHzAgWn9JjAAuJb2ARJw LGWF0FnNEkSTUesrU1oiv3YGBA+Ro0QbYoFTLRbrp8FbLGpLK1e4AuCxbnqsZRFA2cc+gCA7/40r XJcJ04g2Fq7OHW5zp6vT7QYgjTOVbRHQ+KKwclVH2yjsbrdh0sNSNLhsFC4ASGULAKQVprY4QGKO +wDLXve7+F2BaGmIVp4a97G2OO18NyvgmHb3taKF7bDEewRNGmsebWDAVyPn1ZIGhB4dJmlDg3tR PzC2QQlwLgAya1r5TkC0A+5uQ5tbJgHYF7Uupo10Y1pgS8S4fuGlMBGUuVssNKCkxKjH3qqBhiRX o6QZxQBjb/zfxJxYAM4NAJVf/IAeK2HA0ajuT6acVuJqSMzV/TKP5xdPIRuhfsFRgFvAKgHheAHJ ha3CGK7AZ7B+wptSjukt7otjKseVy/z1L/9xC4yDCIfWwYBGsDwIzYgIi1nG8guym3sAnNBNAgp6 FgVYv3peLejZznbWrUnRSdXMSjcBN05uWifrJlpPWrPOhe6a0+wUGsfVynDdaawFsFMW8NrRD23z pqEmEeHoNsQuEuyovcpn8lWDsBKQRjpZkGLIDoEAnkXAY7nt3AQsAbOQ5WyX1QycBhvYso79bFrB bVoEd5e1627rst8chNB1oh5PnoBwBMtVsLrhyE0YDnu5CGiAOlV4HX2GSncS0ZnUNK1tXSls930E ODNCzug9cp1JXVNnA7wm0KIEqPd8E3vS068vV8FfwXmAyVYWuZnEKD80zXEdMLQF3SGQyOv/TOcm 4IHatLh25J5s51uO1oYjkzmQ3WoJVwvArX/VaM/HK6ZULz3UCQ9sOvCM3mBQmwHssKa+C9JRZXdA pTMfZm91DuStIyEaKBK6V5V6h0AQvezMqELo0jI1uP/O8HoFHpvvac2KTm3nibd7DFbg9a9XIKyF qIYVAE+JKjSBYcksPNw1CYLKKqG0GsEy1V86Vh4zNPIa4Ol3F7uBQjPB1f4dTHAwl1tYhPrvp9b8
CFLOCK timing out - why?
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_01BFDBB2.E36B3E82 Content-Type: text/plain; charset="iso-8859-1" Good day, all: I am trying to lock a session variable but am getting the following error: "Timed out while waiting to obtain exclusive access" All my other locks on the sight seem to be working but this one has me stumped. The template with the error is being called from a cfinclude. I'm using 4.5 server. code: - cflock scope="session" type="exclusive" timeout="15" cfset session.download="valid" /cflock Thanks, ant --_=_NextPart_001_01BFDBB2.E36B3E82 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" TITLECFLOCK timing out - why?/TITLE /HEAD BODY PFONT SIZE=3D2Good day, all:/FONT /P PFONT SIZE=3D2I am trying to lock a session variable but am getting = the following error: /FONT /P PFONT SIZE=3D2quot;Timed out while waiting to obtain exclusive = accessquot; /FONT /P PFONT SIZE=3D2All my other locks on the sight seem to be working = but this one has me stumped.nbsp; The template with the error is being = called from a cfinclude. I'm using 4.5 server./FONT/P PFONT SIZE=3D2code: /FONT BRFONT SIZE=3D2- /FONT BRFONT SIZE=3D2lt;cflock scope=3Dquot;sessionquot; = type=3Dquot;exclusivequot; = timeout=3Dquot;15quot;gt;nbsp;nbsp;nbsp;nbsp;nbsp; /FONT BRFONT SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;cfset = session.download=3Dquot;validquot;gt; /FONT BRFONT SIZE=3D2lt;/cflockgt; /FONT BRFONT SIZE=3D2 /FONT /P PFONT SIZE=3D2Thanks, /FONT /P PFONT SIZE=3D2ant /FONT /P /BODY /HTML --_=_NextPart_001_01BFDBB2.E36B3E82-- -- 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.
Re: CF updating values in database
Well, there are several ways this could be done. Here are just a couple: get the existing database value and add to it as follows: cfset updatedList = myquery.fielddata "delimiter-of-your-choice" #form.additions# then do an update to the table, setting table.fieldname = '#updatedList#' or plop the existing data into a list or array and append to it using the ListAppend or ArrayAppend function, then update the table field with the updated list/array. I'm sure there are other ways, and I don't know which of the two above will process more quickly - sorry I can't be of more help. Brenda Jamie Symonds wrote: This is a multi-part message in MIME format. --0744F58F5C26C4A7D1D9CDD6 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello everyone - thanks for provind an interesting list to read. I have now summoned the courage to make a posting, here's my question: I have a web application where a user can enter information (mainly from their CV) into a form where it is then inserted into a table in my database. The user (plans are for a yearly update where it's a CV we're dealing with) can return to the web site anytime in the future and make additions to her/his data. I have accomplished this (using VALUE=, etc.) with my text input fields and text areas (still a little trouble showing a checked radio button from the query but that will come in time). My trouble is that while I want the user to add info to that info currently on file, I do not want to user to be able to edit the information currently on file - I simply want the new data appended to the top of the exisiting information (for example, there's a "publications" field - they could see the publications from previous years, and add this years' to the top of that textarea without being able to edit the old data). I'm sure that there is a simple and easy solution to this? this years' info + info currently on file = updated field in database Thanks in advance for any assistance offered. Jamie --0744F58F5C26C4A7D1D9CDD6 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Symonds, James A. Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: James A. Symonds n: Symonds;James A. org:CompTech Crdntr, StFX Students' Union; Intern w/Prof. Blackwell; Intern w/Acdmc Fndng Rsrch; TSG Lab Assistant adr:Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada email;internet: [EMAIL PROTECTED] title: Bachelor of Info Sys, Major (student) x-mozilla-cpt: ;0 x-mozilla-html: TRUE version:2.1 end:vcard --0744F58F5C26C4A7D1D9CDD6-- -- 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.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.
CFFTP Error
I am having a slight problem with CFFTP. I am using an ACTION="GetFile" and trying to save the file in a local directory. No matter what, it won't save the file. The error is: Error Code: 1 Error Text: Cannot get remote file ftptest.htm to local file D:\websiteshere\connectionwebcom\dev\starr\ftptest.htm I can delete the file or set the FAILIFEXISTS="No" attribute and it does nothing to help the matter. IS it possible that CF runs as its own user for CFFTP and doesn't have permissions to write to my directory? FYI, I have checked to see if write permissions are set. CFFILE works fine in this same directory to create a file of the same name. Any help or ideas of what to look for would be useful. Joshua P Starr President Creative Director, Ælana Evenings (719) 268-1588 Day (719) 310-3030 Email: [EMAIL PROTECTED] Please visit us on the web at http://www.aelana.com or contact me on AOL Instant Messenger at AelanaWeb -- Archives: http://www.eGroups.com/list/cf-talk 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: Need help with a SQL query
If all you want is a comma seperated list of the categories for each item. Why not just add a "categories" field to the item table? Store the comma seperated list there. Because that would be denormalization of the data, which in a transaction processing system is VERY VERY BAD. That's why we spend all sorts of money on SQL Server, Oracle, and so on - so that we can store and manage normalized data. To illustrate some of the problems caused by denormalization, let's say that you do store a comma-delimited list in a field. What if I want to find all of the items within a specific category? I'd have to retrieve EVERY RECORD from the item table, and iterate through the list. Alternatively, what if I delete a category. Again, I'd have to retrieve every item, iterate through each list, delete any entries for that category, then save that item. Instead, if you have a one-to-many relationship, or a many-to-many relationship, you should store each entity in its own proper table, and use referential integrity to manage relationships between the tables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.
OT: how to rid MIME header...
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_01BFDBB5.C0EB5538 Content-Type: text/plain; charset="iso-8859-1" First of all I apologize for a) the ugly headers and b) the OT post but... Is there any way to get rid of the "this message was sent in MIME format" stuff? I'm stuck with Outlook - I set my settings to send the mail in text/plain but it still attaches HTML to the bottom - yuck. I've looked all over and can't find the answer. So, In an effort to clean up my mail to this list - and to inform others how to do the same, could someone please help!? Thank you, Ant --_=_NextPart_001_01BFDBB5.C0EB5538 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" TITLEOT: how to rid MIME header.../TITLE /HEAD BODY PFONT SIZE=3D2First of all I apologize for a) the ugly headers and = b) the OT post but.../FONT /P PFONT SIZE=3D2Is there any way to get rid of the quot;this message = was sent in MIME formatquot; stuff? I'm stuck with Outlook - I set my = settings to send the mail in text/plain but it still attaches HTML to = the bottom - yuck. I've looked all over and can't find the answer. So, = In an effort to clean up my mail to this list - and to inform others = how to do the same, could someone please help!? /FONT/P PFONT SIZE=3D2Thank you,/FONT /P PFONT SIZE=3D2Ant /FONT /P /BODY /HTML --_=_NextPart_001_01BFDBB5.C0EB5538-- -- 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.
Re: Native Drivers
nope. At 02:27 PM 6/21/2000 -0400, Tim Bahlke wrote: Sorry to be flooding the list today ... but there's just so much gosh darn knowledge out there ... Can I use an Oracle native driver on Windows Professional? If so can someone direct me as to where I can find how to install and configure? Thanks again. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 --- --- 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. -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- 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.
Re: CFLOCK timing out - why?
I believe that the syntax for the cflock tag in 4.5 is different - you can omit the type attribute. You just need the scope and the timout. - Original Message - From: "Anthony Israel-Davis" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 21, 2000 1:59 PM Subject: CFLOCK timing out - why? 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_01BFDBB2.E36B3E82 Content-Type: text/plain; charset="iso-8859-1" Good day, all: I am trying to lock a session variable but am getting the following error: "Timed out while waiting to obtain exclusive access" All my other locks on the sight seem to be working but this one has me stumped. The template with the error is being called from a cfinclude. I'm using 4.5 server. code: - cflock scope="session" type="exclusive" timeout="15" cfset session.download="valid" /cflock Thanks, ant --_=_NextPart_001_01BFDBB2.E36B3E82 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" TITLECFLOCK timing out - why?/TITLE /HEAD BODY PFONT SIZE=3D2Good day, all:/FONT /P PFONT SIZE=3D2I am trying to lock a session variable but am getting = the following error: /FONT /P PFONT SIZE=3D2quot;Timed out while waiting to obtain exclusive = accessquot; /FONT /P PFONT SIZE=3D2All my other locks on the sight seem to be working = but this one has me stumped.nbsp; The template with the error is being = called from a cfinclude. I'm using 4.5 server./FONT/P PFONT SIZE=3D2code: /FONT BRFONT SIZE=3D2- /FONT BRFONT SIZE=3D2lt;cflock scope=3Dquot;sessionquot; = type=3Dquot;exclusivequot; = timeout=3Dquot;15quot;gt;nbsp;nbsp;nbsp;nbsp;nbsp; /FONT BRFONT SIZE=3D2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;cfset = session.download=3Dquot;validquot;gt; /FONT BRFONT SIZE=3D2lt;/cflockgt; /FONT BRFONT SIZE=3D2 /FONT /P PFONT SIZE=3D2Thanks, /FONT /P PFONT SIZE=3D2ant /FONT /P /BODY /HTML --_=_NextPart_001_01BFDBB2.E36B3E82-- -- 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.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.
Nesting Output
This is a multi-part message in MIME format. --=_NextPart_000_01B6_01BFDB96.16B98EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am having a problem output nested infomation. I can't seem to get = more than 1 query (ie record stream) to output at a time.Basically I = have a database where in one table there is a 'parent' record, and the = other table has 'children' records, of which there could be many. Now I want to output some information about the parent, and then list = the children, and do this for many records in the db. If I use the = cfoutput query=3D name for the parent record, I have to close that = before I can output the child records. Even using cfloop to display the = child records doesn't seem to let me nest inside the outer cfoutput. = Since the logic in my program does a lot of processing and has many if = statements within the outer cfoutput, openning and closing and openning = and closing cfoutput is really awkward. Isn't there any reasonable way = to nest there cfoutput (except using group which doesn't really apply)? = Any insight would be appreciated. Ruthie --=_NextPart_000_01B6_01BFDB96.16B98EA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I am having a problem output nested=20 infomation.nbsp; I can't seem to get more than 1 query (ie record = stream) to=20 output at a time./FONTFONT face=3DArial size=3D2Basically I have a = database=20 where in one table there is a 'parent' record, and the other table has=20 'children' records, of which there could be many./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Now I want to output some information = about the=20 parent, and then list the children, and do this for many records in the=20 db.nbsp; If I use the cfoutput query=3D name for the parent record, I = have to=20 close that before I can output the child records.nbsp;Even using cfloop = to=20 display the child records doesn't seem to let me nest inside the outer=20 cfoutput.nbsp; Since the logic in my program does a lot of processing = and has=20 many if statements within thenbsp;outer cfoutput,nbsp;openning and = closing and=20 openning and closing cfoutput is really awkward.nbsp; Isn't there=20 anynbsp;reasonable way to nest there cfoutput (except using group=20 whichnbsp;doesn't really apply)?nbsp; /FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Any insight would be = appreciated./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArial size=3D2Ruthie/FONT/DIV/BODY/HTML --=_NextPart_000_01B6_01BFDB96.16B98EA0-- -- 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.
RE: com object
I thought I had seen here or elsewhere that cfexecute wasn't secure or stable.. can't remember... but I would like the contents to be in a variable rather than a file so that I won't have to go to the disk... but perhaps it will be a temporary solution. Have you heard anything negative about the tag? Jason Egan Konnections, INC. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 3:13 PM To: '[EMAIL PROTECTED]' Subject: RE: com object Why not use CFExecute if it runs off of a dos prompt? Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 21, 2000 3:03 PM To: Cf-Talk Subject: com object This is a multi-part message in MIME format. --=_NextPart_000_0010_01BFDB91.D4DB35A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Excuse any dups - I have a JAVA application that works great from a dos prompt, but I need the same (virtually) functionality written to a COM object --- I have the open source available if it will help someone to write the COM object. Is there anyone out there that can, or knows someone else that would be able to write this COM object for me? Please contact me offlist to receive the code and/or inquire of more detail. Basically the JAVA app reads a file, and streams the information over an IP address, receives a reply, and writes it to a file. I want basically the same thing, except in variables rather than Files. The file information is plain text. Thank you, Jason Egan Konnections [EMAIL PROTECTED] --=_NextPart_000_0010_01BFDB91.D4DB35A0 Content-Type: image/gif; name="image001.gif" Content-Transfer-Encoding: base64 Content-ID: [EMAIL PROTECTED] R0lGODlh+gCbAHcAACH/C01TT0ZGSUNFOS4wGAxtc09QTVNPRkZJQ0U5LjAQAiDF3gAh/wtN U09GRklDRTkuMBgMY21QUEpDbXAwNzEyB09tt6UALAD6AJsAhP///ykpKXt7e4SE hN7e3v+MjP8hIefn77W1vWNja87O/3Nz/0JCvSkp/wAA/wECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwT/EMhJq7046827/2AojmRpnih4EMSavnAsz3Qd rrit73zv1y3W4UcsGo+1w7ByUDSeC8DiqahMGw5HlOJ8NiTXJaD7BD/FZO92slhktRavfA1Qs59Z etrcELPdeSF2e1JnVoBwSCQrLRJKLIgEDFl9LAR1b28LYoBYBwiUFJ0On6FslJpCmJlanKgOWFFD U1kIAAdYrJtgqKWwcaytHrQOtqO+XxS5mbuKKkE4lgRvDYgICEKTsIibSrjU363ey3253Uq5DdcL 1y3L1t4ACIjVC6rpK53cLeGw4ee39L1BEG8DvmngzMV7N7CgMw7QhAThpumaRU3WsB1ABAtUFksb /zOpewOSm8V2CjBSwsZvTEWWvrQQ8KgF0QBIImmCbKKyoyoNKfMQ4Djyo5ADPdX9fMiBkVMW6XIx GGCRwDIE6dpZZaaNHctlWrpqzUr1pDWpWpVkrJpRW7Gs18AuEAvzbBYGaTVklEuXhVusd/MybSqR Bc1MAxJfzDPgzdTFjnOVvcaKgeSTjhMrpnzXZtUVmSfTxDu68V2qpiNnmcyC2RvWfpg4RiCg8uV2 jj23iz3YAg5GBBRwvCtA87yBbo27vXu67HIH2qY6H6i5rM3qxbVyM358NYK/yak+j765dWgB2TVm 8AwWevN1rzUXL9uod4Yg0hBmYpAgQXpqqTHwX/8w7x1W2WbBNDBZJggkhl55W8HCXYTqpNZAbcQN gCGBj41FDXrz7ZZBVhsG0yFgtTg4IW/2TfAUTqz05x9V3Lg14wDatOdAejkGkx2OJi7Y3IOsISKd dZkl4JiNxfXISogsHcbfZupdYCSQsPioWGoLVAchiy1GIw2BAfSn2DIDpDPjaJUloJhjbWYH4IMW oakhlO38VZ6e6aRJyYxw7ucmVRKBBWV9F1wVYJtnxsediC1SEI2YQxEoY1lLOjZfJ8+Z2V0DnQ5q pAA3cgadZU+wNlNoQkKnYaYZ5hjqZKgeVp4SGCB1mqwxummqgF5UtVSkt+AHnCQJynhNcssMiiL/ MXfdqE0CYPE3aJ8gIrkaWu1gcx19njH7xqDaCFDtmp/aKpiV1El1bnbiQpcWmL0ZKw2b4w4I3YYC vikhWP3JWQsrZQ6aGakI/vmasPop2CBugfHLr4MD9Zqdfl2GxpIGB79mMVXUZHQUsUzYC6N70WaH iLn5ihdYry672qubbmWr7amU0OftG3huV3OzTZ4GM3y11EwfvT4LnYmnK+e4rg+/fQCNmLBCt2Y6 bk2Z2EAlWgtyLSUWLABNDSSgdVyBOuCrh7U8jE2ffjKXYWq0CeorhaMm1kYzwKT4WteeLmP0Om3Q 0FIF+Pl2+AXAGWmjswSqrXJgSo7r33eBLXfp/3MSQrYflAqUptiqgaUWY9CuVp5FwBCzUvZ8lLBI U5fkaQ55kDTeRW8JTpWMK+Iu3McIYoKvTRR/IS6ctafULT+jjqTtTI3XVSk6mfXLgUrkZc6DG2di 2hD0+wR25oK61caLdHZXt+wuQjSOiPnbJY+4D9w1Gsp46Ul3Bpwe/5oJWHks4iAZ/a9Bdxpgg0hl wPQYBoEPuxcEqQKiS1EJgYkRIKEsQRsH0QkUDPhNbGaCv+ogkIEheiB6/HOonbgPBBF5yoseAQ0N 3G+B+huUaOYzH9YA0ITYAOAK8bTAD5IQfwx0VhCP+KUjPgw1XhINAb2kFRJ60DjVkMb4ioU/CP9i kIrdwqASq7i4G/iBhvaaIUhq6CIxMIJ/FbzgF6nEwS5CUVg/fFQJexhGDxLxgW7TyAoISEggnsSO XixMCS94xGG9MZBShNADDZmfMn6gd8XiR2EKI8M1LqF3x1okJQ8pmns58ST5IeUhf7hKUaoKkJ+h YSu7yLBZzmuQtCQjSxaHS1seMpW53GV+XniBGOLHWJPiZESMCYBlnvKXQVylJ1M5Ey1KUJq+rGMw helEFsSvkrDkJjV3+clwgnNjkgqlKbt1lEcy7JiIEsExnaLGo2xSmaqglGFOWc1rurB94MwnGgFZ SWkq8pfn3Mk3JXIsLXqjoSC5xUKHWcktOiL/oMfKwUQj+lBcEZNx9pynNxRAUgUogaTt8wYngwe/ gErjAQ9wqEUlOgSP1vSmLiUATHcK05ucEZ45HdlN4zFUh9D0pu2TVPweelSm+iapSI2qI9rIVDdK dBHzbGcTSLq3BQinDSUN6xolUiwKuPQAMG3mJUbQUYi+9AEBiGtc1+qbR4izom39KAxqSrINJFOE Q/gqtMjRVXaYdKz0wqQE0gqAAQQApgmgXwJgGoABTAABk31AAsTX08cGQHzAgWn9JjAAuJb2ARJw LGWF0FnNEkSTUesrU1oiv3YGBA+Ro0QbYoFTLRbrp8FbLGpLK1e4AuCxbnqsZRFA2cc+gCA7/40r XJcJ04g2Fq7OHW5zp6vT7QYgjTOVbRHQ+KKwclVH2yjsbrdh0sNSNLhsFC4ASGULAKQVprY4QGKO +wDLXve7+F2BaGmIVp4a97G2OO18NyvgmHb3taKF7bDEewRNGmsebWDAVyPn1ZIGhB4dJmlDg3tR PzC2QQlwLgAya1r5TkC0A+5uQ5tbJgHYF7Uupo10Y1pgS8S4fuGlMBGUuVssNKCkxKjH3qqBhiRX o6QZxQBjb/zfxJxYAM4NAJVf/IAeK2HA0ajuT6acVuJqSMzV/TKP5xdPIRuhfsFRgFvAKgHheAHJ ha3CGK7AZ7B+wptSjukt7otjKseVy/z1L/9xC4yDCIfWwYBGsDwIzYgIi1nG8guym3sAnNBNAgp6 FgVYv3peLejZznbWrUnRSdXMSjcBN05uWifrJlpPWrPOhe6a0+wUGsfVynDdaawFsFMW8NrRD23z
RE: CFLOCK timing out - why?
I believe that the syntax for the cflock tag in 4.5 is different - you can omit the type attribute. You just need the scope and the timout. The TYPE attribute isn't required, but the default value is exclusive, and if you can use a readonly lock instead, that would be preferable. In this case, it doesn't matter, but you will still use the TYPE attribute in CF 4.5.x. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.
RE: COM object/Interface problems
Try... (I've forgotten which is which myself now)... um, CFX_ConsoleCommand. It can capture the text output that occurs during the program execution. Check out the text. Might show you if an error message is coming up. --min I gave it a try, and it didn't work. The program runs, but nothing happens. Russel Try using cfx_spawn from Intrafoundation.com ~J -- 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.
RE: com object
I thought I had seen here or elsewhere that cfexecute wasn't secure or stable.. can't remember... but I would like the contents to be in a variable rather than a file so that I won't have to go to the disk... but perhaps it will be a temporary solution. Have you heard anything negative about the tag? CFEXECUTE, given that it allows CF to execute arbitrary commands at the console, isn't very secure. Neither is CFFILE, or CFREGISTRY, or CFOBJECT (which is what you'd have to use if you were using a COM object). However, as long as your applications aren't compromised, and no one is able to create and execute malicious CFML scripts, you've got nothing to worry about with any of these tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- 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.