I need to read the data out of database and then save them in to a txt file, how can i do that in Ruby on rails? is there any file management system in ruby on rails?
Thanks
I was asked by an interviewer today how I would implement Arabic as a second language into a PHP web application. I talked about choosing a unicode encoding for the database and the front-end, and designing RTL friendly user interface modules. And he didn't seem too happy with the answer. I don't really know anything about multi-lingual systems, how would you have answered that question?
if i have a user entering data into a rich text editor and submitting data that i am storing into a database and then retrieving to show on other dynamic web pages, why do i need encoding here.
Is the only reason because someone might paste javascript into the rich text editor? is there any other reason ?
I want my image wrapping with text align like this
--------------------
--------------------
_________ ----------
image |----------
|----------
|----------
_________|------<end>
I've tried text text text text .... but the result comes like this
_________
image |----------
|----------
|----------
_________|----------
-------------------
--------------------
What should I do without manual putting and without table ? (like align text first , then image and final , text) because all images and texts of my website will be fetched from the database.
Many thanks !!!
It says that port 3306 might be busy - i have changed it (SettingsComponents Settings) but just nothing?
VertrigoServ ? MySQL database server
does not work correctly. Check whether
other applications use the important
port (3306) and terminate them.
Moreover, check firewall settings and
correctness the configuration files.
Hi,
Could somebody point out the necessary rights to do something like
ALTER TABLE myTable ADD myColumn int NOT NULL CONSTRAINT [Constraint_name] DEFAULT ((0))
?
I assumed
grant alter on myTable to [user]
was enough but I'm getting the error message
The UPDATE permission was denied on the object 'myTable', database 'x', schema 'dbo'.
Could UPDATE rights be needed because of the DEFAULT constraint?
Thanks.
When im inserting to the database on my dev server the text goes in fine, for example "that's" is "that's" in the db.
when uploading the exact same code to production server (hosted on a reseller account at bluehost) "that's" becomes "that\'s",
im not double escaping, its exactly the same code, what could be the issue here?
I just read a blog post about NHibernate's ability to create a GUID from the system time (Guid.Comb), thus avoiding a good amount of database fragmentation. You could call it the client-side equivalent to the SQL Server Sequential ID.
Is there a way I could use a similar strategy in my Linq-to-Sql project (by generating the Guid in code)?
I've been searching for a while now and can't seem to find an alternative solution. I need the tree traversal algorithm in such a way that a node can have more than 1 parent, if it's possible (found a great article here: Storing Hierarchical Data in a Database). Are there any algorithms so that, starting from a root node, we can determine the sequence and dependencies of nodes (currently reading topological sorting)?
When i run "svn log ....... --xml", it just also dislpay in the console.
Is there a way and how to copy that log in other xml/txt file?
Because then i want use java to put those data in database.
We keep most of our logs in a dedicated database table. We have written custom appenders for log4j and log4net, have a fixed log schema with lots of handy columns, and are quite happy with it.
Is that the "best practice" (for sites smaller in scale than Facebook, where a simple DB table just won't scale)?
Hello,
I have this string: '30/05/2010', and I would like to enter it to a smallDatetime field.
In the database it should look something like this 2010-05-30 15:33:25
Any Idea how?
TY
I've been using CodeIgniter for some quite time, and I've been extremely happy with its Active Record stuff. It's great to query the database with it.
Recently I've started a new project and I can't use such a framework anymore.
Is there a simple PHP Active Record library that does its job and gets out of the way (similar to CodeIgniter's version)?
I'm going to make a small application for a business that will be used locally for scanning, and storing documents in a database located on the local machine or on a machine located in the same LAN.
I could create a table called Users with username and password and according to the usertype ID show a form, or another form. But I'm more interested in the recommended approach by seasoned programmers.
Any advice?
Hi, i looking for guide/document/tutorial on how to use this new feature write-behind-cache in ehcache? Is there any demo in spring+jpa+ehcache+hibernate?
just to clariyfing, write-behind-cache mean each time we persist entity, it will be written into cache rather than into database correct?
I'm already familiar with how to use onSubmit to evaluate form content against RegEx to ensure it meets static parameters for acceptable content. What I'm wondering is if there is a way to further provide validation against a MySQL database, such as if you want to make sure an e-mail address hasn't been used yet before submitting a form and having to re-load the field data back into the proper places for correction.
What sql query would you write to get the table names which have a particular foriegn key.
Eg. Person_Table(person_id,name,address,...)
Purchases_Table(purchaseid, purchased_by_id(fkey)....)
AccountDetails_Table(AccountId,PersonID,....)
Roles_Table(PersonId,RoleID)
Now i want to find the table names where Person id is used as a foreign key.
The above schema would return me
Purchases_Table,AccountDetails_Table, Roles_Table
Database: SQL Server
I am trying to get a list of webparts deployed on a web page in sharepoint 3.0. Is there way I can retrieve it from sharepoint content database or can I do it programmatically?
I've been looking into writing a web app that will run on Google App Engine, but before I commit myself to the platform I'd like to know what, if any, limitations there are. I'm aware of the basic CPU/bandwidth restrictions that Google places on the free service, but I'm wondering more about development restrictions like how BigTable compares to a standard relational database and what Python libraries aren't available on the GAE platform (and what alternatives Google provides).
Basically I'm looking for any hidden roadblocks before I commit to the platform. Thanks for your help!
I need to install the ExcelPackage library on Visual Studio 2008. The .zip file I downloaded from their website (http://excelpackage.codeplex.com) contains a .dll, a .xml file, a "GacReg.exe" and a file called ExcelPackage (with this description: "Program Debug Database"). What are the steps to installing this library, or any library in general? I appreciate the help.
I use jquery's .submit() to intercept user's submit event, however I found a problem.
When the user single click the submit button, the form is submitted normally, but if a user deliberately fast click it multiple times, it will submit multiple times, which will cause duplicated data in the database.
What's the solution for this kind of problem ?
Hi,
Currently we are using xml files as local data store for our disconnected application,
there is proposal to move to SQL CE database.
Can some one with experience of SQL CE provide some pros and cons of using sql compact, for example data type support etc. As Central DB server we are using SQL Server2005.
One of the requirement is to merge local store with central DB, and we don't want any data loss.
Thanks
i will have multiple applications on the app store and 1 urban airship account to send push notifications to all of these devices. what i want to know is if each apple device has the same "push token" across all applications? this is more of a database architecture thing so that I don't duplicate a push token many times if one single device uses many of my apps
if each apple device generates a unique push token for each application it has installed my architecture needs to change.