Hi, I am using CakePHP framework with MySQL database and I have problem in saving one particular value to the database. I have a table called 'Attributes' with fields,id,form_id,label,type,size and instructions. When a link is clicked,default values are stored in the table for these fields. Now I added a new column called 'required' t...
I have a fairly standard OLTP normalised database and I have realised that I need to do some complex queries, averages, standard deviations across different dimensions in the data. So I have turned to SSAS and the creation of OLAP cubes. However to create the cubes I believe my data source structure needs to be in a 'star' or 'snowflak...
I have a checkbox named required,where if the checkbox is clicked its value is 1,otherwise its 0. The value is correctly passed form the view file to the controller. The model file gets the value from the controller, but the value is not being saved. I echoed the required value in the model,to check if the value is received. The value i...
I am using mysql How often do you back up your database? How do you normally backup your database? Export all data into sql or cvs format and keep it in a folder?? ...
Hello, As I had written in title, I have SQL query, run on Oracle DB, lets say: SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe' If I would like, that the query would return either "IGNORECASE", "ignorecase" or combinations of them, how can this be done? Is this possible? ...
In my database, I have 3 tables that have 2 similar columns, Year and Month. These tables aren't linked by anything. What i want to do is select the distinct year and months from these tables. So where table 1 contains: 2009 MAY (multiple times) 2008 NOVEMBER (multiple times) 2007 MAY (multiple times) and table 2 and 3 contains: 20...
I've been looking all over the internet and I can't find an acceptable solution to my problem, I'm wondering if there even is a solution without a compromise... I'm not a DBA, but I'm a one man team working on a huge web site with no extra funding for extra bodies, so I'm doing the best I can. Our backup plan sucks, and I'm having a re...
Can someone tell me why I get error: Msg 207, Level 16, State 1, Procedure ExtractPDP4FromPDP, Line 21 Invalid column name 'ContainsEX'. when executing the following stored procedure. CREATE PROCEDURE ExtractPDP4FromPDP -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result se...
Hey everyone, I got a simple problem in SQLAlchemy. I have one model in a table, lets call it Model1 here. I want to add a row in this table, and get the autoincremented key, so I can create another model with it, and use this key. This is not a flawed database design (1:1 relation etc). I simply need this key in another table, because ...
I've tried to motivate myself to learn databases several times now, but I'm having a hard time seeing where they're used. I don't do any web development nor any scientific computing, so is there anyplace where I could reasonably use a database? ...
How would i get the number of fields/entries in a database using an SQL Statement? Thanks, Ash ...
I didn't design this table, and I would redesign it if I could, but that's not an option for me. I have this table: Transactions Index --PK, auto increment Tenant --this is a fk to another table AmountCharged AmountPaid Balance Other Data The software that is used calculates the balance each time from the pr...
Here's what I have, which has problems: public User addUser(final String name, final String uid) { final List<User> result = findByProperty("uid", uid); if (!result.isEmpty()) return (result.get(0)); final User user = new User(name, uid); saveOrUpdate(user); return (user); } where findByProperty is usin...
The PL/SQl cursor was getting hanged due to some reason, this makes my app to hang when try to loop through the ResultSet.Is there a way to handle this, like timing out the resultset if the database hangs? ...
Assuming that best practices have been followed when designing a new database, how does one go about testing the database in a way that can improve confidence in the database's ability to meet adequate performance standards, and that will suggest performance-enhancing tweaks to the database structure if they are needed? Do I need test d...
I'm working through some MSDN examples, and some books on ADO.Net. What they all have in common is using the point/click/drag-drop design time feature in Visual Studio to develop database applications, binding data sets to controls etc. And the resulting code does all DB access in the GUI thread, as far as I can tell. This sounds like b...
Hi, I've got a table in my database where there can only be 1 row per non-identity attribute tuple. Whenever we insert a row, we first check to see if a row exists with those values, if not, we insert it, otherwise we use the ID from the existing row. In the example below, there would be a Unique Index on (Id) and (Attr1, Attr2, Attr3...
My database has a table with thousands of records. The primary key is an integer. There's a lot of foreign key constraints associated with this column. I want to change this column to become an identity key. What's the best way to do it? I also need to send this update to our clients installations. Bonus points for an answer that work...
I want to retrieve all the data from 3 tables users , properties and users_properties. So I decided I would use the manytomanyRowset. But to my surprise I get the data from the properties and users_properties table but no data from the users table. Why is that? I need some columns from the users table is there a way to tell the manytom...
I need to add an entry into a database everytime a field changes in a form indicating the old value and the new value. How would you go about this?? Would you... Add a hidden field for every field and compare it to the new value on submit then add an audit entry if neccessary?? Do a select of the data to be inserted on post then comp...