Search Results

Search found 23226 results on 930 pages for 'date format'.

Page 509/930 | < Previous Page | 505 506 507 508 509 510 511 512 513 514 515 516  | Next Page >

• Drupal 6: set pager_query() to display last page of query?

  - by Michael D

  Hi all, Does anyone here know how to set up a pager_query() to automatically go to the last page of the query when the page is displayed? I'm using theme_pager() to format the page.

  Read the article

• How To Get YEARWEEK() To See Sunday As The Start Of The Week?

  - by tan

  I'm trying to get the YEARWEEK function to see Sunday as the 1st day of the week. An example date is: Sunday 1st Mar 2009 Here is my sql SELECT YEARWEEK('2009-03-01') and the result is - 200909 Which is week 9. I believe it is telling me this is week 9 because it sees the sunday as the last day of the previous week. How would I get this function to see sunday as the 1st day of the week and therefore return as week 10?

  Read the article

• String formatting help

  - by Camran

  I have this: 2010-04-08T01:01:00Z I want to remove the 'T' and everything behind it as well. Also I would like to rewrite the date into this format: 08-04-2010 How can I do this the easiest way? Thanks

  Read the article

• Allow users to pull temporary data then delete table data (headers remain)?

  - by JM4

  I don't know the best way to title this question but am trying to accomplish the following goal: When a client logs into their profile, they are presented with a link to download data from an existing database in CSV format. The process works, however, I would like for this data to be 'fresh' each time they click the link so my plan was - once a user has clicked the link and downloaded the CSV file, the database table would 'erase' all of its data and start fresh (be empty) until the next set of data populated it. My EXISTING CSV creation code: <?php $host = 'localhost'; $user = 'username'; $pass = 'password'; $db = 'database'; $table = 'tablename'; $file = 'export'; $link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error()); mysql_select_db($db) or die("Can not connect."); $result = mysql_query("SHOW COLUMNS FROM ".$table.""); $i = 0; if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $csv_output .= $row['Field'].", "; $i++; } } $csv_output .= "\n"; $values = mysql_query("SELECT * FROM ".$table.""); while ($rowr = mysql_fetch_row($values)) { for ($j=0;$j<$i;$j++) { $csv_output .= '"'.$rowr[$j].'",'; } $csv_output .= "\n"; } $filename = $file."_".date("Y-m-d",time()); header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".csv"); header( "Content-disposition: filename=".$filename.".csv"); print $csv_output; exit; ?> any ideas?

  Read the article

• Complex SELECT statement; one-to-many all details in one row

  - by RubyWedge

  There are two tables: Products ID (Primary Key), ProductName PlannedByMonths ProductID (Primary Key) (Link to the Products table many-to-one), MonthNumber (Primary Key), QtytoProduce, How to write SELECT statement to retrieve results in the following format? ProductName, QtytoProduceMonth1, QtytoProduceMonth2, QtytoProduceMonth3, QtytoProduceMonth4, QtytoProduceMonth5, QtytoProduceMonth6, QtytoProduceMonth7, QtytoProduceMonth8, QtytoProduceMonth9, QtytoProduceMonth10, QtytoProduceMonth11, QtytoProduceMonth12 Thank you.

  Read the article

• asp.net mvc create view

  - by mazhar

  I have created a Create view.Now the thing is that I want to throw all the fields from the create view into the data plus two other fields which are not on the view which are created date and created by .How will I do that?

  Read the article

• How do I get records from the database for a particular interval?

  - by Vishal

  My table has records for every minute (for instance the column name is date), now I want to fetch records with an interval of 5 minutes! Can it be done at database level? I am using Django with MySQL

  Read the article

• replacing characters with UTF-8 after using mysql_set_charset('utf8') function

  - by Ahmet vardar

  I converted all mysql tables to utf-8_unicode and started using mysql_set_charset('utf8'); function. But after this, some characters like S, Ö started looking like Ö , Åž How can i replace this kinda letters in mysql with UTF-8 format ? shortly, can i find a list of all these kinda characters to replace ? EDIT: He is explaining about this issue in this article actually but i cannot understand it properly acutally lol http://www.oreillynet.com/onlamp/blog/2006/01/turning_mysql_data_in_latin1_t.html

  Read the article

• Restructuring the xml when reading

  - by Sathish

  Hi I am converting a dataset to xml and reading the xml file by dataset.readxml method and showing it in the grid and it appears as shown below. Now i wanted to read this in pivoted format like the second structure without using loops F1 F2 F3 F4 F5 Group 1 2 3 4 Design 5 6 7 8 F1 Value Group 1 Group 2 Group 3 Group 4 Design 5 Design 6 Design 7 Design 8

  Read the article

• How to use WinHelp (.hlp) using .NET Help API?

  - by showens

  I am saddled with WinHelp format (.hlp) files and need to invoke them from a .NET 3.5 DLL. I can get the file to launch but am unable to get either TopicId or Topic to work. The file always opens to the "Getting Started" topic.

  Read the article

• datesub question

  - by Ahmet vardar

  Hi, is it possible to use date_sub like this ? $dt = date("Y-m-d h:i:s"); $query = "INSERT INTO `table` (`date`) VALUES ('DATE_SUB('$dt', INTERVAL 15 DAY)')"; $result = MYSQL_QUERY($query); Thanks

  Read the article

• Validate links with php

  - by mike

  Can anyone tell me if its possible to validate a link with php? By validate, I mean check if the link is active and works not just the actual format of the link.

  Read the article

• How do you query a MySQL table columns highest entry and store it in a variable.

  - by user315819

  How do you query a MySQL table columns highest entry and store it in a variable. Here is what I have but it is not working. $query = "SELECT MAX(date) FROM Records WHERE ips='$currentip'"; $result = mysql_query($query) or die(mysql_error()); echo $result;

  Read the article

• parse localtime in c++

  - by Crystal

  Is there an easy "beginner" way to take the current time using to a Date object that has int month int day int year for it's member variables? Thanks.

  Read the article

• How to separate the year from a birthdate?

  - by Sandipan

  I want to separate the year from the Birthdate.I have a checkbox called Birthdate and when checked it will show the mm/dd/yy. But I want to separate this and show only the date along with the month. And there will be another checkbox called year which will only show if the Birthdate checkbox is checked and if checked it will show the year

  Read the article

• Read JSON (text file) into .NET application

  - by Bi

  I have a configuration file in the following JSON format: { "key1": "value1", "key2": "value2", "key3": false, "key4": 10, } The user can set/unset the configuration values using a text editor. I however need to read it in my C# application. Whats the best way to do so for JSON? The above keys are not associated with a class.

  Read the article

• Matching elements from 2 arrays in perl

  - by Paul

  Right now I am attempting to synchronize two data files that are listed by date so that i can make comparisons later on. However I can not seem to print out only the lines where the dates match. At this point I have separated out the data for each file into 2 arrays. I need to find only the dates that are in both arrays and print them out. Any suggestions would be much appreciated.

  Read the article

• how to get the last day of a month ?

  - by Gold

  hi if i have this date 03/08/1980 and i need to find the last day of the month (08) (the last day of 08 - is 31) how to do it ? (in C#) thank's in advance

  Read the article

• Help Me Writing a Simple Regular Expression

  - by peace

  I have the following text: txtAddressSup.Text I want the Sup to be replaced by Cus while the whole text remains as is. I have many texts that are in this format: xxxxxxxSup.xxxxx

  Read the article

• Thousands separator in .Net/F#

  - by rwallace

  What's the recommended way to print an integer with thousands separator? Best I've come up with so far is let thousands(x:int64) = String.Format("{0:0,0}", x) Which works in most cases, but prints zero as 00.

  Read the article

• DirectorySearch.PageSize = 2 doesn't work

  - by Bero

  using (DirectorySearcher srch = new DirectorySearcher(String.Format("(memberOf= {0})",p_Target.DistinguishedName))) { srch.PageSize = 2; SearchResultCollection results = results = srch.FindAll(); int count = results.Count; } count = 3 (THREE) and not 2. Why is that? I don't want to have all results in just one page. I know that PageSize = 2 is silly small but I set that value in this case just for testing purpose (in reality it will be more).

  Read the article

• PHP Time Remaining in Current Day

  - by Ajith

  How can we find out how many time remains to end the current day from current time[date('Y-m-d H:i:s')] in PHP.

  Read the article

• Bulk Update in MYSQl

  - by user351806

  I have a site which has client side and admin side. There is a table called account History. which contains fields like uid | accountBalance | PaymentStatus | Date. Now this table has to be updated every month for all the paid users and the table is bulk. So what is the best way to update the table every month.Do i need to select all the uid's and update.

  Read the article

• XML Document straight to Stored Proc Mapping in NHibernate

  - by ZekeTheGeek

  Hello. I'm building a mechanism to take XML data from a queue and call stored procs to save the data from the XML document directly to the database. This seems like something that NHibernate could address, but of course most of the information I find discusses going from objects to database instead of another data format (XML, in this case). Is there a way to use NHibernate in this fashion or am I barking up the wrong tree? Thanks.

  Read the article

• Update a single row with t-sql

  - by dan_vitch

  I want to update a row in my date base. The problem is, through a mistake on my part, I have two identical rows of data. How do I run the update on just one row?

  Read the article

< Previous Page | 505 506 507 508 509 510 511 512 513 514 515 516  | Next Page >