Hello All, I've just moved a forum from BradPPresents.com to BradP.com. May not be SFW. It's located at forum.bradp.com. I'm getting a Database connection error, despite being absolutely sure about the username and password of the database. Here's the VBulletin Configuration file, with the username and password masked. <?php ...
I am building a real estate website. I have a table for properties (i.e. "houses"), a table for pictures, a table for features, etc. So each property's data comes from three, not only one table. I need to provide a function that retrieves requested property data depending on a search criteria, for example: property of the week feature...
How would you maintain separate production anddeveloper databases when working on one machine, which you can toggle transparently? I've seen some close subjects but none of them seem to match. ...
I've been using SubSonic.Query all these while, until one day when I can't do "IS NULL" by adding WHERE, then I realized that SubSonic.SqlQuery existed and it has a function of "IsNull()". After checking out the source code, Query and SqlQuery is not inherited in any way, so what's their major difference and how to decide which to use? ...
Hi, It will be easier to explain with the next code (It's wrong, by the way): $selectGenre_sql = 'SELECT genreID FROM genres WHERE dbGenre = ?'; if ($stmt->prepare($selectGenre_sql)) { // bind the query parameters $stmt->bind_param('s', $genre); // bind the results to variables $stmt->bind_result($genres); // execute the ...
I'm pretty new to the ASP.NET world so I'm having a little trouble coming up with the best way to configure a connection string at runtime and have the entire application use that connection string. Here is a little more info on the application that I plan to build: Application uses Forms authentication, not Windows authentication The...
We use a Visual Studio Database Project for the source control of the schema of our database. We also want to script certain data (configuration values etc.) from the database, so we use a custom command line utility for dumping data into insert scripts. One file represents one table's scripted data. There is a certain SQL script, calle...
Ok, I have a problem that i've searched and searched for solutions to online and can't find any leads, here it is (oh, and i'm very new to this database stuff ;-) Lets say I have thousands of retail stores and each one can carry 1 to 100 products, but there are 10,000 possible products available. I need each store owner to be able to se...
Let's say I have one table that has 1000 rows and the other table with the same structure/index but 10 million records. Will the performance of CRUD operations on the bigger table be slower than the smaller one? Thanks. ...
I'm about to start a new project which should have a rather large database. The number of tables will not be large (<15), majority of data (99%) will be contained in one big table, which is almost insert/read only (no updates). The estimated amount of data in that one table is going to grow at 500.000 records a day, and we should keep...
First of all, i don't have much of a clue about databases, so please forgive me if this is a stupid question. My company is receiving a torrent of positional data via TCP. Each packet consists of a few floats and a timestamp. Our task is to store the data into a database (MS SQL Server 2005), running on a modern PC. Each blob has about...
I'm using a rather busy MySQL 5.0 database. What are the main reasons for me to migrate to MySQL 5.1? Does it worth the trouble? I use VS2008/.NET 3.5 Servers run as a MySQL cluster on Windows 2008 servers. Thank you for your answers so far. To be more specific - I'm looking for answers such as the one by Quanssnoi, listing the feature...
Is there an efficient way for a system to update tags for an item when presented side-by-side in a text box, similar to StackOverflow? In my web app, individual items have tags and I am using a link table between a tags table and the items table to keep some normality. Database schema are discussed here: http://stackoverflow.com/questi...
I have a database with a report table. This table represents report data, and has constraints. Now the application is used by firemen, and they might have to run off and put out some fires. So in the middle of filling out data for this table, they might have to run off. What we do is when the session run out we save the data to a draft t...
I have 2 servers running SQL Server 2005 with merge replication set up between them. Each server is connected to the building network, but they also have a cross-over cable connecting them creating a private network. How do I configure merge replication so it uses the private network and not the building network? The private network i...
I have an SQL Server 2008 database, which contains about 40 tables. Most of them contain at least a couple of varchar columns, and I want to convert every single one of those to nvarchar (of the same length). Also want to convert a number of text fields to nvarchar(MAX). Is there a simple, straightforward way to do this? ...
I'm toying with the idea to write another framework to make it easier to develop "bread'n'butter" applications (like create a class with N fields, get an editor for that for free plus the DB persistence). All data models can be converted into the Entity-Attribute-Value form: TYPE VARCHAR(32) ID LONG INT NAME VARCHAR(32) VALUE VARCHAR(6...
My co-worker is having an issue managing customers in his data-base. The issue is when an order goes through the customer needs to be added to the data-base. But if the customer exists we don't want to make a duplicate customer we want to keep the same customer and just add to their sales history. He is having a hard time figuring out ho...
I have what I think is a rather common use case for NHibernate. I create an entity and try to save it using ISession.Save() followed by a Transaction.Commit(). At this point, I expect violations of things like unique/primary key constraints to come up to me as exceptions. What I'm seeing, however, is just a GenericADOException. This does...
Any guidelines on how to pass a date parameter to a command1 object of Data Environment in VB6?? and yes I did search but didn't come across any :( ...