Search Results

Search found 19449 results on 778 pages for 'query builder'.

Page 532/778 | < Previous Page | 528 529 530 531 532 533 534 535 536 537 538 539  | Next Page >

• 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

• MYSQL: Pull Only Words with Minimum Character length

  - by elmaso

  Hi, how can I pull only words with maximum 50 Characters from MYSQL? $query = "SELECT * FROM example ORDER BY ID DESC LIMIT 200";

  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

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

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

• 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

• 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

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

• 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

• 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

• 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

• How to make a data-bound combo box to display (like a DisplayMember) a syntetic string?

  - by Ivan

  I have a first name and a surname as separate columns in a table. If I bind a combo box to a query and set DisplayMember property to "Name" then each person a table is represented in a combo box by its name. How do I show each person's full name (built from concatenating 2 columns) in a single comb box item in this case?

  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

• 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

• 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

• 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

• how to implement RSA algorithm in iphone application?

  - by jecob

  i have implementing one login page.I have to send password in encrypt format to the server using RSA algorithm.But not working can u advice me for this query.

  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

• Is there anyway to access root on iPhone using NSFileManager?

  - by arashaga

  I was trying to access the root directory and list the contents of it but I got 0 folders listed there. I s there anyway to access it for instance to query the SMS.db under root/SMS folder. Thank you all in advance.

  Read the article

• Selecting and deselecting radio buttons

  - by Vivek Kalkur

  I am developing a quiz application which consists of a question and three options and I am using radio buttons for these options.My query is,I click on one of the options and whenever i want to click another option, the previous option remains in the checked state and it does the same whenever I click on the third option too. I need a solution where in it behaves as a natural radio button,only one option is checked at any point of time.

  Read the article

< Previous Page | 528 529 530 531 532 533 534 535 536 537 538 539  | Next Page >