Search Results

Search found 49727 results on 1990 pages for 'multiple select query'.

Page 257/1990 | < Previous Page | 253 254 255 256 257 258 259 260 261 262 263 264  | Next Page >

• How to join two query in SQL (Oracle)

  - by MAHESH A SONI

  How can I join these queries? SELECT RCTDT, SUM(RCTAMOUNT), COUNT(RCTAMOUNT) FROM RECEIPTS4 WHERE RCTDT BETWEEN '01-nov-2009' AND '30-nov-2009' AND RCTTYPE='CA' AND RCTAMOUNT>0 GROUP BY RCTDT --- SELECT RCTDT, SUM(RCTAMOUNT), COUNT(RCTAMOUNT) FROM RECEIPTS4 WHERE RCTDT BETWEEN '01-nov-2009' AND '30-nov-2009' AND RCTTYPE='CQ' AND RCTAMOUNT>0 GROUP BY RCTDT

  Read the article

• Mysql query question

  - by brux

  I have 2 tables: Customer: customerid - int, pri-key,auto fname - varchar sname -varchar housenum - varchar street -varchar Items: itemid - int,pri-key,auto type - varchar collectiondate - date releasedate - date customerid - int I need a query which will get me all items that have a releasedate 3 days prior to (and including) the current date. i.e The query should return customerid,fname,sname,street,housenum,type,releasedate for all items which have releasedate within (and including)3 days prior today thanks in advance

  Read the article

• An article and comments SQL query - efficient

  - by joe khan

  Hi there, What'd be the most effective and efficient sql query to grab an article and the comments? It'd be two tables (articles, comments.) Would it be best to have it in one SQL query or two SQL querys? Speed is the main concern. Thanks in advance

  Read the article

• Why is Wordpress $wpdb->query() response 1 when the rows returned is 0

  - by codecowboy

  I'm doing the following in a custom function: $exists = $wpdb->query($wpdb->prepare(' SELECT COUNT(*) FROM wp_%d_gdsr_data_article WHERE post_id = %d ', $blog_id, $post_id)); $exists evaluates to 1 even if no rows are returned by the query. Also, var_dump($wpdb-queries) yields a NULL. Anyone know what is going on here? thanks,

  Read the article

• How do I use multiple entries with Zend_Config_Xml?

  - by terrani

  Hello, I am trying to use multiple entries with Zend_Config_XML, but no luck so far. I have the following structure. I can't even access to access entries. Should I use other XML classes to use multiple entries?

  Read the article

• Accessing child collection in query

  - by Gokul

  I am populating a list using List<Country> countries = new List<Country> { new Country() { CountryID = "US", City = new List<City> { new City() { CountryID = "US", CityName="dfdsf", sqkm = 2803 } } }; and so on How to access sqkm in the following query? var countryQuery = countries .Select(c => new { Id = c.CountryId, Area = c.City.sqkm???}); c.city.sqkm gives compilation error...how to modify query

  Read the article

• running query and putting result into a variable ACCESS

  - by every_answer_gets_a_point

  i am running a query from vba editor access: "select max(somerow) from sometable" i want to put the result of this query into a variable. how do i do it?

  Read the article

• Hibernate Native Query problem with named parameters

  - by dime

  I have a problem with Hibernate Native Query. I have one SELECT that selects array slice (PostgreSQL database). The problem is that hibernate recognizes the following part: ":300" from "SELECT my_array[1:300]..." as named parameter and I get the following exception: Not all named parameters have been set. I tried to escape the colon (:) with '\:' , '::' but with no success. The Hibernate version is 3.2

  Read the article

• List Box Multiple Selection Problem

  - by rupeshmalviya

  Hello Friends I am using a list box control in aspx page i have set multiple selection property to true, but when i try to select more than one item it does not select multiple items, it selects one only do i have to do something programatically here is my code on code behind nothing ...i want why it is not selecting more than one item's .. i am using namespace using System.Web.UI.WebControls; as well but of no avail..

  Read the article

• Ruby on rails multiple apps hosting (name server)- configuration question

  - by Sanjay

  I am looking to host multiple ruby on rails apps and want to use lighttpd or nginx.How do I do multiple name server configuration. ? I know how to do it in apache through webmin control panel.But trying to move away from apache here

  Read the article

• LINQ TO SQL, Dynamic query with DATE type fields

  - by acanthus

  Hello, I'm building a query with the LINQ dynamic library so I don't know how many potential parameters will I have and I get an error when trying to query DATE type fields: Operator '=' incompatible with operand types 'DateTime' and 'String' When I step through the debugger in the Dynamic.cs it shows that the value is of type string and the field is of type date so the problem is obvious but I have no idea how to approach it. Any ideas? BR

  Read the article

• JAVA: multiple files download at the same time?

  - by user319096

  hi guys, Is there any methods for downloading multiple files at the same time? That is, after select multiple files, click the download button, and choose the destination directory, the files selected will be downloaded at the same time. i googled it and not find any solutions, can anybody know? im using struts1 and spring2.

  Read the article

• displaying multiple values with .FIELDS adodb

  - by every_answer_gets_a_point

  i am getting some data: rs.Filter = "datapath='" + dpath + "' and analystname='" + aname + "' and reportname='" + rname + "' and batchstate='" + bstate + "'" If Not rs.EOF Then MsgBox rs.Fields("rowid") End If if the rs.filter returns multiple records, how do i get rs.fields("rowid") to give me multiple rowid values?

  Read the article

• Join with table and sub query in oracle

  - by Amandeep

  I dont understand what is wrong with this query it is giving me compile time error of command not ended properly.The inner query is giving me 4 records can any body help me out. select WGN3EVENTPARTICIPANT.EVENTUID from (Select WGN_V_ADDRESS_1.ADDRESSUID1 as add1, WGN_V_ADDRESS_1.ADDRESSUID2 as add2 from WGN3USER inner join WGN_V_ADDRESS_1 on WGN_V_ADDRESS_1.USERID=wgn3user.USERID where WGN3USER.USERNAME='FIRMWIDE\khuraj' ) as ta ,WGN3EVENTPARTICIPANT where (ta.ADDRESSUID1=WGN3EVENTPARTICIPANT.ADDRESSUID1) AND (ta.ADDRESSUID2=WGN3EVENTPARTICIPANT.ADDRESSUID2) I am running it in oracle. Thanks Amandeep

  Read the article

• Multiple file upload in php.....

  - by udaya

  I want to upload multiple files and store them in a folder and get the path and store it in the database... Any good example you looked for doing multiple file upload... Note: Files can be of any type...

  Read the article

• mysql query if else statemnet?

  - by user253530

  I have this sql query: SELECT S.SEARCH, S.STATUS, C.TITLE AS CategoryName, E.SEARCH_ENGINES AS Engine, S.RESULTS, S.DATE, S.TOTAL_RESULTS AS Total, S.ID FROM PLD_SEARCHES AS S Join PLD_CATEGORY AS C ON C.ID = S.CATEGORY_ID Join PLD_SEARCH_ENGINES AS E ON S.SEARCH_ENGINES_ID = E.ID ORDER BY S.DATE ASC I want to identify if S.STATUS is either 1 or 0 and according to those values to return COMPLETE or PENDING in the query results

  Read the article

• Handling Optional Query Parameters

  - by Steven

  I have a GridView bound to an DataSource query with parameters tied to form controls. What is the standard / best-practices way to handle optional query parameters?

  Read the article

• What does "foo" mean in SQL Server Query ?

  - by John

  for eg... SELECT * FROM ( SELECT RANK() OVER (ORDER BY stud_mark DESC) AS ranking, stud_id, stud_name, stud_mark FROM tbl_student ) AS foo WHERE ranking = 10 Here foo is present...actually what it does ?..

  Read the article

• Getting random values in mySql query

  - by Roland

  I have a query which selects 6 names in the database. eg SELECT names FROM users LIMIT 6 Now I want this query to select a random 6 names in the database table, is this possible? And how

  Read the article

• Can php query the results from a previous query?

  - by eaolson

  In some languages (ColdFusion comes to mind), you can run a query on the result set from a previous query. Is it possible to do something like that in php (with MySQL as the database)? I sort of want to do: $rs1 = do_query( "SELECT * FROM animals WHERE type = 'fish'" ); $rs2 = do_query( "SELECT * FROM rs1 WHERE name = 'trout'" );

  Read the article

• Problem in importing the CSV file containing multiple commas in a sigle field

  - by kakaajee

  Hi Experts, I am having an issue with importing a large(60MB) CSV file in MYSQL DB. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc. I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values. Any idea, suggestion or solution from experts how to handle it? Please reply, because I am sick of it. Thanks

  Read the article

• not case sensitive query in mysql

  - by Mac Taylor

  hey guys i need to query my database and find results : mysql_query("select * from ".ALU_TABLE." where username like '%$q%' or name like '%$q%'"); if i have a name in my table such as Book and i enter book in search box it wont show the Book i need to query my database as not to be case sensitive.

  Read the article

• Problem with SQL query

  - by William

  Here's the query INSERT INTO test_bans( ip, Expiration ) VALUES ( "0.0.0.0", DateAdd( "d", 1, Date( ) ) ) Here's the table creation query CREATE TABLE test_bans ( ID smallint(6) NOT NULL AUTO_INCREMENT, IP text NOT NULL, Expiration DATETIME NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM; And here's the error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))' at line 1 Please help.

  Read the article

• How to create Multiple images with hyperlinks

  - by Jasl

  I have a psd image with me. This image has been created combining multiple images. I want that each of this multiple images must have a seperate alt tag and a hyperlink. When the user clicks on it, he/she should be taken to the that url. How can I do it. Please suggest me all options like open source or online tools etc.

  Read the article

• Printing Multiple html page through ASP.NET

  - by sameer

  Hi All, I have multiple letters in html format in a folder and im list those letters in the gridview on ASP.NET page if user select couple of letters and click print i should me those letters Now Question is how to print multiple html files on the event of button click.

  Read the article

< Previous Page | 253 254 255 256 257 258 259 260 261 262 263 264  | Next Page >