Date: 01/18/08 (Data Management)    Keywords: mysql, database, sql, postgresql, security, linux

In all the media excitement over the week's two database deals, Oracle buying BEA Systems and Sun buying mySQL there's a name we're forgetting. It's PostgreSQL. PostgreSQL keeps on keepin' on, getting bugs fixed, upgrading its security, and integrating those fixes with major Linux...

Source: http://blogs.zdnet.com/open-source/?p=1903

Date: 01/20/08 (Javascript Community)    Keywords: php, mysql, html, xml, sql, java, web

Квалифицированно выполняю задачи разного уровня сложности по разработке необходимых Вам web-приложений
Технические инструменты: HTML, XHTML, DHTML, Ajax, JavaScript, XML, XSL, PHP, Субд MySQL
Книги, учебники, документация по Веб-дизайну (html, php, mysql, ajax)
Статьи и обзоры
-----
Роман Лащук
Контактная информация:
icq: 266-299-ноль-четыре-восемь
mob: +38 (095) 180-30-ноль-пять
e-mail: infodevel(sobaka)gmail.com
-----
Выполненные работы:
www.che5.com.ua, www.kddgroup.com.ua, www.kolbiko.com, www.radast.com.ua, www.webmoney.dn.ua, www.dnt.com.ua, www.wineyard.com.ua, www.sommelier.dn.ua, www.real-avto.com.ua, www.lobzz.com, www.gloria.dn.ua, www.ivi-indoor.tv

Source: http://community.livejournal.com/javascript/149318.html

Date: 01/20/08 (Web Development)    Keywords: php, mysql, html, xml, sql, java, web

Квалифицированно выполняю задачи разного уровня сложности по разработке необходимых Вам web-приложений
Технические инструменты: HTML, XHTML, DHTML, Ajax, JavaScript, XML, XSL, PHP, Субд MySQL
Книги, учебники, документация по Веб-дизайну (html, php, mysql, ajax)
Статьи и обзоры
-----
Роман Лащук
Контактная информация:
icq: 266-299-ноль-четыре-восемь
mob: +38 (095) 180-30-ноль-пять
e-mail: infodevel(sobaka)gmail.com
-----
Выполненные работы:
www.che5.com.ua, www.kddgroup.com.ua, www.kolbiko.com, www.radast.com.ua, www.webmoney.dn.ua, www.dnt.com.ua, www.wineyard.com.ua, www.sommelier.dn.ua, www.real-avto.com.ua, www.lobzz.com, www.gloria.dn.ua, www.ivi-indoor.tv

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

Date: 01/21/08 (Asp Dot Net)    Keywords: database, sql

My users need to search a database using an "advanced search" feature.

The advanced search feature has a number of parameters that the user can specify or not specify depending on their needs.

EG search by company name, city, state or search by company name & state or search by city & state

So some of the possible parameters could be blank.

In that case, am I better using dynamic SQL rather than a stored procedure ?

I know stored procedures run faster than dynamic SQL but the SP to handle all the possible permutations of search criteria will make the SP very difficult to write and maintain.

Source: http://community.livejournal.com/aspdotnet/94233.html

Date: 01/24/08 (WebDesign)    Keywords: php, sql

I am looking for a simple news management system (like CuteNews) but it must let you post articles that you have to be logged in to see (like a forum).

It would also be very helpful if it was PHP only, no SQL.

Does such a thing exist?

It's for my rover crew to post messages, meeting notes and stuff but we don't want it completely public. If there's another easy way of doing this I am open for suggestions.


Thanks a lot:=)

Source: http://community.livejournal.com/webdesign/1356211.html

Date: 01/25/08 (MySQL Communtiy)    Keywords: mysql, sql

Hi all,

is ist OK for MySQL that index lenght are larger than a data in a table?

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

Date: 01/25/08 (PHP Community)    Keywords: mysql, database, sql

Hey Guys, I'm new to this community so if this is the wrong place to post please let me know.

I decided tonight to focus on my development environment. Has any one successfully gotten Zend Platform 3.0.3 to run on OS X Leopard 10.5? I was determined to get in running tonight and after about 4 hours I was able to get in installed but keep getting this error after logging in. Im sure there is another error around the corner but this is the current one. :)

Cannot parse database connection data from '', probably the connection data, zend_monitor.events_db directive in the zend.ini file, is invalid.

Specs:
Macbook Pro
MAMP Pro
Zend Platform 3.0.3
Zend Studio 5.5

From what I read Zend Platform installs its own mysql to monitor the local mysql server. Not 100% sure why but at the moment that is my hang up.

Any advise or links would be greatly appreciated.

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

Date: 01/25/08 (Data Management)    Keywords: mysql, software, sql

Sun Microsystems has made a lot of progress in recent quarters: It has become more efficient, stabilized spending, transitioned to new products and made smart acquisitions like MySQL in a quest to offer a complete software stack. But there is one lingering question: Can the company grow? ...

Source: http://blogs.zdnet.com/BTL/?p=7714

Date: 01/25/08 (Web Development)    Keywords: php, mysql, sql

I was amazed at how straightforward this was, and I had to share. If you have ever wanted to run a test server on your Mac but thought it was too complicated / too much of a pain, I suggest you download MAMP a virtual testing server that includes PHP and MySQL. It is super friendly to use.

Is there something like this for Windows users?

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

Date: 01/25/08 (Data Management)    Keywords: sql, microsoft

Visual Studio 2008 went to manufacturing at the end of 2007. Windows Server 2008 is expected to be RTM'd in February. But SQL Server 2008 -- the other of the three products Microsoft is slated to launch together on February 27, 2008, in a big corporate event in Los Angeles...

Source: http://blogs.zdnet.com/microsoft/?p=1133

Date: 01/26/08 (MySQL Communtiy)    Keywords: mysql, database, sql

hi mates,

there's a problem I have, so would be great if someone could help me.

I'm trying to import a .csv table into MySQL database. Following the instructions, I started a  new schema and a new table, which has exactly the number of columns as the table I'm importing. Then I run the following syntax:

LOAD DATA INFILE "F://Documents and Settings//Jah Alarm//Desktop//Bart//HAYForecast2005-3.csv"
INTO TABLE hay_2005
FIELDS TERMINATED BY ",";

I get the following message: Duplicate entry '"HAY2201 "' for key 1

And as a matter of fact only the first entry from the table is imported.  Besides, all the  entries look like "x" rather than just x

What am I doing wrong here?

cheers,

j_a

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

Date: 01/27/08 (MySQL Communtiy)    Keywords: mysql, sql

sort of a sequel to my previous post.

I'm importing a .csv file into mysql table. All entries in the original flie are in the following format: "price", separated by commas. After they are imported, the number of quotation marks doubles, i.e. in my table every entry looks like ""price"", which sucks! I need to export this into Matlab or other interfaces, or simple Excel spreadsheet, and what I get is "price" rather than price!

Could anyone help here?

cheers,

j_a

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

Date: 01/29/08 (Open Source)    Keywords: mysql, sql

Will Red Hat be the only major pure play open source company to go public? That’s what observers are wondering as more and more open source stars are swallowed up by traditional proprietary giants, with Nokia’s purchase of Trolltech – announced yesterday - and Sun’s buy of MySQL earlier this month being the most recent. [...]

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

Date: 02/02/08 (MySQL Communtiy)    Keywords: php, mysql, sql

Hi!

According to my host, this query is blocking the mysql by causing a max_user_connections error, but I can't see the problem in it. Can anyone help me, please?

(The code is PHP)

$query = "SELECT $entries_table.fic_title, $entries_table.id, $entries_table.fic_url, $entries_table.wip, $entries_table.notes, $entries_table.date, $entries_table.hits,
$fic_cats_table.fic_id, $fic_cats_table.cat_id
FROM $fic_cats_table
LEFT JOIN $entries_table ON $entries_table.id = $fic_cats_table.fic_id
WHERE $fic_cats_table.cat_id = $cat AND $entries_table.date = '$date' ";

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

Date: 02/06/08 (Web Development)    Keywords: cms, php, mysql, sql, web, linux, hosting

Hi all,

I have checked time and time again on the 1and1.com website to see which CMS they support, but their website isn't much help, or perhaps I am looking in the wrong direction.

I was wondering if anyone here has uploaded a CMS (Content Management System) to their 1and1.com domain and I was wondering how you went about doing this? We prefer a CMS in which users could easily add new pages/delete pages, add new content and with which we could upload our own files - since we will be handing them the site after we've built it, and since they cannot afford to hire someone to maintain all the coding.

We thought about using the WebBuilder feature, but that only limits our website to 8 pages and wouldn't allow us to upload our own content.

Our webhosting includes Linux, with PHP and MySQL support - if this means anything to anyone.


Thanks,

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

Date: 02/07/08 (C Sharp)    Keywords: browser, database, asp, sql, web, google

This is both a SQL Server 2005 and a C# question, so I'm posting it in the community that probably isn't as sick of me asking questions yet...

I've googled this extensively for the past two hours. All of the pages I'm coming up with either (a) have something to do with ASP, (b) have something to do with surface area configuration, and/or (c) have something to do with SQL Express. None of these is the case with my problem.

I'm trying to create a data source in a C# project. When I test connection (or just try to hit OK), I get the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

I am using SQL Server 2005 Standard Edition. Both the SQL Server engine and the database are on my computer, though they are on different drives. I can connect to the database with SQL Server Management Studio (I've been building it all morning in Management Studio). Despite it not being my problem, I have checked Surface Area Configuration, and "Local and remote connections" is checked. I have stopped and started SQL Server Browser, as I have also been advised to do by some pages, with no effect. This is a Windows Application, not a Web Application, and there is no ASP involved.

Anyone have any ideas of what might be causing this problem other than remote connections? Thanks.

Source: http://community.livejournal.com/csharp/92288.html

Date: 02/19/08 (Data Management)    Keywords: technology, sql, microsoft

Microsoft is rolling out on February 19 a new Community Technology Preview (CTP) test build of SQL Server 2008. The new build, which Microsoft is labeling as "feature-complete," will be available for download by any of the 100,000 testers who are registered to participate in the CTP...

Source: http://blogs.zdnet.com/microsoft/?p=1200

Date: 02/21/08 (MySQL Communtiy)    Keywords: mysql, browser, database, sql, web

Hey all

I'm having difficulties connecting to an online database.

I uploaded it online using the webhost's database manager.

As I would need update the database very frequently, therefore going through the webhost way (using the database manager to update) is pretty troublesome... I thought of connecting to the database directly from MySQL query browser. 

So I have the following details (they are all correct, as given and checked by webhost):
Database name
Username
Password
Server IP

When I start up MySQL query browser, it shows me this "Connect to MySQL Server Instance" window, prompting me for:
Stored Connection (i filled it up with 'nameofdatabase' @ 'server IP')
Server Host (i filled it up with 'server IP')
Port (it's 3306 by default, so i left that number there)
Username (i filled it up as given by webhost)
Password (self explanatory, filled that up too.)
Default Schema (i filled it up with database's name)

After filling all those up, I SHOULD be able to connect to my database. Instead, I keep getting this error:
"Access violation at address 00342F02 in module 'libmysql.dll'. Read of address 00000004."

What exactly does this error mean??? I really need to connect to the database ASAP. Would appreciate any form of help. Thanks!

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

Date: 02/21/08 (PHP Community)    Keywords: php, mysql, database, sql, hosting

i have a new client that moved their site from a good but expensive hosting company to a not so good but inexpensive one. the reason was just price. the expensive one was $300 a month, the inexpensive $100 a year. their site is written in php with a mysql database. they are using about 7.5 megs of their database. the problem, of course, is performance: response is ridiculously slow, they are having form problems, et al. now my question. does anyone here know of any decently good hosting companies that i could recommend to my client? they need a switch, but i don't think they want to go back to the one that is $300 a month. usually i deal with very small sites, so i don't know any myself that can manage all this data. thanks for any help you guys can provide, this community is great :o)

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

Date: 02/26/08 (Web Development)    Keywords: sql

Suppose I have a table filled with events and a date for each event in 'datetime' format. I would like to construct an SQL query that returns a list of events within a specified 49 day block. How would I do this?

SELECT *
FROM events
WHERE date
BETWEEN 2008-03-01 10:00:51
AND 2008-02-29 10:00:51

Doesn't work, and I don't know where to go from here.

Ideally I would like something with math involved like
SELECT *
FROM events
WHERE date
BETWEEN x
AND (x+49)


Do I use the AS keyword to do a TO_DAYS conversion? i haven't a clue.

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