Search Results

Search found 62701 results on 2509 pages for 'sql function'.

Page 592/2509 | < Previous Page | 588 589 590 591 592 593 594 595 596 597 598 599  | Next Page >

• MIN array function non zeros only

  - by user1717622

  I have been trying to get this array function to output (non-zero) minimum values in the 'FINAL DATA' AE column. Can you see a structural error in this formula? =IF($C$4="All EMEA", MIN(IF('FINAL DATA'!$2:$AE$250000<>0, ('FINAL DATA'!$J$2:$J$250000=$C$4)*('FINAL DATA'!$E$2:$E$250000=$E$4)*( 'FINAL DATA'!$AE$2:$AE$250000))), MIN(IF('FINAL DATA'!$AE$2:$AE$250000<>0, ('FINAL DATA'!$K$2:$K$250000=$C$4)*('FINAL DATA'!$E$2:$E$250000=$E$4)*( 'FINAL DATA'!$AE$2:$AE$250000))) )

  Read the article

• How can I use the "Select" statment from a table with a name that contains blankspaces?

  - by yelinna

  When using this SQL query: "Select * from table_name" what happens if the name of the table contains blankspaces? Is there an special SQL sintax for selecting a table with a name such as "Author Code"?

  Read the article

• How does one create a shared_ptr to pass to a function that takes a void *

  - by shaz

  That's pretty much it. I need to allocate memory and pass it to a function that takes a void *. I'd like to use a shared_ptr but I don't know how to do it.

  Read the article

• "document.body is null" is fixed now I get ".setStyle is not a function"

  - by rymarchant

  Hi All, I'm running into a similar problem as this: link text I've done the fix as in the answer but now I end up with an error a couple lines later: $$([overlay = (new Element("div", {id: "mbOverlay"})).addEvent("click", close), center = new Element("div", {id: "mbCenter"})]).setStyle is not a function [Break on this error] ]).setStyle("display", "none") It's on this page: link text When you click on 'showreel' it should pop up into the media box, but instead it just goes to a new page. Any help would be much appreciated. Thanks!

  Read the article

• function with multiple arguments

  - by Viral

  hi, how to pass multiple arguments in a single function in objective c? I want to pass 2 integer values and the return value is also integer.

  Read the article

• can't understand the url function used in the google taskque api documentation

  - by Bunny Rabbit

  import com.google.appengine.api.labs.taskqueue.Queue; import com.google.appengine.api.labs.taskqueue.QueueFactory; import static com.google.appengine.api.labs.taskqueue.TaskOptions.Builder.*; // ... Queue queue = QueueFactory.getDefaultQueue(); queue.add(url("/worker").param("key", key)) in the code example given on the google task queue documentation page i can't understand the url("/worker") function they are calling in the queues.add() invocation .

  Read the article

• C++: Pass array created in the function call line

  - by Jarx

  How can I achieve a result like somebody would expect it according to the following code example: // assuming: void myFunction( int* arr ); myFunction( [ 123, 456, 789 ] ); // as syntactical sugar for... int values[] = { 123, 456, 789 }; myFunction( values ); The syntax I thought would work spit out a compile error. How can I define an argument array directly in the line where the function is called?

  Read the article

• c# : Not getting "Usertype" for RegisterNewUser() function

  - by Preeti

  Hi, I am not getting "user type" for below function: (using Domino.dll in C#) _NotesRegister.RegisterNewUser(pLastn,pIdfile,pServer,pFirstn,pMiddle,pCertpw,pLocation,pComment, pMaildbpath,pForward,pUserpw,pAltName,pAltLang,Usertype); Regards, Preeti

  Read the article

• Help me understand FFT function (Matlab)

  - by estourodepilha.com

  1) Besides the negative frequencies, which is the minimum frequency provided by the FFT function? Is it zero? 2) If it is zero how do we plot zero on a logarithmic scale? 3) The result is always symmetrical? Or it just appears to be symmetrical? 4) If I use abs(fft(y)) to compare 2 signals, may I lose some accuracy?

  Read the article

• Date Difference, Excluding certain Times and Dates

  - by Josefvz

  Hi Folks. I'm looking for a way to determine the difference between two dates. A normal SQL DATEDIFF statement won't cut it because I need to excluded non working Hours and days Namely Weekends and any time between 16:00 - 7:00. Something similar to the NETWORKDAYS function in excel. I'm codeing an excel spreadsheet. Using VBA connect to a SQL server to pull data.

  Read the article

• javascript autocompletion for DSL. (e.g.: SQL)

  - by chacko

  I want to give the user a web-page where he can type some simple SQL. select * from myTable. What I would like is to have the autocompletion area to help typing: sel [selECT] select * f [select * fROM] select * from [select * fROM column1] [select * fROM column2] ... Anybody can suggest if there is a nice open source library for this ? I am not really interested in the SQL (I will have to parse a DSL) I am more interested on a powerful autocompletion text area widget.

  Read the article

• Fatal error: Call to a member function get() in joomla module

  - by vipinsahu

  i am developing a module in joomla . all things goes fine except Fatal error: Call to a member function get() getting this error when i m using $username = $parem-get('username') but if i m using $username = 'foo'; all things goes fine Thanks

  Read the article

• run a function when a user clicks on any list element

  - by sova

  This is probably a very common question, but I was unable to find an answer myself; All my list elements call the function setQuery like this onClick="admin_stats.setQuery(this);" rather than [hardcode] add this to every list element, is there a way to simply have it run when a list element is clicked? I'm not very familiar with jQuery Live or binding/unbinding, but I think they would play a role here? Before I reinvent a rather square-looking wheel I thought I might ask =)

  Read the article

• mysql circular dependency in foreign key constraints

  - by Flavius

  Given the schema: What I need is having every user_identities.belongs_to reference an users.id. At the same time, every users has a primary_identity as shown in the picture. However when I try to add this reference with ON DELETE NO ACTION ON UPDATE NO ACTION, MySQL says #1452 - Cannot add or update a child row: a foreign key constraint fails (yap.#sql-a3b_1bf, CONSTRAINT #sql-a3b_1bf_ibfk_1 FOREIGN KEY (belongs_to) REFERENCES users (id) ON DELETE NO ACTION ON UPDATE NO ACTION) I suspect this is due to the circular dependency, but how could I solve it (and maintain referential integrity)?

  Read the article

• PHP - why is this date function not erroring out

  - by Phill Pafford

  function convertDT($TS) { $TS = strtotime($TS); $TS -= date("Z"); $newTS = date("Y-m-d\TH:i:s\Z", $TS); return $newTS; } echo "Good: ".convertDT('2010-04-20 01:23:45')."\n"; echo "Bad: ".convertDT('2010-31-20 01:23:45')."\n"; The second date returns: 1969-12-31T23:00:00Z Why? Should this error?

  Read the article

• How to use an overloaded function as an argument of function template?

  - by hpsmouse

  Hello, I think everyone has experience working with a code like the following: void fun(Type1&); void fun(Type2&); vector<Type1> vec; for_each(vec.begin(), vec.end(), fun); Of course that won't compile, because it's not clear which function to be passed. And what's your commonly-used solution to the problem?

  Read the article

• Linq to SQL in and not in

  - by pranay_stacker

  what is in and not in equals in Linq to sql ? fore example select * from table in ( ...) and select * from table not in (..) what is equal to above statement in Linq to sql ?

  Read the article

• GDI+ Resize Function

  - by Tyler

  So my logic is flawed and I need a better and correct way to resize an image in my c# app I need a function similar to this setup public void ResizeImageForWeb(string OriginalFile, string NewFile, int MaxWidth, int MaxHeight, int Quality) { // Resize Code } Basically, I'm a web designer lost trying to programming a desktop app.

  Read the article

• Is it better to use "0" concatenation in Convert.ToInt32() function call

  - by Asim Sajjad

  Is better to use the below statement Convert.ToInt32("0" + stringValue) If not then why? I know that it is better to user int.TryParse() function, which is better, but what about the above statement.

  Read the article

• How do I use Perl to parse the output of the sqlplus command?

  - by benjamin button

  I have an SQL file which will give me an output like below: 10|1 10|2 10|3 11|2 11|4 . . . I am using this in a Perl script like below: my @tmp_cycledef = `sqlplus -s $connstr \@DLCycleState.sql`; after this above statement, since @tmp_cycledef has all the output of the SQL query, I want to show the output as: 10 1,2,3 11 2,4 How could I do this using Perl?

  Read the article

• C++ auto function return type implementation

  - by aaa

  hello. Is there macro, something like BOOST_AUTO, which would allow to emulate automatic return type deduction of function in C++? I mean something like trailing-return-type, http://en.wikipedia.org/wiki/C%2B%2B0x#Alternative_function_syntax thank you

  Read the article

• Silent the stdout of a function in python without trashing sys.stdout and restoring each function ca

  - by Tim McJilton

  Is there a way in python without wrapping a function call like following? from sys import stdout from copy import copy tempstdout = copy(stdout) stdout = file("trash",w) foo() stdout = tempstdout That way works but appears to be terribly inefficient. There has to be a better way... I would appreciate any insight I can get into this.

  Read the article

• Call to undefined function recaptcha_get_html() How to fix?

  - by Silent

  Hello all im getting the following error. I tried putting the files everywhere i can and no fix. is there something else i have to do to make this work? thanks here is the error Fatal error: Call to undefined function recaptcha_get_html() in /home/folder/public_html/site/views/users/register.php on line 75

  Read the article

• How to implement Chord function using GDIplus?

  - by leo4ever

  Here are the GDI functions Chord() provided by MFC: BOOL Chord( int x1, int y1, int x2, int y2, int x3, int y3, int x4, int y4 ); BOOL Chord( LPCRECT lpRect, POINT ptStart, POINT ptEnd ); It seems to me that no such method is privided by GDI+ (the Graphics class), so how do I implement my own Chord function (with the exact same prototype) ? By the way, I just don't understand why does MS just don't provide them. Thanks.

  Read the article

• MSSQL using SSH-tunnel from Visual Studio

  - by pbt

  Hi, I recently contacted a web host regarding support for external database access to a Microsoft SQL Database included in a package they offer. They replied saying that it is only possible with an SSH-tunnel. Is it possible to connect to a MS SQL database in Visual Studio using an SSH-tunnel? It is important for me to be able to access the database from my local machine (for debugging, generating LINQ classes, editing tables, etc). Or, how should I go about working with their database?

  Read the article

< Previous Page | 588 589 590 591 592 593 594 595 596 597 598 599  | Next Page >