Search Results

Search found 12096 results on 484 pages for 'to date'.

Page 152/484 | < Previous Page | 148 149 150 151 152 153 154 155 156 157 158 159  | Next Page >

• Complex query with two tables and multilpe data and price ranges

  - by TiuTalk

  Let's suppose that I have these tables: [ properties ] id (INT, PK) name (VARCHAR) [ properties_prices ] id (INT, PK) property_id (INT, FK) date_begin (DATE) date_end (DATE) price_per_day (DECIMAL) price_per_week (DECIMAL) price_per_month (DECIMAL) And my visitor runs a search like: List the first 10 (pagination) properties where the…

  Read the article

• Bulk update + SQL + self join

  - by Nev_Rahd

  Hello All I would like to update a column in Table with reference to other column(s) in same table. Ex: As in figure below - I would like to update effective endate with min date whichever is greater than effective Start Date of currrent record. How can this be acheived in T-SQL. Can this be done with single update statement ? Thanks.

  Read the article

• Datatype Conversion

  - by user87

  I am trying to execute the following Query select distinct pincode as Pincode,CAST(Date_val as DATE) as Date, SUM(cast(megh_38 as int)) as 'Postage Realized in Cash', SUM(cast(megh_39 as int)) as 'MO Commission', from dbo.arrow_dtp_upg group by pincode,Date_Val but I am getting an error "Conversion failed when converting the nvarchar value…

  Read the article

• Save phone calls data in a DB?

  - by Alex

  How would you save this data on a database: An user can make phone calls (id, date, hour, duration, outcome). The "outcome" can be, for example, to recall the client on another day (so I have to save the date, the hour, etc of this "future" call). How would you manage this data on a db? At the moment i have only a "Call" table.

  Read the article

• onClose and datepick with jQuery

  - by Steve

  I have the following code: $('#popupDatepickerWeekly').datepick({ maxDate:'1Y', mandatory:true, highlightWeek:true, onClose: closedDate }); My closedDate function looks like this: function closedDate(value, date, inst) { document.signUpForm.repeatUntil.value = value; } But when I pick a date using the datepicker, the…

  Read the article

• Linq to Sql: Generic Stored Procedures

  - by Eric

  Hello everyone, I am using Linq-to-Sql for a C# application and am currently working on some stored procedures. The application is for a newspaper, and a sample stored procedure is the following: ALTER PROCEDURE dbo.Articles_GetArticlesByPublication @publicationDate date AS SELECT * FROM Articles WHERE …

  Read the article

• AJAX Calendar extender select month and year

  - by nCdy

  Is it real and how can I think about it. To make so the user will select only the month and year, not date, because he need a period on full month, not some date. here is simple control ... <asp:TextBox ID="TextBox3" runat="server" /> <asp:CalendarExtender…

  Read the article

• How to apply formula to cell based on IF condition in Excel

  - by Captain Comic

  Hi I have an Excel spreadsheed like the one shown below A B 10.02.2007 10 10.03.2007 12 Column A is date and B is price of share Now in another sreadsheet I need to create a new column called return In this column i need to place formula like = ln(B2/B1) but on condition that this formula is…

  Read the article

• SQL - How to display the students with the same age?

  - by Cristian

  the code I wrote only tells me how many students have the same age. I want their names too... SELECT YEAR(CURRENT DATE-DATEOFBIRTH) AS AGE, COUNT(*) AS HOWMANY FROM STUDENTS GROUP BY YEAR(CURRENT DATE-DATEOFBIRTH); this returns something like this: AGE HOWMANY --- ------- 21 3 30 5 …

  Read the article

• scrapping blog contents

  - by goh

  Hi lads, After obtaining the urls for various blogspots, tumblr and wordpress pages, I faced some problems processing the html pages. The thing is, i wish to distinguish between the content,title and date for each blog post. I might be able to get the date through regex, but there are so many custom scripts…

  Read the article

• mysqli_query SELECT FROM WHERE [ partial match ] ?

  - by user296516

  Hi guys, I have a database that a time filed that is stored in this format "2010.06.04. | 18:53 01". What I need is to select rows that have a specific date, for example "2010.06.04." Right now I am doing it my first selecting all rows and then looping through them and adding ones with the specified date to…

  Read the article

• MySQL: count enumerated values?

  - by John Isaacks

  If my table looks like this: daily_individual_tracking', 'CREATE TABLE `daily_individual_tracking` ( `daily_individual_tracking_id` int(10) unsigned NOT NULL auto_increment, `daily_individual_tracking_date` date NOT NULL default ''0000-00-00'', `sales` enum(''no'',''yes'') NOT NULL COMMENT ''no'', …

  Read the article

• Filter Datagrid onLoad

  - by Morgan Delvanna

  My data grid successfully filters when I select a month from a dropdown list, however when I try to filter it onLoad it just doesn't filter. The dropdown successfully displays the current month, and the grid should also show the current month data. <script type="text/javascript"> …

  Read the article

• Selecting records with specific month and year in SQL Server 2005

  - by John

  I want to list records with a particular month and year. The table name is 'Arrival' and 'date' is the field that stores the date that the record was added. This is to be done from a C# application. For example, if the user selects month as 'April' and year as '2009' in the application, it will…

  Read the article

• How can I tell when a MySQL table was last updated?

  - by RaGE

  In the footer of my page, I would like to add something like "last updated the xx/xx/200x"; with this date being the last time a certain mySQL table has been updated. What is the best way to do that ? Is there a function to retrieve the date ? Should I make an access to the database everytime…

  Read the article

• Dates comparaisons in java

  - by user308806

  hello, I would like to compare a date to the current date. could you please tell me how to do that in java.

  Read the article

• MySQL update with two subqueries

  - by Julian Cvetkov

  I'm trying to update one column of MySQL table with subquery that returns a date, and another subquery for the WHERE clause. Here is it: UPDATE wtk_recur_subs_temp SET wtk_recur_date = (SELECT final_bb.date FROM final_bb, wtk_recur_subs …

  Read the article

• php sort properties of object

  - by lannoo

  I want to sort the properties of an object so I can loop through them in a defined order. for example: I have an object 'book' with the following properties: 'id', 'title', 'author', 'date'. Now i want to loop through these properties like this: foreach($book as $prop=>$val) //do…

  Read the article

• Returning modified data to a template

  - by Duncan

  I need to amend QuerySet data when i return it to a template. for example, model.objects.all() returns a date (with other fields), but i also want to return the number of days since that date has passed. This is so that in the template, i can say "you last logged in 4 days ago". What…

  Read the article

• how to invoke java.exe in bash under windows in cygwin with space in path

  - by Boris

  Hi, I tried to invoke java inside bash script on windows (Win XP) using cygwin. However path to java.exe contain spaces. only literaly putting in bash sometghing like this worked: /cygdrive/c/Program\ Files/Java/jdk1.5.0_10/bin/java -cp "$TOOL_HOME" DateParse "$DATE" "$FORMAT" …

  Read the article

• How can I order fields in Django ModelForm?

  - by joozek

  I have an 'order' Model: class Order(models.Model): date_time=models.DateTimeField() # other stuff And I'm using Django ModelForm class to render a form, but I want to display date and time widgets separately. I've came up with this: class Form(forms.ModelForm): class Meta: …

  Read the article

• Is there any library to represent SQL queries as objects in Java code?

  - by Pregzt

  I was wondering if there is any library that can be used to represent SQL queries as objects in Java. In the code I have plenty of static variables of type java.lang.String that are hand written SQL queries. I would be looking for library having a nice fluent API that allows me to…

  Read the article

• [Zend Framework] How to create Zend_Db_Select with nested queries?

  - by rasouza

  I don't know if its possible but I'd like to make it a Zend_Db_Select object and I don't know how SELECT * FROM MyTable MT1 WHERE MT1.date = ( SELECT MAX(MT2.date) FROM MyTable MT2 )

  Read the article

• NSDateFormatter always return 2010-12-31 23:00:00 +0000

  - by Janky

  Hello! I'm using this code to format a date from a string: NSDateFormatter *dateFormat = [[NSDateFormatter alloc]init]; [dateFormat setDateFormat:@"EEEE, dd MMMM yyyy"]; NSDate *dateStart = [dateFormat dateFromString:[thisEvent dateEvent]]; [thisEvent dateEvent] contains this…

  Read the article

• jquery ui datepicker IE reload

  - by matthewb

  I am noticing this issue in IE 7 + 8 $('#event-start-date').datepicker({dateFormat:'DD MM dd yy',minDate:'-0d'}); When you pick the date in IE 7 or 8 the page goes to # and reloads the root page I am using jquery 1.4.0 and ui 1.7.2

  Read the article

< Previous Page | 148 149 150 151 152 153 154 155 156 157 158 159  | Next Page >