Search Results

Search found 33316 results on 1333 pages for 'sql team'.

Page 712/1333 | < Previous Page | 708 709 710 711 712 713 714 715 716 717 718 719  | Next Page >

• MySQL join not returning rows

  - by John

  I'm attempting to create an anti-bruteforcer for the login page on a website. Unfortunately, my query is not working as expected. I would like to test how many times an IP address has attempted to login, and also return the ID of the user for my next step in the login process. However, I'm having a problem with the query... for one thing, this would only return rows if it was the same user as they had been trying to login to before. I need it to be any user. Secondly, regardless of whether I use LEFT JOIN, RIGHT JOIN, INNER JOIN or JOIN, it will not return the user's ID unless there is a row for the user in login_attempts. SELECT COUNT(`la`.`id`), `u`.`id` FROM `users` AS `u` LEFT JOIN `login_attempts` AS `la` ON `u`.`id` = `la`.`user_id` WHERE `u`.`username` = 'admin' AND `la`.`ip_address` = '127.0.0.1' AND `la`.`timestamp` >= '1'

  Read the article

• what does this ADO OPEN Method do?

  - by every_answer_gets_a_point

  in plain english can you explain to me what happens here: rs.Open "batchinfo", oConn, adOpenKeyset, adLockOptimistic, adCmdTable what i need to do is to be able to insert values into a table called batchinfo. would this be the best way to do an OPEN? the only thing i would be doing is inserting values.

  Read the article

• ERROR: there is no parameter $1 when creating view

  - by idlemoments

  When we try to create a view within a funcion we get ERROR: there is no parameter $1. This is the sample code. Begin CREATE VIEW artikelnr AS SELECT datum, 'uitgifte' as "type", CASE WHEN 'test'='test' THEN 0 END as "aantal ontvangen", aantal as "aantal uitgegeven" FROM uitgifteregel JOIN artikel ON artikel.artikelnr = new.artikelnr JOIN uitgifte ON uitgifte.uitgiftenr = uitgifteregel.uitgiftenr UNION SELECT datum, 'ontvangst' as "type", aantal as "aantal ontvangen" , CASE WHEN 'test'='test' THEN 0 END as "aantal uitgegeven" FROM ontvangstregel JOIN artikel ON artikel.artikelnr = new.artikelnr JOIN ontvangst ON ontvangst.ontvangstnr = ontvangstregel.ontvangstnr; Return new; end; When we replace new.artikelnr on line 7 with value 1 it works like it should, but the function needs to work with different artikelnr's. example line 7: JOIN artikel ON artikel.artikelnr = new.artikelnr Please point us in the right direction.

  Read the article

• Why am I getting a MySQL error?

  - by John Hoffman

  Here is my query. Its intention is allow access to properties of the animals that constitute a match of two animals. The match table contains columns for animal1ID and animal2ID to store which animals constitute the match. SELECT id, (SELECT * FROM animals WHERE animals.id=matches.animal1ID) AS animal1, (SELECT * FROM users WHERE animals.id=matches.animalID) AS animal2 FROM matches WHERE id=5 However, MySQl returns this error: Operand should contain 1 column(s). Why? Is there an alternative way to do this, perhaps with a JOIN statement?

  Read the article

• How do I delete every row except the last one for each day?

  - by A B

  I have a table with stock quotes that looks something like this: id, date, stock_id, value Every day has several rows for each stock_id (it is automatically updated every five minutes), so the table is rather big at the moment. How do i delete every row but the last one each day for every stock_id?

  Read the article

• SQL Syntax for multiple conditions in the same field

  - by Jonathan

  I can't seem to find this in the mysql manual: How do you enter multiple conditions for the same field in a select statement? e.g.: SELECT * FROM table WHERE ID = '1, 2, 3, 4' Is there a way to do this without using this: SELECT * FROM table WHERE ID = '1' OR ID = '2' OR ID = '3' OR ID = '4'

  Read the article

• Problems while trying to make a query with variables in the conditions (stored procedure)

  - by pablo89

  Hi!! Im having a problem, Im trying to do a query... I remember that in the past I did something like this but today this query is returning nothing, no error, no data, just nothing... the query is something like this: SELECT field1, @variableX:=field2 FROM table WHERE (SELECT COUNT(fieldA) FROM table2 WHERE fieldB=@variableX AND fieldC=0)0 AND (SELECT COUNT(fieldA) FROM table2 WHERE fieldB=@variableX AND fieldC=4)=0; I also tried this query but it didnt work (also it gaves no error): SELECT field1, @variableX:=field2, @variableY:=(SELECT COUNT(fieldA) FROM table2 WHERE fieldB=@variableX AND fieldC=0), @variableZ:=(SELECT COUNT(fieldA) FROM table2 WHERE fieldB=@variableX AND fieldC=4) FROM table WHERE @variableY0 AND @variableZ=0; As you can see, what Im trying to do in the 1st query is use a variable in the conditions; in the 2nd query Im trying to create some variables and evaluate them in the conditions. At the end in the 2nd query the @variableY=1 AND @variableZ=0 but I dont know what the query returns an empty data What could be wrong here??? Any comment or suggest is welcome!!! thanks!!! Bye!!!

  Read the article

• SQL Join Statement Issue

  - by coffeeaddict

  I'm tring to grab all fields from the latest Cash record, and then all fields from the related TransactionInfo record. I can't quite get this to work yet: select t.*, top 1 c.* from Cash c inner join TransactionInfo t on c.TransactionID = t.id order by createdOn desc

  Read the article

• Please help translate this in linq to ef

  - by user3487644

  StringBuilder sb = new StringBuilder(); sb.AppendLine("SELECT"); sb.AppendLine(String.Format(" (SELECT TOP 1 CAST(ProspectID AS VARCHAR(5)) FROM Lead_Import_Fail Where ProspectID < {0} AND ProspectFullName = '{1}')", Convert.ToInt64(lead.LeadID), lead.Name)); sb.AppendLine(String.Format(", (SELECT TOP 1 CAST(ProspectID AS VARCHAR(5)) FROM Lead_Import_Fail Where ProspectID < {0} AND ProspectNRICPassport = '{1}')", Convert.ToInt64(lead.LeadID), lead.NRIC)); Thanks in advance.

  Read the article

• Can I use TSQL to operate on normal os files? Such as create a .bat file and write some query result

  - by Yousui

  Hi guys, Can I use TSQL to operate on normal operating system files? Such as create a .bat file at c:\test and write some query result into that batch file? Thanks.

  Read the article

• How do database servers decide which order to return rows without any "order by" statements?

  - by Chris

  Kind of a whimsical question, always something I've wondered about and I figure knowing why it does what it does might deepen my understanding a bit. Let's say I do "SELECT TOP 10 * FROM TableName". In short timeframes, the same 10 rows come back, so it doesn't seem random. They weren't the first or last created. In my massive sample size of...one table, it isn't returning the min or max auto-incrementing primary key value. I also figure the problem gets more complex when taking joins into account. My database of choice is MSSQL, but I figure this might be an interesting question regardless of the platform.

  Read the article

• insert values with different delimiter

  - by every_answer_gets_a_point

  i want to insert values into a table, with an INSERT INTO statement but i would like to use a different delimiter (not a comma) how do i do this?

  Read the article

• How to pass and Return a Array to stored procedure?

  - by padmavathi

  I would like to know how to pass an array to a stored procedure which in turn will return an array from c# .net? Thanks& Regards Padma

  Read the article

• equal insread of distinct

  - by MirooEgypt

  SELECT DISTINCT IncreasmentAmount, Name, regionid FROM Pricing.GroupOfRegions where regionid in (6,7) i have this result 12.80 AB 6 13.00 ABC 6 15.00 AC 6 12.80 AB 7 13.00 ABC 7 i wanna add more condition where IncreasmentAmount are equals which means i got the rows where regionid in (6,7) and have the same IncreasmentAmount so i got finally 12.80 AB 6 12.80 AB 7

  Read the article

• ms-access: designing a report: printing text on specific x,y coordinates

  - by every_answer_gets_a_point

  i need to design a report that will print text on specified x,y coordinates for example, i will input (50,50), (60,60), (70,70) and i will have my program print text at those specific coordinates on the report. in total there will be about 50 different coordinates. how do i achieve this? should i be using a label control or a textbox? should i be creating the controls dynamically or should i already have controls set at the specified regions?

  Read the article

• What is the best practise for relational database tables in mysql?

  - by George

  Hi, I know, there is a lot of info on mysql out there. But I was not really able to find an answer to this specific and actually simple question: Let's say I have two tables: USERS (with many fields, e.g. name, street, email, etc.) and GROUPS (also with many fields) The relation is (I guess?) 1:n, that is ONE user can be a member of MANY groups. What I dis, is create another table, named USERS_GROUPS_REL. This table has only two fields: us_id (unique key of table USERS) and gr_id (unique key of table GROUPS) In PHP I do a query with join. Is this "best practice" or is there a better way? Thankful for any hint!

  Read the article

• does mysql undo changes if you kill thread?

  - by every_answer_gets_a_point

  i ran a delete rows query. it was taking too long so i killed the thread from administration. did it undo the changes to the table/?

  Read the article

• Query to select from two different tables

  - by ryan

  I would like to select from two tables and display my result using this query: CREATE TABLE Buy_Table ( buy_id int identity primary key, user_id int, amount decimal (18,2) ); go INSERT INTO Buy_Table (user_id, amount) VALUES ('1', 10), ('1', 8), ('1', 20), ('3', 1), ('2', 2); go CREATE TABLE Sell_Table ( sell_id int identity primary key, user_id int, amount decimal (18,2) ); go INSERT INTO Sell_Table (user_id, amount) VALUES ('1', 10), ('1', 8), ('1', 20), ('3', 3), ('2', 3); go select [user_id], 'Buy' as [Type], buy_id as [ID], amount from Buy_Table union all select [user_id], 'Sell', sell_id, amount from Sell_Table order by [user_id], [ID], [Type] However the above query will return each row of the user_id like this I want to display my result to something like this in a grid: Can this be done in query itself rather manipulating the grid? Thx

  Read the article

• SELECT DISTINCT on a field not appearing in recordset?

  - by user151841

  I want to do a SELECT DISTINCT guid, ..., but I don't want guid appearing in the recordset. How do I do this?

  Read the article

• methods of joining 2 tables without using JOIN or SELECT more than one distinct table in the query

  - by GB_J

  Is there a way of joining results from 2 tables without using JOIN or SELECT from more than one table? The reason being the database im working with requires queries that only contain SELECT, FROM, and WHERE clauses containing only one distinct table. I do, however, need information from other tables for the project i'm working on. More info: the querier returns the query results in a .csv format, is there something we can manipulate there?

  Read the article

• When to use JOINs

  - by waiwai933

  It seems to me that there are two scenarios in which to use JOINs: When data would otherwise be duplicated When data from one query would otherwise be used in another query Are these scenarios right? Are there any other scenarios in which to use JOIN?

  Read the article

• MSSQL + Select only two records for each masterID in a table.

  - by Nev_Rahd

  I got childtable wherin it got 1 to n records liked to mastertable with MasterID column. How can i select from child table only first 5 records for each MasterID.

  Read the article

• Count of Sums possibly using group_by

  - by Daniel Johnson

  Say you have a user table and an order table which references user (user has_many orders) and contains an item count field. How could you efficiently ask "how many uses ordered how many items?" That is, to generate something along the lines of: Number of users | sum of items ------------------------------- 5 users | 1 item 4 users | 5 items 1 user | 7 items Thanks in advance.

  Read the article

• How to do Group By in grails to order bei Count(*)

  - by skurt

  How do I translate: SELECT COUNT(*) AS `count`, `a` FROM `b` GROUP BY `a` ORDER BY `a` into grails or gorm query?

  Read the article

• How to insert row a in one column (PK) table?

  - by JohnM2

  I have table with one and only one column, which is an identity column (PK) of this table. How to insert row in this table? INSERT INTO table_name doesn't work, neither do: INSERT INTO table_name() VaLUES()

  Read the article

< Previous Page | 708 709 710 711 712 713 714 715 716 717 718 719  | Next Page >