I have a separate class that includes the database, a cursor, and all the accessor methods for database information. I import the cursor into all the classes that update or use the database. However, I get a runtime error whenever I try to start an intent that uses the database. Any ideas on what might be happening? ...
i'm working on a MS access database.. At some point i needed to create a module which contains a dynamic string array, the data to store in this array should be brought from a table, i use count(*) function on that table to define the size of the dynamic array. what i need to know is how to fill the array with the contents of a columns...
I am planning for monitoring application which will use SQL 2005/08 database. It will monitor old server(s) which are using SQL 2000 db. Tools task is to pick the data from the servers do some statistics and insert the data back into tools own database for reporting purpose. I am using .NET(C#) as development environment. What i would ...
I am in the U.S. I have the following line in my web page: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> And my MYSQL table is MyISAM latin1_swedish_ci But when someone fills out a form with a foreign character it gets stored in MySql as garbage. An example would be an e with accent over it, etc. - something...
I'm testing different locking schemes for a big table, more than 4 million rows and expected to grow up to 10 million. My experience with SyBase: ALLPAGES, extremely slow BCP (in) and update with a field that belongs to the Primary Key. DATAROWS, fast BCP, fast update for fields in the PK, fastest select. DATAPAGES, fastest BCP and upda...
Can we return null value from stored procedure. i dont want to use collase or isnull. I want to capture NULL at the frontend. Is it possible ? Edit: I am using Sql Server 2005 eg. where i want to use CREATE PROCEDURE [Authentication].[spOnlineTest_CheckLogin] @UserName NVARCHAR(50) AS BEGIN TRY BEGIN TRAN ...
We used some Database Projects in VS2005 Professional. Am I correct in saying Microsoft removed support in 2008 Professional edition and moved it to Team System instead? ...
I have a server application, and a database. Multiple instances of the server can run at the same time, but all data comes from the same database (on some servers it is postgresql, in other cases ms sql server). In my application, there is a process that is performed which can take hours. I need to ensure that this process is only execu...
I have a need to support two separate database engines - MySQL and SQL Server. I do not want to maintain two different sets of scripts to create database objects (tables, views, stored procedures etc...), if possible. I wanted to find out if someone has experience in doing such a thing and what were the learnings. Any links to articles/...
In terms of database usage, the last decade was the age of the ORM with hundreds competing to persist our object graphs in plain old-fashioned RMDBS. Now we seem to be witnessing the coming of age of document-oriented databases. These databases are highly optimized for schema-free documents but are also very attractive for their ability ...
Are there any recomended field sizes for commonly used string data storage types? For example things like FirstName, LastName, AddressLine1, AddressLine2, City, State, PostalCode, EmailAddress etc. I am sure anyone who has created a table to store these commonly used data fields has had to make a decision as to what maximum size to use. ...
I am developing a simple WPF Application that requires a database. My question is, can I use an online database to run with my application. That is, can my WPF Application access an onlline database? If yes, then how do I do it? Will the conventional way of accessing the SQL Server work? Also, is there any free online database website av...
Is there an open source thesaurus available for download? It can be in any format. Preferably not from a 1915 dictionary. I need one to merge into a database application. ...
I removed some rows from a very large table. Then I ran a query that usually runs within a few seconds and found it to be running very slowly after deleting the rows. I re-built my index and ran my query and found it to be fast again. Could deleting those rows caused the index to be fragmented? ...
Hello, I want to know if open a transaction inside another is safe and encouraged? I have a method: def foo(): session.begin try: stuffs except Exception, e: session.rollback() raise e session.commit() and a method that calls the first one, inside a transaction: def bar(): stuffs t...
I have around 150 different databases, with dozens of tables each on one of my servers. I am looking to see which database contains a specific person's name. Right now, i'm using phpmyadmin to search each database indvidually, but I would really like to be able to search all databases and all tables at once. Is this possible? How wou...
Right I seem to be having a issue inserting a image into a database (don't ask why lol) If tryed a simple UPDATE player SET Image = load_file('94.jpg') WHERE id =94; And had the image directly located from where im running the sql commands from UPDATE player SET Image = load_file('C:\Users\***\Documents\databases\Scripts\94.jpg') ...
I have been working on porting some Oracle DB code to Postgres, and I am noticing some nomenclature differences (Schemas vs Databases) etc. What are some good resources for dealing with these gotchas? Any tips? What needs to be kept in mind? ...
I have content stored in a table with the following schema: id unsigned int primary_key, name varchar(20) I have two levels of users: 1.Content editor: Who can change content and submit for approval(involves deleting rows as well as editing fields) 2.Content admin: Who can see changes and approve them. The content editor works on a ...
Hi every1! ok so I have this code `$sql = "INSERT INTO userTable (username, password, gender, city, zip, email) VALUES ('$username', '$password', '$male', '$city', '$email')"; mysql_query($sql) or die ("unable to process query");` and for some reason it works on my local server but not on the webserver, all the variables are set for...