Search Results

Search found 27691 results on 1108 pages for 'multi select'.

Page 632/1108 | < Previous Page | 628 629 630 631 632 633 634 635 636 637 638 639  | Next Page >

  • TSQL, How to get smalldatetime's time between two smalldatetime's times ?

    - by eugeneK
    I have Table with two smalldatetime columns, where one is startTime and other one is endTime. I need to select all values from table which between times of both columns compared to getdate()' time. I'm using SQL-Server 2005. example startDate endDate value1 2/2/01 16:00 2/2/01 18:00 1 2/2/01 21:00 2/2/01 22:00 2 2/2/01 05:00 2/2/01 22:00 3 getdate() gives 2/2/2000 21:40 so i need to get value1 2 and 3 thanks in advance

    Read the article

  • addAttributeToFilter and OR condition in Magento's Collection

    - by ÉricP
    Hi, I'd like to select products depending on several criteria from different attribute. I know how to user $collection->addAttributeToFilter('someattribute', array('like' => '%')); But I'd like to use several attribute for OR condition. Like: $collection->addAttributeToFilter('someattribute', array('like' => 'value'));` OR $collection->addAttributeToFilter('otherattribute', array('like' => 'value'));` To get products which either 'someattribute' OR 'otherattribute' set to 'value' Is it possible?

    Read the article

  • Linq, how to specify timestamp condition?

    - by 5YrsLaterDBA
    I have a logins table which records all login and logout activities. I want to look at all login activities of a particular user within 24 hrs. how to do it? something like this: var records = from record in db.Logins where record.Users.UserId == userId && record.Timestamp <= (DateTime.Now + 24) select record; record.Timestamp <= (DateTime.Now + 24) is wrong here. I am using C# 3 + L2E.

    Read the article

  • how to display specific dates in KCalander

    - by yakub_moriss
    hi ,All i want to use KCalander (which is Open Source on www.code.google.com) in my project but i want to allow select only one date from awailable dates (means every monday of limited time period/dates awailable for reservations) what am i want to display only that dates/day in KCalander. is that possible with the use of UIDatePicker controller. which one is easy sollution ? waiting for your reply... Thanks in advance... Yakub Moriss

    Read the article

  • Instantiate defined object with Linq Query

    - by Heinz
    I know that you can instantiate anonymous types with Linq but I am looking to instantiate an object I have already defined. Every time I do, all the properties are returned with their defaults (null, 0, etc.) Is there a way to make this work? I've tried something like this: ServiceDepartment[] serviceDepartments = (from d in departments orderby d.department_name select new ServiceDepartment { DepartmentID = d.department_id, DepartmentName = d.department_name }).ToArray();

    Read the article

  • Delete query in Linq

    - by Ani
    I have this simple code but it shows error. I dont know where I am going wrong. I shows error in last line.."DeleteOnSubmit" linq_testDataContext db = new linq_testDataContext(); var remove = from aremove in db.logins where aremove.username == userNameString && aremove.Password == pwdString select aremove; db.logins.DeleteOnSubmit(remove); Thanks, Ani

    Read the article

  • rails checkbox has_many is hunted

    - by sebajb
    check_box is hunted in rails; but I would like to select some objects and save the relationship to the database anyways. When I debug the code all I see is the value='on' instead of the value I want to save. Any Help or tutorial would be appreciated.

    Read the article

  • List folders from a server RECURSIVELY

    - by fonix232
    I would like to list folders from a webserver into a treeview, keeping the hierarchy. It should not go under level 2 (so root - level 1 - level 2). Would this be possible somehow? If you're interested, I would like to make a list of the Chromium snapshots from here: http://build.chromium.org/buildbot/snapshots/ into a browse-able treeview (well, I'm making a revision checker, what looks up the revisions, and lets the user select the given build and read it's log from http://build.chromium.org/buildbot/snapshots/ + releasetype + / + releasenumber / changelog.xml

    Read the article

  • Please explain in detail this part of YUI3 CSS Reset..

    - by metal-gear-solid
    What is the usefulness of these 2 things in CSS reset? What is the problem in resizing of input elements in IE and in which version? and if legend color doesn't inherit in IE then how it can be solved adding color:#000; /*to enable resizing for IE*/ input, textarea, select { *font-size:100%; } /*because legend doesn't inherit in IE */ legend { color:#000; }

    Read the article

  • jQuery Selector issue finding href with text category1 in it

    - by sushil bharwani
    i have a set of hyperlinks with href = javascript:method('category1') and likewise category2 category3 ... I want to select hyperlink with href containing category1 so i have written jQuery(a[href*='category1']) but dont know why it also selects hyperlinks with category10 category11 category12 ... also I understand that category1 is common in all of them but 'category1' should'nt be do i need to put ' with escape charaters.

    Read the article

  • Asynchronous IO in Java?

    - by thr
    What options for async io (socket-based) are there in java other then java.nio? Also does java.nio use threads in the backround (as I think .NET's async-socket-library does, maybe it's been changed) or is it "true" async io using a proper select call?

    Read the article

  • Is it possible to keep mysql migration running without keeping connection open?

    - by taw
    ALTER TABLE can easily take a few days - and during this time there's a non-negligible chance of connection getting terminated due to network problems. Is it possible to start ALTER TABLE (or CREATE TABLE ... SELECT ...; or some other very long running query) and leave it running without keeping connection open all the time? (the obvious solution of screen + console mysql client won't easily work as there's no ssh running on that server, only mysqld).

    Read the article

  • Printing user specified column from JTable

    - by technomage
    I have an application, and I would like to print a JTable, but since it has many columns, I would like user to select/limit which columns to print so it can fit in regular printer paper. I'm using JTable.print() function to print. (http://java.sun.com/docs/books/tutorial/uiswing/misc/printtable.html) Right now, my solution, is to create another JTable with the columns that user selected, then repopulate the table with the data, then send it to printer. Is there a better way to do it?

    Read the article

  • Change video being played in HTML5 video

    - by Krt_Malta
    Hi! I'm using the tags in HTML5 to play a video on a web browser... (and I'm very impressed with this new feature) Is there the functionality to change the video being played through Javascript? Say when I select another video from a list, a Javascript function would be called which would contain something on the lines of MyVideo.VideoLocation = //location of new video to be played. Is this possible please? Thanks and regards, Krt_Malta

    Read the article

  • showcase website in album

    - by proyb2
    What is the best gallery to showcase web design you have came across? Plan to get various creative agencies to showcase their works on an advertisement platform so that new user will be able to see various portfolio. When it come to select a suitable album, I am indecisive if it too plain (Load and display) or too flashy (coverflow album), which album/gallery script do you recommend for our corporate theme? I would prefer background to be white.

    Read the article

  • how to connect to two databases of oracle using dblink

    - by KASHIFAMAN
    i am tring to use db link for that i have first change the name of both databases to sol1(remote) and sol3(local) then i create a db-link on sol3 CREATE DATABASE LINK SOL1.SWORLD CONNECT TO TEST IDENTIFIED BY TEST USING SOL1; LINK CREATED ON SQL / SELECT * FROM [email protected] MASSAGE SQL COULD NOT RESOLVE THE SERVICE NAME THEN I DROP THE DATABASE LINK AND CREATE A LINK FROM ORACLE ENTERPRISE SCHEMA MANAGER I CREATE A PUBLIC LINK OF FIXED USER AFTED LOGIN AND PASSWORD I ADD THE NAME IN SERVICE TAB AS SOL1 WHEN I TEST TAHT CONNECTION MASSAGE APPERAR LINK IS NOT ACTIVE

    Read the article

  • How do I code a loop for my echo statements?

    - by ggg
    <?php defined('_JEXEC') or die('Restricted access'); $db =& JFactory::getDBO(); $query0 = "SELECT * FROM `#__chesspositions` WHERE . . . . ."; //echo $query0; $db->setQuery($query0); $ginfo = $db->loadObjectList(); //echo $ginfo[0]; echo $db->getErrorMsg(); if(empty($ginfo)){ echo "<center><h2 style='color:navy'>No game found, we apologize</h2></center>"; }else{ $query1= "SELECT * FROM `#__chessmoves` WHERE Id='".$ginfo[0]->MoveDataId."'"; $db->setQuery($query1); echo $db->getErrorMsg(); $gmove = $db->loadObjectList(); } //define array; //how do I code a foreach loop (or any other type of loop) here? //I'm having trouble properly defining the array and structuring the syntax. echo "[Event \"".$ginfo[0]->Event."\"]\n"; echo "[Site \"".$ginfo[0]->Site."\"]\n"; echo "[Date \"".$ginfo[0]->Date."\"]\n"; echo "[Round \"".$ginfo[0]->Round."\"]\n"; echo "[White \"".$ginfo[0]->White."\"]\n"; echo "[Black \"".$ginfo[0]->Black."\"]\n"; echo "[Result \"".$ginfo[0]->Result."\"]\n"; echo "[ECO \"".$ginfo[0]->ECO."\"]\n"; echo "[WhiteElo \"".$ginfo[0]->WhiteElo."\"]\n"; echo "[BlackElo \"".$ginfo[0]->BlackElo."\"]\n"; echo "[Annotator \"".$ginfo[0]->Annotator."\"]\n"; echo "[SetUp \"".$ginfo[0]->SetUp."\"]\n"; echo $gmove[0]->MoveData; ?>

    Read the article

  • EF query to fluent nhibernate query

    - by Shlomi Levi
    I have EF Query: IEnumerable<Account> accounts = (from a in dc.Accounts join m in dc.GroupMembers on a.AccountID equals m.AccountID where m.GroupID == GroupID && m.IsApproved select a).Skip((_configuration.NumberOfRecordsInPage * (PageNumber - 1))) .Take(_configuration.NumberOfRecordsInPage); How to write it in fluent nhibernate query with Session.CreateCriteria<? (My problem is with Join) Regards,

    Read the article

  • mysql query optimization

    - by vamsivanka
    I would need some help on how to optimize the query. select * from transaction where id < 7500001 order by id desc limit 16 when i do an explain plan on this - the type is "range" and rows is "7500000" According to the some online reference's this is explained as, it took the query 7,500,000 rows to scan and get the data. Is there any way i can optimize so it uses less rows to scan and get the data. Also, id is the primary key column.

    Read the article

  • Sql server messed up degree symbol

    - by user228058
    Some of the degree sysmbols in my sql server database are displaying like this: 173-¦F. When I do a search for that - SELECT * FROM PRoduct WHERE description LIKE '%-¦%', it does not bring them up. How can I find (and replace) such characters?

    Read the article

< Previous Page | 628 629 630 631 632 633 634 635 636 637 638 639  | Next Page >