Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can either use setInterval or setTimeout depending on how you want to do things. You may also want to use clearInteval or clearTimeout to prevent the refreshing in certain situations.</p> <p>For the AJAX stuff, you can use jQuery's functions, the example below uses getJSON which is more lightweight than HTML (which the jQuery.get woudl do), but this means processing it to create the HTML on the client.</p> <p>For example:</p> <pre><code>$j = jQuery.noConflict(); $j(document).ready( initSearching ); function initSearching() { Searching = setInterval( 'updateSearch()' , 5000 ); // 5s while testing... $j('#StopRefreshBtn').click( stopSearching ); } function stopSearching() { clearInterval(Searching); } function updateSearch() { if ( $j('#SearchBox').val().length &gt; 0 ) { sendSearchRequest( $j('#SearchBox').val() ); } } function sendSearchRequest( SearchTerms ) { $j.getJSON( 'http://www.myserver.com/webservices/mycfc.cfc?method=readData&amp;SearchTerms='+SearchTerms , handleSearchResponse ); } function handleSearchResponse( SearchResults ) { console.log( SearchResults ); // TODO: Handle JSON response to render the HTML results. } </code></pre> <p><br/> Then, on the CF side, you just need a component with a remote function - and since I'm doing it with JSON, the returnformat is set to that:</p> <pre><code>&lt;cfcomponent output="false"&gt; &lt;cffunction name="readData" returntype="array" output="false" access="remote" returnformat="json"&gt; &lt;cfargument name="SearchTerms" type="String" /&gt; &lt;cfset var Results = ArrayNew(1)/&gt; &lt;!--- TODO: search and populate array of results. ---&gt; &lt;cfreturn Results /&gt; &lt;/cffunction&gt; &lt;/cfcomponent&gt; </code></pre> <p><br/> The above is all quickly thrown together and not tested - hopefully if anyone sees problems with it they'll point them out.</p> <p>For more details on doing remote requests with jQuery and ColdFusion, there are some answers to this similar question: <a href="https://stackoverflow.com/questions/999501/invoke-coldfusion-function-using-ajax">Invoke ColdFusion function using AJAX</a></p> <p>Hopefully that all makes sense, and gets you heading in the right direction?</p>
    singulars
    1. This table or related slice is empty.
    1. POAJAX to do Real Time DB Polls like Twitter's "Real Time Results" in Coldfusion
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USPeter Boughton
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAJAX to do Real Time DB Polls like Twitter's "Real Time Results" in Coldfusion
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks; it definitely seems like a good start! I'm going to try to whip something up right now; I'll let you know if I have any trouble (which I likely will!); thanks again, very helpful!
      singulars
      1. PO
      1. USKeithComito
 

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