Cindy, Gustavo can enter a SQL command and get the books like you are suggesting, but they wouldn't show up on the web page that he uses to approve books. He would have to change the code on the server which generates the page, and that's probably better left to one of the Engineers. HTH Gerald -----Original Message----- From: bksvol-discuss-bounce@xxxxxxxxxxxxx [mailto:bksvol-discuss-bounce@xxxxxxxxxxxxx] On Behalf Of Cindy Sent: Friday, August 25, 2006 5:05 PM To: bksvol-discuss@xxxxxxxxxxxxx Subject: [bksvol-discuss] Re: admin queue redux 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. 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.