Encrypt/Decrypt
If I have Encrypt(x,y) which equals z OR Decrypt(x,y) which equals z, can z be determined (encrypted or decrypted) without having both x and y? Example: cfset variables.secretKey = dj0yJmk9TTJOUXFnakphWjVlJmQ9WVdrOVVtMU9jak5rTjJNbWNHbzlPREV4TVRrNE5EWXkmcz1jb25zdW1lcnNlY3JldCZ4PWQx cfset variables.value = Encrypt(MYPASSWORD, variables.secretKey) if you output variables.value, you get: *'Y^MZ!]F;*=V@ So... if someone gets my MYPASSWORD and *'Y^MZ!]F;*=V@, can they figure out the value of variables.secretKey? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scripting website or host header will IIS and CF
It seems simple enough. My user inputs a web address he wants configured on my server and I programatically create it in IIS through my CF application. And then I may want to create subdomains though host headers on the same IP. Using CF9. Surely this has been done hundreds of times... anyone got some sample code that can get me started in the right direction? Take it easy 'cause I'm not all that smart... =) Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ExactTarget SOAP API
Does anyone have any experience with CF and ExactTarget's SOAP API. We have been using the XML flavor, but want to switch to the more robust SOAP API. Unfortunately, their documentation is pretty unorganized and I can't find any sample code on the web. I can't be the first one doing this. Anyone? Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: other companies and developers to watch out for
That's freakin' hilarious! Please don't go! This I better than anything on TV! On Feb 3, 2011, at 11:17 AM, Michael Firth mftr...@att.net wrote: Please consider this a retraction of my previous statement and an apology to those who feel they have been harmed. Under the threat of legal action I cannot bear to put my family through that, so I must ask those who feel such steps are necessary to call it off and consider this my full apology. Also, let be noted that I have filled out a contact form request to remove me fully from this list because I wish no longer to be a member. This was done yesterday prior to the thread in questioned,but yet I am still waiting. There will be no more and that is a guarantee. Michael Firth Sworn on this date of Feb 3 2010 I ve accepted the fact that I will not probably get another job from this list so you know what who cares. So i might as well empty the closet on all those who I think have done a lot of damage to our career field. companies and developers to watch out for mediaspa - for whatever reason if you get on their bad side watch out colony1 - i ve added mr. adams company because he made an attempt at trying to crucify me in a public arena. i tried apologizing to no avail. i have also worked for adam in the past. i always thought we parted ways on a good note. guess i was wrong. talk about grudges. topofmind - this is an atlanta company that asked to interview twice then said we change our minds even though they told me they were going to hire me. heck i tried apologizing too even though they wronged me. oh well. elliot kayne - another gentleman that said he would hire me then backed out. wish you guys would make up your mind. by the way he runs onlinecorp.com and quickcart.com. watch out he will string you along too. superwarehouse.com - rand will talk to you but wont return your emails once hes made up his mind. ken fergurson - wow . an oldie but goodie. even had a few people asked about him. hope you didnt ruin your career either. maureen with a gmail address - another attempt at crucifying me. seems like a double standard here. you tell me i am disturbing you but you call me out in public too. I do want to thank the gentleman at Adobe who will remain nameless for the free copy of cfbuilder. Alas it wasn't meant to be. I do think there are more good people than bad, but the bad do leave an odor. So anyone who may have a question regarding the above I will give my perspective. I know i also hear from some of you but I dont really care because lets face i wont get a job from here and to be honest i dont think i want one. Mike Firth ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4445 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Text Databases
I've never had to set up an ODBC connection to a text file, but I am now. I have a file that is delimited with the pipe character (|). I have successfully set up the datasource, but CF can't seem to tell what the delimiter is. How do I do this? I can't seem to find information anywhere. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Text Databases
It's in the ODBC driver setup. In windows DS administrator, click Configure, use the options define format buttonthen choose custom delimited. Perfect... Thanks! Steve My Inbox is protected by SPAMfighter 16127 spam mails have been blocked so far. Download free www.spamfighter.com today! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Double Messages?
At about noon today I started receiving 2 of every message. Am I all alone? Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Login/Password screen
Here's the basic concept... You have a login page. The user puts their username and password in and it submits to an action page that checks to see if they are a user. You then set a variable (I usually use session variables). Then you check for that session variable on the pages that are protected. Typically, I have everything that they need to log into put in a separate folder. Then I have code in the application.cfm to say that if the path is to the protected folder, check for the variable otherwise redirect to the login page. Any shortcut to the secured data will redirect them to the login page if they are not logged in. As far as locking out... set a variable on each failed login and increment it by one until they hit 3. Once they hit three, check that variable in the login page and redirect them or give them a message that they have been locked out. You can use a cookie to expire in 30 minutes or however you want to do it. This is just the basic idea to get you thinking in the right direction. If you just want someone to do it for you, then just ask and I'll send you the code (and the bill ;-)) HTH, Steve -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:16 AM To: CF-Talk Subject: RE: Login/Password screen That part is no problem. Its what I need to put into the application.cfm to timeout or after 2-3 attempts lock the user out. Also once they log in they might drag a shortcut to their desktop which would bypass my index.cfm in the root that has the authentication code. How can I force them to the login screen everytime regardless if they dragged a shortcut? On Fri, 13 Dec 2002 13:10:45 -, Craig Dudley wrote: That's quite simple to code yourself, why don't you give it a try and post any questions here if you get stuck? Just pass a username and password from a from into a query, if a matching record is found, the queries record count will be 1 and you can authenticate the user, that's quite simplistic but basically all you need. Have a go, you know you want to ;-) -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 13 December 2002 12:43 To: CF-Talk Subject: Login/Password screen Hi, I know there are alot of custom tags out there that will do what I'm looking for but I want the best one. So this is why I'm asking all of you hoping you've had some experience with some of them. I'd like everything stored in a database. I know some don't do that. Bascially, once the user enters in their username/password they are redirected to a URL on the server based on the authentication. I have one called CF_EzPassword but was wondering if there are any better ones? Thanks --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Login/Password screen
Thanks for your insight, Jochem. My rhetoric was describing the basic concept and was meant to get [FlashGuy] thinking in the right direction. I didn't realize we were being graded. Ahh.. I sure miss the good old days when I knew it all! Steve -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:43 AM To: CF-Talk Subject: RE: Login/Password screen Quoting Steve Reich [EMAIL PROTECTED]: Here's the basic concept... You have a login page. The user puts their username and password in and it submits to an action page that checks to see if they are a user. Why a login page? Why an action page? You can also make every page a login page and every page an action page by putting the relevant code in the Application.cfm. And if you combine that with HTTP authentication even submitted formfields will persist. Also, check the manual on cflogin. You then set a variable (I usually use session variables). Then you check for that session variable on the pages that are protected. Typically, I have everything that they need to log into put in a separate folder. Then I have code in the application.cfm to say that if the path is to the protected folder, check for the variable otherwise redirect to the login page. Any shortcut to the secured data will redirect them to the login page if they are not logged in. As far as locking out... set a variable on each failed login and increment it by one until they hit 3. Once they hit three, check that variable in the login page and redirect them or give them a message that they have been locked out. You can use a cookie to expire in 30 minutes or however you want to do it. Cookies = client-side = insecure Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
SQL UBound?
I'm looking for the SQL function that will return the highest value in a column. I have a field that is the datatype 'decimal' and I want to return the record with the highest value in that column. Can someone help me? Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: SQL UBound?
Perfect! Thanks Sean. Steve -Original Message- From: Alford, Sean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:46 AM To: CF-Talk Subject: RE: SQL UBound? Steve, I think you are looking for the aggregate function max(). SELECT MAX(COL) FROM TBL Sean -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 8:37 AM To: CF-Talk Subject: SQL UBound? I'm looking for the SQL function that will return the highest value in a column. I have a field that is the datatype 'decimal' and I want to return the record with the highest value in that column. Can someone help me? Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
CF Error: The request has exceeded the allowable time limit
I keep getting the following errors for no apparent reason The request has exceeded the allowable time limit Tag: CFQUERY ..or... The request has exceeded the allowable time limit Tag: CFOUTPUT It isn't taking along time or doing anything special. Almost seems more like a connction issue from my machine to the server. How can I fix this or catch it? Thanks, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: MX Hosting
I use hostmysite.com and have had good luck with them. Great support with no waiting and pretty cheap too Steve -Original Message- From: Robert Bailey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 6:52 PM To: CF-Talk Subject: MX Hosting This is a multi-part message in MIME format. --=_NextPart_000_0065_01C29BAD.12311810 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I need to move a client over to MX and wondering if anyone knows of any good companies that offer MX hosting that they have had good experiences with. Rob --=_NextPart_000_0065_01C29BAD.12311810 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable html xmlns:o=3Durn:schemas-microsoft-com:office:office = xmlns:w=3Durn:schemas-microsoft-com:office:word = xmlns=3Dhttp://www.w3.org/TR/REC-html40; head META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; = charset=3Dus-ascii meta name=3DProgId content=3DWord.Document meta name=3DGenerator content=3DMicrosoft Word 10 meta name=3DOriginator content=3DMicrosoft Word 10 link rel=3DFile-List href=3Dcid:[EMAIL PROTECTED]; !--[if gte mso 9]xml o:OfficeDocumentSettings o:DoNotRelyOnCSS/ /o:OfficeDocumentSettings /xml![endif]--!--[if gte mso 9]xml w:WordDocument w:SpellingStateClean/w:SpellingState w:GrammarStateClean/w:GrammarState w:DocumentKindDocumentEmail/w:DocumentKind w:EnvelopeVis/ w:Compatibility w:BreakWrappedTables/ w:SnapToGridInCell/ w:WrapTextWithPunct/ w:UseAsianBreakRules/ /w:Compatibility w:BrowserLevelMicrosoftInternetExplorer4/w:BrowserLevel /w:WordDocument /xml![endif]-- style !-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:Times New Roman; mso-fareast-font-family:Times New Roman;} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle17 {mso-style-type:personal-compose; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} -- /style !--[if gte mso 10] style /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:Table Normal; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:Times New Roman;} /style ![endif]-- /head body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in' div class=3DSection1 p class=3DMsoNormalfont size=3D2 face=3DArialspan = style=3D'font-size:10.0pt; font-family:Arial'I need to move a client over to MX and wondering if = anyone knows of any good companies that offer MX hosting that they have had = good experiences with. o:p/o:p/span/font/p p class=3DMsoNormalfont size=3D2 face=3DArialspan = style=3D'font-size:10.0pt; font-family:Arial'o:pnbsp;/o:p/span/font/p p class=3DMsoNormalfont size=3D2 face=3DArialspan = style=3D'font-size:10.0pt; font-family:Arial'Robo:p/o:p/span/font/p /div /body /html --=_NextPart_000_0065_01C29BAD.12311810-- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Stripping end of cfhttp.filecontent
Try this cfhttp URL=#WWURL# method=get resolveurl=true/cfhttp cfscript // Replace link colors and rename content color = ReReplace(#cfhttp.filecontent#, 800854, 99, All); // Modify all links to second agent page with variable links = ReReplaceNoCase(#Variables.color#, http://url.domain.com/ppp97n260/;, pp2.cfm?id=, All); // Find point in content to strip to from beginning of file count = Find('/NOBR P NOBR', #Variables.links#) -1; // Remove from beginning to the above point postlist = RemoveChars(#variables.links#, 1, #Variables.count#); // Display everything left of the /form tag. postlist=left(postlist, findnocase(/form, postlist) -1); /cfscript cfoutput #postlist# /cfoutput HTH, Steve -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:32 AM To: CF-Talk Subject: Stripping end of cfhttp.filecontent This is probably a really easy and dumb question. I have a page that grabs another page and strips most of the ads, images, and unnecessary information. Then it displays the bulk of the page. At the end are more ads and unnecessary junk I'd also like to stip off, but I'm not sure how to do that. Here is the code that I have so far that is just missing the stripping from a certain point (for example after a /FORM tag, I'd like to strip to the end of the content). Help? Thanks! Cathy *** cfhttp URL=#WWURL# method=get resolveurl=true/cfhttp CFSET color = ReReplace(#cfhttp.filecontent#, 800854, 99, All) !--- Replace link colors and rename content --- CFSET links = ReReplaceNoCase(#Variables.color#, http://url.domain.com/ppp97n260/;, pp2.cfm?id=, All) !--- modify all links to second agent page with variable --- cfset count = Find('/NOBR P NOBR', #Variables.links#) -1 !--- find point in content to strip to from beginning of file --- CFSET postlist = RemoveChars(#variables.links#, 1, #Variables.count#) !--- Remove from beginning to the above point --- !--- Post what's left --- cfoutput #postlist# /cfoutput ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Writing a file with CFFILE
Yes...it is. I am using just as you described and it is perfect! Thanks, Steve -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 10:51 AM To: CF-Talk Subject: RE: Writing a file with CFFILE Used properly, HTMLEditFormat() does not change the content. If you type Hello Goodbye, into a form field, once submitted, it becomes: Hello Goodbye So, this is what you insert into the database. Now, when you *display* the contents of that form field, *if* you *don't* want the browser to parse it, then use HTMLEditFormat(). For instance, let's say we let the user edit that text again in a form field. Using HTMLEditFormat() within the value attribute of a form field, you will get: quot;Hello amp; Goodbyequot; *But* when the form is submitted, you get: Hello Goodbye Using HTMLEditFormat() *is* the perfect, easy solution! -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 7:36 AM To: CF-Talk Subject: RE: Writing a file with CFFILE You mean enabled -- or doesn't disable js... This is true -- but it's the only way I know of to preserve the original format of the text, including html, and allow it to be updated after the fact. HTMLEditFormat() or any other kind of string manipulation going into the form field will change the content in some way after the first edit. So there really is no perfect solution -- either you lose the original format, or you rely on javascript which could potentially be disabled. Unless the client has JS disabled. Then this method won't work at all. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 11:07 PM To: CF-Talk Subject: RE: Writing a file with CFFILE Not necessarily. Assuming you want to be able to enter text areas and the like (or any html actually) in your textarea, using htmledit format will allow you to enter it once -- but never update it after the fact because when you save it the 2nd time, it's no longer html code. The email I just sent off a moment ago explains a method (afaik the only method) of preserving the content in its original format, so it's still viable as html even after it's been saved several times. Nevermind... I'm an idiot over thinking the basics... HTMLEditFormat()..! hehe, Steve -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 9:26 PM To: CF-Talk Subject: RE: Writing a file with CFFILE I'm guessing you're using MX ... Probably using setEncoding() whether you specify ISO latin or UTF-8 on the form scope on the action page will resolve the issue... I'd likely place it in the application.cfm and apply it to both form and url. Thanks! That fixed that problem. I have another one now If I call a file like this... cffile action=READ file=#page# variable=output . then display it like this textarea name=contentscfoutput#output#/cfoutput/textarea . I run into a problem if the variable output has a textarea tag contained within it. It sees the closing textarea tag in the output variable as the closing tag for the textarea used to display the variable. All code after the closing textarea is executed in the browser. Example: output = textarea name=fooThis is some text/textareabrThen some other stuff textarea name=contents'cfoutput#output#/cfoutput/textarea .equals textarea name=contents'/textareabrThen some other stuff/textarea I get a textarea with this: textarea name=fooThis is some text Then some other stuff. Kind of a bitch to explain. Help! TIA, Steve ~~~ ~~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid =4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http
RE: Writing a file with CFFILE
Actually yes. Run this code in a blank page and save all day. Check the results in studio. As was my original problem, you are over thinking this. This is exactly what HTMLEditFormat() was designed for. Hope this clear up the confusion !--- Snip --- cfif isDefined('form.fieldnames') cffile action=WRITE file=#PATH_TRANSLATED# output=#form.display# addnewline=Yes /cfif cffile action=READ file=#PATH_TRANSLATED# variable=output form name=frmDisplay action=cfoutput#SCRIPT_NAME#/cfoutput method=post textarea name=display style=width:500px;height:400pxcfoutput#HTMLEditFormat(output)#/cfoutpu t/textareabr input type=submit value=Update /form !--- Snip --- Steve -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 1:05 PM To: CF-Talk Subject: RE: Writing a file with CFFILE umm... no ... Try this input type=text name=name value=#htmleditformat(myvar)# Then type 'Jim the Man davis' into that form field, drop it into a persistent variable or a database, retrieve it from that location and populate the form with it (as above), submit the form and save it to the same place. It _does_ change the content. You wind up with 'Jim quot;the Manquot; Davis' as your content. I've seen people sometimes use ReplaceNoCase() to convert quot; and other html entities into double-quotes on the action page, but then no-one can enter an html entity in the form field, because those get converted. It's a lose-lose situation. Same story with textareas. textarea name=myhtmlcfoutput#mytextarea#/cfoutput/textarea Do the same thing you did with the text field here, only instead of double-quotes, this time enter 'textarea name=somethingelse/textarea' into the field. After you've edited it once, you no longer have html content you now have lt;textarea name=quot;somethingelsequot;gt;lt;/textareagt; ... I don't make this stuff up. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 Yes...it is. I am using just as you described and it is perfect! Thanks, Steve -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 10:51 AM To: CF-Talk Subject: RE: Writing a file with CFFILE Used properly, HTMLEditFormat() does not change the content. If you type Hello Goodbye, into a form field, once submitted, it becomes: Hello Goodbye So, this is what you insert into the database. Now, when you *display* the contents of that form field, *if* you *don't* want the browser to parse it, then use HTMLEditFormat(). For instance, let's say we let the user edit that text again in a form field. Using HTMLEditFormat() within the value attribute of a form field, you will get: quot;Hello amp; Goodbyequot; *But* when the form is submitted, you get: Hello Goodbye Using HTMLEditFormat() *is* the perfect, easy solution! -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 7:36 AM To: CF-Talk Subject: RE: Writing a file with CFFILE You mean enabled -- or doesn't disable js... This is true -- but it's the only way I know of to preserve the original format of the text, including html, and allow it to be updated after the fact. HTMLEditFormat() or any other kind of string manipulation going into the form field will change the content in some way after the first edit. So there really is no perfect solution -- either you lose the original format, or you rely on javascript which could potentially be disabled. Unless the client has JS disabled. Then this method won't work at all. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 11:07 PM To: CF-Talk Subject: RE: Writing a file with CFFILE Not necessarily. Assuming you want to be able to enter text areas and the like (or any html actually) in your textarea, using htmledit format will allow you to enter it once -- but never update it after the fact because when you save it the 2nd time, it's no longer html code. The email I just sent off a moment ago explains a method (afaik the only method) of preserving the content in its original format, so it's still viable as html even after it's been saved several times. Nevermind... I'm an idiot over thinking the basics... HTMLEditFormat()..! hehe, Steve -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 9:26 PM To: CF-Talk Subject: RE: Writing a file with CFFILE I'm guessing you're using MX ... Probably using setEncoding
RE: Writing a file with CFFILE
to parse it, then use HTMLEditFormat(). For instance, let's say we let the user edit that text again in a form field. Using HTMLEditFormat() within the value attribute of a form field, you will get: quot;Hello amp; Goodbyequot; *But* when the form is submitted, you get: Hello Goodbye Using HTMLEditFormat() *is* the perfect, easy solution! -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 7:36 AM To: CF-Talk Subject: RE: Writing a file with CFFILE You mean enabled -- or doesn't disable js... This is true -- but it's the only way I know of to preserve the original format of the text, including html, and allow it to be updated after the fact. HTMLEditFormat() or any other kind of string manipulation going into the form field will change the content in some way after the first edit. So there really is no perfect solution -- either you lose the original format, or you rely on javascript which could potentially be disabled. Unless the client has JS disabled. Then this method won't work at all. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 11:07 PM To: CF-Talk Subject: RE: Writing a file with CFFILE Not necessarily. Assuming you want to be able to enter text areas and the like (or any html actually) in your textarea, using htmledit format will allow you to enter it once -- but never update it after the fact because when you save it the 2nd time, it's no longer html code. The email I just sent off a moment ago explains a method (afaik the only method) of preserving the content in its original format, so it's still viable as html even after it's been saved several times. Nevermind... I'm an idiot over thinking the basics... HTMLEditFormat()..! hehe, Steve -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 9:26 PM To: CF-Talk Subject: RE: Writing a file with CFFILE I'm guessing you're using MX ... Probably using setEncoding() whether you specify ISO latin or UTF-8 on the form scope on the action page will resolve the issue... I'd likely place it in the application.cfm and apply it to both form and url. Thanks! That fixed that problem. I have another one now If I call a file like this... cffile action=READ file=#page# variable=output . then display it like this textarea name=contentscfoutput#output#/cfoutput/textarea . I run into a problem if the variable output has a textarea tag contained within it. It sees the closing textarea tag in the output variable as the closing tag for the textarea used to display the variable. All code after the closing textarea is executed in the browser. Example: output = textarea name=fooThis is some text/textareabrThen some other stuff textarea name=contents'cfoutput#output#/cfoutput/textarea .equals textarea name=contents'/textareabrThen some other stuff/textarea I get a textarea with this: textarea name=fooThis is some text Then some other stuff. Kind of a bitch to explain. Help! TIA, Steve ~~~ ~~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid =4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~ ~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index. cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives
Writing a file with CFFILE
I have a code editor I've written that uses cffile to grab a cf page and put it in a textarea. Then I can edit my cf code and save it by writing back to the file using cffile. Everything seems to work fine except with the non-braking spaces character (nbsp;). It replaces all nbsp; with a  (alt+0194) character. Can someone shed some light on this problem and a solution? TIA, Steve Reich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Writing a file with CFFILE
I'm guessing you're using MX ... Probably using setEncoding() whether you specify ISO latin or UTF-8 on the form scope on the action page will resolve the issue... I'd likely place it in the application.cfm and apply it to both form and url. Thanks! That fixed that problem. I have another one now If I call a file like this... cffile action=READ file=#page# variable=output .. then display it like this textarea name=contentscfoutput#output#/cfoutput/textarea .. I run into a problem if the variable output has a textarea tag contained within it. It sees the closing textarea tag in the output variable as the closing tag for the textarea used to display the variable. All code after the closing textarea is executed in the browser. Example: output = textarea name=fooThis is some text/textareabrThen some other stuff textarea name=contents'cfoutput#output#/cfoutput/textarea ..equals textarea name=contents'/textareabrThen some other stuff/textarea I get a textarea with this: textarea name=fooThis is some text .Then some other stuff. Kind of a bitch to explain. Help! TIA, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Writing a file with CFFILE
Nevermind... I'm an idiot over thinking the basics... HTMLEditFormat()..! hehe, Steve -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 9:26 PM To: CF-Talk Subject: RE: Writing a file with CFFILE I'm guessing you're using MX ... Probably using setEncoding() whether you specify ISO latin or UTF-8 on the form scope on the action page will resolve the issue... I'd likely place it in the application.cfm and apply it to both form and url. Thanks! That fixed that problem. I have another one now If I call a file like this... cffile action=READ file=#page# variable=output . then display it like this textarea name=contentscfoutput#output#/cfoutput/textarea . I run into a problem if the variable output has a textarea tag contained within it. It sees the closing textarea tag in the output variable as the closing tag for the textarea used to display the variable. All code after the closing textarea is executed in the browser. Example: output = textarea name=fooThis is some text/textareabrThen some other stuff textarea name=contents'cfoutput#output#/cfoutput/textarea .equals textarea name=contents'/textareabrThen some other stuff/textarea I get a textarea with this: textarea name=fooThis is some text Then some other stuff. Kind of a bitch to explain. Help! TIA, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Other Mailing lists
Try http://www.aspfriends.com... HTH, Steve -Original Message- From: Fregas [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 1:56 PM To: CF-Talk Subject: OT: Other Mailing lists This is way off topic, but does anyone know of some mailing lists similar to CFTALK but for Java, C# and/or ASP.NET? CFTalk has served me so well over the years because of the high level of activity and the high level of intellect of everyone on here. However, I'm trying to learn both .NET and Java and would like to know if anyone has found similarily good mailing lists for those. I've looked on topica but they are kind of lame--not much activity in most cases. Any recommendations? Thanks, Fregas ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Preventing URL Display in Status bar
Is there a way to stop the status bar from displaying the URL / path when the pointer is over a hypertext link on a website. Use JavaScript a href=index.cfm?fuseaction=home onmouseover=window.status='Click for home page...'; return true onmouseout=window.status=''; return trueHome/a . this will put the text 'Click for home page...' in the status bar instead of the URL. HTH, Steve ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Javascript Anyone?
I know this is a little off topic, but does anyone know how to disable CTRL+N and F11 in IE??? I'm not sure about the CTRL+N key combination, but this script will disable the F11 key in IE... the only catch is that you have to stop bugging the CF community with Javascript questions and join us all over at JS-Jive where we are dedicated to helping developers with their javascript woes. You can subscribe by sending a blank email to mailto:[EMAIL PROTECTED]. I invite anyone using javascript to join. Now, on to the code !--- This will disable the F11 key in IE --- script function CheckMyKeys(){ var key = event.keyCode; if (key==122){ // F11 key, do something then cancel return cancel(); } // Inline cancel function function cancel(){ event.cancelBubble=true; event.keyCode=0; return false } } document.onkeydown = CheckMyKeys /script !--- END --- HTH, Steve ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: asp vs. cf
My boss just asked me for a list of pros and cons. I want to show him that CF is superior to ASP, but I don't know ASP. If you guys could help with my list I'd appreciate it. I will add to this by saying that I am a CF programmer at heart, but I am presently working on an ASP application. Cold Fusion is faster, easier, and probably more scalable to use, yes, no doubt about it. But it does effect you as a developer by hiding the real guts of what's happening. You can be the world's greatest CF programmer, but if that's all you know, then you are severely limited in the services you can provide. I would even go as far to say that you're not *really* even a programmer. You are just a glorified software operator. (I am using 'you' collectively and not singling you out. It applies to all of us.) Programming, in any language involves two key concepts: logic and syntax. Cold Fusion will teach you logic. But it does not teach you syntax. From that perspective, Cold Fusion tricks you into thinking you are a master programmer. I jump at the chance to program in ASP or JSP simply because it improves my own personal skills and, in turn, my marketability. I think of it as paid training. Yes, I bitch (to myself) the whole way through about how much easier it is with CF. But in the end, I am versatile. If the platform decision falls on my shoulders, then I recommend CF for all the reasons everyone else will tell you. But if someone else makes the decision, I am prepared. I guess in the end, it depends on what your own personal and professional goals are. But I personally, don't want to be bound by any one development platform. FWIW, Steve ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VTM Files
Thanks for the help. I solved my problem but am still looking for more information on creating VTM files. Do resources (websites, books, etc..) exist for these or is the documentation (rather shallow) with CF Studio all there is...? Thanks, Steve ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
VTM Files
Does anyone know of any online resources for writing .vtm files? Specifically, I'm looking for a way to have a color picker popup for the user to select a color. Thanks, Steve ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: VTM Files
Ummm...are you talking CF Studio? It already has a colour picker built in I realize that, but when the user selects 'Edit Tag' and pulls up the tageditor dialog, I want them to fill one of the fields with a color value. How can I access the color picker from within the VTM? Thanks, Steve ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL 5.0
Does CFMAIL simply not work in CF5? Everything appears normal, but the messages are never received. I confirmed connection from CF Server to the mail server. It spools the mail to the Spools folder and then appears to send it out, emptying the spools folder. No undeliverables, but no logs either. They are going somewhere, but I can't figure it out maybe CFMAIL was changed to CFDELETE? It's obviously buggy by the previous posts, but is there a workaround? Macromedia doesn't seem to address the problem. What's everyone else doing? Thanks, Steve ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: New Discussion List
Excuse the intrusion, but I thought this might be relevant to all of us IT-Talk is a new discussion list formed by the people who brought you JS-Jive (http://groups.yahoo.com/group/JS-Jive) and the RIMZOO Developer's Forum (http://groups.yahoo.com/group/RIMZOO)! IT-Talk is a group for the open discussion of all things Internet Technology related. From web server software, programming languages, internet related issues, wireless web, web statistics, browser wars, etc. If it pertains to the web, then it's fair game. This group serves as an overflow buffer to other programming and internet discussions that may be off topic for your other discussion groups. SPAM is not permitted. If you would like to join, send a blank email to mailto:[EMAIL PROTECTED] or visit the home page at http://groups.yahoo.com/group/IT-Talk. We are eagerly looking forward to your participation and contributions! Thanks, Steve Reich Moderator, IT-Talk ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Javascript Validation Coldfusion ?
First I recommend you send a blank email to [EMAIL PROTECTED] and join JS-Jive, the javascript list. You'll get lots of help with Javascript. But to answer your question, you need to access the selectedIndex property of a select box to validate it script function validateSelect(){ if (document.form.fieldname[selectedIndex].value == ){ alert(Please select an option in the select box.); return false; } } /script onsubmit=return validateSelect() This assumes that you have an option in the select box with an empty value... option value=(select option) HTH, Steve [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi How do you add validation to drop down form select boxes using Javascript. I have added validation (shown below in the js) for the two text input fields but need to build in validation for the two select boxes and also a CFFile field as these are required fields in the form, any ideas on how to integrate this into what I have below? SCRIPT LANGUAGE=JavaScript !-- Begin function checkFields() { missinginfo = ; if (document.form.filename.value == ) { missinginfo += \n - Title of the File Uploaded; } if (document.form.filesummary.value == ) { missinginfo += \n - Descriptive Summary of Uploaded File; } if (missinginfo != ) { missinginfo = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (SQL) Selecting Random Record From Database
Someone posted this idea a while back. SELECT TOP 1 employee_id, newid() as new_id FROM yourtable CC That pulls the first1 record from the database. This will pull the first 1000 records... SELECT TOP 1000 employee_id, newid() as new_id FROM yourtable I need a random record. Isn't there a rand funcion in SQL perhaps something like SELECT Rand(employee_id) as RandomRecord FROM yourtable Seems like there's gotta be a simple solution. Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: test if Java is on
how can you test to see if the user has Java Scripting turned off? Join JS-Jive and ask the question there. (Just send a blank email to [EMAIL PROTECTED]) Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(SQL) Selecting Random Record From Database
How do I select a single, truly random (random seed) record from my database? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Marking Email Messages 'Read' with CFPOP
I am using iMail (6.0 I think). Is there anyway I can mark a message on the server as 'Read' using CFPOP? The iMail web interface seems to know what messages have been read. How can I do this with CF? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Kill all cookies
How do I kill all cookies at once? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Javascript Questions Answers
I've noticed a lot of javascript posts lately and wanted to remind everyone about the JS-Jive javascript group. There are nearly 1100 developers on the list and it's proven to be an excellent resource for Javascript questions. The list was spawned from this one and there are many, many CFers on the list as well. You can join by sending a blank email to mailto:[EMAIL PROTECTED] The home page with more information is at http://groups.yahoo.com/group/JS-Jive Hope to see you all there! Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Printing CFEXECUTE
On Windows2000, I have successfully used: print /d:\\server\printer x:\path\filename I'll give that a try. Thanks, Tony! Steve ~~ 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: Meta Tags for search engines and verity
I have found that meta tags vary in importance on the various search engines. What I typically do is a search using the keywords I would expect users to use. Then I take a look at the sites that come up first and try to determine why. Sometimes it's obvious, other times it's oblivious. This has been very successful for us. In fact, if you search for cold fusion ecommerce on google.com, our site proudly comes up first. I have never had the luxury of such a great ranking. However, the same search on other search engines does not yield the same results. Perhaps the whole search engine thing is a government conspiracy ...?? HTH, Steve Robert Everland [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am developing a pretty important site from scratch and was curious to see what everyone out there recommends me with regards to meta tags so that the search engines love them and verity doesn't choke on JavaScript code. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire ~~ 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 - Allaire website
Is anyone else getting *very* slow searches on the Dev-Exchange site? Allaire's ColdFusion is slightly slower than Macromedia's ColdFusion. Positioning your tongue on the right side of your mouth while clicking the form buttons will help some, but keeping your Dev Exchange searches limited to the second Tuesday of each week is the only real work around. It's a known issue and addressed in the support section. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Printing CFEXECUTE
What's the command line parameter and flag to print a document? Can I choose the printer or is default all I get? I want to use it with CFEXECUTE to print to the web server's printer on our Intranet. Thanks, Steve ~~ 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: Ordering query results
Two ways to do it... first, is Nate Weiss' CF_QuerySort tag... a definite must have for any CFer's toolbox... you can get it here http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3470F8-2830-11D4-AA 9700508B94F380method=Full But you might try something like this... ~~ 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
Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]
I am having a problem with the encrypt/decrypt functions. Here is my code: *** This creates the user when they register... cfset dbPassword=#Encrypt(password, application.seed)# cfquery name=CreateUser datasource=#application.dsn# username=#application.dsn_username# password=#application.dsn_password# INSERT INTO users (fname,lname,email,username,password) VALUES('#fname#','#lname#','#email#','#username#','#dbPassword#') /cfquery *** This validates a registered user cfset dbPassword = #Encrypt(password, application.seed)# cfquery name=CheckUser datasource=#application.dsn# username=#application.dsn_username# password=#application.dsn_password# SELECT userid FROM users WHERE username='#username#' AND password='#dbPassword#' /cfquery The problem is that if I output the encrypted password on my page, I get... (6 W=SO*;E^JD The field in the DB says... (6 W=SO*;E^H Obviously, they don't match, so the user can't get in. I've tried using a variety of seed values, including various lengths. It seems that the last one or two chars always come out differently? My questions are, what is a good length for the seed value and should this be alphnumeric or will any ascii character work? Also, I'm not sure why I can encrypt the same value twice and not get the same value. I'm thinking my problem must be in the seed string length, but I'm not sure? Are there known issues with this? Why am I having this problem? Can someone shed some light? Thanks, Steve ~~ 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: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]
Also, I'm not sure why I can encrypt the same value twice and not get the same value. I'm thinking my problem must be in the seed string length, but I'm not sure? Are there known issues with this? Why am I having this problem? Can someone shed some light? After a little more trial and error, it appears that the first 12 characters are consistant. Anything after that can change, even if encrypting the same string with the same seed value. I guess I can do something like.. if password = Left(dbpassword, 12) I would still appreciate a logical explanation of this if someone knows more about this Thanks, Steve ~~ 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: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]
Maybe it's just a wierd browser thing. What do you see if you View SOurce? No.. I checked that. It's very strange because there is no consistency to it. Some strings encrypt the same everytime, others don't. If I run this in my browser cfset encryptedPW = #Encrypt(password, k39dkjw*kd@kfoe%kfps037)# cfoutput#encryptedPW #-#Len(encryptedPW)#/cfoutput and then hit refresh... it toggles between these two values... (78XD6IF#J5( and (78XD6IF#J5' but it returns the Len of both strings as 14. Something with ASCII, either spaces or line feeds might be one of the chars that could be messing me up. In the database field (SQL7), visually you can see some box characters that represents an ASCII character that can't be displayed. Help!! Thanks, Steve ~~ 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: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]
cfif form.Login_Password NEQ Decrypt(LoginAction.Password, key) cfset Error = Invalid UserID and Password. cfelse Dick, That did the trick! I was trying to compare two encrypted strings and I should have been comparing their decrypted values. Thanks for the help it was driving me nuts! Steve ~~ 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
Application Variables
Seems basic, but I've never really addressed this. Assuming this code is in my application.cfm file, what is the difference in these two cfset bgcolor=black and... cfset application.bgcolor=black I guess I need a quick lesson on application variables. I know they are included in the scope defined in the cfapplication tag, but what are pros and cons? I have a small dev box with only 256 RAM. I have CF 4.5 and SQL7 running on it so as you can imagine, it's quite slow. I'm wondering how much RAM is used storing application variables? Could I increase performance (albeit more theoretically) by not using application vars? If I am looking for server performance over speed, the first one seems the way to go since it's not a persistent variable. I'm only faking it by putting it in the app.cfm file. Along this line, do I even need application variables? What's the story? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Trim Question
Try #Trim(OutputVariable)#. Otherwise, you will need to go into your custom tag and figure where the code is adding the spaces. It's not a problem of CF Server adding the spaces. HTH, Steve Brian Scott Barnett [EMAIL PROTECTED] wrote in message 000701c100df$c9b69e20$[EMAIL PROTECTED]">news:000701c100df$c9b69e20$[EMAIL PROTECTED]... For some reason, a custom tag that I am using is adding beginning and trailing spaces to the output. Does this happen when the tag takes a little while for the CF App server to process? It's causing a display issue in some versions of Netscape. Any idea how I might be able to trim the spaces? The code calling the custom tag is: cfmodule template=./customtags/flasher5.cfm flash_src=flash/spotlight_new.swf flash_width=168 flash_height=213 flash_quality=high flash_bgcolor=white flash_loop=yes image_src=images/home_page/home_page_3-3.gif image_width=168 image_height=213 image_border=0 image_alt=Spotlight Thanks! Brian 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: Spell Checking a Textarea Field
http://www.spellchecker.net/ is quite good. Wow! That is very cool (and cheap)... thanks! Steve ~~ 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
Attachments CFPOP
Is there a way to detect an attachment without having to download it to the server? If a user has a 2 mb attachment, and 50 email messages, it's going to be a while I want my users to see that there is an attachment, but only download if they choose to. Is there a work around? Thanks, Steve ~~ 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
Spell Checking a Textarea Field
How can I have my users spellcheck a textarea? Thanks, Steve ~~ 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
Counting Sessions
How does a web site know that there are 26 users on our site right now... oh, wait, now 27?? Steve ~~ 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
Retrieving Multiple Attachments w/CFPOP
Seems like I just did this 5 years ago, but I'm writing a CFPOP application and am having trouble when there is more than one attachment. The docs say that it should return a tab delimited list of the attachments, but I am only getting the first one returned. Can anyone offer a suggestion? Thanks, Steve ~~ 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: Counting Sessions
Thanks Dylan. That's kinda what I figured it had to be. I could think of no way to do it accurately with some sort of database logging. Does anyone know of how this information could be accessed with CF? Sounds like a good project for all you CFXers! I'll BETA test when it's ready! ;-) Steve Dylan Bromby [EMAIL PROTECTED] wrote in message 000c01c0ff3a$9808bf30$6401a8c0@bromby">news:000c01c0ff3a$9808bf30$6401a8c0@bromby... the specifics depend on the OS, but generally speaking, the web server's open threads/processes are counted. -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 11:41 AM To: CF-Talk Subject: Counting Sessions How does a web site know that there are 26 users on our site right now... oh, wait, now 27?? Steve ~~ 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: STILL CAN NOT GET CF-TALK EMAIL
I can send to the group, and I can see my email show up in the archive, but I have been getting nothing for days. Michael what is going on. You said yesterday on js-jive it would be fixed within the day. It's been just about 24 hours since you said that and I haven't gotten anything. Please help. Sounds like you are about ready for CF-Talk Anonymous but, first you must admit you have a problem... ;-) ~~ 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: Where to place developer exchange tags?
Place it in the Custom Tag directory. It's C:\CFUSION\CUSTOM TAGS by default. If it's a cfx (.dll) then you need to register it with CF Server. You can also place the .cfm tag in the directory of the templates you are using it in. But if you have multiple sites on a server that use the tag, it's more practical to put it in the Custom Tag directory. HTH, Steve Daniel [EMAIL PROTECTED] wrote in message news:3b3389c4$[EMAIL PROTECTED]... I just downloaded the cf_back_fwrd tag from the developers exchange. Where do I place this tag in reference to the server and development machine. thanks daniel ~~ 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
Code Check...
Here's my code. cfscript if (HTTP_USER_AGENT CONTAINS Mozilla AND HTTP_USER_AGENT DOES NOT CONTAIN Gecko AND HTTP_USER_AGENT DOES NOT CONTAIN MSIE) BROWSERTYPE=NS; else BROWSERTYPE=MSIE; /cfscript I am using this to detect the browser type. I am only worried about NS or MSIE. This basically says that if it's NS6 treat as NS, otherwise if it's MSIE, NS6, or anything else, treat as MSIE. I'm only using it to determine style elements. I've been using CF_Browser in the tag gallery but it is too bloated for my needs. Are there any holes here or obvious blunders that I haven't considered? Thanks, Steve ~~ 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
CFSCHEDULE User Agent
I just figured out something interesting and useful... If you have a template that is fired using CFSCHEDULE, it will have the cgi.http_user_agent string CFSCHEDULE. With that, you can prevent the template from running if you only want it executed by the scheduler... I have some database maintenance templates, but I didn't want anyone to be able to run them in a browser. This seems like a good way to protect them Thought it was worth sharing... Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: RIM / Go.America Support Forum
Hello developers Due to a lack of peer resources, I have started a mailing list specifically for those developing web content for the RIM 850/950 Pager and RIM 857/957 Handheld. This is primarily focused towards development on GoAmerica's Go.Web platform, but not limited to such. Topics include integration with application servers (such as CF, ASP, PHP, CGI), graphics, layout, user security, navigation, session strategies, etc. I would highly recommend to anyone doing development for these devices to come and join me at RIMZOO! Home Page: http://groups.yahoo.com/group/RIMZOO Post message: [EMAIL PROTECTED] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] For more information on the Go.Web SDK and RIM emulator, check out http://www.goamerica.net/partners/developers/. Please pass this on to anyone who you feel may benefit from it. If you have questions or comments, please feel free to contact me off list. Thanks, Steve Reich ~~ 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: SOLVED: This should be simple--why is it not working?
Somehow CF sees the year as being 1905 when I wrap dateformat around it [#dateformat(2001, 'YY')#]! CF was correct! 2001 is the numeric value of the date 06/23/1905. Here's a quick lesson on numeric date (and time) values DateFormat(6/14/2001, YY) would output 01 DateFormat(2001, YY) would view 2001 as the numeric value of a date which would be 2001 days past Dec 30, 1899 or 06/23/1905, hence your returned year value of 1905. If you do a number format on a date such as NumberFormat(6/14/2001) you would get 37,056 returned as the value (37,056 days past Dec. 30, 1899). The same is true for the time which is returned in a decimal format. So if you did NumberFormat(Now(), _.__) you would get 37056.5117245370. This value equals {ts '2001-06-14 12:16:53'} as a date. Then to convert these back starting with 37056.5117245370... #DateFormat(37056, mm/dd/yy)# to get 06/14/01 and #TimeFormat(.5117245370, h:mm tt)# to get 12:16 PM You can also do it with the complete value... #DateFormat(37056.5117245370, mm/dd/yy)# to get 06/14/01 and #TimeFormat(37056.5117245370, h:mm tt)# to get 12:16 PM or for code to run in your browser !-SNIP-- cfscript MyValue = #NumberFormat(Now(), _.__)#; MyDate = #DateFormat(ListFirst(MyValue, .), mm/dd/yy)#; /* Be sure to add the decimal back in the first parameter of the TimeFormat() function */ MyTime = #TimeFormat(. ListLast(MyValue, .), h:mm tt)#; /cfscript cfoutput Serial Value: #MyValue#br Date: #MyDate# (would output 06/14/01 and...)br Time: #MyTime# (would output 12:16 PM or the time you run this code) /cfoutput !-SNIP-- Try it! It really does work quite well. This is an old approach that I think was originally developed in spreadsheet applications. I have used this method with a calendar applications and it's an interesting approach to dealing with dates. It can get confusing, but it is extremely accurate and effective in calculating date differences once you get the hang of it. Better than DateAdd? This is yet to be debated, but at least you have a little more understanding of what was originally happening with your code. HTH, Steve ~~ 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
WinSysPath Variable(s)
Is there a variable that CF understands to map to the windows system folder? Here's what I'm trying to do... cffile action=READ file=$WinSysPath$\myeula.txt variable=eula What about the root folder and windows folder? My horoscope said these variables are not supported. I'm running IIS5 if that will gain me favor? Thanks, Steve ~~ 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: Any MS Access mailing lists half as good as this mailing list?
news://msnews.microsoft.com ... has all the information you can stomach! [EMAIL PROTECTED] wrote in message 001b01c0f400$a14eb080$[EMAIL PROTECTED]">news:001b01c0f400$a14eb080$[EMAIL PROTECTED]... Michael, Thank you for the years of hosting this GRAT list. Jeff Craig. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Can this be done? Flashy way??
if someone can point out on where I can find CF TAGS to build FLASH stuff (I don't know FLASH AT ALL!) I'll be happy! How about the CF_BuildFlashMovie tag? You just enter what you want the application to do and pass it your experience level with Flash and it will spit out a movie file and code for your page. CF_BuildFlashMovie specifications=I need it to build an application that will have audio integration, visual effects, images, text, everything for a visual project. Also must be able to edit and run clips on the fly ExperienceLevel=I don't know FLASH AT ALL!) cfoutput#FullyFunctionalAndRobustFlashApplicationWithAllTheBellsAndWhistle s#/cfoutput You can download it at http://www.i-wish-it-was-that-easy.com ... But seriously, Flash is much more than that. I would suggest you download the Flash trial and play around with that. Once you have created your Flash file, you can interact with it using CF, but this assumes you have an existing flash application to begin with. In playful jest... Steve ~~ 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: need some advice
First join JS-Jive at http://groups.yahoo.com/group/JS-Jive for all the Javascript help you can stand. But to answer your question, your best bet is to control the forms action depending on how the form in submitted (either through the submit button or the onchange event of the select box). You can find some good information on how to do this here... http://developer.irt.org/script/form.htm#7.2. HTH, Steve S R [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Everyone, I've been staring at my code to long and I'm stumped. I have a select menu (see below) that is being populated from a databse. My problem is, if a user chooses an option from the pull down menu it needs to also send the rest of my form variables to the next page. Right now, using the 'onChange' handler, its only send the ID variable within the 'option' tag. Now I know I can use the 'this.form.submit()' to accomplish this but I cannot use it because I need the page to go somewhere different when they press 'submit'. What would be cool is if I could dynamically change the form tag to go one place when they click submit and another if they choose an option from the pull down menu. I'm not well versed in Javascript, but I probably could do it through Javascript. Any help will do. Thanks function openURL(){ // grab index number of the selected option selInd = document.myForm.CompanyID2.selectedIndex; // get value of the selected option goURL = document.myForm.CompanyID2.options[selInd].value; // redirect browser to the grabbed value (hopefully a URL) top.location.href = goURL; } // end hiding script-- cfoutputselect name=CompanyID2 onchange=openURL()/cfoutput option value=/option cfoutput query=GetCompanies option value=index.cfm?ID=#ID# cfif IsDefined(ThisVar) AND FORM.CompanyID2 IS NOT ''cfif GetCompanies.ID IS FORM.CompanyID2selected/cfif/cfif#CompanyName#/option /cfoutput /select ~~ 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: JavaScript Help
How do I get JavaScript to evaluate tdID into its true value and not think that I'm refering to an object named tdID? I recommend to anyone that uses javascript in there applications to join the JS-Jive mailing list (just send a blank email to [EMAIL PROTECTED]). The list has over 900 members and a lot of CF programmers as well. It was started by a long time member of this list (me). It has proven to be an invaluable resource for Javascript questions. The home page for the group is at http://groups.yahoo.com/group/JS-Jive. HTH, Steve ~~ 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: Loan Calculator
I wrote a loan calculator tag that is in the tag gallery. Can't recall the exact name of it now, but I think if you search for Loan you will find several, including one from Ben Forta, etc. DC Excellent! That's exactly what I was looking for. I saw Forta's tag in there, but it was in Javascript and I needed it to be all server side. Thanks, Dave! Steve ~~ 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: Best way to return multiple records?
I have a query that returns anywhere from 1 to 1800 records. I've implimented a next/previous button but this keeps calling the query over and over again. Is there a way to return all the records and then process them using next and previous? I'm thinking something like a structure maybe? Yes... cache the query. You can use the cachedwithin attribute in your cfquery tag. This will cache your query on the server for the time span you set... this would cache the query for 5 minutes: cfquery name=GetRecords datasource=#DSN# cachedwithin=#CreateTimeSpan(0,0,5,0)# Setting the time span to 0 will un-cache the query. HTH, Steve ~~ 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
CF Wireless
Other than the CF-Wireless mailing list, is anybody aware of other wireless Cold Fusion resourecs such as tags, tutorials, etc... Thanks, Steve ~~ 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: WhoIs tag that returns a variable
What about using WDDX? Russel Madere [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hey all, I need a free WhoIs tag that will return the results as a variable, not as part of the HTML page. I looked at Lewis Sellars CFX_TCPIPClient tag and thought it was too complicated for what I need. The existing CFX_WhoIs by Distributed Data System is perfect, except it doesn't return the results as a variable. As an alternative, if someone who has written on that returns the HTML stream can provide the source, I can modify it myself to return a variable. TIA. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. ~~ 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: Dictionary/Thesaurus
You can buy the Mirriam Webster edition on CD... http://www.m-w.com/service/deluxc10.htm. In the mean time, try this... Include this javascript on your page and doubleclick any word this is a dictionary script, but could easily be edited for the thesaurus. Might not be what you are looking for, but it could be helpful in the meantime. It's a very cool script !SNIP- SCRIPT LANGUAGE=JavaScript !-- var NS = (navigator.appName == Netscape) ? 1 : 0; if (NS) document.captureEvents(Event.DBLCLICK); document.ondblclick = dict; var newwin; function dict() { if (NS) { t = document.getSelection(); opennewwin(t); } else { t = document.selection.createRange(); if(document.selection.type == 'Text' t.text != '') { document.selection.empty(); opennewwin(t.text); } } } function opennewwin(text) { if (text '') { newwin = window.open('http://www.m-w.com/cgi-bin/dictionary?book=dictionaryva='+text , 'dictionary', 'width=800, height=600, resizable=no, menubar=no, toolbar=no, scrollbars=yes, status=yes'); setTimeout('newwin.focus()', 100); } } // -- /script !SNIP- HTH, Steve ~~ 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: Downloading Files NOT in Webroot
What's wrong with creating a virtual directory...? CF-Talk [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... What is the best way to allow users to download from a collection of files that are not in the webroot but rather elsewhere on the server's file system. I don't want people to be able to snoop around the directories. Thanks in advance, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: Downloading Files NOT in Webroot]
You should be able to create a virtual directory to point to any directory on the server... regardless of the webroot... at least you can with IIS. Alex [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... cfcontent pointed to file NOT in webroot Steve Reich [EMAIL PROTECTED] wrote: What's wrong with creating a virtual directory...? CF-Talk [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... What is the best way to allow users to download from a collection of files that are not in the webroot but rather elsewhere on the server's file system. I don't want people to be able to snoop around the directories. Thanks in advance, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Compacting .cfm files
There used to be a tag called StripWhiteSpace or something like that. I just looked in the tag gallery and couldn't find it on my first pass. I would push to rethink your specs. The architecture of your page sounds like an endless pit of nightmares good luck! Steve Brian Fox [EMAIL PROTECTED] wrote in message 85321A4755BED211B3A600805FA70FB702EE8E82@NTXDISTRICT">news:85321A4755BED211B3A600805FA70FB702EE8E82@NTXDISTRICT... Sorry if this is beating a dead horse. A search of the archives brought up similar questions, but didn't really approach a solution. I have a form that contains as many as 200 select boxes with about 6 options each and 200 more input boxes. I guess that there is some type of resource crunch (memory, widget handles, who knows) that causes the following error: when scrolling a large form, the select boxes begin to smear vertically. They become clumped together and function oddly (some still seem to work, although I can't tell what 'line' they belong to). It's in the project specs that I cannot break the form up... which throws out the 'display records 1-20 21-40' type solutions. The only thing I can think to do is tighten the cfm code up. Our shop is indent happy for readability. The indenting produces a LOT of whitespace (perhaps bloating the code as much as 100%). I've already added cfsetting tags to squash output on custom tags, queries, etc. But there is still a lot of whitespace in the other 'normal' code. Are there any utilities to obliterate whitespace in cfm files? Er, something along the lines of turning an indented file into a really long single string? Is there a code beautifier to do the opposite? Is this approach worthwhile? Thanks, Brian ~~ 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
Writing Custom Functions
I already know the answer to this, but I thought I would see what it might inspire Is it possible to write a custom function? Here is an example of what I would like to be able to do. The following code limits the display of lname to 8 characters cfif len(lname) GT 8#Left(lname, 8)#...cfelse#lname#/cfif What I was wondering is if I could somehow create a function, and then call it like so (this is what I really want to know)... #StringLimit(lname, 8)# Maybe I've been playing around too much with Javascript, but this seems logical. I know I can write a custom tag... !StringLimit.cfm cfparam name=attributes.value default= cfparam name=attributes.limit default=0 cfparam name=attributes.tail default=... cfif len(attributes.value) GT attributes.limit#Left(attributes.value, attributes.limit)##attributes.tail#cfelse#attributes.value#/cfif ! Call it as a tag cf_StringLimit value=#lname# limit=8 tail=... Are there other guru secrets anyone wants to share on this topic? Thanks, Steve ~~ 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: Tracking Usage
Sorry about the OT post but I am a little stumped. I was wondering if anyone out there knows how to find out the following information about visitors to a web site: Screen Resolution: (ie. 1024x768, 800x600) Color Depth: (ie. 16-bit, 32-bit, 256 colors, etc...) For screen resolution and color depth you can use this javascript snippet (works in both browsers) ~SNIP~ script language=JavaScript!-- function GetSysInfo() { window.onerror=null; if(navigator.javaEnabled() (navigator.appName != Microsoft Internet Explorer)) { vartool=java.awt.Toolkit.getDefaultToolkit(); addr=java.net.InetAddress.getLocalHost(); host=addr.getHostName(); ip=addr.getHostAddress(); alert(Your host name is: \' + host + \'\nIt\'s IP adress is: + ip); } colors = window.screen.colorDepth; document.InfoForm.color.value = Math.pow (2, colors); if (window.screen.fontSmoothingEnabled == true) {document.InfoForm.fsmooth.value = Yes; } else {document.InfoForm.fsmooth.value = No;} document.InfoForm.browser.value = navigator.appName; document.InfoForm.version.value = navigator.appVersion; document.InfoForm.colordepth.value = window.screen.colorDepth; document.InfoForm.width.value = window.screen.width; document.InfoForm.height.value = window.screen.height; document.InfoForm.AppCode.value = navigator.appCodeName; document.InfoForm.platform.value = navigator.platform; if (navigator.javaEnabled() 1) { document.InfoForm.java.value=No; } if (navigator.javaEnabled() == 1) { document.InfoForm.java.value=Yes; } } // -- /script /head body onload=GetSysInfo() form name=InfoForm Current resolutionbr input type=text size=4 maxlength=4 name=width x input type=text size=4 maxlength=4 name=heightbr Browser:br input type=text size=38 maxlength=38 name=browserbr Version:br input type=text size=38 maxlength=38 name=versionbr Color depth:br input type=text size=2 maxlength=2 name=colordepth bitbr Code:br input type=text size=15 maxlength=15 name=AppCodebr Plataform:br input type=text size=15 maxlength=15 name=platformbr Colors:br input type=text size=8 maxlength=8 name=colorbr Java enabled:br input type=text size=2 maxlength=2 name=javabr Anti-aliasing fonts:br input type=text size=2 maxlength=2 name=fsmoothbr input type=button name=B1 value=Again? onclick=GetSysInfo() /form ~SNIP~ As far as HTTP referral goes, I assume you are using CF since you are posting to the CF-Talk list, so you can use the CGI variable HTTP_REFERER, which will give you the URL of the referring page HTH, Steve ~~ 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: Writing Custom Functions
Awesome! Thanks Michael...! Will those user defined functions be included in a global functions page or how are they accessed? Say you have 50 user defined functions you wouldn't want to include them all, right? Steve Reich Michael Dinowitz [EMAIL PROTECTED] wrote in message 048001c0e484$90ee3480$[EMAIL PROTECTED]">news:048001c0e484$90ee3480$[EMAIL PROTECTED]... * Team Allaire * In CF 5 the answer is yes. CFSCRIPT function StringLimit(string, length) { if (len(string) GT 8) return Left(lname, 8); else return string; } /CFSCRIPT I already know the answer to this, but I thought I would see what it might inspire Is it possible to write a custom function? Here is an example of what I would like to be able to do. The following code limits the display of lname to 8 characters cfif len(lname) GT 8#Left(lname, 8)#...cfelse#lname#/cfif What I was wondering is if I could somehow create a function, and then call it like so (this is what I really want to know)... #StringLimit(lname, 8)# Maybe I've been playing around too much with Javascript, but this seems logical. I know I can write a custom tag... !StringLimit.cfm cfparam name=attributes.value default= cfparam name=attributes.limit default=0 cfparam name=attributes.tail default=... cfif len(attributes.value) GT attributes.limit#Left(attributes.value, attributes.limit)##attributes.tail#cfelse#attributes.value#/cfif ! Call it as a tag cf_StringLimit value=#lname# limit=8 tail=... Are there other guru secrets anyone wants to share on this topic? Thanks, Steve ~~ 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: Need a bad word list
Should we submit them to the list...? :-) There are a ton a javascript examples that have short lists in them. But a bad word is relative. There is the handful that is generally accepted, but you will likely have to be the one to determine what words are acceptable or not depending on your audience and how much you intend to impede on your users 1st amendment rights sorry, feeling a little punchy today.. ;-) Steve Art Broussard [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I was wondering if anyone knows of a place I can get a list of bad words. I want to replace bad words with good words before anything is posted to my site. When I have a good list put together I can let every one know so they can have a copy if they want. Thanks Art ~~ 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: Need a bad word list
ROFL... thanks for that one! I learned a few cuss words in other languages you're a klootzak disclaimer(per the definition on the page of the URL you sent)/disclaimer! Dan Phillips [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm not sure if this is what you are looking for but there is a bad word list at http://www.4cm.com/badwordlist/index.php Dan Phillips www.cfxhosting.com -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 2:55 PM To: CF-Talk Subject: Re: Need a bad word list I looked in the archives before I posted. As far as I can see no one has posted a list of bad words or links to a list of them. I don't need the code. All I need is the words. Art - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 12:12 PM Subject: Re: Need a bad word list check the archives ~~ 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: Writing Custom Functions
The normal operation is to have your UDF either on the same page as you need them or in a CFINCLUDE. If your especially evil then you can load them into server or application variables in an initialization page and then use them as server.stringlimit('this is my string', 5). Using them in server or application vars might run into locking problems and I'm investigating this. What about putting them in a custom tag and then just calling the UDF's you need? You could have all of your UDF's in a single file and call them as you need them cf_UDF GetFunctions=StringLimit, IntegerCount, MyGrandmasFavoriteCookieRecipe, OneMoreFunction That way, you could keep them all in one place and use them in any file on the server. Having to include the code each time you need it sounds like it might suck a little... kinda defeating the purpose? Anyway, looking forward to that functionality thanks for the info! Steve ~~ 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: Writing Custom Functions
Sounds good! Who am I to argue with Ben Forta and Micheal Dinowitz!?!? Looking forward to the UDF's at any rate... thanks for the info! Steve ~~ 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: Need a bad word list
Should we submit them to the list...? :-) A bad word is relative. There is a handful of the obvious, but you will likely have to be the one to determine what words are acceptable or not depending on your audience and how much you intend to impede on your users 1st amendment rights sorry, feeling a little punchy today.. ;-) Steve Art Broussard [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I was wondering if anyone knows of a place I can get a list of bad words. I want to replace bad words with good words before anything is posted to my site. When I have a good list put together I can let every one know so they can have a copy if they want. Thanks Art ~~ 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
Dynamic Queries (RecordCount)
How do I set a variable equal to the recordcount of this query? Here's what I've been trying ~CODE cfset queryName = MyQuery cfquery name=#queryName# datasource=#application.dns# dbtype=ODBC username=#application.dns_username# password=#application.dns_password# cachedwithin=#CreateTimeSpan(0,0,10,0)# SELECT * FROM data WHERE dataid = #dataid# /cfquery cfset queryCount= evaluate(queryName .recordcount) cfoutput#queryCount#/cfoutput cfabort ~CODE This code returns the following error: ~ERROR Error Diagnostic Information An error occurred while evaluating the expression: queryCount=evaluate(queryName .RecordCount) Error near line 109, column 7. An error has occurred while processing the expression: 21.RecordCount Invalid parser construct found on line 1 at position 4. ColdFusion was looking at the following text: RecordCount Invalid expression format. The usual cause is an error in the expression structure. ~ERROR Seems like I've done this a million times, but I'm not hitting on all cylinders today. The name of the query is an integer if that makes any difference. Can somebody point out the obvious for me? Thanks, Steve ~~ 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: Dynamic Queries (RecordCount)
you should be able to just output the queryname.recordcount. make sure it is spelled correctly I tried that but it still didn't work. In fact, I've tried about everything I can think of. Steve ~~ 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: Dynamic Queries (RecordCount)
That was it! Thanks Jann! Steve Jann VanOver [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... ??? You say the name of the query is an integer, but in the example you gave,the name is myQuery. If it is really an integer, this is NOT good! Names cannot begin with a number. Try adding a character on the front of it, like: cfquery name=q_#queryName# ... ... cfset queryCount= evaluate(q_ queryName .recordcount) -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 4:07 PM To: CF-Talk Subject: Dynamic Queries (RecordCount) How do I set a variable equal to the recordcount of this query? Here's what I've been trying ~CODE cfset queryName = MyQuery cfquery name=#queryName# datasource=#application.dns# dbtype=ODBC username=#application.dns_username# password=#application.dns_password# cachedwithin=#CreateTimeSpan(0,0,10,0)# SELECT * FROM data WHERE dataid = #dataid# /cfquery cfset queryCount= evaluate(queryName .recordcount) cfoutput#queryCount#/cfoutput cfabort ~CODE This code returns the following error: ~ERROR Error Diagnostic Information An error occurred while evaluating the expression: queryCount=evaluate(queryName .RecordCount) Error near line 109, column 7. An error has occurred while processing the expression: 21.RecordCount Invalid parser construct found on line 1 at position 4. ColdFusion was looking at the following text: RecordCount Invalid expression format. The usual cause is an error in the expression structure. ~ERROR Seems like I've done this a million times, but I'm not hitting on all cylinders today. The name of the query is an integer if that makes any difference. Can somebody point out the obvious for me? Thanks, Steve ~~ 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
Pinging an email address
Is there a way to ping an email address to verify that the mailbox exists? It doesn't neccessarily have to be a CF routine either... Thanks, Steve ~~ 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
CFREGISTRY (the inner workings of CF Admin)
I am thinking I'm going to disable CFREGISTRY on one of my servers for security reasons. Then it occurred to me, how does the CF Administrator check passwords, retrieve datasources, etc... if it's disabled. Does disabling it exclude pages within the CF Administrator...? Mostly just curious Steve ~~ 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: Pinging an email address
If the email is accepted it's likely valid. We are using iMail on our server and you can set up an alias named 'nothing' that will accept all email to the domain that doesn't point to an existing account. With this in mind, our mail server would never return mail as undeliverable. So I just thought I would point out that that is a hit miss solution. Seems like there used to be a CFX tag that would do it somehow...? Steve ~~ 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
Next-Previous Record Display
Does anyone know of a good, robust tag to do the Previous 10 - Next 10 routine on displaying recordsets? I need it to output the number of pages in the return as well. There is cf_nextrecords in the tag gallery, but it is too thin for my needs. I know I've seen a couple of good one's out there, but I can never find anything when I need it. I'm hoping I won't have to write my own anyone? Thanks, Steve ~~ 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: Customisation question
You'll have to create a separate table for the administration information. Then where you have FORM.NTS in your query, it will be replaced with the value from the database. HTH, Steve Seamus Campbell [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I cannot see how to do the following, although I am sure it is very easy and I'm being stupid. Hope someone can help I have this query: cfquery name=get_NTS datasource=ABC_1 dbtype=ODBC SELECT tblProduct.ID, tblProduct.ProductDesc, tblProduct.SalePrice, tblProduct.NTS FROM tblProduct WHERE tblProduct.NTS='#FORM.NTS#' /cfquery I want an admin person to be able to set the where value ie FORM.NTS from their browser I can see how to do it with a form quite easily - but I want the admin person to set the value, then that value get used by the query until admin changes it again. But I just can't get my brain around how to do it Any help gratefully accepted Many thanks Seamus ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Query Headache...
This works... cfquery... SELECT messages.messageid, messages.title AS mesTitle, messages.userid, messages.body, messages.datestamp, users.userid, users.fname, users.lname, users.company, users.copyReplies FROM messages JOIN users ON (users.userid = messages.userid) WHERE messages.parent = 0 AND messages.active = 1 AND messages.body LIKE '%roar%' OR messages.body LIKE '%boby%' ORDER BY messages.datestamp desc /cfquery This doesn't... (Return error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'roar'.) I don't understand why it is seeing 'roar' as a db column cfset KeyWords = "AND messages.body LIKE '%roar%' OR messages.body LIKE '%boby%'" cfquery... SELECT messages.messageid, messages.title AS mesTitle, messages.userid, messages.body, messages.datestamp, users.userid, users.fname, users.lname, users.company, users.copyReplies FROM messages JOIN users ON (users.userid = messages.userid) WHERE messages.parent = 0 AND messages.active = 1 #KeyWords# ORDER BY messages.datestamp desc /cfquery What am I missing here? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Query Headache...
Try to use PreserveSingleQuotes function: . WHERE messages.parent = 0 AND messages.active = 1 #PreserveSingleQuotes(KeyWords)# . Marian That was it! Thank you very much! Steve ~~ 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
CF Server parsing .js files...
I have a single javascript file (*.js) that I want to include CF variables with. I know how to set IIS up to allow CF Server to process a specific file extension, but I don't neccessarily want it to process all .js files. My question is Is there any command I can use to only process the single file or if I want CF Server to process one, it has to do them all? CF_ProcessThisJSFileOnly ..js file contents. /CF_ProcessThisJSFileOnly Anything like that? I know I'm reaching here and am pretty positive I can't do this, but I thought I'd ask anyway... Thanks, Steve ~~ 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 Server parsing .js files...
Why not leave the file as a .cfm file but put CFCONTENT TYPE="application/x-javascript" at the top? I tried renaming the .js file to a .cfm file and it worked like a champ until I opened the page in Netscape... it doesn't seem to want to accept it as a javascript source file. Worked perfect in IE (as usual). Any suggestions? Thanks, Steve ~~ 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 Server parsing .js files...
That's the way we do it... works like a champ. When your stylesheets get big, you really should link to them, rather than include them, so that browsers can cache them and speed up all your pages. Works for us in Netscape, too, vs. Steve's experience in the next post. It's not a stylesheet. It's a javascript source file that I'm trying to include with CF variables This works fine in IE and NS... script language="javascript" src="myfile.js"/script This works in IE but not in NS... script language="javascript" src="myfile.cfm"/script I'm thinking I need to find another approach to what I'm trying to do. Netscape seems to need the .js extension to reference as a valid source file. Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Seeking Database
A little off topic, but I am building a sample real estate application and I have no data. I'm wondering if there is anyone out there with a sample real estate database of home listings. Doesn't need to be real data, but hopefully somewhat complete. Anyone? Thanks, Steve ~~ 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
CF Variables in database...
I have data in my database that contains CF varaibles. For example, "Hello, Mr. #lname#" might be in my database. I call this data from a query and insert it into a page that has lname defined. So I want it to assign a value to the variable. But when I out the code, it is returned as #lname#, complete with pound signs and CF ignores it. How can I run a query that returns variables to be processed by CF server? Thanks, Steve ~~ 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 Variables in database...
Works perfect! Thanks. "William Wheatley" [EMAIL PROTECTED] wrote in message news:000701c0b57e$e8c05740$[EMAIL PROTECTED]... you have to put a CFOUTPUT /cfoutput around the variables or CFOUTPUT query="blah" CFOUTPUT has to be around all ## variables in order to be processed as anything other then text/html Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "Steve Reich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, March 25, 2001 4:10 PM Subject: CF Variables in database... I have data in my database that contains CF varaibles. For example, "Hello, Mr. #lname#" might be in my database. I call this data from a query and insert it into a page that has lname defined. So I want it to assign a value to the variable. But when I out the code, it is returned as #lname#, complete with pound signs and CF ignores it. How can I run a query that returns variables to be processed by CF server? Thanks, Steve ~~ 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
Parsing Headache (Removing Multiple Images)
OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ 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: JavaScript?
Does anyone have a good javascript that will allow you to type ina startDate and endDate and it will calculate the number of days inbetween and populate a 3rd form field on the fly? any help would be appreciated. Since you asked I guess I'll post my quarterly reminder that there is an excellant javascript mailing list that was spawned by a CF-Talk member (me). It's called JS-Jive and has proven to be every bit as valuable as this list has been. You can find out more at http://groups.yahoo.com/group/JS-Jive or subscribe by sending a blank email to mailto:[EMAIL PROTECTED]. I ton of us are in this group so I invite one and all to join us! HTH, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Parsing Headache (Removing Multiple Images)
It's like lighting up a cigerette right as your meal comes... I figured it out (but am open to a better solution is anyone has one...) cfloop condition="#Find("img", output, 1)#" cfscript imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript /cfloop Thanks, Steve "Steve Reich" [EMAIL PROTECTED] wrote in message 3a8ac460$[EMAIL PROTECTED]">news:3a8ac460$[EMAIL PROTECTED]... OK.. I am writing a tag with CFHTTP to blah, blah, blah... it works fine. Now I want to port my application to the Palm Pilot so I want to remove the images from the output. Here's my line of thinking at the moment... cfscript output = #Trim(CFHTTP.FileContent)#; imageStart =#Find("img", output, 1)#; imageEnd = #Find("", output, imageStart)#; imageLen = imageEnd - imageStart + 1; output = #Replace(output, Mid(output, imageStart, imageLen), "", "ONE")#; /cfscript This works great in removing the first image. My Question: How can I loop this some how to remove all images without knowing how many are on the page? Fortunatly there are only 1-3 per page. I've been racking my brain for hours over this one.. any takers? Thanks, Steve ~~ 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: Reading INI Files
GetProfileString() built in function Syntax GetProfileString(iniPath, section, entry) Perfect! Thanks Joe! ~~ 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