I am working on Desktop application with c# and Data base MySQl. When I install its installer on my machine it works fine but when I install it on other machine its give following exception when try to access DB. I am using MySQL.Data.dll to communicate with MYSql. --------------------------- Could not load file or assembly 'MySql.Dat...
Hello guys, I have this rather classic problem when interacting with databases of handling single quotes and special characters. In PHP I am escaping the single quote with another single quote and regex syntax characters with preg_quote and they are working as a pro. The problem is with javascript, there are some points in my s...
Hi All, I am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning) Which database i should...
Hay all, I'm making a website where a product can come in a variety of colours and sizes. Each item has a different 'item_code'. How could i link these together? I could have an option, so that when an admin adds a new product, it askes if this product is a variation of another product. If it is then finds ALL the linked products and all...
VB.NET tutorial for beginners especially for database, please can you give me some resources. ...
Hi, I am building a web application that uses PHP 5, MySQL 5 and Javascript with jQuery and AJAX. The application is a quite complicated selection process with several pulldown menus that the user can select from in any order. Each select in a pulldown will give some more selection critera, that will limit the choices in the other pull...
Hello when i run my application on server, the connection doesn't open --> my dataset is still closed Dim strconnect As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + "rootPath" + "\" + "VSS_TESTDB.mdb" + "Persist Security Info=False" Dim objConnection As New OleDbConnection(strconnect) Dim sql As String = "SELECT VS...
I have the following SQL query: SELECT Phrases.* FROM Phrases WHERE (((Phrases.phrase) Like "*ing aids*") AND ((Phrases.phrase) Not Like "*getting*") AND ((Phrases.phrase) Not Like "*contracting*")) AND ((Phrases.phrase) Not Like "*preventing*"); //(etc.) Now, if I were using RegEx, I might bunch all the Nots into one big (ge...
Hi, Is there anyway to use a PostgreSQL GUI to modify the database contents without doing a db:pull? I want to administer my database without taking it off line... Any ideas? Thanks ...
Hi, I'm trying to learn nested queries in mysql and I'm stuck while selecting all hotels which are 30 miles away from the city and have rooms that cost 150$ I can chose the rooms which are 30 miles away from the city and costs 150 with this query,but can't reach the hotels. (select id from Rooms where cost = 150 and id in (select...
We have a lot of code that passes about “Ids” of data rows; these are mostly ints or guids. I could make this code safer by creating a different struct for the id of each database table. Then the type checker will help to find cases when the wrong ID is passed. E.g the Person table has a column calls PersonId and we have code like: ...
I was asked to write a database and it's GUI frontend for some non-profit organization I am member of. The decision was to use .NET as I know C# fariy good and writing GUI is quite easy. I though of implementing local SQL Server database (as I worked earlier with MySQL) and connect to it via SqlClient interface. But then I discover some...
Problem1: What is the maximum no of columns we can have in a table Problem2: What is the maximum no of columns we should have in a table ...
I suspect that lots of business related software is designed to manage a particular set of information; customers, orders, leads or products and/or a combination. This has been the case in most of my experience. All other tables are usually data supporting the major ones. If this isn't the case, then assume it is for a moment :) because...
I have a bunch of items in my program that all belong to a specific category. I'd like to return only the items that belong to that category. The problem is that categories can have parent categories. For example, let's say there's a category "Stuff" with the child category "Food" with the child category "Fruit". I have the items, Ap...
This one is interesting to me - despite the almost inane title. I have used Firebird for a long time, but not until recently noticed an interesting behavior. I am using embedded firebird 1.5, and noticed that if I stuff the database full of blobs (lets say 10mb worth), the size of the database increases. I can then delete all the field...
I have an ecommerce store that I am building. I am using Rails/ActiveRecord, but that really isn't necessary to answer this question (however, if you are familiar with those things, please feel free to answer in terms of Rails/AR). One of the store's requirements is that it needs to represent two types of products: Simple products - t...
I'd like to save a plot image directly to the database. Is the best way in R to do this: Write the plot image (png) to the filesystem Read the file that was written Send the file to the database via query (RODBC) Ideally I'd like to combine steps 1 and 2 above by simply write the png image to a binary connection. Does R support thi...
I'm making a WPF program which is able to color the rows in a datagrid one by one in red using the 'for' loop and I've encountered something weird. If the datagrid has more than 40 rows of data from a database table, it doesn't color all the rows. Here's the code I'm using. private void Red_Click(object sender, RoutedEventArgs e) {...
I'd like to use ZODB directly from C++ and don't want to write Python code for that. Have you had any experience doing so? If I were to use C++ for GUI and quering/writing data from/to ZODB, how the design should be? ...