Date: 01/03/08 (SQL Server)    Keywords: database, sql

Is there any way to simply check what the compatibility level is on a database without changing it in SQL Server 2005?

Everything I've found points to sp_dbcmptlevel, which will not simply return the level the database is currently at, it requires you to enter a value to change it to. I need to return the current compatibility level, not write over it.

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

Date: 01/06/08 (PHP Community)    Keywords: php, mysql, sql

Hi,

I'm not very experienced with PHP/MYSQL, so I'll try and keep this as simple as possible. :P


I have dates stored in MySQL as DATETIME.

In my script, I'm trying to get it to display all the results for week #. Week # being 1-52. (I know in PHP it's displayed with "W")

... I have no idea how to do this. :| That is, extract the "W" from the DATETIME.

I'm guessing I might have to strtotime() it and then date() but then that confuses me because I'd have to be doing it in the calling query itself?

Eep. Help much appreciated. :)

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

Date: 01/08/08 (WebDesign)    Keywords: php, mysql, sql, web, hosting

Powweb gave me my money back. I guess I was no longer worth the trouble. Bless them :o).

I had given up on getting my money back. I was searching for class action lawsuits online to participate in and I posted bad reviews about them every time I came across a legitimate review site. I was always in good company with the exception of epinions where I was the first one to post an entry about them. No, I was not obsessed with them, but every day they did something that further aggravated and inconvenienced me. As you all know, I had decided to just keep the account because it was paid for and I didn't believe I'd get my money back anyway. No way they get to keep my money AND shut me down!

They also had a pending charge on my account for November of 2008 when the account would have expired, an auto renewal. I asked them to remove that charge from my account because there was no way I was going to renew anything with them. I made the request twice with no response. On the 3rd request, they closed the account with no warning and no notice. I simply went to sign into the account and got an error. So then I spent over an hour on chat where I told them that I had paid for the account and I wanted it on even though at this point, I was pointing my domain to my new webhost anyway and was in the process of transferring the domain. They said that I had requested that the account be closed it could not be reversed but I could sign up for a new account. I told them that I had not made that request and I explained that I had requested that the auto renewal be turned off. The account didn't expire until 11/08. It was like talking to a robot. She kept repeating the same thing. It was 90 minutes that I was on with her until I just finally got so sick of her that I just disconnected the chat and decided to release this struggle. It wasn't even worth the money. I realised at that point, that I just needed to let it go.

Please be clear that at this point, I am with another company. Unfortunately, Powweb still has their talons in my domain names. My new webhost has been trying to transfer the domain for about 2 weeks now and has been unsuccessful. The new host is telling me the process is taking a while because Powweb won't release their hold on my account. Powweb says this isn't the case. Even though checking with an independent source, I can see that Powweb really doesn't have my domain locked, for whatever reason the new host has been unable to complete the transfer. I don't know what's going on, but it's taking a while and I want my domain names completely moved because I really believe that Powweb is a sinking ship and they will be gone soon and when it's time to renew my domains, I don't want any problems. So I'm paying the cost to get my domains transferred to a different reseller. The whole thing has been a pain in the ass.

I really appreciate that Powweb returned my money, but make no mistake about it, until they fix the MySQL issue, they will still remain a 0 in a rating of 1 to 10 with 1 being the lowest. Also, what I had to go through to get them to give me my money back is an outrage and at the least, I'd say I earned about $5 per hour of my total refund just in the time I spent first of all, trying to resolve this problem that they were never going to resolve for me and then the actual process of trying to get my money back. So they get no cookies, but I do like having my money back. It puts a period on the situation.


P.S. This guy sums up the issues with Powweb much better than I did.
http://www.webhostingtalk.com/showthread.php?p=4893525&highlight=powweb#post4893525

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

Date: 01/10/08 (WebDesign)    Keywords: php, mysql, sql, spam

I'm curious what people here see as the current best practice for email forms.

Lately it seems that the standard Form2Mail cgi (Matt's scripts) that I've had in place for years, has started generating a lot of empty messages, or messages from "nobody@isp.com"... i'm interpreting this to mean that they are getting more attempted attacks from spammers. Or they stop working periodically (!)

What is the current preferred method of sending secure email from a form, without the mailto address being visible to spambots? I've seen more php out there these days- But it's hard to decide at face value if any of the purported free php things out there are any good.

At one bulk host, i tried the wizard to set up a php-MySQL "php form generator" (phpformgen.sourceforge.net) but that proved really difficult to set up and i never did get it working.

Suggestions? I'm looking for free, or cheap license for a bunch of different sites.

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

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

What kind of Collation setting should I use for my Comments section in my MySQL database?

It defaulted to:  latin1_swedish_ci

is this right?

Signed:  Frustrated

-------------
Update
------------

It IS right...and indeed I am a lummox!

-------------
/Update
------------

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

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

By using mySQL to do it, and buying mySQL support contracts, Virgin Mobile is calling mySQL enterprise-ready.

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

Date: 01/11/08 (Data Management)    Keywords: mysql, database, sql

Virgin Mobile's decision to base its SMS database on mySQL is an important milestone for the GPL database. This was not Virgin's first entry into open source. Virgin Mobile also runs Red Hat. Virgin Mobile is a scaled enterprise. Even though SMS messages are...

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

Date: 01/12/08 (Javascript Community)    Keywords: php, sql

 В зеленоградский офис инвестиционно-финансовой компании "Опцион" требуется программист: PHP+C#+SQL
Требование: опыт работы и наличие реализованных проектов;

Условия:
+ З.П. от 1200 у.е. до 2000 у.е. по итогам собеседования;
+ бонусы;
+ гибкий график, возможность совмещения с учебой для студентов;
+ Работа в Зеленоградском Бизнес Центре.

ICQ 396255537, info(собака)option.ru (с пометкой программист)

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

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

I am currently with Startlogic and I've unfortunately learned the hardware that they aren't as good as they once were or people said they are. As of October 16, Startlogic started 'migrating' users to a new platform. My migration date has come and gone. I am still not able to manually migrate my site to the new platform either. Tech Support still hasn't gotten back to me.

I was wondering if there is anyone out there that could give me some recommendations.

I'm looking for a provider with these features:

• >50 GB Storage
• >1TB Bandwidth
• PHP 5
• AJAX
• MySQL 5
• FTP
• SSH
• Word Press
• Photo Gallery
• Multiple domains
• cPanel

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

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

A table exists where the same id can be issued more than once. Each id has an accompanying color.

SQL to build table:

 CREATE TABLE `xorder` (
`id` INT( 3 ) NOT NULL ,
`color` VARCHAR( 20 ) NULL ,
) ENGINE = MYISAM 

 INSERT INTO `xorder` (
`id` ,
`color`
)
VALUES (
'1', 'green'
), (
'2', 'red'
), (
'3', 'black'
), (
'1', 'yellow'
), (
'2', 'blue'
), (
'1', 'orange'
), (
'2', 'white'
), (
'2', 'purple'
), (
'4', 'blue'
), (
'5', 'gray'
)

id	color
1	green
1	yellow
1	orange
2	red
2	blue
2	white
2	purple
3	black
4	blue
5	gray

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

Date: 01/16/08 (Data Management)    Keywords: mysql, database, sql

Updated: Sun Microsystems is taking the plunge into the database market with the purchase of open source database developer MySQL for $1 billion ($800 million in cash in exchange for all MySQL stock and assumption of approximately $200 million in options). With the move, announced Wednesday, Sun...

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

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

Sun announced Wednesday that it is buying MySQL for about $1 billion -- $800 million in cash and $200 million in options. The news comes on the same day that mega proprietary database software giant Oracle announced its intent to buy middleware giant BEA. The deal,...

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

Date: 01/16/08 (Open Source)    Keywords: mysql, software, database, sql

Sun announced Wednesday that it is buying MySQL for about $1 billion — $800 million in cash and $200 million in options. The news comes on the same day that mega proprietary database software giant Oracle announced its intent to buy middleware giant BEA. The deal, which awaits regulatory approval, should allay any talk that [...]

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

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

This morning, after digesting Oracle's acquisition of BEA and Sun's consumption of MySQL, I headed down SAP's Palo Alto offices to hear how the enterprise software giant will digest its latest acquisition, Business Objects. SAP CEO Henning Kagermann said Business Objects gives his company number one leadership...

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

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

I just read the announcement that Sun has acquired MySQL for $1 Billion. Rather than just citing the facts and wishing that I was one of the founders of MySQL so that I could purchase that dream home in Florida, I'd like to consider what's really going on rather than...

Source: http://blogs.zdnet.com/virtualization/?p=322

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

It's obvious that, if you're running a proprietary database system it's probably going to say Oracle on it sooner-or-later. But is the way to open source now closed with Sun taking over mySQL?

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

Date: 01/17/08 (Data Management)    Keywords: mysql, database, sql

Two things seem self-evident concerning this week's news about Oracle buying BEA and Sun acquiring mySQL: This is an important turning point for enterprise open source, and the database business generally. Everyone has an opinion on it, but no one really knows anything. I...

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

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

Oracle finally nails BEA, SAP completes its deal to buy Business Objects: the day started out making a lot of sense. But when I heard that Sun had spent $1 billion to buy MySQL, I had to check the calendar. No, it wasn't April Fools Day, just another day in...

Source: http://blogs.zdnet.com/Greenbaum/?p=146

Date: 01/18/08 (Open Source)    Keywords: mysql, database, sql, postgresql

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.

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

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

The IBM example shows Sun may be going about this in the wrong way. IBM doesn't control Eclipse. IBM doesn't own Eclipse, in the way Sun now owns mySQL.

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