[bksvol-discuss] Re: admin queue redux
- From: Cindy <popularplace@xxxxxxxxx>
- To: bksvol-discuss@xxxxxxxxxxxxx
- Date: Fri, 25 Aug 2006 15:04:53 -0700 (PDT)
Jake,
Thanks for the explanation. I think I understand--more
or less. smile But, if I understand this sentence in
your explanation--"...SQL command that says, give me
all the books that meet
this criteria. And
then the page code generates output, like the table on
Step 1."
Why can't Gustavo request a list of books by date
submitted; or the BSO's; or why can't he look at the
admiin queue that the rest of us see, number them, and
request books 1 through 25, for example?
Just asking.
Cindy
--- siss52 <siss52@xxxxxxxxxxx> wrote:
>
> Hi Jake,
>
> I, of course, do not understand the technical
> requirements, but your
> explanation gives me a picture of the concepts.
>
>
> Having said that, could someone with influence ask
> Gustavo, the website
> manager, to give the engineers permission to set or
> search so as to get some
> of these books which have been in the admin queue
> for a long time?
>
> Just my thoughts. Then, when the backlog has been
> taken care of, it could
> be reset as it is now.
>
> By the way, John Glass is right there where he could
> talk to Gustavo about
> this, just as Marissa used to do. She also seemed
> to have a good rapport
> with the engineers. Just my two cents worth.
>
> Sue S.
>
>
> ----- Original Message -----
> From: "Jake Brownell" <jabrown@xxxxxxxxx>
> To: <bksvol-discuss@xxxxxxxxxxxxx>
> Sent: Friday, August 25, 2006 10:56 AM
> Subject: [bksvol-discuss] Re: admin queue redux
>
>
> Hi Elizabeth,
>
> All right, here's some ideas from a more technical
> standpoint, but one that
> I hope is followable if you don't have a background
> in programming.
>
> Websites like BookShare, are generally run with a
> back end database. Data
> from that database is incorperated into web pages
> for presentation to web
> users. To do this, the pages as stored on the
> BookShare server contain code
> directives that the webserver processes before it
> sends you the page. When
> you get the page all the server commands have been
> processed and all you get
> is just a straight web page.
>
> There are generally two technologies used during the
> pages transformation
> from server to user.
>
> The first is a database query, generally handled by
> SQL, pronounced sequel.
> This query looks up information in the database and
> returns data sets to the
> page that asked for the information.
>
> Second is the code inside the page that the server
> is responsible for
> processing. It requests data from the database using
> SQL and then takes the
> dataset and determines how, when, and where to
> display it.
>
> With pages like the administrative pools and the
> Step 1 page, there is an
> SQL command that says, give me all the books that
> meet this criteria. And
> then the page code generates output, like the table
> on Step 1.
>
> To change the order of display should not require a
> code change, instead
> adjusting the SQL statement to return a better
> dataset should be all that is
> needed.
>
> For instance, say that all the books are stored in
> one table. You will have
> things like status, id number, title, author, etc.
> Then say there is a table
> that contains the comment history, which holds stuff
> like status/date/user.
> From what little I know about relational databases,
> this is probably a good
> guess as to how it is set up.
>
> The existing SQL statement could be modified to use
> what's called a JOIN
> command which basically allows you to analyze data
> from both tables as if
> they were one.
>
> Then, adding an ORDER BY statement to the SQL
> command to reflect the
> appropriate field to sort on should resort the data
> before the page code
> even sees it. (the appropriate data field would
> probably be the last date in
> the comment history).
>
> So, what exactly are we talking about when we change
> the order of books
> displaying on these pages?
>
> We're talking about someone who has a decent/modest
> background in using SQL.
> And, we're probably, I do want to emphasis
> probably/most likely, talking
> about changing just one line in the page, the SQL
> statement.
>
> Keep in mind that this does rely on the fact that
> the database is setup in a
> standard way. From what I've seen the site capable
> of doing, it should be
> setup just fine for our purposes.
>
> Also, if the database is setup in a nonstandard way,
> there are other easy
> ways of reordering the data such that better results
> will be given, just not
> perfect first in first out. For instance, I know
> that the list could be
> ordered based on submission dates rather than
> whatever convoluted way it's
> setup now.
>
> Good job if you made it this far in the message,
> grin. I hope it's been
> informative and not overly technical.
>
> Jake
>
> ----- Original Message -----
> From: "E." <thoth93@xxxxxxxxxxxxx>
> To: <bksvol-discuss@xxxxxxxxxxxxx>
> Sent: Friday, August 25, 2006 5:32 AM
> Subject: [bksvol-discuss] Re: admin queue redux
>
>
> > Jake can you comment from a technical standpoint
> on the reasons for
> > keeping the queue in its present order? Is this
> order difficult to change
> > from a programming standpoint? Do you know of a
> benefit of keeping it
> > this way. Seems so many disadvantages to this
> state of affairs have been
> > voiced so long.
> >
> > Thanks for input.
> >
> > E.
> >
> > To unsubscribe from this list send a blank Email
> to
> > bksvol-discuss-request@xxxxxxxxxxxxx
> > put the word 'unsubscribe' by itself in the
> subject line. To get a list
> > of available commands, put the word 'help' by
> itself in the subject line.
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.405 / Virus Database: 268.11.5/426 -
> Release Date: 8/23/2006
> >
> >
>
> To unsubscribe from this list send a blank Email to
> bksvol-discuss-request@xxxxxxxxxxxxx
> put the word 'unsubscribe' by itself in the subject
> line. To get a list of
> available commands, put the word 'help' by itself in
> the subject line.
>
>
> To unsubscribe from this list send a blank Email to
> bksvol-discuss-request@xxxxxxxxxxxxx
> put the word 'unsubscribe' by itself in the subject
> line. To get a list of available commands, put the
> word 'help' by itself in the subject line.
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
To unsubscribe from this list send a blank Email to
bksvol-discuss-request@xxxxxxxxxxxxx
put the word 'unsubscribe' by itself in the subject line. To get a list of
available commands, put the word 'help' by itself in the subject line.
Other related posts:
