Search Results

Search found 10060 results on 403 pages for 'column'.

Page 35/403 | < Previous Page | 31 32 33 34 35 36 37 38 39 40 41 42  | Next Page >

• SQLite fts3: search for a string in a column

  - by Manoj

  Is there any way to search for a particular string in a column? I want to search like SELECT * from email_fts WHERE email_fts MATCH 'to:"[email protected]" OR from:"[email protected]"' Thanks in advance, Manoj

  Read the article

• How do I select the max value from multiple tables in one column

  - by Derick

  I would like to get the last date of records modified. Here is a sample simple SELECT: SELECT t01.name, t01.last_upd date1, t02.last_upd date2, t03.last_upd date3, 'maxof123' maxdate FROM s_org_ext t01, s_org_ext_x t02, s_addr_org t03 WHERE t02.par_row_id(+)= t01.row_id and t03.row_id(+)= t01.pr_addr_id and t01.int_org_flg = 'n'; How can I get column maxdate to display the max of the three dates? Note: no UNION or sub SELECT statements ;)

  Read the article

• MS SQL Return 1 Row Per Boat

  - by Tyler

  Basically, what I want to do is join 4 tables together and return 1 row for each boat. Table Layouts [Boats] id, date, section, raft [Photos] id, boatid, pthurl, purl [River_Company] id, sort, company, company_short [River_Section] id, section Its very simple as far as structure, however, I've having the time of my life trying to get it to return only 1 row. No boat will ever be on the same day, the only thing that's messing this up is the photo table. If you know a better way for it to return the record table for all the boats boats and only 1 photo from the photo table, please, please post it!!

  Read the article

• How to use linkbuttons within yui datatable?

  - by Pandiya Chendur

  I use yui datatable and i have a field which is resumePath which is path to a file in a folder in my application... So how to use linkbutton and show my path on it... { key: "resumepath", label: "Resumepath", width: 250, formatter: YAHOO.widget.DataTable.formatLink } and this doesnt work any suggestion... I want to make this file to downloaded when the user clicks on it..

  Read the article

• Flex: How to most effectively tavere a table column

  - by Maik

  I have a table "template" which is used in various "instances". All instances have checkboxes in the second column (for record-delete). What would be the most effective way of traversing the table and check if at least one checkbox is selected (to enable a "delete" button)? Thanks! Maik

  Read the article

• Add Checkbox column in flexigrid

  - by Ramji

  The issue about jquery flexigrid using php. unfortunately http://flexigrid.info site is down very often so managed to take some sample code from http://sanderkorvemaker.nl/test/flexigrid/ and worked based on that. The above sample code works now I need to create a grid with a column with checkboxes, So that I can click a couple of those checkboxes and click delete button it should get all the id in which the checkboxes are checked to and create a delete query and execute. Can anyone give me an example please Thanks in advance

  Read the article

• Making only one column of a QTreeWidgetItem editable

  - by Andreas Brinck

  I have a QTreeWidgetItem with two columns of data, is there any way to make only the second column editable? When I do the following: QTreeWidgetItem* item = new QTreeWidgetItem(); item->setFlags(item->flags() | Qt::ItemIsEditable); all columns become editable.

  Read the article

• increase the width of a column dynamically in jasper reports in java

  - by stanley

  How do i increase the width of a column in jasper reports dynamically in java, i have tried changing many things in java side like reading the style sheet and changing the values. But in this case i don't know how to initialize the method which will read the width and change it.

  Read the article

• hibernate column uniqueness question

  - by Seth

  I'm still in the process of learning hibernate/hql and I have a question that's half best practices question/half sanity check. Let's say I have a class A: @Entity public class A { @Id @GeneratedValue(strategy=GenerationType.AUTO) private Long id; @Column(unique=true) private String name = ""; //getters, setters, etc. omitted for brevity } I want to enforce that every instance of A that gets saved has a unique name (hence the @Column annotation), but I also want to be able to handle the case where there's already an A instance saved that has that name. I see two ways of doing this: 1) I can catch the org.hibernate.exception.ConstraintViolationException that could be thrown during the session.saveOrUpdate() call and try to handle it. 2) I can query for existing instances of A that already have that name in the DAO before calling session.saveOrUpdate(). Right now I'm leaning towards approach 2, because in approach 1 I don't know how to programmatically figure out which constraint was violated (there are a couple of other unique members in A). Right now my DAO.save() code looks roughly like this: public void save(A a) throws DataAccessException, NonUniqueNameException { Session session = sessionFactory.getCurrentSession(); try { session.beginTransaction(); Query query = null; //if id isn't null, make sure we don't count this object as a duplicate if(obj.getId() == null) { query = session.createQuery("select count(a) from A a where a.name = :name").setParameter("name", obj.getName()); } else { query = session.createQuery("select count(a) from A a where a.name = :name " + "and a.id != :id").setParameter("name", obj.getName()).setParameter("name", obj.getName()); } Long numNameDuplicates = (Long)query.uniqueResult(); if(numNameDuplicates > 0) throw new NonUniqueNameException(); session.saveOrUpdate(a); session.getTransaction().commit(); } catch(RuntimeException e) { session.getTransaction().rollback(); throw new DataAccessException(e); //my own class } } Am I going about this in the right way? Can hibernate tell me programmatically (i.e. not as an error string) which value is violating the uniqueness constraint? By separating the query from the commit, am I inviting thread-safety errors, or am I safe? How is this usually done? Thanks!

  Read the article

• Update column using rows of a table.

  - by Muhammad Kashif Nadeem

  Update Combined column using CategoryCode of every OrderId. In this example there are two OrderIds 990 and 986. Need to concatenate categories of these two individually. The desired result is like this. 990 Bus, Pub, Shoot, Club, Bus, Hos Thanks.

  Read the article

• Rows in their own columns depending on their date and simbolized by 'x'

  - by Chandradyani

  Dear All, please help me since I'm newbie in SQL Server. I have a select query that currently produces the following results: DoctorName Team Visit date dr. As A 5 dr. Sc A 4 dr. Gh B 6 dr. Nd C 31 dr As A 7 Using the following query: SELECT d.DoctorName, t.TeamName, ca.VisitDate FROM cActivity AS ca INNER JOIN doctor AS d ON ca.DoctorId = d.Id INNER JOIN team AS t ON ca.TeamId = t.Id WHERE ca.VisitDate BETWEEN '1/1/2010' AND '1/31/2010' I want to produce the following: DoctorName Team 1 2 3 4 5 6 7 ... 31 Visited dr. As A x x ... 2 times dr. Sc A x ... 1 times dr. Gh B x ... 1 times dr. Nd C ... X 1 times

  Read the article

• Will a multi column PRIMARY KEY create a multi column INDEX in SQLite?

  - by Derk

  When creating a table with a multi column PRIMARY KEY like this, CREATE TABLE t (a, b, PRIMARY KEY(a, b)) will it create a compound index that behaves the same as it would when indexed like this? CREATE INDEX i ON t (a, b)

  Read the article

• sql server - sum Comma seperated value from a column

  - by Aseem Gautam

  There is a column in database which contains comma seperated values like: 0.00,12.45,14.33 and so on. I need to sum this inside a stored procedure. One way which I can think of is to split and convert it into a table using a function and then sum it. Any other ideas?

  Read the article

• devexpress ASPxGridView column problem

  - by oshafran

  Hey all I have an ASPXGRIDVIEW which is binded to an SQL query. I added to the grid an additional COLUMNCUSTOMBUTTON. But what happens is, that for all the rows it put a link there. I am trying to find a way to add to this column a link (button) ONLY to specific rows! I am unable to understand how to do it thanks

  Read the article

• Timestamp column - Can it be queried?

  - by Randy Minder

  Can a Timestamp (rowversion) column in a SQL Server table be queried? If so, how? I'd like to do something like this: Select * From MyTable Where MyTimestampColumn = "???" But am not sure what to put in for "???" Thanks - Randy

  Read the article

• Ajust table column width to content size

  - by Rui Carneiro

  Form (with firebug highlight): Label column CSS: width: auto; padding: 0; The problem: Why my left columns have that invisible "padding-right"? It's not possible to shrink columns to fit their content?

  Read the article

• TSQL 'Invalid column name' error on value of sproc parameter

  - by Daria

  here's my code: DECLARE @SQL varchar(600) SET @SQL = 'SELECT CategoryID, SubCategoryID, ReportedNumber FROM tblStatistics WHERE UnitCode = ' + @unitCode + ' AND FiscYear = ' + @currYEAR EXEC (@SQL) When i run this sproc with unitCode = 'COB' and currYEAR = '10', i get the following error: Invalid column name 'COB'. Does anyone know why? thx!

  Read the article

• Python In-memory table

  - by nsharish

  What is the right way to forming in-memory table in python with direct lookups for rows and columns.I thought of using dict of dicts this way, class Table(dict): def __getitem__(self, key): if key not in self: self[key]={} return dict.__getitem__(self, key) table = Table() table['row1']['column1'] = 'value11' table['row1']['column2'] = 'value12' table['row2']['column1'] = 'value21' table['row2']['column2'] = 'value22' >>>table {'row1':{'column1':'value11','column2':'value12'},'row2':{'column1':'value21','column2':'value22'}} I had difficulty in looking up for values in columns. >>>'row1' in table True >>>'value11' in table['row1'].values() True Now how do I do lookup if 'column1' has 'value11' Is this method of forming tables wrong?Is there a better way to implement such tables with easier lookups?.Thanks

  Read the article

• Fetch all entries exept those with empty column in Rails

  - by Alfred Nerstu

  How do I fetch all 'link' entries exept those with an 'url' column that is blank? My controller looks like this: def show @user = User.find_by_username(params[:username]) @links = @user.links.all respond_to do |format| format.html # show.html.erb format.xml { render :xml => @links } end end Thanks in advance!

  Read the article

• DataGridView checkbox column - value and functionality

  - by nav

  Here is a reference the old SO question. http://stackoverflow.com/questions/1237829/datagridview-checkbox-column-value-and-functionality/1395215#1395215 I need to know, how would I get the information from a specific cell, so that i may further make the crystal report of the checked rows of datagridview. Thanks. -nav

  Read the article

• How to merge two single column csv files with linux commands

  - by user1328191

  I was wondering how to merge two single column csv files into one file where the resulting file will contain two columns. file1.csv    first_name    chris    ben    jerry file2.csv    last_name    smith    white    perry result.csv    first_name,last_name    chris,smith    ben,white    jerry,perry Thanks

  Read the article

• GridLayout with single column

  - by Albinoswordfish

  Right now I'm trying to use a GridLayout with only a single column. However I'm having a problem where I don't want the object, in this case a JButton, to be stretched the entire width of the JPanel that it's on. Is there a way to decrease the width of the JButton so that it does not stretch the entire width of the JPanel. I've tried using setPreferredSize and setSize with no results. Is this just the way GridLayout works or is there something I'm missing?

  Read the article

• Access Controls in Silverlight DataGrid Column Header from Code

  - by fuzzyman

  We have custom headers in the Silverlight DataGrid using the ContentTemplate. We've got a button in the header and need to programmatically access the button to hook up the event. We're using IronPython, so we can't statically bind the event in the xaml (plus we use the grid for many different views - so we dynamically generate the xaml). How can we get access to controls inside a datagrid column header?

  Read the article

• Column colapses on itself in IE

  - by user146780

  I have a column here: http://www.animactions.ca/contact.php It has contact information. Click contact a few times and you'll notice the text collapses itself. It happens randomly and I don't understand why? (only with Internet Explorer) Thanks

  Read the article

• Managing Unique IDs in stateless (web) DB4O applications

  - by Phil.Wheeler

  I'm playing around with building a new web application using DB4O - piles of fun and some really interesting stuff learned. The one thing I'm struggling with is DB4O's current lack of support for stateless applications (i.e. web apps, mostly) and the need for automatically-generated IDs. There are a number of creative and interesting approaches that I've been able to find that hook into DB4O's events, use GUIDs rather than numeric IDs or for whatever reason avoid using any system of ID at all. While each approach has its merits, I'm wondering if the less-elegant approach might equally be the best fit. Consider the following pseudo-code: If ID == 0 or null Set ID = (typeof(myObject)).Count myObject.Save It seems like such a blindingly simple approach, it's usually about here that I start thinking, "I've missed something really obvious". Have I?

  Read the article

< Previous Page | 31 32 33 34 35 36 37 38 39 40 41 42  | Next Page >