Generally, my development has only covered small to medium size companies and e commerce sites. My next project will encompass say 30 sites - however, they'll have about 95% in common with each other. I want them to have 1 'brain' that means I can roll out changes, updates to the framework etc only once. I wonder if the Stack Overflow ...
again, this qn was from the practice qns in the mysql certification guide book ... QUESTION Here's the structure of a table typetest with three columns (number, string, and dates). As- sume the server is running in MySQL's “forgiving” SQL mode. mysql> DESCRIBE typetest; +--------+---------------------+------+-----+---------+-------+ ...
I am required to implement SSO between Liferay and a number of PHP-based systems. Database used is MySQL. CAS will authenticate through Liferay user database, as well as through user database from System A and System B. The reason why each system use different user database is because they were developed by different teams, perhaps diff...
I'm writing an application that displays posts, much like a simple forum system. Posts can be marked as urgent by users when they submit the post, but a moderator must approve the "urgent" status. A post will still be displayed even if it has not been approved as urgent, but will just appear to be a normal post until the moderator approv...
Hi everyone, i want something like this: SELECT DISTINCT ID from copies WHERE timestamp < 1229444506 ORDER BY CID the problem is that this one only return ID and i need CID and other columns in the table. It may be that this is totally wrong for other reason aswell, so i will explain what i need. I have a table that "record" every r...
How can I update only the time in an already existing DateTime field in MySQL? I want the date to stay the same. ...
How do I set the application to production mode? Okay, this must be a no-brainer but I'm about to deploy my first Rails app and I've got everything setup properly: Ubuntu Hardy, Passenger, MySQL. However, it's still running in development mode. I've only been able to find documentation for older versions of Rails and want to make sure t...
according to http://stackoverflow.com/questions/577463/finding-how-similar-two-strings-are there are several methods to calculate the similarity measure between two strings. Soundex is a very poor algorithm and it's currently available for mysql. Is there any other method implementation available for mysql? ...
Hi, I'm building a page which loads the contents of our MySQL db for editing. Each row of the table is in a seperate, editable textarea on the page. I need the user to be able to update each row (ie send it's contents to the db) without reloading the whole page, with a click of a button that's responsible for that specific textarea. I u...
hi everone, **njhw]wf;fpuk Muha]r]rpa[k]/ rpj]j kUj]Jt tuyhWk] 1). "hdpfSf;F ,y]yhjJ vJ> m). r";rpj fd]kk] m{). m{fhkpa fd]kk] ,). gpuhuj]jf] fd]kk] <). ,tw]wpy] vJt[kpy]iy. 2). ‘,iwtdpy] ,Ue]jy]y/ khiaapy] ,Ue]J jhd; cyfk] cw]gj;jpahfpd;wJ’ – ahh] bfhs]if m). irt-rpe]jhe;jpfs; m{). m{rPtfthjpfs; ,). rkzh]fs; <). ntjh...
Hello, I might have missed something about MySQL. I'm trying to find a way to store a "count" in a column. It has to be dynamically updated without any manual update. I don't want to add or remove 1 to the count any time the member creates or delete a content. The field in contentcount must automatically be a count of every content ow...
Hey there everyone, Sorry for the bad title, but I have no idea how to put this in short. The Problem is the following: I have a generic item that represents a group, lets call it Car. Now this Car has attributes, that range within certain limits, lets say for example speed is between 0 and 180 for a usual Car. Imagine some more attrib...
there is a table with just one column: userid when users access that page, his userid is being inserted to the table but userid's are unique, so there isn't two same userid's on that table. i got two choices (i think); making unique and using insert command everytime a user accesses that page checking if the user alreade recorded by ...
I've got a webapp (basically a CMS) running on Apache built with PHP5/MySQL. Which would be the best practice to create a demo version on the web? The only way I can think of is duplicating the entire database for each new user and running a cron job one or twice a day to remove those duplicates. ...
I can't seem to get MySQL 5.0.32 on 32bit x86 Debian to honour transaction isolation levels. I've reduced my problem to its simplest form, tested with the mysql command-line client: -- On node writer: -- DROP TABLE test; CREATE TABLE test ( name VARCHAR(255) ); set autocommit=0; set transaction isolation level read committed; beg...
I write this code include('database.php'); function get_something() { database instructions } function get_another(){ database instructions } and I try to fix by this function get_something() { include('database.php'); database instructions } function get_another(){ include('database.php'); database instructions } ...
I am trying to implement a search function on a database table using query expansion, and I'm aware that I have to add the FULLTEXT index on the fields I want to become searchable. I have tried to do this and got no errors from PHPMyAdmin, but when I examine the structure of the table the cardinality of the FULLTEXT index is 0. I have tr...
I want to get a result from sql with unlimited rows, I don't want to use limit in my sql statement because I need to know the total number of rows. But I just want to echo, for example row 30-60. I use php. ...
I have this entity class, called "Pagina" and I want to update the entry in the database based on the changes made to the entity. This isn't working. I get no errors, but the db is not changed. @Entity @Table(name = "PAGINA") @NamedQueries({@NamedQuery(name = "Pagina.findAll", query = "SELECT p FROM Pagina p"), @NamedQuery(name = "Pag...
Is there any migration procedures or tools to migrate a Database (Liferay database to be exact) from InnoDB to PBXT? ...