Hi, I am ready and see all the tutorials and videos to configure the subsonic 3.0.0.3 with MySql and fail to genarate the ActiveRecords.cs. I use the MySQL.ttinclude in the folder to generate the class but it is still not working. I rename all the refenreces to SQLServer.ttinclude to MySQL.ttinclude and it still does not work. The error...
How can I use memcache in Joomla? I'm a newbie in this field so please be descriptive with your answer. ...
I'm wondering what are are the pros/cons of the new PBXT Engine vs the good old one InnoDB? Where can I find a list of features and maybe some benchmarks comparing these two DB engines? ...
Im using Mysql server version 5.1 and we have nearly 2 lakh records I need to know how much time will the mysql query takes to complete for Insertion, deletion, updation and for selection. Can anybody help me? ...
Hi all. MySQL++ is licensed though LGPL, that means that I could release an executable dynamically linked against it without worrying about the source code not being GPL. But, MySQL++ DOES link against libmysqlclient{_r}.{a,so} ( http://tangentsoft.net/mysql++/#linkerrors ) which is GPLed. As seen as then MySQL++ is technically just a '...
Hey, I've been thinking about this one for quite some time now, I need a way to add replies to comments in the database but I'm not sure how to proceed. This is my currently comment table (doesn't say much but its a start): CREATE TABLE IF NOT EXISTS `comments` ( `id` int(12) NOT NULL AUTO_INCREMENT, `comment` text, `user_id` in...
Hey there, I've got a pretty basic setup in Visual Studio 2008 - Website project referencing my Class library project. SubSonic 3 is referenced from both projects, but the Template has been modified for my MySQL db. It connects and generates the most of code (Accept for StoreProcs for some reason), and the namespace is there, and my ...
Hello All. I want to make an anouncement system. But i messed the database design part. The system will have unlimited categories and their items so every category will has strange properties for example car has a model, trade, manufacture date, color, gear type. . . and more another example Real Estate has a door count, gardened, du...
I want to pull results and count how many of each name is pulled but without grouping... for example I want this: John Doe 3 John Doe 3 John Doe 3 Mary Jane 2 Mary Jane 2 instead of this: John Doe 3 Mary Jane 2 Does that make sense? Thanks. ...
I have an application which collects data into a mysql table. The table has no unique id column, so I can't reference a specific row by id. I want to write a dump application which every day dumps the new rows added to the table to upload them elsewhere. I could do it by adding a unique id field and storing the last id dumped, but I don...
I have a large (about 10 GB with a 20 GB innodb buffer pool) database, and have noticed that when I start it, for about the first half hour it's running, the database will periodically lock and unlock all tables, making it quite unpleasant for users who attempt to access our site for the first half hour after a database restart. While I...
I am creating an application (VS2005, C++ Forms application) that is supposed to work on many different machines that won't have any version of Visual Studio and I am wondering what I should worry about. I am using the Mysql connector, so apparently the machine running it will need to have some compatible version of MySQL, but appart fro...
Hello! In MYSQL you can choose a length for the VARCHAR field type. Possible values are 1-255. But what are its advantages if you use VARCHAR(255) that is the maximum instead of VARCHAR(20)? As far as I know, the size of the entries depends only on the real length of the inserted string. size (bytes) = length+1 So if you have the wor...
I have a PHP codebase that was written to address our MySQL tables in mixed case. For example, xar_intakeformgenerator_ChangeLog. Our code also runs on windows, and before we knew any better, we imported several databases on to a Windows server. This resulted in Windows MySQL changing all the table names to lower case. (xar_intakeform...
I've spent quite a lot of time today trying various things, but none of them seem to work. Here's my situation, I'd like to be able to select the rank of a row based on it's ID from a specifically sorted row For example, if my query is something like: SELECT id, name FROM people ORDER BY name ASC with results like: id name 3 A...
Given 2 fields of type datetime in mySql which look like: 2009-07-26 18:42:21. After retrieving these values in PHP, how can I compare the 2 time stamps to figure out how many seconds have elapsed between them? I tried simply subtracting them but that didn't to work. ...
Hi, I have 4 tables for each month; oct, dec, feb, apr. They have the same schema. I need to extract the data from all the tables using the same query and grouping it for one attribute. I know how to do it for one table but I would like to combine the results into one query and then dump the output into the file. Here is my sample qu...
I need to check (from the same table) if there is an association between two events based on date-time. One set of data will contain the ending date-time of certain events and the other set of data will contain the starting date-time for other events. If the first event completes before the second event then I would like to link them u...
Some of my combined values have a comma in the textfield, is there a way I can specify the character with which to be concatenated by, instead of a comma? ...
Is this possible or do I have to list all the columns? INSERT INTO table_name (column1, column3, column2,...) VALUES (value1, value2, value3,...) Do I have to list all the columns in order and have values for each one? ...