Hi, I am trying to grab the data from the database and display all the values in sorted order grouped into sections from A-Z and also my UITableView is indexed. In this case the indexes are A-Z. The strange thing that's happening is when I get all the values from the DB onto the table, I see that values under section 'B' has some values...
I have been using stored procedure for more than 1.5 years. But I never thought how data is retrieved from UI or within another stored procedure. When I writes a simple stored procedure. eg. CREATE PROCEDURE sp_test AS BEGIN SELECT * FROM tblTest --Considering table has 3 columns. END How does C# gets this result into DataTable. Wh...
I have a database table called A and now i have create a new table called B and create some coloms of A in table B. Eg: Suppose following colomns in tables Table A // The one already exists Id, Country Age Firstname, Middlename, Lastname Table B // The new table I create Id Firstname Middlename Lastname Now the table A will be look...
I'm getting an error from a deterministic PG function that seems dependent based on when I call it in a query. The function is: CREATE OR REPLACE FUNCTION ircm(starting_money numeric, value numeric, days numeric) RETURNS numeric AS $$ BEGIN -- Calculate effective interest rate, compounded monthly. RETURN 12*(pow((value/starting_mon...
Hi, I'm developing a html5 browser multi-player RPG with node.js running in the backend with a web sockets plug-in for client data transfer. The problem i'm facing is accessing and updating user data, as you can imagine this process will be taking place many times a second even with few users connected. I've done some searching and fou...
Hello All, I am working on project which need to get data from MySql database to PDF form. Can anyone please guide how can I solve this problem? I check internet for solution but I found I can create PDF form and get the data from DB to PDF form. My requirement are: I have PDF form on server I need to open that PDF form (using GUI) ...
Hello, I have four different servers; parent.com, a.com, b.com and c.com. At the end of the day I have to pull data and generate report from a, b and c and show in parent. a, b and c databases are having same the structure, but as I mentioned, they're hosted on different IP/server. Can you please tell me what may be my approach? ...
I am reading up on IOCP, and from what I understand so far, the asynchronous writes only apply in the context of writing to Files. By "Files", I don't mean just disk file, but "File" type output devices on Windows. I am planning to somehow use IOCP in implementing a server that takes messages from clients and then writes those messages ...
I have a question about DBLookupComboBox. I have a program that has a database I wrote. It has everything, except when I open DBLookupComboBox it must have a row with null value for when user wants to select nothing. But there isn't one. How can I make a null row show up? ...
We are starting a new BI project in our company. We have at least three developers working with database design and development. Our tools include Sparks EA, SQL Server 2008 EE and undetermined reporting tools. What kind of tools one can use for database version control in SQL Server? What kind of version control systems there are availa...
Hi All, I'm running MySQL from the command line and executing SQL stored in files. What I'm trying to do, is prompt the user to enter input so that I can include this in the SQL script? Is there a way to do this with MySQL? Many thanks, James ...
Given a table like this: ============================================== | ID1 | ID2 | ID3 | Name | Value | ============================================== | 16 | 1 | 100 | item_name | Toys | | 16 | 2 | 101 | item_name | Computer | | 16 | 1 | 102 | item_price | 55 | | 16 | 2 | 103 | item_price ...
i have a query that return only one row (always) and i want to convert this row to class object (lets say obi) i have a feeling that using data table to this kind of query is to much but i dont realy know which other data object to use data reader? is there a way to execute sql command to data row ? ...
I have several databases hosted on a shared server, and a local testing server which I use for development. I would like to keep both set of databases somewhat synchronized (more or less daily). So far, my ideas to solve the problem seem very clumsy. Anyway, for reference, here is what I have considered so far: Make a database dump ...
I have an array which contains a bunch of ID:s... I can't figure out how to write a query for finding all records which are NOT inside this array, in mysql. SELECT * FROM main_table WHERE .......... Any ideas? Thanks ...
I have a DateTime record in my table in a database and I write a query to get it from the database: string command2 = "select Last_Modified from Company_Data where Company_Name='" + DescriptionEntryForm.SelectedItem.ToString() + "'"; SqlCommand search_company2 = new SqlCommand(command2, con_string.con); SqlDataReader company_reader2 = s...
I have a SolrPhpClient which I use to communicate with Solr. I can make queries very easy, like: $solr->deleteByQuery("id: 12345") Anyways, I wonder if anybody out there know of a way to delete all records in a Solr index EXCEPT ones I have inside an array... Is this even possible... Thanks ...
I have been using MySQL for my school projects, personal web site for years. My company is using MySQL in all web projects as well. Now I am thinking to pay for some classes to learn another new Database system, but I have no idea whether I shall choose MS SQL Server 2008 or Oracle 11g. I hope to find a better job with high paid salar...
We have BigTable from Google, Hadoop, actively contributed by Yahoo, Dynamo from Amazon all aiming towards one common goal - making data management as scalable as possible. By scalability what I understand is that the cost of the usage should not go up drastically when the size of data increases. RDBMS's are slow when the amount of...
Hello all, Is there a way to get current SharePoint localization (or culture like "en-US"), querying DB WSS_Content? Regards, ...