Search Results

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

Page 467/943 | < Previous Page | 463 464 465 466 467 468 469 470 471 472 473 474  | Next Page >

• What are the uses for Cross Join?

  - by vanslly

  A cross join performs a cartesian product on the tuples of the two sets. SELECT * FROM Table1 CROSS JOIN Table2 Which circumstances render such an SQL operation particularly useful?

  Read the article

• Using the HTML 'label' tag with radio buttons

  - by GlenPeterson

  Does the label tag work with radio buttons? If so, how do you use it? I have a form that displays like this: First Name: (text field) Hair Color: (color drop-down) Description: (text area) Salutation: (radio buttons for Mr., Mrs., Miss) I'd like to use the label tag for each label in the left column to define its connection to the appropriate control in the right column. But If I use a radio button, the spec seems to indicate that suddenly the actual "Salutation" label for the form control no longer belongs in the label tag, but rather the options "Mr., Mrs., etc." go in the label tag. I've always been a fan of accessibility and the semantic web, but this design doesn't make sense to me. The label tag explicitly declares labels. The option tag selection options. How do you declare a label on the actual label for a set of radio buttons? UPDATE: Here is an example with code: <tr><th><label for"sc">Status:</label></th> <td>&#160;</td> <td><select name="statusCode" id="sc"> <option value="ON_TIME">On Time</option> <option value="LATE">Late</option> </select></td></tr> This works great. But unlike other form controls, radio buttons have a separate field for each value: <tr><th align="right"><label for="???">Activity:</label></th> <td>&#160;</td> <td align="left"><input type="radio" name="es" value="" id="es0" /> Active &#160; <input type="radio" name="es" value="ON_TIME" checked="checked" id="es1" /> Completed on Time &#160; <input type="radio" name="es" value="LATE" id="es2" /> Completed Late &#160; <input type="radio" name="es" value="CANCELED" id="es3" /> Canceled</td> </tr> What to do?

  Read the article

• Problem with LINQ Where Clause

  - by Krishma

  var results = from formNumber in context.DetailTM join c in context.ClaimPeriodTM on formNumber.ClaimPeriod equals c.Cid where formNumber.FormNumber.StartsWith(fNumber) && formNumber.RegistrationNumber != registrationNumber select new { RegNo = formNumber.RegistrationNumber, CP = c.ClaimPeriod, FormNo = formNumber.FormNumber }; The AND CLAUSE with .STARTSWITH Doesn't work. If I use == operator the query works fine. I tried adding brackets to the where clause but it didn't help. Any idea what is missing. Thank you in Advance.

  Read the article

• Convert this Linq query from query syntax to lambda expression

  - by Jinkinz

  I'm not sure I like linq query syntax...its just not my preference. But I don't know what this query would look like using lambda expressions, can someone help? from securityRoles in user.SecurityRoles from permissions in securityRoles.Permissions where permissions.SecurableEntity.Name == "Unit" && permissions.PermissionType.Name == "Read" orderby permissions.PermissionLevel.Value descending select permissions There is a many-to-many relationship between users and security roles that makes this extra confusing. Thanks! Kelly

  Read the article

• Most Efficient Way To Retrieve MYSQL data in random order PHP

  - by Belgin Fish

  Hey, I have a query like so SELECT * FROM table WHERE premium = 3 I'm just wondering how I can have it return a random order for the results! i was told not to use ORDER BY RAND(); because of the amount of system resources it uses. Thanks.

  Read the article

• checkbox for Drupal CCK

  - by artmania

  Hi friends, I'm new at Drupal. love it so far :) I'm creating a CCK custom content type. I need to make a amenities list in checkbox format. so I made; File Type: Text Widget Type: checkboxes/radiobuttons and Allowed values list: onsite_dining|Onsite Dining meeting_space|Meeting Space business_center|Business Center and it creates Radio Buttons which only 1 selection :( How can I make it Check Box to give ability to select more than 1? Appreciate helps!

  Read the article

• Linq to SQL Case WHEN in VB.NET?

  - by EdenMachine

  How do I do a Case WHEN in Linq to SQL (vb.net please). In SQL it would be like this: SELECT CASE WHEN condition THEN trueresult [...n] [ELSE elseresult] END How would I do this in Linq to SQL?

  Read the article

• Read from XML > Add to Listview

  - by Zubirg

  I have some problems getting the data that i read from XML split into seperate columns. Any help this new C# coder would get would be appreciated. XDocument xmlDoc = XDocument.Load("emails.xml"); var t = from c in xmlDoc.Descendants("dt") select (string)c.Element("name") + (string)c.Element("email"); foreach (string item in t) { listView.Items.Add(item); }

  Read the article

• Sql query executing perfectly in phpmyadmin but giving warning while running on page

  - by saurav

  i don't know whats wrong with this sql query. SELECT * FROM main WHERE key LIKE '%$word%' its giving results in phpMyAdmin but giving warning while executing it in a php page. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

  Read the article

• searchlogic and virtual attributes

  - by Ermin

  Let's say I have the following model: Person <AR def name [self.first_name,self.middle_name,self.last_name].select{|n| n.present?}.join(' ') end end How could I do a search on the virtual attribute with searchlogic, something like: Person.search.name_like 'foo' Of courese I could construct a large statement like: Person.search.first_name_like_or_last_name_like_or_... 'argh' but surely there is a more elegant way.

  Read the article

• is there any chance of sql injection through selectbox( dynamically created or static)

  - by I Like PHP

  Hello All, i want to know that is there any chance of SQL injection via selectbox options? if yes then will u please show some demonstration(or refer any link). and also tell me how do we prevent sql injection in selectbox.(using PHP MYSQL) one more: if i create a selectbox dynamically( based on options of another select box) then is there any chance of SQLinjection? Thanking you.

  Read the article

• FIND_IN_SET exists in MySQL but how do I make it in SQLite?

  - by Pentium10

  In MySQL there exists FIND_IN_SET, that locates a match in a comma separated list. mysql> SELECT FIND_IN_SET('b','a,b,c,d'); -> 2 How would I be able to do this in SQLite in query? Please note, that I can't define or add user defined functions, the Android platform doesn't allow it.

  Read the article

• how to refresh/reload dhtmlx grid

  - by steve

  I am using dhtmlx grid.I have two grids named grid1,grid2. I have loaded the two grids using json object. If i select one record in the grid1 and click on the button that record has to load in the second record.I am able to load that selected record in the second grid using document.location.reload(true);with this, the total page is refreshing.but i want to refresh grid2 only. I want to refresh grid2 only after click on the button.how can i refresh/reload grid2.

  Read the article

• How to get array with clear data from Active Record query without using map

  - by Suborx

  Hi I would like to ask if its possible get array with clear data from ActiveRecord query without using map, collect or each. names = User.find(:all, :select => "name") return names == [#<User name:"Peter">,#<User name:"Martin">] and I want names == ["Peter", "Martin"] without using map, collect or each. Thanks for your answers.

  Read the article

• Determine if an Index has been used as a hint

  - by Joe Bloggs

  In SQL Server, there is the option to use query hints. eg SELECT c.ContactID FROM Person.Contact c WITH (INDEX(AK_Contact_rowguid)) I am in the process of getting rid of unused indexes and was wondering how I could go about determining if an index was used as a query hint. Does anyone have suggestions on how I could do this? Cheers, Joe

  Read the article

• generate/get the Xpath for a selected textnode.

  - by ganapati hegde

  Is it possible to get/generate the XPath, for a text selected in the HTML page. Say,I have opened an html file using a browser,say safari/firefox, now i select some text (using mouse), i want to generate/get the xpath for that. is it possible to get it programatically? how?

  Read the article

• prob. with tquery.requestlive

  - by Vijay Bobba

  hi, do any one know how to request a "live result set" in MySQl when query has offset(eg: select * from table where limit 10 offset 20;). it is throughing an error like 'invalid use of key word'. Thanks, Vijay.

  Read the article

• Help to choose NoSQL database for project

  - by potapuff

  There is a table: doc_id(integer)-value(integer) Approximate 100k doc_id and 27?? rows. Majority query on this table - searching documents similar to current document: select 10 documents with maximum of (count common to current document value)/(count ov values in document). Nowadays we use PostgreSQL. Table weight (with index) ~1,5 GB. Average query time ~0.5s. Should I transfer all this to NoSQL base, if so, what?

  Read the article

• sharepoint full text query with attributes missing isn't returning the results I expected

  - by Jason Hocker

  If I am doing a search in sharepoint, some of the results I'm expecting are not being returned. I believe its because in active directory these entries may not have all the fields. So a name that doesn't have the givenName attribute set in active directory is not being returned from this query. Is there a way I can get this to work like I expected? "select LastName, FirstName, PreferredName, AccountName from scope() where \"scope\"='People' AND (LastName like '%" + search + "%' OR FirstName like '%" + search + "%' OR PreferredName like '%" + search + "%')";

  Read the article

• communicating swf files.

  - by Addis Abebayehu

  I have two swf files I would like communicate. I have a videoplaylist.swf and a player.swf. I would like to select a video from videoplaylist.swf and have it played in the player.swf. How do I do that? How am I going to dispatch the click event with the video url to the player.swf? from the videoplaylist.swf. Please help.

  Read the article

• Convert query from native SQL to LINQ request

  - by mike

  Please, help me. How i can translate this SQL query to LINQ request? SELECT TOP (1) PERCENT DATEDIFF(DAY, dbo.PO.ORDER_DATE, GETDATE()) AS Age FROM dbo.ITEMS INNER JOIN dbo.X_PO ON dbo.ITEMS.ITEMNO = dbo.X_PO.ITEM_CODE INNER JOIN dbo.PO ON dbo.X_PO.ORDER_NO = dbo.PO.DOC_NO AND dbo.X_PO.STATUS = dbo.PO.STATUS WHERE (dbo.ITEMS.ITEMNO = 'MBIN001') AND (dbo.X_PO.STATUS = 3) ORDER BY Age

  Read the article

• NPGSQL seems to have a rather large bug?

  - by Mr Shoubs

  Hello, this is a weird one, when I run the following code all rows are returned from the db. Imagaine what would happen if this was an update or delete. Dim cmd As New NpgsqlCommand cmd.Connection = conn cmd.CommandText = "select * FROM ac_profiles WHERE profileid = @profileId" cmd.Parameters.Add("@profile", 58) Dim dt As DataTable = DataAccess2.DataAccess.sqlQueryDb(cmd) DataGridView1.DataSource = dt My question is why is this happening?

  Read the article

• How do you search between two columns using a parameter and a case when statement? SQL Server

  - by Kip Birgen

  I would like to search between to columns in a s query or a table depending on the variable on a paramenter e.g Declare @SelectAll as interger Set @SelectAll = 1 Declare @Column as interger Select mt.Column1, mtColumn2 From MyTable as mt Where Case When @SelectAll = 1 Then mt.Column1 IN(@Column) and mt.Column2 (' Selecting all") When @SelectAll = 1 Then mt.Column2 IN(@Column) and mt.Column1 (' Selecting all") End The purpose of this query is to allow the user to search between the column they choose. Further more the use of parameter is for the purposes of writing reporting services reports.

  Read the article

• How to use regular expression in lxml xpath?

  - by Arty

  I'm using construction like this: doc = parse(url).getroot() links = doc.xpath("//a[text()='some text']") But I need to select all links which have text beginning with "some text", so I'm wondering is there any way to use regexp here? Didn't find anything in lxml documentation

  Read the article

• How to call a scalar function in a stored procedure

  - by Luke101

  I am wacking y head over the problem with this code. DECLARE @root hierarchyid declare @lastchild hierarchyid SELECT @root = NodeHierarchyID from NodeHierarchy where ID = 1 set @lastchild = getlastchild(@root) it says it does not recognize getlastchild function. What am I doing wrong here

  Read the article

< Previous Page | 463 464 465 466 467 468 469 470 471 472 473 474  | Next Page >