Tagged Questions

A database is an organized collection of data.

learn more… | top users | synonyms (3)

1
vote
1answer
13 views

MYSQL: Can I use outer query table alias inside subquery

Here is my query: select uact.onAssetID as AssetID, a1.value as AssetValue, uact.CommentID, a2.value from useractivity uact inner join asset a1 on uact.onAssetID=a1.ID inner join (select * from asset ...
-2
votes
1answer
26 views

Displaying specific data from database

I have a database that contains data and I want to display it, but I want this database have table rows which contains "0" and "#" and I want to display all the data but "0" and "#"; I'm asking if ...
0
votes
0answers
4 views

Google Sites ListItem Data to Database Event

I have a Google Sites site with a List page. I want to get the data from the ListItems into a database (ScriptDB or JDBC to MySQL/SQL Server.) I'd like to fire an update as a result of an onUpdate ...
0
votes
1answer
11 views

Error backup sql database but succeed creating database dump file

I tried this following code to backup mysql database into file and it works perfectly create the .sql file I need. function backup_tables() { $host='localhost'; $user='root'; $pass=''; ...
-1
votes
0answers
16 views

PL/SQL: ORA-00904: invalid identifier

I am trying to retrieve the difference from 13 and date_of_birth... just as integer... not date.. but this error is shown... ERROR at line 10: PL/SQL: ORA-00904: "STUDENT_ID": invalid identifier 1. ...
0
votes
1answer
25 views

what platform/database should be used?

I am planning to develop a website. The website will have 50k-100k users in near future, so good performance is important. Data flow from/to server will be average. Apart from this, I need to have ...
0
votes
1answer
26 views

Selected value of dropdown list does not change in asp.net

I have a dropdown list in asp.net and it has data binded to it. Here it is: <asp:DropDownList ID="dPrereq1" runat="server" DataSourceID="SqlDataSource2" DataTextField="FullName" ...
0
votes
1answer
9 views

Issue Regarding Garbage Collection/Auto delete on MySQL table

I am writing a few tables for a MySQL database, and within those tables I have entries that I only need for a few weeks. For example: create table LoginAttempts ( ReferenceId int unsigned ...
-1
votes
0answers
13 views

Add the dependence constraint in database is a good thing or bad thing?

Recently, i have a trouble.Our project used the Hibernate framework.but our project not add the dependence constraint in database.and my leader don't let's me use the dependence mapping to select the ...
0
votes
1answer
19 views

Change Display of Column Name in DetailsView

I'm creating a page where a user can edit their user information. I'm using a DetailsView control in ASP to display the data. How do I change the names of the field e.g. "FirstName" display as "First ...
0
votes
1answer
34 views

Storing many to many relationship objects in a column on database

I have an object called listings, and a listing can have a number of amenities (compare this to post, tags model). It's a sort of has/doesn't have relationship. So I have an amenities table which ...
0
votes
2answers
22 views

Zend Framework 1.x - How do I get data from database?

I connected to database by using php.ini: [production] phpSetting.display_status_errors = 1 phpSetting.display_errors = 1 bootstrap.path = APPLICATION_PATH "/Bootstrap.php" bootstrap.class = ...
0
votes
2answers
29 views

PHP database connection not displaying

I created a db connection and now I am trying print_r the results just to get started....I do not know what I am doing wrong here below... $mysqli = new mysqli("localhost", "UserName", "Password", ...
0
votes
0answers
4 views

how to preserve newlines in textarea when nl2br and str_replace \r \n fail

I cannot (but want to) preserve a newline from a text area. I have used nl2br. I have used str_replace for \r, \n, \r\n. As far as I can tell, the newlines make it into the database but not out of it. ...
0
votes
2answers
15 views

ASP.NET MVC 4 - Error Message for Accounts With Same Information

I have created a registration page that asks for certain information, such as e-mail, that should only occur once in my accounts database. If an account already exists in the database with the e-mail ...

1 2 3 4 5 … 3774
15 30 50 per page