CFINCLUDE of CGI pages
I have a cold fusion page and a CGI page that I would like in one without using frames. When I do a cfinclude on the .cfm page the cold fusion code works as it should the insead of displaying the output of the .cgi page it just displays all of the cgi code. Has anyone ran across this before? Thanks, Jim Vosika SoftwareSuperMall.Com ~| 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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stupid SQL Problem (in oracle)
Use the GROUP BY function... Jim Vosika http://www.softwaresupermall.com -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 2:18 PM To: CF-Talk Subject: OT: Stupid SQL Problem (in oracle) I need some way to convert a word into a number. I know I've done it once before, but I can't remember what I did. For example, I have a query that will return something like the following: Machine1 Running Machine2Running Machine3Offline Machine4Running Machine5Offline Machine6Unknown I want to get some result like this: Running OfflineUnknownTotal 3 2 1 6 I know it has something to do with a sum and translating Running into 1, Offline into a 1 and Unknown into a 1, I just can't remember how I did it. This is an oracle 8i system I'm working with. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ 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 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: MS Access SQL Problem
If Seamus' idea didn't work, should DISTINCTROW just be DISTINCT? Jim -Original Message- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 10:18 PM To: CF-Talk Subject: Re: MS Access SQL Problem I think change Theme to 'Theme' seamus At 12:43 pm 11/09/2002 , you wrote: Arg.The SQL works fine in ACCESS, but when I copy to CF5.0, I get an error. Any thoughts??? cfquery name=qryGetGroups datasource=#strDSN# dbtype=ODBC SELECT DISTINCTROW ItemGroups.strItemGroupName, ItemGroups.strItemGroupDesc FROM (GroupTypeCodes INNER JOIN ItemGroups ON GroupTypeCodes.GroupTypeCodes_PK = ItemGroups.intGroupTypeCodes_PK) INNER JOIN GroupedItems ON ItemGroups.intItemGroup_PK = GroupedItems.ItemGroup_PK WHERE (((GroupTypeCodes.GroupTypeName)=Theme)) ORDER BY (ItemGroups.strItemGroupName) /cfquery Results in DETAIL - [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL = SELECT DISTINCTROW ItemGroups.strItemGroupName, ItemGroups.strItemGroupDesc FROM (GroupTypeCodes INNER JOIN ItemGroups ON GroupTypeCodes.GroupTypeCodes_PK = ItemGroups.intGroupTypeCodes_PK) INNER JOIN GroupedItems ON ItemGroups.intItemGroup_PK = GroupedItems.ItemGroup_PK WHERE (((GroupTypeCodes.GroupTypeName)=Theme)) ORDER BY (ItemGroups.strItemGroupName) Data Source = OMGV2 ERRORCODE - 07001 EXTENDEDINFO - MESSAGE - ODBC Error Code = 07001 (Wrong number of parameters) NATIVEERRORCODE - -3010 SQLSTATE - 07001 http://powerdvd.tv __ 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
Tracking Hits
I have a web page that, when it goes live, I am expecting to get about a 500-1000 hits a minute. What would be a good way to track this number? I wouldn't want to make a database call or open a flat file each time the page loads but my curious mind would like to see hard numbers. Are there any good painless ways to do this? Thank you, Jim Vosika SoftwareSuperMall.Com __ 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: SQL Help
Just remove the commas. You shouldn't need them... HTH, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 1:29 PM To: CF-Talk Subject: SQL Help Can any one help me out here? I'm having a problem getting this query to work with putting in the proper commas when necessary in myWHERE clause for the SQL statement. James Blaha CFQUERY name=JobApplicants datasource=ABC SELECT * FROM HRWebAgent.tApply WHERE ReqNO 0 CFIF #form.ReqNo# NEQ 0 AND(ReqNo='#ReqNo#'), /CFIF CFIF #form.FIRSTNAME# NEQ 0 AND(FIRSTNAME LIKE '#FIRSTNAME#%'), /CFIF CFIF #form.LASTNAME# NEQ 0 AND(LASTNAME LIKE '#LASTNAME#%'), /CFIF CFIF #form.APPLIED_DATE# NEQ 0 !--- Dates go in order of old:recent i.e. BETWEEN '11/4/2000' AND '6/18/2001' --- AND(APPLIED_DATE BETWEEN '#back_date_listed2#' AND '#now_date2#'), /CFIF CFIF #form.Desired_Position# NEQ 0 !--- Desired_Position IN ('Briarcliff','New York') --- AND(Desired_Position IN (#ListQualify(Form.Desired_Position,')#)), /CFIF /CFQUERY __ 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 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: Filtering query results
I have done this a few times with URL parameters and cfif's in the where clause and had no problems...That is about the easiest way to go about it I think. Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 1:35 PM To: CF-Talk Subject: Filtering query results In the application that I'm working on, I have a need to filter the results of a query that get displayed on the screen, changing the selectable options for the user. I have a default query that populates a SELECT list, and under that list I have three hyperlinks that will allow a user to click on them to execute a different query to show different results in the list for them to choose from. I'm still pretty new to ColdFusion, and I'm not really sure what's the best way to implement this functionality, and was hoping for some ideas from anyone. The query that gets executed is basically the same, only the WHERE clause changes. I've tried just dynamically changing the WHERE clause using cfif checking based on a URL parameter, but didn't have much luck with that. Then I tried actually creating the three separate queries, and just changing the query parameter of my loop for the list values, using cfswitch checking to set the query parameter based on a URL parameter. That didn't give me much luck either. I'm just not sure how to best go about doing this. Does anyone happen to know of any articles online, or tutorials that might explain something close to how to do this? How to I create a .cfm page to accept a parameter by default to tell it which query to execute? Any help or thoughts would be greatly appreciated. Thanks. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || ))) */ Robert D. Yexley (E-mail).vcf __ 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: Javascript/CF Tag to fill fields
Try fusionscript, here is the zip file for it: http://tinyclick.com/?FUSIONSCRIPTZIP and here is the documentation: http://tinyclick.com/?FUSIONSCRIPTDOCS I hope this is the kind of thing you are looking for... Good Luck, Jim Vosika -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 2:36 PM To: CF-Talk Subject: RE: Javascript/CF Tag to fill fields without a round trip to the server, hm? not too sure you can do that, mang :) ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 3:25 PM To: CF-Talk Subject: RE: Javascript/CF Tag to fill fields Well, actually we got that figured out but have the million dollar question for us... We have 4 items, first is a select box, when an item is selected it fills the other three text input boxes via Javascript. Now, once all four are filled out, wow would it be great for a new empty row to displaywith select box, et al, an exact duplicate. Not sure how to do this? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 2:09 PM To: CF-Talk Subject: RE: Javascript/CF Tag to fill fields a bit more clarification, may return better answers. tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 2:46 PM To: CF-Talk Subject: Javascript/CF Tag to fill fields We have a drop down, and would like it to fill in row with that recordset's info. Is there a custom tag to do such before I switch into the wooly world of javascript. (the first field is drop down, next 4 fields to be filled need to be text input fields) Thanks for any quick pointers...not finding it at DevEx. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ 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: capitalize first letter
Someone made a tag called CF_ProperCase that should be what you are looking for: http://tinyclick.com/?08q2jd HTH, Jim Vosika -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:31 PM To: CF-Talk Subject: capitalize first letter Hi everyone. I would like to capitalize the first letter of variable every time it is displayed. What is the easiest way to do this? Thanks very much. __ 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: capitalize first letter
Someone made a tag called CF_ProperCase that should be what you are looking for: http://tinyclick.com/?08q2jd HTH, Jim Vosika -Original Message- From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 2:31 PM To: CF-Talk Subject: capitalize first letter Hi everyone. I would like to capitalize the first letter of variable every time it is displayed. What is the easiest way to do this? Thanks very much. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Access vs. SQL Server Oracle
Sorry for the off topic question but does anyone know of a good web page that compares Access, SQL Server and Oracle? I know the obvious differences like cost, db size and speed but I would like some more in depth features and statistics. Thank you, Jim __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: HtmlEditFormat()
What versions of CF are you guys running? I am running CF5 and have problems sometimes when I populate a form field so I correct it with htmleditformat() but just out of curiosity, are you all running MX or 5? Perhaps they fixed the problems in MX. Just Curious, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 11:00 PM To: CF-Talk Subject: RE: HtmlEditFormat() Uh, yes, of course. In a bit of a fluster here ;-) -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Thursday, 18 July 2002 3:46 p.m. To: CF-Talk Subject: RE: HtmlEditFormat() When the form is submitted, the quot; becomes etc. So they won't ever end up in the database. (Correct me if I'm wrong.) I don't believe so ... I believe when you post the form there is no conversion of the contents of the form ... When you type gt; into a form that's already loaded, you see gt; because you typed it ... When the form is prepopulated with gt; you see because the browser interpreted it before you had a chance to type anything ... but I don't think the browser actually converts it during a post operation ... I've seen form results ( in debugging output ) with input fields where the browser actually interprets the form results, so you see form elements in the debugging output -- but then I've seen htmlencoded data in the form debugging output also ... Isaac www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is cflib.org down?
I can't either... Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:12 PM To: CF-Talk Subject: Is cflib.org down? Can't seem to get to cflib.org. How about other people? __ 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
CFHTTP on CFMX
Hi, I have one server running CF5 and one I am testing with that has CFMX. On the CFMX machine I run some code that cfhttp's a website a few times each time it is run. Everything works great on the CF5 box but when I run the same code on MX I get a 302 Moved Temporarily error. I tried looking through the docs and I couldn't find any changes that may affect me. Has anyone else encountered this? Thanks, Jim Vosika http://tinyclick.com http://tinyclick.com/ Free URL Shortening! __ 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
Refresh Page
Hi, I was wondering if anyone knew of a way to have a cfm page refresh after a certain timeout, say 30-45 minutes? Thanks! Jim Vosika http://tinyclick.com http://tinyclick.com/ Free URL Shortening! __ 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 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: Refresh Page
Cool, I didn't even think of Meta refresh! I have used those before as redirects for 0 seconds but never a useful way. Thanks for the help! Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 3:17 PM To: CF-Talk Subject: Re: Refresh Page Hi, I was wondering if anyone knew of a way to have a cfm page refresh after a certain timeout, say 30-45 minutes? There are two common ways to do this. One is with a meta refresh tag and the other is with a javascript window.setTimeout() function call... I'm in a bit of a hurry at the moment, otherwise I would look up the syntax for you... In either case, you'll have to multiply your minutes by 60,000 to get the number of miliseconds for the meta tag or the js function. Isaac www.turnkey.to 954-776-0046 __ 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: Avoiding another trip to the database
Look into fusionscript. http://www.fusionscript.com HTH, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: David Fafard [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 7:54 AM To: CF-Talk Subject: Avoiding another trip to the database Hello, I'm new to CF and trying to figure this out. I have a dynamic select on a form where a user can choose an address type. ie. default, ship to, bill to.. etc. based on a query to the address table. When the user selects an address type, I would like to populate street, city, st and zip form input values from the address table based on the users selection BUT I don't want to reload the form. Is this possible using javascript with the query array? I think it should be but I'm stumped. Thanks, Dave Fafard __ 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: Boxes instead of
Would #htmleditformat(yourVariable)# fix it maybe? Jim Vosika Http://tinyclick.com Free URL Shortening! -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 3:04 PM To: CF-Talk Subject: Boxes instead of I have a strange problem in CFMX. When querying data and that data includes a displayed is a box instead of the . Anyone else see this and know how to correct it? THanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Querying 1 million records
512 isn't enough for me and that's on my PC! Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 9:28 PM To: CF-Talk Subject: Re: Querying 1 million records Actually 512mb should be fine on the memory. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Jeff Green [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 12, 2002 6:16 PM Subject: Querying 1 million records Im going to have to deal with some large amounts of data, queries that select 1 million records. Is this something CF should be able to handle? (CF5 on win2000 with 512 RAM) One thing I want to do is query one DB and insert recs to another DB, approx. 1 million recs. Thanks for any advice, Jeff __ 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: Web Services and CF5
That whole process sounds pretty slow! I'm looking into changing to a CFMX server to save myself the headaches and maybe prevent my cheeks from puffing up! I'll look at the custom tags but it sounds like they won't do me much justice. Take Care, Jim Vosika http://TinyClick.Com Free URL Shortening! -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:17 AM To: CF-Talk Subject: RE: Web Services and CF5 Using web services in CF5 is painful at best. You can think of a web service as an http call where you send a command via SOAP and you get back an XML document in return, also in SOAP. In CFMX, this is all taken care of for you. In CF5, you have to write the all the SOAP stuff yourself. This is not fun. In fact, I'd rather get my wisdom teeth pulled out than do that. Having said all that, I think there's some custom tags you can use to invoke web services for CF5. -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 9:47 PM To: CF-Talk Subject: Web Services and CF5 I have never used Web Services before and I thought I should figure them out during my free time before I actually need to. I tried searching on google for topics about web services and cold fusion and could not find anything related to CF5 which is all I get to deal with. I am trying to integrate with google's api and I found a code snippet on their website for use with cold fusion mx that used this tag below to use the web service. Seems pretty simple but I can't seem to figure out the Cold Fusion 5 equivalent tag(s) to use web services, could someone please point me in the right direction? Here is the code for cfmx: cfinvoke webservice=http://api.google.com/GoogleSearch.wsdl; method=doGoogleSearch key=--- PUT YOUR KEY HERE --- q=#searchterm# start=0 maxResults=10 filter=true restrict= safeSearch=false lr= ie=latin1 oe=latin1 returnVariable=resultset Thanks, Jim Vosika http://tinyclick.com http://tinyclick.com/ http://tinyclick.com/ Free URL Shortening! __ 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: Site monitoring services
The site worked fine for me but yes that is funny!! Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:25 PM To: CF-Talk Subject: RE: Site monitoring services Lol.. They're offline.. | -Original Message- | From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, July 10, 2002 2:09 PM | To: CF-Talk | Subject: RE: Site monitoring services | | | We use AlertSite.com for external monitoring. It's never | missed a beat. | | ~~|-Original Message- | ~~|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] | ~~|Sent: Wednesday, July 10, 2002 5:06 PM | ~~|To: CF-Talk | ~~|Subject: OT: Site monitoring services | ~~| | ~~| | ~~|Hay i had a question there was a website that used to | ~~|monitor your site for you and let you know when it was | done ~~|anyone remember a URL for a site like that? ~~| ~~|I | am trying to prove to my isp that my site is down more | ~~|then the AUP says so i wanna stickem! | ~~| | ~~|Bill Wheatley | ~~|Senior Database Developer | ~~|Macromedia Certified Advanced Coldfusion Developer | ~~|EDIETS.COM ~~|954.360.9022 X159 ~~|ICQ 417645 ~~| ~~| | __ 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: Loading CFM page into new browser window
Could you use URL Variables? Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Svee, Eric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:38 PM To: CF-Talk Subject: Loading CFM page into new browser window I have a button that is intended to launch a pop-up window (instruction.cfm). This window will display different information, depending on which button is clicked. How can I feed Cold Fusion the correct string(ie. ?fieldName=EMPLOYEE_hire_date) from each specific button while still being able to control my window.open options (ie. no scroll bars, 300 x 300, etc). Thanks E __ 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: Loading CFM page into new browser window
Are you saying it wont load anything after the question mark? If so then maybe you could try using Ben Forta's way of changing your url variables from instruction.cfm?fieldName=EMPLOYEE_hire_date to instruction.cfm/fieldname/EMPLOYEE_hire_date maybe that would work...and maybe not. Here is information on that if you are interested: It's an article called A Cure for Arachnophobia http://tinyclick.com/?ox9jk8 HTH, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Svee, Eric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:56 PM To: CF-Talk Subject: RE: Loading CFM page into new browser window The problem isn't getting CF to grab the correct info. Instead, it occurs when I try to load instruction.cfm?fieldName=EMPLOYEE_hire_date or instruction.cdm?fieldName=BONUS_targetpercent. Javascript only wants to load instruction.cfm and not the variations that Cold Fusion can create. -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 2:43 PM To: CF-Talk Subject: RE: Loading CFM page into new browser window Could you use URL Variables? Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Svee, Eric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 4:38 PM To: CF-Talk Subject: Loading CFM page into new browser window I have a button that is intended to launch a pop-up window (instruction.cfm). This window will display different information, depending on which button is clicked. How can I feed Cold Fusion the correct string(ie. ?fieldName=EMPLOYEE_hire_date) from each specific button while still being able to control my window.open options (ie. no scroll bars, 300 x 300, etc). Thanks E __ 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
Web Services and CF5
I have never used Web Services before and I thought I should figure them out during my free time before I actually need to. I tried searching on google for topics about web services and cold fusion and could not find anything related to CF5 which is all I get to deal with. I am trying to integrate with google's api and I found a code snippet on their website for use with cold fusion mx that used this tag below to use the web service. Seems pretty simple but I can't seem to figure out the Cold Fusion 5 equivalent tag(s) to use web services, could someone please point me in the right direction? Here is the code for cfmx: cfinvoke webservice=http://api.google.com/GoogleSearch.wsdl; method=doGoogleSearch key=--- PUT YOUR KEY HERE --- q=#searchterm# start=0 maxResults=10 filter=true restrict= safeSearch=false lr= ie=latin1 oe=latin1 returnVariable=resultset Thanks, Jim Vosika http://tinyclick.com http://tinyclick.com/ http://tinyclick.com/ Free URL Shortening! __ 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 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: Web Services and CF5
Thanks Ben. No wonder I couldn't find any information on it! Trust me, I would love to use CFMX but my webhosting company has not upgraded yet, hopefully they will soon! Thanks, Jim -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:06 PM To: CF-Talk Subject: RE: Web Services and CF5 CF5 has no built in support for Web Services. Best you'll be able to do is use CFHTTP to make a request and you'll get XML data back. Then you'll need to use a third party XML parser (sorry, CFXML tag is CFMX only) to manipulate the data. Bottom line, use CFMX. --- Ben -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 11:47 PM To: CF-Talk Subject: Web Services and CF5 I have never used Web Services before and I thought I should figure them out during my free time before I actually need to. I tried searching on google for topics about web services and cold fusion and could not find anything related to CF5 which is all I get to deal with. I am trying to integrate with google's api and I found a code snippet on their website for use with cold fusion mx that used this tag below to use the web service. Seems pretty simple but I can't seem to figure out the Cold Fusion 5 equivalent tag(s) to use web services, could someone please point me in the right direction? Here is the code for cfmx: cfinvoke webservice=http://api.google.com/GoogleSearch.wsdl; method=doGoogleSearch key=--- PUT YOUR KEY HERE --- q=#searchterm# start=0 maxResults=10 filter=true restrict= safeSearch=false lr= ie=latin1 oe=latin1 returnVariable=resultset Thanks, Jim Vosika http://tinyclick.com http://tinyclick.com/ http://tinyclick.com/ Free URL Shortening! __ 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: CGI.HTTP_REFERER
I mean for pages out of my control. Like say the user first goes to a google result page then clicks through to some website where there is a link to me. This is a bad example but I would want to see the google url. Thanks, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 7:15 AM To: CF-Talk Subject: Re: CGI.HTTP_REFERER Save it as a variable? Pete - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 08, 2002 6:19 PM Subject: CGI.HTTP_REFERER I currently use #CGI.HTTP_REFERER# to see the last page my user came from, is there a way to look back 2 pages? Thanks! Jim Vosika http://www.softwaresupermall.com http://www.jimvosika.com __ 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: Search Engine-Friendly URLs
It was featured in the January 2001 issue of CFDJ. In his code example he shows the tag CF_FakeURL. HTH, Jim Vosika http://tinyclick.com Free URL Shortening! -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 3:16 PM To: CF-Talk Subject: Search Engine-Friendly URLs I couldn't find the old thread I vaguely remember on this list. What's the preferred custom tag for replacing and ? in the query string? I think Ben Forta wrote one, but I can't find it now. I'm already using the URLReplacer ISAPI filter, but I wanted to explore alternatives. Thanks, Jamie __ 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 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: Anyone use this email Verifier?
Here is one I ran across yesterday. Seemed ok when I had to go through the process to validate my e-mail address but I have never used it for one of my websites... http://www.validatedemail.com Good Luck, Jim Vosika http://tinyclick.com Free URL Shortening -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 1:04 PM To: CF-Talk Subject: RE: Anyone use this email Verifier? There's a web service for this (free). You can find it at www.xmethods.net. I wouldn't expect ANY approach to be terribly reliable though. Mark -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 12:35 PM To: CF-Talk Subject: RE: Anyone use this email Verifier? I don't see how this script could possibly verify that an email address exists without sending an email to the person for verification. You could easily do this in CF without paying $50. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Jeff Green [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 1:58 PM To: CF-Talk Subject: OT: Anyone use this email Verifier? Just wondering if anyone has any experience with this Advanced Email Verifier http://www.glocksoft.com/aevcgi/ thx, jeff __ 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
CGI.HTTP_REFERER
I currently use #CGI.HTTP_REFERER# to see the last page my user came from, is there a way to look back 2 pages? Thanks! Jim Vosika http://tinyclick.com http://tinyclick.com/ Free URL Shortening! __ 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: Naming Convention choice
I do: CFQUERY datasource=queryName Jim Vosika www.tinyclick.com -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 9:19 AM To: CF-Talk Subject: RE: Naming Convention choice I use this: cfquery name=relevantQueryName datasource=#Request.DBdatasource# dbtype=#Request.DBtype# username=#Request.DBusername# password=#Request.DBpassword# Erika | -Original Message- | From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] | Sent: Friday, July 05, 2002 3:14 PM | To: CF-Talk | Subject: OT: Naming Convention choice | | | Curious as to which one people prefer. | | cfquery datasource=QueryName ... | | OR | | cfquery datasource=query_name ... | | Also, out of curiosity these too: | | CFQUERY DATASOURCE... (all caps) | | Or | | cfquery datasource ... | | Thanks | Paul Giesenhagen | QuillDesign | | __ 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: New to all this
Same way you post a response like you just did... Send you e-mail to: [EMAIL PROTECTED] HTH, Jim Vosika http://www.tinyclick.com -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 9:13 AM To: CF-Talk Subject: New to all this Hi, How can I post a question too? Kodjo Ackah Principal Consultant -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 15:14 To: CF-Talk Subject: OT: Naming Convention choice Curious as to which one people prefer. cfquery datasource=QueryName ... OR cfquery datasource=query_name ... Also, out of curiosity these too: CFQUERY DATASOURCE... (all caps) Or cfquery datasource ... Thanks Paul Giesenhagen QuillDesign __ 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 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: Adding Values (SQL)
It should work exactly how you have it...It does for me. Jim Vosika http://www.tinyclick.com FREE URL Shortening! -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 10:37 AM To: CF-Talk Subject: Adding Values (SQL) I don't have any cheet sheets with me, but I need to do a simple query and have an addition statement in the SELECT statment of a query. Something like: SELECT, column1, column2 + 3 AS NewQty FROM. Basically column2 is a numeric value and I want to add a number to it and rename the Column to NewQty. Does anyone have the correct sytax? Thanks! Paul Giesenhagen QuillDesign __ 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: Dedicated Hosting
I would be interested also. Thanks, Jim Vosika http://tinyclick.com FREE URL Shortening -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 10:07 AM To: CF-Talk Subject: OT: Dedicated Hosting We are looking for some additional Dedicated hosting and curious who else on this list uses dedicated hosting and their experience. Looking for some good prices (go figure). Thank you in advance (you can email off-list if you wish). Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Dedicated Hosting
$900/month seems pretty steepespecially when you have to maintain it yourself. Jim Vosika http://tinyclick.com FREE URL Shortening! -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 10:35 AM To: CF-Talk Subject: RE: Dedicated Hosting We use Rackspace - they're phenomenal, reasonably priced and extremely reliable. You maintain your own server and are responsible for your own software, backups, etc. Just like doing it in-house without the infrastructure expenses. For a basic system we pay about $900 mo. Intel 1.2 GHZ 512MB RAM 2 9GB SCSI Drives Hardware RAID Tape Backup 24/7 Support Rackspace's Fanatical Support is incredible - they're extremely helpful, knowledgeable and available 24/7. We've never waited longer than 15 minutes to see a resolution to ANY problem. They also sport 12 redundant connections and have a guarantee of less than 20-some seconds out of a month downtime. I highly recommend Rackspace. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:07 AM To: CF-Talk Subject: OT: Dedicated Hosting We are looking for some additional Dedicated hosting and curious who else on this list uses dedicated hosting and their experience. Looking for some good prices (go figure). Thank you in advance (you can email off-list if you wish). Paul Giesenhagen QuillDesign __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: whats wrong with cfform tag?
I have always wondererd, when is it better to use the cfform tage over a regular form tag? Just Curious, Jim Vosika http://www.tinyclick.com FREE URL Shortening -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 6:42 AM To: CF-Talk Subject: RE: whats wrong with cfform tag? negatory. just a simple straight forward cfform tag. i have seen this kind of strange result with everyone (cfform tag) i have ever tried to use...ill send the code soon.. tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 11:50 PM To: CF-Talk Subject: RE: whats wrong with cfform tag? Are you using a cflocation? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: lundi 1 juillet 2002 15:41 To: CF-Talk Subject: RE: whats wrong with cfform tag? i guess i cant send an attachment, well here is the graphic url. http://www.revolutionwebdesign.com/clients/coupons/what_is_this.gif thanks tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 11:34 PM To: CF-Talk Subject: whats wrong with cfform tag? why is it that sometimes i get weird header info crap at the top of a page that parses a cfform tag? the graphic i have attached will show you what kinds of stuff i see. thanks :[ frustrated in salisburytony Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.symantecwinfaxpro.com/ http://www.zonealarmprodownload.com/ http://www.nortonantivirusdownload.com/ http://www.nortonghost.net/ 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 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
REPOST: CF Server Error
Hi everyone, I keep getting an error that is getting really annoying and I was wondering if anyone knew why it was happening. First off, my website is one of many on a virtual server, hosted by Media3.net. Obviously right away this isn't ideal using a virtual server but for now that is what I got. Anyways, a few times a day when I am requesting a page all of a sudden the page will sit there and try loading for 30 seconds to a minute before erroring out with this message: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Then after it errors out everything will be fine again for a while. What I was wondering was could it be the server restarting, a cflock issue (I don't use locks and it is using a database if that matters) or could it just be a bad hosting company. Has anyone had this problem or know anything about what it might be? Thank you, Jim Vosika http://www.tinyclick.com http://www.tinyclick.com/ __ 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: REPOST: CF Server Error
Thank you everyone for you help, I would have responded earlier but I was taking a nap. :) After reading all of the responses I don't think it is my code that is the issue on the server because on that account it is mostly cfif's cfquery's and cfoutput's so not that I couldn't have made a mistake but it is probably other accounts on my shard server that are causing the services to restart or what ever is happening. I will probably have to look into a dedicated server this week, which probably isn't economical but it will cost less in Advil... Thank you all for you suggestions and insights, I really appreciate it alot. Take Care, Jim Vosika http://www.tinyclick.com FREE URL Shortening -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 1:51 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Just adding to the thrust, I would say this is pretty certainly a locking issue or a lack of. This error always accompanies memory corruption issues as a result of unlocked shared scope variables. You can only control your own code and in a shared environment other's code could be an issue. Here is what I suggest. If you have Application. - Server. - Session. variables in your application you should lock all reads and writes using the cflock tag. Hth Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 11:30 AM To: CF-Talk Subject: Re: REPOST: CF Server Error Hi Jim, I've typically seen this error in my applications when I've done something horribly wrong and ime it's usually accompanied by the cfserver service restarting. It's possible that it could be related to locking, although locking is typically not related to datasource issues ( although I've heard of it being used as a workaround for certain problems with MS Access ) and even when it is a database problem, you'll usually just get odbc errors rather than big-time cf server problems... It might be related to unlocked data manipulation in the application or more often session scopes... and unfortunately being on a shared server, it'd be difficult to say whether going through all of your own code and making sure all of your own stuff is locked would even solve the problem. Personally I think it'd be nice to see the hosting companies turning full-checking on on their shared servers, but for various reasons ( loss of performance, time on the phone with customers explaining locking, etc... ) it just doesn't happen that way. In any event, if you're using session, application or server ( I'd stay away from these on a shared server ) variables I would probably _start_ by making sure they're all locked and then if it continues I'd consider finding another host if it's bothersome enough. Wish I could provide more solid answers for you, Isaac www.turnkey.to 954-776-0046 __ 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: REPOST: CF Server Error
No I don't have any session. application. Or server. variables, just a few url. variables so locking shouldn't be the issue. I have never used locking and I was under the impression that you used cflock to lock the database when you were writing to it but I have since started auuiming that that is not the case and locking is for session. application. Or server. Variables. Thank you for the suggestion of cihost, I could always afford to save a few bucks. I will look into them Thanks! Jim Vosika http://www.tinyclick.com -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 4:39 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Jim, a couple of things, first a question do you have any Application. - Server. - Session. variables in your app, if so I would still check the locking issue prior to your moving to dedicated. Second a suggestion, when cost is an issue we use the dedicated hosting packages at www.cihost.com, they are good on Win2k systems and keep up with patches etc. It is most cost-effective there to have your own copy of ColdFusion. Their customer service can be a bit patchy at times but we have structured our internal systems to deal with that and they are very cost-competitive. Again hth. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 2:23 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Thank you everyone for you help, I would have responded earlier but I was taking a nap. :) After reading all of the responses I don't think it is my code that is the issue on the server because on that account it is mostly cfif's cfquery's and cfoutput's so not that I couldn't have made a mistake but it is probably other accounts on my shard server that are causing the services to restart or what ever is happening. I will probably have to look into a dedicated server this week, which probably isn't economical but it will cost less in Advil... Thank you all for you suggestions and insights, I really appreciate it alot. Take Care, Jim Vosika http://www.softwaresupermall.com http://www.webbomber.com -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 1:51 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Just adding to the thrust, I would say this is pretty certainly a locking issue or a lack of. This error always accompanies memory corruption issues as a result of unlocked shared scope variables. You can only control your own code and in a shared environment other's code could be an issue. Here is what I suggest. If you have Application. - Server. - Session. variables in your application you should lock all reads and writes using the cflock tag. Hth Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 11:30 AM To: CF-Talk Subject: Re: REPOST: CF Server Error Hi Jim, I've typically seen this error in my applications when I've done something horribly wrong and ime it's usually accompanied by the cfserver service restarting. It's possible that it could be related to locking, although locking is typically not related to datasource issues ( although I've heard of it being used as a workaround for certain problems with MS Access ) and even when it is a database problem, you'll usually just get odbc errors rather than big-time cf server problems... It might be related to unlocked data manipulation in the application or more often session scopes... and unfortunately being on a shared server, it'd be difficult to say whether going through all of your own code and making sure all of your own stuff is locked would even solve the problem. Personally I think it'd be nice to see the hosting companies turning full-checking on on their shared servers, but for various reasons ( loss of performance, time on the phone with customers explaining locking, etc... ) it just doesn't happen that way. In any event, if you're using session, application or server ( I'd stay away from these on a shared server ) variables I would probably _start_ by making sure they're all locked and then if it continues I'd consider finding another host if it's bothersome enough. Wish I could provide more solid answers for you, Isaac www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: REPOST: CF Server Error
I don't even know the os because it is a shared server. Connecting to access using standard cfquery and sql and I have no access to logs. It is when I use any page that the error could happen. I will be looking into new hosts this week because these errors are unacceptable. Thanks! Jim Vosika http://www.tinyclick.com FREE URL Shortening -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 4:51 PM To: CF-Talk Subject: Re: REPOST: CF Server Error What's the OS? How are you connecting to the database? What's the database? Is it the same page that causes this error? Can you check the logs? From what you wrote it looks as if the server is busy. On Sun, 30 Jun 2002, Jim Vosika wrote: Hi everyone, I keep getting an error that is getting really annoying and I was wondering if anyone knew why it was happening. First off, my website is one of many on a virtual server, hosted by Media3.net. Obviously right away this isn't ideal using a virtual server but for now that is what I got. Anyways, a few times a day when I am requesting a page all of a sudden the page will sit there and try loading for 30 seconds to a minute before erroring out with this message: Error Occurred While Processing Request Error Diagnostic Information Request canceled or ignored by serverServer busy or unable to fulfill request. The server is unable to fulfill your request due to extremely high traffic or an unexpected internal error. Please attempt your request again (if you are repeatedly unsuccessful you should notify the site administrator). (Location Code: 26) Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator). Then after it errors out everything will be fine again for a while. What I was wondering was could it be the server restarting, a cflock issue (I don't use locks and it is using a database if that matters) or could it just be a bad hosting company. Has anyone had this problem or know anything about what it might be? Thank you, Jim Vosika http://www.tinyclick.com http://www.powerdvd.tv __ 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 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: REPOST: CF Server Error
Thanks again for your help! Jim Vosika http://www.tinyclick.com FREE URL Shortening -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 5:47 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Just as an FYI, locking is an issue with databases, however, most database engines handle it internally so there's usually no significant need to go out of your way to handle it in a server-side scripting language like ColdFusion ... MS Access has been known to have a few issues, which is why it is occasionally handled externally with ColdFusion's cflock ( using a lock name ) or cftransaction tags. The cftransaction tag provides a means of accomplishing similar functionality as cflock using database specific odbc tools. Both have their strengths and weaknesses. Isaac www.turnkey.to 954-776-0046 No I don't have any session. application. Or server. variables, just a few url. variables so locking shouldn't be the issue. I have never used locking and I was under the impression that you used cflock to lock the database when you were writing to it but I have since started auuiming that that is not the case and locking is for session. application. Or server. Variables. Thank you for the suggestion of cihost, I could always afford to save a few bucks. I will look into them Thanks! Jim Vosika http://www.tinyclick.com -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 4:39 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Jim, a couple of things, first a question do you have any Application. - Server. - Session. variables in your app, if so I would still check the locking issue prior to your moving to dedicated. Second a suggestion, when cost is an issue we use the dedicated hosting packages at www.cihost.com, they are good on Win2k systems and keep up with patches etc. It is most cost-effective there to have your own copy of ColdFusion. Their customer service can be a bit patchy at times but we have structured our internal systems to deal with that and they are very cost-competitive. Again hth. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 2:23 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Thank you everyone for you help, I would have responded earlier but I was taking a nap. :) After reading all of the responses I don't think it is my code that is the issue on the server because on that account it is mostly cfif's cfquery's and cfoutput's so not that I couldn't have made a mistake but it is probably other accounts on my shard server that are causing the services to restart or what ever is happening. I will probably have to look into a dedicated server this week, which probably isn't economical but it will cost less in Advil... Thank you all for you suggestions and insights, I really appreciate it alot. Take Care, Jim Vosika http://www.softwaresupermall.com http://www.webbomber.com -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 1:51 PM To: CF-Talk Subject: RE: REPOST: CF Server Error Just adding to the thrust, I would say this is pretty certainly a locking issue or a lack of. This error always accompanies memory corruption issues as a result of unlocked shared scope variables. You can only control your own code and in a shared environment other's code could be an issue. Here is what I suggest. If you have Application. - Server. - Session. variables in your application you should lock all reads and writes using the cflock tag. Hth Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Webapper - Making the NET work -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 11:30 AM To: CF-Talk Subject: Re: REPOST: CF Server Error Hi Jim, I've typically seen this error in my applications when I've done something horribly wrong and ime it's usually accompanied by the cfserver service restarting. It's possible that it could be related to locking, although locking is typically not related to datasource issues ( although I've heard of it being used as a workaround for certain problems with MS Access ) and even when it is a database problem, you'll usually just get odbc errors rather than big-time cf server problems... It might be related to unlocked data manipulation in the application or more often session scopes... and unfortunately being on a shared server, it'd be difficult to say whether going through all of your own code and making sure all of your own stuff is locked would even solve the problem
RE: Julian Date Format output 0YYDDD
What is julian exactly? Just curious? Please give an example. Thanks, Jim Vosika http://www.softwaresupermall.com -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 10:57 AM To: CF-Talk Subject: Julian Date Format output 0YYDDD Does someone have a function built to convert the current date to a julian format? Thanks, Charles Nahm Sonic Networks Inc. __ 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: Julian Date Format output 0YYDDD
Missing an end quote in the second example -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 12:46 PM To: CF-Talk Subject: RE: Julian Date Format output 0YYDDD #julian(101001, MM/dd/)# =01/01/2001 and #julian(01/01/2001)# = 101001 Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 2:04 PM To: CF-Talk Subject: RE: Julian Date Format output 0YYDDD Thank you Robert. Could you provide a small usage sample for the function? Would it be like: JDate = '#Julian(Now(), '0YYDDD')#' Thanks, Charles Nahm -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 12:36 PM To: CF-Talk Subject: RE: Julian Date Format output 0YYDDD Here is what I have CFSCRIPT /** * Returns a gregorian date if a julian date is submitted, or returns a julian date if a gregorian date is submitted. * * @param date * @param outvar * @return Returns a date. * @author Robert Everland III ([EMAIL PROTECTED]) * @version 1, January 10, 2002 */ function julian(date, date_format) { if (isnumeric(date)) { if (len(date) eq 5) { date = 0 date; } if (left(date,3) LT 100) { yr = 19 right(left(date,3),2); } else { yr = 20 right(left(date,3),2); } days = right(date,3)-1; firstday = 1/1/ yr; return dateformat(dateadd(d,days,firstday),date_format); } else if (isdate(date)) { date = dateformat(date, mm/dd/); if (year(date) eq 1999) { return 0 left(99000+Dayofyear(date),5); } else { return left(1right(date,2)right(00Dayofyear(date),3),6); } } return Not a valid date; } /CFSCRIPT Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 25, 2002 12:41 PM To: CF-Talk Subject: RE: Julian Date Format output 0YYDDD -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] What is julian exactly? Just curious? Please give an example. Some archaic Unix based date format from what I can see. It is still used by some banks. The format is 0YYDDD, so today would be 002150 (assuming there have been 150 days total this year). Regards, Charles Nahm __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: SOT: Live Chat (Customer Service)
The Java Developers Journal issue for this month discusses interfacing AIM with Java but also why AOL blocks places like Trillian and what they do to get around it, it is pretty interesting. Check it out: http://tinyclick.com/?UCYQFS HTH, Jim Vosika http://TinyClick.Com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 9:43 AM To: CF-Talk Subject: Re: SOT: Live Chat (Customer Service) and don't forget that AOL blocks Trillian quite often (and MSN does sometimes as well) ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 24, 2002 7:29 AM Subject: Re: SOT: Live Chat (Customer Service) Trillian is a mutli-network IM client. Works with ICQ, AIM, Yahoo, MSN and even IRC I've not seen Trillian yet, but if you use ICQ you'll have a history of messages that you can save to files. That's probably a handy feature for customer service purposes. Bonnie E. Betts [EMAIL PROTECTED] www.bettsIT.com - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 21, 2002 10:43 AM Subject: RE: SOT: Live Chat (Customer Service) I've been thinking of that. I use Trillian, so I could use any of those... Hmm. Why not just use AIM or Yahoo Messenger. YahooMessenger, I believe has an Online/Not Online type feature set... plus, you can use it to leave messages to a person's yahoo email account if he or she is not there. -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 1:25 PM To: CF-Talk Subject: Re: SOT: Live Chat (Customer Service) Hey, I made SMB open-source. That means I can ask for other stuff for free. Doesn't it? ;) Free... bah... everyone wants things for free. ;P ;) Build your own! :) On Fri, 21 Jun 2002, Tony Schreiber wrote: Oh, let me add that I'm looking first for a free solution. ;p Humanclick (er, LivePerson) looks awesome, but I have no idea how much it costs. Any recommendations for a live customer service chat service or application? CF-based or not? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ 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 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: RE: SOT - Sys-con.com/cfdj
I subscribed to CFDJ about 4 months ago and like it, but for some reason I have been getting Java Developers Journal also and I know I didn't pay for it, anyone else that lucky? Jim Vosika -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 10:24 AM To: CF-Talk Subject: Re: RE: SOT - Sys-con.com/cfdj The first time I subscribed to their magazine, I didn't receive a copy for about 10 months. I then got an issue that was about 8 months old, in a tattered plastic bag with a big sticker on it that had an apology from the post office about the late delivery. My name and address was totally mangled on the magazine envelope. - Original Message - From: [EMAIL PROTECTED] Date: Monday, June 24, 2002 8:07 am Subject: RE: SOT - Sys-con.com/cfdj I just got my june issue last week or something. ~Todd On Mon, 24 Jun 2002, Tipton Josh (orl1jdt) wrote: I really like there magazine but I subscribed I think for 3 years some time ago like in March and finally received my first magazine in May. I have yet to recieve my June issue and june is almost up. Joshua Tipton -Original Message- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 9:55 AM To: CF-Talk Subject: RE: SOT - Sys-con.com/cfdj I tried to subscribe to their magazine online a year ago. After months of trying to get them to deliver a single copy of CFDJ to me, I finally gave up in frustration. -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 6:47 AM To: CF-Talk Subject: Re: SOT - Sys-con.com/cfdj Is it me or are they really hosing things up? Couldn't subscribe to their mailing list last friday, cfmx errors all over the place. Couldn't get to their site over the weekend.. and now this morning I'm seeing random problems between not being able to get to the main site to not being able to subscribe, etc. :p Anyone else seeing this problem? I just chalk it up to the fact that it's a God-awful web site. I gave up on trying to sift through its errors and its navigation system. I guess I'd be a little more pissed if it were my own money paying for the subscription rather than my company! Regards, Dave. __ 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: CFIF Statement
CFIF LEFT(LASTNAME,1) IS A#LASTNAME#/CFIF HTH, Jim Vosika http://www.softwaresupermall.com -Original Message- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:11 AM To: CF-Talk Subject: CFIF Statement Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter A, and order by lastnames, but the following is not working, any ideas? cfif LASTNAME IS A#LASTNAME#/cfif Thanks in advance, Kent __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Statement
Or somehow work in Query of Querys if it is appropriate for this task My 2¢ Jim Vosika http://www.softwaresupermall.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:23 AM To: CF-Talk Subject: Re: CFIF Statement cfif Left(LastName,1) eq A That said, I'd make the database do the work and run a query that only retrieves lastnames that start with A. my 2 cents Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Kent A. Orso [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 24, 2002 9:10 AM Subject: CFIF Statement Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter A, and order by lastnames, but the following is not working, any ideas? cfif LASTNAME IS A#LASTNAME#/cfif Thanks in advance, Kent __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFIF Statement
You could use Query of Query or simply: CFIF LEFT(LASTNAME,1) NEQ A#LASTNAME#/CFIF Jim Vosika http://www.softwaresupermall.com -Original Message- From: Kent A. Orso [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:42 AM To: CF-Talk Subject: Re: CFIF Statement Thanks for the information, how would I keep the database from displaying the remaining LASTNAME records that don't start with A? This is what I have thus far, CFQUERY DATASOURCE=clast NAME=list SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM olist ORDER BY LASTNAME /CFQUERY CFOUTPUT QUERY=list cfif Left(LastName,1) eq A#LASTNAME#/CFIF, #FIRSTNAME# #DEPARTMENT#BR /CFOUTPUT - Original Message - From: Randell B Adkins [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 24, 2002 12:13 PM Subject: Re: CFIF Statement CFIF LEFT(LASTNAME,1) EQ A#LASTNAME#/CFIF [EMAIL PROTECTED] 06/24/02 12:10PM Trying to do a CFOUTPUT Statement that returns all of the lastname records that begin with the letter A, and order by lastnames, but the following is not working, any ideas? cfif LASTNAME IS A#LASTNAME#/cfif Thanks in advance, Kent __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Firewall
BlackICE Server Protection - $299.95 http://shop.softwaresupermall.com/dr/v2/ec_MAIN.Entry17c?CID=34263SID=3 3655SP=10007PN=5PID=313036DSP=CUR=840PGRP=0CACHE_ID=34263 -Original Message- From: Andy Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 2:00 PM To: CF-Talk Subject: OT: CF Server Firewall Sorry for the Off Topic but does anyone know of a good server firewall program for Cold Fusion servers? It's seems as if some hackers are getting past our routers and I want to look into all options to lock it down more. My boss said I have to keep it under $1,000. Thanks, Andy Lynch Applications Developer WebPort, Inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Firewall
Sorry that link was split, here you go: http://tinyclick.com/?SERVER -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 2:02 PM To: CF-Talk Subject: RE: CF Server Firewall BlackICE Server Protection - $299.95 http://shop.softwaresupermall.com/dr/v2/ec_MAIN.Entry17c?CID=34263SID=3 3655SP=10007PN=5PID=313036DSP=CUR=840PGRP=0CACHE_ID=34263 -Original Message- From: Andy Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 2:00 PM To: CF-Talk Subject: OT: CF Server Firewall Sorry for the Off Topic but does anyone know of a good server firewall program for Cold Fusion servers? It's seems as if some hackers are getting past our routers and I want to look into all options to lock it down more. My boss said I have to keep it under $1,000. Thanks, Andy Lynch Applications Developer WebPort, Inc. __ 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: CF Server Firewall
Don't mean to self promote but we sell it for $299.95 http://tinyclick.com/?SERVER -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 2:06 PM To: CF-Talk Subject: RE: CF Server Firewall I like BlackIce from Internet Security Systems (www.iss.com) approx $399 per server Duane -Original Message- From: Andy Lynch [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 3:00 PM To: CF-Talk Subject: OT: CF Server Firewall Sorry for the Off Topic but does anyone know of a good server firewall program for Cold Fusion servers? It's seems as if some hackers are getting past our routers and I want to look into all options to lock it down more. My boss said I have to keep it under $1,000. Thanks, Andy Lynch Applications Developer WebPort, Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and PayPal
I would be interested just out of curiosity -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 15, 2002 3:02 PM To: CF-Talk Subject: Re: CF and PayPal Oh I want some additional info! :-) Lets get in touch to talk.. offlist? [EMAIL PROTECTED] or onlist if you would like (maybe others want to know). Mike - Original Message - From: Stacy Young To: CF-Talk Sent: Saturday, June 15, 2002 3:55 PM Subject: RE: CF and PayPal Ok so maybe I'm a little biased considering our company is in the payment processing biz. ;) At the moment you can interact with our API via CF's CFHTTP tag to send and receive your response in real-time. We've got some very cool additions launching in the near future involving MX / Java / .NET integration. All of our payment processing services will be made available as a suite of Web Services (Including reporting / data feeds)...you will even be able to tie-in directly through Flash MX if that's your operating environment. Gimme a shout if you need additional info. Stace -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 15, 2002 1:30 PM To: CF-Talk Subject: CF and PayPal Hi everyone. I have a shopping cart on a clients website and he would like to use paypal to process the final transaction. The entire cart is stored on the website, and he wishes to use just paypal for the payment regardless of how many items are in the cart, etc... Now, can this be done? Is there an API that I can use to do this? Has anyone made any custom tags for this? Basically, I would hope Paypal would return some kind of status and if the transaction went through I would record the order and send the order to the guy making the items, etc... anyone have any thoughts or comments. This has to be low budget, and that is why paypal is an options. I am open to other alternatives but the transaction fees need to be around paypal's (30 cents per transaction and 2.2% of total). Thanks, Mike __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion Apps You've Built
I have always heard that no matter what, there will be 2 programmers that look at and edit your code; the programmer you were when you wrote the code and the programmer you are now. With every project you will probably get a little better, even with a couple years experience under your belt... Jim Vosika http://www.softwaresupermall.com -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 12:31 PM To: CF-Talk Subject: Coldfusion Apps You've Built Hey guys, I'm 2 years in the CF game, and so far I've built a timesheet program, and events administration, countless shopping carts, pharmacy prescription app. But looking back at my code, it was verry bddd! Like I could think of a hundred places to do things differently, either form CF or from the database design. Obviously it was because of lack of experience Was there anything that you guys have built for past clients that you now know could have been coded better? __ 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 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: CFINSERT is dropping form fields
Have you tried using cfquery instead to see if atleast that works? cfquery datasource=#request.dsn# name=name: INSERT INTO tblProduct (form1, form2) VALUES('value1', 'value2'); /cfquery Jim Vosika http://www.softwaresupermall.com -Original Message- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 4:14 PM To: CF-Talk Subject: CFINSERT is dropping form fields Hello all... I'm using cfinsert to add a new row to my table...problem is cfinsert is dropping (not inserting) one of the form fields like it doesn't even exist. :( I have checked everything...verified the form field names, the database column names, and checked the debug to verify that all the form fields are present on the action page. This has worked flawlessly for months in CF5. The cfinsert looks like this: cfinsert datasource=#request.dsn# tablename=tblPRODUCT I cfdump'ed the entire form scope right before the cfinsert statement and verified that _everything_ is there. Any idea what can be happening here? I'm using: CFMX SQL Server 2000 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: CFINSERT is dropping form fields
Just a thought, did you happen to try adding the formfield attribute to your cfinsert statement? It's not required but who knows Jim Vosika http://www.softwaresupermall.com -Original Message- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 5:27 PM To: CF-Talk Subject: RE: CFINSERT is dropping form fields That solved the problem...but what is going on with CFINSERT...just me or do we have a bug in there somewhere? Anyone else see similar behavior? Chris -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:57 PM To: CF-Talk Subject: RE: CFINSERT is dropping form fields Have you tried using cfquery instead to see if atleast that works? cfquery datasource=#request.dsn# name=name: INSERT INTO tblProduct (form1, form2) VALUES('value1', 'value2'); /cfquery Jim Vosika http://www.softwaresupermall.com -Original Message- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 4:14 PM To: CF-Talk Subject: CFINSERT is dropping form fields Hello all... I'm using cfinsert to add a new row to my table...problem is cfinsert is dropping (not inserting) one of the form fields like it doesn't even exist. :( I have checked everything...verified the form field names, the database column names, and checked the debug to verify that all the form fields are present on the action page. This has worked flawlessly for months in CF5. The cfinsert looks like this: cfinsert datasource=#request.dsn# tablename=tblPRODUCT I cfdump'ed the entire form scope right before the cfinsert statement and verified that _everything_ is there. Any idea what can be happening here? I'm using: CFMX SQL Server 2000 __ 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 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
cffile Questions
Hey everyone, Is there a way with cffile or possibly cfhttp to grab an image from someone else's website and save it on my server, eg. http://www.google.com/images/logo.gif ? Thanks! Jim Vosika http://www.softwaresupermall.com http://www.softwaresupermall.com/ __ 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: cffile Questions
I'm tring this code and it is throwing an error, any idea how I should do it different? cfhttp url=http://www.google.com/images/logo.gif; resolveurl=1 throwOnError=No/cfhttp cffile action = upload fileField = #cfhttp.filecontent# destination = images/google.gif -Original Message- From: Douglas Williams [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 6:51 PM To: CF-Talk Subject: RE: cffile Questions Jim, You should use the CFHTTP tag with the URL of the image in the URL attribute. I'm also pretty sure you'll have to use the file attribute as well. HTH, Douglas -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 6:42 PM To: CF-Talk Subject: cffile Questions Hey everyone, Is there a way with cffile or possibly cfhttp to grab an image from someone else's website and save it on my server, eg. http://www.google.com/images/logo.gif ? Thanks! Jim Vosika http://www.softwaresupermall.com http://www.softwaresupermall.com/ __ 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 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: cffile Questions
Thank You Dave! Here is the code is anyone is interested: cfhttp method=Get url=http://www.google.com/images/logo.gif; path=E:\temp\ file=logo.gif Jim Vosika http://www.softwaresupermall.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 7:22 PM To: CF-Talk Subject: RE: cffile Questions I'm tring this code and it is throwing an error, any idea how I should do it different? cfhttp url=http://www.google.com/images/logo.gif; resolveurl=1 throwOnError=No/cfhttp cffile action = upload fileField = #cfhttp.filecontent# destination = images/google.gif You can save the file directly using the FILE attribute of CFHTTP. You can't reference CFHTTP.FileContent if it's not a character string, I don't think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Slashdot/cfc
I don't have the answer to your question but you spelt timestamp wrong in one spot :) - Jim Vosika http://www.softwaresupermall.com -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:04 PM To: CF-Talk Subject: RE: Slashdot/cfc Ok, Now this is bothering me. How is it that I have isDefined wrapped around each section of this code, but it still is saying that slashDot is undefined in application? I am trying to make it first see if the struct exists, if it does, see how old it is. If it is older than 30 minutes, execute the web service and get the latest feed. See anything glaring in the code below? Tim CFAPPLICATION name=slashDotFeed clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes setdomaincookies=Yes CFLOCK scope=APPLICATION timeout=30 CFIF not isDefined(application.slashDot) !--- create the structure since it doesn't exist right now --- CFSET application.slashDot = structNew() !--- add the timestamp, but make it over thirty seconds old so you will pull the xml --- CFSET application.slashDot.timeStam = dateAdd(n, -31, now()) CFINCLUDE template=slashDot.cfm CFELSE !--- now check for the xmlObject to be older than 30 minutes --- CFIF dateDiff(n, now(), application.slashDot.timestamp) gt 30 !--- invoke the web service to get the xml object --- cfinvoke webservice=http://webservices.isitedesign.com/ws/slashdotnews.cfc?wsdl; method=getXMLNews returnvariable=xmlObject !--- parse the xmlObject into the application scope to be reused for half an hour --- CFSET application.slashDot.xmlObject = xmlParse(xmlObject) /CFIF CFIF isDefined(application.slashDot) CFSET xmlObject = application.slashDot.xmlObject /CFIF /CFIF /CFLOCK -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:39 PM To: CF-Talk Subject: RE: Slashdot/cfc Yes, There is a web service to pull titles, links and images from. You can access it from: http://webservices.isitedesign.com/ws/slashdotnews.cfc?wsdl Now it returns an XML object. So I think I would create structure, in the application scope. One key would contain the XML object, the other would contain a timestamp from the last time you received the xml feed from the web service. Something like this in your Application.cfm should do the trick I think. Make sure it's below the cfapplication tag or it won't run. CFLOCK scope=APPLICATION timeout=30 CFIF not isDefined(application.slashDot.xmlObject) !--- create the structure since it doesn't exist right now --- CFSET application.slashDot = structNew() !--- add the timestamp, but make it over thirty seconds old so you will pull the xml --- CFSET application.slashDot.timeStam = dateAdd(n, -31, now()) /CFIF !--- now check for the xmlObject to be older than 30 minutes --- CFIF dateDiff(n, now(), application.slashDot.timestamp) gt 30 !--- invoke the web service to get the xml object --- cfinvoke webservice=http://webservices.isitedesign.com/ws/slashdotnews.cfc?wsdl; method=getXMLNews returnvariable=xmlObject !--- parse the xmlObject into the application scope to be reused for half an hour --- CFSET application.slashDot.xmlObject = xmlParse(xmlObject) /CFIF /CFLOCK Be aware I have not tested this. There may be mistakes (as you well know Crit). See you tomorrow :) Tim -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 9:41 PM To: CF-Talk Subject: Re: Slashdot/cfc I think I missed something... do they have a *web service* you can interact with (like th Google Web Service API)? All I see is an XML (and of course the RDF) file that you can grab, parse/transform, and format. That's great, but its not a CFC (which is no surprise since /. is Perl). Doesn't change the question much (How do I get my headlines updated) but wanted to see if there's actually a web service access to /. I'm missing :) Regards, John Paul Ashenfelter CTO/TransitionPoint [EMAIL PROTECTED] - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 7:16 PM Subject: Slashdot/cfc oi chatters SlashDot has a cfc that you can use, but on their faq they request that their xml file be hit only once every 30 minutes. So what would be a decent way to go about it? I was thinking cfhttp'ing the cfc
RE: Slashdot/cfc
Looks like you also spelt timestamp wrong in one spot :) - Jim Vosika http://www.softwaresupermall.com. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 11:13 PM To: CF-Talk Subject: RE: Slashdot/cfc quotes! isDefined(application.slashDot) Regards, Matthew Walker /* Easier, smarter forms: http://www.matthewwalker.net.nz/inform2 */ -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 June 2002 4:04 p.m. To: CF-Talk Subject: RE: Slashdot/cfc Ok, Now this is bothering me. How is it that I have isDefined wrapped around each section of this code, but it still is saying that slashDot is undefined in application? I am trying to make it first see if the struct exists, if it does, see how old it is. If it is older than 30 minutes, execute the web service and get the latest feed. See anything glaring in the code below? Tim CFAPPLICATION name=slashDotFeed clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes setdomaincookies=Yes CFLOCK scope=APPLICATION timeout=30 CFIF not isDefined(application.slashDot) !--- create the structure since it doesn't exist right now --- CFSET application.slashDot = structNew() !--- add the timestamp, but make it over thirty seconds old so you will pull the xml --- CFSET application.slashDot.timeStam = dateAdd(n, -31, now()) CFINCLUDE template=slashDot.cfm CFELSE !--- now check for the xmlObject to be older than 30 minutes --- CFIF dateDiff(n, now(), application.slashDot.timestamp) gt 30 !--- invoke the web service to get the xml object --- cfinvoke webservice=http://webservices.isitedesign.com/ws/slashdotnews .cfc?wsdl method=getXMLNews returnvariable=xmlObject !--- parse the xmlObject into the application scope to be reused for half an hour --- CFSET application.slashDot.xmlObject = xmlParse(xmlObject) /CFIF CFIF isDefined(application.slashDot) CFSET xmlObject = application.slashDot.xmlObject /CFIF /CFIF /CFLOCK -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 10:39 PM To: CF-Talk Subject: RE: Slashdot/cfc Yes, There is a web service to pull titles, links and images from. You can access it from: http://webservices.isitedesign.com/ws/slashdotnews.cfc?wsdl Now it returns an XML object. So I think I would create structure, in the application scope. One key would contain the XML object, the other would contain a timestamp from the last time you received the xml feed from the web service. Something like this in your Application.cfm should do the trick I think. Make sure it's below the cfapplication tag or it won't run. CFLOCK scope=APPLICATION timeout=30 CFIF not isDefined(application.slashDot.xmlObject) !--- create the structure since it doesn't exist right now --- CFSET application.slashDot = structNew() !--- add the timestamp, but make it over thirty seconds old so you will pull the xml --- CFSET application.slashDot.timeStam = dateAdd(n, -31, now()) /CFIF !--- now check for the xmlObject to be older than 30 minutes --- CFIF dateDiff(n, now(), application.slashDot.timestamp) gt 30 !--- invoke the web service to get the xml object --- cfinvoke webservice=http://webservices.isitedesign.com/ws/slashdotnews .cfc?wsdl method=getXMLNews returnvariable=xmlObject !--- parse the xmlObject into the application scope to be reused for half an hour --- CFSET application.slashDot.xmlObject = xmlParse(xmlObject) /CFIF /CFLOCK Be aware I have not tested this. There may be mistakes (as you well know Crit). See you tomorrow :) Tim -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 9:41 PM To: CF-Talk Subject: Re: Slashdot/cfc I think I missed something... do they have a *web service* you can interact with (like th Google Web Service API)? All I see is an XML (and of course the RDF) file that you can grab, parse/transform, and format. That's great, but its not a CFC (which is no surprise since /. is Perl). Doesn't change the question much (How do I get my headlines updated) but wanted to see if there's actually a web service access to /. I'm missing :) Regards, John Paul Ashenfelter CTO
RE: Hiding Info In View Source
External javascript files maybe... Jim -Original Message- From: Double Down [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 12:55 PM To: CF-Talk Subject: Hiding Info In View Source Does anyone know of a way to hide some form fields in the view source code? TIA DDINC __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Break apart CFHTTP request and store in database
I am doing a CFHTTP to a webpage that contains a table like this: table tr tda href=link1Link1Name/a/td tda href=link2Link2Name/a/td /tr tr tda href=link3Link3Name/a/td tda href=link4Link4Name/a/td /tr etc... /table There is actually about 400 table rows and the table results are changed often but I would like to be able to pull each of those links and their captions out of the table to be inserted into a database. Does anyone have the slightest idea of how I could do this? I have spent so many hours on this and gotten absolutely no where.. Thanks, Jim Vosika SoftwareSuperMall.Com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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: Break apart CFHTTP request and store in database
Oh that would be perfect! I'll look right now, thank you. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:54 PM To: CF-Talk Subject: Re: Break apart CFHTTP request and store in database Search the archive Jim, I asked this question a long time ago and posted one way to do it, and someone replied with an even better way. Unfortuneately I cant find the source right now. I'll dig around later and see if I can find it though. Basically the solution posted, was a way the parse an entire html docuement and get just the a tags out. From there the parsing would be easy... jon Jim Vosika wrote: I am doing a CFHTTP to a webpage that contains a table like this: table tr tda href=link1Link1Name/a/td tda href=link2Link2Name/a/td /tr tr tda href=link3Link3Name/a/td tda href=link4Link4Name/a/td /tr etc... /table There is actually about 400 table rows and the table results are change d often but I would like to be able to pull each of those links and their captions out of the table to be inserted into a database. Does anyone have the slightest idea of how I could do this? I have spent so many hours on this and gotten absolutely no where.. Thanks, Jim Vosika SoftwareSuperMall.Com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Simple Newbie Question
If I want to do a ReplaceNoCase()function where I am replacing color=#ff with something else how do I let CF know that I am replacing a # sign and that it is not a variable?? Jim Vosika SoftwareSuperMall.Com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Simple Newbie Question
I guess I don't understand what you are saying, do you mean like: cfset variables.test = #ReplaceNoCase(cfhttp.filecontent, color=###ff, new, ALL)# When I tried it this way I got an error: Invalid parser construct found on line 6 at position 11. ColdFusion was looking at the following text: Jim -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 1:27 PM To: CF-Talk Subject: RE: Simple Newbie Question Escape it with ## -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 2:26 PM To: CF-Talk Subject: Simple Newbie Question If I want to do a ReplaceNoCase()function where I am replacing color=#ff with something else how do I let CF know that I am replacing a # sign and that it is not a variable?? Jim Vosika SoftwareSuperMall.Com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Simple Newbie Question
That works! Thanks for your help. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 1:40 PM To: CF-Talk Subject: RE: Simple Newbie Question cfset variables.test = ReplaceNoCase(cfhttp.filecontent, color=##ff, new, ALL) -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 2:39 PM To: CF-Talk Subject: RE: Simple Newbie Question I guess I don't understand what you are saying, do you mean like: cfset variables.test = #ReplaceNoCase(cfhttp.filecontent, color=###ff, new, ALL)# When I tried it this way I got an error: Invalid parser construct found on line 6 at position 11. ColdFusion was looking at the following text: Jim -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 1:27 PM To: CF-Talk Subject: RE: Simple Newbie Question Escape it with ## -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 2:26 PM To: CF-Talk Subject: Simple Newbie Question If I want to do a ReplaceNoCase()function where I am replacing color=#ff with something else how do I let CF know that I am replacing a # sign and that it is not a variable?? Jim Vosika SoftwareSuperMall.Com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Escaping characters
Earlier Ben Forta told me that to escape a character like in: cfset variables.test = ReplaceNoCase(variables.testVar, TD bgcolor=#ff width=1, new code , ALL) that I needed to change #FF to ##FF so it doesn't think it is a variable. Now I am trying to replace table width=640 How do I work around the quotes? Thanks, Jim Vosika __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: Escaping characters
I guess I dont really understand why works as well as why ## works but thanks!! use two s as in table width=640 -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 11:35 PM To: CF-Talk Subject: Escaping characters Earlier Ben Forta told me that to escape a character like in: cfset variables.test = ReplaceNoCase(variables.testVar, TD bgcolor=#ff width=1, new code , ALL) that I needed to change #FF to ##FF so it doesn't think it is a variable. Now I am trying to replace table width=640 How do I work around the quotes? Thanks, Jim Vosika __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Looping over code and seperating out links
I need to loop over a page that just contains links to companies in it and separate out each link to be put into a database. I tried the following code: CFHTTP.../CFHTTP CFSET variables.start = a HREF= CFSET variables.end = /a CFSET variables.orginal_content =#variables.final_content# CFSET variables.edit_content=RefindNoCase('#variables.start#', variables.orginal_content) CFSET variables.final_edit_content=RefindNoCase('#variables.end#', variables.orginal_content, variables.edit_content) CFSET variables.final_content=mid(variables.orginal_content, variables.edit_content, variables.final_edit_content-variables.edit_content) As I expected, this just pulled the first link out. How would I loop over something like this to get each one, which will be put directly into a database as it's own record. Could be anywhere from 10-200 links, changes often. Does anyone have any suggestions? Thank you, Jim Vosika SoftwareSuperMall.Com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Advanced CFHTTP Q's - Logging onto websites
This question is just a shot out into left field but here goes. My example I am using below is an Amazon affiliate program where you can log on and view how much money you have made. Using CFHTTP or any other sort of tags, can you grab the affiliate login page, fill in the user name and password forms and then submit the form (assuming you knew the form names so CF could populate them and execute) Then once logged on you could have if follow a certain link to the page containing your balance then using simple CFHTTP pull the page and strip out your balance? I pretty much assume this is a big fat NO because right at the beginning with the Affiliate Login page, CF just pulls the source code (right?) and doesn't actually open a session giving it a chance to login (or am I mistaken??). Like I said it is a shot out into left field but I figured I would ask anyways. Thank you, Jim Vosika SoftwareSuperMall.Com __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
Setting Query results as a Variable
I am querying my Database and getting back multiple results, as you with any query. I would like to put those results into a Variable to be used in a CFFILE function like: CFFILE ACTION=WRITE FILE=file.html OUTPUT=#MyQueryVariable# Here is my query if it matters: CFQUERY DATASOURCE=createhtml NAME=QueryRNI SELECT * FROM RNI WHERE rniPID=225221 ORDER by rniSection, rniSortOrder; /CFQUERY cfoutput query=QueryRNI#rniContents#br/cfoutput - This outputs all the rows as needed. I tried setting the variable using: CFSET Variables.finalContents=#QueryRNI.rnoContents# and then outputting the variable in the CFFILE tag but that seemed to only return the first row of results. I also tried CFFILE ACTION=WRITE FILE=file.html OUTPUT=#QueryRNI.rnoContents# This also only gave back one row of results. Any suggestions on where to go from here? Is this a Query of Query's thing? I have never used QofQ before but I didn't think it was the solution. Thanks, Jim Vosika SoftwareSuperMall.Com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
HTML in Forms throwing page off
I'm just handling cosmetic problems on my page I have a form that I need to enter HTML code into but it throws my page off. Because I usually start by entering some /TD's which poses a problem. Is there some sort of tag I can wrap around the value so it so it doesn't do that? __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Find Replace on #cfhttp.filecontent#
Is there a way to do a find and replace function on the code returned from doing a cfhttp? I simply need to change a number every place that it appears Thanks. Jim Vosika SoftwareSuperMall.Com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Find Replace on #cfhttp.filecontent#
Awesome! Thanks. - Original Message - From: Andy Parry [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, February 04, 2002 10:49 PM Subject: RE: Find Replace on #cfhttp.filecontent# The following function will do it: rereplace( CFHTTP.FileContent, [0-9], *,ALL ) cheers! andy -Original Message- From: Jim Vosika [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 5 February 2002 12:41 PM To: CF-Talk Subject: Find Replace on #cfhttp.filecontent# Is there a way to do a find and replace function on the code returned from doing a cfhttp? I simply need to change a number every place that it appears Thanks. Jim Vosika SoftwareSuperMall.Com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
CFFTP Question
I have looked at Macromedia's documentation and it pretty much sucks for the CFFTP tag, could someone please help. I am trying to FTP a file to my other server and originally the file is l712 Bytes and once it gets to t destination it is 0 bytes. Could someone please tell me what was wrong in my code? CFFTP CONNECTION=FTP USERNAME=usr PASSWORD=dog SERVER=www.yahoo.com ACTION=Open STOPONERROR=Yes CFFTP ACTION=putfile USERNAME=usr PASSWORD=dog SERVER=www.yahoo.com LOCALFILE=testfile.txt REMOTEFILE=/test/uploadedfile.txt CFFTP ACTION=close CONNECTION=FTP STOPONERROR=Yes Thanks! Jim Vosika SoftwareSuperMall.Com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: CFFTP Question
I have tried the ExpandPath as shown below and when I use that, not a single file is created on the other server. And I can't use a fully qualified path because the server I am trying to FTP to is a virtual server account so I have no idea when the path would be to account. Before it made the file but it was 0 bytesAny more suggestions or am I screwed? CFFTP CONNECTION=FTP USERNAME=usr PASSWORD=dog SERVER=www.yahoo.com ACTION=Open STOPONERROR=Yes CFFTP CONNECTION=FTP ACTION=putfile SERVER=www.yahoo.com LOCALFILE=/test/stuff.txt REMOTEFILE=#ExpandPath('newstuff.txt')# CFFTP ACTION=close CONNECTION=FTP STOPONERROR=Yes Thanks! Jim Vosika SoftwareSuperMall.Com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 8:00 PM To: CF-Talk Subject: Re: CFFTP Question I think you need a fully qualified path to the local file, as in LOCALFILE=C:\somedirectory\myfile.txt If you know it's in the same directory as the CF template, you can use LOCALFILE=#ExpandPath('myfile.txt')# I usually use a cached connection, in which I open the connection, perform one or more ftp operations over the connection, then close it. If that's what you're trying to do, then you don't want to specify the username and password again in the putfile operation (this opens a new connection). Instead, list the name of the connection that you opened previously, by using 'CONNECTION=FTP'. Alternately, if this is you're only ftp operation, supply the username/password in the putfile, but don't bother opening and closing a connection. Jim - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 02, 2002 6:39 PM Subject: CFFTP Question I have looked at Macromedia's documentation and it pretty much sucks for the CFFTP tag, could someone please help. I am trying to FTP a file to my other server and originally the file is l712 Bytes and once it gets to t destination it is 0 bytes. Could someone please tell me what was wrong in my code? CFFTP CONNECTION=FTP USERNAME=usr PASSWORD=dog SERVER=www.yahoo.com ACTION=Open STOPONERROR=Yes CFFTP ACTION=putfile USERNAME=usr PASSWORD=dog SERVER=www.yahoo.com LOCALFILE=testfile.txt REMOTEFILE=/test/uploadedfile.txt CFFTP ACTION=close CONNECTION=FTP STOPONERROR=Yes Thanks! Jim Vosika SoftwareSuperMall.Com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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: CFFTP Question
Jim, That did it, I wish you knew how happy I was right now! Thank you s much for your help! -Jim -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 9:25 PM To: CF-Talk Subject: Re: CFFTP Question You need the fully qualified path of the _local_ file, not the remote file. The local file is the file on your CF server, the remote file is the destination file on the FTP server. CFFTP CONNECTION=FTP ACTION=putfile SERVER=www.yahoo.com LOCALFILE=#ExpandPath('testfile.txt')# REMOTEFILE=/test/uploadedfile.txt Jim - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 02, 2002 7:29 PM Subject: RE: CFFTP Question I have tried the ExpandPath as shown below and when I use that, not a single file is created on the other server. And I can't use a fully qualified path because the server I am trying to FTP to is a virtual server account so I have no idea when the path would be to account. Before it made the file but it was 0 bytesAny more suggestions or am I screwed? CFFTP CONNECTION=FTP USERNAME=usr PASSWORD=dog SERVER=www.yahoo.com ACTION=Open STOPONERROR=Yes CFFTP CONNECTION=FTP ACTION=putfile SERVER=www.yahoo.com LOCALFILE=/test/stuff.txt REMOTEFILE=#ExpandPath('newstuff.txt')# CFFTP ACTION=close CONNECTION=FTP STOPONERROR=Yes Thanks! Jim Vosika SoftwareSuperMall.Com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 02, 2002 8:00 PM To: CF-Talk Subject: Re: CFFTP Question I think you need a fully qualified path to the local file, as in LOCALFILE=C:\somedirectory\myfile.txt If you know it's in the same directory as the CF template, you can use LOCALFILE=#ExpandPath('myfile.txt')# __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
CFHTTP
I recently made a simple page using CFHTTP that pulled a webpage and displayed it. What I heard could be done with CFHTTP was you could pull a page and have CF look at the source and only display certain parts that are between a start and end point that you specify. Could someone give me an example of this? Thanks, Jim Vosika __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
CFFILE/VARIABLES - Dumb Question
No question is too dumb until you read below. I don't know if I am just having a brain fart or what, I am still new to CF but I should know this: I am uploading a file to my server using CFFILE then I want to write the location of the file to the database in this format: #cffile.ServerDirectory#/#cffile.serverFile# My current CFINSERT/CFSET looks like: CFSET uploadedFile=#cffile.ServerDirectory#/#cffile.serverFile# cfinsert datasource=test TABLENAME=Table1 formFields = vehicleType,modelYear,manufacturerName,vehicleDescription How do I get it to pull the value from my variable and put it into the database using CFINSERT or other method? Right now it is just inserting form values from the previous page. Any Suggestions? Thanks! Jim __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: CFFILE/VARIABLES - Dumb Question
That works good enough for me! Thanks for your late-night help! Jim -Original Message- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 2:22 AM To: CF-Talk Subject: Re: CFFILE/VARIABLES - Dumb Question At 02:13 AM 1/18/02 -0600, you wrote: No question is too dumb until you read below. I don't know if I am just having a brain fart or what, I am still new to CF but I should know this: I am uploading a file to my server using CFFILE then I want to write the location of the file to the database in this format: #cffile.ServerDirectory#/#cffile.serverFile# My current CFINSERT/CFSET looks like: CFSET uploadedFile=#cffile.ServerDirectory#/#cffile.serverFile# cfinsert datasource=test TABLENAME=Table1 formFields = vehicleType,modelYear,manufacturerName,vehicleDescription How do I get it to pull the value from my variable and put it into the database using CFINSERT or other method? Right now it is just inserting form values from the previous page. I'm not sure that it's the best solution, but have you tried cfset form.uploadedFile=#cffile.ServerDirectory#/#cffile.serverFile# Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Passing variables through a URL
Hi, I know it's late but I have a newbie question for anyone awake. I am trying to make a text link that would sort records from a query. I would like to pass the parameter through the URL that says which column to sort by but can't figure out how. This brings up another question, am I using SQL/CFML properly to sort records on the fly. If you could tell me how to pass the url variable that would be wonderful! Here is my code so far: CFPARAM NAME=orderBy default=vehicleType CFQUERY DATASOURCE=test NAME=listVehicles SELECT * FROM Table1 ORDER BY #orderBy# /CFQUERY table CELLSPACING=3 tr td align=centerb!---This is where I am attempting the first linkVehicle Type/b/td td align=centerbYear/b/td td align=centerbManufacturer/b/td td align=centerbDescription/b/td /tr CFOUTPUT query=listVehicles tr td#vehicleType#/td td align=center#modelYear#/td td align=right#manufacturerName#/td td#vehicleDescription#/td /tr /CFOUTPUT /table Please be critical if there are better ways to do things. This is my first CFM page ever. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Passing variables through a URL
Bud, Thank you so much for taking that much time to explain it to me! You have been VERY helpful! Thanks! Jim Vosika (newbie) -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 8:53 AM To: CF-Talk Subject: Re: Passing variables through a URL On 1/12/02, Jim Vosika penned: Hi, I know it's late but I have a newbie question for anyone awake. I am trying to make a text link that would sort records from a query. I would like to pass the parameter through the URL that says which column to sort by but can't figure out how. This brings up another question, am I using SQL/CFML properly to sort records on the fly. If you could tell me how to pass the url variable that would be wonderful! Here is my code so far: Hi Jim. This is the easiest way, but less secure as it will display the table names and allow for someone to manually enter a string to pass to the query: CFPARAM NAME=url.orderBy default=vehicleType CFQUERY DATASOURCE=test NAME=listVehicles SELECT * FROM Table1 ORDER BY #url.orderBy# /CFQUERY tr td align=centerba href=mypage.cfm?orderBy=vehicleTypeVehicle Type/a/b/td td align=centerba href=mypage.cfm?orderBy=modelYearYear/a/b/td td align=centerba href=mypage.cfm?orderBy=manufacturerNameManufacturer/a/b/td td align=centerba href=mypage.cfm?orderBy=vehicleDescriptionDescription/a/b/td /tr To add some security, we could check for the valid url variables, changing them to something a little shorter and hiding the table names in the process: CFPARAM NAME=url.orderBy default=vt cfswitch expression=#url.orderBy# cfcase value = my cfset variables.orderBy = modelYear /cfcase cfcase value = mn cfset variables.orderBy = manufacturerName /cfcase cfcase value = vd cfset variables.orderBy = vehicleDescription /cfcase cfdefaultcase cfset variables.orderBy = vehicleType /cfdefaultcase /cfswitch CFQUERY DATASOURCE=test NAME=listVehicles SELECT * FROM Table1 ORDER BY #variables.orderBy# /CFQUERY tr td align=centerba href=mypage.cfm?orderBy=vtVehicle Type/a/b/td td align=centerba href=mypage.cfm?orderBy=myYear/a/b/td td align=centerba href=mypage.cfm?orderBy=mnManufacturer/a/b/td td align=centerba href=mypage.cfm?orderBy=vdDescription/a/b/td /tr This way if anyone manually enters anything other than orderBy=vt (or my, mn or vd) vehicleType will be passed to the Order By clause in the query. Plus as I said, you won't be revealing the table names. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Include a Dynamic Page
I am very, very new to Cold Fusion and I was wondering how you would place a dynamic webpage, let's say and Amazon product for example, into an existing website template? Ultimately what I want to do is: say I am an affiliate of Amazon.com, I want someone to be able to come to my website, click on the books section and see Amazon within my site template, click on a link such as Amazon's shopping cart and again stay within my websites template, through out the entire Amazon order process. I know this is easily achievable with frames but I absolutely hate frames so that is an option I am trying to avoid. Does anyone have any suggestions? Thank you, Jim Vosika SoftwareSuperMall.Com __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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: Include a Dynamic Page
Amazon was actually just an example to show what I needed done. Do you have any more insight on how I would go about doing this or where I could look for answers? Thank you, Jim Vosika SoftwareSuperMall.Com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 2:05 PM To: CF-Talk Subject: Re: Include a Dynamic Page This could potentailly happen via CFHTTP (not an easy task though), but I'd make dang sure Amazon knows what you're up to and they say it's OK ;-) Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Jim Vosika [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 07, 2002 11:53 AM Subject: Include a Dynamic Page I am very, very new to Cold Fusion and I was wondering how you would place a dynamic webpage, let's say and Amazon product for example, into an existing website template? Ultimately what I want to do is: say I am an affiliate of Amazon.com, I want someone to be able to come to my website, click on the books section and see Amazon within my site template, click on a link such as Amazon's shopping cart and again stay within my websites template, through out the entire Amazon order process. I know this is easily achievable with frames but I absolutely hate frames so that is an option I am trying to avoid. Does anyone have any suggestions? Thank you, Jim Vosika SoftwareSuperMall.Com __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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