From volkan.ozcelik at gmail.com Mon Aug 15 01:42:41 2005 From: volkan.ozcelik at gmail.com (=?ISO-8859-9?Q?VOLKAN_=D6Z=C7EL=DDK?=) Date: Mon, 15 Aug 2005 09:42:41 +0300 Subject: [thelist] ReadOnly TextBox BackColor ?? In-Reply-To: <001501c5a02f$922e6bb0$6764a8c0@Papabear> References: <004701c59f97$db7652d0$6764a8c0@Papabear> <20050813002547.16515.qmail@web51103.mail.yahoo.com> <001501c5a02f$922e6bb0$6764a8c0@Papabear> Message-ID: You should give cssClass attribute, not class if I do not remember wrong: Cheers, Volkan. On 8/13/05, Casey wrote: > > > > The below works for me; > > > > HTH, > > Volkan. > > > > > > > > > > /> > > > Hmm. How about with this: > > textmode="multiline" columns="40" rows="5" runat="server" /> > > ?? > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From salim at vodatel.com Mon Aug 15 05:34:33 2005 From: salim at vodatel.com (S.F. Alim) Date: Mon, 15 Aug 2005 13:34:33 +0300 Subject: [thelist] DOM ol li listing issue, Please Help!!! Message-ID: <000001c5a184$ede6fb60$480310ac@localnet> Hi list, This is my first time posting my question, so here is my question. I?ve learn little bit of javascript and dom concept together. Following are my code ?. ? ? Create Element Practise Page #1 ? ? ? ?Click to Create Link ?
? the result I want to get is that array to list out when I click the link. I google a lot and found few example and I try to append them but to my sorrow I have reached my limits of thinking. I will appreciate if someone can help me with it. S.F.Alim Ps: beside that my weakess point in programming is array only. From codepo8 at gmail.com Mon Aug 15 06:01:09 2005 From: codepo8 at gmail.com (Christian Heilmann) Date: Mon, 15 Aug 2005 12:01:09 +0100 Subject: [thelist] DOM ol li listing issue, Please Help!!! In-Reply-To: <000001c5a184$ede6fb60$480310ac@localnet> References: <000001c5a184$ede6fb60$480310ac@localnet> Message-ID: <30bd6ffd05081504011580eb94@mail.gmail.com> You are going about this the completely wrong way. Don't make your sites dependent on JavaScript, especially not with non-existant protocols like "javascript:". A solution to your issue: Start with a server side fallback for the same functionality: create list (I will not do the PHP here...) then add a JavaScript to do it client side, for example: function makelists() { if(!document.getElementById || !document.createTextNode){return;} var listtrigger=document.getElementById('listcreate'); if(!listtrigger){return;} listtrigger.onclick=function() { var items=new Array('One','Two','Three','and so on'); var newol=document.createElement('ol'); var newli; for(var i=0;i Message-ID: <000401c5a19c$15c96f20$480310ac@localnet> Thanks you quick reply, First of all --> I have read your article "Unobtrusive JavaScript" its amazing [still there are points I don't get it but still its amazing], frankly speaking I hardly understand someone else code, but your way of explaining and getting to the point is fantastic. Actually I got this sort of coding from this site "www.pxl8.com" very neatly explained and to the point also. So I was also following the same pattern, maybe I am wrong [well I am wrong as you told me]. Coming back to my own question... tell me this what do u mean by * Don't make your sites dependent on JavaScript, * especially not with non-existent protocols like "javascript". I will test you script InshaAllah soon, and will get back to you soon. Cuz I have a lot of question about how to do good coding and about DOM. Thanks again, S. F. Alim -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Christian Heilmann Sent: Monday, August 15, 2005 2:01 PM To: thelist at lists.evolt.org Subject: Re: [thelist] DOM ol li listing issue, Please Help!!! You are going about this the completely wrong way. A solution to your issue: Start with a server side fallback for the same functionality: create list (I will not do the PHP here...) then add a JavaScript to do it client side, for example: function makelists() { if(!document.getElementById || !document.createTextNode){return;} var listtrigger=document.getElementById('listcreate'); if(!listtrigger){return;} listtrigger.onclick=function() { var items=new Array('One','Two','Three','and so on'); var newol=document.createElement('ol'); var newli; for(var i=0;i References: <004701c59f97$db7652d0$6764a8c0@Papabear> <20050813002547.16515.qmail@web51103.mail.yahoo.com> <001501c5a02f$922e6bb0$6764a8c0@Papabear> Message-ID: <9bff278605081506434ad2053c@mail.gmail.com> I believe it may be because the asp:textbox with the multiline attribute might be creating textarea element instead of the input element, which if that's the case, try changing Volkan's example to be: textarea.readonly hth. -- Cheers, Serdar Kilic http://weblog.kilic.net/ From codepo8 at gmail.com Mon Aug 15 09:00:27 2005 From: codepo8 at gmail.com (Christian Heilmann) Date: Mon, 15 Aug 2005 15:00:27 +0100 Subject: [thelist] DOM ol li listing issue, Please Help!!! In-Reply-To: <000401c5a19c$15c96f20$480310ac@localnet> References: <30bd6ffd05081504011580eb94@mail.gmail.com> <000401c5a19c$15c96f20$480310ac@localnet> Message-ID: <30bd6ffd05081507002f67a75b@mail.gmail.com> > Coming back to my own question... tell me this what do u mean by > * Don't make your sites dependent on JavaScript, Easy, without JavaScript, your list would never be reachable, and as JavaScript can be turned off, that is not a failsafe plan. > * especially not with non-existent protocols like "javascript". Links work with protocols: http, ftp, https and so on. href="javascript:" is a pseudo protocol, not a real one, and only works when JavaScript is available. However, the link appears even when it is not available, promising the visitors functionality that is not available. -- Chris Heilmann Blog: http://www.wait-till-i.com Writing: http://icant.co.uk/ Binaries: http://www.onlinetools.org/ From volkan.ozcelik at gmail.com Mon Aug 15 09:50:21 2005 From: volkan.ozcelik at gmail.com (=?ISO-8859-9?Q?VOLKAN_=D6Z=C7EL=DDK?=) Date: Mon, 15 Aug 2005 17:50:21 +0300 Subject: [thelist] ReadOnly TextBox BackColor ?? In-Reply-To: <9bff278605081506434ad2053c@mail.gmail.com> References: <004701c59f97$db7652d0$6764a8c0@Papabear> <20050813002547.16515.qmail@web51103.mail.yahoo.com> <001501c5a02f$922e6bb0$6764a8c0@Papabear> <9bff278605081506434ad2053c@mail.gmail.com> Message-ID: > I believe it may be because the asp:textbox with the multiline > attribute might be creating textarea element instead of the input > element, which if that's the case, try changing Volkan's example to > be: textarea.readonly That's true a multi-line asp:textbox is converted to an html textarea element as per the server output. input.readonly, textarea.readonly { background: whatever; } Cheers, Volkan. From blas2 at cox.net Mon Aug 15 01:12:20 2005 From: blas2 at cox.net (Blas J. Gallegos) Date: Sun, 14 Aug 2005 23:12:20 -0700 Subject: [thelist] ASP Session Not working. Please Help! Message-ID: <20050815061215.JGKT25443.fed1rmmtao07.cox.net@ibm> To all, I found a page with your email addresses on the web and thought I'd ask for help. I'm having an issue where ASP sessions on my website are working when I access the page on the server with the http://localhost/ address, but not when accessing from outside the server via the web. Any clues, tips, or reason why this would happen? It's simple code. I'm just initializing the session with a string and calling it from a different page. Sometimes it works from the outside, but I don't know what triggers that behavior. Here is example of the code and session mode. <%Session("example") = ("examplestring")%> <-- in one page And <%Response.Write(Session("example"))%> <-- on a different page Session mode I would appreciate any advice. Thank You! Blas Gallegos From JLIST at UNIONINTERACTIVE.COM Mon Aug 15 10:42:18 2005 From: JLIST at UNIONINTERACTIVE.COM (JLIST EMAIL) Date: Mon, 15 Aug 2005 11:42:18 -0400 Subject: [thelist] ASP Session Not working. Please Help! In-Reply-To: <20050815061215.JGKT25443.fed1rmmtao07.cox.net@ibm> Message-ID: <1124121097.14507@mx64a.mysite4now.com> Blas, Check that you have clicked the button named "Create" on the "Directory" tab of the Internet Services Manager (MMC) module. To get there: 1) Click Start 2) Programs 3) Administrative Tools 4) Internet Services Manager 5) tab name = "Directory" Then, about 3/4 down is a text box named "Application Name:". If its grayed out, then the button to the right of that text box will be named "Create". Click it. If its named "Remove" then try to click that once, and then when it is removed and the button is named "Create" once again, click it again. This has bit me before. There is also a good article to read here with tips and pointers concerning session variables not sticking: http://www.aspfaq.com/show.asp?id=2157 I hope that helps you, or someone else has a more accurate solution for you! -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Blas J. Gallegos Sent: Monday, August 15, 2005 2:12 AM To: CAtkins at patriothomes.com; thelist at lists.evolt.org; lonnie at lkraemer.com; catkins at patriothomes.com Subject: [thelist] ASP Session Not working. Please Help! To all, I found a page with your email addresses on the web and thought I'd ask for help. I'm having an issue where ASP sessions on my website are working when I access the page on the server with the http://localhost/ address, but not when accessing from outside the server via the web. Any clues, tips, or reason why this would happen? It's simple code. I'm just initializing the session with a string and calling it from a different page. Sometimes it works from the outside, but I don't know what triggers that behavior. Here is example of the code and session mode. <%Session("example") = ("examplestring")%> <-- in one page And <%Response.Write(Session("example"))%> <-- on a different page Session mode I would appreciate any advice. Thank You! Blas Gallegos -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From kjs at ratking.co.uk Mon Aug 15 13:13:19 2005 From: kjs at ratking.co.uk (Kevin Stevens) Date: Mon, 15 Aug 2005 19:13:19 +0100 Subject: [thelist] Site check IE Mac Message-ID: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> I am doing a site at the moment and, after checking it out on several different browsers, have found something odd. I recently had to re-code a site where the hyphens started appearing as question marks. To make sure this didn't happen again I used the ampersand alternative – instead. We have an old imac at work with IE and all the hyphens appeared on the screen as –. Not sure what version of IE it was, and Safari displays the contents correctly, so... 1. Why is this happening? 2. Could someone else check it out using IE on a mac for me please. 3. What can I do to prevent this? URL is http://www.ratking.co.uk/rrs/skills.htm TIA Kevin Stevens kjs at ratking.co.uk From stanson at gmail.com Tue Aug 16 15:27:06 2005 From: stanson at gmail.com (Theodore Serbinski) Date: Tue, 16 Aug 2005 16:27:06 -0400 Subject: [thelist] CSS: making content appear at the bottom of parent container Message-ID: hi guys! need some help, got a design here i'm working on: http://151.200.137.29/ now how can i attach that little fishy curvered image with that IOOS image to the bottom of it's parent div? i always want it to be on the bottom of the div even if the content is too short (how it is now) and if the content is much longer to have it expand with it? thanks! ted From Brian at hondaswap.com Tue Aug 16 15:57:50 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Tue, 16 Aug 2005 16:57:50 -0400 Subject: [thelist] MSSQL Cursor help Message-ID: <4302534E.5070204@hondaswap.com> Hey all, I'm pulling my hair out on this one. I'm trying to write a stored procedure to kill some records. The problem being, is that they are in multiple tables. I have a "jobs" table, in which, i create my cursor list from, and then, i try to perform the cycle through of select * from @thecurrent_table where @params. Basically, the jobs table is an index of all the tables in this particular database. For example, table jobs: job1 date job2 date table job1: recordid, etc table job2: recordid, etc The code works, but it doesn't seem to cycle. It always stops after the first job table. useless code omitted: ---------------------------------- declare DNCList cursor for SELECT job AS 'joblist' FROM jobs WHERE --etc OPEN DNCList FETCH NEXT FROM DNCList into @joblist while @@fetch_status = 0 begin set @query = 'SELECT * FROM ' + @joblist --etc end exec(@query) FETCH NEXT FROM DNCList into @joblist CLOSE DNCList DEALLOCATE DNCList ------------------------------- anyone see anything wrong? obviously, my vars are declared and things are passing in as supposed to. my problem is on the cursor loop. From vreeland at studioframework.com Tue Aug 16 21:23:18 2005 From: vreeland at studioframework.com (Robert Vreeland) Date: Tue, 16 Aug 2005 22:23:18 -0400 Subject: [thelist] SQL not performing all inserts Message-ID: Mystery solved, sort of. The client's machine had a non-US regional setting. Once we set it to US English it worked fine. It appears as if an internal Access date time stamp was causing the problem, but we are not sure. In any event it is working, thanks for the help. Robert Vreeland -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Robert Vreeland Sent: Friday, August 12, 2005 16:49 To: thelist at lists.evolt.org Subject: [thelist] SQL not performing all inserts Hello List, Hope some one will have an idea, so here goes. I wrote a windows app that migrates the access databases we use in our application to ms sql databases. We have run the updater on six different machines - to update ourselves and clients, with no problem. But on our most recent attempt - another client, only partial success. The application can connect and read / write from both the access databases and the ms sql database but only inserts a few record before stopping. I'm not getting any connection errors, and we have tried the updater locally with a copy of the clients db with no problems - everything migrates. We duplicated our ms sql server config options on the client machine - including the query and connection timeout params, with no apparent difference. Ultimately, I wouldn't even care if the updater failed as we can do a manual import of the data, a pain as there are over a hundred databases involved, but the problem seems to be extending to the application itself, which is relying on at least one database to store user variable for sharing between asp and asp.net and that write seems to be failing as well. So any suggestions on where I can look for settings that might prevent lots of inserts? It seems as if something is timing out or blocking the inserts after x number. Thanks in advance for any help Robert Vreeland -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From erik at erikheerlein.com Tue Aug 16 22:17:46 2005 From: erik at erikheerlein.com (Erik Heerlein) Date: Tue, 16 Aug 2005 23:17:46 -0400 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> References: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: <3a2eca8de9b3f683573bb985ad5f184c@erikheerlein.com> > 2. Could someone else check it out using IE on a mac for me please. Looks fine on Mac OS X in IE 5.2. Erik Heerlein erik at erikheerlein.com From mrees at itsagoodprice.com Wed Aug 17 04:29:57 2005 From: mrees at itsagoodprice.com (Mark Rees) Date: Wed, 17 Aug 2005 10:29:57 +0100 Subject: [thelist] LDAP, PHP and MS Active Directory Message-ID: <006f01c5a30e$3bcff040$4500010a@gammaglobal.com> Hello I am using PHP v5 to write an intranet. The site is hosted on a windows 2000 server running Apache. I want to incorporate some form of Windows authentication to allow or deny access to given resources based on usernames and group membership. I am trying to accomplish this using LDAP. I am able to connect and bind to our Active Directory server (also Windows 2000) from PHP, but when I want to perform a search, I need to know what the base record is. This is in the format o=my company, c=the country it is in. This is where the problem lies. How do I find out this information? Is there some facility in Active Directory that allows me to see what the actual name-values are for all the records (like sn=rees)? The line of code causing the problem is this: $ds is a bound connection to the LDAP server $sr=ldap_search($ds, "o=company name, c=uk", "sn=g*"); It returns "Operations error" Thanks in advance Mark www.itsagoodprice.com - top-brand electronics for less. From fffrancis at fstorr.demon.co.uk Wed Aug 17 09:11:19 2005 From: fffrancis at fstorr.demon.co.uk (fstorr) Date: Wed, 17 Aug 2005 15:11:19 +0100 Subject: [thelist] Regex apostrophe problem Message-ID: <841762C7-A6CA-43F5-A16A-728589CE811E@fstorr.demon.co.uk> Hi all I'm trying to write a regex that will change the case of text from all upper to title case so, from BOB O'NEIL to Bob O'Neil. I'm getting stuck where apostrophes come into play as the N after the apostrophe needs to be capitalised along with the preceding O. I've got this so far: Find: ([\w]{1})([\w]+) Replace: $1\L\$ But don't know how to deal with the apostrophes. Is it possible to do this, and if so, how? regards Francis From Brian at hondaswap.com Wed Aug 17 09:38:19 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Wed, 17 Aug 2005 10:38:19 -0400 Subject: [thelist] asp recordset loop Message-ID: <43034BDB.7010504@hondaswap.com> I sent a post last night about a cursor loop problem. I never got it, so i don't even know if it made it to the list or not. If you saw it, great. if not-- disregard. Turns out, it was working fine all along. it was my web-based asp interface that doesn't seem to work. Here goes... The SP when triggered manually in query analyzer, works fine. I get my multiple result sets via the cursor selecting from multiple specific tables. sp_MULTI_DNC 'ALL', 'company', 'ACME', NULL, NULL, NULL procedure - thejob - flow_type - company - first_name - last_name - phone_number when i call it in an asp loop, i don't get the desired results-- it stops after the first job, which is why yesterday it had me thinking that the cursor wasn't working properly. here's my asp: if theserver = "MBC2" OR theserver = "ALL" then server.ScriptTimeout = 3600 set cnn = server.CreateObject("ADODB.connection") set comm = Server.CreateObject ("ADODB.Command") with comm .CommandTimeout = 0 .ActiveConnection = connstr2 .CommandText = "sp_MULTI_DNC" .CommandType = adcmdstoredproc .parameters("@thejob").value = thejob .parameters("@flow_type").value = flow_type .parameters("@company").value = company .parameters("@first_name").value = first_name .parameters("@last_name").value = last_name .parameters("@phone_number").value = phone_number set rst = Server.CreateObject("ADODB.Recordset") set rst = .execute END WITH if not rst.eof then dim tableheaders tableheaders = "" dim tablebody tablebody = "" tableheaders = tableheaders & "" & vbcrlf for x = 0 to rst.Fields.count - 1 tableheaders = tableheaders & "" & vbcrlf next do until rst.eof tablebody = tablebody & "" & vbcrlf for x = 0 to rst.Fields.count - 1 tablebody = tablebody & "" & vbcrlf next tablebody = tablebody & "" & vbcrlf rst.MoveNext loop tablebody = tablebody & "
" & trim(rst.Fields(x).Name) & "
" & trim(rst.Fields(x).Value) & "
" & VbCrLf else tablebody = tablebody & "

no results

" end if end if ------------------------ and later in the body part-
<%= tableheaders %> <%= tablebody %>
the end result, will have a check box next to the record to select and modify/etc on the next page. anyone know why my loop stops? does the record set end after the first job is complete? From lists at frankmarion.com Wed Aug 17 13:31:18 2005 From: lists at frankmarion.com (Frank) Date: Wed, 17 Aug 2005 14:31:18 -0400 Subject: [thelist] CF: UDF in Application.cfm not accessible? Message-ID: <6.1.1.1.2.20050817143056.01eddab0@127.0.0.1> I've got some UDF's included in the Application.cfm file, but they don't seem to be acessible unless I inlcude them in the actual script I want to use. I'm using include.cfc . I understand why the paths are relative in this tag, but I don't understand why if I include it in Application.cfm that I get the error "variable INCLUDE is not defined" when I call it from an included script. Sounds like a scope thing to me. How can I go about including my UDF's only once, and have them acessible from all my scripts? Frank Marion lists at frankmarion.com Keep the signal high. From april at farstrider.org Wed Aug 17 16:13:58 2005 From: april at farstrider.org (April) Date: Wed, 17 Aug 2005 14:13:58 -0700 Subject: [thelist] Click tracking and google pagerank Message-ID: <4303A896.6070001@farstrider.org> I'd like to see some statistics about what links on my site are clicked on the most, the least, etc. I realize I can easily set this up by sending a location header from a click tracking script. The problem is, I *do* want the sites I link to to get pagerank credit from my links. It doesn't seem like a simple location header would do that (though I'm having a hard time finding anything saying yay or nay). Does anyone know anything about search engine friendly click tracking scripts? Searching isn't being very helpful. Thanks, April From simon at sitepoint.com Wed Aug 17 23:57:38 2005 From: simon at sitepoint.com (Simon Mackie) Date: Thu, 18 Aug 2005 14:57:38 +1000 Subject: [thelist] Looking for good monchrome royalty-free vector clipart/stock imagery Message-ID: <003a01c5a3b1$5b765df0$8845a8c0@Grooverider> I'm currently looking for a varied collection of royalty-free vector-based clipart that we can use in various designs. The images need to be monochrome, stylized and of single subjects (e.g butterfly, camera). I was wondering if anyone had any recommendations as to a good online resource (I've been looking but I can't find anywhere that seems to have what we're looking for) or alternatively a vendor of suitable CDs? Cheers, Simon Simon Mackie, Managing Editor, SitePoint www.sitepoint.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 8/17/2005 From simon at exsonvaldes.net Thu Aug 18 03:03:28 2005 From: simon at exsonvaldes.net (simonb.) Date: Thu, 18 Aug 2005 10:03:28 +0200 Subject: [thelist] Local mod_rewrite with EasyPhp Message-ID: <00cd01c5a3cb$518c1270$e25c210a@trinity> Hi (I'm new on the list, so hello everybody) I've been trying to use a local copy of a website i'm developping using EasyPhp (www.easyphp.org - Apache 1.3.27, php 4.3.3, MySQL 4.0.15). Unfortunatly, mod_rewrite doesn't seem to work (while it's working perfectly online). I'm starting to think that it's impossible to use mod_rewrite with EasyPhp, but i couldn't find anything about it online. Did anybody else have this problem ? Thanks in advance. Simon. From robert at pennyonthesidewalk.com Thu Aug 18 08:27:23 2005 From: robert at pennyonthesidewalk.com (Robert Gormley) Date: Thu, 18 Aug 2005 23:27:23 +1000 Subject: [thelist] PHP compilation Message-ID: <28fd2913998f2e408a73e9773279d7e2@pennyonthesidewalk.com> Hi all, Trying to compile php from source to try out lighttpd - except I cannot get it to generate php_mysql/mysqli.dll's... no configure/make errors, just no *dll files generated. CentOS 4.1... Any thoughts? Robert From chilijoe at gmail.com Thu Aug 18 10:23:03 2005 From: chilijoe at gmail.com (Joe Ngo) Date: Thu, 18 Aug 2005 23:23:03 +0800 Subject: [thelist] Execute external command in ASP In-Reply-To: References: Message-ID: <6a81c230050818082330643710@mail.gmail.com> On 7/26/05, Canfield, Joel wrote: > > is there a way to execute and external command-line program in classic > > ASP and capture its output? I'm looking for something similar to the > > system() command in PHP. > > I've used WSCRIPT.SHELL to automate command line ftp, among other > things. Here's a snippet of code, in case it's helpful: > > ---------------------------------------- > > Set oScript = Server.CreateObject("WSCRIPT.SHELL") > > '********************************************************** > ' create command string, map path to the ftp command file > ' created above, create temp file for logging > '********************************************************** > strCMD = "ftp.exe -s:" & Server.MapPath("vendor.ftp") > strLogFile = "C:\Inetpub\wwwroot\it\transmissions\logs\vendor" & > datDataDate & ".log" > > '********************************************************** > ' run the command, output to the temp file, then read it > ' > '********************************************************** > Call oScript.Run("cmd.exe /c " & strCMD & " > " & strLogFile, 0, True) > Set oFile = objFSO.OpenTextFile (strLogFile, 1, False, 0) > > ---------------------------------------- > > joel > I've tried the above suggestion and I'm getting Permission Denied error. Basically I want to execute a python script and capture the output. My strCMD looks like this: cmd.exe /c {path_to_python_exe} {python_script} {parms} > {output_file} This gives back a Permission Denied error. If I change it to: {path_to_python_exe} {python_script} {parms} > {output_file} then there's no error, but the output file is also not written. I'm not sure if python was actually executed. However, I'm almost sure I have write access to the output folder since I use the same ASP script to upload a file to that folder. Since I'm aiming at capturing the python output, I had better luck with the WshScriptExec object. I tried copying the code in the following page: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wslrfstdoutproperty.asp With the following result: Set oShell = CreateObject("WScript.Shell") Set oExec = WshShell.Exec({path_to_python_exe} {python_script} {parms}) Do While True If Not oExec.StdOut.AtEndOfStream Then Response.Write(oExec.StdOut.Read(1)) Else Exit Do End If Loop This seems to work fine, but if you compare it to the original sample code, I had to remove the WScript.Sleep line because it doesn't seem to be valid in the context of ASP. I think the sleep is necessary to make it more efficient. Is there an alternative to WScript.Sleep for ASP pages? Thanks Joe From fortune_elkins at summithq.com Thu Aug 18 10:25:08 2005 From: fortune_elkins at summithq.com (Fortune Elkins) Date: Thu, 18 Aug 2005 11:25:08 -0400 Subject: [thelist] Best book on creating a taxonomy? Message-ID: Hiya! My management has decided to buy plumtree portal for our new intranet. This is all good for me! But now I need to learn more about how to create a good facetted taxonomy. What is the best book to buy on this? Is the "content management bible" from wiley still the best? Please advise. I know all about browsers, but now I have to become more of a librarian! Tia, f ------------------------------------------------------------------------------------------------ The views and opinions expressed in this email message are the sender's own, and do not necessarily represent the views and opinions of Summit Systems Inc. This message has been checked for viruses but the receiver should not depend upon this and should perform their own virus check. This message may contain confidential and/or privileged information and is intended for the named recipient(s) only. If you are not a named recipient, do not use, copy, transmit or otherwise disclose the contents of this message. Please inform the sender promptly of your receipt of this message. From pieter at roosensdesign.com Mon Aug 15 13:28:11 2005 From: pieter at roosensdesign.com (Pieter Roosens) Date: Mon, 15 Aug 2005 20:28:11 +0200 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> References: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: At least nr. 2: IE 5.2.3 on Mac looks ok. OSX Tiger. Pieter ----------------------------------------- http://www.roosensdesign.com Op 15-aug-05, om 20:13 heeft Kevin Stevens het volgende geschreven: > I am doing a site at the moment and, after checking it out on > several different browsers, have found something odd. I recently > had to re-code a site where the hyphens started appearing as > question marks. To make sure this didn't happen again I used the > ampersand alternative – instead. We have an old imac at work > with IE and all the hyphens appeared on the screen as –. Not > sure what version of IE it was, and Safari displays the contents > correctly, so... > > 1. Why is this happening? > 2. Could someone else check it out using IE on a mac for me please. > 3. What can I do to prevent this? > > URL is http://www.ratking.co.uk/rrs/skills.htm > > TIA > > Kevin Stevens > kjs at ratking.co.uk From rich at richpoints.com Mon Aug 15 13:53:57 2005 From: rich at richpoints.com (Rich Points) Date: Mon, 15 Aug 2005 12:53:57 -0600 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> References: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: <4300E4C5.3080405@richpoints.com> Kevin Stevens wrote: > I am doing a site at the moment and, after checking it out on several > different browsers, have found something odd. I recently had to > re-code a site where the hyphens started appearing as question marks. > To make sure this didn't happen again I used the ampersand alternative > – instead. We have an old imac at work with IE and all the > hyphens appeared on the screen as –. Not sure what version of IE > it was, and Safari displays the contents correctly, so... > > 1. Why is this happening? > 2. Could someone else check it out using IE on a mac for me please. > 3. What can I do to prevent this? Upgrade to Safari or FireFox, IE for Mac is a dead browser, don't waste your time coding for it. It's used by less than 2% of web surfers and that number is falling. You can hide your style sheets from IE 5x and other old browsers using @import syntax. Good Luck Rich > > URL is http://www.ratking.co.uk/rrs/skills.htm > > TIA > > Kevin Stevens > kjs at ratking.co.uk From evolt at kasimir-k.fi Mon Aug 15 14:55:47 2005 From: evolt at kasimir-k.fi (Kasimir K) Date: Mon, 15 Aug 2005 19:55:47 +0000 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> References: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: <4300F343.50907@kasimir-k.fi> Kevin Stevens scribeva in 2005-08-15 18:13: > site where the hyphens started appearing as question marks. To make sure > this didn't happen again I used the ampersand alternative – instead. > 1. Why is this happening? Especially older browsers' support for character entities ("the ampersand alternative") leaves a lot to hope for. > 3. What can I do to prevent this? You could start by reading Jukka Korpela's article "Dashes and hyphens": http://www.cs.tut.fi/~jkorpela/dashes.html .k From aspnet at thecrookstons.com Mon Aug 15 15:46:29 2005 From: aspnet at thecrookstons.com (Casey) Date: Mon, 15 Aug 2005 15:46:29 -0500 Subject: [thelist] ReadOnly TextBox BackColor ?? References: <004701c59f97$db7652d0$6764a8c0@Papabear> <20050813002547.16515.qmail@web51103.mail.yahoo.com> <001501c5a02f$922e6bb0$6764a8c0@Papabear> <9bff278605081506434ad2053c@mail.gmail.com> Message-ID: <004801c5a1da$6b111030$6464a8c0@Papabear> Okay! That works! For whatever fubar silly reason, it won't let me change the bgcolor to "white" or "#ffffff". If I try, it over-rides it and sets it to the ugly grey. But, I can change it to ALMOST white, "#fefefe" and that works just fine. Weird. Thanks for the help! From: "VOLKAN ?Z?ELIK" To: Sent: Monday, August 15, 2005 9:50 AM Subject: Re: [thelist] ReadOnly TextBox BackColor ?? > > I believe it may be because the asp:textbox with the multiline > > attribute might be creating textarea element instead of the input > > element, which if that's the case, try changing Volkan's example to > > be: textarea.readonly > > > That's true a multi-line asp:textbox is converted to an html textarea > element as per the server output. > > input.readonly, textarea.readonly { > background: whatever; > } > > Cheers, > Volkan. > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! From aspnet at thecrookstons.com Mon Aug 15 17:16:06 2005 From: aspnet at thecrookstons.com (Casey) Date: Mon, 15 Aug 2005 17:16:06 -0500 Subject: [thelist] DataGrids: Standard vs Webmatrix Message-ID: <005001c5a1e6$ee7b3890$6464a8c0@Papabear> I'm noticing that datagrids build in WebMatrix have their own namespaces which are imported with the <%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI"... declaration. In a standard datagrid (not build in WebMatrix) you can discover the value of the ButtonColumn the user has clicked as follows: Sub Show_Details(a As Object, e as DataGridCommandEventArgs) Dim getDoc as Integer = gridDocs.DataKeys(CInt(E.Item.ItemIndex)) But, when the datagrid was build in WebMatrix, this same line returns an error: 'DataKeys' is not a member of 'Microsoft.Matrix.Framework.Web.UI.SqlDataSourceControl'. Any idea what the correct WebMatrix syntax would be? TIA Casey From caseyc at internetopus.com Mon Aug 15 19:02:45 2005 From: caseyc at internetopus.com (Casey Crookston) Date: Mon, 15 Aug 2005 19:02:45 -0500 Subject: [thelist] WebMatrix Datagrid only loads onPageLoad Message-ID: <007301c5a1f5$d4e34210$6464a8c0@Papabear> Been beating my head against the wall for hours on this one... starting to get a lump on my forehead. I created a datagrid with Web Matrix... I was so very pleased with how fast and easy it was to do! Then, I tried to make a few modifications to the page on which my handy little datagrid lives, and it stopped working. :-( The grid grabs a list of doctors from a database and spits it onto the page. Cool enough. But, the client wants to be able to select only doctors who practice in one state. So, I add a dropdown list of all fifty states. I put the dropdown list in one panel. I put the datagrid in a second panel. On page load, panel_1 is visible and panel_2 is hidden. The user selects a state. Panel_1 stays visible (in case they want to select another state again later). Panel_2 also becomes visible and shows the datagrid of docs in the selected state. Problem: No matter how I try and work it, that bloody datagrid will not display. (I even tried asking it real nice like.) BUT, if I roll back and remove all panels and shove the datagrid back on the original page load, it works. AND, if I create my own datagrid w/o Matirx, everything works just as it should. I can choose a state, and BAMB! Out comes the grid with docs only from that state. I can choose another state, and HEY! I see the docs from that state. All day long. So, you are of course asking, "What's the issue? Just use your own datagrid and scrap the one from Matrix." Well, yes. But, the really cool thing about the Matrix grid is that it makes sorting and paging so very very very very easy. I've looked into making sorting and paging work on my own grid, and I got scared. So what gives? Why won't that blasted Matrix DataGrid work? I EVEN turned AutoDataBind to OFF and did the bind manually. Still, no love. I've not yet tried a candle light dinner with champaign, but that's next. If someone out there is feeling generous with their time, I even attached text versions of the two docs. (2 much code to paste). Docs2.txt is the webmatrix version. doc2.txt is mine. Any advice? TIA! -------------- next part -------------- An embedded and charset-unspecified text was scrubbed... Name: doctors2.txt URL: From aspnet at thecrookstons.com Mon Aug 15 19:35:58 2005 From: aspnet at thecrookstons.com (Casey) Date: Mon, 15 Aug 2005 19:35:58 -0500 Subject: [thelist] Re: WebMatrix Datagrid only loads onPageLoad Message-ID: <008101c5a1fa$785ec5a0$6464a8c0@Papabear> Maybe this is the simple version of my question: How do you force a web matrix datagrid to do a manual databind? > Been beating my head against the wall for hours on this one... starting to > get a lump on my forehead. > > I created a datagrid with Web Matrix... I was so very pleased with how fast > and easy it was to do! Then, I tried to make a few modifications to the > page on which my handy little datagrid lives, and it stopped working. :-( > > The grid grabs a list of doctors from a database and spits it onto the page. > Cool enough. But, the client wants to be able to select only doctors who > practice in one state. > > So, I add a dropdown list of all fifty states. I put the dropdown list in > one panel. I put the datagrid in a second panel. On page load, panel_1 is > visible and panel_2 is hidden. The user selects a state. Panel_1 stays > visible (in case they want to select another state again later). Panel_2 > also becomes visible and shows the datagrid of docs in the selected state. > > Problem: No matter how I try and work it, that bloody datagrid will not > display. (I even tried asking it real nice like.) BUT, if I roll back and > remove all panels and shove the datagrid back on the original page load, it > works. > > AND, if I create my own datagrid w/o Matirx, everything works just as it > should. I can choose a state, and BAMB! Out comes the grid with docs only > from that state. I can choose another state, and HEY! I see the docs from > that state. All day long. > > So, you are of course asking, "What's the issue? Just use your own datagrid > and scrap the one from Matrix." Well, yes. But, the really cool thing > about the Matrix grid is that it makes sorting and paging so very very very > very easy. I've looked into making sorting and paging work on my own grid, > and I got scared. > > So what gives? Why won't that blasted Matrix DataGrid work? I EVEN turned > AutoDataBind to OFF and did the bind manually. Still, no love. I've not > yet tried a candle light dinner with champaign, but that's next. > > If someone out there is feeling generous with their time, I even attached > text versions of the two docs. (2 much code to paste). Docs2.txt is the > webmatrix version. doc2.txt is mine. > > Any advice? > > TIA! > From Ken at adOpenStatic.com Mon Aug 15 20:04:34 2005 From: Ken at adOpenStatic.com (Ken Schaefer) Date: Tue, 16 Aug 2005 11:04:34 +1000 Subject: [thelist] ASP Session Not working. Please Help! Message-ID: <160489103479AB4892187638EE7D1E6914BE0E@kjserver1.kjhome.local> In addition to JList's post, the other thing to look at is cookies. Using your configuration, the sessionID is transmitted between the server and client using a cookie. You need to ensure that the client is receiving this cookie, and that the client is returning the cookie to the server. If you have software on the client that blocks cookies (either incoming, or returning them), then your session state will not be maintained (ASP.NET will allocate a new session when the 2nd request is made to the server). Cheers Ken : -----Original Message----- : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Blas J. Gallegos : Sent: Monday, 15 August 2005 4:12 PM : To: CAtkins at patriothomes.com; thelist at lists.evolt.org; : lonnie at lkraemer.com; catkins at patriothomes.com : Subject: [thelist] ASP Session Not working. Please Help! : : To all, : : : : I found a page with your email addresses on the web and thought I'd : ask : for help. I'm having an issue where ASP sessions on my website are : working : when I access the page on the server with the http://localhost/ address, : but not when accessing from outside the server via the web. Any clues, : tips, or reason why this would happen? : : : : It's simple code. I'm just initializing the session with a string and : calling it from a different page. Sometimes it works from the outside, : but : I don't know what triggers that behavior. Here is example of the code and : session mode. : : : : <%Session("example") = ("examplestring")%> <-- in one page : : : : And : : : : <%Response.Write(Session("example"))%> <-- on a different page : : : : : : Session mode : : : : : : : : I would appreciate any advice. Thank You! : : : : Blas Gallegos From ian at zstudio.co.uk Tue Aug 16 05:26:22 2005 From: ian at zstudio.co.uk (Ian Anderson) Date: Tue, 16 Aug 2005 11:26:22 +0100 Subject: [thelist] Tip: whitespace in included PHP causes header() calls to fail Message-ID: <4301BF4E.2030707@zstudio.co.uk> Have just had a horrible morning tracking this down, so I thought I'd share it in case others hit the same thing. In PHP, calls to header( "Location: whatever.php" ) were failing silently whenever an include file was used to validate the user's session data. I thought it was something I was doing with cookies or session_start() in my included file, but no... Turned out there was a space *after* the closing "?> " in the included file, which was getting written to the browser as unintentional output at the start of the HTML. Of course, calls affecting HTTP header will not work if output has already been written to the browser. Hope this helps someone Cheers Ian From lists at frankmarion.com Tue Aug 16 10:47:25 2005 From: lists at frankmarion.com (Frank) Date: Tue, 16 Aug 2005 11:47:25 -0400 Subject: [thelist] CF: UDF in Application.cfm not accessible? Message-ID: <6.1.1.1.2.20050816113605.01eddab0@127.0.0.1> I've got some UDF's included in the Application.cfm file, but they don't seem to be acessible unless I inlcude them in the actual script I want to use. I'm using include.cfc . I understand why the paths are relative in this tag, but I don't understand why if I include it in Application.cfm that I get the error "variable INCLUDE is not defined" when I call it from an included script. Sounds like a scope thing to me. How can I go about including my UDF's only once, and have them acessible from all my scripts? Frank Marion lists at frankmarion.com Keep the signal high. From syoung at unitec.ac.nz Wed Aug 17 20:32:29 2005 From: syoung at unitec.ac.nz (Stuart Young) Date: Thu, 18 Aug 2005 13:32:29 +1200 Subject: [thelist] RSS Audio Feed Message-ID: having just researched this for our new podcast feed: http://blog.greens.org.nz/index.php/category/the-game/audioblog/ and help page: http://blog.greens.org.nz/index.php/help-how-to/audioblog-rss-feed/ it seems that an audio feed is just a normal RSS feed but with the audio linked to in an tag. Only RSS2 and Atom support them? So you just need to tweak your CMS that is making RSS files, to make them with tags too. Or you need to start making RSS files. There are plenty of ASP scripts for generating RSS files. I found it was very easy for us to start "podcasting" - the blog software we use, Wordpress, does it automatically for you. If there is a link to the file in the body of the blog post, then it automatically adds the tags to the feed. cheers -- Dr Stuart Young, +64 (0)9-815 4321 x 8656 +64 021 183 2846 (mob) Lecturer, School of Computing and Information Technology, Unitec New Zealand, Auckland, New Zealand http://tinyurl.com/4956o (the official URL for my staffpage is too long and complex) http://www.pixelandgrain.co.nz/ Web development, graphic design and photography >>> Hershel Robinson 10/08/2005 22:55:22 >>> I have a client with a large ASP-based custom-CMS-powered site that now has audio files. He wants to set up an RSS feed for those audio files. The site is presently in ASP although there is a consideration (in deliberations right now) to rebuild the site in PHP, so either one is a solution at present. I also have seen Windows apps that appear (I believe) to create such a feed. I know nothing about RSS, so any suggestions are welcome. Thank you, Hershel -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From Mark.Joslyn at SolimarSystems.com Thu Aug 18 11:14:44 2005 From: Mark.Joslyn at SolimarSystems.com (Mark Joslyn) Date: Thu, 18 Aug 2005 09:14:44 -0700 Subject: [thelist] image galleries Message-ID: <001c01c5a40f$f20e3810$870aa8c0@Corp.Solimarsystems.com> Does anyone know of any good tutorials on how to set up an image gallery - preferably in PHP? Pagination, comments, small thumbnail, large thumbnail - all the bells and whistles. Thanks, markJ From michaelproy at gmail.com Thu Aug 18 14:35:57 2005 From: michaelproy at gmail.com (Mike Roy) Date: Thu, 18 Aug 2005 15:35:57 -0400 Subject: [thelist] Site Redesign: Ruby On Rails or PHP from ASP Message-ID: Hi - I'm a perennial novice developer with high-level experience using PHP, ASP and ColdFusion (in descending order of proficiency) I'll soon be taking over a site for redesign that is currently ASP with SQL Server. I want to start over with Apache/PHP, but I'm getting more and more enamored with Ruby On Rails. I'm especially interested in the labor-saving features as I will be a one-man-show for this site. The Db is most likely going to stay MS SQL Server, no matter what I put out front. I don't know the traffic statistics yet, but it's an academic program and so probably doesn't have quite the performance standards of an e-commerce site. Does anyone have any experience that would cause them to recommend PHP over Ruby/Rails or vice versa? Or even to stay with ASP? Thanks, - Mike Roy From philip at turmel.org Thu Aug 18 15:02:05 2005 From: philip at turmel.org (Phil Turmel) Date: Thu, 18 Aug 2005 16:02:05 -0400 Subject: [thelist] MSSQL Cursor help In-Reply-To: <4302534E.5070204@hondaswap.com> References: <4302534E.5070204@hondaswap.com> Message-ID: <4304E93D.7020109@turmel.org> Brian Cummiskey wrote: [snip] > The code works, but it doesn't seem to cycle. It always stops after the > first job table. > > useless code omitted: > ---------------------------------- > > declare DNCList cursor for > SELECT job AS 'joblist' > FROM jobs > WHERE --etc > > OPEN DNCList > FETCH NEXT FROM DNCList into @joblist > while @@fetch_status = 0 > begin > set @query = 'SELECT * FROM ' + @joblist --etc > end > > exec(@query) > > FETCH NEXT FROM DNCList into @joblist > CLOSE DNCList > DEALLOCATE DNCList > > ------------------------------- > > anyone see anything wrong? > > obviously, my vars are declared and things are passing in as supposed > to. my problem is on the cursor loop. > Brian, Try placing the exec and 2nd fetch *inside* the loop like so: while @@fetch_status = 0 begin set @query = 'SELECT * FROM ' + @joblist --etc exec(@query) FETCH NEXT FROM DNCList into @joblist end HTH, Phil From Brian at hondaswap.com Thu Aug 18 15:08:44 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Thu, 18 Aug 2005 16:08:44 -0400 Subject: [thelist] asp recordset loop In-Reply-To: <43034BDB.7010504@hondaswap.com> References: <43034BDB.7010504@hondaswap.com> Message-ID: <4304EACC.2080707@hondaswap.com> wow- 2 days later... anyway, ignore this. this has been solved for a while now. Brian Cummiskey wrote: > I sent a post last night about a cursor loop problem. I never got it, > so i don't even know if it made it to the list or not. If you saw it, > great. if not-- disregard. > > Turns out, it was working fine all along. it was my web-based asp > interface that doesn't seem to work. Here goes... > > > The SP when triggered manually in query analyzer, works fine. I get my > multiple result sets via the cursor selecting from multiple specific > tables. > > sp_MULTI_DNC 'ALL', 'company', 'ACME', NULL, NULL, NULL > procedure - thejob - flow_type - company - first_name - last_name - > phone_number > > > when i call it in an asp loop, i don't get the desired results-- it > stops after the first job, which is why yesterday it had me thinking > that the cursor wasn't working properly. > > > here's my asp: > > > if theserver = "MBC2" OR theserver = "ALL" then > > server.ScriptTimeout = 3600 > set cnn = server.CreateObject("ADODB.connection") > set comm = Server.CreateObject ("ADODB.Command") > with comm > .CommandTimeout = 0 > .ActiveConnection = connstr2 > .CommandText = "sp_MULTI_DNC" > .CommandType = adcmdstoredproc > .parameters("@thejob").value = thejob > .parameters("@flow_type").value = flow_type > .parameters("@company").value = company > .parameters("@first_name").value = first_name > .parameters("@last_name").value = last_name > .parameters("@phone_number").value = phone_number > > > set rst = Server.CreateObject("ADODB.Recordset") > set rst = .execute > END WITH > > > if not rst.eof then > > dim tableheaders > tableheaders = "" > > dim tablebody > tablebody = "" > > tableheaders = tableheaders & " style=""border-collapse: collapse;"" border=""1"" cellspacing=""0"" > cellpadding=""2"">" & vbcrlf > for x = 0 to rst.Fields.count - 1 > tableheaders = tableheaders & "" & vbcrlf > next > > do until rst.eof > > tablebody = tablebody & "" & vbcrlf > > for x = 0 to rst.Fields.count - 1 > tablebody = tablebody & "" & vbcrlf > next > > tablebody = tablebody & "" & vbcrlf > rst.MoveNext > loop > > tablebody = tablebody & "
" & > trim(rst.Fields(x).Name) & "
" & > trim(rst.Fields(x).Value) & "
" & VbCrLf > > else > tablebody = tablebody & "

no results

" > end if > end if > > > > ------------------------ > and later in the body part- > >
>
> <%= tableheaders %> > <%= tablebody %> > >
>
> > > the end result, will have a check box next to the record to select and > modify/etc on the next page. > > anyone know why my loop stops? > > does the record set end after the first job is complete? > From volkan.ozcelik at gmail.com Thu Aug 18 15:10:10 2005 From: volkan.ozcelik at gmail.com (=?ISO-8859-9?Q?VOLKAN_=D6Z=C7EL=DDK?=) Date: Thu, 18 Aug 2005 23:10:10 +0300 Subject: [thelist] CSS: making content appear at the bottom of parent container In-Reply-To: References: Message-ID: Hi Theodore, - You may give your content a fixed height and overflow auto (which will display scrollbars for lenghty content, it that's OK for you) - You may also dynamically adjust your container heights via js/DHTML. However you should make sure your content is readable & accessible for non-js browsers. Other than these, nothing comes to my mind. HTH, Volkan. On 8/16/05, Theodore Serbinski wrote: > hi guys! > > need some help, got a design here i'm working on: > > http://151.200.137.29/ > > now how can i attach that little fishy curvered image with that IOOS > image to the bottom of it's parent div? i always want it to be on the > bottom of the div even if the content is too short (how it is now) > and if the content is much longer to have it expand with it? > > thanks! > > ted > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From mattias at inreach.com Thu Aug 18 15:11:09 2005 From: mattias at inreach.com (Mattias Thorslund) Date: Thu, 18 Aug 2005 13:11:09 -0700 Subject: [thelist] MSSQL Cursor help In-Reply-To: <4302534E.5070204@hondaswap.com> References: <4302534E.5070204@hondaswap.com> Message-ID: <4304EB5D.5040704@inreach.com> Looks like your loop is wrong. I think the "end" should be after the second "FETCH NEXT". It's been a while since I did MSSQL stored procedures. But I recall that people tend to use cursors WAY too often (they don't have great performance), and they can on 99% of the times be re-written into a set-based format. I admit that this one might be in the 1%, though, and for a "maintenance" function, the performance probably isn't important to warrant putting more time into it than to make it work. /Mattias Brian Cummiskey wrote: > Hey all, I'm pulling my hair out on this one. > > I'm trying to write a stored procedure to kill some records. The > problem being, is that they are in multiple tables. I have a "jobs" > table, in which, i create my cursor list from, and then, i try to > perform the cycle through of select * from @thecurrent_table where > @params. > > Basically, the jobs table is an index of all the tables in this > particular database. > > For example, > > table jobs: > > job1 date > job2 date > > > table job1: > recordid, etc > > table job2: > recordid, etc > > The code works, but it doesn't seem to cycle. It always stops after > the first job table. > > useless code omitted: > ---------------------------------- > > declare DNCList cursor for > SELECT job AS 'joblist' > FROM jobs > WHERE --etc > > OPEN DNCList > FETCH NEXT FROM DNCList into @joblist > while @@fetch_status = 0 > begin > set @query = 'SELECT * FROM ' + @joblist --etc > end > > exec(@query) > > FETCH NEXT FROM DNCList into @joblist > CLOSE DNCList > DEALLOCATE DNCList > > ------------------------------- > > anyone see anything wrong? > > obviously, my vars are declared and things are passing in as supposed > to. my problem is on the cursor loop. > -- More views at http://www.thorslund.us From aspnet at thecrookstons.com Thu Aug 18 15:17:17 2005 From: aspnet at thecrookstons.com (Casey) Date: Thu, 18 Aug 2005 15:17:17 -0500 Subject: [thelist] no emails from The List for two+ days Message-ID: <00dc01c5a431$d4abaa60$6464a8c0@Papabear> I stopped receiving emails from the list for over two days, then about ten minutes ago they started rolling in again. ??? Did anyone else experience this? Did I perhaps make someone mad with two many newbie questions? Problem with my email server? Very curious. From joshua at waetech.com Thu Aug 18 15:19:33 2005 From: joshua at waetech.com (Joshua Olson) Date: Thu, 18 Aug 2005 16:19:33 -0400 Subject: [thelist] MSSQL Cursor help In-Reply-To: <4302534E.5070204@hondaswap.com> Message-ID: > -----Original Message----- > From: Brian Cummiskey > Sent: Tuesday, August 16, 2005 4:58 PM > > Hey all, I'm pulling my hair out on this one. > declare DNCList cursor for > SELECT job AS 'joblist' > FROM jobs > WHERE --etc > > OPEN DNCList > FETCH NEXT FROM DNCList into @joblist > while @@fetch_status = 0 > begin > set @query = 'SELECT * FROM ' + @joblist --etc > end > > exec(@query) > > FETCH NEXT FROM DNCList into @joblist > CLOSE DNCList > DEALLOCATE DNCList Try: declare DNCList cursor for SELECT job AS 'joblist' FROM jobs WHERE --etc OPEN DNCList FETCH NEXT FROM DNCList into @joblist while @@fetch_status = 0 begin set @query = 'SELECT * FROM ' + @joblist --etc exec(@query) FETCH NEXT FROM DNCList into @joblist end CLOSE DNCList DEALLOCATE DNCList <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Fax: 413.812.4864 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From dab.hand at xtra.co.nz Mon Aug 15 14:18:27 2005 From: dab.hand at xtra.co.nz (David Bailey) Date: Tue, 16 Aug 2005 07:18:27 +1200 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: Hi Kevin, > From: "Kevin Stevens" > I used the ampersand alternative – instead. > We have an old imac at work with IE and all the hyphens appeared on the > screen as –. Not sure what version of IE it was, and Safari displays > the contents correctly, so... I can answer the second question you ask with certainty on the browser that I have on my mac. > 1. Why is this happening? I don't know, except that earlier browsers on Mac appear to not support the alternative! > 2. Could someone else check it out using IE on a mac for me please. I've just checked with IE 5 on Mac and it's fine; the hyphens appear as a dash. I'm not sure that there would be too many Macs out there with IE less than 5 now. > 3. What can I do to prevent this? It depends on whether the very few Macs out there with earlier versions of Mac matter to your client, I guess. Someone with more experience will have to answer the first and third questions you have asked. David From morrison.ben at gmail.com Tue Aug 16 04:25:08 2005 From: morrison.ben at gmail.com (ben morrison) Date: Tue, 16 Aug 2005 10:25:08 +0100 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> References: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: <6073aef905081602251e4f8171@mail.gmail.com> > > 1. Why is this happening? > 2. Could someone else check it out using IE on a mac for me please. > 3. What can I do to prevent this? > > URL is http://www.ratking.co.uk/rrs/skills.htm > Looks fine on Mac IE 5.2.3 - which was the last release for mac. ben From volkan.ozcelik at gmail.com Thu Aug 18 15:39:03 2005 From: volkan.ozcelik at gmail.com (=?ISO-8859-9?Q?VOLKAN_=D6Z=C7EL=DDK?=) Date: Thu, 18 Aug 2005 23:39:03 +0300 Subject: [thelist] Regex apostrophe problem In-Reply-To: <841762C7-A6CA-43F5-A16A-728589CE811E@fstorr.demon.co.uk> References: <841762C7-A6CA-43F5-A16A-728589CE811E@fstorr.demon.co.uk> Message-ID: Replaced + with * ([\w]{1})([\w]*) Tested with VOLKAN OZCELIK VOLKAN O ' ZCELIK (added space just to make apos stand out) VOLKAN OZ ' CELIK It matches as expected. HTH, Volkan. On 8/17/05, fstorr wrote: > Hi all > > I'm trying to write a regex that will change the case of text from > all upper to title case so, from BOB O'NEIL to Bob O'Neil. I'm > getting stuck where apostrophes come into play as the N after the > apostrophe needs to be capitalised along with the preceding O. I've > got this so far: > > Find: ([\w]{1})([\w]+) > Replace: $1\L\$ > > But don't know how to deal with the apostrophes. Is it possible to > do this, and if so, how? > > regards > > Francis > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From vkaryl at allvantage.com Thu Aug 18 15:42:22 2005 From: vkaryl at allvantage.com (Vicki Frei) Date: Thu, 18 Aug 2005 14:42:22 -0600 Subject: [thelist] Looking for good monchrome royalty-free vector clipart/stock imagery Message-ID: <4304F2AE.3060101@allvantage.com> Try doverpublications.com - lots of stuff, all epochs, royalty free, much of it on cd.... V On 8/17/2005 10:57:38 PM, Simon Mackie (simon at sitepoint.com) wrote: > I'm currently looking for a varied collection of royalty-free > vector-based clipart that we can use in various designs. The images need > to be monochrome, stylized and of single subjects (e.g butterfly, > camera). I was wondering if anyone had any recommendations as to a good > online resource (I've > been looking but I can't find anywhere that seems > to have what we're > looking for) or alternatively a vendor of suitable > CDs? > > Cheers, > > Simon > > Simon Mackie, > Managing Editor, SitePoint > www.sitepoint.com > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: > 8/17/2005 > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! From apwebdesign at yahoo.com Thu Aug 18 15:52:00 2005 From: apwebdesign at yahoo.com (Anthony) Date: Thu, 18 Aug 2005 13:52:00 -0700 (PDT) Subject: [thelist] Regex apostrophe problem In-Reply-To: <841762C7-A6CA-43F5-A16A-728589CE811E@fstorr.demon.co.uk> Message-ID: <20050818205201.62572.qmail@web51110.mail.yahoo.com> What language? Perl has functions for uppercase and lowercase: uc($text) and a lc($text) function, which should already ignore special characters. If you must use regexp: $lower =~ s/(\w)(\w+)/\u$1\L$2/sig; --- fstorr wrote: > Hi all > > I'm trying to write a regex that will change the > case of text from > all upper to title case so, from BOB O'NEIL to Bob > O'Neil. I'm > getting stuck where apostrophes come into play as > the N after the > apostrophe needs to be capitalised along with the > preceding O. I've > got this so far: > > Find: ([\w]{1})([\w]+) > Replace: $1\L\$ > > But don't know how to deal with the apostrophes. Is > it possible to > do this, and if so, how? > > regards > > Francis > > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony ph: (408) 656-2473 blog: http://www.chovy.com ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs From apwebdesign at yahoo.com Thu Aug 18 15:53:46 2005 From: apwebdesign at yahoo.com (Anthony) Date: Thu, 18 Aug 2005 13:53:46 -0700 (PDT) Subject: [thelist] Click tracking and google pagerank In-Reply-To: <4303A896.6070001@farstrider.org> Message-ID: <20050818205346.85778.qmail@web51109.mail.yahoo.com> mod_rewrite: "/file.html?id=001" becomes "file-id001.html" --- April wrote: > I'd like to see some statistics about what links on > my site are clicked > on the most, the least, etc. I realize I can easily > set this up by > sending a location header from a click tracking > script. > > The problem is, I *do* want the sites I link to to > get pagerank credit > from my links. It doesn't seem like a simple > location header would do > that (though I'm having a hard time finding anything > saying yay or nay). > Does anyone know anything about search engine > friendly click tracking > scripts? Searching isn't being very helpful. > > Thanks, > April > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony ph: (408) 656-2473 blog: http://www.chovy.com ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs From nan at heritageconcord.org Thu Aug 18 15:54:59 2005 From: nan at heritageconcord.org (Nan) Date: Thu, 18 Aug 2005 16:54:59 -0400 Subject: [thelist] Looking for good monchrome royalty-free vector clipart/stock imagery In-Reply-To: <003a01c5a3b1$5b765df0$8845a8c0@Grooverider> Message-ID: Hi Simon, Microsoft PhotoDraw is a wonderful resource for what you are looking for, in their clip art CD, one of the CDs in the 3 DC set. However, I recently found out Microsoft discontinued this program, which is really a shame because it has some really great tools that were easy to use if you are used to the Microsoft environment. Also, the graphics saved for the web are always really crisp and clean looking. I looked and found it on eBay. Even though the latest version was Microsoft PhotoDraw 2000 V2, it works on XP, if you are Windows based. If you are not, NEVER MIND! Nan -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Simon Mackie Sent: Thursday, August 18, 2005 12:58 AM To: thelist at lists.evolt.org Subject: [thelist] Looking for good monchrome royalty-free vector clipart/stock imagery I'm currently looking for a varied collection of royalty-free vector-based clipart that we can use in various designs. The images need to be monochrome, stylized and of single subjects (e.g butterfly, camera). I was wondering if anyone had any recommendations as to a good online resource (I've been looking but I can't find anywhere that seems to have what we're looking for) or alternatively a vendor of suitable CDs? Cheers, Simon Simon Mackie, Managing Editor, SitePoint www.sitepoint.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 8/17/2005 -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From jono at charlestonwebsolutions.com Tue Aug 16 08:18:27 2005 From: jono at charlestonwebsolutions.com (Jono Young) Date: Tue, 16 Aug 2005 09:18:27 -0400 Subject: [thelist] Site check IE Mac In-Reply-To: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> References: <006a01c5a1c5$05fb9450$f78b8756@john4bfcd93394> Message-ID: Appears to be fine in IE Mac 5.2.3 on Tiger (OS 10.4.2). On Aug 15, 2005, at 2:13 PM, Kevin Stevens wrote: We have an old imac at work with IE and all the hyphens appeared on the screen as –. Not sure what version of IE it was, and Safari displays the contents correctly, so... 1. Why is this happening? 2. Could someone else check it out using IE on a mac for me please. 3. What can I do to prevent this? URL is http://www.ratking.co.uk/rrs/skills.htm From jeff at webdesigns1.com Thu Aug 18 16:28:14 2005 From: jeff at webdesigns1.com (Jeff Oien) Date: Thu, 18 Aug 2005 16:28:14 -0500 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? Message-ID: <4304FD6E.50108@webdesigns1.com> I'm looking for a simple, free CMS that isn't blog style-something for "regular" web sites where the client can update content but I can easily modify templates and add features. I'd like it to be XHTML 1.0 compliant and not use tables for layout. Any suggestions? I've installed Etomite which is pretty nice but found the table based layout a little cumbersome. Thanks. Jeff From aspnet at thecrookstons.com Mon Aug 15 17:29:43 2005 From: aspnet at thecrookstons.com (Casey) Date: Mon, 15 Aug 2005 17:29:43 -0500 Subject: [thelist] Re: DataGrids: Standard vs Webmatrix Message-ID: <005901c5a1e8$d5513200$6464a8c0@Papabear> Never mind - figured it out. ----- Original Message ----- > I'm noticing that datagrids build in WebMatrix have their own namespaces > which are imported with the <%@ Register TagPrefix="wmx" > Namespace="Microsoft.Matrix.Framework.Web.UI"... declaration. > > In a standard datagrid (not build in WebMatrix) you can discover the value > of the ButtonColumn the user has clicked as follows: > > Sub Show_Details(a As Object, e as DataGridCommandEventArgs) > Dim getDoc as Integer = gridDocs.DataKeys(CInt(E.Item.ItemIndex)) > > But, when the datagrid was build in WebMatrix, this same line returns an > error: > > 'DataKeys' is not a member of > 'Microsoft.Matrix.Framework.Web.UI.SqlDataSourceControl'. > > Any idea what the correct WebMatrix syntax would be? > > TIA > > Casey > From apwebdesign at yahoo.com Thu Aug 18 17:39:59 2005 From: apwebdesign at yahoo.com (Anthony) Date: Thu, 18 Aug 2005 15:39:59 -0700 (PDT) Subject: [thelist] Local mod_rewrite with EasyPhp In-Reply-To: <00cd01c5a3cb$518c1270$e25c210a@trinity> Message-ID: <20050818223959.19230.qmail@web51107.mail.yahoo.com> Check the mod_rewrite error log: in vhosts.conf: ... RewriteLog "/var/log/apache2/rewrite_log" RewriteLogLevel 9 --- "simonb." wrote: > Hi > > (I'm new on the list, so hello everybody) > > I've been trying to use a local copy of a website > i'm developping using > EasyPhp (www.easyphp.org - Apache 1.3.27, php 4.3.3, > MySQL 4.0.15). > Unfortunatly, mod_rewrite doesn't seem to work > (while it's working perfectly > online). I'm starting to think that it's impossible > to use mod_rewrite with > EasyPhp, but i couldn't find anything about it > online. Did anybody else have > this problem ? > Thanks in advance. > > Simon. > > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From apwebdesign at yahoo.com Thu Aug 18 17:52:27 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Thu, 18 Aug 2005 15:52:27 -0700 (PDT) Subject: [thelist] image galleries In-Reply-To: <001c01c5a40f$f20e3810$870aa8c0@Corp.Solimarsystems.com> Message-ID: <20050818225227.95969.qmail@web51110.mail.yahoo.com> gallery is nice. http://gallery.sf.net --- Mark Joslyn wrote: > Does anyone know of any good tutorials on how to set > up an image gallery - > preferably in PHP? > > Pagination, comments, small thumbnail, large > thumbnail - all the bells and > whistles. > > Thanks, > > markJ > > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From skilic at gmail.com Thu Aug 18 18:07:21 2005 From: skilic at gmail.com (=?ISO-8859-9?Q?Serdar_K=FDl=FD=E7?=) Date: Fri, 19 Aug 2005 09:07:21 +1000 Subject: [thelist] Best book on creating a taxonomy? In-Reply-To: References: Message-ID: <9bff278605081816074a442add@mail.gmail.com> Hi, You will be hard pressed to find a book on Plumtree, your best shot at finding resources is to create a Plumtree account at http://portal.plumtree.com. From there you will need to gain access to the Developer Center where you will find all sorts of documentation and such. Hope this helps. Serdar On 19/08/05, Fortune Elkins wrote: > > > Hiya! > > My management has decided to buy plumtree portal for our new intranet. > This is all good for me! But now I need to learn more about how to > create a good facetted taxonomy. What is the best book to buy on this? > Is the "content management bible" from wiley still the best? > > Please advise. I know all about browsers, but now I have to become more > of a librarian! > > Tia, > > f > > ------------------------------------------------------------------------------------------------ > > The views and opinions expressed in this email message are > the sender's own, and do not necessarily represent the views > and opinions of Summit Systems Inc. This message has been > checked for viruses but the receiver should not depend upon > this and should perform their own virus check. This message > may contain confidential and/or privileged information and is > intended for the named recipient(s) only. If you are not a named > recipient, do not use, copy, transmit or otherwise disclose the > contents of this message. Please inform the sender promptly > of your receipt of this message. > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > -- Cheers, Serdar Kilic http://weblog.kilic.net/ From april at farstrider.org Thu Aug 18 18:46:35 2005 From: april at farstrider.org (April) Date: Thu, 18 Aug 2005 16:46:35 -0700 Subject: [thelist] Click tracking and google pagerank In-Reply-To: <20050818205346.85778.qmail@web51109.mail.yahoo.com> References: <20050818205346.85778.qmail@web51109.mail.yahoo.com> Message-ID: <43051DDB.5080506@farstrider.org> All of the links I want to track are external links to third party websites. Am I missing how this is applicable? Anthony wrote: > mod_rewrite: > > "/file.html?id=001" becomes "file-id001.html" > > > > > --- April wrote: > > >>I'd like to see some statistics about what links on >>my site are clicked >>on the most, the least, etc. I realize I can easily >>set this up by >>sending a location header from a click tracking >>script. >> >>The problem is, I *do* want the sites I link to to >>get pagerank credit >>from my links. It doesn't seem like a simple >>location header would do >>that (though I'm having a hard time finding anything >>saying yay or nay). >> Does anyone know anything about search engine >>friendly click tracking >>scripts? Searching isn't being very helpful. >> >>Thanks, >>April >>-- >> >>* * Please support the community that supports you. >>* * >>http://evolt.org/help_support_evolt/ >> >>For unsubscribe and other options, including the Tip >>Harvester >>and archives of thelist go to: >>http://lists.evolt.org >>Workers of the Web, evolt ! >> > > > > Anthony > ph: (408) 656-2473 > blog: http://www.chovy.com > > > > ____________________________________________________ > Start your day with Yahoo! - make it your home page > http://www.yahoo.com/r/hs > From apwebdesign at yahoo.com Thu Aug 18 18:55:59 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Thu, 18 Aug 2005 16:55:59 -0700 (PDT) Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <4304FD6E.50108@webdesigns1.com> Message-ID: <20050818235559.38184.qmail@web51107.mail.yahoo.com> www.plone.org <--- good, but lots of dependencies. --- Jeff Oien wrote: > I'm looking for a simple, free CMS that isn't blog > style-something > for "regular" web sites where the client can update > content but I can > easily modify templates and add features. I'd like > it to be > XHTML 1.0 compliant and not use tables for layout. > Any suggestions? > > I've installed Etomite which is pretty nice but > found the table > based layout a little cumbersome. > > Thanks. > Jeff > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From Paul.Bennett at wcc.govt.nz Thu Aug 18 19:00:16 2005 From: Paul.Bennett at wcc.govt.nz (Paul Bennett) Date: Fri, 19 Aug 2005 12:00:16 +1200 Subject: [thelist] Tip: whitespace in included PHP causes header() calls tofail Message-ID: Error Reporting is your friend. Turning error reporting right up on test servers or during development will literally save you hours of time. Lower levels of error reporting won't report undeclared variables, call's to Header() when there's white space already outputted to the browser and a hundred other errors which can stop things working properly. If you don't have access to php.ini (i.e.: on a shared server) you can turn error reporting up at runtime via: ini_set('error_reporting', E_ALL); -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Ian Anderson Sent: Tuesday, August 16, 2005 10:26 PM To: thelist at lists.evolt.org Subject: [thelist] Tip: whitespace in included PHP causes header() calls tofail Have just had a horrible morning tracking this down, so I thought I'd share it in case others hit the same thing. In PHP, calls to header( "Location: whatever.php" ) were failing silently whenever an include file was used to validate the user's session data. I thought it was something I was doing with cookies or session_start() in my included file, but no... Turned out there was a space *after* the closing "?> " in the included file, which was getting written to the browser as unintentional output at the start of the HTML. Of course, calls affecting HTTP header will not work if output has already been written to the browser. Hope this helps someone Cheers Ian -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From dean.mah at gmail.com Thu Aug 18 19:25:11 2005 From: dean.mah at gmail.com (Dean Mah) Date: Thu, 18 Aug 2005 18:25:11 -0600 Subject: [thelist] no emails from The List for two+ days In-Reply-To: <00dc01c5a431$d4abaa60$6464a8c0@Papabear> References: <00dc01c5a431$d4abaa60$6464a8c0@Papabear> Message-ID: Yes, thelist was broken. It's fixed for now. Hopefully now that I am able to access the server again now, I'll also be able to fix the tip harvester within the next day or two. Dean On 8/18/05, Casey wrote: > I stopped receiving emails from the list for over two days, then about ten > minutes ago they started rolling in again. > > ??? > > Did anyone else experience this? Did I perhaps make someone mad with two > many newbie questions? Problem with my email server? Very curious. From evolt at roselli.org Thu Aug 18 19:33:32 2005 From: evolt at roselli.org (aardvark) Date: Thu, 18 Aug 2005 20:33:32 -0400 Subject: [thelist] no emails from The List for two+ days In-Reply-To: <00dc01c5a431$d4abaa60$6464a8c0@Papabear> Message-ID: <4304F09C.11018.7A9BB1B@localhost> there was a server reboot... thelist software didn't come up with the rest of the machine... it claims to have called in sick, but we didn't get any messages... On 18 Aug 2005 at 15:17, Casey wrote: > I stopped receiving emails from the list for over two days, then about ten > minutes ago they started rolling in again. From mwarden at gmail.com Thu Aug 18 19:37:33 2005 From: mwarden at gmail.com (Matt Warden) Date: Thu, 18 Aug 2005 20:37:33 -0400 Subject: [thelist] Tip: whitespace in included PHP causes header() calls to fail In-Reply-To: <4301BF4E.2030707@zstudio.co.uk> References: <4301BF4E.2030707@zstudio.co.uk> Message-ID: <430529CD.40904@gmail.com> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ian Anderson wrote: > In PHP, calls to header( "Location: whatever.php" ) were failing > silently whenever an include file was used to validate the user's > session data. > > I thought it was something I was doing with cookies or session_start() > in my included file, but no... > > Turned out there was a space *after* the closing "?> " in the included > file, which was getting written to the browser as unintentional output > at the start of the HTML. Of course, calls affecting HTTP header will > not work if output has already been written to the browser. This is why you should never use the closing ?> in include files (it's optional). - -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFDBSnNAQ0d4HGyPE8RAnI0AJwOC0opkUPqIAoNHJ712MUV73IqCgCfSwMv P+tdBjZvyYvmhLh65eUpOxg= =aKR+ -----END PGP SIGNATURE----- From jeff at webdesigns1.com Thu Aug 18 19:48:44 2005 From: jeff at webdesigns1.com (Jeff Oien) Date: Thu, 18 Aug 2005 19:48:44 -0500 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <20050818235559.38184.qmail@web51107.mail.yahoo.com> References: <20050818235559.38184.qmail@web51107.mail.yahoo.com> Message-ID: <43052C6C.7060706@webdesigns1.com> Ack, I forgot to add I would like it to be PHP based. But I will certainly look at Plone. Jeff Anthony Ettinger wrote: > www.plone.org <--- good, but lots of dependencies. > > --- Jeff Oien wrote: >>I'm looking for a simple, free CMS that isn't blog >>style-something >>for "regular" web sites where the client can update >>content but I can >>easily modify templates and add features. I'd like >>it to be >>XHTML 1.0 compliant and not use tables for layout. >>Any suggestions? >> >>I've installed Etomite which is pretty nice but >>found the table >>based layout a little cumbersome. >> >>Thanks. >>Jeff From discuss at alphanumeric.cz Thu Aug 18 19:52:10 2005 From: discuss at alphanumeric.cz (Jan Brasna) Date: Fri, 19 Aug 2005 02:52:10 +0200 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <4304FD6E.50108@webdesigns1.com> References: <4304FD6E.50108@webdesigns1.com> Message-ID: <43052D3A.1010000@alphanumeric.cz> You can use Drupal; we often use also hacked WordPress. LucidCMS is a good lite CMS too. -- Jan Brasna aka JohnyB :: www.alphanumeric.cz | www.janbrasna.com From Paul.Bennett at wcc.govt.nz Thu Aug 18 19:54:56 2005 From: Paul.Bennett at wcc.govt.nz (Paul Bennett) Date: Fri, 19 Aug 2005 12:54:56 +1200 Subject: [thelist] no emails from The List for two+ days Message-ID: 2 days, that's grounds for a note from the doctor if you ask me -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of aardvark Sent: Friday, August 19, 2005 12:34 PM To: thelist at lists.evolt.org Subject: Re: [thelist] no emails from The List for two+ days there was a server reboot... thelist software didn't come up with the rest of the machine... it claims to have called in sick, but we didn't get any messages... On 18 Aug 2005 at 15:17, Casey wrote: > I stopped receiving emails from the list for over two days, then about > ten minutes ago they started rolling in again. -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From morgan at morgankelsey.com Thu Aug 18 19:57:16 2005 From: morgan at morgankelsey.com (M Kelsey) Date: Thu, 18 Aug 2005 20:57:16 -0400 Subject: [thelist] CF: UDF in Application.cfm not accessible? References: <6.1.1.1.2.20050816113605.01eddab0@127.0.0.1> Message-ID: <006f01c5a458$f1a46f90$8001a8c0@BOPPADEEDEE> Frank, > How can I go about including my UDF's only once, and have them acessible > from all my scripts? > here's what I do in Application.cfm: I'm not really a cfc kind of guy, but that works fine for my UDFs. I just throw them in my "app_functions" folder and they're good to go. Morgan Kelsey http://www.morgankelsey.com From dwain.alford at gmail.com Thu Aug 18 20:21:42 2005 From: dwain.alford at gmail.com (dwain.alford at gmail.com) Date: Thu, 18 Aug 2005 20:21:42 -0500 Subject: [thelist] no emails from The List for two+ days In-Reply-To: References: Message-ID: <43053426.6030305@gmail.com> Paul Bennett wrote: > 2 days, that's grounds for a note from the doctor if you ask me > > -----Original Message----- > From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of aardvark > Sent: Friday, August 19, 2005 12:34 PM > To: thelist at lists.evolt.org > Subject: Re: [thelist] no emails from The List for two+ days > > there was a server reboot... thelist software didn't come up with the rest of the machine... > > it claims to have called in sick, but we didn't get any messages... > be sure to check you hr rules to be sure you don't violate any rights first. From kris at kriskhaira.com Thu Aug 18 21:57:37 2005 From: kris at kriskhaira.com (Kris Khaira) Date: Fri, 19 Aug 2005 10:57:37 +0800 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <43052D3A.1010000@alphanumeric.cz> References: <4304FD6E.50108@webdesigns1.com> <43052D3A.1010000@alphanumeric.cz> Message-ID: <26eb3559fd7c4bb65ed4b408ea4f533e@kriskhaira.com> You're looking for Textpattern - http://www.textpattern.com You can use it to edit content, layout and styles. And it has multiple privilege levels. On Aug 19, 2005, at 5:28 AM, Jeff Oien wrote: > I'm looking for a simple, free CMS that isn't blog style-something > for "regular" web sites where the client can update content but I can > easily modify templates and add features. I'd like it to be > XHTML 1.0 compliant and not use tables for layout. Any suggestions? From Brian at hondaswap.com Thu Aug 18 22:54:53 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Thu, 18 Aug 2005 23:54:53 -0400 Subject: [thelist] MSSQL Cursor help Message-ID: <4305580D.70007@hondaswap.com> Joshua Olson wrote: >Try: > >declare DNCList cursor for > SELECT job AS 'joblist' > FROM jobs > WHERE --etc > >OPEN DNCList > FETCH NEXT FROM DNCList into @joblist > while @@fetch_status = 0 > begin > set @query = 'SELECT * FROM ' + @joblist --etc > exec(@query) > FETCH NEXT FROM DNCList into @joblist > end > > CLOSE DNCList >DEALLOCATE DNCList > > Josh, et all - thanks for the responses. Fortunately, this was solved a couple days ago... must've got clogged in the pipes. What I ended up doing was creating a union statement, to union all the inner selects, and then finally exec() the created querystring. The orig. code worked fine in query analizer, but since the produced out put was a series of selects (like writing: select * from table1 select * from table2 and firing them off at the same time-- you get the two seperate results sets, thus, the recordset was only pulling the first select. Unioned them all together, then fired it off, and things seem to work as desired. But thanks. perhaps moving the exec() inside is better than unioning them together. I'll have to try this tomorrow at the office. From markgroen at gmail.com Thu Aug 18 23:06:56 2005 From: markgroen at gmail.com (Mark Groen) Date: Thu, 18 Aug 2005 21:06:56 -0700 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? References: <4304FD6E.50108@webdesigns1.com><43052D3A.1010000@alphanumeric.cz> <26eb3559fd7c4bb65ed4b408ea4f533e@kriskhaira.com> Message-ID: <001a01c5a473$719c7340$6400a8c0@vn.shawcable.net> ----- Original Message ----- From: "Kris Khaira" < To: Sent: Thursday, August 18, 2005 7:57 PM Subject: Re: [thelist] CMS - Non-Blog-Like XHTML CSS? > You're looking for Textpattern - http://www.textpattern.com > > You can use it to edit content, layout and styles. And it has multiple > privilege levels. > > > On Aug 19, 2005, at 5:28 AM, Jeff Oien wrote: > > > I'm looking for a simple, free CMS that isn't blog style-something > > for "regular" web sites where the client can update content but I can > > easily modify templates and add features. I'd like it to be > > XHTML 1.0 compliant and not use tables for layout. Any suggestions? My latest fave is websitebaker.com, imho one of the easiest admin interfaces for the end user/client, easy-peasy templating, privilege levels, news blocks, can be made to match almost any existing web site. Fairly easy to get valid XHTML 1.0 Transitional code using a slightly customized wysiwyg FCKeditor: http://validator.w3.org/check?verbose=1&uri=http%3A//www.bowenisland.org/ Just last week I moved the site above from a TP back-end to WB, it's about the fifth install I've done of this appy, the clients love it. I *am* a Textpattern fan still, but the Baker is a nice middle ground between complexity for the end user and flexibility for the developer, imho of course :-) cheers, Mark From apwebdesign at yahoo.com Fri Aug 19 00:05:09 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Thu, 18 Aug 2005 22:05:09 -0700 (PDT) Subject: [thelist] Click tracking and google pagerank In-Reply-To: <43051DDB.5080506@farstrider.org> Message-ID: <20050819050509.92936.qmail@web51106.mail.yahoo.com> I was assuming you are using a redirect script on your server. Something like: Campaign ID = 001 for http://www.advertiser.com /redirect.php?cid=001 if that's the case, you could mod_rewrite it as a pretty url (which would help your pagerank) into something like: /redirect-cid001.html Maybe I'm not understanding what you're trying to accomplish. www.organicseo.org has some SEO tips --- April wrote: > All of the links I want to track are external links > to third party > websites. Am I missing how this is applicable? > > Anthony wrote: > > mod_rewrite: > > > > "/file.html?id=001" becomes "file-id001.html" > > > > > > > > > > --- April wrote: > > > > > >>I'd like to see some statistics about what links > on > >>my site are clicked > >>on the most, the least, etc. I realize I can > easily > >>set this up by > >>sending a location header from a click tracking > >>script. > >> > >>The problem is, I *do* want the sites I link to to > >>get pagerank credit > >>from my links. It doesn't seem like a simple > >>location header would do > >>that (though I'm having a hard time finding > anything > >>saying yay or nay). > >> Does anyone know anything about search engine > >>friendly click tracking > >>scripts? Searching isn't being very helpful. > >> > >>Thanks, > >>April > >>-- > >> > >>* * Please support the community that supports > you. > >>* * > >>http://evolt.org/help_support_evolt/ > >> > >>For unsubscribe and other options, including the > Tip > >>Harvester > >>and archives of thelist go to: > >>http://lists.evolt.org > >>Workers of the Web, evolt ! > >> > > > > > > > > Anthony > > ph: (408) 656-2473 > > blog: http://www.chovy.com > > > > > > > > > ____________________________________________________ > > Start your day with Yahoo! - make it your home > page > > http://www.yahoo.com/r/hs > > > > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From apwebdesign at yahoo.com Fri Aug 19 00:06:02 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Thu, 18 Aug 2005 22:06:02 -0700 (PDT) Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <43052C6C.7060706@webdesigns1.com> Message-ID: <20050819050602.39362.qmail@web51101.mail.yahoo.com> plone is php based. --- Jeff Oien wrote: > Ack, I forgot to add I would like it to be PHP > based. But > I will certainly look at Plone. > Jeff > > Anthony Ettinger wrote: > > www.plone.org <--- good, but lots of dependencies. > > > > --- Jeff Oien wrote: > >>I'm looking for a simple, free CMS that isn't blog > >>style-something > >>for "regular" web sites where the client can > update > >>content but I can > >>easily modify templates and add features. I'd like > >>it to be > >>XHTML 1.0 compliant and not use tables for layout. > >>Any suggestions? > >> > >>I've installed Etomite which is pretty nice but > >>found the table > >>based layout a little cumbersome. > >> > >>Thanks. > >>Jeff > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From mrees at itsagoodprice.com Fri Aug 19 03:08:08 2005 From: mrees at itsagoodprice.com (Mark Rees) Date: Fri, 19 Aug 2005 09:08:08 +0100 Subject: [thelist] asp recordset loop References: <43034BDB.7010504@hondaswap.com> <4304EACC.2080707@hondaswap.com> Message-ID: <003501c5a495$2287e1a0$4500010a@gammaglobal.com> ----- Original Message ----- From: "Brian Cummiskey" To: Sent: Thursday, August 18, 2005 9:08 PM Subject: Re: [thelist] asp recordset loop > wow- 2 days later... > > anyway, ignore this. this has been solved for a while now. How? Did you discover the nextrecordset method of the recordset? > Brian Cummiskey wrote: > > I sent a post last night about a cursor loop problem. I never got it, > > so i don't even know if it made it to the list or not. If you saw it, > > great. if not-- disregard. > > > > Turns out, it was working fine all along. it was my web-based asp > > interface that doesn't seem to work. Here goes... > > > > > > The SP when triggered manually in query analyzer, works fine. I get my > > multiple result sets via the cursor selecting from multiple specific > > tables. > > > > sp_MULTI_DNC 'ALL', 'company', 'ACME', NULL, NULL, NULL > > procedure - thejob - flow_type - company - first_name - last_name - > > phone_number > > > > > > when i call it in an asp loop, i don't get the desired results-- it > > stops after the first job, which is why yesterday it had me thinking > > that the cursor wasn't working properly. > > > > > > here's my asp: > > > > > > if theserver = "MBC2" OR theserver = "ALL" then > > > > server.ScriptTimeout = 3600 > > set cnn = server.CreateObject("ADODB.connection") > > set comm = Server.CreateObject ("ADODB.Command") > > with comm > > .CommandTimeout = 0 > > .ActiveConnection = connstr2 > > .CommandText = "sp_MULTI_DNC" > > .CommandType = adcmdstoredproc > > .parameters("@thejob").value = thejob > > .parameters("@flow_type").value = flow_type > > .parameters("@company").value = company > > .parameters("@first_name").value = first_name > > .parameters("@last_name").value = last_name > > .parameters("@phone_number").value = phone_number > > > > > > set rst = Server.CreateObject("ADODB.Recordset") > > set rst = .execute > > END WITH > > > > > > if not rst.eof then > > > > dim tableheaders > > tableheaders = "" > > > > dim tablebody > > tablebody = "" > > > > tableheaders = tableheaders & " > style=""border-collapse: collapse;"" border=""1"" cellspacing=""0"" > > cellpadding=""2"">" & vbcrlf > > for x = 0 to rst.Fields.count - 1 > > tableheaders = tableheaders & "" & vbcrlf > > next > > > > do until rst.eof > > > > tablebody = tablebody & "" & vbcrlf > > > > for x = 0 to rst.Fields.count - 1 > > tablebody = tablebody & "" & vbcrlf > > next > > > > tablebody = tablebody & "" & vbcrlf > > rst.MoveNext > > loop > > > > tablebody = tablebody & "
" & > > trim(rst.Fields(x).Name) & "
" & > > trim(rst.Fields(x).Value) & "
" & VbCrLf > > > > else > > tablebody = tablebody & "

no results

" > > end if > > end if > > > > > > > > ------------------------ > > and later in the body part- > > > >
> >
> > <%= tableheaders %> > > <%= tablebody %> > > > >
> >
> > > > > > the end result, will have a check box next to the record to select and > > modify/etc on the next page. > > > > anyone know why my loop stops? > > > > does the record set end after the first job is complete? > > > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! > From fffrancis at fstorr.demon.co.uk Fri Aug 19 03:17:48 2005 From: fffrancis at fstorr.demon.co.uk (fstorr) Date: Fri, 19 Aug 2005 09:17:48 +0100 Subject: [thelist] Regex apostrophe problem In-Reply-To: <20050818205201.62572.qmail@web51110.mail.yahoo.com> References: <20050818205201.62572.qmail@web51110.mail.yahoo.com> Message-ID: On 18 Aug, 2005, at 21:52, Anthony wrote: > What language? > > Perl has functions for uppercase and lowercase: > > uc($text) and a lc($text) function, which should > already ignore special characters. > > If you must use regexp: > > $lower =~ s/(\w)(\w+)/\u$1\L$2/sig; > Hi I'm using the Grep utilities within TextWrangler to do find+replace in a few huge files. regards F From apwebdesign at yahoo.com Fri Aug 19 03:53:01 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Fri, 19 Aug 2005 01:53:01 -0700 (PDT) Subject: [thelist] Regex apostrophe problem In-Reply-To: Message-ID: <20050819085302.39576.qmail@web51106.mail.yahoo.com> > > What language? > > > > Perl has functions for uppercase and lowercase: > > > > uc($text) and a lc($text) function, which should > > already ignore special characters. > > > > If you must use regexp: > > > > $lower =~ s/(\w)(\w+)/\u$1\L$2/sig; > > > > Hi > > I'm using the Grep utilities within TextWrangler to > do find+replace > in a few huge files. No idea what that is, but if it supports regex syntax, the 2nd solution should work. Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs From evolt at kasimir-k.fi Fri Aug 19 04:27:40 2005 From: evolt at kasimir-k.fi (Kasimir K) Date: Fri, 19 Aug 2005 09:27:40 +0000 Subject: [thelist] Tip: whitespace in included PHP causes header() calls to fail In-Reply-To: <430529CD.40904@gmail.com> References: <4301BF4E.2030707@zstudio.co.uk> <430529CD.40904@gmail.com> Message-ID: <4305A60C.30507@kasimir-k.fi> > Ian Anderson wrote: >>Turned out there was a space *after* the closing "?> " in the included >>file, which was getting written to the browser as unintentional output >>at the start of the HTML. Matt Warden scribeva in 2005-08-19 00:37: > This is why you should never use the closing ?> in include files (it's > optional). I'm getting confused here... Earlier this year I asked about omitting the closing "?>" and then I was discouraged from doing that. [0] Now reading this I again had a look at the manual and a quick google, and it seems that in the old versions of the manual it indeed says that "?>" is optional, but current version says nothing about omitting it. So if I start leaving out those, will my PHP scripts still work fine 2010? cheers, .k [0] http://lists.evolt.org/archive/Week-of-Mon-20050207/169110.html From fffrancis at fstorr.demon.co.uk Fri Aug 19 05:05:12 2005 From: fffrancis at fstorr.demon.co.uk (fstorr) Date: Fri, 19 Aug 2005 11:05:12 +0100 Subject: [thelist] Regex apostrophe problem In-Reply-To: <20050819085302.39576.qmail@web51106.mail.yahoo.com> References: <20050819085302.39576.qmail@web51106.mail.yahoo.com> Message-ID: <3E4AB3E3-5784-4918-910B-F3170EF3367F@fstorr.demon.co.uk> On 19 Aug, 2005, at 09:53, Anthony Ettinger wrote: > > No idea what that is, but if it supports regex syntax, > the 2nd solution should work. Hi Yep it does - I was obviously trying to do something too complex and the solution was staring me in the face. Thanks! F From martynh at gmail.com Fri Aug 19 05:38:46 2005 From: martynh at gmail.com (Martyn Haigh) Date: Fri, 19 Aug 2005 11:38:46 +0100 Subject: [thelist] Extending Javascript Objects Message-ID: <6d2fb30e050819033851771914@mail.gmail.com> Hi, I'#m trying to make my life a bit easier, and kinda failing. I've written a few JavaScript prototype functions and attached them to the Object : Object.prototype.getStyle = function(strProperty) { ... } Object.prototype.setStyle = function(strPoperty, strValue) { ... } Object.prototype.addClass = function(strClass) { ... } Object.prototype.removeClass = function(strClass) { ... } Object.prototype.replaceClass = function(strOldClass, strNewClass) { ... } Object.prototype.classExists = function(strClass) { ... } there are two problems: 1, I've read that this isn't a good way of getting things done as it can really really slow down the javascript and is generally a bad practice. 2, it doesn't work in IE6 All i want is a nice easy way of manipulating classes and styles on elements within a page. Can anyone think of a better way of doing this which will still be as easy as objElement.addClass("alert"); ? Cheers M From markus at staas.biz Fri Aug 19 06:02:27 2005 From: markus at staas.biz (Markus Staas) Date: Fri, 19 Aug 2005 17:02:27 +0600 Subject: [thelist] Open Source Dot.Net CMS In-Reply-To: <6d2fb30e050819033851771914@mail.gmail.com> Message-ID: <200508191102.BLX64227@ms12.netsolmail.com> Hi list! I usually using Typo3 Open Source CMS with Enterprise CMS Features such as Caching, Workflow, Portal landscaping and Versioning, wonders if there is an Enterprise Open Source CMS based on ASP.Net available and about your opinions to that system. I know about DotNetNuke but have not found much more by now. Thanks for your help, Markus From apwebdesign at yahoo.com Fri Aug 19 06:02:56 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Fri, 19 Aug 2005 04:02:56 -0700 (PDT) Subject: [thelist] Extending Javascript Objects In-Reply-To: <6d2fb30e050819033851771914@mail.gmail.com> Message-ID: <20050819110257.83528.qmail@web51107.mail.yahoo.com> Not tested in IE6, but it should work:
blah
Here's a list of css properties you can set: http://www.mozilla.org/docs/dom/domref/dom_style_ref18.html#1002335 --- Martyn Haigh wrote: > Hi, > > I'#m trying to make my life a bit easier, and kinda > failing. I've > written a few JavaScript prototype functions and > attached them to the > Object : > > Object.prototype.getStyle = function(strProperty) { > ... > } > Object.prototype.setStyle = function(strPoperty, > strValue) { > ... > } > Object.prototype.addClass = function(strClass) { > ... > } > Object.prototype.removeClass = function(strClass) { > ... > } > Object.prototype.replaceClass = > function(strOldClass, strNewClass) { > ... > } > Object.prototype.classExists = function(strClass) { > ... > } > > there are two problems: > 1, I've read that this isn't a good way of getting > things done as it > can really really slow down the javascript and is > generally a bad > practice. > 2, it doesn't work in IE6 > > All i want is a nice easy way of manipulating > classes and styles on > elements within a page. > > Can anyone think of a better way of doing this which > will still be as > easy as objElement.addClass("alert"); ? > > Cheers > > M > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From martynh at gmail.com Fri Aug 19 06:22:55 2005 From: martynh at gmail.com (Martyn Haigh) Date: Fri, 19 Aug 2005 12:22:55 +0100 Subject: [thelist] Extending Javascript Objects In-Reply-To: <20050819110257.83528.qmail@web51107.mail.yahoo.com> References: <6d2fb30e050819033851771914@mail.gmail.com> <20050819110257.83528.qmail@web51107.mail.yahoo.com> Message-ID: <6d2fb30e0508190422361a24d@mail.gmail.com> On 19/08/05, Anthony Ettinger wrote: > Not tested in IE6, but it should work: ... > > Here's a list of css properties you can set: > http://www.mozilla.org/docs/dom/domref/dom_style_ref18.html#1002335 Thanks, not quite what i was looking for, but appreciate the reply. M From apwebdesign at yahoo.com Fri Aug 19 07:50:24 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Fri, 19 Aug 2005 05:50:24 -0700 (PDT) Subject: [thelist] Extending Javascript Objects In-Reply-To: <6d2fb30e0508190422361a24d@mail.gmail.com> Message-ID: <20050819125024.89959.qmail@web51106.mail.yahoo.com> no need to re-invent the wheel ;) --- Martyn Haigh wrote: > On 19/08/05, Anthony Ettinger > wrote: > > Not tested in IE6, but it should work: > ... > > > > Here's a list of css properties you can set: > > > http://www.mozilla.org/docs/dom/domref/dom_style_ref18.html#1002335 > > Thanks, not quite what i was looking for, but > appreciate the reply. > > M > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail From Brian at hondaswap.com Fri Aug 19 08:25:32 2005 From: Brian at hondaswap.com (Brian Cummiskey) Date: Fri, 19 Aug 2005 09:25:32 -0400 Subject: [thelist] asp recordset loop In-Reply-To: <003501c5a495$2287e1a0$4500010a@gammaglobal.com> References: <43034BDB.7010504@hondaswap.com> <4304EACC.2080707@hondaswap.com> <003501c5a495$2287e1a0$4500010a@gammaglobal.com> Message-ID: <4305DDCC.9050003@hondaswap.com> Mark Rees wrote: > > How? Did you discover the nextrecordset method of the recordset? No, I altered my procedure, and union'ed all the select queries into one big one, thus, only giving me one recordset. i'll look into the nextrecordset procedure as well, as i've never heard of it. From lists at semioticpixels.com Fri Aug 19 08:47:42 2005 From: lists at semioticpixels.com (chris) Date: Fri, 19 Aug 2005 06:47:42 -0700 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <20050819050602.39362.qmail@web51101.mail.yahoo.com> Message-ID: <001701c5a4c4$92de88d0$6601a8c0@bluedew> No, Plone is not written in php -it's written in python and runs on top of the Zope framework which is also written in python. It's a nice system but has a steep learning curve if you plan to extend it. For the OP, it seems to me that the majority of LAMP cms' are blog based, including Drupal, WordPress, Textpattern but even so those all seem to match your requirements ... So ... What about your requirements indicates "not blog based"? Your search will probably be easier if you refine your requirements. For example, when you say that you like Etomite, but not the table based layout, does that mean the html for the default install must meet a criteria? When I'm looking at systems, I generally look at how easy it will be to customize the layout. I don't really care what the default install looks like, but I do care if I'm going to dig through 300 files to find a being output by some errant function. Realistically, you'll probably have to install and try out a number of systems before you find one you like. In my experience, most systems are over-featured and built around a news model that tends to be awkward for simple web management. I personally like WordPress as a blog and it's very easy to create a theme for WP, but I think the editor exposes novice users to html too much. Drupal is quite popular these days - most Drupal installs look like a blog to me but you can easily install a rich text editor as a module which is a more familiar editing environment for most users. Textpattern is probably the most elegant solution to your requirements. Try out LAMP systems at http://www.opensourcecms.com/ Sort by requirements http://www.cmsmatrix.org/matrix Sort by license at the OSCOM matrix http://www.oscom.org/matrix/index.html hth -chris From hassan at webtuitive.com Fri Aug 19 09:02:18 2005 From: hassan at webtuitive.com (Hassan Schroeder) Date: Fri, 19 Aug 2005 07:02:18 -0700 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <20050819050602.39362.qmail@web51101.mail.yahoo.com> References: <20050819050602.39362.qmail@web51101.mail.yahoo.com> Message-ID: <4305E66A.4010903@webtuitive.com> Anthony Ettinger wrote: > plone is php based. Uh, actually it's *Python*-based; quite a different animal :-) -- Hassan Schroeder ----------------------------- hassan at webtuitive.com Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. From markgroen at gmail.com Fri Aug 19 09:13:20 2005 From: markgroen at gmail.com (Mark Groen) Date: Fri, 19 Aug 2005 07:13:20 -0700 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? Message-ID: <008501c5a4c8$29956c00$6400a8c0@vn.shawcable.net> ----- Original Message ----- From: "Mark Groen" To: Sent: Thursday, August 18, 2005 9:06 PM Subject: Re: [thelist] CMS - Non-Blog-Like XHTML CSS? > ----- Original Message ----- > From: "Kris Khaira" < > To: > Sent: Thursday, August 18, 2005 7:57 PM > Subject: Re: [thelist] CMS - Non-Blog-Like XHTML CSS? > > > > You're looking for Textpattern - http://www.textpattern.com > > > > You can use it to edit content, layout and styles. And it has multiple > > privilege levels. > > > > > > On Aug 19, 2005, at 5:28 AM, Jeff Oien wrote: > > > > > I'm looking for a simple, free CMS that isn't blog style-something > > > for "regular" web sites where the client can update content but I > can > > > easily modify templates and add features. I'd like it to be > > > XHTML 1.0 compliant and not use tables for layout. Any suggestions? > > My latest fave is websitebaker.com, imho one of the easiest admin > interfaces for the end user/client, easy-peasy templating, privilege > levels, news blocks, can be made to match almost any existing web site. > Fairly easy to get valid XHTML 1.0 Transitional code using a slightly > customized wysiwyg FCKeditor: > http://validator.w3.org/check?verbose=1&uri=http%3A//www.bowenisland.org/ > > Just last week I moved the site above from a TP back-end to WB, it's > about the fifth install I've done of this appy, the clients love it. I > *am* a Textpattern fan still, but the Baker is a nice middle ground > between complexity for the end user and flexibility for the developer, > imho of course :-) > > cheers, > > Mark > > From discuss at alphanumeric.cz Fri Aug 19 09:42:43 2005 From: discuss at alphanumeric.cz (Jan Brasna) Date: Fri, 19 Aug 2005 16:42:43 +0200 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <001701c5a4c4$92de88d0$6601a8c0@bluedew> References: <001701c5a4c4$92de88d0$6601a8c0@bluedew> Message-ID: <4305EFE3.1030709@alphanumeric.cz> > For the OP, it seems to me that the majority of LAMP cms' are blog > based, including Drupal, WordPress, Textpattern but even so those all > seem to match your requirements I think so too. We made these web sites on WP and we're happy with its CMS features: http://www.bonsoir.cz/ http://www.zbiroh.com/ http://www.skbu.cz/ -- Jan Brasna aka JohnyB :: www.alphanumeric.cz | www.janbrasna.com From keith at digital-crew.com Fri Aug 19 10:08:41 2005 From: keith at digital-crew.com (Keith Gaughan) Date: Fri, 19 Aug 2005 16:08:41 +0100 Subject: [thelist] Extending Javascript Objects In-Reply-To: <6d2fb30e050819033851771914@mail.gmail.com> References: <6d2fb30e050819033851771914@mail.gmail.com> Message-ID: <4305F5F9.8000503@digital-crew.com> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martyn Haigh wrote: > I'#m trying to make my life a bit easier, and kinda failing. I've > written a few JavaScript prototype functions and attached them to the > Object : > > Object.prototype.getStyle = function(strProperty) { > ... > } > Object.prototype.setStyle = function(strPoperty, strValue) { > ... > } > Object.prototype.addClass = function(strClass) { > ... > } > Object.prototype.removeClass = function(strClass) { > ... > } > Object.prototype.replaceClass = function(strOldClass, strNewClass) { > ... > } > Object.prototype.classExists = function(strClass) { > ... > } Everybody else has covered the other issues, but there's one more that I ought to mention. It's tempting to extend the Object prototype so that you'll have all these extra methods on all the objects derived from Object. But this is a *really* bad idea. You see, doing so makes objects unusable as hashtables. Lets say that you've done this: Object.prototype.foo = function() {}; And later on in some completely unrelated code you've got something that does something like: var bar = { "Fred": "Wilma", "Barney": "Betty" }; if ("foo" in bar) { alert("Whoa! This shouldn't happen!"); } else { alert("All is well: objects behaving as proper hashes."); } You'll get a pop-up window saying "Whoa! This shouldn't happen!", because there's a phantom element in 'bar' called 'foo' from your extending Object like that. Erik explains things even better here: http://erik.eae.net/archives/2005/06/06/22.13.54/ K. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDBfX5mSWF0pzlQ04RAtcqAKCSsqB3NddbhuctS/BJPwjNFLzI/QCfa7eR BzdREvfibyTxeVRrDb4LsgM= =Pm6w -----END PGP SIGNATURE----- From mwarden at gmail.com Fri Aug 19 11:07:42 2005 From: mwarden at gmail.com (Matt Warden) Date: Fri, 19 Aug 2005 12:07:42 -0400 Subject: [thelist] Extending Javascript Objects In-Reply-To: <4305F5F9.8000503@digital-crew.com> References: <6d2fb30e050819033851771914@mail.gmail.com> <4305F5F9.8000503@digital-crew.com> Message-ID: > It's tempting to extend the Object prototype so that you'll have all > these extra methods on all the objects derived from Object. But this > is a *really* bad idea. > > You see, doing so makes objects unusable as hashtables. Lets say that > you've done this: Actually, this is why you should never use Object as a hashtable. It takes about 3 minutes to work around: http://cvs.horde.org/co.php/incubator/Horde_Form/js/simplehashtable.js?r=1.1 -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. From markus at staas.biz Fri Aug 19 11:22:48 2005 From: markus at staas.biz (Markus Staas) Date: Fri, 19 Aug 2005 22:22:48 +0600 Subject: [thelist] CMS - Non-Blog-Like XHTML CSS? In-Reply-To: <008501c5a4c8$29956c00$6400a8c0@vn.shawcable.net> Message-ID: <200508191622.BLY66000@ms12.netsolmail.com> Try Typo3 www.typo3.org , depending on your experience with CMS it could be a bit "fat" A bit smaller is Mambo, but still good www.mamboserver.com/ If you want to make simple sites you should also check out, Contenido, www.contenido.org, a bit german though, but super simple to set up If you do more than one client or website, then best to get into typo3, once you know it well, you can set up sites in no time and serve websites up to enterprise level communication and portal landscape including workflow, visual templating, caching and more, knowledgeable user base and so on. U can get books about it, same about mambo. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Mark Groen Sent: Freitag, 19. August 2005 20:13 To: thelist at lists.evolt.org Subject: Re: [thelist] CMS - Non-Blog-Like XHTML CSS? ----- Original Message ----- From: "Mark Groen" To: Sent: Thursday, August 18, 2005 9:06 PM Subject: Re: [thelist] CMS - Non-Blog-Like XHTML CSS? > ----- Original Message ----- > From: "Kris Khaira" < > To: > Sent: Thursday, August 18, 2005 7:57 PM > Subject: Re: [thelist] CMS - Non-Blog-Like XHTML CSS? > > > > You're looking for Textpattern - http://www.textpattern.com > > > > You can use it to edit content, layout and styles. And it has multiple > > privilege levels. > > > > > > On Aug 19, 2005, at 5:28 AM, Jeff Oien wrote: > > > > > I'm looking for a simple, free CMS that isn't blog style-something > > > for "regular" web sites where the client can update content but I > can > > > easily modify templates and add features. I'd like it to be > > > XHTML 1.0 compliant and not use tables for layout. Any suggestions? > > My latest fave is websitebaker.com, imho one of the easiest admin > interfaces for the end user/client, easy-peasy templating, privilege > levels, news blocks, can be made to match almost any existing web site. > Fairly easy to get valid XHTML 1.0 Transitional code using a slightly > customized wysiwyg FCKeditor: > http://validator.w3.org/check?verbose=1&uri=http%3A//www.bowenisland.org/ > > Just last week I moved the site above from a TP back-end to WB, it's > about the fifth install I've done of this appy, the clients love it. I > *am* a Textpattern fan still, but the Baker is a nice middle ground > between complexity for the end user and flexibility for the developer, > imho of course :-) > > cheers, > > Mark > > -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! From lists at frankmarion.com Fri Aug 19 12:26:43 2005 From: lists at frankmarion.com (Frank) Date: Fri, 19 Aug 2005 13:26:43 -0400 Subject: [thelist] CF: UDF in Application.cfm not accessible? In-Reply-To: <006f01c5a458$f1a46f90$8001a8c0@BOPPADEEDEE> References: <6.1.1.1.2.20050816113605.01eddab0@127.0.0.1> <006f01c5a458$f1a46f90$8001a8c0@BOPPADEEDEE> Message-ID: <6.1.1.1.2.20050819132410.01f0b260@127.0.0.1> At 08:57 PM 2005-08-18, you wrote: >directory="drive-letter:\path-to-site\app_functions\" > > > > > > > Two things. It's an interesting approach. I would also tend to cache the query, and check to see if it's been run before listing the directory again (slow). The issue I'm having, however is that if I include a udf in my application.cfm file, I can't seem to access it from inlcuded documents. I'll often include two levels deep, and what I'm wondering is how to make them accessible regardless of where I call them from, without having to include the UDF each time I want to use it. Frank Marion lists at frankmarion.com Keep the signal high. From joshua at waetech.com Fri Aug 19 13:19:08 2005 From: joshua at waetech.com (Joshua Olson) Date: Fri, 19 Aug 2005 14:19:08 -0400 Subject: [thelist] CF: UDF in Application.cfm not accessible? In-Reply-To: <6.1.1.1.2.20050819132410.01f0b260@127.0.0.1> Message-ID: > -----Original Message----- > From: Frank > Sent: Friday, August 19, 2005 1:27 PM > > > The issue I'm having, however is that if I include a udf in my > application.cfm file, I can't seem to access it from inlcuded > documents. > I'll often include two levels deep, and what I'm wondering is > how to make > them accessible regardless of where I call them from, without > having to include the UDF each time I want to use it. Frank, Are you positive you are calling it from "cfincluded" files, and not file included via cfmodule or using the custom tag format (cf_filename)? Have you looked at putting the UDF in the request scope? <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Fax: 413.812.4864 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From harvester at lists.evolt.org Fri Aug 19 13:27:45 2005 From: harvester at lists.evolt.org (harvester at lists.evolt.org) Date: 19 Aug 2005 18:27:45 -0000 Subject: [thelist] Tip Harvest for the Week of Monday Aug 12, 2005 Message-ID: <20050819182745.31259.qmail@acornparenting.org> The tip harvest for the Week of Monday Aug 12, 2005 has been added to the lists.evolt.org site. Get it at: http://lists.evolt.org/harvest/show.cgi?w=20050812 Week at a glance listing at: http://lists.evolt.org/harvest/week.cgi?w=20050812 Harvest Summary --------------- Number of messages: 2515 Number of tips : 37 Tip Authors ----------- Burhan Khalid (1) Dan McCullough (1) Hershel Robinson (1) Ian Anderson (2) Jan Guichelaar [artmiks] (1) Jay Blanchard (2) Jeff Howden (1) John Brooking (1) John Corry (1) Joshua Olson (3) Kasimir K (2) kasimir k (1) Keith Gaughan (4) Matt Warden (1) Max Schwanekamp (1) Minh Lee Goon (1) Nan (1) Paul Bennett (1) Paul Cowan (1) sbeam (1) Steve Lewis (1) Stuart = Young (1) ted (1) Theodore Serbinski (1) Tyme (1) Volkan Ozcelik (2) Tip Types --------- auto_prepend_file in PHP (1) ColdFusion (1) CSS (1) ergonomics (1) favicon (1) Foreach loops in Smarty PHP templates (1) Homesite (1) Javascript (1) Javascript Debugging (1) localization in .net (1) MySQL SQL Tools (1) php (2) php development (1) Printers (1) Save Time (1) secure forms (1) Small Business (1) SQL (1) stock photography (1) T-SQL (1) Testing PHP (1) think before you post (1) Unclassified (10) vacature webdeveloper (1) VBScript (1) Web Administration (1) Writing Style Guide (1) From jeff at jeffhowden.com Fri Aug 19 15:53:18 2005 From: jeff at jeffhowden.com (Jeff Howden) Date: Fri, 19 Aug 2005 13:53:18 -0700 Subject: [thelist] CF: UDF in Application.cfm not accessible? In-Reply-To: <6.1.1.1.2.20050819132410.01f0b260@127.0.0.1> Message-ID: <20050819194931.13021.27753@hm-pop3.solinus.com> Frank, ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > From: Frank > > Two things. It's an interesting approach. I would also > tend to cache the query, and check to see if it's been > run before listing the directory again (slow). ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< Actually, unless you have numbers approaching a thousand (which you shouldn't in a server-wide UDF directory), the execution time of a to get a list of the contents of that directory isn't even measurable. ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< > The issue I'm having, however is that if I include a udf > in my application.cfm file, I can't seem to access it > from inlcuded documents. [...] ><><><><><><><><><><><><><><><><><><><><><><><><><><><><>< Have you turned on debugging to verify that the files are, indeed, getting included? [>] Jeff Howden jeff at jeffhowden.com http://jeffhowden.com/ From martynh at gmail.com Fri Aug 19 18:10:28 2005 From: martynh at gmail.com (Martyn Haigh) Date: Sat, 20 Aug 2005 00:10:28 +0100 Subject: [thelist] Extending Javascript Objects In-Reply-To: References: <6d2fb30e050819033851771914@mail.gmail.com> <4305F5F9.8000503@digital-crew.com> Message-ID: <6d2fb30e05081916107f50097e@mail.gmail.com> > Actually, this is why you should never use Object as a hashtable. It > takes about 3 minutes to work around: (Matt) I know you do PHP, but is a hashtable a bit like a dictionary object in ASP? If so then I wrote one of these in javascript already. Given that I'm not going to be using my script for a hashtable, are there any other arguements against extending the Object Prototype (and of course apart from IE not supporting it)? M P.S. Thanks for everyones help. From jeffery.to at gmail.com Sat Aug 20 00:48:44 2005 From: jeffery.to at gmail.com (Jeffery To) Date: Sat, 20 Aug 2005 13:48:44 +0800 Subject: [thelist] Extending Javascript Objects In-Reply-To: <6d2fb30e050819033851771914@mail.gmail.com> References: <6d2fb30e050819033851771914@mail.gmail.com> Message-ID: On 8/19/05, Martyn Haigh wrote: > there are two problems: ... > 2, it doesn't work in IE6 If I remember correctly, that's because DOM elements in IE exist outside of the normal JavaScript object hierarchy, i.e. DOM elements don't have the Object object in their prototype chains. > Can anyone think of a better way of doing this which will still be as > easy as objElement.addClass("alert"); ? How about addClass(objElement, "alert"); (having addClass be a global function)? Jeff -- Jeffery To www.thingsthemselves.com From thelist at meidomus.com Sat Aug 20 02:26:38 2005 From: thelist at meidomus.com (Burhan Khalid) Date: Sat, 20 Aug 2005 10:26:38 +0300 Subject: [thelist] PHP compilation In-Reply-To: <28fd2913998f2e408a73e9773279d7e2@pennyonthesidewalk.com> References: <28fd2913998f2e408a73e9773279d7e2@pennyonthesidewalk.com> Message-ID: <4306DB2E.7040008@meidomus.com> Robert Gormley wrote: > Hi all, > > Trying to compile php from source to try out lighttpd - except I cannot > get it to generate php_mysql/mysqli.dll's... no configure/make errors, > just no *dll files generated. CentOS 4.1... You cannot create .dll files if your are compiling on Linux. You will be creating .so files. I'm actually surprised you expected that to work. From thelist at meidomus.com Sat Aug 20 02:33:18 2005 From: thelist at meidomus.com (Burhan Khalid) Date: Sat, 20 Aug 2005 10:33:18 +0300 Subject: [thelist] Tip: whitespace in included PHP causes header() calls to fail In-Reply-To: <430529CD.40904@gmail.com> References: <4301BF4E.2030707@zstudio.co.uk> <430529CD.40904@gmail.com> Message-ID: <4306DCBE.6070105@meidomus.com> Matt Warden wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Ian Anderson wrote: > >>In PHP, calls to header( "Location: whatever.php" ) were failing >>silently whenever an include file was used to validate the user's >>session data. >> >>I thought it was something I was doing with cookies or session_start() >>in my included file, but no... >> >>Turned out there was a space *after* the closing "?> " in the included >>file, which was getting written to the browser as unintentional output >>at the start of the HTML. Of course, calls affecting HTTP header will >>not work if output has already been written to the browser. > > > This is why you should never use the closing ?> in include files (it's > optional). This is bad practice to omit the closing ?> just like its bad practice to use I am asking this for a friend (I haven't done the site) as I can't see the reason for the problem. The problem only occurs in IE 6 Win, it seems (I don't have an earlier version but am told it is okay; and it is okay in Safari and FF). The link is: http://www.propertyvisionnz.co.nz/index.htm (please note: no final "l"; I point this out as there is a "cover" page up while the site is being sorted out by the owner's developer (this is her first site). You can see what the page is meant to look like and how it works in FF. What happens is this: The page flickers if you run the curser over it. I can't pick up what the problem is. It appears that the developer has used Dreamweaver templates. We would appreciate any assistance! David From thelist at meidomus.com Sat Aug 20 02:56:17 2005 From: thelist at meidomus.com (Burhan Khalid) Date: Sat, 20 Aug 2005 10:56:17 +0300 Subject: [thelist] Tip: whitespace in included PHP causes header() calls tofail In-Reply-To: References: Message-ID: <4306E221.9080506@meidomus.com> Paul Bennett wrote: > > Error Reporting is your friend. > > Turning error reporting right up on test servers or during development will literally save you hours of time. Lower levels of error reporting won't report undeclared variables, call's to Header() when there's white space already outputted to the browser and a hundred other errors which can stop things working properly. > > If you don't have access to php.ini (i.e.: on a shared server) you can turn error reporting up at runtime via: > > ini_set('error_reporting', E_ALL); > > Also remember to turn on 'display_errors' otherwise nothing will be displayed. In addition, if you have this on top of a script that has a header() call, any type of error (for example, a notice) will cause the header() call to fail because the output from the error will be sent to the browser. Example: When you request this page directly, you will get a notice similar to 'Undefined key 'code' in array $_GET on Line ...' which will be output to the browser, causing the the header() call to fail with the a notice similar to 'Cannot send headers. Output already started at line...' Need to watch out for things like the above, which can cause some great head scratching for beginners. There are a number of ways to avoid simple notices such as 'undefined key' notices. I'll list the most common that I have seen: 1. Turn up your error reporting level to only report fatal errors, or to filter out notices. 2. Use the @ operator (error suppression operator). if (@$_GET['code'] == '123') 3. Use a function such as array_key_exists or isset: if (array_key_exists('code',$_GET) && $_GET['code'] == '123') (this is my favorite method, and the one I tend to recommend) Hopefully this helps, Burhan From thelist at meidomus.com Sat Aug 20 03:17:15 2005 From: thelist at meidomus.com (Burhan Khalid) Date: Sat, 20 Aug 2005 11:17:15 +0300 Subject: [thelist] IE sending page crazy In-Reply-To: References: Message-ID: <4306E70B.2010402@meidomus.com> David Bailey wrote: > I am asking this for a friend (I haven't done the site) as I can't see the > reason for the problem. The problem only occurs in IE 6 Win, it seems (I > don't have an earlier version but am told it is okay; and it is okay in > Safari and FF). > > The link is: > http://www.propertyvisionnz.co.nz/index.htm (please note: no final "l"; I > point this out as there is a "cover" page up while the site is being sorted > out by the owner's developer (this is her first site). > > You can see what the page is meant to look like and how it works in FF. > > What happens is this: > > The page flickers if you run the curser over it. I can't pick up what the > problem is. It appears that the developer has used Dreamweaver templates. Actually, this is not what happens on my version of IE (latest non-7). What I can say is that this is the most extreme difference that I have seen in rendering between FF and IE. I actually compared the source to make sure it was the same markup! There are a a few problems with this markup, I suggest that you recommend to your friend to validate it. Just my initial 2-minute view of the code leads me to the following: 1. There is a table that from what I know, serves no purpose. Its literally blank. just a set of tags. 2. There are quite a few closing font tags, with no matching opening tags. I did not check the CSS though. FWIW, Burhan From dab.hand at xtra.co.nz Sat Aug 20 06:07:19 2005 From: dab.hand at xtra.co.nz (David Bailey) Date: Sat, 20 Aug 2005 23:07:19 +1200 Subject: [thelist] IE sending page crazy In-Reply-To: <4306E70B.2010402@meidomus.com> Message-ID: Thanks, Burhan. I should have thought of that first myself! I put the page through the validator myself and it came up with 16 errors. Actually, it suggests that the errors made are usually made when using "strict" doctype with frames. The page is neither?it is 4.01 transitional! The css validates, although, I think that this is minimal; it's a table-based page and css is more cosmetics. Thanks for your help. I'm not sure whether fixing these will solve the problem, but we'll see. David > Actually, this is not what happens on my version of IE (latest non-7). > What I can say is that this is the most extreme difference that I > have seen in rendering between FF and IE. I actually compared the > source to make sure it was the same markup! > > There are a a few problems with this markup, I suggest that you > recommend to your friend to validate it. Just my initial 2-minute view > of the code leads me to the following: > > 1. There is a table that from what I know, serves no purpose. Its > literally blank. just a set of tags. > > 2. There are quite a few closing font tags, with no matching opening tags. > > I did not check the CSS though. > > FWIW, > Burhan > David Bailey wrote: >> I am asking this for a friend (I haven't done the site) as I can't see the >> reason for the problem. The problem only occurs in IE 6 Win, it seems (I >> don't have an earlier version but am told it is okay; and it is okay in >> Safari and FF). >> >> The link is: >> http://www.propertyvisionnz.co.nz/index.htm (please note: no final "l"; I >> point this out as there is a "cover" page up while the site is being sorted >> out by the owner's developer (this is her first site). >> >> You can see what the page is meant to look like and how it works in FF. >> >> What happens is this: >> >> The page flickers if you run the cursor over it. I can't pick up what the >> problem is. It appears that the developer has used Dreamweaver templates. From evolt at kasimir-k.fi Sat Aug 20 06:39:29 2005 From: evolt at kasimir-k.fi (Kasimir K) Date: Sat, 20 Aug 2005 11:39:29 +0000 Subject: [thelist] IE sending page crazy In-Reply-To: <4306E70B.2010402@meidomus.com> References: <4306E70B.2010402@meidomus.com> Message-ID: <43071671.6010106@kasimir-k.fi> > David Bailey wrote: >>The link is: >>http://www.propertyvisionnz.co.nz/index.htm >>What happens is this: >>The page flickers if you run the curser over it. Burhan Khalid scribeva in 2005-08-20 08:17: > Actually, this is not what happens on my version of IE (latest non-7). > What I can say is that this is the most extreme difference that I > have seen in rendering between FF and IE. I actually compared the > source to make sure it was the same markup! I've got too latest MSIE 6.0, no flickering here either, and compared to FF, the rendering is almost identical! The only differences I could spot: the menu has slightly larger type in FF, and the top banner is taller in FF. IE 5, IE 4 had no problems either. .k From dab.hand at xtra.co.nz Sat Aug 20 07:12:02 2005 From: dab.hand at xtra.co.nz (David Bailey) Date: Sun, 21 Aug 2005 00:12:02 +1200 Subject: [thelist] IE sending page crazy In-Reply-To: <43071671.6010106@kasimir-k.fi> Message-ID: >> David Bailey wrote: >>> The link is: >>> http://www.propertyvisionnz.co.nz/index.htm >>> What happens is this: >>> The page flickers if you run the curser over it. > > Burhan Khalid scribeva in 2005-08-20 08:17: >> Actually, this is not what happens on my version of IE (latest non-7). >> What I can say is that this is the most extreme difference that I >> have seen in rendering between FF and IE. I actually compared the >> source to make sure it was the same markup! > > I've got too latest MSIE 6.0, no flickering here either, and compared to > FF, the rendering is almost identical! The only differences I could > spot: the menu has slightly larger type in FF, and the top banner is > taller in FF. > > IE 5, IE 4 had no problems either. > > .k > -- That's weird! I have MSIE 6.0 win, so has the client and he reports that another friend had the same problem, although, the developer cannot reproduce the problem on an older IE browser. Not sure what is happening then! On my (and those others mentioned) browser there is only the logo on the top left corner, and the rest of the page is white until I put the cursor on the page; it then flickers to fill the screen with a light green colour. If I click anywhere on the page, the url changes, but the page doesn't!! Weird! Thanks for checking it out! David From steve at thethurstons.net Sat Aug 20 01:43:09 2005 From: steve at thethurstons.net (Steve Thurston) Date: Fri, 19 Aug 2005 23:43:09 -0700 Subject: [thelist] Frames with flash Message-ID: <005c01c5a552$6e4f76d0$6501a8c0@tc1100> Howdy did you ever get to work this prob out? if you did, please let me know how you done it, I can't loose anymore hair over this simple problem thanks steve > you will be able to add an action to the button: > add action : (select "onclick") > options select: "get url" > in the text fields you should be able to specify the file to load and > the target, which can be the name of the frame you want to load the page > into I took a button from Flash's library and inserted following ActionScript in its Actions panel. on (release) { getURL ("KeyCodeDetector.html", parent.bottomFrame); } Here "bottomFrame" is the name of bottom frame in which loading of "KeyCodeDetector.html" is required. The Flash button is in top frame. When the button is clicked, the page is loaded in the top frame instead of bottom frame. What's the wrong with ActionScript? Thank you, Syed Zeeshan Haider. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Need an Assistant - Virtual Assistant Service. * http://www.TheThurstons.net * * Retirement Cash - Get RetiredOnline.info * http://www.RetiredOnline.info/ * * Affordable Supplemental Health Benefits - AmeriPlan. * http://www.deliveringonthepromise.com/40264899 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * From thelist at meidomus.com Sat Aug 20 08:53:06 2005 From: thelist at meidomus.com (Burhan Khalid) Date: Sat, 20 Aug 2005 16:53:06 +0300 Subject: [thelist] IE sending page crazy In-Reply-To: References: Message-ID: <430735C2.2000208@meidomus.com> David Bailey wrote: > >>>David Bailey wrote: >>> >>>>The link is: >>>>http://www.propertyvisionnz.co.nz/index.htm >>>>What happens is this: >>>>The page flickers if you run the curser over it. >> >>Burhan Khalid scribeva in 2005-08-20 08:17: >> >>>Actually, this is not what happens on my version of IE (latest non-7). >>>What I can say is that this is the most extreme difference that I >>>have seen in rendering between FF and IE. I actually compared the >>>source to make sure it was the same markup! >> >>I've got too latest MSIE 6.0, no flickering here either, and compared to >>FF, the rendering is almost identical! The only differences I could >>spot: the menu has slightly larger type in FF, and the top banner is >>taller in FF. >> >>IE 5, IE 4 had no problems either. >> >>.k >>-- > > That's weird! I have MSIE 6.0 win, so has the client and he reports that > another friend had the same problem, although, the developer cannot > reproduce the problem on an older IE browser. Not sure what is happening > then! On my (and those others mentioned) browser there is only the logo on > the top left corner, and the rest of the page is white until I put the > cursor on the page; it then flickers to fill the screen with a light green > colour. If I click anywhere on the page, the url changes, but the page > doesn't!! Weird! This is what I was getting, except I had a large horizontal scroll bar, I saw one link, no logo, and the rest of the page was shifted the right. I just refereshed, and it seems to show similar to FF. From lists at frankmarion.com Sat Aug 20 09:11:13 2005 From: lists at frankmarion.com (Frank) Date: Sat, 20 Aug 2005 10:11:13 -0400 Subject: [thelist] CF: UDF in Application.cfm not accessible? In-Reply-To: <20050819194931.13021.27753@hm-pop3.solinus.com> References: <6.1.1.1.2.20050819132410.01f0b260@127.0.0.1> <20050819194931.13021.27753@hm-pop3.solinus.com> Message-ID: <6.1.1.1.2.20050820101027.01d491d8@127.0.0.1> At 04:53 PM 2005-08-19, you wrote: >Have you turned on debugging to verify that the files are, indeed, getting >included? Yes, they are cfincluded and show up in the debug. I'm going to try Josh's idea of setting them to the request scope. Frank Marion lists at frankmarion.com Keep the signal high. From lists at frankmarion.com Sat Aug 20 10:11:51 2005 From: lists at frankmarion.com (Frank) Date: Sat, 20 Aug 2005 11:11:51 -0400 Subject: [thelist] Interesting SQL Puzzle Message-ID: <6.1.1.1.2.20050820105805.01f4ba18@127.0.0.1> I've got a situation where I have 100 records. Each record has a field named "rank" whose numeric value represents the record's position in a list. If the user wants to move a record to a different location on the list, s/he can change it. My puzzle is this: a user enters a 101st record and wants it to be located as item 33 in the list, thus, record with the current value of 33 would be updated to #34, and so on down the line. If a record is deleted, all the higher valued records would have to be re-updated. (Tangent: if sorting by rank. the last statement is not necessarily true, 36 is still higher than 34, but I can see potential issues arising if it's not kept tight) How do I go about re-ordering the records to prevent collision? Seems to me that updating 64 records with a different rank might be rather inefficient, especially if we have a lot of records. Can anyone suggest a different method? Frank Marion lists at frankmarion.com Keep the signal high. From joshua at waetech.com Sat Aug 20 11:31:38 2005 From: joshua at waetech.com (Joshua Olson) Date: Sat, 20 Aug 2005 12:31:38 -0400 Subject: [thelist] Interesting SQL Puzzle In-Reply-To: <6.1.1.1.2.20050820105805.01f4ba18@127.0.0.1> Message-ID: > -----Original Message----- > From: Frank > Sent: Saturday, August 20, 2005 11:12 AM > > > I've got a situation where I have 100 records. Each record > has a field named "rank" whose numeric value represents > the record's position in a list. If the user wants to move a > record to a different location on the list, s/he can change it. > > My puzzle is this: a user enters a 101st record and wants it > to be located as item 33 in the list, thus, record with the > current value of 33 would be updated to #34, and so on > down the line. If a record is deleted, all the higher valued > records would have to be re-updated. > > How do I go about re-ordering the records to prevent > collision? Seems to me that updating 64 records with a > different rank might be rather inefficient, especially if we > have a lot of records. Frank, Assume your update is something like this: UPDATE table SET rank = rank + 1 WHERE rank >= 33 The update will be really fast, even with a large number of records. Since this is a web application, I'm going to jump out on a limb and assume that SELECTs far out number the UPDATEs and INSERTs. If this is true, then even if this WAS somewhat slow it wouldn't be a big deal in the big picture. > Seems to me that updating 64 records with a different > rank might be rather inefficient, especially if we have a > lot of records. BTW, 64 records is always 64 records, even IF you have lots of records. ;-) <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Fax: 413.812.4864 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From webmaster at munger.ca Sat Aug 20 11:39:09 2005 From: webmaster at munger.ca (Michel Munger) Date: Sat, 20 Aug 2005 12:39:09 -0400 Subject: [thelist] Search script and accented characters Message-ID: <43075CAD.7020504@munger.ca> Hi everybody, New member here. I have a Web site in both English and French, and I have found that when I try to set up a small search engine for it, most won't support the accented characters of the French language, such as ?, ?, etc. Does anybody here know such an engine for free or a relatively low price? Being able to configure which directories can be searched would be a nice bonus. Regards, Michel Munger -- http://www.munger.ca/ From russ at unrealisticexpectations.com Sat Aug 20 11:55:49 2005 From: russ at unrealisticexpectations.com (Russ) Date: Sat, 20 Aug 2005 11:55:49 -0500 Subject: [thelist] Teaching: Book Recommendations Message-ID: <00d501c5a5a8$086f2e40$f3e8010a@BubbaHoTep> Hello... I've been asked to take on 4 courses this fall at the local Community College. I cannot complain; the pay is good, teachers get good discounts and apparently a prime parking spot. I know some of you have taught before, and I'm hoping to get some book recommendations. I've got a total of 4 8-week courses (2 sets of 2) that break down like this: Web Design with Macromedia Beginning Flash Then, then next set of 8 weeks is: Flash Animation Flash Actionscript To a degree, I think that I could get by with a single book for Beginning Flash and Flash Animation. Possibly even for Flash Actionscript. Then again, I've got 8 3-hour session with each. I've not had a chance to look at the "From The Source" books yet and all things considered, sometimes find those a little advanced for the people that I would be teaching. And, just so I'm not coming here asking without doing any sort of homework, some of the books on my list to consider are: Beyond the Basics - Shane Rebenschied & Lynda Essentials for Design: Flash MX 2004 Level One - Dwayne J. Ferguson Actionscript: Training from the Source - Derek Franklin, Jobe Makar Animation & Effects w/ Macromedia Flash MX 2004 - Jen Dehaan Teach Yourself Visually Macromedia Flash MX 2004 - Marangraphics (which, if I had to pay for a class with a book that was titled "teach yourself", I'd probably be pissed). I'm pretty wide open on my Web Design books and haven't even taken too deep of a dive there yet. It's also kind of cursory to me at the moment, but if there are recommendations, I'd welcome them. Thanks for helping out! Russ From apwebdesign at yahoo.com Sat Aug 20 12:12:47 2005 From: apwebdesign at yahoo.com (Anthony Ettinger) Date: Sat, 20 Aug 2005 10:12:47 -0700 (PDT) Subject: [thelist] Search script and accented characters In-Reply-To: <43075CAD.7020504@munger.ca> Message-ID: <20050820171247.8532.qmail@web51107.mail.yahoo.com> nutch.org htdig.org (see FAQ) --- Michel Munger wrote: > Hi everybody, > > New member here. > > I have a Web site in both English and French, and I > have found that when > I try to set up a small search engine for it, most > won't support the > accented characters of the French language, such as > ?, ?, etc. > > Does anybody here know such an engine for free or a > relatively low > price? Being able to configure which directories can > be searched would > be a nice bonus. > > > Regards, > > Michel Munger > > -- > http://www.munger.ca/ > -- > > * * Please support the community that supports you. > * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip > Harvester > and archives of thelist go to: > http://lists.evolt.org > Workers of the Web, evolt ! > Anthony Ettinger ph: (408) 656-2473 blog: http://www.chovy.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From lists at frankmarion.com Sat Aug 20 12:14:18 2005 From: lists at frankmarion.com (Frank) Date: Sat, 20 Aug 2005 13:14:18 -0400 Subject: [thelist] Interesting SQL Puzzle References: <6.1.1.1.2.20050820105805.01f4ba18@127.0.0.1> Message-ID: <6.1.1.1.2.20050820130829.01fa6f88@127.0.0.1> At 12:31 PM 2005-08-20, you wrote: >Assume your update is something like this: > >UPDATE table >SET rank = rank + 1 >WHERE rank >= 33 > >The update will be really fast, even with a large number of records. Since >this is a web application, I'm going to jump out on a limb and assume that >SELECTs far out number the UPDATEs and INSERTs. If this is true, then even >if this WAS somewhat slow it wouldn't be a big deal in the big picture. Yes, this is the easy part, but if we already have have a number 34, this operation would leave us with TWO records of rank #34, which is what I'm trying to avoid. I was also hoping to avoid looping over each record (from 33 to the end). I'm not sure that I can avoid the overall update to all the records. My concern was that I might end up with 500+ records, and that it would consume lots of resources, and that it increases the risk of corruption to the database. > > Seems to me that updating 64 records with a different > > rank might be rather inefficient, especially if we have a > > lot of records. > >BTW, 64 records is always 64 records, even IF you have lots of records. ;-) Got me. Frank Marion lists at frankmarion.com Keep the signal high. From m-lists at bristav.se Sat Aug 20 14:01:21 2005 From: m-lists at bristav.se (marcus) Date: Sat, 20 Aug 2005 21:01:21 +0200 Subject: [thelist] Extending Javascript Objects In-Reply-To: References: <6d2fb30e050819033851771914@mail.gmail.com> <4305F5F9.8000503@digital-crew.com> Message-ID: <43077E01.6020109@bristav.se> Since javascript is javascript (ie Lisp light) you miss one (or several) important method(s): function SimpleHashtable_each(callback) { for(var i = 0 ; i < this._keys.length ; i++) { var key = this._keys[i]; callback(key, this.get(key)); } } SimpleHashtable.prototype.each = SimpleHashtable_each; etc... Usage: var hash = new SimpleHashtable(); hash.put("a", "value a"); hash.put("b", "value b"); hash.each(function(key, value) { alert(key + " = " + value); }); // => alerts a = value a and b = value b Completely untested but should work. A question about the implentation: Since you are indeed using an Object as the a hash internally, aren't you sort of speaking against yourself in this case? And I think it's true that you shouldn't use Object as a hash (at least from a design point of view, perhaps not from a performance point but I guess that dependes on the implementation of the js interpretator) /Marcus From lists at neptunewebworks.com Sat Aug 20 15:11:43 2005 From: lists at neptunewebworks.com (Maximillian Schwanekamp) Date: Sat, 20 Aug 2005 13:11:43 -0700 Subject: [thelist] Interesting SQL Puzzle In-Reply-To: <6.1.1.1.2.20050820130829.01fa6f88@127.0.0.1> References: <6.1.1.1.2.20050820105805.01f4ba18@127.0.0.1> <6.1.1.1.2.20050820130829.01fa6f88@127.0.0.1> Message-ID: <43078E7F.3020309@neptunewebworks.com> Frank wrote: > Joshua wrote: >> UPDATE table >> SET rank = rank + 1 >> WHERE rank >= 33 > > Yes, this is the easy part, but if we already have have a number 34, > this operation would leave us with TWO records of rank #34, which is > what I'm trying to avoid. I was also hoping to avoid looping over each > record (from 33 to the end). I'm not sure that I can avoid the overall > update to all the records. What RDBMS are you using? Is the "rank" column your primary key or at least indexed for unique values? That would one step in enforcing that you do not get duplicate rank values. Joshua's suggestion is AFAIK the most efficient - one query for to "nudge" the records to make a gap, and then one more query to insert a new record into the gap. Taking your example of adding a record to a table consisting of 100 records ranked 1-100, you would do: /* Joshua's query first */ UDPATE table SET rank = rank + 1 WHERE rank >= '33'; /* Then insert the record in the sequence gap */ INSERT INTO table (id, rank) VALUES (NULL, '33'); This is assuming table.id is an auto-numbered column which is the primary key and that rank is an arbitrary value that you're mainly using for a user-defined ordering scheme (common in web apps). You could even go so far as to lock the table if you want to be sure that it does not get corrupted. If you're using an RDBMS that supports stored procedures, that would be easier yet. > My concern was that I might end up with 500+ > records, and that it would consume lots of resources, and that it > increases the risk of corruption to the database. AFAIK 500 records is still a pretty trivial table, and even lightweight RDBMSs can handle a full-table update without undo resource consumption. As Joshua mentioned, if this is a web app where most queries are SELECTs, occasionally updating the rank value for all 64, 100 or 500 or whatever records is nothing to worry about. -- Max Schwanekamp http://www.neptunewebworks.com/ From joshua at waetech.com Sat Aug 20 15:33:08 2005 From: joshua at waetech.com (Joshua Olson) Date: Sat, 20 Aug 2005 16:33:08 -0400 Subject: [thelist] Interesting SQL Puzzle In-Reply-To: <6.1.1.1.2.20050820130829.01fa6f88@127.0.0.1> Message-ID: > -----Original Message----- > From: Frank > Sent: Saturday, August 20, 2005 1:14 PM > > At 12:31 PM 2005-08-20, you wrote: > >Assume your update is something like this: > > > >UPDATE table > >SET rank = rank + 1 > >WHERE rank >= 33 > Yes, this is the easy part, but if we already have have a > number 34, this > operation would leave us with TWO records of rank #34, which > is what I'm > trying to avoid. Frank, Assuming that you know the PK (id field) of the record you just entered, then you can modify the query as such: UPDATE table SET rank = rank + 1 WHERE rank >= 33 AND id <> #theoneIjustentered# Easy nuff? <><><><><><><><><><> Joshua L. Olson WAE Tech Inc. http://www.waetech.com/ Phone: 706.210.0168 Fax: 413.812.4864 Monitor bandwidth usage on IIS6 in real-time: http://www.waetech.com/services/iisbm/ From mwarden at gmail.com Sat Aug 20 16:08:27 2005 From: mwarden at gmail.com (Matt Warden) Date: Sat, 20 Aug 2005 17:08:27 -0400 Subject: [thelist] Extending Javascript Objects In-Reply-To: <43077E01.6020109@bristav.se> References: <6d2fb30e050819033851771914@mail.gmail.com> <4305F5F9.8000503@digital-crew.com> <43077E01.6020109@bristav.se> Message-ID: <43079BCB.8060907@gmail.com> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 marcus wrote: > A question about the implentation: > > Since you are indeed using an Object as the a hash internally, aren't > you sort of speaking against yourself in this case? Yeah, that's true. Using Object is safer than using any of its subclasses. Still, if someone were to try to set add a property named '__foo__' to Object: Object.prototype.__foo__ = 'bar'; it would most certainly conflict with a key named 'foo' in the hashtable. If you have ideas in this regard, let me know. I was originally going to use parallel arrays, but I figured that the additional overhead would not be worth the benefit (which is avoiding a rare case). And, if one didn't think __key__ is enough, one could simply change the getKey method to use another name=>key mapping. Thanks, - -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFDB5vLAQ0d4HGyPE8RAgzkAJ0S+QEhohAKsxMHYGMziCFMlvcJhgCeNaCc LOzD1ebz5WlFbadNUgG7848= =9yCc -----END PGP SIGNATURE----- From lists at frankmarion.com Sun Aug 21 00:57:55 2005 From: lists at frankmarion.com (Frank) Date: Sun, 21 Aug 2005 01:57:55 -0400 Subject: [thelist] Interesting SQL Puzzle [SOLUTION] In-Reply-To: <43078E7F.3020309@neptunewebworks.com> References: <6.1.1.1.2.20050820105805.01f4ba18@127.0.0.1> <6.1.1.1.2.20050820130829.01fa6f88@127.0.0.1> <43078E7F.3020309@neptunewebworks.com> Message-ID: <6.1.1.1.2.20050821011756.01fa6e18@127.0.0.1> I've solved my problem, thank you all for your advice. I'll re-iterate it for the archives. I have a series of records (representing categories) that I want to rank numerically, with no gaps in the sequence of ranking orders and no collisions: I want to move a record from one position in a list to another, up, or down, in my case, with a select menu. Here are the basics of how I've accomplished it. The (MySQL) database looks something like this cat_id (pk) cat_name. cat_rank* parent_id** 133 Sir Anthony Caro 1 130 134 e.e. cummings 2 130 135 Eric Gill 3 130 * The rank is an unsigned INT, meaning no negative values allowed. * I use parent_id as a foreign key to a "parent" record, as this is being used in a hierarchical tree structure. The web page contains a form with a text field for the name (cat_name), a select menu populated with the contents of the rank field that ranges from 1 to MAX() for the query (form.cat_rank) and a hidden field with the current rank value of the record (form.current_rank). When I insert a record, the rank is always set to MAX() + 1. To do otherwise might most likely mess this whole scheme up. When I update my record, I perform the following (pseudo-code) NOTE that when INCREASING the rank we ADD 1 to each record from LOWEST to HIGHEST then move the desired record with a second update. So, to move from position 10 in the list to position 1, we add 1 to records whose rank is 1 to 9 (1+1=2, 5+1=6, 9+1=10) then we take the pk of our one record to move and set it's rank to what we've chosen in our select menu. When DECREASING the rank, we SUBSTRACT1 from each record from the HIGHEST to the LOWEST them move our desired record with a second update. So, to move from position 1 in the list to position 10, we subtract one from 10 to 2 (10-1=9, 5-1=4, 2-1=1) the we take the pk of our one record to move and make a separate and specific update. Remember that MySQL's BETWEEN clause is INCLUSIVE, that means that BETWEEN 1 AND 10 includes all 10 numbers, NOT 2 to 9. To work around this, when I use the BETWEEN operator, when I increase the rank, I increase between 1 and my select menu value MINUS 1, because each number is being updated with +1. If I did not do this, I would end up with an 11. The reverse also applies, when decreasing a rank I substract 1 from my current rank, otherwise I might end up with a zero or negative number at the beginning of my list. ------------------------------------------------------------------------------------------------------ // [1] if there's a change in rank (no point in updating if rank remains the same) if cat_rank != current_rank { // [2] Raise the rank (from 10 to 1, for example) if form.current_rank GT form.cat_rank { // Add 1 to each number between the lowest and the highest (except the one to change UPDATE categories SET cat_rank = cat_rank + 1 WHERE cat_rank BETWEEN (#form.cat_rank#) AND (#form.current_rank# -1) AND parent_id = #form.parent_id#; // Change the rank of the one we want to what we want UPDATE categories SET cat_rank = #form.cat_rank# WHERE cat_id = #form.cat_id#; // [2] Else, lower the rank (from 1 to 10, for example) } cfelse { // Add 1 to each number between the lowest and the highest (except the one to change) UPDATE categories SET cat_rank = cat_rank - 1 WHERE cat_rank BETWEEN (#form.current_rank# +1) AND (#form.cat_rank#) AND parent_id = #form.parent_id#; // Change the rank of the one we want to what we want UPDATE categories SET cat_rank = #form.cat_rank# WHERE cat_id = #form.cat_id#; //[2] End if } // [1] end if } ------------------------------------------------------------------------------------------------------ In the end, I used this in conjuction with a hiearchical tree, so now I can reorder my levels, or within any level, because my query is constrained by the parent_id. I look forward to any efficiencies or elegances that you may come up with. Frank Marion lists at frankmarion.com Keep the signal high. From jeffery.to at gmail.com Sun Aug 21 01:27:08 2005 From: jeffery.to at gmail.com (Jeffery To) Date: Sun, 21 Aug 2005 14:27:08 +0800 Subject: [thelist] Extending Javascript Objects In-Reply-To: <43079BCB.8060907@gmail.com> References: <6d2fb30e050819033851771914@mail.gmail.com> <4305F5F9.8000503@digital-crew.com> <43077E01.6020109@bristav.se> <43079BCB.8060907@gmail.com> Message-ID: On 8/21/05, Matt Warden wrote: > Yeah, that's true. Using Object is safer than using any of its > subclasses. Still, if someone were to try to set add a property named > '__foo__' to Object: > > Object.prototype.__foo__ = 'bar'; > > it would most certainly conflict with a key named 'foo' in the hashtable. You can avoid getting properties from the Object prototype by using hasOwnProperty(). For example in SimpleHashtable_get(): var val = (this._data[key] && this._data.hasOwnProperty(key)) ? this._data[key] : null; In fact, unless I'm mistaken, it should be safe to extend the Object prototype if you always test with hasOwnProperty() before trusting a property. For instance: for (var i in obj) { if (obj.hasOwnProperty(i)) { /* do things */ } } There are a few caveats with hasOwnProperty(): 1) DOM elements in IE don't contain this method, but extended properties in the Object prototype aren't inherited by DOM elements in IE anyway; 2) hasOwnProperty() isn't supported in IE 5.0 [1], Safari [2] and Mac IE 5.2 [2]. I've been working on a replacement function, but I'm not bold enough to let anyone see it before I clean it up a bit. Jeff [1] http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/js56jsmthhasownproperty.asp [2] http://phrogz.net/JS/hasOwnProperty.html -- Jeffery To www.thingsthemselves.com From dwain.alford at gmail.com Sun Aug 21 05:33:02 2005 From: dwain.alford at gmail.com (dwain alford) Date: Sun, 21 Aug 2005 05:33:02 -0500 Subject: [thelist] stink emails Message-ID: <4308585E.2080404@gmail.com> well i thought it would never happen to me, but someone hijacked my dwain at alforddesigngroup.com account and is sending out a virus. dwain -- Dwain Alford dwain.alford at gmail.com http://www.alforddesigngroup.com The Teacher answered: "There is no sin." 'The Gospel of Mary of Magdala' From Chris at globet.com Sun Aug 21 07:31:32 2005 From: Chris at globet.com (Chris at globet.com) Date: Sun, 21 Aug 2005 13:31:32 +0100 Subject: [thelist] Hierarchical SQL query Message-ID: All I am working with SQL Server 2000. I have a table Users as follows: -------------------------- | UserId (PK) | ParentID | -------------------------- I have a table Transactions as follows: -------------------------------------------------------- | TransactionID (PK) | UserID (FK) | TransactionAmount | -------------------------------------------------------- There is a recursive relationship within the Users table, whereby some users are parents to other users (ParentID = UserId of parent user) within the hierarchy thus: User1 | -------------- | | User2 User3 | | ------- ------- | | | | User4 User5 User6 User7 ONLY the users at the bottom of the tree may have transactions in the Transactions table. I need to write a query that will give me the sum of all transactions for all users at the bottom of the tree for each user NOT at the bottom of the tree. So: in the diagram above the value returned for User1 would be the sum of all transaction amounts in the Transactions table for User4, User5, User6 and User7. The value returned for User2 would be the sum of all transaction amounts in the Transactions table for User4 and User5, and the value returned for User2 would be the sum of all transaction amounts in the Transactions table for User6 and User7. I also need to write a query that does the same, but ONLY for the users at the top of the tree. Thus, the only record returned for the diagram above would be for User1. I would imagine that once I have the first query sorted out, the second will be fairly trivial to implement as a modification of the first. I am becoming increasingly frustrated, so any pointers as to technique would be most appreciated. Chris Marsh Web Developer http://www.globet.com/ Tel: +44 20 8246 4804 Ext 828 Fax: +44 20 8246 4808 Any opinions expressed in this email are those of the individual and not necessarily the Company. This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential and privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. From harvester at lists.evolt.org Sun Aug 21 18:00:06 2005 From: harvester at lists.evolt.org (harvester at lists.evolt.org) Date: 21 Aug 2005 23:00:06 -0000 Subject: [thelist] Tip Harvest for the Week of Monday Aug 15, 2005 Message-ID: <20050821230006.32181.qmail@acornparenting.org> The tip harvest for the Week of Monday Aug 15, 2005 has been added to the lists.evolt.org site. Get it at: http://lists.evolt.org/harvest/show.cgi?w=20050815 Week at a glance listing at: http://lists.evolt.org/harvest/week.cgi?w=20050815 Harvest Summary --------------- Number of messages: 29 Number of tips : Tip Authors ----------- Tip Types ---------