Date: 04/05/07 (Web Development)    Keywords: php, mysql, database, sql

here is the site

So basically I am designing a database which lists a client_name, client_description, and then a list of images associated with that particular client. This is all stored in a MySQL database. I am not sure how to handle the images though. Each client will have around 6 images. I currently have it set up where every client has its own folder of images and the PHP just reads every image from that folder and displays it.

Would it be a better idea in terms of best practices to instead have an Images Table that keeps track of every image and what client it is associated with?

Not sure, Mike

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

Date: 04/05/07 (SQL Server)    Keywords: asp, sql, web

I'm building a web application that will use Reporting Services as a reporting tool.

The question I have is this: I have a report that shows projects by various categories (which are parameters to the report). How do I set the Reporting Services parameters without creating my own drop-lists on the aspx page? In the Report Viewer control, I can enter the option "ReportViewer1.ShowParameterPrompts = true;" but I then run the code and change a parameter, it just posts back and doesn't change the parameter's value (like it does from the report server). Am I missing something, or will I have to code drop-boxes for the parameters?

Thanks for any help you can give.

Cross-posted to sqlserver and csharp

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

Date: 04/05/07 (C Sharp)    Keywords: asp, sql, web

I'm building a web application that will use Reporting Services as a reporting tool.

The question I have is this: I have a report that shows projects by various categories (which are parameters to the report). How do I set the Reporting Services parameters without creating my own drop-lists on the aspx page? In the Report Viewer control, I can enter the option "ReportViewer1.ShowParameterPrompts = true;" but I then run the code and change a parameter, it just posts back and doesn't change the parameter's value (like it does from the report server). Am I missing something, or will I have to code drop-boxes for the parameters?

Thanks for any help you can give.

Cross-posted to sqlserver and csharp

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

Date: 04/06/07 (Code WTF)    Keywords: html, sql

Мало, но есть. Давайте вспомним героев большого WTF, а не красноглазых похапистов, опять забывших про sql injection.
Встречайте - Mork DB, худший формат файлов в истории IT. Мой браузер Firefox 1.5.0.11 хранит историю именно в нем (history.dat)

http://www.jwz.org/hacks/mork.pl
http://jwz.livejournal.com/312657.html

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

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

i need to merge rows in a table where column1 = column1 or column2 = column2 or column1 = column2. i'd like to review the data before i merge it. i'm having trouble constructing a query that returns what i need to see. if the table looked like this:

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

Date: 04/08/07 (PHP Community)    Keywords: php, mysql, sql, web

I have a client that may need to have a text message interface with their website. What would type of system would we need to receive and send  text message in a format that I can work with in php/mysql etc

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

Date: 04/12/07 (Code WTF)    Keywords: sql

	/**

	 * @param sql

	 * @param tpl

	 * @param id - ==0 это корневой шаблон, >0 - это обновление строки подшаблона, <0 - это добавление строки подшаблона

	 * @param pid

	 * @param values

	 * @param tableNameSuffix

	 * @return

	 * @throws Exception

	 */

	public static long storeTplValues(

			SqlDb sql, 

			UnitTemplate tpl,

			long id,

			long pid, 

			Map< Long, Object> values,

			String tableNameSuffix) throws SQLException {

		

		Object params[] = new Object[tpl.getNumFieldsNotTemplate() + 1/*for pid*/ + (id!=0?1:0)/*for insert or update*/];

		StringBuffer fieldsBuf = new StringBuffer();

		StringBuffer valuesBuf = new StringBuffer();

		int i = 0;

		for(UnitTemplateField f : tpl.fields) {

			if(!f.isTemplate()) {

				if(i>0) fieldsBuf.append(',');

                fieldsBuf.append("field").append(f.id);

				if(id >= 0) fieldsBuf.append("=?"); // for update or root-template

				valuesBuf.append("?,");

				//System.out.println(f.id + ": "+ values.get(f.id).getClass().getName());

				params[i++] = f.getValue(values);

			}

		}

		params[i++] = pid;

		

		String tableName = TemplateTable.getTableName(tpl, tableNameSuffix);

		if(id < 0) {

			// new sub-template item

			id = GlobalId.getId(sql);

			params[i++] = id;

			sql.insert(

				"INSERT INTO "+tableName+

				" ("+fieldsBuf.toString()+", pid, id)" +

				"VALUES("+valuesBuf.toString()+"?,?);",

				params

			);

			return id; // уровни тройной вложенности пока не поддерживаются!

		} else

		if(id > 0) {

			// update sup-template item

			params[i++] = id;

			sql.update(

				"UPDATE "+tableName+" SET "+fieldsBuf.toString()+",pid=? WHERE id=?;",

				params);

			return id; // уровни тройной вложенности пока не поддерживаются!

		} else {

			// main-template item

			id = pid;

			if(0 == sql.update("UPDATE "+tableName+" SET "+fieldsBuf.toString()+" WHERE pid=?;", params)) { 

				sql.insert(

					"INSERT INTO "+tableName+

					" ("+fieldsBuf.toString().replaceAll("=\\?", "")+",pid) " +

					"VALUES("+valuesBuf.toString()+"?);",

					params);

			}

		}

		

		for(UnitTemplateField f : tpl.fields) {

			if(f.isTemplate()) {

				Map< Long, Map< Long, Object>> list = (Map< Long, Map< Long, Object>>)values.get(f.id);

				if(list == null) continue;

				Vector>> listCopy = new Vector< Map.Entry< Long, Map< Long, Object>>>();

				listCopy.addAll(list.entrySet());



				// имя таблицы подшаблона

				String subTableName = TemplateTable.getTableNameSuffix(f.id, tableNameSuffix);

				// подшаблон

				UnitTemplate subTpl = UnitTemplate.getTemplate(Long.parseLong(f.defValue));

				

				for(Map.Entry> e : listCopy) {

					if(e.getValue() == null) {

                        // строку подшаблона удалили

						sql.update("DELETE FROM " + TemplateTable.getTableName(subTpl, subTableName) + " WHERE id=?", e.getKey());

						continue;

					}

					

					long key = storeTplValues(

						sql,

						subTpl,

						e.getKey(),

						id,

						e.getValue(),

						subTableName

					);

					

					if(e.getKey() < 0) {

						list.put(key, e.getValue());

						list.remove(e.getKey());

					}

				}

			}

		}

		

		return id;

	}

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

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

Hello all,

I'm trying to delete a range of rows in MySQL and coming up broke.

On my command line, I'm doing the following:

mysql> delete from table where table.id in (11700)

Or

mysql> DELETE FROM `table` WHERE `table`.`id` = 11700;

That's great, but, I'll still have 10,000+ more rows to go, and both methods require me to delete rows one by one. I'd rather just delete a range of rows.

I want to only delete rows from 300-11800.Does anyone know how to delete a certain range of rows? Or just tell MySQL to delete a certain range of rows?

Thanks!

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

Date: 04/17/07 (PHP Community)    Keywords: php, programming, mysql, software, browser, css, html, xml, technology, database, sql, java, jsp, web, linux, microsoft, apache

Moderator, if this isn't allowed on this forum just let me know.

I get a lot of emails daily for various web dev and programming positions available. I found a good job, but I keep my resume up. Ya never know.

Just feel guilty constantly deleting them when I know someone may need them. Figured I'd at least post them for any coder friends that may be looking for something. I lj-cut it so it wouldn't be too obtrusive.

If these are just found to be crap, let me know and I'll stop passing them on. But some of them at least appear to have potential. They're all fresh over the past 24 hours.

To whoever is currently looking, hope these help! If it's ok, I'll send periodic digests of these if anyone finds them worthwhile.


Hello,


I came across your resume and would to speak with you in regards to 2 immediate Cold Fusion needs in the Radford, VA areas.

Here are the details.


We need people onsite! 40 hour work week schedules

Location/Address: Radford, VA (Southwestern VA)

Start Date: ASAP

Drop Dead Start Date: ASAP

Project End date: N/A

# Of resources need for role: 1

Position Title: ColdFusion Software Engineer

BE Level/ Job classification: Consultant

Required Skill Set (Yrs Exp):


SKILLS: ColdFusion software developer with experience leading the development of software modules.

EXPERIENCE:
Proven experience analyzing system requirements, guiding overall application development and individual module development. Direct involvement in application development, maintenance and operations of an application environment involving Microsoft SQL Server back-end with Macromedia ColdFusion middleware running on Microsoft IIS webservers.

Specific education and experience requirements include:
1. Minimum 4-year technical degree in Computer Science, Information Technology, or related field from accredited institution
2. Minimum 1 year general programming experience and an additional 1 year experience in web-based application development
3. Minimum 1 year experience with design, development and maintenance of ColdFusion-based online software applications
4. Practical experience in MS SQL Server (v7 or higher) database design, operations, and maintenance involving extensive structured query language (SQL) usage and development of complex queries and procedures
5. Practical experience with MS SQL Server (v7 or higher) database administration
5. Must be a US Citizen
6. Prefer current active Department of Defense (or capable of attaining) Secret Clearance

Preferred Skill Set

Will also consider candidates with Java and JSP experience.



Job#2

Location/Address: Radford, VA (Southwestern VA)

Background of Project:

Start Date: ASAP

Drop Dead Start Date: ASAP

Project End date: N/A

# Of resources need for role: 1

Position Title: Web Page Designer

BE Level/ Job classification: Sr Systems Analyst

Required Skill Set (Yrs Exp):

The candidates we are seeking should be self starters, interested in seeking new ways to help this customer innovate and provide state of the art web design capabilities to DoD customers.

Technical & functional requirements:

- 1-2 years ColdFusion development experience using Version 6.0 or 7.0 (prefer 7.0)
- 1-2 years experience with Enterprise level database design including stored procedures and functions.
- working knowledge of the Fusebox design methodology, using version 3.0 or higher to develop robust web applications.
- proficient with use of Visual Mind software, version 7
- demonstrate ability to elicit requirement definitions from customers, then convert those specifications into realistic software development projects, and further develop a schedule in MS Project for task delegation and performance tracking.
- US Citizen

Preferred Skill Set

XHTML or similar browser based scripting development, web services development experience a plus.
- Cascading Style Sheet development using CSS v2.0 or later preferred.
- Microsoft SQL Server 2000 database design experience preferred.

Please forward me an updated word copy of your resume and give me a call.

Thanks!

Ray Santos | 1-800-627-8323 x9509 | rsantos@mastech.com Mastech | 1000 Commerce Drive Pittsburgh, PA 15275 | Ph:1.888.330.5497 x 9509

Fax: 412-291-3037


Mastech respects your privacy. We will not share your resume or contact details with any of our clients without your consent.

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

Date: 04/18/07 (SQL Server)    Keywords: sql

I have a multiple-table query that will involve either a left or right join, but am not sure how to approach this.

table PERSON is primary table, with PK ID
table SKILL is primary table, with PK SID
table PERSON_SKILL is foreign m-to-m table, with FK PID = PERSON.PID and FK SID = SKILL.ID
table PERSON_JOBS is foreign table, with FK PID = PERSON.ID, 1 to 1

I would need to query all these at once. How accurate is this?

SELECT p.* pj.job, ps.skill
FROM PERSON p
INNER JOIN PERSON_SKILL ps on ps.pid = p.id
INNER JOIN SKILL s ON s.id = ps.sid
INNER JOIN PERSON_JOBS pj ON j.pid = p.id

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

Date: 04/19/07 (SQL Server)    Keywords: sql

What is the maximum number of nested sub queries that can be used in SQL?



Thanks in advance.

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

Date: 04/20/07 (SQL Server)    Keywords: sql

My thirst for SQL knowledge continues.

Four tables: ASSIGNMENT, PROFESSION, SPECIALIZATIONS, ASSIGNMENT_TO_SPECIALIZATION

I want to retrieve all assignments and their associated profession and specializations. While each assignment has only 1 profession, it can have multiple specializations. The m-to-m table, ASSIGNMENT_TO_SPECIALIZATION, handles this possibility.

How can I query this so that I get unique assignments returned? Since there is a possibility for multiple specializations wouldn't that return the same assignment multiple times? Would a GROUP BY do it in this case?

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

Date: 04/25/07 (Apache)    Keywords: php, mysql, sql, apache

I'm running Apache 2.2 from wamp (so I have PHP5 and MySQL 5, though I don't think it has anything to do with them) on Windows XP. Anyway.

I can access everything fine using "localhost", and a friend told me that I could access my server by just using my computer's name. So I named my computer "nemo-serv" (all my electrical devices are named after characters from Finding Nemo, my laptop is Nemo,) and then could use nemo-serv fine, just like localhost.

Then I changed something, and I just get a "You don't have permission to access this directory" when using nemo-serv, though localhost is still fine. I really have no idea what I changed that could have done this, but I was hoping you guys would be able to point me in the right direction.

Thanks ^^

Source: http://community.livejournal.com/apache/36535.html

Date: 04/26/07 (Open Source)    Keywords: mysql, sql, microsoft

Is mySQL now a choice enterprises can place alongside Oracle, IBM DB2 and Microsoft SQL Server? Or does it still have a long way to go?

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

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

Can anyone recommend a good SQL Course (classroom w/ instructor) for a Production (a.k.a. Physical ) DBA to take? I'm mainly interested in migration from 2000, clustering, and maintaining a SQL 2005 environment. I'm already very knowledgeable in SQL 2000, so this would just be a class to "upgrade" my skillset. Anyone out there have any luck with some classes like this ?

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

Date: 05/05/07 (PHP Community)    Keywords: php, database, sql, security

When creating a PHP form that writes to a SQL database, what basic security steps should be implemented (coded)?

I have my own ideas, but I would like to hear what you guys have to say. Maybe we could create a list to include in the user info and memories.

Code samples are encouraged. :D

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

Date: 05/10/07 (MySQL Communtiy)    Keywords: php, mysql, software, database, sql, postgresql, web, linux

I am currently working on 2 great jobs for Linux-loving database folk.

1-MySQL and PHP software engineer in PA near Philly (NE). This is for a young software co founded by a guru who had already built another company. He wants hot programmers who will grow with the company. He currently is looking for a Sr person as well as 1-2 junior folk.

1- Linux DBA in Utah - a company with several websites and millions of pageviews and transactions/day. Needs both senior and junior database tuners to keep their PostgreSQL DBS running smoothly. Every millisecond counts. He will take people w/ MySQL and Linux admin and perl  background for the junior position. Full benefits, great work and flexible working conditions, and powder days!

My email is on my info page if you want to pass this on. Thanks!

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

Date: 05/11/07 (Code WTF)    Keywords: mysql, sql

тут вот родные белоруские программеры такое пишут:

SELECT id AS SubSectionLink, content as brief
		FROM network
			WHERE ((title LIKE '%lamers%')
			OR (content LIKE '%lamers%')

			OR (title LIKE '%LAMERS%') 
			OR (content LIKE '%LAMERS%')

			OR (title LIKE '%LaMeRs%') 
			OR (content LIKE '%LaMeRs%')
	      )

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

Date: 05/11/07 (Code WTF)    Keywords: sql

public static void reloadCache() {
    public static final String tableName = "unit_template";

     ...
     ResultSet res = sql.getResultSet("SELECT id FROM " + UnitTemplate.tableName);// мы в этом классе зачем указывали не понятно.
     while (res.next()) {
         all.put(res.getLong(1), loadFromSQL(res.getLong(1)));
     }
     ...    
}
 private static UnitTemplate loadFromSQL(long id) throws SQLException {
  UnitTemplate tpl = new UnitTemplate();

  SqlDb sql = SqlDb.connection.get();
  tpl.id = id;

  ResultSet res = sql.getResultSet("SELECT #name#, view, usage, is_basic, \"limit\" FROM " +
    tableName + " WHERE id=?", id);// это тотже UnitTemplate.tableName только обратились теперь без официоза
.....
}

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

Date: 05/12/07 (Java Web)    Keywords: php, mysql, database, sql, postgresql, linux

Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux. It used MySQL as backend. Here are the steps: 1. Export Mantis MySQL database from Windows, upload it on Linux and then import it to MySQL database on [...]

Source: http://blog.taragana.com/index.php/archive/how-to-migrate-mantis-defect-tracking-system-from-windows-to-linux-fedora-core-6/