Search Results

Search found 17593 results on 704 pages for 'wmi query'.

Page 491/704 | < Previous Page | 487 488 489 490 491 492 493 494 495 496 497 498  | Next Page >

• Adding A New Row Using SQL Server Management Studio

  - by Soo

  I'm learning how to use SQL Server Management Studio and can't figure out how to insert a new row into a table. Table Structure: ID, Field1, Field2 Query: INSERT INTO Table (Field1,Field2) VALUES(1,2) Error: Major Error 0x80040E14, Minor Error 25503 I'm probably missing something very noobie like. Any help would be appreciated.

  Read the article

• Crystal Report and LINQ

  - by user356760

  hi I am using crystal report for get a report . I have two table , table1 and table2. Primary key of table2 is foreign key of table1, I set some field in my report file to show the data of table1 and I want to show a specefic field of table2 insted of a field that is foreign key of table1, What is the query of LINQ for this problem?

  Read the article

• Count days within a month from date range

  - by G. Muqtada

  I have three date ranges in mysql table as follow from 2013-09-29 to 2013-10-02 from 2013-10-14 to 2013-10-16 from 2013-10-28 to 2013-11-05 I want to count only days that occur in Month of October, for example from first range (2013-09-29 to 2013-10-02) I should get difference of two days (1st and 2nd October) , and it should ignore days from September month, Finally i want to count total days in a given month from above date ranges. Can it be done from direct mysql query. or any short PHP logic.

  Read the article

• About presenter pattern in rails. is a better way to do it?

  - by Totty

  I have in my model: def presenter @presenter ||= ProfilePresenter.new(self) @presenter end The ProfilePresenter is a class that has methods like, get_link(), get_img_url(size), get_sex(), get_relationship_status() and other methods that have not to do with the model, not even with the controller but is used multiple times in the view. So now i use them by doing this: Profile.presenter.get_link # or Profile.presenter.get_img_url('thumb') # returns the path of the image. is not used to make a db query

  Read the article

• SELECT GROUP BY latest entry in INBOX msg sent by user

  - by Mohatir S

  i am building a simple PM for my personal website where a user can join and send message to the registered users on my website, i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page my table : id msg_from msg_to msg date in_del out_del i want to show latest user's id each in a group here is my SQL query : SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name FROM ttalk INNER JOIN users ON ttalk.msg_from = users.id WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0' GROUP BY ttalk.msg_from DESC LIMIT 500 Thanks in advance :-)

  Read the article

• Rails find all with association

  - by aaronrussell

  I have what I think is a very simple problem (famous last words)... I have a Category model that has_and_belongs_to_many Events. I want to construct a simple and efficient query that finds all categories that have 1 or more events. (using Rails 3) I'm sure I'm having a dumb moment here - any help appreciated :)

  Read the article

• What is LINQ? How can I use this with PHP?

  - by Ygam

  Language Integrated Query. Now I know that the acronyms are. I have seen C# examples, but can't really understand them. Can I use them with PHP? Can I use it along with ORM? Has any PHP MVC framework has this?

  Read the article

• c# update xml file

  - by Pila

  I want to replace a xml node that is not a child of the root element. how can I do it - not in .Net 3.5? I don't know the exact path to the node I want to replace, I get the node by XPath query like : XmlElement root = doc.DocumentElement; oldItem = root.SelectSingleNode("//Node1[@name='aaa']//Node2[Item='bbb']/Value"); how can I replace this olditem?

  Read the article

• Not allow a href tags in form textarea

  - by saquib

  Hello friends, How can i prevent user to enter any url or link in contact form text area, i have tried it with this but its not working - if (!isset($_POST['submit']) && preg_match_all('/<a.*>.*<\/a>/', $_POST['query'])) { echo "<h1 style='color:red;'>HTML Tag Not allowed </h1>"; } else { //sendmail } Please help me

  Read the article

• Left Join with Entity Framework

  - by sanfra1983

  hi, someone can tell me how to do this query in EF1: select a.idAnimali, a.titolo, a.commenti, a.ordine, a.idcatanimali, table1.nomefoto FROM tabanimali as a LEFT JOIN (SELECT idanimali, nomefoto tabfotoanimali FROM LIMIT 1) AS Table1 On a.idAnimali = table1.idanimali WHERE a.idcatanimali = idcatanimale Thanks

  Read the article

• Check checkbox checked property using jQuery

  - by Prasad

  I need to check the checked property of a checkbox and perform an action based on the checked property using jQuery. For example, if the age checkbox is checked, then I need to show a textbox to enter age, else hide the textbox. But the following code returns false by default: if($('#isAgeSelected').attr('checked')) { $("#txtAge").show(); } else { $("#txtAge").hide(); } How do I successfully query the checked property?

  Read the article

• mysql: Can I use two "where"s? Like, "SELECT * FROM table WHERE something and something"?

  - by KeriLynn

  I have a table with my products and I'm trying to write a page that would pull bracelets with certain colors from the database. So here's what I have right now (in php): $query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')"; But I only want to select rows where the value for the column "category" equals "bracelet". I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!

  Read the article

• How to display two QuerySets in one table?

  - by Mark

  I have two different QuerySets which both return a list of Users (with different fields). How can I display them both in one HTML table? One Query will always be a subset of the other; I just want to fill in the missing data with 0s. How can I do this?

  Read the article

• How to save a Stored Procedure ?

  - by Richard77

  Hello, I've been playing today with stored procedures. I'm stoned that I picked the basic of it up so easily. (I'll also try triggers very soon). Now, I'd like to know how to save my SPROC under the stored procedure folder (Programmability - Stored Procedure) so that I can access it by name (eventually from my C# application). So far, when I press the save icon, I'm proposed to save the whole query. That's not what I want. Thanks for helping

  Read the article

• difference between where and nested queries

  - by Chris H

  I'm not able to figure out the difference between these queries. I'm pretty sure that the first one is an equi-join. I'm not sure how the second one ISN'T the same as the first. The sub query in #2 selects all Ids from S, and then it returns all R's that also have those ID's, no? SELECT R.cname FROM R, S, WHERE R.Id = S.Id SELECT R.cname FROM R WHERE R.Id IN (SELECT S.Id FROM S)

  Read the article

• How to define a current user?

  - by ie

  Is it possible to define a current user? I found a stored procedure 'sp_mgGetConnectedUsers'. It returns a result set with the only unique field 'Address'. How could I associate an executing query with such 'Address'. Please advice. Note: As far as I understand, another way to get the current user is to set a unique application Id for each connection, but I don't like this way much.

  Read the article

• MYSQL UPDATE with IN and Subquery

  - by Johal

  Hi i have tables like this : table entry : id | total_comments ___________ 1 | 0 2 | 0 3 | 0 4 | 0 table comments : id | eid | comment ___________ 1 | 1 | comment sdfd 2 | 1 | testing testing 3 | 1 | comment text 4 | 2 | dummy comment 5 | 2 | sample comment 6 | 1 | fg fgh dfh Query i write : UPDATE entry SET total_comments = total_comments + 1 WHERE id IN ( SELECT eid FROM comments WHERE id IN (1,2,3,4,5,6)) Results i get is : table entry : id | total_comments ___________ 1 | 1 2 | 1 3 | 0 4 | 0 Expected results : table entry : id | total_comments ___________ 1 | 4 2 | 2 3 | 0 4 | 0 Any help will be appreciated.

  Read the article

• getting rows which including a value with mysql

  - by sundowatch

  I have a mysq query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

  Read the article

• Count # of links programmatically

  - by Duber

  You know how if you type links: "yourwebsite.com" into the normal google search box, it tells you the number of sites linking to you and their addresses. How can I do it programmatically with php? Does google provide an api that can I can programmatically query? What are my options?

  Read the article

• Is there any way to copy contents (text) of a pop up window from a web page,automatically in an Exce

  - by Aexcel

  There is a web page with products(description and prices).If someone wants more details has to click on a row in order to open a pop up window with more details about the certain product.Is there any way to automatically copy the contents of the pop up window into a cell next to the cells i get the data from my web query? the pop up window is like(....http://www.apage.com/product_info.asp?node_serial=&node_id=&ITEMID=0011262) thanks a lot in advance

  Read the article

• C# Reading a file and writing out replacing string

  - by Mike

  What I have is a C# windows app that reads a bunch of SQL tables and creates a bunch of queries based on the results. What I'm having a small issue with is the final "," on my query This is what I have ColumnX, from I need to read the entire file, write out exactly what is in the file and just replace the last , before the from with nothing. I tried .replace(@",\n\nfrom),(@"\n\nfrom) but it's not finding it. Any help is appreciated. Example: ColumnX, from Result: ColumnX from

  Read the article

• What's the best replacement for timeGetTime to avoid wrap-around?

  - by phjr

  timeGetTime seems to be quite good to query for system time. However, its return value is 32-bit only, so it wraps around every 49 days approx. It's not too hard to detect the rollover in calling code, but it adds some complexity, and (worse) requires keeping a state. Is there some replacement for timeGetTime that would not have this wrap-around problem (probably by returning a 64-bit value), and have roughly the same precision and cost?

  Read the article

• Hibernate (JPA) Entity with Static collection as a member

  - by Kyle Partridge

  Is it possible to have a static collection as a member of a hibernate entity? Say I have an object Question: public class Question { private String category; ... } Would it be possible to populate a static Set<String> that is a distinct set of all categories in the Database? I know I could just query this, but I was wondering if there was a more elegant solution, as it seems like something that other people may have come across.

  Read the article

• Finding Shared Columns in SQL Server

  - by smoore

  Is there a quick query I can run that returns all columns of the same name between two tables? I have many pairs of tables that I know are tied together, but I'm not sure which of the 50 or so columns they have in common.

  Read the article

• SQL Server - Missing Indexes - What would use the index?

  - by BankZ

  I am using SQL Server 2008 and we are using the DMV's to find missing indexes. However, before I create the new index I am trying to figure out what proc/query is wanting that index. I want the most information I can get so I can make informed decision on my indexes. Sometimes the indexes SQL Server wants does not make sense to me. Does anyone know how I can figure out what wants it?

  Read the article

< Previous Page | 487 488 489 490 491 492 493 494 495 496 497 498  | Next Page >