00:01:42 loggy has joined #openacs 00:01:42 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 00:01:42 Users on #openacs: loggy abbaJ davb rbm AaronSw Psychephylax shagster chump 00:01:43 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 00:48:59 greetings 00:49:02 * Psychephylax pokes dave 01:15:56 AaronSw has quit 01:22:06 hey! 01:32:34 AaronSw has joined #openacs 01:47:00 http://www.bris.ac.uk/ISC/cms/ttw.html 01:47:00 B: http://www.bris.ac.uk/ISC/cms/ttw.html from davb 01:47:19 B:|List of web-based WYSIWYG Editors 01:47:20 titled item B 01:51:08 http://www.labour.org.uk/lp/new/labour/docs/LONGSPEECHES/TBCONF2001SPEECH.html 01:51:08 C: http://www.labour.org.uk/lp/new/labour/docs/LONGSPEECHES/TBCONF2001SPEECH.html from davb 01:51:29 C:|Transcript of Tony Blair's Speech 01:51:29 titled item C 01:51:38 about what? 01:53:21 I didn't read the whole thing. About 9-11 and what we should do. 01:55:52 heh 01:55:54 dave is awake 01:56:52 Not just about that, but really how it all ties in with how the world is changing and we have to wake up because it's not going to stop. 01:57:52 I'm working on my resume 01:58:00 Have to describe what my project is all about 01:58:38 Somehow "Bugging dave and mark on IRC to get tips on how to structure my program" is not the right thing to write down :/ 01:59:26 Hey we just helped you with the syntax. You learned the system and build extensions. You took a web-based application toolkit and customized it. 02:00:08 But do I really know the system? 02:01:38 i can't even write a damn resume lol 02:02:09 You know more than alot of us. I haven't actually used the system yet. 02:06:25 that's impossible 02:07:49 ·Development of a support tool for the Customer Service and Technical Support Groups of Cablevision. The tool is based on the ArsDigita Community System with a custom data model and user interface as well as additional functionality incorporated into the system through the use of TCL and AOLServer. 02:08:38 cool. 02:08:43 gonna add more stuph 02:09:33 tell what the "added functionality" is. 02:10:13 Beautiful 02:10:16 ·Development of a support tool for the Customer Service and Technical Support Groups of Cablevision. The tool is based on the ArsDigita Community System with a custom data model and user interface as well as additional functionality that allows for cable modem queries incorporated into the system through the use of SNMP, TCL and AOLServer. Upon completion the tool will support approximately a million subscribers of broadband cable servi 02:10:46 good. 02:11:08 davb has changed the topic to: Welcome to the OpenACS based resume enhancement channel 02:11:13 rofl 02:11:19 can anyone change the topic? 02:11:56 yeah. I guess so. 02:12:22 Psychephylax has changed the topic to: Welcome to the OpenACS based resume enhancement channel, soon to be an OACS module 02:12:26 rofl 02:12:48 Cool! I'll tell Don you signed up to work on it 02:13:12 hehehehe 02:15:48 Oh 02:15:51 I might not be around tomorrow 02:16:01 I think they want me to rebuild a server rack 02:17:11 is that good or bad? 02:18:33 Good because i get to do something different 02:18:44 bad because it sounds like a lot of work I probably won't want to do :P 02:18:52 I hear it involves crimpers and stuph 02:19:05 moo 02:19:21 żoom 02:19:49 heh, someones gotta do it. Thats what I do at work now. The network admin has me do all the work he doesn't want to do. 02:22:08 hehehe 02:23:56 ok 02:24:04 Who's up for looking at my resumee 02:28:15 Anyone? 02:30:38 puhleeeeeze? 02:30:40 dave? 02:39:44 heh 02:46:39 Roberto? wanna seeeeee? :) 02:52:18 where is it? 02:52:32 umm http://www.neverhere.com:1085/resume2.pdf 02:52:39 lol 02:52:41 " 02:52:47 "twain assisted data entry" 02:52:54 sounds a lot better than "scan monkey" lol 02:55:54 ack pdf. I don't know if I am equipped to handle that. 02:56:10 heh 02:56:13 What formad you want 02:56:34 Probably plain text or html. 02:57:27 ugh 02:57:39 html or text always mess up the formatting 02:58:05 hmmm.... Really? Most places only want text resumes by email these days. 03:01:26 I have ghostscript. does that do pdf? 03:01:55 umm 03:01:56 not sure 03:02:18 most take word or pdf too 03:04:40 cool. 03:05:02 I got it. gs filename x11 03:06:45 You gotta do something with the twain-assisted thing. Noone who is hiring for the type of position you are looking for is gonna be fooled by that one. Unless they have a really good sense of humor. 03:11:29 Good luck. I have to go though. 03:11:44 davb has quit 05:58:18 abbaJ has quit 06:00:36 abbaJ has joined #openacs 08:34:49 ola has joined #openacs 09:47:16 sinaptico has joined #openacs 09:48:07 sinaptico has left #openacs 10:59:50 ola has quit 11:06:53 ola has joined #openacs 11:24:38 davb has joined #OpenACS 11:25:42 davb has changed the topic to: Welcome to the OpenACS helpline http://openacs.org 11:26:01 morning. 11:26:06 Hi 11:27:34 hmm...I'm trying to open up a shell in emacs so I can do "tail -f"... 11:29:03 M-x shell 11:30:02 thanks. 11:31:37 np 11:31:41 davb has quit 12:00:36 davb has joined #openacs 12:03:50 Psychephylax has quit 12:40:46 dave, when I disable or delete my package from the admin pages, will the system execute the drop script? 12:41:17 It will try. 12:41:35 I am not sure about disable, delete runs it. 12:42:17 ok. 12:43:15 everything installed without errors the first time I tried. I find that hard to believe.. 12:54:30 grr. "database support" only shows oracle8. 13:10:17 hmmmmm 13:10:39 i wonder if that is specified in the .info file 13:13:40 postgresql is specified, but not the sql/postgresql/package-create.sql , the drop file and so on... 13:14:21 perhaps I need to "Manage File Information" and "Scan for new files" first? 13:15:42 see, I haven't edited the info file at all. 13:17:48 sorry to bug you like this, dave;-) 13:22:37 np 13:22:49 i am not sure. try it 13:34:09 that was it. now I'm beginning to see some errors. 13:51:00 markd2 has joined #openacs 13:51:39 cool! that means you are making progress. 13:51:51 progress is good 13:52:00 I was always happy to get a new error. it meant the old one was fixed. 13:53:11 or introduced a brand new one :-) 13:53:18 * markd2 is feeling particularly cynical this morning 13:56:05 heh, i did that too! 13:57:58 markd2: it promises well. 13:58:21 you feeling x-tra cynical, that is:-) 14:01:50 heh 14:37:48 what is wrong with the following view: 14:37:58 create view mp3_mp3_playlist_map_view as 14:37:58 select m.mp3_id, 14:37:58 m.playlist_id, 14:37:58 m.sort_key, 14:37:58 coalesce(v.total,0) as total 14:37:59 from mp3_mp3_playlist_map m 14:38:01 left join (select mp3_id, 14:38:03 playlist_id, 14:38:05 sum(vote) as total 14:38:07 from mp3_votes 14:38:09 group by mp3_id, playlist_id) v 14:38:11 using (mp3_id) 14:38:13 left join v using (playlist_id); 14:38:23 I get: ERROR: Relation 'v' does not exist 14:39:03 the original view looks like this: 14:39:25 create or replace view mp3_mp3_playlist_map_view as 14:39:25 select m.mp3_id, 14:39:25 m.playlist_id, 14:39:25 m.sort_key, 14:39:25 nvl(v.total,0) as total 14:39:26 from mp3_mp3_playlist_map m, 14:39:28 (select mp3_id, 14:39:30 playlist_id, 14:39:32 sum(vote) as total 14:39:34 from mp3_votes 14:39:36 group by mp3_id, playlist_id) v 14:39:38 where m.mp3_id = v.mp3_id (+) 14:39:40 and m.playlist_id = v.playlist_id (+); 14:41:17 ack! I just entered a password into my windows machine by accident. I don't know what it is... 14:41:34 it's probably stored in cleartext in several files 14:41:45 i am not sure about the join syntax... 14:41:51 markd2: i am sure... 14:43:38 Psychephylax has joined #openacs 14:43:46 morning 14:44:58 hi 14:45:26 markd2 has quit 14:49:45 :) 14:50:38 lets seee...where was I 14:50:53 I'm getting moved again 14:51:47 oh...Dave, what do you think I should replace my "Twain assisted data entry" with...ehehe 14:52:27 no idea 14:52:41 ola: looks like you are missing a ( somewhere in there 14:52:43 brb 14:52:50 davb has quit 14:53:06 davb has joined #OpenACS 14:54:09 never mind about the ( 14:54:28 :) 15:00:23 i guess I need a custom search page now 15:01:39 fun! 15:01:53 Well 15:01:57 maybe I can hack this one 15:02:15 it just has to go find a person by e-mail address 15:03:36 That is definitely in ACS already. 15:04:36 yep 15:04:45 I just have to figure out what the hell %5 represents 15:04:49 I know %20 is a space 15:06:10 my bad 15:06:13 it's %5F 15:06:54 ola: try this 15:06:58 left join ( 15:06:58 select mp3_id, 15:06:58 playlist_id, 15:06:58 sum(vote) as total 15:06:58 from mp3_vots 15:06:59 group by mp3_id, playlist_id ) v 15:07:01 on (m.mp3_id = v.mp3_id and 15:07:03 m.playlist_id = v.playlist_id ) 15:07:04 aha 15:07:12 %5F is an underscore 15:07:34 I am just winging it though. 15:08:09 http://www.blooberry.com/indexdot/html/topics/urlencoding.htm 15:08:09 A: http://www.blooberry.com/indexdot/html/topics/urlencoding.htm from Psychephylax 15:08:20 A:| All you ever wanted to know about URL Encoding 15:08:20 titled item A 15:08:22 B 15:08:39 Psychephylax: OpenACS/AOLserver does url encoding for you. 15:08:39 A: Now with it's own converter! 15:08:39 commented item A 15:11:22 I know 15:11:25 I'm trying decode it! 15:11:27 lol 15:12:36 for fun? ad_page_contract should stuff the URL variables into Tcl variables for you 15:12:40 :) 15:13:20 no 15:13:38 I'm trying to search for an email by manually passing it parameters in a URL 15:13:58 Instead of coding the page first and then finding out that it doesn't work I'd much rather try the search manually first 15:14:22 And it searches for everyone still even though I tell it to find people with specific email 15:17:01 dont you need something like this: select * from users where email = :email_passed_in_form_variable 15:17:25 How many users will you have? If its not too many a drop down box might be better. 15:17:54 it'll be many 15:18:05 Ok, so thats a bad idea. 15:18:34 we are assuming the user knows the exact email address? 15:18:55 yeah 15:19:08 of course knowing my boss that will change once i mention this to him 15:19:14 heh 15:19:17 What fun! 15:19:30 not really 15:19:37 I think I'll use this Quick search thing 15:19:46 it seems to use keywords and can find multiple things 15:20:50 cool. 15:21:33 now I just have to figure out how it works 15:21:33 shagster has quit 15:21:34 lol 15:22:14 aha 15:22:16 it calls search 15:22:37 my package is gonna be huuuge 15:22:48 cuz I'm duplicating all the stuff 15:24:40 davb: thanks! it works. 15:24:42 yeah but your package is really "the system" 15:24:50 shagster has joined #openacs 15:25:17 ola! I can't believe it. what luck. Maybe one day I'll actually understand what all the stuff means. I copied off a join DanW helped me port. 15:25:25 lol 15:25:38 I rule 15:26:54 actually..."Eureka!" :) 15:28:06 davb: cool! 15:32:45 muahaha 15:32:50 unfortunately I posted to the forum before... 15:33:29 hi psyche! 15:33:29 shagster has quit 15:33:34 So post back 15:33:37 Hi Ola 15:33:55 Post back with a solution to your problem this way if someone has a similar problem they might learn 15:34:09 there should be an "unpost" option. 15:34:43 shagster has joined #openacs 15:35:06 yes sir, but I want to wait out other possible solutions first:-) 15:36:40 Well 15:36:47 maybe not unpost but definetly an "edit" 15:37:45 shagster has quit 15:38:08 two replies already... 15:38:14 cool 15:38:44 shagster has joined #openacs 15:40:15 shagster has quit 15:40:44 shagster has joined #openacs 15:41:42 ola: There is a difference between ON and USING 15:41:56 but I have no idea what or if it matters for that query 15:43:48 alrighty! 15:44:10 hmmm 15:44:14 this won't be fun 15:44:18 of course not! 15:45:12 no, I have to figure out how to make it so that only the people who you work for and you can edit your information 15:45:49 that is a privilege (write) and a permission I think 15:47:00 davb: both ways are fine but USING is less code. 15:47:16 Interesting. 15:47:57 see Don's and Gilbert's replys. 15:48:11 replies 15:49:13 ON a.blah = b.blah apparently is the same as using ( blah) with on you have to specify which column matches in each table so they could have different name. Using they have to have the same name. 15:49:14 hmm 15:49:15 ok, I got a question 15:49:29 thats my new thing I learned today. 15:49:54 and this : " A side-effect of both 15:49:54 USING and NATURAL is that only one copy of each joined column is emitted into the result table (compare the 15:49:54 relational-algebra definition of JOIN, shown earlier). 15:49:54 " 15:51:14 coolio 15:51:56 This is more of a double check 15:52:12 if I want to pass a variable from page A to page C 15:52:23 wher A links to B first and B goes to C 15:52:24 You just do the ad_permission_p on both pages. 15:52:29 davb: on is good if the tables uses different keys 15:52:31 I have to page_contract the variable in B 15:52:37 and then pass it into C from B again? 15:52:47 Thats what edit-this-page does. 15:53:03 A and B are ADP pages? 15:53:12 A,B,C are all ADP pages 15:53:16 you need something like form_vars 15:53:26 they're not form vars 15:53:29 you set form_vars in the TCL scripts. 15:53:29 shagster has quit 15:53:35 I have a user clicking on add or remove links for a user 15:53:52 the you do @form_vars@ in the ADP page. It encodes them as hidden form fields 15:53:53 I mean edit/remove 15:54:06 They're already hidden sorta 15:54:15 If the user hits edit I don't want the "delete" link showing up 15:54:23 if he hits delete I don't want the edit 15:54:45 shagster has joined #openacs 15:54:47 Oh. Ok. So the TCL page checks and sets a variable say display_edit_link 15:54:55 then check for it in the ADP template. 15:54:57 yes 15:55:14 and you want to pass that around between the pages? 15:55:20 but that page is like 3 pages inward from the page where you click on "edit/remove" 15:55:27 hmmmm... 15:55:30 so each page has to keep the state 15:55:35 Hang on 15:55:39 lemme try my idea :) 15:56:20 ok 15:57:12 Since you claim I know ACS now I should be able to figure it out 15:57:13 hehehe 15:58:00 rbm has quit 16:02:13 vinod has joined #openacs 16:02:46 heh 16:02:52 Hi vinod! 16:03:00 hey dave! 16:03:15 what's new? 16:03:26 Hey vinod! 16:03:42 Not much. Sick kids all week so I had to stay home and haven't got much work done. 16:03:46 hey Psychephylax! 16:03:50 bummer 16:04:00 Arthur's Preschool and Tonka Construction don't run in Linux. 16:04:11 :-) 16:04:13 ..yet 16:04:21 Hey, stupid question 16:04:25 in a page contract 16:04:35 I have the decode block listen for a "action" 16:04:51 can it also have a property to return to adp of "action" or is that a scope problem? 16:05:36 Don't know. Try it. If ad_page_contract doesn't like it, it will tell you. 16:05:46 ok 16:06:05 It should be OK. if action is defined. you should be able to change the value in the tcl code if you need to. 16:06:54 markd2 has joined #openacs 16:07:02 hmmm 16:07:04 Hey Mark 16:07:11 does "acs_object_type__drop_type" take two arguments. if so, what are the second for? 16:07:53 Psychephylax: see how easy it is to make it look like I actually know what I am talking about when I really am totally clueless! 16:07:54 can't find it in the api-browser. 16:07:55 hiya 16:08:08 hmmm. 16:08:37 same here, not in the API 16:09:15 uhmmm 16:09:20 ola: it's a cascade parameter. if 't', it's supposed to drop all types which are dependent on it (i think) 16:10:34 although looking at the code, it's completely ignored... (defined in packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 16:10:57 On the API browser go to acs-kernel then SQL files. You can search through the code to see how it really works. 16:11:39 thanks vinod and dave! 16:11:51 aD planned ahead. That is why there are so many 46 parameter functions. 16:11:53 oooh. vinod is in the haus too 16:11:58 shouldn't you be out saving lives, or something like that? 16:12:11 vinod: you missed the outer join! 16:12:26 should, shouldn't - those are all very subjective terms 16:12:39 ugh - i hate outer joins :-) 16:12:41 subjunctive, too 16:12:49 help! I've got subjunctivitis! 16:13:01 hey, don't go grammar-school on me 16:13:06 w00t 16:13:48 vinod hates outer joins. then how does the rest of us feel about them;-) 16:14:13 haha - well, i love them once they're ported 16:14:20 haha 16:15:07 so mark, how's java treating ya? 16:16:01 i could use some java right about now 16:16:13 the project I was on fell through 16:16:21 doh! sorry to hear that 16:16:30 worked out best for both parties 16:16:45 so I'm taking advantage of my "on the bench time" do get more oracle studliness 16:16:56 hehe 16:16:57 Right now I'm reading a wacky book on Backup & Recovery 16:16:58 Oh 16:17:07 I had a test on Databases yesterday 16:17:14 THere is WHOLE book on backup? 16:17:27 There's like 2 paragraphs for Postgresql. 16:17:28 My oracle l33tness helped me I think 16:17:29 this one is 688 pages 16:18:10 We had to draw an E-R diagram of items with like 5 properties and a relation stored and another entity shelf which had 2 properties 16:18:16 Ah, a small Oracle book. 16:18:17 Then convert that to a schema 16:18:26 yeah. with large type 16:18:34 I am not sure if my syntax was correct 16:19:20 did you use boxes and lines? 16:20:17 yes 16:20:17 and ovals 16:20:24 Well, not for the schema 16:20:32 cuz he wanted us to create tables out of tose 16:20:43 Is this valid 16:20:47 oooh.. ovals 16:20:54 the sophisticated ER tools 16:21:08 I dropped out before we hit the parallelograms 16:21:09 * markd2 shudders 16:21:10 constraint validshelf check (size=100 OR size=150) 16:21:21 I think those are for the transverse normal form 16:21:36 parallelograms are relations :P 16:22:59 hmmm 16:23:00 I see 16:23:05 passthrough_parameters 16:23:09 Need to figure out what this does 16:37:58 john has joined #openacs 16:38:43