Hi Friends,
Could anybody help me by giving some good websites that are describing about T-SQL commands. I am a new guy in this field. thanks in advance..
Hi
I want a linq query to return a calculated timespan,
i have used the timespan function before, but im not sure how to incorporate it into linq.
Basically the linq is returning a datetime field which i want to subtract fromthe current datetime to get days and hours.
Any help appreciated!
Thanks
What is the best way to update a Java or GWT program from MySQL. For example, a MySQL database which holds Weather information... updating whenever the weather changes a degree. How would I update a Java / GWT field with each update. Would I use a thread to query every few seconds??
Hi,
I am planning to have something like this for a website that is on Ruby on Rails. User comes and enters a bunch of names in a text field, and a queue gets created from all the names. From there the website keeps asking more details for each one fromthe queue until the queue finishes.
Is there any queue management gem available in Ruby or I have to just create an array and keep incrementing the index in session variable to emulate a queue behaviour?
Is there a clean way of cloning a record in SQL that has an index(auto increment). I want to clone all the fields except the index. I currently have to enumerate every field, and use that in an insert select, and I would rather not explicitly list all of the fields, as they may change over time.
http://stackoverflow.com/questions/1564566/using-jquery-to-add-or-remove-form-elements/
when i click the add link the information in the existing input field disappears.
How do i tell it to retain this information.
I'd like to have a way to get the sum of a field stored into a variable from inside a dataflow task. The rowcount transform does this, but I can't see how to use any other aggregate functions. Is scripting a transform component my best bet?
Hi all
I made a custom sharepoint workflow with Visual studio, the workflow starts when a new item is inserted in a list
I assigned the title of the task to reference a field in the new item
TaskProps.Title = "Please prepare Hardware for project " + workflowProperties.Item["Contract"].ToString().Split('#')[1];
the task title is correct but i find the string (exteranl participant) concatenated the title of the task
what can be the reason for this ?
thanks
I have articles table, article_comments.
I want to get the value: last_modified_all of article. I need this value to be the great date of this two:
the last_modified field of articles table.
the last comment of article_comments last_modified column.
Can someone help me? the structure is very simple, and you can guess is without problem.
Hi,
I have a database (SQL server express 2008) which has a column that is defined as text. When we try to store some text which is in chinese, it is not saved. I read that thefield should be ntext. I will now have to a conversion to my table to create the column as ntext.
Would I have to do anything with the collation of the database which is set to Latin?
JD
Hello:
I have a note table with columns:
title :string
content :text
rating :integer
and a thinking_sphinx configuration:
define_index do
indexes :title, :sortable => true
indexes :content
end
Then I can search thenotes and assign weights to title and content to define the order or the result:
Note.search "abc", :match_mode => :extended, :field_weights => {
:title => 10,
:content => 3
}
Now I want to assign a weight to the rating column
The type of the rating column is integer. The range of the rating is [1, 2, 3, 4, 5].
Can I just add weight at the :field_weights
:field_weights => {
:title => 10,
:content => 3,
:rating => 5
}
or I need to do something else to make the note which has higer rating display first?
I'm working on a report, and some elements are outside the margins (but some are just barely outside the margins). I was wondering: Is there a way to make two vertical lines, one on each side, along the margins so that one can easily see if it goes outside them?
(Googling it, I only found information about margin notes.)
A figure is below:
|report text goes here|
|more text goes also h|ere
|and so on and so fort|h
It would certainly make correcting these kinds of mistakes very trivial. :)
Feel free to post answers that would solve/show this problem in a more "LaTeX-correct" way, if that makes any sense at all.
Hello folks,
I'm writing a sync application for Lotus Notes and Google (I know, there are some of them out there, but they are either not free or sync only calendar (or only contacts) and most of them cannot deal with local mailfiles). This works so far, but I have a problem when syncing contacts: under certain circustances, the contacts have to be deleted and recreated in Google. This causes them to disappear fromthe chat list in GMail and the people have to be re-invited manually. Is there any way to send these invites through the API?
Thanks in advance
DBa
I have a datagrid which shows the search reasult(time entered by the user preveiously)on a button click event depending uppon the input name or date enter by the user,i want to show a drop down list for a field selection like depertment whenever user want to edit the data in datagridiew,i am using access database & asp3.5.
Hello,
I followed this tutorial:
http://www.magento.cc/custom-accountregistration-fields.html
to add fields in the registration form of a customer under Magento, I succeed to run the example with a checkbox in the frontend and the backend.
I had at the backend a text field with 0 or 1 as value, but I would like to have also a checkbox as in the frontend.
Anyone know what changes to do for this?
Thank you.
The SolrInstall wiki page lists seven different server / Servlet Containers compatible with Solr:
Tomcat
Jetty
Resin
JBoss
WebSphere
Weblogic
Glassfish
I'm sure that "best" is subjective, so I'll just say my criteria are: easiest to set up, best for search performance with a smallish, infrequently-updated dataset, and with the fewest number of gotchas.
Jetty and Tomcat both have apt-get solr packages, so they're clearly the frontrunners for some. Jetty is used in the demo install, but there's some notes that Jetty has some difficulties handling Unicode in some cases. Tomcat is a common choice but my understanding is that it's not as lightweight and has a lot of features not needed by Solr.
Is it worth considering any of the others? Are there some important pro's and cons I should be aware of?
I'm using Stripes and I am validating the values of a drop down box to ensure the user selects an option.
On initial load all data is present, but once the validation kicks in the form loses the data that was set up in the action bean on load. This includes the original list I am validating against.
I'm simply using in the jsp, and annotating thefield in the action bean as @Validate(required=true).
Am I missing something simple?
Cheers
can anyone reply me, How do convert RSS feed publish date-time(GMT) to UNIX time-stamp using php. I need to store the date into my table with thefield'd data type as TIMESTAMP.
Hi there,
I am in need of reorganizing a large CSV file. The first column, which is currently a 6 digit number needs to be split up, using comma's as thefield separator.
For example, I need this:
022250,10:50 AM,274,22,50
022255,11:55 AM,275,22,55
turned into this:
0,2,2,2,5,0,10:50 AM,274,22,50
0,2,2,2,5,5,11:55 AM,275,22,55
Let me know what you think!
Thanks!
I want to list records with a particular month and year. The table name is 'Arrival' and 'date' is thefield 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 list all the records that were added on April,2009. (I only need the query, hope I can figure out the rest :) )
HI,
i am having a Input hidden element like
in my JQuery i am setting the value for the above input type after some ajax call
like
EDIT:::
$.ajax({
type: "POST",
url: "http://localhost/FormBuilder/index.php/forms/saveForm/",
async: false,
data: "formname="+formname+"&status="+status,
success: function(msg){$("#FormID").val(msg); }//success
});//ajax
Now somewhere in the code after this i want to fetch the value of this FIeld.How to get this value on live of value for this input type..
EDIT:::
i am retriving like by var FORMID=$("#FormID").val();//but shows null
How to get the value of it on live of this Input element
Hello stackoverflow,
I'm currently in Python land. This is what I need to do. I have already looked into the itertools library but it seems to only do permutations.
I want to take an input list, like ['yahoo', 'wikipedia', 'freebase'] and generate every unique combination of one item with zero or more other items...
['yahoo', 'wikipedia', 'freebase']
['yahoo', 'wikipedia']
['yahoo', 'freebase']
['wikipedia', 'freebase']
['yahoo']
['freebase']
['wikipedia']
A few notes. Order does not matter and I am trying to design the method to take a list of any size. Also, is there a name for this kind of combination?
Thanks for your help!
I have a field varchar(14) = 20090226115644
I need convert it to - 2009-02-26 11:56:44 (datetime format)
My idea. use cast and convert.. but I allways have errors.
Conversion failed when converting datetime from character string.
I made this, but don`t like it..
SELECT
SUBSTRING(move,1,4) + '-' + SUBSTRING(move,5,2) + '-' + SUBSTRING(move,7,2) + ' ' + SUBSTRING(move,9,2) + ':' + SUBSTRING(move,11,2) + ':'+SUBSTRING(move,13,2) as new --
FROM [Test].[dbo].[container_events]
where move IS not null
Result :2009-02-26 11:56:44
Hi folks,
I have configured the standard "frontpage" view in order to display a list of nodes, just by displaying a field (the banner image).
Unfortunately the URL /frontapge does not return the previewed template, but the same page that would get displayed before the views module was installed.
Help would be much appreciated.