Search Results

Search found 63598 results on 2544 pages for 'sql add on'.

Page 540/2544 | < Previous Page | 536 537 538 539 540 541 542 543 544 545 546 547  | Next Page >

• how do you add a condition to a lambda expression

  - by ooo

  if i have this code today to find out a sum total using LINQ: return (MyArray.Sum(r => r.Trips); and i want to only include itms where r.CanDrive == true. can you add a condition into a single linke lambda expression? how would you do this

  Read the article

• Escape SQL "LIKE" value for Postgres with psycopg2

  - by Evgeny

  Does psycopg2 have a function for escaping the value of a LIKE operand for Postgres? For example I may want to match strings that start with the string "20% of all", so I want to write something like this: sql = '... WHERE ... LIKE %(myvalue)s' cursor.fetchall(sql, { 'myvalue': escape_sql_like('20% of all') + '%' } Is there an existing escape_sql_like function that I could plug in here? (Similar question to How to quote a string value explicitly (Python DB API/Psycopg2), but I couldn't find an answer there.)

  Read the article

• How can i add a new Functionor Property on textbox class's text property

  - by Shantanu Gupta

  I want to add one more function/property to a text property of a textbox like this. txtControl.Text.IsEmpty(); or txtControl.Text.IsEmpty; which returns me bool value. I dont want to compare for empty string every time. i.e. if(txtControl.text==string.Empty) {} else {} Can we do some other way also if just want to do it like if(txtControl.text.isEmpty){}

  Read the article

• I want to add an image from a local directory to a php page

  - by Jean

  Hello, I am trying to add an image from a local directory to a php page on my localhost. It adds fine, but does not display the image. What exactly am I doing wrong here? Thanks Jean

  Read the article

• php add thousandseperator without adjusting decimal places

  - by bobwah

  I'm looking for a way to use the php number_format function or something similar that will add the thousand seperator but will leave any decimal part of the number intatct without and formatting of this. For example: 39845.25843 = 39,845.25843 347346.8 = 347,346.8 1000000 = 1,000,000 Thanks

  Read the article

• C# Find out what column caused the Sql Exception

  - by PaN1C_Showt1Me

  Hi. I'm getting an exception from SQL Data Reader (MS SQL as datastore) and I'd like to know which column name causes this Exception to be thrown. But I cannot find it in the InnerException.. nowhere. ((System.InvalidOperationException)ex.InnerException).StackTrace: System.Data.SqlClient.SqlDataReader.ReadColumnHeader(Int32 i) System.Data.SqlClient.SqlDataReader.IsDBNull(Int32 i) ... Where is it hidden please ?

  Read the article

• dynamically add uitextfield in the uiscrollview in iphone

  - by jaiminpanchal27

  i have an array of some values and i want to dynamically create textfields for all the string objects inside the array and add it to the scrollview.. how to do it..

  Read the article

• add empty rows and edit arbitrary cells in WPF DataGrid

  - by tk

  On the DataGridView in WinForms, I can add empty rows and edit the values of arbitrary cells programmatically like below. dataGridView1.ColumnCount = 10; dataGridView1.RowCount = 100; dataGridView1[1, 1].Value = "a"; Can i do this kind of thing in WPF datagrid ?

  Read the article

• adding checkbox to a combobox

  - by Radhe

  I want to add check boxes inside a combo box and then use the values of the checked boxes in my sql query. Also I need to append the checked values to an array and then use the elements of that array in my sql query. How can I proceed?

  Read the article

• How to add javadoc for Servlet API in eclipse

  - by Daziplqa

  I've a dynamic web app in Eclipse that is using tomcat s a runtime environment. I cannot add javadoc path tomcat Servlet API as appears, the edit button is always disabled! ![alt text][1] [1]:

  Read the article

• C#, add references manually

  - by A B

  Is there anyway I can make the process of adding references to C# projects less painfull? Every time I create a new C# class library project. I have to use the Add Reference dialog for 5 times at least.

  Read the article

• How to add a new row into datagridview using grid only. i.e by showing textboxes and add button in W

  - by Shantanu Gupta

  I want to add a new row to a datagridview such that when a user clicks on new button , a new is is generated with few textboxes and combo boxes and after filling up all the details he save the info by clicking on save button. EDIT I want to do it like it is seen in gridview(Template Fields) in asp.net I am looking for same kind of functionality.

  Read the article

• Add multiple hist fit to a figure, without the hist

  - by clowny

  Hello, I'm a matlab newbie, and i'd like to superpose some hist fit on a same figure. I know the function histfit, but unfortunatly i can't get to remove the hist and only keep the curve. I guess once i'll know how to do that i'll be able to add several curves using "hold on". Thanx for any answers or advices!

  Read the article

• Update multiple table column values using single query

  - by Dave Jarvis

  How would you update data in multiple tables using a single query? In MySQL it would be: UPDATE party p LEFT JOIN party_name n ON p.party_id = n.party_id LEFT JOIN party_details d ON p.party_id = d.party_id LEFT JOIN incident_participant ip ON ip.party_id = p.party_id LEFT JOIN incident i ON ip.incident_id = i.incident_id SET p.employee_id = NULL, c.em_address = '[email protected]', c.ad_postal = 'x', n.first_name = 'x', n.last_name = 'x' WHERE i.confidential_dt IS NOT NULL What is the equivalent SQL statement using Oracle 11g? (Is ANSI SQL possible?) Thank you!

  Read the article

• Add methods to generated WCF client proxy code

  - by dcstraw

  I'd like to add one additional method for each service operation in my WCF client proxy code (i.e. the generated class that derives from ClientBase). I have written a Visual Studio extension that has an IOperationContractGenerationExtension implementation, but this interface only seems to expose the ability to modify the service interface, not the ClientBase-derived class. Is there any way to generate new methods in the proxy client class?

  Read the article

• Create a new table and import data from csv file into SQL Server 2005

  - by Madhu Kiran

  Hi, I have several files about 15k each of CSV data I need to import into SQL Server 2005. What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 180 fields in it, this would simplify things.

  Read the article

• Python: inserting double or single quotes around a string

  - by Jessy

  Im using python to access a MySQL database and im getting a unknown column in field due to quotes not being around the variable. code below: cur = x.cnx.cursor() cur.execute('insert into tempPDBcode (PDBcode) values (%s);' % (s)) rows = cur.fetchall() How do i manually insert double or single quotes around the value of s? I've trying using str() and manually concatenating quotes around s but it still doesn't work. The sql statement works fine iv double and triple check my sql query.

  Read the article

• Entity Framework 4 with SQL Server Express files.

  - by ridecar2

  Hi all, I know that if you use EF in a model-first manner in VS2010 with a standard SQL Server database then it is easy to apply the generated DDL to the database. Is there an easy way to do this with .mdf files (SQL Server Express Files) Thanks in advance.

  Read the article

• Manage views for content types (or add a view to multiple lists)

  - by Janis Veinbergs

  I'm surprised that I cannot find on the net a solution where I could manage views for content types. Do I really have to visit each task list with my browser to add/modify a view? Is there any solutions available that would allow me to just define a view for content type and thus make this view available on all lists where content type is?

  Read the article

• Add newlines to a text resource in Android?

  - by shmuelp

  I have a custom Dialog that contains only a TextView to display some text in my application. The documentation lists that only the b, i, u, tt, big, small, sup, sub, and strike tags are supported. I really need to add some newlines for readability. Do I need to change to a more complicated layout, or is there some way to encode newlines in the resource? I tried adding br tags, but that did not help.

  Read the article

• How to add button in HeaderSpan of SmartGWT

  - by Anuroop

  I want to add a button to the HeaderSpan of ListGrid in SmartGWT. I tried using the 'HeaderSpan.setAttribute((String property, Object value)) method but it did not work. Below is the example I tried with:- ListGrid countryGrid = new ListGrid(); HeaderSpan ident = new HeaderSpan("Identification", new String[]{"countryCode", "countryName"}); ident.setAttribute("control", new Button("Test")); countryGrid.setHeaderSpans(ident); countryGrid.draw(); Please help!

  Read the article

• How to add new menu item in ireport 3.7.2

  - by Jagadesh

  I am customizing the iReport sources. I need to add a new menu item in iReport designer. Note: iReport 3.7.2 is used. Can anyone tell the procedure?

  Read the article

• NHibernate - using custom sql query for a column

  - by stacker

  Is there anyway to use custom sql with NHibernate? I want to use custom sql for a specific column. select id, viewsCount, commentsCount, 0.2 * viewsCount / (select top 1 viewsCount from articles where isActive = 1 order by viewsCount DESC) as priorityViews, 0.8 * commentsCount / (select top 1 commentsCount from articles where isActive = 1 order by commentsCount DESC) as priorityComments, round(0.2 * viewsCount / (select top 1 viewsCount from articles where isActive = 1 order by viewsCount DESC) + 0.8 * commentsCount / (select top 1 commentsCount from articles where isActive = 1 order by commentsCount DESC), 1) as priority from articles

  Read the article

• Magentoo add slashes to file_name

  - by Kein

  I try extend an core class. But catch error: Warning: include( \\\\\\\\\\\\MyModule\Ajaxsearch\Model\Resource\Eav\Mysql4\Product\Collection \\\\\\\\\\.php) [function.include]: failed to open stream:... Why magento add slashes to addres? May be config error?

  Read the article

• how to add lines numbers to : QTextEdit ?

  - by radi

  i am writing a visual basic ide , and i need to add lines numbers to QTextEdit and highlight current line . i have found this tutorial but it is written in java and i write my project in c++ so where to find tutorial like that in c++ , or if there is a ready to use component ? thanks .

  Read the article

< Previous Page | 536 537 538 539 540 541 542 543 544 545 546 547  | Next Page >