Is it possible to delete a local variable?
Umm, I guess the subject says it all. I know the variable doesn't exist when the page has been fully processed, but I want to bin it before then... and I don't mean just set it to null... I mean delete it so that IsDefined(var) returns 0. Thanks Aidan -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ColdFusion FAQ updated
Yes folks, the ColdFusion FAQ at http://www.thenetprofits.co.uk/coldfusion/faq/ has had a sizable update. And all existing users can upgrade for free! Aidan -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Does CF 4.5 Pro Support Advanced Security?
If you want to allow CF to query your NT SAM using the Advanced Security interface (using the CFAUTHENTICATE tag, for example), you need CF Enterprise. sigh I started this a few months back when we were looking to get our first CF server here. CF Pro (4.5+,5) DOES SUPPORT ADVANCED SECURITY. It's an optional module you get prompted for during the install. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: double post - JavaScript and windows
Thanks all who replied. Will -Original Message- From: Jordan Saardchit [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 17:07 To: CF-Talk Subject: RE: double post - JavaScript and windows window.opener.location.href = URL; -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 8:47 AM To: CF-Talk Subject: double post - JavaScript and windows Hi, Just a quick one. I have a window that is opened through clicking on a a href in another window. There is a link in this second window, which when clicked I want to open a page in the first window. Any ideas? Will Swain Hot Horse Ltd http://www.hothorse.com e: [EMAIL PROTECTED] t: 01273 675375 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript Questions Answers
Thanks steve, signed up now :) Will -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: 27 July 2001 19:44 To: CF-Talk Subject: OT: Javascript Questions Answers I've noticed a lot of javascript posts lately and wanted to remind everyone about the JS-Jive javascript group. There are nearly 1100 developers on the list and it's proven to be an excellent resource for Javascript questions. The list was spawned from this one and there are many, many CFers on the list as well. You can join by sending a blank email to mailto:[EMAIL PROTECTED] The home page with more information is at http://groups.yahoo.com/group/JS-Jive Hope to see you all there! Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sort by year
Hi, I have a few hundred articles collected over a few years. What is the proc. to list out articles from database based on year ie; 1. Show all 1995 articles 2. Show all 1996 articles 3. Show all 1997 articles My database has a year column in the table. Thanks Nyon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sort by year
select * from articles where year = the_year_you_want or sleect * from articles order by year mak wl - Original Message - From: nyon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 6:33 PM Subject: Re: Sort by year Hi, I have a few hundred articles collected over a few years. What is the proc. to list out articles from database based on year ie; 1. Show all 1995 articles 2. Show all 1996 articles 3. Show all 1997 articles My database has a year column in the table. Thanks Nyon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Datatype Datetime
Both I keep getting the statement back that itis not consistent with the datatype or length I just did an insert an the DB reported the date back as 01/01/1900, I was trying to manually enter this into the db maybe I should just use this for manual insertions via the Enterprise Manager! -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, 29 July 2001 3:48 PM To: CF-Talk Subject: Re: SQL Datatype Datetime - Original Message - From: Andrew Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, July 28, 2001 11:38 PM Subject: SQL Datatype Datetime Is it possible to have a null Datetime field although I have allowed nulls, it still complains. Or would it be better to have a very distant past date... Have you tried inserting the value NULL, or are you using a zero length string? Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Datatype Datetime
Is it possible to have a null Datetime field although I have allowed nulls, it still complains. Or would it be better to have a very distant past date... OK, the question I have to ask is HOW are you inserting the information? If you do INSERT INTO myTable (myDateField) VALUES (NULL) That will work, but if you try INSERT INTO myTable (myDateField) VALUES ('NULL') Then that is a string with the word NULL in it, not the value NULL Also, via Enterprise Manager, you can't type NULL and expect it to work it out - Pressing Ctrl+0 (that's a Zero, not a capital o) will put NULL into the field When doing an UPDATE, it should read like this; UPDATE myTable SET myDateField=NULL UPDATE myTable SET myDateField='1 Jan 1900' or SET myDateField=#CreateODBCDateTime(myDateValue)# HTH Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Synchronize Web Based DataWith Oulokk
I Have a problem, would you please advice me..how to synchronize data outlook on pc client...with data on server sql..through web base connection would you please.send me source code cfml, or another advice... thank you ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Ouch!
I hope none of you is banking with this outfit! http://www.it-director.com/frame.php?name=Silicon.comurl=http%3A%2F%2Fwww.s ilicon.com%2Fpublic%2Fdoor%3FREQUNIQ%3D996479427%266004REQEVENT%3D%26REQINT1 %3D46106%26REQSTR1%3Dnewsnow Tristram Charnley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
dbType=Query and Joins
Is it me, or do the Joins in Query a Query not work properly? I'm trying to import data from a text file and put it into a SQL Server 7 database, but I only want records which aren't already there... simple enough right? I get the text file via a query; CFQuery datasource=TextImport name=TextImport select Field1, Field2, Field3 from myFile.txt /cfquery Then all of the data in the SQL table CFQuery datasource=SQLdata name=SQLdata select Field1, Field2, Field3 from myTable /cfquery Then I try the join cfquery dbtype=query name=JoinQuery select TextImport.Field1 as Field1, TextImport.Field2 as Field2, TextImport.Field3 as Field3 from TextImport left outer join SQLdata on TextImport.Field1=SQLdata.Field1 where TextImport.Field1 != SQLdata.Field1 /cfquery I know that Query a Query doesn't understand NULLs, so I'm assuming the SQLdata.Field1 won't be NULL but will be empty The problem is that it returns all records and not just the ones that are missing Anyone else have a similar problem and know the solution - I'm tearing what little hair I have left out! Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Why are Query a Query errors so rubbish?
unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag What am I supposed to make of that? The SQL is about 6 lines long, it's not exactly useful, is it??? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: how to re-enable CFREGISTRY?
OK I made a mistake. In the CFAdministrator, I disabled the CFREGISTRY tag. And then I discovered that once you do that, you can no longer use the CFAdministrator. Great. Easy. Read the FAQ (look in the footer). Aidan -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Country - States Database
Just don't ask where it came from :) Where did it come from? (sorry, that was just *asking* for it ;-) Aidan -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Stock Quotes
moreovernews.com offers stocks - they actually use yahoo! They're available in wddx and it's free. Tim Bahlke -Original Message- From: nyon [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 29, 2001 10:40 PM To: CF-Talk Subject: Re: CF Stock Quotes Hi, I need some free live stock quotes without the normal 'powered by' stuff for some companies listed in Nasdaq. Thanks nyon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Ouch!
The expression on that guy's face is priceless! LOL! If he's an actor he did a great job. And its not all bad..Customers just have to wait for them to restore the records from their main banking systems. -Gel -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] I hope none of you is banking with this outfit! http://www.it-director.com/frame.php?name=Silicon.comurl=http%3A%2F%2Fwww.s ilicon.com%2Fpublic%2Fdoor%3FREQUNIQ%3D996479427%266004REQEVENT%3D%26REQINT1 %3D46106%26REQSTR1%3Dnewsnow ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFIF Confusion
Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Confusion
I would use type 'bit' for the field instead of varchar. Where 1 is yes and 0 is no, then in your if check if it is EQ 1 or EQ 0. Mike Michael T. Tangorre Web Applications Developer Office Phone: 703-558-4746 Cellular Phone: 607-426-9277 AIM: CrazyFlash4 Personal Email: [EMAIL PROTECTED] Work Email: [EMAIL PROTECTED] School Email: [EMAIL PROTECTED] This Email contains MillenniuM Information Systems, LLC Privileged Information which is Customer or Business Sensitive. -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Confusion
When in doubt, use Trim() and UCase() functions to make sure, so instead of cfif FIELD1 IS Yes try cfif Trim(UCase(FIELD1)) IS YES See if that helps. Hatton Humphrey -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Confusion
If you can change the data type of the Field1 you would be better to make it a bit field and then use 1 for yes and 0 for no, then your CF logic and your SQL will probably make more sense. Right now your trying to do String Comparisons when what you really want to be doing by what you have put down below is Boolean comparisons. Hope that makes sense, please let me know if you need me to explain more. -Bill Killillay -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is it possible to delete a local variable?
Subject: Is it possible to delete a local variable? Umm, I guess the subject says it all. I know the variable doesn't exist when the page has been fully processed, but I want to bin it before then... and I don't mean just set it to null... I mean delete it so that IsDefined(var) returns 0. No, I don't think you can delete local variables. You can only delete variables if they're contained within a structure, using the StructDelete function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF Confusion
You could check the value of the variable to see if it's really 'Yes' or not: cfoutput FIELD1='#FIELD1#'br /cfoutput Note single quotes surrounding variable output. Check to see if there might be trailing spaces - this might be the problem. HTH, Stephen Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF Confusion
I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx Thats because the correct syntax for SQL would be: WHERE Field1 = 'yes' IS would be the equality check for Cold Fusion. Brian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Confusion
I'm not certain why the SQL statements you noted below would work the way they do, but it's possible that the fields are padded with extra spaces around the yes which is causing a problem. Converting the field type from varchar to integer will solve the problem. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 7:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Confusion
That's because IS is not a valid SQL keyword... I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: query of queries in a custom tag
that did not work. Same error about the value in the from clause being a complex value. -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:19 PM To: CF-Talk Subject: RE: query of queries in a custom tag I'm taking a wild guess without trying it out but maybe try, #evaluate(caller. attributes.query_name)# -Brad -Original Message- From: DeWitt, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 5:11 PM To: CF-Talk Subject: query of queries in a custom tag I am trying to do write a custom tag that I can use to query a query. This tag would take as arguments: query_name query_value datasource rquery orderby sortorder It would look like the following: cfquery name=#Attributes.query_name# datasource=#Attributes.datasource# dbtype=query select cfloop list=#Attributes.query_value.ColumnList# index=i #i# cfif ListFindNoCase(Attributes.query_value.ColumnList,i) is not ListLen(Attributes.query_value.ColumnList) , /cfif /cfloop from #Attributes.query_name# order by #Attributes.orderby# #Attributes.sortorder# /cfquery cfset Caller.#Attributes.rquery# = Attributes.query_name The problem is when I try to reference the attribute query_name. The tag does not know what that value is. If I try to use the attribute query_value it complains about the value being a complex value because it is the actual query. Please do not comment on the code as there could be a typo in this email. But the gist of the issue is I want to have a custom tag that can query a query. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 1:53 PM To: CF-Talk Subject: RE: SkipJack CC stuff My day job uses it... they don't like them because the SDK is for ASP and other Microsoft variations... Nonetheless, as a pure clearer they are great.. their web interface and management consoles thereunder are lacking in many regards... I like them and recommend them as a pure clearer.. -paris -Original Message- From: Chuck Hergenroeder [EMAIL PROTECTED] Date: Fri, 27 Jul 2001 16:20:53 -0400 Subject: RE: SkipJack CC stuff I used it about a year ago. I never had any problems with it, and it was easy to implement. Verisign also has a nice product called PayFlowLink, you might want to check it out. http://www.verisign.com/products/payflow/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 4:00 PM To: CF-Talk Subject: SkipJack CC stuff Anyone using SkipJack to process credit cards? Is it good, or bad? any complaints? I found a couple examples of how to implement CFHTTP commands to communicate with them. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio Trick
I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? Thanks Jan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Confusion
eh-oh: SELECT * FROM Wherever WHERE somefield IS NULL That's because IS is not a valid SQL keyword... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFIF Confusion
That did it! As the other responses indicated, things can get confusing between logical (boolean) comparisons and string comparisons. I really was trying to do a string comparison for the literal word Yes. As Stephen Hait indicated, there were trailing spaces or something that was messing up the statement. I had been outputting the variable and it was showing up fine. Thx - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 10:17 AM Subject: RE: CFIF Confusion When in doubt, use Trim() and UCase() functions to make sure, so instead of cfif FIELD1 IS Yes try cfif Trim(UCase(FIELD1)) IS YES See if that helps. Hatton Humphrey -Original Message- From: Ken Monroe [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:07 AM To: CF-Talk Subject: CFIF Confusion Hello! I'm working with SQL Server 2000 and I have a query I'm confused about. There's a field (FIELD1) that's defined as a VARCHAR. The field contains either Yes or No. I SELECT all records and then want to display somthing different if FIELD1 is a Yes or No. The following structure works: cfif FIELD1 IS NOT No Bunch of code /cfif This structure does not work: cfif FIELD1 IS Yes Bunch of code /cfif I've also notice that in SQL, if I do a: SELECT * FROM TableName WHERE (FIELD1 LIKE 'yes') it works, but SELECT * FROM TableName WHERE (Field1 IS 'yes') does not work... ??? Thx ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio Trick
I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? You have to hit Ctrl+J afterwards Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Code Red Worm: Deadline For Action
I know this is slightly off topic, but since most people are running CF Server on top of WinNT or Win2000, it's highly relevant. CERT believes that Code Red is likely to start spreading again on July 31, 2001, 8:00 PM EDT and has mutated so that it may be even more dangerous. If you are running a Windows NT, or Windows 2000 server and have not patched your system, or removed Index Server mappings from IIS to protect yourself, you need to take immediate action, and either patch your servers yourself, or inform the proper IS / IT people so that the servers can be patched. Here's the official CERT advisory - http://www.cert.org/archive/html/coderedannounce.html Here's the URL to the patch - Windows NT version 4.0: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=30833 Windows 2000 Professional, Server and Advanced Server: http://www.microsoft.com/Downloads/Release.asp?ReleaseID=30800 Idiot Proof Directions on How to Install the Patch - http://www.digitalisland.net/codered/ MS's Security Bulletin - http://www.microsoft.com/technet/treeview/default.asp?url=/technet/secur ity/bulletin/MS01-033.asp Please, patch your systems! Don't be lazy about this, don't procrastinate, just do it! Jay Sudowski HANDY NETWORKS, LLC Tel.: 1-877-70-HANDY Fax: 1-888-800-2FAX http://www.HandyNetworks.com http://www.HandyNetworks.com ICQ 15601511 | AIM Jay Suds - Specializing in Windows 2000 Hosting Solutions Reseller / Managed Dedicated / Colocation Services ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio Trick
Check out Code Templates - Options, Settings. Under Editor, click on Code Templates to see a list of default templates. On my systems, the following code is associated with scriptj and typing scriptj followed by alt+j pops this text into a document at the cursor. SCRIPT LANGUAGE=JavaScript TYPE=text/javascript !-- | //-- /SCRIPT HTH, Stephen I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? Thanks Jan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio Trick
You'll want to setup a Code Template and keyword for it first. F8 -- EDITOR -- CODE TEMPLATES Works great and can save lots of time for things you use frequently. You can also use a Snippet Shortcut to achieve similar results. Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:29 AM To: CF-Talk Subject: CF Studio Trick I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? Thanks Jan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio Trick
After you type scriptj, you have to then hit CTL-J together. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:29 AM To: CF-Talk Subject: CF Studio Trick I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? Thanks Jan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FYI
I found a wonderful bug in CF 4.5 It seems that the Duplicate() function can totally destroy your CF engine if the structure you are copying contains query objects. You will end up with great error messages like SomeVariableName is not a valid attribute for CFSET where the code is cfset SomeVariableName = Some value or Unknown exception and CFMLInterpreterImp::execute At this point the server becomes very unhappy and refuses to parse valid cf tags. There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. -stuart ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Datatype Datetime
Yes, it's fine to have a null value in a datetime field, but you have to be sure you're not passing anything other than a datetime value into it. It's possible that you're trying to send in a blank value, which is actually a set of spaces as opposed to nothing at all, which would be a null value. What I do is put a CFIF around the parts of the SQL statement that involve dates. If there's no date present, I just do nothing with that field. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 10:38 PM To: CF-Talk Subject: SQL Datatype Datetime Is it possible to have a null Datetime field although I have allowed nulls, it still complains. Or would it be better to have a very distant past date... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio Trick
Hello jperlmutter, hey, i was there too (the bald guy with piercings) :) what version of studio are you using? I am running the beta. scriptj then Ctrl-J worked for me -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion --- Monday, July 30, 2001, 10:28:31 AM, you wrote: jBPc I was at the 2001 cf odyssey event this past weekend. When one speaker was jBPc showing us some javascript I thought he typed 'scriptj' in studio, and bang jBPc the entire script header/footer tag and more appeared. I just tried this at jBPc work and it didn't work. Am I doing something wrong? jBPc Thanks jBPc Jan jBPc ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Studio 5.0?
Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:15 AM To: CF-Talk Subject: RE: FYI I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio 5.0?
it's in beta now. to test it, you need to provide your existing CFStu serial number to [EMAIL PROTECTED] when you request participation. -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:12 AM To: CF-Talk Subject: Studio 5.0? Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Studio Trick
Maybe he had it set up as a snippet? You can assign them to hot-keys, although I thought that was the number of keys you pressed at once, not in a specific order. At 10:28 AM 07/30/2001 -0400, you wrote: I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? Thanks Jan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio 5.0?
Mike, I've been using Studio beta 2 since last Thursday. Beta 1 was not fun. I got many fatal exceptions and file sharing violation errors. This version is behaving much better so far. The file tab also hung in beta 1 (didn't refresh when I switched directories) This problem also seems to be fixed. Loryn Tangorre, Mike wrote: Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio 5.0?
Studio 5 is out in Beta 2. -Original Message- From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:12 AM To: CF-Talk Subject: Studio 5.0? Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? If this is the patch to fix Duplicate() on Pro, I could never find it on the web site but a fellow developer was kind enough to point me to a private site to download it...sorry don't have the URL anymore. Support should be able to get it to you since it does exist. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio 5.0?
how much does it differ from 4.52? -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 16:26 To: CF-Talk Subject: Re: Studio 5.0? Mike, I've been using Studio beta 2 since last Thursday. Beta 1 was not fun. I got many fatal exceptions and file sharing violation errors. This version is behaving much better so far. The file tab also hung in beta 1 (didn't refresh when I switched directories) This problem also seems to be fixed. Loryn Tangorre, Mike wrote: Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
Dylan, If you read the KB Article closely *you* will see that the fix applies only to Enterprise, hence my post. Thanks, Chris -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:31 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: FYI had you read the original post closely, you would have seen the reference to knowledgebase article 19107. :) http://www.allaire.com/Handlers/index.cfm?ID=19107Method=Full -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:20 AM To: CF-Talk Subject: RE: FYI Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:15 AM To: CF-Talk Subject: RE: FYI I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FYI
That's why the original poster mentioned the KB article: http://www.allaire.com/Handlers/index.cfm?ID=19107Method=Full Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: Lomvardias, Christopher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 11:20 AM Subject: RE: FYI Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:15 AM To: CF-Talk Subject: RE: FYI I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling Stored Proc....
could you send more information? Database you are using, the error, some code. -Original Message- From: BT [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 28, 2001 8:29 PM To: CF-Talk Subject: Calling Stored Proc I'm getting SQL/ODBC Error when incorporating the following CF code and Stored Procedure... Anyone had this? There are not triggers as well... Error: ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: FYI
Ack - ignore my ramblings... Howie - Original Message - From: Howie Hamlin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 11:34 AM Subject: Re: FYI That's why the original poster mentioned the KB article: http://www.allaire.com/Handlers/index.cfm?ID=19107Method=Full Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
You aren't the only one. I would say it looks like a few people definitely need more coffee this morning. Chris -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:38 AM To: 'Lomvardias, Christopher'; [EMAIL PROTECTED] Subject: RE: FYI more coffee! -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:32 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: FYI Dylan, If you read the KB Article closely *you* will see that the fix applies only to Enterprise, hence my post. Thanks, Chris -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:31 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: FYI had you read the original post closely, you would have seen the reference to knowledgebase article 19107. :) http://www.allaire.com/Handlers/index.cfm?ID=19107Method=Full -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:20 AM To: CF-Talk Subject: RE: FYI Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:15 AM To: CF-Talk Subject: RE: FYI I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL Error w/ CF 5.0
Heya all, Is anyone receiving the TagCFMail::sendMessage error with CF 5.0 Enterprise? I have seen the Allaire KB article, applied the patch, and have increased the delay setting multiple times, still keep receiving this error. Any info will be of great help. Thanks :) David. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
more coffee! -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:32 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: FYI Dylan, If you read the KB Article closely *you* will see that the fix applies only to Enterprise, hence my post. Thanks, Chris -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:31 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: FYI had you read the original post closely, you would have seen the reference to knowledgebase article 19107. :) http://www.allaire.com/Handlers/index.cfm?ID=19107Method=Full -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:20 AM To: CF-Talk Subject: RE: FYI Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:15 AM To: CF-Talk Subject: RE: FYI I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FYI
had you read the original post closely, you would have seen the reference to knowledgebase article 19107. :) http://www.allaire.com/Handlers/index.cfm?ID=19107Method=Full -Original Message- From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 8:20 AM To: CF-Talk Subject: RE: FYI Nice that it is fixed in CF5, but how about a fix for this in CF4.5 Professional? Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:15 AM To: CF-Talk Subject: RE: FYI I found a wonderful bug in CF 4.5 Yep, that's why we fixed it. :) There is a patch, though, from the Knowledge Base (19107). Hope this is fixed in CF 5. Yes it is fixed in CF5. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 My ally is the Force, and a powerful ally it is. - Yoda ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Outputing a Query In a different format Question...
My problem is that I would like to change the way a query is outputed on the page in a table. A picture is worth a thousand words. see below: regular CFOUTPUT user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Instead of outputting it like this, I would like for it to look like this: user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Comming from ASP, this is pretty easy because of the ADO MoveNext command. basically you put it in between the columns for the first user and the second user. then one after the TR. If I have confused anyone, let me know. Thanks in Advance David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ANN: SF area Gathering Wed Aug 1
You are invited to a gathering this Wednesday, Aug. 1 at the Thirsty Bear in San Francisco from 6 to 8. The goal of the gatherings is to get Macromedia users together in an informal, non-marketing setting where we can all talk and just share war stories about the Web. Macromedia takes care of the non-alcoholic bevvies and appetizers and you take care of the beer. If you do plan on coming, drop me a line and let me know so I can save enough tables. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outputing a Query In a different format Question...
try this as a quick fix (needs making beautiful as this'll give you an extra row at the end which you need to deal with, but the theory is sound...): tr cfoutput query=yourquery td#user#/td td#phonenumber#/td cfif NOT currentrow mod 2 /tr tr /cfif /cfoutput This will give you a 2 column table -Original Message- From: David Burt [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 17:22 To: CF-Talk Subject: Outputing a Query In a different format Question... My problem is that I would like to change the way a query is outputed on the page in a table. A picture is worth a thousand words. see below: regular CFOUTPUT user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Instead of outputting it like this, I would like for it to look like this: user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Comming from ASP, this is pretty easy because of the ADO MoveNext command. basically you put it in between the columns for the first user and the second user. then one after the TR. If I have confused anyone, let me know. Thanks in Advance David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outputing a Query In a different format Question...
Here is something i threw together _real_ quick, it uses MOD to generate 'number_of_sections' divisions of the data in a table. And, number_of_sections is dynamic based on the recordcount of the query. (the query is named contacts) Snip --- cfquery name=contacts [...] [...] cfset count=1 cfset number_of_sections=4 cfset sections=contacts.recordcount/number_of_sections table tr td cfloop query=contacts Cfif not count mod sections /tdtd /cfif !--- Output query data --- li#contacts.lastName#, #contacts.firstName#Br cfset count=count+1 /cfloop /td /tr /table End Snip --- -Ryan -Original Message- From: David Burt [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 12:22 PM To: CF-Talk Subject: Outputing a Query In a different format Question... My problem is that I would like to change the way a query is outputed on the page in a table. A picture is worth a thousand words. see below: regular CFOUTPUT user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Instead of outputting it like this, I would like for it to look like this: user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Comming from ASP, this is pretty easy because of the ADO MoveNext command. basically you put it in between the columns for the first user and the second user. then one after the TR. If I have confused anyone, let me know. Thanks in Advance David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Fw: fusebox IIS 5
Hello guys, I'm changing my web hosting plan to a dedicated one. In my share plan we had IIS 4 + CF 4.5. Well, almost everything is ok...but... our search-engine-friendly(Fusebox) urls don't WORK! www.help!.org/directory/index.cfm/var/val.htm Our hosting provider says: in IIS 5 (W2000) it doesn't work, the IIS 5 believes everything is a directory and... crash! it reports an error. is it True? if yes, Any ideas ? something at IIS 5 configuration? at CF ? help! TIA, Juan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Studio Trick - CORRECT
Thanks to everyone who responded. The below responses not only told me to hit Ctrl-J after typing 'scriptj', but also showed me where I can define my own. I have already made my own Code Template called 'doc', which when executed with Ctrl-J inserts our 12 standard lines of document information that all our templates should contain. Then I noticed that it updated a file on my PC called: Program Files/Allarie/ColdFusion Studio 4.5/UserData/tagcomp.dat, so I can share my customizations with my co-workers and help to ensure our web standards. Thanks Jan Ken Wilson [EMAIL PROTECTED] on 07/30/2001 10:48:05 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc:(bcc: Jan E Perlmutter/BISYS_BPS) Subject: RE: CF Studio Trick You'll want to setup a Code Template and keyword for it first. F8 -- EDITOR -- CODE TEMPLATES Works great and can save lots of time for things you use frequently. You can also use a Snippet Shortcut to achieve similar results. Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 10:29 AM To: CF-Talk Subject: CF Studio Trick I was at the 2001 cf odyssey event this past weekend. When one speaker was showing us some javascript I thought he typed 'scriptj' in studio, and bang the entire script header/footer tag and more appeared. I just tried this at work and it didn't work. Am I doing something wrong? Thanks Jan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
fusebox IIS 5 (II part: R.I.P. to fusebox?)
what surprise guys! they say: The reason the behavior was changed was due to several security vulnerabilities associated with this form of passing parameters to scripts. Actually this should not work on IIS 4 either - there was a security fix released about 14 months ago which disabled this functionality on IIS 4 is it true ? Juan - Original Message - From: JAAV [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 6:43 PM Subject: Fw: fusebox IIS 5 Hello guys, I'm changing my web hosting plan to a dedicated one. In my share plan we had IIS 4 + CF 4.5. Well, almost everything is ok...but... our search-engine-friendly(Fusebox) urls don't WORK! www.help!.org/directory/index.cfm/var/val.htm Our hosting provider says: in IIS 5 (W2000) it doesn't work, the IIS 5 believes everything is a directory and... crash! it reports an error. is it True? if yes, Any ideas ? something at IIS 5 configuration? at CF ? help! TIA, Juan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Studio 5.0?
beta.allaire.com I believe you have to be a registered user of ColdFusion Studio 5.0 to participate. I think going into anymore details would be against the beta license / NDA / whatever. At 11:12 AM 07/30/2001 -0400, you wrote: Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio 5.0?
I think talking about it is against NDA. It seems to me that ColdFusion Studio 4.6 would be a better name. Seems to be very few additions, but some nice enhancements. At 04:30 PM 07/30/2001 +0100, you wrote: how much does it differ from 4.52? -Original Message- From: Loryn C Williams [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 16:26 To: CF-Talk Subject: Re: Studio 5.0? Mike, I've been using Studio beta 2 since last Thursday. Beta 1 was not fun. I got many fatal exceptions and file sharing violation errors. This version is behaving much better so far. The file tab also hung in beta 1 (didn't refresh when I switched directories) This problem also seems to be fixed. Loryn Tangorre, Mike wrote: Is Studio 5.0 out yet in Beta for download? Anyone have it? Reviews? Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: fusebox IIS 5 (II part: R.I.P. to fusebox?)
We run Win2K advanced server IIS 5 (we have also done it in Win2K Server) and utilize search engine friendly urls. We have no problem. We did not do anything special to get this to work either. http://www.fastestisp.com for proof that this setup does work. John Lucas [EMAIL PROTECTED] -Original Message- From: JAAV [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:49 AM To: CF-Talk Subject: fusebox IIS 5 (II part: R.I.P. to fusebox?) what surprise guys! they say: The reason the behavior was changed was due to several security vulnerabilities associated with this form of passing parameters to scripts. Actually this should not work on IIS 4 either - there was a security fix released about 14 months ago which disabled this functionality on IIS 4 is it true ? Juan - Original Message - From: JAAV [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 6:43 PM Subject: Fw: fusebox IIS 5 Hello guys, I'm changing my web hosting plan to a dedicated one. In my share plan we had IIS 4 + CF 4.5. Well, almost everything is ok...but... our search-engine-friendly(Fusebox) urls don't WORK! www.help!.org/directory/index.cfm/var/val.htm Our hosting provider says: in IIS 5 (W2000) it doesn't work, the IIS 5 believes everything is a directory and... crash! it reports an error. is it True? if yes, Any ideas ? something at IIS 5 configuration? at CF ? help! TIA, Juan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFEXECUTE and the quote symbol
Hello, Im trying to automate the Win2K command Net User to add users to the computer. The problem im running into is i need to use a inside of the argument. Well when CF sees the it thinks it is the end of the CFEXECUTE tag. Anyway to escape this quote symbol? I tried using quot; but that did not work. cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt /cfexecute ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Outputing a Query In a different format Question...
This is good, but does anyone have an idea for filling one column, then a second with both columns being close to equal, but keeping grouping in the same column??? Alabama Texas Company 1 Company 4 JohnJack BillTyson Company 2 Eric RyanCompany 5 Joe Shane Kansas Tony Company 3 Chad Jimmy John Jason And the fun part is not getting the data to format like this once, but when a new state, or company, or Person is added, then I have to change code on the page...not real dynamic that way. For better referance look at http://www.inmarcollc.com/pva/reps.cfm I don't care if the State wraps columns, but I want the cities to stay together. Any Help would be great. Christian -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:19 AM To: CF-Talk Subject: RE: Outputing a Query In a different format Question... Here is something i threw together _real_ quick, it uses MOD to generate 'number_of_sections' divisions of the data in a table. And, number_of_sections is dynamic based on the recordcount of the query. (the query is named contacts) Snip --- cfquery name=contacts [...] [...] cfset count=1 cfset number_of_sections=4 cfset sections=contacts.recordcount/number_of_sections table tr td cfloop query=contacts Cfif not count mod sections /tdtd /cfif !--- Output query data --- li#contacts.lastName#, #contacts.firstName#Br cfset count=count+1 /cfloop /td /tr /table End Snip --- -Ryan -Original Message- From: David Burt [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 12:22 PM To: CF-Talk Subject: Outputing a Query In a different format Question... My problem is that I would like to change the way a query is outputed on the page in a table. A picture is worth a thousand words. see below: regular CFOUTPUT user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Instead of outputting it like this, I would like for it to look like this: user1 user1phoneNumber user2 user2phoneNumber user3 user3phoneNumber user4 user4phoneNumber Comming from ASP, this is pretty easy because of the ADO MoveNext command. basically you put it in between the columns for the first user and the second user. then one after the TR. If I have confused anyone, let me know. Thanks in Advance David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE and the quote symbol
Im trying to automate the Win2K command Net User to add users to the computer. The problem im running into is i need to use a inside of the argument. Well when CF sees the it thinks it is the end of the CFEXECUTE tag. Anyway to escape this quote symbol? I tried using quot; but that did not work. cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt /cfexecute Several ways to treat this; Start the string with a single apostrphie arguments='user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes' Double the quotes inside to escape them arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes Send the Chr() version of the character rather than the character itself arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:#Chr(34)#BILLYBOB#Chr(34)# /expires:never /passwordchg:no /passwordreq:yes All of these should work Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFEXECUTE and the quote symbol
I think you should be able to double up on the quote within the quote to escape it. that is: cfset blah=hello world! blah - hello world! -Ryan -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 12:52 PM To: CF-Talk Subject: CFEXECUTE and the quote symbol Hello, Im trying to automate the Win2K command Net User to add users to the computer. The problem im running into is i need to use a inside of the argument. Well when CF sees the it thinks it is the end of the CFEXECUTE tag. Anyway to escape this quote symbol? I tried using quot; but that did not work. cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt /cfexecute ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SirCam virus???
I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFEXECUTE and the quote symbol
Use single quotes for the internal argument: cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:'BILLYBOB' /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: Chad Gray [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 12:52 PM Subject: CFEXECUTE and the quote symbol Hello, Im trying to automate the Win2K command Net User to add users to the computer. The problem im running into is i need to use a inside of the argument. Well when CF sees the it thinks it is the end of the CFEXECUTE tag. Anyway to escape this quote symbol? I tried using quot; but that did not work. cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt /cfexecute ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFEXECUTE and the quote symbol
I recommend that you forego using cfexecute and look instead at two different resources: 1. CF_ADSI at http://www.cfcomet.com/ which is a COM .dll that encapsulates the ADSI calls to do this sort of thing so you can call it from cfobject. 2. Intranet / Hosting Toolkit at http://www.intrafoundation.com/ihtk.html - while I haven't used this one myself, it looks to be a fairly complete package that uses CFX tags instead of a COM object. |-+---| |Eric A. |There are many who are uncomfortable with what we have created.| |Laney|It is almost a biological rebellion. A profound revulsion | |Systems |against the planned communities, the programming, the | |Engineer |sterilized, artfully balanced atmospheres. They hunger for an | |LAN |Eden, where spring comes. | |Optimizat| | |ion Team |We all do. The cave is deep in our memories. | |Voice: | | |813.978.4| | |404 | - Spock and Kirk, The Way to Eden, stardate 5832.3.| |Pager: | | |888.985.8| | |519 | | |-+---| Chad Gray chad@attach.To: CF-Talk [EMAIL PROTECTED] net cc: Subject: CFEXECUTE and the quote symbol 07/30/2001 12:52 PM Please respond to cf-talk Hello, Im trying to automate the Win2K command Net User to add users to the computer. The problem im running into is i need to use a inside of the argument. Well when CF sees the it thinks it is the end of the CFEXECUTE tag. Anyway to escape this quote symbol? I tried using quot; but that did not work. cfexecute name=c:\winnt\system32\net.exe arguments=user #GetUsers.Login# #GetUsers.Password# /add /fullname:BILLYBOB /expires:never /passwordchg:no /passwordreq:yes outputfile=c:\output.txt /cfexecute ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SirCam virus???
Yep that's the virus. More info and repair utility here: http:[EMAIL PROTECTED] HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Join the DevCon community at www.coolfusion.com/devcon - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 1:12 PM Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SirCam virus???
http:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 1:12 PM To: CF-Talk Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(MOT) Tamoye (COP: Communities of Practice)
Has anyone heard of, or know where I can get more info on tamoye? I thought they had a domain tamoye.com but I can't find it ... :( Eric Dawson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SirCam virus???
yeah the virus is spread by MS Outlook users... someone sends you mail... you click.. Outlook gets corrupted and starts emailing people in your contacts your random personal documents... Word files, excel, etc... I have received about 100 messages in one email box alone :) McAffee and everyone else has issued patches and virus updates for it... get some virus software running... -paris -Original Message- From: [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 13:12:24 EDT Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SirCam virus???
I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks I've so far had about 150 of these... my Delete key has been very active Oh, and they've tended to pick ISPs who do bugger all about spam - I've emailed 5 different ISPs that it's going through and none have responded at all Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SirCam virus???
it's a nasty little bugger - try and get the folks sending u the emails to apply the fix that is available from SARC - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 30, 2001 10:12 AM Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF_QUERYDUMP
FYI: For those in need of a Query Dumping tag, please check out CF_QUERYDUMP: http://devex.allaire.com/developer/gallery/info.cfm?ID=7691D794-84F8-11D5-83 F300508B94F85Amethod=Full This tag acts just like a CFQUERY tag in that it accepts a SQL Statement inside of the start and end tags. It can also receive a query object and dump the info too. Enjoy! -- scott van vliet -- senior web engingeer juxt interactive 9497525898202 [EMAIL PROTECTED] www.juxtinteractive.com In uniqueness is the preservation of mankind... - Greg Graffin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is it possible to delete a local variable?
Belongs to my information, you can not delete local variables and also you dont need to delete them! Only SESSION, APPLICATION and STRUCTUREs can be deleted. Regards, Hamid Hossain --- Dave Watts [EMAIL PROTECTED] wrote: Subject: Is it possible to delete a local variable? Umm, I guess the subject says it all. I know the variable doesn't exist when the page has been fully processed, but I want to bin it before then... and I don't mean just set it to null... I mean delete it so that IsDefined(var) returns 0. No, I don't think you can delete local variables. You can only delete variables if they're contained within a structure, using the StructDelete function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is it possible to delete a local variable?
Belongs to my information, you can not delete local variables and also you dont need to delete them! Only SESSION, APPLICATION and STRUCTUREs can be deleted. Regards, Hamid Hossain --- Dave Watts [EMAIL PROTECTED] wrote: Subject: Is it possible to delete a local variable? Umm, I guess the subject says it all. I know the variable doesn't exist when the page has been fully processed, but I want to bin it before then... and I don't mean just set it to null... I mean delete it so that IsDefined(var) returns 0. No, I don't think you can delete local variables. You can only delete variables if they're contained within a structure, using the StructDelete function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SirCam virus???
http:[EMAIL PROTECTED] I had the virus sent to me 10 times last week. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 1:12 PM To: CF-Talk Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SirCam virus???
Just that the subject will be variable and the body will be the same but close to what you posted. It could also possible come in in Spanish. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 12:12 PM To: CF-Talk Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: fusebox IIS 5 (II part: R.I.P. to fusebox?)
Juan, This is true, but in no way means the end of Fusebox. I have to be honest and say I haven't kept up with all the latest advancements in Fusebox, but as I remember the tag FORMURL2ATTRIBUTES now picks up the query string and turns a safe URL into a bunch of variables. HTH Regards Stephen -Original Message- From: JAAV [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 17:49 To: CF-Talk Subject: fusebox IIS 5 (II part: R.I.P. to fusebox?) what surprise guys! they say: The reason the behavior was changed was due to several security vulnerabilities associated with this form of passing parameters to scripts. Actually this should not work on IIS 4 either - there was a security fix released about 14 months ago which disabled this functionality on IIS 4 is it true ? Juan - Original Message - From: JAAV [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 30, 2001 6:43 PM Subject: Fw: fusebox IIS 5 Hello guys, I'm changing my web hosting plan to a dedicated one. In my share plan we had IIS 4 + CF 4.5. Well, almost everything is ok...but... our search-engine-friendly(Fusebox) urls don't WORK! www.help!.org/directory/index.cfm/var/val.htm Our hosting provider says: in IIS 5 (W2000) it doesn't work, the IIS 5 believes everything is a directory and... crash! it reports an error. is it True? if yes, Any ideas ? something at IIS 5 configuration? at CF ? help! TIA, Juan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SirCam virus???
The sircam virus is particularly nasty... simple, but nasty. But only sometimes... basically, it pics random numbers... if it picks the right one, it might wipe out your hard drive, or fill it up or it might grab a random document on your computer and email it to everyone. This thing isn't dependant on Outlook or OE either.. it'll check your browser cache, personal folders... everything, to find email addresses to send itself to. It also attaches itself to your executable files. So it runs itself everytime you run anything. And if you remove the virus without getting all the registry entries... well, those executable files become dependant on the virus, so basically... nothing will run without it! Oh, and it stores itself in your recycle bin. Symantic never thought of that I guess cause it never scanned there. So unless you have the updates for your anti virus, you might not know you have it. If you want to read everything that it does.. and the fix for it.. go to this website... http:[EMAIL PROTECTED] Hope that all helps! Stuart Duncan MaracasMedia Inc. http://www.maracasmedia.com At 01:12 PM 7/30/01 -0400, you wrote: I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fw: fusebox IIS 5
On Mon, 30 Jul 2001 18:43:06 +0200, JAAV [EMAIL PROTECTED] wrote: Our hosting provider says: in IIS 5 (W2000) it doesn't work, the IIS 5 believes everything is a directory and... crash! it reports an error. is it True? if yes, Any ideas ? something at IIS 5 configuration? at CF ? All I can tell you is that I'm using SES URLs on two different IIS5 servers, one tuned by a hosting provider and the other a dev server using 100% default Microsoft settings, and both work fine. -- Roger ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SirCam virus???
Actually, the SirCam virus sports its own SMTP application to send mail, target e-mail addresses may come from a variety of sources including browser cache. You don't have to be an Outlook user to spread this. To get infected you must run the attached file. Stephen yeah the virus is spread by MS Outlook users... someone sends you mail... you click.. Outlook gets corrupted and starts emailing people in your contacts your random personal documents... Word files, excel, etc... I have received about 100 messages in one email box alone :) McAffee and everyone else has issued patches and virus updates for it... get some virus software running... -paris -Original Message- From: [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 13:12:24 EDT Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: SirCam virus???
Not all Outlook users I haven't been infected yet, but I've gotten the emails about 60 times. Just be careful opening attachments. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 12:23 PM To: CF-Talk Subject: Re: OT: SirCam virus??? yeah the virus is spread by MS Outlook users... someone sends you mail... you click.. Outlook gets corrupted and starts emailing people in your contacts your random personal documents... Word files, excel, etc... I have received about 100 messages in one email box alone :) McAffee and everyone else has issued patches and virus updates for it... get some virus software running... -paris -Original Message- From: [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 13:12:24 EDT Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ANN: SF area Gathering Wed Aug 1
Wish I was in San Fran :) Read about the Thirsty Beer and share your opinions with us afterwards: http://www.pubcrawler.com/Template/ReviewWC.cfm?BrewerID=1844 -paris -Original Message- From: Matt Brown [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 09:15:20 -0700 Subject: ANN: SF area Gathering Wed Aug 1 You are invited to a gathering this Wednesday, Aug. 1 at the Thirsty Bear in San Francisco from 6 to 8. The goal of the gatherings is to get Macromedia users together in an informal, non-marketing setting where we can all talk and just share war stories about the Web. Macromedia takes care of the non-alcoholic bevvies and appetizers and you take care of the beer. If you do plan on coming, drop me a line and let me know so I can save enough tables. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Synchronize Web Based DataWith Oulokk
Ahhh Outlook has comma delimited export ability on the CF side write a handler to parse the comma delimitted... that is the way I have seen it done... nothing really cool... I too would be interested in hearing about anyone else's approach... -paris -Original Message- From: Mardi Himawan [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 19:30:55 +0800 Subject: Synchronize Web Based DataWith Oulokk I Have a problem, would you please advice me..how to synchronize data outlook on pc client...with data on server sql..through web base connection would you please.send me source code cfml, or another advice... thank you ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SirCam virus???
Might as well one up you. I get about 10-15 a day on both my accounts. I've taken to emailing the sender as well as every domain in the send path to get it removed. It's actually worked. At 01:34 PM 7/30/01, you wrote: http:[EMAIL PROTECTED] I had the virus sent to me 10 times last week. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 1:12 PM To: CF-Talk Subject: OT: SirCam virus??? I've been getting multiple emails for the last couple of days from gr and nl domains. All have a file attached with the same email body. I also read about a new virus making it's rounds ... the Sircam virus. Does anyone have any info on these emails or the SirCam virus? Email body: Hi! How are you? I send you this file in order to have your advice See you later. Thanks Thanks, Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: IIS 4.0 and locking files
Hello all, I am using Coldfusion to handle a couple of files. Unfortunately from time to time, I get a lock on a file that stays on for at least 10 minutes or so... I remember at one time someone mention that IIS produces locks on files being viewed, does any one know how to disable these locks? Registry setting? Any advice greatly appreciated. Thank you in advance. Percy E Perez ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: $*^% Random Numbers!!!
html head titleGenerate 5 Random Numbers/title /head body CFQUERY NAME=test DATASOURCE=Foo SELECT manager_id FROM manager_data /CFQUERY cfset templist = cfset tempnum = cfset counter = 0 !--- Beginning: Sets valid values for random number generation --- cfset checklist = valuelist(test.manager_id,,) !--- End: Sets valid values for random number generation --- !--- Set condition to: counter lt (however many random numbers you want to generate) - in this case 5. --- cfloop condition=counter lt 5 cfset tempnum = randrange(1, #test.recordcount#) !-- Beginning: Ensures the number is not already in the randomly generated list and that the randomly generated number has a match in the source table -- cfif listfind(templist,#tempnum#, ,) eq 0 and listfind(checklist,#tempnum#,,) gt 0 !-- End: Ensures the number is not already in the randomly generated list and that the randomly generated number has a match in the source table -- cfif listlen(templist, ,) lt 5 CFSET templist = ListAppend(templist, #tempnum#, ,) cfset counter = counter + 1 /cfif /cfif !--- Beginning of Output Inside Loop for Correct Random Number Generation --- TempNumber: cfoutput#tempnum#/cfoutputbr TempList:cfoutput#templist#/cfoutputbr TempListLength:cfoutput#listlen(templist, ,)#/cfoutput !--- End of Output Inside Loop for Correct Random Number Generation --- /cfloop !--Select records created using the randomly generated list -- CFQUERY NAME=test1 DATASOURCE=Foo SELECT manager_id, manager_name FROM manager_data WHERE manager_id in (#listqualify(templist,',,,ALL)#) /CFQUERY brbr !--- Beginning of Output to check for Correct Output based on randomly generated List --- cfoutput query=test1 Manager_ID: #test1.manager_id#br Manager_Name:#test1.manager_name#br /cfoutput !--- End of Output to check for Correct Output based on randomly generated List --- /body /html Only records that do not currently exist in the randomly generated list and that have a match in the source table get appended to the randomly generated list, and outputed in the Sample Output below. Thought I would throw that comment in because as you can see the first 2 randomly selected number did not have matches in the source table and therefore did not get appended to the list. You can also see that the number 1074 was selected twice and not appended ot the list a second time. Example Output: TempNumber: 930 TempList: TempListLength:0 TempNumber: 2178 TempList: TempListLength:0 TempNumber: 1715 TempList:1715 TempListLength:1 TempNumber: 1074 TempList:1715,1074 TempListLength:2 TempNumber: 172 TempList:1715,1074,172 TempListLength:3 TempNumber: 1074 TempList:1715,1074,172 TempListLength:3 TempNumber: 1177 TempList:1715,1074,172,1177 TempListLength:4 TempNumber: 731 TempList:1715,1074,172,1177,731 TempListLength:5 Manager_ID: 1177 Manager_Name:Mouse, Mickey Manager_ID: 1715 Manager_Name:Three, Quake Manager_ID: 731 Manager_Name:TBD Manager_ID: 172 Manager_Name:Fudd, Elmer Manager_ID: 1074 Manager_Name:Man, Super Comments: If you want a random number generator NOT based on valid values from a table then just remove the code below from the code above. cfset checklist = valuelist(test.manager_id,,) and delete everything after the and in this statement cfif listfind(templist,#tempnum#, ,) eq 0 and listfind(checklist, #tempnum#,,) gt 0 will become cfif listfind(templist,#tempnum#, ,) eq 0 Enjoy, Casey Cook Dan Slater [EMAIL PROTECTED] on 07/28/2001 01:19:30 PM To: Casey C Cook/TMG/CSC@CSC cc: Subject: RE: $*^% Random Numbers!!! not yet, working on other stuff now -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:15 PM To: [EMAIL PROTECTED] Subject: Re: $*^% Random Numbers!!! Did you ever solve this? CC Dan Slater [EMAIL PROTECTED]@dfwcfug.org on 07/20/2001 03:43:54 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: $*^% Random Numbers!!! Hi all, I've tried and tried, and tried again to solve this one on my own with no success. I'm sure it's pretty ez, but since i'm a coder and not a programmer this is just beyond my abilities i think. Designing a shopping page that should randomly pull up to 5 records (stores). The random number generated should NOT be a duplicate of it self at any time through the loop... That last part is the part I can't seem to do... Sigh. Here's the code i've got right now (try not to laugh): CFSET temp = ValueList(getStores.pkStoreID) CFSET tempnum = #ListLen(temp)# CFOUTPUT table border=0 align=center width=100% cfset NewNum = 0 cfloop query=getStores startrow=1 endrow=5 CFSET randtemp = #RandRange(1,tempnum)# CFSET #RANDNUMBER# = #ListGetAt(temp,
Got the fellow, but....
I'm doing a pretty intensive watch on my server stastics and log files in real-time. sometimes I see people who try stupid stuff like: /winnt/system32/cmd.exe and trying to url hack (with ;drop tables) . my question is: when I'm seeing the guy's IP address in the stas server or log files, and the guy is still causing problem (i,e - trying to hack) what can I do to him? can I throw him, and only him away? will adding him to the banned IP in IIS helps immediatly? any other alternatives? Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Bar codes
I am looking for a way to printout bar codes onto a label. I want to pull out information for a SQL Server and print it onto a label with a thermal printer. If there is some type of software that works with Cold Fusion Server or is just ODBC complaint, that would be great. Has anybody done something like this? Thanks in advance, Jacob ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Bar codes
Jacob, One of the companies I was contracting for flirted with the idea of doing something like this. However, we decided not to go this route. The good thing is that I did find a web site which may help you out: http://www.adams1.com/pub/russadam/webapps.html HTH Nelson Original Message Follows From: [EMAIL PROTECTED] (Jacob) Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: OT: Bar codes Date: Mon, 30 Jul 2001 11:37:18 -0700 Received: from [207.31.122.190] by hotmail.com (3.2) with ESMTP id MHotMailBD2EF3CB00534004379ACF1F7ABE131C0; Mon, 30 Jul 2001 11:34:55 -0700 Received: from hof001.cfhosting.net ([207.31.122.190]) by hof001.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Mon, 30 Jul 2001 14:37:21 -0400 From [EMAIL PROTECTED] Mon, 30 Jul 2001 11:35:51 -0700 message-id: [EMAIL PROTECTED] precedence: bulk References: [EMAIL PROTECTED] I am looking for a way to printout bar codes onto a label. I want to pull out information for a SQL Server and print it onto a label with a thermal printer. If there is some type of software that works with Cold Fusion Server or is just ODBC complaint, that would be great. Has anybody done something like this? Thanks in advance, Jacob ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bar codes
Jacob, Try this... http://devex.allaire.com/developer/gallery/SearchResults.cfm?Keywords=ba rcodesubmit=searchcategory=*searchOptions=0 Lee Fuller Chief Technical Officer PrimeDNA Corporation / AAA Web Hosting Corporation We ARE the net. http://www.aaawebhosting.com -Original Message- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:37 AM To: CF-Talk Subject: OT: Bar codes I am looking for a way to printout bar codes onto a label. I want to pull out information for a SQL Server and print it onto a label with a thermal printer. If there is some type of software that works with Cold Fusion Server or is just ODBC complaint, that would be great. Has anybody done something like this? Thanks in advance, Jacob ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: FoxPro to SQL/Oracle
Hey guys has anyone upsized a FoxPro database to MS SQL or Oracle. If so can you give me any hints on problems you faced or articles that could help me on this type of conversion? Shawn Regan Applications Developer Pacific Technology Solutions ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Synchronize Web Based DataWith Oulokk
Maybe I'm not understanding the question correctly, but... You could use CDO in conjunction with asp to pull data from Outlook on the Exchange server, then create a wddx packet in asp which would get retrieved from the Exchange server by CF thru cfhttp. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 1:57 PM To: CF-Talk Subject: Re: Synchronize Web Based DataWith Oulokk Ahhh Outlook has comma delimited export ability on the CF side write a handler to parse the comma delimitted... that is the way I have seen it done... nothing really cool... I too would be interested in hearing about anyone else's approach... -paris -Original Message- From: Mardi Himawan [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 19:30:55 +0800 Subject: Synchronize Web Based DataWith Oulokk I Have a problem, would you please advice me..how to synchronize data outlook on pc client...with data on server sql..through web base connection would you please.send me source code cfml, or another advice... thank you ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Got the fellow, but....
Hmmm the best thing would to be try banning him at the IIS level by IP.. you might also write an application.cfm level screener to rip certain IPs and redirect them to the FBI.GOV site on hacking or others... That is in part how I do my redirections of about 450 domains in our portfolio... I put the jerks in there too :) -paris -Original Message- From: Michael Lugassy [EMAIL PROTECTED] Date: Mon, 30 Jul 2001 21:14:40 +0200 Subject: Got the fellow, but I'm doing a pretty intensive watch on my server stastics and log files in real-time. sometimes I see people who try stupid stuff like: /winnt/system32/cmd.exe and trying to url hack (with ;drop tables) . my question is: when I'm seeing the guy's IP address in the stas server or log files, and the guy is still causing problem (i,e - trying to hack) what can I do to him? can I throw him, and only him away? will adding him to the banned IP in IIS helps immediatly? any other alternatives? Michael. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists