Search Results

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

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

• Extract time part from TimeStamp column in ORACLE

  - by RRUZ

  Actually i' am using MyTimeStampField-TRUNC(MyTimeStampField) to extract the time part from an timestamp column in Oracle. SELECT CURRENT_TIMESTAMP-TRUNC(CURRENT_TIMESTAMP) FROM DUAL this return +00 13:12:07.100729 this work ok for me, to extract the time part from an timestamp field, but i' m wondering if exist a better way (may be using an built-in function of ORACLE) to do this? Thanks.

  Read the article

• How do I create a Guid with Infopath Script?

  - by Ten Ton Gorilla

  In infopath script (J), how do I generate a GUID? This is my current and comletely hacked (and horrid) method. var getGuid = new ActiveXObject("ADODB.Recordset"); getGuid.Open("SELECT NewId()", mySqlConn); var guid = getGuid.Fields(0).Value; There has to be a better way...

  Read the article

• Setting custom SQL in django admin

  - by eugene y

  I'm trying to set up a proxy model in django admin. It will represent a subset of the original model. The code from models.py: class MyManager(models.Manager): def get_query_set(self): return super(MyManager, self).get_query_set().filter(some_column='value') class MyModel(OrigModel): objects = MyManager() class Meta: proxy = True Now instead of filter() I need to use a complex SELECT statement with JOINS. What's the proper way to inject it wholly to the custom manager?

  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

• Problems with MySQL OR clause

  - by Simon

  I have a problem with AND and OR clause in SQL. Here is my query: SELECT `act1`.`name`, `act1`.`surname`, `act2`.`name`, `act2`.`surname`, `act3`.`name`, `act3`.`surname` FROM `videos`, `actors` AS act1, `actors` AS act2, `actors` AS act3 WHERE `videos`.`ident` = 'somethink' AND ( `act1`.`id` = `videos`.`id_actor1` OR `act2`.`id` = `videos`.`id_actor2` OR `act3`.`id` = `videos`.`id_actor3` ) It returns me all variations of {name, surname}, but I want the name and surname of first exactly, second and thirth, if they exist.

  Read the article

• ORDERING A MYSQL QUERY WITH JOINS AND GROUPS

  - by Oliver

  I have this mysql query: SELECT * FROM Customer c JOIN eHRDemographic ehD ON ehD.CxID = c.CustomerID JOIN CustPrimaryWeight cpW ON cpW.CxID = c.CustomerID WHERE c.CustomerID =22703 GROUP BY c.CustomerID ORDER BY cpW.CustPrimaryWeightID DESC This doesn't really work correctly as the CustPrimaryWeight table has multiple enteries and it's simply joining the first entry and not the more recent one as the ORDER statement doesn't seem to do anything. Any ideas?

  Read the article

• mysql : possible to put IF statment in LEFT JOIN ?

  - by Haroldo

  Ok so i want to get an artists info from the db, but i want to know if they have any forthcoming events. To do this i need to traverse 2 tables, where events_artists is a 2 col link table... (this doesnt work but is what id like to do) SELECT art.*, events.event_id FROM art LEFT JOIN events_artists ON art.art_id = events_artists.art_id LEFT JOIN events ON events_artists.event_id = events.event_id IF ( {criteria} ) what should i be doing here to get this to work?!!

  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

• 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 do I upload a file when I know the client's filepath?

  - by GJTorikian

  I'm interested in the way Sonic Living detects your iTunes library XML file. It prompts the user to approve its actions, then automatically uploads the XML file based on the client OS (and assuming the default installation path of iTunes). How the heck does it do that? None of the upload libraries I've looked at have this feature. They all assume that a user will click "Select file..." then browse around for the right thing to upload.

  Read the article

• computed column calculate a value based on different table

  - by adnan

  i've a table c_const code | nvalue -------------- 1 | 10000 2 | 20000 and i've another table t_anytable rec_id | s_id | n_code --------------------- 2 | x | 1 now i want to calculate the x value with computed column, based on rec_id*(select nvalue from c_const where code=ncode) but i get error "Subqueries are not allowed in this context. Only scalar expressions are allowed." how can i calculate the value in this computed column ? thanks.

  Read the article

• Problem in updating field in codeigniter please help

  - by pokhara

  It says , you must use the “set” method to update an entry. Pls help My model is $this->db->where('id', $this->uri->segment(3)); $this->db->update('mytable', $data); My controller is $data = $this->db->select('mytable', $_POST); $this->contact_model->model_update_function($data);

  Read the article

• Easy way to use Images in WPF

  - by j-t-s

  Hi All I've only just started using WPF. (I'm a WinForms guy), and from what I can see, trying to simply drag an image onto the Window is a huge PAIN. There seems to be no way where you can just select an option to tell it what picture to put indide the image control. I've seen so many sites within the last 10 minutes with atleast 10lines of code just to insert animage into a window. Is there an easier way?

  Read the article

• Form filter in symfony: imposible when a field is type "date"

  - by user248959

  Hi, anyone has tried to create a symfony form filter from a class which has a field of type "date" ? When i do it, i get this error: 500 | Internal Server Error | Doctrine_Connection_Mysql_Exception SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens stack trace I think the error dependens on this command: 'SELECT b.id AS b_id, b.day AS b_day FROM birthday b WHERE b.day = ? AND b.day <= ?', array('month' = '1','day' = '2', 'year' = '2014') but i dont know how can i solve it.. Any idea? Javi

  Read the article

• Can the google map API return a street address that was clicked.

  - by Code

  Hi guys, I'm trying to work out an app design in my head and I would like the user to be able to click there destination address on the map of there area. If I know the user is in Liverpool is it possible to pop up the map over liverpool and then allow the user to select on the map where they wanna go, and the google map/api return the street or the name of the area? I've never used googlemap/api yet so just wondering if this kind of thing is possible on the iphone yet. Many Thanks -Code

  Read the article

• Excel c# convert cell to percentage

  - by rubentjeuh

  Hello. I need to convert a cell with a double to a precentage. I used a macro in excel and it says: Range("B5").Select Selection.Style = "Percent" When I do this in c#, it doesn't work: Excel.Range procentRange = xlWorksheet.get_Range("A1","A1"); procentRange.Style = "Percent"; Anybody knows how to do this?

  Read the article

• Expire models in Rails

  - by Koning Baard XIV

  I'm creating a simple paste-bin in Ruby on Rails, which will have an expire-feature. With this, people can select a date when the paste will be deleted automatically. How can I implement this? I was thinking of a cronjob, but maybe there is a more platform-independent way, by defining this in the model itself. Can anyone help me? Thanks.

  Read the article

• Blackberry - Programmatically extract/open zip file

  - by KKlucznik

  I have looked online with mixed results, but is there a way to programmatically extract a zip file on the BB? Very basic my app will display different encrypted file types, and those files are delivered in a zip file. My idea was to have the user browse to the file on their SDCard, select it, and I extract what i need as a stream from the file. is this possible?

  Read the article

• round a number in SQL

  - by LIX

  I have a number and I use ROUND() function in SQL : SELECT ROUND(1.81999,2,1) I want the result 1.82, not 1.81. I don't know where my mistake is.

  Read the article

• SQL Server- PIVOT table. transform row into columns

  - by Matt

  I am trying to convert rows into columns. here is my query SELECT M.urn, M.eventdate, M.eventlocation, M.eventroom, M.eventbed, N.time FROM admpatevents M INNER JOIN admpattransferindex N ON M.urn = N.urn AND M.eventseqno = N.eventseqno AND M.eventdate = N.eventdate WHERE M.urn = 'F1002754364' AND M.eventcode = 'TFRADMIN' Current result URN Date Location Room Bed Time F1002754364 20121101 EDEXPRESS 4-152 02 0724 F1002754364 20121101 CARDSURG 3-110 02 1455 F1002754364 20121102 CHEST UNIT 6-129-GL04 1757 required result F1002754364 20121101 EDEXPRESS 4-152 02 0724 20121101 CARDSURG 3-110 02 1455 20121102 CHEST UNIT 6-129-GL 04 1757 Thanks for your help.

  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

• What is wrong with this javascript?

  - by bala3569

  i use this javascript syntax for validating a checkbox... alert(document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").checked); if (document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").checked == false) { document.getElementById("ctl00_ContentPlaceHolder1_ErrorMsg").innerHTML = "please select the checkbox"; document.getElementById("ctl00_ContentPlaceHolder1_Chkreg").focus(); return false; } My alert showed me false but my if loop is not working... Any suggestion...

  Read the article

• JAVA: multiple files download at the same time?

  - by user319096

  hi guys, Is there any methods for downloading multiple files at the same time? That is, after select multiple files, click the download button, and choose the destination directory, the files selected will be downloaded at the same time. i googled it and not find any solutions, can anybody know? im using struts1 and spring2.

  Read the article

• jquery selecting a selector with namespaced element

  - by Val

  how would i select the following in jquery <ns:text value="my value" /> i have tried selecting it like so: 1: var x= $('ns:text').attr('value'); return x; 2: var x= $('text').attr('value'); return x; but nothing so far... i don't know if it is possible or not but ... Thanks

  Read the article

• Can I lock tables in an IF statement in MySQL?

  - by MalcomTucker

  This is throwing a syntax error - --from body of a stored proc IF (name = in_name) SET out_id = temp; ELSE LOCK TABLE People WRITE; INSERT INTO People (Name) VALUES (in_name); UNLOCK TABLE; SELECT LAST_INSERT_ID() INTO out_id END IF do I have to lock any tables I need at the start of the SP?

  Read the article

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