AaronHopkins's Profile User Rating: -----

Reputation: -1 Dishonored
Group:
Active Members
Active Posts:
174 (0.14 per day)
Joined:
01-March 11
Profile Views:
997
Last Active:
User is offline Apr 23 2014 09:59 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   AaronHopkins has not set their status

Posts I've Made

  1. In Topic: The data source does not support server-side data paging.

    Posted 20 Apr 2014

    Thank you, that worked. But now I can only stay on page 1 & can't go through the rest of the pages because i'm receiving an error of not firing PageIndexChanging. I tried something like this:
          protected void titlesGridView_PageIndexChanging(object sender, EventArgs e)
          {
              titlesGridView.PageIndex = e.NewPageIndex;
              titlesGridView.DataSource = titlesQuery.ToList();
              titlesGridView.DataBind(); // displays query results  
    
          }
    


    But it won't compile. Does it need its own method like I did?
  2. In Topic: SQL Query To Obtain authors that Occurs more than twice

    Posted 13 Mar 2014

    after i join the tables this is how it looks:
    AU_FNAME       |AU_LNAME       |TITLE_NAME                              
    ------------------------------------------------------------------------
    Sarah          |Buchman        |1977!                                   
    Sarah          |Buchman        |200 Years of German Humor               
    Christian      |Kells          |Ask Your System Administrator           
    Hallie         |Hull           |But I Did It Unconsciously              
    Klee           |Hull           |But I Did It Unconsciously              
    Klee           |Hull           |Exchange of Platitudes                  
    Wendy          |Heydemark      |How About Never?                        
    Wendy          |Heydemark      |I Blame My Mother                       
    Klee           |Hull           |I Blame My Mother                       
                   |Kellsey        |Just Wait Until After School            
                   |Kellsey        |Kiss My Boo-Boo                         
    Wendy          |Heydemark      |Not Without My Faberge Egg              
    Hallie         |Hull           |Perhaps It's a Glandular Problem        
    Klee           |Hull           |Perhaps It's a Glandular Problem        
                   |Kellsey        |Perhaps It's a Glandular Problem        
    Wendy          |Heydemark      |Spontaneous, Not Annoying               
    Sarah          |Buchman        |What Are The Civilian Applications?  
    

    thats wi/ using this code:
    select authors.au_fname, authors.au_lname, titles.title_name
    	from title_authors
    	inner join authors
    		on title_authors.au_id  = authors.au_id
    	inner join titles
    		on title_authors.title_id = titles.title_id;
    

    i need it to print like this:
    AU_FNAME       |AU_LNAME       |TITLE_NAME                              
    ------------------------------------------------------------------------
    Sarah          |Buchman        |1977!                                   
    Sarah          |Buchman        |200 Years of German Humor 
    Sarah          |Buchman        |What Are The Civilian Applications?   
    Wendy          |Heydemark      |How About Never?                        
    Wendy          |Heydemark      |I Blame My Mother 
    Wendy          |Heydemark      |Not Without My Faberge Egg 
    Wendy          |Heydemark      |Spontaneous, Not Annoying                        
    Hallie         |Hull           |But I Did It Unconsciously 
    Hallie         |Hull           |Perhaps It's a Glandular Problem                
    Klee           |Hull           |But I Did It Unconsciously              
    Klee           |Hull           |Exchange of Platitudes   
    Klee           |Hull           |I Blame My Mother  
    Klee           |Hull           |Perhaps It's a Glandular Problem                                         
                   |Kellsey        |Just Wait Until After School            
                   |Kellsey        |Kiss My Boo-Boo                         
                   |Kellsey        |Perhaps It's a Glandular Problem        
    


    basically, i think i got it but i don't know how to write it. i need to combine these 2 codes, but dont know how.

    select au_id
      from title_authors
      group by au_id
      having count(*)>2
    
    

    select authors.au_fname, authors.au_lname, titles.title_name
    	from title_authors
    	inner join authors
    		on title_authors.au_id  = authors.au_id
    	inner join titles
    		on title_authors.title_id = titles.title_id
    
  3. In Topic: SQL Query To Obtain authors that Occurs more than twice

    Posted 13 Mar 2014

    yea because before putting in the GROUP BY & HAVING COUNT lines, everything is fine. The JOINs i have show the table how i want it to be with the authors & all the books they wrote. All i need is to print out the authors that wrote more than 2 books.
  4. In Topic: SQL Query To Obtain authors that Occurs more than twice

    Posted 13 Mar 2014

    results are nothing.
  5. In Topic: SQL Query To Obtain authors that Occurs more than twice

    Posted 13 Mar 2014

    nothing happens when i try to run it.

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

AaronHopkins hasn't added any friends yet.

Comments

AaronHopkins has no profile comments yet. Why not say hello?