Posts by rch1231

Hello,

Your problem is that the file you are trying to attach to the email is too large. Most email servers limit the size of an attachment to less than 10MB.

Hello,

Looking at the order of the output I would be willing to bet that the variable type for Aantal_Duiven is varchar or char and is string based and not Integer of Float which are numerically based. What you are seeing is a sort based on alphanumeric characters instead of numbers. If treated as a character it evaluates each position in turn so that ax comes before ba (a being less than b). Using an alphanumeric sort the 3 in the first position of 3<blank> is greater than the 1 in the first position of 12. Does that help?

Add the following to the beginning of your text file:

USE Database ;

Where Database is the name of the database you want to create the table in.

Hello,

What you are trying to do is really what unix shells were designed for. Try this:

for x in `/bin/ls /home`
do
find /home/$x \! -user $x -exec echo "{}" is not owned by $x \;
done

This executes the command
/bin/ls /home
and puts the results in that place in the for loop. The reason you use /bin/ls instead of just ls is that most shells have ls aliased to color the output based on the file type and the color escape sequences wreck havoc with your code...

access2mysql sync is the best app I have found for quickly and easily moving data back and forth. You can usually find a copy for trial at http:\\download.CNET.com. If nothing else you will find several other apps there.

What you need to do is add the port 3389 to the DMZ and point it toward the server that needs to be available. The router will let one host normally be available to the outside on specific ports. Look up DMZ in your router docs.

concat(table1.field1, table2.field2) as newname

try this:

update table1, table2
set table1.col1 = table2.col1, table1.col2 = table2.col2, table1.col3 = table2.col3 where table1.col1 = table2.somefield

Hello,

I hate to disagree with someone on a response but ftp works fine is shell scripts. Typical ftp client programs under Unix, Linux, Solaris and NetBSD all read the ftp password from /dev/tty (or /dev/pty). The following site has a discussion of the issues involved and a script that does what you want.

http://www.stratigery.com/scripting.ftp.html

If you look at the man pages for ftp it states that you add the account parameter to the command line followed by the password for the account. To look at the manula pages use:

man ftp

from a shell prompt.

Hello,

This is quick and dirty since I don't know the real field names or table name but something like this should work:

select 
left(`date`,7) as 'Year-Month',
sum(income) as Monthly_Income,
sum(expenses) as Monthly Expenses
from 
mytable
group By 'Year-Month'

You should get a monthly total on each line.

Here is a basic netmask table:

ID  # Bits  Number Hosts    Usable Hosts    Netmask     Note

6   /6      67108864    67108862     252.0.0.0      

7   /7  33554432    33554430    254.0.0.0   

8   /8  16777216    16777214    255.0.0.0   Class A Network 

9   /9  8388608     8388606     255.128.0.0     

10  /10     4194304     4194302     255.192.0.0     

11  /11     2097152     2097150     255.224.0.0     

12  /12     1048576     1048574     255.240.0.0     

13  /13     524288      524286      255.248.0.0     

14  /14     262144      262142      255.252.0.0     

15  /15     131072      131070      255.254.0.0     

16  /16     65536       65534       255.255.0.0     Class B Network 

17  /17     32768       32766       255.255.128.0   

18  /18     16384       16382       255.255.192.0   

19  /19     8192        8190        255.255.224.0   

20  /20     4096        4094        255.255.240.0   

21  /21     2048        2046        255.255.248.0   

22  /22     1024        1022        255.255.252.0   

23  /23     512     510     255.255.254.0   

24  /24     256     254     255.255.255.0   Class C Network 

25  /25     128     126     255.255.255.128     

26  /26     64      62      255.255.255.192     

28  /28 16      14      255.255.255.240 

27  /27 32      30      255.255.255.224 

29  /29     8       6       255.255.255.248     

30  /30     4       2       255.255.255.252     

If you are running windows then try starting in safe mode. It could simply be your video driver being in the wrong mode for your monitor. If not what OS are you running and how far into the boot does the system go?

Best best is to reinstall the OS. Probably Windows XP. There should be a licence key somewhere on the machine if it is a name brand (HP, Dell, Compaq etc.) If so all you need to do is get an installation cd and use that key.

Check the speed of your network cards. I am willing to bet that PC1 has a 10MB card in it.

You might want to look into any of the O'Reilly books on the bash shell. The Bash cookbook is a good reference. It will give you all of these examples.

Use the shell built-in variable ${#}. Here’s some scripting to enforce an exact count
of three arguments:
#!/usr/bin/env bash
# cookbook filename: check_arg_count
#
# Check for the correct # of arguments:
# Use this syntax or use: if [ $# -lt 3 ]
if (( $# < 3 ))
then
printf "%b" "Error. Not enough arguments.\n" >&2
printf "%b" "usage: myscript file1 op file2\n" >&2
exit 1
elif (( $# > 3 ))
then
printf "%b" "Error. Too many arguments.\n" >&2
printf "%b" "usage: myscript file1 op file2\n" >&2
exit 2
else
printf "%b" "Argument count correct.
Proceeding...\n"
fi

Use the various file characteristic tests in the test command as part of
your if statements. Your specific problems might be solved with scripting
that looks something like this. This tests for the existence of a file:

if [ -e myfile ]
then do something
fi.

Unary operators that check file characteristics
Option Description
-b File is block special device (for files like /dev/hda1)
-c File is character special (for files like /dev/tty)
-d File is a directory
-e File exists
-f File is …

SOrry misread that part. This is where tail would come in. tail is used to view the last 10 (or a number you select) of lines from a file. to view the last line of a file you would use:

$ tail -1 myfile

and a script to read the last lines from a list of files and then sort those lines could look like this:

$ for x in text1.txt text2.txt text3.txt
> do
> tail -1 $x >> out1
> done
$ cat out1 | sort > out2

The first part runs a little for loop to write the last line of each file (you can list as many files names as you want separated by a space or tab) to a new file and then the last line sorts that file and writes it to another file.

Good then this will be easy.

The text files with random words I am assuming you can make for your self. But lets say you have the three files called text1.txt text2.txt and text3.txt. Linux has a built in sort command called sort that will do what you are trying to do. To use it you either pipe the output of another program to it or redirect a file in to it.

** Note in my examples the $ is your prompt and not part of the command.

For example to sort the contents of text1.txt you could cat the file and pipe it to sort like this:

$ cat text1.txt | sort

The results will be displayed on your screen. To write the output to a file you simply redirect the output to a file name. The file does not need to exist and using a single redirect if it exists it will be overwritten.

$ cat text1.txt | sort > sortedfile.txt

To sort all three files together you simply list them one after the other:

$ cat text1.txt text2.txt text3.txt | sort > big_sortedfile.txt

By default sort uses the first word of each line and sorts alphanumerically which means that 2 is larger than 10 because the first letter (2) is larger than the first letter of 10 (1). There is a flag to tell it to look for numerical values but you did not ask about that.

Ok first are we talking Linux or windows shell?

I think what you are trying for is where r1 = standard and the status is either NTC or In Progress. If so try this:

SELECT * FROM installs 
WHERE r1 = 'Standard' 
AND (STATUS = 'NTC' 
OR STATUS = 'In Progress') 
ORDER BY building, appointment_date ASC

The way the logs are written to is determined by the application doing the writing. Normally there are entries in the application conf file to tell it how to make entries in the log.

Unless I am mistaken you have to install the printer first then set it as the default printer.

What happens if you put that URL in a browser on that computer?

May tell you what is going on and also check the apache logs for the errors when it tries to get the page.

OReilly makes the best books on just about any computer topic.

O'Reilly - Designing Large-Scale LANs
O'Reilly - Network Security Assessment 2nd Edition Nov 2007
O'Reilly - TCP IP Network Administration
O'Reilly - Internet Core Protocols The Definitive Guide
O'Reilly - TCP IP Network Administration 3rd Edition
O'Reilly - The Network Administration Guide

And more.....

There is no ; at the end of the sql query to tell MySQL to execute the code. Try this:

$query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number';";
$result= mysql_query($query) or die(mysql_error());

A join is used in a query to retrieve data from more than one table based on a common element in the two tables. For example you might keep shipping addresses in one table and orders in another with a field in the order table holding the id of the address record it was shipped to. To print an order you could use a join to get the address data.

A foreign key is used to create a permanent link between two tables to prevent removal of important data. In the above example you might create a foreign key from the orders table to the shipping addresses specifying (constraining) that the address cannot be deleted if there are orders using the address.

Unless I am mistaken you need to set the following lines in the
/etc/vsftpd/vsftpd.conf file:

local_root=/var/www/
chroot_local_user=YES

Try this site for more information:

http://ubuntuforums.org/archive/index.php/t-518293.html

Ok I have looked around for something that might help but the only think I can see is I believe there should be a space after the IN

class CHAR(10) NOT NULL CHECK class IN ('x1','x2','x3'),

I am not sure what you mean by "A value that I choose" but there are several ways. Here is an example from the mysql cookbook that should do the trick:

We've used lookup tables often in this chapter in join queries, typically to map ID values or codes onto more descriptive names or labels. But lookup tables are useful for more than just SELECT statements. They can help you create new records as well. To illustrate, we'll use the artist and painting tables containing information about your art collection.
Suppose you travel to Minnesota, where you find a bargain on a $51 reproduction of "Les jongleurs" by Renoir. Renoir is already listed in the artist table, so no new record is needed there. But you do need a record in the painting table. To create it, you need to store the artist ID, the title, the state where you bought it, and the price. You already know all of those except the artist ID, but it's tedious to look up the ID from the artist table yourself. Because Renoir is already listed there, why not let MySQL look up the ID for you? To do this, use INSERT ... SELECT to add the new record. Specify all the literal values that you know in the SELECT output column list, and use a WHERE clause to look up the artist ID from the name:

INSERT INTO painting (a_id, title, state, price)
SELECT a_id, 'Les jongleurs', 'MN', 51 …

If I am reading the error correctly you do not have an index built on the account_number field.

Looking at the code I think the problem is you are not using the "SET" command to identify the variable you are updating. Normal syntax for an update statement is something like:

UPDATE table_name
set table_name.field5 = <field5data>,
table_name.field10 = <field10data>
where table_name.id = <record_id>

In your case I think the line should read:

$query= "UPDATE account 
set account_type =`".$_POST['account_type']."` , 
fd_period = '"$_POST['fd_period']."' 
WHERE `account_number`='".$_POST['account_number']."'";

Hopefully this will help but I am not sure about the $_POST. I think it should be the array (or hash) $info instead.

Just looking at it real quick is identity your primary key and set for auto-increment? If so then do not attempt to set the value as the system will automatically fill it in.

The message you are receiving could be from a virus that is trying to get you to install it. To find out for sure get the latest copy of MALWAREBYTES from the link below. The free version will usually get rid of almost everything and you can install it in "Safe Mode with Networking" and get the updates and for the software too.

The code you have is selecting every record from question and only joining info from records in answer that match the criteria. I think what you ar looking for would be:

SELECT * 
FROM question 
LEFT JOIN answer ON question.Que_ID=answer.Que_ID 
AND question.Que_Answer1=answer.Ans_Answer1 
AND question.Que_Answer2=answer.Ans_Answer2 
AND question.Que_Answer3=answer.Ans_Answer3
AND question.Que_Answer4=answer.Ans_Answer4
WHERE				
question.Tes_ID=7
AND answer.Use_ID=1

Your problem is coming from the field being treated as a string rather than a number. Basically you have two options.
1. Split the files into tree separate fields as integers and then do the order by using all three fields.

2. Change the columns that need it in your data to be 2 digit based instead of one or two.

So the data would look like this possibly:
1.1.01
1.1.02
1.1.03
......
1.1.10
1.1.11

What you want is a RAID controller card to connect the drives to. You will setup the RAID on the drives prior to installing the OS and the OS will see the array without any problems as a single install drive.

It does not make sense for the server to block you unless the account is restricted to only one connection per user. I am not sure what ssh client you are using to access the server but may I suggest you try PUTTY.

http://www.chiark.greenend.org.uk/~sgtatham/putty/

I work for a hosting company and have been supporting Linux for 20 years and it is the best free client. You will be able to connect and if nothing else see why you are not connected.

I don't believe what you are describing is possible with just one hard drive. You are attempting to use partitions for the RAID instead of physical disks. RAID, an acronym for Redundant Array of Independent Disks (Changed from its original term Redundant Array of Inexpensive Disks), is a technology that provides increased storage functions and reliability through redundancy. This is achieved by combining multiple disk drive components into a logical unit, where data is distributed across the drives in one of several ways called "RAID levels".

You would actually run slower attempting to access multiple partitions on the same drive as opposed to accessing data across multiple physical drives. The following site may give you a better idea of what RAID is and how it is used:

http://en.wikipedia.org/wiki/RAID

Not pretty but it works and I moved 1 from the first position for testing:

#!/bin/bash
 y=0
for x in 4 6 23 1 5 7 100 2
do
if [ $y -eq 0 ]
then
y=$x
fi
if [ $x -lt $y ]
then
y=$x
fi
done
echo "Answer: $y"

try this to seewhat is happening:

/bin/sh -x cup.sh
it will show you each line and result as it executes.

Duplicate the lines from 62 through 82 and change the select to:

$qry = "SELECT * FROM members WHERE email is not null and email = '$email'";

And the error message to:

$errmsg_arr[] = 'email address already in use on another ID';

Try this on line 64:

$qry = "SELECT * FROM members WHERE login='$login'" or ( email is not null and email = '$email' )";

This will eliminate the empty email addresses (since you don't test for it being filled in) and return a result if login or email match. You will need to change your message to reflect email or login already used.

Try CNET's download site and you will find some excellent options that are both free and paid along with reviews by editors and users.

http://download.cnet.com/

How do you know it is broke and not running? have you tried adding pause statements to the bat file to force it to show the command line results. which version of windows??

But the poster referred to running this on a laptop and unless you move up to something like ESXi from VMware (which is a Linux based OS) I am not aware of another method to allow you to run some of the older OS's that he mentioned. I run Fedora Core 14 which is primarily designed for Laptops and their various wireless adapters. The installation of the OS from the distribution DVD is easy and has drivers for almost everything built in. I have even removed the SATA laptop drive from my AMD 1.9GHz Athlon x2 based laptop and plugged it into my Intel P4 - 3.6GHZ Desktop and booted the system without any errors or prompts for drivers. Then moved it back without any hitches either.

The virtual OS's run just a hair slower than the real thing on the laptop and having more than one running at a time would not be a great idea. If you would like to give it a try and have any questions I have set this u a couple times for some of our developers and would be happy to assist.

Jlego - Unless you have another idea of a method to accomplish this based on the parameters he supplied then I think this is his best bet. Installing Linux is easier than installing Windows, runs faster, crashes less, has the OS versions he needs available virtually and has practically no Viruses plus it is FREE. Don't knock it till …

As an idea you could install Linux on the system and then put the old os in a virtual application (Oracle VirtualBox works well) and there are several emulators like dosbox for Linux that give you a virtual system with simulated Floppy disk drives etc.

http://en.wikipedia.org/wiki/DOSBox

The Oracle VirtualBox supports the following per their documentation:

Windows NT 4.0
All versions, editions and service packs are fully supported; however, there are some issues with older service packs. We recommend to install service pack 6a. Guest Additions are available with a limited feature set.

Windows 2000 / XP / Server 2003 / Vista / Server 2008 / Windows 7
All versions, editions and service packs are fully supported (including 64-bit versions, under the preconditions listed below). Guest Additions are available.

DOS / Windows 3.x / 95 / 98 / ME
Limited testing has been performed. Use beyond legacy installation mechanisms not recommended. No Guest Additions available.

Not sure if you have solved this yet but I may not have made it clear that the entry for the etc/hosts file goes on the PC that you are trying to access the site from as opposed to the server. That way when you enter the domain-name on the Workstation it pulls the IP address from etc hosts instead of looking the address up via DNS. Hope that helps.

That is basically it. You should have an installation CD for each of the printers and it will configure the IP address for you and set up the drivers on your computer.

It is not easy to tell what is wrong with out the information on the table you are pulling from however your query shows a field called BLLinehaul but you don't reference one called BLLinehaulEntered

if it is on linux system and you are referring to the active connections to the server use the following:

netstat -a

to list a count of all of the UDP entries use:
netstat -a | grep udp | wc