Search Results

Search found 13055 results on 523 pages for 'date calculation'.

Page 300/523 | < Previous Page | 296 297 298 299 300 301 302 303 304 305 306 307  | Next Page >

• 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

• Is there a .net 4.0 provider for IBM DB2?

  - by Mesan

  I can do any .Net development using v2 of the CLR (.net 2, 3, 3.5) but when I try to use .Net 4.0 then I get an error saying that the version of IBM.Data.DB2 is too old / out of date (it's compiled for CLR v2). Where would I find a .Net 4 version of IBM.Data.DB2?

  Read the article

• Hibernate not Loading a class

  - by Noor

  Hi, I have a class Auction that contains a Class Item and Users but when I am getting the class, the class item and Users are not being loaded. Auction Class Mapping File: <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- Generated Dec 28, 2010 9:14:12 PM by Hibernate Tools 3.4.0.Beta1 --> <hibernate-mapping> <class name="com.BiddingSystem.Models.Auction" table="AUCTION"> <id name="AuctionId" type="long"> <column name="AUCTIONID" /> <generator class="native" /> </id> <property name="StartTime" type="java.util.Date"> <column name="STARTTIME" /> </property> <property name="EndTime" type="java.util.Date"> <column name="ENDTIME" /> </property> <property name="StartingBid" type="long"> <column name="STARTINGBID" /> </property> <property name="MinIncrement" type="long"> <column name="MININCREMENT" /> </property> <many-to-one name="CurrentItem" class="com.BiddingSystem.Models.Item" fetch="join" cascade="all"> <column name="ItemId" /> </many-to-one> <property name="AuctionStatus" type="java.lang.String"> <column name="AUCTIONSTATUS" /> </property> <property name="BestBid" type="long"> <column name="BESTBID" /> </property> <many-to-one name="User" class="com.BiddingSystem.Models.Users" fetch="join"> <column name="UserId" /> </many-to-one> </class> </hibernate-mapping> When I am doing this: Query query=session.createQuery("from Auction where UserId="+UserId); List <Auction> AllAuctions= new LinkedList<Auction>(query.list()); The Users and Item are null

  Read the article

• NHibernate and MySql Keywords

  - by jalchr

  Why Nibernate HQL can not handle the following query: from Deal D where (D.ApprovalDate + INTERVAL 1 Year) < current_timestamp() < (D.RenewalDate + INTERVAL -1 Year) knowing that INTERVAL and YEAR are keywords in MySQL, so this is kind of mixing Sql within Hql (unless Hql can handle date functions like so and I don't know) . The dialect is MySQLDialect Its perfectly valid to execute this query SELECT '2005-01-01' + INTERVAL 1 Year;

  Read the article

• Timezone issue in Drupal

  - by cinqoTimo

  I have a drupal site where all the views and times associated with nodes are off by 1-hour. -I checked the server time, and it is correct -I checked that my admin user (uid 1) had a zero in the timezone offset -Checked all CCK date fields in question to make sure there was no timezone handling Yet still when the admin user views nodes, there is a 1-hour offset. Is there some sort of system variable - or something else I haven't checked....?

  Read the article

• redirection follow by post

  - by lucas

  hi, just wonder how those air ticket booking website redirect the user to the airline booking website and then fill up(i suppose doing POST) the required information so that the users will land on the booking page with origin/destination/date selected? Is the technique used is to open up new browser window and do a ajax POST from there? Thanks.

  Read the article

• how to get time in millis in c++ just like java

  - by atomsfat

  In Java you can do this: long now = (new Date()).getTime(); How can I do the same but in c++ ?

  Read the article

• Should I store logging information in main database tabel?

  - by Mike

  For example, say I have a table of products. Should I store logging information such as who it was created by, last edited by, last updated date, ... Or should I separate the logging information in say an auditing table if the logging information is not relevant to the actual application? Thank you.

  Read the article

• How to access application setting through markup using expression?

  - by ParagM

  In a repeater control I've Eval binding as: <%#Eval("PubDate", "{0:dd-MMM-yyyy}")%> But date time format needs to be configurable from the web.config. I want to access datetime format from web.config in markup like: <%#Eval("PubDate", "{0:<%$ AppSettings: DateTimeFormat %>}")%> But is is not working... Any suggesions?

  Read the article

• How to perform an action when file changed?

  - by ZeissS

  Hi, I want to create a script that checks an URL and perform an action (download + unzip) when the "Last-Modified" header of the remote file changed. I thought about fetching the header with curl but then I have to store it somewhere for each file and perform a date comparison. Does anyone have a different idea using (mostly) standard unix tools? thanks

  Read the article

• Amazon S3 permissions

  - by Joe

  Trying to understand S3...How do you limit access to a file you upload to S3? For example, from a web application, each user has files they can upload, but how do you limit access so only that user has access to that file? It seems like the query string authentication requires an expiration date and that won't work for me, is there another way to do this?

  Read the article

• Programming introduction book

  - by Avi

  Hello there, I've offered an out-of-job girl to help her study programming (with an MCSD as the ultimate goal) - and she has no progrmming knowledge. The idea is that she'll study from books and I"ll help. Help- I need a gentle introduction to programming book, very easy, very practical, very hands-on and up to date. Optimally would be for the .Net 4.0 MS enviornment (C#,Visual Basic) but other alternaitves (Jave, Python etc.) are OK.

  Read the article

• How to insert time in SQl Derver 2005?

  - by sam

  i am creating windows application .In this i have to subtract two dates .i subtract it successfully ,i used TimeSpan to get subtracted value.But when i insert it in SQl Server 2005 db, it inserted with starting date i.e. 1/1/1900 and the calculated difference which format should i use to insert Time only? Thanks in advance

  Read the article

• bind event after fullCalendar has been created

  - by user279612

  Is there a way to bind event after fullCalendar has been created? Something like: jQuery( '#calendar' ).bind( 'dayClick', function( date, allDay, jsEvent, view ){} );

  Read the article

• Inverse function of FormatDateTime

  - by Salvador

  i am looking an funtion to reverse any string (YYYYMDD,YY/MM/DD,YYMMDD,...) created by the function FormatDateTime to datetime. example i have a string-date in format YYYYMMDDcreated by FormatDateTime mydatestr:=FormatDateTime('YYYYMMDD',Mydate); now how i can convert mydatestr to DateTime again?

  Read the article

• Simple tool/steps to obfuscating/scrubbing production data

  - by Krishna Kumar

  I am involved in a project where I need to provide subset of our production data (for a date range) to one of my co-workers for trouble shooting. I would like to scrub the data and insert this in to another table. Please suggest best approach to achieve this

  Read the article

• SQL to have one specific record at the top, all others below

  - by superdario

  Hey all, I am trying to put together a query that will display one specific record (found by the record's primary ID) at the top, and display all other records below it, sorted by date (I have "date_added" as one of the fields in the table, in addition to primary ID). I could do this with a UNION (first select would locate the record I want, and the other select would display all other records), but I'm wondering if is there perhaps a better way? I'm using Oracle, by the way.

  Read the article

• can you use jquery datepickers renderCalendar with the multimonth plugin

  - by oo

  using jquery date picker you can render specific cells the way you want. (in my case i have a list of dates that i want to highlight as they are important days) i see that datepicker itself supports this here: http://www.kelvinluck.com/assets/jquery/datePicker/v2/demo/renderCalendarCallback.html but i dont see the multimonth implementation having an option for renderingcustomDates http://www.kelvinluck.com/assets/jquery/datePicker/v2/demo/datePickerMultiMonth3.html was this missed out in the implementation to expose this functionality?

  Read the article

• jQuery - Display the value of a textbox and input the value to another

  - by user1128694

  Basically I want to get the value of a textbox which is to select a date and output the value that is selected to another textbox. These textboxes are on the same page (different steps of the same page) and the document is loaded when the page is ready on click of the next step, I've tried using: $('#TextBox1').val($('#TextBox2').val()); But this doesn't seem to be working. What is it I am doing wrong?

  Read the article

• Convert multiquery to a query using group by and so on

  - by ffffff

  -schema CREATE TABLE `ratings` ( `id` int(11) NOT NULL default '0', `rating` int(11) NOT NULL default '1', `rating_start` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM -myprogram.php foreach($ids as $id){ $sql = "SELECT rating FROM ratings WHERE id = '$id' AND rating_start >= NOW()"; $sql .= "ORDER BY rating_start DESC LIMIT 1;" $ret = $db->execute($id); } Can I teke same date from a Query? by using id IN (".implode(",",$ids).") and GROUP BY id

  Read the article

• [Zend Framework] How to format Zend_db Rowset output?

  - by rasouza

  I have a model which is referenced to a table registries extending Zend_Db and some methods which bascially uses fetchAll() all the time. What happens is: my table has a DATE field and I'd like it to output already formated when I call $row-reg_date. Is it possible by doing something in the model or do I have to manually format?

  Read the article

• C# ASP.Net WebForm Membership Extra User Details (Profile)

  - by user1638362

  I'm learning how to use the ASP.net membership, when a user registers they just create a username and password, however i want to create a page on my website called "profile" where they can fill in extra details such as firstname, lastname, date of birth ect. However i don't see where i can place this in the asp.net membership database. Theres an asp.net_profile table however i'm not sure how this works. Could someone please explain how i can do this?

  Read the article

• C# DateTime, is this method regional setting safe?

  - by JL

  I am using the following method to serialize a date as a string private const string DateFormatString = "dd.MM.yyyy HH:mm:ss"; string LastsuccessfuldownloadDateTime = DateTime.Now.AddDays(-91).ToString(DateFormatString); Is this the safest way to ensure that the string always gets serialized in this format?

  Read the article

• Log files legal aspect?

  - by relwarc

  I like data. That is why I add a standalone PHP script which logs all relevant HTTP variables like: Date of visit IP User-agent Request URI Referer Am I allowed to store all this in non-public text files? Am I allowed to evaluate the data? What am I allowed to do with the log files? Do I have to delete them after some time?

  Read the article

• Unique text field in MySQL and php

  - by Jonathan

  I've created a salt using; md5(rand(0,10000000)); (there is probably a better way?) There doesn't seem to be possible to make a text field unique in MYSQL. So how do I check if the salt has already been used for a previous user? Or should I generate the salt based on the current date/time? as it is impossible for 2 users to register at exactly the same time correct?

  Read the article

< Previous Page | 296 297 298 299 300 301 302 303 304 305 306 307  | Next Page >