www.webdeveloper.com

Search:

Type: Posts; User: pollymac

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    1,396

    select student, avg(grade) average_grade from...

    select student, avg(grade) average_grade
    from grade
    group by student;
  2. Replies
    8
    Views
    2,052

    Also: I disagree with the poster above, this will...

    Also: I disagree with the poster above, this will return 0 rows.

    Draw a table on a piece of paper and in the first column randomly write a number in each row but be sure to include the numbers...
  3. Replies
    8
    Views
    2,052

    Remove your 'or' then union the entire query with...

    Remove your 'or' then union the entire query with same except perform the join on r.fk_user_to=u.user_id:
    SELECT * FROM (
    SELECT r.fk_user_to,r.fk_user_from,u.user_first_name, u.user_last_name,...
  4. Replies
    6
    Views
    759

    ahh, then consider you have x number of inputs...

    ahh, then consider you have x number of inputs (42 in total), your loop now reads:
    for ( i = 0 ; i <= x ; i++){
    var tempVar = m[i];
    }

    The crucial bit is where x gets to the length of the array...
  5. Replies
    10
    Views
    1,659

    It's also worth noting, given the request...

    It's also worth noting, given the request regarding efficiency, that you should order your IN clause by the whichever value is most likely to occur in the database most often, i.e. if there are...
  6. document.Italy is so messy. At the least use...

    document.Italy is so messy.

    At the least use document.all.Italy

    Better still would be to give the element an id, thus: <form action="/World-Cup-2010-Country-Italy" name="Italy" id="Italy"...
  7. Replies
    6
    Views
    1,279

    Your three 'HINTS' suggest this is a uni/college...

    Your three 'HINTS' suggest this is a uni/college coursework, lol
  8. Replies
    6
    Views
    759

    Can you show any of your html, or is it...

    Can you show any of your html, or is it dynamically created?
    ...

    i <= m.length - a short discussion...

    if there are no <input> elements on the page then the code will still run through as i is...
  9. Replies
    2
    Views
    1,150

    Yip, it has to run the conversion on every line...

    Yip, it has to run the conversion on every line on the table, whether it's selected or not - a huge overhead.
  10. Thread: 672 fields???

    by pollymac
    Replies
    6
    Views
    893

    You would only need one table for all loggers,...

    You would only need one table for all loggers, with a unique id to, erm, identify them with. This would then have a one-to-many relationship with the table described above (svidgen's post).

    You...
  11. For something like that, you'd use WHERE clauses,...

    For something like that, you'd use WHERE clauses, eg.

    SELECT <rows>
    FROM <table>
    WHERE id BETWEEN 57 AND 66;

    or

    SELECT <rows>
    FROM <table>
  12. I'm assuming you're wanting this to allow for...

    I'm assuming you're wanting this to allow for IE's different JavaScript capabilities?

    You used to be able to do this:

    browserAgent = navigator.userAgent;
    browserIE =...
  13. SELECT SUM(points) FROM 'table' WHERE game =...

    SELECT SUM(points)
    FROM 'table'
    WHERE game = 'pingpong';
    ??
  14. Replies
    1
    Views
    3,016

    SELECT...

    SELECT CL_WSP_NAME,CL_PROJ_NAME,CL_ORGANIZATION_NAME,CL_MAPID,SUM(MAPPED_CNT) MAPPED, SUM(NOTMAPPED_CNT) UNMAPPED,MAX(CL_MAPRUN_DATE) CL_MAPRUN_DATE,CL_CONFIRMER_ID,CL_VENDOR_FILE,CL_MAP_COMMENTS,...
  15. Replies
    3
    Views
    5,024

    Questions? Where?

    Questions?

    Where?
  16. Replies
    8
    Views
    911

    I just copied the one line and edited it. Kind...

    I just copied the one line and edited it.

    Kind of thought that was obvious. Evidently it was not :(
  17. Replies
    8
    Views
    911

    for(var i=0;i

    for(var i=0;i<group.snapshotItem.length;i++){


    ??
  18. Replies
    4
    Views
    2,246

    function...

    <script type="text/javascript">
    function formDisplay(shaftOpVal) {
    if(shaftOpVal=='default' || shaftOpVal=='hollow') document.getElementById("hidediv").style.display = "block";
    ...
  19. Thread: getDate()

    by pollymac
    Replies
    2
    Views
    918

    getDate() returns both the time and the date.

    getDate() returns both the time and the date.
  20. Replies
    9
    Views
    1,383

    The select should take care of the ordering of...

    The select should take care of the ordering of display data...

    SELECT *
    FROM locations
    ORDER BY location_id/location_name/whatever/etc
  21. Replies
    1
    Views
    781

    Quarter past three

    Quarter past three
  22. Replies
    6
    Views
    954

    SELECT account, Count(reviewer) revCount FROM ...

    SELECT account, Count(reviewer) revCount FROM
    USER left join
    (SELECT reviewer FROM table1
    ...
  23. Replies
    6
    Views
    954

    Sorry, I tested using Oracle 10g. This should...

    Sorry, I tested using Oracle 10g.

    This should work (I think):

    These should order the data for you as well.

    Let me know if it works.

    -pmcc
  24. Replies
    6
    Views
    954

    SELECT account, Count(reviewer) FROM USER left...

    SELECT account, Count(reviewer) FROM
    USER left join
    (SELECT reviewer FROM table1
    UNION ALL
    SELECT reviewer FROM table2
    UNION ALL
    SELECT reviewer FROM table3)
    on account = reviewer
    GROUP BY...
  25. Replies
    3
    Views
    797

    What joins DEALER to OWNER?

    What joins DEALER to OWNER?
Results 1 to 25 of 36
Page 1 of 2 1 2
HTML5 Development Center



Recent Articles