As part of a contact management system I have a large database of names. People frequently edit this and as a result we run into issues of the same person existing in different forms (John Smith and Jonathan Smith). I looked into word similarity but it's easy to think of name variations which are not similar at all (Richard vs Dick). I w...
MY question deals with month to month data changes..I want a simple (if possible) SQL query that will show the person , and month change grouped by person/month or similar.. the important part is to show gains and losses. For Example I have a table: (date simplified ) id | Date | Person | Sales ---|-----------|--------| ----- 1 ...
I want to create dictionary for my iPhone application. For that I need a list of words with detailed meanings of the words in a database. Can anyone suggest me a good word list that is freely available? ...
Hi all, I'm looking for a CMS that would be something like a front-end of an SQL database. It should be able to create new databases and also be able to generate graphs. The data stored in the database will be data collected from fauna and flora measurements. CMS should have user access levels where each user has access to different da...
Hi, I need to create a data access library to access data from multiple databases like SQL, Oracle. The Library should work equally with all databases. In .NET i guess ODBC will help me in doing this. But do I need to think about any other alternatives? And if I finalize ODBC what special precautions I need to take ? ...
Hi folks, I have database on the server but as a developer when we found some bug in the product then to resolved that bug quickly we need to take dump of database which is currently present on the server.As the db size is much larger so it is not possible everyday to create dump and download it which is wasting some times.So I w...
I'm using MySQLdb and run into the following problem: STMT="""INSERT INTO test_table VALUES (%s, %s, %s, %s, %s)""" rows=[('Wed Apr 14 14:00:00 2010', 23L, -2.3, 4.41, 0.83923)] conn.cursor().executemay(STMT, rows) results in: Traceback (most recent call last): File "run.py", line 122, in <module> File "C:\Python25\lib\site-pack...
I would like to develop for Windows Phone 7 but the lack of database support still blocks me. Has anyone found a good library, stack to use for accessing local database from WinPhone7? Can you post links/examples of good practices to select/insert data in DB from a WinPhone7 application? Thanks in advance ! c. ...
I have a database: class dbConnect { var $strHost = ""; var $strDatabase = ""; var $strUser = ""; var $strPassword = ""; var $intLinkID = 0; var $intQueryID = 0; var $arrRecord = array(); var $intRow; var $intErrno = 0; var $strError = ""; function dbConnect() { $this->Connect(); } function dbHalt($s...
Is there any function preserved to extract database configuration inside of my code, something like $db_user = drupal_get_dbuser(); $db_pass = drupal_get_dbpass(); ... ... ...
Hi. I want to implement a kind of xor constraint on foreign keys in mysql 5.1 There is this table, let's say Entity which can refer to two different kinds of valuesets represented by Tables ValsA and ValsB. Now I would like to implement a constraint wich makes sure that exactly one of those two is mapped, and the other one isn't. In ...
Dim sqlDataAdapter As SqlDataAdapter Dim sqlCmd As SqlCommand Dim sqlCon As SqlConnection Dim _result As Integer Dim filePath As String = Application.StartupPath & "\BACKUP\ClinicBackup.bak" Dim folderPath As String = Application.StartupPath & "\BACKUP" Private Sub FullBackUp() Try sqlCmd = New SqlCommand() sqlCmd.C...
FastDB is an open-source, in-memory database that's tightly integrated with C++ (it supports a SQL-like query language where tables are classes and rows are objects). Like most IMDBs, it's meant for applications dominated by read access patterns. The algorithms and data structures are optimized for systems that read and write data entire...
I am using SQL Server 2005 to Extract XML data. I would appreciate some help extracting the following XML snippet? <ELEMENT_A> <CHILD_A _attribA="ABC"> <CHILD_B Type="1"> <CHILD_C> <CHILD_D Type="1" Date="2010-08-31"> <CHILD_E _attribB="M0"> <CHILD_F>-0.32295</CHILD_F>...
i want to be able to edit a table in a sql server database using c# can someone please show me a very simply tutorial on connecting to the DB and editing data in a table thank you so much ...
I'm selecting columns from one table and would like to select all values of a column from a related table when the two tables have a matching value, separate them by commas, and display them in a single column with my results from table one. I'm fairly new to this and apologize ahead of time if I'm not wording it correctly. ...
i want to create an object with different key-value as attributes, for example: animal id name attribute id name and mapping animal_attribute animal_id attribute_id so i can have a entry "duck", which has multiple attribute "flying", "swimming", etc. Each attribute type would have its own table defining so...
i am running a script from visual studio 2008 to a sql server 2008 connection i am getting this message when i build: to debug this project you must enable sql/clr debugging for the connection. note that during debugging all managed threads on the server will stop. is this dangerous to do given that i have other databases on this ser...
I am using Visual Studio 2008 and I am a beginner. I am connecting to a SQL Server 2008 database. I would like to display data from a table. How do I do this? Can someone please show me an easy tutorial? ...
I am developing a Job application which executes multiple parallel jobs. Every job will pull data from third party source and process. Minimum records are 100,000. So i am creating new table for each job (like Job123. 123 is jobId) and processing it. When job starts it will clear old records and get new records and process. Now the probl...