Search Results

Search found 25852 results on 1035 pages for 'linq query syntax'.

Page 756/1035 | < Previous Page | 752 753 754 755 756 757 758 759 760 761 762 763  | Next Page >

• Amazon S3 permissions

  - by Joe

  Trying to understand S3...How do you limit access to a file you upload to S3? For example, from a web application, each user has files they can upload, but how do you limit access so only that user has access to that file? It seems like the query string authentication requires an expiration date and that won't work for me, is there another way to do this?

  Read the article

• Google GSA Stems for scandinavian languages

  - by HAXEN

  I have installed Scandinavia-2.1-1 language bundle to our GSA. After that I expected to find those languages available in Query Expansion, but nope nothing new there. Am I missing something? How are you other Scandinavians handling stems for your language?

  Read the article

• PreparedStatement.setString() method without quotes

  - by Slavko

  I'm trying to use a PreparedStatement with code similar to this: SELECT * FROM ? WHERE name = ? Obviously, what happens when I use setString() to set the table and name field is this: SELECT * FROM 'my_table' WHERE name = 'whatever' and the query doesn't work. Is there a way to set the String without quotes so the line looks like this: SELECT * FROM my_table WHERE name = 'whatever' or should I just give it up and use the regular Statement instead (the arguments come from another part of the system, neither of those is entered by a user)?

  Read the article

• Pagination in Google App Engine with Java

  - by newbie

  I need to create simple pagination of objects, but when I read manual I found out that query.setRange(5, 10); will fetch 10 objects, even when only 5 objects are needed. Is there anyway to fetch just needed objects? EDIT: I started bounty, so fi you can show me simple example code in Java that works, then I will accept you answer.

  Read the article

• Transfer table from one database to another?

  - by Mahmoud

  Hey all i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused

  Read the article

• Getting a count of users each day in Mondrian MDX

  - by user1874144

  I'm trying to write a query to give me the total number of users for each customer per day. Here is what I have so far, which for each customer/day combination is giving the total number of user dimension entries without splitting them up by customer/day. WITH MEMBER [Measures].[MyUserCount] AS COUNT(Descendants([User].CurrentMember, [User].[User Name]), INCLUDEEMPTY) SELECT NON EMPTY CrossJoin([Date].[Date].Members, [Customer].[Customer Name].Members) ON ROWS, {[Measures].[MyUserCount]} on COLUMNS FROM [Users]

  Read the article

• How to search dob in db is in the yyyy-mm-dd strucuture. But i have to compare only with yyyy of the

  - by Fero

  Hi How to search dob in db is in the yyyy-mm-dd strucuture. But i have to compare only with yyyy of the field using mysql. example: id dob 1 1999-05-10 2 2000-10-05 I am having only the year 2000 . Now how can i get the record 2000-10-05 using mysql search query. thanks in advance

  Read the article

• MKTIME, PHP date/timestamp YYYY-MM-DD

  - by Mikey1980

  I need to query MySQL for the current date (from PHP) in YYYY-MM-DD format... anyone?

  Read the article

• Alternative to subqueries

  - by Juanma

  I'm using Mysql 5.1, and have this query, is there a way to not use the subqueries and accomplish the same result? SELECT oref.affiliate_id, ROUND(sum( oph.amount ) * 0.10 ,2) AS tsum FROM operators_referer AS oref LEFT JOIN operators_payments_history AS oph ON oref.operator_id = oph.operator_id WHERE oref.affiliate_id = 28221 AND ( oph.date_paid > ( SELECT MAX(aph.date_paid) FROM affiliates_payments_history AS aph WHERE aph.operator_id = oref.affiliate_id ) OR ( SELECT MAX(aph.date_paid) FROM affiliates_payments_history AS aph WHERE aph.operator_id = oref.affiliate_id ) is NULL )

  Read the article

• Count total number of callers?

  - by Kristopher Ives

  I'm currently doing this query to find the guy who makes the most calls: SELECT `commenter_name`, COUNT(*) AS `calls` FROM `comments` GROUP BY `commenter_name` ORDER BY `calls` LIMIT 1 What I want now is to be able to find out how many total unique callers. I tried using DISTINCT but I didn't get anywhere.

  Read the article

• Subsonic SELECT FROM msdb

  - by Lukasz Lysik

  Hi, I want to execute the following query using Subsonic: SELECT MAX([restore_date]) FROM [msdb].[dbo].[restorehistory] While the aggregate part is easy for me, the problem is with the name of the table. How should I force Subsonic to select from different database than default one.

  Read the article

• SQL to have one specific record at the top, all others below

  - by superdario

  Hey all, I am trying to put together a query that will display one specific record (found by the record's primary ID) at the top, and display all other records below it, sorted by date (I have "date_added" as one of the fields in the table, in addition to primary ID). I could do this with a UNION (first select would locate the record I want, and the other select would display all other records), but I'm wondering if is there perhaps a better way? I'm using Oracle, by the way.

  Read the article

• How to trigger an application in mobile automatically

  - by san6086

  My idea is to make an application start automatically when a message from a specific user reaches the inbox of the mobile . For example if my friend sends some numbers to my mobile, the sms has to be read and validated first and then calculator ( inbuilt mobile application) has to be triggered and process the numbers from the message. Please help me with the above query.

  Read the article

• Android: how to get the walking distance between two geo coordinats?

  - by wei

  I used this query URL http://maps.google.com/maps?q=from+A+to+B&output=kml ,which is given in the answer to this question. But after I tried it, it doesn't work with coordinates. It works with address names tho. I guess I could use google's geocoding to get the addresses first. But I wonder if there is another way to get the walking distance between two coordinates?

  Read the article

• Inserting random characters to MYSQL Database

  - by spotlightsnap

  I want to add 100 entry to users table numbers field, random characters length is 10, all entry should be unique as well. How can i achieve this using MYSQL query code ? Or do i need to use PHP ? Help me with code snippets please. Thanks.

  Read the article

• jQuery .css() behaves differently in FF and IE

  - by Misha Moroshko

  When there is no border, why IE returns medium while FF returns 0px on the following query ? .css("border-left-width") I checked this in FF 3.6.3 and IE 6/7. Example here

  Read the article

• how to remove hazardous character in php

  - by Ajay

  Hi All, I have to remove hazardous chracter from my query post string. Is there any function define in php to remove directly or another way ?

  Read the article

• TSQL: How can I update the value of an xml tag with the value of an xml tag from another related tab

  - by halfjust

  Hello, How can I update the value of an xml tag with the value of an xml tag from another related table? something like this: UPDATE v2 SET [xml].modify ('replace value of (//TAG1/text())[1] with "CAST(v1.[xml].query(''//TAG2'') AS NVARCHAR(MAX))"') FROM table2 v2, table1 v1 WHERE v2.id = v1.id Thanks

  Read the article

• Stock Symbols using python

  - by nimmyliji

  Hi all, Hi, I am looking for some stock symbol look-up API. I could able to query yahoo finance with a symbol & could able to retrieve the stock price & other details. Is there any API for stock symbol searches Any help would be great .. Thanks

  Read the article

• how to select * from tableA where columnA values don't start with letter 'F'

  - by subash

  Can I have a SQL query to get the data from columna in tableA whose values don't start with 'f' ? For example: select * from tableA where columnA where values don't start with letter 'F'.

  Read the article

• ado.net-data-services filer using composite

  - by Thurein

  Hi, I am having a problem filter a query. I have Contact and Tag entities. Actually in the database, they are 3 different tables, Contacts, Tags and ContactTag table. I would like to filter contacts using the Tag name. I was trying this filter but it did not work. http://localhost:50143/ContactDataService.svc/Contacts?$filter=Tags/TagName eq 'Tag1' Am I missing any thing ? Thanks Thurein

  Read the article

• How to output items in Order in MySQL?

  - by RailsRor

  I have a column called "menu_order" which has no default value. When I select the contents of this column using the following select statement: SELECT * FROM categories ORDER BY menu_order ASC It lists the category items that have nothing as their menu order first and then the one's that have 1's and 2's and 3's. Is there any way to prevent SQL from take nothing to come before numbers when I am trying to list things in order? So for example, if I have: cat_name | menu_order ---------------------- Lunch | 1 Dinner | And I perform my query, the output should be: Lunch Dinner Not: Dinner Lunch

  Read the article

• hibernate restrictions.in with and, how to use?

  - by cometta

  I have table like below id, employee_no, survey_no, name 1 test 1 test_name 2 test2 1 test_name2 3 test3 1 test_name3 4 test4 2 test_name4 how to query with Restriction.in by combining below AND into one IN statement? IN[ (if(survey_no==1) && employee_no== 'test') , (if(survey_no==1) && employee_no== 'test2') , ... ]

  Read the article

• MySQL How to select friends from a friendship table?

  - by Thomas Puthoor

  Hi I have a simple database for storing friendship, with just two columns person_a, person_b , denoting that person_a and person_b are friends. From a big list like this what query should I run to get say get all friends of 'sam'. Thank you.

  Read the article

• mysql rollback when auto commit is on

  - by devang

  hi, by mistake i fired a update query and all the records in the table in dat field got updated nd also cannot rollback as auto_commit is on..is der ny other way in which i can retreive the records.plz help its urgent.. Thanks in advance

  Read the article

< Previous Page | 752 753 754 755 756 757 758 759 760 761 762 763  | Next Page >