Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You are getting a lot of concepts wrong here. Lemme explain what you are trying to do here. But before I do so I strongly suggest that you get a good Rails book and try out couple of the applications from those books before trying things on your own. Everybody starts at your level. Theres nothing wrong in what you are trying to do :). </p> <p>Firstly: Ruby code is executed only once when the page is loaded for the first time in the browser. You cannot use ruby in javascript. You can use Ruby to render javascript as you wish when you send the HTML page as a response to the request from the browser side not once after that. So the part where you are doing <code>var search = &lt;%User.paginate(page: params[:page]).search('$(this).val();')%&gt;</code> is impossible to do.</p> <p>You need to get these concepts right before developing. :) So get a good rails book. </p> <p>Alright.</p> <p>Secondly: I am assuming that your search works fine except for your keyup requirement. So Im guessing that you have your controllers and models in order. So let me explain AJAX to you.</p> <p>Remember when I said you can only execute ruby code or in other words invoke a Rails Controller only once when the page is loaded? Thats true but theres a magical thing called AJAX in the javascript world. This allows you to call the Rails Application and get responses without loading the page! This is exactly what you want here. You are trying to just update the search results. You dont wanna reload the entire page. You just want to update the results as the user presses keys on the search field. </p> <p>Using AJAX you can make a request to your server and get a response. So in your application, the request would be to the URL where the search form would submit if the user presses enter or submits. What would you pass as arguments to this URL? yes you guessed it right! the search field value. </p> <p>Alright after getting your concepts right start here: <a href="http://railscasts.com/episodes/240-search-sort-paginate-with-ajax?view=comments" rel="nofollow">http://railscasts.com/episodes/240-search-sort-paginate-with-ajax?view=comments</a></p> <p>Then you'll know what to do. </p> <p>Good luck.</p>
    singulars
    1. This table or related slice is empty.
    1. POhow can i redo a search on keyup function
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSteve Robinson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POhow can i redo a search on keyup function
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COthanks for the advice, I do eventually plan reading a rails book. I've been learning as I go which is more fun for me but obviously leaves fundamental gaps.
      singulars
      1. PO
      1. USAPJ
    2. COThats a good way to learn too. But you need some basic understanding of serverside code and client side code and the whole client-server architecture. So go for the basics first. Understand what youre doing before attempting it. You can either be a developer who just cooks up an app without knowing how it works just by copying snippets or you could spend some time understanding the concepts behind what you are trying to build and become a great developer. Nobody is perfect. Everybody doesn't understand everything.. we just have to keep going at it!.. all the best..
      singulars
      1. PO
      1. USSteve Robinson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload