Search Results

Search found 7311 results on 293 pages for 'rows'.

Page 146/293 | < Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >

• Access: strange results with queries against MDB file

  - by Craig Johnston

  I am running the following SQL against an MDB file, a copy of which is located here: http://hotfile.com/dl/40641614/2353dfc/test.mdb.html (perfectly clean file, no macros or viruses) SELECT datediff("d", MAX(invoice.date), Now) As Date_Diff , MAX(invoice.date) AS max_invoice_date , customer.number AS customer_number FROM invoice …

  Read the article

• How do I connect to MySQL 5.1 in Visual Studio 2010?

  - by jake

  Does any one know how to connect to MySQL 5.1 with Visual Studio 2010? I have already tried the MySQL Connector/ODBC route and it got me really nasty results. The table rows were all listed as a view in the views section and nothing at all was listed in the tables or procedures folder.

  Read the article

• Silverlight Datagrid select on right click

  - by VexXtreme

  Hi Is there a way for a right click event to select a row in toolkit datagrid? I'm using toolkit context menu which works nicely, but the problem is, only left click is able to select rows, and I need right click to be able to do that if I want my context menu to work properly. Any help is appreciated

  Read the article

• how to create dynamic two dimensional array in java?

  - by Arivu2020

  i want to create two dimensional array dynamically.I know the number of columns.But the number of rows are changed dynamically.I try the array list,but it stores the value in single dimension only.what can i do?

  Read the article

• How Do I Select for Multiple Classes Using Nokogiri and Ruby

  - by Russ Bradberry

  From a table element, I would like to select all rows that have the class even or the class odd. I tried the jQuery syntax: report.css("table.data tr[class~=odd even]").each{|line| parse_line_item(line)} but it threw an error, any help is appreciated, thanks.

  Read the article

• Bug in UITableView: Why is the section header covered by an row after deleting an row?

  - by mystify

  When I delete a row like this, and then scroll a little bit, one of the rows of that section happens to cover the section header. - (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath { if (editingStyle == UITableViewCellEditingStyleDelete) { …

  Read the article

• QT how to select and change all coulmns of QStandardItemModel

  - by user63898

  Hello im trying to programmatic select and change the background color of all the columns of QStandardItemModel i have this that paint me only the first column out of 5 that the row contains // getting the rows QStandardItem* standardItem = m_model->item(i); //set the color i like all the row to be painted…

  Read the article

• transforming binary data using ssis and sql server 2008

  - by Rick

  Hello All - I have a task to import/transform and extract zipped binary files that contain both text data as well as embeded binary data. Within the data is data that is relational in nature and needs to be processed into a defined database structure. Currently I have a C# single threaded app that essentially…

  Read the article

• Finding the most common values from given data

  - by Ben Shelock

  I have some data that looks something like this... +----------+----------+----------+ | Column 1 | Column 2 | Column 3 | +----------+----------+----------+ | Red | Blue | Green | | Yellow | Blue | Pink | | Black | Grey | Blue | +--------------------------------+ I need to go…

  Read the article

• Advanced SQL query with lots of joins

  - by lund.mikkel

  Hey fellow programmers Okay, first let me say that this is a hard one. I know the presentation may be a little long. But I how you'll bare with me and help me through anyway :D So I'm developing on an advanced search for bicycles. I've got a lot of tables I need to join to find all, let's say, red and brown…

  Read the article

• How do I get the length of a regex match in vim?

  - by misfo

  If I want to get the length of each match within the parentheses in the following regex, how do I do it?: ^\(\-\+\s\)\+ I'm trying to modify the width of columns in a buffer with data that is laid out as a table. Since the first two rows of the table will look like this DESIGN_ID DESIGN_YEAR…

  Read the article

• Improving performance of cluster index GUID primary key

  - by TheVillageIdiot

  Hi, I've a table with large number of rows (10K+) and it primary key is GUID. The primary key is clustered. The query performance is quite low on this table. Please provide suggestions to make it efficient.

  Read the article

• jQuery Table - Reference User Input Row Names and Values

  - by Vic

  I have several tables which are generated by another application, which I have no control over. I am totally new to jQuery and ajax, and have only a limited knowledge of jsp. Two sample rows are: <table class="sicknessForm"> <tr id="row_0" class="datarow"> <td…

  Read the article

• mysql - speedup regex

  - by Uwe

  I have a table: +--------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+------------------+------+-----+---------+----------------+ | idurl | int(11) | NO | PRI | NULL | auto_increment…

  Read the article

• jQuery selector not working in IE

  - by CurlyFro

  this method should return a unique array of text from rows with a specific td class. works in ffs and chrome but not in ie8 or safari. can you spot the problem? function getUniqueIds() { var tblLnks = new Array(); $('td.tblLnk').each(function() { …

  Read the article

• How can I reload a datagrid in flash action script, after an xml file has loaded

  - by optician

  Hi Everyone, Does anyone know how to change the rowcount of a datagrid in flash after it has been created on the stage. I am loading an xml file externally that contains the number of rows the datagrid should have, but the problem is that becuase this file is not loaded…

  Read the article

• MYSQL DELETE from a table [closed]

  - by Hossein

  Possible Duplicate: MySQL DELETE in a single table Hi, I have this table: userurltag(id,user,Url,tag) I want to remove rows that contain urls that are used by only one user, can someone help me? It seems that DELETE...(SELECT...) is not supported in Mysql.

  Read the article

• sql conditional union on rowcount

  - by Stavros

  I have an SQL function which returns a list of Teams. I want to join an additional list to that list with a union, but only if it returns more than one rows. Something like: CREATE FUNCTION Teams() RETURNS TABLE AS RETURN ( SELECT * FROM TABLE1 UNION if…

  Read the article

• How to insert date in sqlite through java.

  - by dimitar

  Hello guys, I want to make a database that will hold a date in it(SQLite). Now first to ask is what is the right syntax to declare a date column. The second i want to know is how to insert date in it after that. And the third thing i want to know is how to…

  Read the article

• Find Missing Records

  - by Lennie De Villiers

  Hi, My SQL is a bit bad. I got a query that when I run it I return for example 10 rows but there are 15 in my where clause, how do I identify those 5 that I can't find? Off course I can dump it in MS Excel but how do I use SQL?

  Read the article

• Select nth percentile from MySQL

  - by mazin k.

  I have a simple table of data, and I'd like to select the row that's at about the 40th percentile from the query. I can do this right now by first querying to find the number of rows and then running another query that sorts and selects the nth row: …

  Read the article

• PIVOT not performing as expected.

  - by Matt W

  Sorry for an unclear question previously; hopefully I can start again... I have this data: entityid name stringvalue ----------- -------------------- -------------------- 1 ShortDescription Coal 1 …

  Read the article

• Grid overlayed on image using javascript, need help getting grid coordinates.

  - by Alos

  Hi I am fairly new to javascript and could use some help, I am trying to overlay a grid on top of an image and then be able to have the user click on the grid and get the grid coordinate from the box that the user clicked. I have been…

  Read the article

• Creating a grid overlay over image.

  - by neteus

  Hi everybody, I made a script (using mootools library) that is supposed to overlay an image with a table grid and when each grid cell is clicked/dragged over its background color changes 'highlighting' the cell. Current code creates…

  Read the article

• How do i delete an empty array of objects?

  - by dimitar

  Hello guys, i define an object: tempRes = new Object[100000][7]; now after that i fill it up till 100 rows for example. Now how to delete every object past that(from tempRes[100] too tempRes[10000]). I need this for a JTable.

  Read the article

< Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >