IRC log of openacs on 2001-10-03
Timestamps are in UTC.
- 02:08:13 [loggy]
- loggy has joined #openacs
- 02:08:13 [niven.openprojects.net]
- topic is: Welcome to the OpenACS Helpline | http://www.openacs.org/
- 02:08:13 [niven.openprojects.net]
- Users on #openacs: loggy rzolf davb ola shagster AaronSw rbm Psychephylax chump
- 02:08:13 [ChanServ]
- This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
- 02:09:10 [abbaJ]
- abbaJ has joined #openacs
- 02:09:47 [rzolf]
- rzolf has quit
- 05:40:45 [rbm]
- rbm has quit
- 05:40:46 [rbm]
- rbm has joined #openacs
- 06:33:55 [davb]
- davb has quit
- 06:54:36 [rzolf]
- rzolf has joined #openacs
- 07:13:41 [rzolf]
- rzolf has quit
- 08:45:16 [jerryasher]
- jerryasher has joined #openacs
- 08:45:35 [jerryasher]
- Hey ola, are you around?
- 08:51:11 [ola]
- yes, hi.
- 08:51:32 [jerryasher]
- Was that you ten minutes ago poking around my blog module?
- 08:51:41 [ola]
- I'm looking at your blog. nice!
- 08:52:07 [jerryasher]
- Yeah, I was just finishing debugging it, and you came through.
- 08:52:58 [jerryasher]
- The plan for tomorrow is to build some templates for it and then to package it up.
- 08:53:16 [ola]
- cool.
- 08:53:26 [jerryasher]
- Did you hear Tony Blair's speech today?
- 08:53:44 [ola]
- no. what did he say?
- 08:54:09 [jerryasher]
- I've never really heard him speak before. Just the usual views in the U.S. that he
- 08:54:13 [jerryasher]
- was pretty good friends with Bill.
- 08:54:27 [jerryasher]
- But today he gave one of the best speeches I've ever heard
- 08:54:50 [jerryasher]
- Good not just for its content (on the WTC attacks), but just a
- 08:55:06 [jerryasher]
- wonderfully spoken speech.
- 08:55:20 [jerryasher]
- I've been trying to find a link to a video of it but cannot.
- 08:55:46 [ola]
- you mean that lovely Oxford english...?:-)
- 08:56:01 [jerryasher]
- Yes, that was certainly part of it, but not all of it.
- 08:56:21 [jerryasher]
- GWB for instance speaks neither like a Texan, nor like a Yalie.
- 08:56:43 [jerryasher]
- I always think GWB speaks like, a, uh, minister.
- 08:57:18 [jerryasher]
- But the content and tenor of Blairs speech was right on the mark.
- 08:58:31 [ola]
- well, somethings going to happen soon, I just hope they don't overreact.
- 08:59:03 [jerryasher]
- That was sort of what Blair was saying....
- 08:59:26 [jerryasher]
- I found a about two minutes of it over on MSNBC using Windows Media Player, but
- 08:59:49 [jerryasher]
- the ten minutes or so I heard was great. A very good mix of
- 09:00:17 [jerryasher]
- suggesting what should and should not be done, and why....
- 09:00:26 [jerryasher]
- (uh, as far as I was concerned.)
- 09:00:35 [jerryasher]
- Anyway, certainly much much better than "wanted dead or alive"
- 09:02:33 [jerryasher]
- Well, I gotta go and get up in 4 hours to take my girls to school, so I'll say goodnight.
- 09:02:46 [jerryasher]
- And thanks for taking a look at the blogs.
- 09:02:50 [jerryasher]
- bye.
- 09:02:59 [ola]
- I guess I'll hear it on the news today. I like the things I have herad lately from GWB, and US officials. try to make as many friends throughout the world as possible before action.
- 09:03:04 [ola]
- bye.
- 09:03:19 [jerryasher]
- jerryasher has quit
- 10:55:42 [ola]
- ola has quit
- 10:56:33 [ola]
- ola has joined #openacs
- 11:37:19 [rbm]
- rbm has quit
- 11:37:31 [rbm]
- rbm has joined #openacs
- 11:37:47 [shagster]
- shagster has quit
- 11:39:58 [shagster]
- shagster has joined #openacs
- 12:35:43 [davb]
- davb has joined #OpenACS
- 12:39:42 [ola]
- good morning, davb.
- 13:16:24 [markd2]
- markd2 has joined #openacs
- 13:18:15 [davb]
- Good morning/afternoon,etc
- 13:21:55 [markd2]
- * markd2 waves
- 13:39:45 [davb]
- argh!
- 13:39:56 [markd2]
- * markd2 unwaves
- 13:40:02 [davb]
- heh
- 13:40:19 [davb]
- The modifications I made to the CR have to be redone. No big deal.
- 13:42:25 [markd2]
- heh
- 13:42:35 [markd2]
- * markd2 is getting scolded by some wrens
- 13:42:47 [markd2]
- there's two birds out here that are giving me and the cat the what-for
- 13:42:56 [davb]
- You are working outside?
- 13:43:12 [davb]
- * davb needs 802.11b and a new laptop with a working keyboard
- 13:43:35 [markd2]
- yeah. We've got a nice little screene-enclosed porch
- 13:44:24 [davb]
- Neat.
- 13:44:35 [davb]
- * davb adds screened-porch to the list...
- 13:44:55 [Psychephylax]
- gah
- 13:45:01 [Psychephylax]
- I don't want to go to work
- 13:45:16 [ola]
- yes you do.
- 13:45:47 [markd2]
- work is good
- 13:45:54 [markd2]
- just think "infect the boss.. infect the boss"
- 13:46:00 [Psychephylax]
- Not with a slave driver who gets me sick for a boss :(
- 13:46:04 [Psychephylax]
- hmmm
- 13:46:07 [Psychephylax]
- Good idea mark
- 13:46:20 [Psychephylax]
- * Psychephylax searches for his bags of germinating germs
- 13:46:23 [markd2]
- * markd2 suggests anthrax-leprosy-mu
- 13:46:29 [Psychephylax]
- hmmmmmm
- 13:46:50 [Psychephylax]
- * Psychephylax gives up his search for germinating germs and invests his efforts into obtaining anthrax
- 13:47:24 [markd2]
- I think CD now has their albums
- 13:47:55 [Psychephylax]
- har har har
- 13:47:58 [Psychephylax]
- No cookie for you!
- 13:48:05 [markd2]
- no cookie for me :-(
- 13:48:09 [Psychephylax]
- * Psychephylax is the cookie nazi
- 13:48:21 [Psychephylax]
- That seinfeld episode was on last night
- 13:49:04 [Psychephylax]
- ping dslreports.com
- 13:49:06 [Psychephylax]
- arg
- 13:49:26 [markd2]
- 25.987 ms
- 13:49:38 [Psychephylax]
- interesting
- 13:50:01 [Psychephylax]
- their site is down though
- 13:50:03 [Psychephylax]
- I broke it
- 13:50:39 [ola]
- * ola needs a new laptop (and wonders if dell's any good)
- 13:50:52 [ola]
- inspiron 400 in particular..
- 13:50:58 [ola]
- inspiron 4000 in particular..
- 13:51:33 [Psychephylax]
- yah
- 13:51:36 [Psychephylax]
- Dell makes good laptops
- 13:51:47 [Psychephylax]
- most enterprises use dell
- 13:51:48 [ola]
- they do?
- 13:51:52 [ola]
- cool
- 13:51:53 [Psychephylax]
- yah
- 13:52:11 [Psychephylax]
- I know of at least 2 corporations and 1 university :)
- 13:52:26 [Psychephylax]
- Symbol, Cablevision and my school all use Dell laptops and/or workstations
- 13:52:35 [markd2]
- I know a couple folks with them - they're generally liked
- 13:52:41 [markd2]
- save for one guy that has a lemon
- 13:52:41 [Psychephylax]
- yeah
- 13:53:17 [Psychephylax]
- i want a laptop but I'm poor
- 13:53:22 [ola]
- It would be nice to run Linux without problems
- 13:54:07 [Psychephylax]
- one of my classmates I think had a dell (possibly an ibm) and he ran Suse on it
- 13:54:10 [markd2]
- any local Linux Users Groups around you?
- 13:54:28 [markd2]
- they're generally a good source about what machines run which distributions well
- 13:54:36 [Psychephylax]
- heh
- 13:54:48 [markd2]
- * markd2 is a big LUG fan
- 13:54:56 [Psychephylax]
- LUG?
- 13:54:59 [markd2]
- a LUG-nut, as you might say
- 13:55:01 [markd2]
- Linux Users Group
- 13:55:02 [ola]
- markd2: probably, i'll check.
- 13:55:03 [Psychephylax]
- Ah
- 13:55:07 [markd2]
- choo!
- 13:55:10 [Psychephylax]
- moo?
- 13:55:20 [markd2]
- how now brown cow
- 13:55:29 [Psychephylax]
- Mooooooooo!!!
- 13:55:39 [Psychephylax]
- Damn it
- 13:55:42 [markd2]
- mü
- 13:55:45 [Psychephylax]
- I want my timestamps
- 13:56:07 [markd2]
- I sent a roll of them to you in the past! didn't you get them then?
- 13:56:25 [markd2]
- lemme guess, you used them all up next week
- 13:56:43 [Psychephylax]
- uh huh
- 13:57:56 [Psychephylax]
- :(
- 13:57:56 [Psychephylax]
- it time stamps your messages but not mine
- 14:00:58 [davb]
- Get a titanium!
- 14:04:08 [markd2]
- TiBooks rule(tm)
- 14:04:25 [Psychephylax]
- hmmm?
- 14:04:34 [davb]
- or an IBM
- 14:04:58 [davb]
- of course, neither one of them is cheap
- 14:04:59 [ola]
- that would be awesome but sounds kind of expensive.
- 14:05:05 [ola]
- heh
- 14:05:34 [davb]
- * davb needs to run CAT5 to the porch...
- 14:06:17 [Psychephylax]
- off to work
- 14:06:24 [markd2]
- happy infecting
- 14:29:00 [ola]
- * ola trips over CAT5 almost every time he's heading for the living room:-(
- 14:29:09 [davb]
- Apartment?
- 14:29:15 [ola]
- yes.
- 14:31:08 [ola]
- you live in a house?
- 14:31:27 [davb]
- Yeah. We bought it in June. All the network is in one room so far.
- 14:31:43 [markd2]
- that's right - you've got the sprawling estate somewhere
- 14:31:50 [davb]
- haha!
- 14:32:00 [markd2]
- davb's dude ranch
- 14:32:20 [davb]
- Not quite. Our neighbor has the rest of our backyard. Of course, someone else's house is in his. Interesting setup.
- 14:32:24 [ola]
- * ola looks up sprawling
- 14:32:42 [davb]
- OK Who wants to port the NEWS package?
- 14:32:46 [davb]
- :)
- 14:33:05 [davb]
- * davb thinks about doing it to avoid working on static-pages
- 14:33:34 [markd2]
- ola: sprawling estate - large house on a big piece of land
- 14:33:50 [ola]
- shouldn't we use ETP instead of news?
- 14:34:11 [ola]
- markd2: ok. thanks!
- 14:34:13 [markd2]
- mmm.. Eat This Page....
- 14:34:43 [davb]
- I just read Luke's message on that subject. He said the news package is good because visitors can suggest items. ETP doesn't have that kind of function.
- 14:35:43 [davb]
- I hadn't thought of that.
- 14:36:09 [davb]
- Maybe like he said someone eventually will build a generic user-generated content module.
- 14:41:55 [Psychephylax]
- well
- 14:41:58 [Psychephylax]
- I have arrived at work
- 14:42:01 [davb]
- * davb discovers he needs two more internet connected machines for the kids...
- 14:42:17 [Psychephylax]
- If I need to back up my development files
- 14:42:25 [Psychephylax]
- do you guys recommend making a package out of it
- 14:42:40 [Psychephylax]
- it being my package files in /packages/snmp
- 14:42:47 [Psychephylax]
- or just moving the files to a different place
- 14:45:14 [ola]
- mmm...time for some coffee and a few of those chocolate balls I made yesterday...
- 14:45:29 [Psychephylax]
- heh
- 14:48:12 [davb]
- Do one of each.
- 14:49:29 [ola]
- one coffee and one chocolate ball.. ok. that will do.
- 14:49:33 [davb]
- heh
- 14:50:30 [davb]
- * davb thinks there should be a fine for sending unsubscribe messages to a list.
- 14:51:10 [davb]
- Thing is, in mutt I can see all the list instructions in the header. Outlook could offer those as hyperlinks in the message.
- 14:52:42 [markd2]
- that would imply that MS would want to support existing internet conventions
- 15:01:17 [Psychephylax]
- heh
- 15:10:40 [davb]
- if you pass an empty string as the regexp to the tcl regexp command will it match everything?
- 15:12:05 [davb]
- * davb checks the docs
- 15:24:40 [Psychephylax]
- hmmm
- 15:24:50 [Psychephylax]
- db_string is an SQL bridge
- 15:25:04 [Psychephylax]
- but it says it returns the first column of the reult of the SQL query
- 15:25:07 [Psychephylax]
- what if it's an insert?
- 15:25:18 [markd2]
- query != insert
- 15:25:26 [markd2]
- so it should complain at you
- 15:26:10 [Psychephylax]
- ok
- 15:26:16 [Psychephylax]
- so how do I do inserts and updates?
- 15:26:22 [markd2]
- db_dml
- 15:27:01 [markd2]
- db_dml me_want_cookie "insert into blah (id, date, hoover) values (cookiesequence.nextval, sysdate, :some_bind_variable)"
- 15:27:04 [markd2]
- or something like that
- 15:30:36 [Psychephylax]
- what's DML stand for
- 15:32:26 [Psychephylax]
- ok, I got a question: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0002r2&topic_id=12&topic=OpenACS%204%2e0%20Design
- 15:32:39 [markd2]
- data modeling langauge
- 15:32:40 [Psychephylax]
- look down right above Deletes the test user and group
- 15:32:43 [markd2]
- e.g. insert and update
- 15:32:45 [Psychephylax]
- ah
- 15:33:13 [Psychephylax]
- He creates a new relation_id and creates a new relation
- 15:33:21 [Psychephylax]
- Can I use db_dml for that?
- 15:36:06 [markd2]
- you can use db_exec_plsql for doing plsql procedure calls
- 15:36:11 [markd2]
- there's a whole page on the db_* calls
- 15:36:25 [markd2]
- go to /doc, 'kernel documentaton', then 'database api'
- 15:36:26 [Psychephylax]
- where at
- 15:36:30 [Psychephylax]
- k
- 15:40:18 [Psychephylax]
- interesting
- 15:41:44 [Psychephylax]
- so if i have $variable
- 15:41:55 [Psychephylax]
- I can use it in the db_dml like this :variable
- 15:41:58 [Psychephylax]
- very cool!
- 15:41:58 [markd2]
- yep
- 15:45:14 [Psychephylax]
- I have a databases midterm tomorrow
- 15:45:35 [Psychephylax]
- So I wanna thank you for passing on some of the l33t Or4cl3 knowledge on me
- 15:49:09 [markd2]
- sure thing
- 15:59:13 [Psychephylax]
- * Psychephylax gives Mark a cookie
- 16:00:14 [Psychephylax]
- I gotta figure out how to break this pl/sql procedure into a smaller piece
- 16:00:35 [Psychephylax]
- I don't need the first 2 blocks for creating a new group and user I just need to take 2 existing ones and create a relation between them
- 16:01:27 [Psychephylax]
- aha
- 16:09:19 [Psychephylax]
- it does not appear to have a db_exec_plsql
- 16:09:29 [markd2]
- maybe it's db_execplsql
- 16:10:15 [Psychephylax]
- no
- 16:10:18 [Psychephylax]
- you have it right
- 16:10:29 [Psychephylax]
- but you have to explicitly search for it
- 16:10:47 [Psychephylax]
- so my call would be:
- 16:10:54 [Psychephylax]
- (bear with me while i type it out)
- 16:11:40 [Psychephylax]
- db_exec_plsql add_to_group "declare
- 16:11:47 [Psychephylax]
- v_rel_id : integer
- 16:11:50 [Psychephylax]
- begin
- 16:12:07 [Psychephylax]
- v_rel_id := membership_rel : new (
- 16:12:21 [Psychephylax]
- object_id_one => $group_id,
- 16:12:31 [Psychephylax]
- object_id_two => $person_id
- 16:12:33 [Psychephylax]
- );
- 16:12:35 [Psychephylax]
- end;
- 16:12:44 [markd2]
- something like that, yeah
- 16:12:49 [Psychephylax]
- "
- 16:12:56 [markd2]
- don't know if you need the ';' at the end of the end
- 16:13:04 [Psychephylax]
- ok
- 16:13:08 [Psychephylax]
- well, I'm gonna try tat
- 16:13:13 [Psychephylax]
- let's hope I don't break many things
- 16:14:49 [Psychephylax]
- it is going to expand the $group_id and $person_id right?
- 16:14:53 [Psychephylax]
- or do I have to bind them?
- 16:15:29 [markd2]
- since you have it in double-quotes, the variables will get expanded
- 16:15:44 [davb]
- Psychephylax: it will expand them, but it is safer to use bind variables.
- 16:15:46 [Psychephylax]
- ok
- 16:15:52 [Psychephylax]
- k
- 16:15:57 [Psychephylax]
- i'll try to bind them
- 16:16:13 [Psychephylax]
- so it would be single quotes if i"m binding?
- 16:16:19 [markd2]
- doesn't matter
- 16:16:28 [markd2]
- you can use binds with double quotes or curly braces
- 16:16:56 [Psychephylax]
- ok
- 16:17:13 [Psychephylax]
- Does whitespace get ignored?
- 16:17:20 [markd2]
- yep
- 16:17:24 [Psychephylax]
- ok good
- 16:17:25 [markd2]
- unless it's in a ' string'
- 16:17:30 [Psychephylax]
- cuz I like making my things look purty
- 16:18:45 [Psychephylax]
- so if I'm binding object_id_one => $blah becomes object_id_one => :blah
- 16:18:58 [Psychephylax]
- and on the end I add a bind paramenter?
- 16:19:06 [markd2]
- yep
- 16:19:18 [markd2]
- if it's just variables, you don't need any special parameters
- 16:19:27 [markd2]
- it'll pick up the value of $blah from the calling environment
- 16:19:52 [Psychephylax]
- oh so I can do just :blah and it will search for a $blah
- 16:20:15 [markd2]
- yep
- 16:20:49 [davb]
- Wow, that McMaster University I talked about yesterday has absolutely no information about their academdic progeams on their web site.
- 16:21:07 [Psychephylax]
- heh
- 16:21:08 [markd2]
- What's McMonster University?
- 16:21:09 [Psychephylax]
- McMaster
- 16:21:10 [markd2]
- er, McMaster
- 16:21:26 [markd2]
- * markd2 thanks Thigh McMaster
- 16:21:28 [Psychephylax]
- sounds more like McMonster to me if they have no info o the webpage
- 16:21:37 [Psychephylax]
- mmmm
- 16:21:39 [Psychephylax]
- McDonalds
- 16:23:19 [Psychephylax]
- doh
- 16:24:05 [Psychephylax]
- invalid positional variable `:', valid values start with 1
- 16:24:06 [Psychephylax]
- while executing
- 16:24:08 [Psychephylax]
- "ns_ora dml nsdb0 {
- 16:24:40 [Psychephylax]
- stupid ;
- 16:24:56 [markd2]
- hmmm
- 16:25:25 [Psychephylax]
- doh ; wsn't it
- 16:26:34 [Psychephylax]
- This is my code:
- 16:26:36 [Psychephylax]
- db_exec_plsql add_to_group "
- 16:26:36 [Psychephylax]
-
- 16:26:36 [Psychephylax]
- declare
- 16:26:36 [Psychephylax]
- v_rel_id : integer;
- 16:26:37 [Psychephylax]
- begin
- 16:26:39 [Psychephylax]
- v_rel_id := membership_rel.new(
- 16:26:41 [Psychephylax]
- object_id_one => :group_id,
- 16:26:43 [Psychephylax]
- object_id_two => :user_id
- 16:26:45 [Psychephylax]
- )
- 16:26:47 [Psychephylax]
- end;
- 16:26:49 [Psychephylax]
- /"
- 16:26:56 [Psychephylax]
- it craps out on the object_id_two => :user_id from my understanding of the error message
- 16:27:26 [markd2]
- you don't need the "/" either
- 16:27:31 [Psychephylax]
- oh
- 16:27:33 [markd2]
- that's a sqlplusism
- 16:27:41 [markd2]
- "execute the sql that's in the buffer"
- 16:27:47 [Psychephylax]
- it's in the sql files though
- 16:28:30 [markd2]
- right - since the sql files are consumed by....
- 16:28:32 [markd2]
- sqlplus!
- 16:28:42 [Psychephylax]
- oh
- 16:28:50 [Psychephylax]
- * Psychephylax is a n00b!!!
- 16:28:54 [markd2]
- heh
- 16:29:05 [davb]
- is this right? v_rel_id : integer
- 16:29:23 [Psychephylax]
- no
- 16:29:23 [Psychephylax]
- lol
- 16:29:25 [Psychephylax]
- <--dummy
- 16:29:53 [davb]
- Psychephylax => dummy;
- 16:29:57 [davb]
- :)
- 16:30:46 [Psychephylax]
- Or like mr pascal would do it
- 16:30:53 [Psychephylax]
- Psychephylax := dummy;
- 16:31:17 [Psychephylax]
- muahaha
- 16:31:20 [Psychephylax]
- oracle errors
- 16:31:20 [Psychephylax]
- !
- 16:31:24 [davb]
- aha, see I am not an oracle expert.
- 16:31:49 [Psychephylax]
- it's saying something about an end
- 16:32:09 [Psychephylax]
- Encountered the symbol "END" when expecting one of the following:
- 16:32:30 [Psychephylax]
- The symbol ";" was substituted for "END" to continue.
- 16:32:37 [markd2]
- you probably need a semicolon after the membership_rel.new function
- 16:33:07 [Psychephylax]
- jeez you're a genius!
- 16:33:12 [Psychephylax]
- * Psychephylax gives Mark a cookie
- 16:33:43 [Psychephylax]
- YES!!!!!
- 16:33:46 [Psychephylax]
- It works!
- 16:33:48 [Psychephylax]
- Eureka!
- 16:35:14 [markd2]
- woo hoo!!
- 16:36:10 [Psychephylax]
- indeedy!
- 16:37:06 [Psychephylax]
- now I can add lusers
- 16:53:08 [ola]
- one coffee and one chocolate ball.. ok. that will do.
- 16:53:17 [ola]
- sorry
- 16:53:37 [markd2]
- what a tease
- 16:53:43 [ola]
- hehh
- 16:54:55 [Psychephylax]
- wow, poor site design on the javascript menu: http://www.abit.com.tw/
- 16:55:04 [Psychephylax]
- Hah
- 16:55:07 [Psychephylax]
- chocolate balls
- 16:55:13 [Psychephylax]
- I want rumballs instead
- 16:55:15 [Psychephylax]
- much tastier
- 16:56:00 [Psychephylax]
- God I'm dumb
- 16:56:07 [Psychephylax]
- I can't even remember what the letter before W is
- 16:56:26 [Psychephylax]
- T sounds about right
- 16:57:20 [ola]
- U
- 16:57:28 [Psychephylax]
- oh
- 16:57:29 [Psychephylax]
- heh
- 16:57:36 [Psychephylax]
- Oracle problems
- 16:57:59 [markd2]
- V
- 16:58:11 [ola]
- ok:-)
- 16:58:17 [markd2]
- forgivable :-)
- 16:58:31 [ola]
- thanks.
- 16:58:47 [Psychephylax]
- wow I was way off
- 16:58:57 [Psychephylax]
- so " allow for variable expansion
- 16:59:00 [Psychephylax]
- but ' do not?
- 17:01:31 [markd2]
- I know " does. I don't use ' ' quotes in tcl
- 17:01:36 [markd2]
- so I can't ocmment
- 17:01:39 [markd2]
- or comment either
- 17:01:53 [Psychephylax]
- ok then how would I do a query
- 17:02:02 [Psychephylax]
- Because Oracle is complaining when I do a = Manager
- 17:02:07 [Psychephylax]
- it wants a = 'Manager'
- 17:03:42 [Psychephylax]
- I think I can do '$blah'
- 17:03:45 [Psychephylax]
- * Psychephylax tests his theory out
- 17:05:03 [Psychephylax]
- doh
- 17:05:18 [Psychephylax]
- it expands in the console properly but doesn't in the script
- 17:05:34 [markd2]
- the single quotes in oracle are in a different world than the quotes in tcl
- 17:05:50 [markd2]
- so yeah, in that case '$blah' does expand the variable
- 17:05:57 [markd2]
- if you don't want variable expansion, use curly braces
- 17:06:09 [Psychephylax]
- i do want variable expansion
- 17:06:31 [Psychephylax]
- I want the query to be dependent on $user_type which stores either Manager or Supervisor
- 17:06:35 [markd2]
- in that case single quotes inside of your double-quoted string
- 17:06:40 [Psychephylax]
- I did
- 17:06:48 [markd2]
- sounds like you're golden
- 17:06:49 [Psychephylax]
- "db_string group_id "select group_id from groups where group_name = '$user_type'""
- 17:07:25 [markd2]
- presuming the real command doesn't have double-quotes aound it, that should be ok
- 17:07:32 [markd2]
- e.g. db_string instead of "db_string
- 17:07:41 [Psychephylax]
- I don't have " around db_string
- 17:07:44 [davb]
- Or just use :user_type and the bind variable will quote it for you.
- 17:07:44 [Psychephylax]
- I have [ ]
- 17:07:45 [markd2]
- ok
- 17:07:55 [Psychephylax]
- oh good idea dave
- 17:07:57 [markd2]
- the paste into IRC had "db_string
- 17:08:23 [Psychephylax]
- yeah
- 17:08:27 [Psychephylax]
- that was from the error message
- 17:08:37 [Psychephylax]
- Dave, it didn't work for the same reason :(
- 17:08:55 [Psychephylax]
- this is the command I'm using:
- 17:08:58 [Psychephylax]
- set group_id [db_string group_id "select group_id from groups where group_name = :user_type"]
- 17:09:11 [davb]
- really? Weird. Did it log the actual query string after it was expaneded?
- 17:09:17 [Psychephylax]
- I have tried '$user_type' instead of :user_type and plain old $user_type
- 17:09:20 [Psychephylax]
- and it bombs
- 17:09:41 [davb]
- I think it is a different error. '$user_type' or :user_type should be OK.
- 17:09:53 [Psychephylax]
- this is the error with the string above:
- 17:09:55 [Psychephylax]
- "db_string group_id "select group_id from groups where group_name = :user_type""
- 17:10:07 [Psychephylax]
- Selection did not return a value, and no default was provided
- 17:10:07 [Psychephylax]
- while executing
- 17:10:29 [davb]
- What is the contents of $user_type
- 17:10:37 [Psychephylax]
- no it's not :)
- 17:10:42 [Psychephylax]
- oh
- 17:10:43 [Psychephylax]
- doh
- 17:10:46 [Psychephylax]
- * Psychephylax misreads
- 17:10:54 [Psychephylax]
- user_type is either Manager or Supervisor
- 17:11:24 [davb]
- No I mean what is it when you run that query. Put in a ns_log notice "$user_type" to see what is really is or turn VERBOSE on in the db pools.
- 17:11:30 [Psychephylax]
- if I leave everything off and try $user_type the query gets expanded to the right thing but oracle expects ' ' around the keyword to look for
- 17:12:39 [Psychephylax]
- I guess I could try doing this set user_type '$user_type'
- 17:13:09 [davb]
- that will just return '$user_type' to the database.
- 17:13:28 [Psychephylax]
- why
- 17:13:46 [Psychephylax]
- isn't it going to expand it to this: set user_type 'Manager'
- 17:13:54 [Psychephylax]
- and then the user_type should contain 'Manager'
- 17:14:01 [Psychephylax]
- instead of Manager?
- 17:14:47 [davb]
- Oh maybe. Anyway you are confusing me.
- 17:15:10 [Psychephylax]
- brb
- 17:15:11 [Psychephylax]
- lunch
- 17:15:13 [davb]
- You really should set verbose on in your aolserver config file. It will log the text of every query.
- 17:15:41 [davb]
- Then you will know exactly what the database is running, instead of just what it is before the driver converts the variables.
- 17:25:20 [ola]
- * ola wonders how difficult it would be to port "news"...
- 17:28:17 [ola]
- I guess the answer is; "about as easy/difficult as the other packages"
- 17:28:17 [davb]
- ola: doesn't look too bad. Only a couple of queries in /tcl and
- 17:28:17 [davb]
- not too many www pages.
- 17:28:30 [ola]
- what about CR integration?
- 17:29:26 [Psychephylax]
- back
- 17:29:36 [ola]
- that was quick!
- 17:29:50 [Psychephylax]
- yeah I wanna leave early
- 17:30:04 [Psychephylax]
- so I'm not taking my usual lunch break * 2
- 17:30:17 [Psychephylax]
- How do I turn the verbose thing on
- 17:31:05 [Psychephylax]
- i have this: ns_param Verbose On
- 17:31:07 [davb]
- Actually looks good. It uses extended attributes for the items.
- 17:31:26 [davb]
- it uses built in functions.
- 17:32:03 [davb]
- The only tricky part would be the search function.
- 17:32:36 [Psychephylax]
- odd
- 17:32:37 [davb]
- I would do it if I wasn't already way behind on static-pages plus my other projects...
- 17:32:39 [davb]
- even
- 17:32:41 [Psychephylax]
- I don't even have logs for today
- 17:33:26 [Psychephylax]
- Maybe I'm not launching the server properly
- 17:33:32 [Psychephylax]
- I use /bin/nsd -ft oacs4.tcl
- 17:33:53 [ola]
- davb: maybe the search part could be left out, and instead use Neophytos's/Dan's search.
- 17:33:56 [davb]
- Aha -f doesn't log.
- 17:34:00 [davb]
- ola: right
- 17:34:12 [davb]
- it goes to the foreground. Logs to the console.
- 17:34:23 [davb]
- Do nsd -it and tail -f the log.
- 17:34:32 [davb]
- (I learned that this week)
- 17:35:00 [Psychephylax]
- hehe
- 17:37:26 [Psychephylax]
- which log file
- 17:37:32 [Psychephylax]
- it still does not make one for today
- 17:37:54 [davb]
- servername-error.log unless you called it something else.
- 17:38:19 [Psychephylax]
- yes
- 17:38:31 [Psychephylax]
- but I don't have one for 10-03-
- 17:38:31 [davb]
- strange.
- 17:38:55 [Psychephylax]
- you got that right
- 17:38:57 [davb]
- I just have one big huge error log file. It doesn't roll.
- 17:39:19 [markd2]
- yeah. error logs have to be rolled externally
- 17:39:25 [markd2]
- HUP 2 3 4...
- 17:41:13 [Psychephylax]
- i'm so lost
- 17:41:46 [markd2]
- Land of the Lost In Space
- 17:42:00 [Psychephylax]
- yeah
- 17:42:05 [Psychephylax]
- You guys are getting me side tracked
- 17:42:08 [Psychephylax]
- I know the problem
- 17:42:12 [Psychephylax]
- I just don't know how to fix it
- 17:45:07 [Psychephylax]
- why doesn't it expand properly?
- 17:47:01 [davb]
- In the log it should show the actual query sent to the database. You are just seeing the Tcl call. Look back farther in the log and it should say Querying ' whatever the query is'
- 17:47:08 [davb]
- On OpenACS anyway.
- 17:56:54 [davb]
- argh! The internet is too interesting. I am always finding new books to read. I think if I started now on the list I have I might just finish before I am dead, as long as I don't add any new books to the list.
- 17:57:15 [davb]
- I need one of those Matrix things to plug into my brain :)
- 18:02:17 [Psychephylax]
- ok
- 18:02:29 [Psychephylax]
- I just got a totally irrelevant lecture on code indentation
- 18:02:41 [Psychephylax]
- I think I can indent my code the way I want to
- 18:03:05 [markd2]
- good luck when you enter a job that has an existing style guide
- 18:03:10 [davb]
- Only if you never share it with anyone else. Although I admit I have absolutely no style standards myself.
- 18:03:32 [Psychephylax]
- hey
- 18:03:35 [Psychephylax]
- my style is easy to read
- 18:03:43 [Psychephylax]
- I indent and structure the code and actually comment
- 18:04:00 [davb]
- I think if you actually comment the code, you should be able to indent any way you like.
- 18:04:15 [Psychephylax]
- exactly
- 18:04:41 [Psychephylax]
- and as if it is my fault that I don't have root to install the tcl major mode for xemacs
- 18:22:13 [Psychephylax]
- i can't even find it on the xemacs ftp
- 18:36:10 [Psychephylax]
- Anyone still awake?
- 18:38:57 [davb]
- weird. isn't it installed automatically? emacs has tcl mode installed by default.
- 18:39:47 [Psychephylax]
- that's what I thought
- 18:39:50 [Psychephylax]
- I gave up on that
- 18:39:57 [davb]
- right.
- 18:40:06 [Psychephylax]
- I'd rather have working code
- 18:40:20 [Psychephylax]
- If it was hard to write, it should be hard to understand damn it!
- 18:40:28 [davb]
- heh
- 18:40:53 [Psychephylax]
- BLURB: If code is hard to write, it should be hard to understand!
- 18:40:54 [chump]
- A: If code is hard to write, it should be hard to understand! from Psychephylax
- 18:41:14 [Psychephylax]
- back to my $user_type problem
- 18:41:32 [Psychephylax]
- ok
- 18:41:35 [Psychephylax]
- if I have this:
- 18:41:45 [Psychephylax]
- set group_id [db_string group_id "select group_id from groups where group_name = $user_type"]
- 18:41:56 [Psychephylax]
- $user_type gets expanded into Manager
- 18:42:13 [Psychephylax]
- but: Oracle complains about the query of where user_type = Manager
- 18:42:15 [markd2]
- if you're using variable expansion, you need single quotes
- 18:42:24 [davb]
- what he said
- 18:42:26 [markd2]
- user_type = Manager, oracle looks for a column named MANAGER
- 18:42:36 [Psychephylax]
- Where do these single quotes go
- 18:43:10 [davb]
- around $user_type like this
- 18:43:25 [davb]
- select group_id from groups where group_name= '$user_type'
- 18:43:34 [Psychephylax]
- ok
- 18:43:38 [Psychephylax]
- but when I try that it bombs out
- 18:44:09 [davb]
- msg me with the log output of the entire operate
- 18:44:14 [davb]
- s/operate/operation
- 18:44:18 [Psychephylax]
- umm
- 18:44:23 [Psychephylax]
- ok lemme try
- 18:58:22 [Psychephylax]
- Psychephylax has quit
- 18:58:22 [ola]
- argh! I can't decide if I should volunteer to port "news", so instead I've started porting "mp3jukebox" in secrecy...
- 18:59:38 [Psychephylax]
- Psychephylax has joined #openacs
- 19:00:11 [Psychephylax]
- ooops
- 19:00:18 [Psychephylax]
- Hit the wrong key sequence
- 19:00:21 [ola]
- ooopsie.
- 19:00:27 [Psychephylax]
- heh
- 19:00:32 [Psychephylax]
- * Psychephylax is not a very good BitchX
- 19:00:35 [davb]
- heh
- 19:00:36 [Psychephylax]
- luser
- 19:00:49 [Psychephylax]
- Trying to close a query and it didn't close
- 19:00:59 [davb]
- I though someone was working on MP3jukebox
- 19:01:00 [Psychephylax]
- so I tried /exit query davb and ummm...yeah
- 19:01:21 [davb]
- now you know!
- 19:03:14 [Psychephylax]
- hmmmmmm
- 19:03:20 [ola]
- davb: ok. I haven't checked with Don. You know how it is... I just wanna see if it's very hard or not..
- 19:03:30 [markd2]
- markd2 has quit
- 19:03:55 [ola]
- davb: it says "none" in the status sheet
- 19:04:42 [Psychephylax]
- hmmm
- 19:04:46 [Psychephylax]
- ok
- 19:05:10 [Psychephylax]
- if I log in and then go to re-log in as a different user, I'm taken to /pvt/home which is part of the sub-site package
- 19:05:20 [Psychephylax]
- How do unmount that and make them go to the regular site
- 19:05:38 [Psychephylax]
- i was thinking of symlinking over to the regular site but that seems wrong and inefficient
- 19:05:59 [Psychephylax]
- * Psychephylax wanders off to read the Request Processor docs
- 19:12:44 [davb]
- ola: aha
- 19:13:40 [davb]
- * davb looked at the CR and CMS first before anything else. So all the packages seem easy :)
- 19:17:18 [ola]
- :-)
- 19:18:06 [Psychephylax]
- heh
- 19:18:16 [Psychephylax]
- This stuff makes sense if you work on it
- 19:18:36 [Psychephylax]
- Of course this isn't what I want to do but oh well
- 19:18:38 [Psychephylax]
- they pay me
- 19:19:26 [ola]
- what DO you want to do, then?
- 19:19:57 [Psychephylax]
- I wanna be a detective
- 19:20:09 [Psychephylax]
- Jump over rooftops after bad guys with my gun drawn
- 19:20:13 [davb]
- You are a code detective.
- 19:20:17 [Psychephylax]
- While the theme from cops is playing in the background
- 19:20:32 [Psychephylax]
- :)
- 19:20:39 [Psychephylax]
- hey, one can dream!
- 19:21:29 [davb]
- Hey, is there a carpentry IRC channel? I need some advice on fixing my shed.
- 19:21:44 [ola]
- psyche: aha. like Beastie Boys in "Sabotage"
- 19:21:58 [ola]
- ?
- 19:22:00 [Psychephylax]
- yeah!
- 19:22:06 [ola]
- cool!
- 19:22:13 [Psychephylax]
- That song kicks major ass
- 19:22:17 [Psychephylax]
- oh boy
- 19:22:21 [Psychephylax]
- you got me all excited now
- 19:22:26 [Psychephylax]
- now I need to listen to the song
- 19:22:41 [Psychephylax]
- * Psychephylax fetches it from his super secret webpage which has 2000 mp3s
- 19:23:14 [Psychephylax]
- damn fast
- 19:23:29 [Psychephylax]
- 100K/sec
- 19:23:43 [ola]
- psyche: that one, or 100%
- 19:23:56 [Psychephylax]
- 100K/sec
- 19:24:06 [Psychephylax]
- test it for yourself if you really want
- 19:24:38 [Psychephylax]
- i'll give you the url
- 19:24:55 [ola]
- no. that song, or 100% by Sonic Youth!
- 19:25:02 [Psychephylax]
- oh
- 19:25:03 [Psychephylax]
- hehehe
- 19:25:10 [Psychephylax]
- I never heard that one
- 19:25:39 [ola]
- download it now!
- 19:25:54 [Psychephylax]
- ok but where from?
- 19:26:12 [ola]
- napster???
- 19:26:17 [Psychephylax]
- don't have it here
- 19:26:21 [Psychephylax]
- if you have it
- 19:26:25 [Psychephylax]
- e-mail it to me :)
- 19:28:30 [Psychephylax]
- ok
- 19:28:42 [Psychephylax]
- Now i need to figure out user removal
- 19:29:30 [Psychephylax]
- if i mutate a use email address i'm not messing up the database because it's all linked by his user_id right?
- 19:30:26 [ola]
- right!
- 19:30:43 [Psychephylax]
- excellent!
- 19:31:20 [ola]
- brilliant!
- 19:31:21 [Psychephylax]
- After i figure that out
- 19:31:32 [Psychephylax]
- I just have to figure out how to keep a user hierarchy
- 19:31:56 [ola]
- what do you mean?
- 19:32:06 [Psychephylax]
- well, I need to keep track of who works for whom
- 19:32:16 [Psychephylax]
- like say you have Mr Bob (uid 100)
- 19:32:24 [Psychephylax]
- He has 2 workers who work for him
- 19:32:31 [ola]
- ok
- 19:32:34 [Psychephylax]
- Mr Dave and Mr Mark
- 19:32:41 [Psychephylax]
- uid 101 and uid 102
- 19:32:49 [Psychephylax]
- i need to keep track of that somehow
- 19:32:55 [Psychephylax]
- I think it's going to be a table
- 19:33:03 [Psychephylax]
- where one side is who works for whom
- 19:33:13 [Psychephylax]
- like
- 19:33:19 [Psychephylax]
- 100 | 101
- 19:33:22 [Psychephylax]
- 100 | 102
- 19:33:37 [Psychephylax]
- now if Mark has 2 other guys it would be in the table like this:
- 19:33:41 [Psychephylax]
- 102 | 104
- 19:33:45 [Psychephylax]
- 102 | 105
- 19:33:48 [Psychephylax]
- 101 | 103
- 19:33:59 [Psychephylax]
- or something like that
- 19:35:37 [ola]
- aha. have you seen this: http://www.arsdigita.com/books/sql/trees.html
- 19:37:12 [Psychephylax]
- Psychephylax has quit
- 19:38:11 [Psychephylax]
- Psychephylax has joined #openacs
- 19:38:23 [Psychephylax]
- I hug trees...!!!!
- 19:38:38 [ola]
- wb, psyche!
- 19:39:51 [Psychephylax]
- thanks
- 19:39:54 [Psychephylax]
- I got a ping time out
- 19:40:20 [Psychephylax]
- my medicine is wearing off
- 19:40:30 [Psychephylax]
- What wouldn't I give for my bottle of Dayquil
- 19:41:01 [ola]
- Dayquil?
- 19:41:22 [Psychephylax]
- yes
- 19:41:48 [ola]
- what is Dayquil?
- 19:42:13 [ola]
- I' curious.
- 19:42:47 [davb]
- Cold remedy. Supposed to not make you sleepy.
- 19:43:48 [Psychephylax]
- Ever heard of yeah opposite of Nyquil
- 19:43:56 [Psychephylax]
- Nyquil is for night and Dayquil is for day
- 19:44:09 [Psychephylax]
- good stuff i tells ya
- 19:44:29 [ola]
- ok. whatever you say.
- 19:44:41 [Psychephylax]
- I say it's good
- 19:44:49 [Psychephylax]
- Nyquil gets you sleepy though
- 19:44:51 [Psychephylax]
- the other one doesn't
- 19:45:05 [Psychephylax]
- Clears your head pretty well
- 19:47:48 [Psychephylax]
- mmmkay
- 19:50:39 [ola]
- nvl becomes coalesce, right?
- 19:51:05 [Psychephylax]
- wha?
- 19:53:36 [ola]
- nvl(v.total,0) as total ---> coalesce(v.total,0) as total - Oracle to PG.
- 19:55:41 [Psychephylax]
- * Psychephylax watches that fly over his head
- 19:57:48 [Psychephylax]
- aha
- 19:57:54 [Psychephylax]
- * Psychephylax finds a bug
- 19:58:28 [davb]
- ola: yep
- 20:00:54 [ola]
- thanks.
- 20:01:16 [davb]
- np
- 20:03:26 [Psychephylax]
- if {[ad_permission_p $package_id manager] || [ad_permission_p $package_id admin] && [$user_type == 'Manager'] || [$user_type == 'Supervisor']} {
- 20:03:36 [ola]
- oooh! an outer join...
- 20:04:00 [Psychephylax]
- this will only execute the block if user is a manager or admin and they are trying to add a Supervisor or Manager..correct?
- 20:04:12 [Psychephylax]
- * Psychephylax lacks confidence in his skills
- 20:05:33 [davb]
- sounds right. Try it.
- 20:06:38 [Psychephylax]
- i think i'm missing parenthesis
- 20:07:08 [davb]
- yeah. after the and, around the or.
- 20:07:37 [davb]
- over the river and trhough the woods...
- 20:08:22 [Psychephylax]
- lol
- 20:09:00 [Psychephylax]
- gotta love TCL
- 20:09:00 [ola]
- I vote for this:
- 20:09:03 [ola]
- if {([ad_permission_p $package_id manager] || [ad_permission_p
- 20:09:03 [ola]
- $package_id admin]) && ([$user_type == 'Manager'] || [$user_type
- 20:09:04 [ola]
- == 'Supervisor'])} {
- 20:09:09 [Psychephylax]
- Now I gotta figure out what kind of parenthesis
- 20:09:28 [Psychephylax]
- i second that
- 20:09:56 [Psychephylax]
- much easier to look at it like this: (A or B) and (C or D)
- 20:11:19 [ola]
- question:
- 20:11:28 [Psychephylax]
- answer: yes or 42
- 20:11:32 [ola]
- where is everyone?
- 20:11:37 [Psychephylax]
- hmmmm
- 20:11:46 [Psychephylax]
- Well, neither of those fit quiet well
- 20:11:47 [davb]
- Physically?
- 20:11:51 [Psychephylax]
- Define by everyone
- 20:12:11 [ola]
- the acs community.
- 20:12:14 [talli]
- talli has joined #openacs
- 20:12:19 [Psychephylax]
- see
- 20:12:20 [ola]
- whoa!
- 20:12:22 [Psychephylax]
- you call them and they come
- 20:12:24 [talli]
- heeeelllloooo
- 20:12:28 [Psychephylax]
- Hey talli
- 20:12:32 [ola]
- helloooo!
- 20:12:41 [Psychephylax]
- http://www.cnn.com/2001/US/10/03/bus.crash/
- 20:12:41 [chump]
- B: http://www.cnn.com/2001/US/10/03/bus.crash/ from Psychephylax
- 20:12:42 [davb]
- Hi talli
- 20:12:44 [talli]
- was i summonned?
- 20:13:04 [Psychephylax]
- B:| Greyhound service resumes after fatal bus crash
- 20:13:04 [chump]
- titled item B
- 20:13:45 [ola]
- talli: look at the last line of the chatlog!
- 20:13:51 [Psychephylax]
- B: Greyhound Lines resumed bus service at 1 p.m. EDT Wednesday after one of its buses crashed in Tennessee when the driver's throat was slit. Authorities said six people were killed in the crash.
- 20:13:51 [chump]
- commented item B
- 20:15:03 [Psychephylax]
- and Hijacked Indian airliner lands in New Delhi, CNN confirms. Details soon.
- 20:19:02 [Psychephylax]
- any of you guys into distributed computing?
- 20:20:34 [davb]
- Like distributed.net or seti@home or something like that?
- 20:22:27 [Psychephylax]
- yeah
- 20:24:37 [davb]
- not really. I don't like to run that stuff on my development machine and it's the only one I've got.
- 20:25:05 [markd2]
- markd2 has joined #openacs
- 20:25:19 [Psychephylax]
- oh
- 20:25:23 [Psychephylax]
- wb Mark
- 20:26:06 [markd2]
- tnx
- 20:26:09 [Psychephylax]
- arg
- 20:26:13 [markd2]
- felt the urge to go outside and read an oracle book
- 20:26:15 [Psychephylax]
- trying to dumb things down for people is hard
- 20:26:44 [markd2]
- certainly. that's why I avoid polysyllabatic rhetoric in my commonstance discourse
- 20:27:16 [Psychephylax]
- lol
- 20:29:28 [ola]
- I'd like to show you guys two views so you can tell me if I ported it right:
- 20:29:52 [ola]
- ok, oracle:
- 20:29:55 [ola]
- create or replace view mp3_mp3_playlist_map_view as
- 20:29:55 [ola]
- select m.mp3_id,
- 20:29:55 [ola]
- m.playlist_id,
- 20:29:55 [ola]
- m.sort_key,
- 20:29:55 [ola]
- nvl(v.total,0) as total
- 20:29:55 [ola]
- from mp3_mp3_playlist_map m,
- 20:29:58 [ola]
- (select mp3_id,
- 20:29:59 [ola]
- playlist_id,
- 20:30:01 [ola]
- sum(vote) as total
- 20:30:03 [ola]
- from mp3_votes
- 20:30:05 [ola]
- group by mp3_id, playlist_id) v
- 20:30:07 [ola]
- where m.mp3_id = v.mp3_id (+)
- 20:30:09 [ola]
- and m.playlist_id = v.playlist_id (+);
- 20:30:11 [ola]
- tada!
- 20:30:17 [Psychephylax]
- * Psychephylax falls off his chair
- 20:30:32 [ola]
- and now PG:
- 20:30:34 [ola]
- create view mp3_mp3_playlist_map_view as
- 20:30:34 [ola]
- select m.mp3_id,
- 20:30:34 [ola]
- m.playlist_id,
- 20:30:34 [ola]
- m.sort_key,
- 20:30:35 [ola]
- coalesce(v.total,0) As total
- 20:30:37 [ola]
- from mp3_mp3_playlist_map m,
- 20:30:39 [ola]
- left join (select mp3_id,
- 20:30:41 [ola]
- playlist_id,
- 20:30:43 [ola]
- sum(vote) as total
- 20:30:45 [ola]
- from mp3_votes
- 20:30:47 [ola]
- group by mp3_id, playlist_id) v
- 20:30:50 [ola]
- on (m.mp3_id = v.mp3_id)
- 20:30:51 [ola]
- and on (m.playlist_id = v.playlist_id);
- 20:30:53 [ola]
- voila...
- 20:31:38 [ola]
- how does that outer join look?
- 20:32:04 [Psychephylax]
- beyond my abilities
- 20:32:06 [Psychephylax]
- lol
- 20:33:03 [davb]
- Looks ok. I am not a join expert.
- 20:33:28 [Psychephylax]
- my dad is a joint expert...well, at least he was back in Russia
- 20:33:55 [davb]
- The main thing is that you HAVE to use an alias for the table name in an outer join if you join it to itself( which you are not doing anyway)
- 20:33:56 [ola]
- can you ask him?
- 20:34:21 [davb]
- Psychephylax: I assume the extra T is not a mistake...
- 20:34:37 [Psychephylax]
- it's not
- 20:34:45 [Psychephylax]
- hehehe, he was an orthpaedic surgeon
- 20:34:50 [Psychephylax]
- fixed all sorts of joints
- 20:34:52 [davb]
- Cool.
- 20:35:10 [Psychephylax]
- ok
- 20:35:24 [Psychephylax]
- Is it possible to have variables that were not specifically contracted?
- 20:36:29 [davb]
- Sure. The contract is for incoming and outgoing variables. Any that stay in the page are OK.
- 20:36:53 [davb]
- Also you can just leave them out, but you would have to check for them explictly in the code. The contract is just a helpful tool.
- 20:37:17 [Psychephylax]
- heh
- 20:37:26 [Psychephylax]
- not helpful when you're trying to determine where a variable came from :)
- 20:37:54 [markd2]
- ns_set print [ns_getform] is a handy way to see what's in your formadata
- 20:38:14 [Psychephylax]
- well, I traced it down to ad_registration_finite_state_machine_admin_links
- 20:38:30 [Psychephylax]
- Which returns administration links to change users state
- 20:38:35 [Psychephylax]
- but
- 20:38:42 [Psychephylax]
- It returns more than I want to display
- 20:39:21 [Psychephylax]
- i s'pose I can hack the tcl file it's in
- 20:44:07 [Psychephylax]
- i came to a conclusion
- 20:44:15 [Psychephylax]
- If my boss had given me exact specs for what he wants
- 20:44:18 [Psychephylax]
- I would be much happier
- 20:44:58 [markd2]
- * markd2 welcomes psychephylax to the real world
- 20:45:11 [markd2]
- you'll never get exact specs
- 20:45:21 [markd2]
- except for classroom exercises
- 20:45:23 [markd2]
- and even for those....
- 20:45:24 [Psychephylax]
- heh
- 20:45:28 [Psychephylax]
- well, I have NO spec docs
- 20:45:34 [Psychephylax]
- basically what I want to do I do
- 20:47:29 [Psychephylax]
- then if he doesn't like it I get to redo it all
- 20:47:33 [Psychephylax]
- stupid if you ask me
- 20:55:46 [Psychephylax]
- ugh
- 20:56:25 [Psychephylax]
- you guys familiar with the finite state machine in OACS?
- 20:56:38 [Psychephylax]
- the user_state one
- 20:56:43 [Psychephylax]
- if there's more than one
- 21:02:30 [talli]
- talli has quit
- 21:09:10 [Psychephylax]
- gah
- 21:09:13 [Psychephylax]
- it doesn't edit
- 21:13:15 [Psychephylax]
- Ok, why the hell isn't it calling the proper function
- 21:13:17 [Psychephylax]
- ooooh
- 21:13:22 [Psychephylax]
- The server has to be restarted
- 21:14:29 [Psychephylax]
- w00t!
- 21:15:12 [Psychephylax]
- Eureka!
- 21:18:41 [rbm]
- m000t
- 21:18:49 [Psychephylax]
- lol
- 21:18:52 [Psychephylax]
- moot to you too
- 21:20:36 [rbm]
- hey Psyche
- 21:21:12 [Psychephylax]
- Hello Roberto
- 21:21:19 [Psychephylax]
- Anyone know when Beta is coming out?
- 21:22:05 [rbm]
- I forgot when.
- 21:22:10 [markd2]
- markd2 has quit
- 21:22:43 [rbm]
- I've been so screwed up by the INS, and it has taken so much time of me that I've been off of things a bit.
- 21:22:46 [Psychephylax]
- that's not very helpful ;)
- 21:22:59 [rbm]
- s/INS/Post-WW2 Gestapo/
- 21:23:05 [Psychephylax]
- lol
- 21:23:38 [rbm]
- * rbm cries
- 21:23:44 [ola]
- rbm: hi, do you know if someone is porting mp3jukebox?
- 21:24:20 [rbm]
- ola: No, but if you want to that, I'd love it :-)
- 21:24:30 [rbm]
- And remove that dependency on Perl please
- 21:24:41 [rbm]
- I looked at it. It seems like a piece of cake to port.
- 21:24:52 [Psychephylax]
- I wanna port it! hehehe
- 21:24:59 [Psychephylax]
- You guys always helping me
- 21:25:02 [Psychephylax]
- I wanna help you
- 21:25:08 [ola]
- what pearl dependency?
- 21:25:36 [Psychephylax]
- the one that brings in the money for the pearls?
- 21:25:36 [ola]
- perl
- 21:25:44 [Psychephylax]
- :-/
- 21:26:26 [rbm]
- It uses a little Perl script with a Perl module to extract the ID3 tags from the files and insert them into the database.
- 21:26:44 [ola]
- aha.
- 21:27:18 [rbm]
- I was exaggerating :)
- 21:27:23 [rbm]
- err. wrong window,.
- 21:28:11 [Psychephylax]
- what do you guys is more efficient/appropriate
- 21:28:25 [Psychephylax]
- I'm hacking a bunch of files that are already written for me
- 21:28:34 [Psychephylax]
- like from acs-subsite and whatnot
- 21:28:46 [Psychephylax]
- is it better to copy them to my package or edit them in theirs?
- 21:29:09 [Psychephylax]
- s/guys/guys think
- 21:29:24 [rbm]
- Is that for a new package?
- 21:29:34 [rbm]
- I guess I'm not understanding what you're trying to do
- 21:29:47 [Psychephylax]
- Well
- 21:29:51 [Psychephylax]
- I'm writing a package
- 21:30:01 [Psychephylax]
- which requires it's own user interface
- 21:30:23 [Psychephylax]
- And things like adding a user, removing a user are kinda written already
- 21:30:38 [Psychephylax]
- so i've edited a bunch of files
- 21:30:47 [Psychephylax]
- for example
- 21:31:00 [Psychephylax]
- the user removal
- 21:31:23 [Psychephylax]
- uses admin-procs.tcl from the kernel (i think)
- 21:31:50 [Psychephylax]
- But I need a modified one, because we don't want to show things like ban a user to the people...so is it better to move these types of things to my package or edit them in place?
- 21:34:27 [ola]
- oh no! this function has 26 parameters. I think I need to overload.
- 21:40:00 [rbm]
- Psychephylax: Is "admin-procs.tcl" a page or library?
- 21:40:07 [rbm]
- If it's a page, copy and modify.
- 21:40:17 [rbm]
- But how?
- 21:40:20 [rbm]
- argh!
- 21:40:28 [rbm]
- nevermind
- 21:51:51 [Psychephylax]
- library afaict
- 21:53:16 [Psychephylax]
- gah
- 21:53:26 [Psychephylax]
- if only my boss didn't modify the UI every time he takes a look at it
- 21:54:19 [Psychephylax]
- let's seeeee
- 21:54:22 [Psychephylax]
- I was here at 10:30
- 21:54:27 [Psychephylax]
- andi t's 5:50
- 21:54:45 [Psychephylax]
- that's....ummmm 6 hours and 20 minutes?
- 21:55:32 [Psychephylax]
- I'm going home
- 21:55:32 [Psychephylax]
- :)
- 21:55:41 [Psychephylax]
- I can't count that far so it must be long and time to go home
- 21:55:42 [Psychephylax]
- hehehehehe
- 21:56:09 [rbm]
- If it's library, you should be able to use it as is. But if it has UI, you might be better just copying to your package
- 21:57:14 [Psychephylax]
- i be back later
- 22:00:06 [ola]
- bye
- 22:11:18 [ola]
- ola has quit
- 22:33:40 [davb]
- davb has quit
- 22:57:14 [davb]
- davb has joined #OpenACS