Search Results

Search found 27691 results on 1108 pages for 'multi select'.

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Page 315/1108 | < Previous Page | 311 312 313 314 315 316 317 318 319 320 321 322  | Next Page >

  • Send value from one action to another

    - by TJY
    I have vendors/show view with button "Add new item" button. When i press "Add new item", it leads to items/new view with select which contain all Vendors. I want to send vendor id value to items/new, that way it will be possible to show correct Vendor on my select. How it can be done RIGHT?

    Read the article

  • removing comma from string array

    - by sarah
    Hi, I want to execute a query like select ID from "xyz_DB"."test" where user in ('a','b') so the corresponding code is like String s="("; for(String user:selUsers){ s+= " ' " + user + " ', "; } s+=")"; Select ID from test where userId in s; The following code is forming the value of s as ('a','b',) i want to remove the comma after the end of array how to do this ?

    Read the article

  • MySQL using function IN with variable

    - by misanov
    I have problem querying table with variable in IN function. SELECT s.date, (SELECT GROUP_CONCAT(value) FROM value WHERE id_value IN(s.ref_values) ) AS vals FROM stats s ORDER BY s.date DESC LIMIT 1 Where s.ref_values is '12,22,54,15'. I get only one return for first number (12). When I insert that value directly in IN(12,22,54,15) it finds all 4. So, there must be problem with using variable in IN. What am I doing wrong?

    Read the article

  • How do i use the top keyword in an insert statement?

    - by acidzombie24
    I was using it as LIMIT when i got the exception Incorrect syntax near the keyword 'TOP'. Maybe i can omit it in this case without problem? but if i couldnt where do i put top? INSERT INTO [user_data] (...) SELECT ... @14 WHERE not exists (SELECT * FROM [user_data] WHERE [email] = @15 OR [name] = @16 OR [unconfirmed_email] = @17 TOP 1);

    Read the article

  • Simple DB2 Query for connection validation

    - by Eric Tuttleman
    I'm looking for a simple DB2 query that can be used to test if a database connection in pool is still valid. It needs to be a generic query that would execute regardless of which databases exist. For other database servers, I've used something like 'SELECT 1' or 'SELECT version();' What would be an equivalent for DB2? Thanks!

    Read the article

  • Given a Date "03/13/2010", using that in a MYSQL Where Clause?

    - by nobosh
    I would like to pass a MYSQL query via Coldfusion the following date: 03/13/2010 So the query filters against it like so: SELECT * FROM myTable WHERE dateAdded before or on 03/13/2010 I'd also like to be able to take 2 dates as ranges, from: 01/11/2000, to: 03/13/2010 SELECT * FROMT myTable WHERE dateAdded is ON or Between 01/11/2000 through 03/13/2010 thanks

    Read the article

  • Oracle query with LOWER

    - by Nickolodeon
    Hi. Why this returns 0 rows SELECT GARTUSERID, USER_CODE, UNITID, RANKCODE, RANKID, FIO, LOGINNAME, START_DATE, EXPIR_DATE, NOTE, POSITION, ISCHGPASSWORD, IS_EXPIRDATE, IS_BLOCKED, ROW_ID FROM ACONTROL.GARTUSERS WHERE LOWER(LOGINNAME)=LOWER(:LOGIN) AND ROW_ID=:MD5PSWD and this returns 1 row (as I wanted for the first query)? SELECT GARTUSERID, USER_CODE, UNITID, RANKCODE, RANKID, FIO, LOGINNAME, START_DATE, EXPIR_DATE, NOTE, POSITION, ISCHGPASSWORD, IS_EXPIRDATE, IS_BLOCKED, ROW_ID FROM ACONTROL.GARTUSERS WHERE LOGINNAME=:LOGIN AND ROW_ID=:MD5PSWD

    Read the article

  • SQL Server > Query > Column Names

    - by pojomx
    Hi, I'm here again- I have something like this Select A.a, A.b, A.a+A.b as c, (A.a+A.b*2)+A.d as d from Table But i want to know, if it is possible, to make it work with something like this: Select A.a,A.b,A.a+A.b as c, (c*2)+A.d as d from Table Thank you

    Read the article

  • Slow query execution time

    - by rotor
    select p.id,p.title,p.slug,p.content, (select url from gallery where postid=p.id limit 1) as url, t.name from posts as p inner join termrel as tr on (tr.object = p.id) inner join termtax as tx on (tx.id = tr.termtax_id) inner join terms as t on (t.id = tx.term_id) where tx.taxonomy_id=3 and p.post_status is null order by t.name asc This query took about 0.2407s to execute. How to make it fast?

    Read the article

  • How to save the values of one model in another?

    - by ragupathi
    I have user model and Language model where the language model contains different languages and i want the user to select the languages from that model and it should be stored for the corresponding user. Consider there are five languages A, B, C, D, E then the user has to select from the languages. Suppose user 1 selects A and C whereas user 2 selects B and D then the languages has to be stored for that user. How can i do this? please help me.

    Read the article

  • Why is one query consistently ~25ms faster than another in postgres?

    - by Emory
    A friend wrote a query with the following condition: AND ( SELECT count(1) FROM users_alerts_status uas WHERE uas.alert_id = context_alert.alert_id AND uas.user_id = 18309 AND uas.status = 'read' ) = 0 Seeing this, I suggested we change it to: AND NOT EXISTS ( SELECT 1 FROM users_alerts_status uas WHERE uas.alert_id = context_alert.alert_id AND uas.user_id = 18309 AND uas.status = 'read' ) But in testing, the first version of the query is consistently between 20 and 30ms faster (we tested after restarting the server). Conceptually, what am I missing?

    Read the article

  • SQL more elegant combination of boolean checks possible?

    - by Matze
    Call me pedantic but is there a more elegant way to combine all those checks? SELECT * FROM [TABLE1] WHERE [path] = 'RECEIVE' AND [src_ip] NOT LIKE '10.48.20.10' AND [src_ip] NOT LIKE '0.%' AND [src_ip] NOT LIKE '127.%' ORDER BY [date],[time] DESC; To something like this: SELECT * FROM [TABLE1] WHERE [path] = 'RECEIVE' AND [src_ip] NOT LIKE IN ('10.48.20.10','0.%','127.%', .... ) ORDER BY [date],[time] DESC;

    Read the article

  • Join two results sets to make one result set in T-SQL

    - by Michael Kniskern
    What would be the best approach to combine the two results sets in one result set in T-SQL? SQL statment #1: SELECT COUNT(t.col1) as 'Number of Responses', t.col2 as 'Department' FROM table t WHERE col3 IS NOT NULL GROUP BY t.col1 ORDER BY t.col1 SQL Statment #1: SELECT COUNT(t.col1) as 'Total number of participants', t.col2 as 'Department' FROM table t GROUP BY t.col1 ORDER by t.col1 Desired result set Number of Responses | Total Number of participants | Department

    Read the article

  • linq group by with count

    - by snorlaks
    Hello, Im trying to write query in linq Select UserId, UserNumber FROM User where UserNumber in (Select UserNumber FROM User group by UserNumber having Count(UserId) = 1) Aby hints ?

    Read the article

  • Doing sum's if certain conditions are true

    - by Gugu
    I am trying to build a query that does a sum if a certain parameter is set. For example: SELECT SUM(IF(<condition>,field,field)) AS total_value ...which is working correctly. But i have more than one condition in IF(), like: SELECT SUM(IF(<condition> <condition>,field,field)) AS total_value ..which is not working, could you have any idea what should be the right query for this.

    Read the article

  • MySQLi - Should every statement be prepared?

    - by Kerry
    I know its supposed to improve performance and clean strings, but lets say there are no variables? Might just be a SELECT COUNT( `column` ) AS count FROM `table` Should that be prepared? Is there any case that a SELECT statement should not be prepared?

    Read the article

  • how to validate

    - by kumar
    I have this Calender Control I am using..user can select any date from the calender.. I need to validate the dates like Saturday and Sundays and 1/1 and 1/25.. if they select these days I need to show them Popup message not valid date? can anybody help me out.. thanks

    Read the article

  • sqlite insert into: do the column names have to match?

    - by P a u l
    (This question is specific to SQLite3, but it may be common to all SQL I don't know.) This doesn't seem to work. Is it because the column names don't match? (If they match, it works.) If this is true, how can I select from a different field in the source table? INSERT INTO [ImagePoint] (ImageID, PointID, X, Y) SELECT Image2ID, PointID, X, Y FROM Point

    Read the article

  • Need help with a SQL Query

    - by Jack
    I have created a table with the following structure- $sql = "CREATE TABLE followers ( uid int UNSIGNED NOT NULL UNIQUE, PRIMARY KEY(uid), follower_count int UNSIGNED , is_my_friend bool, status_count int UNSIGNED, location varchar(50) )"; I need to find the uid of the person with max(status_count+follower_count) and whose is_my_friend = 1 I wrote the following query but I ain't getting the correct uid. SELECT p.uid FROM (select uid,is_my_friend,max(follower_count+status_count) from followers) p WHERE p.is_my_friend = 1;

    Read the article

  • Subscript out of bounds on a which statement in R

    - by ahandler
    I have data that looks like this: > head(newdata) zero one real 601 0.01273885 0.9872611 1 602 0.01273885 0.3242234 1 I want to select records where one is greater than .5 When I try this, I get "subscript out of bounds." Why am I getting this error? How do I perform this select? newDataGoodPredict <- newdata[ which(one0.5),] Error in newdata[which(one 0.5), ] : subscript out of bounds

    Read the article

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

< Previous Page | 311 312 313 314 315 316 317 318 319 320 321 322  | Next Page >