select sum(amount)as Total from studenttbli have wriiten above query ,now i need that amount sum in vbscript variable. i m not able to write tht i have written folowing but it is showing errortotal=sum.filed("Total")
View 1 RepliesCan I call a value from the database to javascript/vbscript. Let's say the database is called SQL="SELECT * from checkout".Can I validate that the SQL and the javascript/vbscript equals to each other and inside the javascript uses the response.redirect function to another asp page?
View 3 Replies View RelatedIm using the onchange event for a dropdown list to change SQL statements based on the index of that dropdown chosen. For example I have a function like this for my onchange event of the drop down list.
<script type="text/javascript">
function listboxchange(index)
declare connection ...
[code]....
Not sure whether this should go in the JavaScript or VBScript/ASP section, but I'll try here anyway.
I have an ASP include file that contains both VBScript and JavaScript code. The VBScript processes some information and has an onChange event which calls a JavaScript function. Within this javascript function I want to access a recordset and retrieve a value using a variable from the javascript. Here's the code from the JavaScript section. Code:
I am trying to display the year in two columns vice the single column. I know I need to create some master table, but the more I mess with it the worse it gets. display the previous and following year in the same format. Here is the code.
Code:
<head>
<script language="JavaScript" type="text/javascript">
function day_title(day_name) {
document.write("<TD ALIGN=center WIDTH=35>"+day_name+"</TD>")
[Code]....
I have a PHP script that will get images out of the database and display them in a grid. I have two verisons. I save a thumbnail which I display and then a larger image in a different folder. These images are placed in a scroll bar but what I would like to happen is that when I click on a thumbnail it basically displays the bigger image until I click on that image and it goes away. I would love for the middle of the image to be displayed in the middle of the users screen but beggers probably can't be choosers in this case.
An example of a similar desired result is a link here:http://qrayg.com/experiment/hig/Instead of the hover, I'd like to utilize the onclick to display and remove the image. If it's easy to put the center in the center of the screen that that would be absolutely incredible as well.
I have a MySQL database with a table where I store images (the file name, the mimetype of every file and the binary data in a BLOB plus a unique ID). Now what I'd like to achieve is to load an image from the database using AJAX and the POST method. Viewing a specific image using the GET method is quite simple, I just set the SRC attribute of an <img /> HTML tag to link to the PHP file and set the correct GET variables, there's no AJAX needed for that.I click a button or something, and 'behind the scenes' PHP is retrieving an image from the MySQL database, depending on the unique ID that was provided by AJAX through the POST method. AJAX uses the returned data to fill an element somewhere in the document, and that would be the freshly-loaded image.
Alright here's some code:
//PHP retrieving an image:
$returnImageQuery = "SELECT imageName, mimetype, imageBinaryData FROM imageTable WHERE ID = $_POST['someID']";
$return = mysql_query($returnImageQuery );
[code]....
I'm trying to display data from mysql database using getJSON
this is the code JQuery Code
Code:
//get data from database
$.getJSON('getCategories.php', parseCat);
// display data
[Code]....
i have a image that need user click on it and get the coordinates and store the coordinates to mysql database by using php. Here my code:
Code:
<script type="text/javascript">
function(ev){
var pos=zxcPos(this.img);
var mse=[ev.clientX-pos[0],ev.clientY-pos[1]];
var ary=this.ary;
if (ary.length>4)
[Code]...
Does anyone know how to set a javascript variable as a query result from a MySQL database.
As an example, like this:
Set this query:
I just can't do it. I've tried doing it like this:
But the thing stops my <body onLoad=""> function from working. I'm no expert in Javascript.
I'm using drupal, and am having trouble to convert a table to a one field two column at code level.Is it possible to manipulate it using jquery using odd and even?
View 2 Replies View RelatedWith input box if you type something and refresh the page, the previous words that you typed in will be filtered and be display in a scroll down form in which you can click it.My question is, when I click the input type is it possible to scroll down, and display values that comes from a database? It should also filter the scroll down results. If it's possible I don't know how to do it.
View 1 Replies View RelatedFind a solution to this... I am trying to get a page to load into a div, but only if a database variable is equal to 1, if the variable is not equal to 1, it should check back every 5 seconds. Once the page is loaded into the div, it should stop checking. Also when the page that was loaded into the div is closed, everything starts over again.
View 19 Replies View RelatedI have succesfully applied the datepicker to a blank textbox. However, when I apply the datepicker to a textbox with the initial value dynamically set to display a value from a database, the date picker genertes an error when anything on it is selected. The datepicker will display when the trigger icon is selected but you cannot select anything from the date picker without generating the following errors: When selecting:
a day: 'undefined' is null or not an object (ui.datepicker.js line 767) a month or year: 'input' is null or not an object (ui.datepicker.js line 755) a back or forward arrow: 'settings' is null or not an object (u.i datepicker.js line 1137) I have looked at these lines in the file, but I have no idea where to begin.
i am trying to create a form that where the page will not refresh if the form is submitted specially if the user inputs any errors in the form my problem is i do not know how to send multiple variables using jquery to a php file i saw somewhere that in order to do this you need to concatenate the variables you will be sending this is the code i am using
<html>
<head>
<style type="text/css">
#add(display: none;}
[code]....
the jquery successfully sends the variable to the php file the problem is once i insert it into a database all the variables i sent are concatenated for example in the column stud_no once you send the form this is what will be inserted "123123name=asdasd"
I'm very new to jQuery, only picked it up yesterday, so there is very little I understand at the moment. I have a website on which I would like to display a real time, time-series chart displaying results from a database that is constantly updated. how to pull live data from my database and display it in an alert box on my sight. One of the replies said I should use jquery to achieve this.
[Code]...
Basically the user would see a button on a form that would be something like "add contact"...then a window opens that shows a search window (want to implement something like [URL]) and it would show all the contacts available in the contacts table...then the user selects the contact to add (via a link).
I think i could get it this far, but how would i then pass that $row to the main form so that i can use the fields from that $row in the contacts table on my form?
Can i make a column as a checkbox column?
View 1 Replies View RelatedI'm trying to get a select box to display text from a database in a div tag from the select box populated by a while loop that also pulls from the database. The only way I can do this is from a javascript written by sending it over to a second page and I need it on just one page. Here is my code below:
<?php
session_start();
$q=$_GET["q"];
$num = $_GET['num'];
$test = $_GET['oneGram1'];
$_SESSION['oneGram']=$test;
[Code]...
Even if this is a wrong way to go about doing this can someone post just a simple script using a select box and displaying data on the same page?
I try to write code for some form. When user click on checkbox variable price should be change and display new value. My code is
function change_price(){
var price = 0;
if($('#checkbox1').is(':checked')){
var price = 450;
[Code].....
Why price is still 0 when I click checkbox?
i am editing a javascript game and im trying to get a heading (h1) to display the value of a variable in a javascript function however everything i have tried always causes an error.
View 1 Replies View RelatedI am fairly new to coding HTML with Javascript. I am hitting my head onto the table because i cannot figure out how to pull the variable value out in a document.write statement. Basically, I am calling a function to give me a random number between 1-4. I use that randomNumber to attach to different .jpg, descriptions, and URL's. So far, i have only got the image to display, but unable to get the link and description to display. Basically, i am trying to diplsay random ads and links like the one at the top of this page.
p.s. I know I am getting the randomNumber out of my function becasue I can call a simple document.write(randomNumber) and it works. Substitute adDesc and adURL in place of randomNumber and I also get the description and link respectively.
[Code]...
On my site there is information that changes several times a year and I want to make it a lot easier by having it change on all my pages at once. For instance the delivery time may change from 1 week to 2 weeks depending on the time of year. What I've come up with so far should work, but I don't know how to finish it, or if it's the best approach for my problem.
Since the sections I want to change frequently may have a bit of text I would link the template of my site to the external JavaScript file external.js. In that file I would declare the variable and assign it a value related to the shipping time (see below). code...
my spring mvc controller dumps a map variable to the jsp page.MyController.java
Map map=new HashMap();
map.put("optionMap",optionMap;//
value of variable optionMap is like//key=optionGroup1, value="<option value="abc">abc</option><option value="def">def</option>"
there is a single selector in the jsp page. which has two options "optionGroup1", and "optionGroup2" respectively.when user click optionGroup1, value of ptionMap.optiongGroup1 will be inserted in a multiple selector
jsp:
<select id="single">
<option value="optionGroup1">optionGroup1</option>
<option value="optionGroup2">optionGroup2</option>
</select>
[Code].....
I'm trying to make a basic rss reader with a google reader-esque functionality of clicking on article names and being able to expand/collapse that article. I'm working on the expand part and am going crazy. I am having no trouble getting content and displaying it without the onclick function but when I try to integrate onclick I can just get the titles.
[Code]...
$displaytext = "display this text";
$(".image").mouseenter(function(){
$(".test").text("$displaytext");
});
I would like to display the text in the variable $displaytext in my div.test when I mouse over the .image div. But instead, it just displays "$displaytext". Anyone know how I could make this work?