I've been reading a couple of questions/answers on StackOverflow trying to find the 'best', or should I say must accepted way, to name tables on a Database. Most of the developers tend to name the tables depending on the language that requires the database (JAVA, .NET, PHP, etc). However I just feel this isn't right. The way I've been ...
I am trying to create a simple login system. When I run the login form (with the correct username and password) it doesn't seem to run the php. Any suggestions? <?php $host="linuxserver"; // Host name $username="jparry2"; // Mysql username $password=""; // Mysql password $db_name="jparry2"; // Database name $tbl_name="customer"; // Tabl...
What is largest free datababase for SQL Server engine available for testing purposes? ...
Hi guys, this might sounds silly but I am super confused. I want to install drupal on localhost but I need to install a SQL database for it too. Which database package do I get (for free) ? I went to MySQL website but I do not understand which one I need to download, or if mysql at all.. ? I have win 7 32 bit and I only care that dru...
Honestly, I'm not even sure the best way to go about this, but essentially, I have a function in an include file that takes a $type parameter and then will retrieve/print results from my db based on the $type passed into it... What I'm trying to do is have a series of links on a page that, when you click on a certain link, will run the ...
Hello Stackoverflowers, I'm making a social community application with profile. User must be able to style their profiles. That's why i'm looking for a way to store and retrieve color values from a MySql database to style flex 3 components at runtime. Does anybody know how i could accomplish this. (I don't want to use Runtime css swf s...
I have two tables 'Elements' and 'Lists' Lists has a primary key and a list name. Elements has data pertaining to an individual entry in the list. Elements needs a column that holds which list the element is in. I've read about SQL's foreign key constraint and figure that is the best way to link the tables, but I'm using SQLite which d...
In Excel 2003 I'm getting a Runtime error 1004: "application-defined or object-defined error" on the last line of this code (commandtext = abc) Sub SCommandTxt() Dim abc as string abc = Sheets("Totals").PivotTables("PivotTable2").PivotCache.CommandText Sheets("Totals").PivotTables("PivotTable2").PivotCache.CommandText = abc End Sub T...
There are some free databases on the internet. But it's interesting to know, in what way they are formed. Can you suggest some? ...
Where I'm working, we have multiple database we need to be able to query. Some of them are predefined and we're using Datasources to access. Others are named after the customer id #. For instance _2. We have hundreds of customers and some customers can pose as other customers and depending on which customer is using the interface at t...
So I have some data in an Access table. I am well-versed in Access and am using it in this instance for its report-generating qualities and ease of use for the non-tech proficient. This is the only tool at my disposal. The data came to me as an .xls with a lot of junk and stuff basically all over the place. I made a bunch of queries to ...
Hi, I'm using JADE (Java Agent DEvelopment Framework) and need to set up a database back end. Does anyone have any recommendations for which database system would work well with the framework? ...
Hi everyone, I'm trying to validate the password entered by the user with the password in the database. I've worked out that it checks the username fine (if the username doesn't exist it displays an error), however when it tries to validate the password with the mysql password it never works. The working 'example' is at http://scaperscle...
I have a table with the following structure: Col1 Col2 --------------- 1 2 3 4 I need to Query in the such a way that the output should be like: ColumnName | ColumnValue ---------------------------- Col1 1 Col2 2 Col1 3 Col2 4 Any help in this will be greatly appreciated. Th...
Hi, I have a quesion regarding tracking changes of database records/entityspace objects. Iam using webservices and passing enityspace objects to WPF client through webmethod. These objects will be assigned to a custom class in WPF application. Custom class is tied to UI of WPF. I want to track changes of Entityspace objects when saving...
Language VB.NET (VS 2008) Database: ACCESS The DataView doesn't seem to be filtering correctly. It seems to automatically filter out null values even though it is set to "Serial LIKE '%" & tcSerialTB.Text & "%'" Code: ci = New DataTable("Capital") Dim cid As New DataColumn cid.DataType = System.Type.GetType("System.Int32") cid.ColumnN...
In my Django application, I repeatedly run the same query on my database (e.g. every 10 seconds). I then create an MD5 sum over the queryset I receive and compare that to the MD5 sum I created in the previous run. If both are equal, the data has not changed and the web page does not need updating. While I do this, the data in the DB mig...
I had a problem this week (which thankfully I've solved in a much better way); I needed to keep a couple of fields in a database constant. So, I knocked up a script to place a Trigger on the table, that would set the value back to a preset number when either an insert, or update took place. The database is RDB running on VMS (but i'...
Is it posible to duplicate an entire MySQL database on a linux server? I know I can use export and import but the original database is >25MB so that's not ideal. Is it possible using mysqldump or by directly duplicates the database files? ...
Hi there, i'm trying to request any records from a table that appear on or after todays date, using a single query. All the dates for each record are stored in seperate columns eg. - one for 'month', one for 'year', and one for 'day'. obviously i've been getting all records that occur after the year in today's date $sql = "SELECT * FRO...