Hi all, I have written a application that parses the html code of some web pages. My problem is with inserting that data into my mysq database. So for example i want to insert ľščťžýáíé and when i look into the table i get ?š??žýáíé. I guess the problem could be that the html pages i'm downloading are encoded in cp1250. but the databas...
Hi! I'm trying to join some tables together in MySQL, but I seem to get an error saying: #1066 - Not unique table/alias: 'calendar_jobs' I really want it to select everything from the cal_events, the 2 user bits and just the destination col from the jobs table, but become "null" if there arn't any job. A right join seemed to fit the bi...
I'm coming up with a web app which will want me to store more than 80 Lakh (8 million) rows. Will it be fine to handle those many number of rows with MySQL without having any performance degradation? Assume my RAM to be 4 GB and Infinity GB Harddisk space. Also, the main fields have been indexed. ...
how to manage a process php file?? i want every form which connected to database just use one php file..how to separate every command inside that php file??can i do that? ...
I am developing a Java application with MySql as the database. I have to dump the MySql database from my application periodically(let say every day at 10 a.m.) and I have written a batch (.bat) file for dumping the database. The batch file is working fine, but the problem is that it is asking for password each time during its execution. ...
After having solved a previous issue with this query, i'm now stuck with getting this error: 1054 - Unknown column 'calendar_events.jobID ' in 'on clause' I can't undertstand why... and the column defiantly exists! Is it something to do with the WHERE blah AND ... section of the query at the bottom? SELECT calendar_events.* , ...
Hello all! I have a Flex GUI where I have to place quadrate elements. The position of these elements need to be stored into a database. So I can create two integer fields in the db table x and y. Also I need an angle, because the user can rotate these elements, so I can also make a int (int is okay, I do not need a double value therefor...
i have a mySQL table which the data in one of its columns is in a language other than English.(Persian) when i input data in the table , it is shown properly but when i want to show the data in a php file it displays like this:???? well,what should i do in order to show the data in its correct form? ...
SO i am in the process of setting up a load balanced configuration for our web application with nginx. I would most probably go with sticky sessions to avoid session issues on the load balanced setup or maybe even go with a database session handler. However there are 2 concerns that i have right now: 1 : When deploying from SVN ( we us...
Hi guys, I have a database with date field is this format "2010.06.11. | 10:26 13" What is need is a php array that would hold all the different dates, .i.e. array[0] = "2010.06.09." array[1] = "2010.06.10." array[2] = "2010.06.11." Currently I am doing it by selecting the whole table, then looping through the result and adding the ...
Hi, I got a strange problem. I am using iReport 3.7.1 tool to create some reports. The Query Editor has one query. It shows all the data types of the fields in that query exactly same as the data types shown when I execute it using SQLYOG editor. The problem is here: One field data type is mismatched. I don't know the reason. SQLYOG s...
Hi all, How can I save to my mysql db an array from flash? I pass the array as a parameter to a php script. What I have to do next? ...
Hi All, I am running a heavy traffic site and our server is beginning to get to its limits, at the moment the entire LAMP stack is on one box (not ideal). I would like to move the database onto it's own box or onto a cloud service, but from my previous experience moving the database off the same box as the webserver increases the laten...
What is a good, and easy to install MySQL module for Python? Especially for Mac OS X (in terms of installation)? ...
In my experience I have used many queries like select, order by, where clause etc.. in mysql, sql-server, oracle etc For a moment i have thought, 1)how is this internally written to implement the above queries 2) which language do they use? 3) is that programming language? if yes which language? 4)what kind of environment required t...
I'm on Ubuntu 10.04 x64, ruby version 1.8.7 (2010-01-10 patchlevel 249) I've read this thread first: http://stackoverflow.com/questions/1332207/uninitialized-constant-mysqlcompatmysqlres-using-mms2r-gem and tried everything that people suggested: apt-get install libmysqlclient-dev export ARCHFLAGS="-arch x86_64"; sudo gem install --no...
What are the pros and cons? When should we have them and when we shouldn't? UPDATE What is this comment in an update SP auto generated with RepositoryFactory? Does it have to do anything with above columns not present? --The [dbo].[TableName] table doesn't have a timestamp column. Optimistic concurrency logic cannot be generated ...
I am using mysql data base with rails. I have created a field of type of string. Are there any limits to its length? What about type text? Also as text is variable sized , I believe there would be extra costs associated with using text objects . How important can they get , if at all ? ...
Hey folks, Previously I've worked on a Symfony project (MySQL PDO based) with XAMPP, with no problems. Since then, I've moved to MAMP - I prefer this - but have hit a snag with my database connection. I've created a test.php like this: <?php try { $dbh = new PDO('mysql:host=localhost;dbname=xxx;port=8889', 'xxx', 'xxx'); fore...
Hi, I'm new to Hibernate+Derby... I've seen this issue mentioned throughout the google, but have not seen a proper resolution. This following code works fine with mysql, but when I try this on derby i get exceptions: ( each Tag has two sets of files and vise-versa - manytomany) Tags.java @Entity @Table(name="TAGS") public class Tags ...