I am trying to write a MySQL query that retrieves one record from table "projects" that has a one-to-many relationship with table "tags". My application uses 4 tables to do this: Projects - the projects table Entities - entity table; references several application resources Tags - tags table Tag_entity - links tags to entities Is it p...
It's quite possible a question like this has been asked before, but I can't think of the terms to search for. I'm working on a photo gallery application, and want to display 9 thumbnails showing the context of the current photo being shown (in a 3x3 grid with the current photo in the centre, unless the current photo is in the first 4 ph...
Any simple, but secure script available for Flash > MySQL DB integration? I need something for a Login DB. Exchanging variables with PHP is nice and easy, but obviously insecure. via Remoting? I've got the Flash 8 remoting components installed, and some ideas: idea-1, idea-2. via NetConnection? Got some leads: lead-1, lead-2. Cold Fu...
I'm about to start developing a product (in .NET), and I'm evaluating open source database engines in order to avoid adding licensing costs to the overall cost of my product. Which ones do you know that are potent? Is MySQL a good alternative? What kind of website load can it support? Do you have any experience using an open source dat...
hi, Im writing a program at the moment(below) that interacts with a MySQL database and im having a problem. As you can see ive written a query that will look for products in the products table that corresponds to the barcode that the user has inputted. If the barcode that is inputted by the user is found in the products table, I want to ...
I want to execute some mysql statements that are stored in a text file from my C program using the mysql.h library. My inclination was to do something like the following, but this doesn't work: mysql_query(conn, "source test.mysql"); This is because the SOURCE command is not a mysql statement in and of itself. Is there a way call ...
We are working on a database solution for a high available (5 9s) application with high performance and data consistency needs. We are planning to use MySQL Cluster as the primary in-memory datastore backed up by a secondary innoDB MySQL datastore for persistent storage. The proposed approach is that the online application will only inte...
I seem to have a problem with this SQL query: SELECT * FROM appts WHERE timeStart >='$timeStart' AND timeEnd <='$timeEnd' AND dayappt='$boatdate' The time is formatted as military time. The logistics is that a boat rental can be reserved at 7am til 1pm or 9am til 1pm or 9am til 5pm. If there is an appt within that range, it should ...
Is it possible to directly access MySql databases through an Adobe AIR/Flex application? If not, what is the next best alternative? ...
How can I limit a result set to n distinct values of a given column(s), where the actual number of rows may be higher? Input table: client_id, employer_id, other_value 1, 2, abc 1, 3, defg 2, 3, dkfjh 3, 1, ldkfjkj 4, 4, dlkfjk 4, 5, 342 4, 6, dkj 5, 1, dlkfj 6, 1, 34kjf 7, 7, 34kjf 8, 6, lkjkj 8, 7, 23kj desired output, where limit ...
Is there an easy way to do a GROUP BY DATE(timestamp) that includes all days in a period of time, regardless of whether there are any records associated with that date? Basically, I need to generate a report like this: 24 Dec - 0 orders 23 Dec - 10 orders 22 Dec - 8 orders 21 Dec - 2 orders 20 Dec - 0 orders ...
I'm working with a MySQL database that has some data imported from Excel. The data contains non-ascii characters (em dashes, etc.) as well as hidden carriage returns or line feeds. Is there a way using MySQL to find these records? ...
I am trying to install and configure MySQL 5.0.41 on Windows Vista Home Premium and am getting the following error message: Could not connect to the Service Control Manager. Error: 0 I am running the installer via an Administrator account, so I'm not sure why it would not have access to this. Any ideas? ...
I am trying to connect to a remote MySQL database using Visual C# 2008 Express Edition. Is there a way to connect using the editor, or do I have to code the connection manually? The editor has a clear and easy-to-follow wizard for connecting to Microsoft SQL Server and Access databases, but I don't see an easy way to add a remote MySQL d...
Hi, I'd like to use a single SQL query (in MySQL) to find the record which comes after one that I specify. I.e., if the table has: id, fruit -- ----- 1 apples 2 pears 3 oranges I'd like to be able to do a query like: SELECT * FROM table where previous_record has id=1 order by id; (clearly that's not real SQL syntax, I'm ju...
I'm hoping someone can help me with this problem. I have a small app to 'patch' our DB as we need to augment the functionality and fix bugs. It reads in the patches which are just files with SQL statements and does some internal housekeeping, querying the DB and applying the patches that haven't been applied. Anyhow, this is the solut...
I'm working in a project where we develop php on Zend using a mySQL database and the project is about to get to a point where it will be necessary to use version control not only for the actual code but also for the database. Also we are getting a good production server (and the actual production server will be a test server). So i w...
I'm trying to connect a C# application (using Visual C# 2008 Express Edition) to a remote MySQL server. I have the drivers for this, but when I followed the tutorials (including adding the pooling and connection reset properties), I get an error that: Object reference not set to an instance of an object. I've included the two lines of co...
hi, i have a small problem with a program that im writing. I have a table - stocks which contains information(products, barcodes etc.) about items stored in a fridge. I then have another table - shop which acts like a shop,containing loads of products and their barcodes.some of the products in the shop table are in the stock table at the...
I'm now using Visual Studio 2008 Pro Edition. I installed Connector/Net 5.2 with Visual Studio integration. I restarted Visual Studio, and MySQL database now appears in the list of data providers. I entered my database information, and clicked "Test Connection" and it succeeds, but when I try to close the Add Connection dialog, I get an ...