CFQUERY question
I've got a field in a database that is a list of id numbers. When creating a query how do I say pull all records that have an id of "whatever" in that list? I don't want to use CONTAINS since the id could be "1" and any number with "1" in it could return the record like "142,3,8,76". Any thoughts? Joby Bednar Director of Internet Design iNEOgroup.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: OT: W2K vs. NT
You can get SQL Server 2000 Enterprise with 25 CALs for $3200 at: http://shop.store.yahoo.com/i-market/sqlser20ened.html But, in my opinion, there's no TECHNICAL reason to go SQL2000 rather than SQL7. SQL7 with 10 cals for $1189 at: http://shop.store.yahoo.com/dealsoftware/micsqlser70w1.html 20 more CALs for $899 at: http://shop.store.yahoo.com/dealsoftware/sqlser720cli.html best, paul At 12:38 PM 2/7/01 -0500, you wrote: Howdy all. I'm about to take the plunge and get my SQL 2000 box. As usual, I'm afraid to blow my nose without input from you guys. LOL Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of new stuff to keep 2000 going? Is 2000 stable? I'm doing pretty good with NT sp5 and don't want to bite off more than I can chew. The SQL machine will be for SQL Server only! The only other software I'd install is some defrag stuff and a client for my Retrospect backup. FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. -- 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: HTML/OS
they are obviousely watching this list as several items on the comparison have changed since some of the posts indicating no IIS for CF - that is now a YES - Original Message - From: "Aaron Johnson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 10:26 AM Subject: RE: HTML/OS They didn't mention anything about error handling either... Everyone check out this page! :) http://www.aestiva.com/pages/htmlos/a061497.22.18854561327 AJ -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 3:28 PM To: CF-Talk Subject: Re: HTML/OS I'm not sure, but I think if I click the link below, they will think that I am you. http://www.aestiva.com/pages/htmlos/061497.22.18854561327 Brings up the same page. Probably has something to do with the user tracking. I was amused by the press release, which stated that ColdFusion was windows centric. I'm suspicious of any product that does not adhere to standards. It seems counterproductive to create a custom database, that does not use SQL. I wonder how they keep track of users who leave and come back, since it claims it is fully state persistent, yet doesn't use cookies. dennis baldwin wrote: this all sounds really hokey to me. you can't download a trial, you either view a demo or purchase. then it's all web based, what does that mean? i like how on the comparison page they say Cold Fusion won't run on IIS: http://www.aestiva.com/pages/htmlos/061481.7.18510733152 Dennis Baldwin ZAP Designs www.zapdesigns.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 7:13 AM To: CF-Talk Subject: HTML/OS Anyone know about ColdFusion users being wooed by HTML/OS http://biz.yahoo.com/bw/010205/ca_aestiva.html Sebastian ~~ 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
Browser Question
I have a very simple application. It takes only 2 templates (not counting my application page). It lets the user query a database of about 9500 records of our company's different office locations and addresses. They can choose a report by stock location, city, state, zip code, region, geo code, or all. The result page obviously gives them the result and also offers them the option to download an excel file of the result. (This is not the same page that I had the excel problem with before and still do). Anyway, everything works wonderfully using IE but if I'm using Netscape (4.76) and select the all option it will go to the result page and freeze Netscape. I have to end the task to get out of it. The frustrating thing is that it works with any other of the options. I don't see how the size of the table could be the problem since the same table is being queried for all the options. Can anyone think of something that might be causing this to happen. [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: String Concatenation in CFSCRIPT
If you're concatenating in a loop, you probably want myvariable = myvariable myQuery.Link "?urlvariable=" myQuery.otherquerydata NOT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata That said, string concatenation in loops can be pretty expensive operations: you might want to move the initial formatting into your SQL query as in SELECT link + '?urlvariable=' + otherQueryData AS myvariable just a thought. Michael Caulfield -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 4:03 PM To: CF-Talk Subject: String Concatenation in CFSCRIPT I suppose the subject says it all. How do you perform string concatenation in CFSCRIPT? This isn't working: CFLOOP query="myQuery" CFSCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata /CFSCRIPT /CFLOOP I don't have the original code, since I already re-worked it to accomplish what I wanted, but I was curious to know for the future. I also tried to use the Insert function, and that also seemed to have no effect. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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
cfset newfilename = #left(File.ServerFile,(len(File.ServerFile)-4)# This will take the length of the string, subtract 4 from the length, use that for the left function. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:56 AM 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: CF Query Column Order - Random?
There's a tag on the developer's exchange called CFX_QueryColumns, that returns the List of Columns in the same order as that returned by the database. This may help you do what you want. Bob -Original Message- From: Scott Becker [mailto:[EMAIL PROTECTED]] Sent: February 7, 2001 12:53 PM To: CF-Talk Subject: CF Query Column Order - Random? When you make a CFQUERY, the variable queryName.columnList variable returns a list of field names from the query. However, this order doesn't appear to reflect the order of columns from the SELECT statement, or the table itself. Is there some logic to how its ordered? And, is there a way to access the columns in the order of the SELECT statement? Thanks, Scott ~~ 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: HTML/OS
At 01:26 PM 2/7/01 -0500, you wrote: They didn't mention anything about error handling either... Everyone check out this page! :) http://www.aestiva.com/pages/htmlos/a061497.22.18854561327 Nice. I just about timed out on one of the pages in the site but I got bored and went somewhere else instead. I think we should barrage them with email requesting that they correct their obviously inaccurate press release. Of course, I think that Allaire should also. ~~ 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
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? You could try either ListFirst(File.ServerFile,".") or Left(File.ServerFile,Len(File.ServerFile)-4) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: trim a string variable
The easiest way is probably by using the ListFirst function like this: newName = ListFirst(oldName, ".") jay -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:56 AM 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: harpoon beta
Yes -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 1:57 PM To: CF-Talk Subject: harpoon beta did anyone try out the Harpoon beta yet? (and, which one 2? or 2_250 ? ) ATTN HouseofFussion: Please start a Harpoon mailing list if possible. ~~ 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: String Concatenation in CFSCRIPT
I suppose the subject says it all. How do you perform string concatenation in CFSCRIPT? This isn't working: CFLOOP query="myQuery" CFSCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata /CFSCRIPT /CFLOOP I don't have the original code, since I already re-worked it to accomplish what I wanted, but I was curious to know for the future. I also tried to use the Insert function, and that also seemed to have no effect. Erm, you're already doing string concatonation... that's what the does If you want myVariable to have those strings added onto it... myvariable = myvariable myQuery.Link "?urlvariable=" myQuery.otherquerydata; Also, what you're doing isn't very efficient - you should only use CFScript if you have more than 3 real commands in it Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Wanted: Sr. Developer
Isn't this what the CF-Jobs list is for? CF-ThereAreTooManyLists Maybe, but CF-Talk is for TALKing about CF, while CF-Jobs is for JOBS using CF... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HTML/OS
lsellers wrote: I'm suspicious of any product that does not adhere to standards. It seems counterproductive to create a custom database, that does not use SQL. I wonder how they keep track of users who leave and come back, since it claims it is fully state persistent, yet doesn't use cookies. By ip no doubt. ;- Aww, yes. That would make sense. As I am on a dial-up (and so are many users) I think I would prefer cookies. I'd to lose state every time I sign off. Or have someone else go to the site and enter into my previous state. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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
You can do several things... Using the "." as a list delimiter, you could use listfirst() If you know that the extension will always be 3 characters plus a ".", you can use left(var,val(len(var)-4)) blah blah blah Heath -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 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: ORDER BY?
You need to use a sub select to the order by. Select ID, (Select ID, SUM(amount) from contestant group by ID) from contestant order by summed amount Been a while since I have done something like that but that is the general gist. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 14:00 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
SQL 2000
what features does it have that SQL 7 doesn't? Bug fixes maybe? I mean, is it worth upgrading to considering how much it costs? ~~ 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
Left(var,Len(var)-4) Let's say var = Bahehehe You End up with Bahe Left gives x numbers of characters in var from the left, and Len(var)-4 tells it to get X numbers of character minus 4. that way, u get everything except the last 4 numbers. Bahehehehe!! -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12: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: Wanted: Sr. Developer
I agree.. -- Clint Tredway www.factorxsoftware.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: Custom Tag
causes the following error if you use a comma in amount... An error occurred while evaluating the expression: monthlypayment = round((ammount * rate / (1 - (1 / (1 + rate) ^ payments))) * 100) Error near line 37, column 7. Cannot convert 130,000 to number. Please, check the ColdFusion manual for the allowed conversions between data types The error occurred while processing an element with a general identifier of (CFSET), occupying document position (37:1) to (37:90). Date/Time: 02/07/01 15:36:38 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 206.155.0.2 HTTP Referer: http://www.fusemonkey.com/cf_mortgage_calculator/example1.cfm -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:06 PM To: CF-Talk Subject: OT: Custom Tag Hi everyone, I just finished up an article for the April issue of CFDJ on Custom Tags. The custom tag is for calculating a mortgage payment based on user input. This is version 1.0 so any feedback from you guys for version 2.0 would be great. Download it at: http://www.fusemonkey.com/cf_mortgage_calculator/index.cfm Thanks, Kevin Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.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
left(File.ServerFile,len(File.ServerFile)-4) -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12: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: ORDER BY?
Just use a numeric reference to the column's position in your order by. In your example, if you want to order by the highest total points, just say: ORDER BY 2 because SUM(AdjPoints) is the second column. Bob -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: February 7, 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: W2K vs. NT
If you're only using SP5 (as opposed to SP6) for your web server, then you might be using the various FuseBox URL faking techniques. Those don't work on NT4 SP6 or Win2k. That's not an issue if this is just a SQL box, but do keep that fact in mind... Not true. Our servers running Win2k SP1 work fine with those techniques. The CGI.PATH_INFO works like a charm, however I have herd others say it doesn't work for them. --=@ greg @=-- - Original Message - From: "Zachary Bedell" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 2:19 PM Subject: RE: W2K vs. NT -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of new stuff to keep 2000 going? A little... A lot of the admin stuff is done differently, but you can pick it up pretty quickly. Is 2000 stable? "Like a rock." (Please don't sue me, G.M) I'm doing pretty good with NT sp5 and don't want to bite off more than I can chew. The SQL machine will be for SQL Server only! If you're only using SP5 (as opposed to SP6) for your web server, then you might be using the various FuseBox URL faking techniques. Those don't work on NT4 SP6 or Win2k. That's not an issue if this is just a SQL box, but do keep that fact in mind... The only other software I'd install is some defrag stuff and a client for my Retrospect backup. You won't need to install defrag w/ Win2k -- it comes with it. Tho a SQL only box shouldn't get fragmented -- SQL Server creates big contiguous files works with in them for everything it does. I doubt your drive would get fragmented at all if it's dedicated SQL. On the whole, I'm fairly certain you'll enjoy Win2k. It's performance is stellar for us. We've only got one box left to upgrade, and it's going soon! Best regards, Zac Bedell -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com Comment: Please use PGP! iQA/AwUBOoGfyKvhLS1aWPxeEQIw1gCeP0VxL8lkF5AColTMfxaCd4nOEfwAni4d STbIz6ubFIVd9OVIbp95Cpek =BpC3 -END PGP SIGNATURE- ~~ 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
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: W2K vs. NT
Advanced Server is not really necessary, get the Server version. Adv Server provides very nice load balancing and clustering but other than that, the regular server version has everything you need. Definately dont put Professional on a server though. jon - Original Message - From: "Michael Buffington" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 2:21 PM Subject: RE: W2K vs. NT I've found Win 2K to be very stable. I use it for my workstations, as well as a CF/IIS server and a SQL 7.0 server. I've not yet tried it with SQL 2000. You mentioned that you would be using Win2K soley for SQL, but I always feel it's important to mention that if you're ever planning on web serving with Win2K, that you should install the Win2K advanced version. Win2K Pro only allows 10 connections to IIS at a time, Advanced allows unlimited. It's one of those silly microsoft things where they throw in free software that's crippled depending on the license of the OS you purchase. I wouldn't be suprised if they lose the "scientific" mode of the calculator in future, lower-end releases. ;) FYI, I found SQL 2000 Enterprise for $3952 @ PriceComputing.com with free shipping and no tax if you live outside of Wisconsin. http://computing.price.com/prices.htm?ref=mikeid=-2146569074 Michael Buffington [EMAIL PROTECTED] (714) 556-3890 x222 http://www.price.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 9:39 AM To: CF-Talk Subject: OT: W2K vs. NT Howdy all. I'm about to take the plunge and get my SQL 2000 box. As usual, I'm afraid to blow my nose without input from you guys. LOL Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of new stuff to keep 2000 going? Is 2000 stable? I'm doing pretty good with NT sp5 and don't want to bite off more than I can chew. The SQL machine will be for SQL Server only! The only other software I'd install is some defrag stuff and a client for my Retrospect backup. FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. -- 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: W2K vs. NT
So what's your commision? - Original Message - From: "Michael Buffington" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 2:21 PM Subject: RE: W2K vs. NT I've found Win 2K to be very stable. I use it for my workstations, as well as a CF/IIS server and a SQL 7.0 server. I've not yet tried it with SQL 2000. You mentioned that you would be using Win2K soley for SQL, but I always feel it's important to mention that if you're ever planning on web serving with Win2K, that you should install the Win2K advanced version. Win2K Pro only allows 10 connections to IIS at a time, Advanced allows unlimited. It's one of those silly microsoft things where they throw in free software that's crippled depending on the license of the OS you purchase. I wouldn't be suprised if they lose the "scientific" mode of the calculator in future, lower-end releases. ;) FYI, I found SQL 2000 Enterprise for $3952 @ PriceComputing.com with free shipping and no tax if you live outside of Wisconsin. http://computing.price.com/prices.htm?ref=mikeid=-2146569074 Michael Buffington [EMAIL PROTECTED] (714) 556-3890 x222 http://www.price.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 9:39 AM To: CF-Talk Subject: OT: W2K vs. NT Howdy all. I'm about to take the plunge and get my SQL 2000 box. As usual, I'm afraid to blow my nose without input from you guys. LOL Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of new stuff to keep 2000 going? Is 2000 stable? I'm doing pretty good with NT sp5 and don't want to bite off more than I can chew. The SQL machine will be for SQL Server only! The only other software I'd install is some defrag stuff and a client for my Retrospect backup. FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. -- 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: 'mailto' content
Michael, your code is correct. It is the user's default email program that should interpret the chars and format they accordingly... your code produces this in outlook, being sent to an the blah.cfm email: This is a test. I like testing things. This is the beginning of a paragraph. Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Caulfield, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:06 PM To: CF-Talk Subject: RE: 'mailto' content While 'mailto:' is a psuedo-href, it's still an HTML attribute, and as such it will ignore your return characters. Meaning a href="linkch eck.cfm?line1=1 line2=2"link/a is equivalent to a href="linkcheck.cfm?line1=1line2=2"link/a I don't think there is any way around this. Michael Caulfield Cognitive Arts (847) 425-8529 -Original Message- From: Trace Faber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 11:37 AM To: CF-Talk Subject: 'mailto' content Hi Guys, I'm trying to include body text in a a href="mailto:." tag. Now I get the body text in there but I am having trouble formatting it. For example line breaks. I am probably going about this completely wrong, but below is my code. cfset emailContent = "This is a test."chr(13)chr(10)"I like testing things."chr(13)chr(10)chr(13)chr(10)"This is the beginning of a paragraph." cfset emailContent = URLEncodedFormat(emailContent) cfoutput a href="mailto:blah.cfm?subject=Testbody=#emailContent#"Test/a /cfoutput Any tips would be greatly appreciated. Trace ~~ 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: CFFILE :: Multiple image uploads?
What about asking the user how many images they want to upload with the default of one. If they put in 7, reload the page with a loop for the input box(es) to dynamically generate 7 input boxes. Just a thought... Stephen -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:39 AM To: CF-Talk Subject: RE: CFFILE :: Multiple image uploads? It is CF , and ASP. It is basically a Java program that you can pass params to from CF. At 07:40 AM 2/7/01 -0500, you wrote: that seems to be an asp solution. are there any cf friendly solutions. js, exct. thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Chad Gray [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 5:43 PM To: CF-Talk Subject: RE: CFFILE :: Multiple image uploads? I am currently using AppletFile to upload multiple files. http://www.infomentum.com/activefile/ If is pretty powerful, but be prepared to deal with browser issues. For one MSIE for Mac does not support JAVA so you have redirect those users to a page with a simple input name="FileName" size=30 type=FILE Another is Netscape 4.6 for PC has some sort of bug so you have to re-direct those users also. BUT other then that the program is great! At 03:33 PM 2/6/01 -0500, you wrote: lol. thats exactly what we talked about on the cf-extensions list for Ultra Dev. using Ben's CFX_zip tag. it's a small world af any other ideas? thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq:47658358 -Original Message- From: Aaron Johnson [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 2:59 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: CFFILE :: Multiple image uploads? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Paul, As far as I know, it's only possible to upload one file per browse/File field... however, you could have the user zip up x number of files, upload the zip file and then unzip the .zip serverside, creating x number of pictures... ? Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [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: W2K vs. NT
You're missing a product level here: "Windows 2000 Server" which is approx. $700 vs. $3200 for "Windows 2000 Advanced Server". "Windows 2000 Pro" is the successor to NT Workstation, which also had the same connection limitations when running IIS. Jim - Original Message - From: "Michael Buffington" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 12:21 PM Subject: RE: W2K vs. NT I've found Win 2K to be very stable. I use it for my workstations, as well as a CF/IIS server and a SQL 7.0 server. I've not yet tried it with SQL 2000. You mentioned that you would be using Win2K soley for SQL, but I always feel it's important to mention that if you're ever planning on web serving with Win2K, that you should install the Win2K advanced version. Win2K Pro only allows 10 connections to IIS at a time, Advanced allows unlimited. It's one of those silly microsoft things where they throw in free software that's crippled depending on the license of the OS you purchase. I wouldn't be suprised if they lose the "scientific" mode of the calculator in future, lower-end releases. ;) FYI, I found SQL 2000 Enterprise for $3952 @ PriceComputing.com with free shipping and no tax if you live outside of Wisconsin. http://computing.price.com/prices.htm?ref=mikeid=-2146569074 Michael Buffington [EMAIL PROTECTED] (714) 556-3890 x222 http://www.price.com -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 9:39 AM To: CF-Talk Subject: OT: W2K vs. NT Howdy all. I'm about to take the plunge and get my SQL 2000 box. As usual, I'm afraid to blow my nose without input from you guys. LOL Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of new stuff to keep 2000 going? Is 2000 stable? I'm doing pretty good with NT sp5 and don't want to bite off more than I can chew. The SQL machine will be for SQL Server only! The only other software I'd install is some defrag stuff and a client for my Retrospect backup. FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. -- 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: String Concatenation in CFSCRIPT
Your concatenation is correct. However, you must put a semi-colon at the end of statements, just like in JavaScript. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Jeffry Houser wrote: I suppose the subject says it all. How do you perform string concatenation in CFSCRIPT? This isn't working: CFLOOP query="myQuery" CFSCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata /CFSCRIPT /CFLOOP I don't have the original code, since I already re-worked it to accomplish what I wanted, but I was curious to know for the future. I also tried to use the Insert function, and that also seemed to have no effect. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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
cfset newfilename = #left(File.ServerFile,(LEN(File.ServerFile)-4))# should work, however remember that not all files have just a 3 letter ext. you might want to just use CFSET newfilename = server.serverfilename serverfilename is the file without ext and period... another long way is to grab the ext before moving the file around, then remove LEN(ext)+1 from the right... Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 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: trim a string variable
cfset myString = file.jpg cfset myString = left(myString,len(myString)-4) or something like that should do what you're asking. You might need to adjust the 4 to be a 3 or 5 to account for a one-off error (I'm not near a CF machine at the moment and can't test it). A smarter way would be to parse for the last period and return everything before that. Return everything if there is no period. - Original Message - From: "Chad Gray" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 11:55 AM 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: W2K vs. NT
* it's important to mention that if you're ever planning on web serving with * Win2K, that you should install the Win2K advanced version. Win2K Pro only * allows 10 connections to IIS at a time, Advanced allows unlimited. I think that you are confusing Win2k Professional (workstation) with Win2k Server. (Advanced Server is a flavor of Win2K Server with built in clustering and failover as well as support for a larger number of processors). Win2K Server (standard) has unlimited web connections. Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.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: HTML/OS
Sounds something like frontpage2000 the way they describe it, mite be good, but I DOUBT IT. [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... There's glib, glad-handing, sales hype, and there's product knowledge. The two don't necessarily go together. --John "Dave Hannum" hannum@ohio.To: CF-Talk [EMAIL PROTECTED] edu cc: Subject: Re: HTML/OS 02/07/2001 11:43 AM Please respond to cf-talk They also say it won't run on Netscape Enterprise. Funny, I guess I've been just imagining that it runs on Enterprise like we have here. . . . . Also they must not know about Session and Application scope variables . . .. Dave - Original Message - From: "dennis baldwin" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 10:44 AM Subject: RE: HTML/OS this all sounds really hokey to me. you can't download a trial, you either view a demo or purchase. then it's all web based, what does that mean? i like how on the comparison page they say Cold Fusion won't run on IIS: http://www.aestiva.com/pages/htmlos/061481.7.18510733152 Dennis Baldwin ZAP Designs www.zapdesigns.com -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 7:13 AM To: CF-Talk Subject: HTML/OS Anyone know about ColdFusion users being wooed by HTML/OS http://biz.yahoo.com/bw/010205/ca_aestiva.html Sebastian ~~ 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
correction, line 3: CFSET newfilename = server.serverfilename should read CFSET newfilename = file.serverfilename sry... Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader ~~ 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: Custom Tag
Tried downloading your custom tag and got NOTHING "Kevin Schmidt" [EMAIL PROTECTED] wrote in message news:012701c09141$595e54f0$9621a098@win2kserver... Hi everyone, I just finished up an article for the April issue of CFDJ on Custom Tags. The custom tag is for calculating a mortgage payment based on user input. This is version 1.0 so any feedback from you guys for version 2.0 would be great. Download it at: http://www.fusemonkey.com/cf_mortgage_calculator/index.cfm Thanks, Kevin Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.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
If you think of your string "file.jpg" as a list made up of two strings "file" and "jpg" delimited by the period, you can do this: cfset filename = ListFirst(file.jpg, ".") cfoutput#filename#/cfoutput == will give you "file" HTH, 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 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12: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: HTML/OS
They also say it won't run on Netscape Enterprise. Funny, I guess I've been just imagining that it runs on Enterprise like we have here. . . . . Also they must not know about Session and Application scope variables . . . It now says it runs on IIS, but not Netscape yet... The other thing that annoys slightly is that it's "ColdFusion" and not "Cold Fusion" Research is a wonderful thing g Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Printing from CF Output page
I have a number of small apps that are basically queries, with results pages showing a table tailored to the user's circumstances. I want the users to be able to print the page from their browsers. IE users ... no problem. They just hit the print button and get a paper version of what they see on the screen. NN users, not so. Instead they get a page that says "Data missing .. This document resulted from a POST operation and has expired from the cache ... " I can't really turn caching on, or the users won't see a new version of the page when they change their parameters. How do you people handle this issue? Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia ~~ 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
CFSLIDER
Hi, Anybody had any trouble with CFSLIDER? I used it here in a Web page, and it seems like machines w/o CF installed don't automatically dl the Java applet (machines with CF installed already have the applet installed I think). One thing I wonder is the CODEBASE="/CFIDE/classes/" in the final HTML. Shouldn't there be a full Web address there? How do I change this, given that CODEBASE isn't part of the CFSLIDER tag??? Take a look: http://www.rmf.org.nz/colorpicker/ Regards, Matthew Walker !--- E l e c t r i c S h e e p W e b Innovative Web Applications Tel: +64-3-374 2137 Mobile.: +64-25-605 5747 Fax: +64-3-377 7930 Web: http://www.electricsheep.co.nz/ Post...: P O Box 13-907, Armagh Christchurch, New Zealand Street.: 71 Durham Street Christchurch, New Zealand --- ~~ 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
CFSLIDER
Hi, Anybody had any trouble with CFSLIDER? I used it here in a Web page, and it seems like machines w/o CF installed don't automatically dl the Java applet (machines with CF installed already have the applet installed I think). One thing I wonder is the CODEBASE="/CFIDE/classes/" in the final HTML. Shouldn't there be a full Web address there? How do I change this, given that CODEBASE isn't part of the CFSLIDER tag??? Take a look: http://www.rmf.org.nz/colorpicker/ Regards, Matthew Walker !--- E l e c t r i c S h e e p W e b Innovative Web Applications Tel: +64-3-374 2137 Mobile.: +64-25-605 5747 Fax: +64-3-377 7930 Web: http://www.electricsheep.co.nz/ Post...: P O Box 13-907, Armagh Christchurch, New Zealand Street.: 71 Durham Street Christchurch, New Zealand --- ~~ 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
SQLOLEDB questions
I set up the sqlledb in the cf administration sucessfully and I tried to write the CFQuery and CFSTOREDPROC, but some how it doesn't work, when i load up the page, it takes forever, if someone have any examples codes so i can follow 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: 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: W2K vs. NT
On 2/7/01, Greg Wolfinger penned: I have found that Win2k is a lot more stable. Migrating is a bad ideabut any new servers that are using the Wintel solution should run Win2k OK, great. FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. Buy.com $4,500 at buy.com. -- 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: W2K vs. NT
On 2/7/01, Zachary Bedell penned: If you're only using SP5 (as opposed to SP6) for your web server, then you might be using the various FuseBox URL faking techniques. Those don't work on NT4 SP6 or Win2k. That's not an issue if this is just a SQL box, but do keep that fact in mind... I had problems with my sites on Intermedia when they went to SP6. So did they obviously, because they ended up reinstalling Windows and SP5 soon afterward. When I bought my server I requested they install SP5 and it's treated my well. -- 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
Removing the documentation and sample applications
WRT security, does anyone know off the top of their head what files need deleting (and any other changes that might need making) in order to remove the sample applications and documentation if they were selected when installing ColdFusion on a server? 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: ascf.dll
ASCF.DLL is for ASAPI, primarily Apache. There are many of these DLL's for different web server protocols. 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: W2K vs. NT
Look out - we've got a runaway!! I've received this message 8 times so far . . . . (along with a bunch of others . . . ) - Original Message - From: "Greg Wolfinger" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 2:17 PM Subject: Re: W2K vs. NT I have found that Win2k is a lot more stable. Migrating is a bad ideabut any new servers that are using the Wintel solution should run Win2k FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. Buy.com --=@ greg @=-- - Original Message - From: "Bud" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 12:38 PM Subject: OT: W2K vs. NT Howdy all. I'm about to take the plunge and get my SQL 2000 box. As usual, I'm afraid to blow my nose without input from you guys. LOL Any advantages/disadvantages with NT 4 vs. Win 2000? Please consider I'm a novice when it come to Windows. I've learned enough NT to keep my CF/Web server knocking_woodrunning almost constantly/knocking_wood. Will I have to learn a bunch of new stuff to keep 2000 going? Is 2000 stable? I'm doing pretty good with NT sp5 and don't want to bite off more than I can chew. The SQL machine will be for SQL Server only! The only other software I'd install is some defrag stuff and a client for my Retrospect backup. FYI. I signed up for a biz account with PC Connection and they're going to sell me SQL 2000 with a single Processor license for 4K on the nose. Beats the next best price I could find by 700 bucks. -- 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
HTML/OS (Persistant State Management *WITH* cookies?
Despite their claims, HTML/OS apparently does not use persistent state management w/o cookies. Or maybe they use a different version of persistent. [snip] Enter your login ID and password to obtain access to HTML/OS support services. If you selected the auto login option then upon logging in for the first time Aestiva will place a cookie on your computer so the next time you access the Aestiva Web site, you will automatically be logged in. [endsnip] -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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: W2K vs. NT
If you're only using SP5 (as opposed to SP6) for your web server, then you might be using the various FuseBox URL faking techniques. Those don't work on NT4 SP6 or Win2k. That's not an issue if this is just a SQL box, but do keep that fact in mind... Is there a way of making that technique work? I.e. can you make IIS evaluate URL from left to right instead of from right to left as its seems to be doing? Michel Vuijlsteke Netpoint NV ~~ 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
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
Installing Advanced Security on NT4
Can you subsequently install Advanced Security on an NT4 CF 4.0.1 box if it wasn't selected during the original installation? 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: Stored Procedure speed curiosity
I had always presumed that a Stored Procedure ran faster than a SQL query... the problem is that when I actually run speed tests, it's about the same speed... did you try running the sp w/cfquery? in any case, the sp will get faster in the long run. And NOT R.RequestId In (Select distinct t.RequestId From TaskEffort as te, task as t where Te.taskid=t.task) order by r.DateEntered this is a bear. have you tried NOT EXISTS instead? There are indexes in place where I can, but it's just damn confusing why the SP runs slower than the SQL... have you let the index wizard at this? got a clustered index? ~~ 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: Btrieve conversion
Eron, Here is some info I found from an Access listserv. It's not much, but maybe it can get you started. "I did a web search using ODBC and btrieve and got many hits, including Pervasive, SW-Tools, SWSoft and others. Try Lycos, or yahoo, or...whatever your favorite search engine is." AND Check out Data Junction. It converts a large number of files to other file types including Btrieve to Access. If your files aren't actually Btrieve, Data Junction can help find out what type of files they actually are and convert them. http://www.datajunction.com/ HTH, Lynn -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: February 07, 2001 11:53 AM To: CF-Talk Subject: OT: Btrieve conversion Hi Folks, I was given some data files that I don't know how to convert. I think they are from Btrieve (and they end in .B) Does anyone know of a conversion program for Btrieve (preferably free :-) ). I have no experience with this format whatsoever. I'd like to get an Excel or MS Access file out of it. Eron ~~ 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: Parsing HTML in ColdFusion
usage may vary. -Alex -Original Message- From: Caulfield, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:44 PM To: CF-Talk Subject: RE: Parsing HTML in ColdFusion Note that it can get a little more complicated, depending on what level of accuracy you want. For instance: a href="MyPageWithAWeirdCharacterInIt.htm"/a would get stripped wrong. As would: !-- if r 1 then don't execute this next bit -- For the majority of documents, this is not much of a problem, but if you are stripping for security reasons, or if you need absolute accuracy, then you might need a more finely tuned process. Michael Caulfield -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:29 AM To: CF-Talk Subject: RE: Parsing HTML in ColdFusion you need a regex that matches everything between and minus the ones you want to keep like br or b. how bout: rereplace(#my_html_file#, '{1}[A-Za-z0-9_/]*{1}', '', 'all') this should be : match '' once followed by any alphanumeric char until you hit a '' once and replace it with ''. this is an explanation of regex features in javascript as implemented by netscape (you could parse text given to you in a form through javascript before cf even sees it): http://developer.netscape.com/docs/manuals/js/client/jsref/regexp.htm but you need to get the exact syntax that allaire parses. mike dinowitz did a great right up on this very subject and i think it is chapter 12 of ben fortas green book, not to mention his web sites. if you can try doing this in perl before hand, i am sure it is speedier then cf in this area. good luck, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia Presbyterian Medical Center 212.305.1318 [EMAIL PROTECTED] -Original Message- From: Randy Pringle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 1:43 AM To: CF-Talk Subject: Parsing HTML in ColdFusion We need to parse an HTML page, and remove all HTML tags. Could someone please explain how to do this in ColdFusion? There is a component in ASP that allows this sort of thing, but we prefer to do it ColdFusion. Any help would be greatly appreciated. Randy Pringle Khalifa Al-Kuwari RasGas Doha Qatar ~~ 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
OT: repeating maling list messages
am i the only one or do the mailing list message keep repeating?? is there anything wrong with the mailing list? why i keep getting the same messages? mak wl ~~ 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
OT: Mutiple CFTalk messages
I'm getting multiple copies of postings today. Is it just me? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: OT: W2K vs. NT
But, in my opinion, there's no TECHNICAL reason to go SQL2000 rather than SQL7. SQL7 with 10 cals for $1189 at: price aside, sql2000 does have these which i find interesting : - user defined functions - indexed views - xml support (includes nifty metadata stuff) - named log marks (can restore partial db, to a point in time, etc.) - bigint ("infinite" identity values), table sql variant datatypes - full text search (many cool new options general improvements!!) - kerberos security - text in row (instead of on seperate page) - 20-40% speed improvement plus its getting tougher tougher to buy sql server 7 around here... ~~ 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: HTML/OS - WRRONG
Big Brother is watching... It did not say that this morning. I swear it. Phoeun Pha wrote: Funny, i just looked at that site and it does say that CF run on IIS -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 11:41 AM To: CF-Talk Subject: RE: HTML/OS this all sounds really hokey to me. you can't download a trial, you either view a demo or purchase. then it's all web based, what does that mean? i like how on the comparison page they say Cold Fusion won't run on IIS: http://www.aestiva.com/pages/htmlos/061481.7.18510733152 They obviously haven't looked into the "rival" software Database Function - No for CF Array Processing - No for CF Run on IIS - No for CF Run on Netscape Ent - No for CF (I'm sure it does, but not 100%) Also; BASIC-like ease-of-use - No for ASP - isn't ASP based on Visual Basic? Then they forgot; Incredibly biased comparison? - Yes for Aestiva Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: trim a string variable
cfset newfilename = #mid(File.ServerFile,1, len(File.ServerFile)-4)# This just truncates the last 4 characters off the end, obviously won't work if the extension is longer than 3 characters. Robert --- In the real world as in dreams nothing is quite what it seems. - Dean R. Koontz, The Book of Counted Sorrows - Original Message - From: "Chad Gray" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 1:55 PM 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: Another alternative to CF
Check out www.tagfusion.com. This is a servlet engine that uses CF tags. Kinda cool... I guess... It's been done before. Before Allaire purchased Live Software, the original makers of JRun, that product had an add-on called CF_ANYWHERE, which would allow you to run CFML 2.0 code on JRun - CFML scripts would be compiled as servlets. 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: Attn HouseofFussion
The "official" Harpoon mailing list is now available at http://chattyfig.figleaf.com -S -Original Message- From: Steve Drucker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:22 PM To: CF-Talk Subject: RE: Attn HouseofFussion The "official" Harpoon mailing list will be run through Fig Leaf Software (creator of the tools). This will be available shortly through the following URL: http://chattyfig.figleaf.com -S -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12:37 PM To: CF-Talk Subject: RE: Attn HouseofFussion ditto -Original Message- From: Doug Powell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 11:26 AM To: CF-Talk Subject: RE: Attn HouseofFussion I would second that! -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:08 AM To: CF-Talk Subject: Attn HouseofFussion ATTN HouseofFussion: Please start a Harpoon mailing list if possible. Thanks, 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
CFSLIDER
Hi, Anybody had any trouble with CFSLIDER? I used it here in a Web page, and it seems like machines w/o CF installed don't automatically dl the Java applet (machines with CF installed already have the applet installed I think). One thing I wonder is the CODEBASE="/CFIDE/classes/" in the final HTML. Shouldn't there be a full Web address there? How do I change this, given that CODEBASE isn't part of the CFSLIDER tag??? Take a look: http://www.rmf.org.nz/colorpicker/ Regards, Matthew Walker !--- E l e c t r i c S h e e p W e b Innovative Web Applications Tel: +64-3-374 2137 Mobile.: +64-25-605 5747 Fax: +64-3-377 7930 Web: http://www.electricsheep.co.nz/ Post...: P O Box 13-907, Armagh Christchurch, New Zealand Street.: 71 Durham Street Christchurch, New Zealand --- ~~ 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: CFQUERY question
Try the CF functions ListContains or ListFind. We dealt with the very same issue and used one of these two to solve it, but I don't remember which. This works as long as your database field is exactly a CF list format. Brian -Original Message- From: Joby Bednar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 3:13 PM To: CF-Talk Subject: CFQUERY question I've got a field in a database that is a list of id numbers. When creating a query how do I say pull all records that have an id of "whatever" in that list? I don't want to use CONTAINS since the id could be "1" and any number with "1" in it could return the record like "142,3,8,76". Any thoughts? Joby Bednar Director of Internet Design iNEOgroup.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: Session timeout question
session timeout refers to a session as a whole and not the individual components. all session scope variables will be cleared for that session when the timeout limit is hit after the last time the user had used the site during that specific session. hope that made sense. Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:43 PM To: CF-Talk Subject: Session timeout question Does the session timeout apply to all session variables at the same time, or since they were last used? lemme be a lil' more clear I have session.hello and session.goodbye, and they are both active for now. but then I stop using session.goodbye for a while, but at the same time, I am continuously using session.hello. Will session.goodbye timeout? and if it does time out, will session.hello timeout too (i doubt that, but I'm paranoid)? 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? ~~ 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: Parsing HTML in ColdFusion
im jumping into the middle of this conversation, so please forgive if i am off topic... seems to me this is exactly what i just somewhat-finished working on last night, so i will paste the part of the code that you are interested in this code is being used to pull data from a status page with alot of numbers and stuff in it CFSET parsed_input = TRIM(attributes.status_html) CFSET parsed_input = LCASE(parsed_input) CFSET parsed_input = REPLACE(parsed_input, "br", " ", "ALL") CFLOOP CONDITION="#FIND("", parsed_input)# NEQ 0" CFSET leftBr = FIND("", parsed_input) CFSET rightBr = FIND("", parsed_input) CFSET parsed_input = REMOVECHARS(parsed_input, leftBr, rightBr-leftBr+1) /CFLOOP Now, line 3 is there because when I have lines like this: 4BR3050BR if you just remove the BR they get bunched together: 43050 and i cant tell where the numbers should be seperated, so replacing the BR with a " " (\s) will do: 4 3050 If you needed to check what was inbetween the tags, you could also include a check variable useing the MID function, something like MID(parsed_input, leftBr+1, rightBr) should return what is in the ... hope this helps, im still working on my parser, but this is being done for a specific page format vice a general application Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Caulfield, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:44 PM To: CF-Talk Subject: RE: Parsing HTML in ColdFusion Note that it can get a little more complicated, depending on what level of accuracy you want. For instance: a href="MyPageWithAWeirdCharacterInIt.htm"/a would get stripped wrong. As would: !-- if r 1 then don't execute this next bit -- For the majority of documents, this is not much of a problem, but if you are stripping for security reasons, or if you need absolute accuracy, then you might need a more finely tuned process. Michael Caulfield -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:29 AM To: CF-Talk Subject: RE: Parsing HTML in ColdFusion you need a regex that matches everything between and minus the ones you want to keep like br or b. how bout: rereplace(#my_html_file#, '{1}[A-Za-z0-9_/]*{1}', '', 'all') this should be : match '' once followed by any alphanumeric char until you hit a '' once and replace it with ''. this is an explanation of regex features in javascript as implemented by netscape (you could parse text given to you in a form through javascript before cf even sees it): http://developer.netscape.com/docs/manuals/js/client/jsref/regexp.htm but you need to get the exact syntax that allaire parses. mike dinowitz did a great right up on this very subject and i think it is chapter 12 of ben fortas green book, not to mention his web sites. if you can try doing this in perl before hand, i am sure it is speedier then cf in this area. good luck, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia Presbyterian Medical Center 212.305.1318 [EMAIL PROTECTED] -Original Message- From: Randy Pringle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 1:43 AM To: CF-Talk Subject: Parsing HTML in ColdFusion We need to parse an HTML page, and remove all HTML tags. Could someone please explain how to do this in ColdFusion? There is a component in ASP that allows this sort of thing, but we prefer to do it ColdFusion. Any help would be greatly appreciated. Randy Pringle Khalifa Al-Kuwari RasGas Doha Qatar ~~ 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: String Concatenation in CFSCRIPT
:hmm:Semi-colon. I'm pretty sure it was there (I swear it). Typo in the code below. When I outputted the resulting variable it only contained 'myQuery.link', not the other two values. John Anderson wrote: CFLOOP query="myQuery" CFSCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata; /CFSCRIPT /CFLOOP You need the semicolon at the end? other than that looks like it was right? John Anderson http://www.aloha-webdesign.com -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:03 PM To: CF-Talk Subject: String Concatenation in CFSCRIPT I suppose the subject says it all. How do you perform string concatenation in CFSCRIPT? This isn't working: CFLOOP query="myQuery" CFSCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata /CFSCRIPT /CFLOOP I don't have the original code, since I already re-worked it to accomplish what I wanted, but I was curious to know for the future. I also tried to use the Insert function, and that also seemed to have no effect. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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
(Admin) Server explosion
The mail server blew up yesterday afternoon and I've been working on getting it back up without losing anything. Some of you may notice a double message or two and an explosion of mail. This is unavoidable as the system is getting everything out. Sorry for the inconvenience. Michael Dinowitz Publisher: Fusion Authority weekly news alert (www.fusionauthority.com/alert) Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. (www.houseoffusion.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
Regular Expression Help
I have some text, and in this text there may or may not be URLs. Some of these URLs may already be inside of an A HREF tag while others may not. I need a regular expression that will find all the URLs (starting with http:// or www. or email addresses) that are not already inside of HREF tags and make them into valid HREF tags while leaving the URLs already inside a HREF tag alone... Can anybody give some suggestions about this? Joseph E. Sheble [EMAIL PROTECTED] Wizaerd's Realm http://www.wizaerd.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
OT: Mailing List Server Explosion?
Did anyone else just get a huge amount of repeats last night, or do I need to talk to my network admin about our mail server recreating 24 e-mails about 100 times... I walked in this morning and had 233 e-mails from this list... and no dupes from anything else. Hatton Humphrey ~~ 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: String Concatenation in CFSCRIPT
Single quotes... that had to be it. Much thanks. The semi-colon I knew (typo in my code) Much thanks. "Sicular, Alexander" wrote: try this - CFXCRIPT var1 = 'some text'; var2 = 'some more text'; var3 = var1 ' ' var2 ' ' 'yet some more text'; /CFXCRIPT !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" html head titleUntitled/title /head body cfoutput #var1#br #var2#br #var3#br /cfoutput /body /html don't forget the single quotes and semicolon at the end. good luck, Alexander Sicular Technical Director, Information Technology The Neurological Institute of New York Columbia University 212.305.1318 [EMAIL PROTECTED] -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 5:03 PM To: CF-Talk Subject: String Concatenation in CFSCRIPT I suppose the subject says it all. How do you perform string concatenation in CFSCRIPT? This isn't working: CFLOOP query="myQuery" CFXCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata /CFXCRIPT /CFLOOP I don't have the original code, since I already re-worked it to accomplish what I wanted, but I was curious to know for the future. I also tried to use the Insert function, and that also seemed to have no effect. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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
Try cfset filename = "file.jpg" cfset newfilename = spanexcluding(filename,".") -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: 07 February 2001 20:26 To: CF-Talk Subject: RE: trim a string variable Left(var,Len(var)-4) Let's say var = Bahehehe You End up with Bahe Left gives x numbers of characters in var from the left, and Len(var)-4 tells it to get X numbers of character minus 4. that way, u get everything except the last 4 numbers. Bahehehehe!! -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12: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
Date Validation
I want to do check to see if users are entering the date properly in my form. Is this correct? cfif #form.due_date# IS NOT #DateFormat(form.due_date, "mm/dd/")# SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- alert ('Your Date entry is invalid.') location.href='javascript:window.history.back(1)' //-- /SCRIPT cfabort /cfif ~~ 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: HTML/OS - WRRONG
Funny, i just looked at that site and it does say that CF run on IIS Methinks we have a *mole* amongst us then. I looked, it DOES now say it runs on IIS. That was not the way it was yesterday though. Still says it doesn't run on netscape servers. Haven't run on them in a year or so, but I definately know it did for a long time. Oh well... not very relevant in the scheme of things. :) http://www.aestiva.com/pages/htmlos/061017.3.18249683236 --min ~~ 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: Wanted: Sr. Developer
Does that mean we need another list for TALKing about JOBS? Hal Helms == See ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training == -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 3:40 PM To: CF-Talk Subject: RE: Wanted: Sr. Developer Isn't this what the CF-Jobs list is for? CF-ThereAreTooManyLists Maybe, but CF-Talk is for TALKing about CF, while CF-Jobs is for JOBS using CF... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL 2000
what features does it have that SQL 7 doesn't? http://www.microsoft.com/sql/productinfo/whatsnew.htm ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ 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
Getting Access to HARPOON
If you have not been able to access the Harpoon beta through beta.allaire.com, try the following URL instead: http://beta.allaire.com/harpoon Regards, Steve Drucker CEO Fig Leaf Software ~~ 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 2000
Tons of new stuff, udf support expanded, cascading dri, instead of triggers , enterprise manager got a major overhaul...plus many many more! ;-) jon - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 3:44 PM Subject: SQL 2000 what features does it have that SQL 7 doesn't? Bug fixes maybe? I mean, is it worth upgrading to considering how much it costs? ~~ 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: String Concatenation in CFSCRIPT
Philip Arnold - ASP wrote: I suppose the subject says it all. How do you perform string concatenation in CFSCRIPT? This isn't working: CFLOOP query="myQuery" CFSCRIPT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata /CFSCRIPT /CFLOOP I don't have the original code, since I already re-worked it to accomplish what I wanted, but I was curious to know for the future. I also tried to use the Insert function, and that also seemed to have no effect. Erm, you're already doing string concatonation... that's what the does If you want myVariable to have those strings added onto it... myvariable = myvariable myQuery.Link "?urlvariable=" myQuery.otherquerydata; Also, what you're doing isn't very efficient - you should only use CFScript if you have more than 3 real commands in it I think the person who said single quotes, not double quotes, hit the nail on the head, although I haven't tested it yet. My problem was that the string wasn't concatenating. I had about 5-6 statements in the CFSCRIPT. This was a code segment. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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
Try: cfset myFileName = ListFirst(File.ServerFile, '.') This uses a list function, treating the '.' as a delimiter. Jeff Beer Senior Programmer Architect Hydrogen Media, Inc (727) 530-5500 x303 [EMAIL PROTECTED] -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 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: harpoon beta
LOL John McKown, VP Business Services Delaware.Net, Inc. 30 Old Rudnick Lane, Suite 200 Dover, DE 19901 email: [EMAIL PROTECTED] phone: 302-736-5515 fax: 302-736-5945 icq: 1495432 -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 3:41 PM To: CF-Talk Subject: RE: harpoon beta Yes -Original Message- From: John Quarto-vonTivadar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 1:57 PM To: CF-Talk Subject: harpoon beta did anyone try out the Harpoon beta yet? (and, which one 2? or 2_250 ? ) ATTN HouseofFussion: Please start a Harpoon mailing list if possible. ~~ 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: String Concatenation in CFSCRIPT
"Caulfield, Michael" wrote: If you're concatenating in a loop, you probably want myvariable = myvariable myQuery.Link "?urlvariable=" myQuery.otherquerydata NOT myvariable = myQuery.Link "?urlvariable=" myQuery.otherquerydata Actually, the first one was correct. I was creating an array of structures. So the 'myvariable' got put into a structure, and then the structure into the array. (and then it starts again). That said, string concatenation in loops can be pretty expensive operations: you might want to move the initial formatting into your SQL query as in SELECT link + '?urlvariable=' + otherQueryData AS myvariable just a thought. Ooh, I've never seen that before. Pretty neat. You learn something new every day. That's my one, back to bed. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 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 -- I've got the brains, you've got the looks, let's make lots of money ~~ 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: OT: Mailing List Server Explosion?
It happened to me too, but to a lesser degree. Tom At 08:59 AM 2/8/01, you wrote: Did anyone else just get a huge amount of repeats last night, or do I need to talk to my network admin about our mail server recreating 24 e-mails about 100 times... I walked in this morning and had 233 e-mails from this list... and no dupes from anything else. Hatton Humphrey ~~ 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: hardware
APC makes something... I think it's called a Master Switch. It has 8 ports you can switch on/off through a web page interface. Kent Runyan -Original Message- From: Nick Call [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 8:09 AM To: CF-Talk Subject: OT: hardware O.T. warning. I am trying to find a remote power cycling switch that is IP based, not telephony based. Anyone have experience or a good source for these? My application does not permit me to string in a dedicated phone line for the switch, it has to be IP based communication. I have seen them before, but I am not having much luck locating vendors. Thanks in advance. end O.T. Nick [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: Mailing List Server Explosion?
it's not just you. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 6:00 AM To: CF-Talk Subject: OT: Mailing List Server Explosion? Did anyone else just get a huge amount of repeats last night, or do I need to talk to my network admin about our mail server recreating 24 e-mails about 100 times... I walked in this morning and had 233 e-mails from this list... and no dupes from anything else. Hatton Humphrey ~~ 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
Problem with Insert Using Select
I want to insert new records into a table which has MyUUID as its primary key as well as a column, VersionId, which needs to be updated. Each new record should be identical to the old record, except for a new MyUUID and an incremented VersionID. For example, this old record: MyUUID: BT784-PI89 MyName: Smith VersionID: 1 should have its corresponding new record: MyUUID: A622T-U8FF MyName: Smith VersionID: 2 I can't use the query syntax: INSERT into tbl (MyUUID, name, VersionID) SELECT MyUUID, name, VersionID FROM tbl WHERE MYUUID = '#form.MyUUID#' because that would be overwriting (making non-unique) the UUID, not to mention the version number. Is there a way to do the insert with the Select as well as a dynamically generated uuid? In other words, to simultaneously use the select for given columns (MyName) and passed-in values for other columns(MyUUID, VersionID). I need this to work with CF4.5; any ideas? Thanks ahead of time, Andrew Kopelman ~~ 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: [Regular Expression Help]
first strip out all the href tags then add href tags to all URLS Joe Sheble aka Wizaerd [EMAIL PROTECTED] wrote: I have some text, and in this text there may or may not be URLs. Some of these URLs may already be inside of an A HREF tag while others may not. I need a regular expression that will find all the URLs (starting with http:// or www. or email addresses) that are not already inside of HREF tags and make them into valid HREF tags while leaving the URLs already inside a HREF tag alone... Can anybody give some suggestions about this? Joseph E. Sheble [EMAIL PROTECTED] ===Wizaerd's Realm http://www.wizaerd.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: Attn HouseofFussion
Steve, I didn't see the list on the page. dave -- Original Message -- From: Steve Drucker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Wed, 07 Feb 2001 17:13:28 -0500 The "official" Harpoon mailing list is now available at http://chattyfig.figleaf.com -S -Original Message- From: Steve Drucker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 2:22 PM To: CF-Talk Subject: RE: Attn HouseofFussion The "official" Harpoon mailing list will be run through Fig Leaf Software (creator of the tools). This will be available shortly through the following URL: http://chattyfig.figleaf.com -S -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 12:37 PM To: CF-Talk Subject: RE: Attn HouseofFussion ditto -Original Message- From: Doug Powell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 11:26 AM To: CF-Talk Subject: RE: Attn HouseofFussion I would second that! -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:08 AM To: CF-Talk Subject: Attn HouseofFussion ATTN HouseofFussion: Please start a Harpoon mailing list if possible. Thanks, 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: HTML/OS (Persistant State Management *WITH* cookies?
All throughout the site they simply track you by an url variable. If you send the url to a friend, all of a sudden your friend now looks like you... if you close your browser and open it back up.. you get a new session... Persistent State Management? Sure, while you keep your browser open. An url variable, which has the danger of being shared by multiple people and which dies when you close your browser? Yes. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [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: Date Validation
Why not use CFFORM and the validation built in? There's a "date" option for that :) - Original Message - From: "James Taavon" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, February 08, 2001 7:39 AM Subject: Date Validation I want to do check to see if users are entering the date properly in my form. Is this correct? cfif #form.due_date# IS NOT #DateFormat(form.due_date, "mm/dd/")# SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript" !-- alert ('Your Date entry is invalid.') location.href='javascript:window.history.back(1)' //-- /SCRIPT cfabort /cfif ~~ 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 Access to HARPOON
any major problems with Harpoon beta? Also I remember seeing a breif explanation as to what it is but can anyone direct me to some more detailed info on it? Specifically what is it? What can it do? etc -chris.alvarado [developer] - VerticalNet -Original Message- From: Steve Drucker [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 9:21 AM To: CF-Talk Subject: Getting Access to HARPOON If you have not been able to access the Harpoon beta through beta.allaire.com, try the following URL instead: http://beta.allaire.com/harpoon Regards, Steve Drucker CEO Fig Leaf Software ~~ 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: Mailing List Server Explosion?
YES!!! AAARRRGGGH!! -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 7:00 AM To: CF-Talk Subject: OT: Mailing List Server Explosion? Did anyone else just get a huge amount of repeats last night, or do I need to talk to my network admin about our mail server recreating 24 e-mails about 100 times... I walked in this morning and had 233 e-mails from this list... and no dupes from anything else. Hatton Humphrey ~~ 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: Attn HouseofFussion
I only see three mailing lists and none specifically say harpoon... Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Steve Drucker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 5:13 PM Subject: RE: Attn HouseofFussion The "official" Harpoon mailing list is now available at http://chattyfig.figleaf.com -S ~~ 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
Stop Query From Caching
I have a page that calculates the shipping method after a person updates their cart. It looks in their shopping cart database table for the ship method, recalculates then redirects to the cart page. The problem is that sometimes the database gets changed, but the query runs off of "old" data. IE it's not making a new query. How can I force a query to use data from a table and not from cache? HELP! _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: repeating maling list messages
are you hitting "REply to All"?? this would send an email back to yourself and the list... that could be one reason... Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:03 AM To: CF-Talk Subject: OT: repeating maling list messages am i the only one or do the mailing list message keep repeating?? is there anything wrong with the mailing list? why i keep getting the same messages? mak wl ~~ 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: Mutiple CFTalk messages
Me too. Dave -Original Message- From: Windle, Kevan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 3:47 AM To: CF-Talk Subject: OT: Mutiple CFTalk messages I'm getting multiple copies of postings today. Is it just me? ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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
Duplicates
Is there something wrong with my account on this list if I keep getting duplicate (well more like quadruplicate) messages? If there's something I'm doing wrong, please let me know so I can fix it. The great thing about the list is that it's so active. But when the messages are sent over and over again, it gets to be unmanagable. Athelene Gieseman [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
list of page queries
Hello, does CF create a list of queries that are run on a page? I am using cf_dump for debugging like this: cfset scopelist = "application,session,form,request,url" cfloop list="#scopelist#" index="i" cf_dump v = #i# /cfloop I would like not to have to add queries to #scopelist# explicitly if I can avoid it. 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
wierd oracle error
We recently went from native drivers to odbc. I currently have a wierd error that is occurring: ODBC Error Code = 37000 (Syntax error or access violation) [Oracle][ODBC][Ora]ORA-01460: unimplemented or unreasonable conversion requested SQL = "ep_upd_Employment" Has anyone seen this before? 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