I've been assigned the task of creating an import utility as part of our application, and as part of the requirements, we need to be able to import from as many different file types as possible. For the most part, this is fine, the initial loading of data comes from a component that then passes it up so we can put everything in it's pro...
I have a bunch of data in text format and I need to do some analysis on it. I think SQL will be very efficient but don't want to install a server (like sql server or mysql) all I need is a simple engine I can import the data into and then do a few queries (from the local machine) is there such a database ? ...
I'm very new to .NET and this is driving absolutely crazy. I want to pull a value from my database and then assign it to a variable that I can pass into javascript. Printing the value is easy, but does nothing for me! <asp:Repeater ID="Repeater3" runat="server" DataSourceID="SqlDataSource11"> <ItemTemplate> <asp:BoundField DataFi...
What's the difference between the two types of column/table collations? Which is preferred and why? Any thoughts? ...
I have multiple SQL stored procedures (e.g. UPDATE, SELECT INTO statements) executed in VBA in MS Access: CurrentDb.Execute "qry1" CurrentDb.Execute "qry2" I want it so that: * if qry2 fails, it will undo qry1. * qry1 and qry2 are executed at the same time, (as I have many of these stored procedures executed in a chain), so the procedu...
If someone knew little about databases and wanted to learn about them from scratch, which database would you recommend learning with and why? MySQL seems ubiquitous, but are there others that are more modern that have learned lessons from the past, or others that are simply nicer or more logical to work with? Universal compatibility/li...
Hello guys, hope you all had a happy new year. So, my question is, what's the best way to make a log of actions. Let me explain it with a example, suppose we have these entities: User Friend (User is a friend of another User, many to many relationship) Message (An user can message another user) Group (An user can be in various group...
I have class that extends another class. class TWITTER_FOLLOWERS extends TWITTER_BOT in TWITTER_FOLLOWERS i want to acces the db object from TWITTER_BOT but i get just an error Fatal error: Call to a member function fetch_all_array() on a non-object in /var/www/bot/inc/TWITTER_FOLLOWERS.php on line 163 On line 163 i have this code ...
I haven't got my hands dirty yet with neither CouchDB nor MongoDB but I would like to do so soon... I also have read a bit about both systems and it looks to me like they cover the same cases... Or am I missing a key distinguishing feature? I would like to use a document based storage instead of a traditional RDBMS in my next project. I...
A table contains the string "Hello world!" Thinking of * as the ordinary wildcard character, how can I write a REGEXP that will evalute to true for 'W*rld!' but false for 'H*rld!' since H is part of another word. 'W*rld' should evalute to false as well because of the trailing '!' ...
hi all I have heard that in web-based applications, when we want to get data from DB, it's better to collect data into a data reader instead of a data table. What 's your choice? ...
I am creating an application which generates statistical information for a pupil's performance over their school career. To achieve this, I need to store every grade ever attained by a pupil. But I have no idea how to optimally store this information. This is a preliminary design, but don't know how it will hold up in practice. So ea...
Is there any tangible difference (speed/efficiency) between these statements? Assume the column is indexed. SELECT MAX(someIntColumn) AS someIntColumn or SELECT someIntColumn ORDER BY someIntColumn DESC LIMIT 1 ...
What is the difference between single quotes and double quotes in SQL? ...
A little background here: I know what a data warehouse is, more or less. I've read several dozen guides on data warehousing, I've played with SSAS, I know what a star schema and a dimension table and a fact table is, I know what ETL is and how to do it. This is not a "how" question or a request for tutorials. My issue is that all of ...
Here is my code, but its the other way around, it commits changes to the datagridview when the database is updated. Imports System Imports System.Data Imports System.Data.OleDb Imports System.Windows.Forms Public Class Form1 Inherits System.Windows.Forms.Form Private bindingSource1 As New BindingSource() P...
Hi, I have got 3 tables with those columns below: Topics: [TopicID] [TopicName] Messages: [MessageID] [MessageText] MessageTopicRelations [EntryID] [MessageID] [TopicID] messages can be about more than one topic. question is: given couple of topics, I need to get messages which are about ALL these topics and not the less, but t...
Please, help me clear my mind on the following question. Recently I asked a question on SO, about possibility of immediate updating WPF classes from SQL Server DB through LINQ to SQL: http://stackoverflow.com/questions/1991455/how-to-use-propertychangedeventhandler-of-linq-to-sql-class-for-immediate-updatin from the answers I got know...
Amazon has "Customers Who Bought This Item Also Bought". I am wondering and want to add this to my shopping cart which I made. What fields do I need in a database? Any website, blog or resources for this? Can you suggest the mechanism how to I should code it please? ...
I am working on a website and this is my first web project. Scenario for Session I have created a database for my project with security level little bit high. I want to manage session for each and every user who is logging in to my website. Session state can be used using Cookie as well as URL, only one at a time. Now I went over wi...