Have a lot of unnecessary results using contains() method in my query. Don't tell me to use like or something else. It is hardcoded and couldn't be changed.
I'm having a heck of a time trying to get a silverlight datagrid to properly sort, and do so quickly (sub 1/10 second). Here's the scenario:
-WCF callback every 1/5 of a second
-Take the callback, match up to the existing record in an ObservableCollection
-Update the ObservableCollection's properties
-Bind the grid.
I've tried a linq query, PagedCollectionView, and observablecollection.select(), all are waaaaaaay too slow, and introduce 12+ second delays in processing. Anyone else experience this?
Hi,
I have a list of 'n' contact ids corresponding to which I need to obtain the contact details. One simple way to make n queries using the contact ids and retrieve those contacts. But this will be very time-consuming especially if n is large. I would like to know if there is any simpler way to obtain these results (like batch query etc).
I would like to ask you about your opinion guys.
Is SSL secure enough for using sensitive data (like password) in query string?
Is there any extra options to implement?
thanks for any word.X.
Dear friends
I try to use system.form_status state,but when i check it after I change some texts or my list item,there is no changes in system.form_status ,I just receive "query" message but I must receive "changed" message.
So how I can solve my problem?has it any precondition?
I have a large table (300 million lines) that I would like to dump to a csv - I need to do some processing that cannot be done with SQL. Right now I am using Squirrel as a client, and it does not apparently deal very well with large datasets - at least as far as I can tell from my own (limited) experience. If I run the query on the actual host, will it use less memory? Thanks for any help.
Hi, I know that you can do a GET with Response.Redirect where you build the query string up but how can I do a post? I got a bunch of values in a list that I want to post using Response.Redirect to another page e.g. POST from one page to another.
I would like to create a web server that will serve/accept json files through REST. The JSON files being served will come from a database query and format the results into JSON.
Any suggestions for a good java library. I have tried using Apache HTTPComponents.
While maybe I can just create a servlet but I am not really allowed to install a servlet container in the server machine.
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
Articles.PublicationDate=@publicationDate
Anyway, this query gets all of the articles where the publication date is equal to the argument (publicationDate). How can I alter this so that the argument can handle multiple publication dates?
Also, I'd prefer not to use "BETWEEN," rather, I want to pick and choose dates.
How to store java.util.Calendar field into one column with Datanucleus JDO. By default it is stored into two columns (millisecs, Timezone) with following JDO metadata.
field name="startDate" serialized="true" embedded="true"
persistence-modifier="persistent"
What need to be changed in metadata to store it into single column (Timestamp)?
Is it posible query (JDOQL) on calendar field when it is in two clumn?
Have a binary field and want to insert into this from a hex string:
insert into binaryTable(binaryField)
values(convert(varbinary(max), 0x0))
however when I run select the value is return with an extra 0 as 0x00
This extra 0 is causing a problem in another application, I dont want it.
Interesting, is if I do a select on an existing value and it returns say 0x55 then inserting this same value using the above query will return a select of 0x055.
How to stop the extra 0 being added?
Language Integrated Query. Now I know that the acronyms are. I have seen C# examples, but can't really understand them. Can I use them with PHP? Can I use it along with ORM? Has any PHP MVC framework has this?
I want to find a string such as "qwertty=" in a file with "awk" or "grep" but I don't want to see the lines with #. Please see the example
grep -ni "qwertty" /aaa/bbb
798:# * qwertty - enable/disable
1222:#qwertty=1
1223:qwertty=2
1224:#qwertty=3
I want to find the line 1223.
What should be the search query for this purpose?
OK, so we all saw the lists of "funny" or "bad" comments.
However, today, when maintaining an old stored proc, I stumbled upon a comment which I couldn't classify other than "refreshingly brutally honest", left by a previous maintainer around a really freakish (both performance and readability-wise) page-long query:
-- Feel free to optimize this if you can understand what it means
So, in the first (and hopefully only) poll type question in my history of Stack Overflow, I'd like to hear some other "refreshingly brutally honest" code comments you encountered or written.
I have a YQL query that extracts data from a page and returns it to my script as JSON. The JSON is huge, and as such, here's my question:
Is JSON array parsable? So that I can iterate over the entire JSON structure?
Here's my Model:
class User(models.Model):
pass
class Item(models.Model):
pass
class ItemVote(models.Model):
user = models.ForeignKey(User)
item = models.ForeignKey(Item)
vote = models.BooleanField()
I want to retrieve a list of Items, and I want to know if the current user has voted for each Item. How do I alter my query object so that it will generate sql similar to:
SELECT ...
FROM items
LEFT OUTER JOIN item_votes ON (item_votes.user_id = ? AND
item_votes.item_id = items.id)
Hello,
In a Java method, I'd like to use a Jersey client object to do a POST operation on a RESTful web service (also written using Jersey) but am not sure how to use the client to send the values that will be used as FormParam's on the server. I'm able to send query params just fine.
Thanks in advance.
Is it possible to monitor a mysql table for changes within a c# application? I basically want an event to be raised when data is inserted into the table. The only thing I can think of now is to query the table every 100ms or so.
How to specify blob type in MS Access? I have office 2007 installed. I am using jdbc, but this should not matter for the SQL query I am passing. Tried to pass a length to it, or FILE type, did not help.
CREATE TABLE mytable (
[integer] INTEGER not null,
[string] VARCHAR (255),
[datetime] DATETIME,
[boolean] BIT,
[char] CHAR,
[short] SHORT,
[double] DOUBLE,
[float] FLOAT,
[long] LONG,
[blob] BLOB, // does not work
Primary Key ([integer])
)
When using this SQL query:
"Select * from table_name"
what happens if the name of the table contains blankspaces? Is there an special SQL sintax for selecting a table with a name such as "Author Code"?
I am getting passed comma seperated values to a stored procedure in oracle. I want to treat these values as a table so that I can use them in a query like:
select * from tabl_a where column_b in (<csv values passed in>)
What is the best way to do this in 11g?
Right now we are looping through these one by one and inserting them into a gtt which I think is ineffecient.
Any pointers?
We have a database that is updated via a background process. We are using NHibernate to query the data for display on the web UI, so we don't need change tracking or lazy-loading.
If we mark all the mappings as mutable="false", is this the same as using a stateless session?