Date: 06/23/05 (Web Development)    Keywords: mysql, database, sql, apache

I had an interesting question come up? How much of a speed improvement (if any) will I get by installing mod_deflate on apache?

I would think that it would be a good bit but without some sort of test I have no way of knowing. So I wrote a Test Program It requires mozilla or firefox to run but if people here would be willing to help me out It would be very good. It is not very hard. Just click on that link and then click the “run test” button. It will take over from there. It will take a few minutes to run.

Please note that this test requires Mozilla or Firefox to run.

You don’t have to send me the output, as it will store all the timing data in a MySQL database.

I’ll post a summery here when this is done.

Thank you once again.

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

Date: 06/25/05 (PHP Community)    Keywords: xml, database, sql

Okay, the subject's kind of vague, but here is what I need to do:

Right now, the Perl programmers are using a perl script to do a database dump of multiple tables into XML format, and Im using cURL to retrieve that XML.

Now here is the problem, for some reason, they refuse to handle the proper SQL selections for what I need, so basically, I need to correlate the data in the different nodes (tables) to each other.

For instance, I have one node that contains the foreign key of another node, which then holds the foreign key of another node.

Ill give you a good example of what I need to do:

machine_user_map contains the package_service_id.
I then need to grab the package_id from package where the package_id in package_service is the same as the package_id in package.
Then, I need to grab the package name from package.

I've been using XPath so far, but there is no way to do multiple select-type commands with XPath like there is in SQL.

Does anyone have a good solution for handling this sort of thing?

Thanks in advance :)

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

Date: 06/26/05 (SQL Server)    Keywords: database, sql, microsoft, google

Hello everyone. I apologize in advance for being the typical newbie at this sort of thing, but I don't really have a choice. I just landed a new summer job at an Embassy and I really need some help.

I have been giving the task of sorting out maps in my department. I'm to build a database where I index all of the maps so that people in the Embassy can have easier, more organized access to them. However, I have never, ever done anything like this before and unfortunately I am stuck with Microsoft Access (I've already been told that SQL is far superior to MA). Believe me, I would switch to SQL in a heartbeat because I have heard that it is more user-friendly, but MA is what I've been given to work with and I cannot download anything onto my computer.

So far I've set up tables and created a couple of forms. I've probably already done something wrong just through that. I realize that people take courses to learn how to use MA and it's going to take more than a few LJ comments to help me get through this. What I was hoping you guys could direct me toward are some detailed MA tutorials online. I'm having specific problems trying to understand what 'queries' are and how to set up a main switchboard. The purpose of this index is to serve as sort of a search engine to look up these maps, and I don't know how to do that.

So if anyone has any links to tutorial sites, hopefully more specific to what I'm trying to do, that'd be great. I've already Googled for help and I've found a few tutorials, but I'm hoping for even more help.

Sorry about my sob-story. I'm really in a bind here. MA is making me feel really, really unintelligent.

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

Date: 06/28/05 (PHP Development)    Keywords: mysql, database, sql, google

I'm working on a site at the moment and I'm trying to optimise the MySQL queries, to place less of a strain on the server and make generally neater code. I'm currently using this technique to pull the last 10 topics flagged as news from the database:

$query = mysql_query( "SELECT * FROM frm_topics t WHERE t.tpc_news = '1' AND t.tpc_news_mod_id > 0 ORDER BY t.tpc_sticky DESC, t.tpc_time DESC LIMIT 10", $_GLOBALS[ 'sql' ] );

$news_sql = mysql_query( "SELECT * FROM frm_posts p WHERE p.pst_tpc_id = '".$results[ 'tpc_id' ]."' ORDER BY pst_time ASC LIMIT 1", $_GLOBALS[ 'sql' ] );

$query = mysql_query( "SELECT * FROM frm_posts p, frm_topics t WHERE p.pst_tpc_id = ( SELECT tpc_id FROM frm_topics t WHERE t.tpc_news = '1' AND t.tpc_news_mod_id > 0 ORDER BY t.tpc_sticky DESC, t.tpc_time DESC LIMIT 10 ) AND t.tpc_id = p.pst_tpc_id ORDER BY p.pst_time ASC LIMIT 1", $_GLOBALS[ 'sql' ] );

Source: http://www.livejournal.com/community/php_dev/59389.html

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

Hi all.

I'm trying to move some tables from an old 2.5.3 database to my new 2.6.2 one and I'm experiencing some difficulties. I'm doing my usual method of exporting the old files to a text SQL file and then uploading the file to the new database, which has always worked for me in other situations, however, in this situation whenever I upload the file to the v2.6.2 database, it gives me an error message of "No SQL query".

Edit: never mind, I figured out what I had been doing wrong. I had been forgetting to check "Extended inserts" when exporting the database files. Problem fixed. :)

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

Date: 06/29/05 (Open Source)    Keywords: database

Oracle likes to hire people in their late twenties or early thirties who combine attitude with some sales skills, but do you know anyone in that age bracket who doesn't work for Oracle and nevertheless favors the company's database products? I don't.

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

Date: 06/29/05 (PHP Community)    Keywords: php, mysql, database, sql

I'm running this bit of PHP script in a page I'm writing for a real estate's site:
$query = "CREATE TABLE 'mls" . $mls . "' ('id' INT NOT NULL AUTO_INCREMENT,'photo' VARCHAR(50) NOT NULL, PRIMARY KEY ('id'))";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

The idea is that it's supposed to create a table named using a variable in the database. I would like to be able to dynamically create and drop tables as real estate listings are added and deleted. I just tried it out and it didn't work. No errors but the table didn't appear in the db when I went to look using phpMyAdmin. Is there something wrong with my code or is what I'm trying to do not possible?

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

Date: 06/29/05 (Web Development)    Keywords: php, mysql, database, sql

I'm running this bit of PHP script that I'm writing:
$query = "CREATE TABLE 'mls" . $mls . "' ('id' INT NOT NULL AUTO_INCREMENT,'photo' VARCHAR(50) NOT NULL, PRIMARY KEY ('id'))";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

The idea is that it's supposed to create a table named using a variable in the database. I would like to be able to dynamically create and drop tables as real estate listings are added and deleted. I just tried it out and it didn't work. No errors but the table didn't appear in the db when I went to look using phpMyAdmin. Is there something wrong with my code or is what I'm trying to do not possible?

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

Date: 07/01/05 (PHP Community)    Keywords: php, xml, database

Hi everyone, I am having some problems processing an XML document with PHP.

I know the XML doc is well formed and valid, I would post it but I cant seem to figure out how to post XML without it being processed. The structure of the document is as follows.

updates
     franchise
          CRH
               SN
               FID
          CRH
          CRH
               SN
               FID
          CRH
          CRH
               SN
               FID
          CRH
     franchise
updates

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

Date: 07/02/05 (Java Web)    Keywords: database, java

Sun Microsystems is looking at providing its Java Enterprise System (J2EE) customers with a database management solution that will either take advantage of existing open-source database management technologies or developed in-house. I think they should leverage from some high quality open source database management solutions rather than re-inventing the wheel. Loiacono said that customers are also [...]

Source: http://blog.taragana.com/index.php/archive/sun-shares-more-on-its-database-management-plans-for-java-enterprise-system-j2ee/

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

Hi,

I am having problems with an SQL query not returning any rows. My table in my database is set up like:

ns_event_month INTEGER
ns_event_day INTEGER
ns_event_year INTEGER

(i'm leaving many fields out)

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

Date: 07/05/05 (Web Development)    Keywords: database, asp, sql

IIS 6 SQL 7.0 ASP VBScript

Some simple math:
0.55 + 0.02 -0.49

Should equal 0.08 – correct?

When I add up these values from the database (the rest are 0 value - there are only three fields that have value as above)

totalAdjust = oRecordset("hisSunAdj") + oRecordset("hisMonAdj") + oRecordset("hisTueAdj") + oRecordset("hisWedAdj") + oRecordset("hisThuAdj") + oRecordset("hisFriAdj") + oRecordset("hisSatAdj") + oRecordset("his2SunAdj") + oRecordset("his2MonAdj") + oRecordset("his2TueAdj") + oRecordset("his2WedAdj") + oRecordset("his2ThuAdj") + oRecordset("his2FriAdj") + oRecordset("his2SatAdj")

I get: 8.00000000000001E-02

If I do this in code:

response.write 0.55 + 0.02 -0.49

I get: 8.00000000000001E-02

THAT is the most bizarre part because I’m just outputting the calculation – it can’t possibly be anything in the code or database because I hard coded the math and came out with the same WRONG answer!!

Just to double check that I cut and pasted the record from the database into Excel and Summed it in there, and sure enough, it gave me the (correct) 0.08 just as my calculator did.

Any thoughts??

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

Date: 07/06/05 (Computer Help)    Keywords: database, virus

a) What are some good, free virus scanning/get-rid-ofing programs? Something I can use without using IE (since any time I try to open it, it freezes) and not AVG (as a few people have suggested), since it makes Windows fail to open when it makes me restart and I have to uninstall it in safe mode.

b) Whenever I'm using ACDSee and I go to Database Maintenance, a window pops up that says "Runtime error. C:\PROGRAM FILES\ACD SYSTEMS\ACDSEE\ACDSEE.EXE abnormal program termination" and ACDSee closes. Any clue what could cause that? I haven't changed any settings or (un)installed anything new...

And c) Whenever I try to open Quicktime Player on this computer, it won't open unless I go to "Search for updates" and update the program (every time I restart, I have to update to get it to respond). Then, when I try to open it, I get an error "Quicktimeplayer has caused an error in QUICKTIME.QTS. Quicktimeplayer will now close." I've uninstalled and reinstalled Quicktime about 7,000 times. So... how do I fix this?

Basically, this computer is a mess.

Source: http://www.livejournal.com/community/computer_help/437333.html

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

I've got an array and a database. How do I check the data in the array against the database (basically to see if that piece of data exists in a specific field) and then show a message depending on whether it exists or not?

I figured it'd be something to do with the foreach() thingymajig.. but as expressed in the title, foreach() & me don't get along well.

Please excuse my n00bish-ness.. out of all things PHP, arrays & I have the most arguments. ;)

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

Date: 07/06/05 (SQL Server)    Keywords: database, sql

Alright, here's an oddball situation for everyone. Seems we have a client that is running the above version of SQL Server 7.0 - SP3 on NT4.0, and is attempting to upgrade to SP4. But the SP doesn't seem to be applying itself. From what I've been told, they check the version numbers after applying the SP and rebooting, and it continues to remain the same, not switch over to the newer SP4 version number. And now this got passed off to me (being the lowest on the already short totem pole), to attempt to research.

Whee... don't suppose anyone out there might miraculously have any insight into this?

And to answer some of the obvious questions, no I have no idea why they just don't upgrade past NT4 and 7.0... no, I don't have direct or even indirect access to the machine, and cannot attempt to apply the service pack myself. SQL Server continues to chug along happily. No errors are logged anywhere as far as I know either.

x-posted to databases

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

Date: 07/08/05 (Java Web)    Keywords: database

The newly released Oracle Database 10g Release 2 offers enhanced automated features designed to ease the burden of statistics collection and analysis. Automation is the key mantra with 10g release. In the words of Mark Townsend, Oracle's Senior Director of Database Product Management, "wherever we could, if it was a housekeeping task, we would automate [...]

Source: http://blog.taragana.com/index.php/archive/oracle-database-management-system-10g-r2-takes-a-huge-leap-forward-on-automated-diagnostics-and-monitoring/

Date: 07/13/05 (Security)    Keywords: database

Company's database, application server and 11i E-Business Suite are covered in the quarterly update.

Source: http://news.zdnet.com/Oracle+update+fixes+security+flaws/2100-1009_22-5786474.html?part=rss&tag=feed&subj=zdnn

Date: 07/13/05 (Web Development)    Keywords: php, browser, css, database, web

This is driving me crazy. Any help would be much, much appreciated.

I'm redoing the site template for this intranet website I'm designing - the Dreamweaver template I'd made using tables is completely, inexplicably fubar on certain pages of the site. I got sick of messing with it and told my boss I was going to make an all-new, CSS-based layout, and that was that. He agreed to let me do so.

Everything's been going fine...I've been doing my primary testing in FireFox, but I've been doing testing in IE6 (mostly because that's what almost everyone in this department is likely to use), as well as minimal viewing in Opera 8 and Netscape 7.

Suddenly, things broke. Now I have part of the content text repeated below my footer text. See link here:

http://www.shifuimam.com/php_tutorials/database_trial/drfe/template.php

I've discovered that if I remove the "float: left" property of the lefthand area of the site in my CSS, it fixes it. However (of course), removing that element completely throws the site layout out of whack. I'm about to do absolute positioning of all the elements and throw this template out the window.

I beseech you, please, please help me.

Oh, and while I'm at it...I want the gray lefthand column to extend to the bottom of the browser window, regardless of the length of the content. In all browsers, setting the "length" property to "100%" makes it too long, because there's stuff ABOVE that navigation bar. Any ideas?

X-posted between shifuimam, webdev and webdesign.

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

Date: 07/14/05 (Java Web)    Keywords: php, database, java

Today I had an interesting conversation with my ex-Boss and good friend. He asked me to summarize the current state of Java world these days as he was busy with databases and scientific computing. Here is my short take on it. Ruby has become a cult like Apple. PHP guys think they are winning over Java. [...]

Source: http://blog.taragana.com/index.php/archive/how-is-java-world-going-thse-days-a-summary/

Date: 07/17/05 (WebDesign)    Keywords: cms, php, mysql, database, sql

I know, another "what CMS should I use?" question. But hear me out. I'm looking for a CMS that's flexible, easy to set up, allows all users to submit content, and has some sort of mechanism for reviewing items (like Epinions or Amazon or Yelp.)

I can run PHP (safe mode only) or Perl, and I've got a MySQL database.

Any suggestions? Please?

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