Menu
Hey guys,
I need to wright a MySQL query that take the items of selectedFields to be as my fields in the output table
I mean something like that: SELECT (all items of selectedField list) FROM table1
what should be instead of (all items of the selectedField list) .. !!??
[code]
<HTML>
<HEAD>
<TITLE>Form</TITLE>
<SCRIPT LANGUAGE=”JavaScript” SRC=”form.js”></SCRIPT>
</HEAD>
<BODY>
<style type=”text/css”>
#list { width: 200px;}
#button {width: 100px;}
</style>
<br/>
<h1>Field Selection</h1>
<form name=”fieldselectionform”>
<table width=”100%”>
<tr>
<td nowrap>Available Fields</td>
<td> </td>
<td nowrap>Selected Fields</td>
<td> </td>
<td rowspan=2 align=”center” valign=”bottom”>
<input type=”button” id=”button” value=”Clear Form” onClick=”moveAllOptions(document.forms[0]
[‘selectedFields’],document.forms[0][‘availableFields’]); “>
</td>
</tr>
<tr>
<td width=”20%”>
<select size=”20″ id=”list” multiple name=”availableFields” onDblClick=”moveSelectedOptions(this.form
[‘availableFields’],this.form[‘selectedFields’])”>
<option value=”item_1″>Item 1</option>
<option value=”item_2″>Item 2</option>
<option value=”item_3″>Item 3</option>
<option value=”item_4″>Item 4</option></select>
</td>
<td width=”20%” align=”center” valign=”center” nowrap>
<input type=”button” id=”button” name=”add” value=”>>” onClick=”moveSelectedOptions(document.forms[0]
[‘availableFields’],document.forms[0][‘selectedFields’]);”>
<br><br>
<input type=”button” id=”button” name=”remove” value=”<<” onClick=”moveSelectedOptions(document.forms
[0][‘selectedFields’],document.forms[0][‘availableFields’]);”>
</td>
<td width=”20%”>
<select size=”20″ multiple id=”list” name=”selectedFields” onDblClick=”moveSelectedOptions(this.form
[‘selectedFields’],this.form[‘availableFields’])”>
</select>
</td>
<td width=”20%” align=”center” valign=”center” nowrap>
<INPUT TYPE=”button” id=”button” VALUE=”Move Up” onClick=”moveOptionUp(this.form
[‘selectedFields’])”>
<BR><BR>
<INPUT TYPE=”button” id=”button” VALUE=”Move Down” onClick=”moveOptionDown(this.form
[‘selectedFields’])”>
</td>
</tr>
</table>
</form>
</BODY>
</HTML>
here’s java functions:
[code]
// ——————————————————————-
// moveSelectedOptions(select_object_From,select_object_To)
// This function moves options between select boxes. Works best with
// multi-select boxes to create the common Windows control effect.
// Passes all selected values from the first object to the second
// object.
// You can also put this into the <SELECT> object as follows:
// onDblClick=”moveSelectedOptions(this,this.form.target)
// This way, when the user double-clicks on a value in one box, it
// will be transferred to the other (in browsers that support the
// onDblClick() event handler).
// ——————————————————————-
function moveSelectedOptions(from,to) {
// Move them over
if (!hasOptions(from)) { return; }
for (var i=0; i<from.options.length; i++) {
var o = from.options[i];
if (o.selected) {
if (!hasOptions(to)) { var index = 0; } else { var index=to.options.length; }
to.options[index] = new Option( o.text, o.value, false, false);
}
}
// Delete them from original
for (var i=(from.options.length-1); i>=0; i–) {
var o = from.options[i];
if (o.selected) {
from.options[i] = null;
}
}
from.selectedIndex = -1;
to.selectedIndex = -1;
}
// ——————————————————————-
// moveOptionUp(select_object)
// Move selected option in a select list up one
// ——————————————————————-
function moveOptionUp(obj) {
if (!hasOptions(obj)) { return; }
for (i=0; i<obj.options.length; i++) {
if (obj.options[i].selected) {
if (i != 0 && !obj.options[i-1].selected) {
swapOptions(obj,i,i-1);
obj.options[i-1].selected = true;
}
}
}
}
// ——————————————————————-
// moveOptionDown(select_object)
// Move selected option in a select list down one
// ——————————————————————-
function moveOptionDown(obj) {
if (!hasOptions(obj)) { return; }
for (i=obj.options.length-1; i>=0; i–) {
if (obj.options[i].selected) {
if (i != (obj.options.length-1) && ! obj.options[i+1].selected) {
swapOptions(obj,i,i+1);
obj.options[i+1].selected = true;
}
}
}
}
// ——————————————————————-
// selectAllOptions(select_object)
// This function takes a select box and selects all options (in a
// multiple select object). This is used when passing values between
// two select boxes. Select all options in the right box before
// submitting the form so the values will be sent to the server.
// ——————————————————————-
function selectAllOptions(obj) {
if (!hasOptions(obj)) { return; }
for (var i=0; i<obj.options.length; i++) {
obj.options[i].selected = true;
}
}
// ——————————————————————-
// moveAllOptions(select_object,select_object[,autosort(true/false)[,regex]])
// Move all options from one select box to another.
// ——————————————————————-
function moveAllOptions(from,to)
{
selectAllOptions(from);
moveSelectedOptions(from,to);
}
// ——————————————————————-
// hasOptions(obj)
// Utility function to determine if a select object has an options array
// ——————————————————————-
function hasOptions(obj) {
if (obj!=null && obj.options!=null) { return true; }
return false;
}
// ——————————————————————-
// swapOptions(select_object,option1,option2)
// Swap positions of two options in a select list
// ——————————————————————-
function swapOptions(obj,i,j) {
var o = obj.options;
var i_selected = o[i].selected;
var j_selected = o[j].selected;
var temp = new Option(o[i].text, o[i].value, o[i].defaultSelected, o[i].selected);
var temp2= new Option(o[j].text, o[j].value, o[j].defaultSelected, o[j].selected);
o[i] = temp2;
o[j] = temp;
o[i].selected = j_selected;
o[j].selected = i_selected;
}