[thesite] Members' Directory/Pages

rudy r937 at interlog.com
Thu May 17 16:07:28 CDT 2001


>(1)  Why is PRIV on both member and membattr tables?
> I thought we only needed one PRIV?

yes it can be discussed here

we need a PRIV on every record where the record contents need privacy

>(2)  What is SEQ on the membattr table?

sequence, e.g. if i list several urls, i can put them in the order i want

>(3)  What are REMARKS for?  Will the member be able to use this field?

to add remarks to the attibute value, yes it's for the member to supply
remarks

>(4)  Are ATTRVALUE and REMARKS set to be 255 characters?

yes they are, i don't think we should be writing book-length entries on
each individual attribute -- remember, they are meant for things like phone
numbers, icq numbers, stuff like that

>If we want to go one step further and incorporate Joshua's resume builder,
>that will require additional memo (clob??) fields?  Feasibility?

no comment, sorry, i just don't know enough about it, but as soon as i saw
"you would take the form struct as it comes in, wddx it, and store it in a
repository for later compilation!" my mind sort of tuned out...

no offence, josh, but we should get the basics up and running first...

>One final question, do you have a list of attributes already created?

SQL> select * from attribute;
   ATTRID ATTRNAME
--------- ---------------------
     2757 email
     2761 url
     2762 icq
     2763 photo

this was in test.evolt.org's database (i think) from codefest 2, not sure
if they're still there

the IDs are taken from the same oracle sequence as all the rest of them

there will of course be plenty of pre-determined attributes, and perhaps
the form should offer them in a dropdown or something








More information about the thesite mailing list