Date: 05/14/07 (PHP Community)    Keywords: php, mysql, html, sql

At the end of a very long and tedious php/html/mysql job...

echo "\n\n\n\n\n";

I'm just glad it's over actually.

Source: http://community.livejournal.com/php/566489.html

Date: 05/15/07 (Application Development)    Keywords: sql, microsoft

Endeavor aims to tie the SAP Business Suite more closely with Microsoft's SQL Server 2005.

Source: http://news.zdnet.com/2100-9593_22-6184010.html

Date: 05/17/07 (SQL Server)    Keywords: sql

SQL Server 2005 Express edition. I installed the advanced tools and the toolkit, but when I try to run Business Intelligence Development Studio, devenv.exe is not found. I did a full hard drive search and confirmed that it is not, in fact, there. I tried to reinstall the toolkit, but it says the entire toolkit is already installed on the drive. Obviously, this is not the case...

any idea how I can reinstall that portion without having to uninstall the entire toolkit? (And if I have to do that, what do I look for in add/remove programs, since there is no entry for SQL Server 2005 toolkit?)

Thanks.

Source: http://community.livejournal.com/sqlserver/59058.html

Date: 05/19/07 (Java Web)    Keywords: database, sql, java

HSQLD is a mature, high-performant database written in Java. It is used in several high profile popular commercial and open source products like Open Office 2.0 (Office productivity suite; competitor of MS Office), JBoss (Application Server), JFox (Application Server), Jonas (Application Server), Mathemetica, Hibernate (ORM), Jira (Defect Tracking), TrackStudio (Defect Tracking), C-JDBC (Database Clustering) etc. [...]

Source: http://blog.taragana.com/index.php/archive/the-case-for-hsqldb-as-rdbms-for-java-development/

Date: 05/26/07 (Java Web)    Keywords: database, sql

Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character. HSQLDB doesn’t accept either backtick or single quote as escape character. Instead you have to use escaped double quotes as shown in the example below: st.execute("CREATE TABLE sheet (tg_meta_id int identity [...]

Source: http://blog.taragana.com/index.php/archive/how-to-escape-column-names-in-hsqldb-rdbms/

Date: 05/28/07 (MySQL Communtiy)    Keywords: mysql, sql

Hello,
I'm a new mysql user. I had download the GUI mysqlcc (mysql control center) from source forge. I didn't find any user guide or reference book for this tool on the internet. Please, do you know if it is available anywhere?
Thank you in advance for yours answer.

Source: http://community.livejournal.com/mysql/113991.html

Date: 05/29/07 (Open Source)    Keywords: mysql, software, sql, linux, microsoft, apache

Writer Rodney Gedda at Computerworld writes that aQuantive, the online ad agency Microsoft is buying for $6 billion, is an open source play. The reason? Many aQuantive units, including AvenueA Razorfish and Atlas, make extensive use of open source software, including mySQL, Linux, and Apache. If you use open source, are you ...

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/120506500/

Date: 05/30/07 (MySQL Communtiy)    Keywords: php, mysql, sql, web

Howdy. I have a MySQL 5.0.41 (community) installed on my home computer under win32. When phpMyAdmin starts, I get a 2003 (server is not responding) error.

Judging from what the console tells me (was checked via "sq query mysql"), MySQL service starts successfully (state: 4 RUNNING) and runs. Until the moment any site from localhost tries to connect to MySQL - after that the service crashes (with win32 exit code 1067).

Didn't find an answer on the web (didn't search thoroughly enough, perhaps). Can someone point me to a solution for this problem, or some further diagnostics?

Source: http://community.livejournal.com/mysql/114398.html

Date: 05/31/07 (SQL Server)    Keywords: database, sql

Okay, this one's got me stumped...

I'm converting SQL Server 2000 DTS packages to SQL Server 2005. It seems like what I'm trying to do should be simple: An Execute SQL Task runs a stored procedure, then stores the output in an Object called ResultSet. (The Execute SQL task isn't working, but that's beside the point right now.) Now, what I need to do is export the result set into Excel. Simple, right? Take the result set and export into Excel using a data flow.

Except, umm, there doesn't seem to be any source in the data flow screen that specifies a variable. I realize the easiest way to do this would be to store the results of the stored procedure in an actual table and just export the table to Excel, but I'm not entirely sure I have create permission on the database.

Anyone tried to do this? Is there something painfully obvious that I'm overlooking? Thanks.

Source: http://community.livejournal.com/sqlserver/59141.html

Date: 06/03/07 (SQL Server)    Keywords: programming, database, sql

I'm trying to update my resume with the sql server tasks I've been doing for the last 2+ yrs, but I'm really stuck on what exactly to put and how to word it.

Quick background: I've heavily programmed in and used MS Access since 1994. In many cases, I did the db design, creation, and upgrades for all tables, queries, forms, and reports. I often created the app that other people use. It took me a while to find a job where I could learn and use SQL Server. I finally found that about 2.5 years ago (there's a lot of Access programming using a tool already created at my company, with a SQL Server backend).

Could really use some input!


I'm really not performing SQL Server DBA work; the majority of the tasks I tend to perform are:
- writing and running simple select queries

- writing and running complex queries (several inner and/or left joins) to select, append (insert into), update, or create a new table from a data set using particular criteria

- processing/manipulating large data sets (1 million + records) to drill down to a smaller set that can be handled by the Access app

- incorporating CASE statements into the queries

- importing a table into SQL Server from text files, spreadsheets, or Access tables, using the Import/Export tool (a task I do only very occasionally)

Any suggestions on how I can word this in the resume?

Oh, and I can tell you as an experienced Access programmer (who started from v2, where you had to really understand Access and database concepts and normalization, no cute little wizards to help) that SQL Server really ROCKS and I prefer it. Now, to be able to use it more...

Source: http://community.livejournal.com/sqlserver/59901.html

Date: 06/04/07 (Web Development)    Keywords: php, templates, mysql, html, xml, database, sql, web

xml.lt has announced the release of DIY Framework. It is an open–source web application framework based on MVC architecture, object–oriented PHP 5, MySQL, and XSLT.

The Model is database–backed and generated by Propel ORM tool, the Controller is inspired by REST and RDF, and the View is based on XSLT stylesheets as templates.

The framework allows clean and precise sever–side development with a fully object–oriented code, absolutely no mixing of PHP, (X)HTML and/or SQL code, resources that have nice meaningful URIs with no extra effort, and many other features. On the other hand, it is tiny, flexible, and not overloaded with buzzword things.

Blog post (digg!):
http://www.xml.lt/Blog/2007/06/04/DIY+Framework+v0.1+released

More information and download:
http://www.xml.lt/Resources/Framework

Martynas

Source: http://community.livejournal.com/webdev/411944.html

Date: 06/05/07 (HTML Help)    Keywords: mysql, sql

Hi!

Does anybody know where I can find simple user-friendly Guest-book scripts, that I can edit easily?

And what is "CGI" and "MySQL"?

Thank you in advanced.

Source: http://community.livejournal.com/htmlhelp/2401202.html

Date: 06/08/07 (MySQL Communtiy)    Keywords: php, mysql, sql, web, apache

I have what is probably an easy question, but I've been Googling and don't quite know where to go.

I write and test MySQL queries on a virtual Apache server on my PC before transferring it to the live server on a website. At the moment, I write the MySQL through a command-line interface, which makes it very difficult (almost impossible) to go back and edit the query if I need to change things or have made mistakes. It seems to take much longer to develop things than it should!

At work, I use Teradata SQL and we have a nice graphical interface where we can type in SQL, edit it easily, save SQL to re-use and all those good things. It's much easier to develop in and also easier to copy and paste the query into other files, such as Excel or PHP.

Can anyone recommend a good equivalent program for MySQL?

Source: http://community.livejournal.com/mysql/114511.html

Date: 06/10/07 (Webmaster View)    Keywords: php, mysql, software, browser, html, database, sql, linux, apache

Last month,I did a clean install of Ubuntu Feisty Fawn on my home computer removing the "dapper drake". But it is only now, I got a chance to sit down and install all necessary packages to set up my development server again.

With Dapper Drake, I had to use alien to convert MySQL5 rpm to .deb, because there was no version 5 in the repositories. Anyway, Feisty has all newest versions of software.

This is what I did for setting up my development server:

For installing MySQL server I ran the command: sudo apt-get install mysql-server. Then I installed the following:

MySQL Administrator: It is a Graphical User Interface for administrating MySQL: sudo apt-get install mysql-admin

MySQL Query Browser is a GUI for managing databases: sudo apt-get install mysql-query-browser

Apache: sudo apt-get install apache2

Apache Manual: sudo apt-get install apache2-doc

PHP: sudo apt-get install php5

PHP module for Apache: sudo apt-get install libapache2-mod-php5

Enabling public_html directories for users

Well, I am the only user in my computer. But I can create and edit files without running sudo if I have a public_html directory at my home. sudo a2enmod userdir. I then restarted Apache and created a 'public_html' directory in my home. Now I can access it with http://localhost/~username/.

Enable mod_rewrite

1. sudo a2enmod rewrite.
2. Edit Apache configuration: sudo gedit /etc/apache2/sites-available/default
3. Change line 12: “AllowOverride none” to “AllowOverride all”
4. save and close
5. Restart Apache

(Thanks to mod_rewrite for Apache2 in Ubuntu Feisty Fawn 7.04)

How to restart Apache?

sudo /etc/init.d/apache2 force-reload.

Todo:

1. Install IEs4Linux.
2. Install Opera.
3. Install Komodo Edit.
4. Install gftp.

Source: http://www.webmasterview.com/server_side/development_server_on_ubuntu_desktop

Date: 06/11/07 (Java Web)    Keywords: sql

While inserting a SQL query we do not specify the auto increment values, if any. However they are often required for further processing. Here is how you can obtain auto increment / auto generated values after a successful SQL INSERT statement. // // Insert one row that will generate [...]

Source: http://blog.taragana.com/index.php/archive/java-how-to-get-auto-increment-values-after-sql-insert/

Date: 06/11/07 (Open Source)    Keywords: mysql, sql

Booking.com says it's processing "tens of thousands" of reservations a day, but more important that it's growing exponentially. Yet they commited to mySQL. Not Oracle, not DB2, not SQL Server, and not Ingres. Now it's always possible these people are out of their minds, or just enamored of freeware, but I doubt it.

Source: http://feeds.feedburner.com/~r/zdnet/open-source/~3/123917232/

Date: 06/12/07 (Java Web)    Keywords: mysql, sql

ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query. ANALYZE helps query optimizer to make accurate decisions by detailed analysis of the data, unlike query optimizer which makes quick analysis. The command [...]

Source: http://blog.taragana.com/index.php/archive/how-to-quickly-analyze-all-tables-in-mysql-database/

Date: 06/13/07 (MySQL Communtiy)    Keywords: mysql, sql

I have a query that worked fine against the MySQL 4.0.x binaries, but when I perform the same query on a 5.0.x install I have a problem. I'm using a query with a GROUP_CONCAT clause to put the results into a single field. This is a section of the query, just to show how I'm using it:

GROUP_CONCAT( DISTINCT album ORDER BY album SEPARATOR '||' ) AS album_list

The problem is that it seems to truncate all results at exactly 341 characters. Again, on 4.x it worked fine, but something changed in 5.x that now limits the size of the returned dataset. I read something about group_concat_max_len and a MySQL bug with utf8 columns (all of my tables are utf8). Has anyone come across this problem or a solution? How does one set the group_concat_max_len variable--is that an SQL command or a DB startup parameter?

Source: http://community.livejournal.com/mysql/114840.html

Date: 06/20/07 (SQL Server)    Keywords: sql, web, microsoft

SSIS.

Can anyone please explain to me what the above error means and how to correct it? Microsoft's error reference is its usual helpful self, and it seems no one has gotten this error (or asked about it anywhere on the web) in my particular situation. Before someone suggests it, no, I cannot permanently change the type of output.

I'm trying to take the restuls of a stored procedure and export them to Excel in a data flow task. This is a common thing at my workplace, and we have hundreds of them that work correctly. Every once in a while, though, one of them starts dying, and it always throws the error in the subject line, invariably preceded by a DTS_E_OLEDBERROR. The going wisdom for people using OLEDB or SQL SERVER destinations is that it actually is what it says it is-- there's a problem with a transformation. So I figured I'd give that a shot with the Excel Destination. I switched it over to Fast Load (in order to be able to get to the MaxBatchSize parameter, to set it to 1-- I don't usually use it), dropped all the columns but one, and tried to execute the task with that single mapping, of a four-byte signed integer. I redirected the error output to a text file, but it's a four-byte signed integer, how can anything go wrong?

Here's a piece of the text file that comes out.

,,,,,,0,,,,,,,,,,,,-1071607685,-1
,,,,,,0,,,,,,,,,,,,-1071607685,-1
,,,,,,1,,,,,,,,,,,,-1071607685,-1
,,,,,,2,,,,,,,,,,,,-1071607685,-1
,,,,,,2,,,,,,,,,,,,-1071607685,-1
,,,,,,0,,,,,,,,,,,,-1071607685,-1
,,,,,,0,,,,,,,,,,,,-1071607685,-1
,,,,,,0,,,,,,,,,,,,-1071607685,-1

Obviously, the problem is not with four bytes being too small to hold the integers that are failing out on me. The brilliant -1071607685 error code translates to "no status is available." Which tells me less than nothing.

I have deleted and recreated the destination spreadhseet to make sure there's no corruption in a template or anything. I've tried this single-mapping approach with every column (Unicode string, four-byte signed int, and currency), and, of course, with all columns. I've read every page I can find on the internet about DTS_E_OLEDBERROR, DTS_E_INDUCEDTRANSFORMFAILUREONERROR, and -1071607685, and tried every applicable suggestion. It works wonderfully when I send the output to a flat file destination, but as I said previously, that is not an option that's available to me in production, only in testing-- I must use the Excel Destination for this client.

I don't even know where to begin looking at this point. I've exhausted all my possibilities. Anyone have any other ideas? Thanks.

Source: http://community.livejournal.com/sqlserver/60479.html

Date: 06/24/07 (MySQL Communtiy)    Keywords: mysql, sql

Does anybody has an experience with japanese language with mySQL?
my client asked to implement "two bite kanji". What should I set in mySQL in order to get it work?
Thanks,
Roman

Source: http://community.livejournal.com/mysql/115333.html