Date: 08/20/08 (IT Professionals)    Keywords: database, asp, sql, web, hosting

I have two dead beat ASP sites I need to get off a under used dedicated rack and onto some sort of shared hosting service.... my biggest problem is that I despise GoDaddy and they're about the only name I know of in the ASP shared hosting world. Anyone else out there have any experience with shared ASP hosting services and who to avoid or who to check into.

Also this is legacy,lets gut VBA and make it a web script, ASP with minimal MSSQL backend data ( 2 databases, 1:1 per site )

Source: http://community.livejournal.com/itprofessionals/78636.html

Date: 02/17/09 (Web Development)    Keywords: database, asp, sql, web

Hi,
What I am trying to do this time is create an asp.net listbox from
an SQL Server 2005 result set (done) which then users can sort the
records to form the running order within the same Listbox and then
submit all the records including the new running order back into
the database. Each record has already been automatically assigned
a running order number based on their position in the old website.

I am looking for suggestions on the quickest and *easist* way to do
this, examples would be much appreciated. My web application is asp.net
written in C#.

Any help is appreciated.

(cross-posted on asp.net)

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

Date: 02/13/09 (Web Development)    Keywords: php, html, technology, sql, web, linux

Hi Guys!

Here is a great opportunity to get a high paid interesting job in Barcelona.

This is a copy-paste from our positions list:

- PHP Developers (2+ years of Exp)
- MS SQL Developers (2+ years of Exp)
- Flash Developers - ( 3+ years of Exp w/ Action Script 2 – 3)
- Python Developers - (2+ years Exp)
- C/C++ Developers - ( 3+ years of Exp)
- Mobile-platforms Developers – (2+ years of Exp)
- Network Engineer / Linux Sys Admin – (4+ years Exp)
- HTML /XHTML Developers – ( 2+ years Exp)
- Graphics & Web Designers - ( 3+ years Exp in WWW & Digital Media )

Note: Candidates must be able to legally work in Spain and be able to
speak, read, & write in
  English.

And a bit about the company:

ISS iMedia is a dynamic, exciting and fast moving multi-media,
multi-platform technology and entertainment company at the forefront
of media technology. Having developed various world first technology
solutions in the converging Internet, Mobile and interactive ipTV
markets, including the world's first cross platform live video
telephony solution that is now being used by some of the world's
largest global players in over 30 countries - from Internet sites,
Satellite channels, Mobile Networks to top Hotel Chains.
ISS iMedia is a highly successful and fast expanding company with new
offices in Barcelona, offering an excellent opportunity to become part
of a team that takes the company to the next level of rapid growth.

If you need more information or you want to apply for the position,
sent CVs here: hr@issimedia.es

P.S. If you have someone to recommend - welcome!

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

Date: 02/10/09 (Web Development)    Keywords: php, mysql, sql, web, shopping

A client of ours wants to integrate a shopping cart into their website, but one of the features they want the cart to have is that the product page has to allow for price-altering features to be selected. So say you want to buy a picture. That picture is $24 base. But you want it framed, and you want to choose Frame XX; which is another $32. And you want Matte YY which is another $5.

The cart would have to show those price increases right on the product page; rather than at checkout.

I was wondering if anyone could recommend a cart solution for this sort of functionality. We don't mind paying vs. open source, or if the functionality is through a 3rd party addon. The only condition other than providing that feature is that it be PHP / MySQL driven.

Many thanks in advance.

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

Date: 01/15/09 (Web Development)    Keywords: php, mysql, asp, sql

Hello all!

I hope it is a right community for my question.

I have to setup a new MediaWiki site using IIS.


The server does not have PHP and MySQL installed, so I must install it first.

The step 1 was to install PHP.
I've done it as described here:

http://learn.iis.net/page.aspx/247/using-fastcgi-to-host-php-applications-on-iis-60/

In this description the file php-cgi.exe is mentioned.

But I've got only the file php.exe after installation.

What could be my mistake?

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

Date: 03/10/09 (Java Web)    Keywords: sql, web

Are you one of those Telegraph subscribers? You must have known by know that the online website of British UK newspaper Telegraph has been hacked. The proofs in Hackersblog confirm that the site has been hacked by Romanian whitehat hacking group. It also revealed that the hackers have used SQL injection technique to  access Telegraph's [...]

Source: http://blog.taragana.com/index.php/archive/telegraphcouk-hacked/

Date: 02/03/09 (Code WTF)    Keywords: sql

Иногда приходится писать редчайший маразм.

Source: http://community.livejournal.com/code_wtf/155776.html

Date: 02/25/09 (SQL Server)    Keywords: sql

Коллеги, ищется очень хороший DB(A) MSSQL для компании Innova Systems, Москва.

Задачи, которые будут ставиться перед вами - амбициозны и технически сложны. Вы будете работать в игровой индустрии, где требования к проектам меняются очень быстро, а нагрузки на системы очень высоки.
Процесс разработки построен по методологии Agile - Scrum. У вас будет возможность изучить новейшие методы работы команды и стать Scrum-мастером, если захотите.

Если вы получаете удовольствие от разработки и настройки баз данных и , если вы ищете драйв в работе и если хотите работать в команде лучших специалистов - мы ищем именно вас.

З/П определяется по результатам собеседования. Предлагайте ваши варианты.
Мы рассматриваем кандидатов из других городов и оказываем помощь при переезде.

Кратко о компании:
Мы занимаемся топовыми MMORPG (Lineage2, RF, R2 etc)
Даем - работу в компании, которая растет даже в кризис.
Официальное оформление, офис на м. Павелецкой


Должностные обязанности:
* Проектирование баз данных
* Участие в проектах разработки программного обеспечения в качестве эксперта БД
* Разработка и поддержка различных скриптов, хранимых процедур, триггеров и других объектов баз данных
* Оптимизация производительности баз данных
* Разработка, планирование и реализация ‘housekeeping’ задач на всех поддерживаемых серверах баз данных

Требования:
* Глубокие знания проектирования, внедрения и поддержки баз данных для приложений
* Опыт работы с MS SQL 2000,2005 от 3-х лет
* Опыт поддержки систем с высокой доступностью (7x24x365)
* Опыт разработки бекап/рековери стратегий, безопасности, мониторинга и оптимизации производительности
* Глубокое понимание концепций проектирования БД
* Высшее техническое образование
* Умение работать в команде
* Знание английского языка

Желательно:
* Опыт администирирования и работы с высоконагруженными OLTP базами данных
* Опыт работы с ETL (Extraction, Transformation, and Loading)
* Опыт работы с OLAP (On-line Analytical Processing) - плюс
* Знание администирирования серверов, администрирования безопасности и администирирования сети желателен
* Опыт работы c SAN


email: suren@innovasystems.ru
skype: surensv

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

Date: 02/17/09 (SQL Server)    Keywords: sql

SSRS.
Bank in Pleasanton, CA.
Now.
Must pass a 30-minute SQL test.
Must be willing to put up with me for a boss.
No sponsorship.
Details on request.

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

Date: 11/12/08 (SQL Server)    Keywords: sql

T-SQL Code:

[...]
SET @OGCWKT = (SELECT Geometry FROM inserted);
SET @valuesOnly = LEFT(@OGCWKT,LEN(@OGCWKT)-1);
SET @valuesOnly = RIGHT(@valuesOnly,LEN(@valuesOnly)-12);
RAISERROR(N'@valuesOnly = %s',0,0,@valuesOnly);
DECLARE @Index INT;
SET @Index = (SELECT CHARINDEX(@valuesOnly,N','));
RAISERROR(N'charindex of , = %i',0,0,@Index);
[...]


Input:

Geometry = 'LINESTRING (-1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917)'


Output:

@valuesOnly = -1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917
charindex of , = 0
Msg 536, Level 16, State 5, Procedure InsertEdge, Line 38
Invalid length parameter passed to the SUBSTRING function.
The statement has been terminated.

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

Date: 09/12/08 (SQL Server)    Keywords: sql

Okay, this is new...

SQL Server Express Edition 2008. Brand-new install. For some reason SQL Server Agent was listed as Disabled in the agents listing, so I set it to automatic and started it. It worked. I restarted the computer (for an unrelated reason) and started having problems connecting from C#, so I checked the agent again. It was again listed as disabled. I switched it once again to Automatic and hit Start, at which point I received the following message:

"The SQL Server Agent (SKINGAWEE) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

SkingaWee (the instance name) is currently running, I have it open in Management Studio. Thus, it would seem Agent would have something to do. Anyone know why this might be occurring and, more importantly, how I can fix it?

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

Date: 04/10/08 (SQL Server)    Keywords: database, sql

Hi,

I'm new to this community. I joined last week. I hope posting a Crystal Reports question is OK to do here.

I'm using a SQL server to store a database that contains calibration data. I have been using Crystal Reports to create calibration certificates and so far everything has been working fine. Recently I started working on a way to create calibration labels using Crystal Reports. I have everything laid out fine and all the correct data is being displayed. The problem I am having is trying to make the report start printing from a specific location.

I'm trying to print to a sheet of labels. There are 30 labels on the sheet. 10 rows and 3 columns. There isn't a problem if I'm trying to print on a brand new sheet of labels. The problem I'm running into is trying to start printing on a specific row/column.

For example, I had a brand new label sheet and printed 13 calibration labels. So I have used up the first 4 rows and the first column on the fifth row. Now the next time I want to print calibration labels I want to start on the second column of the fifth row. Does anyone know a way to do this?

I'm currently using Crystal Reports 8.0 but I'm planning on getting the newest version in a few weeks.

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

Date: 02/03/09 (MySQL Communtiy)    Keywords: mysql, database, sql

Folks may remember last week when I was asking questions about mysqldumps. I was doing that in order to get a DB backup for a specific database we wanted to replicate on another server, and I've been working on that.

After some hit and miss I think I nearly got it working, at least to a point where the replication started between the Master and the slave. It seemed to work for a few seconds, then bombed when the slave tried to execute a statement that was for a DB that it didn't have in it.

The point is that of all the several databases on the Master machine, at this point we only want to replicate one on the slave machine. I thought I had had that set up in the slave's my.cnf with the line

replicate-do-db - aid #aid is the database we want to replicate

however High Performance MySQL says that this is not the way to do this since filtering will be done on the current default database. "This is not usually what you want." :-)

The book does indicate that "On the slave, the relicate_* options filter events as the slave SQL thread reads them from the relay log." This make sense to me, and at this point it also makes sense that the log coming from the master has every statement coming into the DB. It goes on to say that "You can replicate or ignore one or more databases (emphasis mine)...based on LIKE pattern matching syntax." There is where I lose it. I understand how to use the LIKE syntax in mySQL statements, but not in this environment.

Is it possible to set up a small battery of statements in the slave my.cnf along the lines of:

replicate_ignore_table = .%

Would that do it?

Is anyone basically doing replication in a simple Master-Slave relationship where you are only replicating one DB? If so, how are you doing it?

THANKS, folks!

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

Date: 01/28/09 (MySQL Communtiy)    Keywords: mysql, database, sql

Folks, I'm having what I think is a weird problem restoring a DB from a mysqldump. What I'm trying to do is basically copy a DB from one mysql database server to another.

The mysqldump command I used originally was:

mysqldump --quick --add-locks --extended-insert -u root -p dbname > dbname.sql

When this didn't work upon restoration I also tried:

mysqldump --opt -u root -p dbname > dbname.sql

Both these commands created the dbname.sql file with no problems or complaints.

I copied the SQL file over to the target computer. I went into mySQL as root and did:

create database dbname;
use dbname;
source dbname.sql;

The import would start, but it wouldn't get very far. In the end, after not many seconds it would just...stop. Here is an example:

Query OK, 8708 rows affected (0.11 sec)
Records: 8708 Duplicates: 0 Warnings: 0

Query OK, 8750 rows affected (0.12 sec)
Records: 8750 Duplicates: 0 Warnings: 0

Query OK, 8740 rows affected (0.11 sec)
Records: 8740 Duplicates: 0 Warnings: 0

Query OK, 8758 rows affected (0.11 sec)
Records: 8758 Duplicates: 0 Warnings: 0

Query OK, 8745 rows affected (0.12 sec)
Records: 8745 Duplicates: 0 Warnings: 0

^CQuery aborted by Ctrl+C
^CAborted
mysql: 0 files and 1 streams is left open

$

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

Date: 12/17/08 (MySQL Communtiy)    Keywords: mysql, database, sql

I need to "synchronize" the output of a stored procedure in one database (I don't have access to any tables there, just stored procedures) and a table in another database. So I need to call a remote stored procedure once in a while and populate a local table with its output. For the remote database, I know hostname, port, username, password and db name.

Is this possible in mysql? Any help would be appreciated

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

Date: 12/11/08 (MySQL Communtiy)    Keywords: mysql, database, sql

I'm starting a new consulting gig that requires me to work on a MySQL database. Typically, I use Rapid SQL as my IDE, but I have been informed that it doesn't support 5.x. What IDEs out there support MySQL 5?

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

Date: 12/07/08 (MySQL Communtiy)    Keywords: html, sql, google

Heyo. I'm putting together a user search function and I would like to include a Facebook-style name recognition system that understands name synonyms. A search for Will would also return Bill and William, for example. To some extent I could see a Soundex search kinda accomplishing this, but I'm wondering if anyone has any really good ideas as to how to implement this. At the moment I'm trying to find a sql dump of name synonyms which I would use for cross-references.

Anyone done this before and have some words of wisdom?

*update*

I've found this: http://answers.google.com/answers/threadview/id/778986.html

... which is definitely helpful.

I created a SQL file and posted about it here: http://danconnor.com/wordpress/?p=138

I'm still open to suggestions though!

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

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

I have a table as below (Slightly truncated, but the idea is there)

mysql> SELECT date, (sat0700 + sat0800 + sat0900 + sat1000) FROM alerts WHERE date LIKE '2008%' ORDER BY date ASC;

+------------+-----------------------------------------+
| date       | (sat0700 + sat0800 + sat0900 + sat1000) |
+------------+-----------------------------------------+
| 2008-09-13 |                                      39 |
| 2008-09-20 |                                       0 |
| 2008-09-27 |                                       9 |
| 2008-10-04 |                                      16 |
| 2008-10-11 |                                       9 |
| 2008-10-18 |                                       4 |
| 2008-10-25 |                                       1 |
+------------+-----------------------------------------+

+------------+-----------------------------------------+---------+
| date       | (sat0700 + sat0800 + sat0900 + sat1000) | average |
+------------+-----------------------------------------+---------+
| 2008-09-13 |                                      39 |       39|
| 2008-09-20 |                                       0 |     19.5|
| 2008-09-27 |                                       9 |       16|
| 2008-10-04 |                                      16 |       16|
| 2008-10-11 |                                       9 |     14.6|
| 2008-10-18 |                                       4 |    12.83|
| 2008-10-25 |                                       1 |    11.14|
+------------+-----------------------------------------+---------+

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

Date: 07/24/08 (MySQL Communtiy)    Keywords: database, sql

I used to use MS Access a lot and I know a little about SQL. My company wants me to change job roles and part of my new role will be writing queries for our company database. All I've ever had to do with SQL was write simple queries, and I usually just built the query in Access and modified as needed. As a test for this position, which I don't really want, they had me write some test queries. This is the first one I came up with and it's so convoluted I ended up needing Access to do it anyway.


SELECT
tblCust.FName, tblCust.LName, tblAdvCust.CardID, tblContacts.Phone, tblAddresses.FirstLine, tblAddresses.SecondLine, tblAddresses.ThirdLine, tblAddresses.City, tblAddresses.State, tblAddresses.Zip, tblCountry.Description

FROM
tblCountry INNER JOIN (tblAddresses INNER JOIN (tblContactTypes INNER JOIN ((((tblCust INNER JOIN tblAdvCust ON tblCust.CustomerID = tblAdvCust.CustomerID) INNER JOIN tblCustomerMembers ON (tblCust.CustomerID = tblCustomerMembers.CustomerID) AND (tblCust.CustomerID = tblCustomerMembers.MemberID)) INNER JOIN tblDealer ON tblAdvCust.DealerID = tblDealer.DealerId) INNER JOIN tblContacts ON tblCust.OwnerID = tblContacts.ReferTo) ON (tblContactTypes.ContactTypeId = tblContacts.ContactTypeId) AND (tblContactTypes.ContactTypeId = tblContacts.ContactTypeId) AND (tblContactTypes.ContactTypeId = tblContacts.ContactTypeId) AND (tblContactTypes.ContactTypeId = tblContacts.ContactTypeId))ON tblAddresses.OwnerID = tblCust.OwnerID) ON tblCountry.CountryID = tblAddresses.CountryID

WHERE
tblDealer.DealerId="109" AND tblContactTypes.ContactTypeId=1;

Now, maybe they haven't explained it to me well enough, maybe they think I have more experience with SQL than I do and just assume there are things I know that I don't. I don't know. But am I expected to be able to write this sort of thing by hand? If I won't have some tools at my disposal to write this up, how am I expected to do this? I can't even wrap my head around this and for the life of me, because of the way the relationships in the database are set up, I couldn't think of a simpler way to do it.

I'm probably going to turn this job down but it seems like they really want me to do it. So if there's a simpler way to go about this, I want to be able to do it. But this is bollocks.

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

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

I have two RHEL5 machines, both built & configured at the same time. Both have MySQL 5.0.45 installed and share an identical database.

So - this query returns 334 on one machine, and 0 on the other:

• SELECT COUNT(*) FROM mytable WHERE DATE(datetimefield) = '2008-05-05';

• SELECT COUNT(*) FROM mytable WHERE datetimefield LIKE '2008-05-05%';

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