What's the best way to determine if a given SQL Server table is readonly, either because of account permissions or the database being marked as read-only?
Hi stack, i'm working on an app that loads some data from xml file from internet.
Is this a good way to develop iPhone apps??...I think xml is more light than SQlite database...
Basically my logic is:
1 - Parsing Xml file from internet to retrive the data
2 - Load data on device
Security?..other stuff??..
Thanks
Mat
Hi,
I'm developing a Rails application with Rspec for unit testing.
Weeks ago, Rspec used to migrate the database to the last version automatically when executing 'rake spec', but now it doesn't do it automatically, I have to implement everything for myself.
This happens in test environment, because my development data doesn't desappear.
Is my fault? I didn't change anything, I think :)
Thanks in advance.
I am having problems with creating an in memory table, using H2 database, and accessing it outside of the JVM it is created and running in.
The documentation structures the url as "jdbc:h2:tcp:///mem:'
I've tried many combinations, but simply cannot get the remote connection to work. Is this feature working, can anyone give me the details of how they used this.
assuming that I have setup the Database (MySQL) Replication using Master-Slave configuration, and have synchronized those Master and Slave servers, how can my C# program know that it has to update the Slave server when the Master server fails? What are the conditions that the C# program switch from the Master server to the Slave server?
I am using MySQL server.
I need to create a custom field that supports multiple values which can be uniquely identified (beyond the delta field which changes when the values are re-ordered). I have created a module for the field and specified the two database columns that I would like CCK to use (one for the value and one for the ID) but I am not sure where the entry point is for adding in a unique id for each value (probably will just take the id from a sequence).
I have a Browser and I want to display history & favorites of user on webbrowser on button_Click event. Can I accomplish this by using treeview in my form? if not what other way i can use. Data about History and Favorites is stored in SQL server database.
Thanks,
Ani
Hello ...
I created a table using ER/STudio 8.0.3 ... The table has a serial pk (SERIAL/INTEGER in ER/Studio)...
But the ER/Studio Physical Model generated convert the Serial to Integer...
And The generated table in database has a integer pk, without auto-increment functionality...
Any idea?
Table generated :
CREATE TABLE test
(
id integer NOT NULL
)
Should be :
CREATE TABLE test
(
id serial NOT NULL
)
Hi,
If I am running an organization that has 50 .net developers and all are using SQL Server, what is the best way to make a single SQL Server available to them?
Here is some of the concerns that I want to be careful about
Should I configure database users per project or per user? or both?
Should I provide single SQL Server instance?
There are some more concerns but I think getting answer of these two will be a good starting point.
Hello Friends,
I have developed customized setup Installer using NSIS. But every time when I reinstall an application, I want to take backup of old database files. & backup file should be rename as 'currentdatetime'(ex: 201003101140 means 2010-03-10 at 11:40 AM).
please, Help me soon
I am waiting your reply
Thanks !
How to initialize variables in ActiveRecord class?
Variables here is the variables that are outside the scope of database
such as:
class Product
attr_accessor :used
end
I want to initially assign @used initially to false, later if some person access the product, i will change @used to true
First i thought of putting @used=false in initialize method, but it does not get called.
How can we generate a link that can be clicked on by 5 different people on a Social Network game, so that each of the five people can get a bonus? The link will be published as a "newsfeed" on the Social Network such as Facebook.
The link shouldn't be easily "generated" by any people as a cheating method.
Also, what database table(s) should be added to handle:
1) the bonus can be claimed up to 5 times
2) must be claimed by different people
?
I have a mysql database with 60 tables most of the tables have primary keys (expect pivot tables) all these primary keys had the attribute AUTO INCREMENT
Then over night some how all the primary keys had that attribute removed, and the default value set to 0.
I have no idea how this may have been caused. Any suggestions?
I'm thinking of creating a diagnostics page for an ASP.NET app, which would be mostly intended for admin use to get more information about the application for diagnosing problems.
Examples of the info the page might have :
System.Environment.MachineName (might be useful in web farm scenarios)
System.Environment.Version
Environment.UserName
database name
current user's session ID
Some of the info on this page might be sensitive from a security perspective.
If you've done this sort of page before, what sort of security did you put on access to this page ? .
In my application I have a bool property named DisplayIndicator. In the database (DB2) it's correspondence is DISPL_IND column of type smallint.
The correspondence is the following:
[DisplayINdicator=True, DISPL_IND=1] and
[DisplayINdicator=False, DISPL_IND=0]
Is it possible to map using nhibernate fluence the bool property to smallint?
For instance, there’s a integer column in a database table.
Then in java model, it can be mapped both as primitive int and Integer.
My question is what's difference between the int and Integer in this case? And performance concern?
Thanks!
Menu style:
File . Tool
-file1 -tool1
-file2 -tool2
-file3 -tool3
datable contains the rows like.
col1 col2
------------
File file1
File file2
File file3
Tool tool1
Tool tool2
Tool tool3
How to bind my data table value into menu strip dynamically i get my data table values from database dynamically.
Based on my data table value the menu should display in my form.
In the database I'm working with, every table repeats the same nine columns and I don't want to have to supply the same properties in each of my entities to map these columns.
I've tried adding properties to a common base class and adding them to the sub class's mapping file, but this doesn't work. I've read the documentation around inheritance mapping but this did not help.
What is the best way to map columns that repeat accross multiple tables in NHibernate?
Joined is a datetime data type column in the database and dates are saved as '12/05/2010 15:54:32'
This my query:
SELECT *
FROM users
WHERE joined BETWEEN '12/05/2010 00:00:00' AND '12/05/2010 59:59:59'
ORDER BY id ASC
But it doesn't work. It returns no rows.
So how i gan get them?
I'm trying to use dumpdata to generate JSON for a database that is sufficiently large for django to take a long, long time to output. Is there any way to dump only a subset of the fields; say, 100, for testing?
I'm using MySQL and Django 1.0.
Hi,
If I already have domain classes, and I want to be able persist them using EF via a model first approach how do I do this?
For example do I go to the EF designer (in VS2010) and create the model and generate the classes, then go to these EF classes and somehow manually modify them? But then would there be an issue if I needed to change the model and re-create database TSQL from the model for updates?
What's the easiest approach?
I am using jquery to set a session, i have a php page which gets the values of the person logging. The value in the session array, is then used in another page where, it is stored in a hidden field for database entry.The problem is, the value is not set unless you refresh the page of which beats the purpose of AJAX and Jquery.Again,the session seems to be one session behind.How can I do this without page refresh/ reload?
Hi guys,
I got this Error when querying MYSQL Database:
Glib-Error **: gmem.c:173:falied to allocate 216000000 bytes aborting..
Do anybody have some explanations?
I am using MYSQL Query Browser.
thanks