Solved

jQuery and SQL to pull and place random text from database

Posted on 2010-09-02
5
320 Views
Last Modified: 2012-05-10
How would one use jQuery to randomly select a column from a table in an SQL database that would then be shown to the user on a page?
0
Comment
Question by:mikesExpertExchange
  • 2
  • 2
5 Comments
 
LVL 1

Author Comment

by:mikesExpertExchange
ID: 33591420
this needs to occur when the page loads. and only needs to do the random select once, not on a timer...
0
 
LVL 82

Accepted Solution

by:
leakim971 earned 250 total points
ID: 33592124
if you do it only one time, at page load you should be able to do that on the server side directly.

else of course your answer is ajax : http://api.jquery.com/jQuery.get/

you need to create an .net page returning the random column
<script>
$(document).ready(function() {
    $.get( "page.aspx/randomColum", null, function(data) { $("#here").html(data); } );
});
</script>
<body>
<div id="here"></div>

Open in new window

0
 
LVL 6

Assisted Solution

by:Mike D
Mike D earned 250 total points
ID: 33676516
...and with serverside he means something like

<?

echo "<script>";
echo "var =" . $my_rand_nr;
echo "</script>";

?>

Greets
JD
0
 
LVL 1

Author Closing Comment

by:mikesExpertExchange
ID: 33801366
thank you.
0
 
LVL 82

Expert Comment

by:leakim971
ID: 33801392
You're welcome! Thanks for the points!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will learn how to count occurrences of each item in an array.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question