Hi all,
I need to convert the system datetime to timestamp in script task SSIS.
input date format: 29/05/2010 2:36 AM
output format: 29-15-2010 14:36:00
thanks
prav
Hi, I'm trying to parse Email Subject which have encoding specified in format itself. I get the format and imagine how this can be done, but maybe there is any free .Net solution available already so I wouldn't waste time on it?
Here is an example of subject I want to parse:
=?ISO-8859-13?Q?Fwd=3A_Dvira=E8iai_vasar=E0_vagiami_da=FEniau=2C_bet_draust?=
The use case is simple.
I allow users to enter in an expiration field which needs to be between 1 and 15 into a form. The model takes that number and converts it into a datetime (such as adding 15 days from today) and stores it in the database.
What's the correct way to actually validate that though? Do I validate against the datetimeformat that gets persisted in the database or the select box (1..15) that the user gets to pick through the form? I want to be able to validate that the user is putting in 1..15.. How is this done with ActiveRecord validation in Rails 2.3.5?
In my MySQL database, I have a float field named "HoursSpent" with values like "0.25", "1.75", "2.5", etc. Is there a way that I can have my SELECT statement format those values in a friendly format like this?:
0.25 = 15 minutes
1.75 = 1 hour and 45 minutes
2.5 = 2 hours and 30 minutes
The "HoursSpent" field is supposed to only have values in 0.25 increments, but if somebody were to put something random like 0.16, it would be nice if the SELECT statement handled that by rounding it up to the nearest 0.25 (so in this case 0.16 would become 0.25, or 15 minutes).
I have an array of entries I would like to print.
Being arr the array, I used just to write:
puts arr
Then I needed to use the DOS format end-of-line: \r\n, so I wrote:
arr.each { |e| print "#{e}\r\n" }
This works correctly, but I would like to know if there is a way to specify what end-of-line format to use so that I could write something like:
$eol = "\r\n"
puts arr
UPDATE
I know that puts will use the correct line-endings depending on the platform it is run on, but I need this because I will write the output to a file.
Hi,
I have a rdf file (file.trp) in n-triples format, where each line is:
"subject predicate object ."
I tried to use rdf_load in semweb/rdf_db to load it into memory, but failed. Here is what I tried:
?- rdf_load('file.trp').
?- rdf_load('file.trp', [format(triples]).
the manual says it supports xml and triples. But it only loads rdf xml files. How can I load such rdf triple file?
Thanks,
Li
Hi All,
I have a file that is in structured storage format.
I was wondering if this format be accessed concurrently by threads.
Meaning have multiple threads read the different streams process it at once. The objective is to load the file faster.
When i refer to a file i refer one that represents CAD information.
Thank you.
I want to provide a trial version of my software. This version should only be evaluated within a specific period of time. Let's say only during January 2011.
As this software massively uses the system clock in processing, it would be quite annoying to set the clock to an earlier time to be able to use it over and over. So because of this, I wound't think of a more complicated protection mechanism.
So I have thought about exiting after a test like:
if (DateTime.Now.Year != 2011 && DateTime.Now.Month != 1)
{
MessageBox.Show("expired!");
Application.Exit();
}
How easy will this be cracked :-) ?
Is there a "safe" way to do this ?
I have a problem getting a character from the user in VC++.the function i want to use uses the char format so when i get the input using getch() it gives me an error that can't convert 'int' to 'char'.
could someone please help me how to get the input in char format please?
I'm trying to store a list of generic objects in a generic list, but I'm having difficulty declaring it. My object looks like:
public class Field<T>
{
public string Name { get; set; }
public string Description { get; set; }
public T Value { get; set; }
/*
...
*/
}
I'd like to create a list of these. My problem is that each object in the list can have a separate type, so that the populated list could contain something like this:
{ Field<DateTime>, Field<int>, Field<double>, Field<DateTime> }
So how do I declare that?
List<Field<?>>
(I'd like to stay as typesafe as possible, so I don't want to use an ArrayList).
I want to post json object to my WCF service
My only problem is his date property. I get the date from an jquery datepicker and i want to get it in my service as c# datetime.
My service:
namespace Employee
{
[ServiceContract]
public interface IService1
{
[OperationContract]
[WebInvoke(Method = "POST",
RequestFormat = WebMessageFormat.Json,
ResponseFormat = WebMessageFormat.Json,
BodyStyle = WebMessageBodyStyle.Wrapped)]
bool UpdateEmployee(Employee Employee);
}
}
And this is Employee:
[DataContract]
public class Employee
{
[DataMember]
public string Name { get; set; }
[DataMember]
public string Department { get; set; }
[DataMember]
public int Salary { get; set; }
[DataMember]
public DateTime Hired { get; set; }
}
All the other properties work fine. I just need to convert my date string to json date.
hi,
it show me this error Incorrect syntax near the keyword 'Select' to make to clear Employee ID in this case is FK in the table (Attendance detail) and the other thing is i am using Data Grid View from another table(Employee information) to Show the list of the staff in my form. then i want to transfer each selected cell value from Data Grid View to attendance detail table. 10q
private void time_in_Click(object sender, EventArgs e)
{
employee_InformationDataGridView.SelectedCells[0].Style.ForeColor = Color.Green;
time_in.Enabled = false;
time_out.Enabled = true;
con = new SqlConnection(GlobalClass.conn);
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Attendancedetail Values(" + "Select from EmployeeInformation(EmployeeID)" + ",'" + employee_InformationDataGridView.SelectedCells[0] + "','" + DateTime.Now.ToLongDateString() + "','" + null + "','" + null + "','" + DateTime.Now.ToLongTimeString() + "'," + null + ")", con);
int i = cmd.ExecuteNonQuery();
MessageBox.Show(i.ToString() + " record inserted");
}
0 down vote
hi,
I have problem in showing $date="2011-02-10 15:26:20"; in the format of Thursday 10th of February 2011 03:26:20 PM in php.
i know there is one date function in php and can be done in one line for example: but via this it will flash today date or so.
i want to do it when user check any date and want that date in the format which i mention earlier.
please revert me back as soon as posib....
thanks
I have an application that uses an access 2000 database currently in distribution. I need to update one of the recordsets with additional fields on my customer's computers. My data controls work fine as I have them set to connect in access 2000 format but when I try to open the database in code, I get an unrecognized data format error. What is the best way to replace or add to the database on their machines? Any help is greatly appreciated.
My asp.net 4 website url format is http://www.somesite.com/ShowProduct.aspx?ID=3330
but it sometimes gets changed to
http://www.somesite.com/(S(ghtef0vy5fgfdjgdfgderd55)X(1))/ShowProduct.aspx?ID=3330
or
http://www.somesite.com/ShowProduct.aspx?ID=3330&AspxAutoDetectCookieSupport=3330
How can i prevent this. I want all url's to be of this format only
http://www.somesite.com/ShowProduct.aspx?ID=3330
Hello, in my web page a user fill a form who send information to a MySql database. One of the data inputs sent is a date/time, in the format date('l jS \of F Y h:i:s A');
(I can change the format as needed)
So when the user submits the form i wanna check if the actual time/date is 30 seconds more than the sent time/date in order to allow or not the submission of the form. Thanks!
Hi,
when I do the following
def somefunction
@texts = A.find_all_by_someid(someid)
respond_to do |format|
format.xml { render :xml => @texts }
end
end
it gets the string from the db correctly, except if the string has leading whitespaces, it seems they are trimmed.
Note: the whitespaces are there in the db correctly
What can I do to conserve those whitespaces?
Thanks
Hi,
I am trying to get the following spec to run:
describe BlacklistController, "GET index" do
it "should display the list of universally blocked numbers" do
get :index
debugger
assigns[:blocked_numbers].should contain "190"
end
end
Here's the action
def index
@blocked_numbers << "190"
respond_to do |format|
format.html
end
end
And the failure simply says that assigns[:blocked_numbers} is nil. Why's that?
I have problem in asp.ne Mvc with multiple model in one view on create and update
I 'm work on exams system
class Questions and class Answers
Question is aparent class and Answers is a child class
[Bind(exclude("id"))]
class Quesions
{
public string question{get; set;}
public Datetime Timepostquestion{get; set;}
}
[Bind(exclude("id"))]
class Answers
{
public string answer{get; set;}
public Datetime Timepostanswer{get; set;}
public questionId {get; set;}
}
in a view I use two classes how to use classes in insert and update
what a way which I have to solve my problem
How do I show the dates number format next to its name in the array using PHP? So that the number format is saved in the database and the month name is displayed?
Here is the php code.
$month_options = array("Month", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
I'm trying to do the following for my IIS logs table:
ALTER TABLE [W3CLog]
ADD [LogTime] AS [date] + ([time] - '1900-01-01') PERSISTED
However, SQL Server 2008 tells me:
Computed column 'LogTime' in table 'W3CLog' cannot be persisted because the column is non-deterministic.
The table has this definition:
CREATE TABLE [dbo].[W3CLog](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
...
[date] [datetime] NULL,
[time] [datetime] NULL,
...
)
Why is that non-deterministic?
I really need to index that field. The table currently has 1598170 rows, and it is a pain to query if we can't do an index seek on the full time. Since this is being UNION'd with some other log formats, we can't very easily just use the two columns separately.
StringBuilder sb = new StringBuilder();
sb.AppendLine("SELECT");
sb.AppendLine(String.Format(" (SELECT TOP 1 CAST(ProspectID AS VARCHAR(5)) FROM Lead_Import_Fail Where ProspectID < {0} AND ProspectFullName = '{1}')", Convert.ToInt64(lead.LeadID), lead.Name));
sb.AppendLine(String.Format(", (SELECT TOP 1 CAST(ProspectID AS VARCHAR(5)) FROM Lead_Import_Fail Where ProspectID < {0} AND ProspectNRICPassport = '{1}')", Convert.ToInt64(lead.LeadID), lead.NRIC));
Thanks in advance.
Hi All
I want to generate image on server side. My Image is stored in server side's database in blob format and I am able to convert it into string_image;
Then How to convert that string_image into actual .jpg or .png format.
Actually I am posting attachment as image on users facebook' wall.
How to generate Image at server side in Java?
Is there any sample code to do it?