Tagged Questions

A database is an organized collection of data.

learn more… | top users | synonyms (3)

0
votes
1answer
8 views

get hyperlink list from database column in asp.net c#

I am having 1 project website (quotes website) I have a page where all the quotes are displayed to gather. (screenshot below). I used stored procedure to display this result. Now my main problem: ...
-1
votes
0answers
18 views

Database extern in ruby on rails

I want to know how I can generate a class from a database extern which is not in my rails Application. I want really your help. Thanks you
0
votes
1answer
6 views

Choosing SETNX over SET in Redis

I'm writting this application in which i will use Redis as a database of sorts to store chat messages. I am considering using SETNX whenever i need to set any given key just to be sure it doesn't ...
0
votes
0answers
6 views

converting sql server database to mysql, needing change table structure and column names?

I need to achieve: 1, similar demands in this question: How to export data from SQL Server 2005 to MySQL 2, change table structure and column names, for example: Source(sql server): Table A id ...
0
votes
0answers
6 views

Database issue when I upgraded prestashop from 1.5.2 to 1.5.4.1

After an upgrade my prestashop from version 1.5.2 to 1.5.4.1, it seemed that everything was more or less well, until I try to modify the long description field. In the products I already had, when ...
0
votes
1answer
32 views

How to define a variable inside $_GET in php

<?php $var = "sub"; echo $_GET['{$var}']; ?> i want this working when i called mydomain.com?sub=hii . is there any other way to make this work? I want to use random $var value from my ...
0
votes
1answer
20 views

How i can use cloud mysql database with java?

I Have a software built in Java/Swing mysql. Can I use any Cloud Service for storing and retrieving data with JDBC? or what else i can use?
0
votes
1answer
12 views

Neo4j vs (Neo4j + Postgres)

I am developing an recommendation engine and was thinking of saving actual data (email, name, password, etc) in Postgres and saving relationship in Neo4j. But was wondering if this gives any advantage ...
0
votes
1answer
10 views

Does SQLite's VACUUM preserve key relations?

PRAGMA foreign_keys is enabled. Table foo has no explicit INTEGER PRIMARY KEY. Table bar has foo_rowid INTEGER with FOREIGN KEY (foo_rowid) REFERENCES foo(rowid). Row f in foo has a rowid of x and ...
-2
votes
0answers
25 views

Good database for C# deployment? [closed]

I have an application in C# but still not decided on which database to use. I have these choices but still not decided which database is good to deploy? My concern is more on deployment and just ...
0
votes
2answers
19 views

Prevent windows admin user from reading a SQL Server database

I am creating a product software that many people will install on their machines themselves. It is a VB.Net - SQL Server application. I certainly don't want a user to have some SQL Server GUI tool ...
1
vote
5answers
39 views

Get data from database inserted in latest 7 days

I am in problem in mysql database data retrieving. I have to get latest data inserted within a week or latest 7 days. I just know get data of specific date, but no within a span of days. Please ...
1
vote
0answers
28 views

In jpa criteria, “in case there is at least 1 row return true”

I'm trying to create the follow sentence using the criteria api in JPA (eclipselink), it simple ask if there exist some user in some category The sentence I want: SELECT CASE WHEN EXISTS ...
1
vote
3answers
28 views

PHP convert datetime in SQL statements

Is it possible to convert datetime from SQL statements ? Example : SELECT * FROM t_status WHERE Function to Convert(date_added) BETWEEN '2013-05-01' AND '2013-05-31' My date time format in table ...
1
vote
2answers
22 views

SQL Max function mixing rows

Seems like i'm having fundamental problems using MAX - it's mixing the contents of rows, i think. There is a View: id rev state 1 100 pass 1 99 fail 1 98 fail Result should ...

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