Date: 12/16/05 (Java Web)    Keywords: software, database

Nicu Sebe from the University of Amsterdam in the Netherlands tested emotion-recognition software on Monalisa's smile. Why am I unhappy about it? His algorithm examines key facial features such as the curvature of the lips and crinkles around the eyes, then scores each face with respect to six basic emotions. Sebe drew on a database of [...]

Source: http://blog.taragana.com/index.php/archive/mona-lisa-was-83-per-cent-happy-and-i-am-2748-per-cent-unhappy/

Date: 12/18/05 (MySQL Communtiy)    Keywords: database

I have a database table with 4 keyword fields. I guess they like to store up to 4 keywords against each entry. Unfortunately this makes processing quite difficult, as I'm constantly having to search each field (key1, key2, key3, key4).

Is there an easy way to merge these into a big conglomerate sort of list that would be easier to manipulate?

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

Date: 12/21/05 (Code WTF)    Keywords: database, sql

public static void isDBConnectionValid(Connection dbConnection)
throws Exception
{
if(dbConnection == null)
throw new SQLException("Database connection does not exist");
else
return;
}

Source: http://www.livejournal.com/community/code_wtf/21568.html

Date: 12/23/05 (PHP Community)    Keywords: php, mysql, rss, database, sql

Hiya,

I don't have a shell account and uploads via PHP are disabled on my server and this is why I'm looking for a robust RSS parser which feeds into a MySQL database. Since it's nearly impossible to install anything I'm looking for functions/classes I can use.

I have been able to get LastRSS to work but this does not use MySQL and writes to a directory. I need to leave that directory set to 777 - which is, clearly, no good.

I've lost faith in the RSS parser I wrote. It glitches too often.

Does anyone have any recommendations?

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

Date: 12/23/05 (Asp Dot Net)    Keywords: database, asp, sql, microsoft

I'm working on my first asp.net page and am running into some problems. I'm trying to read data from an MS Access database. I'd appreciate if anyone could point me in the right direction - I pretty much lifted the example code from w3schools. Thanks for any help, I'm feeling a bit lost!

The code below gives an error on line 4, character 5 - expected ";".

[%@ Import Namespace="System.Data.OleDb" %>
[script runat="server">
sub Page_Load
dim dbconn, dbcomm, dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=test.mdb")
dbconn.Open()
sql="SELECT * FROM values"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
value.DataSource=dbread
value.DataBind()
dbread.Close()
dbconn.Close()
end sub
[/script>


Database:
filename: test.mdb, resides in same directory as index.asp file.

table: values
fields: ID, key, value

read [s as <.

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

Date: 12/25/05 (Algorithms)    Keywords: database

In my prev project, I used GP to build evolve hardware, more specifically, a radar. The radar is unknown, only thing known is if X is input then Y is output and I built the radar based on the input database and based on some common-sense about what the radar is like. It works fairly well w/ GP however I always look for more ideas so that I can solve more complicated hardware models. I am wondering if there are other algorithms/methods to achieve the same goal ? I am hoping to find some other alternatives to hybrid their strong features to my GP proj. Thanks

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

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

Hi everyone,
I am writing a program that uses zip code location information. I am having a really hard time finding a database for this information in a format that I need. Almost all of the databases I have found have the records like this:

Sample Records
"Key West","FL","33040","305","12087","Monroe","P",
"Stock Island","FL","33040","305","12087","Monroe","A",
"Raccoon Key","FL","33040","305","12087","Monroe","N",
"Agoura","CA","91376","818","06037","Los Angeles","A","P"

I think what I may be looking for is a list of states with unique IDs. A list of counties tied to those state IDs. A list of zip codes tied to those county IDs.

Am I wrong? The sample records dont seem to follow the rules for database normalization.

Any insite would be much appreciated.

cross posted.

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

Date: 12/27/05 (Web Development)    Keywords: database

Hi everyone,
I am writing a program that uses zip code location information. I am having a really hard time finding a database for this information in a format that I need. Almost all of the databases I have found have the records like this:

Sample Records
"Key West","FL","33040","305","12087","Monroe","P",
"Stock Island","FL","33040","305","12087","Monroe","A",
"Raccoon Key","FL","33040","305","12087","Monroe","N",
"Agoura","CA","91376","818","06037","Los Angeles","A","P"

I think what I may be looking for is a list of states with unique IDs. A list of counties tied to those state IDs. A list of zip codes tied to those county IDs.

Am I wrong? The sample records dont seem to follow the rules for database normalization.

Any insite would be much appreciated.

cross posted.

Source: http://www.livejournal.com/community/webdev/281496.html

Date: 12/27/05 (MySQL Communtiy)    Keywords: database

Hi everyone,
I am writing a program that uses zip code location information. I am having a really hard time finding a database for this information in a format that I need. Almost all of the databases I have found have the records like this:

Sample Records
"Key West","FL","33040","305","12087","Monroe","P",
"Stock Island","FL","33040","305","12087","Monroe","A",
"Raccoon Key","FL","33040","305","12087","Monroe","N",
"Agoura","CA","91376","818","06037","Los Angeles","A","P"

I think what I may be looking for is a list of states with unique IDs. A list of counties tied to those state IDs. A list of zip codes tied to those county IDs.

Am I wrong? The sample records dont seem to follow the rules for database normalization.

Any insite would be much appreciated.

cross posted.

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

Date: 12/28/05 (MySQL Communtiy)    Keywords: mysql, database, sql

I am trying to make it so this result can be ordered by the last name of the client. However, the name is in another table thus the JOIN LEFT. That part seems to be working OK (I think), but where I am running into a problem is that the results are showing duplicates (example if invoice 10, there are 3 result rows for invoice 10, but only 1 row in the actual MySQL table "invoice_main").

(Yes, there are some name/case mismatches, but I didnt create the database.)

Thanks!

SELECT DISTINCT
invoice_main.invoice_number,
invoice_main.invoice_date,
invoice_main.due_date,
invoice_main.clientid,
invoice_main.subtotal,
invoice_main.paid_amounts,
invoice_main.payment_status,
clients.ClientLast
FROM $TableName
LEFT JOIN clients ON invoice_main.clientid=clients.ClientID
WHERE invoice_main.office_id='$office_id'
ORDER BY $SortParam
LIMIT $limit,$Limit_increment

Adding GROUP BY invoice_main.invoice_number gave me an SQL error


[UPDATE] Figured it out
LEFT JOIN clients ON invoice_main.office_id=clients.office_id AND invoice_main.clientid=clients.ClientID

Gotta thank jedifreeman and his help with JOIN a couple weeks ago. I was re-reading our AIM conversation and thought of this.

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

Date: 01/03/06 (PHP Community)    Keywords: mysql, database, sql

While trying to connect to the mysql database, I get this error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
So I look up the solutions for this error. I discover that I need to edit a my.cnf file and change the socket setting. I wish it was that easy. I check what socket is set too.

[client]
#password = my_password
port = 3306
socket = /opt/local/var/run/mysqld/mysqld.sock

Not the socket the server is trying to connect to.

The file is located in /opt/local/etc/mysql4 and I also copied it to /opt/local/etc incase.
The password and username is correct, I can manually connect to the database.
Using a Mac OSX.4 server.
DB Server version is 4.1.15
Connection: Localhost via UNIX socket

I am out of ideas, can anyone help me?

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

Date: 01/03/06 (MySQL Communtiy)    Keywords: mysql, database, sql

While trying to connect to the mysql database, I get this error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
So I look up the solutions for this error. I discover that I need to edit a my.cnf file and change the socket setting. I wish it was that easy. I check what socket is set too.

[client]
#password = my_password
port = 3306
socket = /opt/local/var/run/mysqld/mysqld.sock

Not the socket the server is trying to connect to.

The file is located in /opt/local/etc/mysql4 and I also copied it to /opt/local/etc incase.
The password and username is correct, I can manually connect to the database.
Using a Mac OSX.4 server.
DB Server version is 4.1.15
Connection: Localhost via UNIX socket

I am out of ideas, can anyone help me?

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

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

Just joined. Looks like a nice comm.

Quick question:

I have a production database that is about 1 GB in size. I have been tasked to script that baby out into sql files. The tables, procedures, etc. should be little problem (thanks to the database scripting wizard), but the data is eluding me. How can I (relatively automated) script table data into a series of INSERT statements?

Is there any way to avoid manually typing:
"INSERT INTO tbl_WHATEVER (ID, FIELD1, FIELD2, ...) VALUES (1, 1, 1, ...)"?

Thanks in advance!

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

Date: 01/05/06 (WebDesign)    Keywords: cms, software, html, database, web, hosting

Hey all. I'm in the process of creating a client/project survey to give to clients. Right now I'm focusing on web and html/text email blasts. Does anyone have any good references to this stuff already. I had a few, but can't find them in my infinite number of bookmarks {that's next on the list}. If you can, please review the questions I wrote below and tell me what's crap and what's gold or if I missed anything. Also, do you think this is too long to give a client? I've seen them usually be 10 questions or so long. Please look at the sections as two different ones that I may or may not give to clients. Thanks so much.

x-posted in design, webdesign, designrants, graphicdesign

WEB SITES

Figuring Out What You Need:

1. What is the Main Purpose or Goal of the site?

2. Is this a new web project/presence or a redesign?
a.) If it’s a redesign, what are the good and bad parts of your current site?
b.) Will the content be the same / How will it differ? Is it ready or does it need editing?

3. Who is your main audience and user base?

4. Do you want Flash for your site? If yes, please explain the desired implementation.

5. How many and what kind of pages does the site need? Please be as specific as possible.

6. Are there any special functions of the site? Ex: User info submission forms; e-commerce/take payments; etc.

7. Name some competitors’ sites or sites you like and why.

8. What are the short term and long term project timelines?


Management/Maintenance:

9. How often does the site need updating?

10. Who will be doing the updates? Will the person require training?

11. What existing technologies do you have to support the site? Ex: Is there already web hosting and domain name registration in place? Does the site have a database installed yet? Proper software & hardware for updating the site?

12. Will a Content Management System {CMS} benefit your organization?


The Big Picture:

13. What is a realistic length of time for your company to complete this project?

14. What is your company’s budget for this particular project?



HTML/TEXT EMAIL BLASTS


1. How many emails per month? How many email addresses in each blast?

2. Who is your user base? Will there be different newsletters for different audiences?

3. Who creates the content?

4. Is there already a system in place for this?

5. What is the budget and timeline for each email blast?

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

Date: 01/05/06 (PHP Community)    Keywords: mysql, database, sql, web

Okay, stumped.

if ($_GET['id'] == "") { $link = mysql_connect("localhost","iop","iopweb") or die ("Could not connect"); mysql_select_db("iop") or die("Could not select database"); $select_string = "SELECT `id`,`name` FROM internships WHERE `approved` != \"yes\" ORDER BY `post_date` DESC"; $result = mysql_query($select_string); while ($current = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<a href=\"internships_edit.php?id=" . $current['id'] . "\">" . $current['name'] . "</a><br />"; } //end of first clause of get_id if statement } else { echo $_GET['id'] . "<br /><br />"; $query_id = $_GET['id']; echo $query_id; $select_string_specific = "SELECT * FROM internships WHERE `approved` != \"yes\" AND `id` = " . $query_id . " ORDER BY `id` DESC"; echo $select_string . "<br />"; $result_spec = mysql_query($select_string_specific); // Print out the information while ($current = mysql_fetch_array($result_spec, MYSQL_ASSOC)) { echo "<td><b>ID</b>: <input type=\"text\" name=\"this_id\" value=\"" . $current['id'] . "\"/><br /><b>Name:</b> <input type=\"text\" name=\"this_name\" value=\"" . $current['name'] . "\"/><br /><b>Post Date:</b> " . $current['post_date'] . "<br /><b>Title:</b> " . $current['title'] . "<br /><b>Deadline:</b> " . $current['deadline'] . "<br /><b>Description:</b> " . $current['description'] . "<br /><b>Application Requirements:</b> " . $current['app_requirements'] . "<br /><b>City:</b> " . $current['city'] . "<br /><b>Contact Name:</b> " . $current['contact_name'] . "<br /><b>Contact Address:</b> " . $current['contact_address'] . "<br /><b>Contact Email:</b> " . $current['contact_email'] . "<br /><b>Contact Phone:</b> " . $current['phone'] . "<br /><b>Contact Fax:</b> " . $current['fax'] . "<br /><b>URL:</b> " . $current['url'] . "<br /><b>Link to Application:</b> " . $current['app_link'] . "<br /><b>Job yes/no:</b> " . $current['job'] . "<br /> <b>State:</b> " . $current['state'] . "<br /><form action=\"internships_approve.php\" method=\"post\"><input type=\"hidden\" name=\"approved\" value=\"yes\"> <input type=\"hidden\" name=\"submitted\" value=\"yes\"><input type=\"hidden\" value=" . $current['id'] . " name=\"id\"><input type=\"submit\" value=\"Click to Approve\"></form></td>"; } }

Everything works fine until the else portion is reached. At that point, the query that is echoed works just fine if I paste it into my MySQL db, but it acts like an asshole here, apparently, because I get the old "not a valid resource" error message that we all live for. It should only be selecting one record, the one with the corresponding ID number (there are no duplicate IDs) and then displaying the information associated with that ID number after obtaining the ID number from the url as a $_GET. (I know there's some unnecessary variable re-setting in here - I was trying anything I could.)

I can't figure this out. It's something so simple, I bet, and that's why I'm not seeing it because I've been swearing at it for over 30 minutes now.

Any help is appreciated.

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

Date: 01/09/06 (C Sharp)    Keywords: database, sql

Okay, I'm stumped.

I'm using Intersystems Cache, for which there seem to be no peer help fora anywhere on the net, though theoretically it shouldn't matter, should it? ODBC is ODBC, I hope. In any case, here's a quick code snippet:

       private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string InsertString = "INSERT INTO Erasmus.Publisher(Name, PublisherURL) VALUES(@Name,@URL)";
                ErasmusTransaction = ErasmusConnection.BeginTransaction(IsolationLevel.ReadCommitted);
                ErasmusInsertCommand = new OdbcCommand(InsertString, ErasmusConnection, ErasmusTransaction);

                OdbcParameter prmName = new OdbcParameter();
                prmName.Direction = ParameterDirection.Input;
                prmName.OdbcType = OdbcType.VarChar;
                prmName.Value = txtName.Text;
                prmName.ParameterName = "@Name";
                ErasmusInsertCommand.Parameters.Add(prmName);

       private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string InsertString = "INSERT INTO Erasmus.Publisher(Name, PublisherURL) VALUES(@Name,@URL)";
                ErasmusTransaction = ErasmusConnection.BeginTransaction(IsolationLevel.ReadCommitted);
                ErasmusInsertCommand = new OdbcCommand(InsertString, ErasmusConnection, ErasmusTransaction);

                ErasmusInsertCommand.Parameters.Add("@Name", OdbcType.VarChar, 100).Value = txtName.Text;

Source: http://www.livejournal.com/community/csharp/46500.html

Date: 01/09/06 (PHP Community)    Keywords: cms, php, html, database, security, web

Hey all,

I know there's been a couple posts about this recently, so if I'm asking redundant questions, sorry.

A friend of mine has come up with a pretty novel idea for a MySpace-ish site, but for a specific niche market (kind of like those CatSpace and DogSpaces that exist) - users will have profiles, photos, a blog, message boards, send friend requests, yadda yadda yadda, you've seen it all before. I'm going to be developing the initial setup myself (since we have no money), and this is a somewhat long term project that I'll be picking at casually for a little while.

Right now I'm trying to figure out if I should give this a go coding from scratch, or use an existing CMS type solution (like Mambo, Joomla, Drupal, etc). I'd really like to code it myself, as I think it could be a fun project to work on. I'm a pretty solid PHP programmer, but as I have a feeling that this idea could jump in popularity pretty quick, I really want to make sure I keep this thing as efficient as possible for a large user base. For instance, I don't want to go making another MySpace which I think runs horribly as a web app compared to even LiveJournal.

Currently I use PEAR's DB_DataObject or my database interactions and I've just gotten into Smarty for templating, though I'm sure I'm not using either to their fullest potential. I saw mention of a couple of development environments and frameworks in someone's recent post looking for a visual studio-esque PHP environment - http://www.livejournal.com/community/php/388602.html but I've never used any of these.

I'm not really concerned here with using a "rapid development" framework - I don't mind coding, I like it - but what I'm really concerned with is stability, efficiency and security - I know of course that these also rely heavily on how well I code, and using a good coding environment or framework won't do the coding for me, but there have to be some tools/frameworks/etc out there that pros are using that I just haven't moved onto yet, and I wanted to see what you guys (and gals) are using on some of your bigger projects.


- I know this comes up a bunch, but does anyone else think would it be handy at all for us as a community to maybe organize some of the more useful threads and frequently asked (and answered) questions in the php community at a separate location? Doing just a search on the community doesn't necessarily give you anything about the quality of the responses, and it may even be nice to be able to 'browse' solutions/posts by categories or something; maybe we could have some sort of quality ranking on posts, or some way to identify posts that contain questions that get asked all the time. I don't think this would be too tricky to put together, and I'd be willing to work on it, but I don't know if anyone would even use it?

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

Date: 01/10/06 (Computer Geeks)    Keywords: software, database

Problem

Solution 1 - Build a file server

• Data will be easily accessible.


• Hard drives are more durable than other media (Assumption)


• There are good maintenance applications for hard drives.


• Organization. Easier to keep hard drives organized


• Very Compact

• Cost.


• Time required to build box


• Maintenance of another computer


• Software expense


• electricity usage

Solution 2 - Buy External USB Hard Drives and HUB

• Less expensive


• Doesn't require building another box


• No software needed


• easy Maintenance

• Cables. This will require a lot of data cables and power cables


• Need something to contain it all like a cabinet


• USB Reliability?(Info Needed)


• Drive Reliability?(Info Needed)


• Data Transfer speed?(Info Needed)

Solution 3 - Tape Storage

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

Date: 01/10/06 (Security)    Keywords: database

Developers urge users of open-source database to update their installations immediately to protect themselves.

Source: http://news.zdnet.com/2100-1009_22-6025254.html

Date: 01/13/06 (PHP Community)    Keywords: php, mysql, html, database, sql, web

Hey Guys

I'm new to this community. I am starting a web design company, and although I used to be decent at PHP, that was a couple of years ago and my knowledge is now pretty much non-existent. I need a script coded for a band website and I was wondering if some of you would give me a price estimate on it.

The script is for bands that want to add shows to their website. The script needs to do the following

- Allow a user to add / edit / delete shows to their website. The shows will be in 2 categories (which will be 2 HTML tables) which are Upcoming shows, and past shows.
- The user puts in information in a form and it's stored in a MySQL database. The most important information is displayed in an HTML table, and in the last cell of the table will have a link for more information. When a user clicks on this link it opens up a popup window and displays ALL the information of the show (eg. Date, time, venue, cost, directions, other notes yada yada yada) in another HTML table (within the pop-up window)

I realise that this is a pretty simple script (in comparison to what you guys have probably coded in the past, so I hope someone out there can code it for me at a reasonable price

Thanks in advance

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