How to populate default textarea value on select from dropdown

[Ramakanta Sahoo]

Hi All,

I am not able to get this silly question. I searched in google but didn't any satisfactory answers.
What i want is i have a default value in textarea which needs to get populated/replaced with a list of options from drop down.
Each dropdown has a big sql query named something. I want that query should get replaced with what ever is there by default in the text area.

Any examples will be great!!
Please help!!

[Eric Pascarello]

You either need t post the form back to the server or look into Ajax.

Eric

[Joe Sondow]

Ramakanta,

I recommend that you post a very short HTML snippet showing the type of form you have in mind, along with any JavaScript attempt you have made so far, if possible. You're more likely to get a helpful response that way. See PostRealCode and NotACodeMill

[Ramakanta Sahoo]

Okay as you say here is code
I made it work by this but this has no advantage.
I am having problem in putting the queries which are big and multiline in savedquery.js how do i put very big multiline queries in array values.

savedquery.js

  
var myQueries = new Array();
myQueries[0] = "Select * from dual";
myQueries[1] = "Select * from mytable where claus is this";
myQueries[2] = "Select column A from here";
  

  
<script src="/savedquery.js" language="javascript" type="text/javascript">
</script>
<script language="javascript" type="text/javascript">
function setTextArea(dropDown){

 //get the currently selecte dropdown option
 var curOption = dropDown.options[dropDown.selectedIndex];

 //get the text of the current option
 var optionIndex = curOption.value;

 //get a reference to your textarea or textbox
 var theTextArea = document.getElementById("instantTextarea");

 //set the value
theTextArea.value = myQueries[optionIndex];
}
</script>
  

  
<form>
blah...
  <textarea cols="80" id="instantTextarea"  name="h66"  rows="8"  wrap="off" ></textarea>
<select id="querychoice" name ='InstantQuery' onChange="setTextArea(this)">
                                    <option  value ="">SELECT</option>
                                    <option value ="0">Dual</option>
                                    <option value ="1">Recyclebin</option>
                                </select>
blah..
</form>

  

[Joe Sondow]

Ramakanta,

You can add newline characters in your strings using \n like this:

 var myQueries = new Array();
 myQueries[0] = "Select * from dual";
 myQueries[1] = "Select * from mytable\nwhere id > 5\nand other stuff < 10";
 myQueries[2] = "Select column A from here";

[Ramakanta Sahoo]

Yes I know but my problem is
How can I put if my query is like this :

  

select	tsu.tablespace_name "Tablespace"
,	ceil(tsu.used_mb) "Size MB"
,	100 - floor(tsf.free_mb/tsu.used_mb*100) "%Used"
,	ceil((tsu.used_mb - tsf.free_mb) / .8) - tsu.used_mb "Add (80%)"
from	(select tablespace_name, sum(bytes)/1024/1024 used_mb
	from    dba_data_files group by tablespace_name) tsu
,		(select ts.tablespace_name
	,       nvl(sum(bytes)/1024/1024, 0) free_mb
	from    dba_tablespaces ts, dba_free_space fs
	where   ts.tablespace_name = fs.tablespace_name (+)
	group by ts.tablespace_name) tsf
where	tsu.tablespace_name = tsf.tablespace_name (+)
and	100 - floor(tsf.free_mb/tsu.used_mb*100) >= 80
order	by 3,4


  

[Eric Pascarello]

you DO NOT, let me repeat DO NOT want to store SQL Queries in your JavaScript. You are asking for your site to be hacked. That logic BELONGS on the server.

Eric