Search Results

Search found 19966 results on 799 pages for 'datetime query'.

Page 577/799 | < Previous Page | 573 574 575 576 577 578 579 580 581 582 583 584  | Next Page >

• Colored Data in 1 String in a gridview in asp.net?

  - by Kovu

  Hi, I have a resultgridview from a search query. In this gridview I have a name e.g. "aaaaaaaaaabbbbbbbbbbbbcccccccc" If the user serach "bbbbbbbbbbbbbb" I will select the "bbbbbbbbbbbbbb" in the string in the gridview in red and bold. how to do it?

  Read the article

• sql clarification

  - by JPro

  Can anyone please clarify what this query will return ? SELECT TestCase FROM MyTable WHERE Verdict = 'PASS' AND StartTime > DATE_SUB(NOW(), INTERVAL 2 MONTH)

  Read the article

• T-SQL - GROUP BY with LIKE - is this possible?

  - by fieldingmellish

  Is there a way to include a LIKE expression in a GROUP BY query? For example: SELECT Count(*) from tblWhatever GROUP BY column_x [LIKE %Fall-2009%] column_x: -------- BIOL-Fall_2009 HIST Fall_2009 BIOL Spring_2009 Result: ------ Fall_2009 2 Spring_2009 1

  Read the article

• How to list all installed ActiveX controls?

  - by sep

  I need to display a list of ActiveX controls for the user to choose. It needs to show the control name and description. How do I query Windows on the installed controls? Is there a way to differentiate controls from COM automation servers?

  Read the article

• Email Accounts Issue

  - by AliDeo

  Is there any way that i can access the email accounts that are saved in the default email client of android. Basically i want to access the inbox and display their mails without asking for username and password. Does AccountManager class thats available in android version 2 answer my query? and if yes then is there any alternative for v1.5 or v1.6.

  Read the article

• sql: how to use count for a particular column ,(or) to count a particular column by its field name

  - by Aravintha Bashyam

  in my query i need a to count a particular column by its field name, SELECT C.INC_COUNT, MIN_X, MIN_Y, MAX_X, MAX_Y, B.STATE_ABBR, B.STATE_NAME, B.LATITUDE, B.LONGITUDE, A.STATE, GEO_ID, concat(A.LSAD_TRANS,' ' , A.NAME) DIST_NAME, A.LSAD, GeometryType(SHAPE) GEO_TYPE, AsText(SHAPE) GEOM from SHAPE_LAYERS A join SHAPE_LAYER_STATE_DESC B on ( A.state = B.state) left outer join INC_DIST_SUMMARY_ALL C on (C.SHAPE_GEO_ID = A. GEO_ID) here i have to count by B.STATE_NAME ,C.INC_COUNT if exmple the field name nevada means i have to get all neveda value count and the C.INC_COUNT.

  Read the article

• Why cant i use the field user in SQL Server 8?

  - by acidzombie24

  Maybe not literally but the query below gets an error near user. If i change it to userZ it works. WHY can i not use that name? Is there a way to specific its a field instead of a keyword? (or whatever it is) create table Post2 ( id INTEGER PRIMARY KEY NOT NULL, title nvarchar(max) NOT NULL, body nvarchar(max) NOT NULL, user integer REFERENCES Post1(id));

  Read the article

• linq group by with count

  - by snorlaks

  Hello, Im trying to write query in linq Select UserId, UserNumber FROM User where UserNumber in (Select UserNumber FROM User group by UserNumber having Count(UserId) = 1) Aby hints ?

  Read the article

• Check Directories in C# using Linq

  - by pm_2

  Can someone tell me what I'm doing wrong with the following Linq query? I'm trying to find the directory with the highest aphanumerical value. DirectoryInfo[] diList = currentDirectory.GetDirectories(); var dirs = from eachDir in diList orderby eachDir.FullName descending select eachDir; MessageBox.Show(dirs[0].FullName);

  Read the article

• sqlite and visualstudio

  - by dban10

  How do I set an identity column for sqlite in visual studio? I am performing a new query and am trying to create a new table using script.

  Read the article

• Selecting all tables with no records

  - by sqlgrasshopper5

  I need to display all tables that have zero records. I tried, select * from user_all_tables where (select count(*) from user_all_tables)=0; But it doesn't seem to work. How should I go about redesigning this query? Thanks.

  Read the article

• case-insensitive search of MySQL?

  - by Haroldo

  case-insensitive search of MySQL? For my site search, what is the most efficient way of to query my db for a word/phrase regardless of case?

  Read the article

• Make a set from CSV values in TSQL

  - by rossfabricant

  If I want to see which values from an Excel spreadsheet column don't match values in a table, I can easily create a table with Bulk Import. Is there a simpler way? EG, I want to do a query like: select into #temp from ('a', 'b', 'c') as 'Id' select * from #temp where Id not in (select Id from MyTable)

  Read the article

• access forms: forcing UCASE in a textbox

  - by every_answer_gets_a_point

  i would like to force the textbox to immediately change the text to UCASE as soon as the user moves away from the field. is this possible? the important thing is that this text will be used in a SQL query to update a table.

  Read the article

• XML XQUERY Problem with NTEXT data type

  - by johnfa

  Hello I want to use XQuery on a column of data type NTEXT (I have no choice!). I have tried converting the column to XML using CONVERT but it gives the error: Incorrect syntax near the keyword 'CONVERT'. Here's the query SELECT y.item.value('@UserID', 'varchar(50)') AS UnitID, y.item.value('@ListingID', 'varchar(100)') AS @ListingID FROM dbo.KB_XMod_Modules CROSS APPLY CONVERT(xml, instancedata).nodes('//instance') AS y(item) (instancedata is my column) Can anyone think of a work around for this ? Thanks

  Read the article

• Get all design documents in CouchDB

  - by karlthorwald

  How can I get a list of all design documents in CouchDB? Using a http query, not futon.

  Read the article

• iPhone to host server to mySQL and back?

  - by ronbowalker

  Can someone please direct me to process for doing this? I have already done the Login verification exercise using mySQL for the dbase on my host server (thanks to kiksy). Now I am trying to move forward and "Query" from the iPhone a list of "users" that currently occupy the table (iphoneusers) in MySQL. And of course get it back to the iPhone via the php connection. Any help would be very much appreciated. ronbowalker

  Read the article

• I am searching for a string like Cityname, State in mysql table where state name is 2 letter char.

  - by subson

  I am searching for a string like Cityname, State (e.g.Moline,IL) in mysql table. How can i make the query using regexp in mysql.

  Read the article

• CONCAT_WS rows in JOIN

  - by Alex Kiselev

  i have tables profiles (id, name, deleted) categories (id, name, deleted) profiles_categories (id, profile_id, category_id, , deleted) I have wrong query SELECT p.id, p.name CONCAT_WS(', ', c.name) AS keywords_categories FROM profiles p LEFT JOIN profiles_categories pc ON p.id = pc.profile_id LEFT JOIN categories c ON pc.id = c.id WHERE p.deleted = FALSE So, i want have result with all profiles with concan categories.name. Thanks

  Read the article

• Excluding records based upon a one to many SQL join

  - by tequila2k

  How would I write a SQL query that excludes a record if one (external) record from a one to many join matches a certain condition? For example: Details ID 1 2 Items DetailID Item 1 A 1 B 2 B 2 C How would I select the detail records where the Items do not include 'A'?

  Read the article

• HTML actual page link

  - by lore3d

  Hi all, I'm building a website, and i need to know the actual page address in which the user is in, in order to take users in the same page after login. The problem is that every page is generated from variables passed by url and query string, so I dont't know how to recover every variable and assign to it the correct value. How to recover variables name and assign them the correct values? Thanks lore (sorry for my English)

  Read the article

• Update on #temp table is faster then the @ table variable.

  - by pansingh

  In the similar query Update on #temp table is faster then the @ table variable. But I m forced to use table variable as I am wokring with function. I feel index is not being picked up for table variable. I have unique clustered index. Please help

  Read the article

• How to create Local Data Caching in c# WinApps?

  - by kurt_jackson19

  Anyone can give me an example on how to create local data caching? Like for example I query 10 millions records from my DB and I want to store it in my local so that I would not encounter performance problem next time when I want to reload the data. Thank you so much.

  Read the article

• How can i add '"-" in column

  - by jasmeet

  my query is showing in row 2000 the data of 2000-2001 & in 2001 the data of 2001-2002. how can i change the column so that it displayes column 1 column 2 2000-2001 5 2001-2002 3 2002-2003 9 2003-2004 12 . . . . and so on...

  Read the article

• Get matching route from URL in rails (again)

  - by fturtle

  Hi, How can I get hold of the matching route for a url in rails? Given a url, I want to query the respective controller and action. Note, the current page isn't the url in question. This question has been posed before but wasn't answered. Cheers.

  Read the article

< Previous Page | 573 574 575 576 577 578 579 580 581 582 583 584  | Next Page >