IRC log of openacs on 2001-12-19

Timestamps are in UTC.

00:35:01 [loggy]

loggy (~openacs-l@xcdfddb76.ip.ggn.net) has joined #openacs

00:35:01 [forward.openprojects.net]

topic is: Cross-stitch for web nerds. http://openacs.org

00:35:01 [forward.openprojects.net]

Users on #OpenACS: loggy AaronSw til davb talli beattiek hazmat Psychephylax chump

00:35:01 [ChanServ]

[#OpenACS] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog

00:35:06 [davb]

Thanks!!

00:35:14 [AaronSw]

no prob

00:35:20 [AaronSw]

perhaps i should make a web interface for you guys ;-)

00:35:27 [AaronSw]

even better: perhaps you should ;-)

00:35:33 [davb]

no really I should figure it out one of these days.

00:35:59 [davb]

I swear it hates me. I have spent a few hours dorking around with it. it just never starts up without any error message.

00:36:12 [AaronSw]

Heh heh.

00:36:21 [AaronSw]

it's ok-- it's not exactly hard to kill the process

00:37:11 [davb]

do you mind sharing your command line :)?

00:37:29 [AaronSw]

for what?

00:37:39 [AaronSw]

(sorry, got disconnected)

00:37:54 [davb]

logger.

00:38:13 [AaronSw]

perl -w /usr/local/stuff/logger/logger -html -nick logster <password> irc://irc.openprojects.net/swhack Swhack /web/blogspace/www/swhack/chatlogs/ http://blogspace.com/swhack/chatlogs/

00:38:21 [davb]

I must figure out this perl script !!!!!

00:38:22 [davb]

:)

00:38:41 [davb]

ok. I should be able to make it work with that...

00:38:51 [davb]

I never used perl -w before...

00:40:06 [beattiek]

davb, i'm at packages install and it is taking forever, any idea why?

00:40:18 [davb]

it does take forever :)

00:40:35 [beattiek]

okay good

00:41:28 [davb]

yeah! an error message!!

00:41:52 [beattiek]

Acs-kernel not installed.

00:41:59 [beattiek]

that is bad right?

00:42:17 [davb]

yeah. hmmm any more info? you might have to explore the server error log to get the real reason.

00:42:28 [beattiek]

okay

00:42:39 [AaronSw]

so how is all in openacs land?

00:42:49 [beattiek]

going slow

00:42:56 [beattiek]

there is always a problem.

00:43:13 [davb]

The project is moving forward, but the holidays are slowing down the last bits of the release especially the documentation.

00:43:25 [AaronSw]

hmm

00:43:31 [AaronSw]

to be expected

00:43:41 [davb]

yes.

00:43:41 [AaronSw]

i came in here a while back and it seemed awfully quiet...

00:43:51 [davb]

well vinod went on vacation on us...

00:44:22 [davb]

how can I tell if my firewall (ipchains) is blocking port 6667?

00:44:41 [davb]

actually it can't be... duh chump is on it...

00:44:56 [davb]

but they both should be able to run right?

00:45:00 [davb]

or am I dumb?

00:45:02 [beattiek]

dav, where is the server log?

00:45:08 [AaronSw]

yeah, they should both run

00:45:17 [davb]

beattiek try /usr/lib/aolserver/log

00:45:22 [beattiek]

nope..

00:45:29 [beattiek]

that what i hoped

00:45:35 [davb]

try /var/log/something

00:45:48 [davb]

that is where it actually belongs anyway :)

00:46:23 [davb]

any special user have to run logger?

00:46:52 [davb]

I guess not...

00:47:01 [beattiek]

does this look like it?

00:47:11 [beattiek]

<---spam eminent--->

00:47:13 [beattiek]

[11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: access(/var/www/homecity/www/errorpage.adp, R_OK) failed: No such file or directory

00:47:13 [beattiek]

[11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: [ns/server/homecity/adp]errorpage reset to NULL

00:47:13 [beattiek]

[11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: access(/var/www/homecity/www/startpage.inc, R_OK) failed: No such file or directory

00:47:13 [beattiek]

[11/Dec/2001:17:05:35][27397.1024][-main-] Error: conf: [ns/server/homecity/adp]startpage reset to NULL

00:47:21 [davb]

beattiek thats it.

00:47:37 [beattiek]

hmmm

00:47:44 [davb]

btw all you have to do it look in the server config file to find out where it is putting it :) (sorry I just though it that)

00:47:53 [davb]

but I don't know what that error means.

00:48:14 [beattiek]

well it means i'm missing two files, right?

00:49:07 [beattiek]

wait a sec

00:49:11 [beattiek]

those are old errors

00:49:25 [beattiek]

11 Dec not 17 Dec

00:50:45 [AaronSw]

i better be off, c'yas

00:50:46 [AaronSw]

AaronSw has left #openacs

00:53:05 [davb]

brb

00:53:15 [til]

beattiek: what's your document root set to?

00:53:34 [davb]

brb

00:53:38 [davb]

davb has quit ()

00:53:45 [beattiek]

i'm not sure

00:54:04 [beattiek]

/usr/share/doc i think...

00:55:59 [til]

there should be a line "ns_param pageroot" somewhere

00:56:37 [til]

in the config file

00:56:54 [beattiek]

s_param pageroot $pageroot

00:56:57 [beattiek]

that?

00:57:21 [til]

yeah ... ok, look further up, what is the variable $pageroot being set to?

00:58:04 [til]

(cool thing about this config file: you can just execute any tcl code you want, including simplifiyng your life or making it more complicated with variables)

00:58:10 [beattiek]

/var/www/${server}/www

00:58:48 [beattiek]

so /var/www/homecity/www computed.

01:01:02 [til]

and that exists, right?

01:02:24 [beattiek]

yes

01:02:27 [beattiek]

:P

01:02:50 [til]

ok, that would have been too easy ;-)

01:02:57 [beattiek]

yeah

01:03:05 [beattiek]

but as i mentioned, the files are not there.

01:03:09 [beattiek]

some are

01:03:11 [til]

do you have a "ns_param startpage" in your config file?

01:03:32 [til]

comment that out

01:03:33 [beattiek]

no...

01:04:27 [beattiek]

i don't have it.

01:04:40 [beattiek]

the error was from OACS congiuring modules

01:05:08 [beattiek]

and it was not a current one

01:05:16 [til]

oh yes, sorry

01:05:22 [beattiek]

np

01:05:34 [til]

so what's the current error then?

01:05:37 [beattiek]

i still haven't located it

01:05:44 [beattiek]

thats the current problem

01:06:08 [beattiek]

i am running updatedb

01:06:34 [til]

you are looking for the error log?

01:06:49 [beattiek]

yes

01:07:05 [til]

look for "ns_param serverlog" in the config file

01:07:34 [beattiek]

that would be the problem

01:08:00 [beattiek]

i have this:

01:08:01 [beattiek]

ns_param nslog nslog.so

01:08:07 [beattiek]

but not that.

01:08:22 [til]

nslog is only the access log, the server log is sth different

01:09:47 [til]

strange ... where is this config file from? well, just enter a meaningful file location and make sure that is writable for the aolserver process

01:09:50 [beattiek]

so ns_param serverlog /var/log/aolserver.log

01:09:57 [til]

y

01:10:12 [beattiek]

It is a ACS 3 config file

01:12:21 [beattiek]

i meant ns_param serverlog /var/log/aolserver

01:13:05 [til]

in my config file it includes the filename: "ns_param ServerLog /var/log/aolserver/server.${servername}.log"

01:13:05 [beattiek]

should this be under ns_section "ns/server/${server}/module/nslog"

01:13:25 [til]

no, here: "ns_section "ns/parameters""

01:16:50 [beattiek]

where did you get the config file from?

01:17:34 [til]

i think i took that one from the aolserver source distribution and modified it according to the instructions of the openacs doc

01:17:41 [beattiek]

Error: Error sourcing /var/www/homecity/packages/acs-bootstrap-installer/installer/packages-install.tcl:

01:18:08 [beattiek]

psql:acs-install.sql:247: ERROR: apm_packages_package_key_fk referential integrity violation - key referenced from apm_packages not found in

01:18:08 [beattiek]

apm_package_types

01:18:08 [beattiek]

psql:acs-install.sql:254: ERROR: ExecAppend: Fail to add null value in not null attribute object_id

01:20:14 [beattiek]

i missed this: env: write error: Broken pipe

01:21:02 [til]

is this happening on a freshly created database?

01:22:10 [beattiek]

not any more

01:22:17 [beattiek]

i mean, it was fresh

01:22:33 [beattiek]

then i ran the OACS config.

01:22:44 [beattiek]

it had an error and then i did it again

01:22:55 [beattiek]

this is the second error

01:24:56 [til]

with OACS config you mean pushing the "install" button or whatever it is called? if yes then you should better try to do dropdb and creatdb again

01:25:40 [beattiek]

okay

01:25:53 [til]

and don't forget to do createlang

01:26:14 [til]

if you did not executed it on the template1 db before

01:26:23 [beattiek]

?

01:27:52 [beattiek]

well i am installing the data model again

01:27:59 [til]

http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0001YU&topic_id=12&topic=OpenACS%204%2e0%20Design

01:28:00 [chump]

D: http://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0001YU&topic_id=12&topic=OpenACS%204%2e0%20Design from til

01:31:21 [beattiek]

it seems to be doing better now

01:31:37 [til]

did you do createlang?

01:31:50 [beattiek]

nope

01:32:44 [beattiek]

it is working fine, should i do it?

01:33:25 [til]

well, at least some time ago it was essential

01:33:40 [til]

try how far you get

01:33:52 [beattiek]

createlang: 'plpgsql' is already installed in database template1

01:33:58 [beattiek]

page 3 or 4

01:34:00 [til]

perfect!

01:34:07 [beattiek]

OpenACS Installation: Create Administrator

01:34:18 [beattiek]

i'm so happy

01:34:34 [til]

:-)

01:34:35 [beattiek]

one day it may actualy be a web site!

01:37:19 [beattiek]

hmm

01:40:01 [davb]

davb (dave@alb-24-58-160-135.nycap.rr.com) has joined #openacs

01:40:12 [beattiek]

hey dave

01:41:05 [davb]

hi.

01:41:47 [beattiek]

i got it working

01:41:50 [davb]

cool!

01:42:43 [davb]

was it an error in the server config file?

01:42:54 [beattiek]

soon i will be able to take over the world right? (yeah)

01:43:06 [davb]

right!

01:43:06 [beattiek]

that _is_ what the OACS does right?

01:43:11 [beattiek]

okay good

01:43:13 [talli]

talli has quit ("See ya!")

01:43:17 [beattiek]

just checking

01:43:40 [davb]

YOu need the evil module though... and it only runs on oracle :)

01:43:50 [beattiek]

damn

01:43:56 [beattiek]

thats too expensive

01:44:08 [beattiek]

i will settle for the good module for now

01:44:22 [beattiek]

damn PGSQL

01:44:24 [beattiek]

:P

01:45:21 [beattiek]

okay so i still need to install packages

01:58:36 [davb]

argh is the internet broken or just me?

01:58:46 [davb]

I can't get to alot of web sites....

01:59:41 [davb]

beattiek: how is package install going?

02:06:27 [davb]

going back to the light side...

02:06:30 [davb]

davb has quit ()

02:09:24 [Psychephylax]

gah

02:09:32 [Psychephylax]

I don't use Unix and it breaks

02:09:34 [Psychephylax]

That's a first

02:10:52 [davb]

davb (~dave@alb-24-58-160-135.nycap.rr.com) has joined #OpenACS

02:12:04 [davb]

hmmm dns is OK

02:12:56 [davb]

ok...

02:15:22 [davb]

this explains it: Every page made by our software was generated by a program written

02:15:22 [davb]

in Rtml. We called these programs templates to make them less

02:15:22 [davb]

frightening, but they were real programs. In fact, they were Lisp

02:15:22 [davb]

programs. Rtml was a combination of macros and the built-in Lisp

02:15:22 [davb]

operators.

02:15:38 [davb]

a quote from the creator of ViaWeb which became Yahoo store.

02:16:34 [davb]

Eventually we made it our goal

02:16:34 [davb]

that no one should ever have to use Rtml.

02:16:43 [davb]

so there is no documentation :(

02:19:39 [beattiek]

davb: I havn't started yet, i'm celebrating

02:26:14 [davb]

excellent. excuse my little rant re: Yahoo Store

02:47:30 [til]

til has quit ("Download Gaim [http://gaim.sourceforge.net/]")

02:49:11 [talli]

talli (talli@lti-4.dialup.access.net) has joined #openacs

02:49:15 [talli]

talli has quit (Remote closed the connection)

03:06:54 [Psychephylax]

Psychephylax has quit (forward.openprojects.net irc.openprojects.net)

03:10:23 [Psychephylax]

Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #OpenACS

03:29:03 [davb]

davb has quit (forward.openprojects.net irc.openprojects.net)

03:29:03 [chump]

chump has quit (forward.openprojects.net irc.openprojects.net)

03:29:03 [Psychephylax]

Psychephylax has quit (forward.openprojects.net irc.openprojects.net)

03:29:58 [Psychephylax]

Psychephylax (proxy@ool-18baa98f.dyn.optonline.net) has joined #OpenACS

03:29:58 [chump]

chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #OpenACS

03:29:58 [davb]

davb (~dave@alb-24-58-160-135.nycap.rr.com) has joined #OpenACS

03:30:15 [ChanServ]

[#OpenACS] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog

03:30:18 [davb]

davb has quit (forward.openprojects.net irc.openprojects.net)

03:30:18 [chump]

chump has quit (forward.openprojects.net irc.openprojects.net)

03:34:11 [davb]

davb (~dave@alb-24-58-160-135.nycap.rr.com) has joined #OpenACS

03:34:11 [chump]

chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #OpenACS

03:45:12 [davb]

now to record some CDs

03:45:55 [davb]

Psychephylax: do you know if I can do CDROM -> CDR direct in linux?

04:09:41 [davb]

nm

04:09:42 [davb]

later

04:09:47 [davb]

davb has quit ("I'm too lame to make a quit message")

05:09:26 [chump]

chump has quit (Ping timeout: 180 seconds)

05:10:27 [chump]

chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs

05:11:39 [Psychephylax]

hmm?

08:26:39 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

08:29:39 [miguel]

miguel has quit (Ping timeout: 180 seconds)

08:35:46 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

08:37:10 [miguel]

hi guys!!

08:40:10 [miguel]

miguel has quit (Ping timeout: 180 seconds)

09:08:56 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

09:10:14 [miguel]

hi guys!!!

09:28:47 [miguel]

miguel has quit (Ping timeout: 180 seconds)

09:32:59 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

09:36:01 [miguel]

hi guys!

12:16:02 [miguel]

miguel has quit (Ping timeout: 180 seconds)

12:18:54 [ChanServ]

[#OpenACS] This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog

12:31:08 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

12:35:54 [miguel]

hi guys!!1

13:25:54 [miguel]

miguel has quit ()

13:44:15 [davb]

davb (~dave@208.136.23.203) has joined #openacs

13:56:31 [chump]

chump has quit (Remote closed the connection)

13:57:17 [chump]

chump (~chump@alb-24-58-160-41.nycap.rr.com) has joined #openacs

14:08:39 [davb]

I wonder if only one logger can attend...

15:17:01 [davb]

davb has quit ()

15:29:16 [davb]

davb (~dave@208.136.23.203) has joined #openacs

15:48:43 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

15:48:49 [miguel]

hi guys!!!

15:49:29 [ola]

ola (~ola@as3-1-3.mal.s.bonet.se) has joined #openacs

15:49:42 [ola]

hi.

15:50:31 [davb]

hi ola and miguel

15:50:52 [ola]

davb: I found a bug in static-pages-procs.tcl...

15:51:25 [ola]

static_pages_regexp needs to escape two backslashes

15:51:59 [davb]

yipee!

15:52:10 [davb]

I gotta get you CVS access :)

15:52:15 [ola]

what? :-)

15:52:22 [ola]

cool

15:52:31 [davb]

Its always good when you can fix something.

15:52:47 [davb]

That is kinda weird, I never messed with those, that is a leftover from aD.

15:53:22 [ola]

nope. a leftover from ME. :-(

15:53:33 [davb]

heh

15:53:45 [davb]

ok, send me a patch for now.

15:53:53 [davb]

You have an account at Openacs.org for CVS right?

15:54:06 [ola]

yes I do.

15:54:24 [davb]

cool. I'll just ask Don to add you to /static-pages

15:55:49 [ola]

thanks dave. in that case I can commit to cvs myself...

15:56:01 [ola]

wohoo!

15:56:25 [davb]

ok. i emailed donb.

15:56:43 [davb]

oops. I hope he knows your username, I didn't send it :)

15:57:02 [ola]

lemme know what he says, ok?

15:57:07 [davb]

np.

15:57:17 [ola]

he knows it:-)

15:58:37 [davb]

cool.

16:02:53 [davb]

You know what strikes me as amazing?? The visual basic editor can do all kinds of fancy stuff, guess what command you are typing etc... but it does not autoindent if, do , etc...

16:03:15 [davb]

I mean come on, it has all these incredible features, but you have to tab/backspace to line up your code!!

16:03:46 [miguel]

he he he

16:03:59 [miguel]

what did you expect?

16:04:02 [davb]

once you hit tab, it lines up all lines to that tabstop until you hit tab or backspace again. all the other timesaving features are wasted!

16:04:17 [davb]

Well, I use emacs, so I exepcted it to work :) silly of me.

16:04:57 [miguel]

try visual c++, you will know something good ;)

16:05:03 [miguel]

(just been ironic ;) )

16:05:09 [ola]

lol

16:05:11 [davb]

heh

16:05:42 [davb]

I wonder if there is a Visual Basic for Access mode for emacs?? :)

16:07:10 [miguel]

you mean that you want to use emacs for using Access (the dbase) ?

16:07:44 [davb]

sure why not :) I am sure it could be done.

16:07:52 [davb]

Just to edit the VB code.

16:08:41 [davb]

Actually I'd rather not use Access at all, but that is not my choice to make :(

16:08:42 [miguel]

how? i am getting lost, there is any open sourced VB?

16:09:13 [Psychephylax]

woooohoooo

16:09:32 [Psychephylax]

Hola ola! greetings dave :)

16:09:45 [davb]

hey Psychephylax

16:09:49 [davb]

miguel nope.

16:09:50 [davb]

http://lists.debian.org/debian-jr/2001/debian-jr-200105/msg00019.html

16:09:51 [chump]

A: http://lists.debian.org/debian-jr/2001/debian-jr-200105/msg00019.html from davb

16:10:06 [davb]

A:|Mailing list post that mentions VB mode for emacs, but the link is broken :(

16:10:07 [chump]

titled item A

16:11:00 [miguel]

ok didnt know. you mean just editing VB code with emacs and then port it to your windows box (or are u using emacs under windows?)

16:11:34 [davb]

I have emacs for windows too :)

16:11:35 [davb]

http://www.tardis.ed.ac.uk/~skx/win/NTEmacsFAQ/NTEmacs-split218.html

16:11:36 [chump]

B: http://www.tardis.ed.ac.uk/~skx/win/NTEmacsFAQ/NTEmacs-split218.html from davb

16:11:39 [miguel]

ok

16:11:45 [davb]

B:|Two links to VB mode for emacs!! :)

16:11:46 [chump]

titled item B

16:12:14 [miguel]

he he he so u just got it!!

16:13:02 [Psychephylax]

I have to go do the modem inventory now

16:13:07 [Psychephylax]

that should take me a while

16:13:07 [miguel]

are you using Visual Basic? why dont you switch over C++ Builder? Its a lot better

16:13:48 [davb]

Its inside Access. We don't actually own VB.

16:15:14 [miguel]

then you mean Access Basic?

16:15:41 [davb]

Yeah, its Visual Basic for Applications/Access.

16:16:47 [miguel]

ok

16:16:56 [davb]

davb has changed the topic to: Topic? What Topic? http://openacs.org

16:17:43 [miguel]

i have used c++ builder for a while and it is quite good, much better than Visual Basic. I have developed some Dbase applications to work with PostgreSQL and works fine

16:18:18 [davb]

great!

16:18:24 [miguel]

there is a driver for Borland compilers (Delphi, Kylix - Delphi in linux, C++ Builder) to access

16:18:33 [miguel]

PostgreSQL

16:18:44 [miguel]

and it is very easy to use

16:19:04 [miguel]

its powerful as C++ and the use of APIs (which are in C)

16:19:28 [miguel]

and very easy for developing interfaces very fast

16:19:32 [miguel]

sorry for the off-topic

16:20:21 [davb]

heh np, we are always off topic :)

16:20:33 [miguel]

he he he

16:21:00 [miguel]

i just wanted to give you some tips, maybe you never heard about c++ builder or that you could use it with PG

16:22:31 [miguel]

but some people say that the future will be .NET

16:22:47 [miguel]

i have to read these Xmas something about it, i dont want to get lost

16:24:13 [davb]

thanks. If you program for windows, you will need to learn .NET

16:24:46 [davb]

Of course, Python, Tcl, Perl, Ruby, etc... all run on Windows.

16:26:17 [miguel]

I would like to know much about programming with widgets and work with Kylix but if you want to make money in this world you need to know how to program applications in Windows (although you use linux as servers ;) )

16:27:46 [miguel]

sorry i should have written (much more and not only much) sorry for my english ;)

16:28:03 [davb]

np at all.

16:28:04 [davb]

:)

16:29:00 [miguel]

over here people use windows a lot, at least customers, however universities embraced linux

16:29:13 [miguel]

(low budgets)

16:29:37 [davb]

of course. We have to budget, but they are not interested in non-MS solutions.

16:29:43 [davb]

s/to/no

16:31:52 [miguel]

who? your company?

16:32:08 [davb]

I work for a small New York State goverment agency.

16:32:28 [davb]

I do OpenACS on the side.

16:32:37 [Psychephylax]

He works for the CIA

16:32:44 [davb]

heh, not even close.

16:33:04 [davb]

it's more like, if I told you, you would be bored to death.

16:33:21 [Psychephylax]

Actually

16:34:17 [miguel]

not really

16:36:42 [davb]

We enforce the Taylor law which is the law allowing public employees to unionize, and sets the rules for resolving disputes in bargaining relationships, representation of public employees etc...

16:37:11 [davb]

ack

16:38:02 [miguel]

i am spanish, so i dont know very much about US laws

16:38:25 [davb]

thats ok most americans don't know very much about US laws either :)

16:40:20 [Psychephylax]

As I was saying

16:40:32 [miguel]

US laws let employees to unionize? after watching Hoffa i thought that unions in the US have not very much power ;) just kidding

16:40:36 [Psychephylax]

Dave is the guy they send out when the local farmers need to count their sheep

16:40:43 [davb]

Psychephylax: heh

16:40:45 [miguel]

lol

16:41:38 [davb]

This is for civil servants. Until 1969 they were not allowed to unionize. Now they can, but it is illegal for them to go on strike, hence the mission of our agency to help resolve disputes.

16:42:23 [Psychephylax]

You mean count the sheep

16:42:36 [Psychephylax]

"Farmer Bob stole my sheep"

16:42:37 [miguel]

and if you are not a civil servant then you can go on strike?

16:42:43 [Psychephylax]

Quick, send out Counter Dave

16:42:48 [miguel]

or unionize?

16:42:53 [davb]

Basically.

16:43:24 [miguel]

over here, civil servants are the very first ones that go on strike ;)

16:43:38 [miguel]

and the unions are much stronger among them

16:43:41 [davb]

aha.

16:43:54 [Psychephylax]

http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=19

16:43:55 [chump]

C: http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=19 from Psychephylax

16:44:01 [Psychephylax]

C:| they stole ACS

16:44:02 [chump]

titled item C

16:44:07 [Psychephylax]

C: Damn theives

16:44:08 [chump]

commented item C

16:44:16 [miguel]

in fact, my mother is a teacher (public one) and she is working for a while for a teacher union

16:44:44 [davb]

Yes we have alot of teachers!

16:45:20 [miguel]

anyway we have a conservative prime minister which means that you can cry out as much as you want but nobody cares in the gov

16:45:47 [miguel]

there is really a big fuss over here in the university, they want to change the law

16:46:38 [davb]

It is a very big issue.

16:46:55 [talli]

talli (talli@lti-4.dialup.access.net) has joined #openacs

16:46:59 [miguel]

well, actually they changed without asking the responsibles, teachers and students, never see a teachers agreeing with students for going on a strike, but now...

16:47:04 [talli]

hey guys

16:47:05 [Psychephylax]

hi talli

16:47:10 [davb]

C: Hey! He gives credit to the original Psets in the Copyright/Credit section

16:47:10 [chump]

commented item C

16:47:20 [davb]

hi talli

16:47:20 [miguel]

have you heard anything out there about that?

16:47:40 [Psychephylax]

that's funny though

16:47:47 [davb]

Psychephylax: yes

16:48:04 [davb]

Psychephylax: we need Psets for OpenACS/PG hackers now.

16:48:12 [Psychephylax]

heh

16:48:15 [davb]

phew, good thing RBM didn't hear me say that.

16:48:15 [Psychephylax]

* Psychephylax wanders off

16:49:12 [miguel]

davb: i am just starting off, but i am finishing off the pset 1 using OACS/PG

16:49:29 [miguel]

writting down the problems I had so far with the differences between PG and Oracle

16:49:37 [miguel]

and because i was using OACS

16:49:37 [davb]

Excellent.

16:50:04 [miguel]

actually i am working now on the mini-project of pset 1

16:50:46 [miguel]

it took me 8 days to finish off pset1, because the differences that made me to look around in some books (of PG for instance)

16:51:32 [miguel]

my responsible thinks that it is too much

16:51:35 [miguel]

time

16:51:36 [davb]

a great learning opportunity! :)

16:52:05 [davb]

That is not too much time to learn a new system, database and finish the problem set I think.

16:52:13 [davb]

Have you programmed Tcl before?

16:52:16 [miguel]

i knew a bit of linux, postgresql

16:52:19 [miguel]

no, just php

16:52:24 [miguel]

i had to learn first

16:52:49 [miguel]

also it took me two weeks to set up the whole system, thanks that ola helped me out

16:53:09 [miguel]

i just could set up from sources aolserver and PG, but didnt know very much about OACS

16:53:22 [miguel]

and how to debug the errors of Aolserver

16:53:50 [Psychephylax]

I'm sleepy

16:53:59 [davb]

Psychephylax: its lunchtime!

16:54:09 [davb]

naptime is later.

16:54:23 [Psychephylax]

I'm just tired from staying up

16:54:28 [Psychephylax]

too late last few days

16:54:29 [miguel]

I hope next week i will have a step-by-step guide (thanks to ola)

16:54:50 [davb]

that is really great!

16:55:37 [miguel]

i think that even for guys like me that know a little bit, it takes time to figure out how to set up OACS

16:56:05 [davb]

ITs all the seperate pieces. You have a little problem with each piece.

16:56:15 [miguel]

there were just a few things that i needed to touch actually, but without the guidance of ola, it would have taken me more time

16:56:22 [davb]

did you have trouble with nsxml?

16:56:34 [miguel]

what is that for?

16:56:43 [davb]

it is a module for aolserver.

16:56:50 [davb]

if you installed frm an RPM its included I think.

16:57:01 [miguel]

i tried with rpms but didnt work

16:57:12 [miguel]

and then i tried it from sources and did work

16:57:17 [miguel]

i have a RH 7.2 linux box

16:57:20 [davb]

are you using 3 or 4?

16:57:25 [miguel]

3

16:57:34 [davb]

aha. that doesn't use nsxml :)

16:58:07 [miguel]

i downloaded the rpms recommended for RH 6.2 and 7.1 but none of them did work

16:58:18 [Psychephylax]

because rpms suck :)

16:58:46 [miguel]

i rather prefer to compile myself, that way i know a little bit more what I am installing

16:59:41 [miguel]

actually i am quite dissapointed with my "boss", he hasnt help me out and i have to do everything by myself, thanks that i found this channel

17:00:08 [davb]

miguel: does your "boss" know Psychephylax's boss?

17:00:09 [davb]

:)

17:00:25 [miguel]

no i dont think so

17:00:28 [miguel]

;)

17:00:37 [miguel]

may i ask why?

17:00:54 [Psychephylax]

lol

17:01:22 [miguel]

no, i do happen to work in Spain

17:01:28 [Psychephylax]

Hmmm

17:02:06 [miguel]

you mean that your boss insists in he know OACS when he actually doesnt?

17:03:16 [Psychephylax]

mine?

17:03:25 [miguel]

yes yours ;)

17:03:43 [Psychephylax]

He inisists that i use it

17:03:49 [miguel]

he he he

17:04:12 [miguel]

well, i guess your boss´ attitude is not very far from mine

17:04:22 [Psychephylax]

yup

17:06:48 [miguel]

the funny thing is that i am learning OACS for no money

17:07:00 [Psychephylax]

heh

17:07:04 [davb]

me too!

17:07:06 [Psychephylax]

Elaborate on that

17:07:10 [miguel]

and my boss told me that I am being lazy (just because all the problems that I got) and hopefully

17:07:54 [miguel]

and i would not get a grant because of that (the rest of my group are working with Psets with ACS and Oracle)

17:08:21 [miguel]

besides i am working alone, no help at all, and that group they know each other

17:08:33 [Psychephylax]

is this for school or work?

17:09:01 [miguel]

a mix

17:09:26 [miguel]

i am still in college (finishing off my CS degree)

17:09:47 [Psychephylax]

heh

17:09:49 [miguel]

and i have joined a group of "visionaries" that want to set up a company who will work

17:09:50 [Psychephylax]

Sounds like me

17:09:59 [miguel]

with ACS

17:10:04 [davb]

aha!

17:10:06 [davb]

:)

17:10:07 [Psychephylax]

I was working on ACS for work while finishing CS

17:10:55 [miguel]

and i am working as intern in a small research institute, my director gave them good references cause last year i got an A grade

17:11:37 [Psychephylax]

heh

17:11:43 [Psychephylax]

I'm working as an intern :)

17:11:53 [miguel]

he he he

17:12:00 [miguel]

my US soul mate ;)

17:12:03 [Psychephylax]

:)

17:12:24 [Psychephylax]

I emailed the VP of one of the divisions asking him for an internship

17:12:28 [miguel]

i got an A grade last year because a project i did working on Apache+SSL+PHP

17:12:38 [miguel]

postgresql

17:12:45 [miguel]

and c++ builder (windows side)

17:12:54 [miguel]

VP? what is that?

17:13:27 [Psychephylax]

Dave?

17:15:20 [miguel]

psychephylax: have you done the psets?

17:15:28 [Psychephylax]

nope

17:15:34 [Psychephylax]

VP = Vice President

17:15:38 [miguel]

and you dave?

17:16:30 [Psychephylax]

I started and did a part of 1

17:16:56 [miguel]

ok psyche, sometimes i got lost with all these...how you call a word like VP that stands for something?

17:17:04 [davb]

Psychephylax how may I help you.

17:17:20 [Psychephylax]

Dave

17:17:24 [davb]

I just read Philip's book and then found OpenACS.

17:17:31 [Psychephylax]

why the hell can't I do if { } else { }

17:17:36 [davb]

So I started fooling around.

17:17:40 [Psychephylax]

And then he counted sheep

17:17:41 [davb]

you can

17:17:52 [davb]

if {condition} {

17:17:54 [davb]

stuff

17:17:56 [davb]

} else {

17:18:00 [davb]

more stuff

17:18:00 [davb]

}

17:18:13 [davb]

the else HAS to be between } else { all on one line.

17:18:16 [davb]

Tcl is wacky like that.

17:18:18 [Psychephylax]

Blast ACS and it's white space un-ignorance

17:18:25 [davb]

not ACS. Tcl

17:18:25 [miguel]

yes dave i have suffered it

17:18:48 [davb]

I built a little web site, then promptly failed to work on it :)

17:18:57 [Psychephylax]

Same here

17:18:59 [davb]

Then I started proting on OpenACS 4.

17:19:00 [Psychephylax]

but mine wasn't OPenACS

17:19:50 [davb]

Then I came to this channel and helped Psychephylax.

17:19:54 [Psychephylax]

I do like emacs though

17:19:55 [davb]

:)

17:20:03 [Psychephylax]

hehe

17:20:08 [miguel]

he he he

17:20:18 [Psychephylax]

yeah between the 4-5 of us in the channel we have a whole ACS team here

17:20:18 [miguel]

you guys know anything about ns_schedule_proc^?

17:20:28 [davb]

miguel A little.

17:20:30 [Psychephylax]

I believe

17:20:42 [Psychephylax]

it's used to schedule specific procedures to run at a specific time

17:20:44 [davb]

Psychephylax: don't forget vinod and rbm...

17:20:51 [Psychephylax]

Right

17:20:58 [Psychephylax]

between 6 or 7 of us here

17:21:00 [davb]

heh

17:21:03 [Psychephylax]

Mark - Databases

17:21:07 [miguel]

ACS team? you develop code for OACS?

17:21:12 [Psychephylax]

Dave - To smack me around when I make stupid mistakes

17:21:23 [Psychephylax]

Vinod - Tcl/Oracle genius

17:21:32 [Psychephylax]

Talli - he manages us all

17:21:36 [davb]

miguel: I worked on porting. I am supposed to be building some other modules, but haven't had a change to work on them.

17:21:41 [Psychephylax]

Rbm - provides all the documentation

17:21:59 [Psychephylax]

Me - I make stupid mistakes and ask them to help

17:22:06 [miguel]

dave i want to schedule a tcl script, where i have to execute it? dont know how it works

17:22:10 [Psychephylax]

Ola - we still don't know what he does :)

17:22:23 [Psychephylax]

But it must be important

17:22:48 [miguel]

greenspun is still in MIT and working for Arsdigita?

17:22:51 [davb]

miguel: ns_schedule_proc usually is run from the tcl library directory.

17:23:02 [davb]

Still at MIT, not arsDigita.

17:23:04 [miguel]

the private one?

17:23:10 [davb]

miguel: yes.

17:23:28 [davb]

let me find an example.

17:23:46 [miguel]

so i just create a tcl file that executes ns_schedule?

17:23:54 [davb]

YES.

17:24:09 [miguel]

but i can point to a file which is not in the tcl private lib?

17:24:31 [davb]

No. the proc it calls needs to be in the library also.

17:24:42 [miguel]

ok

17:24:46 [miguel]

thanks dave

17:24:46 [davb]

Usually in OpenACS the proc is created, then scheduled in the same file at the end.

17:24:49 [davb]

np,

17:25:10 [davb]

You could have a tcl page schedule a proc also when it was run.

17:25:30 [miguel]

what?

17:25:51 [miguel]

do you know philip personally?

17:25:55 [davb]

no.

17:26:31 [davb]

I planned on attending one of the seminars, but never made it.

17:26:41 [davb]

I also missed all the OpenACS socials :(

17:26:42 [miguel]

ok

17:27:18 [miguel]

can u explain me a little bit more that thing about a tcl page?

17:27:49 [davb]

I'll try.

17:28:54 [davb]

Say for some reason you wanted a web interface to schedule some recurring event on the server. The tcl script attached to that page could call ns_schedule_proc. Its just more common to schedule all those things on server startup.

17:29:49 [miguel]

how can i set it up from a web interface?

17:32:02 [davb]

Probably with some sort of form that would parse the input and convert it into the proper syntax along with security checking :)

17:33:36 [Psychephylax]

bah

17:33:42 [Psychephylax]

I have to pay 500$ to Sprint PCS

17:34:11 [miguel]

but how can i say to the system to schedule a tcl script?

17:34:41 [davb]

it can only schedule one proc.

17:35:05 [davb]

for each ns_schedule_proc anyway, of course that could be an entire script.

17:35:26 [davb]

I think I am not explaining it well :)

17:35:38 [miguel]

only one proc?

17:35:43 [miguel]

that means that i have to add to the tcl script to execute the code to add?

17:36:01 [miguel]

i mean to add the reference to a new proc in the tcl script

17:36:34 [davb]

you need to create a proc to run whatvever code you want run, yes.

17:36:46 [davb]

proc myproc {} {

17:36:49 [davb]

a bunch of code

17:36:50 [davb]

}

17:37:04 [davb]

ns_schedule_proc -thread 3600 myproc

17:37:09 [davb]

or something like that.

17:37:54 [davb]

inside myproc you can have any code you want.

17:37:54 [miguel]

and inside myproc i have to add all what i want? that means that i can parse a new proc to execute and just put it in the end of myproc?

17:38:04 [miguel]

by the way can i execute a .tcl script?

17:38:17 [davb]

you could using source

17:38:27 [davb]

source "path to tcl script"

17:39:12 [davb]

I don't think you would want to define a new proc inside the scheduled proc. it would be recreated every time the sheduled proc was run.

17:39:26 [miguel]

so how?

17:39:37 [miguel]

i meant i can execute a tcl script with ns_schedule

17:39:37 [davb]

maybe I am confused.

17:40:07 [davb]

grep for 'ns_schedule_proc' in the OpenACS private tcl library. There should be alot of examples in there.

17:40:15 [davb]

that might explain it better than I can.

17:41:11 [davb]

brb

17:42:37 [miguel]

miguel has quit (Ping timeout: 180 seconds)

17:46:06 [miguel]

miguel (~miguel25@cancerbero.unileon.es) has joined #openacs

17:47:26 [Psychephylax]

lunchtime

17:47:28 [Psychephylax]

bbl

17:47:31 [miguel]

dave i got disconnected. the net today is a bit crappy

17:47:37 [miguel]

where were we?

17:49:43 [miguel]

dave i go for a coffe, ill be back in 15 minutes

18:18:43 [graszew]

graszew (~rob@pc218.warszawa.sdi.tpnet.pl) has joined #openacs

18:24:41 [davb]

ola: done

18:24:50 [talli]

talli has quit (Ping timeout: 180 seconds)

18:24:53 [davb]

you now have commit acces to static-pages :)

18:44:42 [til]

til (tils@port-212-202-128-201.reverse.qsc.de) has joined #openacs

18:44:58 [Psychephylax]

back

18:56:37 [miguel]

ok sorry i am back

19:07:19 [Psychephylax]

:/

19:13:16 [davb]

working... I'll be in an out :)

19:21:26 [til]

til has quit (Ping timeout: 180 seconds)

19:23:28 [Psychephylax]

me too

19:23:55 [talli]

talli (~user@xcdfddb76.ip.ggn.net) has joined #openacs

19:26:21 [Psychephylax]

:)

19:43:40 [davb]

davb has quit (Read error: 104 (Connection reset by peer))

19:50:52 [davb]

davb (~dave@208.136.23.203) has joined #openacs

19:53:27 [davb]

anyone know a quick way to select the next and previous record in a query?

19:53:39 [davb]

I have entries by date, but not one every day.

19:53:52 [davb]

I want to select the previous and next day that there was an entry.

19:55:59 [Psychephylax]

hmm?

19:56:19 [davb]

I am trying to figure out a way to add previous and next links to my weblog.

19:56:29 [Psychephylax]

hold on

19:56:32 [davb]

ok

19:56:54 [davb]

* davb should be working, but this is bugging him

19:57:03 [Psychephylax]

wouldn't it be

19:57:49 [Psychephylax]

where date = date - 1 OR date = date + 1

19:58:14 [davb]

thanks, but there is not necessarily an entry every day :)

19:59:39 [Psychephylax]

hmmm

19:59:42 [Psychephylax]

right

19:59:52 [Psychephylax]

you'd need subqueries then

20:00:00 [Psychephylax]

to select the dates smaller and larger

20:00:08 [Psychephylax]

and take the min(date) and max(date)

20:01:07 [Psychephylax]

like select * from (min(select * from records where date < today))...etc

20:01:15 [Psychephylax]

Mark would help you better

20:01:17 [davb]

I did this: (two queies)

20:01:50 [davb]

select entry_id from blog where entry_date < $my_entry_date order by entry_date desc limit 1

20:02:01 [davb]

and the other one is <

20:03:26 [Psychephylax]

That should work

20:13:55 [Psychephylax]

Did it work?

20:15:09 [davb]

the query seems to work, the rest of my code still sucks :)

20:18:00 [Psychephylax]

heh

20:18:04 [Psychephylax]

sounds like my databases project

20:22:17 [davb]

heh

20:22:18 [miguel]

ok guys, i gotta go home

20:22:22 [miguel]

bye!

20:22:29 [davb]

the problem is I reused the same var name in every query :)

20:22:30 [davb]

bye!

20:23:10 [Psychephylax]

bye bye

20:23:16 [miguel]

miguel has quit ()

20:24:43 [Psychephylax]

Dave?

20:26:09 [davb]

yes?

20:26:17 [davb]

It works except on the last day the next link still appears.

20:26:24 [Psychephylax]

Isn't Malaysia like some really technologically advanced nation

20:26:45 [Psychephylax]

so check for NOT EXISTS

20:27:01 [davb]

well the query should just return 0 rows...

20:27:06 [davb]

I'll have to look further.

20:27:08 [davb]

:)

20:27:46 [davb]

not sure about malaysia, except consumer electronics are manufactured there.

20:27:53 [Psychephylax]

http://net-snmp.sourceforge.net/postcards/postcard.59.html

20:27:53 [chump]

D: http://net-snmp.sourceforge.net/postcards/postcard.59.html from Psychephylax

20:27:59 [Psychephylax]

D:| Malaysia?

20:27:59 [chump]

titled item D

20:28:56 [Psychephylax]

LOL!!!! http://net-snmp.sourceforge.net/postcards/postcard.101.html

20:29:03 [davb]

Psychephylax: there are parts of the US that are like that

20:29:18 [Psychephylax]

they dont' count

20:29:21 [Psychephylax]

:)

20:29:39 [davb]

oh.

20:32:17 [davb]

ok now it works for no reason :)

20:32:26 [davb]

wait no it doesn't

20:39:28 [davb]

what is the keyword for order by ascending?

20:39:44 [Psychephylax]

ascd

20:39:46 [Psychephylax]

wait

20:39:46 [Psychephylax]

oracle?

20:39:48 [Psychephylax]

hang on

20:39:54 [davb]

no pg, but I think its standard.

20:41:16 [davb]

well I tried ascending and descending, it just breaks in the oposite direction :)

20:41:38 [davb]

I can get the previous day with that query, but using > $entry_date always gives the last entry or the first entry.

20:42:26 [Psychephylax]

asbah

20:42:32 [Psychephylax]

I have to think about it more when I am at home

20:43:17 [davb]

heh.

20:43:25 [davb]

I am just thinking in the channel...

20:43:26 [davb]

:)

20:43:50 [Psychephylax]

you're trying to get a nav thing going right?

20:43:56 [davb]

yeah

20:43:59 [davb]

I figured it out.

20:44:07 [Psychephylax]

?

20:44:13 [davb]

I have entry_date > $entry_date instead of entry_date > '$entry_date'

20:44:28 [Psychephylax]

in TCL?

20:44:36 [davb]

nah, thats the SQL query

20:44:48 [davb]

pg wanted the date in ''s

20:44:49 [Psychephylax]

oh

20:45:16 [davb]

I fixed the previous query but forgot to fix it on the next query.

20:47:39 [davb]

thanks.

20:51:06 [davb]

exit

20:51:09 [davb]

oops

21:01:44 [Psychephylax]

lol

21:02:00 [Psychephylax]

2001-12-04 Vlad Seryakov vlad@crystalballinc.com

21:02:10 [Psychephylax]

* Compilation problems with Linux and Solaris(Nikolay Blyumberg nickb@cv.net)

21:06:01 [Psychephylax]

I never made anything cool like a CHANGEME log before

21:15:19 [davb]

excellent!

21:16:10 [Psychephylax]

heh

21:29:31 [davb]

ok, how can I check if a variable exists in Tcl?

21:29:35 [davb]

I can;t seem to remember :)

21:30:45 [ola]

Dave, I have commited the little fix I was whining about ;-)

21:31:01 [davb]

yeah!

21:31:12 [davb]

ok ola: what is the command to check if a variable exists?

21:31:12 [ola]

davb: info exist var

21:31:16 [davb]

aha!

21:31:20 [davb]

thanks a million!

21:31:50 [ola]

np. might be; info exists var

21:32:25 [ola]

* ola wonders which module to ask for commit rights to next

21:32:39 [davb]

cool thanks!

21:32:46 [davb]

I retrofitted my weblog.

21:32:50 [ola]

did it work?

21:32:54 [davb]

yes

21:33:01 [ola]

aha. cool

21:33:04 [davb]

this is the last work I do on this crappy old site. the code is icky.

21:33:16 [davb]

But alot of people were visiting so I fixed it up a little.

21:33:33 [ola]

your just about to move to OpenACS4, aren't you?

21:33:40 [davb]

yes.

21:34:05 [ola]

it seems very stable IMHO!

21:34:08 [davb]

I was going to go before, but I am glad I waited, don rebuilt ALOT of queries.

21:34:21 [davb]

As soon as the beta release I am going for it.

21:34:30 [davb]

I have to figure out how to stuff my weblog into ETP.

21:35:19 [davb]

everything else is getting thrown out. I have to figure out a custom 404 page that gives a serach box/site map kinda thing so I won't feel obligated to fix all the broken links I am creating :)

21:35:34 [ola]

I think I will go for it tomorrow. I don't have the patience to wait another two weeks:-)

21:35:39 [davb]

heh

21:36:17 [davb]

I just don't really have time to work on it all. Plus I want to do it with CVS which means a day or two to get the mechanics of the development/staging/production servers down.

21:36:27 [ola]

are you keeping the weblog in the db?

21:36:37 [Psychephylax]

heh

21:36:38 [davb]

yes.

21:36:41 [Psychephylax]

Hola Ola

21:36:51 [ola]

HOLA Psychephylax!

21:36:53 [davb]

It will be pretty easy I think. Just create a new ETP page for each day.

21:37:00 [davb]

Then I can finally SEARCH it :)

21:37:15 [davb]

and I will migrate chump over to static-pages and that will be searchable too.

21:37:30 [davb]

and maybe even I will get the logger working and hook that in.

21:37:43 [davb]

so the IRC logs will be searchable.

21:38:42 [talli]

talli has left #openacs

21:38:57 [ola]

cool dave. that sounds like some great plans. I hope you'll find the time (perhaps during the x-mas hollidays;-))

21:39:51 [Psychephylax]

where do logs get put by aolserver?

21:39:52 [davb]

good luck!

21:40:06 [davb]

argh!

21:40:12 [davb]

in /usr/local/aolserver/log

21:40:13 [davb]

usually

21:40:22 [davb]

or /wherever aolserver lives/log

21:41:55 [ola]

Psychephylax: how is your module doing? was it ever accepted by the boss?

21:42:22 [Psychephylax]

not sure yet

21:42:30 [Psychephylax]

I'm trying tofind out why i cna't query 3Com modems

21:42:37 [ola]

still working on it, huh?

21:43:11 [Psychephylax]

yep

21:43:16 [Psychephylax]

debugging lots of it

21:43:51 [ola]

who needs modems anyway when we have dsl? :-P

21:44:39 [ola]

I still need a DSL modem, I guess...

21:44:55 [davb]

<wiseass>thats not really a modem</wiseadd>

21:45:03 [davb]

Its all digital.

21:45:07 [davb]

:)

21:45:36 [Psychephylax]

Cable modems not dialup (I was talking about)

21:47:34 [davb]

time to go! bye for now!

21:47:37 [davb]

davb has quit ()

21:52:26 [Psychephylax]

a product that does only two thirds of a job is not really a product

22:40:47 [markd2]

markd2 (~Snak@r-41.194.alltel.net) has joined #openacs

22:41:00 [markd2]

markd2 has quit (Remote closed the connection)

22:43:01 [ola]

ola has quit ("changing universes")

22:43:40 [graszew]

graszew has quit ("using sirc version 2.211+KSIRC/1.1")

22:44:37 [markd2]

markd2 (~Snak@r-41.194.alltel.net) has joined #openacs

22:53:07 [Psychephylax]

hi

22:53:16 [Psychephylax]

* Psychephylax hands Mark a cookie

22:53:26 [markd2]

heya

22:58:24 [Psychephylax]

:)

22:58:24 [Psychephylax]

hi

22:59:33 [Psychephylax]

Oracle pop quiz :)

22:59:36 [Psychephylax]

how do i list the history

22:59:38 [Psychephylax]

I forgot

22:59:45 [markd2]

list the history?

22:59:45 [Psychephylax]

and how do I edit queries in the command line

22:59:53 [markd2]

do "L" for "list"

22:59:55 [Psychephylax]

you gave me the command

22:59:55 [markd2]

that'll show line numbers

23:00:05 [markd2]

you can do the number to "go to' the line number

23:00:13 [markd2]

the slash command "/" executes whatever's in the sql buffer

23:00:39 [Psychephylax]

you mean go to '1'

23:00:41 [Psychephylax]

?

23:00:46 [markd2]

* markd2 sighs

23:00:48 [markd2]

if you ahve 3 lines

23:00:53 [markd2]

doing "2" will take you to the second line

23:01:01 [markd2]

to edit a line, do c/old-text/new-text/

23:01:03 [markd2]

c for change

23:01:51 [Psychephylax]

oh

23:02:58 [Psychephylax]

how come it always tells me I have only 1 query in the list

23:04:34 [Psychephylax]

Aha

23:04:36 [Psychephylax]

this is spiffy

23:04:43 [Psychephylax]

* Psychephylax gives mark a cookie

23:06:36 [markd2]

it only has one statement history

23:07:18 [Psychephylax]

well, that doesn't help me

23:07:22 [Psychephylax]

can I make it more than one?

23:07:38 [markd2]

nope

23:08:04 [Psychephylax]

that sux0rz

23:08:05 [markd2]

if you run your sqlplus session in an emacs shell, you can use M-p M-n to go back and forward through your typed commands

23:08:17 [markd2]

that's the way ti is

23:08:43 [Psychephylax]

we must change the way it is

23:09:01 [markd2]

I'll watch

23:11:00 [Psychephylax]

:)

23:11:12 [Psychephylax]

What kind of a dog does Greenspun have

23:11:47 [markd2]

Samoyed

23:12:20 [Psychephylax]

got a question for you

23:12:22 [Psychephylax]

ok

23:12:35 [Psychephylax]

I'm looking at sql for web nerds on his site

23:12:49 [Psychephylax]

Chapter 10 (for my employee hierarchy)

23:12:54 [Psychephylax]

And he has a table

23:12:56 [markd2]

ok

23:13:02 [Psychephylax]

which references itself

23:13:37 [Psychephylax]

Now, I hope i learned something in databases but you need to manually insert something in there as your "Big cheese" row where supervisor_id = NULL

23:14:02 [Psychephylax]

right?

23:14:18 [markd2]

that might not be necessary

23:14:27 [markd2]

with oracle's 'connect by' statement, you can start the tree at any arbitrary point

23:15:09 [Psychephylax]

so how does it reference iself

23:15:48 [markd2]

read the docs on connect by

23:15:52 [markd2]

it's been ahwile since I've used it

23:17:16 [Psychephylax]

I'm asking because I ran this:

23:17:28 [Psychephylax]

and got constraint errors (self referencing table)

23:18:36 [markd2]

what's the *exact* constraint error you're getting?

23:18:57 [Psychephylax]

I'm not sure if i will get it now

23:19:00 [Psychephylax]

I added a row

23:20:42 [Psychephylax]

Right

23:21:00 [Psychephylax]

I didn't get that error because I added admin as the "BIG CHEESE"

23:21:24 [markd2]

AFAIK, constraints don't know about a tree-like table

23:21:27 [markd2]

since connect by only happens at query time

23:22:14 [Psychephylax]

right

23:22:37 [Psychephylax]

So there's no way of defer the checking

23:22:38 [Psychephylax]

?

23:23:54 [markd2]

I don't see how the checking could happen

23:24:05 [markd2]

without seeing the *actual* complaint from oracle, it's all speculation

23:24:23 [Psychephylax]

heh

23:24:25 [Psychephylax]

hold on

23:27:48 [Psychephylax]

must do a query where it's sorted somehow

23:27:57 [Psychephylax]

They did not teach us about ORDER BY

23:28:01 [markd2]

whoa

23:28:11 [markd2]

how did they expect you to sort stuff?

23:28:14 [markd2]

in the java layer?

23:29:00 [Psychephylax]

probably

23:29:04 [Psychephylax]

We didn't have to do any sorting

23:29:15 [Psychephylax]

Infact, when I get home, I will send you my project so you can make fun of it

23:29:45 [markd2]

heh

23:29:46 [markd2]

kool

23:30:07 [Psychephylax]

Not really :)

23:30:09 [Psychephylax]

It's really bad

23:30:18 [Psychephylax]

At least to my liking

23:33:01 [Psychephylax]

shweeeeet!

23:33:03 [Psychephylax]

EMPLOYEE_ID SUPERVISOR_ID

23:33:03 [Psychephylax]

----------- -------------

23:33:03 [Psychephylax]

2189

23:33:03 [Psychephylax]

3497 2189

23:33:03 [Psychephylax]

3500 2189

23:33:04 [Psychephylax]

3503 3500

23:33:36 [markd2]

qool

23:36:36 [Psychephylax]

looq?

23:37:27 [markd2]

ooql

23:39:10 [markd2]

markd2 has quit ("Bork")