Search results for query: *

The DB can be changed, but as this is a rather large application and such a change would require changing a whole lot of code. While the setup you describe would be better, it's not worth the time or money (I'm not working for free here) it would require. Fortunately I seem to have figured out...

I have an events table with a class field that I need to search. The class field contains a comma-delimited list of all the grade levels involved in event. For instance, if the event included just high schoolers it would be "12,11,10,9", or if it was even-numbered grades it would be...

It's not the MD5'ed string that's been giving me problems. It's the next string, the long one that begins with "N" and includes the unicode characters. Anyway, I've played around with column types and collations and finally found something that will let me write the string to the database...

I'm trying to write a PHP script for encrypting data and saving it to a MySQL database. I've tested the script, and it can encrypt and decrypt just fine. However, when I actually try to post the data to the database, much of it gets truncated. The SQL query that gets posted: INSERT INTO...

ceco, that query does work. Thank you. It appears that there's a bug in the way PostgreSQL (ver 8.2.4) handles "not in" clauses, particularly when it contains a subquery that returns a large number of results. The following works. select count(*) from tbclients where id not in ( select...

The queries in my original post are the exact queries I'm using.

I think you missed the point of my issue. Let's take your example, except I'll shorten the table to make things more clear. id date filter match -------------------------- 1 2002-01 - 2 2002-01 - 3 2002-01 - 1 2003-01 - 2 2003-01 - 3 2003-01 - 1...

A little background: I work for a small not-for-profit organization. We have a PostgreSQL server containing all of our client information dating back to 2001. I've been asked to do some data mining. The problem is that I'm getting weird results. Note: "tbclients" is the table containing...

I'm trying to set up a new computer to use an HP printer (LaserJet 4250) we've got networked via a JetDirect 170x external. The problem is that for whatever reason, this particular computer cannot see the JetDirect. It can't find it on Network Neighborhood, and can't ping the IP address. It...

I've been having the hardest time trying to install a network printer on this WinME computer. When I run the install program it keeps giving me this error: Msiexec has caused an error in KERNEL32.DLL. Msiexec will now close. I've tried everything I can think of short of a complete Windows...

OK, finally found the problem. This computer has another firewall program, specifically McAfee. And sure enough, it was reporting "unsolicited" connection attempts from computers on the network. I'm keeping it, but I've modified the settings to allow connections from our network.

Oh yeah, I should have mentioned that I have already turned off Windows Firewall.

I've got a very frustrating problem here. I've got one XP Home system on our network with mostly Win98 systems and one Linux machine. The XP machine is able to browse the network and see others' shared directories just fine. However, other computers are not able to browse the XP computer's...

OK, I think I've found the problem. The latest update of IE 6 for Windows 98 (I'm unsure of the number) apparently is a bit buggy in handling POSTing of data. I removed the update through "Add/Remove Programs", and it seems to be working fine. Better yet, I get to blame Microsoft. :p

I'm using IE 6. Never had problems with IE 6 and the website until just recently. I just checked on NeoPlanet. That seems to work.

I'm testing it several ways. I'll come in fresh, entering in the data and then hitting submit. Or I'll refresh the results page. Or I'll enter the information and hit submit, then hit the back button, then hit submit again. It appears that the first attempt usually fails, but subsequent...

The webserver is Apache (version 1.3.20). In httpd.conf I've set up Apache to parse files with the extension "ccs1" (not "css1") with PHP. Essntially, on this system .ccs1 files are the same as .php files. PHP version is 4.1.1.

It seems that POSTing information from a form to another page only works intermittently. Sometimes it works and sometimes it doesn't. Here's some example code: The intake page (posttest.ccs1): <html> <head> <title>Test of POST</title> </head> <body bgcolor='#000088'><form...

Well, the thing has a new power supply and a new NIC, but it's still hanging at the same line. Bringing up interface lo:

Well, while swapping out the NIC, we discovered that the back of the computer felt quite a bit hotter than it should have been. We turned it back on, and sure enough the fan on the power supply wasn't working. Our hardware guy's going to be taking a look at it over the weekend. We'll see...