Re: Help With CF8 Regular Expressions
It's all good, I've got a towel to sit on! :Den Well I guess that makes you a hoopy frood then! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Variable naming and reserved scope names.
In the Live Docs - ColdFusion Developer's Guide, under the subject Using scopes, you will find the following quote: Because ColdFusion must search for variables when you do not specify the scope, you can improve performance by specifying the scope for all variables. I have always taken this for gospel. However, I was debugging an application that makes me question that statement. It seems that one of our developers named a query request. (cfquery name=request.../cfquery) This made for some very confusing code such as cfoutput#request.recordID#/cfoutput. In this case request.recordID is really variables.request.recordID. This got me thinking about how ColdFusion evaluate variables. It is clear in this case that ColdFusion first checked the request scope for recordID and not finding it there checked the other scopes for request.recordID and found it in the variables scope. I wrote the example below to demonstrate this issue. We are are CF 7 shop so I have not tested this in CF 8. cfscript form.session = structNew(); form.session.type = I live in the form scope.; form.session.token = bogus token; /cfscript cfoutput session.type = #session.type#br session.cftoken = #session.cftoken#br /cfoutput hr cfdump var=#form# label=form scopebr cfdump var=#session# label=session scopebr cfdump var=#variables# label=variables scope I have the following questions: 1. Does the same thing happen in CF7 and CF8? 2. Why doesn't ColdFusion stop searching after checking the session scope, as implied by the Live Docs statement. Well in any case this is either a good argument for scope-prefixing all variables (form.session.type, variables.request.recordID, etc) and/or an argument for prohibiting the naming of variables with reserved scope names (form, request, etc). ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Variable naming and reserved scope names.
Ok here is the output in CF7 session.type = I live in the form scope. session.cftoken = 72624939 [form scope - struct ] [SESSION][form scope - struct ] [TOKEN ][bogus token ] [TYPE ][I live in the form scope.] [session scope - struct ] [cfid ][200 ] [cftoken ][72624939 ] [sessionid][SCOPENAME_200_72624939 ] [urltoken ][CFID=200CFTOKEN=72624939] [variables scope - struct [empty]] Scoping and avoiding using reserved scopes outside of their intended uses keep you from playing the guessing game of which will take precedent. For the record, I completely agree with you. But still it is disterbing that ColdFusion doesn't stop searching for type beyond the session scope. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Variable naming and reserved scope names.
(from: http://livedocs.adobe. com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp. htm?context=ColdFusion_Documentationfile=0914.htm ) I just reread the quote Because ColdFusion must search for variables when you do not specify the scope, you can improve performance by specifying the scope for all variables. I now realize my thinking was incorrect. I was thinking that by specifying the scope that this would prevent (short circuit, like the logic of an AND operator) ColdFusion from searching the other scopes to find the variable in question. Clearly I was wrong. The real affect of specifying the scope, is to cause ColdFusion to check that scope first. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help with Ajax Grid.
We have had good success with dhtmlxGrid. It has built-in AJAX support. We use it in conjunction with JSMX for our AJAX communication. http://www.scbr.com/docs/products/dhtmlxGrid/ -John Hi all, I was wondering if anyone has any recommendations for a very simple to implement Ajax style grid. I have been assigned a project here and of course it needs to be done by Monday morning. I am trying to find a grid that will allow me to having a paging option and the ability to add/update a record. I can find plenty of .Net based grids, but I am having a hard time finding a CF based grid. What they want is a grid that will display say 10 records with a paging control for the next record(s) and of course the ability to edit/update or create a new record on the fly. Thanks mario = = Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html = = ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Calling a Coldfusion Variable From a .js File
First, I want to reiterate an AJAX solution is probably best. However, if AJAX is out of the question a secure has WILL work. Let me clarify that... 1. CFC generates a CAPTCHA (EX: ABC123) 2. CFC hashes the CAPTCHA (EX: A6B7D8991A) 3. CF sends the HTTP response with the hash and a JShash() method. 4. Upon submit (or whatever event desired) JSHash is called passing user_input_CAPTCHA. 5. JSHash returns a hash of user_input_CAPTCHA and it is compared to the CAPTCHA hash (EX: A6B7D8991A) has sent by the CFC. 6a. If they match, post the form to the server (user_input_CAPTCHA is sent to the server) 6b. If they don't match, tell the user to try again. (goto 4) 7. CF can hash form.user_input_CAPTCHA and verify it again. a. The unhashed CAPTCHA is never sent to the browser. b. The hashed CAPTCHA is never sent to the server. c. Considerable computing power could be user to dehash the hash so that it could be input into the form and there by breaking CAPTCHA. But if a spammer has that much time and expertise they are going to break your system anyway. For that matter the spammer should move to hacking if they have such a skill set. It is quite a bit to go through, but if AJAX is not an option a hash will work. -John A secure hash might be what the doctor ordered. CF could send a hashed version of the answer then you could run js code to hash the users input before the compare. I haven't read the whole thread, but if you send the hash to the browser, anybody could just see the hash and ensure that gets sent again to the server when appropriate. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275357 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Calling a Coldfusion Variable From a .js File
A secure hash might be what the doctor ordered. CF could send a hashed version of the answer then you could run js code to hash the users input before the compare. Here is one site that has some JS hash algorithms. http://pajhome.org.uk/crypt/md5/ The only problem is you will need to analyze the JS code and create a CF counterpart. It would take a bit of work on your part, but I think outside of an Ajax solution it is your best bet. You will need to explain more on waht you want to do, if you processing the page at runtime the #variable# will still work. However if it is already processed and sitting on the client you will need to let us know what you want to do, programs like DWR, ajaxCFC and CFJsonService all allow for information to be returned back to the client to then do what you want to do. but your question is not specific enough to help you. On 4/13/07, Byte Me [EMAIL PROTECTED] wrote: Does anyone know how to call a Coldfusion variable from a .js file, without converting the variable in a .cfm file? Hi Andrew, I have a form that has a CAPTCHA on it, the answer to the CAPTCHA is stored in a CF SESSION variable. I use JavaScript to check the form contents being submitted, which (now includes a CAPTCHA challenge). If I convert the answer to js format(in the form), and then call it from the external .js file, that will work fine, but the problem is, I made the answer available to any bots, because it is now in the source code of the form. What I am trying to do is get the contents of the SESSION variable into the .js file, without compromising the answer. I think however it may make more sense for me to simply have the challenge in a separate template(that the user must go through first), before allowing him access the form. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF7 Hosting company
I used Viux, but their CF servers intermittently fails... and their tech support are not too familiar with CF either. Well I canât speak for Mr. Carluenâs experience with ViUX. My onw experience is that I have never know the CF sever to go down. Once, the mail server did go down. It was clearly posted on the status page and although they did not offer an estimated down time, they were back up in about two hours. The nature of âsharedâ hosting is that you can be affected by what the other sites are doing. SO it is possible that Mr. Carluenâs sites were on a server with a rogue site. But who knows. I have always found their support team to be knowledgeable and helpful. But, I must admit that I have never had a CF specific question to ask them. They also have the following tags disabled: CFContent CFDirectory CFExecute CFFTP CFIndex CFRegistry CFSchedule Well yes and no. Yes, they did have these tags disabled but all the NEW servers have ALL tags enabled except, CFExecute and CFRegistry. All the old servers are currently being migrated. I canât speak for HostMySite either, but I do know that have a pretty good reputation and some snazzy print ads. For me my experience with ViUX has been good and so they keep my business. With Viux, you'll definite get what you'd pay for. Well, I would agree, however, for me that that has always been a good thing. PS: Yes ViUX does host ColdFusion but it is an option on any of their plans under the new plans structure. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best CF7 Hosting company
I use ViUX, I have six sites with them. There just recently restructured their plans a bit, so I am not entirely familiar with the new plans. However, they have both Windows and Linux servers. There support has been awesome and quick, when needed which is not much. Lots of features and lots of control, more than on any other shared plan that I have seen. http://hosting.viux.com/services/shared/shared-plans.asp Hi: I need a Cf7 hosting. What is the best? thanks benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Serving XML without CFCONTENT
I rewrote an application of mine using XML and web services. However, when I uploaded it to my hosting server I learned that CFCONTENT was disabled. This was a problem because I knew of no other method for setting the mime type to XML. I found several articles on serving image content via CFMX, without using CFCONTENT. Of those I found, Using ColdFusion to Write Out Binary Data by Christian Cantrell, was the best. However, it took a bit of fiddling to make it work with XML. Below is my solution. If this is of any use to you great. If you have a better method of serving XML without using CFCONTENT please share it. cfscript function stripNonTag(sInput){ sInput = reReplace( sInput, [\s\r\n]*, , all ); return sInput; } function stringToByteArray(s, compressFlag){ var byteArray = ArrayNew(1); var sLen = 0; var i = 1; var byteValue = 0; if(compressFlag) s = stripNonTag(s); sLen = Len(s); for(i=1; i LTE sLen; i = i + 1){ byteValue = Asc(Mid(s, i, 1)); ArrayAppend(byteArray, byteValue); } return byteArray; } function serveXML(xmlString, compressFlag){ var xmlBytes = stringToByteArray(xmlString, compressFlag); context = getPageContext(); context.setFlushOutput(false); response = context.getResponse().getResponse(); out = response.getOutputStream(); response.setContentType(text/xml; charset=utf-8); response.setContentLength(ArrayLen(xmlBytes)); out.write(xmlBytes); out.flush(); out.close(); } /cfscript ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Serving XML without CFCONTENT
Is your webservice returning XML? Teddy On 10/19/06, John Morgan [EMAIL PROTECTED] wrote: Yes it is. I call the serveXML function to send an XML response. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257395 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF7 hosting; cheap but reliable?
I use viux.com. The price is great, about $60.00 a year. The support is quick and helpful. The control panel is great. Downtime, what is that? OK, in one year there was a period of about 40 mins once when the mail server was down. -John- PS: I host six sites with viux. Hi: I need a CF7 hosting that doesn't cost very much cause I need it for personal use but a reliable one that doesn't be down all the time and has a good email server. What do you suggest? Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CreateDateTime function??
In light of this new information my original suggestion still stands. If you format your data as a string (EX: ww:dd:hh:mm) then it will sort correctly (assuming you zero pad 3 = 03) and pure string comparison will yield correct results. ( 00:03:11:15 GT 00:03:11:25 ) -John- At 09:11 AM 12/18/2002 +, you wrote: Hi, My intention is to allow a user to select 'how long' eg, months, weeks, days, hours, minutes, it took to solve a problem, this information will then be stored as one field in the database. It is the intention that searches etc can be carried out on this information for comparison. Thanks for the help so far, Lisa -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 04:27 To: CF-Talk Subject: RE: CreateDateTime function?? Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the request was to store it. Lisa: Can you confirm on your question? is, how to store the selected values into one field of my database? Am not sure what your purpose is behind all this. ***Logically.. you would just give a drop down of dates(MM-DD-) HH:MM*** If i understand the question correctly.. User comes in and selects something to happen(e.g Email me cheap flights after this period) 2 weeks 3 days 5 hours 10 minutes... Yes the question is how do you store weeks days hours and minutes... My understanding is a future dateTime has to be created and the database field would be a DateTime field.. in that case...? cfscript //create a default current date with form data... myDate=CreateDateTime(year(now()),month(now),day(now()),form.hrs,form.mins,s econd(now)); //adding weeks here myDate=DateAdd(ww,form.ww,myDate()); //adding days here myDate=DateAdd(d,form.dd,myDate()); /cfscript myDate would be the future date created from the form.. to be inserted into the database in one DateTime FIELD. Joe -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 6:58 PM To: CF-Talk Subject: Re: CreateDateTime function?? Joe Eugene wrote: All you need is create a default date and use function DateAdd(,defaultDate) and create whatever..date you want. Check previous post for code. Why add a date if you want to store an interval? I mean, if you want to calculate a new date it is the obvious route, but the request was to store it. Isn't creating a new date and converting that new date back to an interval when you need to extract the interval just a whole lot of extra hassle? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: CreateDateTime function??
Good point. My method would make the data more readable in the database but your method would be more flexible. -John- At 04:54 PM 12/18/2002 +0100, you wrote: John Morgan wrote: In light of this new information my original suggestion still stands. If you format your data as a string (EX: ww:dd:hh:mm) then it will sort correctly (assuming you zero pad 3 = 03) and pure string comparison will yield correct results. ( 00:03:11:15 GT 00:03:11:25 ) But you can't do math on it without resorting to ugly workarounds. One of the nice parts of a good interval implementation in a DBMS is that many operations just work automatically. For example, if you want to add 2 intervals, just use interval + interval. Division/multiplication by numbers, substracting intervals, they all work using the normal arithmetic operators. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CreateDateTime function??
For what you are doing a date field does not seem appropriate. If you really want to store the data in a single field I would store it as a delimited string. (EX; ww:dd:mm:hh) You would then use the list functions *(EX: ListGetAt() ) to extract the data. -John- At 06:17 PM 12/17/2002 +, you wrote: I'm new to CF and I have hit a wall. I have 4 select lists (numeric); Weeks Days Minutes Hours and I need the user to select a value from each of these lists. The problem is, how to store the selected values into one field of my database? I cannot see how CreateDateTime as weeks is not included in the function. Thanks in advance Lisa ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: can't listappend w/ double pipe delimiter?
You can, however, use non-printing characters like the ASCII bel as list delimiters, which can be helpful if you have a list of user-input data and aren't sure what it might contain. I recommend using tab (chr 9 for items) and carriage return (chr 13 for records) as delimiters because if you need to dump the values they format nicely if wrapped in a pre tag. -John- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: HELP! Preferences page
Assuming that your query is returning a boolean field that indicates the include state, you could order on this field and use the GROUP option of the CFOUTPUT tag and some conditional logic to control formatting the output. Pseudo-example Code: cfoutput query=myquery cfif myquery.showthis Preferences: (Click to omit directories from listing) cfelse Preferences: (Click to add directories to listing) /cfif cfoutput group=showthis !--- your form input code here --- /cfoutput /cfoutput At 09:48 AM 11/14/2002 -0500, you wrote: Hi, I have a preferences page that lists directories with check boxes. This is displaying by querying my database. It looks something like this: Preferences: (Click to omit directories from listing) [ ] dir1 [ ] dir2 [ ] dir3 [ ] dir4 [ ] dir5 [ UPDATE ] Preferences: (Click to add directories to listing) No directories selected. [ UPDATE ] So if the user checked on boxes dir2 and dir4 and clicks on the update I then want the screen to appear like: [ ] dir1 [ ] dir3 [ ] dir5 [ UPDATE ] Preferences: (Click to add directories to listing) [ ] dir2 [ ] dir4 [ UPDATE ] I'm not how to make this happen using my queries? --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
Re: OT: CSS2 and NetScape
Can you provide a code snip-it of the problematic CSS? -John- At 01:48 PM 11/6/2002 -0500, you wrote: All, I apologize for t he off-topic post but I am having a terrible time finding another resource. I have a site on which I am using a CSS2 style sheet (validated) to format the content. IE6 displays it beautifully. NS messes it up copmpletely. I think it is because NS hasn't implemented the position attribute. Does anyone know of a good source of information or support, preferably free? If curious, the site is http://www.buildacourse.com . Thank you, Robert Robert J. Polickoski Senior Programmer, ISRD Inc. (540) 842-6339 [EMAIL PROTECTED] AIM - RobertJFP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: CF Quiz on Macromedia.com
I think they mean that the path is one that is relative to the calling template as opposed to being relative to the HTTP request path. However, I do agree that the wording is poor. -John- At 08:12 AM 10/28/2002 -0500, you wrote: The path used in the template attribute in the cfinclude tag is... The Calling Template Relative Path That is either unclear or wrong . If I put the relative path to the calling template in the template attribute of the cfinclude tag, the template will call itself (I.E. recursion ). We really want is the Called Template Path Relative to the Calling Template -- Jeffry Houser | mailto:jeff;farcryfly.com DotComIt, Putting you on the web AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Re: OT: SQL Server database problem
You should either trim the text being inserted using the left function ... EXAMPLE: Left(form.MessageTeaser, 16 ) or you should expand the size of the field in the table. If this is data input via a form you could use the size option in the input tag to enforce the size restriction but I would still trim the data with the left function for safety sake. EXAMPLE: input type=Text name=MessageTeaser size=16 -John- At 02:58 PM 10/28/2002 +, you wrote: ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I have a SQL Server 7 database and I am trying to insert a large amount of text, passed by a ColdFusion form, into a table within this database. The problem I am having is a ODBC Error Code = 22001 (String data right truncation) error. My table design is like this. Column name DatatypeLength MessageID int 4 MessageType char20 Department char20 CreationDatechar15 PublicationDate char15 MessageTitletext16 MessageTeaser text16 MessageBody text16 I think that the problem is when the text is being added to the fields, MessageTitle, MessageTeaser and MessageBody. This is the complete error message: ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. SQL = INSERT INTO Messages ( MessageType, Department, CreationDate, PublicationDate, MessageTitle, MessageTeaser, MessageBody, Status ) VALUES ( 'None', 'Housing', '28/10/2002', 'Awaiting', 'Some text to throw error', 'Some text to throw error, Some text to throw error', 'Some text to throw error,Some text to throw error and Some text to throw error', 'Awating Approval' ) Data Source = WIRE_USERS The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (24:1) to (24:57) in the template file E:\INETPUB\WWWROOT\WIRE\MESSAGES\SENDFORAPPROVAL.CFM. Anyone know how I can fix this error? Thanks Stephen ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: Application Framework problem
Try pnbsp;/p that can't be stripped out! Or try BRBR Some folks like using hr size=1 at the start of their footers and that forces seperation. -John- At 09:03 AM 10/28/2002 -0600, you wrote: A CFMX new guy question. I'm building an Intranet using Application Framework where Application.cfm calls a header and, via OnRequestEnd, a footer page that are added to the top and bottom of whatever page is being displayed. Pretty standard stuff. However, particularly on displaying longer Master pages tables in a Master/Detail set, the footer ends up to the right of the table instead of below it---streatching the page from, say, 800 px to 1600 px. It's really annoying and I don't see how to fix it to be consistantly at the bottom since all those little html tricks to I might use (like an empty p/p are stripped out by White Space control. Any insight would be appreciated. Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT: SQL Server database problem
Are you sure that the fields you think are the problem really are. Try doing the insert with short strings for the fields in question and see if you still get the error. -John- At 03:16 PM 10/28/2002 +, you wrote: ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** O.K I have increased the length of these three fields to 100, 150 and 500 respectively, but still I get the 22001 error. -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 28 October 2002 15:05 To: CF-Talk Subject: Re: OT: SQL Server database problem Quoting Adams, Stephen [EMAIL PROTECTED]: The problem I am having is a ODBC Error Code = 22001 (String data right truncation) error. My table design is like this. Column name DatatypeLength MessageID int 4 MessageType char20 Department char20 CreationDatechar15 PublicationDate char15 MessageTitletext16 MessageTeaser text16 MessageBody text16 I think that the problem is when the text is being added to the fields, MessageTitle, MessageTeaser and MessageBody. 'Some text to throw error' is indeed longer as 16 characters. Not entirely unexpected behaviour, isn't it? Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
Re: Locking and clustered servers
What DBMS are you using Oracle, MS SQL Sever, Etc? Your Database system may offer a solution. I know Oracle has a way to handle this and I think MS SQL has a way too. -John- At 09:19 AM 10/28/2002 -0600, you wrote: Ok, we are thinking about setting up 2 port redirectors/load balancers (hardware) and 5 separate servers running CF 5. So, the only problem is that some of our code has named locks to prevent simultaneous record insertions on a particular table. I can't think of any way to make a lock recognizable to another server, but maybe someone out there has a neat trick or two. Or, maybe we can eliminate the need for the lock: how do some of you handle the process of inserting data into a table that generates an autonumber and then figuring out what number was just generated? Any help would be greatly appreciated. Thanks, Ryan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: What in the world is this?
Come to think of it I remember a mysterious null showing up in CF4 so long ago. -John- At 10:32 AM 10/28/2002 -0500, you wrote: I think the line counter is off, the problem is with the cfapplication tag. This is just a hunch, but I've seen the null error before, coincidentally it was on houseoffusion.com right after it was upgraded to MX. I would get the error going to www.houseoffusion.com or houseoffusion.com, but Michael only got it when going to houseoffusion.com. That makes me think that there is an odd bug with the cfid and cftoken cookies. I didn't have the cookies, and got the error, presumably Michael didn't get the error on the www domain because he already had that cookie, or it could be the other way around... Anyway that's my reasoning, as for as solution I'm not sure, but you might try playing around with the cfapplication tag, and clearing cookies. -- jon mailto:jonhall;ozline.net Monday, October 28, 2002, 10:06:21 AM, you wrote: ML In the application.cfm, right after the CFAPPLICATION tag (running on ML Win CFMX) I get the following NULL - however the line in question is a ML comment tag???: ML == ML null ML The error occurred in C:\Inetpub\website\admin\Application.cfm: line 24 ML 22 : !--- This page creates global variables for use throughout the site --- ML 23 : ML 24 :!--- Toggles the security check 0=off 1=on --- ML 25 :CFSET REQUEST.securitycheck = 0 ML 26 : ML == ML Thanks, ML Mark ML ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: Debugging Code ... is this possible?
If you don't run MX, you could create a persistent variable (session, application, etc) and list append to it at specific points in the code. ex: cfset session.mytest = listAppend(session.mytest, at line xx = varToTest) This will give you a poor-man's trace that can be output at the bottom of the page. -John- At 10:38 AM 9/23/2002 +1000, you wrote: When I write code, I often need to know the value of a variable at different points in a page. Up to now, I've put output tags and p tags and displayed the variable at that point on the page. Is there an easier way to do this? In a javascript debugger, for example, you can set points where you want to test the value of a variable and have it display in the dev tool. Is there an equivalent in CFStudio or DWMX? The best I can find to debug in ColdFusion is to just have the debugging information at the bottom of the page, but if a variable changes its value as the page progresses, you can't find that out. All it displays is the value the variable has after the page has finished processing. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ 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: Debugging Code ... is this possible?
You can only see your variables if the page runs without errors That is not quite true. If you put the testing variable into the persistent scope, say application, then you can have another page that does a CFDUMP on your variable. this way even if your page fails you can still dump the trace info from your inspection page. -John- At 01:28 PM 9/23/2002 +1000, you wrote: Thanks John, that's more or less what I do now. But its not the same as tracking the value down the page in Studio. You can only see your variables if the page runs without errors, and if the reason you're wanting to look at these values is to find out where an error is occurring, it's no help. In some programming tools in other languages, you can click on a part of a stream of code, and a window will display the value of variables you're interested in at that point. Very useful if you can't find the bit of code that's sending things haywire. Looks kinda like I have to keep on doing what I am doing now - output tags, and display the variable I'm interested in in the code. Which means running the page on a server, rather than in CFStudio. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: John Morgan [mailto:[EMAIL PROTECTED]] Sent: Monday, 23 September 2002 1:17 PM To: CF-Talk Subject: Re: Debugging Code ... is this possible? If you don't run MX, you could create a persistent variable (session, application, etc) and list append to it at specific points in the code. ex: cfset session.mytest = listAppend(session.mytest, at line xx = varToTest) This will give you a poor-man's trace that can be output at the bottom of the page. -John- At 10:38 AM 9/23/2002 +1000, you wrote: When I write code, I often need to know the value of a variable at different points in a page. Up to now, I've put output tags and p tags and displayed the variable at that point on the page. Is there an easier way to do this? In a javascript debugger, for example, you can set points where you want to test the value of a variable and have it display in the dev tool. Is there an equivalent in CFStudio or DWMX? The best I can find to debug in ColdFusion is to just have the debugging information at the bottom of the page, but if a variable changes its value as the page progresses, you can't find that out. All it displays is the value the variable has after the page has finished processing. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ 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: OT: sub-folder domain hosting
First whatever.mydomain.com is a subdomain. whatever being the sub of mydomain.com. subdomain.com would be another doamin all together. Second most hosts will charge you for additional domains even if they share the same server HD space (ex: mydomain/mysubdomain ). The reason is the ISP must maintain additional DNS (domain name service) records (an addition file to maintain in most cases) for the addition domains. Sub-domains are just added to the main domain as addition lines in the main DNS record. Bottom line is if you want addition domains pointed to the same server space you will have to pay for it. -John- At 06:12 PM 9/20/2002 +0100, you wrote: Sorry for the OT, but I don't do many, so I've got some left in my quota I'm sure ;-) I'm just getting conflicting messages from my host about whether they do sub-folder hosting or not, i.e. having subdomain.com pointing to maindomain.com/subdomain/ (and not having a simple redirect, i.e. subdomain.com stays in the browser address bar when you go to the site). I was told earlier this week by someone there that they do this, now I've been told by someone else there that they don't. Maybe one of the two people misunderstood (the second one is, I believe, a little less than a guru, shall we say ;-). But, leaving aside the fact that your host should know what they're talking about 24/7, especially with such simple matters - is there any reason why a host *couldn't* do sub-folder hosting as described above? Is it merely a case of *wouldn't* due to maybe raking in a little more from forcing everyone to have separate accounts their domains? The second adviser mentioned above just said they can do sub-domain hosting, i.e. subdomain.maindomain.com. Now, (1) I always thought this was just a machine name - is sub-domain the common term for it?, and (2) this is no good if you've bought subdomain.com and want to use it! I've got to wait until next week to sort this out with my host, but I want some ammo for potential arguments, i.e. if they say they don't do it, I'd like to be able to ask why? and know whether they're bulls***ting or not - and also to be able to say, Surely all you have to do is xyz to set it up? To save me OT'ing more on this sort of thing ;-) - anyone know of a good website resource explaining these behind-the-scenes hosting/domain things. Something not too technical, but more practical than sales pitch? I'm pretty good at CF, but I'm no webmaster yet! TIA, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: OT: sub-folder domain hosting
There is probably no technical reason they can't do it. They won't do it because they would rather sell 2 hosting account instead of letting you host two sites on one account. You might ask if they will let you have two domain names for the same account that also share the same root. If they will allow that there is a way with ColdFusion to do the routing to the sub-directory yourself. -John- At 06:59 PM 9/20/2002 +0100, you wrote: - Original Message - From: John Morgan [EMAIL PROTECTED] Bottom line is if you want addition domains pointed to the same server space you will have to pay for it. --- For sure - I'll pay! It's just that they (or *one* of their staff) say they plain *don't* do sub-folder hosting, as in further domains pointing to subfolders within one account. Just wanted to know if there's a reason for them to not do / be able to do this (short of me refusing to pay for the domain registration! ;-) - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Query Name to variable
One solution would be to always put queries into the request scope... cfquery name=request.whatever Then you could loop over the request scope looking for queries and append their names to a list. cfset session.querylist = cfloop collection=#request# item=thisKey cfset x = evaluate(request. thisKey) cfelseif IsQuery(x) cfset session.querylist = ListAppend(session.querylist,thisKey) /cfif /cfloop BTW other scopes (session, client, etc) will work too. So long as CF will let you loop over them as a structure. However Variables does not work. At 10:22 AM 9/12/2002 -0500, you wrote: Does any one know how to get the names of all of the queries that have run on a particular page? I want to store them in a structure or a variable. Just like CF displays on debugging output. I asked my local CFUG and didn't get any good answers. So I'll try a (hopefully) wider audience and see if you guys can answer it. Thanks in advance! Dave P.S. I am running CF5. __ 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: Weird Behavior
If you really want to have a directory with a .com extension create a virtual directory to point to the physical directory and only use the virtual directory in CF. I use this technique to keep client work in a directory according to their domain. But the underscore works too. -John- At 03:50 PM 9/11/2002 -0400, you wrote: Yeah, you're right. I tried it before running out to the gym at noon. I had a weird feeling about naming a directory .com. I changed it to _com and it worked. :-) (I have a directory with the same company name for that domain.net) Thanks! -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:30 PM To: CF-Talk Subject: RE: Weird Behavior : Not sure what os that was -- and I think it may have actually : been /com/ as : a directory name... I've never seen a problem with Windows IIS using the : domain name as the directory name -- it's a fairly common convention for : hosting companies, often including www. so you'd see a directory with the : client list like: Now that you mention it, I seem to recall someone earlier mentioning that if you name a directory with a .com extension, IIS assumes that what you really mean to do is call a file in it's parent directory with it's name and the rest of the URL as parameters. Hmm. HTH. mmm... I think you're right... Probably if the directory in question is below the root of the website... i.e. if the site points to the root directory of c:\clients\www.myclient.com you're fine, but you probably run into problems with c:\clients\www.myclients.com\cap.com where www.myclients.com is the root directory... Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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: More law suits
At 02:57 PM 9/26/00 -0400, you wrote: I can't sue the casino when I lose all my money there either. Wait a minute that's a great idea! :) -John- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Law Suit
Looks like Allaire has a new freshly pressed suit... a law suit! http://biz.yahoo.com/bw/000925/ny_milberg.html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Exam
I just want to thank Mr. Dinowitz. I used your study rules for my cram session last night. I passed the exam with a score of 90%. Thanks -John- PS: Anyone taking the exam study structures! At 01:39 PM 9/21/00 -0400, you wrote: Broad topics. Error handling, data validation, state management. If this wasn't the last night, I'd give you the study rules that I gave the developers over here at CA. TO ANYONE WHO HAS TAKEN THE CF EXAM: Tonight is the last night I can study for the Allaire CF certification exam. Is there any area that you recommend I concentrate on tonight? THANKS! -John- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Exam
TO ANYONE WHO HAS TAKEN THE CF EXAM: Tonight is the last night I can study for the Allaire CF certification exam. Is there any area that you recommend I concentrate on tonight? THANKS! -John- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Certified?
Has anyone taken the Allaire CF Certification test yet? -John- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Certification is BS
... I would put 0 value on some yahoo C++ certification that every joe can get. You can get Yahoo certification? :) What about AltaVista and Lycos? :) -John- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: stupid cfx tag question
At 02:13 PM 4/7/00 -0800, you wrote: So the second question is, how can I convince an ISP that a CFX tag, like CFX_checkemail is safe? Throw cash at them. They love that stuff! -John- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Programmer's font
Me too please! -John- At 08:51 AM 4/3/00 -0400, you wrote: I use a font called Hells Programmer. It has exactly what you want. Let me know if you want it and I'll send it to you. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Search Engines where there are no static pages
At 07:32 PM 3/31/00 +1000, you wrote: I taught a client how to use meta tags and comments inside the header of his static pages to give the search engines something to index. He's done this to great effect, and he has hundreds of static pages - one for every product - most of which are indexed by the major search engines. I would add a "memo" (VarChar) column to a product table that contained the text for meta-tags and other "head" content. Then you can dynamically write that information into each product page. We do a similar type of thing at Blue Star Training. Check out the URLs below to see dynamic pages that "act" like static. http://www.bluestarcorp.com/DYN_CF1.cfm http://www.bluestarcorp.com/DYN_HT1.cfm http://www.bluestarcorp.com/DYN_HT2.cfm Not surprisingly, keeping all those static pages up to date is a nightmare, and his store lends itself to a ColdFusion shopping cart. ... How do you all get round this?If you have few static pages, what do you give the search engines to index? I wrote an article on this subject from the ColdFusion Developers Journal (Volume 2 Issue 1, January 2000 page 31). The technique that I call "Fake URL" uses IIS and CF to present an URL that the search engines see as static. The URLs listed above are the "Fake" versions of the URLs listed below. http://www.bluestarcorp.com/CourseInfo.cfm?COURSE_ID=CF1 http://www.bluestarcorp.com/CourseInfo.cfm?COURSE_ID=HT1 http://www.bluestarcorp.com/CourseInfo.cfm?COURSE_ID=HT2 -John- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.