Search Results

Search found 23568 results on 943 pages for 'select'.

Page 526/943 | < Previous Page | 522 523 524 525 526 527 528 529 530 531 532 533  | Next Page >

• what's wrong with this function?

  - by Joann

  function get_ibo_id() { if($registerquery = $this->conn->query("SELECT ibo_id FROM fasttrack WHERE count < 8 && flag = 1 ")){ $this->increase_count(); while ($row = $registerquery->fetch_assoc()) { return $row[ibo_id]; } } else return "No id"; } it always enters the if block even if the condition is not satisfied... going crazy

  Read the article

• Convert this SQL Query into LINQ (OVER (PARTITION BY Date))

  - by user1106649

  Here's the query i'm trying to convert into Linq: SELECT R.Code, R.FlightNumber, S.[Date], S.Station, R.Liters, SUM(R.Liters) OVER (PARTITION BY Year([Date]), Month([Date]), Day([Date])) AS Total_Liters FROM S INNER JOIN R ON S.ID = R.SID WHERE (R.Code = 'AC') AND FlightNumber = '124' GROUP BY Station, Code, FlightNumber, [Date], Liter ORDER BY R.FlightNumber, [Date] Thanks for any help.

  Read the article

• what is the out put of this code?

  - by user329820

  Hi I want to know that this code will have an out put or it will show an error? thanks CREATE TABLE T1(A INTEGER NULL); SELECT * FROM T1;

  Read the article

• How do I search for the comma character within data stored in SQL Server?

  - by Fred

  I have some data that I needs to be searched for the comma character. example entry I need to locate in the field Citation in the Citations table: This is sometimes true, Textual Reference In the end, I'm looking to extract Textual Reference Selecting the column with the data: select Citation from Citations;

  Read the article

• ORDERING A MYSQL QUERY WITH JOINS AND GROUPS

  - by Oliver

  I have this mysql query: SELECT * FROM Customer c JOIN eHRDemographic ehD ON ehD.CxID = c.CustomerID JOIN CustPrimaryWeight cpW ON cpW.CxID = c.CustomerID WHERE c.CustomerID =22703 GROUP BY c.CustomerID ORDER BY cpW.CustPrimaryWeightID DESC This doesn't really work correctly as the CustPrimaryWeight table has multiple enteries and it's simply joining the first entry and not the more recent one as the ORDER statement doesn't seem to do anything. Any ideas?

  Read the article

• saving the FOR XML AUTO results to variable in SQL

  - by petergo

  select @[email protected]('*') for xml raw,type Above statement will generate following alert: Msg 6819, Level 16, State 3, Line 2 The FOR XML clause is not allowed in a ASSIGNMENT statement.

  Read the article

• SQL Cartesian product joining table to itself and inserting into existing table

  - by Emma

  I am working in phpMyadmin using SQL. I want to take the primary key (EntryID) from TableA and create a cartesian product (if I am using the term correctly) in TableB (empty table already created) for all entries which share the same value for FieldB in TableA, except where TableA.EntryID equals TableA.EntryID So, for example, if the values in TableA were: TableA.EntryID TableA.FieldB 1 23 2 23 3 23 4 25 5 25 6 25 The result in TableB would be: Primary key EntryID1 EntryID2 FieldD (Default or manually entered) 1 1 2 Default value 2 1 3 Default value 3 2 1 Default value 4 2 3 Default value 5 3 1 Default value 6 3 2 Default value 7 4 5 Default value 8 4 6 Default value 9 5 4 Default value 10 5 6 Default value 11 6 4 Default value 12 6 5 Default value I am used to working in Access and this is the first query I have attempted in SQL. I started trying to work out the query and got this far. I know it's not right yet, as I’m still trying to get used to the syntax and pieced this together from various articles I found online. In particular, I wasn’t sure where the INSERT INTO text went (to create what would be an Append Query in Access). SELECT EntryID FROM TableA.EntryID TableA.EntryID WHERE TableA.FieldB=TableA.FieldB TableA.EntryID<>TableA.EntryID INSERT INTO TableB.EntryID1 TableB.EntryID2 After I've got that query right, I need to do a TRIGGER query (I think), so if an entry changes it's value in TableA.FieldB (changing it’s membership of that grouping to another grouping), the cartesian product will be re-run on THAT entry, unless TableB.FieldD = valueA or valueB (manually entered values). I have been using the Designer Tab. Does there have to be a relationship link between TableA and TableB. If so, would it be two links from the EntryID Primary Key in TableA, one to each EntryID in TableB? I assume this would not work because they are numbered EntryID1 and EntryID2 and the name needs to be the same to set up a relationship? If you can offer any suggestions, I would be very grateful. Research: http://www.fluffycat.com/SQL/Cartesian-Joins/ Cartesian Join example two Q: You said you can have a Cartesian join by joining a table to itself. Show that! Select * From Film_Table T1, Film_Table T2;

  Read the article

• How to Calculate longest streak in SQL?

  - by VJ

  I have EMPLOYEE-ID,DATE,IsPresent I want to calculate longest streak for a employee presence.The Present bit will be false for days he didnt come..So I want to calculate the longest number of days he came to office for consecutive dates..I have the Date column field is unique...So I tried this way - Select Id,Count(*) from Employee where IsPresent=1 But the above doesnt work...Can anyone guide me towards how I can calculate streak for this?....I am sure people have come across this...I tried searching online but...didnt understand it well...please help me out..

  Read the article

• mysql : possible to put IF statment in LEFT JOIN ?

  - by Haroldo

  Ok so i want to get an artists info from the db, but i want to know if they have any forthcoming events. To do this i need to traverse 2 tables, where events_artists is a 2 col link table... (this doesnt work but is what id like to do) SELECT art.*, events.event_id FROM art LEFT JOIN events_artists ON art.art_id = events_artists.art_id LEFT JOIN events ON events_artists.event_id = events.event_id IF ( {criteria} ) what should i be doing here to get this to work?!!

  Read the article

• Blackberry - Programmatically extract/open zip file

  - by KKlucznik

  I have looked online with mixed results, but is there a way to programmatically extract a zip file on the BB? Very basic my app will display different encrypted file types, and those files are delivered in a zip file. My idea was to have the user browse to the file on their SDCard, select it, and I extract what i need as a stream from the file. is this possible?

  Read the article

• Setting custom SQL in django admin

  - by eugene y

  I'm trying to set up a proxy model in django admin. It will represent a subset of the original model. The code from models.py: class MyManager(models.Manager): def get_query_set(self): return super(MyManager, self).get_query_set().filter(some_column='value') class MyModel(OrigModel): objects = MyManager() class Meta: proxy = True Now instead of filter() I need to use a complex SELECT statement with JOINS. What's the proper way to inject it wholly to the custom manager?

  Read the article

• Table is realigned after setting the display property to 'block'

  - by Holicreature

  I'm having a table and i have a row which is initially set to the display property of 'none' and i changing it to 'block' at some selection of value from my select box , at that point of time the row is not aligned properly. My two columns are set inside a single column of the above row? but when i change it again to 'none' all the other rows are aligned correctly..

  Read the article

• how to change color of table view title

  - by madhavi

  hello, Can we change the color of the table view title the string which i am showing appears in gray color can we choose color for it .Is there any property of table view title i am not asking for table view header or footer i mean the title - (NSString *)tableView:(UITableView *)tableView titleForHeaderInSection:(NSInteger)section { // Keep space in the following line ........ DONT REMOVE return [NSString stringWithFormat:@"Select your service:"]; }

  Read the article

• pgSQL query error

  - by running4surival

  i tried using this query: "SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;" and I'm getting this error: ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function can anyone explain how i can work around this?

  Read the article

• MySQL full text search, why am I getting Incorrect arguments to MATCH

  - by vick

  SELECT * FROM company c INNER JOIN city ci ON ci.city_id = c.city_id INNER JOIN state s ON s.state_id = c.state_id WHERE MATCH ( c.name, ci.name, c.zipcode, s.name ) AGAINST ( 'los angeles' )

  Read the article

• What is wrong with this javascript?

  - by bala3569

  i use this javascript syntax for validating a checkbox... alert(document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").checked); if (document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").checked == false) { document.getElementById("ctl00_ContentPlaceHolder1_ErrorMsg").innerHTML = "please select the checkbox"; document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").focus(); return false; } My alert showed me false but my if loop is not working... Any suggestion...

  Read the article

• Sharepoint - how to set permission level to add item but not view?

  - by Stuart

  I want to allow a certain group of users to add items to a list, but not be able to view all items. This is so I can set up a workflow with certain parts of it private. I thought it'd be possible by defining a new permission level in: http://servername/_layouts/addrole.aspx ('Add a permission level' page) However, when you select the "add items" list permission, "view items" is automatically ticked also. Anyone know a solution to this?

  Read the article

• Update one list from another

  - by lacqui

  I have two multi-select lists in HTML - one of categories, and another of items. What I want is that, when an item selected in the "category" list, everything in the "items" list from that category is also selected. For example, if "Categories" contains "Animal", "Mineral", and "Vegetable", and "Items" contains "Dog", "Cat", "Monkey", "Diamond", "Granite", "Carrot", "Tomato": If "Animal" is selected in one list, "Dog", "Cat", and "Monkey" should be selected; any other selections should remain as they are. I'm using a Symfony PHP backend on the server, if that makes any difference

  Read the article

• round a number in SQL

  - by LIX

  I have a number and I use ROUND() function in SQL : SELECT ROUND(1.81999,2,1) I want the result 1.82, not 1.81. I don't know where my mistake is.

  Read the article

• How to handle with multiple selection ListBox? asp.net c#

  - by Ayyappan.Anbalagan

  In my aspx registration page i have more then 6 item available in my list box, I am allowing multiple selection on it..I am not sure about how many items i will select each and every time. then how i have to store it into dataset and how to pass it as a mysql paramter...

  Read the article

• Any way to make this PostgreSQL count query any faster?

  - by Ben Dauphinee

  I'm running a case-insensitive search on a table with 7.2 million rows, and I was wondering if there was any way to make this query any faster? Currently, it takes approx 11.6 seconds to execute, with just one search parameter, and I'm worried that as soon as I add more than one, this query will become massively slow. SELECT count(*) FROM "exif_parse" WHERE (description ~* 'canon')

  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

• concatenate arbitrary long list of matches in SQL subquery

  - by lordvlad

  imagine 2 tables (rather stupid example, but for the sake of simplicity, here you go) words word_id letters letter word_id how can i select all words while selecting all letters that belong to a word and concatenating them to said word? it is important that the letters are returned in the order they appear in the table, as the letter may be mixed into other words, but the order is correct. |word_id| |word_id|letter| +-------+ +-------+------+ | 1| | 1| H| | 2| | 2| B| | 2| Y| | 1| I| | 2| E| should return |word_id|word| +-------+----+ | 1| HI| | 2| BYE| any way to accomplish this in pure SQL?

  Read the article

• Selecting events from SQL Profiler in 2005 for profiling a query

  - by user279521

  Hi, I need to profile a large SQL query (in a particular database, not the whole server), and I cant figure out how to setup the profiler. I tried reading MSDN SQL web site, but it has not helped. I am stuck at the Trace Properties "Events Selection" window. I need help as to which items to select in "Events Selection" window. Thanks

  Read the article

• Excel c# convert cell to percentage

  - by rubentjeuh

  Hello. I need to convert a cell with a double to a precentage. I used a macro in excel and it says: Range("B5").Select Selection.Style = "Percent" When I do this in c#, it doesn't work: Excel.Range procentRange = xlWorksheet.get_Range("A1","A1"); procentRange.Style = "Percent"; Anybody knows how to do this?

  Read the article

< Previous Page | 522 523 524 525 526 527 528 529 530 531 532 533  | Next Page >