Search Results

Search found 24890 results on 996 pages for 'pivot table'.

Page 635/996 | < Previous Page | 631 632 633 634 635 636 637 638 639 640 641 642  | Next Page >

• .Net: Best technique to fill a number of combo boxes on the form in windows application?

  - by odiseh

  hi Suppose that you have a win form with 5 combo boxes on it. Some one told me that you must have 5 data table in order to fill them one by one. How do you fill them with data stored in Database?

  Read the article

• collation in stored procedure

  - by Sharique

  I have a table which contains data in different languages. All fields are nvarchar(max). I created a stored procedure which trim values of all the fields Create Proc [dbo].[TrimValues] as update testdata set city = dbo.trim(city), state = dbo.trim(state), country = dbo.trim(country), schoolname = dbo.trim(schoolname) after trim all non-english text become ?????

  Read the article

• ASP.net: Radio Button Not Maintaining Selection After Postback, Inside DIV/Thickbox

  - by jlrolin

  I have a set of radio buttons inside a hidden DIV. <div id="reports" style="display:none;"> <center> <br /> <table cellpadding="4" cellspacing="0"> <tr> <td class="label"> Report Type::&nbsp; </td> <td class="value"> <asp:RadioButton ID="rbReportTypeCust" runat="server" Text="By Customer" Enabled="True" Checked="True" GroupName="rbType" />&nbsp;<asp:RadioButton ID="rbReportTypeProg" runat="server" Text="By Program" Enabled="True" GroupName="rbType" /> </td> </tr> <tr> <td class="label"> Customer:&nbsp; </td> <td class="value"> <asp:DropDownList ID="ddlCustomer" runat="server" /> </td> </tr> <tr> <td class="label"> Program Group::&nbsp; </td> <td class="value"> <asp:DropDownList ID="ddlProgramGroups" runat="server" /> </td> </tr> </table> <br /> <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClientClick="doPostBack(this);" /> </center> </div> The DIV is displayed using Thickbox as a modal popup. The doPostback javascript function posts the button click back, and hits btnSubmit_Click where a report is then generated. If I see if a radio button is checked, it's always rbReportTypeCust.checked = True, never the rbReportTypeProg.checked = True even if I click it. Any suggestions?

  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 @@rowcount>1 SELECT * FROM TABLE2 end if )

  Read the article

• mysql query optimisation

  - by Bharanikumar

  i have around (1,049,906 total, Query took 0.0005 sec) in my x table , If i simply retrieve trying to retrive the particular field records , Its tooks hardly 6 mins , This is my query SELECT CUSTOMER_CODE FROM X_TBL ; CUSTOMER_CODE = UNIQUE THE ABOVE QUERY TOOK 6MIN , Tel me optimization tips for this , Also in some situation to search customer , i used the CUSTOMER_CODE in like , select CUSTOMER_CODE from X_TBL WHERE CUSTOMER_CODE LIKE "$KEY_WORD%" Regards Bharanikumar

  Read the article

• CakePHP ACL - Do I need to add all my users to ARO ?

  - by dilip

  I have a users table and also have a column for role. Added the roles in ARO. the command : cake acl view aro shows 1 role1 2 role2 3 role3 Me confused about creating ACO. Should I add all my users to ARO ? Thanks

  Read the article

• MySQL 5.1 / phpMyAdmin - logging CREATE/ALTER statements

  - by pako

  Is it possible to log CREATE / ALTER statements issued on a MySQL server through phpMyAdmin? I heard that it could be done with a trigger, but I can't seem to find suitable code anywhere. I would like to log these statements to a table, preferably with the timestamp of when they were issued. Can someone provide me with a sample trigger that would enable me to accomplish this? I would like to log these statements so I can easily synchronize the changes with another MySQL server.

  Read the article

• Get Unique Results in a query.

  - by Bathan

  Hi guys! Im sure this will be pretty simple for a t-sql guru. I have the following result from a table idMain IdSecondary TextValue 1,1,text1 1,2,text2 2,5,text3 2,6,text5 And I want to obtain the first occurence of the idMain only. THe result should be like this. idMain,idSecondary,TextValue 1,1,text1 2,5,text3 How can I achieve this?

  Read the article

• Mysql query trouble: uploading

  - by Jakub Zak

  I'm trying for last hour solve this problem. I have a long form and I'm trying to upload info into mysql database. Into table I made. This is the mysql query I'm using: mysql_query("INSERT INTO `users_temp`(`first_name`, `surname`, `birthday`, `nationality`, `email`, `mobile`, `landline`, `address`, `town`, `post_code`, `country`, `password`, `code_conf`) VALUES ([$f_name],[$s_name],[$bday],[$nationality],[$email],[$mobile],[$landline],[$address],[$town],[$post_code],[$country],[$pass],[$conf_code])"); If anyone see any problem why it doesn't work pls let me know. Thank you...

  Read the article

• SQL SERVER - Detecting non-indexed columns but used in WHERE clause

  - by Vadi

  How to detect a column included in WHERE clause but used in indexed? Little Background: Until the time the table has few number of records things will be okay, once it started having millions of records then index should be created for a column which is used in WHERE clauses in stored procs, inline queries etc., Since we have hundreds of stored procs and queries that often gets changed by the devs I wanted to have a automated way of identifying those columns that are used in WHERE clauses but not an index is created. How to do that in SQL SERVER 2008?

  Read the article

• NSMutableArray: count is a method or a property?

  - by Rafael Oliveira

  I want to verify if I'm in the last cell of the UITable. Should I use a NSInteger property in my controller and store the value of the count of the data (it's an NSMutableArray) that populates the table? I'm asking because I don't know if count iterates over all objects of the array to count or if it only gets me a value of a count property. What would be better ? store the value: myCount = [myArray count] use directly: [myArray count] store numberOfRows: myCount = numberOfRowsInSection:[indexPath 0] use numberOfRows directly: numberOfRowsInSection:[indexPath 0]

  Read the article

• How to add additional data column in EF using ASP.Net MVC 2

  - by Picflight

  My Table: [LocationId] [Address] [ZipCode] When I show a list of Location's, I also want to show the distance from a given zip code. In Asp.Net Web Forms I had a stored procedure that would return the distance and I would call this SP on ItemDataBound on my GridView. Or, I also would have my SP that is returning the Location list add another column ([Distance]) which I could display in my GridView. How would you do this using Entity Framework and Asp.Net Mvc 2?

  Read the article

• HTML Strict increases line height...

  - by Ryano

  Hi Why does XHTML 1.0 Strict display a line height as appearing larger than a line height of the same value in XHTML 1.0 Transitional? This therefore pushing down content within table cells (i.e Hotmail in Firefox, Gmail in IE and Firefox). Has anyone else experienced this issue and know a way around it? Cheers

  Read the article

• Radio Button text

  - by niya

  Trying to create a profile using content provider.I want to add the gender to the table when the radio button corresponding to the male or female is clicked. Any solution?

  Read the article

• change an attribute of css

  - by balalakshmi

  newbie question in css: I have the following style defined: TABLE.tabulardata th { font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; background: #CAE8EA url(images/bg_header.jpg) no-repeat; } I want to create an identical style but with different background color. question: is it possible to parameterize the attribute. Background color in this case Or do i need to copy the same style again

  Read the article

• Programming a callback function within a jQuery plugin

  - by ILMV

  I'm writing a jQuery plug-in so I can reuse this code in many places as it is a very well used piece of code, the code itself adds a new line to a table which has been cloned from a hidden row, it continues to perform a load of manipulations on the new row. I'm currently referencing it like this: $(".abc .grid").grid(); But I want to include a callback so each area the plug-in is called from can do something a bit more unique when the row has been added. I've used the jQuery AJAX plug-in before, so have used the success callback function, but cannot understand how the code works in the background. Here's what I want to achieve: $(".abc .grid").grid({ row_added: function() { // do something a bit more specific here } }); Here's my plug-in code (function($){ $.fn.extend({ //pass the options variable to the function grid: function() { return this.each(function() { grid_table=$(this).find('.grid-table > tbody'); grid_hidden_row=$(this).find('.grid-hidden-row'); //console.debug(grid_hidden_row); $(this).find('.grid-add-row').click(function(event) { /* * clone row takes a hidden dummy row, clones it and appends a unique row * identifier to the id. Clone maintains our jQuery binds */ // get the last id last_row=$(grid_table).find('tr:last').attr('id'); if(last_row===undefined) { new_row=1; } else { new_row=parseInt(last_row.replace('row',''),10)+1; } // append element to target, changes it's id and shows it $(grid_table).append($(grid_hidden_row).clone(true).attr('id','row'+new_row).removeClass('grid-hidden-row').show()); // append unique row identifier on id and name attribute of seledct, input and a $('#row'+new_row).find('select, input, a').each(function(id) { $(this).appendAttr('id','_row'+new_row); $(this).replaceAttr('name','_REPLACE_',new_row); }); // disable all the readonly_if_lines options if this is the first row if(new_row==1) { $('.readonly_if_lines :not(:selected)').attr('disabled','disabled'); } }); $(this).find('.grid-remove-row').click(function(event) { /* * Remove row does what it says on the tin, as well as a few other house * keeping bits and pieces */ // remove the parent tr $(this).parents('tr').remove(); // recalculate the order value5 //calcTotal('.net_value ','#gridform','#gridform_total'); // if we've removed the last row remove readonly locks row_count=grid_table.find('tr').size(); console.info(row_count); if(row_count===0) { $('.readonly_if_lines :disabled').removeAttr('disabled'); } }); }); } }); })(jQuery); I've done the usually searching on elgooG... but I seem to be getting a lot of noise with little result, any help would be greatly appreciated. Thanks!

  Read the article

• Attribute Error in django

  - by itsandy

  Hi all, I am having an attribute error while working with django-registration it says 'NoneType' object has no attribute 'strip' I dropped my db table and created again but the error doesnt go..can anyone help..

  Read the article

• T_BOOLEAN_AND error?

  - by Ronnie Chester Lynwood

  whats wrong with this? anybody help me please.. if(stripos($nerde, $hf) !== false) && (stripos($nerde, $rs) !== false){ @mysql_query("update table set dltur = '3' where id = '".$ppl[id]."'"); } else { //dont do anything } i get T_BOOLEAN_AND error.

  Read the article

• SQL Server 2008: Getting duration between user sessions

  - by Nai

  I have this table UserID SessionID SessionStart SessionEnd ----------------------------------------------- 1 abc1 2010-1-1 2010-1-2 5 def3 2010-1-5 2010-1-9 1 llk0 2010-1-10 2010-1-11 5 spo8 2010-1-13 2010-1-15 1 pie7 2010-1-16 2010-1-29 I would like to be able to find the days between the end of one session to the start of the next session for each particular user. So I am looking to get something like UserID DaysBetweenSessions ----------------------------- 1 8 1 5 5 4 Thanks!

  Read the article

• How to set up global connect to datebase in pylons(python), sqlalchemy.

  - by gummmibear

  Hi! I just start lern python, pylons. i have problem with setting up datebase connection. i won't to set connection, where i can see this connection in all my controllers. Now i use: some thing like this in my controller: 45 ' db = create_engine('mysql://root:password@localhost/python') 46 ' metadata = MetaData(db) 47 48 ' email_list = Table('email',metadata,autoload=True) in development.ini i have: 44 sqlalchemy.url = mysql://root@password@localhost/python 45 sqlalchemy.pool_recycle = 3600 and now, pleas help me to set __init__.py

  Read the article

• how do i get the sum of the 4th column

  - by every_answer_gets_a_point

  this statement will generate a 4 column table: SELECT shipped.badguy AS badguy, shipped.sdate AS LineDate, 'Delivery' AS Legend, -price*quantity AS amount FROM product JOIN shipped ON (product.id = shipped.product) UNION SELECT receipt.badguy, receipt.rdate,notes, amount FROM how do i get the total sum of the 4th of column of what the above generates?

  Read the article

• lua split into words

  - by anon

  I have a string in lua. It's a bunch of [a-zA-Z0-9]+ separated by a number (1 or more) spaces. How do I take the string and split it into a table of strings? Thanks!

  Read the article

• *Right* outer join in LINQ

  - by Rap

  Is it safe to say that there is no such thing as a right outer join in LINQ? I know to effectively create one, you'd just swap the tables in a left outer join. But can you apply the DefaultIfEmpty() method to the table on the left side of the equijoin to make it a right outer join?

  Read the article

• generating sequence number

  - by stackoverflowuser

  Hi Based on following TableA Data -------- Dummy1 Dummy2 Dummy3 . . DummyN is there a way to generate sequence number while selecting rows from the table. something like select sequence() as ID,* from Data that will give ID Data --------- 1 Dummy1 2 Dummy2 3 Dummy3 .... N DummyN Thanks.

  Read the article

• changing cell background color in qt

  - by Moayyad Yaghi

  hello .. i'm new to pyqt , and i'm still facing some newbie problems :D i have a QTableWidget that is item delegated on a QChoice control ( hope i said it right ) i need to have the cell background color changes whenever a user change the choice control selection briefly: how to change a cell background color in a table widget ?? i use pyqt4 and python 2.6 thanx in advance

  Read the article

< Previous Page | 631 632 633 634 635 636 637 638 639 640 641 642  | Next Page >