A database is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If it is about a particular database management system, like MySQL for instance, please use that tag instead.

learn more… | top users | synonyms (3)

0
votes
0answers
4 views

Select AS is not working properly with jdbc

I am using JTable to display the result of a query. Table does not show as XYZ for all columns but it shows XYZ as a header for the fields not existing in database(manipulated fields). Don't know ...
0
votes
1answer
16 views

Database add connection screen

A while ago a created an application that would prompt the user for the database connection details. I found that Microsoft had created a control specifically for this purpose and they had released ...
0
votes
0answers
11 views

Task Dependency graph in a DATABASE

i need to store all the dependencies in a database for the folling use cases suppose there are 2 task A and B and A is dependent on B( Task A cannot happen before task B) i need to store it in a DB ...
0
votes
0answers
10 views

Assign value to checkbox from database pull

I'm trying to add a value to my checkbox. But It's not there when I'm trying to view it via inspect element. Here's how I do it. Database select: @amenities = ...
0
votes
2answers
18 views

Insert Unique Rows into Database Tables Using Java, Hibernate

I don't know this is already asked or not. But I don't find anyone. (Anyway this is not required for my project. But when I was working with database and Hibernate I had a doubt and now got time to ...
0
votes
3answers
19 views

How to define super user concept in MySQL DB for web application

I am developing the application in which i have a super user concept. Super user is the user who has all the access for the application. So what my initial thinking is in user table the user with id 1 ...
-3
votes
1answer
33 views

PHP Mysql database class error

I don't know why I am having this error. I'm using WampServer. I am trying to configure my database thru OOP and I came up with this error. Parse error: syntax error, unexpected '?>', expecting ...
0
votes
2answers
58 views

SQL - Join two tables but only show specific value

Alright so I've created a database called news which contains few tables with different information in them. I have two table's one named Employee's and the other table is called Article's. Now what ...
-2
votes
1answer
47 views

Update of Database [on hold]

Need help, my database created in visual studio 2010 for windows form application didn't update, why it is happen? if i run the program, add new record and save it, it works, but when i open the ...
0
votes
2answers
40 views

Get array of unique elements from Mysql

I have such query: SELECT id, forum_theme, owner, enter_time, main_topic FROM forum_message WHERE main_topic IN (1,2,3) ORDER BY enter_time DESC LIMIT 3 Array is changing, and I'm adding it in ...
0
votes
1answer
17 views

Upgrade database and refactoring database schema

I am very new to database design concepts. In my application we are using SQLite. Everything is working fine. Now because of the requirement changes we need to modify the database (need to remove some ...
0
votes
0answers
13 views

Database for tracking users on a website

Consider a website getting approximately 50K unique visitors daily. Now, I want to track the user visiting the website using pixel tracking. Before starting any development, I wish to decide about the ...
0
votes
1answer
9 views

testing database content that was generated by another process

I want to test the content of a database. this might sound stupid but we have a few scenario and this makes sense. For example each morning we receive a file having 100 records an ETL process those ...
0
votes
1answer
38 views

VBA: Loop isn't working as it should

Being new here I don't know if I can state my question really clear, but I'll try. I have this VBA code which extracts certain information from an access database into an excel sheet in relation to ...
0
votes
0answers
17 views

Windows Azure SQL Database

I am trying to understand windows azure SQL database functionality and it leads to some questions that I am looking to be clarified. 1)What we can do to get full SQL Server functionality in windows ...

1 2 3 4 5 3988
15 30 50 per page