database

Database connection with Flex and C#/Asp.Net

I've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder). I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net. If I've correctly understood what I've read in the last ...

SQL Server Reporting Services Round() function

Hi, there is some bizarre thing happening with my report generated in SQL Server Reporting Services and I hope I am not being too stupid. I use the Round function to get integers. Sometimes a 4.5 will round to 4 and a 5.5 will round to 6. Is this because of the rounding method? I am using this: Round(Fields!GroupAverageAssessment.Value,...

SQL Server 2005 - Multiple Databases

We are using SQL Server 2005 at work and when development started it was decided that multiple databases would be created. For example, we have one database for Individual say dbIndividual and another one for Translation say dbLocale. So far this has simplified the backing up and potential restore greatly as we just need to backup what...

SQL help query not returning all data,

I am building a website that remembers the users choices from a navigation menu and then shows content the next time they visit the webiste there last view content is available, to this I am running this query SELECT * FROM (`categoryTable`) LEFT JOIN `userMenuTable` ON `userMenuTable`.`categoryId` = `categoryTable`.`categ...

MySQL database setup help

I am making a classifieds website... I have these 6 tables: Every category has sub-categories (or options) which you can see below. Lets say the user wants to post a classified, and has entered all info into the forms necessary, and I am at the stage where I have to create the PHP code to actually INSERT the data into the database. I a...

How do I build a on-the-fly search engine? (with ranking/relevancy)

I was a heavy user in Sphinx and Lucene. Sphinx just takes a database, indexes it. And you call Sphinx to get the ID's. But what if I want to create a search engine that's very tiny. Just a few rows of data and a few paragraphs of words? The trick is, the rows of data is constantly changing. So, I can't have an "index". I want to be ...

sqlite & flex - insert into if not exists?

I'm using flex to develop my first desktop app and I'm working with sqlite for the first time as well. I'm creating my database and all the tables and I would also like to add a few rows of data into a couple of the tables so that the users have some data to work with on first install. The only problem I'm having is every time I run ...

How to see all records changed since last commit in Oracle 10?

I have a rather large Oracle PL/SQL script I'm testing and I wanted to know if it was possible to see what records were updated/deleted/inserted since the last commit to the database? I need a faster way to check that all the database actions were done correctly. I have access to the command line as well as Oracle's custom tool SQL Devel...

When do you have too many tables?

Two of my colleagues and I are building a system to do all sorts of hydrology and related stuff. It has a lot of requirements and have a good number of tables. We are handling all sorts of sampling that it is done within this scope (hydrology) and we are trying to figure out a way to do it in a less painful way. Sometimes we need to ge...

How do I store XML data into a mysql database? I don't want foreign keys like crazy.

If my XML data is very complex, is there a way I can store this in DB? ...

Efficient db design for retrieving 'most popular' table rows

I am planning to create a mysql 5 (myISAM) table that will contain x thousand rows of data. Each row will have a count field, & the rows with the 20 highest count values will be retrieved quite a lot, probably on a one-for-one ratio to every row update. The x thousand rows not in this 20 will not typically be retrieved. What are the c...

My database query keeps setting all columns to the same value in MySQL

I can't figure this one out; it's probably really obvious to everyone's eyes except mine. Here is my update method for Kohana 3. public function update($type, $id, $updates) { $info = $this->getInfo($type); $dbTable = $info['table']; $updatesKeysToValues = array(); var_dump($updates); foreach(...

Getting started with VB.NET Databases...

I'm having trouble figuring out databases in VB.NET. (VS 2008) What control(s) do I need to use and how do I use them? I am ,looking for tutorials and sample code too. I'm working on a trivia game where the admin can remove and add questions to a database. EDIT: The program must be able to do all of the DB interactions itself throu...

Need quick primer on databases for C++.

My primary area is HW/Software interaction & Robotics, but we're running into situations where having a few database tables would be handy. I've got almost no knowledge on DBs. What is a good primer on Database programming that would quickly get me up to speed on create/add entries/delete entries/query. Prefer either a basic Flat-file...

How do you mix SQL DB vs. Key-Value store (i.e. Redis)

I'm reviewing my code and realize I spend a tremendous amount of time taking rows from a database, formatting as XML, AJAX GET to browser, and then converting back into a hashed javascript object as my local datastore. On updates, I have to reverse the process (except using POST instead of XML.) Having just started looking at R...

Advantages of interface metadata in a database

I'm working on an application where the interface metadata is stored in a database. Basically the C# .NET application reads the positions, size and text of buttons, labels, radiobuttons, etc.. from SQL Server tables. As far as I can tell, who ever wrote the application entered all of this information by hand as I cannot find the tool (...

Access a DB from two different server using CGI

Need to access a DB from two different servers [ 123.123.125.12 , 75.182.16.36 ] using CGI in a single file ...

WPF & Linq to Entities: How can I dynamically display data where it is changed by another user?

Hi, apologies in advance for the noob question, I've only been using WPF for a few weeks and SQL Server for a few days, but I can't find out how to do this anywhere on the web so far. I have a database on SQL Server with one table in it 'User', and have an application that can display data (Username) from that table in a ListView using ...

How to predict/calculate field length of numeric values (INT) in MySQL?

In phpmyadmin there is a field length which you may specify, usually set to 11 on INT if nothing is specified. Field Name: ID Field Type: INT(11) // This is what I need to figure out! How can I calculate the length, and what does the length actually stand for? Does it mean how many digits? Bytes? And what is Unsigned and Signed g...

Tool to retrieve binary jpg data from SQL Server

(Asking on behalf of a friend employed in a local bank) Since he's no programming experience (neither do I with SQL Server), he's looking for a tool which can show all the jpg images stored in a windows SQL Server database. Google didn't give any satisfactory result. ...