[select] Forum Topics

Dear all, i am trying to design a purchase form in which i wish to use jtable , when i press any character into the cell it should open a jlist with populated values from database and which let me select only one item from there and get the selected …

I am trying to update for some products their category in Database. But I get an error and and I dont understand where my statement is wrong. Please help me. I want to find products that have in their name a specific word and after that I want to update …

**Modifications Required for VB6 Applications to Work on Vista/7** Thanks to Hassan Basri in VBForums **Application Changes** - Remove SendKeys calls and replace them with API code. - Use the HKEY_CURRENT_USER in the registry for the settings of your application. - Do not write to HKEY_LOCAL_MACHINE. - If you are …

Hi I have this query: `SELECT SUM(`KN`) + SUM((COALESCE(`EUR`, 0)))*7.5 FROM log WHERE `KN` IS NOT NULL and `EUR` IS NOT NULL` And it retunrs 0 SUM(`EUR`)* 7.5 should be zero but SUM(`KN`) is 60. I am not shure what I am doing wrong here, I want to add numbers …

hi there , i would like to use the select statement in this event and not sure how to proceed... Private Sub TreeView1_AfterSelect(sender As Object, e As TreeViewEventArgs) Handles TreeView1.AfterSelect Dim NS As String = "" Select Case NS Case "Monday" If NS And e.Node.Text = "Monday" Then MessageBox.Show("The user …

hya im trying to populate a drop down select list from the database i have set the database up and written the following out if anyone can help would be much appreicated // Fetch user details $userdata = mysql_query("select * from user where user_id = '".$_SESSION['userid']."' "); $fetch_user = mysql_fetch_array($userdata); …

Hi when i click on a link and there are three select box populated dynamically now i want to change the first select box value and want to add the third one select box value add.as much as i populated select box all the value of third select box is …

Guess this is javascript. Similar as in excel, (I have seen this before), lets say I have 3 fields in a form. Now when entering a numeric value in field 1, and lets say field 2 has the value of 5, then the value of field 1 times field 2 …

I wanted to chain 3 selects and I got it working using this code. http://jsfiddle.net/FJFFJ/1/ The issue I now have is, how do I fetch the selected values from each dropdown in PHP? For example, the above creates 3 select boxes when the page is opened. When I click on …

I currently wish to write a query to duplicate data in database while modifying one column. First of all, my database structure: table code CURCD NOT NULL VARCHAR2(3) CODE NOT NULL VARCHAR2(2) ITEM NUMBER(1) DSCPT VARCHAR2(20) The unique idx is the curcd,code,item. What I wish to achieve is duplicate data …

SQL Gurus, help !! I have a table with 3 fields, ID, Answer_5, Answer_6. Answer_5 & Answer_6 both hold a date value, but the fields are defined as string (for other reasons). In Answer_6 it is possible to have the string of 'Now'. I am trying to do a simple …

I have some Tkinter code with a Label object. The user needs to be able to select text from the Label in order to copy the text (and paste into something else). However, it seems Labels aren't selectable? I can't figure out how to enable this... any suggestions? [code] from …

I’m trying to patch a routine and I finally found the problem. I am given the following string: [code] $query = "SELECT title, DATE_FORMAT(event_date, '%Y-%c-%e') AS event_date FROM $dbTable WHERE event_date LIKE '$year-$month%'"; [/code] In the month variable at the end, for the months January through September I am returned …

I am looking for help to write a query. I have a database with an ID a Date_Field and a Description. I want to find out two things What Date_Field and Description and Description are the same? {duplicate records} [code] SELECT * FROM TIME_TABLE t1 WHERE EXISTS ( SELECT * …

I have just one tables in database and three stored procedure (IUD)..and i m using EF for db integration MVC 4 ..as soon as i insert data in db ..it just display as it as (call it select * from tbl1) ..what if i m going to select data from …

hi people how do I select a specific row in a data grid view to be updated. the row contains item number, item name and price. thanks

Hello, I'm developing a custom plugin for wordpress and I've got to retrieve some numbers from a table where the value in the expiry_date column is greater than value that I've stored in a variable called $scheduleddate (That is, I need to retrieve numbers that haven't expired as at the …

Hello everyone, I'm trying to select same "id" for more than one input. My code works with 1 input, but when I add 2 textareas or more my code stops working... Here's my code: *Javascript* *<script> function validateComment() { var value = $("[id=commentbox]").val(); var word = value.toLowerCase(); // make sure …

hi all, I want to use multiple select drop down box. I am using client, project and activity. These all values are coming from database. I want when i select one client from first drop down box .Then second drop down box will display only that project which come under …

I have a html select list where one can chose an option. <select name='price' id='price'> <option value='' >Select....</option> <option value='0-50,000'>0-50,000</option> <option value='50,000-100,000'>50,000-100,000</option> <option value='100,000-150,000'>100,000-150,000</option> <option value='150,000-200,000'>150,000-200,000</option> <option value='200,000 and above'>200,000 and above</option> <option value='see all'>See All</option> </select> When this list is submitted via a html submit button, this list shows …

Hi All We found many Calendar, which are fine what we need is only show date in season like **25-12-2012 to 15-01-2013** and date we allow to use to select, like if we say available **26-dec and 10-jan** all the can do is select the date fr calender Please help …

Hey guys, I just learned the very basics of arrays and I have to write this program of a tic-tac-toe game. The requirements are this: Write a modular program that allows two players to play a game of tic-tac-toe. Use a two-dimensional char array with 3 rows and 3 columns …

Hello, I have a script that allows user to upload a file to a mysql 5 database. That is working OK. The File size is accurate. However, my download script is for some reason downloading the files without any content - 0KB. The files are OK when I open them …

I have the following code: <?php session_start(); include_once("config.php"); $query = "SELECT Category FROM books"; $result = mysqli_query ($mysqli, $query); echo '<select name="dropdown" value=""><option value="">Dropdown</option>'; while($row = mysqli_fetch_array($result)) { echo '<option value="' . $row['Category'] . '">' . $row['Category'] . '</option>'; } echo "</select>"; ?> the values of the drop down box …

I am very new to the Mysql/php environment so would appreciate guidance here please. 1) I have a php program that uses a Form to enter data into a MySQL table. This is working OK when data is entered into the fields manually. 2) I have a short php script …

what is the code for the selection boxes in html?? is that code included in the form tag or not??

upload.php <form name="selectionForm" method="POST" action='query.php'> echo "<select name='$q2['type']'>"; //echo "<select name='selecttype'>"; echo "<option value='Regular Project'>Regular Project</option>"; echo "<option value='FSA Project'>FSA Project</option>"; echo "</select></td>"; echo "<input type='hidden' name='mid' value='$q2[0]'>"; echo "<td width='140'><textarea rows='2' name='comments[]' cols='20' ></textarea></td>\n"; echo "</tr>\n"; </form> query.php $selecttype = $_POST['selecttype']; instead of calling 'selecttype' i want to call …

I am maybe blind or so... just got nearly the same problem as before. I not get the values of the selectfields. I got 0 - 8 instead of some strings. Here is the url: http://web159.login-142.hoststar.ch/memberd/de/prices/ Here is my code I use to get it: # read size of one …

Hi I just have the follow problem. In my form, I have a select option. Usually I should see some text there, I can change and open the dropdown menu, but I not see any text. What it could be? Here is the url: http://web159.login-142.hoststar.ch/memberd/de/prices/ And here some html code: …

I have an enquiry form where once the user click the submit button the form mailhandler.php and sends the email to myself. I have tried doing this through php but its not fully working as I do not recieve any emails. Here is my mail handler.php <?php if(isset($_POST['buttonSubmit'])){ $to = …