Search Results

Search found 23568 results on 943 pages for 'select'.

Page 510/943 | < Previous Page | 506 507 508 509 510 511 512 513 514 515 516 517  | Next Page >

• Specific cast is not valid, while retrieving scope_identity

  - by coure06

  I am getting exception: "Specific cast is not valid", here is the code con.Open(); string insertQuery = @"Insert into Tender (Name, Name1, Name2) values ('Val1','Val2','Val3');Select Scope_Identity();"; SqlCommand cmd = new SqlCommand(insertQuery, con); cmd.ExecuteNonQuery(); tenderId = (int)cmd.ExecuteScalar();

  Read the article

• MySQL: How can fetch SUM() of all fields in ne Query?

  - by takpar

  Hi, I just want somthing like this: select SUM(*) from `mytable` group by `year` any suggestion? (I am using Zend Framework; if you have a suggestion using ZF rather than pure query would be great!)

  Read the article

• FileUpload control event

  - by user321632

  I want to know how to raise an event for fileupload control.... In my project, as soon as I select a file(Image) it should show FILENAME,EXTENSION & SIZE in the labels given below. Pls reply me.... Thanks in advance.

  Read the article

• PHP echo query result in Class??

  - by Jerry

  Hi all I have a question about PHP Class. I am trying to get the result from Mysql via PHP. I would like to know if the best practice is to display the result inside the Class or store the result and handle it in html. For example, display result inside the Class class Schedule { public $currentWeek; function teamQuery($currentWeek){ $this->currentWeek=$currentWeek; } function getSchedule(){ $connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); if (!$connection) { die("Database connection failed: " . mysql_error()); } $db_select = mysql_select_db(DB_NAME,$connection); if (!$db_select) { die("Database selection failed: " . mysql_error()); } $scheduleQuery=mysql_query("SELECT guest, home, time, winner, pickEnable FROM $this->currentWeek ORDER BY time", $connection); if (!$scheduleQuery){ die("database has errors: ".mysql_error()); } while($row=mysql_fetch_array($scheduleQuery, MYSQL_NUMS)){ //display the result..ex: echo $row['winner']; } mysql_close($scheduleQuery); //no returns } } Or return the query result as a variable and handle in php class Schedule { public $currentWeek; function teamQuery($currentWeek){ $this->currentWeek=$currentWeek; } function getSchedule(){ $connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); if (!$connection) { die("Database connection failed: " . mysql_error()); } $db_select = mysql_select_db(DB_NAME,$connection); if (!$db_select) { die("Database selection failed: " . mysql_error()); } $scheduleQuery=mysql_query("SELECT guest, home, time, winner, pickEnable FROM $this->currentWeek ORDER BY time", $connection); if (!$scheduleQuery){ die("database has errors: ".mysql_error()); // create an array } $ret = array(); while($row=mysql_fetch_array($scheduleQuery, MYSQL_NUMS)){ $ret[]=$row; } mysql_close($scheduleQuery); return $ret; // and handle the return value in php } } Two things here: I found that returned variable in php is a little bit complex to play with since it is two dimension array. I am not sure what the best practice is and would like to ask you experts opinions. Every time I create a new method, I have to recreate the $connection variable: see below $connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); if (!$connection) { die("Database connection failed: " . mysql_error()); } $db_select = mysql_select_db(DB_NAME,$connection); if (!$db_select) { die("Database selection failed: " . mysql_error()); } It seems like redundant to me. Can I only do it once instead of calling it anytime I need a query? I am new to php class. hope you guys can help me. thanks.

  Read the article

• Is there any query in sqlite to choose a substring ?

  - by john terry

  Hey, Lets say I have a table Y with column X. There is one row of "X" with the string "abcdefg", and another row with "qwerty". Can I make a SELECT query in sqlite to choose the row which contains the substring "abcd" ? Thanks in advance.

  Read the article

• How to rebuild Safari Web Clip functionality in PHP

  - by Mayko

  Hi there, is there a way to rebuild Mac OSX Snow Leopard's Dashboard Widget 'Web Clip' on a PHP website? Something like a crawler or scraper. I thought about using file_get_contents to getting the page content into the page, but how do I select a section on the external page? And does this work with session/login content as well? I'm happy for any kind of suggestions! Cheers

  Read the article

• Ado.net entity model problem

  - by ognjenb

  public ActionResult Index() { using (testEntities korisnici = new testEntities()) { my_aspnet_users user = new my_aspnet_users(); user = from i in korisnici.my_aspnet_users select i; return View(user); } } Error: Cannot implicitly convert type 'System.Linq.IQueryable' to 'MyApp.Models.my_aspnet_users'. An explicit conversion exists (are you missing a cast?)

  Read the article

• Improve long mysql query

  - by John Adawan

  I have a php mysql query like this $query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10"; As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing. But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit. Let's discuss how we can improve on such long query.

  Read the article

• Improve long mysql query

  - by John Adawan

  I have a php mysql query like this $query = "SELECT * FROM articles FORCE INDEX (articleindex) WHERE category='$thiscat' and did>'$thisdid' and mid!='$thismid' and status='1' and group='$thisgroup' and pid>'$thispid' LIMIT 10"; As optimization, I've indexed all the parameters in articleindex and I use force index to force mysql to use the index, supposedly for faster processing. But it seems that this query is still quite slow and it's causing a jam and maxing out the max mysql connection limit. Let's discuss how we can improve on such long query.

  Read the article

• Sorting string column containing numbers in SQL?

  - by Ish

  Dear Folks, I am trying to sort string column (containing numbers). // SELECT `name` FROM `mytable` ORDER BY `name` ASC +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 12 --+ +-- a 2 ---+ +-- a 3 ---+ You see natural sorting algorithm of Mysql is placing a 12 after a 1 (which is ok for most apps), But I have unique needs, so I want result should be sorted like this. +----------+ +-- name --+ +----------+ +-- a 1 ---+ +-- a 2 ---+ +-- a 3 ---+ +-- a 12 --+ Is it possible with just SQL, or I have to manipulate result-set at application level? Thanks for reading...

  Read the article

• Hibernate using OneToOne

  - by Soft

  I have two tables tab1 { col1 (PK), col2, col3 } tab2 { col1, col2(PK), col3 } I am using Hibernate annotation for joining using "OneToOne" I have the below Hibernate class for tab1 class tab1 { @OneToOne @JoinColumn(name = "col2", referencedColumnName = "col1") private tab2 t2; } i was expecting to run the below sql select * from tab1 t1, tab2 t2 where t1.col1 = t2.col2 But it is not working as i expected.Please help

  Read the article

• jQuery $(this) selector and children?

  - by Alex

  I'd like to use a selector to select the child img of the div I'm clicking on this example: <div id="..."><img src="..."></div> To get the div, I've got this selector: $(this) How do I get the img with a selector?

  Read the article

• What is the best way to use MySQL full-text search with a self-join?

  - by gersh

  I want to do something like: select a.a_ft,count(b.a_ft) FROM row a JOIN row b on match a.a_ft against (b.b_ft). However, this isn't legal. Basically, I just want to look for similar phrases in my database. What is the easiest way to do this?

  Read the article

• Committing Transaction

  - by Costa

  Hi http://msdn.microsoft.com/en-us/library/ms189797.aspx In this link they are committing a transaction within catch clause IF (XACT_STATE()) = 1, I don't get it, if there is an error why they are committing it? even if the problem in select statement and there is no big deal committing it, why don't just roll it back. Thanks

  Read the article

• Good way to deal with comma seperated values in oracle

  - by dmitry

  I am getting passed comma seperated values to a stored procedure in oracle. I want to treat these values as a table so that I can use them in a query like: select * from tabl_a where column_b in (<csv values passed in>) What is the best way to do this in 11g? Right now we are looping through these one by one and inserting them into a gtt which I think is ineffecient. Any pointers?

  Read the article

• We hear: Order by Rand() is bad for large tables. But how many rows is large?

  - by ggg

  I use order by rand() LIMIT 1. I have a database with 150,000 rows and I'm getting split second results after a select of three tables. If I stay under a million rows, am I going to be OK? At what point should I consider upgrading my code to something more sophisticated?

  Read the article

• question about group by

  - by chun

  Hi in mysql how to write a sql like this, to get the amount of X 20 and <20 select date, numberOfXMoreThan20,numberOfXLessThan20, otherValues from table group by (date, X20 and X<20) thanks

  Read the article

• UIView animation in different way?

  - by senthilmuthu

  Hi, If you see the URL in TRY ME simulator select cardex tab,if u scroll vertically on simulator(flash),the no of uiviews are coming,if u touch anything, it will be shown,any idea to do this ,have they used OPENGL? please any help?

  Read the article

• Listview Multiple Selection

  - by Evan

  Is there any way to force a listview control to treat all clicks as though they were done through the Control key? I need to replicate the functionality of using the control key (selecting an item sets and unsets its selection status) in order to allow the user to easily select multiple items at the same time. Thank you in advance.

  Read the article

• how to bind gridview through linq

  - by Manoj Wadhwani

  I am using linq to sql Currently i am binding gridviw through linq which query written in business logic call . i have extract record through query in business logic class and i want to bind that particular data to gridviw and return data . how to retrun data which type is array. code is mention below: CMSBusiness.DataClasses1DataContext db = new DataClasses1DataContext(); var cate = from p in db.categoryTables select new { categoryId=p.categoryId, categoryName=p.categoryName, categoryDesc=p.categoryDesc }; how to return value and bind gridview , Please suggest

  Read the article

• KnockoutJS showing a sorted list by item category

  - by Darksbane

  I just started learning knockout this week and everything has gone well except for this one issue. I have a list of items that I sort multiple ways but one of the ways I want to sort needs to have a different display than the standard list. As an example lets say I have this code var BetterListModel = function () { var self = this; food = [ { "name":"Apple", "quantity":"3", "category":"Fruit", "cost":"$1", },{ "name":"Ice Cream", "quantity":"1", "category":"Dairy", "cost":"$6", },{ "name":"Pear", "quantity":"2", "category":"Fruit", "cost":"$2", },{ "name":"Beef", "quantity":"1", "category":"Meat", "cost":"$3", },{ "name":"Milk", "quantity":"5", "category":"Dairy", "cost":"$4", }]; self.allItems = ko.observableArray(food); // Initial items // Initial sort self.sortMe = ko.observable("name"); ko.utils.compareItems = function (l, r) { if (self.sortMe() =="cost"){ return l.cost > r.cost ? 1 : -1 } else if (self.sortMe() =="category"){ return l.category > r.category ? 1 : -1 } else if (self.sortMe() =="quantity"){ return l.quantity > r.quantity ? 1 : -1 }else { return l.name > r.name ? 1 : -1 } }; }; ko.applyBindings(new BetterListModel()); and the HTML <p>Your values:</p> <ul class="deckContents" data-bind="foreach:allItems().sort(ko.utils.compareItems)"> <li><div style="width:100%"><div class="left" style="width:30px" data-bind="text:quantity"></div><div class="left fixedWidth" data-bind="text:name"></div> <div class="left fixedWidth" data-bind="text:cost"></div> <div class="left fixedWidth" data-bind="text:category"></div><div style="clear:both"></div></div></li> </ul> <select data-bind="value:sortMe"> <option selected="selected" value="name">Name</option> <option value="cost">Cost</option> <option value="category">Category</option> <option value="quantity">Quantity</option> </select> </div> So I can sort these just fine by any field I might sort them by name and it will display something like this 3 Apple $1 Fruit 1 Beef $3 Meat 1 Ice Cream $6 Dairy 5 Milk $4 Dairy 2 Pear $2 Fruit Here is a fiddle of what I have so far http://jsfiddle.net/Darksbane/X7KvB/ This display is fine for all the sorts except the category sort. What I want is when I sort them by category to display it like this Fruit 3 Apple $1 Fruit 2 Pear $2 Fruit Meat 1 Beef $3 Meat Dairy 1 Ice Cream $6 Dairy 5 Milk $4 Dairy Does anyone have any idea how I might be able to display this so differently for that one sort?

  Read the article

• How can I uninstall NetBeans on a mac?

  - by Henri W

  I currently have NetBeans 6.5 installed on my mac running leopard. I searched Google on how to uninstall it and the NetBeans website says to right click on it, select "Show Package Contents" and the uninstaller should be there, but it isn't. How can I completely uninstall NetBeans in this situation? Thanks!

  Read the article

• How do I update a column in 3rd row the same as a column in 2nd row in MySQL?

  - by user198729

  I'm doing it this way,but get an error: mysql> update products set products_image=(select products_image from products where products_id=2) where products_id=3; ERROR 1093 (HY000): You can't specify target table 'products' for update in FROM clause

  Read the article

• Problems with jQuery .not() and the draggable ui

  - by Chris

  Okay, when something is draggable, it is given the class .ui-draggable And when something is disabled from being draggable .ui-draggable-disabled I want to select only items that are draggable. I'm using the following selector, but it doesn't seem to work. My disabled draggable items are still doing something on hover. Any ideas why? $('.ui-draggable').not('.ui-draggable-disabled').hover(function() { // rest of code Thanks

  Read the article

• Php/Mysql - need help to insert and update multiple rows with a single query

  - by Guanche

  Hello, is there any way how in this situation insert and update DB with single queries? $message = 'Hello to all group members'; $userdata = mysql_query("SELECT memberid, membernick FROM members WHERE groupid='$cid'") or die('Error'); while(list($memberid, $membernick) = mysql_fetch_row($userdata)) { $result1 = mysql_query("INSERT INTO messages VALUES (NULL,'$membernick', '$memberid', '$message')") or die('Error'); $result2 = mysql_query("UPDATE users SET new_messages=new_messages+1, total_messages=total_messages+1 WHERE id='$memberid'") or die('Error'); }

  Read the article

< Previous Page | 506 507 508 509 510 511 512 513 514 515 516 517  | Next Page >