I have a problem..
Hi there, I've a problem which I'm trying hard to solve, hope you guys can help me out on this.. I have two huge tables with alot of fields. One of the table is driven by a form which will be filled by user and not all the fields are compulsory. I am required to compare these two tables and to match the correct data out. However I can't perform a CFQUERY with lots 'AND' criteria because some of the fields are NULL. I only need to match those fields that the user enter. How do I go about doing it? Hope that my message is clear. Thanks, Roger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Business Directory
Has anyone deployed a Regional Business and Service Directory to the net using CF that can have a look at please? Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Tab Key
You can have IE skip the links by setting their tab index to -1. For example: a href="#" onClick="MM_openBrWindow('name_uspis-pop.html','name','scrollbars=yes,wid th=310,height=490')" tabindex="-1" -David On Mon, 11 Sep 2000 "Vyna P. Courtney" [EMAIL PROTECTED] writes: Please help me with the Tab key. What I'm trying to do is to allow users to use the tab key to navigate between input fields and the drop down list without going though the html links. The codes I have doesn't work yet I'm not sure what I'm doing wrong. V.C. td width="100" rowspan="1" align="RIGHT" bgcolor="#cc" Bfont size="-1"a href="#" onClick="MM_openBrWindow('name_uspis-pop.html','name','scrollbars=yes,wid th=310,height=490')"Name:/a/font/B /TD TD ALIGN=RIGHT colspan=3 div align="left" input type="Text" name="sname" size="60" tabindex="1" /div /TD /TR tr TD ALIGN=RIGHT VALIGN=middle bgcolor=#cc width=100 Bfont size="-1"a href="#" onClick="MM_openBrWindow('case_uspis-pop.html','case','scrollbars=yes,wid th=310,height=450')"Case:/a/font/B/TD td colspan="4" align="LEFT" input type="Text" name="case" size="60" tabindex="2" /TD/tr tr TD ALIGN=RIGHT VALIGN=middle bgcolor=#cc width=100 Bfont size="-1"a href="#" onClick="MM_openBrWindow('ssn_uspis-pop.html','ssn','scrollbars=yes,width =310,height=420')"SSN:/a/font/B/TD td colspan="4" align="LEFT" input type="Text" name="ssn" size="60" tabindex="3" /TD/tr TR td rowspan="2" align="CENTER" valign="MIDDLE" bgcolor="#cc" div align="right"font size="-1"ba href="#" onClick="MM_openBrWindow('dob2_uspis-pop.htm','dob2','scrollbars=yes,widt h=310,height=460')"Date of Birth:/a/b/font/div /td tdfont size="-1"bMonth:/b/font select name="month" id="4" option selected option selected value="1"January option selected value="2"February option selected value="3"March option selected value="4"April option selected value="5"May option selected value="6"June option selected value="7"July option selected value="8"August option selected value="9"September option selected value="10"October option selected value="11"November option selected value="12"December /select /TD tdBfont size="-1"Day:/font/bnbsp;nbsp;nbsp; select name="day" id="5" option selected cfloop index="count" from="1" to="31" option selectedcfoutput#count#/cfoutput /cfloop /select /td td font size="-1"bYear:/b/font select name="year" id="6" option selected cfoutput query="year" option#year# /cfoutput /select /TD /TR tr td align=right colspan="4" div align="center"bfont size="-1"Age Range:nbsp;nbsp;nbsp;/font/b font size="-1"From:/font input type="Text" name="from_age" size="2" maxlength="3" tabindex="7" font size="-1"To:/font input type="Text" name="to_age" size="2" maxlength="3" tabindex="8" /div /td /tr TR TD COLSPAN=6 ALIGN=center INPUT TYPE="HIDDEN" NAME="rollcount" VALUE="2" INPUT TYPE="submit" name = "done" VALUE="Search cfoutput #total.a# records/cfoutput" INPUT TYPE="reset" VALUE="Clear" /TD /TR YOU'RE PAYING TOO MUCH FOR THE INTERNET! Juno now offers FREE Internet Access! Try it today - there's no risk! For your FREE software, visit: http://dl.www.juno.com/get/tagj. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: I have a problem..
Hi Roger, I have two huge tables with alot of fields. One of the table is driven by a form which will be filled by user and not all the fields are compulsory. I am required to compare these two tables and to match the correct data out. However I can't perform a CFQUERY with lots 'AND' criteria because some of the fields are NULL. I only need to match those fields that the user enter. What you can do very crudely is wrap the AND sections with cfif len(suspect_var) tags so that you only do the AND if there is something in the field: Select stuff from somewhere where 1=1 cfif len(suspect_var) and ColumnName = #suspect_var#/cfif etc. -- Yours, Kym -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: I have a problem..
select * from tablename where fieldname is NOT NULL I dunno about you, but sometimes I forgot a simple thing. - Rudy - Original Message - From: Roger Lim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 2:16 PM Subject: I have a problem.. Hi there, I've a problem which I'm trying hard to solve, hope you guys can help me out on this.. I have two huge tables with alot of fields. One of the table is driven by a form which will be filled by user and not all the fields are compulsory. I am required to compare these two tables and to match the correct data out. However I can't perform a CFQUERY with lots 'AND' criteria because some of the fields are NULL. I only need to match those fields that the user enter. How do I go about doing it? Hope that my message is clear. Thanks, Roger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: I have a problem..
Hi Kym, THANKS! That's exactly what I'm looking for! Really a great help!! ;) roger - Original Message - From: "Kym Kovan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 2:56 PM Subject: Re: I have a problem.. Hi Roger, I have two huge tables with alot of fields. One of the table is driven by a form which will be filled by user and not all the fields are compulsory. I am required to compare these two tables and to match the correct data out. However I can't perform a CFQUERY with lots 'AND' criteria because some of the fields are NULL. I only need to match those fields that the user enter. What you can do very crudely is wrap the AND sections with cfif len(suspect_var) tags so that you only do the AND if there is something in the field: Select stuff from somewhere where 1=1 cfif len(suspect_var) and ColumnName = #suspect_var#/cfif etc. -- Yours, Kym -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Aggregate by Month
So, what would be the proper query? Or proper output? And/OR? Howard Something like SELECT DatePart('M', DateCreated)), count(*) AS MonthCreatedCount FROM Table1 GROUP BY DatePart('M', DateCreated)) ORDER BY MonthCreatedCount DESC Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Alternative to cftransaction
Howdy all. I'm trying to port my cf_ezcart over to Linux and MySql. All's going well so far. One problem though. I get an error that MySql is not transactional so I can't use the ctransaction tag to lock the database while I write a record then do a query get the max(customer_id) record written. Can I just use a cflock like this? cflock name="cust#attributes.dsn#" timeout="30" type="exclusive" Will that basically do the same thing? If not, any hints? And if so, will that work on 4.51 without the scope parameter? Thanks. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs UltraDev
Actually, UltraDev was not necessarily meant to be a replacement for ColdFusion--it was developed to enhance the development environment and create a more "wysiwyg" environment for more rapid development. You can choose a default platform and change it at any time (even on a per-project basis). It has a very nice interface for building your queries, and it allows you to drag and drop the variables right into the page, wherever you want them displayed. You can very easily incorporate Next N browsing, e-commerce, regular expressions, etc. Basically, anything you could do with ColdFusion, JSP or ASP--you can do with UltraDev. The nice thing is, you don't even have to buy a new app server--just use your existing one. Per Macromedia's site: "UltraDev currently supports ASP 2.0, ColdFusion, and the JSP 1.0 server including Microsoft IIS, Allaire ColdFusion, IBM WebSphere, BEA WebLogic, and the Netscape Enterprise Server. However, UltraDev can be extended to support any server." And it supports "ODBC, JDBC, or ADO relational databases including Oracle, Sybase, Informix, Microsoft SQL Server, and Microsoft Access." This is why their site still showed a .cfm extension. They very well may have used UltraDev, but their server is a ColdFusion server. Therefore, they would have had it set to default to the CF technologies. Similarly, if they were using IIS, they would have defaulted to ASP and had a .asp extension. I went to a demonstration held by Macromedia on this, and I was quite impressed. I am currently evaluating UltraDev for our Software Development Team. Though it currently does not have anything in place for version control (you would still have to use something like SourceSafe), they plan on implementing this in the next version, which is due to be out by the end of this year. I am absolutely amazed at the speed with which one can construct applications. Things that would take a couple of hours in ColdFusion Studio took a matter of minutes in UltraDev. And, you have complete access to your HTML and SQL, should you need to create anything more advanced than the interface will let you accomplish. I would highly recommend checking it out (and you can download the demo) at http://www.macromedia.com/software/ultradev/. Terri Original Message Follows From: Peter Tilbrook [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: CF vs UltraDev Date: Tue, 12 Sep 2000 09:23:45 +0930 Heh heh! Any wonder. They use CF on their site too: http://www.internet.au.com Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 September 2000 9:47 To: CF Talk (E-mail) Subject: CF vs UltraDev FYI - October issue of internet.au (an Australian Internet mag for those who may not have heard of it) rated Ultradev at 3/5 and CF at 4/5. Reviewer felt that CF was more reliable and user friendly than ASP. But I guess we all new this. Kevin Parker Service and Communication WorkCover Corporation [EMAIL PROTECTED] ph: +61 8 82332548 fax: +61 8 82332000 This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private,
CFHTTP, CFWDDX, cflock'ing it - cfcatch'in and cftry'ing.
Hi, First of all I'm using CF4.51 Pro. I'm using CFHTTP to hit a page that produces WDDX, then trying to deserialise the wddx. I'm aware that there were many problems with CFHTTP in CF4.01 but don't know what it's like now, but under my own basic testing I've experienced repeated fails So, I'm trying to minimise the errors visible to the user. I've encapsultated by communication with the remote server in a custom tag and this is the CFTRY and CFLOCK -ing I'm doing: CFTRY CFLOCK type="READONLY" scope="SESSION" timeout="20" throwontimeout="Yes" CFHTTP throwonerror="Yes" method="POST" url="#URL#" timeout="5" CFHTTPPARAM type="FORMFIELD" name="value1" value="#ATTRIBUTES.value1#" CFHTTPPARAM type="FORMFIELD" name="value2" value="#ATTRIBUTES.value2#" /CFHTTP /CFLOCK CFWDDX action="WDDX2CFML" input="#CFHTTP.FileContent#" output="RequestResult" CFCATCH type="Any" CFSET request.ErrorMessage = "Communications Error" CFMAIL to="#ben#" from="#server_email#" subject="Site error" #CFHTTP.FileContent# /cfmail CFEXIT /CFCATCH /CFTRY So, does this all look right??? Will the throwontimeout in cflock and throwonerror in cfhttp be caught by the cfcatch? Should I be using a session scoped readonly cflock around all this? Is CFHTTP a reliable tag to use on a frquently hit site - a few thousand hits a day?? Is there a better alternative to CFHTTP? Is there a better alternative method for providing sites with rapidly changing data than a script that produces WDDX that is accurate at the time of being hit (big question!!)? If anyone can answer just a couple of these questions I'd be very happy!! Thanks Ben. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Order query results by numeric values from a text field
I have a problem with ordering the display of my querys I have to keep de fields in my access database as text fields because theses queries are generating my page dynamically. I use cfquery... SELECT * FROM TABLE ORDER BY field ASC /cfquery The value of this field can be numeric and alpha. in the output it apears this way: 1000mhz amd thunderbird 650mhz amd duron 700mhz amd duron 800mhz amd thunderbird note:1000mhz comes before the 650mhz ... thats not right Is there a way to order correctly by keeping thoses strings as text strings Thanks in advance -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: I have a problem..
cfif criteria neq ""AND field1 field2,/cfif and then you ternimate by anything true to complete the coma delimited list... like AND 1 0 -Message d'origine- De: Roger Lim [SMTP:[EMAIL PROTECTED]] Date: Tuesday, September 12, 2000 2:17 AM À:[EMAIL PROTECTED] Objet:I have a problem.. Hi there, I've a problem which I'm trying hard to solve, hope you guys can help me out on this.. I have two huge tables with alot of fields. One of the table is driven by a form which will be filled by user and not all the fields are compulsory. I am required to compare these two tables and to match the correct data out. However I can't perform a CFQUERY with lots 'AND' criteria because some of the fields are NULL. I only need to match those fields that the user enter. How do I go about doing it? Hope that my message is clear. Thanks, Roger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Windows MySQL
Has anybody done any development with the Windows version of MySQL? How does it rate compared to an Access DB, SQL Server, etc? Free-ish :-) No graphical IDE-type tools :-| Nice but incomplete implementation of SQL language (no subselects or stored procs) with some useful web-oriented extensions :-| No support for transactional integrity :-| You might or might not care about this, see http://openacs.org/philosophy/why-not-mysql.html for a tedious acrimonious holy war on this subject Blisteringly fast for read-only access :-) Overall you will probably be less productive with MySQL than either of the other two - to what extent, depends on how much you like to use the M$ visual tools as opposed to being a hardcore SQL programmer. Your site will be better off using MySQL than Access. If you have a lot of update transaction volume, SQL Server is the only serious DBMS of the three. But if it's mostly read-only access, MySQL will stand up well. I've developed using the Windows version but only deployed on Linux so I'm not sure if this holds true for both. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: text to speech program recommendation? (for db-middleware-flash)
Dave, Thanks for your feedback. Why would you say it would be better to do it client side as opposed to server side? I'm guessing it's really a questions of performance/speed in getting the text to wav and then having it come into a flash file? Unfortunately because the user base will not be controlled, an IE only solution won't work. And because of the real need to have the solution server side I think I'll be stuck heading that route. :: Wonders if throwing more hardware at the problem would solve it :: From your posting is it then safe to say If I were to go with a server side solution, purchasing of an L H product would not be necessary since a version of it comes with MS Agent that I can use instead? I had tried giving them a ring but alas they did not want to recommend a shrink wrap package and was more interested in providing a "solution." If by using the Agent the result is the same then of course that would be more to my liking as the cost won't be an issue :) Finally I haven't really had a chance to get into COM all that much any materials you can point me to, to get me started? Thanks, Jack P.S. By the way just wanted to say I thought the presentation you figleaf guys put together down at Bethesda a couple of months ago was awesome, Flash front end interfaces to apps that really cook. You could hear the ooohs and hs in the auditorium. What will you guys think of next? ;) Dave Watts wrote: Can anyone recommend a text to speech "TTS" program that would allow me to create a web app using coldfusion, asp, php, etc. (lang doesn't matter) and be able to connect to a database for the text which in turn is fed to the TTS program which outputs a wav file that can be used by flash to import through generator or other and thus having dynamic sound being generated through a flash file? The process would be something like this: DB -- TextFile -- TTS Program -- WAVFile -- Generator -- Flash (of course flash would be the activation point which would actually start up the process by going to a db connectivity set page such as an ASP file which will kick off the rest. Flash's next step through Generator would then be to get the Wav file, etc. Yikes! Conceivably, you could do some of this using the COM interface of the Lernout Hauspie package, which comes with Microsoft Agent 2.0. You'd query the database using CF (or whatever), retrieve your text, feed it to L H via COM, then use the resulting WAV file. You can get two versions of the L H engine from the MS Agent site: http://msdn.microsoft.com/msagent/ Others are listed there as well. However, doing this on the server is going to be relatively intensive - you might be better off doing this on the client if possible. The MS Agent interface is designed for that, although I do think it requires IE. This, of course, wouldn't involve Flash at all, although you could use MS Agent and Flash in the same interface. We've got some sample files using MS Agent here: http://www.figleaf.com/figleafhome/cfug/cfugFeb00/web_help_cfug.zip Also anyone know of a mailing list specific to generator? (news server won't work for me) No, I don't know of any, but there's a Flash coders list which discusses some Generator stuff, I believe - and even if they don't, they'll know where to go for this: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Jack Montealegre Application Developer G.Triad Tel: (973) 428-9600 ext. 7618 Fax: (973) 428-1112 [EMAIL PROTECTED] http://www.gtriad.com FOR MORE INFORMATION ABOUT G.TRIAD Visit the G.Triad Corporate Web Site http://www.gtriad.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF 4.5.1 Service Pack 1 Available
Links are available from the Allaire home page http://www.allaire.com, and Release Notes in each download detail the changes and fixes. Thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Spawning a background process?
Hello gurus, I have a CF page that uploads a file, and then I need to do some LENGTHY processing of the file (lots of parsing and breaking it into lots of little files). Is there any way I can do the processing in the background, while my user goes on his merry way? I have the Forta books as well as _Mastering Cold Fusion_, but I must not be searching for the right keywords. While I'm at it, when I'm building a file for output, is it better to build it first in a variable (several steps, many concatenations) and do one file write, or build it by appending to the file? (I assume the former, but my 2 MB input file is still timing out after 1500 seconds! There must be a better way!) Thanks very much, Carol -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HELP CFCACHE......
whenever I try and use cfcache within my application it causes my application to timeout? I don't see any documentation about this problem? Anyone know what this is caused from? Thanks Rich -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Hotel Booking Engine up
- Original Message - From: "Robert Everland III" [EMAIL PROTECTED] Sent: 12 September 2000 03:09 You know you're right and it wasn't my first decision to sell it for $5,000 I consulted someone else. So in light of this discussion I will now have the same deal all source codes, SQL scripts, tech support and updates for a year now only for $500. I have not and would not want to pay too much for an application and I hope $500 is a more fair price with everyone. Thanks for the feedback from the forum. That's some reduction - if only everything where reduced by a factor of 10 :-) The main issue is though - does it directly and seemlessly integrate (or easily made to) with Hotel legacy and real-time booking systems - i.e. so it is_totally_automated. If not it has very limited value because it means people manually updating both systems. I was amazed for instance (to say the least) when I discovered that the brand new "online banking service" recently launched by my bank - one of the biggest in the UK and the world - had a manual backend! I discovered (after a clerical error was made on my account), that after a transaction was input online, it would go like an email to a manual operator sitting at a desk, only to be printed out and manually keyed into their computer system! So much for progress :-) Online systems which do interface with legacy and RT systems really are worth $. Adrian Cooper. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
No Subject
I have just downloaded cf server 4.5 however when I go to the administration section to modify my server settings the browser proceeds to the address of http://127.0.0.1/CFIDE/Administrator/index.cfm and it generates browser message file not found hence I cannot run the admin interface any ideas would be grateful Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Stored Procedure Help
How do you refer to the result of a query in a stored procedure? The statement "IF MemberStatus = 0" gives an error of "invalid column name for MemberStatus" -- Check Member Status SELECT MemberStatus FROM Members WHERE MemberID = @ThisMemberID -- If they are not currently active RETURN 2 IF MemberStatus = 0 BEGIN RETURN 2 END Sebastian Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Access Relationships
Hi, I have 2 tables, which have a relationship of the unique ID. I'm kind of confused how to update table 2, with a matching record from table 1. For instance, if table 1 was products, and table 2 was a download count of those products. Each time it's downloaded, I need to update the product count in table 2 according to which product it is in table 1. Make sense? Not sure how to go about this, any suggestions please? Thanks, Peter -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
fuseware vs email
Is anyone else not getting their posts through to the list if they post it to the newsgroup? Won -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Hah! I'm an idiot!
So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
why not use a verity collection? Chris Olive, DOEHRS Website Administrator -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 9:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stored Procedure Help
declare a variable and make it equal to the value of member status then test for that value...i.e. declare @memberstatus same datatype as member status field SELECT @memberstatus = MemberStatus FROM Members WHERE MemberID = @ThisMemberID -- If they are not currently active RETURN 2 IF @MemberStatus = 0...etc -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: 12 September 2000 17:01 To: [EMAIL PROTECTED] Subject: Stored Procedure Help How do you refer to the result of a query in a stored procedure? The statement "IF MemberStatus = 0" gives an error of "invalid column name for MemberStatus" -- Check Member Status SELECT MemberStatus FROM Members WHERE MemberID = @ThisMemberID -- If they are not currently active RETURN 2 IF MemberStatus = 0 BEGIN RETURN 2 END Sebastian Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Query Question
This is a multi-part message in MIME format. --=_NextPart_000_0054_01C01CB4.1200B0A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable can someone tell me if there is a way to consolidate this query into one = Query rather than multiple queries like I'm currently doing? cfquery name=3D"Companynumber_Update" datasource=3D"Oco_Adapco" = dbtype=3D"ODBC" UPDATE Ct_productsTemp SET CompanyNumber =3D'1' WHERE CompanyNumber =3D'AP' /cfquery cfquery name=3D"Companynumber_Update" datasource=3D"Oco_Adapco" = dbtype=3D"ODBC" UPDATE Ct_productsTemp SET CompanyNumber =3D'2' WHERE CompanyNumber =3D'NL' /cfquery cfquery name=3D"Companynumber_Update" datasource=3D"Oco_Adapco" = dbtype=3D"ODBC" UPDATE Ct_productsTemp SET CompanyNumber =3D'3' WHERE CompanyNumber =3D'BL' /cfquery Thanks Ben Densmore --=_NextPart_000_0054_01C01CB4.1200B0A0 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 http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2can someone tell me if there is a way = to=20 consolidate this query into one Query rather than multiple queries like = I'm=20 currently doing?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2lt;cfquery = name=3D"Companynumber_Update"=20 datasource=3D"Oco_Adapco" dbtype=3D"ODBC"gt;BRUPDATE = Ct_productsTempBRSET=20 CompanyNumber =3D'1'BRWHEREBRCompanyNumber=20 =3D'AP'BRlt;/cfquerygt;BRlt;cfquery name=3D"Companynumber_Update" = datasource=3D"Oco_Adapco" dbtype=3D"ODBC"gt;BRUPDATE = Ct_productsTempBRSET=20 CompanyNumber =3D'2'BRWHEREBRCompanyNumber=20 =3D'NL'BRlt;/cfquerygt;BRlt;cfquery name=3D"Companynumber_Update" = datasource=3D"Oco_Adapco" dbtype=3D"ODBC"gt;BRUPDATE = Ct_productsTempBRSET=20 CompanyNumber =3D'3'BRWHEREBRCompanyNumber=20 =3D'BL'BRlt;/cfquerygt;/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2Thanks/FONT/DIV DIVFONT face=3DArial size=3D2Ben Densmore/FONT/DIV/BODY/HTML --=_NextPart_000_0054_01C01CB4.1200B0A0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
change the ip to the one you need? Actually fill out the title of your messages? Fred T. Sanders Charlottesville, VA --- There's no such thing as idiot-proof software. Idiots are just too clever for that. - Original Message - From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Cold Fusion User Group" [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 11:14 AM I have just downloaded cf server 4.5 however when I go to the administration section to modify my server settings the browser proceeds to the address of http://127.0.0.1/CFIDE/Administrator/index.cfm and it generates browser message file not found hence I cannot run the admin interface any ideas would be grateful Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
verity? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: 12 September 2000 14:25 To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[ot] ColdFusion Product Timeline
Hi , does anyone know where I can find a ColdFusion , Product time line , ie , when ,what versions were released etc Thanks ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFOBJECT Help
Sorry to post this again, but someone must have an idea what this error message indicates. Looking at it again, I realize it's a CF error, not a COM error. Any ideas? This is my first use of CFOBJECT. What does the "dll was not loaded" error message below mean? The dll is registered on the server and the cfobject action="create" appears to execute correctly. The call to the Login() method is generating the error. It appears the object is being created by CF, since if I try to set an invalid property, say 'GM.blah = "blah"' then I get an 'Unknown name' COM error. Is it possible that CF can instantiate the object without loading the dll (just because the dll is registered on the server)? Code and error message follow. Thanks, Jim cfobject type="COM" action="create" class="GMComAPI.Application" name="GM" cfset GM.CommonFolder = "MSSQL: GoldMine_Sales_And_Marketing: dbo:" cfset GM.SystemFolder = "\\SQLTEST\GoldMine\" cfset GM.GoldMineFolder = "MSSQL: GoldMine_Sales_And_Marketing: dbo:" cfset GM.GMUserName = "ADMIN" cfset GM.SQLUsername = "sa" cfset GM.SQLPassword = "xyz" cfset dummy = GM.Login() --- Error Occurred While Processing Request Error Diagnostic Information The GoldMine dll was not loaded. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (94:1) to (94:26) in the template file d:\web\tqp\test.cfm The specific sequence of files included or processed is: D:\WEB\TQP\TEST.CFM . Date/Time: 09/11/00 21:03:04 Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98) Remote Address: 206.168.47.60 Template: d:\web\moguls\tqp\mgmt\test.cfm --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Web servers
Except that WS has the best documentation of any software, anywhere, and the best support from users and developers. This TOTALLY overshadows any cost advantage IIS purports to have. best, paul At 10:50 AM 9/7/00 -0700, you wrote: The only winning point I'd have for IIS would be the interface, granted I spend more time changing features (so it seems) in website than I am in IIS. Other than that nothing terribly significant between the 2. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
I have just downloaded cf server 4.5 however when I go to the administration section to modify my server settings the browser proceeds to the address of http://127.0.0.1/CFIDE/Administrator/index.cfm and it generates browser message file not found hence I cannot run the admin interface That's odd...I went to the address above and the admin page came back correctly...but your password was the same as mine, and all the settings were just like mine... [...] Seriously, though...have you made certain the ColdFusion services are running on your server? Brandon Whitaker [EMAIL PROTECTED] --- "It'll get used by the same people using Opera. People dressed in black wearing berets." - Dave Watts, on Mozilla "Everytime someone mentions Java the phrase 'cheap plastic toy, that breaks a lot' comes to mind." - Lewis Sellers "The net interprets censorship as damage and routes around it." - John Gilmore -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Hah! I'm an idiot!
Verity works ok. My solution was a little script that read all the directories, pulled out the HTML and CFM tags, then parsed out all the "buzz" words before adding them to a collection. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
Use http://localhost/CFIDE/Administrator/index.cfm ... this always works for me. Joshua Miller Web Site Development Eagle Technologies Group Business Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: AustralianAccommodation.com Pty. Ltd. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 11:14 AM To: [EMAIL PROTECTED]; Cold Fusion User Group Subject: I have just downloaded cf server 4.5 however when I go to the administration section to modify my server settings the browser proceeds to the address of http://127.0.0.1/CFIDE/Administrator/index.cfm and it generates browser message file not found hence I cannot run the admin interface any ideas would be grateful Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [Spawning a background process?]
use cfhttp "Carol Chandler" [EMAIL PROTECTED] wrote: Hello gurus, I have a CF page that uploads a file, and then I need to do some LENGTHY processing of the file (lots of parsing and breaking it into lots of little files). Is there any way I can do the processing in the background, while my user goes on his merry way? I have the Forta books as well as _Mastering Cold Fusion_, but I must not be searching for the right keywords. While I'm at it, when I'm building a file for output, is it better to build it first in a variable (several steps, many concatenations) and do one file write, or build it by appending to the file? (I assume the former, but my 2 MB input file is still timing out after 1500 seconds! There must be a better way!) Thanks very much, Carol -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Upgrading CF Server Pro v3.1.0 to Pro v4.5.1
Hi group, Is there any problem going directly from CF Server Pro ver. 3.1.0.0 directly to Pro 4.5.1? Any pitfalls? Oh, and the software that was purchased appears to be a full retail copy of 4.5.1, not an upgrade. Does this make a difference? Server config. is Win NT Server 4.0 (Build 1381) w/ SP 4, IIS 4.0. Thanks! Ben Braver Information Technology Ultramar Incorporated Avon Refinery 150 Solano Way Martinez, CA 94553-1487 (925) 370-3673 voice (925) 370-3393 fax (510) 716-2557 pager [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
Try substituting "localhost" for 127.0.0.1 tom - Original Message - From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Cold Fusion User Group" [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 11:14 AM I have just downloaded cf server 4.5 however when I go to the administration section to modify my server settings the browser proceeds to the address of http://127.0.0.1/CFIDE/Administrator/index.cfm and it generates browser message file not found hence I cannot run the admin interface any ideas would be grateful Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: Java Script Question
How many of the 99% had punctuation within the PW? best, paul At 02:27 PM 9/8/00 +0100, you wrote: Just as example , I used to work in an ISP with 60,000 user accounts. I ran a password cracker ,with a very average size dictionary , against my pwd file, 99% of the passwords were found in one hour. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
Sounds like a candidate for a verity search. Don't ask me how though cause I've never built one. Although I'm sure someone else on this list can help you. --K -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 6:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Access Relationships
On 9/12/00, Peter Benoit penned: I have 2 tables, which have a relationship of the unique ID. I'm kind of confused how to update table 2, with a matching record from table 1. For instance, if table 1 was products, and table 2 was a download count of those products. Each time it's downloaded, I need to update the product count in table 2 according to which product it is in table 1. Make sense? Not sure how to go about this, any suggestions please? Two ways to go about it. Enter a record into downloads when you enter the product into products. CFQUERY DATASOURCE="mydatasource" INSERT INTO products (product_id,column2,column3,etc) VALUES (#product_id#,#column2#,#column3#,#etc#) /CFQUERY CFQUERY DATASOURCE="mydatasource" INSERT INTO downloads (product_id,downloadcount) VALUES (#product_id#,0) /CFQUERY Then when they download: CFQUERY DATASOURCE="mydatasource" UPDATE downloads SET downloadcount = downloadcount + 1 WHERE product_id = #product_id# /CFQUERY Or let them do it on the fly. CFQUERY DATASOURCE="mydatasource" NAME="indownloads" SELECT product_id FROM downloads WHERE product_id = #product_id# /CFQUERY CFIF downloads.recordcount IS "0" CFQUERY DATASOURCE="mydatasource" INSERT INTO downloads (product_id,downloadcount) VALUES (#product_id#,1) /CFQUERY CFELSE CFQUERY DATASOURCE="mydatasource" UPDATE downloads SET downloadcount = downloadcount + 1 WHERE product_id = #product_id# /CFQUERY /CFIF -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Stored Procedure Help
-- Check Member Status DECLARE @memerStatus int SELECT @memberStatus = MemberStatus FROM Members WHERE MemberID = @ThisMemberID -- If they are not currently active RETURN 2 IF @memberStatus = 0 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Upgrading CF Server Pro v3.1.0 to Pro v4.5.1
Is there any problem going directly from CF Server Pro ver. 3.1.0.0 directly to Pro 4.5.1? Any pitfalls? Yes, your existing CF scripts may not work. CF is significantly pickier about its code than it was back in those days. Your best bet is to set CF 4.5.1 up on a separate server, test your applications on that server, then go from there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Hah! I'm an idiot!
One word for ya... Verity. - Original Message - From: "Gavin Myers" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 6:25 AM Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: fusebox stats
I thot adding a .htm to a fusebox URL enabled stats programs to keep stats on the different fusebox pages requested. Right? Wrong? Yet another senior moment? best, paul At 11:14 AM 9/8/00 -0700, you wrote: I would look at writing a custom tag that keeps track of statistical data (ie hits on a page). -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Latest MDAC ??
you wrote: MDAC was mainly developed to my knowledge This info is wrong. MDAC 2.5 Sp1 is for W2K and NT4. - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 3:45 PM To: [EMAIL PROTECTED] Subject: Re: Latest MDAC ?? MDAC was mainly developed to my knowledge that it is supporting OS Win2000 Is it recommended to Win NT 4 also ? Does s.o. successfully running 2.5 (with or without SP 1) with CF 4.01 without problems ? Uwe - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 11, 2000 9:18 PM Subject: RE: Latest MDAC ?? Are you sure? For a while 2.5 was NOT recommended with CF 4.01, but maybe SP1 to 2.5 solves that? -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 2:23 PM To: [EMAIL PROTECTED] Subject: RE: Latest MDAC ?? Neither, use 2.5 SP1. which can be found at www.microsoft.com/data - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 10:41 AM To: [EMAIL PROTECTED] Subject: OT: Latest MDAC ?? What is the latest MDAC you would run CF 4.01 Server plus WIN NT 4 Server with ? 2.5 or 2.1 SP2 ? Thanks Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Stored Procedure Help
-- Assuming your query returns only one value you can do the following: DECLARE @MemberStatusINT SET @MemberStatus = (SELECT MemberStatus FROM Members WHERE MemberID = @ThisMemberID) IF MemberStatus = 0 BEGIN RETURN 2 END sebastian palmigiani [EMAIL PROTECTED] on 09/12/2000 12:01:07 PM Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Jerry Tolentino/SIAC) Subject: Stored Procedure Help How do you refer to the result of a query in a stored procedure? The statement "IF MemberStatus = 0" gives an error of "invalid column name for MemberStatus" -- Check Member Status SELECT MemberStatus FROM Members WHERE MemberID = @ThisMemberID -- If they are not currently active RETURN 2 IF MemberStatus = 0 BEGIN RETURN 2 END Sebastian Sebastian --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
Use Verity to first make a collection and then search on it. Instructions on how to get started with this are available in the CF Web Application books by Forta, et al. The Allaire docs also explain this but in less detail. Be careful not to allow users to search for, and then view, the raw source code. Steve -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 9:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Latest MDAC ??
This info is wrong. MDAC 2.5 Sp1 is for W2K and NT4. To further clarify this, you don't download and install MDAC on Win2K, because it's built into the operating system. Win2K comes with MDAC 2.5, and Win2K SP1 bumps it to MDAC 2.5 SP1. On Windows NT, MDAC is a separate component, which can be downloaded and installed from http://www.microsoft.com/data/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFOBJECT Help
Assuming you've posted the exact error message, my guess would be that the Goldmine software is not installed properly on the machine where CF is running; I base this on believing the CF on its own could not tell you "The GoldMine dll was not loaded." because it wouldn't know that "GMComAPI.Application" = Goldmine. I'll bet CF is instantiating the Goldmine ActiveX/COM control/object, but that the ActiveX can't contact other pieces of Goldmine. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 12:27 PM To: [EMAIL PROTECTED] Subject: CFOBJECT Help Sorry to post this again, but someone must have an idea what this error message indicates. Looking at it again, I realize it's a CF error, not a COM error. Any ideas? This is my first use of CFOBJECT. What does the "dll was not loaded" error message below mean? The dll is registered on the server and the cfobject action="create" appears to execute correctly. The call to the Login() method is generating the error. It appears the object is being created by CF, since if I try to set an invalid property, say 'GM.blah = "blah"' then I get an 'Unknown name' COM error. Is it possible that CF can instantiate the object without loading the dll (just because the dll is registered on the server)? Code and error message follow. Thanks, Jim cfobject type="COM" action="create" class="GMComAPI.Application" name="GM" cfset GM.CommonFolder = "MSSQL: GoldMine_Sales_And_Marketing: dbo:" cfset GM.SystemFolder = "\\SQLTEST\GoldMine\" cfset GM.GoldMineFolder = "MSSQL: GoldMine_Sales_And_Marketing: dbo:" cfset GM.GMUserName = "ADMIN" cfset GM.SQLUsername = "sa" cfset GM.SQLPassword = "xyz" cfset dummy = GM.Login() --- Error Occurred While Processing Request Error Diagnostic Information The GoldMine dll was not loaded. The error occurred while processing an element with a general identifier of (CFSET), occupying document position (94:1) to (94:26) in the template file d:\web\tqp\test.cfm The specific sequence of files included or processed is: D:\WEB\TQP\TEST.CFM . Date/Time: 09/11/00 21:03:04 Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98) Remote Address: 206.168.47.60 Template: d:\web\moguls\tqp\mgmt\test.cfm --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Weird CFHTTP behaviour in 4.5
The problem is that it is posting the same field twice! I only have one CFHTTPPARAM tag. The effectis the same as having two form fields with the same name. The same code works fine on CF 4.01. Any hints? Frank Mamone -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
another thought make sure your webserver is running, and proper mappings/permissions are in place - Original Message - From: "AustralianAccommodation.com Pty. Ltd." [EMAIL PROTECTED] To: [EMAIL PROTECTED]; "Cold Fusion User Group" [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 11:14 AM I have just downloaded cf server 4.5 however when I go to the administration section to modify my server settings the browser proceeds to the address of http://127.0.0.1/CFIDE/Administrator/index.cfm and it generates browser message file not found hence I cannot run the admin interface any ideas would be grateful Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
if CF server down...
Hello, Our home page is a .cfm file. I tested a scenario if the CF Server failed or did not respond by shutting it down in the Services section of NT's control panel. The error generated is below. I have a simple question: Is there a way to provide a default page in case the CF server crashes or is not responding. I don't like the idea of the error below appearing for our home page. Does the application.cfm file handle this? I already have it handling a bad connection to a Oracle machine w/a default home page (!--- Error template --- CFERROR TYPE="REQUEST" TEMPLATE="defaultx.htm". Thanks for any help or suggestions on this. Robert O. Error Occurred While Processing Request Error Diagnostic Information Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 25) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: if CF server down...
one problem. think about what you just asked. "if CF server is down, can the CF server handle this error?" if the service isn't on, how could the application.cfm file get included and processed? Chris Olive, DOEHRS Website Administrator -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:53 PM To: Cold Fusion Group Subject: if CF server down... Hello, Our home page is a .cfm file. I tested a scenario if the CF Server failed or did not respond by shutting it down in the Services section of NT's control panel. The error generated is below. I have a simple question: Is there a way to provide a default page in case the CF server crashes or is not responding. I don't like the idea of the error below appearing for our home page. Does the application.cfm file handle this? I already have it handling a bad connection to a Oracle machine w/a default home page (!--- Error template --- CFERROR TYPE="REQUEST" TEMPLATE="defaultx.htm". Thanks for any help or suggestions on this. Robert O. Error Occurred While Processing Request Error Diagnostic Information Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 25) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Hotel Booking Engine up
Is there anything like this for a single hotel? I have a request for a system to book everything from rooms to times on the Golf course for a large resort, the trouble is that there is probably a less than one in ten chance of us getting the job (the owners son fancies himself as a html genius) so I don't want to waste too much time or money on the proposal. If there is an application available; or even a page describing how to design booking databases that would cut down our research time, it would help immensely! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Alternative to cftransaction
If the only thing that modifies the database is CF, this could work just fine. It doesn't do exactly the same thing, but it works well enough for your purposes. And you don't need the scope paramaters. Good luck. ;) Ed -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Java Script Question
Actually using special characters in your passwords !@#, etc increases the time it takes to crack exponentially. __ Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM / NETDesign Inc. ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 1:17 PM To: [EMAIL PROTECTED] Subject: Re: OT: Java Script Question How many of the 99% had punctuation within the PW? best, paul At 02:27 PM 9/8/00 +0100, you wrote: Just as example , I used to work in an ISP with 60,000 user accounts. I ran a password cracker ,with a very average size dictionary , against my pwd file, 99% of the passwords were found in one hour. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFOBJECT Help
Jim, If you abort after the CFObject tag, and you do not receive an error, then the dll is instantiated properly. Then move the abort until after the first property that you are trying to set. I think your syntax should be: cfset temp = GM.CommonFolder("MSSQL: GoldMine_Sales_And_Marketing: dbo:") cfset temp = GM.SystemFolder("\\SQLTEST\GoldMine\") etc Let me know if that gets you any further. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Jim McAtee [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 11:27 AM |To: [EMAIL PROTECTED] |Subject: CFOBJECT Help | | |Sorry to post this again, but someone must have an idea what this error |message indicates. Looking at it again, I realize it's a CF error, not |a COM error. Any ideas? | |This is my first use of CFOBJECT. What does the "dll was not loaded" |error message below mean? The dll is registered on the server and the |cfobject action="create" appears to execute correctly. The call to the |Login() method is generating the error. It appears the object is being |created by CF, since if I try to set an invalid property, say 'GM.blah = |"blah"' then I get an 'Unknown name' COM error. Is it possible that CF |can instantiate the object without loading the dll (just because the dll |is registered on the server)? Code and error message follow. | |Thanks, |Jim | |cfobject type="COM" | action="create" | class="GMComAPI.Application" | name="GM" | |cfset GM.CommonFolder = "MSSQL: GoldMine_Sales_And_Marketing: dbo:" |cfset GM.SystemFolder = "\\SQLTEST\GoldMine\" |cfset GM.GoldMineFolder = "MSSQL: GoldMine_Sales_And_Marketing: dbo:" |cfset GM.GMUserName = "ADMIN" |cfset GM.SQLUsername = "sa" |cfset GM.SQLPassword = "xyz" | |cfset dummy = GM.Login() | | |--- |Error Occurred While Processing Request |Error Diagnostic Information | |The GoldMine dll was not loaded. | |The error occurred while processing an element with a general identifier |of (CFSET), occupying document position (94:1) to (94:26) in the |template file d:\web\tqp\test.cfm | |The specific sequence of files included or processed is: |D:\WEB\TQP\TEST.CFM . | | |Date/Time: 09/11/00 21:03:04 |Browser: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98) |Remote Address: 206.168.47.60 |Template: d:\web\moguls\tqp\mgmt\test.cfm |--- | | |--- |--- |Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ |To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Latest MDAC ??
If you can find anything from Allaire that says don't use MDAC 2.5 with CF 4 please let me know. I know of no such warning. Moreover we have used 2.5 on a number of 4.0x production sites since early March. We recently ran into a problem with 2.5 SP1 that appears to affect a very small number of CFQUERY but other than that MDAC 2.5 seems to work very well. - Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 3:19 PM To: [EMAIL PROTECTED] Subject: RE: Latest MDAC ?? Are you sure? For a while 2.5 was NOT recommended with CF 4.01, but maybe SP1 to 2.5 solves that? -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 2:23 PM To: [EMAIL PROTECTED] Subject: RE: Latest MDAC ?? Neither, use 2.5 SP1. which can be found at www.microsoft.com/data - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 10:41 AM To: [EMAIL PROTECTED] Subject: OT: Latest MDAC ?? What is the latest MDAC you would run CF 4.01 Server plus WIN NT 4 Server with ? 2.5 or 2.1 SP2 ? Thanks Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Hah! I'm an idiot!
I am almost finished a verity tutorial, if this doesn't help, I also have the script I mentioned earlier that reads from the directories and parses out all the html, cfm tags, and "noise" words so that verity returns better matches. Check the search on this site, and if you like it, I will send you a copy. (off list email - [EMAIL PROTECTED]) http://cfhub.com/advanced/verity/index.cfm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP, CFWDDX, cflock'ing it - cfcatch'in and cftry'ing.
On 9/12/00, Ben Lowndes penned: I'm using CFHTTP to hit a page that produces WDDX, then trying to deserialise the wddx. snip CFWDDX action="WDDX2CFML" input="#CFHTTP.FileContent#" output="RequestResult" I may be wrong here. I'm on a roll with wrong answers lately. LOL I'm not sure you CAN pick up a wddx packet as filecontent. I just did a little test and I get XML errors and unknown element found errors whenever I try and pick up any WDDX that is any kind of complex structure like a query. If I do the WDDX2CFML on the remote page then output that, it's fine. If it's a page that people also access straightaway, then you could output inside of html comment tags then strip out that part of the cfhttp.filecontent. Of course, hopefully you have access to edit the remote page to suit your needs. This is my remote test page. cfset newquery = QueryNew("cell") cfset temp = QueryAddRow(newquery) cfset temp = QuerySetCell(newquery, "cell", test1) cfset temp = QueryAddRow(newquery) cfset temp = QuerySetCell(newquery, "cell", test2) CFWDDX action="CFML2WDDX" input="#newquery#" output="content" CFWDDX action="WDDX2CFML" input="#content#" output="testquery" !--StartCFOUTPUT query="testquery"#cell#br/CFOUTPUTEnd-- This is the calling page: cfhttp url="http://192.168.0.5/testing/wddx/test.cfm" method="POST" cfhttpparam type="formfield" name="test1" value="This is row 1" cfhttpparam type="formfield" name="test2" value="This is row 2" /cfhttp cfset start = find("!--Start", cfhttp.filecontent) + 9 cfset end = find("End--", cfhttp.filecontent) cfset length = end - start CFOUTPUT#mid(cfhttp.filecontent, start, length)#/CFOUTPUT This is what I see in the browser: This is row 1 This is row 2 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFStudio 4.5 Memory Hog
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've converted a couple of VAIOs to win2k without any problem and been pretty happy. most of the pages on the site are so much verbiage. Basically there is just a suite of drivers you need to install and, depending on which you need, a best order to install them. Worked like a charm... just be sure to download the drivers and have them on floppy FIRST, or have access to a machine that you can download from while converting. c - -- Chris Lott [EMAIL PROTECTED] | IT Manager | p907-474-3494 -BEGIN PGP SIGNATURE- Version: PGP 6.5.8 for message encryption and authentication: USE PGP! Comment: KeyID: 0x51046CFD iQA/AwUBOb57CtaLYehRBGz9EQKd0gCgmZ0JOdVurUv+H12Xb648LSgN/8IAnjQJ 6n8a6yGkiv8zkXhDnSzU4qkX =ry7j -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Encrypting CF files
Hi All, I am working on an existing project with encrypted CF templates. My question is twofold: 1- How do I encrypt templates? I cannot find anything in the help. I suspect it is an exe or something. 2- I am also told that there is a DECRYPT exe floating around as well. Is it widely available, or is it one of those tools nobody admits to having? Thanks, James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
Yes, Verity. It's a search engine company. Allaire bundles a low-end version of their engine with CF. Steve -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 12:24 PM To: '[EMAIL PROTECTED]' Subject: RE: Hah! I'm an idiot! verity? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stored Procedures
Could you provide an example of a dynamic stored procedure being executed from CF. Currently I just use lots of CFIF in my CFQUERY to build them dynamically, how can I do this and pass it to a stored procedure. Obviously I dont have experience with SP but would like to start utilizing them. Thanks,Adrian -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sebastian Although it is a bit of a chore I'd use stored procedures all of the time if you can. The reason for this is as follows: When you use CFQUERY CF passes the SQL through to SQL Server which then parses the SQL before executing it. If you use CFSTOREDPROC CF calls SQL which SQL SERVER "knows about". i.e. it has already been parsed and it has an execution plan for it. This is why you will see the improved performace than Ben talks about in his book. There are also many other advantages (in my view) in that getting SQL Server to handle the SQL makes it much more flexible than building the SQL statement in CF. A classic example is if you want to build a large dynamic SQL statement it is much easier to do it in an SP by building up a string and then executing it than in CF (at least I reckon it is). -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Latest MDAC ??
o.k. I remember s.o. told me that MDAC 2.1 SP2 is definetely the final MDAC for NT 4 and as 2.5 was released I thought it is only written for Win2000. But now I know... Thank you all. Uwe - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 7:49 PM Subject: RE: Latest MDAC ?? This info is wrong. MDAC 2.5 Sp1 is for W2K and NT4. To further clarify this, you don't download and install MDAC on Win2K, because it's built into the operating system. Win2K comes with MDAC 2.5, and Win2K SP1 bumps it to MDAC 2.5 SP1. On Windows NT, MDAC is a separate component, which can be downloaded and installed from http://www.microsoft.com/data/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
verty... cool, thanks guys I'll look into that. -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 12:43 PM To: [EMAIL PROTECTED] Subject: RE: Hah! I'm an idiot! Use Verity to first make a collection and then search on it. Instructions on how to get started with this are available in the CF Web Application books by Forta, et al. The Allaire docs also explain this but in less detail. Be careful not to allow users to search for, and then view, the raw source code. Steve -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 9:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Ok, What is Fusebox?
What is Fusebox? I keep hearing about it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Latest MDAC ??
Just to stir up more problems MDAC 2.6 comes with SQL 2000... Thanks, Neil - Original Message - From: "Steve Pierce" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 1:30 PM Subject: RE: Latest MDAC ?? you wrote: MDAC was mainly developed to my knowledge This info is wrong. MDAC 2.5 Sp1 is for W2K and NT4. - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 3:45 PM To: [EMAIL PROTECTED] Subject: Re: Latest MDAC ?? MDAC was mainly developed to my knowledge that it is supporting OS Win2000 Is it recommended to Win NT 4 also ? Does s.o. successfully running 2.5 (with or without SP 1) with CF 4.01 without problems ? Uwe - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 11, 2000 9:18 PM Subject: RE: Latest MDAC ?? Are you sure? For a while 2.5 was NOT recommended with CF 4.01, but maybe SP1 to 2.5 solves that? -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 2:23 PM To: [EMAIL PROTECTED] Subject: RE: Latest MDAC ?? Neither, use 2.5 SP1. which can be found at www.microsoft.com/data - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 11, 2000 10:41 AM To: [EMAIL PROTECTED] Subject: OT: Latest MDAC ?? What is the latest MDAC you would run CF 4.01 Server plus WIN NT 4 Server with ? 2.5 or 2.1 SP2 ? Thanks Uwe SD Solutions Lange Zeile 27 85435 Erding Fon: 08122/903791 Fax: 08122/903792 Mail: [EMAIL PROTECTED] Web: www.sdsolutions.de -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Encrypting CF files
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 1- How do I encrypt templates? I cannot find anything in the help. I suspect it is an exe or something. Depending on your version, it's either cfcrypt.exe or cfencode.exe in the c:\CFusion\Bin directory. Both apps do the same thing, so I'm not really sure why they changed the name. It only comes w/ CFServer, not Studio for some odd reason 2- I am also told that there is a DECRYPT exe floating around as well. Is it widely available, or is it one of those tools nobody admits to having? It is indeed one of those tools few people admit to having, but I suspect most folks who do any serious amount of CF coding have probably obtained a copy by now... Maybe an anonymous poll of the list is in order? ;-) Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBOb59lAraVoMWBwRBEQJUCQCgoLiBMTI3vknYw2jpd2kHPF8idi4An1Yj S16I3xqMePWvzNFlegd0NrPx =SDzm -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
what happens after browser STOPS
If a browsers requests a template that has a fairly hefty query, and the user clicks the STOP, or decides to browse elsewhere, what happens to that query running in MSSQL7..? Does it terminate or just keep on running. In my environment it appears that it keeps on processing. Enviro: WSP 2.3.7 CF 4.01 M$-SQL7 Thanks,Adrian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hotel Booking Engine up
Wayne, An interface that might give you some ideas is http://service.austin360.com, where as a consumer, you can schedule auto repair appointments, exterminating service, maid service, etc. If you have any questions in particular about that site, contact me off list. Dan -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 5:36 AM |To: [EMAIL PROTECTED] |Subject: Re: Hotel Booking Engine up | | |Is there anything like this for a single hotel? I have a request for a |system to book everything from rooms to times on the Golf course |for a large |resort, the trouble is that there is probably a less than one in ten chance |of us getting the job (the owners son fancies himself as a html |genius) so I |don't want to waste too much time or money on the proposal. | |If there is an application available; or even a page describing how to |design booking databases that would cut down our research time, it would |help immensely! | | | |--- |--- |Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ |To Unsubscribe visit |http://www.houseoffusion.com/index.cfm?|sidebar=listsbody=lists/cf_ |talk or send a message to [EMAIL PROTECTED] with |'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Java Script Question
What cracking tool are you using out of curiosity and on what OS? I tried L0phtCrack on Win2k, but the 2.5 version does not display the results. They supposedly have a 3.0 version coming that will support Win2K, but no word on when. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Pete Freitag [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 1:14 PM |To: [EMAIL PROTECTED] |Subject: RE: OT: Java Script Question | | |Actually using special characters in your passwords !@#, etc increases the |time it takes to crack exponentially. | |__ |Pete Freitag ([EMAIL PROTECTED]) |CFDEV.COM / NETDesign Inc. |ColdFusion Developer Resources |http://www.cfdev.com/ | |-Original Message- |From: paul smith [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 1:17 PM |To: [EMAIL PROTECTED] |Subject: Re: OT: Java Script Question | | |How many of the 99% had punctuation within the PW? | |best, paul | |At 02:27 PM 9/8/00 +0100, you wrote: |Just as example , I used to work in an ISP with 60,000 user |accounts. I ran |a password cracker ,with a very average size dictionary , against my pwd |file, 99% of the passwords were found in one hour. | |--- |- |-- |Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ |To Unsubscribe visit |http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or |send a message to [EMAIL PROTECTED] with 'unsubscribe' in |the body. | |--- |--- |Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ |To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Encrypting CF files
cfencrypt is in the in dicectory.. Decrypt can only work in some cases... -Brian - Original Message - From: J.Milks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 12:45 PM Subject: Encrypting CF files Hi All, I am working on an existing project with encrypted CF templates. My question is twofold: 1- How do I encrypt templates? I cannot find anything in the help. I suspect it is an exe or something. 2- I am also told that there is a DECRYPT exe floating around as well. Is it widely available, or is it one of those tools nobody admits to having? Thanks, James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Encrypting CF files ;-P
That tool does not exist. Its all a big hoax. Stop looking for it. ..move along..move along.. there's nothing to see here.. ;-P -Gel - Original Message - From: Zachary Bedell [EMAIL PROTECTED] It is indeed one of those tools few people admit to having, but I suspect most folks who do any serious amount of CF coding have probably obtained a copy by now... Maybe an anonymous poll of the list is in order? ;-) Best regards, Zac Bedell -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Escaping #
I have turned HTML code into a list with "" as the delimiter. There are # signs in the HTML code for the colors. How do you escape the # signs in the HTML code without manually changing it into ##. Using the List functions generates an error when # is encountered. Sebastian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
MS Access getting the FieldID from a newly inserted record
I am using access 2000 for an intranet site, and would like to know how to get the recordid of a newly created record. here is the code. cfquery name="AddRecord" datasource="#DSN#" INSERT INTO TableName (FieldName) VALUES('#Form.FieldValue#') /cfquery I want to be able to display the newly created record, but need the key value created by the autonumber feature in access. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: if CF server down...
You might be able to write an ISAPI filter, or an Apache Module to do it, but remember that you are generating overhead to every page hit by doing this. I think it would make more sense to write a service that polls the status of the server, and restarts it if necessary. You should also reduce the settings for Reduce after x unresponsive requests in the CF administrator. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:53 PM To: Cold Fusion Group Subject: if CF server down... Hello, Our home page is a .cfm file. I tested a scenario if the CF Server failed or did not respond by shutting it down in the Services section of NT's control panel. The error generated is below. I have a simple question: Is there a way to provide a default page in case the CF server crashes or is not responding. I don't like the idea of the error below appearing for our home page. Does the application.cfm file handle this? I already have it handling a bad connection to a Oracle machine w/a default home page (!--- Error template --- CFERROR TYPE="REQUEST" TEMPLATE="defaultx.htm". Thanks for any help or suggestions on this. Robert O. Error Occurred While Processing Request Error Diagnostic Information Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 25) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Linkshare App
Has anyone here written the code, or seen it written somewhere that tracks the user information and siteid information that Linkshare requires? .. and then generate the reports? Before I stick my nose too deeply into this code, has anyone does this? Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFHTTP, CFWDDX, cflock'ing it - cfcatch'in and cftry'ing.
Ben, In answer to your question regarding CFHTTP under CF 4.51... forget about it. I'm now using a COM object called ASPHTTP (from www.serverobjects.com) within my CF scripts. It is rock solid -- the only downside is that it does not permit HTTPS.There is another COM object, ASPTEAR, that also has a good reputation. Bottomline, I wouldn't (and don't) rely on CFHTTP. Regards, Chris - Original Message - From: "Ben Lowndes" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 9:50 AM Subject: CFHTTP, CFWDDX, cflock'ing it - cfcatch'in and cftry'ing. Hi, First of all I'm using CF4.51 Pro. I'm using CFHTTP to hit a page that produces WDDX, then trying to deserialise the wddx. I'm aware that there were many problems with CFHTTP in CF4.01 but don't know what it's like now, but under my own basic testing I've experienced repeated fails So, I'm trying to minimise the errors visible to the user. I've encapsultated by communication with the remote server in a custom tag and this is the CFTRY and CFLOCK -ing I'm doing: CFTRY CFLOCK type="READONLY" scope="SESSION" timeout="20" throwontimeout="Yes" CFHTTP throwonerror="Yes" method="POST" url="#URL#" timeout="5" CFHTTPPARAM type="FORMFIELD" name="value1" value="#ATTRIBUTES.value1#" CFHTTPPARAM type="FORMFIELD" name="value2" value="#ATTRIBUTES.value2#" /CFHTTP /CFLOCK CFWDDX action="WDDX2CFML" input="#CFHTTP.FileContent#" output="RequestResult" CFCATCH type="Any" CFSET request.ErrorMessage = "Communications Error" CFMAIL to="#ben#" from="#server_email#" subject="Site error" #CFHTTP.FileContent# /cfmail CFEXIT /CFCATCH /CFTRY So, does this all look right??? Will the throwontimeout in cflock and throwonerror in cfhttp be caught by the cfcatch? Should I be using a session scoped readonly cflock around all this? Is CFHTTP a reliable tag to use on a frquently hit site - a few thousand hits a day?? Is there a better alternative to CFHTTP? Is there a better alternative method for providing sites with rapidly changing data than a script that produces WDDX that is accurate at the time of being hit (big question!!)? If anyone can answer just a couple of these questions I'd be very happy!! Thanks Ben. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFOBJECT Help
A... Very good point. The COM object is essentially a wrapper for the GoldMine API dll. That must be the dll that isn't loaded (and it's not, since GM is actually running on a separate machine, along with MS SQL). I think I'll try calling the COM object on the other machine using context="Remote" rather than on the local one. Don't know what I'll run into. Can a remote server object be instantiated if it's a dll? Thanks, Jim -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, September 12, 2000 12:44 PM Subject: RE: CFOBJECT Help Assuming you've posted the exact error message, my guess would be that the Goldmine software is not installed properly on the machine where CF is running; I base this on believing the CF on its own could not tell you "The GoldMine dll was not loaded." because it wouldn't know that "GMComAPI.Application" = Goldmine. I'll bet CF is instantiating the Goldmine ActiveX/COM control/object, but that the ActiveX can't contact other pieces of Goldmine. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Ok, What is Fusebox?
Mark, "Fusebox" is a method of structuring your ColdFusion applications for ease of maintenance. Instead of writing each application page with separate queries in each page, you write all of your components separately, then use them as needed in your pages via includes. This is quite advantageous, especially if you find yourself using the same queries over and over in every page. So, as an example, you might structure your site with a folder called "queries", a folder called "blocks" etc. You would then write your queries and save each one in a .cfm file with a file name like "qry_getmaindata", "qry_calculatedate", etc. Those files with the qry prependage would go in the query folder. Similarly, for any code that is used to display output (tables, output tags, etc.), you would put those .cfm files in separate folder called "blocks" and prepend those with "blk_". The idea is that each of these separate pages performs a very specific task. Then, when you need to use them, you just call them into your pages via includes. Makes code reuse so much easier. I sort of think of it like building applications "lego-style" ;) You can read all about it at http://www.fusebox.org. Terri Original Message Follows From: "Mark Adams" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Ok, What is Fusebox? Date: Tue, 12 Sep 2000 11:48:22 -0700 What is Fusebox? I keep hearing about it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Full Text Searching
I am looking for a full-text searching software that will look at the actual text and other attributes of documents. Cold Fusion's Verity does not seem to support this functionality. Can anyone recommend a really good and reliable software package or vendor? Thanks in advance. Jerry T. [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help I cannot access by local host cf server admin facility
Yes the web serer is running as I am able to browse my pages of code I write to check the output the code generates the mappings you refer to are modified with cf studio correct ?? - Original Message - From: "Fred T. Sanders" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 13, 2000 3:56 AM Subject: Re: | another thought make sure your webserver is running, and proper | mappings/permissions are in place | | - Original Message - | From: "AustralianAccommodation.com Pty. Ltd." | [EMAIL PROTECTED] | To: [EMAIL PROTECTED]; "Cold Fusion User Group" | [EMAIL PROTECTED] | Sent: Tuesday, September 12, 2000 11:14 AM | | | I have just downloaded cf server 4.5 however when I go to the | administration | section to modify my server settings the browser proceeds to the address | of | | http://127.0.0.1/CFIDE/Administrator/index.cfm | | and it generates browser message file not found hence I cannot run the | admin | interface | | any ideas would be grateful | | | | Kind Regards | | Claude Raiola (Director) | AustralianAccommodation.com Pty. Ltd. | Website: www.AustralianAccommodation.com | Email: [EMAIL PROTECTED] | | | -- | | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit | http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or | send a message to [EMAIL PROTECTED] with 'unsubscribe' in | the body. | | | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. | -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help I cannot access by local host cf server admin facility
tried the change you suggested however the result is still the same - Original Message - From: "tom muck" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 13, 2000 3:11 AM Subject: Re: | Try substituting "localhost" for 127.0.0.1 | | tom | | - Original Message - | From: "AustralianAccommodation.com Pty. Ltd." | [EMAIL PROTECTED] | To: [EMAIL PROTECTED]; "Cold Fusion User Group" [EMAIL PROTECTED] | Sent: Tuesday, September 12, 2000 11:14 AM | | | I have just downloaded cf server 4.5 however when I go to the administration | section to modify my server settings the browser proceeds to the address of | | http://127.0.0.1/CFIDE/Administrator/index.cfm | | and it generates browser message file not found hence I cannot run the admin | interface | | any ideas would be grateful | | | | Kind Regards | | Claude Raiola (Director) | AustralianAccommodation.com Pty. Ltd. | Website: www.AustralianAccommodation.com | Email: [EMAIL PROTECTED] | | | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit | http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send | a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. | | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help I cannot access by local host cf server admin facility
I tried your suggestion no difference unfortunately - Original Message - From: "Joshua Miller" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 13, 2000 2:50 AM Subject: RE: | Use http://localhost/CFIDE/Administrator/index.cfm ... this always works for | me. | | Joshua Miller | Web Site Development | Eagle Technologies Group | Business Solutions for the Next Generation | www.eagletgi.com | [EMAIL PROTECTED] | | | | -Original Message- | From: AustralianAccommodation.com Pty. Ltd. | [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, September 12, 2000 11:14 AM | To: [EMAIL PROTECTED]; Cold Fusion User Group | Subject: | | | I have just downloaded cf server 4.5 however when I go to the administration | section to modify my server settings the browser proceeds to the address of | | http://127.0.0.1/CFIDE/Administrator/index.cfm | | and it generates browser message file not found hence I cannot run the admin | interface | | any ideas would be grateful | | | | Kind Regards | | Claude Raiola (Director) | AustralianAccommodation.com Pty. Ltd. | Website: www.AustralianAccommodation.com | Email: [EMAIL PROTECTED] | | | -- -- | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit | http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or | send a message to [EMAIL PROTECTED] with 'unsubscribe' in | the body. | | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. | -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help I cannot access by local host cf server admin facility
Yes they are running if they were not I would not be able to browse my code on an open page in cf studio correct ??? - Original Message - From: "Brandon Whitaker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 13, 2000 2:48 AM Subject: Re: | I have just downloaded cf server 4.5 however when I go to the | administration | section to modify my server settings the browser proceeds to the address of | | http://127.0.0.1/CFIDE/Administrator/index.cfm | | and it generates browser message file not found hence I cannot run the | admin | interface | | That's odd...I went to the address above and the admin page came back | correctly...but your password was the same as mine, and all the settings | were just like mine... | | [...] | | Seriously, though...have you made certain the ColdFusion services are | running on your server? | | Brandon Whitaker | [EMAIL PROTECTED] | --- | "It'll get used by the same people using Opera. People dressed in black | wearing berets." | - Dave Watts, on Mozilla | | "Everytime someone mentions Java the phrase 'cheap plastic toy, that breaks | a lot' comes to mind." | - Lewis Sellers | | "The net interprets censorship as damage and routes around it." | - John Gilmore | | | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Web servers
On Tue, 12 Sep 2000, paul smith spake thusly: Except that WS has the best documentation of any software, anywhere, and the best support from users and developers. This TOTALLY overshadows any cost advantage IIS purports to have. I would have to disagree on both points, those accolades belong to Apache, nuff' said best, paul At 10:50 AM 9/7/00 -0700, you wrote: The only winning point I'd have for IIS would be the interface, granted I spend more time changing features (so it seems) in website than I am in IIS. Other than that nothing terribly significant between the 2. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** "There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence." - Jeremy S. Anderson *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Java Script Question
I dont think a username is nor shouldbe considered sensitive information. It goes against most of the security philosophy and or methodology in existence. If you hide the username its considered "Security through obscurity" because you are relying on the fact that no one will "discover" the usernames. You should expect and depend on the fact that your usernames are exposed to the outside world. Granted you can go to measures to protect usernames and give a little added buffer. If your going to use passwords that should be where you concentrate making it secure, not hiding details and such. A really great book "Applied Cryptography" by Bruce Schneier Written by one of the biggest security advocates out there (also one of the best) outlines what security via obscurity is and how it does *NOT* protect you. And about cracking passwords, if the encryption is strong enough, cracking a password will not occur in an hour, if ever. I recently installed an OpenBSD system on a machine of mine at home. Instead of using DES as the encryption algorithm it uses Blowfish which has been in use for a while and available public domain. Brute forcing the passwords on that system would not be a trivial task (lets hope quantum computing does not come along and make a liar out of me ;) Most systems give you their username just by virture of details. A non work email I have is [EMAIL PROTECTED] It doesnt take much to figure out jallen is probably my username. Usernames on every *nix/login ive used / any login ive seen has always been visible, which means someone peeking over my shoulder has my username. In a very controlled environment it may be possible to hide more details, but given a determined hacker and someone who knows a bit more than your average 'cracker' who isnt going to really be able to figure out what to do beyond downloading a utility to Brute Force Decrypt your passwords. Anyhow, these are more my beliefs just reenforced by what I have read and experienced:) So I agree with courtney, however YMMV -Original Message- From: Courtney Payne [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:25 AM To: '[EMAIL PROTECTED]' Subject: RE: OT: Java Script Question This is true. However, I wouldn't think usernames would be considered sensitive info. Courtney E. Payne, Developer Fig Leaf Software "We've got you covered" [EMAIL PROTECTED] www.figleaf.com -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 8:09 AM To: [EMAIL PROTECTED] Subject: Re: OT: Java Script Question your database beforehand and (using WDDX) make it available to your JS so that you can do the check right there on the client, without having to hit the problem with that is anyone can get a list of your usernames just by looking at the source ~Justin MacCarthy -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Ok, What is Fusebox?
It is a coding methodology that produces sound cf code. Fusebox increases efficiency, productivity, and reduce the time it takes to build a web application, it also makes the reuse of code easier. At 11:48 AM 9/12/00 -0700, you wrote: What is Fusebox? I keep hearing about it. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
I used a verity search but moved out the directories I didn't want searched, replaced them later and now that collection forms the basis of my search page Ricahrd Kern Web Developer, RSAcompanies -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 10:20 AM To: '[EMAIL PROTECTED]' Subject: RE: Hah! I'm an idiot! why not use a verity collection? Chris Olive, DOEHRS Website Administrator -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 9:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dynamic Framesets
Is there a way to determine the dimensions of an HTML document. Reason: attempting to create a dynamic-sized frameset. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: if CF server down...
You're right...that's what happens when you type faster than you think. Is there something in the pipeline that can prevent an error or "page not found" if the CF server fails?...I guess that's what I meant... Robert O. -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 1:10 PM To: '[EMAIL PROTECTED]' Subject: RE: if CF server down... one problem. think about what you just asked. "if CF server is down, can the CF server handle this error?" if the service isn't on, how could the application.cfm file get included and processed? Chris Olive, DOEHRS Website Administrator -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:53 PM To: Cold Fusion Group Subject: if CF server down... Hello, Our home page is a .cfm file. I tested a scenario if the CF Server failed or did not respond by shutting it down in the Services section of NT's control panel. The error generated is below. I have a simple question: Is there a way to provide a default page in case the CF server crashes or is not responding. I don't like the idea of the error below appearing for our home page. Does the application.cfm file handle this? I already have it handling a bad connection to a Oracle machine w/a default home page (!--- Error template --- CFERROR TYPE="REQUEST" TEMPLATE="defaultx.htm". Thanks for any help or suggestions on this. Robert O. Error Occurred While Processing Request Error Diagnostic Information Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 25) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). - --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: if CF server down...
I think on 4.5.1, at least on linux, I think you can specify an error page to be displayed if the apache module can not reach the CF application server (the CF server is down). RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Encrypting CF files
1. there's an executable in the Cfusion\bin directory of your server install called "Cfcrypt". It accepts command line parameters. Be careful about writing over your source code, though (w/o having a backup copy). 2. Don't know of a decrypting tool...sounds interesting, though! joe craven applications engineer business systems group Akin Gump, et al (202) 416-5026 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: J.Milks [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:46 PM To: [EMAIL PROTECTED] Subject:Encrypting CF files Hi All, I am working on an existing project with encrypted CF templates. My question is twofold: 1- How do I encrypt templates? I cannot find anything in the help. I suspect it is an exe or something. 2- I am also told that there is a DECRYPT exe floating around as well. Is it widely available, or is it one of those tools nobody admits to having? Thanks, James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message may be an attorney-client communication and/or work product and as such is privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF vs UltraDev
Personally I love UD. I can whip out a simple app in a day, and a more complex one in about 5 days. Compared to CF where it would take me a week for somthing simple a month for something a bit more advanced. When It comes down to it there is no VS to CF Studio. Studio will always be essential. But if rapid deployment is what you're after, give it a try. Also, UD will only be as good as the developers supporting it. If you build a few nice server behaviors [Please DO] like CFFile the like, users will flock to using it. Right now the hard core JSP ASP developers are whipping out Server Behaviors objects for it. On the same note, for a beginning web designer, moving to Ultra Dev, may give that user enough courage when it comes to databases, to start to learn the code. That's what its aboutto learn. Encourage learning. -paul -Original Message- From: Terri Stocke [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 10:04 AM To: [EMAIL PROTECTED] Subject:RE: CF vs UltraDev Actually, UltraDev was not necessarily meant to be a replacement for ColdFusion--it was developed to enhance the development environment and create a more "wysiwyg" environment for more rapid development. You can choose a default platform and change it at any time (even on a per-project basis). It has a very nice interface for building your queries, and it allows you to drag and drop the variables right into the page, wherever you want them displayed. You can very easily incorporate Next N browsing, e-commerce, regular expressions, etc. Basically, anything you could do with ColdFusion, JSP or ASP--you can do with UltraDev. The nice thing is, you don't even have to buy a new app server--just use your existing one. Per Macromedia's site: "UltraDev currently supports ASP 2.0, ColdFusion, and the JSP 1.0 server including Microsoft IIS, Allaire ColdFusion, IBM WebSphere, BEA WebLogic, and the Netscape Enterprise Server. However, UltraDev can be extended to support any server." And it supports "ODBC, JDBC, or ADO relational databases including Oracle, Sybase, Informix, Microsoft SQL Server, and Microsoft Access." This is why their site still showed a .cfm extension. They very well may have used UltraDev, but their server is a ColdFusion server. Therefore, they would have had it set to default to the CF technologies. Similarly, if they were using IIS, they would have defaulted to ASP and had a .asp extension. I went to a demonstration held by Macromedia on this, and I was quite impressed. I am currently evaluating UltraDev for our Software Development Team. Though it currently does not have anything in place for version control (you would still have to use something like SourceSafe), they plan on implementing this in the next version, which is due to be out by the end of this year. I am absolutely amazed at the speed with which one can construct applications. Things that would take a couple of hours in ColdFusion Studio took a matter of minutes in UltraDev. And, you have complete access to your HTML and SQL, should you need to create anything more advanced than the interface will let you accomplish. I would highly recommend checking it out (and you can download the demo) at http://www.macromedia.com/software/ultradev/. Terri Original Message Follows From: Peter Tilbrook [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: CF vs UltraDev Date: Tue, 12 Sep 2000 09:23:45 +0930 Heh heh! Any wonder. They use CF on their site too: http://www.internet.au.com Peter Tilbrook Internet Applications Developer Aspect Computing Pty. Ltd. 19-25 Moore Street Turner, ACT, 2612 AUSTRALIA http://www.aspect.com.au Phone: (02) 6247 7677 Fax: (02) 6249 1620 Mobile: 0428 765 020 ACT ColdFusion Users Group - http://203.37.24.198 -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 September 2000 9:47 To: CF Talk (E-mail) Subject: CF vs UltraDev FYI - October issue of internet.au (an Australian Internet mag for those who may not have heard of it) rated Ultradev at 3/5 and CF at 4/5. Reviewer felt that CF was more reliable and user friendly than ASP. But I guess we all new this. 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
RE: Hotel Booking Engine up
The application I made has 2 options. You can use it per hotel or you can set it up to be a travelscape of sorts. Email me off list if you're interested or go to http://www.reactivevision.com/products/ Robert Everland III -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 6:36 AM To: [EMAIL PROTECTED] Subject: Re: Hotel Booking Engine up Is there anything like this for a single hotel? I have a request for a system to book everything from rooms to times on the Golf course for a large resort, the trouble is that there is probably a less than one in ten chance of us getting the job (the owners son fancies himself as a html genius) so I don't want to waste too much time or money on the proposal. If there is an application available; or even a page describing how to design booking databases that would cut down our research time, it would help immensely! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: what happens after browser STOPS
Adrian, That would definitely be correct for MSSQL7, and I would suspect is probably the case for all ODBC connected databases. MSSQL does not know the pipe has been broken until it goes to return the results to the ODBC handle that was created at the start of the session. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.675.3115 |-Original Message- |From: Adrian Cesana [mailto:[EMAIL PROTECTED]] |Sent: Tuesday, September 12, 2000 2:07 PM |To: [EMAIL PROTECTED] |Subject: what happens after browser STOPS | | |If a browsers requests a template that has a fairly hefty query, and the |user clicks the STOP, or decides to browse elsewhere, what happens to that |query running in MSSQL7..? Does it terminate or just keep on |running. In my |environment it appears that it keeps on processing. | |Enviro: |WSP 2.3.7 |CF 4.01 |M$-SQL7 | |Thanks,Adrian | |--- |--- |Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ |To Unsubscribe visit |http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_ |talk or send a message to [EMAIL PROTECTED] with |'unsubscribe' in the body. | -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT: Java Script Question
Yes, I include special chars within passwords all the time, even on passwords without punctuation that are not in any dictionary. best, paul At 02:13 PM 9/12/00 -0400, you wrote: Actually using special characters in your passwords !@#, etc increases the time it takes to crack exponentially. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: if CF server down...
As far as I know, if CF goes down there isn't a way to prevent what you are experiencing unless you create a ISAPI filter to test CF's state prior to passing the request from IIS to CF, this assumes you are using MS Internet Information Server. The way it works is that IIS receives the initial request, checks the MIME type/file extension, and then passes the request on to the process that has been associated with that MIME type. Although IIS can be set to check for the file's existence it doesn't check that the target process if functioning, hence your error. The same would be true for any processing engine be it Perl, PHP, Tcl, JSP, etc. Web servers will let you set default pages but, they go down the list of allowed filenames and serve the first one that they find. So, again, if the .cfm file exists in the directory then the web server will pass the request on the CF. If you put an ASP page first in the list then that will always be served as long as it exists. I guess you could create a scheduled task that requested a particular .cfm page and if an error were returned, verified by parsing the returned text, then you could rename/move/delete the .cfm file and have an appropriate plain text/html or ASP page as the second entry in the default list. When IIS didn't find the correct .cfm file then it would server the other file. Now that I think about it, I do know how to do this ... I'll get back to you, time to hack. Steve -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:10 PM To: '[EMAIL PROTECTED]' Subject: RE: if CF server down... one problem. think about what you just asked. "if CF server is down, can the CF server handle this error?" if the service isn't on, how could the application.cfm file get included and processed? Chris Olive, DOEHRS Website Administrator -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 2:53 PM To: Cold Fusion Group Subject: if CF server down... Hello, Our home page is a .cfm file. I tested a scenario if the CF Server failed or did not respond by shutting it down in the Services section of NT's control panel. The error generated is below. I have a simple question: Is there a way to provide a default page in case the CF server crashes or is not responding. I don't like the idea of the error below appearing for our home page. Does the application.cfm file handle this? I already have it handling a bad connection to a Oracle machine w/a default home page (!--- Error template --- CFERROR TYPE="REQUEST" TEMPLATE="defaultx.htm". Thanks for any help or suggestions on this. Robert O. Error Occurred While Processing Request Error Diagnostic Information Server busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 25) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Narrow-down search...
I'm trying to find the best way to create a search routine that allows me to "narrow-down" the choices as the user types. SOrt of like what Microsoft Help does. If I have a query of 50 items, and the user types a "b", then everything that starts with "b" is left, but everything else is parsed out. If they then type an "a", then everything starting with "ba" is left, and everything else is parsed out. I've downloaded CF_combosearch, and it's SORT of what I'm looking for, except I'm trying to avoid having to click on a button to submit the search. I want it to update with each keypress. I'm not a Javascript wizard by a longshot, but it seems to me that there should be some way to do this client-side, without re-submitting the form, using javascript. Has anyone else ever written something like this? If not, are there any javascript gurus who can help coach me through doing it myself? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 3:12 PM To: [EMAIL PROTECTED] Subject: Re: Encrypting CF files cfencrypt is in the in dicectory.. Decrypt can only work in some cases... -Brian - Original Message - From: J.Milks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 12:45 PM Subject: Encrypting CF files Hi All, I am working on an existing project with encrypted CF templates. My question is twofold: 1- How do I encrypt templates? I cannot find anything in the help. I suspect it is an exe or something. 2- I am also told that there is a DECRYPT exe floating around as well. Is it widely available, or is it one of those tools nobody admits to having? Thanks, James -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.