Advertisement
Bienvenido a Squishdot Reportes Anuncios Debian Ciencia Linux
 principal
 nivel superior
 enviar artículo
 buscar
 administrar
 acerca de ...
 rdf
 rss
 main


Finished!
Anuncios Posted by Ricardo Beltran on Monday December 10, @08:39AM el 2007
from the Plenary Session 2 dept.

Finally the Plenary Session 2 is going live, The survey is finished and the Classification system is at the front door. The next steps follows:

1)Vic, Would you please sync the information at icme11.org into test.icme11.org... Please be careful since icme11.org is the latest version that should be spread to the others!

2)We need to promote this survey around the world (waiting for instructions about how are we going to accomplish this goal ).

3) We need to provide a download of the responses for David's team from Drupal to Comma Separated Value.


The Query?

The question is, who can give me a query that solves the following problem. I have four data table with the following fields

Table1 (The table with almost all the questions

UID (FNK)
Q1
Q2
Q3
...
Q11

And also I have the following three tables for the multiple choice questions, for example Table2 is something like: Table2
UID (FNK)
Q6

Then, Table1 has a one to many (no more than ten) relationship with table2, Who can give me a query to obtain this Table Result UID
Q1
Q2
Q3
...
Q6_1
Q6_2
Q6_3
...
Q6_8
Q6_9
Q6_10
...
Q9
Q10
Q11

I will give a chocolate bar to the person that correctly solves this riddle.



reporte invernal | Arreglo en las fechas de los posts...  >

 

Related Links
  • Articles on Anuncios
  • Also by Ricardo Beltran
  • Contact author
  • The Fine Print: The following comments are owned by whoever posted them.
    ( Reply )

    Re: Finished!
    by Jergas on Tuesday December 11, @09:43PM

    Hear Ye! Hear Ye! Hear Ye! Edgar Senior has announced the following:

    Plenary 2 Survey

    Please comment as a reply to this.


    [ Reply to this ]
    • Re: Finished!
      by David Clarke on Wednesday December 12, @01:25AM

      Hi Everyone, I'm confused - I went to the ICME11 website yesterday and the link was there - the site works perfectly. The link that Edgar provided takes me to a webpage that includes http://icme11.org/surveyinvitation - but the Plenary Session 2 Survey is also included in the right-hand menu. If I go to the existing live ICME11 homepage, then the same link is present in the right-hand menu, so I'm not sure where the new webpage (http://icme11.org/node/485) fits into the system. I have no complaints or concerns at all about the existing form of the ICME11 homepage. Now it's my job to advertise the survey as widely as possible (see the attached flyer). I don't know how to reply to the ps about the taxonomy content. Do you mean have I tried classifying responses? If so, I wasn't aware that there had been any. Certainly the survey has now been advertised quite widely, through the ICME11 IPC, through my own international research network and through Jerry Becker's international mailserv (see below). It's not clear to me what more I need to do - other than to test the data downloading facility once this is available. As per my email to everyone - thanks again - I'm very pleased with the outcome. David

      Jerry Becker's mailout: Sent at the request of Professor David Clarke. -------------------------------------- See at the bottom how to respond to the Survey. *************************** ICME 11 Mexico 2008

      11th International Congress on Mathematics Education

      Monterrey, Mexico, July 6 - 13, 2008

      Help to shape the Research Agenda in Mathematics Education!

      PLENARY 2 SURVEY

      What do we need to know?

      Does research in mathematics education address the concerns of teachers and policy makers?

      One of the plenary activities for ICME 11 will be a panel presentation addressing the question of whether research in mathematics education is providing the information that teachers and policy makers most need. The panel members are mathematics education researchers from different countries, who will respond to teachers' and policy makers' questions submitted through this website.

      WE NEED YOUR CONTRIBUTIONS!

      Whether or not you plan to attend ICME 11 - and we hope you do - you can make an important contribution by letting us know how research can help you.

      To do this, we invite you to submit an important question that you think should be answered by research in mathematics education and also to indicate whether research has helped you in the past and, if so, how.

      WE NEED RESPONSES FROM ALL COUNTRIES, ALL SCHOOL TYPES AND ALL LEVELS OF THE SCHOOL SYSTEM INCLUDING TEACHERS, POLICY MAKERS AND CURRICULUM DEVELOPERS. This is your chance to play a part in shaping the research agenda in mathematics education. To do this, please go to the ICME 11 website (http://icme11.org/) and select the Plenary Session 2 Survey link. It is important that you and your colleagues make your views known and contribute to shaping the direction of mathematics education research internationally.

      A REPORT WILL BE MADE AVAILABLE THROUGH THE CONFERENCE WEBSITE OF BOTH THE SUBMISSIONS AND THE RESPONSES OF THE PLENARY PANEL.

      *******************************************
      Jerry P. Becker Dept. of Curriculum & Instruction Southern Illinois University 625 Wham Drive Mail Code 4610 Carbondale, IL 62901-4610 Phone: (618) 453-4241 [O] (618) 457-8903 [H] Fax: (618) 453-4244 E-mail: jbecker@siu.edu

      Click to download attachment ICME 11 Plenary 2 Survey Invite.doc
      50KB (51200 bytes)

      [ Reply to this ]
    Re: Finished!
    by jergas on Thursday January 03, @03:06AM

    Hola y Feliz Anyo!

    No entiendo bien los detalles de las tablas involucradas. Al margen, dime, se resolvio esto?

    Un abrazo para ti y para tu farmacia!


    [ Reply to this ]
    • Re: Finished!
      by pks on Thursday January 03, @01:11PM

      Aun no, no estaria mal que alguien chipocludo en los Queries echara una mano. Gracias por los saludos


      [ Reply to this ]
    Puzzle solved!
    by Gunnar on Thursday January 31, @09:59PM
    Ok, I must say I'm proud of myself ;-) This piece of code took me just under an hour, and it provides the needed transformation from four tables to a single CSV file. It's all now a matter of integrating this into the site (so it is no longer a manually-run process).
    Of course, I'm attaching here my source - but not the resulting CSV, as it might contain non-public data.
    Of course, _please_ check my little program works correctly - that is, that the generated data is coherent with the input. I'm unfamiliar with the database layout, and I could have got something wrong. (Of course, how can you check the resulting data if you don't have it? Oh, that's simple: I'm just about to send it by mail to the interested parties: Victor, Ricardo, David, Edgar[0] and Marcela. Edgar[1] still told me his mail is out of order - Edgar, don't blame Telmex. It's for our own good, this time there's no real argument against it. Besides, the same thing is happening all around the world. And, yes, those are good measures!
    [ Reply to this ]
    • Grah, where's my attachment?
      by Gunnar on Thursday January 31, @10:02PM
      Nevermind. Here it is.
      Click to download attachment merge_csvs.pl
      1KB (2010 bytes)

      [ Reply to this ]
    • Re: Puzzle solved!
      by jergas on Tuesday February 05, @01:56PM

      How about a daily cron job?

      If we wanted backups we could even have 2 cron jobs, one which saves de scv file with the date on the filename, and one (right after the first one) which copies that one to a fixed filename (with a fixed URL).

      Then we could just have a fixed link in the plenary 2 website which only shows on the contextual menu of taxonomists.


      [ Reply to this ]
      • Re: Puzzle solved!
        by Gunnar on Tuesday February 05, @08:53PM
        The script is quite trivial, and the output file is not large. My original proposal to Ricardo was to integrate the script as a CGI process, to generate the output on demand (that means, always-fresh). I understand our hosting would not have a problem with that - but it involves setting it up with Drupal, and I don't know how involved that is.
        On the other hand, we could just generate the files every hour (or every x hours), and -why not?- save all of the generated data sets - in case they are useful for something. That's as easy as just appending the timestamp to the filename! Of course, if the historic record is not needed, scrap my proposal - We would not even need a backup, as the whole data is in the database. And I understand DreamHost provides snapshot backups for it in case of disaster. (but I might understand wrong, of course!)
        [ Reply to this ]
        • Re: Puzzle solved!
          by jergas on Wednesday March 19, @05:19AM

          Well, Ive seen the entry in the Taxonomists menu, and Ive even roadtested it. So, just out of curiosity: which solution was implemented?


          [ Reply to this ]
    • Re: Puzzle solved!
      by jergas on Friday March 21, @04:54AM

      Hola Gunnarcindo,

      Revisitando esta vieja conversacion, tengo una par de comentarios sobre el articulo que mencionas arriba:

      • lo que describe el articulo (filtrar los emilios) es mas agresivo que obligar a la gente a cambiar de puerto
      • el articulo no lo menciona como algo bueno, de hecho, retoricamente pregunta si es deseable, y cuando haces una pregunta asi generalmente implica una critica indirecta
      • una solucion moronica a un problema serio no me parece "good security policy", ya que al incrementar gradualmente la complejidad del problema que los atacantes enfrentan, solo los estamos ayudando a evolucionar mejor software

      y bueno, este post no es un acto trollista, ni busca una piroguerra, solo es mi opinion expresada de manera poco delicada, pero ya que tu acostumbras expresarte de manera poco delicada, espero que aprecies mi candidez.


      [ Reply to this ]

     
    The Fine Print: The following comments are owned by whoever posted them.
    ( Reply )

    Powered by Zope  Squishdot Powered
      "Any system that depends on reliability is unreliable." -- Nogg's Postulate
    All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest ©1999 Butch Landingin.
    [ home | post article | search | admin ]