00:01:21 loggy has joined #openacs 00:01:21 topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/ 00:01:21 Users on #openacs: loggy ASwartz davb yanni til docwolf foonatz shagster chump strainmaker2 abbaJ rbm 00:01:22 This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog 00:02:34 ASwartz is now known as AaronSw 00:19:11 I should probably whip up some docs for the categorization I hacked into Edit-This-Page... 00:19:35 jabba_ has joined #openacs 00:20:03 abbaJ has quit 00:27:20 til has quit 00:43:10 davb has quit 00:48:08 jabba__ has joined #openacs 00:48:42 jabba_ has quit 00:56:36 davb has joined #openacs 01:01:23 Psychephylax has joined #openacs 01:01:35 man I'm tired 01:01:39 * Psychephylax pokes dave in the eye with a banana 01:02:38 davb has quit 01:02:44 muahahaha 01:04:56 davb has joined #openacs 01:05:04 * Psychephylax trips dave up 01:06:09 woooaaaahhhhh!!!!!! 01:06:26 ? 01:08:26 what did I miss in the last 2 days>/ 01:09:50 not much 01:10:04 figures ;) 01:10:09 I had fun though 01:10:13 2 day XML seminar 01:10:21 same old stuff. some bugs in the CVS are fixed. 01:10:26 cool 01:10:35 Beta coming soon? :) 01:12:30 Alpha is planned for next week I believe. So after that is beta. 01:12:36 Like 2 weeks I think. 01:12:47 wooohooo 01:13:02 heh, my databases professor made stupid mistakes 01:13:26 He's not consistent in telling us if the book is allowed to have multiple copies in the system 01:13:36 He should hang out with rbm's professor. 01:14:09 And the search, assuming there are no copies, does not require the ID since it's probably going to be the primary key 01:14:28 i mean, if you know the ID, why would you need title, author or year? 01:14:34 the id binds to only one book 01:15:25 if the id on the title or the edition (ie paperback, hardcover, etc...) 01:15:43 they would have different ids 01:15:48 Again, he's not consistent 01:16:04 If a book is allowed to have multiple copies even then it's not needed 01:16:27 Say you have 1- bible 2-koran 3-Torah 01:16:51 If you're going to search for a book, why would you enter 1 for Id and bibl to find the bible? 01:17:27 I would assume the user does NOT know the book id and has to find it by author for example 01:17:54 of course. ids should not be exposed to the user. 01:18:01 Exactly 01:18:01 causes all kinds of problems. 01:18:08 this whole database is based on the book_id 01:18:17 here 01:18:31 look at this--> http://www.cs.sunysb.edu/~cse305/project.html 01:18:39 Well do it right, and explain it to him if he says its wrong. 01:18:43 If you read it, read it carefully 01:19:07 Again, this is why I am going to Empire State College where I get to decide what I will learn and how. 01:19:08 Well, this is just prototype GUI and a manual 01:19:48 Well, it's not the problem of what and where...it's just that he had it right in the beginning 01:20:07 then he decided to be funny and add all these constraints that invalidated the system he had right in the first place 01:20:16 Oh wait, its a library. Yeah EACH book has to have a unqiue id otherwise you won't know if its in or not. 01:20:24 If you have 5 copies, they have to be unique. 01:20:26 Right 01:20:32 But what I'm saying is 01:20:52 When YOU (as a user) go to the library, do you know what book id is assigned to Learn java in 21 days 01:20:55 no 01:21:06 So, I don't understand why that's even a field in the search 01:22:51 I think its the patron id (i hope) he's referring to. 01:23:11 Why would you need that? 01:23:18 the system knows it upon your login 01:23:42 capiche? 01:24:32 Well it says the interface has to remember the id, not necessarily tell the user what it is. So that once you are logged in it remembers it for every query. 01:24:50 Ok, do you want to know where to send the check? 01:24:52 exactly 01:25:00 huh? 01:25:14 My renumeration for doing your homework :) 01:25:23 you're not doing my homework 01:25:49 I see, you are just sharing the fun! 01:26:12 Yeah I know. 01:26:32 I should XML him to death for putting this up as a homework 01:26:44 Get used to it. It will prepare you for a real job. Actually you already know all about ill-defined specs don't you? :) 01:27:04 * Psychephylax nods, mumbles something about killing Roberto and Don 01:27:52 uhoh. Time to take a break I think :) 01:27:58 :) 01:28:06 I didn't get paid today....that's all 01:28:14 ick 01:28:16 brb 01:28:16 * Psychephylax mumbles something about murdering Jen 01:28:20 davb has quit 01:33:08 davb has joined #openacs 01:33:57 Here's another one 01:34:00 Paying a fine 01:34:07 Why enter a book id when you're paying a fine? 01:56:18 man i'm tired 01:56:21 tests tomorrow 01:56:24 pointless............ 01:57:29 sorry to hear that. 01:58:02 http://www.foxnews.com/story/0,2933,36218,00.html 01:58:02 E: http://www.foxnews.com/story/0,2933,36218,00.html from Psychephylax 01:58:15 E:| Bert - Henchman for Osama Bin Laden? 01:58:16 titled item E 01:58:29 E: Somewhat freaky, and funny at the same time 01:58:29 commented item E 02:00:43 Really weird. 02:00:49 ya 02:01:09 I have only seen that one photo though, so I still think its fake. 02:01:14 nah 02:01:15 hold on 02:01:37 either that or someone has a really wild sense of humor over there. 02:02:47 if the first one doesn't work 02:02:50 wow, that is incredible. 02:02:52 but you know, now that I look at it 02:03:06 The doctored picture....is actually a poster in the pictures 02:03:21 like 02:03:55 Camera took a shot of a poster held up by a kid in real life in that poster there's another poster with a (doctored Earnie) 02:05:08 I have to reboot. My Windows has gone insane... 02:05:12 davb has quit 02:08:13 davb has joined #openacs 02:08:18 windows 02:08:19 pshhhh 02:08:23 10:19PM up 78 days, 12:16, 1 user, load averages: 1.01, 1.01, 1.00 02:21:38 I gotta get a Mac to do graphics, then I will be 100% MS free 02:42:41 Graphics? 02:42:43 what kind? 02:42:51 You can probably use Photoshop 02:43:03 Or Macromedia tools (which I think are great) 02:43:07 mmm....acromedia 02:43:21 BLURB: Macromedia applications kick major ass 02:43:22 F: Macromedia applications kick major ass from Psychephylax 02:43:24 Yeah. Macromedia 02:43:30 Freehand and Fireworks. 02:43:32 moo 02:43:33 yeah 02:43:35 Plus photoshop. 02:43:36 Those kick ass 02:43:38 Hi rbm 02:43:43 żoom 02:43:58 Gimp is cool, but doesn't work the way I do. I do like the fact that you can script it. 02:44:05 i gotta learn how to do an upside down bang 02:44:13 yah 02:44:21 uh keep that off the channel please... 02:44:30 ever seen this: http://www.cooltext.com/ 02:44:45 keep what off the channel? 02:45:00 nevermind 02:45:19 my upside down characters mess up Loggy and chimp? 02:45:31 heh, read your comment. 02:45:39 oh 02:45:41 you sick puppy 02:45:43 Thats cool. I saw that a long time ago. 02:45:48 yeah 02:46:01 davb: It would very hard to make a tool that would work in every possible way that people do. 02:46:13 Roberto, you're so wrong 02:46:33 That doesn't help. If you tell me why, then I may start to believe. 02:46:38 Look at Microsoft..."You do it this way and only this way"...It managed to suit xxx million people 02:46:45 Of course. Anyway I like Gimp for gimpy stuff. But most of my graphics work better. 02:46:52 Only because they have no clue what they are missing. 02:46:58 i hear that 02:47:13 * Psychephylax imagines a world without Microsoft 02:47:15 Thats why people should learn to program. 02:47:32 SO that they know the computer is supposed to work for them, not the other way around. 02:47:32 Psychephylax: That's not making tools work on different ways. It's making them work one way (easy) and them forcing that unto people 02:47:40 Just think! 3rd World Hunger, homelessness, unemployment, tsunami and volcano eruptions will instantly be fixed 02:47:53 * rbm opens his new Mozart CD 02:47:55 If only microsoft didn't exist 02:48:09 Oh crap! Forgot that my CD-ROM is in another computer 02:48:17 d'oh! 02:48:25 SEe, 02:48:35 ack! 02:48:39 I can see Microsoft marketing their product by showing nude chicks on the boxes 02:48:40 I always have a spare. 02:48:42 * rbm goes to grab it 02:48:56 I make sure I have 2 cd-roms in every computer I have 02:49:04 THats why you shouldn't mix entertainement and PCs 02:49:24 brb. Gott turn the computer off to plug the CD in. 02:54:22 ugh 02:54:29 stupid Figure captions 02:55:48 docwolf has quit 02:57:42 Wow this is so cool. 02:58:18 In fireworks, you can paint and each bit of paint is an object which you can then, change the width, color, etc. 02:59:06 yeah 02:59:29 I don't recall, can Fireworks export in xml or svg yet? 03:01:56 apparently not. Maybe theres an update. 03:02:01 perhaps 03:02:05 soon it will 03:02:07 That would be cool. 03:02:22 yeah 03:02:29 03:02:37 arg 03:02:49 I can't think of any good things to describe in XML ;) 03:04:07 Web sites. (RSS) 03:04:39 The chump is available in a custom XML format and RSS 03:06:30 Eventually I want to be able to export an OpenACS site to a series of XML files. The content anyway, not the templates. 03:08:36 hmmm 03:08:47 my manual has a bunch of pics 03:08:51 it's 7 megs large 03:09:37 which one? 03:09:44 For my database 03:09:50 project thingie 03:10:07 geez it's only 11 I feel like it's 3 am 03:10:39 aha. 03:10:41 yeah. 03:10:42 * rbm is here 03:11:05 I have to finish these graphics before I go to sleep. I have only had like 2 months to work on them. 03:11:44 * rbm has homework to do 03:13:03 rbm, you going for your masters/phd? 03:21:02 * rbm laughs 03:21:19 ? 03:21:26 Psychephylax: No. Not yet at least. I'm getting my undergrad, finishing next semester :) 03:21:48 I plan on going on to a Masters if I find some way to pay for it. 03:21:51 heh 03:21:57 I'm gonna finish this semester 03:21:58 I hope 03:22:07 2 degrees in 3.5 years! woohoo! 03:22:15 My undergrad is being almost all paid by a scholarship (at least tuition), but I have nothing as of yet for the master.s 03:22:27 ah 03:22:30 What are you finishing? 03:22:47 Computer Science/Applied Math and Stats 03:23:14 Cool. Computer Science/Biology here. 03:23:21 Biology? lol 03:23:28 that's not very computer science related 03:23:39 Yep. I was in Medical School for 3.5 years in Brazil before coming to the U.S. 03:23:45 ah 03:23:47 How old you be? 03:23:50 25 03:23:52 * Psychephylax guesses 27 03:23:53 ah 03:23:55 so close hehe 03:24:17 * Psychephylax is 22 03:24:22 Just turned :) 03:24:27 * davb is old 03:24:30 heh 03:24:33 (30) 03:24:33 * Psychephylax guesses 37 03:24:36 oh 03:24:36 I would be 23, but I spent 2 years as a volunteer missionary down in Brazil. 03:24:36 heh 03:25:19 Yeah buy all I have are two associates degrees. 03:25:32 Psychephylax: I beat you though, 2 degrees in 3 years :-) 03:26:01 you cheated :) 03:26:13 you probably got a bunch of credits 03:26:20 I did :-) 03:26:21 ehehe 03:26:24 No fair 03:26:29 I only had 11 when i started 03:26:34 had I had 30 I would be done already 03:26:36 I think it's fair. Medical School was really tough. 03:26:48 so then you really finished in 6.5 :) 03:26:55 Yeah, I guess that's true. 03:27:06 'bout time I finish 03:27:10 of course then technically I finished in 4 03:27:18 almost time for me to start. 03:27:19 since i took a semester of College Chem in high school 03:27:26 and some AP credits from those stupid tests 03:27:41 * Psychephylax gives dave some popcorn 03:27:41 Hey oomloopy 03:27:51 * Psychephylax departs to get water 03:27:51 heh 03:28:06 * rbm lights Psychephylax on fire 03:28:19 Wow that Psychephylax really plans ahead 03:28:34 ouch ouch ouch! 03:28:36 Oh dear umloopy, lord of the diagrams and redundant diagrams, have mercy on us mere mortals 03:28:39 * Psychephylax pours the water on himself 03:28:54 rofl 03:28:57 UMLOOPY is the UML + OO god :-) 03:29:03 nice 03:29:11 You're doing UML now? 03:29:21 * rbm is taking a "Advanced Objected Oriented Development" class 03:29:44 Psychephylax: Yes. I had UML in this class and in a class I took last semester (Software Engineering) 03:29:54 What are you using for UML? 03:30:13 argh 03:30:29 hmmm 03:30:47 I didn;t name it, I'm just the designer. 03:31:03 ah 03:31:33 Yes. Object-oriented painting 03:50:18 rzolf has joined #openacs 03:50:49 rbm has quit 03:58:17 rzolf has quit 04:12:34 davb has quit 04:55:56 rzolf has joined #openacs 04:56:10 rzolf is now known as rzolf-san 04:57:59 rzolf-san has quit 05:03:15 foonatz has quit 05:10:35 rzolf has joined #openacs 05:24:21 rzolf has quit 05:43:00 jerryasher has joined #openacs 05:59:37 djg has joined #openacs 07:47:10 rzolf has joined #openacs 07:47:37 is it possible to alter a constraint on a postgres table without dropping the table? 08:09:10 I have found you can drop some constraints, but 08:09:19 I haven't figured out how to alter the constraing 08:09:31 or add a "new" constraint to an existing table. 08:11:30 i just did it the cheap and sleazy way 08:12:08 renamed column, added new column with same name as renamed column, with the right constraints. :-/ 08:12:37 i have to rebuild the whole database later anyway, but the client wants to see this change now. 08:16:26 oh yeah. 08:16:36 since you're the reservation guy ;-).... 08:17:24 what do i do, when the client decides they want to have a super user that can stuff more people into rooms that are available in the room? 08:29:04 rzolf has quit 08:51:12 jerryasher has quit 09:31:47 rzolf has joined #openacs 09:34:28 rzolf has quit 09:47:46 ola has joined #openacs 10:35:40 djg has quit 12:02:26 rzolf has joined #openacs 12:43:25 rzolf has quit 13:00:14 foonatz has joined #openacs 13:01:03 davb has joined #openacs 13:02:54 hi davb. 13:03:56 Hey ola. How's it going? 13:04:22 straight to hell! 13:05:20 Excellent. No point in delaying it ;) 13:06:09 I really have to add some content to my web site or something. My most frequent visitors are Google and Scooter, then myself. 13:06:21 I've got problems with bind vars and dynamic vars that also change in number from time to time. 13:06:29 Ack. That sounds evil. 13:06:50 it truly is. 13:06:51 I know about bind vars, but haven't tackled any dynamic queries yet. 13:07:13 ok. 13:07:19 One thing you can do to get it working is just use all Tcl variables $tclvar in the queries. 13:07:39 just make sure they are 'quoted'. 13:08:36 I can take a look at the query in you want. I will need to learn it anyway. Maybe another viewpoint will help. 13:08:56 sure. thanks! 13:09:28 I will try to explain first...hold on:-) 13:09:49 np, i'll be here all day... 13:12:16 http://www.treedragon.com/ged/map/ti/newOct01.htm#10oct01-resume 13:12:16 A: http://www.treedragon.com/ged/map/ti/newOct01.htm#10oct01-resume from davb 13:13:35 A:|David McCusker on writing better resumés 13:13:35 titled item A 13:13:42 A: for Psychephylax 13:13:42 commented item A 13:13:57 A: and anyone else. This is great advice explained clearly 13:13:57 commented item A 13:15:02 markd2 has joined #openacs 13:15:35 hi markd2. 13:15:45 hello markd2 13:17:27 hiya 13:21:33 pascal has joined #openacs 13:21:46 hello 13:22:14 yo 13:22:47 I am finaly getting back to openacs 4 - but forgot where I can find nsxml 13:23:41 http://acs-misc.sourceforge.net 13:23:41 B: http://acs-misc.sourceforge.net from davb 13:23:46 B:|ns_xml 1.4 13:23:46 titled item B 13:23:59 thx 13:24:06 np 13:33:50 alltelsucks has joined #openacs 13:34:02 markd2 has quit 13:34:12 alltelsucks is now known as markd2 13:38:07 are you ready, davb?;-) here we go: 13:38:23 there's a perl script that extracts info pairs from the mp3 file. 13:38:36 one problem is that the number of pairs are different for different mp3s 13:38:46 and since plpgsql doesn't handle default values I have to initialize all 13:39:01 the vars that can possibly belong to a mp3 to NULL 13:39:14 before the "foreach" loop sets the vars for the pairs that REALLY exist. 13:39:22 ok 13:39:46 and then......I reference ALL the vars separately in the postgresql.xql file for mp3__new, (with some vars preset to NULL). 13:39:59 should I reference the vars as bind vars or regular vars? 13:40:09 then you do the hokey-pokey, and turn yourself around 13:40:12 that's what it's all about 13:40:38 probably bind vars. They all exist before you call the query so that should be ok. 13:41:16 so its like this? SET A NULL SET B NULL SET C NULL 13:41:28 yes 13:41:36 then you grab the info from the MP3 and enter the data into the appropriate vars? 13:41:46 right 13:42:39 then mp3__new ( :A, :B, :C ) should work. Is the potential set of vars always the same? That is, is it a fixed set of information where some of the pieces may not be set? 13:44:50 well, some vars may be left out in certain mp3s, but may exist in others. so yes there's a fixed number of total vars. 13:45:27 now, NULL is quoted if I use bind vars. 13:45:36 not so good. 13:45:55 hmmmm... that should not confuse Postgresql. 13:46:23 I thought that was causing an error last week, but it was something else. 13:46:31 I think it does... 13:46:46 ok 13:48:31 try using an empty string. The bind var converts them to NULL 13:48:59 if you want to insert an empty string I think you need to do set var "''" 13:49:16 lemme try. 13:59:41 rzolf has joined #openacs 13:59:41 ugh 14:00:55 you said it 14:12:54 rzolf has quit 14:15:31 hmm... I get this when initializing to "" (sorry about the pollution): 14:15:34 [11/Oct/2001:18:04:50][835.142341][-conn11-] Notice: dbinit: sql(localhost::openacs4): 'create function __exec_69_add_mp3 () returns varchar as ' 14:15:34 14:15:34 begin 14:15:34 select mp3__new( 14:15:34 ''7246'', 14:15:35 ''hr644.mp3'', 14:15:37 ''Track 12'', 14:15:39 null, 14:15:41 ''128'', 14:15:43 ''Dillinger Four V.god'', 14:15:45 ''12'', 14:15:47 null, 14:15:49 null, 14:15:51 ''3'', 14:15:53 ''f'', 14:15:55 ''1'', 14:15:57 ''1'', 14:15:59 ''t'', 14:16:01 ''44.1'', 14:16:03 ''2'' 14:16:05 ); 14:16:07