Date: 01/20/08 (Java Web)    Keywords: database, spam

SplogSpot is service that keeps track of spam blogs or Splogs. The splogspot spam database can be queried by using the SplogSpot API. A nice idea. Is the service appears to be dead since March 2007? The recently updated splog dump from SplogSpot has the latest entry from 20th March 2007: Casino Club Las Vegas - 07:45 [...]

Source: http://blog.taragana.com/index.php/archive/is-splogsplot-splog-detection-site-dead-i-hope-not/

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 (C Sharp)    Keywords: database

Maybe I'm just blind, but...

I have a DataGridView on a form with MultiSelect = false and SelectionMode = DataGridViewSelectionMode.FullRowSelect displaying data from a table in a database. My idea is, that a row is automatically selected, if a user enters the key value in a dialog. Not filtering, just selecting. The Rows property provides a collection, and I can set the Selected property of the current DataGridViewRow element to true. But the only way I see to find the correct row is to iterate over all items, until I find the requested row.

Does someone have an idea for a simpler way?

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

Date: 01/25/08 (Web Development)    Keywords: html, technology, database, security, web

I realize that this is a webdev group targeted at web application developers, but since we all know a thing or two about security, I was wondering what all of you think about RFID chips in passports?

Basically it's a radio-frequency chip that will be issued in new passports in the U.S. The chip will contain personal information, an image of what a person looks like, and can be read by an RFID reader when placed up close - it is then transferred over a wireless network to a database. The technology is "similar to what is used at Wal-mart to track goods" (Source: http://www.washingtonpost.com/wp-dyn/content/article/2007/12/31/AR2007123101922.html)


Do you think this idea is safe in terms of identity theft?
Should this idea continue?

I am just curious as to what all of you think, not taking any polls or anything, but just trying to get a conversation going :)


In my opinion, I think as long as there will be new secure measures of holding on to information, hackers will dedicate more time on trying to exploit what they find.

That's what they're paid for!


You can read more about it here if you don't believe me: http://travel.state.gov/passport/ppt_card/ppt_card_3926.html

Source: http://community.livejournal.com/webdev/461070.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/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/28/08 (Asp Dot Net)    Keywords: database

How do I run a piece of code each time a page is displayed ?

I thought I could just put it in the page_load and not use a page.ispostback and that would mean the code is called each time the page is displayed.

However, I have a linkbutton that modifies a customer in the database. When the user clicks the linkbutton, the customer is modified and the page is redisplayed BUT I dont see the updated information for the customer.

(I have another page that displays a grid that shows the latest data whenever it is called).

Should I create a function to load the customer that the page_load and linkbutton both call ?

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

Date: 02/06/08 (Java Web)    Keywords: database, virus, spam

The Spamhaus Exploits Block List (XBL) is a realtime database of IP addresses of hijacked PCs infected by illegal 3rd party exploits, including open proxies (HTTP, socks, AnalogX, wingate, etc), worms/viruses with built-in spam engines, and other types of trojan-horse exploits. I was recently testing this list againt spam email. Here are few observations from [...]

Source: http://blog.taragana.com/index.php/archive/overview-of-exploits-block-list-xbl-spamhausorg-in-comment-spam-protection/

Date: 02/06/08 (PHP Community)    Keywords: php, database

Has anyone had any luck running exec() in the background?

I'm using php to initiate a perl script using exec with the following...

exec('cd /usr/local/www/data/site/parse; perl parse_dbf.pl "'.$var1.'" "'.$var2.'" "'.$var3.'"');

now that parse dbf.pl is doing a lot of various database updates and takes several minutes to run, and since the php page that's running it is waiting for it to finish, it dies before completion.
I also don't want to do something like set_time_limit(), because that's just messy and hangs the page.

Looking at the php docs for exec, I see "If you start a program using this function and want to leave it running in the background, you have to make sure that the output of that program is redirected to a file or some other output stream or else PHP will hang until the execution of the program ends."

This sounds like exactly what I want it to do, but I'm not having any luck getting it to run.

I've been googling for ideas, but nothing has worked yet. My most recent attempt (and there have been many variations) looks like:

exec('cd /usr/local/www/data/site/parse; perl parse_dbf.pl "'.$var1.'" "'.$var2.'" "'.$var3.'" > holdfile.txt 2>&1');

It quickly executes the php page, but doesn't actually run the perl.

I'm stuck. Has anyone had luck with this? Any ideas?

Thanks

_________

edit: This seems to work (although for some reason without changing the set_time_limit(), it only changes 70 of the 1657 records it's suppose to edit. Anyway, I'll figure that out. Thanks.

exec('cd /usr/local/www/data/site/parse; perl parse_dbf.pl "'.$var1.'" "'.$var2.'" "'.$var3.'" > /dev/null 2> /dev/null & echo $!');

Source: http://community.livejournal.com/php/611669.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/08/08 (Asp Dot Net)    Keywords: database, yahoo

I need a grid where I can select a checkbox or select everything else in the row.

So I could select the checkbox and hit the delete button and the row is deleted in the database. Or I could click on one of the other columns in the row and the item is opened in another page. (Kinda the way Yahoo Mail works)

Does anyone know if that is possible ? (And have you seen an example if it is ?)

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

Date: 02/17/08 (PHP Community)    Keywords: database

I have two arrays. one is data from a database, one is data from a form. If the data in the two arrays are the same, meaning no changes were made to the form, then I want to know so that a database update is not needed. If the data are different, then I want to not only update the database, but mark the time and date of the new update.

Here's what I've come up with:
$difference=array_diff($formdata, $dbdata);
$num_diff=count($difference);
if ($num_diff!=0){ update Database & set new date_updated }

Might there be a more elegant way to do this?

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

Date: 02/19/08 (Data Management)    Keywords: database

Michael Stonebraker has a history of database breakthroughs. He was a founder of Ingres, Illustra, Cohera and StreamBase Systems. He also served as CTO of Informix and helped develop Postgres. His most recent creation is Vertica, which just launched version 2.o of its database. The claims...

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

Date: 02/20/08 (Data Management)    Keywords: database

Guest Post: Curt Monash reports from the front lines of a database revolution. Mike Stonebraker created much of the database management industry. Now he wants to blow it up. Via a project called H-Store [pdf file], he proposes to manage high-end OLTP databases entirely in...

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

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 (PHP Community)    Keywords: database

I'm trying to create an array that holds the name of the table as its key, and the field as its value. The array is populated via database output. However, the same table may be listed multiple times, since more than 1 field for each table can be present.

However, I am having trouble appending a field to the previously created key/value pair.

$search_array = array();
$current_table = '';
$result = $d->dbQuery('SELECT the_table, the_fields FROM sitesearch ORDER BY id');
while($row = $d->dbFetchObject($result)):
	if ($current_array != $row->the_table):
		$search_array[$row->the_table] = $row->the_fields;
		$current_table = $row->the_table;
	else:
		$search_array[${$row->the_table}] .= ','.$row->the_fields;
	endif;
endwhile;

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

Date: 02/27/08 (Security)    Keywords: database, security

Finjan said it has uncovered a database with more than 8,700 FTP account credentials--user name, password and server address--that allow hackers to compromise security and deliver malware as a service. In a report released Wednesday, Finjan said the list of stolen accounts includes many Fortune 500 type...

Source: http://blogs.zdnet.com/security/?p=908

Date: 03/06/08 (Data Management)    Keywords: database, sql, microsoft

Microsoft has begun signing up testers for SQL Server Data Services (SSDS), a forthcoming service that will allow customers and developers to host their data in a Microsoft-hosted database. Microsoft officials were reticent to compare SQL Server Data Services to offerings from any competitors. But Gartner Vice...

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

Date: 03/11/08 (Data Management)    Keywords: technology, database, web

David Beitel, CTO of Zillow.com describes how the company is using technology to process millions of new property records into an electronic database and then post on the company's web site in a user-friendly format. by Administrator

Source: http://video.zdnet.com/CIOSessions/?p=263