Date: 03/17/05 (Security)    Keywords: database

School alerts more than 100,000 former students of an attack on a database that holds records used for fund raising.

Source: http://news.zdnet.com/Boston+College+reveals+alumni+data+breach/2100-1009_22-5623084.html?part=rss&tag=feed&subj=zdnn

Date: 03/17/05 (MySQL Communtiy)    Keywords: php, mysql, database, sql

Alright, so I'm a bit new to MySQL. I haven't had to work with databases much, and when I have done them, it was with Access (Ick!). Anyway, i've got a php page that I'm trying to connect to a MySQL database. This isn't how the data's going to be displayed, obviously, but I'm unsure where to go from here.


// Connecting, selecting database
$connect = mysql_connect('localhost', 'mannsye', 'nickmann1169');
if (!$connect)
die('Could not connect: ' . mysql_error());
else
echo "Connected successfully

";

$category = 1;

mysql_select_db("mannsye_conigeninformation") or die("Could not select database");

// Performing SQL query
$query = "SELECT * FROM residental_links, residental_types ";
$query += "WHERE ((residental_links.section)=(residental_types.type)) ";

$query += "ORDER BY residental_types.index, residental_links.name;";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($connect);
?>


I've got my query seperated from the code, but as I know very little about MySQL, I don't know if the syntax is correct or not.


SELECT * FROM residental_links, residental_types
WHERE ((residental_links.section)=(residental_types.type))
ORDER BY residental_types.index, residental_links.name;


Whenever I try and access the database and the tables, I can connect, but I can't display any data.



Connected successfully

Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1



Please, any help would be appreciated.

Many thanks!
--Lisa

Source: http://www.livejournal.com/community/mysql/50953.html

Date: 02/17/05 (Java Web)    Keywords: database, web

It is a very strong capability to be able to post dynamic content in your blog. You can use this to integrate contents from other websites, fetch data from your database etc. It enables whole plethora of functionalities to your blog posting to make it more lively. A plugin developed by Mark allows you to [...]

Source: http://blog.taragana.com/index.php/archive/how-to-post-dynamic-content-using-php-on-wordpress-webblogs-know-your-ip-address/

Date: 03/24/05 (Asp Dot Net)    Keywords: database, asp

I'm about to start a new ASP.NET project and one thing I'd like to find is a way to do is automate the export of static constants to a text file. The text will ultimately be used when building the database tables and stored procs. The goal here is to make sure constants get defined in only one place. For example letus say I have a set of classes like

public class FilterTypes {
  public enum Categories { cero, uno, dos, tres, quatro };
}

public class UserModes {
  public static readonly int mask1 = 1;
  public static readonly int mask2 = 2;
  public static readonly int mask3 = 4;
  public static readonly int mask4 = 8;
}

public sealed MyKingdomForAClassName {
  private static int _hidden = 13;

  static public int Hidden {
   get { return _hidden; }
  }
}

Test1.Data.FilterTypes.mask1 = 1 
Test1.Data.UserModes.mask2 = 2 
Test1.Data.UserModes.mask3 = 4 
Test1.Data.UserModes.mask4 = 8 
Test1.Data.MyKingdomForAClassName.Hidden = 13 
Test1.Data.FilterTypes.Categories.cero = 0 
Test1.Data.FilterTypes.Categories.uno = 1 
Test1.Data.FilterTypes.Categories.dos = 2 
Test1.Data.FilterTypes.Categories.tres = 3 
Test1.Data.FilterTypes.Categories.quatro = 4

Source: http://www.livejournal.com/community/aspdotnet/29556.html

Date: 03/24/05 (SQL Server)    Keywords: database, sql

Using ONLY T-SQL (a stored proc really), is there a way to gain access to a MS Access DB and pull data out of it into a SQL Server database?

I know one theoretical solution is to create a linked server against the MS Access DB, pull my data out that way, kill the linked server property, and go along my merry way, but there's gotta be a better way to do this!

And no, DTS really isn't an option either I'm afraid.

x-posted to databases

Source: http://www.livejournal.com/community/sqlserver/22438.html

Date: 03/25/05 (SQL Server)    Keywords: mysql, database, sql

I'm used to working with MySQL and I have to make this forray into SQL server. So, I need a quick bit of help.

I need to be able to browse through a database one record at a time. For that, I guess I need a way to give my query a start row and. I can end it just fine. What should I use? And how do I figure out what row I am currently on. With MySQL theres the LIMIT clause and I know thats not available in SQL server.

Thanks in advance.

Source: http://www.livejournal.com/community/sqlserver/22596.html

Date: 03/25/05 (MySQL Communtiy)    Keywords: php, mysql, browser, database, sql

I'm trying to create a PHP browser-based chat room application. It will include Savant, JPSpan, and a custom MySQL wrapper class. The server is running PHP 4.3.10 and MySQL 4.0.18-standard. Now that the background information is out of the way, to the real issue at hand...

I obviously want the application to be able to support as many users as the server will allow. That said, the application must be as efficient as possible in terms of the database design and implementation. The database will be relational in design. There will be tables for rooms, users, and posts made by users to rooms. The application will also include a feature to allow users to search posts. My plan at the moment is to use a HEAP table as a buffer for current posts, given that they provide a speed advantage because they exist in memory and use hash indexing. On some sort of timed interval, posts would be moved from the HEAP table to a separate permanent table for archived posts.

However, this approach would require that posts be archived regularly over the course of the day. The more frequently posts are archived, the smaller the number of posts that could potentially be lost due to a server crash, power less, etc. The HEAP table really only needs to hold posts long enough for them to propagate to users. I'm not certain what frequency would be best.

Also, because HEAP tables don't support the TEXT field type, the HEAP table would initially need a VARCHAR(255) field for the post body. The application would have to check the length of posts when users submit them and then ALTER the table to add additional VARCHAR(255) fields, split the post body up to store it across those fields, and then concatenate the value of those fields to display the post. Since displaying each post would require getting all fields in the table anyway, it should be fairly easy for the application to figure out with each display how many fields it needs to concatenate to display the post body.

Any input? Any alternative approaches? I probably neglected to mention some tenant of my application requirements, so if you have questions, please ask, and I'll most certainly answer them. I think I've covered most of the bases, though. HEAP tables are a new concept to me, so I'm mostly lingering in the world of hypotheses before I actually try to make this work.

Source: http://www.livejournal.com/community/mysql/52183.html

Date: 03/26/05 (Algorithms)    Keywords: database

Hi all, I attempt to show an example of heuristic based algorithm such as Genetic Algorithm runs in polynomial time, my analysis is below. Please give comments as I feel that the way I write it is not very clear and possibly can contain technical errors.  Thank you in advance. 

  


    Approximation algorithms such as Genetic Algorithm takes polynomial time.  It is O(G) where G is the number of generation.
       
    The most important and time consuming part in each generation is probably the fitness evaluation since all chromosomes are tested against the database (tvn note: in this GA example the chrome fitness is tested against a DB).  The time for each individual chromosome to process an entire database of size D, where D is the number of column and R is the largest row, is at worst (max(D,R))^2 or O(max(D,R)), still polynomial time.  Of course, each chromosome will be tested against the database so it would be the population size * the time to process the entire database for each in
dividual.
        There are other operations in each generation such as the cross-over and mutation, but the run time for these two operations per chromosome is either constant or at most O(n) where n is the number of genes in a chromosome.
       

Source: http://www.livejournal.com/community/algorithms/50976.html

Date: 03/29/05 (MySQL Communtiy)    Keywords: database, sql

Okay, I don't know how to form this SQL statement... I'm so not a database person, I always knew it.

I've got three tables: users, questions, and answers. Each user can answer a question only once, but each question has lots of different answers, each by different users.

What I want to do is let a user search for questions that he has not answered. I know how to do the search for questions he has answered, it's just one neat SQL statement that links all the tables together (user id matches userid in answer table, which also has a question id which matches the question id in the question table) but I don't know how to go the other way. I need to list all the questions for which no answer (with this user's user ID) exists.

Source: http://www.livejournal.com/community/mysql/52672.html

Date: 03/30/05 (MySQL Communtiy)    Keywords: php, mysql, database, sql

hi all ~ i have a vB board out there in cyberland and it's got a "random quote" hack (the UQH by kurafire) ~

anyway, after three years of smooth sailing, it recently developed some kvetchy sickness and i can't figure out the problem.

this is the error message:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT *
FROM quotes
WHERE 1=1 AND mod!='N'
ORDER BY letter,name ASC
LIMIT 0,30
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!='N'
ORDER BY letter,name ASC


mysql error number: 1064

Date: Tuesday 29th of March 2005 07:20:54 PM
Script: http://www.lookingland.com/board/board/quotelist.php?s=

Source: http://www.livejournal.com/community/mysql/53159.html

Date: 03/31/05 (Open Source)    Keywords: php, mysql, database, sql, web, apache

Open source bundling is the new trend. Martin Lamonica's story yesterday about SourceLabs describes one such bundles. Most are aimed at businesses. Many, like the SourceLabs bundle, are AMP Stacks, with the Apache Web Server, MySQL database, and PHP scripting tools. The idea is for a company to give ...

Source: http://blogs.zdnet.com/open-source/index.php?p=215&part=rss&tag=feed&subj=zdblog

Date: 04/06/05 (Computer Geeks)    Keywords: programming, database, java

Hello, I'm new here.

I have a quick question.

I'm doing research and wanted to know of the two programming languages (C++ and Java), and two databases (Visual Basics and Oracle) which do you think is the most "in demand" in the IT industry.

And if I had to choose one of the four to concentrate on which would be around in the next decade? And with what applications?

Basically what would you get certified in to help you land a good IT job.

Any information you could provide me would be fantastic. Thanks in advance.

Source: http://www.livejournal.com/community/computergeeks/653597.html

Date: 04/07/05 (Computer Geeks)    Keywords: database

Hi guys, need a little help with VB.

I'm using Visual Basic 6 and currently working on a personal information system / database.

I was wondering if anyone knew how to add an image to a record? I created a database on Access and I use Jet 4.0 + ADO.

Help would be greatly appreciated.

g33ks of t3h w0rld, un173!

Source: http://www.livejournal.com/community/computergeeks/655937.html

Date: 04/08/05 (Asp Dot Net)    Keywords: database, asp, sql, microsoft

Hello peoples, I am having a bitta trouble with my code and can't seem to find an answer. Im currently running XP Pro with SP2, IIS 5.1, and try to do a simple DSNless SQL Update from a form connecting to a Access 2000 database. The ASP code is as follows.

<% 
	Dim strDataPath, objConnection
	strDataPath = Server.MapPath("rest.mdb")
	Set objConnection = Server.CreateObject("ADODB.Connection")
	strConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;"_
	+ " Data Source= " & strDataPath & ";"
	objConnection.ConnectionTimeout = 15
	objConnection.CommandTimeout = 10
	objConnection.Mode = 3
	
	if objConnection.State = 0 then
	objConnection.Open strConnectString
	end if
			
	Dim strSQL, objRS
			
	strSQL = "SELECT * FROM food"
	Set objRS = Server.CreateObject("ADODB.RecordSet")
	objRS.Open strSQL, objConnection,3,3
	objRS.AddNew
	objRS("tableno") = Request.Form("tableno")
	tableno = Request.Form("tableno")
	objRS("people") = Request.Form("people")
	people = Request.Form("people")				
	objRS.Update

	Set objRS = Nothing
	objConnection.Close
	Set objConnection = Nothing
			
	Response.Redirect("placeorder2.asp?tableno=") + tableno + "&people=" + people
		
%>

Source: http://www.livejournal.com/community/aspdotnet/31731.html

Date: 04/09/05 (WebDesign)    Keywords: database

anyone here that's done a site that connects to an inventory management database?

I have a potential client that wants a secure place where salesmen can log in and check stock, check prices. The stock can be updated when new stuff comes in, deleted on the database when the company is out, etc. This company is small with about 10 salesmen maybe. They will want to be able to log in remotely.

if anyone has any experience or recommendations, I'd be glad to hear it. Thanks!

Source: http://www.livejournal.com/community/webdesign/850238.html

Date: 04/12/05 (PHP Community)    Keywords: database

Right now, I am storing my database password as plain text in a file on a shared server. I recently figured out that anyone with access to the server can read this file, and thus retrieve my database password. Other than making sure that only authorized people(i.e., me) can access that file, what can I do to make this set-up more secure? Is there a good and relatively painless way to encrypt and decrypt it?

[EDIT]I am looking for a secure way to store the database password, not passwords in the database. Thanks!

Source: http://www.livejournal.com/community/php/283722.html

Date: 04/12/05 (Java Web)    Keywords: database, security

An investigation by the firm's Anglo-Dutch parent Reed Elsevier determined that its databases had been fraudulently breached 59 times using stolen passwords, leading to the possible theft of personal information such as addresses and Social Security numbers. This is the second biggest breach after Bank of America incident. And then there were breach at ChoicePoint, DMV [...]

Source: http://blog.taragana.com/index.php/archive/data-broker-lexisnexis-said-personal-data-of-310-000-us-citizes-feared-stolen/

Date: 04/18/05 (Web Hosts)    Keywords: php, mysql, database, sql, hosting

www.subnixus.com now has three easy ways to earn free hosting.

1. Being an active member of the forum. It's that simple, by posting on our forum you can earn free hosting. Read about it here: http://www.subnixus.com/forums/viewtopic.php?id=798

2. By signing up for one of our sponsers, such as DISH Network, you can earn one year of free hosting. Read about it here: http://www.subnixus.com/forums/viewtopic.php?id=799

3. By making a donation of $10 or more you will earn one year of free hosting. Read about that promotion here: http://www.subnixus.com/forums/viewtopic.php?id=802

Your hosting package will be reviewed and given on a case by case basis. The minimum package includes (but you could qualify for more):

www.yourname.com
125MB of Space
1G of bandwidth
1 MySQL Database
POP Email
Control Panel
FTP
(basically anything you need to get your site up and running)


This new program starts this week. All accounts that are earned between April 18 - 22 will be setup on Sat. the 23rd. Please visit www.subnixus.com for all of the details.

Source: http://www.livejournal.com/community/webhosts/26063.html

Date: 04/19/05 (PHP Community)    Keywords: php, mysql, database, sql

Greetings... Semi-novie with PHP here. Toyed with it years ago, and just started working on a project that is based in PHP. I'm getting some information from a MySQL database, and I've used str_replace to modify most of what I need, but I'm pulling a domain name from a sentence, so what string_replace leaves me with is 'domain.name.com.'

I'm trying to get rid of the trailing period, and I've tried using:

$text="domain.name.com.";

$newtext=rtrim($text, '.');

The . does not go away. I've tried with double quotes as well.

Any help would be most graciously appreciated!




EDIT: Got it... thanks for all your help!

Source: http://www.livejournal.com/community/php/288213.html

Date: 04/20/05 (PHP Community)    Keywords: php, mysql, browser, html, database, sql

Hi all,
I have a program that gets its images from a mysql database. I pass a string to the program that gets the picture inside an HTML image tag like this:

<*img src=\"show_image.php/thumbnails/$boxData[thum_id]/img.jpg\">

This is what the string looks like when it has been passed:

show_image.php/thumbnails/7678/img.jpg

This is the program show_image.php

$pic_id = get_pic_id($_SERVER['REQUEST_URI']);

$table_name = get_table_name($_SERVER['REQUEST_URI']);

$file_data = get_file_data($pic_id, $table_name);

header("Content-type: " . $file_data['type']);

echo $file_data['binary_data'];

Source: http://www.livejournal.com/community/php/288307.html