Search Results

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

Page 543/778 | < Previous Page | 539 540 541 542 543 544 545 546 547 548 549 550  | Next Page >

• How to test if table was updated in Zend Framework?

  - by AD

  When user opens a form to modify a record, but instead of changing information, he just clicks the Update button. Which causes the update() function to return 0. However, I consider this case a valid update task. How would I test it, so I can assign a success message? Is update() returns -1 when SQL query failed or also 0? Method: Zend_Db_Table_Abstract::update() Any ideas? Thanks

  Read the article

• Filter on count(*) in oracle

  - by chris

  I have a grouped query, and would like to filter it based on count(*) Can I do this without a subquery? This is what I have currently: select * from (select ID, count(*) cnt from name group by ID) where cnt > 1;

  Read the article

• SELECT GROUP BY latest entry in INBOX msg sent by user

  - by Mohatir S

  i am building a simple PM for my personal website where a user can join and send message to the registered users on my website, i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page my table : id msg_from msg_to msg date in_del out_del i want to show latest user's id each in a group here is my SQL query : SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name FROM ttalk INNER JOIN users ON ttalk.msg_from = users.id WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0' GROUP BY ttalk.msg_from DESC LIMIT 500 Thanks in advance :-)

  Read the article

• News Portals and mysql queries

  - by jasmine

  Consider a news portal like cnn. There is 8 categories. Is there 8 query in every page loading? For eg SELECT title FROM category where cID = 1 SELECT title FROM category where cID = 2 ................... And for sites with high traffic, would be memcache a good solution? Thanks in advance

  Read the article

• How do I TRUNCATE TABLE using Django orm?

  - by Silver Light

  Hello! To empty database table, I use this SQL Query: TRUNCATE TABLE `books` How to I Truncate table using Django models and orm? I've tried this, but it doesn't work: Book.objects.truncate()

  Read the article

• LINQ - more than or equal to

  - by trnTash

  Part of the code: ...where se.DateFrom >= pDateFrom && se.DateTo <= pDateTo select se... Does not work. There is no any error but the To and From days do not get returned. How do I query "more than or equal to" and "less than or equal to"? Thanks :)

  Read the article

• deadlocked on lock | communication buffer resources

  - by Robert Wilkinson

  Do all deadlocks indicate a problem with the query or does this kind deadlock indicate a problem with something else like SQL mail or something? The stored proc in question uses SQL mail.

  Read the article

• How can you tell which columns are unused in ALL_TAB_COLS?

  - by thecoop

  When you query the ALL_TAB_COLS view on Oracle 9i, it lists columns marked as UNUSED as well as the 'active' table columns. There doesn't seem to be a field that explicitly says whether a column is UNUSED, or any view I can join to that lists the unused columns in a table. How can I easily find out which are the unused columns, so I can filter them out of ALL_TAB_COLS?

  Read the article

• Database design for business numbers

  - by Rob Morris

  I'm in need of some help, I need to store the information below into a database, what would the relational database structure be for this: Then I need to create a dropdown for the insurance company followed by another dropdown depending on what the first dropdown selected value was, then once both selects have been chosen display the relevant telephone number. I guess i need to query the database, then display the dropdowns using javascript(jquery) or Ajax?

  Read the article

• mysql condition to select empty fulltext cell?

  - by significance

  i need write a select query to find the number of rows which have an empty fulltext field but for some reason both: select count(id) from table where field is null; and select count(id) from table where field = ""; don't seem to work! what else is there?!

  Read the article

• How do I use cvs to compare two points in time on a branch?

  - by andrewducker

  I can use something like: cvs.exe rdiff -D2010-03-23 -D2010-03-24 -s "ProjectName" to get the changes which occurred on the 23rd. But I want to get the changes that were checked in on the 23rd on a specified branch - and if I add in a -v branchv1-0-0-0 into that it tells me I can't have more than two dates/revisions in one query. Any suggestions?

  Read the article

• How to get final destination URL from AJAX?

  - by Maurice Lam

  When I do an XMLHttpRequest, I always get redirected automatically to the URL (presumably by the headers of the response). For example, if I query "http://www.stackoverflow.com" I will be redirected to "http://stackoverflow.com". How can I get that final URL? (http://stackoverflow.com/ in the example) I checked in the response headers but I cannot seem to find it. (I just used the GET/POST method not HEAD).

  Read the article

• How to update database when using wild characters for example like .

  - by SmartDev

  Hi , I have column which consists of path for example \Abc\F\E\record_123 , now i need to update the path in database where only one change i need to do is tht \Abc\F\E\record_123 = \Abc\F\G\record_123 - i want to update E to G . how to do that with update query in database . Can anyone help me its urgent. Thanks Smartdev

  Read the article

• Replace always replacing null values

  - by Mike

  Why does left(FIELD, replace(nullif(charindex('-', FIELD), 0), null, len(FIELD))) always return null? The idea behind the query is that if charindex() returns 0, then convert the results into null, then convert the null into the length of the field. So if '-' does not exist, show the whole string. For some reason it makes every row equal null. Thank you.

  Read the article

• How to syncronize merge subscription in Sql Compact DB (on a Mobile device emulator)

  - by Bero

  Using SQL ManagementStudio 2008 I created SQL 3.5 Compact DB (TestCompact.sdf) and I have created subscription to existing Publication. Using SQL Management Studio it is working. I have transfered TestCompact.sdf to Windows Mobile 5 emulator device and with QueryAnalyzer for Mobile I could query existing tables in TestCompact.sdf. I don't know how to start replication synchronization on that mobile device. Do I need to write some C# code or it is possible do it more simple?

  Read the article

• Do access subforms that are not visible still update/requery? If not, can this be behavior be confi

  - by pc1oad1etter

  I have an old Access database that is being upgraded to work with Access 2007. The client is complaining that it is slow now. I am looking for ways to optimize it. There is one subform that is in a particular tab on the form. I have been wondering -- does the subform still update/query even when it is not visible? If this is configurable --- how?

  Read the article

• Rails 2.3: How to turn this SQL statement into a named_scope

  - by randombits

  Having a bit of difficulty figuring out how to create a named_scope from this SQL query: select * from foo where id NOT IN (select foo_id from bar) AND foo.category = ? ORDER BY RAND() LIMIT 1; Category should be variable to change. What's the most efficient way the named_scope can be written for the problem above?

  Read the article

• Bad Request (400): Why?

  - by ProfK

  Why do I get a 400 - bad request error using the following URL? It is encoded using Server.UrlEncode. The actual path query parameter is C:\Development\Chase\Exports\ChaseExport-090312073930.zip http://localhost:50199/Common/Forms/Export_Stream.aspx%3fpath%3dC%3a%5CDevelopment%5CChase%5CExports%5CChaseExport-090312073930.zip

  Read the article

• Linq-to-Entities Dynamic sorting

  - by verror

  This is my query, how can I use string as orderby parameter? string sortColumn="Title"; var items = (from ltem in ctxModel.Items where ltem.ItemID == vId orderby //something here select ltem).Skip(PageSize * PageIndex).Take(PageSize);

  Read the article

• CSV is not creating format problems with integer value when generated through SSIS package

  - by paranjai

  Hi I am trying to generate a CSV file from DB Query as source one of my column is having datatype nvarchar(50) with values as "01050007029604301001" After the export when the csv file is viewed using Excel the value appears as "1.0500E18" . How can i stop this . Please suggest

  Read the article

• SQL Server with XML and selecting child nodes

  - by Zenox

  I have the following XML: <tests> <test>1</test> <test>2</test> <test>3</test> </tests> And I am trying the following query: CREATE PROCEDURE [dbo].[test] @Tests xml=null AS BEGIN SELECT doc.col.value('(test)[1]', 'nvarchar(50)') FROM @Tests.nodes('//tests') AS doc(col) END But it only returns me a value from the first What am I missing here?

  Read the article

• JPA: How do I get a scalar result of type Long-- not BigNumber-- from Oracle NUMBER?

  - by rektide

  The default mapping from an Oracle NUMBER value is into BigNumber... How can I get a scalar result query to return a Long instead?

  Read the article

• How to get "Friends who like/play games" list (similar to Farmville 2)

  - by FBAppDev

  I'm working on a Facebook app, and I'm trying to get a friends list similar to Farmville 2. They have a "friends who like games" list. My first thought is, I can get a list of all friends, then for each friend, see if they like any pages with type == "GAMES/TOYS". But ideally, I would like to get the list in one query (not by making one graph API or FQL request per friend). Is this possible, and if so, how?

  Read the article

• access: passing variables from vba to sql

  - by every_answer_gets_a_point

  i am clicking a button on a form in access: Private Sub Command29_Click() some_variable = 2 stDocName = "test" DoCmd.OpenQuery stDocName End Sub my query looks like this: SELECT * FROM [some_table] WHERE [Occurrence Number]=some_variable; is this possible to do?

  Read the article

• Update table of two different database

  - by chetan

  This is the query to update table in one database that is of other Update test.temp a, test2.temp b Set a.name=b.name Where a.no=b.no; Now I don't want to write every field i.e a.name=b.name Is there any solution?

  Read the article

< Previous Page | 539 540 541 542 543 544 545 546 547 548 549 550  | Next Page >