[OT] disabling embedded slides in Windows Media
Hi folks, and apologies for veering out of CF-Land (but I'm at the 11th hour and about ready to pull my hair out!). What we have is a series of ASF files acting as a mini-presentation. The client encoded them originally for a framed presentation screen... but where the movies are shown now is not a frameset. Therefore, the slides associated with the movie are popping up in a new window... most disconcerting! I'm told we have somehow fixed this in IE, but Netscape still proves to be a problem. What I'm getting at is: Is there a way within our object/embed declarations to force Media Player to discard slide-display events? If you have any suggestions, please let me know, preferably off-list (because I'd feel bad for that much clutter on the list ;) ). Thanks! Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: URGENT: Case Question
Use Compare(). It's case-sensitive. HTH -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Javed Mushtaq [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, January 26, 2001 6:39 PM Subject: URGENT: Case Question Hi all, Please could you tell me how i could verify if a password being posted from another page has the exact same case as the password in the database. Eg password: Orange But if enter orangE it evaluates to being true. Please could you tell me how to determine if the password matches the entry in every way. Yours hopefully ~~ 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
[WAY OT] Media Player/Netscape wackiness
Hi all, and apologies for being so off-topic... but I've got a pretty tight deadline and don't know where else to turn. We have a client that wishes, for some reason, to have an .ASF file embedded on their front page. The current code allows a control-less display in IE, but no matter how much I tweak the EMBED, the Netscape version still shows the start/stop control. Does anyone have experience with Windows Media Player/Netscape interaction (and wouldn't mind helping me)? Thanks in advance, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ 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: DELPHI - where does it fit in the scheme of things?
I remember that Nick Bradbury's original releases of Homesite (before HS was bought by Allaire, which begat CFStudio...) was a Delphi app. It would stand to reason, then, that the current releases at least have some Delphi floating around in them. And wasn't there a known bug with how Delphi handled Z-Order that caused CFStudio/HS that caused it not to "pop forward" on window focus? I recall having a problem with this at the previous job, and I think it was attributed to a Delphi glitch. I can't remember exactly. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Marius Milosav [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 09, 2001 9:00 AM Subject: Re: DELPHI - where does it fit in the scheme of things? Delphi is a client/server RAD development tool, developed by Borland (Inprise or whatever they are called this days). Main competitors are (were) Visual Basic and PowerBuilder. If I'm not mistaken ColdFusion Studio was built using Delphi. form more information go to Borland home page. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Help Desk Demo (VHD) www.scorpiosoft.com/vhd/login.cfm - Original Message - From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 8:50 AM Subject: RE: DELPHI - where does it fit in the scheme of things? For those that are using Delphi, what role does it play in the internet? Is it being used strictly for COM access with CF, or are there hidden web abilities some of us may be unaware of? At 07:45 AM 1/9/01 -0600, you wrote: We use Delphi and CF here. The main reason for that is most of our products have some standard application interfaces as well as web interfaces. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 1:48 AM To: CF-Talk Subject: RE: DELPHI - where does it fit in the scheme of things? What is Delphi? Is it a peer to ASP and ColdFusion or is it more a peer to VisualBasic and used for making COM Objects? Is it any good? Would you other webmasters live with ASP, ColdFusion AND Delphi in your sites? Never used it, but I keep bumping into Delphi shops that also use CF. There's at least a couple of those folks on the mailing list somewhere. Delphi is basically the child of Pascal, like C++ was to C. Think of it as Pascal++. Somewhere between Java and C++ in power/complexity. You can make COM's with it. You can also make CFX's with it. Yes, it's roughly in the same league as VisualBasic, Java and C++. --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: Stripping CRs and LFs
Couldn't you replace all instances of Chr(13) (I think that's right...) with a null? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Bryan Batchelder [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 09, 2001 9:13 AM Subject: Stripping CRs and LFs What is the best way to strip CRs and LFs from a string? StripCR() gets the CRsbut I still have linefeeds (or CR/LF combos...) left in the string. I am doing this as part of cleaning up data from an SQL server to put into a ..CSV file...and well, CSV doesn't handle random CR/LF very well :-) Thanks in advance... --b -- Bryan BatchelderHome:727.547.1322 Web Application Developer Work:813.935.7100 x427 Cell:727.460.6665 -- Company:http://www.connectwise.com Personal:http://pontiphex.stetsonsucks.com PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt -- At the macro level, it may appear that I am doing nothing. But at the cellular level I am really quite busy. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to force CFOUTPUT to display results horizontally
After the output of a record, do this: (assuming that breakpoint = 5) #IIf(queryname.currentrow mod breakpoint,DE(""),DE("br"))# -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Britta Wingenroth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, January 05, 2001 4:36 PM Subject: Re: How to force CFOUTPUT to display results horizontally Hi, I just used this and suddenly realized that, yes! all the images are displaying horizontally from the query output, but unfortunately, they are not breaking at the end of the table, but extending the table way off to the right. Setting the table cells to the appropriate width has no effect. Any way of forcing it to break after, say five records have been output, and then staring the new row? record record record record record record record record record record instead of record record record record record record record record record record Thanks a lot, Britta - Original Message - From: "Britta Wingenroth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Thursday, January 04, 2001 8:24 PM Subject: How to force CFOUTPUT to display results horizontally I would like to display the results of the Cfoutput tag running horizontally, ie. tdimage image image image/td instead of td image image image image /td Is there any way that I can do this? Any help would be greatly appreciated. Britta ~~ 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
preparing for CF certification...
Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Just looking for suggestions. :) Thanks and hope you all had a happy and safe New Year's! Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: preparing for CF certification...
I've done that and scored a Master's Certification from it. Thanks though. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Nick Betts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 02, 2001 10:14 AM Subject: RE: preparing for CF certification... Try looking at www.brainbench.com. They have a free certification exam on there which is good prep. Nick Betts -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: 02 January 2001 15:18 To: CF-Talk Subject: preparing for CF certification... Hi folks. I'm thinking about going for my Allaire CF Certification in the moderately near future. What are some of the things I can do to help prepare? Just looking for suggestions. :) Thanks and hope you all had a happy and safe New Year's! Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Sessions/cookies
CF usually doesn't care about case (except for string comparison functions that aren't of the "NoCase" variety), but if you wanted to fake case-insensitivity just in case, use lcase() on the strings. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 02, 2001 12:29 PM Subject: Re: Sessions/cookies I don't know if you missed my additional comments in the code or not, but just to re-specify, You use CFPARAM to set the default to 'na' and when you check the value (in the else statement) you are checking for 'NA' . Technically, the two values are different. Does anyone know if the CF default is to check cases or not? It's the only other idea I can think of... Michael Ross wrote: Yes thats exactly what it should do. But in the first instance I define the session.user_name as a unique number. so the next time round it will update the table. I know why the query isn't working, it shouldn't be getting the na in the first place. -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 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 Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access. um, access on a Linux box
Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ 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: Access. um, access on a Linux box Redux
Oops. I forgot to add: The two datasources we'd be connecting to are an Access DB and an Oracle DB. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Jamie Keane [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 02, 2001 4:56 PM Subject: Access. um, access on a Linux box Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ 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: Access. um, access on a Linux box
The thing is these are existing datasources, and the admin who's going to be in charge of maintaining the servers has minimal NT experience. He wants to migrate over to Linux where the client was once using NT/Apache. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Ryan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 02, 2001 5:05 PM Subject: Re: Access. um, access on a Linux box At 17:05 1/2/01 -0500, you wrote: Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) You can run MySQL on a Winbox, but their license was worded such that it was not free if you were running on Windows. I don't know if its still that way. You can connect to MSSQL on a winbox from Linux/CF. I have no idea why anyone would *want* their data running on a winbox if they were running everything else on a linux box. MySQL is quick and easy to setup on linux, they could just put their data there. RPS ~~ 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- HTH
Hope This Helps. :-) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Guy J. McDowell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 29, 2000 8:35 AM Subject: OT- HTH Okay, I've seen a million people use HTH in their signatures or sign-offs. I can't figure it out. I guess I'll just have to return my Mensa membership card... Please tell me what it means, I get a headache when I don't know everything! ;0) Yours In Conservation, Guy J. McDowell, Webmaster The Ontario Federation of Anglers Hunters E-mail: [EMAIL PROTECTED] Phone: (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Forfields WDDX
What you could do is convert the formfields to a struct (or a query set, if that suits you) by assigning key values or column values whilst looping over the form.fieldnames list. Then WDDX-ify the resulting dataset and you're good to go. :) I wrote an inhouse custom tag that does the dirty work of converting it to a struct, and I could email it to you if you'd like. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: paul smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 29, 2000 5:15 PM Subject: RE: Forfields WDDX Thanks! I was thinking it would be easier in 4.5 than 4.0.1 I'll have to settle for the 4.0.1 version for now. best, paul At 04:53 PM 12/29/00 -0500, you wrote: In 4.5, you get a structure called "form" that you can do this with: cfwddx action="CFML2WDDX" input="#form#" output="aWDDXpacket" Then you can save that string, aWDDXpacket, as a client variable. Hal Helms == See www.ColdFusionTraining.com for info on "Best Practices with ColdFusion Fusebox" training, Jan 22-25 == -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Friday, December 29, 2000 4:38 PM To: CF-Talk Subject: Forfields WDDX What's a slick way to put all FormFields (name value) into WDDX for placement into a client variable? best, paul ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: how do i delete client vars?
Use DeleteClientVariable. To get a list, use GetClientVariablesList(). -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: S R [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, December 28, 2000 12:50 PM Subject: how do i delete client vars? I know how to delete a session variable using: cfset structdelete(session, "myVariable") it works fine but I tried it with a client variable: cfset structdelete(client, "myVariable") and I got an error. ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Select Distinct problems
What you may wish to do is perform a UNION query and alias each subquery's column to the same name. That's worked for me in the past. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, December 27, 2000 3:05 PM Subject: Re: Select Distinct problems Are these tables related in any way? What the SQL server is doing is returning every distinct row it can make up. Say you have table 1 contains A and B and table 2 conatins 1, 2, and 3. With your query you end up with this A 1 A 2 A 3 B 1 B 2 B 3 As you can see .. all of these are indeed distinct rows, but probably not what you wanted. I'm gusing you want something like this: A B 1 2 3 right? Todd Ashworth - Original Message - From: "W Luke" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, December 27, 2000 2:38 PM Subject: Select Distinct problems | Hi, | | I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am | trying to select 2 columns from 2 different tables, as follows, to obtain x | unique email address from the columns "email" and "email2", part of the | tables "EMAILS" and "EMAILS2" respectively. | | cfquery name="getemails" datasource="emails" | SELECT distinct email,email2 FROM EMAILS,EMAILS2 | /cfquery | | After a lot of crunching from my server, it just timed out, and I needed to | restart CF App server to operate the comp again as it had tied up all the | resources. I suppose I'm using the wrong SQL - could someone explain what I | have to do? | | Cheers | | Will | | | ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
importing session variables?
Hi all, I'm working on a project that requires me to use two different application.cfm templates in separate directories. What we need to do is be able to access some of the session variables from the root directory in its child directory. Is there any way we could import only the session variables that matter to both applications? We'd prefer not to include the parent Application.cfm in the child, since that's just messy. Thanks! Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax ~~ 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: Cool CF site - webos.org
The fact that they don't have the +.htr bug patched. Very interesting. Cheers, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Gena [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 18, 2000 5:41 PM Subject: Re: Cool CF site - webos.org Pardon, do you mean this web site or my message??? Regards - Original Message - From: "Jamie Keane" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 9:20 AM Subject: Re: Cool CF site - webos.org *ROFL* That's the funniest thing I've seen this month! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Gena [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 18, 2000 4:54 PM Subject: Re: Cool CF site - webos.org And what is cool on this site? I found only one thing - it is possible to get all source code from this URL. It is not cool. - Original Message - From: "Eric Fickes" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 8:00 AM Subject: Cool CF site - webos.org Hello all, I was wondering if any of you have seen/used www.webos.org yet? I noticed that it's using CF, so I was hoping that some of you may have an answer to my question. WebOs emulates a desktop, and pops up windows within one large parent window. I would love to do this on my inhouse site for navigation and was wondering if any of you knew how to do this. E ~~ 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: Name are Intranet !!
Sex and food? Well then, I suggest... banana. (I could get worse. Really.) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 15, 2000 9:24 PM Subject: Re: Name are Intranet !! ahh ... sex and food at the same time .. who can beat that? ;) Todd - Original Message - From: "Rif Kiamil" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 4:49 PM Subject: RE: Name are Intranet !! Sell Food to End Users. -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] Sent: 15 December 2000 18:44 To: CF-Talk Subject: Re: Name are Intranet !! Rif: It should be name OUR intranet, not arewhat exactly does your company do? -Greg ~~ 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: CFHeader
HTTP headers are different from META tags in that they are handled completely on-server. CFLOCATION is a front-end for a commonly-used HTTP header, a location redirect. I also use them for setting expiration dates for served documents, to prevent caching. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Michael She [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 18, 2000 10:42 AM Subject: CFHeader Does CF header generate meta tags, or are HTTP responses something different? Thanks. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Cool CF site - webos.org
*ROFL* That's the funniest thing I've seen this month! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Gena [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 18, 2000 4:54 PM Subject: Re: Cool CF site - webos.org And what is cool on this site? I found only one thing - it is possible to get all source code from this URL. It is not cool. - Original Message - From: "Eric Fickes" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 8:00 AM Subject: Cool CF site - webos.org Hello all, I was wondering if any of you have seen/used www.webos.org yet? I noticed that it's using CF, so I was hoping that some of you may have an answer to my question. WebOs emulates a desktop, and pops up windows within one large parent window. I would love to do this on my inhouse site for navigation and was wondering if any of you knew how to do this. E ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: how many milliseconds is too many?
Is there any way you could consolidate the queries, ie find some common ground to perform a join on? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 15, 2000 11:06 AM Subject: Re: how many milliseconds is too many? | However, 3.6 seconds is a lengthy time for a page to be processing. Yes, it is. That's why I was concerned about how much of an impact it would have on the application and the server once users started using it for real. I would hate to lauch the site and then have it die pitifully under normal use and have to go back a do a rewrite. The page pulls data from 6 different tables and performs several loops in the process. Unfortunately, I can't figure out how to make it go any faster. I'm sure a stored procedure would help, but it was all I could do to get it written in CF, heh. Todd Ashworth - Original Message - From: "Greg Wolfinger" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, December 15, 2000 10:21 AM Subject: Re: how many milliseconds is too many? | Todd: | | It all really depends. You can't accurately determine the number of users | until your server will crash. It all depends on what the page is doing and | such. However, 3.6 seconds is a lengthy time for a page to be processing. | | -Greg | - Original Message - | From: "Todd Ashworth" [EMAIL PROTECTED] | To: "CF-Talk" [EMAIL PROTECTED] | Sent: Thursday, December 14, 2000 7:33 PM | Subject: how many milliseconds is too many? | | | Say I have a page that takes about 3,600 ms to process. Does anyone know | how much traffic that page can handle before killing the server .. or at | least until the app becomes unusable? | | Todd Ashworth | | | | | ~~ 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: Alternating TR colors
Initialise your counter to 0. Output your TR, with the IIF statement determining the row colour (like your standard currentrow snippet would do). Set counter equal to counter = 1. Voila! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Ryan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 15, 2000 1:18 PM Subject: Alternating TR colors Lets say I wanted the background color of each row in a table to be different colors. I found this code: COLOR=###IIF(QueryName.currentrecord MOD 2, DE ('E9E7CF'), DE ('FFA768'))# But I'm not looping through a query, I'm just manaully writing table rows, BUT, some of the rows may not always be displayed, so I can't just hardcode the color values, because then you'd have two rows right after each other that are the same color. In perl I would just write a function that increments a counter and returns the new result. Like: COLOR=###IIF(MyIncrementFunc(counter) MOD 2, DE ('E9E7CF'), DE ('FFA768'))# How can I accomplish this in ColdFusion? Thanks, Ryan ~~ 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: IsNumeric Function
You shouldn't need the quotation marks around the parameter passed to IsNumeric(). Try that. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Greg Wolfinger [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 15, 2000 12:28 PM Subject: IsNumeric Function Hey Guys/Gurls: I am trying to do some server side validation for a phone number, but I am running into an odd problem. I split the phone number entry form into three textboxes the first one for area code (ie must be 3 numbers) and then the two parts of the phone number (ie must be 3 numbers and then must be 4 numbers). I check to make sure the length of each textbox is correct and then I try to check if they are numeric, however it will throw an error. My code looks something like this: cfif not IsNumeric("attributes.custPhone1") or not IsNumeric("attributes.custPhone2") or not IsNumeric("attributes.custPhone3") cfset attributes.error = attributes.error "Please enter a valid phone number.br" /cfif The strange part is that when I take out the not IsNumeric() statements for the first two form variables it works fine. Ideas??? -Greg ~~ 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: Detecting if JavaScript is enabled with Cold Fusion
There really isn't a way to determine it with CF, but there is a workaround in HTML. You can use a NoScript block to contain verbiage and/or code in the event of the browser being able to see the JS block but not being able to act on it. There's a custom tag somewhere in the gallery that simplifies the process somewhat. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Jerry Tolentino [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, December 15, 2000 4:56 PM Subject: Detecting if JavaScript is enabled with Cold Fusion Anyone know how to detect if JavaScript is enabled on the client machine using Cold Fusion??? Thanks in advance Jerry ~~ 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: Making changes to a live Database
To complement what Daniel wrote, if you're going to run more than one alter statement, wrap them in a transaction. That way, you can test all you want, and should something screw up down the chain, the DB will revert to its original state. It makes life easy. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Daniel Lancelot [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, December 14, 2000 5:49 AM Subject: RE: Making changes to a live Database I suggest using an ALTER TABLE SQL statement - look up ALTER TABLE in access help (JET SQL) (I always create the statement on my development box - test it does what I want, then run it through a CF page on the live box...) HTH Dan -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: 14 December 2000 10:31 To: CF-Talk Subject: Making changes to a live Database Hi, I have a small change to make to a live database (create a new column in a table) which is in Access. I don't really want to download it and upload it again, as I will undoutedly lose data (or visitors will get an error). So I was wondering what people's experiences are of this kind of situation and how best to handle it. Rgds Will www.localbounty.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: Another debate
It has COM support on NT only. The downside is if you wanted to migrate servers from NT to Unix, you're kinda hosed if you were using COM objects. Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: lsellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, December 14, 2000 2:08 AM Subject: RE: Another debate #2. Extensible into Java/COM/etc #2 and #4 are not available in PHP, nor is formal support available Not that I really know what the hell I'm talking about as far as PHP goes, but I thought php4 had COM support(?). --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: Decrypting
I know there is an encrypt/decrypt CFX on Allaire's DevEx site. Worth a check-out! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kevin Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, December 14, 2000 12:14 PM Subject: Decrypting I know I saw the URL for a site that allows decryption of CF filesanybody got it??? Kevin Schmidt, Web Technology Manager Allaire Certified Cold Fusion 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: cftry cfcatch/cfcatch/cftry
Alternately, you could have a main page that has a cftry/cfcatch block, and include the meat of the page within (a la Fusebox). Worth a shot, neh? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, December 13, 2000 11:37 AM Subject: cftry cfcatch/cfcatch/cftry I just found, disappointingly enough that you can't have a cftry at the top of a document via a CFinclude and the rest in another include at the bottom? Is there a work around. I don't want to use a handler, and I want the same error checking code on every page. Please advise or throw ideas (even bones will do) Thanks, Neil p.s. Running CF 4.51. - Original Message - From: "Hales, John M" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, December 13, 2000 11:17 AM Subject: RE: CFreport and crystal reports I could never get it to work. We just use CF to pass the parameters to Crystal, and the CR Web Server to display the reports. That works well for us. HTH Mike Hales -Original Message- From: Katie Bessiere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:08 AM To: CF-Talk Subject: CFreport and crystal reports has anyone had any luck using CFREPORT with crystal reports 8? i've tried the workaround that Allaire recommends and I still can't get the tag to work. It's very frustrating.. If anyone has any ideas, please let me know.. katie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Another debate
Well, the two are really different critters. It could be said that PHP is more secure since it is open source, therefore flaws can, in theory, be discovered (and hopefully patched) quicker. As for other discussion along the lines of "CF is a better platform because it's easier to write in", it really depends on your style of programming. If you're most comfortable dealing with logical pseudo-extensions to an HTML-style programming system, of course CF is for you. It's tag-based to ease the transition between static HTML and dynamically-generated templates. PHP, OTOH, is very reminiscent of Perl, so if your department is strong in Perl you'll love PHP. The down side of PHP is its fairly non-existant error handling capabilities and lack of DB abstraction. You will have to be familiar with different function sets to use different DBs. If you're a non-programmer, it is a bit trickier to learn, since you'll have to work with creating file pointers and whatnot on occasion. And PHP doesn't include Verity or any other nifty toys, so you're on your own. On the plus side, PHP currently supports user-defined functions, which makes for very structured, elegant code. I haven't tried out PHP's session support, however, so I can't comment on that. Chances are, though, that CF has a better implementation, though, simply because CF has had session support longer. Also, what web server/OS are you running? That's also a big part of the picture, and arguably more important than the application server you're using. Jamie (best tool for the job, et cetera, et cetera) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kelly Shepard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, December 13, 2000 1:04 PM Subject: Another debate The new boss has arrived in my department and of course he wants everyone to switch from the awesome and all mighty cold fusion to PHP. We do need some other strengths in our department for those clients who don't want us to host their application or don't have cf on their server, but, he wants a complete switch. Here is a glimpse into his last email: "It could be argued that both technologies have their strengths and weaknesses. However, in the corporate IT department, CF is usually not an option due to cost and security problems. I realize that changing perceptions and old habits are sometimes difficult, but necessary. Especially in our industry (high-tech). The need to deliberate the issue further is a mute point." Does anyone have any opinions on his security problems comment? It seems that alliare is pretty good about getting patches up - or we have just been lucky and not had any problems. And, would you agree that in the corporate IT department cf is "usually" not an option? Thanks in advance for any input. ~~ 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: Just a stray thought
Yes, I'm interested too. Send it on up! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Andres [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, December 13, 2000 12:13 PM Subject: RE: Just a stray thought Can you send the URL where you read this?? -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:36 AM To: CF-Talk Subject: Just a stray thought Ok, this is meant as no shameless plug but I read on their website: UPS expects to receive 5 million tracking requests on their website per day especially on their peak days (it reads something like that) Your mission: build a Cold Fusion application for UPS that could handle such a beating, how would you do this? Bear in mind: 1) You will have to search through a database of approximately 245 million records (packages delivered) 2) 5 million per day equals 60 per second, transactional integrity has to be TIGHT! 3) Money is no real object (UPS needs this to work some how, but be realistic in terms of "what you get is what you pay for") Who's up for this? Gregory Harris Web Developer Stirling Bridge Group LLC ~~ 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 debate
Above all-out evangelisation, the only thing that could stand up against the IT boss in question is solid facts. Present speed test results, testimonials, and other basically-factual data. Ask him why is it, exactly, that he considers CF a security risk and PHP not one. If the boss is at least somewhat reasonable, he'll at least hear your concerns. If he's completely unresponsive, then it really doesn't reflect well on his ability to manage, does it? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kevin Schmidt [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, December 13, 2000 4:47 PM Subject: Re: Another debate Tell your boss to go out to the garage and use the head puller to pull his head out of his ass. CF is far above PHP in my mind and why would you want to tell all of your developers hey forget what you know and learn this new technology. I could understand if you were all COBOL programmers and wanted to learn something new but CF is a great technology and as I said far superior in my mind. - Original Message - From: "Kevin Schmidt" [EMAIL PROTECTED] To: "Kevin Schmidt" [EMAIL PROTECTED] Sent: Wednesday, December 13, 2000 12:39 PM Subject: Fw: Another debate - Original Message - From: Kelly Shepard [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, December 13, 2000 12:14 PM Subject: Another debate The new boss has arrived in my department and of course he wants everyone to switch from the awesome and all mighty cold fusion to PHP. We do need some other strengths in our department for those clients who don't want us to host their application or don't have cf on their server, but, he wants a complete switch. Here is a glimpse into his last email: "It could be argued that both technologies have their strengths and weaknesses. However, in the corporate IT department, CF is usually not an option due to cost and security problems. I realize that changing perceptions and old habits are sometimes difficult, but necessary. Especially in our industry (high-tech). The need to deliberate the issue further is a mute point." Does anyone have any opinions on his security problems comment? It seems that alliare is pretty good about getting patches up - or we have just been lucky and not had any problems. And, would you agree that in the corporate IT department cf is "usually" not an option? Thanks in advance for any input. ~~ 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: What are the recognized CF variable scopes?
In essence, refering to variables outside the scope of a tag is analogous to using global variables in other languages, something that was frowned upon in the books I read and the courses I took. The proper way, then, would be to explicitly pass all necessary parameters to a tag, and eliminate the uncertainty. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: David Shadovitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, December 12, 2000 10:29 AM Subject: Re: What are the recognized CF variable scopes? Jeff, I'm with you. When I raised this issue in December '99, Dave Watts pointed out that just because you can do something doesn't mean that you should. -David On Wed 06 Dec 2000 Jeffry Houser [EMAIL PROTECTED] wrote: Shouldn't custom tags be coded to be as self-contained as possible? If you need to access values in the custom tag, wouldn't it make more sense to pass them as attributes to the custom tag, as opposed to globally defining them? ~~ 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
error upon verity access
Hi all, I'm having a bit of a problem with a Verity collection (in tandem with Allaire Forums). For some reason I now receive the following error upon accessing it with a CFSEARCH command: Collection failed to open: collection_name (collection_name is not a literal; it's the name of the collection in question.) I've tried to repair the collection through the administrator, which seems to work fine, but doesn't fix the problem. Any other ideas about what to do? Thanks! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax ~~ 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: variables passed en masse - what is the tag?
It's CF_EMBEDFIELDS. I based a form-to-struct tag on its logic. Cool stuff! (I know in 4.5 form is a struct, but we're dealing with 4.0 here) Do a search for "Forta" in the DevEx, and you'll find some nice derivatives of his works. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Daniel Lancelot [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, December 07, 2000 9:13 AM Subject: RE: variables passed en masse - what is the tag? There is a tag, i've used it - its available on allaire tag gallery - I believe its written by Ben Forta - cant remember whatits called... very simple though - loops through #form.formfields# creates an input type = hiidden... for each one... : -Original Message- : From: Walker, Matthew [mailto:[EMAIL PROTECTED]] : Sent: 07 December 2000 03:49 : To: CF-Talk : Subject: RE: variables passed en masse - what is the tag? : : : I remember several replies to a previous question where a : tag was referenced : that gathered all the variables on a form and passed them to : subsequent : pages : what was that tag - I hope I'm not dreaming but it would : help to replace : hidden fields. : : How about something like (needs CFServer 4.5) : : cfloop item="ThisField" collection=#Form# : input type="hidden" name="#ThisField#" : value="#Evaluate("Form.#ThisField#")#" : /cfloop : : : ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: passing cfquery results to another page
Convert the query to a WDDX packet, and store the packet as a hidden form field. I've done it before, and it works pretty well. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: sam sidhom [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, December 07, 2000 9:59 AM Subject: passing cfquery results to another page Can anyone tell me if there is anyway CF will pass the results of a CFQuery to another page without having to requery the database? Thanks, Jennifer Johnson ~~ 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: Slightly OT....HTML question
Egads, that's a big number. What we commonly use for a drill-down is the TwoSelectsRelated tag (or if the data is sufficiently cumbersome, ThreeSelectsRelated). Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, December 05, 2000 8:53 AM Subject: Re: Slightly OTHTML question | Does anyone know if there is a known issue here and if so is there a way | around it? Yes .. strike the client about the head firmly and repeatedly until they understand the foolishness of their ways ;) What in the world would you need 7,000 entries in a single select box? Is there a way you could split that up, or drill down to a more manageable number? Todd Ashworth - Original Message - From: "Andy Ewings" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 7:53 AM Subject: Slightly OTHTML question | I have a form with a select control that loads approx 7000 options into it | (I know this is stupid but it's what the client wants). When I view the | form on a PC it's fine. However on a Mac I see nothing. When I reduce the | number of entries to about 4,500 I can see them on the Mac. | | Does anyone know if there is a known issue here and if so is there a way | around it? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Big companies using CF
I believe www.roomstogo.com is CF-based (and FuseBox-based to boot!). -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, December 05, 2000 8:36 AM Subject: Re: Big companies using CF Autobytel.com You can also look here for a list: http://www.allaire.com/casestudies/index.cfm Todd Ashworth - Original Message - From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 9:18 PM Subject: Big companies using CF | I know this is probably one of those discussions that turn up all the time | on a mailing list such as this, and I apologize for bringing it up. I have | a new IT Director starting at my company in the very near future who's a big | Microsoft fan, and thinks there's nothing better than ASP and/or C# (which I | believe hasn't even been released yet, no?). | | When I told him that CF has been around for a long time, and some really big | companies use it, he doubted it. I told him Amazon.com was using it (was I | right about this?). | | So anyway, I've agreed to compile a list of some of the bigger well known | internet comapnies using it, and would like some assistance. What big time | comapnies are using CF for their pages? ~~ 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: Slightly OT....HTML question
Basically what they do is whip together two or three select boxes that are tied with Javascript. Select a category in Box 1, and the categories linked to your selection show up in Box 2. Change the selection in Box 1 again, and Box 2's contents change to reflect a new category. Spiffy! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Andy Ewings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, December 05, 2000 9:54 AM Subject: RE: Slightly OTHTML question Thanks. I'll have a lok at these tags. Can you give me a brief desription as to what they do? -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 05 December 2000 14:11 To: CF-Talk Subject: Re: Slightly OTHTML question Andrew You can try allocating more memory to the browser on the Mac. A better approach might be to use something like twoSelectsRelated or ThreeSelectsRelated custom tags availab at allaire. At least you could break the unwieldy number of entries into smaller groups. HTH Dick At 12:53 PM + 12/5/00, Andy Ewings wrote: I have a form with a select control that loads approx 7000 options into it (I know this is stupid but it's what the client wants). When I view the form on a PC it's fine. However on a Mac I see nothing. When I reduce the number of entries to about 4,500 I can see them on the Mac. Does anyone know if there is a known issue here and if so is there a way around it? -- Andrew Ewings ~~ 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: deallocate
I know that there's a scope defined for ordinary variables on a page. It's the "variables" scope, right? Anyway, whatever its name is, do you know if it's a struct too? Thanks. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 10:04 AM Subject: RE: deallocate is there any function or method that would allow me to deallocate a variable after its been created and used? There's no explicit way to deallocate variables; typically, you simply wait for their scope to close. However, if the variable is part of a structure, you can delete it from the structure, which should suffice. Many variables, such as Session variables, are stored within structures. 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: deallocate
Are there any issues with using the request scope in lieu of the variable scope? Or is the fact that one's a struct the only difference? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Simon Horwith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 2:03 PM Subject: RE: deallocate Apparently the variables scope is not a struct. Mr. Dave Watts pointed this out to me, after my posting this e-mail. Learn something new everyday, I suppose. The variables scope does hold the local variables on a page, usually. If you want to store your variables in a "local" scope structure, write them to the request scope. ~Simon Simon Horwith Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 11:39 AM To: CF-Talk Subject: RE: deallocate indeed it is... on both counts. ~Simon Simon Horwith Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message----- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 11:15 AM To: CF-Talk Subject: Re: deallocate I know that there's a scope defined for ordinary variables on a page. It's the "variables" scope, right? Anyway, whatever its name is, do you know if it's a struct too? Thanks. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 10:04 AM Subject: RE: deallocate is there any function or method that would allow me to deallocate a variable after its been created and used? There's no explicit way to deallocate variables; typically, you simply wait for their scope to close. However, if the variable is part of a structure, you can delete it from the structure, which should suffice. Many variables, such as Session variables, are stored within structures. 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: ColdFusion for Dummies revision - CF5 features
O! This makes me very happy, and will certainly make the other developers happy as well. We've been lamenting the lack of UDFs for a good while. Thanks for the pointer! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Alex Aguilar [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 1:38 PM Subject: Re: ColdFusion for Dummies revision - CF5 features Taken from CFVault's summary of Allaire DevCon: [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/E l ementPage/2] CF 5.0 will be built on the existing codebase, and released during the first half of 2001. It is NOT part of the Pharaoh initiative, the next generation of Allaire application server platform. Here are some of the CF 5.0 features: a.. User defined functions and functions libraries. b.. Ability to run queries against existing query result sets (CFSQL). c.. Partial page output. d.. Server side graphic engine. - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 7:56 AM Subject: RE: ColdFusion for Dummies revision Ok..did I miss something? Where is the featureset for Coldfusion 5.0 listed? :-) -Gel -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] John: Make sure you include user defined functions because that is the singlemost important (in my opinion) new feature with 5.0. Also, you might want to go over briefly application frameworks like fusebox and any other known ways for newbies to structure CF. Best Regards, ~~ 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: ColdFusion for Dummies revision - CF5 features
Yeah, you could just run another query, but if you already have a query and you want to pull a subset of it, it does save resources to run a subquery off of what you already store. So in responce to your question: "Yeah". -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 3:34 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Todd Ashworth - Original Message - From: "Alex Aguilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summary of Allaire DevCon: | [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/E l | ementPage/2] | | CF 5.0 will be built on the existing codebase, and released during the first | half of 2001. It is NOT part of the Pharaoh initiative, the next generation | of Allaire application server platform. | | Here are some of the CF 5.0 features: | a.. User defined functions and functions libraries. | b.. Ability to run queries against existing query result sets (CFSQL). | c.. Partial page output. | d.. Server side graphic engine. ~~ 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 7.0 Question
Try just DELETE FROM table WHERE conditions You'd have to use UPDATE to delete/mangle individual cell data, so the * in the previous statement is unnecessary. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: ibtoad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, November 30, 2000 2:24 PM Subject: SQL 7.0 Question Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything works great except one statement. cfquery name="get_auctions" datasource="happytoad" DELETE * from auction_records where auction_id='#id#' and userid='#userid#' /cfquery Here is the error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'. Is * not the correct syntax for All is SQL 7.0? 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 ~~ 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_Calendar
Have you taken a look at MultiCalendar? http://www.lafilm.net/multicalendar/ We're using it on one of our big projects, and it's pretty cool. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Wednesday, November 29, 2000 5:35 PM Subject: Re: CF_Calendar I've noticed a lot of people looking for calandars and/or scheduling apps. My company needed a hefty one for a current project. We couldn't find anything that suited our needs so we are having to build our own. It's pretty complex. It takes 6 tables in the database just to schedule an event. It supports almost any type of scheduled event .. including complicated ones that look like this: Class 1 Number of seats 30 Price $35 Location: Building C Age Range - N/A Monday 5-6pm, Wed. 5-6pm, Friday 3-4:15pm From October 1, 2000 to December 31, 2000 Except on Dec. 25 because of a holiday Monday and Weds classes will be taught by Bob and Fridays classes will be taught by Sue. This is just an example though .. it can hold other events besides "classes". It can be used to schedule a single event for a single day, or one that repeates infinately into the future and the past, or even a reacurring event that never falls on the same day, at the same time. Let me tell you what .. setting up the database structure for that was a pain ;) If anyone is interested in a calander/scheduling app with this much flexability, I will see about making it available when it's done. I would like to just toss it out open source so everyone can make fun of my coding, but I don't know if the boss will go for that ... Todd Ashworth - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, November 29, 2000 4:42 PM Subject: RE: CF_Calendar | DOn't get it. It's not really administratableblaablaggg. what i meant | was, the only thing u set on it are the events and dates. thats all. There | are some FREE nifty CF based event /planner calendar on the allaire site, | which have a hugeload of cool stuff you can mess around with ~~ 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 ~~ 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: time in CF
Current date and time? You can use the Now() function to get a date/time object with that. Afterwards, use the DateFormat() and TimeFormat() functions to format the date the way you like. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Jeremy Bunton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, November 27, 2000 3:04 PM Subject: time in CF Hello, I was wondering how to display the time and date in CF. In asp it is %date%. I know there must be an equally easy way of doing it in CF. Jeremy ~~ 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 ~~ 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 CFMAIL
Other than setting the "type=html" param in CFMAIL, you should be set. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: paul smith [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, November 27, 2000 5:09 PM Subject: HTML CFMAIL Do we need to do anything special to send HTML Mail with CFMAIL? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ 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
highlighting strings, with a twist.
Hi all, I know this has been discussed previously, but I've got a question with a little quirk in it. I know there are ways to highlight a string, and basically you REReplace the string with a copy of itself wrapped in a highlighting font tag (or span, or what have you). The problem is this: What if the string contains HTML and the highlighter mangles the HTML output? Is there a smart way for the regexp to do the highlighting but skip over the insides of an HTML tag? In other words, it would be okay to highlight the label portion of an A tag, but not touch the HREF attribute. Any assistance would be very appreciated! And if you know a custom tag that does this, please pass it on my way. Thanks! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Smart renames on images?
Hi folks, I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: Smart renames on images?
What type of error is returned from an unsuccessful upload? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Cameron Childress [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, October 23, 2000 11:35 AM Subject: RE: Smart renames on images? I've got a project that requires that all images that are uploaded are named uniquely. This would usually be a simple case of using the MAKEUNIQUE attribute in CFFILE but the client is picky about the names of the incoming files. Therefore, the original name must be preserved. If the desired filename already exists on the server, I need to let the user know, and rename the file accordingly. What's the easiest and most efficent way to handle this? Do they have to be names correctly on the server, or just when they are downloaded back to the client again? There are different filename two parameters which would help you do that. File.ServerFile is the unique name on the server, but File.ClientFile is the original name of the file before it was made unique. You can always store BOTH these names in the DB so that you can preserve the filename in listings and such in the application. If a file is downloaded out of the app, you can also apply the original name back again to fake out the users into thinking it was always named that on the server. If they actually need it to be named correctly on the server itself (boy that is picky), then you'll want to read up no the NAMECONFLICT="Error" attribute of the CFFILE tag. You should be able to use this along with CFTRY/CFCASE to handle the error and give the user some options on renaming it. -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: CGI Referrer variable
Yeah, I did that too. The funny thing is that it didn't throw an error in my case. Is the CGI variable space particularly (and annoyingly) lenient when it comes to nonexistant variables or is this anomalous behaviour? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, October 09, 2000 4:02 PM Subject: RE: CGI Referrer variable #CGI.REFERER# I found out the hard way just one r not 2 Larry Juncker Senior Cold Fusion Programmer Heartland Communications Group, Inc. -Original Message- From: Brian bouldernet [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 2:47 PM To: CF-Talk Subject: CGI Referrer variable Does anyone know the variable name for refferer? I forgot ofhand... Thnaks, Brian --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Value to Variable?
To get the value of name ".recordcount", use the Evaluate function. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Thursday, October 05, 2000 12:19 PM Subject: Value to Variable? if I cfset tmp = #name# ".recordCount" I can't use it as it literally should, when I cfoutput#tmp#/cfoutput it prints out but if I cfif #tmp# is not "0" it doesn't work... is there a type conversion I have to do here? --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: #Timeformat(Now())#
I would put the formatting mask behind the date. #DateFormat(Now(),"mm/dd/")# would result in 10/03/2000. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, October 03, 2000 5:39 PM Subject: #Timeformat(Now())# why doesn't this work: INPUT type="text" name="timeopen" value="#Timeformat(Now())#" size="8" It does not display the time, but displays #Timeformat(Now())# It's in the book! The date version works! ? Richard Colman --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: MORE: #Timeformat(Now())#
Well, that would do it too! I'm in the habit of always adding the formatting mask, and I've always done it this way, so I sorta jumped to conclusions. Doh. Sorry. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Richard Colman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, October 03, 2000 5:49 PM Subject: MORE: #Timeformat(Now())# sorry. works. /cfoutput in the wrong place. Boy, you can just look and look and look and not see the obvious. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 2:17 PM To: Cf-Talk Subject: #Timeformat(Now())# why doesn't this work: INPUT type="text" name="timeopen" value="#Timeformat(Now())#" size="8" It does not display the time, but displays #Timeformat(Now())# It's in the book! The date version works! ? Richard Colman --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: _date fields
I've experienced that on a few occasions, and it is because CF reserves the "_date" suffix for validating fields. The way around this is to not name your form fields with _date or _required or whatnot. I wish there was a way to turn this off! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Karl Simanonok [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, October 02, 2000 3:44 PM Subject: _date fields I've also experienced problems with form fields named 'something_date', they don't get properly passed as form fields. I think it has something to do with CF's data input validation algorithm getting confused when it doesn't find a 'something' field to do the validation on. I've learned (the hard way) to never name a form field with a _date suffix, except for validating a date field. Regards, Karl Simanonok Original message: === Date: Sun, 1 Oct 2000 11:13:17 -0400 From: Bud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Date fields in SQL Message-ID: p0432040fb5fd043d4afa@[192.168.0.2] On 10/1/00, W Luke penned: Hi, Well it's another Query problem for Will today - the error message is telling me it can't find expiry_date field - in Access I've set the date/time format to a custom dd-mmm-yy - is this the problem? Here's the code: For some reason, every now and again I have problems if I name something underscore date. Try naming expirydate and see if that helps. And it wouldn't hurt to refer to today as #createodbcdate(today)#. But that's probably not the problem. -- --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Javascript string search question...
You could use JS's regex functions... -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kevin Langevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, October 02, 2000 4:08 PM Subject: Javascript string search question... Anyone know how to do a text string search in Javascript? I've used substring before, but I'm looking for some way to do something akin to find() in CF, where it finds the substring ANYWHERE in the string to be searched. Is it necessary to do a character by character search, or is there a javascript command to find any instance of the search string in the string to be searched? CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Stewart, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 12:44 PM To: CF-Talk Subject: RE: CFServer a memory leaker? Tim, I'm basically running the same thing: Win98, CFServer, CFStudio, PWS, Intel Celeron 300 (overclocked to 450) and 128 RAM. I've had a few problems, but nothing major. This configuration works quite well for what I use it for. Now, I wouldn't use this for any type of production scenario, but it works well for just playing around at home. I also run many other programs on this machine as well: MS Office, numerous games, mem turbo and Zone Alarm. I would definitely beef-up the RAM on your machine and it should act a little better. For what it's worth, ~Mark -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 11:54 AM To: CF-Talk Subject: CFServer a memory leaker? At home I have installed CFSERVER running on Personal Web Server, using RDS. Since I have installed both server and studio, my system is very unstable and totally locks up many times a day. This is on Windows 98 with only 64 meg of RAM. Is this simply a memory issue, or is this configuration giving everyone else fits as well??? Tim Claremont Xerox Corporation -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HeadHunters?
I get those too. They were especially heavy on my first week on the job here, but I still occasionally get a call or email... I have no idea where they get my name. Jamie (I know I've had a long week when I look at the subject line and think "Why is CF-TALK talking about a Front 242 song?") -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Friday, September 29, 2000 9:06 AM Subject: Re: HeadHunters? We have been getting that *and* headhunters are also calling our company up trying to get us to hire people completely unrelated to anything we do. Go figure ... Todd Ashworth - Original Message - From: "Larry Juncker" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, September 29, 2000 8:56 AM Subject: RE: HeadHunters? | Yes, I am getting them to and haven't even sent out any apps or feelers. | | Larry Juncker | Senior Cold Fusion Programmer | Heartland Internet | | -Original Message- | From: Robert Everland [mailto:[EMAIL PROTECTED]] | Sent: Thursday, September 28, 2000 1:55 PM | To: CF-Talk | Subject: HeadHunters? | | | Is anyone else magically getting job offers from headhunters who | know your name or is it just me? | | Robert Everland III | Web Developer | Dixon Ticonderoga --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Date Timestamp??
Have you tried using #Now()# in your insert statement? That should work in most cases. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: HappyToad.com [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, September 26, 2000 11:15 AM Subject: Date Timestamp?? How do I input the current date and time into a database? In other words I want to time stamp an entry. Rich --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [CF-Talk] RE: listing tables in Access?
That's what I needed. Thanks very much! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Billy Cravens [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, September 18, 2000 8:35 PM Subject: Re: [CF-Talk] RE: listing tables in Access? You must open the database in Access, and make MSysObjects readable (system table; lists objects that make up the db, including tables). Can't remember the exact menu sequence, but we're all smart here :) Then you can query that table. Very similar to sysobjects table in SQL Server. Here some quick queries that do the tricks you need: http://home.att.net/~dashish/queries/qry0002.htm (disclaimer: I spent 5 seconds searching, so it's probably not the best out there) -- Billy Cravens [EMAIL PROTECTED] Eron Cohen wrote: Once upon a time there was a tag in the Allaire Tag Gallery that did this for MS Access. Unfortunately, it quit working when we we upgraded to Access 2000 or something like that (I forget exactly what went wrong). Just in case it will work for you, it was called CFX_TABLEFIELDS. HTH, Eron -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Monday, September 18, 2000 1:38 PM To: CFTalk Subject: OT: listing tables in Access? Hello everyone, I was wondering if Access has some mechanism in place to list all tables in a database. Thanks. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax - --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: listing tables in Access?
Hello everyone, I was wondering if Access has some mechanism in place to list all tables in a database. Thanks. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [CF-Talk] Re: listing tables in Access?
I meant as a query. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Ricq Pattay [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, September 18, 2000 3:28 PM Subject: [CF-Talk] Re: listing tables in Access? Assuming Access 97 (don't know about 2000): With the main database window visible, select Tools/Analyze/Documenter. There you can choose which db objects you wish to view/print. Ricq Pattay [EMAIL PROTECTED] Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message - From: Jamie Keane [EMAIL PROTECTED] To: CFTalk [EMAIL PROTECTED] Sent: Monday, September 18, 2000 12:37 PM Subject: OT: listing tables in Access? Hello everyone, I was wondering if Access has some mechanism in place to list all tables in a database. Thanks. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: cf error question...
I assume you mean the error messages with the diagnostic information in a box (syntax error, ODBC error, etc.)? The way you can set a default alternative for these admittedly ugly errors is to use the CFERROR tag in your application.cfm. If that's too limiting for what you wanted to do, you could use CFTRY/CFCATCH to trap individual errors per page and manipulate them. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Chris Terrebonne [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, September 05, 2000 6:15 PM Subject: cf error question... This has probably been covered already but... Is there any way to replace or customize CF's internal error messages ("canceled or ignored by server...", etc)? Thanks, Chris _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: count() or recordcount
Furthermore, count() is just that, a tally of the rows as a query column in and of itself. The RecordCount variable is an attribute of the query object. Returning a query object assumes that you wish to do something with it, other than count how many rows are returned. If you're just wishing to count the items with x criteria, your intent is closer to count() anyway. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, September 06, 2000 12:31 PM Subject: Re: count() or recordcount In a direct comparison, I would think count() would be since it's run on the SQL server. Todd Ashworth - Original Message - From: "Bud" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 06, 2000 12:11 PM Subject: count() or recordcount | Which is faster? I'm presuming count() or what else would it be good for? | -- | | Bud Schneehagen - Tropical Web Creations | | _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | ColdFusion Solutions / eCommerce Development | [EMAIL PROTECTED] | http://www.twcreations.com/ | 954.721.3452 | - - | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. | --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF not letting go of database connection?
This works with Access (so I'm not sure if it'll work in your case), and it's a quick-and-dirty approach, so YMMV. Todd's idea is better in the long run, but if you absolutely must kill the lock on the DB *right now*, try this: Just make a bogus SELECT query (usually I pull from a table named 50 characters of gibberish). In Access it kills the lock on the DB, and it might help out in Sybase. HTH, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, September 01, 2000 10:03 AM Subject: Re: CF not letting go of database connection? Do you mean that the database engine stays running even after the last connection has been closed? If so, go to your ODBC administrator in your control panel and open the properties for the DSN in question. Under the "Database" tab, you will have 2 checkboxes at the bottom. One is to automaticly start the database if it isn't running and the other is to shut down the database after the last disconnect. You will want to check the second one. Note that with this option checked, anytime the database is not being queried, the database engine will shut down. This means that it will have to restart every time a new query comes along, which adds about 1 second of overhead (YMMV). Todd Ashworth - Original Message - From: "Boris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 1:20 PM Subject: CF not letting go of database connection? | I have a number CF based pages that once the query is completed with the | data presented it will not let go of the database connection to my Sybase | SQL Anywhere database. Even after the page has been exited. | | Any suggestion would be appreciated. | | Boris --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: StructClear
StructClear destroys struct keys. As for deleting structures altogether, I'm not sure. Surely there's got to be a way to unset variables, right? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Stas Newdel [EMAIL PROTECTED] To: CFTalk [EMAIL PROTECTED] Date: Friday, September 01, 2000 3:44 AM Subject: StructClear Does StructClear reset keys in a structure to be blank, or does it remove the keys? Also, what's a function to get rid of a structure altogether? Thank you --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: New and Worried (terminating a session)
You can specify a session variable's timeout in the CFAPPLICATION tag (in fact, you MUST set it). Session variables can last as long as you want them to, but bear in mind that they typically reside in memory, so be judicious about their usage! As for terminating the session, you can use the StructClear() function. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: megan sherman [EMAIL PROTECTED] To: cold fusion [EMAIL PROTECTED] Date: Friday, September 01, 2000 3:38 AM Subject: New and Worried (terminating a session) Hi all, This is proving to be an informative list! I have worked out a lot of the cold fusion portion of my latest site. Session variables are still a mystery. How do I turn off a session? In other words, if I leave the website and come back in an hour, or next day, I want a fresh session. Can this be done in applications.cfm with a timer/counter? I think I read somewhere that a session can be terminated with javascript. Earlier, someone posted the cold fusion script below. Will that terminate my session after 30 minutes (or do I have to modify this code somewhat?) Any help would be greatly appreciated. BTW, what is the philosphy of a "session"? Do customers expect their session to be persistant over days? Thanks! Megan I use this which deletes all client variables if they haven't been accessed in 30 minutes: CFIF not isDefined('client.initialize_session') cfset client.initialize_session = now() cfelse cfset app_timeout = now() - createtimespan(0,0,30,0) CFIF client.initialize_session GTE app_timeout cfset client.initialize_session = now() CFELSE cfset clientlist = GetClientVariablesList() cfloop index="i" list="#clientlist#" cfset temp = DeleteClientVariable('#i#') /cfloop cfset client.initialize_session = now() /CFIF /CFIF --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Has the Apocalypse cometh? (Was RE: CF vs. ASP)
I am, well at least professionally. I fiddle with PHP as a hobby, and my job hasn't required me to switch over yet, so I guess I still qualify. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 30, 2000 8:32 PM Subject: Re: Has the Apocalypse cometh? (Was RE: CF vs. ASP) Me - Original Message - From: "Owens, Howard" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 30, 2000 8:22 PM Subject: RE: Has the Apocalypse cometh? (Was RE: CF vs. ASP) -Original Message- From: Gregory Harris [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 30, 2000 8:32 AM To: [EMAIL PROTECTED] Subject: Has the Apocalypse cometh? (Was RE: CF vs. ASP) How many dedicated CF programmers are there still out there? Me. = Howard Owens Web Producer InsideVC.com mailto:[EMAIL PROTECTED] = - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
(OT) making fields readonly with JavaScript
Hi all, and I apologise for being off-topic, but this is driving me nuts! Is there a way to "disable" text field via JavaScript? I know of the READONLY attribute, and the client likes how that works, but in my research I was not able to come up with a way to access that attribute through JS. Any ideas? Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Javascript Question
Here's what I'd do. Make the image an HREF pointing to "#", and calls a function when clicked. Like so: function doMyStuff() { document.image.src = "newimage.jpg"; document.form.submit(); } I think this will work. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Robert Everland [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Thursday, August 31, 2000 11:20 AM Subject: OT: Javascript Question I can't remember where or the name of the javascript forum off of cf-talk but I figured I may as well as my question and then have someone tell me where to do. I have a form button that is an image. I put some javascript in there so that when I click on it, it changes the image. What I want to do now is make it so that image is not clickable that way no one can keep clicking on submit. Anyone know how to do this, it can't be a href tag becuase I have to pass form variables. Robert Everland III Web Developer Dixon Ticonderoga --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: (OT) making fields readonly with JavaScript
Yep, that'll do it. I forgot entirely about blur(). Thanks! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Jason Powers [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Thursday, August 31, 2000 12:05 PM Subject: RE: (OT) making fields readonly with JavaScript Jamie, Shouldn't it be possible for you to use the blur() method to force focus off of that text box? Like this: input type="text" onFocus="this.blur();" to take focus off of that field, or input type="text" onFocus="document.forms[0].someotherelement.focus()" to focus on another element, which would actually be rather confusing for the user. If that doesn't work, you might be able to do something like this: scriptvar myval;/script input type="text" onFocus="myval=this.value;" onBlur="this.value=myval;" to replace the value in the field with its previous value. -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 31, 2000 9:51 AM To: CFTalk Subject: (OT) making fields readonly with JavaScript Hi all, and I apologise for being off-topic, but this is driving me nuts! Is there a way to "disable" text field via JavaScript? I know of the READONLY attribute, and the client likes how that works, but in my research I was not able to come up with a way to access that attribute through JS. Any ideas? Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Re[2]: (OT) making fields readonly with JavaScript
Well, the bugbear of this was I needed to control, via radio buttons, whether or not the text field(s) was/were readonly. What I ended up doing was storing the state in a hidden formfield. If anyone cares to see the code, I'll post it. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Carol Bluestein [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 31, 2000 4:14 PM Subject: Re[2]: (OT) making fields readonly with JavaScript Yes, it works and works well. Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] I haven't tried this, and in fact I'm stealing this from the JS-Jive list: onFocus="this.blur()" in the input tag Ricq Pattay [EMAIL PROTECTED] Univ of Minnesota - Twin Cities College of Veterinary Medicine - Original Message ----- From: Jamie Keane [EMAIL PROTECTED] To: CFTalk [EMAIL PROTECTED] Sent: Thursday, August 31, 2000 8:50 AM Subject: (OT) making fields readonly with JavaScript Hi all, and I apologise for being off-topic, but this is driving me nuts! Is there a way to "disable" text field via JavaScript? I know of the READONLY attribute, and the client likes how that works, but in my research I was not able to come up with a way to access that attribute through JS. Any ideas? Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: IsDefined help
What method is the form using? To use the FORM scope a form must use the POST method. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Joel Blanchette [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, August 29, 2000 10:34 PM Subject: IsDefined help This is a multi-part message in MIME format. --=_NextPart_000_0005_01C01200.C3750520 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everyoneI am having some stupid problems with a simple = command. I am to make a check on a form field and if it is not defined = to write something. i tried the following with no success...Hope = someone can help. CFIF NOT IsDefined("form.name") You forgot your name /CFIF I also tried CFIF IsDefined("form.name") EQ "FALSE" You forgot your name /CFIF but still with no success...Hope someone can help me out!!! Thanks... Joel --=_NextPart_000_0005_01C01200.C3750520 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2Hello everyoneI am having some stupid problems = with a=20 simple command.nbsp; I am to make a check on a form field and if it is = not=20 defined to write something.nbsp; i tried the following with no = success...Hope=20 someone can help./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2lt;CFIF NOT IsDefined("form.name")gt;/FONT/DIV DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2I also tried/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 DIVFONT size=3D2lt;CFIFnbsp;IsDefined("form.name") EQ=20 "FALSE"gt;/FONT/DIV DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV DIVnbsp;/DIV DIVbut still with no success...Hope someone can help me out!!!/DIV DIVnbsp;/DIV DIVThanks.../DIV DIVnbsp;/DIV DIVJoel/DIV/FONT/DIV/BODY/HTML --=_NextPart_000_0005_01C01200.C3750520-- --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Need help validating a URL...
How about... cfif Left(var,7) is not "http://" (error message...) /cfif -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Edward Chanter [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 30, 2000 4:33 AM Subject: Need help validating a URL... Hey Gurus, Does anyone know a quick way to take a url input into a form and check to see if the user has put in the http:// ??? There must be a way to do it in CF but I haven't found it yet... Been searching the archives for ages but so far with no luck... :-( Any help would be most appreciated! TiA -= Edward --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: IsDefined help
I don't think so. I know Form.FIELDNAMES is reserved, but that's about it, I think. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Andy Ewings [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wednesday, August 30, 2000 8:56 AM Subject: RE: IsDefined help Just a thoughtis Form.name a reserved variable? Try renaming the control and see what happens. -Original Message- From: Jamie Keane [mailto:[EMAIL PROTECTED]] Sent: 30 August 2000 13:56 To: [EMAIL PROTECTED] Subject: Re: IsDefined help What method is the form using? To use the FORM scope a form must use the POST method. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Joel Blanchette [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, August 29, 2000 10:34 PM Subject: IsDefined help This is a multi-part message in MIME format. --=_NextPart_000_0005_01C01200.C3750520 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everyoneI am having some stupid problems with a simple = command. I am to make a check on a form field and if it is not defined = to write something. i tried the following with no success...Hope = someone can help. CFIF NOT IsDefined("form.name") You forgot your name /CFIF I also tried CFIF IsDefined("form.name") EQ "FALSE" You forgot your name /CFIF but still with no success...Hope someone can help me out!!! Thanks... Joel --=_NextPart_000_0005_01C01200.C3750520 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2Hello everyoneI am having some stupid problems = with a=20 simple command.nbsp; I am to make a check on a form field and if it is = not=20 defined to write something.nbsp; i tried the following with no = success...Hope=20 someone can help./FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2lt;CFIF NOT IsDefined("form.name")gt;/FONT/DIV DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2I also tried/FONT/DIV DIVnbsp;/DIV DIVFONT size=3D2 DIVFONT size=3D2lt;CFIFnbsp;IsDefined("form.name") EQ=20 "FALSE"gt;/FONT/DIV DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV DIVnbsp;/DIV DIVbut still with no success...Hope someone can help me out!!!/DIV DIVnbsp;/DIV DIVThanks.../DIV DIVnbsp;/DIV DIVJoel/DIV/FONT/DIV/BODY/HTML --=_NextPart_000_0005_01C01200.C3750520-- -- - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: formatting social security number
Here's what I did: cfset output = Replace(form.ssn,"-","","ALL") and to display it properly, #Left(output,3)#-#Mid(output,4,2)#-#Right(output,4)# -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kim Ahlbrandt [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 30, 2000 2:35 PM Subject: formatting social security number I need to take the dashes out of a social security number before storing to the database, and then put them back in when the page is brought up again later. Is there a way to do this in coldfusion?? Thanks, Kim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What I want in CF (was: Learning ASP)
God that's kludgy, but if it works it works, eh? Still, I wish Allaire would put a more "standardised" and documented syntax, so I wouldn't have to scratch my head as much. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Theobald [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, August 28, 2000 5:53 PM Subject: Re: What I want in CF (was: Learning ASP) Cold Fusion is weak in these areas, but really you can do all these things (or "emulate" them :-) ) using existing features. (forgive my syntax - I'm writing this quickly) Pick a standard variable name, like ReturnValue and only use it for returning a value from a custom tag: caller.ReturnValue = xxx Or use the tag's name as a structure: If NOT IsDefine("MyTagName") { MyTagName = StructNew() } MyTagName.Return = "some data" Static variables: How static do you want them? :-) Cold Fusion has extra "scopes" that wouldn't make sense in a standard programming language like C++ where the application all runs at once. In Cold Fusion you might want static variables that retain their value (1) for the entire Application, (2) for the page request (there are more you could define if you tried hard). Pick a standard word, for example "static" and keep them under Application and Request. Use a hash of the module name: In Application.cfm: If NOT IsDefined('Request.Static') Request.Static = StructNew() In module: MyTagName: Request.Static["MyTagName"] = StructNew() Request.MyTagName.ThisStaticVar = "some data"; This is now a static variable that will retain it's value for the duration of this page request through all files and multiple calls to this tag. It is only "private" within the tag because you make it so with the naming convention. The same thing can be done under the Application scope (scopes are structures). Now the *REAL* problem with Cold Fusion is there is no ability to define a macro, function, or subroutine to "hide" these details so these kinds of things are very wordy which encourages mistakes when you have to specify them a hundred times. At 02:49 PM 8/28/00 -0400, Jamie Keane wrote: My biggest complaint with the language is the lack of user-defined functions. I know that custom tags are sorta a work-around, but sometimes a function just needs to return a value, not just assign a value back to the calling template. Also, there's no way (that I know of at least) to pass values by reference, or declare static variables within the scope of a custom tag. While PHP doesn't have the simplicity that CF has in terms of database twiddling, and its error handling leaves a bit to be desired, it does have support for user-defined functions that may contain variable references and static variables, and that helps me out a lot. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Gregory Harris [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, August 28, 2000 2:30 PM Subject: Re: What I want in CF (was: Learning ASP) Ok, my wish list now: 1) How about a way to determine whether a dimension exists in an array, for instance this works: ArrayLen(ThisArray) But if ThisArray were a 2 dimensional array and I needed to figure out the length of something in dimension 2, using this ArrayLen(ThisArray[DimensionOne]) breaks the page Rather than having to go thru the excess overhead of trying to use a counter, maybe extending Arraylen could help this? Or how about a ArrayDimensionExists() function? 2) Extending CFHTTP (I think this is a BIG one) 3) Making Structures Multi-Dimensional, or is it possible to do structures like: Stuff.Things.MoreThings = ThisVariable This has never worked with me, the best I could do would be Stuff.Things I'm sure there are more headaches I've run into, but these are right off the top of my head. What else can everyone think of? Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/28 11:11 AM Dave Watts [mailto:[EMAIL PROTECTED]] I agree that the interfaces for SMTP, POP, HTTP, etc. need a lot of work. As for other stuff, I'm kind of curious. What basic functionality would you like to see? I can't really think of all that much that I'd like to see added. Personally, I've got a laundry list. :) However, off the top of my head, in no particular order (I mentioned most of these at The Con last year, and will do so again if I go this year): 1. Extend the CFX API to make it more useful. There a
Re: Is there are way to get a hold of the referring server
It should also be noted that Allaire provides a PDF quick-reference that summarises all functions, CF tags, and objects created by invocation of said tags and functions. It's a real life-saver. You should be able to find it on Allaire's site. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: JustinMacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, August 29, 2000 12:06 PM Subject: Re: Is there are way to get a hold of the referring server From cfdocs/Quick_Reference/contents.htm CGI.AUTH_TYPE CGI.CONTENT_LENGTH CGI.CONTENT_TYPE CGI.PATH_INFO CGI.PATH_TRANSLATED CGI.QUERY_STRING CGI.REMOTE_ADDR CGI.REMOTE_HOST CGI.REMOTE_USER CGI.REQUEST_METHOD CGI.SCRIPT_NAME Server CGI.GATEWAY_INTERFACE CGI.SERVER_NAME CGI.SERVER_PORT CGI.SERVER_PROTOCOL CGI.SERVER_SOFTWARE Client CGI.CERT_ISSUER CGI.CERT_SUBJECT CGI.CLIENT_CERT_ENCODED CGI.HTTP_ACCEPT CGI.HTTP_USER_AGENT EG: cfoutput #cgi.http_referer# /cfoutput ~Justin - Original Message - From: "Kevin Schmidt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 29, 2000 6:02 PM Subject: Is there are way to get a hold of the referring server This is a multi-part message in MIME format. --=_NextPart_000_0C9A_01C011B1.04723110 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there are way to get a hold of the referring server in CF's CGI = variables. I can't even find the list of CGI variables in Allaires = Documentation. Thanks. Kevin Schmidt Internet Services Manager Peterson, WIlliams Bizer Office: 734.995.5000 Mobile: 734.649.4843 --=_NextPart_000_0C9A_01C011B1.04723110 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIV PIs there are way to get a hold of the referring server in CF's CGI = variables.=20 I can't even find the list of CGI variables in Allaires = Documentation.nbsp;=20 Thanks./P/DIV DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20 ManagerBRPeterson, WIlliams amp; BizerBROffice: = 734.995.5000BRMobile:=20 734.649.4843BR/FONT/DIV/BODY/HTML --=_NextPart_000_0C9A_01C011B1.04723110-- - - Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFLOCK datasource var?
Yeah, but the "Variables" scope isn't persistent. Each time a page loads it will unset itself. It would be better IMHO to just do a plain vanilla CFSET. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, August 29, 2000 4:48 PM Subject: Re: CFLOCK datasource var? You shouldn't need to use a Session variable for your DSN .. especially if you are going to be setting it over and over in your Application.cfm. That defeats the purpose of having a Session variable anyway. You could get by with another scope .. say Variables.ds, or something. That way, you wouldn't have to worry about locking at all. cfif not IsDefined('Variables.ds') cfset Variables.ds = "something_dev" /cfif Todd Ashworth - Original Message - From: "Ricq Pattay" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 29, 2000 4:42 PM Subject: CFLOCK datasource var? | In my application.cfm I set a session var for all my queries' datasource | like this: | | cflock scope="session" timeout="30" type="exclusive" | cfset session.ds = "something_dev" | /cflock | | So... Do I need to read-only lock every reference to session.ds in all my | other templates where I have a query using that datasource session var? | e.g., | | cfquery name="get_year" datasource=#session.ds# | select sysdate from dual | /cfquery | | Since session.ds is always identical for every user of this site, what does | it matter if it's locked or not? | | | Ricq Pattay [EMAIL PROTECTED] | Univ of Minnesota - Twin Cities | College of Veterinary Medicine | | | | | - - | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. | --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: What I want in CF (was: Learning ASP)
My biggest complaint with the language is the lack of user-defined functions. I know that custom tags are sorta a work-around, but sometimes a function just needs to return a value, not just assign a value back to the calling template. Also, there's no way (that I know of at least) to pass values by reference, or declare static variables within the scope of a custom tag. While PHP doesn't have the simplicity that CF has in terms of database twiddling, and its error handling leaves a bit to be desired, it does have support for user-defined functions that may contain variable references and static variables, and that helps me out a lot. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Gregory Harris [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, August 28, 2000 2:30 PM Subject: Re: What I want in CF (was: Learning ASP) Ok, my wish list now: 1) How about a way to determine whether a dimension exists in an array, for instance this works: ArrayLen(ThisArray) But if ThisArray were a 2 dimensional array and I needed to figure out the length of something in dimension 2, using this ArrayLen(ThisArray[DimensionOne]) breaks the page Rather than having to go thru the excess overhead of trying to use a counter, maybe extending Arraylen could help this? Or how about a ArrayDimensionExists() function? 2) Extending CFHTTP (I think this is a BIG one) 3) Making Structures Multi-Dimensional, or is it possible to do structures like: Stuff.Things.MoreThings = ThisVariable This has never worked with me, the best I could do would be Stuff.Things I'm sure there are more headaches I've run into, but these are right off the top of my head. What else can everyone think of? Gregory Harris Los Angeles Information Technology Agency (ITA) [EMAIL PROTECTED] [EMAIL PROTECTED] 08/28 11:11 AM Dave Watts [mailto:[EMAIL PROTECTED]] I agree that the interfaces for SMTP, POP, HTTP, etc. need a lot of work. As for other stuff, I'm kind of curious. What basic functionality would you like to see? I can't really think of all that much that I'd like to see added. Personally, I've got a laundry list. :) However, off the top of my head, in no particular order (I mentioned most of these at The Con last year, and will do so again if I go this year): 1. Extend the CFX API to make it more useful. There are some things (like working with arrays, as Jeremy mentioned) that don't work or are hellishly hard to workaround. Some of us (very few, I know) *like* to work in C++ and *like* to optimize our stuff by putting it in machine code. 2. Fix the encryption. It's really *really* broken. 3. (or, in deference to or addition to #2) Support for "compiling" templates. We know that they already do this in memory (something akin to a p-code or bytecode type thing), but what I'd like to see is the ability to take that compiled chunk of memory and save it to a file. Python has this, as does Perl (in a limited sense). This would do two things for me: (a) It would mean that even though people could still "decompile" it, they'd still have to figure out var names, etc. (b) It would save the overhead of parsing the file every time. 4. Better regular expression engine. (Especially non-greedy matching.) 5. Better locking system. (This is a whine.) It's all fine and good to put the burden of the locking on the programmer (who has to go absolutely crazy on the CFLOCKs in a production system), but I'd really like to see something a bit better. I dunno how, but I know they have some pretty smart people who can surprise us. 6. Binary data support for variables. (Unicode?) Right now I can't (reliably) mess around with binary files. :( 7. Fix CFHTTP! Please! In the current implementation so much is broken it's not even funny! a. Not thread-safe (gah!) b. Can't use CFHTTPPARAM (and therefore cookies) without the POST method. (lame) c. Can't select encoding type (multipart/form-data doesn't work everywhere) - at least make it smart enough so that if no files are attached it doesn't use multipart! (exceedingly lame) d. The hack for port is *stupid*. If I want to access an arbitrary URL that could be on any port, I have to manually parse out the port number from the URL and put it in the PORT attribute and at the same time take it out of the URL string (it barfs otherwise!). (mired in a sweaty mass of lameness) 8. Fix PreserveSingleQuotes() - Right now it doesn't act like a real function. I can't do other things in it. That is, PreserveSingleQuotes(ListChangeDelims(list,"','")) is broken. (This is my most common use for it.) 9. Fix the standard structures (Form, Client, etc) to actually work like structures, so that I can enumerate them, delete from them, etc. Having to GetClientVariables() or get Form.FieldNames is just ann
Re: IF this OR this
Just like you said. I usually wrap my conditional components in parentheses just to be certain. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Monday, August 28, 2000 2:43 PM Subject: IF this OR this how can I cfif this OR this /cfif ? Thanks Pete --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: password generation code snippet needed
Just for fun, I tried something. It seems to work pretty well, and fast too! cfset length = 8 cfset pswd = "" cfloop index="i" from="1" to="#length#" step="1" cfset donumbers = RandRange(0,1) cfif donumbers cfset lowend = 49 cfset highend = 57 cfelse cfset uppercase = RandRange(0,1) cfif uppercase cfset lowend = 65 cfset highend = 90 cfelse cfset lowend = 97 cfset highend = 122 /cfif /cfif cfset pswd = pswd Chr(RandRange(lowend,highend)) /cfloop -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Stas Newdel [EMAIL PROTECTED] To: CFTalk [EMAIL PROTECTED] Date: Monday, August 28, 2000 5:06 PM Subject: password generation code snippet needed Hello, Does anyone have code lying around that will generate an alpha-numeric mixed case string? Thanks. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Query syntax
The "dbo" scope is the "owner" of the table. This means it was created by user "dbo." The "dis_products" scope is the name of the table the column belongs to. That's to eliminate ambiguity in multitable queries. "DESC" means descending. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Chad [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, August 28, 2000 5:22 PM Subject: Query syntax ORDER BY dbo.dis_products.product_name DESC This is a part of a query that im trying to de-cipher. How can the variable have two scopes? And what is DESC? Thanks Chad --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: IsNotDefined()
Try NOT IsDefined(). -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Friday, August 25, 2000 8:49 AM Subject: IsNotDefined() Is there a way to do this? I've tried things like !IsDefined() with no success... Thanks, Pete --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Concatenate Strings
cfset ConcatenatedString = string1 string2 -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Thursday, August 24, 2000 7:18 PM Subject: Concatenate Strings How can I concatenate 2 strings in CF? --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: splitting strings
Do you wish to convert your list to an array? If so, there's the function ListToArray. If you are wanting to put each element on a blank line, you could loop through the array and output each element at a time, followed by br. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Thursday, August 24, 2000 3:17 PM Subject: splitting strings if I have a string like word1,word2,word3 How could I split it in Cold Fusion into ? word1 word2 word3 Thanks, Pete --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Division in Cold Fusion?
cfset myval = thisval / thatval should work. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wednesday, August 23, 2000 2:37 PM Subject: Division in Cold Fusion? I must be looking at all the wrong stuff... but I want to take 2 values and divide them. like: cfset myval = #thisval# \ #thatval# Is there a correct way to do this? Thanks, Pete --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie Cold Fusion Studio Question
You will need Cold Fusion Server installed on the machine that's serving up the documents for variables to be interpreted. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kim Woodbridge [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 23, 2000 2:43 PM Subject: Newbie Cold Fusion Studio Question Hello, I am trying to set up Cold Fusion Studio in order to view and alter .cfm files created by our main IS department. I have set up the Developmental Mappings properly and have created a very simple file from an example in the Studio documentation. HTML HEAD TITLECall Department/TITLE /HEAD BODY STRONGCall Department/STRONG !--- Set all variables --- CFSET Department="Sales" CFSET City="Boston" CFSET Salary="11" !--- Display results --- CFOUTPUT I'd like to talk to someone in #Department# in #city# who earns at least #Salary#. /CFOUTPUT /BODY /HTML When I view this in my browser it shows #Department# etc. rather than filling in the variables. Does anyone know what I may have not configured properly or what I am missing here. I am not running Cold Fusion Server but am using the Microsoft Personal Server for Windows 95. Thanks in advance. Kim A. Woodbridge Web Developer Children's Hospital of Philadelphia 215-590-1197 [EMAIL PROTECTED] --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: limiting Malicious uploaded file types
The way I'd do it is cffile action="upload" (other_attributes) cfset Disallow = "cfm,exe,asp,vbs,js" cfif ListFindNoCase(Disallow,ListLast(FILE.ServerFile,".")) is not 0 cffile action="delete" file="#FILE.ServerFile#" -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Milks, Jim [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Wednesday, August 23, 2000 3:46 PM Subject: limiting Malicious uploaded file types Hi all, I am in the process of coding a site on which users can upload files for collaboration. I need to limit the file types that can be uploaded for obvious security reasons, and am curious if anyone has encountered this type of situation. I have found a way of determining this after the file is uploaded (maybe there is a CFX??), at which point I delete it, but what I am really interested in is which type of files I should exclude. So far, I have figured on these: .cfm, .asp, .vbs, .exe, .js Also, should I be concerned about EXE is I do not permit a file type that could execute it? (such as cfm) If I do not have anything like JRun on the server, need I be concerned with .jsp files? Lastly, what is a .dbm file? I have seen this MIME type on CF powered sites before. Thanks, JM --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: assigning value to dynamic variable
The proper syntax is: CFSET Evaluate("CurBills_#myBillFolder#" =ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Ric Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 23, 2000 4:24 PM Subject: assigning value to dynamic variable How can I accomplish this. CFSET Evaluate("CurBills_"myBillFolder) = ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum) CF doesn't want to let me use a function . - Just in time compilation error Illegal left hand side of assignment near line 127, column 11. Left hand side cannot be a function call. --- There must be a way to do this, my brain is a little mushy. Help! Ric Smith --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: assigning value to dynamic variable
oops remove the "evaluate(" from the beginning! (I really should proofread...) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message----- From: Jamie Keane [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 23, 2000 4:31 PM Subject: Re: assigning value to dynamic variable The proper syntax is: CFSET Evaluate("CurBills_#myBillFolder#" =ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Ric Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 23, 2000 4:24 PM Subject: assigning value to dynamic variable How can I accomplish this. CFSET Evaluate("CurBills_"myBillFolder) = ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum) CF doesn't want to let me use a function . - Just in time compilation error Illegal left hand side of assignment near line 127, column 11. Left hand side cannot be a function call. --- There must be a way to do this, my brain is a little mushy. Help! Ric Smith -- - --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamic IIf
The syntax should be IIF(condition,result1,result2) where result1 occurs if condition is true and result2 occurs if condition is false. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Monday, August 21, 2000 11:41 AM Subject: dynamic IIf Having a hard time with this: cfset value="#IIF url.stuff IS "whatever", "something", "something else"#" Tried mixing things up a bit (quotes, pound signs) with no success. Any suggestions? TIA, Pete --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: dynamic IIf
Oh, my mistake... I forgot the DE()'s around the results. These are needed. My brain's fried today. :) -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: Monday, August 21, 2000 12:03 PM Subject: RE: dynamic IIf Well that's what I have IIF(url.stuff IS "whatever" then "something" else "something else") which is what my line of code essentially says. Though it doesn't work :/ * -Original Message- * From: Jamie Keane [mailto:[EMAIL PROTECTED]] * Sent: Monday, August 21, 2000 11:53 AM * To: [EMAIL PROTECTED] * Subject: Re: dynamic IIf * * * The syntax should be IIF(condition,result1,result2) * where result1 occurs if condition is true and result2 occurs * if condition is * false. * * -- * Jamie Keane * Programmer * SolutionMasters, Inc. * 9111 Monroe Rd., Suite 100 * Charlotte, NC 28270 * www.solutionmasters.com * 704.563.5559 x 228 Voice * 704.849.9291 Fax * -Original Message- * From: Peter Benoit [EMAIL PROTECTED] * To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] * Date: Monday, August 21, 2000 11:41 AM * Subject: dynamic IIf * * * * Having a hard time with this: * * cfset value="#IIF url.stuff IS "whatever", "something", "something * else"#" * * Tried mixing things up a bit (quotes, pound signs) with no * success. Any * suggestions? * * TIA, * Pete * * * --- * --- * Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ * To Unsubscribe visit * http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lis ts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- - -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Printing anchor code
You'd need to escape the "trouble" characters, I'd think. Have you tried CF's HTMLCodeFormat() function? -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kevin Queen [EMAIL PROTECTED] To: Cold Fusion [EMAIL PROTECTED] Date: Monday, August 21, 2000 4:56 PM Subject: OT: Printing anchor code All, OK, my brain is about to explode for not being able to remember a simple command from HTML 3.2, if I want to display the text "a href="..."Blah, blah, blah/a" in a browser, how do I do that. BTW: pre/pre is not it. Please help before my brain goes on permanant vacation. -Kevin --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: How can you programmatically keep a web browser from caching a page?
You could use CFHEADER to expire the page: CFHEADER Name="Expires" Value="#Now()#" -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Brandon Behrens [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, August 16, 2000 6:23 PM Subject: OT: How can you programmatically keep a web browser from caching a page? How can you programmatically keep a web browser from caching a page with HTML? Thanks in advance, Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Open Source (and free?) web content editor?
It's not WSIWYG, and it's for PHP, but you might take a gander at http://www.ekenberg.se/php/ide/ -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Cameron Childress [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 17, 2000 11:36 AM Subject: Open Source (and free?) web content editor? I know this has been discussed before, but after looking through my email archives I don't see a direct answer to my question, so here it is: I'm scouring the web for word processor-ish content editor to embed into a content management system. I've found Activedit (www.cfdev.com) and eWebEditPro (www.ektron.com) so far. The two products look very similar with a few differences. You can get Activedit as open source, and I like that. What I'd really love to find though, is a nice *free* and full featured editor. I don't know that's going to happen, but I gotta try. I'm thinking that one may exist in PHP-land or something. In the event that there was a PHP (or ASP) version out there, all I really need is the client editor part. It should be trivial to change the small amount of code which exchanges the content with the DB. Anyone seen anything like this anywhere out there? -Cameron Cameron Childress McRae Communications p. 770-460-7277 x.232 f. 770-460-0963 --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: credit card validation
If you wanted to use Javascript there is a Javascript validator at http://www.dejeu.com/web/tools/tech/js/forms/form_chkcard-f.asp -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Kiley Simpson [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 17, 2000 1:10 PM Subject: credit card validation Does anyone have an up to date credit card number validation tag? I don't need to verify funds or anything, I just have to see if the credit card (visa, mc, amex) is a potentially valid number. Thanks. --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: javascript help
Your cfform needs a name. If you're just using HTML forms, you'll still need a name for your form to access the form's contents. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: sebastian palmigiani [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 17, 2000 1:50 PM Subject: javascript help I'm trying to develop a javascript validation for a textarea. I'm getting an error message which says "ProgramDescription.value" is not an object. === script language="javascript1.2" function validate(testform) { if (testform.ProgramDescription.value == " ") { window.alert("Please add a program description."); return false; } return true; } /script cfform action="AddNewProgram.cfm" method="post" ONSUBMIT="return validate(this)" textarea name="ProgramDescription" value="" cols="30" rows="10" wrap="virtual"/textarea input type="submit" value="submit" /cfform Thanks, Sebastian --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: go back to previou s page
You can refer to the referring document with the CGI.HTTP_REFERER variable. Just set your href to that and that should do the trick for you. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: thanh nguyen [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 17, 2000 2:06 PM Subject: go back to previou s page I have different pages go to the same page and i want to know know how if I go to that page and click done it go back to previous page where I come from thanks Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL query problem...
It's an old-school bass synthesizer. (yeah, I'd love to get my hands on one too...) veering blindly off-topic, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Chapman, Katrina [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, August 17, 2000 3:01 PM Subject: RE: SQL query problem... What's a TB303? --K -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 17, 2000 10:57 AM To: [EMAIL PROTECTED] Subject: RE: SQL query problem... OK, this is probably wrong, but its all I can glean from SQL BOL ALTER TABLE table_name NOCHECK CONSTRAINT your_primary_key ...do your stuff... ALTER TABLE table_name CHECK CONSTRAINT your_primary_key If I'm right, you owe me a mint condition TB303! *me sits down and crosses fingers in hope* -- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Ryan Williams [mailto:[EMAIL PROTECTED]] Sent: 17 August 2000 18:15 To: [EMAIL PROTECTED] Subject: Re: SQL query problem... Oops. I just stumbled onto the answer by accident. I just removed the "-2" and associated parentheses from the sub-query and I got my results. My sub-query now looks like: select max(right(wire_id,len(wire_id))) from wire_list) and it works too !! :-) My sincerest apologies to everyone in the list. Ryan Williams [EMAIL PROTECTED] - Original Message - From: "Ryan Williams" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 17, 2000 12:45 PM Subject: SQL query problem... I have a SQL problem. I know what information I want to retrieve from the DB, however, I do not know what precisely is the proper SQL syntax/function is in order to achieve it. The query as it is currently written in my CF template is: select wl.*,p.*,wlg.*,wb.*,wsnd.*,wrcvd.*,ws.* from wire_list wl left join P_officers p on wl.reg_by = p.off_id left join wire_status ws on wl.status_code = ws.status_code left join wire_log wlg on wl.wire_id = wlg.wire_id left join wire_senders wsnd on wl.sender_id = wsnd.sender_id left join wire_rcv_modes wrcvd on wl.rcv_mode = wrcvd.rcv_mode left join wire_banks wb on wl.bank_id = wb.bank_id where wl.wire_id = ( select max(right(wire_id,(len(wire_id)-2))) from wire_list) The error this code generates when I attempt to run it in SQL query analyzer: Server: Msg 536, Level 16, State 1, Line 1 Invalid length parameter passed to the substring function. The content of the wire_id column looks like this format: ab999 and is of varchar datatype. I did not code these tables and I am in the middle of re-coding the entire site to be FuseBox compliant. I am trying to select the top (max) wire_id from the wire_list table, and display all records related to the returned value of the max function, but the result that areretrieved to date, with the code "Select max(wire_id)" and no WHERE clause, is ab99 when I know there are wire_id's in the table that have values of ab999, etc. It seems that SQL does not recognize that ab999 is the larger value when compared to ab99. The solution I am trying to apply with the code at the top of this email is to "get" the "number" part of the wire_id column, minus the two letters, and then use the max function on the remainder to get the ab999 wire_id i know is in the table. I looked through the SQL books online and it seems that SQL Sever does not have the ability to convert the varchar datatype (of the wire_id) column to the int data type that the max function seems to need in order to work properly. Does anyone know of a work around for this problem? Or am I going totally in the wrong direction with this logic? Any help/ideas/comments would be greatly apprecia
Re: Robot chasing question
I don't know about the first part but they shouldn't follow the includes, since the robot should only see the resultant HTML code, like any browser. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Larry Juncker [EMAIL PROTECTED] To: Cf-Talk@Houseoffusion. Com [EMAIL PROTECTED] Date: Thursday, August 17, 2000 3:49 PM Subject: Robot chasing question Will searchengine robots search cfm pages and will they follow cfincludes through a page? Thanks In Advance Larry Juncker Developer @ Heartland Internet --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.