Search Results

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

Page 528/943 | < Previous Page | 524 525 526 527 528 529 530 531 532 533 534 535  | Next Page >

• Doctrine: how to create a query using "LIKE REPLACE" ?

  - by user248959

  Hi, this SQL clause is working OK: SELECT * FROM `sf_guard_user` WHERE nombre_apellidos LIKE REPLACE('Mar Sanz',' ','%') Now I'm trying to write this query for Doctrine. I have tried this: $query->andWhere(sprintf('%s.%s LIKE REPLACE (?," ","%")', $query->getRootAlias(), $fieldName), 'Mar Sanz')); but I get this error: Warning: sprintf() [function.sprintf]: Too few arguments Any idea? Regards Javi

  Read the article

• Speed up :visible:input selector avoiding filter

  - by macca1

  I have a jQuery selector that is running way too slow on my unfortunately large page: $("#section").find(":visible:input").filter(":first").focus(); Is there a quicker way to select the first visible input without having to find ALL the visible inputs and then filtering THAT selection for the first? I want something like :visible:input:first but that doesn't seem to work.

  Read the article

• JavaScript + Adding items into dropdown

  - by Panther24

  I have two dropdowns in my JSP page 1. lstA test1 test2 test3 test4 2. lstB Now on selection of lstA, I want to populate all the items of lstA into lstB except the select one, also the content of lstA should remain the same. How can I achieve this? I tried to do it, but from lstA some random items get removed, which is quite wired.

  Read the article

• asp.net dropdown list postback to anchor

  - by The Talking Walnut

  How can I go to an anchor tag on the page when the myDropDownList_SelectedIndexChanged() event fires? I am using regular ASP.NET Forms. Update: The following is valid for an ASP.NET Button. I would like to achieve the same functionality (going to #someAnchor) when I select an option from the Dropdown list. <asp:Button ID="btnSubmit" runat="server" Text="Do IT" Width="186px" PostBackUrl="#myAnchor" CausesValidation="false" />

  Read the article

• ruby yaml ypath like xpath ?

  - by gurpal2000

  Hi i have a yaml file like so --- data: - date: "2004-06-11" description: First description - date: "2008-01-12" description: Another descripion How can i do a "ypath" query similar to xpath for xml ? Something like "get the description where the date is 2004-06-11" YAML.parse_file('myfile.yml').select('/data/*/date == 2004-06-11') How do you do it, and if that's possible how can i similarly edit the description by 'ypath' ? Thanks

  Read the article

• Operation precedence on postgress

  - by user24691

  I have set new division on postgress pg_operator table because i want tath when is division by zero return 0. i have write this: create operator / ( procedure = zero_division, leftarg = double precision, rightarg = double precision); where zero_division is: CREATE OR REPLACE FUNCTION zero_division(double precision, double precision) RETURNS double precision AS 'select case when $2 = 0 then 0 else $1 / $2::real end;' LANGUAGE sql IMMUTABLE COST 100; when i run value/ 0 i get error of division.

  Read the article

• Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '.

  - by sajad

  i am trying to query from a temp table,and i keep getting the message Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '. can somebody tell me wats the problem..is it due to convert.. plz help The query is select compid,2, convert(datetime, '01/01/' + CONVERT(char(4),cal_yr) ,101) ,0,  Update_dt, th1, th2, th3_pc , Update_id, Update_dt,1 from #tmp_CTF

  Read the article

• How to put comma in counted numbers?

  - by Ronnie Chester Lynwood

  hey huys im counting my table with this code: $county = mysql_query("SELECT COUNT(id) from table where type = 'application'"); $county = mysql_result($county, 0); $applications = ''.$county.''; this give me result like 1156563. but I want to see it like 1,156,563 with commas. how can i do this?

  Read the article

• How do you do a 'like' query in appengine JPA?

  - by Mark M

  I know there is a limited version of a LIKE query in the App engine's datastore where you can only search on the end of a string but I can't seem to find the syntax. I want to do something like this SELECT * FROM MyTable WHERE name LIKE ji%

  Read the article

• running query and putting result into a variable ACCESS

  - by every_answer_gets_a_point

  i am running a query from vba editor access: "select max(somerow) from sometable" i want to put the result of this query into a variable. how do i do it?

  Read the article

• How to use the IN operator in linq

  - by Hallaghan

  I'm querying a view and filtering the results with a column named status. I'd like to query it so I can search for rows with different status, by using the IN operator as I'd do in SQL. As so: SELECT * FROM VIEW WHERE Status in ('....', '.....') How can I achieve this?

  Read the article

• How can I get Eclipse to insert tabs instead of spaces for Java content assist?

  - by Simon Nickerson

  Is there any way to persuade Eclipse to use tabs instead of spaces for indenting its built-in Java content assist proposals (such as when creating an empty method which overrides a method in the parent class)? The only setting I could find that looked relevant is in Windows/Preferences/General/Editors/Text Editors/Insert spaces for tabs, and this setting is unchecked. At the moment I have to remember to select them and re-format with <Ctrl>+<Shift>+<F>.

  Read the article

• Anyone know a working CSS selector hack that works in recent Safari but not chrome ?

  - by user318144

  The title sums it up. I'll get this out of the way and say I am aware that css hacks are dirty ugly horrible things. Sometimes dirty problems call for dirty solutions though :) So does anyone know of a css selector hack that works for recent safari versions but is not a general webkit hack ? My site behaves properly in chrome but has a bug in safari. So if anyone knows how i can select an element to only have a certain style in safari let me know!

  Read the article

• How to find all points away from some polygon?

  - by Z77

  What I need is to find all points away from rectangle for 10km. Points geometry is the_geom1, rectangles (polygon) geometry is the_geom2. SRID of them is 4258. I tried: SELECT * FROM table1,table2 WHERE ST_DWithin(table1.the_geom1,table2.the_geom2,10000) and table1.gid=2; But the result is not Ok.

  Read the article

• Equivalent lambda syntax for linq query

  - by ilias

  Hi, I am having a mind-freeze here, but I cant seem to find the equivalent lambda syntax for - string[] a = {"a","b","c"}; string[] b = {"1","2","3"}; var x = from a1 in a from b1 in b select new{a1, b1};

  Read the article

• Problem with libxml2 and Unicode char in XML Soap with Qotes (") and &amp;quot;

  - by x2on

  I'm using libxml2 for SOAP-Actions in an iPhone App. The big problem is that i want send an SQL-Statement with NSString *query = @"SELECT test FROM database WHERE test = \"string\"" But libxml2 converts the qotes " into &amp;quot; Any ideas how to prevent this?

  Read the article

• Unknown column '' in 'field list'

  - by Rixius

  I am running a sql in PHP query that is dieing with the mysql_error() of Unknown column '' in 'field list' The query: SELECT `standard` AS fee FROM `corporation_state_fee` WHERE `stateid` = '8' LIMIT 1 when I run the query in PHPmyadmin, it return the information without flagging the error

  Read the article

• Accessing child collection in query

  - by Gokul

  I am populating a list using List<Country> countries = new List<Country> { new Country() { CountryID = "US", City = new List<City> { new City() { CountryID = "US", CityName="dfdsf", sqkm = 2803 } } }; and so on How to access sqkm in the following query? var countryQuery = countries .Select(c => new { Id = c.CountryId, Area = c.City.sqkm???}); c.city.sqkm gives compilation error...how to modify query

  Read the article

• Problem in sql query

  - by Vishwa

  Hi I have 2 tables Order and orderDetails table... I have written a inner join SELECT Order.id FROM Order INNER JOIN orderDetails ON Order.id=orderDetails.id I have got the output as id 100 100 100 101 101 from the above data i want the count of each record OUTPUT AS : id count 100 3 101 2 help me i am new to sql

  Read the article

• How to save datagridview columns with datas in sql server database

  - by Shiny

  Scenario is.... I have to select a row in datagridview and save those datas to database.It can any number of columns present. how to achieve this..

  Read the article

• In Asp.net (c#) i'm not able to catch any exception properly????

  - by Anand

  In Asp.net (c#),i'm not able to catch exception(FileNotFoundException) properly... i don't know the reason..Actually File s not there..But catch statement fails to catch the exception.. here is the code.. try { System.Drawing.Image imgg1 = System.Drawing.Image.FromFile(Server.MapPath("").ToString() + "\\images\\img1.jpg"); } catch (FileNotFoundException) { Response.Write("<script>alert('Please Select and upload Student's Photo');</script>"); }

  Read the article

• What is the best 3-D technology for the "Online Room Planner" site?

  - by Omega

  The main user-case is: Create the 2D floor plan See the 3D view of the room in colors and in dynamic lighting (switching on and off the lamps) Select the furniture from the large library of predefined samples. Change the color and texture of the furniture samples. Create the photos of the 3D room view from different points. Also user can move and turn the camera in the room and discover the view.

  Read the article

• How to use pdo's prepared statement for order by and limit ?

  - by user198729

  $sql = "SELECT * FROM table ORDER BY :sort :dir LIMIT :start, :results"; $stmt = $dbh->prepare($sql); $stmt->execute(array( 'sort' => $_GET['sort'], 'dir' => $_GET['dir'], 'start' => $_GET['start'], 'results' => $_GET['results'], ) ); I tried to use prepare to do the job,but $stmt->fetchAll(PDO::FETCH_ASSOC); returns nothing.

  Read the article

• Drupal best way to change text

  - by booze2go

  Hi Guys, I'm using the module "simplenews" and during the registration process it reads "Select the newsletter(s) to which you wish to subscribe.". I'd like to change this line and wanted to ask what the best way is to do so without hard coding it? Thanks in advance!

  Read the article

• Delete duplicate rows, do not preserve one row

  - by Radley

  I need a query that goes through each entry in a database, checks if a single value is duplicated elsewhere in the database, and if it is - deletes both entries (or all, if more than two). Problem is the entries are URLs, up to 255 characters, with no way of identifying the row. Some existing answers on Stackoverflow do not work for me due to performance limitations, or they use uniqueid which obviously won't work when dealing with a string. Long Version: I have two databases containing URLs (and only URLs). One database has around 3,000 urls and the other around 1,000. However, a large majority of the 1,000 urls were taken from the 3,000 url database. I need to merge the 1,000 into the 3,000 as new entries only. For this, I made a third database with combined URLs from both tables, about 4,000 entries. I need to find all duplicate entries in this database and delete them (Both of them, without leaving either). I have followed the query of a few examples on this site, but whenever I try to delete both entries it ends up deleting all the entries, or giving sql errors. Alternatively: I have two databases, each containing the separate database. I need to check each row from one database against the other to find any that aren't duplicates, and then add those to a third database. Edit: I've got my own PHP solution which is pretty hacky, but works. I cannot answer my own question for 8 hours because I'm new, so here it is for now: I went with a PHP script to accomplish this, as I'm more familiar with PHP than MySQL. This generates a simple list of urls that only exist in the target database, but not both. If you have more than 7,000 entries to parse this may take awhile, and you will need to copy/paste the results into a text file or expand the script to store them back into a database. I'm just doing it manually to save time. Note: Uses MeekroDB <pre> <?php require('meekrodb.2.1.class.php'); DB::$user = 'root'; DB::$password = ''; DB::$dbName = 'testdb'; $all = DB::query('SELECT * FROM old_urls LIMIT 7000'); foreach($all as $row) { $test = DB::query('SELECT url FROM new_urls WHERE url=%s', $row['url']); if (!is_array($test)) { echo $row['url'] . "\n"; }else{ if (count($test) == 0) { echo $row['url'] . "\n"; } } } ?> </pre>

  Read the article

< Previous Page | 524 525 526 527 528 529 530 531 532 533 534 535  | Next Page >