Search results for query: *

Hmmm. Fair enough. What's your Paypal ID? Also, if you do figure out any other ways to cut the select statement down even more I'd appreciate it! Thanks!

Aha.. Very close. However, I need it to just return a User_ID if there is a match, without returning the result of summa1 and summa2. If you can make that happen, then you just earned yourself $20. :)

Er, that is what I want to do. However, I don't want to have to write out an extremely long select statement if I can help it. This is the finishing touch on a website I have been working on for months now, and I need a solution soon. Since I need this solution soon, and it is a complicated...

Yep, that's exactly correct.

In other words, the table looks like this: CREATE TABLE some_data ( User_ID varchar(6) NOT NULL default '', s1_1 int(1) default NULL, s1_2 int(1) default NULL, s1_3 int(1) default NULL, s1_4 int(1) default NULL, s1_5 int(1) default NULL, s2_1 int(1) default NULL, s2_2 int(1)...

Unfortunately, that's not an option in this database. Any other ideas, tips, or tricks out there?

Many systems' hostname has a -s flag to strip off any additional domain information from the hostname that is returned. Solaris is not one of these systems, hence why your script kept setting the hostname to "-s". If you just took the -s off the end in the script, it should be fine and...

Hello, I have a table that has a User_ID, then many columns that have integer values. They are named s1_1 through s1_5, s2_1 through s2_5, s3_1 through s3_5, s4_1 through s4_5 and s5_1 through s5_5. So, in other words, there are 25 columns total with these integer values, and 1 User_ID column...