Dear All,
I need to know how to interrogate my Microsoft SQL Server to know if a given database has been set to readonly or not. Is that possible?
Thanks
Giuseppe
I am trying to decide between the Zend Framework and Ruby On Rails for my web application.
If I go with ZF, I need the following:
A way to incrementally track changes to my database, as with RoR's migration feature (001_something.sql, 002_something_else.sql).
A place to put SQL for the next release of my software. At work in our custom PHP…
Hello, I am trying to insert a data to my db2 9.7 database from IBM RAD 7.5 using struts 1.3
But when i execute the query i got this errors
[Pastebin link][1]
Here is my code
KayitBean kayit=(KayitBean)form;
//String name = kayit.getName();
String name="endee";
DBConn hb = new DBConn();
Connection conn =hb.getConnection();…
Can anyone have an estimate of how much data can be inserted in a 5MB database?
Also, would 1 Dyno handle a slashdot,hackernews, etc frontpage?
Thanks.
I am getting this error,
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' address='xxxxx', city='sssssssss', pincode='333333333', state='Assam', count' at line 1
Thanks in advance.
http://dpaste.com/hold/181959/
Hi,
We are facing an issue with MS access.
There are two users having the same access for tables and previliges in database.
But one user can access the tables from MS access and another user can't.
Can you please let me know the reason.
Thanks for updating from options. I am looking in to it.
User having grant permissions for SELECT ANY…
so I'm trying to get some info in the auto-complete widget like it's shown in the JQuery UI demo Demo, the only problem is they use a variable that they fill with the data they want to show, I instead want to access the data and the different description and stuff using a Data Base in MySQL, for this I have changed the source to use another…
I want to save a user's IP address to my database just in case any legal issues come up and we need to track down who performed what action. Since I highly doubt I will ever actually need to use this data (well, maybe for counting unique hits or something) do you think I can just dump the REMOTE_ADDR into a field? If so, what should the…
my question is:
i have a member that can pay in 3 different way
credit card
check
transfer from bank account
how design the table that contain the history of payment.
the fields of every way is different .
if i save all in one table , i have lot of blank field ?
what the right way to deal it ?
I have a JOB table, with two interesting columns:
Creation Date
Importance (high - 3, medium 2, low - 1).
A JOB record's priority calculated like this:
Priority = Importance * (time passed since creation)
The problem is, every time I would like to pick 200 jobs with highest priority, and I don't want to resort the table. Is…
MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?
I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or…
Hello All,
I want to fetch game record of Dota map. what player won, loss, kills or death ? I am fetching value, using PGPVN server but this not fetching custom map war craft III game. I did more and more googling. what is the perfect way to fetch this Dota map record ????
thanks in advance.
I have a .net desktop app that connects to an oracle database. At times, there are very noticable delays.
I ran a trace on the code, and it was always in the DataReader.Read().
I turned on sql tracing, and found the following, which corresponds to the delays I'm seeing:
(2128) [23-MAR-2010 13:00:07:310] nsprecv: reading…
I want to know which ODBC driver version is recommended for Oracle 9 and 10.
Is there official Oracle document that says that newest version of Oracle ODBC driver can or even should be used with older servers?
Hi All, this question came up based on the responses I got for the question
http://stackoverflow.com/questions/2785033/getting-wierd-issue-with-to-number-function-in-oracle
As everyone suggested that storing Numeric values in VARCHAR2 columns is not a good practice (which I totally agree with), I am wondering about a basic…
Dear All,
I am making an application which saves the camera roll images as blob in sqlite3 database.
When the image is retrieved, its dimensions changes(height and width get interchanged). This happens only on iphone and not on simulator. Please help
I need to have text IDs in my application.
For example, we have acceptable charset azAZ09, and allowed range of IDs [aaa] - [cZ9]. First generated id would be aaa, then aab, aac, aad e.t.c.
How one can return ID & increment lower bound in transaction-fashion? (provided that there are hundreds of concurrent requests and…
Hello,
this is my code which populates a drop down menu, all working perfectly, but when editing a database record, i want the first value in the drop down to be what is currently in the database, how would i do this?
<li class="odd"><label class="field-title">Background <em>*</em>:</label>…
Hello,
tried connecting to mysql server in realbasic using the folowing code:
dim db as MySQLCommunityServer
db=New MySQLCommunityServer
db.host="192.168.240.129"
db.port=3306
db.databaseName="test"
db.userName="test"
db.Password="test"
If db.Connect() then
txt1.Text = "Connected"
else
…
Hi.
I have a SHA1 password and PasswordSalt in my aspnet_Membership table.
but, when I run a query from the server (a Sql Query), the reader reveals
that the pass has returned as its cleartext equivalent.
I am wondering if my web.config configuration is causing this?
<membership…
Hi everyone,
Does anyone out there use SQL Express 2008 R2 in a production environment?
I am looking at hosting a Windows VPS as a server for a client software product I have developed.
Clients connect to the server, send their data to a service running on the server, and the service…
Hi
Say I have the unknown number of questions. For example:
Is the sky blue [y/n]
What date were your born on [date]
What is pi [3.14]
What is a large integ [100]
Now each of these questions poses a different but very type specific answer (boolean, date, float, int). Natively…
I'm cleaning up my code, should i change the following function to a MySQL query? If so what would be a nice MySQL function to achieve this functionality?
public ArrayList getNewTitles(ArrayList candidateTitles, ArrayList existingTitles) {
ArrayList newTitles = new ArrayList();
…