Search Results

Search found 24958 results on 999 pages for 'select region'.

Page 545/999 | < Previous Page | 541 542 543 544 545 546 547 548 549 550 551 552  | Next Page >

• how to display specific dates in KCalander

  - by yakub_moriss

  hi ,All i want to use KCalander (which is Open Source on www.code.google.com) in my project but i want to allow select only one date from awailable dates (means every monday of limited time period/dates awailable for reservations) what am i want to display only that dates/day in KCalander. is that possible with the use of UIDatePicker controller. which one is easy sollution ? waiting for your reply... Thanks in advance... Yakub Moriss

  Read the article

• LINQ Group By to project into a non-anonymous type?

  - by vikp

  Hi, I have the following LINQ example: var colorDistribution = from product in ctx.Products group product by product.Color into productColors select new { Color = productColors.Key, Count = productColors.Count() }; All this works and makes perfect sense. What I'm trying to achieve is to group by into a strong type instead of anonymous type. For example I have a ProductColour class and I would like to Group into a List<ProductColour> Is this possible? Thank you

  Read the article

• TSQL, How to get smalldatetime's time between two smalldatetime's times ?

  - by eugeneK

  I have Table with two smalldatetime columns, where one is startTime and other one is endTime. I need to select all values from table which between times of both columns compared to getdate()' time. I'm using SQL-Server 2005. example startDate endDate value1 2/2/01 16:00 2/2/01 18:00 1 2/2/01 21:00 2/2/01 22:00 2 2/2/01 05:00 2/2/01 22:00 3 getdate() gives 2/2/2000 21:40 so i need to get value1 2 and 3 thanks in advance

  Read the article

• jQgrid In-Line Edit:-How to give specific edittype to particular jqgrid cell ?

  - by nigam kumar

  I am using In-Line Edit:I want to give different edit type to each cell in the same column rather than giving only one edittype to whole column.1st row's 2nd column should have edit type as select,2nd row's 2nd column should have edit type as textarea etc..

  Read the article

• How do I code a loop for my echo statements?

  - by ggg

  <?php defined('_JEXEC') or die('Restricted access'); $db =& JFactory::getDBO(); $query0 = "SELECT * FROM `#__chesspositions` WHERE . . . . ."; //echo $query0; $db->setQuery($query0); $ginfo = $db->loadObjectList(); //echo $ginfo[0]; echo $db->getErrorMsg(); if(empty($ginfo)){ echo "<center><h2 style='color:navy'>No game found, we apologize</h2></center>"; }else{ $query1= "SELECT * FROM `#__chessmoves` WHERE Id='".$ginfo[0]->MoveDataId."'"; $db->setQuery($query1); echo $db->getErrorMsg(); $gmove = $db->loadObjectList(); } //define array; //how do I code a foreach loop (or any other type of loop) here? //I'm having trouble properly defining the array and structuring the syntax. echo "[Event \"".$ginfo[0]->Event."\"]\n"; echo "[Site \"".$ginfo[0]->Site."\"]\n"; echo "[Date \"".$ginfo[0]->Date."\"]\n"; echo "[Round \"".$ginfo[0]->Round."\"]\n"; echo "[White \"".$ginfo[0]->White."\"]\n"; echo "[Black \"".$ginfo[0]->Black."\"]\n"; echo "[Result \"".$ginfo[0]->Result."\"]\n"; echo "[ECO \"".$ginfo[0]->ECO."\"]\n"; echo "[WhiteElo \"".$ginfo[0]->WhiteElo."\"]\n"; echo "[BlackElo \"".$ginfo[0]->BlackElo."\"]\n"; echo "[Annotator \"".$ginfo[0]->Annotator."\"]\n"; echo "[SetUp \"".$ginfo[0]->SetUp."\"]\n"; echo $gmove[0]->MoveData; ?>

  Read the article

• how to remove repeated record's from results linq to sql

  - by Sadegh

  hi, i want to remove repeated record's from results but distinct don't do this for me! why??? var results = (from words in _Xplorium.Words join wordFiles in _Xplorium.WordFiles on words.WordId equals wordFiles.WordId join files in _Xplorium.Files on wordFiles.FileId equals files.FileId join urls in _Xplorium.Urls on files.UrlId equals urls.UrlId where files.Title.Contains(query) || files.Description.Contains(query) orderby wordFiles.Count descending select new SearchResultItem() { Title = files.Title, Url = urls.Address, Count = wordFiles.Count, CrawledOn = files.CrawledOn, Description = files.Description, Lenght = files.Lenght, UniqueKey = words.WordId + "-" + files.FileId + "-" + urls.UrlId }).Distinct();

  Read the article

• MySQL: Is it possible to compute MAX( AVG (field) )?

  - by Brad

  My current query reads: SELECT entry_id, user_id, cat_id, AVG( rating ) as avg_rate FROM entry_rate WHERE 1 GROUP BY entry_id cat_id relates to different categories: 1, 2, 3 or 4 Is there a way I can find the maximum average for each user in each category without setting up an additional table? The return could potentially be 4 maximum avg_rate for each user_id Visit the link below for example: http://lh5.ggpht.com/_rvDQuhTddnc/S8Os_77qR9I/AAAAAAAAA2M/IPmzNeYjfCA/s800/table1.jpg

  Read the article

• SQL Server Query Question

  - by Lp1

  Running SQL Server 2008, and I am definitely a new SQL user. I have a table that has 4 columns: EmpNum, User, Action, Updatetime A user logs into, and out of a system, it is registered in the database. For example, if user1 logs into the system, then out 5 minutes later, a simple query (select * from update) would look like: EmpNum User Action Updatetime 1 User1 I 2010-01-01 23:00:00:000 1 User1 O 2010-01-01 23:05:00:000 I'm trying to query the Empnum, User, Action, I(in time), O(out time), and the total time.

  Read the article

• Difference between Facebook query from iphone and from web

  - by Aashutosh

  Hi, I am creating a iphone application for the existing web application. The fql which is happening at the web is giving me right results but the fql happening at the iphone is not giving all the results. select name, pic_square, pic_big, uid, sex, birthday, relationship_status , current_location, meeting_sex, interests, music, tv, movies, books, quotes, education_history, work_history from user where uid = XXXXXXX is giving me different result in web when compared to the iphone. Thanks, Aashutosh

  Read the article

• Linq, how to specify timestamp condition?

  - by 5YrsLaterDBA

  I have a logins table which records all login and logout activities. I want to look at all login activities of a particular user within 24 hrs. how to do it? something like this: var records = from record in db.Logins where record.Users.UserId == userId && record.Timestamp <= (DateTime.Now + 24) select record; record.Timestamp <= (DateTime.Now + 24) is wrong here. I am using C# 3 + L2E.

  Read the article

• Sql server messed up degree symbol

  - by user228058

  Some of the degree sysmbols in my sql server database are displaying like this: 173-¦F. When I do a search for that - SELECT * FROM PRoduct WHERE description LIKE '%-¦%', it does not bring them up. How can I find (and replace) such characters?

  Read the article

• how to store a value returned from a sql query in a variable in batch programming ?

  - by Arunachalam

  how to store a value returned from a sql query in a variable in batch programming ? i can invoke sqlserver queries from my cmd prompt using sqlcmd server name then the qwery this is query statement i m going to use SELECT CASE WHEN DATEDIFF(minute, record_timestamp, GETDATE()) < 10 THEN 1 ELSE 0 END how to store the value returned i tried using set variablename but it save the statement rather than the return value .. and if i save this in a variable what type of variable it will can i compare it with numeric values in if condition

  Read the article

• Splitting tables by field to optimize MySQL?

  - by AK

  Do splitting fields into multiple tables ever yield faster queries? Consider the following two scenarios: Table1 ----------- int PersonID text Value1 float Value2 or Table1 ----------- int PersonID text Value1 Table2 ----------- int PersonID float Value2 If Value1 and Value2 are always being displayed together, I imagine Table1 is always faster because the second schema would require two SELECT statements. But are there any situations where you would choose the second? If the number of records were expected to be really large?

  Read the article

• Can a sql server aggregate udf be passed in multiple parameters?

  - by Burg

  I am trying to write an aggregate udf for using Sql Server 2008 and C# 3.5 that implodes an aggregation of data. The kind of syntax I am looking for is: SELECT [dbo].[Implode]([Id], ',') FROM [dbo].[Table] GROUP BY [ForeignID] where the second parameter is the delimiter for the aggregate function. And example return value would be something like: 1,4,56 Is there a way to have multiple parameters in an aggregate udf?

  Read the article

• limit by taxonomy in view

  - by bratna

  I use view to show node and i set filters to taxonomy:vocabulary (select 3 taxonomy). I want set limit by vocabulary (1 vocabulary show 3 node). Anyone know how to do this? Please help me. Thanks

  Read the article

• why do I have to commit explicitly when doing an UPDATE

  - by Tshepang

  Here's my code: import cx_Oracle conn = cx_Oracle.connect(usr, pwd, url) cursor = conn.cursor() cursor.execute("UPDATE SO SET STATUS='PE' WHERE ID='100'") conn.commit() If I remove the conn.commit(), the table isn't updated. But for select statements, I don't need that conn.commit(). I'm curious why?

  Read the article

• Where to put the application ID in YQL

  - by earlyriser

  I'm trying to read an xml response from YQL: $url = 'http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20geo.places%20where%20woeid%3D%22'.$woeid.'%22'; if (!$xml=simplexml_load_file($url) ) { //DO STUFF } This code works. Now i'm trying to put my application ID in the url string but I don't know how it should be done. Thanks.

  Read the article

• How can I use Generics to create a way of making an IEnumerable from an enum?

  - by Samantha J

  Given an enum like this: public enum City { London = 1, Liverpool = 20, Leeds = 25 } public enum House { OneFloor = 1, TwoFloors = 2 } I am using the following code to give me an IEnumerable: City[] values = (City[])Enum.GetValues(typeof(City)); var valuesWithNames = from value in values select new { value = (int)value, name = value.ToString() }; The code works very good however I have to do this for quite a lot of enums. Is there a way I could create a generic way of doing this?

  Read the article

• How to search multiple columns in MySQL?

  - by George

  I'm trying to make a search feature that will search multiple columns to find a keyword based match. This query: SELECT title FROM pages LIKE %$query%; works only for searching one column, I noticed separating column names with commas results in an error. So is it possible to search multiple columns in mysql?

  Read the article

• selecting data from table based on date .

  - by mehdi

  i have database table like this +-------+--------------+----------+ | id | ip | date | +-------+--------------+----------+ | 505 |192.168.100.1 |2010-04-03| | 252 |192.168.100.5 |2010-03-03| | 426 |192.168.100.6 |2010-03-03| | 201 |192.168.100.7 |2010-04-03| | 211 |192.168.100.10|2010-04-03| +-------+--------------+----------+ how can i retirive data from this table where month=03 how to write sql to do that . select * from table where month=03 something like that .

  Read the article

• Correct Sql Script for Formula

  - by Madan Madan

  Can anyone help me write SQL script for the following formula? If DEP = 1 If DROP 1 PLV = 334.86 * exp(0.3541 * ACTIVE_DAYS) + 0.25 * DROP + 20 * DEP Else If DROP < 0 PLV = DROP + 70 * ACTIVE_DAYS Else PLV = 0.25 * DROP + 70 * ACTIVE_DAYS The SQL script which I have is the following SELECT IF(dep=1, if(dep=1, (334.86 * exp(0.3541 * act_days)) + (0.25 * 'drop') + (20 * dep), if('drop'<0, 'drop' + (70 * act_days), (0.25 * 'drop') + (70 * act_days))),'0') as PLV But the above query is not right as something is missing where the formula says Else PLV = 0.26 * DROP Thanks,

  Read the article

• cakePHP and GROUP BY

  - by Lizard

  I am trying to solve a hopefully simple problem here is the query I am trying produce: SELECT `categories`.*, COUNT(`entities`.id) FROM `categories` LEFT JOIN `entities` ON (`categories`.`id` = `entities`.`category_id`) GROUP BY `categories`.`id` I am really struggling to do this is in cakePHP 1.2 How would/should I go about doing this... (I am using 'Containable' if that helps) Thanks in advance

  Read the article

• Qt: How can I access the actual widgets on a page in WebKit?

  - by Jen

  Is there a way to access the widgets generated by INPUT and SELECT on a page in WebKit, using Qt? On a related note, does WebKit provide these widgets, or does it delegate back to Qt to generate them?

  Read the article

• how to go back to previous screen in tableview?

  - by Rajendra Bhole

  Hi, My appliaction is viewbased application in which i have one button . On click of that button i will push to other screen that is table view screen on which what i want when i select any data from row in table view it will get back to previous view automatically instead of selecting the navigation back button generated automatically. Please help me out its urgent . Thanks in Advance

  Read the article

• Group Specific set of data by Day

  - by Jacques444

  Need to get a certian subgroup of data per day (Seperated by weekday) For example Select weekday,bla,blabla,blablabla from dbo.blabla where bla = @StartDate and bla <=@endDate I need the output to be: Monday bla blabla blablabla Tuesday bla blabla blablabla If someone could help me that would be awesome. Thanks & Regards Jacques

  Read the article

< Previous Page | 541 542 543 544 545 546 547 548 549 550 551 552  | Next Page >