456 Topics
| |
Hy. I'm trying to do a select from multiple databases and tables for an occurence. let's say i have databases db1, db2 and db3. Each have the following tables t1, t2, t3. And in each table there is a field named id which i want to select and a field … | |
I would like to retrieve the previous date (i.e., current date minus 1) and use it in a query through an = operator. I got the following query to retrieve the previous date: [icode]select DATEADD(DD, DATEDIFF(DY, 0, GETDATE()), -1)[/icode] It gives: 2011-03-14 00:00:00.000 I would like to get only: 2011-03-14, … | |
I have an SQL Server Query: select *from table1 where column in ('list of values') When I execute this, I get all the details, however, when I do this: select *from table1 where column in ('list of values') and date_of_req='2011-03-15' I get an empty table. All the column headings are … | |
Hi all, I can't figure out how to select a child node when I already know its parent [Index] and the child's [Index] itself. Imagine a treeview like this: + Parent[0] |--- Child [0] |--- Child [1] + Parent[1] |--- Child [0] |--- Child [1] |--- Child [2] So how … | |
hello friends i need to make a edit profile page in my website,while registering a user can select multiple locations using multiple select options,so while editing user must get defaultly selected options while registering,i tried using multiple=multiple,but after getting details from databas it must select automaticlly....i cant do that can … | |
A simple streaming server-client pair with non-blocking user input can easily be coded in Python by using the 'select' module that provides a straightforward interface to the Unix select() system call. For Windows users however this is not an option as the acceptance of three empty sequences in the conventional … | |
Hi, I am new to mysql and have got a problem. I have managed to INSERT into the database and and check from it (a simple login system) but now after i login i want to copy all the data from that row and throw it into an arraylist. I … | |
hi!!! i have got a small problem wid an sql query that i m writting in jsp the query is real simple... but i dont know y m not gettin it... [CODE] q="select '" +col+ "' from '" +ta+ "'"; Class.forName(sq.getName()); cn=DriverManager.getConnection(sq.getConnstr(),sq.getUser(),sq.getPwd()); st=cn.prepareStatement(q); out.println("before query1"); rst=st.executeQuery(); [/CODE] [CODE] q="select ? … | |
Hi, I am having an issue getting my select boxes working in IE. My current situation is that I have 2 select boxes, 1 for Styles and another for Substyles. Not all Styles have a Substyle, but each Style has a different Substyle, so when should happen is when you … | |
I am working on a little project here. I have two arrays (States, Cities) I am trying to allow the user to chose one from a select form (Choice) and then have the values of the chosen array displayed in a alert(). Obviously I could just write an if statement … | |
| Hi I wonder if anyone can help I have a query SELECT b.name,c.name FROM directory_organisation_area_of_interest a, directory_organisation b, directory_areaofinterest c where b.id = a.organisation_id and a.areaofinterest_id = c.id which returns multiple rows per organisation however I would like to be able to have one row per org with multiple colums … |
Hi, I guess it's time for my first post here :) I've managed to create a php script that can run through a MySQL table and print out OPTIONS for a HTML SELECT tag. That was Google 101. But I want to keep my php and HTML separate so i've … | |
| Hey all, my first post in this brilliant website, got a lot of ideas from here. So I'm a student and currently we are learning a bit of php and right now I'm stuck. I have a database with URL adresses, there is 3 fields, id, name and adress. I … |
Hi, I need your help... I need to get the value selected by a user from the HTML page and pass this value into my servlet program for processing. So I did something like this: Part of my jsp code: [CODE] <select name="tool" id="tool"> <option value=kim>KIM</option> <option value=ontomat>Ontomat Annotizer</option> <option … | |
I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September … | |
I need help on dynamic forms with php. With a select action "Employees" checked, I want to show information of employees from a database in a text box. Thanks | |
I'm sure this is stupidly simple, but I havent been able to figure it out with lots of Google searching and pouring through tutorials. I'm building a simple computer trade-in value calculator PHP app. Using a form to select the type of computer and the various specs, I need it … | |
| Hi I am a bit rusty with SQL, not used it for about 8 years so would appreciate a bit of help. I have three tables, normalised, organisation, stores org_name and org_id ativities stores activity_name and ativity_id org_activity stores org_id and activity_id I need to get a list that contains … |
PHPMYSQL - How do you perform a double SELECT query or check against multiple fields? Does anyone know how this can be achieved? What i want is from a search page that has multiple search areas such as name / description / functions and be able to type multiple search … | |
Hi guys, me again. Having an issue with a multiple select form object that is generated through PHP and retrieves and displays MYSQL values. it displays and retrieves correctly and PHP produces is correctly, however, the form submission to post the values to MYSQL do not, instead it posts the … | |
| I have mySQL v.5.3 I think... I cannot figure out what is going on. Ive searched high and low and cant find an answer as to why i keep getting a syntax error. Heres the error I keep getting. [code] You have an error in your SQL syntax; check the … |
| I am filling a dropdown list and an HTML page with the contents of a MySQL database (the tablename is in the variable $tablename2). The file contains a single field, "BusinessCat", with 20 or so unique records. The code below is an attempt to display every category on an HTML … |
Hi, I used mysql_real_escape_string to insert a data with apostrophe, in the database, using php. This works. But when I want to select this data and display it in a form's field, it does not work. What happens is that the data before the apostrophe is displayed in the field, … | |
I am having a hard time understanding subqueries. I am pretty sure that is what I need to accomplish my task, but not sure how to put it together. I have a unique ID field that auto-increments, so that a new entry always gets a higher number assigned to that … | |
[B]This is the code that not getting the result[/B] [CODE] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> <html> <head> <title>Nice select</title> <script Language="JavaScript"> function checkData() { var myTest = me.D1.value; //alert(myTest); var req = new Request.JSON({ url: 'dbselect.php', method: 'post', data: 'brand=' + encodeURIComponent(myTest) }); req.addEvent('success', function(response) { var … | |
Hello, i have eleven drop down lists, one of them is main, and from the ten other lists only one should be visible. What i am doing is when i choose one option from the main select box, one of the ten other boxes becomes visible depending on which i … | |
For a website about tours I made a form to request for a quotation. There's quite a lot of input fields, some of them with dropdown menu's where the user can choose for example one of the tour destinations. I would like to know if I can pass variables from … | |
Hello, I am trying to get the element of an option, but seems my code is not working: <script type="text/javascript"> /*<![CDATA[*/ function reportsendipp() { if (window.XMLHttpRequest) { xmlhttp=new XMLHttpRequest(); } else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange=function() { if (xmlhttp.readyState==4 && xmlhttp.status==200) { ; } } xmlhttp.open("GET","report_member.php?report=" + document.getElementById("ipps").value + "&&member=" … | |
Hi I am using the following query: [CODE]"SELECT * FROM members WHERE name LIKE '$searchKey%';"[/CODE] Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, … | |
I have a site i've done in wordpress with multiple select boxes loaded from the database. How would i take the selected options from the select boxes and send the user to the corresponding url?? The select boxes are not chained or connected at all. Do they need to be … |
The End.