I am building my wife a Contacts Manager program as a fun exercise in learning Silverlight 4. It will track peoples Addresses, Phone Numbers, Emails, Special Occasions(Birthday, Anniversary, etc) Along the way I hit a minor road bump while designing the Database. She would like to be able to group Contacts(people) by Family so I creat...
I tried to set up an eXist WebDav using my network Location area. The folders were created, but they won't open. And I have no idea why. I'm currently using Windows 7 Ultimate. I hope someone can help me. ...
Hey all, I've been developing a PHP-based CMS for use on my robotics team's website. Sure, there's plenty of other platforms out there, but what's the fun in that? In all seriousness, though, we do receive extra points for being able to say that we did more than make a template for Drupal or WP. This is a bit unrelated, but I'd like to...
I work a data transformation product that has a GUI interface that maps one type of object to another. So it has a bunch of elements on the left that maps to elements on the right. These can be XML, Java, or database. With database the product is built on top of Hibernate, so it creates the definitions based on importing the metadata and...
What can be the database for a search engine? I mean after creating inverted index for a site, where one could store it so that program can create indices for other sites and save them too. Later on indexer can query them also. Because indices can range in thousands of billions. Thanksyou ...
Hello All, I have created a crystal report using MySql 5.1, using XML (Dataset save as xml in application root folder) now when i run on my machine it works fine. But when app is installed on other machine it give database login required. how can i remove that login window ? The code is given below cDataSet.DataSetNam...
How do you design and manage the development of a web application that should be compatible with multiple database management system such as Oracle and MS SQL Server? If you can't use ORM like NHibernate or EF, how do you maintain database schemas during the development? My approach now is to have a development database on SQL Server...
I added a new field (type BLOB) to an sqlite table and the table size doubled from 50mb to 100mb. the field doesn't have any data in it yet. anyone know why this would happen? thanks for any help. ...
Hi, I have a persistence problem in my application. I'm using sqlite database. when some insert queries executed results temporary added to the database. After restarting application the new values vanish! I think new values stored on RAM do not save on hard-disk. -(IBAction)add:(id)sender { NSString *myDB; NSString *query; myDB=[...
Hi, I use Zend Oauth to connect my app to Twitter as described here: http://framework.zend.com/manual/en/zend.oauth.introduction.html It works perfectly saving the Twitter Request Token and the Twitter Access Token in the session using serialize and unserialize like this (abbreviated): 1: $consumer = new Zend_Oauth_Consumer($config); ...
Users in our application participate in forums and create various entities. In the schema you mark references from those tables back to the User table as foreign key references. We are unable to remove this user entry from the database, since it has several foreign key constraints which can be removed. One way of addressing would be t...
In you database and/or code. Do you avoid nulls or do you explicitly program to handle them in your logic? What is best practice on how to handle nulls? ...
How can I dump some of the tables from my mysql database into an sql file in C#? Is there a class which does this? UPDATE: just wanted to mention to DO NOT USE mysqldump, because this application will be installed on many computers and the mysql folder could be on different places. ...
I've been doing quite a bit of searching, but haven't been able to find many resources on the topic. My goal is to store scheduling data like you would find in a Gantt chart. So one example of storing the data might be: Task Id | Name | Duration 1 Task A 1 2 Task B 3 3 Task C 2 Task Id | Predecessors...
In the SQLite documentation on the write-ahead-log feature introduced in version 3.7, there are some comments which confused me a bit. The linked page says "syncing the content to the disk is not required, as long as the application is willing to sacrifice durability following a power loss". Then a couple of paragraphs down, it says "C...
Hy, I'm learning for my exams and came over the following question: Take the History (or Schedule) H = w1[x] w2[x] w2[y] c2 w1[y] w3[x] w3[y] c3 w1[z] c1 where w1[x] means: Transaction 1 writes to Data-Object X (r1[x] means read) and c1 means: Transaction 1 commits. Why is this transaction view serializable? For view Serializabilit...
Im reading a xlsx file as a db to do some work i noticed that its reading some feilds in as int and date even though i just want it all to come in as text . is there anyway to override this feature? Code below (feel free to point out anything i could be doing better with my code as well) private DataSet ExceltoDT(OpenFileDialog dia...
I am lost on multi-language implementation. How to handle it? Session, Cookies, File, ...other ways? Overview Website is a user content website, like a social network. We will have system content controlled by us and user content translated by users. Languages supported will be system controlled. To start there will be the top 20 suppor...
I need to know if somebody can read and save to oneself packages from my database, Oracle specifically. Can I prevent it? I mostly worry about tools like "Export schema" of Toad. How can I know somebody didn't something like exporting my database structure? ...
I'm having all sorts of trouble... Here is the code I'm using: $c = OCILogon('user', 'pass', 'host'); I get the following error: PHP Warning: ocilogon(): ociopen_server: Error while trying to retrieve text for error ORA-12514 in D:\Inetpub\wwwroot**\oracle.php on line 26 Anyone know what the hell I'm doing wrong? It's PHP4, II...