Search Results

Search found 18566 results on 743 pages for 'query hints'.

Page 514/743 | < Previous Page | 510 511 512 513 514 515 516 517 518 519 520 521  | Next Page >

• Ajax, no response

  - by Jeremy Wagemans

  When I try to create a jquery alert coming from an ajaxy query, I don't get any response. Do you know how to fix it ? jquery: $.ajax({ type: "GET", url: "php/submission.php", success:function(data){ if(data==1) { alert("working"); } } }); submission.php: echo '1';

  Read the article

• SQL Server- PIVOT table. transform row into columns

  - by Matt

  I am trying to convert rows into columns. here is my query SELECT M.urn, M.eventdate, M.eventlocation, M.eventroom, M.eventbed, N.time FROM admpatevents M INNER JOIN admpattransferindex N ON M.urn = N.urn AND M.eventseqno = N.eventseqno AND M.eventdate = N.eventdate WHERE M.urn = 'F1002754364' AND M.eventcode = 'TFRADMIN' Current result URN Date Location Room Bed Time F1002754364 20121101 EDEXPRESS 4-152 02 0724 F1002754364 20121101 CARDSURG 3-110 02 1455 F1002754364 20121102 CHEST UNIT 6-129-GL04 1757 required result F1002754364 20121101 EDEXPRESS 4-152 02 0724 20121101 CARDSURG 3-110 02 1455 20121102 CHEST UNIT 6-129-GL 04 1757 Thanks for your help.

  Read the article

• sphinx cuts symbol

  - by YS-PRO

  I have a music collection and use sphinx for searching in it. Search mode is SPH_MATCH_PHRASE, but when I search f.e. for "B'Day" album - sphinx cuts "'" and searching by "Day" query. How can I force sphinx to search by exact phrase without filtering any symbols?

  Read the article

• How can I get file size in perl before uploading it?

  - by zeina

  I want to get file size I'm doing this: my $filename=$query->param("upload_file"); my $filesize = (-s $filename) ; print "Size: $filesize "; Yet it is not working.Note that I did not upload the file. I want to check its size before uploading it. so to limit it to max of 1 MB.

  Read the article

• SQL: count days in date range?

  - by John Isaacks

  I have a query like this: SELECT COUNT(*) AS amount FROM daily_individual_tracking WHERE sales = 'YES' AND daily_individual_tracking_date BETWEEN '2010-01-01' AND '2010-03-31' I am selected from a date range. Is there a way to also get the total days in the date range?

  Read the article

• What doesn't MySQL do? [closed]

  - by sean riley

  When using MySQL 5.1 Enterprise after years of using other database products like Sybase, Infomix, DB2; I run into things that MySQL just doesn't do. For example, it can only generate an EXPLAIN query plan for SELECT queries. What are the other things I should watch out for?

  Read the article

• How to decrypt a password from SQL server?

  - by sef

  I have this query in sql server 2000: select pwdencrypt('AAAA') which outputs an encrypted string of 'AAAA': 0x0100CF465B7B12625EF019E157120D58DD46569AC7BF4118455D12625EF019E157120D58DD46569AC7BF4118455D How can I convert (decrypt) the output from its origin (which is 'AAAA')?

  Read the article

• Passing variables from Model to Model in codeigniter

  - by Craig Ward

  Hi, I need to pass a variable to model, that model needs to send another back and use that variable to query a different model. EG: I have a product_ID which I send to the product model, From that I find out the supplier_ID. I want to grab that supplier_ID to the supplier model to get the supplier name. How do you implement this in codeigniter?

  Read the article

• How do you keep the order using SELECT WHERE IN()?

  - by Pepper

  Is there a way to keep the order when using SELECT WHERE IN()? For example, using the following query: SELECT id FROM data_table WHERE id IN(56,55,54,1,7); The results will come back using the default order by id. 1,7,54,55,56 When I want to keep the order used in the IN: 56,55,54,1,7 Is there a quick way to do this in mySQL or will I be forced to order it after in code. Thanks :)

  Read the article

• i want to get id through passing values in sql server 2008?

  - by jaykanth

  id Ptypefield Value 1 1 D 2 1 E 3 1 F 4 1 G 5 1 H 6 2 FL 7 2 IF 8 2 VVS1 9 2 VVS2 10 2 VS1 11 2 VS2 12 3 0.50 13 3 1.00 14 3 1.50 15 3 2.00 16 4 Marquise 17 4 Round 18 4 Pear 19 4 Radiant 20 4 Princess this table i want to get id no i give value like D and F my ans is 1 and 3 please write a query

  Read the article

• How to make a data-bound combo box display (like a DisplayMember) a concatenated 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

• 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

• 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

• Enumerate printers on a Mac

  - by Kirk Backus

  So, I'm familiar how to enumerate the printers using the Windows API, there are a ton of examples out there. What I gathered from here is that I can find the printers in the /Library/Printers/ directory. When I searched there, I found more folders which didn't really mean anything to me. To keep it simple, how do I query the mac to get a list of printers (local and networked) "attached" to the system? Or can anyone point me in the right direction?

  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

• 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

• 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

• 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

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

• 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

• 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

< Previous Page | 510 511 512 513 514 515 516 517 518 519 520 521  | Next Page >