Should dates for a temporal database stored in one or 2 tables ? If one doesn't this violate normalisation ? PERSON1 DATE11 DATE21 INFO11 INFO21 DEPRECATED PERSON2 DATE21 DATE22 INFO21 INFO22 CURRENT PERSON1 DATE31 DATE32 INFO31 INFO32 CURRENT DATE1 and DATE2 Columns indicate that INFO1 and INFO2 are true for the period between DATE1 ...
Hello this SQL statement "select firstname,lastname from users where lastname in('foo','bar') group by firstname" it means select all records in table "users" where lastname match any of the "foo" or "bar" I don't want this behaviour what I want to retrieve is all records in "users" table where lastnames match all of "foo" and "b...
Hi, I have an application that I need to query lifetables (for insurance calculation). I was thinking about using XML to store the data, but thought it was a little big, but maybe a little small for using a full-fledged database. So I chose to use SQLite. In my application, I have enums defining a few different things. For example, GEN...
New to appfuse - I like the concept. I configured the username/password to the database in jdbc.properties. It didn't work. So I also configured my credentials in pom.xml Why is it so? Am I doing something wrong? ...
Hi All, I need to test the connectivity if the Oracle::OCCI::Connection, and how can i get and set the connection timeout value? i read the documentation of Oracle OCCI but i can't find the required functions. Thanks in Advance. ...
I have here a medium sized intranet site which is written entirely in Zend FW. The database for the intranet is located on another server. Now I need to extend the intranet with some new functionality. In order to do this I need to connect to another database on the same server (and same DBMS). The question is now: What is the best way ...
I have a database in Interbase and I want to access it directly from my Rails app using ActiveRecord. How can I do it? ...
Like most people, I work on a data-driven object-oriented business application. I use a relational database to store my data. I have designed my application so far that I never store computed values. That is, if a user would like to consult the output of a "simulation" he ran last year, my application would simply recompute the report ...
It is said here: http://www.ibm.com/developerworks/web/library/wa-dbdsgn2.html Each table in the DB should have a history table, mirroring the entire history of the primary table. If entries in the primary table are to be updated, the old contents of the record are first copied to the history table before the update is mad...
Lets say I have a datbase of Cars. I have Makes and Models (FK to Makes). I plan on having users track their cars. each Car has a FK to Model. Now, I have a lot of users, and I want to split up my database to distribute load. The Makes and Models tables don't change so much, but they need to be shared across shards. My thought is to use ...
I was originally looking for a basic tutorial on how to get started using client-side databases in FF3.5. My understanding was that this feature is support in FF, Safari, and IE8. However, I'm running into a pretty basic problem, which is that the syntax to created such a database doesn't seem to be found in FF3.5. For example, to creat...
I have a dataset that contains: Table { date itemName } The date for the most part is sequential. There are no duplicates of the date [as it is the primary key]. The question is split up into multiple parts (all with respect to using SQL): Is it possible to find gaps in the date series listed in the table? For example: Dates 1/2/09...
I am trying to execute a query like "show tables". But I don't know the column names that will be returned by the query. I've tried using something like RS.Fields(1).Name to show me the names but that doesn't seem to work. Any suggestions? Here is the full code: Response.Buffer = true Dim oConn, oRs Dim qry, connectst...
How to get column size from database in .NET? ...
what is best suited Data type for mobile no. , longitude and latitude??in Mysql And oracle ...
hi, can someone please tell me the elegant way of inserting a java date instance into database? presently, i am using IBATIS with Spring MVC . i have defined a java.util.date property in the command bean and property editor in the controller for Date conversion, however i am unable to insert java.util.date property in DB . should i c...
appfuse: Embedded error: java.sql.SQLException: Field 'x' doesn't have a default value ...
I have a Java application and have mapped a boolean field to a bit(1) field in MySql. I know for sure that some rows have the value set to true and some to false, however, I can't see it from the mysql console - which is annoying when you try to debug things and understand what is going on. Is it possible to configure mysql to display ...
I'm having trouble getting my data from fetchAll to print selectively. In normal mysql I do it this way: $rs = mysql_query($sql); while ($row = mysql_fetch_array($rs)){ $id = $row['id']; $n = $row['n']; $k = $row['k']; } In PDO, I'm having trouble. I bound the params, then I'm saving the fetched data into $rs like above, wi...
Hi all, I am storing pages for websites in a 'pages' database table, they are referenced by their path (i.e. 'articles/my-first-blog-post'), I need to select all the children of a particular page, but without selecting grandchildren. So if I run: SELECT * FROM pages WHERE path LIKE 'articles%' I'll get pages with the following paths:...