Search Results

Search found 17583 results on 704 pages for 'query analyzer'.

Page 471/704 | < Previous Page | 467 468 469 470 471 472 473 474 475 476 477 478  | Next Page >

• Getting contacts when ids are known

  - by frieza

  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).

  Read the article

• Do Response.Redirect As A HTTP Post

  - by Lennie De Villiers

  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.

  Read the article

• Dump to CSV/Postgres memory

  - by alex

  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.

  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 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.

  Read the article

• How secure is sending sensitive data over https?

  - by Xabatcha

  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.

  Read the article

• why t-sql pathindex not work with declared variable?

  - by mmtemporary

  why this query is not work correctly? declare @s nvarchar set @s = 'abcd' select patindex('%b%', @s) it is return zero.

  Read the article

• Store java.util.Calendar field into one column

  - by Rasika

  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?

  Read the article

• What was the most refreshingly honest non-technical comment you saw in the code?

  - by DVK

  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.

  Read the article

• Java library suggestions for implementing a custom web server

  - by dexter

  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.

  Read the article

• Insert hex string value to sql server binary field is appending extra 0

  - by rotary_engine

  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?

  Read the article

• What is LINQ? How can I use this with PHP?

  - by Ygam

  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?

  Read the article

• Monitor MySQL table for changes within a C# program?

  - by Brian

  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.

  Read the article

• Is JSON array parsable?

  - by Alex

  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?

  Read the article

• Django left join m2m field.

  - by duder

  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)

  Read the article

• Using the Jersey client to do a POST operation

  - by Jon

  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.

  Read the article

• How to specify blob type in MS Access?

  - by Firat

  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]) )

  Read the article

• search a string in a file as ignoring the lines beginning with #

  - by ephieste

  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?

  Read the article

• How can I use the "Select" statment from a table with a name that contains blankspaces?

  - by yelinna

  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"?

  Read the article

• Stateless NHibernate for querying

  - by JontyMC

  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?

  Read the article

• flickering issue while using accordion

  - by Mubeen

  hi folks, Im using accordion query to my webpage. In that i got an flickering issue. Can any one help me to solve this prob. Thanx

  Read the article

• return a single list property List in Linq

  - by bharat

  I am having an issue here i have a list this.Ddown having 3 properties i want to write a Linq Query to return one of the property lets say i have property a,b,c i want to retutn list(c) how do i do that in linq

  Read the article

• What is the recommended way to set GET parameters on a Restlet request?

  - by Simon Nickerson

  What is the recommended way of setting GET query parameters on a Restlet Request object? I think I can see how to get them out of the request using getQueryAsForm(), but how do they get set in the first place? At the moment, I am adding them manually to the URL using a StringBuilder and java.net.URLEncoder, but it seems like there should be a better way.

  Read the article

• Good way to deal with comma seperated values in oracle

  - by dmitry

  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?

  Read the article

• GQL Reference for Appengine

  - by user242153

  Anyone have a good reference guide for GQL (query language for google appengine datastore)? I find the reference guide on the google appengine site very limited with examples

  Read the article

• Split string with delimiter in sql server

  - by Renju

  I'm having a coloumn name with varchar field that holds some folder path like "C:\Program Files\Internet Explorer\en-US" .I need to update the root folder name(Program files to profilesNew).Can anyone please help. I tried with a query declare @val as varchar(100) set @val='C:\Program Files\Internet Explorer\en-US' select substring(@val,charindex(':\',@val),charindex('\',@val)) but not getting the exact answer C:\Program FilesNew\Internet Explorer\en-US

  Read the article

< Previous Page | 467 468 469 470 471 472 473 474 475 476 477 478  | Next Page >