Search Results

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

Page 596/2509 | < Previous Page | 592 593 594 595 596 597 598 599 600 601 602 603  | Next Page >

• Execute sql statement and get datareader - WITH flow control

  - by dotnetdev

  I have a standard method which gets some data from SQL Server. I want to refactor this so that based on the value of an enum (passed as a method parameter), a different sql statement is executed (all return datareader). I can't seem to code this in a way which is elegant and tidy. What would be a good way to do this? Thanks

  Read the article

• Malloc function in C++

  - by Mohit Deshpande

  I am transitioning to C++ from C. In C++, is there any use for the malloc function? Or can I just declare it with the "new" keyword. For example: class Node { ... } ... Node *node1 = malloc(sizeof(Node)); //malloc Node *node2 = new Node; //new Which one should I use?

  Read the article

• C++ greatest integer function

  - by Thomas

  I want to implement greatest integer function. int x = 5/3; My question is with greater numbers could there be a loss of precision as 5/3 would produce a double?

  Read the article

• Import/Export table definistrions using SQlServer Management Studio

  - by fireBand

  Hi, How to import/export table definitions from my dev database to production database(recreate the whole database). I have Sql server 2005, Sql Management studio with power shell. Thanks in advance.

  Read the article

• Variable table or column names.

  - by Frank Computer

  INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.brach char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names.

  Read the article

• How do I modify the hundards of records based on my query result?

  - by Nano HE

  Hi, I inserted some error record to my table, I can query via the sql below and found hundards of record marked with half. SELECT * FROM `marathon` WHERE gender = 'male' && distance = 'half'; How to write a SQL then I can modify the result rows distance from 'half' to 'full'. Thank you.

  Read the article

• Javascript syntax with () - function scope

  - by Fabien

  I am not very familiar with the Javascript syntax bellow. Can anyone shade light about the sense of this block? For what purpose? (function foo() { alert('bar'); })(); Thanks in advance.

  Read the article

• Create a new instance in a static function of an abstract class

  - by arno

  abstract class db_table { static function get_all_rows() { ... while(...) { $rows[] = new self(); ... } return $rows; } } class user extends db_table { } $rows = user::get_all_rows(); I want to create instances of a class from a static method defined in the abstract parent class but PHP tells me "Fatal error: Cannot instantiate abstract class ..." How should I implement it correctly?

  Read the article

• How to execute Javascript function in C++

  - by owais masood

  Please tell me, how to include a javascript header file or javascript function in C++ code. The C++ code is written in Linux(UBUNTU)? Although i need to perform the above action only, but let me tell u my purpose of doing it, as i am intending to implement CTI (Computer Telephony Integration) operation. (Help will be appreciated) Thanks a lot in advance

  Read the article

• C++: how to declare template array as function parameter

  - by ~buratinas

  Very similar to this post How can I declare template array as a parameter in templated function? Something like this code: template <unsigned i> void my_func (char (&a)[i]); //yes, I do need that reference

  Read the article

• what's wrong with this function?

  - by Joann

  function get_ibo_id() { if($registerquery = $this->conn->query("SELECT ibo_id FROM fasttrack WHERE count < 8 && flag = 1 ")){ $this->increase_count(); while ($row = $registerquery->fetch_assoc()) { return $row[ibo_id]; } } else return "No id"; } it always enters the if block even if the condition is not satisfied... going crazy

  Read the article

• SQL commands generated in Django by running sqlall

  - by k-g-f

  In my Django app, I just ran $ python manage.py sqlall and I see a lot of SQL statements that look like this, when describing FK relationships: ALTER TABLE `app1_model1` ADD CONSTRAINT model2_id_refs_id_728de91f FOREIGN KEY (`model2_id`) REFERENCES `app1_model2` (`id`); Where does "7218de91f" come from? I would like to know because I'd like to manually write SQL statements to accompany models changes in the app so that my db's can be kept up to date.

  Read the article

• SlideUp Function on Jquery

  - by Silent

  i have a slide up function and a slide down on my script, everything works. The problem is that the DIVs are collapse and not hidden how would i be able to hide the divs on page start up. i tried to set the DIV to hidden but no luck with that.

  Read the article

• Existing function to slice pandas object by axis number

  - by Zero

  Pandas has the following indexers: Object Type Indexers Series s.loc[indexer] DataFrame df.loc[row_indexer,column_indexer] Panel p.loc[item_indexer,major_indexer,minor_indexer] I would like to be able to index dynamically by axis, for example: df = pd.DataFrame(data=0, index=['row1', 'row2', 'row3'], columns=['col1', 'col2', col3']) df.index(['row1', 'row3'], axis=0) # index by rows df.index(['col1', 'col2'], axis=1) # index by columns Is there a built-in function that does this?

  Read the article

• How write query to alter table in Sql Compact

  - by Shiny

  Im new to Sql Compact concept. How to Alter table in sql compact ? I have existing table and i need to add identity column.

  Read the article

• combining results of two select statements

  - by ErnieStings

  I'm using T-SQL with ASP.NET, and c# and i'm pretty new to SQL. I was wondering how i could combine the results of two queries Query1: SELECT tableA.Id, tableA.Name, [tableB].Username AS Owner, [tableB].ImageUrl, [tableB].CompanyImageUrl, COUNT(tableD.UserId) AS NumberOfUsers FROM tableD RIGHT OUTER JOIN [tableB] INNER JOIN tableA ON [tableB].Id = tableA.Owner ON tableD.tableAId = tableA.Id GROUP BY tableA.Name, [tableB].Username, [tableB].ImageUrl, [tableB].CompanyImageUrl Query2: SELECT tableA.Id, tableA.Name, COUNT([tableC].Id) AS NumberOfPlans FROM [tableC] RIGHT OUTER JOIN tableA ON [tableC].tableAId = tableA.Id GROUP BY tableA.Id, tableA.Name Any help would be much appreciated. Thanks in advance

  Read the article

• Can I put a function inside a struct?

  - by drigoSkalWalker

  Maybe I use inline functions... There are any way to archieve it, without using function pointers? Thanks in advance.

  Read the article

• how can i call a javascript function when an ASP.net validation summary is filled

  - by july

  i have a validationSummary in my page. i want to call a javascript function after the validationSummary is filled. how can i achieve this? i think i should add an attribute in the code behind, but i can't figure out what is the attribute's key. any help?

  Read the article

• Function defined but not used in C

  - by thetna

  I have following code: static __inline__ LIST list_List(POINTER P) { return list_Cons(P,list_Nil()); } After compilation I got following warning: inlining is unlikely but function size may grow I removed the inline and changed into the following : static LIST list_List(POINTER P) { return list_Cons(P,list_Nil()); } Now I get the following warning: list_List is defined but not used. Can anybody please suggest me how can remove that warning.

  Read the article

• A 16-digit hashing function

  - by Aly

  Is there a hash function that returns a 16-digit hex value (as MD5 returns 32-digit), or is there a library (for C++) in which I can use MD5 or SHA-1 which returns a 16-digit value

  Read the article

• Calling a function in the Form Class from another Class, C# .NET

  - by mouthpiec

  Hi, Can someone please let me know by some code how I can call a function located in the Form class from another class? Some code will be of great help! thanks

  Read the article

• How do I keep connection in object explorer

  - by dotnet-practitioner

  This is regarding SQL server 2008 management studio.. I connect to different environment DB and every time I launch the Sql management console, I have to sign up every time to get those connections back in object explorer. Is there a way I could persist the connection so I don't have to login every time to different environments?

  Read the article

• Is select function internaly call tcp connect ?

  - by Syedsma

  Code Sinnpet: int CreateaTCPSocket() { int iSockID = ACE_OS::socket(......); ACE_OS::set_flags(iSockID,O_NONBLOCK); ACE_OS::bind(); if (ACE_OS::connect(iSockID ,....) < 0) { if (ACE_OS::select(.....,timeout) <= 0) { return INVALID_HANDLE; } } return iSockID; } My question is when connect is failed for non-block error and select is called and say select return success then again we need to call connect or select function internal do connect?

  Read the article

• Using Jquery autocomplete - looking for example of overriding the filllist() function

  - by TLL

  I'm using the JQuery autocomplete plugin. I wish to override the implementation of the filllist() function. Can someone point me to an example of how to do this?

  Read the article

• Need help with C# function to translate smoothly between numeric ranges

  - by Shachar Weis

  I'm trying to write a function : Input: Source range, Source value, output range, curve type (Linear, smooth) Output: The output is the "source value" converted into the "output range" according to the curve type. I hope I am making sense here... Any ideas ? Thanks.

  Read the article

< Previous Page | 592 593 594 595 596 597 598 599 600 601 602 603  | Next Page >