Search Results

Search found 43145 results on 1726 pages for 'sql select'.

Page 158/1726 | < Previous Page | 154 155 156 157 158 159 160 161 162 163 164 165  | Next Page >

• jQuery toggle div from select option

  - by Jeffrey

  I'm in need to toggle divs from a dropdown select option box. I'd like it similar to asmselect for jquery but instead of listing the option tag I'd like it to display a hidden div. Is there anything like this out there? Or anyone know how to set it up? Thanks, Jeff.

  Read the article

• C# : Filtering data of data table using select method

  - by Royson

  I have data table containing one column as FilePath. FilePath D:\New folder\link.txt D:\New folder\SharepointMigration(Work Schedule).xls D:\New folder\my2\link.txt D:\New folder\my2\SharepointMigration(Work Schedule).xls D:\New folder\my2\my3\New Text Document.txt D:\New folder\Try.txt I am filtering my data table by DataRow[] dtRow = dataTable_FilesWithMetaData.Select("FilePath Like '" + sourcePath + "%'"); But it gives me all files and subfolder files. But i want only files not subfolders. How to write such type of filter expression..??

  Read the article

• Select Case on an object's Type in VB.Net

  - by mcjabberz

  I'm not sure if this valid C# but hopefully you get the idea. :) switch (msg.GetType()) { case ClassA: // blah case ClassB: // blah 2 case ClassC: // blah 3 } How would I switch on an object's type but using VB.NET's Select Case? I'm aware that some might suggest using polymorphism but I'm using a hierarchy of small message classes so that really wouldn't work in my csae.

  Read the article

• count total records after groupBy select

  - by solomongaby

  Hello, I have a mysql select query that has a groupBy. I want to count all the records after the group by statement. Is there a way for this directly from mysql ? thanks.

  Read the article

• SELECT INTO and "Undeclared variable" error

  - by hsz

  Hello ! When I try to execute following querry: SELECT id_subscriber INTO newsletter_to_send FROM subscribers I get an error: #1327 - Undeclared variable: newsletter_to_send What is wrong with that query ?

  Read the article

• How to select from datetime in sqlite?

  - by Sein Kraft

  Joined is a datetime data type column in the database and dates are saved as '12/05/2010 15:54:32' This my query: SELECT * FROM users WHERE joined BETWEEN '12/05/2010 00:00:00' AND '12/05/2010 59:59:59' ORDER BY id ASC But it doesn't work. It returns no rows. So how i gan get them?

  Read the article

• Select and delete selected

  - by Donator

  I am programming something like e-mail for my users. I want to allow people to select letters and delete selected. How can I do it? I can't imagine how can I do it only with one MySQL query. Is it even possible?

  Read the article

• Need help in Select query..

  - by Parth

  If I have four rows for a field with different values with other fields similar and then other four rows with same condition, as given below here u can see there different rows for insert with only difference in the "newvalue" and "field" excluding "id" for the table_name=jos_menu, operation=INSERT and live=0 now here what select query should be used to get only single row from the table on every change of table_name...??

  Read the article

• MySQL SELECT Statment issue

  - by mouthpiec

  Hi, I have the following query which returns 2 tuples SELECT bar_id, bar_name, town_name, bar_telephone, subscription_type_id, type FROM towns, subscriptiontype, regions, bar LEFT JOIN barpictures bp ON bar.bar_id = bp.bar_id_fk WHERE town_id = town_id_fk AND bar.test_field = 0 AND subscription_type_id = subscription_type_id_fk AND region_id = region_id_fk AND (type like 'logo%' OR type IS NULL) The main difference between the tuples is that one has 'type' = logo and the other tuple has 'type' = logo_large. I need that instead of having two tuples, I need that I have 2 type attributes, one holding the "logo" and the other the "logo_large" eg bar_id, bar_name, town_name, bar_telephone, subscription_type_id, type1, type2 is this possible

  Read the article

• Multi-Select Dropdown with size of 1

  - by Thomas

  Is there any way of creating a combo box (<select>) with a size of 1? All the examples I can find allow for multiple selects but with a number of options visible at any one time. If this cannot be accomplished with bog standard HTML is it possible in a JS library such as JQuery?

  Read the article

• C# datagridview right click select row and show menu to delete it

  - by Data-Base

  Hello, I have few columns in my DataGridView, and there is data in my rows, I saw few solutions in here, but I can not combine them! simply a way to right-click on a row it select the whole row and show a menu with an option to delete the row and when the option selected it will delete the row I made few attempts but none is working and it looks messy any suggestions? cheers

  Read the article

• Select All button WPF DataGrid

  - by urema

  Hi, I was wondering if there is anyway of disabling the select all options on the top corner of the WPF DataGrid....this only seems to occur when I add a UserControl to a fixeddocument in WPF. Thanks in advance, U.

  Read the article

• Javascript focus and select not working in FF

  - by Metropolis

  Hey guys, Using jQuery, the following is not working in FF, but it is in IE $(this).focus().select(); I looked around for this and found that you could use a timeout to get around this, but that is not something I want to do if I can avoid it. Does anyone know another way to do this and have it work in FF? Metropolis

  Read the article

• Prototype set selected option based on other select

  - by xain

  Hi, how can I "copy" the selected option between two s that have the same options using prototype ? I tried getting the selected option from the "master" combo using function getSelectedArea() { $$('#areacont1 option').find(function(ele){return !!ele.selected}) } which returns null And setting the second combo using var c2ROptions = $$('select#areacont2 option') c2ROptions[getSelectedArea()].selected = true That obviously doesn't work because the function returns null. Any hints? Thanks.

  Read the article

• select multiple double side

  - by Mercer

  hello, i want to do a select multiple double side like this : http://www.senamion.com/blog/jmultiselect2side.html (Demo2) but i don't know how i can retrieve my data when i click submit button..?

  Read the article

• How UPDATE and SELECT at the same time

  - by xRobot

  I need to update some rows of the tables and then display these rows. Is there a way to do this with one single query and avoid this 2 query ? : UPDATE table SET foo=1 WHERE boo=2 SELECT * from table WHERE ( foo=1 ) AND ( boo=2 )

  Read the article

• CSS Doozie: Replacing BG Image on SELECT dropdown

  - by ToiletOverflow

  I need to be able to change the background-image property of a SELECT drop-down using JavaScript/CSS. We have been able to accomplish this in Firefox, but it doesn't appear to be supported at all in IE. From what I've read, IE won't support this. But I'm wondering if there's anything else I could try. Does anyone here have any recommendations?

  Read the article

• MySQL Select distinct values across multiple tables..

  - by PoorCoder

  I have two tables: table_1 uid | xid | name table_2 uid | elements | time I want to select xid, elements and time where time is the least and uid (or xid) is distinct.

  Read the article

• MySQL select one field from table WHERE condition is in multiple rows

  - by Alex

  Tried to find the answer, but still couldn't.. The table is as follows: id, keyword, value 1 display 15.6 1 harddrive 320 1 ram 3 So what i need is something like this.. Select an id from this table where (keyword="display" and value="15.6") AND (keyword="harddrive" and value="320") There's also a possibility that there will be 3 or 4 such keyword conditions which should result into returning one id (one row) It seems there's something to deal with UNION but i didn't use it before so i can't figure it out Thanks in advance

  Read the article

• MySQL get variable from SELECT

  - by rlb.usa

  MySQL keeps saying my syntax is incorrect. I want to do this: DELIMITER $$ DROP PROCEDURE IF EXISTS `myprocedure` $$ CREATE DEFINER=`db`@`%` PROCEDURE `myprocedure`( var_name varchar(10) ) BEGIN /* syntax errors below */ DECLARE countTemp integer; SET countTemp=(SELECT COUNT(Name) FROM mytable WHERE Name= var_name); /* more stuff */ END $$ DELIMITER ; What's the correct syntax?

  Read the article

• IE font size decrease does not cause select box height to decrease

  - by leaf dev

  I have a font resize function on my page which increases the font size via javascript for the entire page. This works fine in most browsers except IE. When decreasing the font size after increasing it, the select boxes new height does not decrease, even though the font size is decreasing on it. Instead the smaller font appears to be padded with white space. Any ideas as to what IE is doing here, and a work around?

  Read the article

• select lastest 2 element group by a topic_id

  - by Luca Romagnoli

  Hi i have to select the 2 lastest element for every topic ex: table: msg id | topic_id ----------- 1 | 1 2 | 1 3 | 1 4 | 1 5 | 2 6 | 2 7 | 2 8 | 3 i want obtain these rows: 3 1 4 1 6 2 7 2 8 3 How can i do? thanks

  Read the article

• jquery plugin to show form based on select option

  - by yogsma

  I have a form which includes select options with different items. Based on item selected, I need to show respective form on the same page.Does any one know jquery plugin for this or how aesthetically we can do this kind of requirement?

  Read the article

• Matlab- select data from a 3d plot

  - by Li

  Hey, I have a 3d plot. I want to select a certain area in the plot and get the points within this area into a variable. Is that possible? Thanks, Li

  Read the article

• How do I select count() and LIMIT?

  - by alex

  SELECT * FROM ...LIMIT 5, 10 But what if I want the total rows? I don't want to make another query without the limit.

  Read the article

< Previous Page | 154 155 156 157 158 159 160 161 162 163 164 165  | Next Page >