Re: ways to time a file upload?
Well after browsing this thread I thought if it would be possible to connect the submit button to an XMLHttpRequest which triggers a session var for the starting of the upload and after processing the upload you take another timestamp and could calculate with that. Stupid idea? Yeah, I didn't think about the client/server time difference, although using JavaScript to get the time on the action page after the file upload would work without any time-offset calculations. -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What do you use to capture a video frame?
Hi Mike, a commonly used Screencap utility is HypersnapDX. HTH Patric MK I had to take a snapshot of a WMV video I'm putting on one of my sites MK today, and I was surprised to learn that you cant capture a video (in MK WinXPPro anyway) frame into a jpg file by the method of screen capture I MK normally use - the good ole' print screen key to put it into the clipboard. MK I found when I use that method with the video paused at the right frame, MK that method captures everything in the screen EXCEPT the video frame, which MK is what i wanted. MK So i went to my usual resource for software - TUCOWS - and didnt find MK anything but a gazillion programs to convert DVDs or rip them to hard drive. MK So how do you make a still image from a movie scene in WinXPPro? -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: What do you use to capture a video frame?
Man, how much time do we have to spent on such silly things. Another alternative *could* have been to open the video with a decent mediaplayer (MPC or ZoomPlayer) and then use the integrated snapshot functionality. But who knows if that works with wmv (it does with normal avi-container material and mpg-vids). Glad you could work out a solution Mike! Patric MK As it turned out, the HypersnapDX that Patric suggested wouldnt capture the MK video image either. Just like all the other capture mechanisms I'd tried up MK to that point, it captured anything on the desktop EXCEPT the content of the MK video.Which is what i wanted in the first place. MK So here's what I ended up doing: MK I used right-click/ Open with ... and tried a few programs, none of which MK would capture the image i needed. All captured anything BUT the video. MK I used right-click/open with ... and chose Internet explorer. It opened MK the video and I was able to capture it by using Alt-PrtScrn (anyone MK forgotten what those keys are for?it copies a window or the whole MK desktop to the clipboard, to be pasted into some other program). MK I pasted the result into a new image in fireworks, then cropped off all the MK bits of the desktop I didnt want, reduced the size of the image, exported MK it as a jpg and used it in my content management system. MK If anyone wants to see the result, it's at MK http://bluegrass.org.au/index.cfm?pid=111454 WARNING: content includes MK banjos - view with adult supervision. It links to a 3.5minute video done MK with flash video. MK Cheers MK Mike Kear MK Windsor, NSW, Australia MK Certified Advanced ColdFusion Developer MK AFP Webworks MK http://afpwebworks.com MK ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Hi Paul, PH in theory, yes sure. but locale resource data/implementation varies version to PH version i suppose OS to OS--even something as simple as the terminology PH differs OS to OS (and sometimes version to version). PH any chance the host is setting the file encoding? Hmm, I doubt so. But my hope is to find the source of the problem, because theoretically it should be running fine the way I thought. cfscript dDate1 = CreateDate(now()); PH that works? if it does it's redundant, now() should suffice. dDate2 = CreateDate(DateAdd('', 1, now())); PH that works? just dateAdd should be ok. Was to late for me write that last reply. For sure I just juse now() and DateAdd() without CreateDate. Even without using those vars as formfield-values the umlauts are screwed up... PH ?? that script only produces numeric values for your day/month/year bits. am i PH missing something? No your missing nothing. It's absolutely correct. Those values are just filled into corresponding formfields for start and end day, month, year. PH btw are you using cfprocessingdirective cfcontent both set to use iso-8859-1? For now I only used cfcontent type=text/html; charset=ISO-8859-1 / cfset setEncoding(URL, ISO-8859-1) / cfset setEncoding(FORM, ISO-8859-1) / in Application.cfm. I would imagine that the use of cfprocessingdirective is only useful when you want to force the processing encoding on one special page. Or does one have to use it always when not using utf-8? Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Hmm, I doubt so. But my hope is to find the source of the problem, PH ask? That whole hosting thing has become some kinda political beyond my recommendations. Really difficult. So I have to stick with what's given on the server side. You won't believe how happy I was when I heard that I was *allowed* to port the DB... No your missing nothing. It's absolutely correct. Those values are just filled into corresponding formfields for start and end day, month, year. PH do you have an example? Sure (if nobody minds): -- [snip] -- cfscript request.dDatum1 = now(); request.sDatum1Tag = DateFormat(request.dDatum1, 'dd'); request.sDatum1Monat = DateFormat(request.dDatum1, 'mm'); request.sDatum1Jahr = DateFormat(request.dDatum1, 'yy'); request.dDatum2 = DateAdd('', 1, request.dDatum1); request.sDatum2Tag = DateFormat(request.dDatum2, 'dd'); request.sDatum2Monat = DateFormat(request.dDatum2, 'mm'); request.sDatum2Jahr = DateFormat(request.dDatum2, 'yy'); /cfscript cfoutput div id=bereich_veranstaltungssuche form id=veranstaltungssuche method=post action=#request.sDirDepth##request.sCurrentWebNr##request.sCurrentWebLang#/events/suche.cfm fieldset legendVeranstaltungssuche/legend div class=frmZeile label class=beschriftungvon/label input type=text name=sDatum1Tag value=#request.sDatum1Tag# size=2 class=frmText / input type=text name=sDatum1Monat value=#request.sDatum1Monat# size=2 class=frmText / input type=text name=sDatum1Jahr value=#request.sDatum1Jahr# size=2 class=frmText / /div div class=frmZeile labelbis/label input type=text name=sDatum2Tag value=#request.sDatum2Tag# size=2 class=frmText / input type=text name=sDatum2Monat value=#request.sDatum2Monat# size=2 class=frmText / input type=text name=sDatum2Jahr value=#request.sDatum2Jahr# size=2 class=frmText / /div div class=frmZeile input type=text name=sSuchbegriff value=Stichwort size=10 class=frmTextLang / input type=submit name=submit value=suchen class=frmButton / /div /fieldset /form /div /cfoutput -- [snip] -- That little bit of code gets included in every page. After that I cfoutput text fields from the MySQL4-datasource (connected through the MySQL-Connector/J JDBC3-driver) almost identically (other fieldnames) to the following: -- [snip] -- cfquery name=qToday datasource=#application.sDSN# SELECT* FROM dates WHERE adate = CreateODBCDate(now()) AND sdate = CreateODBCDate(now()) ORDER BY sdate, adate /cfquery cfoutput query=qToday h2#qToday.title#/h2 p#qToday.shorttext#/p /cfoutput -- [snip] -- And those title and shorttext contents get screwed as long as I use the upper DateFormat. Setting the date vars manually (for testing) everything works fine (or - as discovered - using LSDateFormat() without setting a setLocale() in App.cfm). I would imagine that the use of cfprocessingdirective is only useful when you want to force the processing encoding on one special page. Or does one have to use it always when not using utf-8? PH it's good practice to include it especially in your case where you're not using PH the default encoding. Well, that's something I'll look in again... Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231570 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
PH well it would really help to know if they are actually forcing utf-8 or whatever PH as file encoding. make some sense of your problems. Hmm, then I'll have to dig a bit into this on the live server. But at the moment the problems occur on our dev server. A quick test shows that its default encoding is UTF-8. Without setting the encoding to latin1 the output of the query I showed displays garbage - as it should (only cfquery/cfoutput). Changing the encoding to latin1 everything looks fine. Dropping in a simple cfset foo = DateFormat(now(), 'dd.mm.') / anywhere on that page renders it instantly wrong! WHERE adate = CreateODBCDate(now()) AND sdate = CreateODBCDate(now()) PH CreateODBCDate is redundant. Uhm, is it really? Something new to me after years :) And those title and shorttext contents get screwed as long as I use the upper DateFormat. Setting the date vars manually (for testing) PH which is kind of overkill, why not use day/month/year functions instead? the 0 PH padding? Yep it is. But the 'designer' insists on those fields being two digits. And a wrapper-function around the day/month/year values would be the same overkill as DateFormat. So this is again one of those compromises one has to make I think. everything works fine (or - as discovered - using LSDateFormat() without setting a setLocale() in App.cfm). PH it might be because of either the file encoding forced to utf-8 (low odds?) or PH dateformat on a localized OS is producing UTF-8 which gets mixed in w/the rest PH of the latin-1 text stream breaks. also are you sure the text from the db is PH latin-1? maybe windows-1252? that's a superset of latin-1 can cause some PH interesting side effects if used as if it were latin-1. I always thought of it being latin-1 because my conversion tool told me it'll that encoding. And the MySQL status output also tells me that it uses 'latin1' as server and client characterset. -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231574 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
PH look at the JVM arguments. How would I read them without shell or CFAdmin access? PH you're setting the *file encoding* to utf-8? Ermm, the GetEncoding(URL) and GetEncoding(FORM) return UTF-8. PH is there a public example of this? May I contact you offlist with that? PH now() produces a very fine datetime object. But it's not ODBC compliant, is it??? PH its the format for your locale (ex.'06.02.06'). Pardon? PH no, not really. if you have to stick to the locale format then you need to PH provide the padded date part output but using single function to do this at PH least gets around the DateFormat issue you're seeing. Now my brain gets fuzzy... I do need tree (or six) single values, each padded to two digits. PH to further narrow this maybe another workaround does this: PH cfscript PH request.dDatum1=now(); PH thisLocale=createObject(java,java.util.Locale).init(de,DE); PH jDateFormat=createObject(java,java.text.SimpleDateFormat); PH request.sDatum1Tag=jDateFormat.init(dd,thisLocale).format(request.dDatum1); PH request.sDatum1Monat=jDateFormat.init(MM,thisLocale).format(request.dDatum1); PH request.sDatum1Jahr=jDateFormat.init(y,thisLocale).format(request.dDatum1); PH /cfscript PH blow up the german text too? Huh, this one works like a charm! All umlauts are rendered properly. How comes? I always thought of it being latin-1 because my conversion tool told me it'll that encoding. And the MySQL status output also tells me that it uses 'latin1' as server and client characterset. PH well these encodings are *almost* identical, some apps/people treat them as if PH they were identical. Hmm. But I thought CFMX always uses its own JVM with its own settings... -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
DateFormat and german umlauts
Hi cf-talkers, I'm experiencing a very strange problem with CFMX6.1 and the usage of the DateFormat function. While relaunching a site I transfered the original Access-DB to MySQL4. All of this site is using (and forced to) ISO-8859-1. After the transfer and setting up some page everthing worked like a charm. But then I realized that there were some unwanted questionmarks in the output where some german Umlauts should appear. First I thought of a problem with some improper encoding (like MySQL having imported the data as UTF) but I could narrow down the problem to the point that the umlauts will be displayed correctly as long as I'm not using the DateFormat function. As soon as that's dropped in the umlauts all get converted to questionmarks. The page encoding (and delivery) is still set to ISO. For now I can't see if there's a problem with my setup or if there's a bug in CFMX6.1. Hope that someone can shed some light into this... TIA Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231397 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Hi James, thanks for your quick reply. What makes me curious is the fact, that the umlauts have nothing to do with the date being formatted by DateFormat. I ran a quick test with setting the german standard locale in Application.cfm. Now every umlaut is always displayed as a questionmark, no matter if I use DateFormat/LSDateFormat - still for formatting a date that has nothing to do with the garbled text - or skip it. Very weird. Any other hints? Patric JH Locale specific dates should be formatted with LSDateFormat(), after JH the SetLocale() function has been used to set the correct locale for JH the request. JH On 2/6/06, Patric Stumpe [EMAIL PROTECTED] wrote: Hi cf-talkers, I'm experiencing a very strange problem with CFMX6.1 and the usage of the DateFormat function. JH -- JH CFAJAX docs and other useful articles: JH http://jr-holmes.coldfusionjournal.com/ JH ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231399 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Hi Chris, cpn the way CFMX handles a file usually depends on teh BOM (Byte Order Mark). It is cpn a tiny signature set by the editor, that tells CF whether the file is encoded cpn in UTF-8, ISO-something, cp1252, etc. cpn First, make sure that your editor is saving the file as UTF-8 encoded. (E.g. in cpn Eclipse go to File - Properties - Text file encoding and set it to UTF-8 cpn (not(!) inherited). I'm aware of that and as Homesite+ has always had problems with UTF-8 encoded files I'm still using ISO. For sure that's probably the most useful and approach. cpn Then, in your Application.cfm you should make sure form and url variables are cpn seen as UTF-8: cpn cfset setEncoding(url, utf-8) cpn cfset setEncoding(form, utf-8) Already done this for ISO-8859-1 as CFMX defaults to UTF-8 after installtions. As there's absolutly no need for i18n on this project (there's really no circumstance that another encoding than latin-1 will be used) this is realized with our local encoding. cpn There still may be problems with umlauts in cfmail. To resolve those, use the cpn 'charset=utf-8' attribute in cfmail tag. There will surely arise a problem with a few - but still used - older email clients not being able to parse UTF8-encoded mails. But that's another story. cpn Best, cpn Chris Even though you're absolutly right with what you explained and it should be some kind of best practice for a lot (almost all) of projects I'm still wondering why suddenly this curious behaviour occurde. Normally a page originally delivered (or parsed by CF) in UTF-8 and afterwards rendered false by the UA shows really garbled chars instead of real questionmarks. But for now it seems to work as already replied to James by using LSDateFormat and leaving out the SetLocale(). Thanks Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231402 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Hehe, thanks for that. I even wondered why he didn't respond... :) But now I accidently got a correct output by removing the setLocale but keeping the LSDateFormat. Man - this is really weird. Hopefully the live server will behave the same... Patric JH Yep: wait and hope for Paul Hastings to tell you how to fix it :-) JH Paul? -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Hi Paul, nice from you dropping in! PH Patric Stumpe wrote: I even wondered why he didn't respond... :) PH busy. project crossing 4-5 tz can make you not know one day from the other. i PH also don't have a cf6 server to test on anymore. Can understand that and I don't think that you have to answer every question regarding i18n. :) But now I accidently got a correct output by removing the setLocale but keeping the LSDateFormat. PH that can't be correct. what is the OS? is it localized (de_DE)? what does PH getLocale() return? Surely that can't be correct. It's a Win2k Pro SP4. And yes, it it localizied to (de_DE). And surprisingly a GetLocale outputs the correct German (Standard) without me setting this value. If I set it in App.cfm the output gets corrupted as already described. Man, sometimes I really hate those systems. Btw. this just happens with this new project after transferring the db from Access to MySQL. The original project (same dev-server, same encoding) still works correct. As always if there's anything to be tested I will give it a try... Thanks for answering Paul! Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
PH you can force the whole server to use latin-1 by chnaging the encoding in the PH cf_root/lib/neo-runtime.xml file: PH var name='defaultCharset'stringUTF-8/string/var Won't work as this is a shared host. And as you point out, it wouldn't even be advisable. PH from utf-8 to whatever. i don't recommend this approach but if you never will PH need unicode encodingand how many times have i heard that before? I knew that this would come :) But our customer doesn't wanna pay the additional work for a clean rewrite. You can't imagine how hard it was for me to convince them (and even our own chiefs) to switch to another DB-system... (there's really no circumstance that another encoding than latin-1 will be used) this is realized with our local encoding. PH what about the euro? Doesn't matter. The ¤-Symbol will be written as EUR. Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231426 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: DateFormat and german umlauts
Patric Stumpe wrote: Surely that can't be correct. It's a Win2k Pro SP4. And yes, it it localizied to (de_DE). And surprisingly a GetLocale outputs the correct German (Standard) without me setting this value. that would be sort of expected behavior for a localized OS. but the depth of localization can be pretty thin for some locales. i wouldn't count on it in general. But where should be the difference if I set the locale explicitly or it's set by the OS (or Java default?)? Shouldn't they be the same? Btw. this just happens with this new project after transferring the db from Access to MySQL. The original project (same dev-server, same encoding) still works correct. are the dates coming out of the mysql DB? you're using the JDBC driver? and the special mysql url? The dates do not come from the DB. It's just a simple script to prefill some form fields for date selection (but it also happens with records from the DB, so to say any time the function is used): cfscript dDate1 = CreateDate(now()); sDate1Day = DateFormat(dDate1, 'dd'); sDate1Month = DateFormat(dDate1, 'mm'); sDate1Year = DateFormat(dDate1, 'yy'); dDate2 = CreateDate(DateAdd('', 1, now())); sDate2Day = DateFormat(dDate2, 'dd'); sDate2Month = DateFormat(dDate2, 'mm'); sDate2Year = DateFormat(dDate2, 'yy'); /cfscript Even without using those vars as formfield-values the umlauts are screwed up... this all sounds vaguely familiar. Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: 100% height and css
Hi Ray, ever gave the following site a shot: http://www.csscreator.com/version2/pagelayout.php You can define which doctype you'd like to have and even define some base colors. I used it for a template exactly as you wish. When I remember correctly the trick is to use the margin of the center column for the outer columns. Perhaps its of some use for you... Patric RC BTW, if it helps, here is a rather lame-ass design that I'm using to RC learn with: RC http://wagtailweb.com/rvr/csstemplate.html RC Ray RC Ray Champagne wrote: Okay, I've looked all over the place, and can't find my answers. I am going forward with my complete css layout ambitions, and already, I can see why css doesn't catch on. It's frustrating! I want to make a fixed with (770 px), center-aligned, 3 column site that looks like so: header |left col| center | right col| footer Now, I want the right and left columns (and their background colors and borders) to stretch down the page when the page gets wordy in the content column. Searching Google and the archives, all I can see is that there are a lot of solutions for a liquid layout, but none for a fixed layout. There has to be a way to do this, right? Ray == Ray Champagne Application Developer CrystalVision Web Site Design http://www.crystalvision.org 603.433.9559 [EMAIL PROTECTED] == RC ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Rounding...
Hi Jeff, this could be a start: output = Ceiling(input/10)*10; Just some tests around it... Patric JW I have a whole number rounding problem that I am not sure how solve most JW efficiently. JW I'd like to take any number and round to the nearest whole 10. JW For example: JW 31 would equal 40 JW 27 would equal 30 JW 155 would equal 160 JW Any help would be appreciated... JW Thanks! JW Jeff JW ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Another one for the RegEx-Gurus
Hi folks, i did already search the web and the archives but without any success. I'm trying to build a HTML-Email-Interface which runs on an old CF4.5. The input and some parts of the processing are running quite fine. But now I'm stuck on the img-tags, where I have to replace the relative image-URL with inline-attached images. The building of the attachments works but I've no clue how to replace (or better find) the src-attribute of the img-tags to extract and replace them with the proper inline reference. Hope that some of you can help me out with that one. Cheers, Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Another one for the RegEx-Gurus
Hi Ben, thanks for the quick reply. Am I right that I could embrace the different parts of that regex for simple back-reference? I have to grab the complete URL of the src-attribute (need to work with that a bit) and replace it with a known string: e.g.: img src=/path/to/image.gif height=25 width=20 would lead to: img src=cid:inlineImage01; height=25 width=20 So something like that could work? (img [^]*src=)([^]+)([^]*) = \1cid:inlineImage01\3 Patric Finding the img tags should be easy. Replacing them with inline tags is, unfortunately, something I'm not familiar with. To find an img tag, you would look for something like this: img [^]*src=[^]+[^]* Hopefully, someone can help with the other half (9/10ths?) of the problem. --Ben -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211570 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Another one for the RegEx-Gurus
Hi Howie, I did already solve that part. Manually geneerated messages are properly sent. So now I (hopefully) only need to concentrate on that replacment for the WYSIWYG-submitted mailbody. Greets Patric FYI - Even if you replace the source with a CID you still need to encode the image into the email using that same CID as a reference. Regards, Howie -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Another one for the RegEx-Gurus
Thanks Ben, it really seems to work. Now I have to crawl the source html backwards and have a look at what happens :) Thanks a lot! Patric More or less. I would probably skip the backreferences and rewrite the img tag from scratch, or specify which attributes I want to keep. But if you want to keep all additional attributes (style, alt, title, etc.) then you're right -- that'd be how to go about it. --Ben Patric Stumpe wrote: Hi Ben, thanks for the quick reply. Am I right that I could embrace the different parts of that regex for simple back-reference? I have to grab the complete URL of the src-attribute (need to work with that a bit) and replace it with a known string: e.g.: img src=/path/to/image.gif height=25 width=20 would lead to: img src=cid:inlineImage01; height=25 width=20 So something like that could work? (img [^]*src=)([^]+)([^]*) = \1cid:inlineImage01\3 Patric Finding the img tags should be easy. Replacing them with inline tags is, unfortunately, something I'm not familiar with. To find an img tag, you would look for something like this: img [^]*src=[^]+[^]* Hopefully, someone can help with the other half (9/10ths?) of the problem. --Ben ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: what is this? (photoshop 7 question) cross-post
Tony, it's Aobe info for slices. You can hide with the view menu. HTH Patric :) http://www.revolutionwebdesign.com/whatIsThis.gif what in the heck is this? its not that big of a deal, just annoying while designing a graphic. -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: limit display of text
Well you treat the resulting string as a list with space as the ldelimiter an d delete the last list element. So you get whole only words with a maximal length as specified in the Left-function. Anyone else doing it like this? Patric this will do #Left(report.maint_report_task,25)#... BH Out of curiosity, that will trim based on number of characters, yes? BH How would one grab the first X number of whole words. IOW trim BH characters but stop at a space. Would you need to combine that with BH some regex? BH - BH Regards, BH Bob Haroche BH O n P o i n tS o l u t i o n s BH www.OnPointSolutions.com BH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: passing multiple CF vaules to a javascript variable
Hi Joy, could you possibly make a dump of your query? So we can understand what you data looks like? Patric JH onClick didn't understand a CF variable like: #linkStyle#. It wants _javascript_. I don't know how to make the _javascript_ variable I create from the CF variable return each of the different JH values in the onClick event. JH I get: menu item one: ...> menu item two: ...> menu item two: ...> JH How can I make the _javascript_ variable I create from the CF variable loop through the values properly? JH Thanks for trying to help with this problem. But by the time the code gets to the browser, #linkStyle#will have been replaced by exactly what you show us here menu item one: ...> menu item two: ...> menu item two: ...> view source from your browser might help clear things up for you. Or like Dick, I don't understand :( - Original Message - From: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 4:12 PM Subject: Re: passing multiple CF vaules to a _javascript_ variable Would this information help explain what I need? Here's where the styles comes in: I have a CSS stylesheet with these values: #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} In the db table, I have a column for the same styles from the stylesheet. Let's say the column name is linkStyle (like Dick's example). Another column in the db table has the text for the menu link that displays on the page. When a user clicks on a menu link (generated by the CF code prior to the user interaction), an assoicated DIV with an ID equal to the stylename displays its content because the onClick event tells the matching style in the stylesheet to change display=none to display=block. Using Dick's example, just change the end to something like this: Now, iterating over the query: cfoutput query=menu bra href="" #linkName# /a /cfoutput Now, that doesn't work because #linkStyle# is CF and onClick needs js. I don't know how to loop through this onClick variable to get the range of values to be produced - one for each iteration of the results, like: menu item one: ...> menu item two: ...> menu item two: ...> etc. Does that help? I need to be gone for a few hours, but I'll check back. Thank you and Dick so much for sticking with me on this!!! It sounds like you need to combine the results from the 2 queries into a single query objectOR write a more complex query to join all the tables involved to produce a single recordset. 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: Joy Holman To: CF-Talk Sent: Tuesday, April 13, 2004 11:55 AM Subject: Re: passing multiple CF vaules to a _javascript_ variable The rendered output is a menu of links. One query column returns the text for a link, another query column returns the target for the link. The style name column is used in an onClick event to set a CSS style to display content when clicked. The style name doesn't display on screen. I'm able to generate all the values I need except for all the stylename values. If I only had one result from the query, it would work fine. But I can't get the style name value to change as additional menu items are generated from the query results. Maybe what I need is help with _javascript_. I don't know how to explain it any better. I guess that's a drawback of not being able to talk in real time. Thanks for your efforts. I'll keep at it. event. From the query results, I create the js: target() which returns the value of the stylename field. How do I loop over the stylename values so that I get one value per onClick event which is generates multiple times based on the number of records in the query? I am sorry... I can't understand what you are trying to do. It is a simple matter to include the value of a column from the query in a line of text generated within the output tags... But you are already doing that... Maybe this would help me to help you: 1) show me a few lines of the rendered output that you desire--- no CF tags, just the rendered output. 2) put an asterisk or something in front of each value in the
Re: passing multiple CF values to a JavaScript variable
Joy, taht's what I think too. The code sample Dave provided does the same thing your code should render. That's why I thought you could provide a dump of your database query to see if it's serving unexpected data... Patric So there was nothing wrong with my original code and I shouldn't have gotten an error saying that onClick didn't understand the CF variable #menu_bmarkLink#. Maybe it failed because there was no value for #menu_bmarkLink# when that variable was blank - which would be the case when the menu_nonBmarkLink column had a value. So maybe that column is relevant after all. I'll pull out the record containing the menu_nonBmarkLink value and see if I get the results you did. At least that will pinpoint the problem better. Thanks. Joy I created the following test code and it runs just fine, I believe it does basically what you are asking code to do. HTH !--- Test Code --- cfscript aQuery = queryNew(menu_bmarkLink,menu_Text,menu_nonBmarkLink); tmp = QueryAddRow(aQuery,4); tmp = QuerySetCell(aQuery,menu_bmarkLink,MinorRts,1); tmp = QuerySetCell(aQuery,menu_bmarkLink,FellSvc,2); tmp = QuerySetCell(aQuery,menu_bmarkLink,AmnInf,3); tmp = QuerySetCell(aQuery,menu_bmarkLink,AnteSter,4); tmp = QuerySetCell(aQuery,menu_Text,MinorRts Link,1); tmp = QuerySetCell(aQuery,menu_Text,FellSvc Link,2); tmp = QuerySetCell(aQuery,menu_Text,AmnInf Link,3); tmp = QuerySetCell(aQuery,menu_Text,AnteSter Link,4); /cfscript cfdump var=#aQuery# html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 style #FellSvc{display:none;} #MinorRts{display:none;} #AmnInf{display:none;} #AnteSter{display:none;} /style /head body ul cfoutput query=aQuery liA HREF="" > display='block'#menu_Text#/a/li /cfoutput /ul div id=FellSvcFellSvcbr/a href="" > display='none'Hide content/a/div div id=MinorRtsMinorRtsbr/a href="" > display='none'Hide content/a/div div id=AmnInfAmnInfbr/a href="" > display='none'Hide content/a/div div id=AnteSterAnteSterbr/a href="" > display='none'Hide content/a/div /body script language=_javascript_ !-- window.open = SymRealWinOpen; //-- /script /html !--- End Test Code --- -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Update price
Well when you want to set percentage to ZERO and discountedprice to the value of price the just strip the quotes from your second SET-line - assuming the two price-fields are database-fields. But there has should be a WHERE-clause because else all fields in your db will get updated. CFQUERY name=change datasource=printprices UPDATE bookinfo SET percentage = '#form.percentage#', discountedprice = price WHEREid = #form.id# /cfquery HTH Patric RC Take out the second set statement. RC CFQUERY name=change datasource=printprices RC Update bookinfo RC SETpercentage = '#form.percentage#', RC 'discountedprice' = 'price' RC /cfquery RC There probably should be a 'WHERE' clause in there too, as well as u should RC be using cfqueryparam.Look it up in a book for the syntax, etc RC At 10:23 AM 3/30/2004, Robert Orlini wrote: I have a query in an action page where I set a column to 0 (from a form) and update discountedprice to the same value as price. Here is the code: CFQUERY name=change datasource=printprices Update bookinfo SET percentage = '#form.percentage#' SET 'discountedprice' = 'price' /cfquery I'm kinda a newy to all this so of course it doesn't work. I get an error with -- SET 'discountedprice' = 'price' Any ideas please? Thanks. Robert O. HWW RC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Mimic a perl/php function
Hi cf-talkers, I'm not that maths genie so I'm wondering if it is possible to mimic the unpack()-function that's implemented in perl and php with ColdFusion? I have some data as an 32Bit Word in LittleEndian order and want to convert it to a normal decimal... Already searched the CFLib for something but had no success. I hope some of you guys out there have an idea... TIA Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 5 Trial
Hi Neil, ain't it the full Enterprise Edition for the first thirty days before turning into the the single IP version? Patric Thanks, But can you not get the full Enterprise Edition rather than the Single IP restrictor? Thanks -Original Message- From: Deb Dickerson [mailto:[EMAIL PROTECTED] Sent: 14 June 2003 14:28 To: CF-Talk Subject: RE: ColdFusion 5 Trial http://www.macromedia.com/support/coldfusion/downloads.html Third link from the bottom. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Saturday, June 14, 2003 5:30 AM To: CF-Talk Subject: ColdFusion 5 Trial Anyone know if you can still download CF5 Enterprise Trial edition? if so, where can you get it?!?!?!? ~| 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. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Homesite+ update error
Hi Critz, as far as I remember there are two Updaters for Homesite. One for the normal Homesite 5 - Homesite 5.2 and another for Homesite+ 5 - 5.2. Saw them at the HS-Support. Patric C oi CF-Talk,!! C My homesite+ started throwing errors, so I thought I would un/reinstall it... C now, I am trying to run the 5.2 updater, and I get C a valid version of homesite 5 was not found on this machine C any ideas? C Crit C ~| 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: Link to named anchor
Well shouldn't it be on emore pund sign? Like: page2.cfm?#session.urltoken###foo Patric C never tried it, but what happens if you reverse it? C page2.cfm?#session.urltoken##foo C Probably wont work but just a thought C -Original Message- C From: Mark Leder [mailto:[EMAIL PROTECTED]] C Sent: Tuesday, February 18, 2003 10:21 AM C To: CF-Talk C Subject: Link to named anchor C Hi All, C On page 1, I Have a link which looks like this: a C href=page2.cfm#foo?#SESSION.URLToken#Page 2/a C On page 2, the named anchor towards the bottom of this long page in the HTML C is: a name=foo/a C Can't get the link to jump to the appropriate section on page 2. C I've tried the following with no luck: C cfoutputa C href=page2.cfm##foo?#SESSION.URLToken#/cfoutput C a C href=page2.cfm#foo?cfoutput#SESSION.URLToken#/cfoutput C BTW: Works OK without the CFML Session Tag as: a href=page2.cfm#fooPage C 2/a C Thanks, Mark C ~| 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: Developer Edition IP address
Hmm, isn't it asumed to allow localhost and the first other IP that connects to it? Patric Look sharp, lads. The piracy police is in town! - Original Message - From: Tangorre; Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 1:01 PM Subject: RE: Developer Edition IP address why would you even mention this? -Original Message- From: Fregas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 1:53 PM To: CF-Talk Subject: Re: Developer Edition IP address Yes, get a crack for the full version of CFMX on altavista.box.sk :) Seriously, I think it only allows localhost to go through. - Original Message - From: Carol Dowling [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 12:35 PM Subject: Developer Edition IP address Is there any way to change the one permitted IP address to access the Developer Edition - I want to do a demo from another office. Thanks, Carol Carol Dowling Manager, Information Resources Maryland Municipal League ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: submiting forms created server side
Hi Jay, would a cfhttp-posting from an action-page solve your prob? You submit the user-data to your action-page and that page makes an cfhttp-post to authorize.net. Patric JK Hello everybody- JK I'm sure this is one of those I've been working for to long and I've JK overlooked the answer 100 times sort of questions. JK I've built a shopping cart and I'm trouble shooting the form submission. The JK Payment gateway is Authorize net. The problem comes when submitting the JK customers' order and credit card information: JK In addition to the customers Information, Authorize net requires you to JK submit specific form fields, some of which are sensitive passwords, and JK access codes. Obviously I can't hard code the information as hidden fields JK in the html form, anybody who viewed the source code would see the sensitive JK material. JK I want to take the form the user filled out, submit it to a CF template, add JK the sensitive data, then submit the augmented form to the Authorize net JK gateway (which requires a FORM submitted via Post to JK https://secure.authorize.net/gateway/transact.dll), JK AND that brings me to my question: How do I post a form to this address with JK out having a user hit the submit button. How do I post a form from the JK coldfusion server to that address? JK As always, thanks in advanced for your help! JK Jason JK ~| 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: Javascript MultiDimensional Array
Hi Howard, JS can only handle one-dimensional arrays. Had a similar problem. Patric MS You should declare the second array as well. MS holidayPackages.[Explorer 60] = new Array(); MS holidayPackages.[Explorer 60].dates = MS [Winter, Easter, Spring, Value, Summer, Fall, Halloween, MS Fall 2, Thanksgiving, Holiday, New Years]; MS I haven't tried it, but it makes sense to me. MS Matthew Small MS IT Supervisor MS Showstopper National Dance Competitions MS 3660 Old Kings Hwy MS Murrells Inlet, SC 29576 MS 843-357-1847 MS http://www.showstopperonline.com MS -Original Message- MS From: Howard Owens [mailto:[EMAIL PROTECTED]] MS Sent: Sunday, January 19, 2003 11:54 PM MS To: CF-Talk MS Subject: OT: Javascript MultiDimensional Array MS I tried posting this to js-jive (yahoo) and didn't get a response, so I MS guess I'll try here, since there's a lot of smart Javascripters on this MS list. MS I need to create some multidimensional arrays, but things aren't MS working like I expect ... this isn't working MS var holidayPackages = new Array(); MS holidayPackages = [Explorer 60, GetAway MS Plus, Discovery, GetAway 300]; MS holidayPackages.[Explorer 60].dates = MS [Winter, Easter, Spring, Value, Summer, Fall, Halloween, MS Fall 2, Thanksgiving, Holiday, New Years]; MS I can get holidayPackages.dates to display the dates, but of course MS that does me no good. Each package has its own unique set of dates. MS And then, each of those date elements are going to need their own MS arrays of info (prices, four each for each date) ... and ideally, MS each date element/label will have the actual calendar date assigned, MS based on with package ... so in other words, I'm trying to build a MS pretty complex array of arrays tree. MS But I can't get over this first hump. What am I missing? MS H. MS ~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: JS - submit/button problem
Hi Uwe, could be something like: INPUT TYPE=button VALUE=SUBMIT onclick=return something(this.form); And: function something(form) { if return true; else return false; } UD Hi list, UD at the end of a form I have: UD INPUT TYPE=submit VALUE=SUBMIT onclick=something(this.form) UD but I need a UD INPUT TYPE=button VALUE=SUBMIT onclick=something(this.form) UD to let a JS-routine run, which is further up. UD But I want to pass values to a action script. UD So is there a way to only let the form submit parameters UD if the onclick-routine is passed ? UD Thanks for ideas. UD Uwe -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
CF5 on .NET-Server
Hi CF-Talkers, did anyone of try to run CF5 on a .NET-Server Release-Candidate? I found some infos on how to get CFMX working with IIS6 but nothing about CF5. Any experience??? Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] ~| 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: WDDX regional data coming in wrong
I faced the same problem here today with sending a wddx-packet from cfmx via cfhhtp (+char-encoding=iso) to cf4.0. The 4.0-WDDX-Parser screwed up on the first occurrence of an extended german char. *Sigh* Patric JvD Robertson-Ravo, Neil (REC) wrote: I have a wddx file which has a CF structure within it. In that structure there is a series of German text blocks with all the regional type letters within it... however, when I read the value into ColdFusion 5, the value seems to go tits up ? it appears to be CF which is messing with the original value. JvD What charset are you using on both ends? JvD Jochem JvD ~| 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: WDDX regional data coming in wrong
Hi Jochem, charset=ISO-8859-1 JvD Patric Stumpe wrote: I faced the same problem here today with sending a wddx-packet from cfmx via cfhhtp (+char-encoding=iso) JvD ISO what? JvD Jochem JvD ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
Re: WDDX regional data coming in wrong
Well I solved it (kind of) by using cfftparams of type=formfield to transfer every needed info for itself instead of transferring the serialized structure... Not really what I wanted! Patric PS I faced the same problem here today with sending a wddx-packet from cfmx PS via cfhhtp (+char-encoding=iso) to cf4.0. The 4.0-WDDX-Parser screwed up PS on the first occurrence of an extended german char. PS *Sigh* PS Patric JvD Robertson-Ravo, Neil (REC) wrote: I have a wddx file which has a CF structure within it. In that structure there is a series of German text blocks with all the regional type letters within it... however, when I read the value into ColdFusion 5, the value seems to go tits up ? it appears to be CF which is messing with the original value. JvD What charset are you using on both ends? JvD Jochem JvD PS ~| 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: Upgrading to CFMX from CF 4.0
Hi Rick, a problem occurs when outputting database-entries with CFMX which came from CF4/CF5 because they know only use Unicode. Was a problem for me here with german extended characters... Patric RR I'm about to take on the daunting task of moving a large departmental RR web site built in Cold fusion from a Windows NT machine running CF 4.0 RR to a new Windows 2000 machine running CFMX. RR Thank god I don't have to do a pure upgrade, as I can keep the web site RR live on the old machine until I've fully tested and made all the RR necessary changes. RR The old machine uses a variety of Access databases, along with RR connections to Oracle and DB2 using native drivers. RR I've never worked with CFMX yet, but I have been using CF 5 for quite a RR while in my consulting business. RR What are some of the gotchas i'm going to face in this upgrade? RR The ones I know off the top of my head: RR #1 - Locking changed between CF4 and CF4.5 RR #2 - White Space Supression (I can disable, right?) RR Thanks for your comments! RR - Rick RR ~| 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: Visual Source Safe and CF Studio
Hi Jeffry, when you log any file out via CFStudio it becomes marked ni VSS on the server. At least it should be. Patric JH At 01:08 PM 10/10/2002 +0100, you wrote: How does CF Studio integrate with Visual Source Safe? Very well, I've used it in the past. It seems to me that VSS is intended to copy the file locally. That I think I'm probably missing something important with regards to Source Control. Well, if it didn't copy it to local storage, how would you be able to edit it ? I think the way round it is to check things out to a local project, and then use Studio's deploy functions to send them up to the RDS server when ya done. JH It is all becoming clear (sort of) JH However, if all the other developers are editing on Server A, wouldn't I JH have to be editing on the same server for the VSS to have any effect? JH -- JH Jeffry Houser | mailto:[EMAIL PROTECTED] JH Need a Web Developer? Contact me! JH AIM: Reboog711 | Phone: 1-203-379-0773 JH -- JH My CFMX Book: JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 JH My Books: http://www.instantcoldfusion.com JH My Band: http://www.farcryfly.com JH ~| 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 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: Visual Source Safe and CF Studio
Weel that's what I mean to recall too. Jeff said he had a mapped drive, so it shouldn't be a problem. And VSS-Server allows to publish a project (if needed) to an online server. I think it's a very good solution for a concurrent users working with CFStudio. The only sad thing is to connect to the VSS-Server via Internet. I tested SourceOffSite, but that screwed (kind of) my checked in/out files with where users with LAN-connection to the server worked also on the project. Hrmm... Perhaps I'll try to get my VPN working sometime... Patric KW I don't believe Projects work with RDS. Project are based on local or KW mapped drives. KW Ken KW -Original Message- KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]] KW Sent: Thursday, October 10, 2002 9:39 AM KW To: CF-Talk KW Subject: Re: Visual Source Safe and CF Studio KW Okay, that makes sense. I can't figure out how to fill a CF Studio KW project with files over RDS, though. KW It hasn't helped that the server was inaccessible by me this morning, KW though. KW At 03:07 PM 10/10/2002 +0200, you wrote: Hi Jeffry, when you log any file out via CFStudio it becomes marked ni VSS on the server. At least it should be. Patric JH At 01:08 PM 10/10/2002 +0100, you wrote: How does CF Studio integrate with Visual Source Safe? Very well, I've used it in the past. It seems to me that VSS is intended to copy the file locally. KW That I think I'm probably missing something important with regards to Source Control. Well, if it didn't copy it to local storage, how would you be able to edit it ? I think the way round it is to check things out to a local project, and then use Studio's deploy functions to send them up to the RDS server when ya done. JH It is all becoming clear (sort of) JH However, if all the other developers are editing on Server A, wouldn't I JH have to be editing on the same server for the VSS to have any JH effect? JH -- JH Jeffry Houser | mailto:[EMAIL PROTECTED] JH Need a Web Developer? Contact me! JH AIM: Reboog711 | Phone: 1-203-379-0773 JH -- JH My CFMX Book: JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20 JH JH My Books: http://www.instantcoldfusion.com JH My Band: http://www.farcryfly.com JH KW ~| 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: Visual Source Safe and CF Studio
Ahh, should have read your initial post more carefully. Sorry. But wouldn't it be too easy if everthing would work instantly..? :) Patric JH At 04:05 PM 10/10/2002 +0200, you wrote: Weel that's what I mean to recall too. Jeff said he had a mapped drive, so it shouldn't be a problem. JHI have a mapped drive to the VSS database. But, only RDS or FTP access JH to the actual files I'm working on. JH : groans: JH Luckily, I think they are the same server.. so my username / password JH combo might work. JH Unluckily, the server seems down, so I can't test the theory. And VSS-Server allows to publish a project (if needed) to an online server. I think it's a very good solution for a concurrent users working with CFStudio. The only sad thing is to connect to the VSS-Server via Internet. I tested SourceOffSite, but that screwed (kind of) my checked in/out files with where users with LAN-connection to the server worked also on the project. Hrmm... Perhaps I'll try to get my VPN working sometime... Patric KW I don't believe Projects work with RDS. Project are based on local or KW mapped drives. KW Ken KW -Original Message- KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]] KW Sent: Thursday, October 10, 2002 9:39 AM KW To: CF-Talk KW Subject: Re: Visual Source Safe and CF Studio KW Okay, that makes sense. I can't figure out how to fill a CF Studio KW project with files over RDS, though. KW It hasn't helped that the server was inaccessible by me this morning, KW though. KW At 03:07 PM 10/10/2002 +0200, you wrote: Hi Jeffry, when you log any file out via CFStudio it becomes marked ni VSS on the server. At least it should be. Patric JH At 01:08 PM 10/10/2002 +0100, you wrote: How does CF Studio integrate with Visual Source Safe? Very well, I've used it in the past. It seems to me that VSS is intended to copy the file locally. KW That I think I'm probably missing something important with regards to Source Control. Well, if it didn't copy it to local storage, how would you be able to edit it ? I think the way round it is to check things out to a local project, and then use Studio's deploy functions to send them up to the RDS server when ya done. JH It is all becoming clear (sort of) JH However, if all the other developers are editing on Server A, wouldn't I JH have to be editing on the same server for the VSS to have any JH effect? JH -- JH Jeffry Houser | mailto:[EMAIL PROTECTED] JH Need a Web Developer? Contact me! JH AIM: Reboog711 | Phone: 1-203-379-0773 JH -- JH My CFMX Book: JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20JH JH My Books: http://www.instantcoldfusion.com JH My Band: http://www.farcryfly.com JH KW JH ~| 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: SOT: RegEx
Hi Willy, if it's always the same structure you could get use ListGet(myString, 3, ' ') With space as delimiter. Just a thought... Patric WR Ok, I have a string that looks like this: WR /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01 WR It's an imagemagic identification of a file that my user is uploading. myfile.jpg is CFFILE.clientfile. WR I need to go through this thing and get the 1280x1024 out. I could come up with a way to do this w/o regular expressions, but it wouldn't be as flexible as I'd like it to be. WR I've tried this: WR cfset location = REFind(/d+x/d+, mystring) WR And this: WR cfset start = REFind([/d+]x[/d+], mystring) WR Doesn't seem to work. Any ideas? WR - WR Willy Ray WR Web Applications Developer WR Certified Advanced ColdFusion Developer WR Westminster College WR ~| 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: How do I send email with logos(images) after a query result?
Hi Kodjo, could it be that you need to use an absolute URL or embed the image manual? Patric KA I expect to see the image in the first row at the top of the email but I KA only see a place holder. KA Kodjo Ackah KA Principal Consultant KA Concrete Media Ltd KA 32 Great Sutton Street KA Clerkenwell KA London, EC1V 0DX KA Tel:+44 (0)20 7251 8090 KA Fax: +44 (0)20 7251 8780 KA Mobile: +44 (0)7748 79 1038 KA Office Location: KA http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 KA -Original Message- KA From: Stephen Moretti [mailto:[EMAIL PROTECTED]] KA Sent: 07 October 2002 11:41 KA To: CF-Talk KA Subject: Re: How do I send email with logos(images) after a query KA result? KA Kodjo, Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? KA Why doesn't it work? What happens? Is there an error that you receive? KA Stephen KA ~| 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: Starting PWS Automatically to Run Scheduled Tasks
Hi Chris, why don't you setup IIS5 on your machine which always runs as a service? (It even runs on Win2K-Pro) So you can be sure it's on boot-time. Patric CM Howdy Cf-Talk, CM My ISP won't allow it's customers to use CFSchedule to run events[1] and CM so I need to execute an event on my remote site from my local dev box. I CM am running Personal Web Server on Win2k for development purposes. Can't CM remember how to make sure PWS starts automatically when my computer CM starts/re-starts. I had it working for awhile where it ran automatically CM upon bootup, but now it won't start automatically. CM Can anyone remind me of what service makes PWS start and run CM automatically? I have the World Wide Web Publishing Service service CM set to start automatically, but it must be something else. CM Thanks! CM [1] My ISP says: I regret that we are unable to support scheduled tasks CM in a large shared environment due to the serious performance problems CM and crashes that it creates on the servers. I'm sorry for the CM misunderstanding about this. We specifically mention on the ColdFusion CM page of our website that the Scheduled Tasks feature is not available on CM shared servers. Most folks who need to have an automated activity use CM their local system to make the call. This avoids the inherent problems CM with the task scheduler and does not crash the servers. CM The note on their site about not allowing scheduled tasks is new and I CM wasn't aware about it. But is this a normal policy for most hosting CM companies offering CF on shared services? Just wondering. CM Chris Montgomerymonty @ airtightweb.com -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: Starting PWS Automatically to Run Scheduled Tasks
Hi Chris, you look in control-panel under services (should be named this way in english) and there you should find a WWW-service at the bottom of the list which has to be set to start: automatically. Hope this helps Patric CM Howdy Patric, CM Friday, September 27, 2002, 9:49:31 AM, Patric Stumpe wrote: PS why don't you setup IIS5 on your machine which always runs as a PS service? (It even runs on Win2K-Pro) PS So you can be sure it's on boot-time. CM I actually did install IIS5 on my machine after I installed Win2k Pro. I CM just can't seem to remember the correct settings to ensure it's running CM after booting. The desktop icon actually says Personal Web Manager, CM not Personal Web Server. My mistake. Sorry for the confusion. CM Thanks. CM Chris Montgomerymonty @ airtightweb.com -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: Retrieving foreign characters from DB
To Paul Hastings (and other that may help), I found out that my problem is related to the fact that I use MySQL. When I use MS-Access as the backend everthing seems to work fine. I made a simple insert-form and took care of the encoding in the head of the page. The data gets correctly inserted when submitting the form with MX (as far as I can trust my query tool) but it's not getting display properly when outputting it to screen with MX...? Now is this an CFMX-issue or an MySQL-thing?? Hope you or someone else from the list can point me to a solution. TIA Patric PS Hi CF-Talkers, PS does anyone of know how to retrieve and properly display foreign characters (in this case PS german ones) from an existing MySQL-Datasource with CFMX. My app PS worked with CF5 but now it renders some glyphs where those extended PS characters should appear. The characters are correctly shown in the DB PS when the data is retrieved with any other query-tool. PS Btw the CFMX_Server is the english release, PS not the international. PS Hope my question is understandable PS Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: Retrieving foreign characters from DB
Hi Paul, could you kindly point me to a direction where can I dig into the options for the mm-mysql-driver? And thanks for repeatingly answering all those questions regarding internationalization even on the mm-forums :) Patric I found out that my problem is related to the fact that I use MySQL. When I use MS-Access as the backend everthing seems to work PH sorry, been at another site all day. PH i kind of thought that might be the case--mysql isn't particularly suited to PH i18n apps, doesn't do unicode, etc. though the driver mm uses (mm.mysql) claims PH to handle double byte data. i guess have a look at what options for character PH encoding that driver has to offer. Now is this an CFMX-issue or an MySQL-thing?? PH since i can work plenty fine with just about any language w/cfmx sql server i PH will take a stab at blaming mysql... PH __ 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: Retrieving foreign characters from DB
Thanks a lot Paul. If I find something usefull I'll share my thoughts... Patric could you kindly point me to a direction where can I dig into the options for the mm-mysql-driver? PH maybe try here: http://sourceforge.net/projects/mmmysql PH __ 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: Retrieving foreign characters from DB
Well I read that too. But I think they mentioned it for release 4.1. I just installed the actual devel.-release 4.0.1 alpha. Don't know how long to last. Now I'm trying to get the actual released 2.0.14 MM.MySQL-JDBC-Driver installed into CFMX... Hmm we'll see Patric Thanks a lot Paul. If I find something usefull I'll share my thoughts... PH googled a few more: PH http://www.caucho.com/projects/jdbc-mysql/index.xtp PH http://www.firstsql.com/java/mysql/ PH well if you can wait, i've heard (but really no nothing about mysql) that the PH next version (4.x??) will be unicode compliant. PH __ 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: Retrieving foreign characters from DB
Well folks, I think I got it. MySQL displays german Umlaute! If anyone wants to know reply to the list 'cause i'll take hurry writing the facts... Patric PS Well I read that too. But I think they mentioned it for release 4.1. I PS just installed the actual devel.-release 4.0.1 alpha. Don't know how PS long to last. Now I'm trying to get the actual released 2.0.14 PS MM.MySQL-JDBC-Driver installed into CFMX... Hmm we'll see PS Patric Thanks a lot Paul. If I find something usefull I'll share my thoughts... PH googled a few more: PH http://www.caucho.com/projects/jdbc-mysql/index.xtp PH http://www.firstsql.com/java/mysql/ PH well if you can wait, i've heard (but really no nothing about mysql) that the PH next version (4.x??) will be unicode compliant. PH PS __ 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
Retrieving foreign characters from DB
Hi CF-Talkers, does anyone of know how to retrieve and properly display foreign characters (in this case german ones) from an existing MySQL-Datasource with CFMX. My app worked with CF5 but now it renders some glyphs where those extended characters should appear. The characters are correctly shown in the DB when the data is retrieved with any other query-tool. Btw the CFMX_Server is the english release, not the international. Hope my question is understandable Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: Retrieving foreign characters from DB
Well Marius and Paul, would I get the characters to be displayed properly with these modifications to the application.cfm?? Patric CFMX cannot read (properly) locales saved with CF5. no, only utf-8 encoded stuff saved via cf5. laurent i (mainly laurent's ideas) are working on a fix for that. my thai saved as varchar--note not N varchar--works plenty fine. in any case you should put the following in your Application.cfm file cfcontent type=text/html; charset=your char set cfset setEncoding(URL, your char set) cfset setEncoding(FORM, your char set) yes these and cfprocessingdirective (in each template) form the big three for i18n work. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/6/2545 __ 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: java compiler errors
Had the same error once. Deleted all compoiled files in cfclasses and everything worked. Patric wec Error Occurred While Processing Request wec Errors reported by Java compiler: Found 1 semantic error compiling wec C:/CFusionMX/wwwroot/WEB-INF/cfclasses/cfApplication2ecfm573238503.java: wec 1. public final class cfApplication2ecfm573238503 extends wec coldfusion.runtime.CFPage{ - *** Error: Cannot wec write class file cfApplication2ecfm573238503.class because that name wec conflicts with the name of the class file wec cfapplication2ecfm573238503.class in directory cfclasses. This is wec illegal because file names are case-insensitive in this system. . wec Anyone have an idea what this error msg is describing? I don't see the path wec being described, but I was guessing that was some sort of virtual java wec path... or ?? wec It seems to be only happening with one site... so I'm about to dig in and wec look for it, but I figured I'd toss the question to the list and see if I wec could get an explanation. wec TIA! wec -Lou wec __ 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
CommerceBlocks anyone?
Hi list! Did anyone on this list work with any of those CommerceBlocks-Modules (in fact there seems to be only this database-module at the moment)? It seems to be an interesting concept but I'd like to evaluate some opinions 'bout this. Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: CommerceBlocks anyone?
Hi Andy, I think the productline they're about to release (if so) could be good approach for enhancing development productivity in concern of standard taasks -- e.g. building forms and so on... So I'm curious if anyone here did/does work with their product (www.commerceblocks.com). Patric AO What are you referring to? AO -Original Message- AO From: Patric Stumpe [mailto:[EMAIL PROTECTED]] AO Sent: Monday, June 24, 2002 8:13 AM AO To: CF-Talk AO Subject: CommerceBlocks anyone? AO Hi list! AO Did anyone on this list work with any of those CommerceBlocks-Modules AO (in fact there seems to be only this database-module at the moment)? AO It seems to be an interesting concept but I'd like to evaluate some AO opinions 'bout this. AO Patric AO -- AO Patric Stumpe AO mailto:[EMAIL PROTECTED] AO __ 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: CommerceBlocks anyone? From Adam
Hi Adam, thanks for your response to the list. I can imagine that this honourable 'Honourware'-concept did fail. But besides this do think there will be a chance of testing your V3 when it comes prior to buy it? TIA Patric AC Folks, AC We've been working on CommerceBlocks 3 for the past fifteen months, and we AC are currently looking for a small (manageable) group of people who want to AC guide us on the final details of what they want out of the product and how AC they want to work with the tool as ColdFusion developers. We're all going AC to meet in Atlanta within the next few weeks to grind out the final details. AC If you're interested in joining the team then please contact me offlist. AC The new CommerceBlocks has many new modules and will make you all very happy AC people, I assure you. AC Don't go to www.commerceblocks.com, because you will get the old version 2 AC that times out. We never bothered to upgrade to the licensable version AC because out of the thousands of people who downloaded it, so few people AC actually paid for it that the total revenue didn't even pay our attorneys AC for crafting the End User License Agreement, and we lost tens thousands of AC dollars developing it. For this reason, HonorWare is now dead forever, and AC the new CommerceBlocks is copy protected tighter than Pamela Anderson in a AC training bra. AC We'll be shutting down the current CommerceBlocks.com in a few days until V3 AC is launched, and we're selling no new licenses to V2. AC PS-- We will be switching our new ColdFusion optimization and analysis AC tool -- LoRCAT -- to a public Beta later today on AC www.ProductivityEnhancement.com. I'll send another message to this list AC when Beta 4 is ready for download. Don't get Beta 3, as we fixed a number AC of bugs in Beta 4. AC Respectfully, AC Adam Phillip Churvis AC Certified Advanced ColdFusion Developer AC Productivity Enhancement, Inc. AC http://www.ColdFusionTraining.com AC E-mail: [EMAIL PROTECTED] AC Phone: 770-446-8866 AC - Original Message - AC From: Patric Stumpe [EMAIL PROTECTED] AC To: CF-Talk [EMAIL PROTECTED] AC Sent: Monday, June 24, 2002 9:12 AM AC Subject: CommerceBlocks anyone? Hi list! Did anyone on this list work with any of those CommerceBlocks-Modules (in fact there seems to be only this database-module at the moment)? It seems to be an interesting concept but I'd like to evaluate some opinions 'bout this. Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] AC __ 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: iif driving me nuts
Hi Joshua, you could also use a simple (perhaps faster cfif-statement like this: onClick='alert(cfif qryquicklinks GTE 8Sorry, you suckcfelseYou Deleted Me/cfif)'; Does this help? Patric JT Please help me with this or can you guys and gals tell me a better way to JT code this. Of course the phrases will be changed but this will give you the JT basic concept. JT Josh JT #iif((qryquicklinks.recordcount gte 8), DE(onClick='alert(Sorry, you JT suck)';), DE(onClick='alert(You Deleted Me)';))# JT __ 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: CFMX-Linux won't initate Session-Scope
Hi folks, after all I managed to get it workeing with your help by renaming my application.cfm to Application.cfm. So i finally 'got up my A' :) But now there's another strange problem. I have installed the Verity Locales to implement a full-text-search-interface for *.html and *.pdf which works great under CF5/NT and a bit buggy under CFMX/NT (here it ddoesn't understand the german extended characters?). But it does not return any results under CFMX/Linux. I doesn't matter whether I create the collection (german) from the CF-Admin or programmatically. Did anyone else run into this issue? I already did a search on the forums but there was no CFMX-related problem. Patric PS Hi folks, PS i have a wierd problem. I try to port an small application (that's PS working) for one of our customers from CF4/NT4 to CFMX/RH7.3. PS My application.cfm is this: PS -- PS cfsetting enablecfoutputonly=Yes PS cfapplication name=medienverzeichnis PS applicationtimeout=#CreateTimeSpan(0,0,30,0)# PS sessiontimeout=#CreateTimeSpan(0,0,30,0)# PS clientmanagement=No PS sessionmanagement=Yes PS setclientcookies=No PS cflock timeout=10 PS cfset application.ds = 'guvv_medien' PS cfparam name=session.artikel default=0 PS /cflock PS cfsetting enablecfoutputonly=No PS -- PS The startingpage in this dir is the following index.cfm: PS -- PS cflock timeout=10 PS cfoutput PS frameset cols=170,* border=0 framespacing=0 frameborder=0 PS frame name=navigation src=_frame/navigation.cfm?#Session.URLToken# marginwidth=0 marginheight=0 noresize scrolling=auto border=0 framespacing=0 frameborder=0 PS frame name=inhalt src=_inhalt/start.cfm?#Session.URLToken# marginwidth=0 marginheight=0 noresize scrolling=auto border=0 framespacing=0 frameborder=0 PS /frameset PS /cfoutput PS /cflock PS -- PS This one seems to load just fine. But when the navigation.cfm comes up PS I get the following error: PS Error Occurred While Processing Request PS Element URLTOKEN is undefined in SESSION. PS The Error Occurred in /var/www/html/guvv-wl/medien/verzeichnisse/_frame/navigation.cfm: line 17 PS 15 :tr align=lefttd width=155 align=left valign=topa href=../../zeitschriften target=mainimg src=../../_px/nav_zei_of.gif width=155 height=17 alt= PS border=0/a/td/tr PS 16 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr PS 17 :tr align=lefttd width=155 align=left valign=topa href=../../verzeichnisse/cfoutputindex.cfm?#Session.URLToken#/cfoutput target=mainimg PS src=../../_px/nav_med_on.gif width=155 height=17 alt= border=0/td/tr PS 18 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr PS 19 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_blind.gif width=155 height=20 alt= border=0/td/tr PS BTW: There's a lock around the session-request. And I do not have any PS other application.cfm lying around. PS The same pages on CFMX-RC with Windows do work. PS I don't know where to go... any help? PS TIA PS Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: CFMX-Linux won't initate Session-Scope
Thanks Dave, i'll give that a try! Patric Hi folks, after all I managed to get it workeing with your help by renaming my application.cfm to Application.cfm. So i finally 'got up my A' :) But now there's another strange problem. I have installed the Verity Locales to implement a full-text-search-interface for *.html and *.pdf which works great under CF5/NT and a bit buggy under CFMX/NT (here it ddoesn't understand the german extended characters?). But it does not return any results under CFMX/Linux. I doesn't matter whether I create the collection (german) from the CF-Admin or programmatically. Did anyone else run into this issue? I already did a search on the forums but there was no CFMX-related problem. DC Quoting directly from the release notes under the Verity Searches section: DC Verity does not support VSpider on Linux. Also note that Linux does not DC support PDF files. DC Since you're trying to index PDFs, that might answer your question. Try DC doing *.html pages only on Linux and see if you have better success. DC Regards, DC Dave. DC __ 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: CFMX-Linux won't initate Session-Scope
Well that didn't really do it. Nothing seems to get indexed... and no error occurs Patric PS Thanks Dave, PS i'll give that a try! PS Patric Hi folks, after all I managed to get it workeing with your help by renaming my application.cfm to Application.cfm. So i finally 'got up my A' :) But now there's another strange problem. I have installed the Verity Locales to implement a full-text-search-interface for *.html and *.pdf which works great under CF5/NT and a bit buggy under CFMX/NT (here it ddoesn't understand the german extended characters?). But it does not return any results under CFMX/Linux. I doesn't matter whether I create the collection (german) from the CF-Admin or programmatically. Did anyone else run into this issue? I already did a search on the forums but there was no CFMX-related problem. DC Quoting directly from the release notes under the Verity Searches section: DC Verity does not support VSpider on Linux. Also note that Linux does not DC support PDF files. DC Since you're trying to index PDFs, that might answer your question. Try DC doing *.html pages only on Linux and see if you have better success. DC Regards, DC Dave. DC PS __ 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
CFMX-Linux won't initate Session-Scope
Hi folks, i have a wierd problem. I try to port an small application (that's working) for one of our customers from CF4/NT4 to CFMX/RH7.3. My application.cfm is this: -- cfsetting enablecfoutputonly=Yes cfapplication name=medienverzeichnis applicationtimeout=#CreateTimeSpan(0,0,30,0)# sessiontimeout=#CreateTimeSpan(0,0,30,0)# clientmanagement=No sessionmanagement=Yes setclientcookies=No cflock timeout=10 cfset application.ds = 'guvv_medien' cfparam name=session.artikel default=0 /cflock cfsetting enablecfoutputonly=No -- The startingpage in this dir is the following index.cfm: -- cflock timeout=10 cfoutput frameset cols=170,* border=0 framespacing=0 frameborder=0 frame name=navigation src=_frame/navigation.cfm?#Session.URLToken# marginwidth=0 marginheight=0 noresize scrolling=auto border=0 framespacing=0 frameborder=0 frame name=inhalt src=_inhalt/start.cfm?#Session.URLToken# marginwidth=0 marginheight=0 noresize scrolling=auto border=0 framespacing=0 frameborder=0 /frameset /cfoutput /cflock -- This one seems to load just fine. But when the navigation.cfm comes up I get the following error: Error Occurred While Processing Request Element URLTOKEN is undefined in SESSION. The Error Occurred in /var/www/html/guvv-wl/medien/verzeichnisse/_frame/navigation.cfm: line 17 15 :tr align=lefttd width=155 align=left valign=topa href=../../zeitschriften target=mainimg src=../../_px/nav_zei_of.gif width=155 height=17 alt= border=0/a/td/tr 16 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr 17 :tr align=lefttd width=155 align=left valign=topa href=../../verzeichnisse/cfoutputindex.cfm?#Session.URLToken#/cfoutput target=mainimg src=../../_px/nav_med_on.gif width=155 height=17 alt= border=0/td/tr 18 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr 19 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_blind.gif width=155 height=20 alt= border=0/td/tr BTW: There's a lock around the session-request. And I do not have any other application.cfm lying around. The same pages on CFMX-RC with Windows do work. I don't know where to go... any help? TIA Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: CFMX-Linux won't initate Session-Scope
Hi Mark, I already tried that but when the server also didn't know what session.sessionid was. Very strange behaviour Patric MAKC Patric, MAKC There is an Admin feature to use JSP type sessions ( .cfm;sessionid=adf090 MAKC .. etc.) Is it possible this is set? MAKC Mark MAKC -Original Message- MAKC From: Patric Stumpe [mailto:[EMAIL PROTECTED]] MAKC Sent: Friday, June 07, 2002 10:31 AM MAKC To: CF-Talk MAKC Subject: CFMX-Linux won't initate Session-Scope MAKC Hi folks, MAKC i have a wierd problem. I try to port an small application (that's MAKC working) for one of our customers from CF4/NT4 to CFMX/RH7.3. MAKC My application.cfm is this: MAKC -- MAKC cfsetting enablecfoutputonly=Yes MAKC cfapplication name=medienverzeichnis MAKC applicationtimeout=#CreateTimeSpan(0,0,30,0)# MAKC sessiontimeout=#CreateTimeSpan(0,0,30,0)# MAKC clientmanagement=No MAKC sessionmanagement=Yes MAKC setclientcookies=No MAKC cflock timeout=10 MAKC cfset application.ds = 'guvv_medien' MAKC cfparam name=session.artikel default=0 MAKC /cflock MAKC cfsetting enablecfoutputonly=No MAKC -- MAKC The startingpage in this dir is the following index.cfm: MAKC -- MAKC cflock timeout=10 MAKC cfoutput MAKC frameset cols=170,* border=0 framespacing=0 frameborder=0 MAKC frame name=navigation src=_frame/navigation.cfm?#Session.URLToken# MAKC marginwidth=0 marginheight=0 noresize scrolling=auto border=0 MAKC framespacing=0 frameborder=0 MAKC frame name=inhalt src=_inhalt/start.cfm?#Session.URLToken# MAKC marginwidth=0 marginheight=0 noresize scrolling=auto border=0 MAKC framespacing=0 frameborder=0 MAKC /frameset MAKC /cfoutput MAKC /cflock MAKC -- MAKC This one seems to load just fine. But when the navigation.cfm comes up MAKC I get the following error: MAKC Error Occurred While Processing Request MAKC Element URLTOKEN is undefined in SESSION. MAKC The Error Occurred in MAKC /var/www/html/guvv-wl/medien/verzeichnisse/_frame/navigation.cfm: line 17 MAKC 15 :tr align=lefttd width=155 align=left valign=topa MAKC href=../../zeitschriften target=mainimg src=../../_px/nav_zei_of.gif MAKC width=155 height=17 alt= border=0/a/td/tr MAKC 16 :tr align=lefttd width=155 align=left valign=topimg MAKC src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr MAKC 17 :tr align=lefttd width=155 align=left valign=topa MAKC href=../../verzeichnisse/cfoutputindex.cfm?#Session.URLToken#/cfoutput target=mainimg src=../../_px/nav_med_on.gif width=155 height=17 alt= border=0/td/tr MAKC 18 :tr align=lefttd width=155 align=left valign=topimg MAKC src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr MAKC 19 :tr align=lefttd width=155 align=left valign=topimg MAKC src=../../../_px/nav_blind.gif width=155 height=20 alt= border=0/td/tr MAKC BTW: There's a lock around the session-request. And I do not have any MAKC other application.cfm lying around. MAKC The same pages on CFMX-RC with Windows do work. MAKC I don't know where to go... any help? MAKC TIA MAKC Patric MAKC -- MAKC Patric Stumpe MAKC mailto:[EMAIL PROTECTED] MAKC __ 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: CFMX-Linux won't initate Session-Scope
hr, I think the week was too long for me (too much soccer and work :) ). Now I'm at homebut surely the application.cfm-File has an lowercase letter 'a'. I'll try that on monday! Thanks a lot guys! Patric Yeah, Application.cfm on linux is case sensitive. On Fri, 7 Jun 2002, Dick Applebaum wrote: Patric I just tried this on CFMX Linux ported to Mac OS X. It worked, fine Could it be that your Application.cfm doesn't start with an upper case A This is not required on OS X, but I think it is required on Linux Dick On Friday, June 7, 2002, at 08:49 AM, Mark A. Kruger - CFG wrote: Patric, There is an Admin feature to use JSP type sessions ( .cfm;sessionid=adf090 .. etc.) Is it possible this is set? Mark -Original Message- From: Patric Stumpe [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 10:31 AM To: CF-Talk Subject: CFMX-Linux won't initate Session-Scope Hi folks, i have a wierd problem. I try to port an small application (that's working) for one of our customers from CF4/NT4 to CFMX/RH7.3. My application.cfm is this: -- cfsetting enablecfoutputonly=Yes cfapplication name=medienverzeichnis applicationtimeout=#CreateTimeSpan(0,0,30,0)# sessiontimeout=#CreateTimeSpan(0,0,30,0)# clientmanagement=No sessionmanagement=Yes setclientcookies=No cflock timeout=10 cfset application.ds = 'guvv_medien' cfparam name=session.artikel default=0 /cflock cfsetting enablecfoutputonly=No -- The startingpage in this dir is the following index.cfm: -- cflock timeout=10 cfoutput frameset cols=170,* border=0 framespacing=0 frameborder=0 frame name=navigation src=_frame/navigation.cfm?#Session.URLToken# marginwidth=0 marginheight=0 noresize scrolling=auto border=0 framespacing=0 frameborder=0 frame name=inhalt src=_inhalt/start.cfm?#Session.URLToken# marginwidth=0 marginheight=0 noresize scrolling=auto border=0 framespacing=0 frameborder=0 /frameset /cfoutput /cflock -- This one seems to load just fine. But when the navigation.cfm comes up I get the following error: Error Occurred While Processing Request Element URLTOKEN is undefined in SESSION. The Error Occurred in /var/www/html/guvv-wl/medien/verzeichnisse/_frame/navigation.cfm: line 17 15 :tr align=lefttd width=155 align=left valign=topa href=../../zeitschriften target=mainimg src=../../_px/nav_zei_of.gif width=155 height=17 alt= border=0/a/td/tr 16 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr 17 :tr align=lefttd width=155 align=left valign=topa href=../../verzeichnisse/cfoutputindex.cfm?#Session.URLToken#/cfoutput target=mainimg src=../../_px/nav_med_on.gif width=155 height=17 alt= border=0/td/tr 18 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_trenner.gif width=155 height=1 alt= border=0/td/tr 19 :tr align=lefttd width=155 align=left valign=topimg src=../../../_px/nav_blind.gif width=155 height=20 alt= border=0/td/tr BTW: There's a lock around the session-request. And I do not have any other application.cfm lying around. The same pages on CFMX-RC with Windows do work. I don't know where to go... any help? TIA Patric -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Well folks, I'm a bit stuck with retrieving data from a mySQL-datasource which was exported from ms-access via a little nifty utility called MyAccess. The problem is that the text in the db has german special characters. Since I exported the data to mySQL I'm able to retrieve all the data but the special-chars are shown as symbols 'n' stuff. I took textpad and looked into the data-files mySQL generates for the datasource and they do contain the german chars. Any help out there? Patric PS Hi Jerry, PS thanks for your reply. I'll make sure to have a close look at the PS db-structure before converting. PS Patric JJ I've done this on 5 projects, now. JJ The three things that bit me repeatedly: JJ Boolean types in Access were not the same in mySQL. Went with int (1/0). JJ Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. JJ Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) JJ But it really wasn't very difficult. JJ Jerry Johnson [EMAIL PROTECTED] 05/21/02 08:33AM JJ Hi fellows, JJ i looking for some advice on migrating websites of one of my customers JJ from windows to linux. The customers has it's own CF4.5Pro-Server and JJ 'cause he switched his entire office to linux he's also chenging the JJ webserver to linux with apache. The nice thing is, that is will JJ purchase/update to CF5 or MX. Now my question is will the applications JJ i wrote under Windows+Access run under Linux+MySQL without bigger JJ problems??? i have a event-calendar-app which will probably make no JJ trouble. but i have a little shopping-cart-like app with session-vars JJ and a full-text-search with verity. JJ So if anyone can share experience i would be really glad for any JJ input! JJ TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: Heirmenu
Hi phumes1, I would assume that the dhtml-layer of the menu can't appear anywhere else than in it's own frame... Patric p Hi, p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm p using frames and my dropdown navigation menu is in the top frame and when p clicked does *not* overlay the bottom frame. p Is there a version of heirmenu that allows overlaying on frames? If so, p which one? p +---+ p Philip Humeniuk p [EMAIL PROTECTED] p [EMAIL PROTECTED] p ++ p __ 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: Heirmenu
Well, there'll be nothing (at the moment) that can be rendered partly out of it's own frame. This needs to be implementet in the browsers rendering-engine Patric p In this version, correct. p At 03:34 PM 5/24/2002 +0200, you wrote: Hi phumes1, I would assume that the dhtml-layer of the menu can't appear anywhere else than in it's own frame... Patric p Hi, p Has anyone used the heirmenu from (www.dhtmlmenu.com)? My problem is I'm p using frames and my dropdown navigation menu is in the top frame and when p clicked does *not* overlay the bottom frame. p Is there a version of heirmenu that allows overlaying on frames? If so, p which one? p +---+ p Philip Humeniuk p [EMAIL PROTECTED] p [EMAIL PROTECTED] p ++ p p __ 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: Recomend for those just starting ColdFusion, or experienced
Hi Neil, I ALWAYS use #-signs around all variables everywhere. I've made a keyboard-shortcut for 'Evaluate(#something#)'! It's cool... :))) Patric NCT I think there will be one... Go one then, what did you learn :-) when do NCT you use # signs for the best.. NCT Neil Clark NCT Team Macromedia NCT http://www.macromedia.com/go/team NCT Announcing Macromedia MX!! NCT http://www.macromedia.com/software/trial/. NCT -Original Message- NCT From: Brian Eckerman [mailto:[EMAIL PROTECTED]] NCT Sent: 23 May 2002 16:29 NCT To: CF-Talk NCT Subject: Recomend for those just starting ColdFusion, or experienced NCT Hello, just thought I'd give my $0.02 NCT About a week ago I bought NCT Certified macromedia COLDFUSION Developer Study Guide NCT http://www.amazon.com/exec/obidos/ASIN/0789726963 NCT I bought it to get certified, but I find it has alot of really good NCT tips. NCT Ex. Do you know exactly when and when not to use # around variables? NCT Most people overuse them. NCT It also mentions LDAP a bit. NCT And ofcourse you can get certified. NCT Does anybody know if Macromedia will come out with a book for CFMX? NCT __ 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: Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Hi Jerry, thanks for your reply. I'll make sure to have a close look at the db-structure before converting. Patric JJ I've done this on 5 projects, now. JJ The three things that bit me repeatedly: JJ Boolean types in Access were not the same in mySQL. Went with int (1/0). JJ Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. JJ Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) JJ But it really wasn't very difficult. JJ Jerry Johnson [EMAIL PROTECTED] 05/21/02 08:33AM JJ Hi fellows, JJ i looking for some advice on migrating websites of one of my customers JJ from windows to linux. The customers has it's own CF4.5Pro-Server and JJ 'cause he switched his entire office to linux he's also chenging the JJ webserver to linux with apache. The nice thing is, that is will JJ purchase/update to CF5 or MX. Now my question is will the applications JJ i wrote under Windows+Access run under Linux+MySQL without bigger JJ problems??? i have a event-calendar-app which will probably make no JJ trouble. but i have a little shopping-cart-like app with session-vars JJ and a full-text-search with verity. JJ So if anyone can share experience i would be really glad for any JJ input! JJ TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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
Migrating from CF4.5+WinNT to CF5(or MX)/Linux
Hi fellows, i looking for some advice on migrating websites of one of my customers from windows to linux. The customers has it's own CF4.5Pro-Server and 'cause he switched his entire office to linux he's also chenging the webserver to linux with apache. The nice thing is, that is will purchase/update to CF5 or MX. Now my question is will the applications i wrote under Windows+Access run under Linux+MySQL without bigger problems??? i have a event-calendar-app which will probably make no trouble. but i have a little shopping-cart-like app with session-vars and a full-text-search with verity. So if anyone can share experience i would be really glad for any input! TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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
FileDate from cfftp-listdir
Hi readers, i'm writing a little script for backing up a server to antoher via ftp. everything works except of on thing. i only want to do backup files where the date of the remote ftp-file is newer than the local one. but cfftp shows the correct date only on a few from hundred of files. almost every files LastModified property is 30.12.1899 (after formatting it with #DateFormat(CreateODBCDateTime(LastModified), 'dd.mm.')#). am i missing something??? when list the remote dir with my ftp-client it shows the correct dates... curious about this -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: test
Me too, me too..! No. don't respond. LOL | -Original Message- | From: James Taavon [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, May 14, 2002 11:55 AM | To: CF-Talk | Subject: RE: test | | | are we supposed to respond? this will produce many emails?? | | -Original Message- | From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, May 14, 2002 2:31 PM | To: CF-Talk | Subject: test | | | test | | Michael Dinowitz | Publisher: Fusion Authority weekly news alert | (www.fusionauthority.com/alert) | Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. | (www.houseoffusion.com) | | | __ 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: CF5 Developer Edition
Hi Anthony, just download the 5.0 Enterprise Trial. It'll convert to Developer Edition after 30 days. regards Patric WA Does anybody remember the URL to the CF5 developers edition? Macromedia WA seems to have purged every metion of 5.0 from their site. WA WA Tony Weaver WA Limited Technology Services WA Technology Planning WA Programmer/Analyst WA Phone: 614.415.7647 WA E-mail: [EMAIL PROTECTED] WA THE LIMITED, INC. WA __ 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
RegEx for cleaning up Word-exported HTML
Hi list, is there any regex out for cleaning up html exported from ms-word on the fly? I know 'bout the Word-Addon from M$ but want to plug this regex into my page-processing... Tia -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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[2]: RegEx for cleaning up Word-exported HTML
Thanks Jeff, I'll give it a try! Patric Try using the COM version of HTML-tidy. It should clean up the Word garbage... You can find HTML tidy at http://tidy.sourceforge.net/ (it used to be under the care and feeding of the W3C). The COM object version is linked on the right hand side of the page... HTH, Jeff Garza - Original Message - From: Patric Stumpe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 1:30 PM Subject: RegEx for cleaning up Word-exported HTML Hi list, is there any regex out for cleaning up html exported from ms-word on the fly? I know 'bout the Word-Addon from M$ but want to plug this regex into my page-processing... Tia -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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[3]: RegEx for cleaning up Word-exported HTML
Well, a problem 'bout this approach is that i can't register the Tidy DLL on my ISP server. Any other suggestions? Patric Thanks Jeff, I'll give it a try! Patric Try using the COM version of HTML-tidy. It should clean up the Word garbage... You can find HTML tidy at http://tidy.sourceforge.net/ (it used to be under the care and feeding of the W3C). The COM object version is linked on the right hand side of the page... HTH, Jeff Garza - Original Message - From: Patric Stumpe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 1:30 PM Subject: RegEx for cleaning up Word-exported HTML Hi list, is there any regex out for cleaning up html exported from ms-word on the fly? I know 'bout the Word-Addon from M$ but want to plug this regex into my page-processing... Tia -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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: RegEx for cleaning up Word-exported HTML
Well Jeff, I think I can cfexecute. (i think it worked) Will give this a try! Patric A, the joys of shared hosting Do you have access to CFEXECUTE? I'm assuming not, but if so, there is a command-line version there as well that you might get to work http://freepages.genealogy.rootsweb.com/~renowden/tidy/ beyond that, I think you might be in for a nightmare trying to remove all the junk using regexes HTH, Jeff - Original Message - From: Patric Stumpe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 1:50 PM Subject: Re[3]: RegEx for cleaning up Word-exported HTML Well, a problem 'bout this approach is that i can't register the Tidy DLL on my ISP server. Any other suggestions? Patric Thanks Jeff, I'll give it a try! Patric Try using the COM version of HTML-tidy. It should clean up the Word garbage... You can find HTML tidy at http://tidy.sourceforge.net/ (it used to be under the care and feeding of the W3C). The COM object version is linked on the right hand side of the page... HTH, Jeff Garza - Original Message - From: Patric Stumpe [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 1:30 PM Subject: RegEx for cleaning up Word-exported HTML Hi list, is there any regex out for cleaning up html exported from ms-word on the fly? I know 'bout the Word-Addon from M$ but want to plug this regex into my page-processing... Tia -- Patric Stumpe mailto:[EMAIL PROTECTED] __ 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
DB problem
Hi fellows, I'm stumbling about an SQL-error. I'm just trying to insert some stupid news-ticker-data to an acces-db, but the following error appears: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in der INSERT INTO-Anweisung. SQL = INSERT INTO news (text, startdatum, enddatum, aktiv) VALUES ('test-news', {ts '2002-04-20 00:00:00'}, {ts '2002-05-20 00:00:00'}, 1) Data Source = MAX_FORUM The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:2) to (6:51) in the template file D:\inetpub\site\_admin\action_news.cfm. -- My action looks like this: -- cfset startdatum = CreateODBCDateTime(CreateDate(#form.startjahr#, #form.startmonat#, #form.starttag#)) cfset enddatum = CreateODBCDateTime(CreateDate(#form.endjahr#, #form.endmonat#, #form.endtag#)) cfquery name=insertNews datasource=max_forum INSERT INTO news(text, startdatum, enddatum, aktiv) VALUES ('#HTMLEditFormat(form.text)#', #startdatum#, #enddatum#, #form.aktiv#) /cfquery - The db-fields are defined as these: TABLE news id (Auto) text (MEMO) startdatum (DateTime) enddatum (DateTime) aktiv (BIT) Any ideas -- best regards Patric Stumpe mailto:[EMAIL PROTECTED] __ 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[2]: DB problem
Hi Justin, that's what it all was about :( too late for me today :) Big thanks JS Avoid using generic table and column names (such as text) if at all JS possible. If you MUST, enclose it in brackets [] so that the driver will JS know you mean a table/column name instead of a data type. JS -Justin Scott, Lead Developer JS Sceiron Internet Services, Inc. JS http://www.sceiron.com -- Patric Stumpemailto:[EMAIL PROTECTED] __ 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[2]: CF VS ASP - let the trolling being
Well just a snippet from MM-site: The ColdFusion Trial Edition automatically converts to a non-expiring, full-featured single user Developer Edition after the 30-day trial period. The Developer Edition is currently available only for Windows and only in English. Not that crippled CFExpress-version Patric Stumpe mail: [EMAIL PROTECTED] __ 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
Verity Speech-Packs
Hi there, does ne1 know where to get the additional language packs for the verity engine in cf4.0? Patric Stumpe mail: [EMAIL PROTECTED] __ 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[2]: Using RegularExpressions
Hi Dick, I'll give it a try on monday. Is the 'Backslash-1' an Placeholderholder? Thanx a lot Patric mail: [EMAIL PROTECTED] DA Try DAnew = ReReplaceNoCase(old, 'a href=([a-z0-9])', 'a href=../\1', DA 'all'); DA HTH DA Dick __ 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[3]: Using RegularExpressions
So do you think it would also work in the Extended-Search/Replace-Menu in Studio or do I have to write a little cfm for that? Patric Stumpe mail: [EMAIL PROTECTED] DA It is a backreference to remembered text (enclosed in parens) in the DA first term (you can have up to 9 such items \1, \2... corresponding DA to 9 sets of parens DA So: DA 'a href=([a-z0-9])', 'a href=../\1' = DA|| DA|| DA|| DAremembered replaced with remembered DA The remembered text, in this case is DA any letter or number followinga href= DA Dick __ 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[4]: Using RegularExpressions
Well... :) I'll try the Studio feature. Nothing can't go wrong. But nevertheless fine to get some help from a Mac-User :)) But I'll mention here if it worked, when I'm back to work again! Patric Stumpe mail: [EMAIL PROTECTED] DA I don't know... I don't use studio... DA If studio supports back references then you are good! DA Its my understanding that most program editors support grep (and back DA references), so I would be surprised if studio doesn't. DA I use BBEdit on the Mac and it supports them. DA Dick __ 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 Previous/Next-Records Navigation
Hi fellows, i have the following problem. On one of my sites I have result-pages for querys where a lot of records may be outputted. Now I want to include a Previos/Next-Navigation with 25 records displayed per page. The problem is that the query is grouped by two columns before the actual record is displayed. So i don't have the ability to work with the standard approach with limiting the output via cfoutput query="foo" startrow="#start#" maxrows="25" because only the outer two grouped cfoutputs use the query-attribute. I hope someone does understand what I mean and can help me. Below is the adress of the mentioned site called Teilemax.de. There you can enter a space in the formfield "Schnellsuche" (quicksearch) and you get the result-page. For the coders out there I would also send my code off-list 'cause I think it would blow this mail. -- thanx in advance Patric Stumpe Knust Stumpe Datentechnik Abt. Webdesign mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Displaying message during loading..?
Hi there, i'm wondering how i can create a message on a page that's displayed during the page is loaded. So when a query returns many results the users gets this message saying the data is on it's way and hiding this message when the query results have been loaded and displayed. Hope someone can point me to the right direction... Patric -- Patric Stumpe Knust Stumpe Datentechnik Abt. Webdesign mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Displaying message during loading..?
Well people, i have to thank you all for the great response on such a perhaps lame question. But nevertheless i'll test all variants. Personally the version Mike mentioned with the bg-image sounds like a nice approach :). Am 13.03.2001 um 00:47 schrieben Sie: MK Have a look at www.ibluegrass.com ... I think Skip Ogden is doing this MK with a very simple method just use a background image for the page MK that has "Loading ..." in it. The page first appears with only the MK background image showing. Then, when the page is finished loading, a MK table appears over the top of the "loading" text with a bgcolor set in the MK .table tag and the "loading ..." isn't seen any more. Simple, and MK absolutely no processing overhead. And no need for pesky javascript. MK But I might be wrong - I often am - just ask my wife and kids. MK Cheers, MK Mike Kear MK Windsor, NSW, Australia MK AFP Webworks. -- Patric Stumpe Knust Stumpe Datentechnik Abt. Webdesign mail: [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Comparing 2 Lists in a query
Well, it's not the elegant way - but i'll give it a try. I hope it works. Thanks Aaron. Patric - Original Message - From: "Aaron Johnson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, January 14, 2001 6:42 AM Subject: RE: Comparing 2 Lists in a query -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Patric, I don't think there is anyway to do it SQL (you can do a "select * from hotels WHERE merkale IN ('var1,var2'), but this means your the form variable merkale would have to be ordered exactly the same as the vars in the db)... However, you could get all the hotels from your DB that match the other criteria (zipcode, city..) and then loop over the results of the query and compare the two lists you have to see if they are equal using a custom tag from the Gallery called cf_listcompare available here (http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347369-2830- 11D4-AA9700508B94F380method=Full). HTH. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. phn617.350.0339 fax617.350.8884 icq66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Comparing 2 Lists in a query
Well Jeff, for the meantime i solved the problem with the help of what Aaron mentioned. First I searched for all hotels matching the search-forms simple input-fields. Then when outputting the data I matched the submitted form against every hotels criteria-list with a loop. It works but i think it's some really 'dirty' and slow code (see below). I can't really work out how your idea will work - please excuse my stupidness :) So I'd be very happy about a more deeply explanation if you could afford the time. But nevertheless thanks. Patric - Original Message - From: "Jeff Beer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, January 14, 2001 6:40 PM Subject: RE: Comparing 2 Lists in a query Hi Patric, You might be better off by creating lookup tables for your criteria, and performing the search using a join, rather than storing the lists of matching criteria. Simply make a table with hotel_ID (whatever the primary key is) and the primary key of the criteria item. It might look like this: Hotel_ID Criteria_ID 1 21 1 14 1 13 1 3 2 12 2 21 2 10 and so on. The criteria table would look like: Criteria_ID CriteriaText 1 Swimming Pool 2 Family Friendly 3 24 Hour Room Service 5 Concierge 6 Business Center and so on. While making it far easier to retrieve values, it also makes maintenance and modification much simpler. Good luck! Jeff B. -Original Message- From: Patric Stumpe [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 13, 2001 10:01 AM To: CF-Talk Subject: Comparing 2 Lists in a query Hi folks, I actually got a problem I don't know how to solve. I have form-page where you can search for hotels. You can enter the city, the zip-code and enter some check some criterias the hotel should have like family-friendly, allow pets, swimming-pool and so on. These criterias are checkboxes with name 'merkale' and each criteria has it's own number as value. The hotels have also a list 'merkmale' in the table 'hotels'. My problem is how to check if all the list-values in 'form.merkmale' from the search-page are in 'hotels.merkmale'. I tried it with a loop in the query but i can't figure out the right syntax. The values from the search-page are properly posted to the result page. So I hope anyone can help. Thanks in advance... Patric Stumpe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Comparing 2 Lists in a query
Arrgh, forgot to paste my actual code... result.cfm cfquery name="ergebnis" datasource="develop" SELECT * FROM hotels WHERE 1 = 1 cfif form.name IS NOT '' AND name LIKE '%#form.name#%' /cfif cfif form.plz IS NOT '' AND plz LIKE '#form.plz#%' /cfif cfif form.ort IS NOT '' AND ort LIKE '%#form.ort#%' /cfif ORDER BY plz /cfquery CFSET temp_list = '' ---snip... table border="1" tr tdbName/b/td tdbOrt/b/td /tr cfoutput query="ergebnis" cfif ParameterExists(form.merkmale) CFLOOP INDEX="merkmal" LIST="#form.merkmale#" CFIF ListFindNoCase(#ergebnis.merkmale#, merkmal) IS "No" CFSET temp_list = ListAppend(temp_list, merkmal) /CFIF /CFLOOP /cfif cfif temp_list IS '' tr td#name#/td td#ort#/td /tr /cfif cfset temp_list = '' /cfoutput /table ...snip... /result.cfm - Original Message - From: "Jeff Beer" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Sunday, January 14, 2001 6:40 PM Subject: RE: Comparing 2 Lists in a query Hi Patric, You might be better off by creating lookup tables for your criteria, and performing the search using a join, rather than storing the lists of matching criteria. Simply make a table with hotel_ID (whatever the primary key is) and the primary key of the criteria item. It might look like this: Hotel_ID Criteria_ID 1 21 1 14 1 13 1 3 2 12 2 21 2 10 and so on. The criteria table would look like: Criteria_ID CriteriaText 1 Swimming Pool 2 Family Friendly 3 24 Hour Room Service 5 Concierge 6 Business Center and so on. While making it far easier to retrieve values, it also makes maintenance and modification much simpler. Good luck! Jeff B. -Original Message- From: Patric Stumpe [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 13, 2001 10:01 AM To: CF-Talk Subject: Comparing 2 Lists in a query Hi folks, I actually got a problem I don't know how to solve. I have form-page where you can search for hotels. You can enter the city, the zip-code and enter some check some criterias the hotel should have like family-friendly, allow pets, swimming-pool and so on. These criterias are checkboxes with name 'merkale' and each criteria has it's own number as value. The hotels have also a list 'merkmale' in the table 'hotels'. My problem is how to check if all the list-values in 'form.merkmale' from the search-page are in 'hotels.merkmale'. I tried it with a loop in the query but i can't figure out the right syntax. The values from the search-page are properly posted to the result page. So I hope anyone can help. Thanks in advance... Patric Stumpe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Comparing 2 Lists in a query
Hi folks, I actually got a problem I don't know how to solve. I have form-page where you can search for hotels. You can enter the city, the zip-code and enter some check some criterias the hotel should have like family-friendly, allow pets, swimming-pool and so on. These criterias are checkboxes with name 'merkale' and each criteria has it's own number as value. The hotels have also a list 'merkmale' in the table 'hotels'. My problem is how to check if all the list-values in 'form.merkmale' from the search-page are in 'hotels.merkmale'. I tried it with a loop in the query but i can't figure out the right syntax. The values from the search-page are properly posted to the result page. So I hope anyone can help. Thanks in advance... Patric Stumpe ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Inserting Updating data...?
Hello all you coders, i have the following problem: a customer shall make an entry to a database where the entered data gets to table A. This is surely simple and already works fine :). Now I try to update a record in another table B (where the customers infos are stored). There is a field containing a list of id's (foreign key?!) belonging to the entries he already entered. So how can I update the customers record (the field 'list_entries') in table B while inserting the entry he made to table A. I really don't know how to get the data to that list... many thanks in advance Patric Stumpe -- 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.
Second problem with my query
Hi all, after solving the problem with converting numeric fields to string fields (I actually didn't use the Str()-function but the Format()-function to avoid a leading space) I now wonder how to avoid that ColdFusion cuts the generated line (in the following Query the header_name) after 256 Characters. Is there any chance to convert the retrieved and generated line to a LONGCHAR already in SELECT-statement? cfquery name="quicksearch" datasource="ersatzteile" SELECT eintraege.id, eintraege.fzg_typ_id, eintraege.hersteller_id, eintraege.bereich_id, eintraege.datum, eintraege.eintragstext, eintraege.preis, 'a href="suche/hersteller.cfm?fzg_typ_id=' + Format(fzg_typ.fzg_typ_id) + '"' + fzg_typ.name + '/anbsp;nbsp;|nbsp;nbsp;a href="suche/teilebereich.cfm?fzg_typ_id=' + Format(fzg_typ.fzg_typ_id) + 'hersteller_id=' + Format(hersteller.hersteller_id) + '"' + hersteller.name + '/anbsp;nbsp;|nbsp;nbsp;a href="suche/ergebnis.cfm?fzg_typ_id=' + Format(fzg_typ.fzg_typ_id) + 'hersteller_id=' + Format(hersteller.hersteller_id) + 'bereich_id=' + Format(teilebereich.bereich_id) + '"' + teilebereich.name AS header_name FROM eintraege, fzg_typ, hersteller, teilebereich WHERE eintragstext LIKE '%#FORM.suchbegriff#%' AND fzg_typ.fzg_typ_id = eintraege.fzg_typ_id AND hersteller.hersteller_id = eintraege.hersteller_id AND teilebereich.bereich_id = eintraege.bereich_id ORDER BY fzg_typ.fzg_typ_id, hersteller.name, teilebereich.name, datum /cfquery TIA Patric -- 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: Another Query to Table
Well David, that's the way... :-) Thanks a lot. Patric - Original Message - From: "David Gassner" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 29, 2000 2:25 AM Subject: RE: Another Query to Table | Patric, you'll need to use the index array method of getting to query data. | Here's some code which does what you want, assuming a query named "q" and a | field called "fieldvalue": | | !--- If number of items isn't divisible by three, | add one row --- | cfset numRows = q.recordcount / 3 | cfif (numRows mod 3) | cfset numRows = int(numRows) + 1 | /cfif | | table cellpadding="5" cellspacing="0" | cfloop from=1 to="#numRows#" index="currentRow" | | !--- Start the row with alternating colors --- | cfoutput | tr bgcolor=#iif(currentRow mod 2, | de("silver"), | de("white"))# | /cfoutput | | cfloop from="1" to="3" index="cellNumber" | cfset dataIndex = (numRows * (cellNumber-1)) + currentRow | td | cfif dataIndex lte q.recordcount | cfoutput#dataindex#-#q.fieldvalue[dataIndex]#/cfoutput | /cfif | /td | /cfloop | /tr | | /cfloop | /table | | David Gassner | Vintage Business Applications -- 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.
Another Query to Table
Well, another problem. I read the thread about 'Query to Table' but it didn't fit my need for generating a table with three columns in the following format: 1 5 9 2 6 10 3 7 11 4 8 12 Then it should easily be possible to alter the row's bgcolor every second row. Thanks... Patric Stumpe -- 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: Another Query to Table
Hi Joe, thanks for your reply, but this ain't the way i wanted it to be displayed... the way you described is like 123 456 789 10 11 12 ... but i wanted it like 1 5 9 2 6 10 3 7 11 4 8 12 Hope this is possible...!?! Patric - Original Message - From: Joseph Eugene [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 28, 2000 8:15 PM Subject: Re: Another Query to Table Patric, I am not sure what you are trying to do? Do you want to put a database query results in the format described below?? If so, here is the code. cfquery Name="Get_Data" datasource="" Select *from your_table. /cfquery table width="400" align="center" border="1" tr cfoutput query="Get_data" td#Your_Column#/td cfif Get_Data.currentrow Mod 3 eq 0 /trtr /cfif /cfoutput /tr /table Hope this helps Joe -- 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.
Problem with a query
Hi folks, I have a problem with a query where i don't know how to group the retrieved records. There are four tables involved in this query (hope you can ignore the german declarations): 1. table: eintraege (the important one) - id (counter) - fzg_typ_id (integer) - hersteller_id (integer) - bereich_id (integer) - kunden_id (integer) (not involved in query) - datum (datetime) - eintragstext (memo) - preis (text) 2. table: fzg_typ - fzg_typ_id (counter) - name (text) 3. table: hersteller - hersteller_id (counter) - name (text) - fzg_typ_id (text) (not involved, just for storing a list) 4. table: teilebereich - bereich_id (counter) - name (text) - fzg_typ_id (text) (not involved, just for storing a list) Now I have the following query which perfectly gives me the records I need: cfquery name="quicksearch" datasource="ersatzteile" SELECTeintraege.id, eintraege.fzg_typ_id, eintraege.hersteller_id, eintraege.bereich_id, eintraege.datum, eintraege.eintragstext, eintraege.preis, fzg_typ.name AS f_name, hersteller.name AS h_name, teilebereich.name AS t_name FROM eintraege, fzg_typ, hersteller, teilebereich WHEREeintragstext LIKE '%#FORM.suchbegriff#%' AND fzg_typ.fzg_typ_id = eintraege.fzg_typ_id AND hersteller.hersteller_id = eintraege.hersteller_id AND teilebereich.bereich_id = eintraege.bereich_id ORDER BY fzg_typ.name, hersteller.name, teilebereich.name /cfquery My problem is that I don't really want the retrieved records to be ordered like stated in the ORDER BY-clause but to be grouped by these fields so that the output could look like this: {Heading} f_name1 / h_name3 / t_name9 {entry 1} {entry 2} {entry 3} {Heading} f_name1 / h_name3 / t_name11 {entry 1} {entry 2} {Heading} f_name2 / h_name1 / t_name4 {entry 1} {entry 2} {entry 3} {entry 4} ... ... ... could anyone please point me to the right direction. I searched the web and the Allaire docs now for almost a week and couldn't really find something that works. TIA Patric -- 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: Problem with a query
Well Stephen, if you were here I would kiss your feet. Worked almost as you described but I had to alter the expression for combining the name-fields in the query like this: fzg_typ.name + ' | ' + hersteller.name + ' | ' + teilebereich.name AS header_name I think the next I post my questions earlier to the list. A big "Thank You" goes out to you! Patric -- 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.