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

• 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

• 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

• 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

• jquery/ajax post() in a posted page

  - by haltman

  hi everybody, I have a page with a div, inside this div I load a page with a form with a select, I can get selected option by post() function but, how can I get at the same time selected option and full data option? I've tried to get full data with a post() in a click() function positioned directly on form page but it does not work, can I post 2 times on the same page(one for get selected option and one for full data option)? thanks in advance ciao, h.

  Read the article

• Table is realigned after setting the display property to 'block'

  - by Holicreature

  I'm having a table and i have a row which is initially set to the display property of 'none' and i changing it to 'block' at some selection of value from my select box , at that point of time the row is not aligned properly. My two columns are set inside a single column of the above row? but when i change it again to 'none' all the other rows are aligned correctly..

  Read the article

• Nokogiri (Ruby) and XPath

  - by JP

  Does Nokogiri only support XPath 1.0? I'm trying to do simple string replacement in a value-of cell, like so (where element contains something like '* My string (useless text)') <xsl:value-of select="replace(element,'^\*\ (.+)\ \(.*\)$','\\1')"> Is this poorly formed XSL? Or is there a limitation with Nokogiri?

  Read the article

• how to return some default value in oracle cursor when nothing is found

  - by john

  I have following statement in one of the oracle SP: OPEN CUR_NUM FOR SELECT RTRIM(LTRIM(num)) as num FROM USER WHERE USER_ID = v_user_id; When the above does not return anything the SP result just has no column name in it. But I'd like the cursor to still have num column with some default value like NOTHING when no data is found. Is this doable ?

  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

• 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

• 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 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

• 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

• Disable mobile textbox popup while taping on a textbox

  - by Vishal Suthar

  I have used Kendo UI Multiselect control and it is working fine. But I have one issue now that if I tap on a textbox for selecting different values then the default mobile textbox popup window come up which I want to prevent. I tried Readonly="true" but that will simply disable the function and not able to select any values from that. So I want to prevent this input window when I click on a textbox.

  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

• 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

• 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

• Get a list of the last 10 Mondays

  - by Jonesy

  Hi folks, I wanna have a drop down that lets me select "Week Commencing Monday the 20th" going back 10 Mondays but I'm not sure how to go about doing this. I've used date.now(), etc. before but not sure how to do this one. Thanks, Billy

  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 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

• Can I override a query in DJango?

  - by stinkypyper

  I know you can override delete and save methods in DJango models, but can you override a select query somehow to intercept and change a parameter slightly. I have a hashed value I want to check for, and would like to keep the hashing internal to the model.

  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

• SQL SERVER 2005 Self Joins output

  - by user301751

  HI I am looking for some help I just can't seem to get my head how self joins work. I have this sql code select Persno'Name',convert(char(20), A_Date , 13)'Logins',acode from atrail as LOGIN where acode = 'LOGIN' OR acode = 'LOGOUT' order by a_date desc Which produces a list of User names and when the have logged in and out. What I am trying to acheive is to get anther column with the LOGOUT date next to the date they logged in date so that it is easyer to see when they logged in and out. Thanks Andy

  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

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