Search Results

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

Page 496/943 | < Previous Page | 492 493 494 495 496 497 498 499 500 501 502 503  | Next Page >

• LINQ VB.NET variable not found when looping through grouped query

  - by Ed Sneller

  I'm trying to do the following LINQ grouping, which works in the debugger (the results are populated in the GroupedOrders object. But VS 2008 gives me the following error at design time... Name 'x' is not declared Dim GroupedOrders = (From m In thisConsultant.orders _ Group m By Key = m.commCode Into Group _ Select commCode = Key, orders = Group) For Each x In GroupedOrders Next VS 2008 gives me the following error,

  Read the article

• Need help how to call c# function which return type is array in jquery

  - by Manoj Wadhwani

  $('#calendar').fullCalendar ( { editable: true, events: $.ajax ( { type: "POST", url: "Calender.aspx/GetCDCatalog", contentType: "application/json; charset=utf-8", data: "{}", dataType: "json" } ) } ) calender.aspx is page and getcddialog is function which return type is array which doest not bind calender. public CD[] GetCDCatalog() { XDocument docXML = XDocument.Load(Server.MapPath("mydata.xml")); var CDs = from cd in docXML.Descendants("Table") select new CD { title = cd.Element("title").Value, star = cd.Element("star").Value, endTime = cd.Element("endTime").Value, }; return CDs.ToArray<CD>(); }

  Read the article

• How do you create a transaction that spans multiple statements in Python with MySQLdb?

  - by Fast Fish

  I know that with an InnoDB table, transactions are autocommit, however I understand that to mean for a single statement? For example, I want to check if a user exists in a table, and then if it doesn't, create it. However there lies a race condition. I believe using a transaction prior to doing the select, will ensure that the table remains untouched until the subsequent insert, and the transaction is committed. How can you do this with MySQLdb and Python?

  Read the article

• Multiple File Selection For Uploading in ASP.NET

  - by IrfanRaza

  Hi Friends, There are several resources available on net to upload multiple files, but using multiple FileUpload controls. What I need to have multiple file selection dialog box so that user can select multiple files at one shot and then all files should be uploaded on one click. Anyone of you have any idea? Thanks in advance.

  Read the article

• Simple 3D Editor/Viewer

  - by mnn

  I'm looking for an application, which could be able to load bunch of points in space, render them and be able to simple 3D operations (select such point, rotate & move viewport). The source has to be available, as I want to use it as basis for my own application.

  Read the article

• In SQL Server, how to move/import a multiple .trc files to a trace table

  - by frankadelic

  I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc I can import the first one using this command: use [my-database] SELECT * INTO trace_folder FROM::fn_trace_gettable('C:\mytrace.trc', 4) However, this only appears to load the first file, not all four.

  Read the article

• How to search a MySQL database for a specific string

  - by Nadia

  I am trying to set up a search feature on my site that will only return exact matches to keyword entered by the user. So if the user searches "dog" I don't want an article titled "Doggy Style" to appear in the search results (just an example I don't really have an article by that name). This of course does exactly that: SELECT * FROM articles WHERE article_title LIKE '%$searchQuery%' $searchQuery here is a PHP variable taken from the user's input form. So is there any way to return only exact matches?

  Read the article

• Copying an sqlite database from file to :memory using C#

  - by davidb

  I have a small database with tables containing a small amount of data which I need to copy into memory. Currently I am using: insertcommand.CommandText = "SELECT sql FROM sqlite_master WHERE sql NOT NULL;"; To pull all the table schema from the file database, however I'm not really sure how to proceed with creating these tables in the new memory database, and copying all the relevant data across. In short, how do I copy an SQLite database from file to memory using C# and System.Data.SQLite?

  Read the article

• SQL column length query

  - by Mike

  i've been using the following query: select LEN(columnname) as columnmame from dbo.amu_datastaging This works, but is there a way to only return the greatest value instead of all the values? So if i return 1million records and the longest length is 400, the query would just return the value of 400?

  Read the article

• Search in static pages

  - by Shyju

  I have an ASP web application which has pages with static content as well as dynamic content(data from database). I want to implement a search feature in the site.I Can do this with the dynamic data easily by framing the select query based on the search keys and pull data from the tables,But i would like to know how can i implement the search with the static pages ?

  Read the article

• asp:upload postedfile lost during postback

  - by Neil

  I am using an asp:upload control to upload an image and am using the postedfile property to insert the path to the database. In my form I have a dropdown with autopostback=true where the user can select a topic to populate a checkbox list of categories. During that postback, the postedfile value is being lost and after a little research I have discovered that the posted file value is not maintained in viewstate for security reasons. Has anybody else found out how to get around this?

  Read the article

• Acessing Datagridview

  - by Shiny

  One of my form has dropdownlist.when i select the item.textbox holds the value of 2.0. that has to be applied to my datagridview in cell content 11.with other records that will be pulled from access database. but cell content 11 wil have data when other records are pulled. how can i achieve this? thanks in advance

  Read the article

• LINQ statement as if condition

  - by dotnetdev

  I saw a piece of code which was written like this: if (from n in numbers select n where n = 5) However, I tried writing something like this but came across errors (bare in mind the code sample may not be exactly as above as I am typing from memory). How can I write code like the above? Thanks

  Read the article

• MySQL count elements in a database based on how many unique values there are in a field.

  - by 0plus1

  (Sorry for the title, I don't really know how to phrase that :-) ) I have a table that has a date and a uid fields. I need to get the number of uid for each date, currently I'm doing it in php running multiple queries like this one: SELECT COUNT(uid) FROM users where Date = 'xxx'; Is there a simple way to achieve this with only an sql query?

  Read the article

• Date and time Query - problem

  - by Gold

  hi i try to run this query: select * from WorkTbl where ((Tdate = '20100414' AND Ttime = '06:00') and (Tdate <= '20100415' AND Ttime <= '06:00')) i have this date: 14/04/2010 and time: 14:00 i cant see hem, how to fix the query ? thank's in advance

  Read the article

• Delphi: Multiple tokens edit component

  - by Dorin

  Hello, I'm looking for an enchanced edit component that allow users to input multiple tokens (items) manually separated by some symbol, or to select them from another source. It's something like "TO" field in outlook or facebook that allow you to input multiple recipients. Can anyone suggest any solution? Thanks in advice!

  Read the article

• Filter sharepoint content

  - by carl

  Hi Everybody, I need to filter the content in all the pages according to user selections. there should be one control to select different parameters like country, branch and location. page content should change according to user selected values throughout site even user navigate to other pages or subsites. When user closes his/her browser and comes back he/she has to see the content according to most recent selections. Thanks in advance.

  Read the article

• Retrieving top 50 rows from Table using LINQ

  - by James

  Hey, Am new to LINQ, and am trying to retrieve the top 50 rows of a particular table. In SQL Server using an actual query i coudl say "Select TOP 50 from Transactions" , but not sure how i need to do that with LinQ Any pointers that could help ? Thanks !

  Read the article

• SQL Query to get Count within a Stored Proc

  - by sia

  So i need to figure out how i can get a record count value and use that count as a new value to insert into a table. Ex: In My Stored Procedure @Count int What im looking for @Count to equal "select top (1) _fieldName from _someTable order by _fieldName Desc" Finally insert into _newTable (_fieldName) values (@Count) End I dont have to use a variable, just trying to demonstrate what im really trying to do. My SQL knowledge is pretty limited so no laughing, or smirking! ;)

  Read the article

• cant get ordering mysql results by current date ASC to work

  - by Patrick

  Im trying to order results ASCENDING from the current date this is what im using now; SELECT * FROM friends JOIN bdays ON bdays.user = friends.friendname WHERE username = $userid ORDER BY DATE_FORMAT(date, '%m %d') any ideas?

  Read the article

• A solution for the slow diff in (Tortoise)SVN?

  - by Michal Czardybon

  I often do code review in the following way: Open the SVN log Select a revision Double click on a file... ...and wait See the changes Goto 2 or 3 or finish The 4th step is very annoying. Do you know a solution for this?

  Read the article

• Having a number in

  - by Wiika

  Can someone give me a query that will return as a result rows ID 1 & 3? ID Name Hidden 1 Mika 1,4,2 2 Loca 0 3 Nosta 4 4 Like 2 Something like this SELECT * FROM table WHERE Hidden HAVING(4)

  Read the article

• How do you use jQuery filter() on an attribute that is not a class or id

  - by Ankur

  I want to filter based on an attribute called "level". Where I have written -- something here -- I don't know what to do to reference the level attribute. If it was an id attribute I would do #idName if it was a class I would do .className. I am not sure what to do to select the level attribute. $(".myClass").filter(--something here to reference the level attribute --).remove();

  Read the article

• Nhibernate - Getting Exception when run a simple join query

  - by Muhammad Akhtar

  hi, I am getting issue when I run sql Query having inner join, here is what I am doing very simple ISession session = NHibernateHelper.GetCurrentSession(); string query = string.Format("select Documents.TypeId from Documents inner join DocumentTrackingItems on Documents.Id = DocumentTrackingItems.DocumentId WHERE DocumentTrackingItems.ItemStepId = {0} order by Documents.TypeId asc", 13); System.Collections.ArrayList document = (System.Collections.ArrayList)session.CreateSQLQuery(query, "document", typeof(Document)).List(); I am getting this exception Exception Details: System.IndexOutOfRangeException: Id what's wrong in my query? --- thanks

  Read the article

• how to run Make table query that i have in access in C# code ?

  - by Gold

  hi i have query (DO2) in access that makes a table and inserting any data. how to run this query in C# code ? i try this: SQL = "Select * from DO2"; Cmd = new OleDbCommand(SQL, Conn); Cmd.ExecuteNonQuery(); Cmd.Dispose(); but i get error

  Read the article

< Previous Page | 492 493 494 495 496 497 498 499 500 501 502 503  | Next Page >