RE: Making 2D array
there are a coupld of ways to do this. you have CFSET filearray = ArrayNew(1) CFLOOP List=#file_content# Index=rc Delimiters=#Chr(10)# CFSET rc = ArrayAppend(filearray, rc) /CFLOOP already. therefore, each element of filearray[] is a pipe delimited list over which you can iterate with another list loop. one of the problems with the acove code is that it will whack the value of RC each time through. maybe use a throwaway variable to hold the boolean result of arrayappend. therefore, you would have... CFSET filearray = ArrayNew(1) CFLOOP List=#file_content# Index=rc Delimiters=#Chr(10)# CFSET resultValue = ArrayAppend(filearray, rc) /CFLOOP then, replacing the inner set with another loop to break up each row of the file, the code becomes... CFSET filearray = ArrayNew(2) CFSET loopindex = 1 CFLOOP List=#file_content# Index=rc Delimiters=#Chr(10)# CFLOOP List=#rc# INDEX=innerRC DELIMITERS=| CFSET resultValue = ArrayAppend(filearray[loopindex], innerrc) /CFLOOP CFSET loopindex = loopindex + 1 /CFLOOP if you notice, i added an outer loop count to track where we were in the file (WRT rows). this should give you a two dimensional array. the length of the first array index is equal to the number of rows in the file. as a side note, because of the nature of list loops, any empty element in the file will fail this piece of code. CF treats multiple delimiters (in the inner loop's case, | symbols) as one delimiter (for some reason). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 8:06 PM To: CF-Talk Subject: RE: Making 2D array Thanks. I already knew cfset filearray = arraynew(2). It's the rest I don't know how to do - how to break the text along the rows up into cells at the pipe character. (the sample text I sent in my original message wrapped - it was originally 4 lines only) I need to do this so I can take this large text file, and break it up into 6 smaller files, delete some rows, delete some columns, reformat others, turn them into tables, and save them as includes for a template to use based on a form input. SO thanks for your help Alex, but it doesn't tell me what I need to know. I have a large text file, I need to turn it into an array or structure or some other format so I can manipulate the contents. I figured using an Array was the way to do it. Isnt it? So I still don't know how to do it. (sigh) Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks cfset filearray = arraynew(2) but what are you going to do with the sencond dimension. why not just load the data into a db table which is probably the easiest. Or put it in a structure. On Wed, 22 Aug 2001, Mike Kear wrote: I get a large ASCII text file every month, and I want to read it into a 2D array so I can manipulate it then write it out to a HTML file in a series of tables. But I'm stumped with the second dimension of the array. I can read it into one dimensional table like this: CFSET filearray = ArrayNew(1) CFLOOP List=#file_content# Index=rc Delimiters=#Chr(10)# CFSET rc = ArrayAppend(filearray, rc) /CFLOOP How do I make it into the two dimensional array instead? Here's a sample of the text I get. I want the elements in the second dimension to break on the pipe character. [sample text] UBS Asset Management (Australia) Ltd|SBC0813AU|UBS Australian Bond|339.30|7.77|5.31|8.02|0.42|~|8/55|| Colonial First State Invest Aust Ltd|FSF0027AU|Col First State Wsale AustBond|24.42|7.50|5.16|7.88|0.46||7/55|| IOOF Funds Management|IOF0012AU|IOOF Flex Tr FI|6.23|6.91|5.14|7.47|1.12|~|5/55|| Commonwealth Financial Services|COM0011AU|C'Wealth Bond Fund|146.70|6.68|4.91|6.46|1.11|Not Rated|0/55|| [end sample] ~~ 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: Using CFHTTP
perhaps you could create a user account on the target machine who's entire job is to have access to that file/directory. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:19 AM To: CF-Talk Subject: Using CFHTTP Hi all, I'm trying to use the cfhttp tag to get a webpage in a directory on our server which is not open to the general public. I don't like the idea of having to hard code a username and password into the attributes of the cfhttp tag. Is there a way round this? I've tried to change the login account of the CF service on the server to one which would allow access to the directory, but no luck there. Hope someone can help, Alex Little Open University ~~ 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: counting of domain-acesses
or even more tersely... HTTP_REFERER=http://www.helloworld.com/thepage/that_the/person.came?from cfscript UserDomain=ListGetAt(HTTP_REFERER, 2, /) /cfscript cfoutput#UserDomain#/cfoutput chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Trishan Singh [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 12:50 PM To: CF-Talk Subject: Re: counting of domain-acesses HTTP_REFERER=http://www.helloworld.com/thepage/that_the/person.came?from cfscript UserDomain=Replace(CGI.HTTP_REFERER,http://,;); DomainEnd=Find(/,UserDomain); UserDomain=RemoveChars(UserDomain,DomainEnd,Len(UserDomain)); /cfscript cfoutput#UserDomain#/cfoutput - Original Message - From: CF-Talk (SD Solutions) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 20, 2001 11:20 AM Subject: counting of domain-acesses Hi list, I want to count accesses of one certain domain on a customerdomain via bannerlinks. ( e.g.: www.exampledomain.com ) The cgi.http_referer variable gives me an exact url But the acesses do come from more than one http_referer I haven't found s.th. like: cgi.http_refererdomain which would have been helpful. Any ideas what I could do ? Uwe ~~ 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: Subtract Null = Error
check out the NVL function. i'm assuming this is SQL server. if you NVL(total, 0) in your sql query, it will substitute 0 for the NULL values. i'm also assuming that negative #newtotal# is ok. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Gryphawk [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 4:41 AM To: CF-Talk Subject: Subtract Null = Error Hi there I was hoping you could help me with a problem - I have a calculated value from the following code: cfoutputcfset newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)#newTotal# /cfoutput Which works just fine when the Recordset2.TOTAL and Recordset1.TOTAL are populated by the SQL (as set by search parameters on a previous page). However, on occasion Recordset2.Total is equal to nothing (null?) while Recordset1.TOTAL has a value due to the search string, and when this happens, CF throws an error which reads: An error occurred while evaluating the expression: newTotal =(Recordset2.TOTAL - Recordset1.TOTAL) Error near line 316, column 17. Cannot convert to number. Is there anyway to get around this such as an If Recordset.TOTAL = nothing, Then [don't subtract]? My apologies that I am only just starting to learn how to write coded stuff. Many thanks, Gryphawk ~~ 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: CFMAIL and MS SMTP
we use IIS's SMTP extensively with CFMAIL. do you have IIS set to allow the CF machine to relay? it's a common error, and one that most security minded folks ignore, since they turn it off by default. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 3:57 PM To: CF-Talk Subject: CFMAIL and MS SMTP I'm attempting to send mail from CF to IIS4's SMTP service. For some reason it doesn't look like it's accepting the mail. CF spools it fine, and the cfusion/logs/mail.log file doesn't report any errors. cfusion/logs/sentmail.log reports that the message was sent correctly. The message does not end up in cfusion/mail/undeliverd. The SMTP service's logs report the following: 19:32:15 130.205.XXX.XXX MAIL FROM - 250 19:32:15 130.205.XXX.XXX RCPT TO - 250 19:32:15 130.205.XXX.XXX QUIT - 0 It looks like the data is being sent to the SMTP service, but then the message just vanishes into thin air! It's not in the queue directory or the badmail directory or any other directory in the SMTP service's root. It also doesn't get received by the recipient, and a review of the mail server it's addressed to reveals that MS SMTP didn't even try to open a connection to it. Has anyone else seen anything like this? Anyone else use the MS SMTP service for outgoing mail? -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software ~~ 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: Netscape / CF4.0 / Apache / CFLOCATION
that's because CFLOCATION essentially sends a 302 header. it instructs the browser to go to that location because the resource has been moved... sounds like your browser(s) don't know how to follow the link automatically. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dasher [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 2:55 PM To: CF-Talk Subject: Netscape / CF4.0 / Apache / CFLOCATION Netscape 4.xx / IE for MAC Cold Fusion 4.0 Apache on Unix -- When we use CFLOCATION we get this weird page that says: HTTP/1.1 302 Found Date: .Apache/1.3.6(Unix) The document has been moved here where here is a link to the page we wanted to cflocate to in the first place. Does anyone have a soultion for this? Thanks, -- Dasher [EMAIL PROTECTED] http://www.bentmedia.com/ Bent Media, Inc. 128 South Clark Street New Orleans, LA 70119-6103 Phone - 504.488.2848 x19 Fax - 504.488.2979 ~~ 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 trojen? BackdoorJY.sv
actually, microsoft has a good article on hardening IIS5. don't have the link right now, but go to microsoft.com and search for securing IIS5. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Surma [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 9:31 AM To: CF-Talk Subject: Re: CF trojen? BackdoorJY.sv Rather than relying on Microsoft patches, you'll get better mileage out of properly configuring your servers up front. Here's a little secret of mine. I don't bother installing most of the IIS patches when they come out. I don't have to, because they patch things that I've already disabled or removed. I can wait until everyone else has regression-tested the patch on their production web servers. Can you throw us bone, and point us to some information on how to strip down a CF, IIS Server? Lee Surma [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS from Store Procedure MSQL 7.0
actually, i started down that road. tried REMOTE. didn't know i had to use the CLSID instead of the name (how does one go about finding that?). the fact that CF has to be logged on as admin instead of system is another problem. the whole reason i'm trying to do this is for security purposes, anyway, so it seems like this might not be the way. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:48 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 I saw this at CF Comet, at http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=F05079C2-EAB3-4B25- B9EEA9B47F3186F5. Perhaps this covers your situation. -David If your object is external to the Web server, use the CONTEXT=Remote attribute of CFOBJECT as well as the CLSID (class ID) for the object in the CLASS attribute, which looks like {----} (your object's CLSID won't be all zeroes, but it looks very similar). When using a Remote context, the CLSID is used instead of the ProgID (Object.Application) and you must also specify a valid server that has the object loaded. The server can be an IP address of a UNC path. Keep in mind that the ColdFusion services must be logged in as Administrator, not LocalSystem (the default) for most objects to work -- you change this in your services control panel. On Monday, July 16, 2001 7:47 AM, Christopher Olive, CIO [SMTP:[EMAIL PROTECTED]] wrote: reviving an old topic... i've been looking into doing this for a recent client. i read simon horwith's (very clear) article on CFCOMET. works beautifully...on a machine with both CF ands SQL server on it. of course, this is the test box. when i move it to our production servers (two bxes, one CF 4.52, the other SQL 7), i get a COM error 0x800401F3: Invalid class string on the object creation call of CFOBJECT. is this method presented bty simon predicated on the fact that CF and SQL are on the same box? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS from Store Procedure MSQL 7.0
reviving an old topic... i've been looking into doing this for a recent client. i read simon horwith's (very clear) article on CFCOMET. works beautifully...on a machine with both CF ands SQL server on it. of course, this is the test box. when i move it to our production servers (two bxes, one CF 4.52, the other SQL 7), i get a COM error 0x800401F3: Invalid class string on the object creation call of CFOBJECT. is this method presented bty simon predicated on the fact that CF and SQL are on the same box? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 8:39 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 Check out www.cfcoment.com there is a great article about this exact thing. Mike -Original Message- From: Cruz, Joseph [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 7:56 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Check out xp_cmdshell and the dtsrun command-line tool. That might get you where you want to be. :) Joe == Joseph Cruz Programmer/Analyst Wharton Computing 3620 Locust Walk, Suite 400 Philadelphia, PA 19104-6302 (215) 898-1220 (w) (215) 308-0657 (p) (215) 768-2071 (m) [EMAIL PROTECTED] -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 2:22 PM To: CF-Talk Subject: DTS from Store Procedure MSQL 7.0 Is is possible to execute a DTS package from a stored procedure? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS from Store Procedure MSQL 7.0
actually, i've tried that already. however, the xp_cmdshell runs as SQLServer Agent (or some account) and needs sa access. i can't do that on a production box with other folks on there, it's a HUGE security hole. i was trying the CFcomet method written by mr horwith. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: David Sterling [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:04 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 Here is the syntax you need to run the DTS packet, assumed it is saved on the SQL server. CREATE PROCEDURE [MyDTS] AS Exec MASTER..xp_CmdShell 'dtsrun /S (server_name) /U (username) /P (password) /N (name_of_DTS)', no_return -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 9:47 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 reviving an old topic... i've been looking into doing this for a recent client. i read simon horwith's (very clear) article on CFCOMET. works beautifully...on a machine with both CF ands SQL server on it. of course, this is the test box. when i move it to our production servers (two bxes, one CF 4.52, the other SQL 7), i get a COM error 0x800401F3: Invalid class string on the object creation call of CFOBJECT. is this method presented bty simon predicated on the fact that CF and SQL are on the same box? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Bruce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 8:39 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 Check out www.cfcoment.com there is a great article about this exact thing. Mike -Original Message- From: Cruz, Joseph [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 7:56 AM To: CF-Talk Subject: RE: DTS from Store Procedure MSQL 7.0 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Check out xp_cmdshell and the dtsrun command-line tool. That might get you where you want to be. :) Joe == Joseph Cruz Programmer/Analyst Wharton Computing 3620 Locust Walk, Suite 400 Philadelphia, PA 19104-6302 (215) 898-1220 (w) (215) 308-0657 (p) (215) 768-2071 (m) [EMAIL PROTECTED] -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 2:22 PM To: CF-Talk Subject: DTS from Store Procedure MSQL 7.0 Is is possible to execute a DTS package from a stored procedure? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Print without bringing print dialogue?
actually, you can't. it's a JS security feature. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Nathan Chen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 12:46 PM To: CF-Talk Subject: Print without bringing print dialogue? Hi, All: I posted this before the list went down a few weeks ago. I don't know if it went though so I re-post it. I need to know how to print a cfm page without bringing up the print dialogue from the browser. If I use window. print() method, the print dialogue will popup. But what I need is to send the displayed information to the printer directly without bringing this print dialogue box. Is this possible? Any hint or suggestion will be appreciated. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Get Last Item in DB
not technically correct. in an RDBMS, there is no last row. the data exists in a set, not a table. therefore, the last row is only relevant if you mean something like the last row inserted, AND that you have a timestamp on it. therefore, this SQL would look like SELECT TOP 1 column AS thenewcolum FROM table ORDER BY datetimecolumn DESC chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 6:13 PM To: CF-Talk Subject: Re: Get Last Item in DB SELECT TOP 1 column AS thenewcolum FROM table Hope this helps -- Will new media discussion for Berkshire -=- http://bnm.lukrative.com local classifieds -=- http://www.localbounty.com e: [EMAIL PROTECTED] icq: 31099745 - Original Message - From: Mike [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Saturday, July 07, 2001 10:21 PM Subject: Get Last Item in DB Hi, I think this might be a pretty simple SQL question... but here goes: If I have a bunch of rows in an database, how do I write the CFQUERY to return the very last row (and only the last row)? Thanks in advance, -- Mike ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: maxrows and blockfactor
BLOCKFACTOR is how many rows are returned along the pipe at one time from the query. for example, if you have BLOCKFACTOR set to 50, and the query would return 400 rows, the DB sends the rows along the network pipe in blocks of 50. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 07, 2001 5:28 PM To: CF-Talk Subject: maxrows and blockfactor What is the difference between maxrows and blockfactor? Both are available with cfquery but only blockfactor is available with cfstoredproc. Can you use blockfactor with a cfstoredproc the same way that you would use maxrows in cfquery? Sebastian Palmigiani Cash Flow Club Charity http://www.cashflowclubonline.com/?SEB007883 voice: 773.929.9256 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email this page to a friend....
problem with that is that if they haven't configured their email client correctly in their browser (at least have of the clusers i've talked to have not), it won't work well. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 10:44 AM To: CF-Talk Subject: Re: Email this page to a friend if you don't want to add special credits and/or details to this tell a friend message I would recommened using the mailto: method. it's easy, reliable and will pop up the user's prefarble e-mail client (where he can select his contacts much easier!!) in cf, you can create something like this: (I forgot the actual CGI variables, check them out) cfset mailto=?subject=check this outbody=#CGI.template_name##CGI.template_params# and then, provide a link like this: cfoutputa href=mailto:#mailto#;share with a friend/cfoutput get a better example here: http://www.imvamp.com/share/index.cfm Thanks, Michael - Original Message - From: Dasher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 08, 2001 3:35 PM Subject: Email this page to a friend What's the best way to set up an Email This Page To A Friend using Cold Fusion? I need to get input like name_of_friend and your_name and plug it in to the emailed page... Thanks, Dasher ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UI question
you could do a check server side on the action of the form. CFIF FORM.myselect EQ Other AND NOT Len(FORM.myotherdesc) whatever error processing you want... /CFIF chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 2:29 PM To: CF-Talk Subject: UI question I would like some input on how people handle the following situation: A client wants a form with a Job Title select box with 5 options - Developer Programmer Engineer Electrician Other If the user selects Other then they have to enter the information in a text box. Otherwise, the selection in the Select box is sufficient. Now, my problem isn't programming related. Rather, I am interested in a good way to handle the user interface for this mess. For example, in VB it's easy enough to make the text box only appear when Other is selected. However, HTML is not that flexible. It just seems that there might be a good way to handle this that I'm missing. Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
yup. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 4:04 AM To: CF-Talk Subject: RE: Referencing an array item So, to access a element [2][1] in the 3rd array I would have: Application.SM[3][2][1] ? -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 5:49 PM To: CF-Talk Subject: RE: Referencing an array item well, you collapse the three arrays into an uber array, called SM. so your original statement might be.. CFSET Application.SM = ArrayNew() cfset Application.SM[1] = SM1 cfset Application.SM[2] = SM2 cfset Application.SM[3] = SM3 then use your number as an index into your outer array. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:21 AM To: CF-Talk Subject: RE: Referencing an array item But I have 3 arrays, so it will really need to look like: Application.SM1[n][element] Application.SM2[n][element] Application.SM3[n][element] I can't see how else to work around this. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:31 PM To: CF-Talk Subject: RE: Referencing an array item ray has an excellent point. however, why not exploit the nature of arrays? if you make Application.Sm an array with three elements, each one the arrays sm1..3, then you can reference an element in SM(n) by Application.SM[n][element]. you don't have to futz with string evaluation at all. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:41 AM To: CF-Talk Subject: Referencing an array item I have 3 arrays, which are assigned to the application scope: cfset Application.SM1 = SM1 cfset Application.SM2 = SM2 cfset Application.SM3 = SM3 My custom tag receives a number (1,2 or 3), and with that I reference the correct array. I need to dynamically use this number to reference the correct array, e.g. #ArrayLen(application.SM attributes.Num)# (The above code does not work.) Any help would be much appreciated!! Thanks in advance. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
well, you collapse the three arrays into an uber array, called SM. so your original statement might be.. CFSET Application.SM = ArrayNew() cfset Application.SM[1] = SM1 cfset Application.SM[2] = SM2 cfset Application.SM[3] = SM3 then use your number as an index into your outer array. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 2:21 AM To: CF-Talk Subject: RE: Referencing an array item But I have 3 arrays, so it will really need to look like: Application.SM1[n][element] Application.SM2[n][element] Application.SM3[n][element] I can't see how else to work around this. -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:31 PM To: CF-Talk Subject: RE: Referencing an array item ray has an excellent point. however, why not exploit the nature of arrays? if you make Application.Sm an array with three elements, each one the arrays sm1..3, then you can reference an element in SM(n) by Application.SM[n][element]. you don't have to futz with string evaluation at all. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:41 AM To: CF-Talk Subject: Referencing an array item I have 3 arrays, which are assigned to the application scope: cfset Application.SM1 = SM1 cfset Application.SM2 = SM2 cfset Application.SM3 = SM3 My custom tag receives a number (1,2 or 3), and with that I reference the correct array. I need to dynamically use this number to reference the correct array, e.g. #ArrayLen(application.SM attributes.Num)# (The above code does not work.) Any help would be much appreciated!! Thanks in advance. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Referencing an array item
ray has an excellent point. however, why not exploit the nature of arrays? if you make Application.Sm an array with three elements, each one the arrays sm1..3, then you can reference an element in SM(n) by Application.SM[n][element]. you don't have to futz with string evaluation at all. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 8:41 AM To: CF-Talk Subject: Referencing an array item I have 3 arrays, which are assigned to the application scope: cfset Application.SM1 = SM1 cfset Application.SM2 = SM2 cfset Application.SM3 = SM3 My custom tag receives a number (1,2 or 3), and with that I reference the correct array. I need to dynamically use this number to reference the correct array, e.g. #ArrayLen(application.SM attributes.Num)# (The above code does not work.) Any help would be much appreciated!! Thanks in advance. Steve Development Manager Vardus Internet Solutions (SA) Tel: (+27) 21 670 9880 Fax: (+27) 21 674 4549 Email: [EMAIL PROTECTED] Website: www.vardus.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS4 Log file
did you select these items in the Logging configuration on both machines? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Friday, May 18, 2001 3:12 PM To: CF-Talk Subject: OT: IIS4 Log file I have two servers. One server logs browser, and computer information like this: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) This computer has CF 4.5, and Webtrends loaded on it. The other server (IIS4 also, but without CF4.5, and Webtrends) does not log this information. Anyone know why? TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange problem (or still asleep)
that OR should be an AND. something can't be BOTH 5 and 9 at the same time. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:20 PM To: CF-Talk Subject: Strange problem (or still asleep) Hello, i'm running the code below and i'm not getting the expected results. i'm passing in a variable with the length of 5 so i would expect that the errorString would not be appended, but in fact it is. The same thing happens when i pass in a variable with the length of 9. I can't seem to figure out why this is happening. Can anyone help? Sorry if this is way basic. david code: script . }else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){ errorString = ListAppend(errorString, Please enter a valid zipcode (too long/short), |); errorFlags = ListAppend(errorFlags, zp, |); . /script ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: E-commerce Dilemma
CFWebstore is EXCELLENT. Mary Jo has created an incredible product that works right out of the box. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Christine Kelley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:03 PM To: CF-Talk Subject: E-commerce Dilemma Hi! I need to implement an e-commerce package for one of my sites, but I haven't worked with e-commerce before. What they want is fairly simple, just the ability to buy items on-line. This in mind, I think AbleCommerce would be over-kill. The two I have researched are CFWebstore and Cartease. I'm torn between the two...does anyone have reasons to go with one or the other? What I need is a solution that I can add on to an existing site or build a complete store from scratch. Ease of implementation would be nice too :) Thanks, Christine ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query Help!! Problems???
are shipfrom and shipto string? if so, you'll get that error on the second query, as you're comparing strings to numbers. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 8:16 PM To: CF-Talk Subject: RE: Query Help!! Problems??? OK when I use: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where '#total#' =shipfrom and '#total#' = shipto /cfquery I get multiple records returned. When I get rid of the tick marks: cfquery name=get_shipratedollars datasource=#config.datasource# dbtype=ODBC select shiprate from shipratesdollars where #total# =shipfrom and #total# = shipto /cfquery I get Data type mismatch in criteria expression. WHAT AM I DOING WRONG?? HELP, Rich -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:07 PM To: CF-Talk Subject: RE: Query Help!! These queries give me: ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'shipRate' in query definition's SELECT list. Rich -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 5:35 PM To: CF-Talk Subject: RE: Query Help!! it's impossible to know what's wrong without knowing the values of the session variables at any given time You'll notice that you don't need to do a comparison on both numbers: cfquery name=myQuery... SELECT max(shipRate) AS shipRate FROM shipRatesDollars WHERE shipFrom = #val(session.total)# OR SELECT min(shipRate) AS shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# Either of these will return the one value you need Also if you're sure the columns in the DB will always be sorted in ascending order then just do this: cfquery name=myQuery maxrows=1... SELECT shipRate FROM shipRatesDollars WHERE shipTo = #val(session.total)# This time the first record in the DB where shipTo is greater than your session variable is the one you want and will be the only one returned. You may have noticed by now that you only need to have shipFrom OR shipTo in the DB table, you do not need both :) Bryan Love ACP Internet Application Developer [EMAIL PROTECTED] -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:01 PM To: CF-Talk Subject: Query Help!! Does anyone see any problems with the following query: cfquery name=get_shipratedollars datasource=#config.datasource# Select shiprate from shipratesdollars WHERE '#session.total#' = shipfrom and '#session.total#' = shipto /cfquery I can not figure out why I am getting incorrect results. Sometimes it will pull more than one record and sometimes it will pull the max record only. Here is a copy of the table I am using named shipratedollars. ID shiprateshipfrom shipto 1 4.00 0.00 50.00 2 6.0050.01100.00 3 8.00 100.01200.00 4 12.00 200.01300.00 5 18.00 300.01500.00 6 25.00 500.01750.00 7 40.00 750.01 1000.00 8 50.00 1000.01 1500.00 9 70.00 1500.01 2000.00 10 100.00 2000.009.00 Thansk, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Who's a good merchant these days?
what? boa is FUBAR! i tried to use them, and their tech is WAY behind. they're only now starting to let you use CFHTTP to do the processing (or they will be...within the next 2 or 3 months...) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:06 PM To: CF-Talk Subject: RE: Who's a good merchant these days? Erika here are a few. SkipJack - http://www.skipjack.com GoRealtime - http://www.gorealtime.com Itransact - http://www.itransact.com but I highly recommend Bank of America services, if you have a b of a account http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_ov. cfm Greg -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:28 AM To: CF-Talk Subject: OT: Who's a good merchant these days? Hi all, I have to recomend a couple of good credit card processing companies to a new client. Other than iBill, CyberCash and Authorize.net, are there any others worth taking a look at, easy to integrate and have no problems? Look for fellow programmer references. Thank you. ReplaceNoCase(Erica, c, k, ALL)* *A thanks to Dylan, for being the ever observant CF programmer!! Once in a while it really hits people that they don't have to experience the world in the way they have been told to. - Alan Keightley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL query help
SELECT distinct(color) as color WHERE name = 'bar' chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 4:16 PM To: CF-Talk Subject: SQL query help I have a database similar to this: SKU NAMECOLOR STYLE 1 bar blue12 2 bar blue6 3 bar blue5 4 bar red 12 5 bar red 6 6 bar red 5 I want to find all the colors that 'bar' comes in. If i do a query on this to find all the colors for the NAME 'bar'. I get: blue blue blue red red red How do i get results like this? blue red Thanks in advanced Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Who's a good merchant these days?
my bad. their techS ARE way behind. they don't know how to support CF. most of the guys i talked to had *heard* of CF, not used it. in fact, they were techinically not supposed to support customer software according to their techs. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 5:25 PM To: CF-Talk Subject: RE: Who's a good merchant these days? well...I have no complaints. My clients don't either. :) IMHO, their customer service is SOLID for the amount you pay per transcation (which used to be around .20 per, BUT NOW TRANS are FREE up 1000 transacation per month) and Monthly SvcChg, which is much less than most competitors. Their chargeback rates are competitive as well. you said their tech is WAY behind, however, they are using ColdFusion. H. just my .02 of a dollar :p G -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:17 PM To: CF-Talk Subject: RE: Who's a good merchant these days? what? boa is FUBAR! i tried to use them, and their tech is WAY behind. they're only now starting to let you use CFHTTP to do the processing (or they will be...within the next 2 or 3 months...) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:06 PM To: CF-Talk Subject: RE: Who's a good merchant these days? Erika here are a few. SkipJack - http://www.skipjack.com GoRealtime - http://www.gorealtime.com Itransact - http://www.itransact.com but I highly recommend Bank of America services, if you have a b of a account http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_ov. cfm Greg -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 10:28 AM To: CF-Talk Subject: OT: Who's a good merchant these days? Hi all, I have to recomend a couple of good credit card processing companies to a new client. Other than iBill, CyberCash and Authorize.net, are there any others worth taking a look at, easy to integrate and have no problems? Look for fellow programmer references. Thank you. ReplaceNoCase(Erica, c, k, ALL)* *A thanks to Dylan, for being the ever observant CF programmer!! Once in a while it really hits people that they don't have to experience the world in the way they have been told to. - Alan Keightley ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Simple SQL SELECT
whenever you use an aggregate function (like count()), you have to use the GROUP BY clause. put the rest of your columns there. ie: SELECT phID, phCOL, COUNT(phID) As coPHOTOS FROM photos WHERE phGROUP='#grid#' AND phCOL IS NOT NULL GROUP BY phID, phCOL chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 6:11 AM To: CF-Talk Subject: Simple SQL SELECT I'm trying to simply select a few colums from a table (phID,phCOL) + the count of that certain select each time into a variable (coPHOTOS) SELECT phID, phCOL, COUNT(phID) As coPHOTOS FROM photos WHERE phGROUP='#grid#' AND phCOL IS NOT NULL GROUP BY phCOL I keep on getting an error: Column 'photos.phID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. What is wrong? Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to Force https vs http
i used to override the custom error from IIS (403.5, i think). write your own redirect script. so when they go to http:// something, they get automatically redirected to https:// something. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 9:57 AM To: CF-Talk Subject: How to Force https vs http Howdy all, Quick questionis it possible to have a URL redirect to a secure URL? For example, someone enters http://www.xxxblahxxx.com/secure/securepage.cfm instead of https://www.xxxblahxxx.com/secure/securepage.cfm. How do you force a redirect to the secure URL? Is that a server function, or can it be done programmatically? TIA, Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Sales Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 Instant Messaging: AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Finding the last item in a loop
maybe cfloop query=qry_show_event_sponsors #EventSponserName#cfif CurrentRow NEQ qry_show_event_sponsors.recordcount,/cfif /cfloop ? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chris Martin [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 11:13 AM To: CF-Talk Subject: Finding the last item in a loop IS it possible to find the last item in a loop? Right now I have this: cfloop query=qry_show_event_sponsors #EventSponserName#, /cfloop Is it possible to check if the #EventSponsorName# is the last item in the record set, and then not display the comma? I.E. cfloop query=qry_show_event_sponsors #EventSponserName#cfif something,/cfif /cfloop Thanks in advance Chris Martin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Benefits of CFSWITCH vs. CFSCRIPT with SWITCH
that's actually something they warn about in C courses. you must have a break in your case statements, or it will cascade down the cases after the first match. it's defined as bad programming in most cases, but all bad things (infinite loops, etc) have applications in carefully controlled circumstances. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 1:33 PM To: CF-Talk Subject: Re: Benefits of CFSWITCH vs. CFSCRIPT with SWITCH *** Team Allaire *** Miachael, Go ahead and steal the code. But in what way is this a hack? The part where you did a case with no content in it that 'slid' down to the next case and used the same content. This isn't in any docs and probably hasn't been thought of by many people. switch ( foo ) { case 1 : case 2 : { // code break; } I do find your numbers interesting. I am a little disappointed at the apparent performance hit one takes when using a cfscript switch/case statement. I know that MM people are on list and will probably look into it. I'll also post it to the bug tracking for CF 5. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ' in SQL 2000
perhaps you could post the code you're using. we could take a look. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 9:42 AM To: CF-Talk Subject: ' in SQL 2000 I'm having a frustrating problem I have several queries in which I'm composing the SQL statement and then inserting it into the query through a variable (Necessary because I'm looping through a list to get the fieldnames and values). e.g.: cfset list1=#field1#, #field2#cfset list2= '#value1#', '#value2#' then in the query: insert into table1(#list1#) values (#list2#) When I output the generated SQL, it looks perfectbut SQL seems to be having a problem with the ' (single quotes) surrounding strings I've tried preservesinglequotes(), using chr(39), etc...and I still get syntax errors on insert or update. When I take the output data and manually insert it into the query, it works fine - eliminating the possibility of data type errors. I've tried this with 4 different queries, with the same results. I've now run out of things to try..Ideas? TIA! D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 One man's magic is another man's engineering. ---Lazarus Long ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using NT accounts for username/password login authentication
if you're running IIS, just switch off anonymous access. users will be prompted for their NT password, and the ACL on that directory/file will take over. if they're not authorized, they get a 403.1 error. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Philip Humeniuk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:09 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication How would you go about accessing the NT accounts and use those username/password for login authentication rather than accessing an MS Access database? Has anyone done this before? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using NT accounts for username/password login authentication
um...you did post to the list. :) ldap is a different animal. i've never really used it for authentication, besides Win2K's ACLs being LDAP-compliant. you're probably going to want to look into Advanced Security. it can use an LDAP database for suthentication. of course, it's a BEAST to setup. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 3:52 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication Chris, Sorry to respond to you this way. I subscribed to this list only today. I am looking for help on authenticating users against an ldap directory but have not quite gotten there yet and I cannot see how to post to the list. Any pointers on how to post to the list would be appreciated. Then I will be more descriptive in my question. Thanks, Jerre Christopher Olive, CIO wrote: if you're running IIS, just switch off anonymous access. users will be prompted for their NT password, and the ACL on that directory/file will take over. if they're not authorized, they get a 403.1 error. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Philip Humeniuk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:09 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication How would you go about accessing the NT accounts and use those username/password for login authentication rather than accessing an MS Access database? Has anyone done this before? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: textarea
well, you can't techincally put bullets in there, but if you want to save the carriage returns that people use in your textarea, use the WRAP=HARD attribute in the textarea. when outputting, use ParagraphFormat() to do something about the CRs in the output. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 5:52 AM To: CF-Talk Subject: textarea Hi all, I've got a form which has a text area for people to fill in. Then the next page displays the information they entered. What i want to do is save the information the people entered but in the same format. So for example, if the information entered is in bullet format, each on a separate line. I want it to display that way, each bullet on a separate line. Is that possible? and how? = Heidi Belal ICQ# 32127109 http://m3.easyspace.com/hmbelal A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Character code for a TAB
problem with that is exactly what we're discussing. the answer may not have come into my inbox before i reply to a message. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 10:31 AM To: CF-Talk Subject: Re: Character code for a TAB Instead of quickly hitting reply and sending out the answer, one can quickly scan the inbox or the digest to see if its been answered and then not reply. Mary There must be a way to let us know the question has been answered! Let's think about it! - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 3:51 PM Subject: RE: Character code for a TAB I think the problem is more due to the fact that the responses are more hey, I know the answer to this!!! repetitions than meant to clog the list. It's one of the downsides of using an e-mail list versus some other message base format. All of the replies probably got sent out at the same time and the delay the list actually getting them is more due to email lag than anything else. It's great to get a response and frustrating not to, and I think all of us have experienced both sides of that coin. So to make up for it, when we know how to help someone we reflexively hit reply. The cascade effect is what we all see. Hatton Humphrey Barbara remains in the hospital and needs blood donors for more transfusions. She is also having trouble sleeping and requests tapes of Pastor Jack's sermons. - From Real Church Bulletin Bloopers -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] How about everyone bookmarks this page (http://www.asciitable.com/), now...then no-one should ever have to ask again. Except of course the newcomers. And those we'll beat into submission with a big ole CF book or something...? :) Erika -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] I JUST LOVE IT WHEN 1203483409875 PEOPLE answer the same answer to a pretty easy question. I think we gotta sort this out somehow... :) Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 100s of FTP Accounts
you could always write a WSH script to use ADSI to do that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:22 AM To: CF-Talk Subject: 100s of FTP Accounts We're about to offer all of our users and client complete ftp access to 10mb of storage. Every user will have his own directory on our NT machine and ftp account that will log him automaticlly to HIS special directory. What is the best way to seperate directories and accounts without the need to create 1000s of FTP accounts under NT? I've heard somewhere that by logging onto FTP with a username that is the same as on of the directories, the user automaticlly logs inside it. but I don't want to assign NT account to every user... :( - is it somehow possible with Anonymous FTP? Thanks, Michael Lugassy Interactive Music Ltd. I don't live in fantasy; I just work there... http://www.imvamp.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Character code for a TAB
that'd require a synchronous type of situation. the beauty is that people who may be able to answer the question don't have to be there when you are. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 12:48 PM To: CF-Talk Subject: Re: Character code for a TAB What about a CHAT solution? CHAT ROOM would be great!!! - Original Message - From: Dylan Bromby [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 5:28 PM Subject: RE: Character code for a TAB i still disagree with this. here's why: 1) sometimes answers are wrong 2) some people post really innovative solutions even after the problem might have been solved some people might be frustrated when the SAME answer is posted over and over. well...delete the thread. i don't think the answer is asking people not to respond just because there's a response that looks like an answer. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 7:31 AM To: CF-Talk Subject: Re: Character code for a TAB Instead of quickly hitting reply and sending out the answer, one can quickly scan the inbox or the digest to see if its been answered and then not reply. Mary There must be a way to let us know the question has been answered! Let's think about it! - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 24, 2001 3:51 PM Subject: RE: Character code for a TAB I think the problem is more due to the fact that the responses are more hey, I know the answer to this!!! repetitions than meant to clog the list. It's one of the downsides of using an e-mail list versus some other message base format. All of the replies probably got sent out at the same time and the delay the list actually getting them is more due to email lag than anything else. It's great to get a response and frustrating not to, and I think all of us have experienced both sides of that coin. So to make up for it, when we know how to help someone we reflexively hit reply. The cascade effect is what we all see. Hatton Humphrey Barbara remains in the hospital and needs blood donors for more transfusions. She is also having trouble sleeping and requests tapes of Pastor Jack's sermons. - From Real Church Bulletin Bloopers -Original Message- From: Erika L Walker [mailto:[EMAIL PROTECTED]] How about everyone bookmarks this page (http://www.asciitable.com/), now...then no-one should ever have to ask again. Except of course the newcomers. And those we'll beat into submission with a big ole CF book or something...? :) Erika -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] I JUST LOVE IT WHEN 1203483409875 PEOPLE answer the same answer to a pretty easy question. I think we gotta sort this out somehow... :) Thanks, Michael Lugassy Interactive Music Ltd. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 100s of FTP Accounts
have i left you speechless? :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Tobe Goldfinger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 1:20 PM To: CF-Talk Subject: RE: 100s of FTP Accounts At 11:51 AM 4/24/2001 , you wrote: you could always write a WSH script to use ADSI to do that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:22 AM To: CF-Talk Subject: 100s of FTP Accounts We're about to offer all of our users and client complete ftp access to 10mb of storage. Every user will have his own directory on our NT machine and ftp account that will log him automaticlly to HIS special directory. What is the best way to seperate directories and accounts without the need to create 1000s of FTP accounts under NT? I've heard somewhere that by logging onto FTP with a username that is the same as on of the directories, the user automaticlly logs inside it. but I don't want to assign NT account to every user... :( - is it somehow possible with Anonymous FTP? Thanks, Michael Lugassy Interactive Music Ltd. I don't live in fantasy; I just work there... http://www.imvamp.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: JS-question- transferring text from one template to another
take a look at irt.org and thier JS faq. there are TONS of code snippets there. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:31 PM To: CF-Talk Subject: OT: JS-question- transferring text from one template to another Hi, I want to do the following: I have an Input-template with five text-fields. On on text field (memory-field, text area) I want to call a small browser window via JS (wiht a hyperlink). So far so good. I know how I can do that. In the called template I have another Input-field which gets filled by the user. What I want to do is transferring the text in this text-area back to the calling page and reloading, but the text already filled in the four ohter input-boxes shouldn't be touched/changed. How can I do this. Does s.o. has his code available ? Thank you. Uwe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: statement help...
are you only outputting one? as in, do you have QUERY specified in the CFOUTPUT tag? or does your debug show only one returned? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:17 PM To: CF-Talk Subject: Re: statement help... i tried this also, and it still didnt work since then i have switched everything to be id specific now however, it still only returns the first record w/ that id, now. any ideas this is my query now cfquery name=getRodeos datasource=#datasource# dbtype=ODBC username=#username# password=#password# SELECT * FROM RodeoManager WHERE CircuitID = #url.CircuitID# /cfquery thanks, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com - Original Message - From: Mike Sprague [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 9:48 AM Subject: Re: statement help... Try the following as your where clause: WHERE trim(Circuit) = '#trim(url.CircuitName)#' *** REPLY SEPARATOR *** On 4/23/2001 at 9:31 AM Jay Patton wrote: |Why would this only select one record from the db?(there are about 12 it |should return but it only returns one (which is the first one) | |cfquery name=getRodeos | datasource=#datasource# | dbtype=ODBC | username=#username# | password=#password# |SELECT * |FROM RodeoManager |WHERE Circuit = '#url.CircuitName#' |/cfquery | | |Thanks, | |Jay Patton |Web Design / Application Design |Web Pro USA |p. 406.549.3337 ext. 203 |p. 1.888.5WEBPRO ext. 203 |e. [EMAIL PROTECTED] |url. www.webpro-usa.com | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFTRY / CFCATCH questions
that's incorrect, actually. it will catch them in the order defined. so if there is an ALL first, there will never be any other. basically, it starts at the first CATCH, compares exception types. if it is a match, that handler occurs, if not, it examines the next one in order, ad nauseum, until the last catch (which should probably be an ALL JIC) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 9:00 PM To: CF-Talk Subject: Re: CFTRY / CFCATCH questions There are no requirements on the order of cfcatch statements that I'm aware of. - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 6:45 PM Subject: CFTRY / CFCATCH questions I know that at least one CFCATCH must be put inside a CFTRY block. How picky is CF on the order of the tags, though? for example: CFTRY Some code CFCATCH type=Database /CFCATCH CFCATCH type=object /CFCATCH CFCATCH type=all /CFCATCH /CFTRY First off, can you use an 'all' catch with other specialized catches defined? Would a database exception catch at 'all' or would it catch at 'database'? If I changed the code around to look like this: CFTRY Some code CFCATCH type=all /CFCATCH CFCATCH type=Database /CFCATCH CFCATCH type=object /CFCATCH /CFTRY Then, where would a database exception catch? At 'all' or at 'database'? If I put the code after the CFCATCHs, would an error catch? Like this: CFTRY CFCATCH type=Database /CFCATCH CFCATCH type=object /CFCATCH CFCATCH type=all /CFCATCH Some code /CFTRY Thoughts, comments? Much thanks! Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http 500 Internal Server Error and CF installation
roger. for some reason i assumed that he had just installed all that mess. rebuilding the engine is something i ALWAYS do the first time around. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 9:13 AM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation true, but i always try that first. no need to rebuild the engine if your only out of gas grin -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 5:43 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation that depends. i've always had to (per instructions provided by Dave Watts) reinstall CF. however, the "500 error" is pretty generic. your way will fix 90% of the problems. however, if he just did an install, he may also be seeing these problems. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 4:19 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation no need to reinstall, go into IIS, application settings, remove and recreate the app...should fix it fine -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 3:00 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation you need to reinstall Win2K. it comes bundled with MDAC 2.5, and when installing CF over it, it breaks. just "upgrade" to Win2K FROM win2K and it'll be fine. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:14 PM To: CF-Talk Subject: http 500 Internal Server Error and CF installation I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the html pages to display but not the cfm pages, when for example, going to the cf administrator page. I get an http 500 Internal Server Error. I have followed all the instructions in the knowledge base article 7671 and the problem persists. There has to be a simple fix for this but I can't figure it out. Thanks, Sebastian -- There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Open the 127.0.0.1 home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Bank of America and e-stores and CFHTTP
has anyone had any particular problems or success using CFHTTP to talk to BoA's estores solution? i haven't been able to get it to work, and their techs tell me that people have *definately* used CF in the past to do this. i can follow thei rinstructions and use a standard HTML form post to their processing URL. this works successfully. however, when i try to make it a CFHTTP call, i get a "Failed form POST" error from their servers. anyone lend a hand? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bank of America and e-stores and CFHTTP
my apologies. i neglected to mention that the CF guys at BoA verified that the code is correct. in response to the other questions: 1) i'm going to try to use the USERAGENT part of CFHTTP to "spoof" IE if nothing else works. 2) yes, i'm posting to a secure URL. no, i haven't had any problems with that in the past with CFHTTP. the authorize.net stuff i use works perfectly 3) they suggested that i have to be coming *from* a secure URL as well. i'm working on trying that possibility next. as i said, the BOA folks said that my CFHTTPparams are correct. the CFHTTP call is here: CFHTTP URL="https://cart.bamart.com/payment.mart" METHOD="POST" PORT="443" i have a couple of options. if anyone happens to know the secret trick for this one, i'd be most grateful. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: JoshMEagle [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 11:30 AM To: CF-Talk Subject: RE: Bank of America and e-stores and CFHTTP could you show us the code? Are you using cfhttpparam? Are you closing your /cfhttp? Are you certain you've included the POST command? It's hard to diagnose without a snippet. Thanks, Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:16 AM To: CF-Talk Subject: Bank of America and e-stores and CFHTTP has anyone had any particular problems or success using CFHTTP to talk to BoA's estores solution? i haven't been able to get it to work, and their techs tell me that people have *definately* used CF in the past to do this. i can follow thei rinstructions and use a standard HTML form post to their processing URL. this works successfully. however, when i try to make it a CFHTTP call, i get a "Failed form POST" error from their servers. anyone lend a hand? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bank of America and e-stores and CFHTTP
that was on my list. tried it now while waiting for my client to get their SSL setup so i can test my first suspicion. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Tracy Bost [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 1:04 PM To: CF-Talk Subject: Re: Bank of America and e-stores and CFHTTP Have you tried specifying your user agent in the cfhttp post ?. I have seen certain web servers not play well with cfhttp unless that is specified. cfhttp url="yourbankofamericaserver.com" method="POST" port="443" resolveurl="true" useragent="Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)" - Original Message - From: "JoshMEagle" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, April 19, 2001 10:30 AM Subject: RE: Bank of America and e-stores and CFHTTP could you show us the code? Are you using cfhttpparam? Are you closing your /cfhttp? Are you certain you've included the POST command? It's hard to diagnose without a snippet. Thanks, Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 10:16 AM To: CF-Talk Subject: Bank of America and e-stores and CFHTTP has anyone had any particular problems or success using CFHTTP to talk to BoA's estores solution? i haven't been able to get it to work, and their techs tell me that people have *definately* used CF in the past to do this. i can follow thei rinstructions and use a standard HTML form post to their processing URL. this works successfully. however, when i try to make it a CFHTTP call, i get a "Failed form POST" error from their servers. anyone lend a hand? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: http 500 Internal Server Error and CF installation
that depends. i've always had to (per instructions provided by Dave Watts) reinstall CF. however, the "500 error" is pretty generic. your way will fix 90% of the problems. however, if he just did an install, he may also be seeing these problems. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 4:19 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation no need to reinstall, go into IIS, application settings, remove and recreate the app...should fix it fine -- Stephenie Hamilton Senior ColdFusion Administrator Express Technologies, Inc. want CF_Freedom? try CFXHosting.com -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 3:00 PM To: CF-Talk Subject: RE: http 500 Internal Server Error and CF installation you need to reinstall Win2K. it comes bundled with MDAC 2.5, and when installing CF over it, it breaks. just "upgrade" to Win2K FROM win2K and it'll be fine. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:14 PM To: CF-Talk Subject: http 500 Internal Server Error and CF installation I have just installed CFServer 4.5.1 on Windows 2000 with IIS. I get the html pages to display but not the cfm pages, when for example, going to the cf administrator page. I get an http 500 Internal Server Error. I have followed all the instructions in the knowledge base article 7671 and the problem persists. There has to be a simple fix for this but I can't figure it out. Thanks, Sebastian -- There is a problem with the page you are trying to reach and it cannot be displayed. Please try the following: Open the 127.0.0.1 home page, and then look for links to the information you want. Click the Refresh button, or try again later. Click Search to look for information on the Internet. You can also see a list of related sites. HTTP 500 - Internal server error Internet Explorer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: The Best Clustering Solution
i seem to remember reading that cluster cats DID come with replication. check the docs again. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Paul's Mail [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:19 PM To: CF-Talk Subject: The Best Clustering Solution we have 2 Win2000 servers running CF applications and wish to cluster them so that they both are duplicates of each other. The clustering solution must include replication. Cluster Cats supplied with CF Enterprise does not include replication and I cannot find this software in its full version including replication anywhere. Which is the best solution for clustering just two servers? Is the solotion supplied by Microsoft any good? Any help would be appreciated as the subject is new to me. Kind regards Paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Problem browsing web pages in the CFStudio editor window
go to Debug-Development Mappings (Alt-M if you're a shortcut guy) enter the path that studio "sees" as your studio path. this will be the same as the "server path" if you're running IIS/PWS locally. then put "http://localhost/" as your "Browser Path". this is what you would enter if you were browsing your local machine with IE/NS normally. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 5:21 PM To: CF-Talk Subject: Problem browsing web pages in the CFStudio editor window hi, i'd like to be able to browse web pages in the cfstudio editor window. however, when i click on the browse button above the window i get the following error message: "The CF file you are trying to browse cannot be resolved into a URL. Add a server development mapping to enable URL resolution for this file." What does 'server development mapping' mean, and how and to where should I add it? sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfif myvar IS true vs cfif myvar
that's CFIF isDefined("myvar"). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bonnie Betts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 8:45 PM To: CF-Talk Subject: Re: cfif myvar IS true vs cfif myvar I thought cfif myvar tested to see if it existed.. no? Bonnie E. Betts [EMAIL PROTECTED] www.interacttechs.com - Original Message - From: "Bert" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 6:19 AM Subject: cfif myvar IS true vs cfif myvar There seems to be a difference in the outcome of cfif myvar IS true and cfif myvar, when myvar is a number but neither 0 nor 1. Is this a feature to be used, or a bug, or have i missed something? Bert ps save the code below as trueorfalse.cfm to see what i mean: cfparam name="myvar" default="2" cfoutput b#myvar#:/b cfif myvar IS true myvar IS true cfelseif myvar IS false myvar IS false cfelse cfelse (i.e. NOT "myvar IS true" OR "myvar IS false") /cfif br b#myvar#:/b cfif myvar myvar cfelseif NOT myvar NOT myvar cfelse cfelse (i.e. NOT "cfif myvar" OR "cfif NOT myvar") /cfif form action="trueorfalse.cfm" method="post" input type="text" name="myvar" value="#myvar#" input type="Submit" /form /cfoutput ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query string disappear
the only way to do that is with a javascript generated window. js won't let you touch the "chrome" on a non-js generated window. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:21 PM To: CF-Talk Subject: RE: Query string disappear Alternativly you could possibly disable the location and status bars of the browser. A bit drastic however and more likely to annoy users than anything else. -Original Message- From: Javier Woodhouse [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 18 April 2001 13:02 To: CF-Talk Subject: RE: Query string disappear To hide 'ugly' URL's i usually put the page in a frame so the url will always read http://someplace.com/ as the user clicks through the one frame -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 12:32 PM To: CF-Talk Subject: Re: Query string disappear Yes, but these can be easily seen and manipulated by viewing the source. Encrypt() is a much better option for URL passed data. Todd - Original Message - From: "Garza, Jeff" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:18 PM Subject: RE: Query string disappear Really you can't. You'll have to look into using an onClick event to fire off some javascript that submits a form with hidden fields. That's what I do when I don't want clutter my urls with bunches of variables. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamically Displayed Content Weekly?
you don't even really need to do that. if you have queries to pull the data from your database on the "main page" (the one with the weekly data), use the CACHEDAFTER property of CFQUERY. this will cache the results until a certain date. set the date for one week from today, and voila! chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: dk [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 14, 2001 3:49 AM To: CF-Talk Subject: Re: Dynamically Displayed Content Weekly? Just create a .cfm page to get/ retrieve the content (maybe from a database or from some other site). Use the cfschedule tag to create a weekly schedule to run the above .cfm file once a week. This will update the content weekly. hth, DK - Original Message - From: SHEETS, DAYV (PB) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 1:31 AM Subject: Dynamically Displayed Content Weekly? Can anyone tell me where I could find out more regarding dynamically displaying text on a cfm page weekly? I know this can be done in ASP but wasn't sure if it was possible in cf. TIA, Dayv ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dynamically Displayed Content Weekly?
whoops. didn't state it correctly. i was hung up on the "date" idea. of course, you are correct. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 9:43 PM To: CF-Talk Subject: RE: Dynamically Displayed Content Weekly? Actually, that's not right. The cachedwithin attribute of cfquery will do what you are saying. cachedafter caches a query AFTER the date/time you specify, like so: cfquery datasource="MyDSN" name="MyQuery" cachedafter="#CreateDateTime(2001, 04, 16, 21, 35, 0)#" .SQL... /cfquery Would continue to retrieve the query data from the database until the query was run after the date/time specified in the cachedafter attribute. So to specify a time in the future when the query should be flushed and reloaded from the database, use: cfquery datasource="MyDSN" name="MyQuery" cachedwithin="#CreateTimeSpan(days, hours, minutes, seconds)#" .SQL... /cfquery - Andy -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 8:25 PM To: CF-Talk Subject: RE: Dynamically Displayed Content Weekly? you don't even really need to do that. if you have queries to pull the data from your database on the "main page" (the one with the weekly data), use the CACHEDAFTER property of CFQUERY. this will cache the results until a certain date. set the date for one week from today, and voila! chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: dk [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 14, 2001 3:49 AM To: CF-Talk Subject: Re: Dynamically Displayed Content Weekly? Just create a .cfm page to get/ retrieve the content (maybe from a database or from some other site). Use the cfschedule tag to create a weekly schedule to run the above ..cfm file once a week. This will update the content weekly. hth, DK - Original Message - From: SHEETS, DAYV (PB) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 1:31 AM Subject: Dynamically Displayed Content Weekly? Can anyone tell me where I could find out more regarding dynamically displaying text on a cfm page weekly? I know this can be done in ASP but wasn't sure if it was possible in cf. TIA, Dayv ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reveral of a field
you could use the listfirst and listlast functions. assuming that your names are alwas Last, First: CFSET thename = "Smith, John" CFOUTPUT #listlast(thename)# #listfirst(thename)# /CFOUTPUT make sense? chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 7:48 AM To: CF-Talk Subject: Reveral of a field Hi, I have a field with Smith, John as the contents. I want to display John Smith... I'm think I get the total length(a), then the charlength of the comma(b). Take contents b + 1 and subtract that from a equals (c) Then display the difference of c to a (d) and then output c after d to the total of the field Any other ideas? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disabling back or second insert
why not move the check to the action form? that way they can enter the data all they want, and click submit all they want. it won't insert the data if someone by that name's already there. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Smith, Daron [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 9:17 AM To: CF-Talk Subject: disabling back or second insert I have a registration form, that queries initially to make sure that the registrant is not already registered, so it eliminates people from registering more than one time if they come back to the site, however if they submit the form and do not think anything has happened, they can use their back button, hit the submit button and the query does another insert and I end up with multiple records in my DB. What is the best way of keeping them from doing this? An expiring cookie? Or is there javascript to eliminate the ability to go back? Thanks Daron J. Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disabling back or second insert
you really can't stop them from using the back button. javascript won't let you touch the "chrome" stuff on a non-js generated window. even if you could stop the button itself, they could right-click in the window and select back, or do a few other things. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 12:07 AM To: CF-Talk Subject: RE: disabling back or second insert Might as well chime in What I do is set a hidden variable in the form, usually a time/date or random number (depends on how I'm feeling!). That variable is created on the first page of the form. It can be carried through countless form pages, but the user hits the submit and an insert is to be performed, I query the db for a record with that variable, if it already exists, it is presumed this a duplicate entry attempt, and the insert is not performed. Sometimes I even spit our a little message like "Yeah Yeah we got it the first time you hit submit!" that sorta thing. The only really drawback to this is if the user hit the back button to make changes to his form entry, they will never be submitted. I would prefer the abilty to kill the back. How are some of you doing this with Javascript? Brian -Original Message----- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 3:52 PM To: CF-Talk Subject: RE: disabling back or second insert why not move the check to the action form? that way they can enter the data all they want, and click submit all they want. it won't insert the data if someone by that name's already there. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Smith, Daron [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 9:17 AM To: CF-Talk Subject: disabling back or second insert I have a registration form, that queries initially to make sure that the registrant is not already registered, so it eliminates people from registering more than one time if they come back to the site, however if they submit the form and do not think anything has happened, they can use their back button, hit the submit button and the query does another insert and I end up with multiple records in my DB. What is the best way of keeping them from doing this? An expiring cookie? Or is there javascript to eliminate the ability to go back? Thanks Daron J. Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: disabling back or second insert
only problem with that particular approach is that HTTP_Referer is not always passed by the browser. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 9:48 PM To: CF-Talk Subject: Re: disabling back or second insert This approach is interesting... it uses a session variable and the HTTP_referer variable to check if the user is going "back" and simply won't let them. http://cfhub.com/contributions/backbutton/ you really can't stop them from using the back button. javascript won't let you touch the "chrome" stuff on a non-js generated window. even if you could stop the button itself, they could right-click in the window and select back, or do a few other things. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: adding records
i don't think it will directly do it. i've worked with it, and she wants to populate a textbox, not another drop down. but i think you can abuse the tag by writing your own handler for what it already does. just replace the bit that changes the second select box to populate the text box. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 6:50 PM To: CF-Talk Subject: RE: adding records Check out the Allaire Developer's Exchange for CF_TwoSelectsRelated custom tag. This will do exactally what you want. http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA 9700508B94F380method=Full (carefull of the line wrapping...) Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:43 PM To: CF-Talk Subject: adding records hey again, i have a form which allows a user to add a new application to my apps database. i want to have a drop down list of companies. (that i can do) but i want the phone number field to automatically populate if when the user selects say "microsoft" from the list. that phone number will show up in the phone number field because "microsoft" has a phone number in my database. otherwise, the person inputting the data will have to retype the phone number in each time (and remember the number in order to input it!) is this possible to do on the same form? thanks for the info.. b * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to Allow a Doesn't Matter Variable in a Search?
if you use checkboxes for the selections, use isDefined() on your action page. if the checkbox for that selection is defined, include it in your where clause ex: SELECT WHERE CFIF isDefined("FORM.hottub") AND hottub field is yes /CFIF chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: P@tty Ayers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 1:31 PM To: CF-Talk Subject: How to Allow a "Doesn't Matter" Variable in a Search? Friends: Can anyone help with this problem I'm stuck on? Not sure if this is a simple one or not, but in any case I'll sure be delighted to get it working. This set of pages allows the user to search a set of records using 9 search objects. Four of those are for searching yes/no (1/0) fields in the Access2000 database. For the four search fields which search yes/no columns, I want them to choose either "This doesn't matter - don't include this in the search" OR "Include only records with "yes" (1) in this column. They need to be able to specify that they want to see only rental properties that have a hot tub, or else that this doesn't matter to them. Obviously this differs from offering the choice between "Include only records with 'yes' in this column" and "Include only records with 'no' in this column", which is *not* what I need to do here. This could be done with checkboxes or a menu - but I can't figure out how to allow that "This doesn't matter" search parameter. Thanks very much in advance for your help! P@tty Ayers Macromedia Evangelist Dreamweaver Resources, FAQs, and Tutorials: http://www.thepattysite.com/dreamweaver/ P@tty's ColdFusion Site http://carolina.cf-developer.net Carolina Web Solutions http://www.carolinawebsolutions.com "Design in art, is a recognition of the relation between various things, various elements in the creative flux. You can't invent a design. You recognise it, in the fourth dimension. That is, with your blood and your bones, as well as with your eyes." - D. H. Lawrence "Well-behaved women seldom make history." - Anonymous ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Line Breaks
that's odd. would have been my answer before today, but i had a template that WOULD NOT put in CRs for me. wierd. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Diana Nichols [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:22 PM To: CF-Talk Subject: RE: Line Breaks CFmail works just like pre.line breaks, tabs, etc will appear in the email as you type them * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:18 PM To: CF-Talk Subject: Line Breaks How do you make line breaks within a cfmail? Everything seems to just run together. Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Simple validation
isDate(). isNumeric(). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Steven A. del Sol [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 6:04 PM To: CF-Talk Subject: Simple validation I am in desperate need of a simple validation of two types of form fields. 1. Date field (not a cfform just a plain form) - must validate that data entered is a date 2. Number field (not a cfform just a plain form) - must validate that data entered is a number Thanks Stephanie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [Oracle Auto-Increment]
just mark something as an identity in the design table form. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 9:58 AM To: CF-Talk Subject: RE: [Oracle Auto-Increment] What about SQL Server -- how to auto-increment?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Alex [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 9:45 AM To: CF-Talk Subject:Re: [Oracle Auto-Increment] create a sequence then in your INSERT sql type sequencenqme.next_val. not sure on specific syntax Jamie Symonds [EMAIL PROTECTED] wrote: Hi - I am inserting results of a form into an Oracle 8 database - in the past, while using Access, I would set the first field of the table ("id") to "auto-number" for my primary key. Oracle does not have an auto-increment feature - how do I go about this? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
PreserveSingleQuotes(). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:39 PM To: CF-Talk Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Text area question
when you save it, make sure your form area WRAP attribute is set to HARD. then use paragraphformat on the output side. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Javed Mushtaq [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:18 AM To: CF-Talk Subject: Text area question Hi all, I have a text area on a page and need to save to a database and then output the information exactly as it appeared on the text area. How do i do this, could anyone send me the code as got to get this up and running by 10am today. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session time out
you need to enclose your time units in " marks for createtimespan eg: createtimespan("0","1","0","0") chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chang Liu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 3:52 PM To: CF-Talk Subject: session time out Hi all, I tried to use: cfapplication name="the name" sessionmanagement="yes" sessiontimeout=#createtimespan(0,1,0,0)# for one hour time out, but it still keeps 20 mins time out. any ideas and suggestions? thanks in advance! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Import List into DB
just use Access' Import function and select "Text File" as a source. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jim Mixon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 6:55 PM To: CF-Talk Subject: Import List into DB a question for the sages here . . . What would the CF function or tag be for importing a simple list, w/line breaks ie. . . [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] which is in a plain ASCII .txt file into an existing ACCESS table . . . . OR is there a way? thanks in advance. . . Jim Mixon - CEO APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . [EMAIL PROTECTED] http://www.apt.net/ PO Box 160217 Hialeah, FL 33016 305-821-8451 FAX (305) 821-8189 auto-switching FAX powered by Cold Fusion 4.01 . . . . feel the force! CF Hosting Now Available . . . . ! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: newbie wants to access by rows and columns
technically, you can't do this. some other people have suggested solutions that will give you a close approximation of "the second row". the problem (there is no fault with the suggestions or code) is that the concept of "the second row" is not a constant. because of the way RDBMS systems work, there is no way to *guarantee*, *every single time* that the "second row" will be the "second row". the data "lives" out in database land, and is returned in sets. just because something is the second row one time you query for * from the DB, there is no hard and fast guarantee that it will be the second row the next time. this is especially true for SQL server and Oracle (IOW, the more "powerful" DBMSs.) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Roadrunner [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 9:48 PM To: CF-Talk Subject: newbie wants to access by rows and columns Yes, Lee I want to access fields by rows and columns. Exactly. If it is more advanced which you state it is, what topic would I look under in a Cold Fusion book. I've abused everyone's talents enough for one evening. I'm willing to go out and study this on my own. I just need direction. Thanks, Greg -Original Message- From: BORKMAN Lee [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 9:38 PM To: CF-Talk Subject: RE: Thanks everyone but one last question Do you really want to see what's in row 2, column 2, or do you want to see what ID(3)'s First Name is? That seems much more useful. To do that you just use CFQUERY name=test SELECT FirstName from TableName WHERE ID = 3 /CFQUERY #test.firstname# If you really want to access fields by row and column number, there are a number of ways, all of them slightly more advanced, but I doubt that's actually what you want. Let us know, thanks Leeb. -Original Message- From: Roadrunner [mailto:[EMAIL PROTECTED]] .. See the database setup below. ID PASSWORD FIRSTNAME LASTNAME 4 sdf greg landry 3 gth tom jones Lets say I wanted to see what is in the second record and see what's under the column FIRSTNAME. What I am learning is that I have to print out the entire database to see what is in it. I would just like to be able to know how to access a particular element in a database. Like what's in row 2, column 2? IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server...
i've never had the defaults/identity stuff transfer successfully, either. even between SQL installs, selecting "Transfer Objects". i've resorted to scripting the tables, sticking the defaults in myself (scripting will capture the identities) and running the scripts on the target system. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 9:02 PM To: CF-Talk Subject: RE: SQL Server... I used the SQL Server export function (Data Transformation Service) to move data (and table structure) from one SQL Server database to a blank SQL Server database. Everything looked fine initially, however I have realized that it did not copy over default value. Nor did it copy over seed information. Is this common? Is there a better way to do this (Other than detaching / attaching the database)? Although I haven't verified it yet, I do suspect that I exported the data from a SQL Server 2000 DB into a SQL Server 7 DB. Would I experience the same results if this occurred between to SQL Server 2000 DBs? Typically, when transferring between two SQL 7 servers, you have an option to transfer "objects and data". This gets not only the tables and their data, but everything else as well. In addition, you can do a backup to file from one, then restore from file on the other. I've had better luck with that, with pre-SP versions of SQL 7. This is better than detaching and attaching, since you don't have to stop operation of the database on the source server, and you don't have problems with "phantom logins" that might exist in one server but not the other. (Although there is a way to address that, if necessary.) 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: getting users name
it's NT Challenge/Response. (not that that's important...:) look at CGI.AUTH_USER for the login name. (this question has been asked several times recently. kind of interesting how things seem to run in cycles) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 12:08 PM To: CF-Talk Subject: OT: getting users name I have a web page that is secured so the user has to enter a name and password to get into the site. This is done with WinNT permissions on the folder that the web page is in. I think the official name is server side validation. Is there a way to grab the name the user inputs and use it in my cold fusion pages? Thanks In Advanced Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL + time stamp
try GROUPing on the hour part of the time. similar to: SELECT datepart("hh", dt) as myhour, sum(columnOne) as totalflow FROM tablename WHERE date criteria here GROUP BY datepart("hh", dt) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 12:29 PM To: CF-Talk Subject: RE: SQL + time stamp Eric one reading is coming in every 15 minutes of every hour. Its a C compiled agent that is taking quartly flowrates from a reservoir and emailing to our database. I'm getting 4 readings, one every 15 minutes, 4:15 , 4:30 , 4:45 , and 5:00 and so on. the only thing is they are not coming in quite as accurate like that, at least not all the time. More like 4:16 , 4:29 , :4:45 , 4:59. So what I want to do is sum(all Quaters for every hour). Any ideas? (hope this is clearer!!) -Original Message- From: Eric Barr [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 16:07 To: CF-Talk Subject: RE: SQL + time stamp John, I'm not quite clear what your getting at do you mean that a reading is taken every 15 minutes and you want to know the sum of the readings at 00, 15,30, and 45 ? so that the readings from 2:15 are summed with readings from 1:15 and 3:15 ? Or are multiple readings being inserted every 15 minutes and you want the sum of all the entries entered at 2:15 to be in one group and 2:30 in another and 3:15 into still another ? -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:11 AM To: CF-Talk Subject: SQL + time stamp I know this is an SQL question. I am getting readings inserting into a database every 15 minutes on the hour. They are time stamped like so, (dt) (columOne) 2001-02-28 12:59:5938.7 2001-02-28 12:45:0138.77 2001-02-28 12:30:0138.7 2001-02-28 12:15:0137.22 My problem is how would I do a sum value for 'columOne' adding up each quarter for each hour? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Building Cold Fusion Search - Dynamic SQL
since a multiple select gives you nothing more than a list, try a list loop. SELECT e.empId, es.skillId FROM emp e, empSkills es WHERE e.empId=es.empId CFLOOP INDEX="skillidx" LIST="#FORM.frmSkill#) AND skillId = #frmSkill# /CFLOOP chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kim Mayhall [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:23 PM To: CF-Talk Subject: Building Cold Fusion Search - Dynamic SQL I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Building Cold Fusion Search - Dynamic SQL
great googlymoogly! my bad. thanks. (i've been doing "customer relationship" stuff all day. must have rotted my brain!) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Maia, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:22 PM To: CF-Talk Subject: RE: Building Cold Fusion Search - Dynamic SQL The problem with this approach is that it ignores the relational model of the two tables. Each record in empSkills will only have one value for skillId, so you won't get any records looking for two values. You'll need to do a self-join or subquery to look for one record in emp that has two or more related records in empSkills that match the two skills you're looking for. Try this: SELECT e.empId, es.skillId FROM emp e, empSkills es WHERE e.empId=es.empId CFLOOP INDEX="skillidx" LIST="#FORM.frmSkill#) AND e.empID IN (SELECT empID FROM empSkills WHERE skillId = #skillidx#) /CFLOOP GROUP BY empId -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 6:43 AM To: CF-Talk Subject: RE: Building Cold Fusion Search - Dynamic SQL since a multiple select gives you nothing more than a list, try a list loop. SELECT e.empId, es.skillId FROM emp e, empSkills es WHERE e.empId=es.empId CFLOOP INDEX="skillidx" LIST="#FORM.frmSkill#) AND skillId = #frmSkill# /CFLOOP chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Kim Mayhall [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:23 PM To: CF-Talk Subject: Building Cold Fusion Search - Dynamic SQL I'm trying to build some sql statements based on selections from a list box: select name="frmSkill" option Skill1 option Skill2 option Skill3 option Skill4 (etcthis size will vary as it's dynamically populated) /select A user can do a multiple select, so let's say the user picked option 1 and option 3. On my action page, I want to pick ONLY the employees that have the 2 skills selected. If I use an IN statement, I get employees with one skill or the other, but I only want those with both: SELECT e.empId,es.skillId from emp e,empSkills es where skillId IN (#frmSkill#) AND e.empId=es.empId How can I write the SQL to select only the employees with both, or do I use Cold Fusion to do that? Kim Mayhall The Garrigan Lyman Group http://www.glg.com http://www.glg.com/ (206) 223-5548 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Selecting a date range, access DB
well, if you pick all the dates that have a date greater than today AND less than today, you'll get nothing. :) i think you need to rethink your date range. :) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 10:45 AM To: CF-Talk Subject: Selecting a date range, access DB My aim is to pick all records out of an access DB, by date range. I'm using the following CF: cfquery name="bulletins" datasource="News" SELECT * FROM Articles where approved and startdate #Now()# and expirydate #Now()# /cfquery Turning on debug on the server shows this ends up as SQL = SELECT * FROM Articles where approved and startdate {ts '2001-02-26 15:37:22'} and expirydate {ts '2001-02-26 15:37:22'} Unsuprisingly, this returns no results (there is at least one record in the intended range). Is my SQL off, or do I need to use a particular type of date in access ? Regards, Thomas Chiverton, Intranet Webmaster and Desktop Analyst Office: 01565 757 909 As a GUI, reality in useless... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Selecting a date range, access DB
where you will be promptly killed and eaten by the CFTALKers waiting for your return. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ramonda Ramos [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 11:59 AM To: CF-Talk Subject: Re: Selecting a date range, access DB I will be out of the office today, Monday, February 26. I will return Tuesday, February 27. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: browser refresh/reload
that's not strictly correct. the webserver and browser are the ones that handle these variables (CGI and HTTP scoped ones.) not all browsers support them. additionally, the HTTP_REFERER variable you talk about first is only populated when following a link. refreshing a page does not change the referer. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 12:36 PM To: CF-Talk Subject: RE: browser refresh/reload yes there is. there coldfusion automatically creates a variable that contains the url or address that u came from to get to the current page. it also gives u a variable which contains the url of the page u are on (I am 95% sure hehe). so u can do a CFIF to see if the page the person came from matches the page he is at. if it is true, then it must be a refresh -Original Message- From: Jay E Wigginton [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 10:52 AM To: CF-Talk Subject: browser refresh/reload Is there a way to determine in CF whether the page has been refreshed or reloaded? Or maybe a method in JavaScript? thanks Jay ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: A little help with aggregate query, please?
your sum is being GROUPed by each individual donor. it might be more advantageous to calculate it yourself while looping through the "individual donors" query. ex: query cfquery name="GetReportInfo" datasource="tjf" dbtype="ODBC" SELECT Donors.ID, Donors.Fname, Donors.MI, Donors.Lname, Donations.DateDonated, Donations.AmountDonated, FROM Donors, Donations WHERE Donors.ID = Donations.DonorID AND Donations.DateDonated Between #CreateODBCDate(StartDate)# and #CreateODBCDate(EndDate)# ORDER BY Donors.ID, Donors.Fname, Donors.MI, Donors.Lname, Donations.DateDonated /cfquery then in your output... CFSET numdonors = 0 CFSET totaldonations = 0 cfoutput query="GetReportInfo" CFSET numdonors = numdonors + 1 CFSET totaldonations = totaldonations + getReportInfo.amountdonated /CFOUTPUT your totals will be in these two variables to display at your leisure. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 5:53 PM To: CF-Talk Subject: A little help with aggregate query, please? Howdy, I have an aggregate query that's kicking my butt. Its purpose is to retrieve a simple report of donations by donors within a given date range. Most everything works except for the Count and Sum functions. I'm not sure this can be done in one query or not. Database is MS Access. What I'm trying to do: display individual donations (name, amount and date they donated) and then have a total for the number of people who donated during this period and the total amount of their donations. Here's what a simple report should look like: Period: 1/1/2001 to 3/1/2001 Donor Amount Donated Date Donated James C Montgomery $1.0002/21/01 Joe A Blow $1.0002/21/01 John C Doe $1.0002/21/01 Total Donors This Period: 3 Total Donated This Period: $3.00 But here's what I'm getting: Period: 1/1/2001 to 3/1/2001 Donor Amount Donated Date Donated James C Montgomery $1.0002/21/01 Joe A Blow $1.0002/21/01 John C Doe $1.0002/21/01 Total Donors This Period: 1 Total Donated This Period: $1.00 Notice the totals aren't computing properly. Here's my code: cfset StartDate = StartMonth "/" StartDay "/" StartYear cfset EndDate = EndMonth "/" EndDay "/" EndYear cfquery name="GetReportInfo" datasource="tjf" dbtype="ODBC" SELECT Donors.ID, Donors.Fname, Donors.MI, Donors.Lname, Donations.DateDonated, Donations.AmountDonated, Count(Donors.ID) AS DonorCount, Sum(Donations.AmountDonated) AS TotalAmount FROM Donors, Donations WHERE Donors.ID = Donations.DonorID AND Donations.DateDonated Between #CreateODBCDate(StartDate)# and #CreateODBCDate(EndDate)# GROUP BY Donors.ID, Donors.Fname, Donors.MI, Donors.Lname, Donations.DateDonated, Donations.AmountDonated /cfquery !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleDonation Report/title /head body cfif GetReportInfo.recordcount h3 align="center"Period: cfoutput#startdate# to #enddate#/cfoutput/h3 table border="0" cellspacing="2" cellpadding="2" align="center" tr align="left" thDonor/th thAmount Donated/th thDate Donated/th /tr cfoutput query="GetReportInfo" tr td#fname# #mi# #lname#/td td#DollarFormat(amountdonated)#/td td#DateFormat(datedonated, "mm/dd/yy")#/td /tr /cfoutput tr td colspan="3"hr size="1"/td /tr tr td/td tdTotal Donors This Period: cfoutput#GetReportInfo.donorcount#/cfoutput/td tdTotal Donated This Period: cfoutput#DollarFormat(GetReportInfo.totalamount)#/cfoutput/td /tr /table cfelse pThere were no donations during this period./p /cfif /body /html If anyone can help me figure out how to fix the query I would greatly appreciate it. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Delimiters...
look at the ListFirst, ListLast, and ListRest functions. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Ethan Rosch [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 4:20 PM To: CF-Talk Subject: Delimiters... Hi all Is there a command similar to Left(string, count) that is DelemiterLeft(String,Delimeter) DelemiterRight(String, Delimeter) such that if I was to get a variable like Name = Toohey,Elton I could do CFSET LastName = DelimterLeft(Name, ",") CFoutput#LastName/CFoutput would give me Toohey ? thanks... ethan - Original Message - From: "Ethan Rosch" [EMAIL PROTECTED] To: "Fusebox" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 3:20 PM Subject: Re: modules, loops, and fun! Hi Douglas...thanks for the tip... I still think I need to pass my fields as I will be uploading/deleting files and don't want to be running my actions on every field. Perhaps I could just do a test for "://". the evaluate() was what I was looking for. e - Original Message - From: "Douglas Smith" [EMAIL PROTECTED] To: "Fusebox" [EMAIL PROTECTED] Sent: Friday, February 16, 2001 11:55 AM Subject: Re: modules, loops, and fun! By the way, you don't need to pass in your list of form fields, since they are globally available to the CFMODULE you are running. I think you want to use the EVALUATE function like so: CFLOOP collection="#form#" item="CurFormField" CFSET MyFormField = Evaluate("form.#CurFieldField#") /cfloop However, if you do a list loop (which is slightly slower), then do this: CFLOOP list="#MyList#" index="CurFormField" CFSET MyFormField = Evaluate("form.#CurFieldField#") /cfloop At 10:22 AM 2/16/01, Ethan Rosch wrote: hi all... quick question as I delve into the world of modules and loops... I am trying to build a module that will in turn loop over the attributes sent to it, which are form fields..this module will take whatever form fields are sent to it and then get there values and act via a loop. my problem is how to get the formfelds to parse to their values in the module loop and not their names. here's a sample code of the idea: cfmodule template="test.cfm" mylist="firstformfieldname,secondformfieldname," --- for this example let's say that firstformfield's user inputed value = Red secondformfield's user inputed value = blue now the module --- cfloop index="fieldname" list="#attributes.mylist#" cfoutput#Fieldname#/cfoutput /cfloop what I want is : Red Blue what I get is: FirstFormField SecondFormField any idea's would be greatly appreciated...I'm beating myself up and now I come to you. thanks, ethan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Pre-made State and Country database tables?
there's country and state tags in the Developers's exchange at allaire. very nice, i use them a lot. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Joby Bednar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 8:18 PM To: CF-Talk Subject: OT:Pre-made State and Country database tables? Anyone have a pre-made Access database table with the State Name and State Abbr. and/or Country Name and 2 digit Country Code? Or really any other information that might be of use... I'm using Access 2000, but any format that can be imported would be helpful. I need to use them for a client's site and I shutter at the thought of researching the info and populating the fields myself. Sorry for being lazy, but I thought I'd try... I've got SIC codes in a table if anyone wants to swap? ;) Joby Bednar Director of Internet Design iNEOgroup.com http://www.ineogroup.com Fusing your Dreams and the Web, Together as One [EMAIL PROTECTED] Cell: 949-283-5138 Personal Fax: 208-485-1170 Only $19.95! Register your Domain Name with SAVE-A-NAME.COM www. . com net org ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIS redirect URL
you don't really need a redirect. just create a virtual site for members.mydomain.com with its root at /userhomepages. that should get you started. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay E Wigginton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:08 PM To: CF-Talk Subject: OT: IIS redirect URL I apologize for the off topic message but I am about to pull my hair out trying to figure out how to redirect a URL in IIS v5.0... I have a website that has two domain names... http://www.mydomain.com and http://members.mydomain.com they are both DNS'd to the same IP address... the members.mydomain.com needs to redirect to a members homepage... I have directory structure under my wwwroot that holds all the members homepages... /userhomepages/username I need the members to be able to type the url... http://www.mydomain.com/username and have it redirect to the correct /userhomepages/username under the wwwroot. I have played around using various combinations of the redirection variable $S... but the IIS docs do not really give any examples... they simply state to use $S to append what follows the redirected URL... Any help would be greatly appreciated thanks Jay ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can anyone help?
you need to put the lvalue in for both comparisons. like this: cfif ProdCount LTE "3" AND ProdCount GTE "1" chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 12:40 PM To: CF-Talk Subject: can anyone help? Hello all, Im getting an error that i cant figure out here... everything looks fine to me but maybe someone else can see something. here is the error.. Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 98 at position 30. ColdFusion was looking at the following text: GTE Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFIF tag occupying document position (98:2) to (98:6). AND HERE IS MY CODE: cfquery datasource="#datasource#" name="find_subcats" SELECT * FROM SubCats WHERE TopCatID = #URL.CategoryID# ORDER BY SubCat /cfquery cfset ProdCount = prodpage.RecordCount cfoutputcenterfont class="boldtext"#prodpage.Category# /font/center/cfoutputbr center table cellspacing="0" cellpadding="4" border="0" width="30%" CFPARAM NAME="URL.StartRow" DEFAULT="1" cfloop query="prodpage" cfoutput query="prodpage" startrow=#URL.StartRow# maxrows=6 !! this is line 98!! cfif ProdCount LTE "3" AND GTE "1" cfif ProdCount EQ "0" tr /cfif td colspan="4" align="center" valign="bottom" a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID#"img src="images/#ItemPic#" border="0"/abr font class="boldtext"a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID#"#ItemN ame#/a/font/td cfif ProdCount EQ "3" /tr /cfif /cfif cfif ProdCount LTE "6" AND GTE "4" cfif ProdCount EQ "4" tr /cfif td colspan="4" align="center" valign="bottom" a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID#"img src="images/#ItemPic#" border="0"/abr font class="boldtext"a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID#"#ItemN ame#/a/font/td cfif ProdCount EQ "6" /tr /cfif /cfif cfset ProdCount = ProdCount + 1 /cfoutput /cfloop /table /center Any help would be much appreciated. Thanks, Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing a value
looks like you're not terminating the string on the last meta tag. meta http-equiv="refresh" content="0;URL=http://www.workcover.com/search/?ul=ps=10np=0q=#URL.SemioQ ueryString#" notice the closing " on the content piece. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 7:03 PM To: CF-Talk Subject: Passing a value Can anyone help me with this please and tell me why I am not getting the output I want. I am passing a value on the URL. If my input is say "rise" what I am getting from this template is "rise head body bgcolor text" instead of just "rise". I have considered CFLOCATION but the problem is that when I get this working I need to put some frame busting code in and I understand that there is a problem mixing JavaScript and CFLOCATION. html head titleSEMIO Redirect/title meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" cfoutput meta http-equiv="refresh" content="0;URL=http://www.workcover.com/search/?ul=ps=10np=0q=#URL.SemioQ ueryString# /cfoutput /head body bgcolor="#FF" text="#00" + Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 800 287 + This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dateformat behaviour
actually, it looks like DateFormat is helping you out by assuming that the second date you supply is the "european" style of mm/dd/. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: INGECOM - D. Delcomminette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 9:05 AM To: CF-Talk Subject: Dateformat behaviour Have a strange behaviour of DateFormat() function. Look at the following code and the results below. In my opinion CF could give me an error message on the second line (invalid date) but certainly not invert the day and month as it does! Your comments? Dominique cfoutput TABLE border="1" TR TDDateformat("01/12/2000","mmdd")/TD TD#Dateformat("01/12/2000","mmdd")#/TD/TR TR TDDateformat("13/12/2000","mmdd")/TD TD#Dateformat("13/12/2000","mmdd")# /TD/TR/TABLE/P /CFOUTPUT/P Dateformat("01/12/2000","mmdd") 2112 Dateformat("13/12/2000","mmdd") 20001213 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Running Low on Virtual Memory
doing a properties on that file, i see it's description is (helpfully...) "Generic Host Process for Win32 Services". HTH. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Raley, Scott M (MIL) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 3:21 PM To: CF-Talk Subject: RE: Server Running Low on Virtual Memory I've had a problem with CF 4.5.1 and Win2K AS ... there is a file called svchost.exe that shows up in taskmanager. I don't recall what it is linked to but every once in a while it goes crazy and eats up all the virtual memory and I have to reboot the server. I've added SP1 and that hasn't solved the problem either. I've been shutting down service by service to see if I can figure out what is causing it to trigger but nothing yet. -Original Message- From: Debbie McDaniel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 1:33 PM To: CF-Talk Subject: Server Running Low on Virtual Memory Hi All, For the past couple of months we have been getting a low virtual memory error on our CF Server about every 10 days. The CF server software ran fine until we moved it to Win2K and added .asp pages to the server as part of our intranet (please don't ask why, but part of our intranet is written using CF technology and the other part in written using ASP technology, both running session variables). Here is the server's configuration: Win2K (no service pack) CF 4.5.1 SP1 Max 728 MB Paging File PIII 800 with 256 MB Ram Plenty of harddrive space No Active Directory Service on Win2K In addition to this, we access an Oracle database using native drivers for the CF pages and ADO for the ASP pages. There is also an additional website running on the server using an Access 97 database as the backend (the shopping cart application we are using is AbleCommerce). We haven't been able to pinpoint the source of the memory leak. We don't know if it has to do with AbleCommerce and Access 97, the .asp or .cfm connections to the Oracle database, or simply some other memory leak problem between Win2K and CF. If anyone has any experience or practical suggestions on how to fix the low memory error, your knowledge would be greatly appreciated. As it stands right now, we end up having to reboot our Web Server every Monday morning to avoid the low memory error which eventually shuts down the server if it is not caught in time. Thanks, Debbie McDaniel Sr. Web Developer Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Urgent - Forums 2.05 Anyone Got?
unfortunately, it's not so easy to find the "TODO" list for the forumspot project. i looked all over the site today, as i'm interested in contributing, but could find no place that listed the TODO stuff (as is traditional in open source projects). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 6:27 PM To: CF-Talk Subject: Re: Urgent - Forums 2.05 Anyone Got? Gel, Since Forums is now open source, you have a great opportunity to contribute to the project and make all of those features happen. When should we expect your involvement in the effort and the completion of all of these great additions? Rey Forumspot Core Team Member www.forumspot.org - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 12, 2001 3:17 PM Subject: RE: Urgent - Forums 2.05 Anyone Got? I don't understand.. why doesn't the CF Forum software look like the accepted and most useful type of discussion board? The Threaded Discussion Board... and why doesn't it have cool features like small iconic representations of board members etc.?? I mean look at UBB, Fuestalk,even Coolboards..they all have some really cool features and appear...Exciting! That CF Forum stuff just looks so ..bland by today's standards. Why would someone choose this over say Fusetalk? Beside the fact that it's free.. -Gel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Multiple conditions in a single CFIF statement.
what you wrote was correct. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 11:15 PM To: CF-Talk Subject: Multiple conditions in a single CFIF statement. So far I've only used single CFIF statements - hence don't know syntax for multiple conditions and haven't been able to find an example in the books I have. Can someone give me a hint or example of the CF syntax to do state the following condition: CFIF mTEST1 EQ "ABC" AND mTEST2 EQ "DEF" without using nested CFIF statements??? Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Session timeout question
i don't think that's strictly correct. you can't "define the timeouts" of session variables, you define them of the entire session. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:34 PM To: CF-Talk Subject: RE: Session timeout question that's not exactly true. if you define the timeouts of session variables in an application.cfm file, they can timeout at different times. if you set one to timeout in 15 minutes and another at 30 minutes, then idled for 20 minutes, the first would timeout, the second would not. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:49 PM To: CF-Talk Subject: Re: Session timeout question On 2/7/01, Phoeun Pha penned: Oh, i know the question now! Are individual session variable timeouts independent of other session variables, or are they all affected at the same instance? All session variables that exist are refreshed at the same time when cfapplication loads and will time out simultaneously, or real close to it. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ORDER BY?
order by the aggregate function. cfquery name="GetTotalPts" datasource="?" dbtype="ODBC" SELECT ContestantID, SUM (AdjPoints) as TOTALPTS, SUM (MoneyEarned) as TOTALMONEY FROM ResultsManager GROUP BY ContestantID ORDER BY SUM(AdjPoints) /cfquery chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:00 PM To: CF-Talk Subject: ORDER BY? im having trouble getting this query to order the results the way that i want it to... OR am i going about this the wrong way? i want it to total the points for each contestant and then output them in a page listed first through whatever it outputs them fine w/o the order by but it orders them by ContestantID, i need it go order by the amount of total points that the query comes up with. it should be: contestant 2 500 contestant 3 485 contestant 1 355 ect but instead its contestant 1 355 contestant 2 500 contestant 3 485 ect.. can anyone help me with this? here is my query: !--- cfquery name="GetTotalPts" datasource="?" dbtype="ODBC" SELECT ContestantID, SUM (AdjPoints) as TOTALPTS, SUM (MoneyEarned) as TOTALMONEY FROM ResultsManager GROUP BY ContestantID ORDER BY ??? --- CANT FIGURE OUT WHAT TO PUT HERE IVE TRIED TOTALPTS but it says its not a valid field in the table... so im at a loss now. /cfquery -- Thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: trim a string variable
i was actually going to suggest this. the only problem is if the file name is something like filename.old.cfm or something like that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 3:42 PM To: CF-Talk Subject: RE: trim a string variable Look at the List functions within ColdFusion - they are extremely useful. In your example, you could say cfset newfilename = ListFirst(File.ServerFile,".") Note that you don't need the # signs inside the CFSET tag. Bob -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: February 7, 2001 1:56 PM To: CF-Talk Subject: trim a string variable Is there a way to trim a string like : file.jpg to : file (aka knock off the last 4 characters) cfset newfilename = #left(File.ServerFile,4)# Does not work because the name of the file in the database could be longer then 4 characters Is there a function that im missing to trim off the last 4 characters of a variable? Thanks Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Displaying the IP of a server
CGI.REMOTE_ADDR will give you the IP of the client computer, if their browser supports it. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:09 PM To: CF-Talk Subject: RE: Displaying the IP of a server CGI.REMOTE_ADDR Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 4:19 AM To: CF-Talk Subject: Displaying the IP of a server Can't find the answer to this probably oh-so-easy question... What variable holds the IP address of a server? Turned debugging and there's no cgi variable that displays it... only server name which is the URL part after http://. Thanks -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLOCK question
AAMOF, the scope attribute was added in 4.5. you have to use "NAME" in 4.0. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: JB Mentzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:25 AM To: CF-Talk Subject: CFLOCK question Hi all I'm attempting to execute this: cflock scope="APPLICATION" timeout="30" type="EXCLUSIVE" On CF Server 4.0. This is the error I'm getting: Just in time compilation error An unknown attribute 'scope' has been encountered at document position (35:10) to (35:14) while processing tag CFLOCK. This tag can only take the following attributes: NAME THROWONTIMEOUT TIMEOUT TYPE I removed the attribute and the error goes away. Any chance that CF Server 4.0 doesn't support the scope attribute? Thanks! * John * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Syntax error....
you have your ids as text fields when inserting the values. my first thought would be to remove them. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 5:05 PM To: CF-Talk Subject: Syntax error Can anyone tell me what is wrong with this insert statement? Ive been looking at this for about an hour now and cant figure it out I get the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, Time, Points, AdjPoints, Money) VALUES ( '1', '2', '7', '1', '0', '50', '125', '5000')" Data Source = "??" !-- cfquery name="PutResults" datasource="?" dbtype="ODBC" INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, Time, Points, AdjPoints, Money) VALUES ( '#RodeoID#', '#EventID#', '#ContestantID#', '#Place#', '#Time#', '#Points#', '#AdjPoints#', '#Money#') /cfquery -- Thanks, Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Break in attempts?
actually, ran into that error message when i named one of my templated MemberApplication.cfm. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:37 PM To: CF-Talk Subject: Break in attempts? We've noticed the following error in our logs recurring recently: "Error","TID=618","02/02/01","22:04:23","24.114.162.188","","Invalid Request of CFDOCS\EXAMPLEAPP\EMAIL\APPLICATION.CFM File You have requested a template with the name APPLICATION.CFM or ONREQUESTEND.CFM. These file names are reserved by the ColdFusion engine for the specification of application level settings and therefore cannot be directly requested from a web client.If you are creating a template which is intended for direct access by end users you should use a name other than APPLICATION.CFM or ONREQUESTEND.CFM." I remember reading about the above applications allowing hackers to change data sources and such. Does anybody have any more information? Or perhaps some remedies? Cheers, Jon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: why use 3rd dimensional array??? You dont understand!
take something like a body of information with multiple levels of organization. for example, when i was working for the DOD, i had an installation. this had major commands associated with it. these macoms had people assocated with them. inefficiently, you might index the data so the installation hashes into the first dimension, the macom the second, and the person in the third. i don't think that a nasty tone is necessary for clarification. i imagine if you asked your clarification question a bit more politely, you might have gotten more answers. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:55 PM To: CF-Talk Subject: why use 3rd dimensional array??? You dont understand! BAH! This is what i mean. What are the PRACTICAL real life uses for 3rd dimensional arrays? ANALOGY if u still dont understand. In trig, we learned how to figure out volume using the shell, disc, and i forget the other one. Ok, big deal. however, the practical use of this is to measure the volume of a hill and figure out how much of it you're gonna chop off so u can biuld a house on it blah blah blah. I understand how 3 dimensional arrays work programmatically. but i wanna know the practical uses of it -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:57 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? Since when was math stuff not a real situation - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 1:36 PM Subject: RE: why use 3rd dimensional array??? well yeah i can see how it can be used for math stuff. but i mean like a real situation -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 1:17 PM To: CF-Talk Subject: Re: why use 3rd dimensional array??? to hold 3 dimensional data. sorry. Simple example. some kind of cubic sample. like say air temperature in a room for each specific cubic foot. The index is h,w,l and the value corresponds to the appropriate cube in the room. I can get a better, more practival example if you like. E From: Phoeun Pha [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: why use 3rd dimensional array??? Date: Mon, 05 Feb 2001 12:35:38 -0600 how would one use a third dimensional array? it's hard for me to conceptualize a practical use for it! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Question about CFFILE permissions
you could implement Advanced Security and create a "sandbox" for each user. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:17 PM To: CF-Talk Subject: Question about CFFILE permissions Good morning people. I was thinking about Self Serve hosting today when I got to wondering, how to people who do run serve hosting businesses (aka Virtualscape, Fusionfx, etc.) prohibit others from using, say CFFILE and CFDIRECTORY on other User's directories? That could get very messy when people are hacking into other people's stuff on that same server, any ideas? Gregory Harris Web Developer The Stirling Bridge Group, LLC *We Engineer Internet Business Solutions* TEL: (949) 707-1534 FAX: (949) 707-1535 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query problem
actually, you WANT a cartesian product for this, since you want every row in members compared to every row in details. that means no join. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 3:24 PM To: CF-Talk Subject: Re: Query problem Will, Are you using access? ID is a reserved word, I think. So, number one would be to change the name of your field in the table. Also, is ID in members the same as id in fields? If so, you can do something like this: SELECTm.email, m.id FROMmembers m, main_details d WHERE(d.body LIKE '%m.watch1%' ORd.body LIKE '%m.watch2%' ORd.body LIKE '%m.watch3%') ANDd.id = m.id Make sense? Makes perfect sense, and thanks to Eric too - the only problem is d.id and m.id are entirely seperate and can't be joined. I see now that I need to join the tables - what is the thing to do, however, when there aren't any "joinable" fields? Thanks for the help, Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: session application variable
really? i took the fast track and thought it was pretty good. i had tought myself much of what was in it, but it was nice to see why things worked the way they do. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:14 PM To: CF-Talk Subject: RE: session application variable the fast track classes i have heard nothing but bad things about. When i took the Advancaed class it was much better Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorized alterations to this e-mail or attachment to it -Original Message- From: S C [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:02 PM To: CF-Talk Subject: RE: session application variable And taking the Allaire classes. They are so well constructed that they really pack a lot in three days and always get you so far ahead. --- Cameron Childress [EMAIL PROTECTED] wrote: Sounds like you are diving into CF with your eyes closed. You would probably benefit from reading the documentation that comes with it. You can download it at the following location if you don't have a hardcopy. http://www.allaire.com/developer/documentation/ColdFusion.cfm Don't let that stop you from asking questions if you are confused, but it is usually best to RTM (read the manual) first. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 9:36 PM To: CF-Talk Subject: RE: session application variable Session Application Variables are variables that are stored on in SERVER RAM, and hence due to that fact need to belocked using CFLOCK, what you can do with those variables though is to use them to pass persistant data to the client browser. Evaluate() is a command that lets you evaluate the value of a variable you can use this along with SETVARIABLE() its quite handy at times Bill Wheatley Director of Development AEPS INC Allaire ColdFusion Consulting Partner Allaire Certified ColdFusion Developer http://www.aeps.com ICQ: 417645 http://www.aeps2000.com 954-472-6684 X303 IMPORTANT NOTICE: This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No c = Suzanne Capener Allaire Certified ColdFusion Developer Allaire Certified ColdFusion Instructor Infovision Inc. aka - [EMAIL PROTECTED] Looking to certify go to www.cfcertification.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email app!
there's the Crazy Cab Email client example application that comes with Server. check it out. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 4:24 AM To: CF-Talk Subject: Email app! Hi there I was wondering if there is already a free email (web based like yahoo or hotmail) appl that has been written in CF or any other lang like Java etc Bossess need to access their email when away from the office! *** Dusty Tinashe Shoko Web Applications Developer SARDC http://www.sardc.net 13 Bath Rd Belgravia Phone: 738694/5/6 *** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DB Query
so you want a list of proucts and both manufacturers? try a double join. (please note. this assumes that there are always values for both ManID and RealManID. if they are not always populated, make the joins OUTER and you'll be good.) SELECT p.pid, p.columns from products, m1.manname, m2.manname FROM products p, manufacturers m1, manufacturers m2 WHERE p.manid = m1.manid AND p.realmanid = m2.manid chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:24 AM To: CF-Talk Subject: DB Query I have a couple of tables I am working with that do not have very good PK/FKs setup. (Unfortunately this is not my schema and I don't have the luxury of changing it) 1) Manufactures [ManID, ManName, ] 2) Products [PID, ManID, RealManID ] ManID and RealManID map to MID and usually contain differing values. I need (hopefully) in one query to extract both the Real Manufacturer Name and the other Manufacturer Name. Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random letter/number value
there are tags in the developer gallery for this. search for "password". chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:56 AM To: CF-Talk Subject: Random letter/number value Hi, I'd like to produce a random letter/number value for a password field, could be around 8 characters I suppose. Can I get help with this please? Thanks, Peter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Check filesize BEFORE uploading
the entire point of that thread was that there was not a way in CF to do that. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Roger Lim [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 9:57 PM To: CF-Talk Subject: Check filesize BEFORE uploading Hi, I read a mail regarding the subject which said : "ColdFusion has no way of knowing what the file size is BEFORE it reaches the server. The way i've done it is allow the full file to be uploaded, check the file size (CFFILE) and then delete it. Of course, the system will warn the user that the file they uploaded was too big AFTER CF has checked it. It's not a pretty solution, but it's the only one that semi-accomplishes the task." So, is there any way that we can check the filesize BEFORE the file is being uploaded? Please advice, thanks! Roger ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dumb Questions :: About Verity :: Intranets
verity can index queries. look up CFINDEX in the docs. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 8:25 AM To: CF-Talk Subject: Dumb Questions :: About Verity :: Intranets Hello All! this is going to sound dumb. My manager wants only one interface for our search form on our intranet. right now i have tons of separate little DB apps that do the usual. each one has its own search interface, to search its own DB. i mentioned verity to him before i knew what it was, now he want's it in one little tight search form. correct me if i am wrong, but verity will only search text based doc's exct.. not database's? so how would *You* start to tie in 12-20 DB apps all the normal text doc's into one thing. the problem i see is to keep the content relative to the pages it was created for. so how? where to start? thanks for your time... -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Driving Me Nuts
actually, it will default to ascending. you don't need to specify. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Stuart Duncan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 1:53 PM To: CF-Talk Subject: Re: Driving Me Nuts You have to specify the sort order. ORDER BY FormDescrip ASC That's all it is. Caught me on that one once too. Stuart Duncan MaracasMedia Inc. At 10:53 AM 1/30/01 -0600, you wrote: I have a query running fine on my local server, but it won't execute properly on the remote server. It's very simple: cfquery name="GetFormInfo" datasource="#request.dsn#" SELECT FormID, FormName, FormDescrip FROM Forms ORDER BY FormDescrip /cfquery The error: "ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly." Any ideas? This is driving me crazy. Running Access 2000. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists