Search Results

Search found 22900 results on 916 pages for 'pascal case'.

Page 343/916 | < Previous Page | 339 340 341 342 343 344 345 346 347 348 349 350  | Next Page >

• limiting a query to a specific item

  - by Dev-Ria

  I have a db with thousands of domains and data. I want to list only 100 rows of each domain. i can't use LIMIT 100 cause that only limits 100 records but I want dom1 to list 100 dom2 to list 100 dom3 to list 100 all in one query. This is what I have so far. SELECT domain COUNT(Key) AS DomCount FROM table_domain GROUP BY user,location ORDER BY domain,DomCount DESC Could I use a CASE?

  Read the article

• sql query help join (i think)

  - by milan

  I am having trouble figuring our how I can get results only when products.published, product_types.published, and product_cats.published = 1 but my query isn't working. Please help: SELECT `products`.`title`, `products`.`menu_id`, `products`.`short_description`, `products`.`datasheet_icon`, `products`.`datasheet`, `products`.`ordering`, `products`.`product_type_id`, CASE WHEN CHAR_LENGTH(`products`.`alias`) THEN CONCAT_WS(':', `products`.`id`, `products`.`alias`) ELSE `products`.`id` END AS slug FROM `products`, `product_cats`, `product_types` WHERE `products`.published=1 AND `product_cats`.published=1 AND `product_types`.published=1 AND `products`.`product_cat_id`='42' AND `product_types`.`id` IN (1,40,48,49,50) GROUP BY `products`.`id` ORDER BY `product_types`.`ordering`, `products`.`ordering`

  Read the article

• SQL Server Query with "ELSE:"

  - by Mike D

  I have various VB6 projects I'm maintaining with some of the queries being passed to the server having "ELSE:" with the colon used in case statements. I'm wondering can someone tell me what the **ll the colon is used for? It causes errors in SQL2005 and greater, but SQL2000 works with no complaints. I'd like to just remove it from the code & re-compile, but I'm afraid it'll break 10 other things in the application.. Thanks in advance...

  Read the article

• Rails - Always have to check exists, and then value?

  - by Jason B

  I am checking to see if a value in a related table exists quite often in my view, in this case, expenses have approvals. If they have not been submitted, then there is no record of them in the approvals table. I am ending up with some really awkward code <% if !expense_item.expense_approval || expense_item.expense_approval.approval_status == 0 %> Is there a way to do an if statement on a value, without having to check if it exists first? Or some default way to set it nil?

  Read the article

• WinSock best accept() practices

  - by Meta

  Imagine you have a server which can handle only one client at a time. The server uses WSAAsyncSelect to be notified of new connections. In this case, what is the best way of handling FD_ACCEPT messages: A Accept the connection attempt right away but queue the client until its turn? B Do not accept the next connection attempt until we are done serving the currently connected client? What do you guys think is the most efficient?

  Read the article

• Scrollbar moves back after WM_VSCROLL

  - by user146780

  I have a window with its own H and V scrolling. I'm handling the event like this: case WM_VSCROLL: SetScrollPos(hWnd, SB_VERT, (int)HIWORD(wParam), TRUE); break; all I want is for the position of the scroll bar to stay once I release my mouse but what it's doing is just going back to the top after. What am I doing wrong? Thanks

  Read the article

• Function equivalent to sprintf() with maximum number of characters to be copied?

  - by Tommy

  function(char* name) { char sql[50]; sprintf(sql, "select %s;", name); } What's the best way to make sure only 50 chars of name are copied to sql in the case name is larger than what sql can hold? (sprintf with a N parameter?) Thank You.

  Read the article

• What's the best way to display a blown-up image using minimal JQuery?

  - by TkTech

  The Goal: On mouseover (or :hover), enlarge the preview image by about 400% and display it in the center of the page Remove the preview when the mouse leaves The Problem: Solutions like FancyBox are too bloated in FancyBox's case it ignores width and height for image elements, which makes it useless Most of these "lightboxes" steal focus when they're called Really, I'm just looking for a simple, efficient solution. Oops - StackOverflow won't let me post images yet, mockup - http://img685.imageshack.us/img685/7649/idae.png

  Read the article

• iPhone connect to SQL server

  - by immuner

  Since i am new to iphone and mac dev, which is the suggested way to connect your application to an sql server/sql server express 2005 database (in my case to sync data with sqlite)? Thank you

  Read the article

• What is the rationale for difference between -> and . in c++ ?

  - by Good Person

  I know the difference between the member operator (.) and the member by pointer operator (-). Why did the c++ designers create a different operator for this access? Why can't the compiler figure it out on its own? If you always used a . does any case exist where it is ambiguous whether you mean a member or a member by pointer?

  Read the article

• What is the rationale for difference between -> and . in c/c++ ?

  - by Good Person

  I know the difference between the member operator (.) and the member by pointer operator (-). Why did the C designers create a different operator for this access? Why can't the compiler figure it out on its own? If you always used a . does any case exist where it is ambiguous whether you mean a member or a member by pointer?

  Read the article

• Multiple requests to server question

  - by embedded

  I have a DB with user accounts information. I've scheduled a CRON job which updates the DB with every new user data it fetches from their accounts. I was thinking that this may cause a problem since all requests are coming from the same IP address and the server may block requests from that IP address. Is this the case? If so, how do I avoid being banned? should I be using a proxy? Thanks

  Read the article

• Iterate through html table using jQuery, converting the data in the table into JSON

  - by rama-m

  I came across a case where I have to convert html table data into json. In this process I have to iterate through table and convert one by one(row) into array and then convert the whole array into json? Need help in iterating through table(each ow and column)?

  Read the article

• What makes C faster than Python?

  - by Chris

  I know this is probably a very obvious answer and that I'm exposing myself to less-than-helpful snarky comments, but I don't know the answer so here goes. If Python compiles to bytecode at runtime, is it just that initial compiling step that takes longer? If that's the case wouldn't that just be a small upfront cost in the code (ie if the code is running over a long period of time, do the differences between C and python diminish?)

  Read the article

• [Linux] Incremental search on command line?

  - by florianbw

  I'd like to write small scripts which feature incremental search (find-as-you-type) on the command line. Use case: I have my mobile phone connected via USB, Using gammu --sendsms TEXT I can write text messages. I have the phonebook as CSV, and want to search-as-i-type on that. What's the easiest/best way to do it? It might be in bash/zsh/perl/python or any other scripting language. Thanks!

  Read the article

• Will the error be displayed?

  - by user281180

  I have an ajax post and in the controller I return nothing. In case there is a failure will the error message displayed with the follwoing code? [AcceptVerbs(HttpVerbs.Post)] public void Edit(Model model) { model.Save(); } $.ajax({ type: "POST", url: '<%=Url.Action("Edit","test") %>', data: JSON.stringify(data), contentType: "application/json; charset=utf-8", dataType: "html", success: function() { }, error: function(request, status, error) { alert("Error: " & request.responseText); } });

  Read the article

• `export PS1='value'` does not propagate to (Korn) subshells for root?

  - by user319845

  Please consider the following /root/.profile: export PS1=value1 export x=value2 How come the login shell shows the expected prompt (and $x as value2), while the subshells keep showing $x as value2 but $PS1 as '#'? Just in case, I'm trying this under OpenBSD. [Yeah, I know... What on earth am I doing with OpenBSD if I don't know this? Just toying... in an isolated, most definitely non-production VM =).]

  Read the article

• Is <div> always better than <table>, even to make any design where data is not tabular, only looks l

  - by metal-gear-solid

  Possible Duplicate: Tables instead of DIVs I'm making a site using Purely semantic HTML and CSS but for one design which is Not tabular data but only possible with <table> or with lots of <div> then what we should choose? in this case is div more semantically correct or table?

  Read the article

• How to find whether an element exists in std::map?

  - by Vincenzo

  My use case: map<string, Car> cars; bool exists(const string& name) { // somehow I should find whether my MAP has a car // with the name provided return false; } Could you please suggest the best and the most elegant way to do it in C++? Thanks.

  Read the article

• how to read the contents of a file In Erlang ?

  - by Zubair

  I know you can do something like this: readlines(FileName) -> {ok, Device} = file:open(FileName, [read]), get_all_lines(Device, []). get_all_lines(Device, Accum) -> case io:get_line(Device, "") of eof -> file:close(Device), Accum; Line -> get_all_lines(Device, Accum ++ [Line]) end. : Is there a one liner BIF that can do this too?

  Read the article

• how do i use @var on a function variable?

  - by fayer

  i've got a variable $user that is of data type User (a class). i've got it in a class method so i can't just type: /** * @var User */ $user = Factory::getInstance('User'); because that will work only with class properties, not method variables like in this case. how could i tell netbeans that that variable is of data type User in a method? Thanks!

  Read the article

• This code works fine in Chrome, Firefox but not in IE.

  - by Jeddizero

  Hi, I'm trying to make a jquery tooltip that appears when a user mouses over a link. In my case the link is using display:block style so that it covers a large area. It works perfectly in Chrome and Firefox but in Internet Explorer it doesn't work at all. The tooltip doesn't show, the browsers own tooltip shows etc... IE!!!! http://pastebin.com/1kBaMujV Any ideas? Got to love internet explorer...

  Read the article

• MySQLi - Should every statement be prepared?

  - by Kerry

  I know its supposed to improve performance and clean strings, but lets say there are no variables? Might just be a SELECT COUNT( `column` ) AS count FROM `table` Should that be prepared? Is there any case that a SELECT statement should not be prepared?

  Read the article

• Why Pointers in C++?

  - by viswanathan

  Why do we actually need pointers in C++. Why can we just live with Arrays? Or is it really powerful in the case of data structures like linked lists and binary trees.

  Read the article

• C++ constructor behavior

  - by lastzebranky

  I'm declaring an instance of a class like so: Matrix m; This appears to implicitly initialize m (i.e. run the constructor). Is this actually the case?

  Read the article

< Previous Page | 339 340 341 342 343 344 345 346 347 348 349 350  | Next Page >