Hi friends, I use codeigniter. I have a multiple image upload form. The code below is working well for uploading, but I also need to save file names to database. How can I get the names in here? I spent hours & hours :/ but could not sort it :/ Appreciate helps!!! uploadform.php echo form_open_multipart('gallery/upload'); <inpu...
how to database connectivity between mysql and eclipse java? plz tell me hw it can be done? ...
Sometimes we load data from a lot of sources, like files, streams, etc. Well ... to do it with low headaches, we usually disable foreign keys checking, the problem is that when we do get some foreign key constraint violations that we are not warned of that. How can we check this after restoring foreign key constraints? ...
We have an IBM UniData server. I just installed UniObject .net. It looks like you just issue unidata queries through the .net classes. Where can I learn the query language/syntax and to work with UniData in general? What books, sites, or videos do you recommend? ...
Basically it's a financial database, with both daily and intraday data (date,symbol,open,high,low,close,vol,openinterest) -- very simple structure. Updates are just once a day. A typical query would be: date and close price of MSFT for all dates in DB. I was thinking that there's got to be something out there that's been optimized for...
I have a WPF app that updates my database from an in-code entity model. There may be instances that it updates the DB while there are users connected and I would like to put it in Single-User-Mode to avoid errors. I would also like to avoid using sql. I am aware that I can run sql using: DataContext.ExecuteCommand("ALTER DATABASE..."...
I need to design and implement something similar to what Martin Fowler calls the "Unit of Work" pattern. I have heard others refer to it as a "Shopping Cart" pattern, but I'm not convinced the needs are the same. The specific problem is that users (and our UI team) want to be able to create and assign child objects (with referential in...
Let's say you have many applications in your environment all of which store their connection strings to SQL Server in a web config. Is it possible to have the application retrieve those connection strings from Active Directory? We're moving some database servers around and would like a way to have them read from a central location. Acti...
I'm always asking myself should I create an index or not in my Oracle tables, what criteria in a table makes the index worth creating? And is it also a criteria in the query? And are there (with respect to Oracle) different kinds of indexes you can create based on some factor(s)? ...
I have a MySQL database, containing a table with an auto_increment primary key. Consider the following definition as sufficient for this example: create table test(id integer not null auto_increment primary key) engine=innodb; Now, typically I would insert into this table using the following syntax: insert into test() values(); Th...
I am designing a system that will allow users to take data from one system and send to other systems. One of the destination systems has a sophisticated SOA (web services) and the other is a mainframe that accepts flat files for input. I have created a database that has a PublishEvent table and PublishEventType table. There are also n...
Hello all, how can I pull masterpage content from the database and pass that into the masterpage so that my Views inherits from it? This is an example: Clients to the website will have a unique code, lets call it "TargetCode", for example, ABC123, ABC456, etc... This unique code will be entered in the querystring, for example: mysite.co...
Is it possible to get a history of queries made in postgres? and is it be possible to get the time it took for each query? I'm currently trying to identify slow queries in the application I'm working on. I'm using Postgres 8.3.5 ...
Is it possible in DB2 to detect if the table is locked or not. Actually whenever we use Select statement and if that table is locked [ may be because of on going execution of insertion or deletion ] , then we have to wait till the table is unlocked. In our application sometimes it goes to even 2-3 mins. What i think is, if i can have s...
any advise on backing up millions of data? or use tips in mySQL or software to the backing up job?? ...
We are currnetly looking at redeveloping an Interanet application that was created it would appear with Pervasive SQL and Tango (it usues TAF fiels so this is out assumption). Looking at the Pervasive website I cannot even find any references for Tango now. Is this product no longer being sold or used? Are there any resources availabl...
i have a <h1> that has a news title in it and i want to insert the content of this <h1> into sql server 2008 database how can i do this using c# ...
Is there something like HSQLDB (for Java) which can be run in a storage-in-file mode for C#/.NET 3.5? ...
Where can I find sample data of medical information? Data on medicines, diseases, etc. and preferably in a format easy to import into an SQL database. ...
What is the best way to check if a table exists in MySQL (preferably via PDO in PHP) without throwing an exception. I do not feel like parsing the results of "SHOW TABLES LIKE" et cetera. There must be some sort of boolean query? ...