I have two tables. Posts and Replies. Think of posts as a blog entry while replies are the comments. I want to display X number of posts and then the latest three comments for each of the posts. My replies has a foreign key "post_id" which matches the "id" of every post. I am trying to create a main page that has something along the...
Hi, I'm a research assistant for a university. We're retooling our Software Architecture subject, hoping to "modernize", and address some of the teaching and collaborative learning issues we've discovered in past semesters. Students are asked to rapidly build a prototype of their architectured system using Eclipse. For persistence, we...
Let's say I have a table with a Date column. In my C# application, I want to be able to query for rows using the LIKE operator on the DateTime column. My problem is, how do I handle the regional settings? For example, if the current regional settings are set to de-DE, the date format of windows is dd.mm.yyyy. Now the user might enter so...
Fatal error: Call to undefined function mysql_connect() in /opt/lampp/htdocs/cake/cake/libs/model/datasources/dbo/dbo_mysql.php on line 370 //shell <?php class ReportShell extends Shell { var $uses = array('Customer'); function main() { $customers = $this->Customer->find('all'); var_dump($customers);...
hi guys, i have only very limited exposure with .net 1.1 and a bit of 2.0, so i'm actually pretty excited and confused with the many changes that they have in .net 3.5. so i have this access database but we don't want the other programs from calling into this database directly. so i'm writing a wrapper exe which will contains functions w...
I've been asked by a client to make an online tracking system for work we do for them (we will be typesetting a high volume of books for this client). Basically, it would be a database showing the books we are currently working on, with information on what stage of the project we are at, and estimated completion dates. The only people wi...
How do I get the last insert id from a database using a ODBC connection? I'm looking for a solution similar to the mysql_insert_id() function. ...
What is the best database strategy for paginating a blog entry or page content where some entries may be a single page and some may span multiple pages? Note: The content would be article-like rather than a list of items. The method that I'm currently considering is storing all of the content in a single text field and using a page sepa...
I had a developer tell me recently that you should ALWAYS do database calls asynchronously. (Either using ThreadPool.QueueUserWorkItem or IAsyncResult and delegates) His justification was this: IIS only has 24 (or so) threads that it can use for requests. When a user makes a request they get one of those threads. However, when you use a...
I have created a VSTS database project by importing an existing database schema. Upon importing I get a slew of (thousands) of TSD3025 warnings on the project that aren't clear as to how I might resolve them. I don't get what it means by cross-database since the objects in question are all contained within the same database. Exam...
You usually normalize a database to avoid data redundancy. It's easy to see in a table full of names that there is plenty of redundancy. If your goal is to create a catalog of the names of every person on the planet (good luck), I can see how normalizing names could be beneficial. But in the context of the average business database is it...
I'm designing a web application for a team that is currently tracking all of their data in a Microsoft Access database. The new database will be stored in mySQL, but I don't know enough about Microsoft Access to be certain that I'm doing things correctly. Is there a tool or procedure that exists that will quickly create all the proper t...
Should I use PostgreSql, MySql, Oracle or SqlServer for storing documents / binary files ? Are there any performance benefits of using one or the other? Are there any advantages/disadvantages? Documents stored will be mainly excel files, image files, pdf's and images. ...
I have a large set of NUnit tests; I need to import the results from a given run into a database, then characterize the set of results and present them to the users (email for test failures, web presentation for examining results). I need to be tracking multiple runs over time, as well (for reporting failure rates over time, etc.). The...
Hi all, I roamed the site for this question using the search engine, and I don't think it's out there. If it is, apologies in advance and feel free to point me to it. Here is my scenario: I am setting up a web application, Moodle if anyone is familiar with it, with Apache, MySQL, and php on Windows. Moodle supports enabling SSL for ...
I am looking for a hot backup system for mysql databases? I like to ask you for experiences and expertise. ...
in Access DB... I need to extract the itemcode / desc combination for each itemcode in the following table where the desc has been used most frequently. most frequently could possibly mean that there was only one version (see added record for pear) in the case of itemcode 777, I'll have to decide later which description version to use....
Duplicates Why should I use document based database instead of relational database? Pros/Cons of document based database vs relational database I don't know much about Google's BigTable but am wondering what the difference between Google's BigTable and relational databases like MySQL is. What are the limitations of both...
I'm trying to write an embedded (NOT web, not enterprise) content management system in Java, with a focus on organization and ease of use and scalability to 100,000 or so items. The user & system should be able to create and define metadata items which can be associated with unique resources, to allow for searching. For example, they c...
I have a report that calculates multiple date differences (in business days, not DATEDIFF) for a variety of business reasons that are far too dull to get into. Basically the query (right now) looks something like SELECT -- some kind of information DATEDIFF(dd, DateOne, DateTwo) AS d1_d2_diff, DATEDIFF(dd, DateOne, DateThr...