Search Results

Search found 10657 results on 427 pages for 'group'.

Page 227/427 | < Previous Page | 223 224 225 226 227 228 229 230 231 232 233 234  | Next Page >

• SQL Error with Order By in Subquery

  - by cagin

  Hi all. i m working sql server 2005. My query is: SELECT ( SELECT COUNT(1) FROM Seanslar WHERE MONTH(tarihi) = 4 GROUP BY refKlinik_id ORDER BY refKlinik_id) as dorduncuay And the error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified. How can i use order by in a sub query?

  Read the article

• How To: show color option in FontDialog with no underline and strikeout options.

  - by Vijay

  Hi All, I am using FontDialog control in vb.net application. When I set its ShowColor property to true, it shows me StrikeOut, Underline and Color option under Effects group. I need only color from these three. Is there any way to hide Strikeout and underline effects, so that only Color option will be visible. Thanks in advance for any kind of help.

  Read the article

• Error using iif in ms access query

  - by naveen

  I am trying to fire this query in MS Access SELECT file_number, IIF(invoice_type='Spent on Coding',SUM(CINT(invoice_amount)), 0) as CodingExpense FROM invoice GROUP BY file_number I am getting this error Error in list of function arguments: '=' not recognized. Unable to parse query text. I tried replacing IIF with SWITCH to no avail. What's wrong with my query and how to correct this?

  Read the article

• Crystal Reports - Passing a current value of grouping field into a subreport as a parameter

  - by DarkDeny

  Hello All! I have a query with grouping on one of the fields in Crystal Reports. My question is - is there a way to pass that value into a subreport? I.e. if there are three values in that field, there will be three groups in report. I want a subreport in every group to have that value as its parameter. Is that possible to accomplish with CR 2008?

  Read the article

• SMS/Text message sending via PHP

  - by Onion

  I'm interested in knowing if it would be at all feasible to be able to send text messages via PHP. The main purpose of which would be to send a single message to a group of people - 10+ - with updates regarding news and such. Preferably the solution should be free, though it is not a necessity in any way. Thanks to all in advance.

  Read the article

• DB2 Query to Hibernate Criteria

  - by Fortega

  Hi, I have a specific DB2 query, and I would like to execute this query using criteria. The query: SELECT sum(units) as volume, location_id, aged FROM ( SELECT units, location_id, CASE WHEN daysinstock < 61 THEN 'NOT_AGED' WHEN daysinstock < 91 THEN 'AGED' ELSE 'OVER_AGED' END AS AGED FROM STOCK_TABLE ) x group by location_id, aged the STOCK_TABLE contains the following fields: units, location_id, daysinstock. This table is matched by a StockDataSource object, with the same fields.

  Read the article

• problem in mysql query with join and limit the time

  - by moustafa

  i have this SELECT COUNT(1) cnt, a.auther_id FROM `posts` a LEFT JOIN users u ON a.auther_id = u.id GROUP BY a.auther_id ORDER BY cnt DESC LIMIT 20 its work fine bu now i want select from posts which added from 1 day tried to use WHERE from_unixtime(post_time) >= SUBDATE(NOW(),1) but its didnot worked any one have idea

  Read the article

• Livevalidation clientside validation - can you control the position of the validation messages?

  - by JK

  I'm using LiveValidaion for my clientside validation http://livevalidation.com/ and DataAnnotations for my validation rules. This all works fine except that the clientside error messages are only ever displayed to the right of the element being validated. Is it possible to move this validation message below the element being validated? Or even better, group all messages in a div at the top/bottom of the page? I dont see anything in their docs or examples

  Read the article

• How to make "msiexec /x" shortcut ask for elevation on XP?

  - by lonelyass

  On XP (user account) when running this shortcut: <Shortcut Id="UninstallStartMenuShortcut" Advertise="no" Name="AppName" Description="Uninstalls AppName" Target="[SystemFolder]msiexec.exe" Arguments="/x [ProductCode]"/> I'm getting an error "You must be an Administrator to remove this application. To remove this application, you can log on as an administrator, or contact your technical support group for assistance." Why this happens instead of asking for elevation with admin password? How can I avoid this stupid error?

  Read the article

• Can I create a file that sits next to a .Designer.cs file in Visual Studio?

  - by Ian Potter

  In Visual Studio, two files are created when you create a new Windows Form in your solution (e.g. if you create MyForm.cs, MyForm.Designer.cs and MyForm.resx are also created). These second two files are displayed as a subtree in the Solution Explorer. Is there any way to add files to the sub-tree or group for a Windows Form class?

  Read the article

• SQL - How to display the students with the same age?

  - by Cristian

  the code I wrote only tells me how many students have the same age. I want their names too... SELECT YEAR(CURRENT DATE-DATEOFBIRTH) AS AGE, COUNT(*) AS HOWMANY FROM STUDENTS GROUP BY YEAR(CURRENT DATE-DATEOFBIRTH); this returns something like this: AGE HOWMANY --- ------- 21 3 30 5 Thank you. TABLE STUDENTS COLUMNS: StudentID (primary key), Name(varchar), Firstname(varchar), Dateofbirth(varchar) I was thinking of maybe using the code above and somewhere add the function concat that will put the stundents' names on the same row as in

  Read the article

• Rookie file permissions question

  - by Camran

  What is the ending 'r' for and the leading 'd' for in file permissions on Linux? Example: drwxr-xr-x I know about the user, group, others part, and I know w=write, r=read, x=execute. But I don't know about the leading 'd' and the trailing 'r'. Care to explain? Thanks

  Read the article

• Making sites on the fly, programatically

  - by dotnetdev

  Hi, Is it possible to create a site on demand? So in the response of an event, such as button click. I want users to be able to see one site (all users), but users with assigned to a certain group will see two sites. Also, when would I want to create a seperate web application? Thanks

  Read the article

• Find substring with Jquery?

  - by bothered

  How would our group find out if a particular string contain the scertain substring? Only with the help of Jquery, please.

  Read the article

• Do you know Sybase Forums for ASE and Replication server?

  - by Pradeep

  Are you aware of one of the largest sybase user group forums for ASE , Replication Server , IQ server , Sun Solaris and Perl on the web?

  Read the article

• What are some good usability guidelines an average developer should follow?

  - by Allain Lalonde

  I'm not a usability specialist, and I really don't care to be one. I just want a small set of rules of thumb that I can follow while coding my User Interfaces so that my product has decent usability. At first I thought that this question would be easy to answer "Use your common sense", but if it's so common among us developers we wouldn't, as a group, have a reputation for our horrible interfaces. Any Suggestions?

  Read the article

• SQL ORDER BY thing1 ASC, thing2 DESC not working

  - by William

  it puts item1 down as DESC for some reason. edit: $sql_result = mysql_query("SELECT post, name, trip, Thread, sticky FROM (SELECT MIN(ID) AS min_id, MAX(ID) AS max_id, MAX(Date) AS max_date FROM test_posts GROUP BY Thread ) t_min_max INNER JOIN test_posts ON test_posts.ID = t_min_max.min_id WHERE Board=".$board." ORDER BY sticky ASC, max_date DESC", $db); http://prime.programming-designs.com/test_forum/viewboard.php?board=0&page=3

  Read the article

• Where do I find an Open Source project written in Scala?

  - by stacker

  I'm looking for a well documented open source project, written in scala to see best practices etc. At sourceforge.net I found a few projects tagged as scala but they were actually written in java. github seems a bit better: http://groups.google.com/group/scala-melb/web/open-scala-projects Does anyone know such a project which could be recommended for learning?

  Read the article

• mysql problem left join and from_unixtime

  - by moustafa

  i have this SELECT COUNT(1) cnt, a.auther_id FROM `posts` a LEFT JOIN users u ON a.auther_id = u.id GROUP BY a.auther_id ORDER BY cnt DESC LIMIT 20 its work fine bu now i want select from posts which added from 1 day tried to use WHERE from_unixtime(post_time) >= SUBDATE(NOW(),1) but its didnot worked any one have idea

  Read the article

• sql query returns incorrect result

  - by reza saberi

  I have a mysql database that stores quotation documents with some products that are clearly defining the price of each product in them, and a table for contracts storing contract details as well as customer code and quotation code to which it belongs. I have the following query to see how much is the total price of the quotation to write it in the invoice: select sum(sqproducts.price * sqproducts.quantity) as 'total-price', squotations.currency as 'currency' from sqproducts, ccontracts, squotations where sqproducts.contracted=1 AND squotations.code=sqproducts.quotation_code AND sqproducts.quotation_code=ccontracts.squotation_code AND sqproducts.quotation_code='QUOT/2012/1' group by currency

  Read the article

• MySQL: How can fetch SUM() of all fields in one Query?

  - by takpar

  Hi, I just want somthing like this: select SUM(*) from `mytable` group by `year` any suggestion? (I am using Zend Framework; if you have a suggestion using ZF rather than pure query would be great!) Update: I have a mass of columns in table and i do not want to write their name down one by one. No Idea??

  Read the article

• not able to solve markup problem

  - by pradeep

  http://validator.w3.org/check?uri=http%3A%2F%2Fratingscorner.com%2Fproduct_rating.php%3Falias%3DPeoples-Education-Society-Institute-of-Technology-%28PESIT%29-100-feet-Ring-Road-Bangalore%26product%3DColleges&charset=%28detect+automatically%29&doctype=Inline&ss=1&outline=1&group=1&No200=1&verbose=1&st=1&user-agent=W3C_Validator%2F1.767 have fixed most of the errors . but could not fix the » problems ...if any1 can help it will be helpful for me.

  Read the article

• MySql - set of time stamped data (timestamp,event) calculating events per day

  - by Kevin Ohashi

  I have a table: id, datetime, event i also have table dates: date (Y-m-d format) the problem is some days don't have any events, I would like them to show 0 (or null) SELECT DATE_FORMAT(table.timestamp, '%Y-%m-%d') ydm, count(table.fkUID) FROM `table` where table.fkUID=$var group by ydm; is there some way to join or use conditional statements to make the result show: date|count ---------- 2010-05-23| 5 2010-05-24| 0 <--- this line just doesn't exist in my query. 2010-05-26| 3

  Read the article

• Spaces in OU causing drupal ldapgroups lookup to deny login

  - by jgreep

  I'm trying to configure mapping of LDAP Groups to Drupal roles. The DN for the group that I have been given contains a space in the OU: CN=CommunityUsers,OU=Distribution Groups,DC=TLD,DC=AD Drupal is authenticating if there is no space, but under no circumstances can I have the space removed. Can I change the way I specify the DN?

  Read the article

• jquery not working in internet explorer using mvc

  - by Barry

  i have a group of radio buttons that are generated on the fly from the db into a partial control then rendered on the page as html and they all have the same name now in firefox and chrome the following code works fine $(".FlightSelectedRadio").live('click', function() { alert("after flight select"); $("#ToisGarantueedBid").attr("disabled", false); }); however in ie it doesnt work on the first select of a radio but only fires if u select something else ? any ideas wat the problem is ?

  Read the article

< Previous Page | 223 224 225 226 227 228 229 230 231 232 233 234  | Next Page >