Search Results

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

Page 504/943 | < Previous Page | 500 501 502 503 504 505 506 507 508 509 510 511  | Next Page >

• exploratory SPARQL queries?

  - by significance

  whenever i start using sql i tend to throw a couple of exploratory statements at the database in order to understand what is avaliable, and what form the data takes. eg. show tables describe table select * from table could anyone help me understand the way to complete a similar exploration of an rdf datastore using a SPARQL endpoint? Thanks :)

  Read the article

• diff between two days, in hours

  - by Cristian Boariu

  Hi, I do not uderstand why the result of: (DateTime.Now.Subtract(user.created_time.Value.Date)).Hours is 23. where: DateTime.Now is:{3/30/2010 12:00:00 AM} and user.created_time.Value.Date is : {3/24/2010 12:00:00 AM} Does it make sense for anybody? ps: I want to select all users created in last 72 hours so i suppose that is the way i should do...

  Read the article

• I want to display the missing (non-matching) records

  - by Eric

  Is there a way to program the following SQL query SELECT dbo.Assets_Master.Serial_Number, dbo.Assets_Master.Account_Ident, dbo.Assets_Master.Disposition_Ident FROM dbo.Assets_Master LEFT OUTER JOIN dbo.Assets ON dbo.Assets_Master.Serial_Number = dbo.Assets.Serial_Number WHERE (dbo.Assets.Serial_Number IS NULL) in c# .net code using dataviews or data relation or something else? I have a spreadsheet of about 4k rows and a data table that should have the same records but if not I want to display the missing (non-matching) records from the table. Thanks, Eric

  Read the article

• VB.NET Use With keyword on existing object?

  - by ropstah

  Is it somehow possible to use the 'With' keyword on an existing object? I would like to do the following using LINQ to objects and can't seem to find a way: From m as Product in Me _ Select m With {.Match = m.Name.IndexOf(query)} _ Where m.Name.IndexOf(query) > 0

  Read the article

• jquery element filter by css

  - by salmane

  I would like to select every div that has a red background color for example. is this possible in jquery? <div style="background-color:red"></div> <div style="background-color:white"></div> <div style="background-color:red"></div> <div style="background-color:yellow"></div> thank you

  Read the article

• mysql IF EXISTS

  - by cosy

  What is wrong with this ? mysql_query("IF EXISTS(SELECT * FROM y where 1=1 ) THEN do something ELSE do something END IF"); Thanks!

  Read the article

• rails checkbox has_many is hunted

  - by sebajb

  check_box is hunted in rails; but I would like to select some objects and save the relationship to the database anyways. When I debug the code all I see is the value='on' instead of the value I want to save. Any Help or tutorial would be appreciated.

  Read the article

• SQL function to get count of how many times string appears in column?

  - by Kristopher Ives

  Is there a function for MySQL that will count the number of times a string occurs in another string or column? Basically I want: SELECT SUB_COUNT('my word', `my_column`) AS `match_count` FROM `table` Thanks!

  Read the article

• linq to entites left outer join

  - by parminder

  I am struggling linq to entities left outer join. I have two entities (tables): Listings { ListingID, MakeID (nullable) } Makes { MakeID, Description } I want to write something like this in LINQ: select listings.listingID ,listings.makeid , IsNull(makes.Description, 'NA') from listings left outer join makes on listings.makeid = makes.makeid

  Read the article

• How to write a contains statement to match a member of a class?

  - by afuzzyllama

  If I have the following structure: Public Class UserData Public ID As String Public Name As String End Class How can I select it in a conditional like this? Dim myUsers As New List(Of UserData) If myUsers.Contains(.ID = "1") = True Then ... I know that myUsers.Contains(.ID = "1") is totally wrong, but I am curious how to do something like that? Is it possible? Is this a job for LINQ?

  Read the article

• mysql query optimization

  - by vamsivanka

  I would need some help on how to optimize the query. select * from transaction where id < 7500001 order by id desc limit 16 when i do an explain plan on this - the type is "range" and rows is "7500000" According to the some online reference's this is explained as, it took the query 7,500,000 rows to scan and get the data. Is there any way i can optimize so it uses less rows to scan and get the data. Also, id is the primary key column.

  Read the article

• How do you change an HTML radiobutton selection from Javascript?

  - by Giffyguy

  I need to select an HTML radiobutton (deselecting any previously selected radiobutton) on my form, from within Javascript. How is this accomplished?

  Read the article

• Creating a MySQL view with an auto-incrementing id column

  - by hmemcpy

  I have a MySQL database from which a view is created. Is is possible to add an auto-incrementing id for each row in the view? I tried CREATE ALGORITHM=UNDEFINED DEFINER=`database_name`@`%` SQL SECURITY DEFINER VIEW `MyView` AS set @i = 0; select @i:=@i+1 as `id` ... but that doesn't work in a View. Sorry, my SQL is weak, any help is appreciated.

  Read the article

• Bizarre Escape Character Question

  - by William Calleja

  I have the following c# code embedded in a literal <% %> of a c# asp.net page string commandString = "SELECT tblData.Content " + "FROM tblData " + "WHERE (tblData.ref = N\'%"+myCurrentREF+"%\')"; This is breaking my code since it apparently cannot use the \' escape character. Why is it so? other escape characters like \" are working so why isn't \' working?

  Read the article

• t-sql get variable value from string with variable name

  - by Markus

  Hi. Is there a way to convert '@my_variable' string into a value of @my_variable? I have a table which stores names of variables. I need to get the value of this variable. Something like this: DECLARE @second_variable AS NVARCHAR(20); DECLARE @first_variable AS NVARCHAR(20); SET @first_variable = '20'; SET @second_variable = SELECT '@first_variable'; --here I want that @second variable be assigned a value of "20".

  Read the article

• jQuery drawing and modifying lines and positions

  - by Chris

  I want to allow people to select a feature region on an image using jQuery. This should work similarly to the Facebook tagger except once someone "tags" an area of the image an ellipse should appear with the ability for the user to rotate and scale it. How can I achieve this using jQuery?

  Read the article

• How to find the worst performing queries in MS SQL Server 2008?

  - by Thomas Bratt

  How to find the worst performing queries in MS SQL Server 2008? I found the following example but it does not seem to work: SELECT TOP 5 obj.name, max_logical_reads, max_elapsed_time FROM sys.dm_exec_query_stats a CROSS APPLY sys.dm_exec_sql_text(sql_handle) hnd INNER JOIN sys.sysobjects obj on hnd.objectid = obj.id ORDER BY max_logical_reads DESC Taken from: http://www.sqlservercurry.com/2010/03/top-5-costly-stored-procedures-in-sql.html

  Read the article

• How To Upload a file on the click of an image button

  - by Jibu P C_Adoor

  Hii, I have an 'Attach image button' in my web page, I don't want see the the file upload control in my page. On the click of the 'Attach image button' it will directly shows the browser's directory window and select the file from that and can directly uploads to the server. Does any body knows how it is possible

  Read the article

• sql - get the latest date of two columns

  - by stacker

  table1 - date1 datetime not null - date2 nvarchar null I want to get the latest date of this two. select date1, date2, (CASE WHEN date1 > CAST(date2 as DateTime) THEN date1 ELSE date2 END) as DateTime) as LatestDate from table1 please note that date2 can be null. in this case, date1 win.

  Read the article

• Tootip steals mouse click

  - by deerchao

  I'm writing a custom TreeView from ScrollableControl. I decided to show tooltips when mouse is hover nodes with text too long to display. I find out when tooltips are shown, user would not be able to click the node to select it, because (I think) he's clicking the tooltip window, not my control. Is there any easy solutions? As I can see System.Windows.Forms.TreeView don't have this problem. Thanks!

  Read the article

• JSF SelectOneMenuItem onselect attribute

  - by William

  I have created selectOneMenuItem(JSF).I placed my events on valueChangeListener / onchange like that <h:selectOneMenu id="ddl" value="#{Foo.attr}" onchange="submit()" valueChangeListener="#{Foo.renderFoo}"> When I select one vlaue from selectOneMenuItem then event fires.Now when I reselect that value ,then event doesn't fire (because this is the valueChangeListener event) so it doesn't fire.I want that event should fire on every selection even on again the same selection.I found onselect but unable to find that is it right and how can i use this onselect.Anyu help would be greatly appreciable

  Read the article

• complex Subtract in sql server query

  - by AmRoSH

  Hello, I have table like following PK num1 num2 numsdiff 1 10 15 ? 2 20 25 ? 3 30 35 ? 4 40 45 ? i need to get Subtract of 20 - 15 and 30 - 25 and 40 - 35 and so on by select query from this table. any ideas?. thanks

  Read the article

• SQL AND operator not working properly

  - by Chandana De Silva

  I have following two tables LandParcels Table Blockid ParcelNo storPri ======= ======== ======= 52000105 3 State 52000105 4 Private 52000105 5 State Actions Table Blockid ParcelNo ActionTaken ======= ======== =========== 52000105 3 Received 52000105 3 Send to Computer 52000105 4 Received 52000105 5 Received I want to find the records Received but not Send to Computer Here is my query select l.blockid, l.parcelno from landparcels l left join actions ac on l.blockid = ac.blockid and l.parcelno = ac.parcelno where ac.actiontaken = 'Received' and ac.actiontaken <> 'Send to Computer' and ac.blockid = 52000105 The result is Blockid ParcelNo ======= ======== 52000105 3 52000105 4 52000105 5 I want ParcelNo 4 and 5

  Read the article

• Is it possible to use multiple languages in .NET resource files?

  - by Gabe Brown

  We’ve got an interesting requirement that we’ll want to support multiple languages at runtime since we’re a service. If a user talks to us using Japanese or English, we’ll want to respond in the appropriate language. FxCop likes us to store our strings in resource files, but I was curious to know if there was an integrated way to select resource string at runtime without having to do it manually. Bottom Line: We need to be able to support multiple languages in a single binary. :)

  Read the article

• sql query not executing

  - by sarah

  Hi, Not able to execute a query ,i need to check if end date is greater than today in the following query Getting an error invalid query select * from table1 where user in ('a') and END_DATE >'2010-05-22' getting an error liter string does not match

  Read the article

< Previous Page | 500 501 502 503 504 505 506 507 508 509 510 511  | Next Page >