Search Results

Search found 106338 results on 4254 pages for 'code table'.

Page 285/4254 | < Previous Page | 281 282 283 284 285 286 287 288 289 290 291 292  | Next Page >

• lambda vs. operator.attrGetter('xxx') as sort key in Python

  - by Paul McGuire

  I am looking at some code that has a lot of sort calls using comparison functions, and it seems like it should be using key functions. If you were to change seq.sort(lambda x,y: cmp(x.xxx, y.xxx)), which is preferable: seq.sort(key=operator.attrgetter('xxx')) or: seq.sort(key=lambda a:a.xxx) I would also be interested in comments on the merits of making changes to existing code that works.

  Read the article

• Array "tree" creation from db table

  - by Tural Teyyuboglu

  Trying to create array tree for db driven navigation. Getting following errur: array_key_exists() expects exactly 2 parameters, 1 given on line if (!array_key_exists($tree[$parent]['children'][$id])) Function looks like that $tree = array(); $sql = "SELECT id, parent, name FROM menu WHERE parent ... etc.... "; $results = mysql_query($sql) or die(mysql_error()); while(list($id, $parent, $name) = mysql_fetch_assoc($results)) { $tree[$id] = array('name' => $name, 'children' => array(), 'parent' => $parent); if (!array_key_exists($tree[$parent]['children'][$id])) { $tree[$parent]['children'][$id] = $id; } } Db structure How can I fix that? Whats wrong in this function?

  Read the article

• Is it best to code from a blank sheet or improving a code that's already written?

  - by user300371

  Just had a curious thought, but for general coding and programming, do you think it's best to work out all the logic yourself and start from a blank sheet or just take a code that has been written already(by you or someone else) and just change it to your liking? Assuming you have a programming background of like 1year+. (because as a beginner, it's best to learn from nothing) I'm not saying copy+paste someone else's code and say it's yours.

  Read the article

• LINQ2SQL: How to let a column accept null values as zero (0) in Self-Relation table

  - by Remon

  As described in the img, I got a parent-Children relation and since the ParentID not accepting null values (and I can't change to nullabel due to some restriction in the UI I have), how can I remove an existence relation between ReportDataSources in order to change the parent for them (here i want to set the parentId for one of them = 0) how could i do that since i cant change the ParentID directly and setting Parent = null is not valid public void SetReportDataSourceAsMaster(ReportDataSource reportDataSource) { //Some logic - not necessarily for this scenario //Reset Master this.ReportDataSources.ToList().ForEach(rds => rds.IsMaster = false); //Set Master reportDataSource.IsMaster = true; //Set Parent ID for the rest of the Reports data sources this.ReportDataSources.Where(rds => rds.ID != reportDataSource.ID).ToList().ForEach(rds => { //Change Parent ID rds.Parent = reportDataSource; //Remove filttering data rds.FilteringDataMembers.Clear(); //Remove Grouping Data rds.GroupingDataMembers.Clear(); }); //Delete parent HERE THE EXCEPTION THROWN AFTER CALLING SUBMITCHANGES() reportDataSource.Parent = null; //Other logic } Exception thrown after calling submitChanges An attempt was made to remove a relationship between a ReportDataSource and a ReportDataSource. However, one of the relationship's foreign keys (ReportDataSource.ParentID) cannot be set to null.

  Read the article

• International Zip Code Search

  - by Dave

  I implemented a U.S. "find near zip code" search for somebody. The coordinates of U.S. zip codes come from a commercial zip code database. Now, they would like a similar ability for countries other than the U.S. Has anybody implemented something like this for non-U.S. searches? How about general "find close to this address" searches? What commercial data is available?

  Read the article

• SQL SELECT INSERTed data from Table

  - by Noam Smadja

  its in ASP Classic. MS-Access DB. i do: INSERT INTO Orders (userId) VALUES (123)" what i want to retrieve is orderNumber from that row. its an auto-increment number. so i did: SELECT orderNumber FROM Orders WHERE userId=123 but since it is on the same page, the SELECT returns: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. i've seen somewhere RETURNING orderNumber as variable but it was for oracle and i dont know how to implement it into my asp :( set addOrder = Server.CreateObject("ADODB.Command") addOrder.ActiveConnection = MM_KerenDB_STRING addOrder.CommandText = "INSERT INTO Orders (userId) VALUES ("&userId&")" addOrder.CommandType = 1 addOrder.CommandTimeout = 0 addOrder.Prepared = true addOrder.Execute() Dim getOrderNumber Set getOrderNumber = Server.CreateObject("ADODB.Recordset") getOrderNumber.ActiveConnection = MM_KerenDB_STRING getOrderNumber.Source = "SELECT orderNumber FROM Orders WHERE userId=" & userId getOrderNumber.CursorType = 0 getOrderNumber.CursorLocation = 2 getOrderNumber.LockType = 1 getOrderNumber.Open() session("orderNumber") = getOrderNumber.Fields.Item("orderNumber").value

  Read the article

• Help with PHPExcel Library and mySQL data from a table

  - by user547363

  Hello! Everyone.. I have this script $query = "SELECT id,last_name,first_name FROM users WHERE tmima_id='6'"; $result = @mysql_query($query); while($row = mysql_fetch_array($result)) { $i = 3; $emp_id = $row['id']; $cell = 'A'.$i; $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($cell, $row['last_name']. $row['first_name']); $i++; } But in the .xls file it prints only one user. Why id doesnt print all of the users ? W Thanks in advance.

  Read the article

• SE friendly URLs appache code snippets

  - by Dan

  I want example.com/23-45 be transformed to example.com?id=23-45 Could you please post the code I should add to .htaccess file to make this work (Is this everything I should do to make this work - add a piece of code to .htaccess file ???) Thanks a lot!

  Read the article

• how to call the javscript funtion on table row click

  - by kumar

  hi, I have a javascript function.. <script type="text/javascript"> var RowClick = function() { $("#mytable").click( $("#showgrid").load('/Products/List/Items/')); }; </script> Can I call this function on onclick event on tr? I am calling something like this? <tr class="something" onclick="javascript:RowClick()');"> can i call like this? if I call its not loading the URL? can anybody help me out? thanks

  Read the article

• nhibernate, Retrieve the latest row in a table

  - by Blankman

  A user can have many addresses, but I want to retrieve the latest entry for the user. In sql I would do: SELECT TOP 1 * FROM UserAddress WHERE userID = @userID How can I create a criteria query with the same logic? Is there a TOP functionality?

  Read the article

• Where should i store data table [ViewState/ Session/ Catch]

  - by Hemant Kothiyal

  Hi I have datatable having around 10 thousand rows. I would like to store this data once for aspx page. When use select different options in page data would be further select from already stored datatable. I then tried solution using ViewState, but as soon as data grow beyond 100 rows, performance degrade. Where should i store data please help?

  Read the article

• How to modify this c++ code so it doesn't overwrite the whole file

  - by Phenom

  ofstream f("test",app); f.seekp(5,ios::beg); f << "hello world"; f.close(); What I'm trying to do here is open a file that already has data in it, and then put "hello world" somewhere in the middle of the file. However, when I run my code, it overwrites the whole file. How can this code be fixed?

  Read the article

• Lua choose random item from table

  - by Zen

  Seems easy but I just don't get any further: Take this example: local myTable = { 'a', 'b', 'c', 'd' } print( myTable[ math.random( 0, #myTable - 1 ) ] ) Why doesn't it work? Google seems to have no answers on this either

  Read the article

• Retrieving last 10 row inserted in mysql table

  - by Hari kanna

  Retrieving last 10 row inserted

  Read the article

• My MYSQL & PHP while code is out of memory, when there is only one row

  - by Sam

  Hey all, why is this code throwing an out of memory error, when there is only 1 row in the database.. $request_db = mysql_query("SELECT * FROM requests WHERE haveplayed='0'") or die(mysql_error()); $request = mysql_fetch_array( $request_db ); echo "<table border=\"1\" align=\"center\">"; while ( $request['haveplayed'] == "0" ) { echo "<tr><td>"; echo $request['SongName']; echo "</td><td>"; echo "<tr><td>"; echo $request['Artist']; echo "</td><td>"; echo "<tr><td>"; echo $request['DedicatedTo']; echo "</td><td>"; } echo "</table>"; Thanks.

  Read the article

• Query a SharePoint List from InfoPath web form in code

  - by dawsonweb

  I'm writing an InfoPath web form, using C# code behind. The form is a holiday request, after the user inputs the start and end dates I want the code to query a bank-holiday sharepoint list and count occurrences between the dates. I've added the sharepoint list as a second datasource however I'm now stuck. Any ideas?

  Read the article

• How can I run Gcov over an installed Cocoa application?

  - by Joe

  I have a Cocoa application which uses an installer. I want to be able to run code coverage over the code (after it has been installed). This is not the usual unit-test scenario where a single binary will run a suite of tests. Rather, the tests in question will interact with the UI and the app back-end whilst it is running, so I ideally want to be able to start the application knowing that Gcov is profiling it and then run tests against it. Any ideas?

  Read the article

• MYSQL: Copying a table from a snapshot into production

  - by ming yeow

  Hi folks, i have a snapshot of the database that I took before i did some data migration. The data migration messed up, so I want to retrieve the data from the snapshot to migrate over to the production database. Question: How do i access the snapshot, and how do i retrieve the available data? Thanks!

  Read the article

• navigate to calling code..asp.net

  - by Mohan

  Hi Everybody, I want to know that we can use F12 to jump to the function that is called from this code , if i have to return to the code again how I can do this.

  Read the article

• How to configure netbeans to show code completion

  - by user225269

  I've just started to use netbeans IDE 6.8. And consulted youtube for tutorials. And I've seen that the code is being completed just like in dreamweaver. Whenever you type something. And it shows some suggestions on what probably would be the next code. But when I tried it on my computer. It does not do this. How do I configure it?

  Read the article

• SSIS with different table structures

  - by Grace

  I have a flat file source from Excel that has a structure like this: **People** Day1 Day2 Day3 Day4 Person1 someValue ... Person2 Person3 And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at the moment because the days are going along the top, the package is assuming these are seperate data columns when they are not really and the mapping is not working.

  Read the article

• UPDATE Table SET Field

  - by davlyo

  This is my Very first Post! Bear with me. I have an Update Statement that I am trying to understand how SQL Server handles it. UPDATE a SET a.vField3 = b.vField3 FROM tableName a INNER JOIN tableName b ON a.vField1 = b.vField1 AND b.nField2 = a.nField2 – 1 This is my query in its simplest form. vField1 is a Varchar nField2 is an int (autonumber) vField3 is a Varchar I have left the WHERE clause out so understand there is logic that otherwise makes this a nessessity. Say vField1 is a Customer Number and that Customer has 3 records The value in nField2 is 1, 2, and 3 consecutively. vField3 is a Status When the Update comes to a.nField2 = 1 there is no a.nField2 -1 so it continues When the Update comes to a.nField2 = 2, b.nField2 = 1 When the Update comes to a.nField2 = 3, b.nField2 = 2 So when the Update is on a.nField2 = 2, alias b reflects what is on the line prior (b.nField2 = 1) And it SETs the Varchar Value of a.vField3 = b.vField3 When the Update is on a.nField2 = 3, alias b reflects what is on the line prior (b.nField2 = 2) And it (should) SET the Varchar Value of a.vField3 = b.vField3 When the process is complete –the Second of three records looks as expected –hence the value in vField3 of the second record reflects the value in vField3 from the First record However, vField3 of the Third record does not reflect the value in vField3 from the Second record. I think this demonstrates that SQL Server may be producing a transaction of some sort and then an update. Question: How can I get the DB to Update after each transaction so I can reference the values generated by each transaction?

  Read the article

• Any reason to clean up unused imports in Java, other than reducing clutter?

  - by Kip

  Is there any good reason to avoid unused import statements in Java? As I understand it, they are there for the compiler, so lots of unused imports won't have any impacts on the compiled code. Is it just to reduce clutter and to avoid naming conflicts down the line? (I ask because Eclipse gives a warning about unused imports, which is kind of annoying when I'm developing code because I don't want to remove the imports until I'm pretty sure I'm done designing the class.)

  Read the article

• Join with table and sub query in oracle

  - by Amandeep

  I dont understand what is wrong with this query it is giving me compile time error of command not ended properly.The inner query is giving me 4 records can any body help me out. select WGN3EVENTPARTICIPANT.EVENTUID from (Select WGN_V_ADDRESS_1.ADDRESSUID1 as add1, WGN_V_ADDRESS_1.ADDRESSUID2 as add2 from WGN3USER inner join WGN_V_ADDRESS_1 on WGN_V_ADDRESS_1.USERID=wgn3user.USERID where WGN3USER.USERNAME='FIRMWIDE\khuraj' ) as ta ,WGN3EVENTPARTICIPANT where (ta.ADDRESSUID1=WGN3EVENTPARTICIPANT.ADDRESSUID1) AND (ta.ADDRESSUID2=WGN3EVENTPARTICIPANT.ADDRESSUID2) I am running it in oracle. Thanks Amandeep

  Read the article

• Java API for source formatting

  - by Marty Pitt

  Hi There are several PHP or js code formatting libs out there -- does anyone know if similar libs exist in Java? Ie., Given a string of code, return a formatted string with syntax colouring etc. It'd be ideal if it auto detected the language, but I might be pushing my luck there...

  Read the article

< Previous Page | 281 282 283 284 285 286 287 288 289 290 291 292  | Next Page >