Search Results

Search found 33834 results on 1354 pages for 'site column'.

Page 340/1354 | < Previous Page | 336 337 338 339 340 341 342 343 344 345 346 347  | Next Page >

• changing existing duplicate entries in mysql

  - by Mladen

  sorry for the (probably) noob question, but I', new at this stuff. i have a table that has column 'position', and I want to, when inserting a new row, change positions of every row that has position lower than row that is inserted. for example, if I add row with position 4, if there is a duplicate, it should become 5, 5 should shift to 6 and so on... also, is there a way to get highest value for column besides testing it in every row via php?

  Read the article

• how to store hour and minute in database table while using mktime() function?

  - by Learner Miz

  I am using a form to get the hour and minute using post method and then store it to mysql DB. Such as : $hour = $_POST['hour']; $minute = $_POST['minute']; ** There is no need of date, month and year. I just need to store the hour and minute in a column of a table (ex: exam_time) Column structure: exam_time time NOT NULL Now how to store these value into database using mktime() function. I tried but it stores 00:00:00, not the one which I am sending via form.

  Read the article

• Using Oracle Zero Date

  - by Noam

  I have an application with existing data, that has Zero in the date column. When I look at it from sqlplus I see: 00-DECEMB when I use the dump function on this column, I Get: Typ=12 Len=7: 100,100,0,0,1,1,1 I need to work with the existing data from .Net (no changes to the data,or the data structure or even existing sql statements) How the hack do I read this value, or write it. The db version varies, from 8 to 11. Help would be appreciated

  Read the article

• how to get Next month date from today date (i.e) exactely one month expires from today date

  - by Ranjana

  i have maintained two datas into my table 1 column 2 column PaidDate validitydate in padidate ill give insert todaydate. but in validity date i may either insert validity for 1 week/1 month. I have used validity=DATEADD(Day,7,@paiddate) to insert validity for 1 week. but how to gtet the validity for 1 month from todays date

  Read the article

• SharePoint 2010 - Change table row /cell hover effect

  - by Sam

  In SharePoint 2010 when you hover over a column heading (i.e. to sort) in a list table, you get a hover effect, how can you supress / change this? I can see it uses OnChildColumn(this), so is there a way to modify this - either preventing the effect (e.g. when sorting can't be done on a column), or using a different background image? Also want to do the same when you hover over a cell in any of the list table's contents.

  Read the article

• Retrieving Data in A NSTableView

  - by Heisennberg

  I have a three column Table View populated by two NSMutableDictionaries which share the same keys (ie key | value1 | value2 ) with dict1(key,value1) and dict2(key,value2). I want to manually enter data in the third column and create the key/value objects in dict2. But when I do that, my code picks the wrong key :S Here's the code for the delegate : - (void)tableView:(NSTableView *)aTableView setObjectValue:(id)anObject forTableColumn:(NSTableColumn *)aTableColumn row:(NSInteger)rowIndex { if ([[aTableColumn identifier] isEqualToString:@"value2"]) { [dict2 setValue:anObject forKey:[[[aTableView tableColumnWithIdentifier:@"key"] dataCellForRow:rowIndex] stringValue ]]; } } Any idea ?

  Read the article

• SharePoint 2007 - Content deployment and swapping content database

  - by Mel Lota

  Hi all, I'm currently working on a SharePoint 2007 site which is setup to allow clients to author content on a staging server and then this is automatically pushed up to the live environment via content deployment. The content deployment is setup in the 'Content deployment jobs and paths' in central admin. Now the problem I've got is that it seems that historically there have been a mixture of full and incremental deployments done to the live site collection which according to Stefan Goßner's best practices post (http://blogs.technet.com/stefan_gossner/pages/content-deployment-best-practices.aspx) is a bad idea due to the fact that things soon become out of sync. It's gotten to the point where the content deployment has just stopped working and incremental or full deployments are throwing errors in the logs. What I'm thinking is that I probably need to perform a full content deployment to an empty site collection and then somehow switch the new clean site collection with the current live one. I was wondering if anybody has any experience with this and could provide any pointers, I'm currently investigating the feasibility of performing the clean content deployment and then switching the live content database with the new one, however in my tests I've found that as soon as I switch content databases, the incremental deployment still fails. Any help much appreciated. (Note: I did post this on SharePoint Overflow as well, but thought I'd put it on here in case anybody else has any ideas) Cheers

  Read the article

• Mysql dynamic query

  - by pradeep

  I have two table in mysql one tbl_a which has one int column id, second tbl_b which has one column song_ids in which data stored seapated by comma like 1,2,3,4 i want to select all id like this select * from tbl_a where id in (select song_id from tbl_b) but its giving me no record as its varchar HOW to do it in mysql

  Read the article

• How to replace the following character with an empty space?

  - by Pandiya Chendur

  One of my datatable column value looks like the below, How to replace that character which is square in shape with a \n or an empty space using c#? Any suggestion... ClientAddress column holds value of a Multiline textbox....

  Read the article

• PHP/MySQL Problem

  - by Scott

  Why does this only print the sites specific content under the first site, and doesn't do it for the other 2? <?php echo 'NPSIN Data will be here soon!'; // connect to DB $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'root'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to DB'); $dbname = 'npsin'; mysql_select_db($dbname); // get number of sites $query = 'select count(*) from sites'; $result = mysql_query($query) or die ('Query failed: ' . mysql_error()); $resultArray = mysql_fetch_array($result); $numSites = $resultArray[0]; echo "<br><br>"; // get all sites $query = 'select site_name from sites'; $result = mysql_query($query); // get site content $query2 = 'select content_name, site_id from content'; $result2 = mysql_query($query2); // get site files // print info $count = 1; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "Site $count: "; echo "$row[0]"; echo "<br>"; $contentCount = 1; while ($row2 = mysql_fetch_array($result2, MYSQL_NUM)) { $id = $row2[1]; if ($id == ($count - 1)) { echo "Content $contentCount: "; echo "$row2[0]"; echo "<br>"; } $contentCount++; } $count++; } ?>

  Read the article

• Oracle Minus query. How can I get a result with NULLS if the top SQL and the bottom SQL don't contai

  - by George

  CREATE TABLE NewTable AS SELECT A,B,C FROM Table1 minus SELECT A, B, C From Table2 Create a new table with NULL values for column A when neither Table1 or Table2 had NULL values for this column. Yet, SELECT * FROM ( SELECT A,B,C FROM Table1 minus SELECT A, B, C From Table2 ) WHERE A IS NULL return 0 rows?

  Read the article

• In a C# app, what is the most optimal way to insert many records into sql server?

  - by Otter

  I need to perform a very large sql server insert from a c# application. Somewhere in the range of 20,000 through 50,000 records. What is the fastest way through SQL server to perform the insert? There are several options I know of, but I don't know which is the fastest. insert into MyTable(column1, column2, ..., column*) select 'value','value',...,'value' union select 'value','value',...,'value' VS insert into MyTable(column1, column2, ..., column*) exec('select ''value'',''value'',...,''value''' 'select ''value'',''value'',...,''value''') VS bulk insert from a data file VS Any better way that you know of :)

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• question about timestamp with timezone in postgresql+java?

  - by ylazez

  hey guys i have a column in the database(postgresql) i want to insert the current time in GMT in this column when getting the current time and inserting it into the DB it's inserted in the server timezone GMT-5 although that time was in GMT+0 any ideas how to insert this time in the database in GMT timezone ?

  Read the article

• How to find missing alpha values in sets of data within same table in SQL

  - by Jeff

  I have a table of many values where one column has the WO Number, and another column has the Resource ID. I need to be able to find all the WO numbers that do not have a resource value of "RW". Here is an example of the typical information. I need to be able to know that work order 5678 does not have an "RW" Resource ID. WO Number - Resource ID 1234 - IN 1234 - WE 1234 - AS 1234 - RW 5678 - PR 5678 - WE 5678 - IN 5678 - AS

  Read the article

• How to remove duplicate entries from a mysql db?

  - by Yegor

  I have a table with some ids + titles. I want to make the title column unique, but it has over 600k records already, some of which are duplicates (sometimes several dozen times over). How do I remove all duplicates, except one, so I can add a UNIQUE key to the title column after?

  Read the article

• WPF bind IsEnabled on other controls if a listbox has a select item

  - by the empirical programmer

  I have a grid with 2 columns, a listbox in column 0 and a number of other controls in the a secondary grid in the main grids column 1. I want this controls only to be enabled (or perhaps visible) if an items is selected in the listbox through binding. I tried on a combo box: IsEnabled="{Binding myList.SelectedIndex}" But that does not seem to work. Am I missing something? Should something like this work? thanks

  Read the article

• Erro while join table in SQL

  - by Color Shadow

  I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement: SELECT CarReserve.ID FROM CarReserve INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName WHERE UserName = @UserName Unfortunately, I am getting this warning: Ambiguous column name "UserName" Can anyone here tell me what is wrong with my statement?

  Read the article

• How to change the header height in jQuery grid?

  - by rockers

  Hello Friends, I have a jquery grid,, with columns 5..but my column name is too large so defined somethign like this in my jquery grid.. Informatoin about <br/> customers bioData In my jquery column I am seeing Information about I am not able to see Customers BioData.. how to set the header height? thanks

  Read the article

• Return 0 when a value of a cell is negative

  - by Robert

  I have a google spreadsheet that uses this function: =SUM(E:E) - SUM(C:C) It adds up all the values of column E and column C and them subtracts the difference. I would like to be able to return a 0 if the difference is negative.

  Read the article

• Dynamically updating DIV on hover of link using jquery

  - by Nabin

  Hi, In my project data is display as a table with first column ID as hyperlink. On hover on the first column i need to display all the information as another table(DIV). This should change dynamically(ajax) on the hover of each ID. I am using jQuery and asp.net 3.5 Please suggest.

  Read the article

• delete records from a table based on data from a different table

  - by every_answer_gets_a_point

  table1 has column CITY and COUNTRY. table2 has column CITY. how do i delete from table2 all records that have CITY in common with table1 but also the COUNTRY='Russia' ?? please keep in mind that both tables have about 1 million rows of data

  Read the article

• sphinx questions about searching multiple columns

  - by letian

  if i am trying to search "a b". a appears in column x, b appears in column y. when i do SPH_MATCH_ALL the row does not show up..

  Read the article

• sql: connecting tables that have no relation

  - by every_answer_gets_a_point

  if i have two tables that have nothing in common i want to do a select as follows: column from table1, column from table 2 how do i do it?

  Read the article

• selectively update prepared statement

  - by user309584

  for an prepared statement update table t set a = ? ,b = ? where i = ? column a to stay column a ie. a=a and only need to setInt for b and visa versa, without needing another statement. Is there a concise way of doing this?

  Read the article

< Previous Page | 336 337 338 339 340 341 342 343 344 345 346 347  | Next Page >