Search Results

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

Page 460/943 | < Previous Page | 456 457 458 459 460 461 462 463 464 465 466 467  | Next Page >

• Excel 2003 - VBA for looping through every cell in a row to provide attributes/formatting

  - by Justin

  say I want to make the first row of the excel ss something like this: .Rows("1:1").Select With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With only I want each individual cells to have the outline, not the entire selection. how can i say for each cell in row 1, do the above idea Thanks!

  Read the article

• Querying to construct XML in TSQL without a source table, only variables?

  - by Darth Continent

  Using a SELECT statement in MS SQL 2005 TSQL, and no source table, just variables as listed below... @FirstName varchar(20) @LastName varchar(20) @ZipCode varchar(5) ...what syntax will build XML resembling the following? <XMLDATA><REC FirstName="JOHN" LastName="SMITH" ZipCode="98052" /></XMLDATA>

  Read the article

• Move to next message

  - by demas

  I have a messages line this: message 1 answer 1.1 answer 1.1.1 answer 1.2 answer 1.3 massage 2 ... and I have the line in my .gnus.el: (global-set-key [f9] (lambda () (interactive) (gnus-summary-lower-score-by-subj-substr-temp))) When I select "message 1" and press F9 next lines: message1 answer 1.1 answer 1.1.1 answer 1.2 answer 1.3 change the score. But I need the selection move to next message (message 2) when I press F9. How can I get it?

  Read the article

• SQL using with clause not working

  - by user1290467

  My question is why this query does not work? Cursor c = db.rawQuery("SELECT * FROM tbl_staff WHERE PMajor = '%" + spin.getSelectedItem().toString() + "%'", null); Cursor c: it is a cursor for handling my query tbl_staff: my table that consist of PName,PMajor,PCert spin: is spinner that has values which I need for my database query. When I use: if (c.moveToNext()) else (log.d("error query","couldn't do the query!");) It goes to else statement and moveToNext() doesn't work.

  Read the article

• grouping selected records of grid to the first page of the grid.

  - by subash

  i have a devexpress grid with some 500 pages.the coding has been done in asp.net & c#.net what i do is i select a record in 2nd page, 3rd page , 4th page, and in 10thpage, on clicking a button i want all the selected records in different pages of the grid should come to the first page.

  Read the article

• Hotkey for double-click highlight?

  - by Steven Wright

  I'm working in Eclipse and find myself always replacing multiple copies of the same word, but I always have to take my hands off the keyboard and screen to get the mouse, hover over the word, double click to select, and then copy or rewrite the word. Is there any way I can just move the cursor inside the word and hit some hotkey that would highlight it? Seems like this would be a big timesaver. Or if there's a way to create a hotkey that would be perfect too.

  Read the article

• UIPopoverController. Is is appropriate to embed a tableViewController within?

  - by dugla

  I am doing an iPad imaging app and I am considering UIPopoverController as my workhorse user interface element. The user will spend most of their time immersed in fullscreen content (in both portrait and landscape). When the user wants to select a different piece of content I want to use UIPopoverController to handle that. Is it appropriate to embed a tableViewController in a UIPopoverController to allow in-place scrolling or am I abusing the intended use of UIPopoverController? Thanks, Doug

  Read the article

• I'm missing something

  - by Redi

  declare @servername varchar(2000) set @EmriServerit=(select @@servername) declare @dbname varchar(2000) set @dbname ='Test1' declare @Dir varchar(2000) set @Dir='F:\dataclient.sql' exec master.dbo.xp_cmdshell 'osql -E -S ' + @servername+ ' -d ' + @dbname +' -i ' + @Dir It gives me and error: "incorrect sysntax near +" If i don't use variables it works ok. What am i missing! Thanks in advance

  Read the article

• How do I set TargetNullValue to a date?

  - by Bryan Anderson

  I'm using the WPF toolkit's Calendar control to allow users to select a date. If the date is not yet selected then the property the SelectedDate is bound to is Null. This makes the Calendar default you January 1, 0 AD. I'd like to do something like SelectedDate="{Binding UserPickedDate, TargetNullValue=Today, Mode=TwoWay}" But both "Today" and "Now" throw binding errors. Can I use TargetNullValue to set the default date to Today or Now?

  Read the article

• jQuery cleaning up two strings (compare string1 to string2 and remove items not uniq)

  - by atmorell

  Hello, How do I remove the oldItems from the newItems string? (remove Blue and Green) newItems is generated from jQuery autocomplete and I would like to remove already selected items from the select list. newItems = Blue \n Red \n Black \n Yellow \n Green \n oldItems = Blue,Yellow,Orange,Green Best regards. Asbjørn Morell.

  Read the article

• count columns group by

  - by zhangzhong

  I hava the sql as below: select a.dept, a.name from students a group by dept, name order by dept, name And get the result: dept name -----+--------- CS | Aarthi CS | Hansan EE | S.F EE | Nikke2 I want to summary the num of students for each dept as below: dept name count -----+-----------+------ CS | Aarthi | 2 CS | Hansan | 2 EE | S.F | 2 EE | Nikke2 | 2 Math | Joel | 1 How shall I to write the sql?

  Read the article

• How to drop all stored procedures at once in SQL Server database?

  - by z-boss

  Currently we use separate a drop statements for each stored procedure in the script file: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MySP]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[MySP] Is there a way to drop them all at once, or maybe in a loop?

  Read the article

• find elements of a varchar in another varchar

  - by Luca Romagnoli

  hi, i have a varchar field with the content like these: a,b,c,d e,d,a,c b,q,d,e i need to do a query that select only the rows with the field that has elements equals with an input string. ex input: c,a rows selected: a,b,c,d e,d,a,c is possible without use the OR (field like '%a%' OR field like '%c%') ? thanks

  Read the article

• In a SQL GROUP BY query, what value is used for the non-aggregate columns?

  - by Queencity13

  Say I've got the following data back from a SQL query: Lastname Firstname Age Anderson Jane 28 Anderson Lisa 22 Anderson Jack 37 If I want to know the age of the oldest person with the last name Anderson, I can select MAX(Age) and GROUP BY Lastname. But I also want to know the first name of that oldest person. How can I make sure that, when the Firstname values are collapsed into one row by the GROUP BY, I get the Firstname value from the same row where I got the max age?

  Read the article

• Django Admin Actions missing

  - by Andrew C

  One of my Django sites is missing the Django Admin Action bar shown here: http://docs.djangoproject.com/en/dev/ref/contrib/admin/actions/#ref-contrib-admin-actions There is no checkbox next to each row and no Action select box near the top of the page. This is happening on every model. I have several sites running Django 1.1, and they all show the Admin Actions, so it feels like a local configuration issue. Anyone seen this before?

  Read the article

• array of UIView display?

  - by senthilmuthu

  Hi, If you see the URL in TRY ME simulator select cardex tab,if u scroll vertically on simulator(flash),the no of uiviews are coming,if u touch anything, it will be shown,any idea to do this ,have they used OPENGL? please any help?

  Read the article

• Get contents of local folder in javascript (or ASP.NET VB)

  - by Jonathan

  Is it possible for a webpage to popup a open folder dialog, ask the user to select a folder, then show the contents of that folder in a list(or something) in the webpage. It won't write to the files, only read them. The webpage is hosted remotely. Jonathan

  Read the article

• global member creation

  - by Akash

  how the global members can be created in vc++ 6.0 mfc project. if i select globals option in WizardBar(WizardBar C++ class). then (WizardBar C++ members),it display (No members - Create New Class...). How to create the members for this globals class please give the steps to create.

  Read the article

• Order by descending is not working on LINQ to Entity

  - by Vinni

  Order by descending is not working on LINQ to Entity In the following Query In place of ascending If I keep descending it is not working. Please help me out var hosters = from e in context.Hosters_HostingProviderDetail where e.ActiveStatusID == pendingStateId orderby e.HostingProviderName ascending select e; return hosters.ToList();

  Read the article

• MS Access 2003 : VBA for INSERT INTO statement, new record: how to grab autoid number created?

  - by Justin

  I have a button click event that takes information from controls and enters it into a table via INSERT INTO SQL statement in VBA. I was wondering if there is anything I could add to this, or some other method to acquire the record number that is created for the record? Could I just turn around and SELECT against the table and use rs.last?

  Read the article

• MySQL & PHP Parameter 1 as Resource

  - by Nik

  Alright, PHP is throwing this error at me (in the log) when I run the code mentioned below: Error mysql_num_rows() expects parameter 1 to be resource, string given in (place) on line 10 Line 9-11 $queryFP = ("SELECT * FROM db"); $countFP = mysql_num_rows($queryFP); $aID = rand(1, $countFP); I think it has something to do with the $queryFP's syntax, but I'm not completely sure how to fix it since $queryFP's syntax is the simplest query I've ever seen.

  Read the article

• Getting results in a result set from dynamic SQL in Oracle

  - by msorens

  This question is similar to a couple others I have found on StackOverflow, but the differences are signficant enough to me to warrant a new question, so here it is: I want to obtain a result set from dynamic SQL in Oracle and then display it as a result set in a SqlDeveloper-like tool, just as if I had executed the dynamic SQL statement directly. This is straightforward in SQL Server, so to be concrete, here is an example from SQL Server that returns a result set in SQL Server Management Studio or Query Explorer: EXEC sp_executesql N'select * from countries' Or more properly: DECLARE @stmt nvarchar(100) SET @stmt = N'select * from countries' EXEC sp_executesql @stmt The question "How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?" addresses the first half of the problem--executing dynamic SQL into a cursor. The question "How to make Oracle procedure return result sets" provides a similar answer. Web search has revealed many variations of the same theme, all addressing just the first half of my question. I found this post explaining how to do it in SqlDeveloper, but that uses a bit of functionality of SqlDeveloper. I am actually using a custom query tool so I need the solution to be self-contained in the SQL code. This custom query tool similarly does not have the capability to show output of print (dbms_output.put_line) statements; it only displays result sets. Here is yet one more possible avenue using 'execute immediate...bulk collect', but this example again renders the results with a loop of dbms_output.put_line statements. This link attempts to address the topic but the question never quite got answered there either. Assuming this is possible, I will add one more condition: I would like to do this without having to define a function or procedure (due to limited DB permissions). That is, I would like to execute a self-contained PL/SQL block containing dynamic SQL and return a result set in SqlDeveloper or a similar tool. So to summarize: I want to execute an arbitrary SQL statement (hence dynamic SQL). The platform is Oracle. The solution must be a PL/SQL block with no procedures or functions. The output must be generated as a canonical result set; no print statements. The output must render as a result set in SqlDeveloper without using any SqlDeveloper special functionality. Any suggestions?

  Read the article

• nslookup for C# and C++ to resolve a host using a specific Server

  - by Shahmir Javaid

  i need to resolve a hostname using a specific DNS server like you would in nslookup C:\>nslookup hotname 192.100.10.10 Server: UnKnown Address: 192.100.10.10 Name: hostname.host Address: 192.100.10.14 But ofcourse in return i dont just want the address i want all the values for Server, Address, Name and Address I have looked at the System.Net.Dns Class but that only gives me the Resolved IP Address and dosent let me select the DNS Server of my choosing If any one has done this before and you can help me with this. it would be great :D Thanks in Advanced

  Read the article

• How do I center a java.awt.FileDialog on the screen

  - by Software Monkey

  I have never been able to figure this one out; the usual suspects don't work. Given: FileDialog dlg=null; dlg=new FileDialog(owner,"Select File to Load",FileDialog.LOAD); dlg.setFile(null); dlg.setVisible(true); is there any way to get that dialog centered?

  Read the article

• Entity Framework Many-To-Many with additional field on Joining Table

  - by Cory G

  I have an entity context that includes three tables (see diagram here). The first is a table that contain products, the second contains recipes. The joining table has fields for IDs in both the products and recipes table as well as a 'bit' field called 'featured'. I've searched and found no example on how to insert only how to select against this type of scenario.Does anyone have any suggestions on how this can be done? Thanks in advance for any help. Cory

  Read the article

< Previous Page | 456 457 458 459 460 461 462 463 464 465 466 467  | Next Page >