Posts by rch1231

Normaly the domain names become availaable around 2 weeks after they expire. I would try going to their site and getting the account re-establshed but they say on their terms site that they keep the names for 2 weeks.

Hello,

My question would be where is it lagging? Is it when accessing the internet or when you are simply running normal applications. And you mentioned running disk cleaners have you checked out any of the registry cleaners (like CCleaner or Gleary utilities). It could be that some of the entries in the registry are corrupted or point to files no longer there and that really confuses windows.

What you are looking for is probably the group by clause. Group By consolidates the results for a unique value of one of the data fields. Below is an example of two tables joined and results given using group by.

To display the artists by name rather than ID numbers, join the painting table to the artist table:

SELECT artist.name AS painter, COUNT(painting.a_id) AS count
FROM artist, painting
WHERE artist.a_id = painting.a_id
GROUP BY artist.name;



+----------+-------+
| painter  | count |
+----------+-------+
| Da Vinci |     2 |
| Renoir   |     1 |
| Van Gogh |     3 |
+----------+-------+

Hello,

You could try making the default value for the fields 0 or you could add 0 to the value of the field in your query to get a result that you add in the sum.

The question is can you get out of your computer and after that the thing to check is can you resolve any domain names. Try going to a command prompt and checking to see if you can ping your computers IP address then the gateway then try to resolve domain names.

ipconfig /all

Will give you the information you need to check these things.

nslookup google.com

If that does not come back with a IP address then you have problems with your DNS server.

Hello,

A lot of people "claim" to be hackers and really are nothing of the sort. Your running Linux if you have a secure password, don't have your system set to auto log you in, don't give them the password or give them a login to your system then odds are they are not going to get on your computer. It would be different if it was Windows which has too many security holes to count. If you are really worried that some one might get on your computer then disconnect it from the network when you are not using the internet. That really makes it hard for people to connect. Then keep an eye on your /var/log/secure file to watch for people trying to hack the system or run a program like denyhosts to lock them out when they try to hack their way in.

Without digging into the sql you have so far and based on what you are looking to do I suggest you look into using Group By and then if still needed the HAVING option to limit the output after it has been selected.

The query first selects the CID (or city id from what I see) using the employee city shown on the page or in the query.

Then is selects the eid (employee ID's) for all employees whos cid in the works table is equal to the CID pulled from the company data.

It then selects all fields from the employee table whos city is equal to the CID.

Hope that helps

I would take a look at the Virtual PC network configuration. See what virtual network card you are using and make sure the drivers are available for the guest system.

Why would you need to use MinGW almost every linux distrubution has gcc available as part of the distro. Wine should not be needed.

Besides the rpm is also available on the site so again why use a Windows compiler on a Linux system?

We really would have to have samples of the tables to give you the exact code. No telling what triggers are in place or what actual tables are involved with out seeing the database.

Are you using a USB keyboard or mouse? Try unplugging them and plugging them into another port forcing the driver to load. If not then use one. Also try toggeling the numlock or caps lock to see if the keyboard changes the lights.

Hello,

To follow normal accounting procedures you would need two transactions. One debiting the receiving account and one crediting the sending account. Banks credits and debits are backwards from other accounting methods. In other words money added to your account is a debit an removed from your account is a credit. Don't ask me why just something I remember from class. Any ways you have to show both transactions because they cancel out each other as far as the accounting side is concerned leaving 0 funds left over. If you have a transfer fee involved then you need three transactions. Total removed from account, amount added to receiving account, and amount going to fee account.

Hello,

You really don't have to worry about the OS so much as the browsers and the language that the page is written in. I would say keep it simple and use applications that depend on the server not the client like html, php, css and mysql. PHP converts to html which most browserrs have no trouble with. It is when you try to get fancy with active-x, java, or net-framework and other client based scripts that you run into issues.

It is normally found here:
C:\xampp\php\php.exe

Before we can really answer that you are going to have to tell us which database you are trying to connect to (MySQL, MS SQL Server, Access, Oracle, etc.) and what you are trying to connect from (VB script, web page, php, c, etc.)

That is just a Unix/linux shell script that can be invoked one line at a time from the command line (if needed) for testing. If you notice the first line is #!/bin/bash wheich tells the OS what to use to run the script.

The other thing that I noticed is you keep referencing that the vendor has a secure ftp server and all of us have been referencing the ftp application instead of sftp. Try the shell script like this:

#!/bin/bash
# $1 is the file name for the you want to tranfer
# usage: this_script <filename>
FILE=path/file
IP_ADDRESS="xx.xxx.xx.xx"
USERNAME="remote_ftp_username"
domain = sample.domain.ftp
PASSWORD= password
/usr/bin/expect<<EOD
spawn /usr/bin/sftp $USERNAME@$IP_ADDRESS
expect "assword:"
send "$PASSWORD\r"
expect "sftp>"
send "put $FILE\r"
expect "sftp>"
send "bye\r"
EOD

The reason for expect "assword:" is that in some cases it responds with a capital P and others a lower case p and this will accept either one.

I would use count to see if the user ID returns any rows where status_type(10) and status_value(11). and use that as the having part of you query.

select id, 
name,
(select count(*) from user_status where status_type=10 and status_value=11) as mycount
having mycount > 1

Ok a couple of things that ma help. Curl is designed to get files not send them so drop that approach all together. SInce your not on a windows (yea) then I am assuming you have access to ssh and a command line or as you said you want to run it from cron. Here is a shell script that will transfer a file to another server via ftp:

#!/bin/bash    
# $1 is the file name for the you want to tranfer
# usage: this_script  <filename>
IP_address="xx.xxx.xx.xx"
username="remote_ftp_username"
domain = sample.domain.ftp
password= password

ftp -n > ftp_$$.log <<EOF
 verbose
 open $IP_address
 USER $username $password
 put $1
 bye
EOF

You then use crontab -e to edit the crontab and call the script:

05  00  * * * /my/path/to/file/this-script dafile.csv 2&>1

Then it probably is Windows Firewall try turning it off and see if you can turn Network sharing on then, If that makes it so it works then:

Go to
Control panel>>windows firewall
Click on Allow a program or feature through windows firewall
Make sure file sharing and network discovery have been checkmarked.

Hello,

I would be willing to bet that the ones you cannot save the settings on and gave them stay are not Win 7 Professional but either Windows 7 Home or Home Premium. they only support homegroups.

Just out of curiosity have you run the select query to see what records you are attemptng to delete? It could be your delete is pulling more than on record.

SELECT * FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street'

But with that said the problem seems to be the STUDENT_ID_TRIGGER is trying to update values it cannot write to. I would take a look at the trigger to see if it is an update trigger that should be an insert trigger.

You could also limit it to the first x number of characters and check them against each other but Pritaeas is correct you will have to define some rules to go by. A query that would find your similar names would be:

where Left(Table1.CompanyName, 4) = left(Table2.CompanyName, 4)

Are you looking for the configs/IOS files for gns3 devices? If so I gave most of them.

Hello,

It depends on the error you are getting when you try to send email. Probably need to change your MX records or set the spf record to show you are running a legit email server. You can check your email settings with one of the tools like:

http://www.dnsstuff.com/tools

I would grab a copy of hijackthis which is a malware detector that will show you all of the hooks into your system through registry entries and help you track down the culprit.

You could add

sleep X

as a fifth line where X s the number of seconds till it continues or use

echo "Backup Complete" | more -d

instead of the read -p to get it to prompt with

Backup Complete
[Press space to continue, 'q' to quit.]

Hello,

I am not sure if you are looking for the php code or the sql code but here is the sql code for what you need to do. You would either put a real values for the where clauses for Month selected and for userid from login or use php to put the current varible values there. To get January for Tom you would use:

select 
statement.StatementID, 
tom_sawyer_db.TransacID,
tom_sawyer_db.DateID,
tom_sawyer_db.TransacName,
tom_sawyer_db.Deposits,
tom_sawyer_db.Withdrawal,
tom_sawyer_db.Balance
from tom_sawyer_db
join statement on statement.MonthID = tom_sawyer_db.MonthID
where tom_sawyer_db.UserID = 4
and statement.MonthID = 1

Hope ths gives you something to work with.

You can't use join in an update. You have to reference both tables and select the records to update.

update folders, Documents
set folders.folder_ProductID = Documents.products_ProductID 
where folders.FolderID = Documents.FolderID

Hello,

Try this site it has several formats and includes city, region, country, latitude and longitude.

http://www.maxmind.com/en/worldcities

Hello,

You can download the drivers you need from the nvidia site at:

http://www.nvidia.com/Download/index.aspx?lang=en-us

In the list select GeForce 6 Series and you can get the latest driver or you can go to the beta and older drivers section and work from there.

So what was wrong with your query other than you tried to select a field Permanentaddress2 that was not listed in the definition you provided or the criteria you listed. Also you are narrowing down to Permanentstate which you did not list in your definition or criteria.

GNS3 is a Graphical Network Simulator that allows emulation of complex networks. You may be familiar with VMWare, VirtualBox or Virtual PC that are used to emulate various operating systems in a virtual environment. These programs allow you to run operating systems such as Windows XP Professional or Ubuntu Linux in a virtual environment on your computer. GNS3 allows the same type of emulation using Cisco Internetwork Operating Systems. It allows you to run a Cisco IOS in a virtual environment on your computer. Dynamips is the core program that allows IOS emulation. GNS3 runs on top of Dynamips to create a more user friendly, graphical environment.

GNS3 also supports other emulation programs, namely Qemu, Pemu and VirtualBox. These softwares are used to emulate Cisco ASA and PIX firewalls, Cisco IPS, Juniper routers as well as hosts (Linux, Windows, Mac OS X, FreeBSD etc.) GNS3 makes all of this emulation magic work together and allow you, for instance, to have your Cisco router talking to your Linux host. The possibilities are almost endless!

GNS3 allows the emulation of Cisco IOSs on your Windows, Linux and Mac OS X based computer. Emulation is possible for a long list of router platforms and other devices. Using an EtherSwitch card in a router, switching platforms may also be emulated to the degree of the card’s supported functionality. This means that GNS3 is an invaluable tool for preparing for Cisco certifications such as CCNA, CCNP and CCIE.

There is a great tool for this called GNS3 or Graphic Network Simulator 3 which will create Virtual Cisco routers and switches that actually uses the cisco or juniper ios. It is licensed under the GNU public license and is available for Linux, Windows and OSx. Works with virtual systems (like gem and virtualbox).

http://gns3.net/

Hello,

How about this instead which is supposed to be the right way to do the query:

    SELECT 
    tbl_class.class_id,
    tbl_class.course_id,
    tbl_class.class_room,
    tbl_course.semester
    FROM tbl_class
    inner join tbl_course on tbl_course.course_id = tbl_class.course_id 
    WHERE tbl_course.semester = '5'

Or back to your original selection change the wording to:

    SELECT *
    FROM tbl_class
    WHERE course_id IN (SELECT course_id FROM tbl_course WHERE semester = '5')

Hello,

I was looking over what you have and what you said you wanted to do and I have a couple of ideas on how to do it but I am a little confused by your wording.

If what you are trying to do is give the min, max or avg response times then you could use something like:

select websites.url,
min(responses.response_time) as 'Minimum Response',
max(responses.response_time) as 'Maximum Response',
avg(responses.response_time) as 'Average Response'
from responses
left join websites on websites.id=responsetable.website_id 
group by website.url

It really depends on what table you start in and I think it will run fast if you run from the responses table and join to get the names like website.url.

The other suggestion I would make is about how you are getting your response times. There is a tool out there called mtr which does a ping and traceroute together for several runs and compiles the results for you showing you where there may be any packet loss along the way. For windows there is winmtr.

I suggest downloading UBCD which is a bootable CD image you can write to a CD and then boot from. It has multiple drive utilities that should do the trick one way or another.

http://www.ultimatebootcd.com/

If you are worried about damaging your current system put the drive back in the system it was in to begin with and run the boot cd from there with no other drives attached.

I would say you will proabably have to wipe the drive with a DOD level drive wipe application in order to be able to use it again.

Unless it is based on the drive being encrypted by the drive bios somehow that should work.

Dani,

That would be a tough choice to make and would depend on what SSD drives are available. I have always heard that SSD drives did not have a great life expectancy if you do a lot of writes to the drives however every site I look at says they are much better now and have the potential to last longer that a standard drive. The problem is that the technology is so new that we don't really have any SSD drives that have been in use for 10 years to examine.
If your running a RAID 5 array your going to get the speed of striped data to and from the array controller by the controller. The company I work for supplies SSD drives and it seems to me that we are replacing a lot of them that have failed and in some cases more than one that failed in an array at a time and we are also doing a lot upgrades to the latest controller firmware due to issues being addressed.

Personally I would say unless you are really in need of much greater speed, go with the SAS array and give the SSD drives time to get out there and get the controller and life expectancy issues fixed.

Hello,

What you need to do is use UNION to merge the output from the two databases and if needed you can sort the out put into one large table intermixed:

Select * 
from 
(select table1.data_field as result1
from table1
UNION
select table2.data_field as result1
from table2) as data1
order by data1.result1

Or something roughly like that depending on the database you are using. UNION puts the results from one query together with the results from a second query provided they have the same names for the result data fields.

To get to the command prompt as administrator go to start accessories and then right click Command prompt and select "Run as administrator" from the menu. Then try your unlock command again.

Hello,

The UID is the user id and it is stored in the /etc/passwd file. Below is a link to a site the explains the format of the date in the file:
http://en.wikipedia.org/wiki/Passwd

Rubberman's suggestions are accurate and correct. I would like to add that you can run what is referred to as a LAMP (Linux, Apache, MySQL, PHP) server with $0.00 cost for the software and you would only have to pay for the virtual or hardware based system. Amazon or SoftLayer are companies that offer Virtual servers on a month to month basis so if you need a larger server at a later date you are not out the hardware costs. There are also hundreds of free php applications that can be used to access the database over the web, depending on what you are trying to accomplish, or you can write your own.

Hello Dani,

Please remeber that this is my opinion however personally I would go with an ASUS or an HP. Dell used to be a quality product but over the past few years (in my opinion) the quality has gone down hill. HP and ASUS make a rugged product that can take knocks and have enough expansion bays to take your security system cards. Levono and Toshiba also make a good product but they both also cost more. Acer makes good laptops but they are new to the desktop market and they also us ASUS boards on some of their systems. ASUS makes a large percentage of HP's boards and have been doing so for longer (about 10 years) than many people realize.

Buying an ASUS you can get the same high quality mother board that you would pay a little more with another brand name on it (HP, Acer, Dell,etc). They also make systems pre-configured with fairly decent video cards. Best Buy Fry's and Tiger Direct all sell a lot of desktop computers and they stock more ASUS and HP than any other brands because they work out of the box and have the lowest return rate. If you want a system that is going to be working still in a couple of years then I say go with an HP or ASUS.

Hope this helps.

Hello,

The databases do not have to be on the same server or the same type of server they must simply have a location that both servers can somehow read and write files to. I do this all of the time working database conversions for companies. Normally I use Perl (or VB) scripts to export the data from one database and import the data to the other. The file delimiters can be based on any unique charactor that is not normally used in your data but CSV files normally work just fine.
First you need to decide what the final server hosting the web site is going to be running and then set up a location for the two servers to write to (Linux Samba, Windows mapped drive, sftp, pscp or scp). If you are only displaying data on the web site and not updating it there then I usually delete the whole table and recreate it prior to importing the data so there is no residue form the previous data. And if you script the exports and imports and you can then schedule them to run from cron jobs or task scheduler several times a day if needed. It also is normally faster to drop a table and import all rows than to test for differences and update rows if needed.
I also suggest that if you have enough room store the export files for a few days or more after you import them. Sometimes you have …

Hello,

I know you mentioned using awk but I thought I would throw this in anyway:

cat myfile.txt | sort -k 1,2 | uniq -w 13

sorts the file by first and second columns (seperated by white space) then prints the unique entries based on the first 13 charactors.

The only way you could double your speed would be to run a separate cable and configure your switch to treat the two ports as one single 2GB port and have two Network ports (bonded) configured on your computer. This is not going to do anything for speeding up you home networks connection to the internet as it is controlled by the speed of your modem. JorgeM is correct that cat5e will work with 1GB networks (Cat 5 will for very short distance) you probably just need to upgrade your switch to a 1GB switch or router and your internal LAN will be much faster. If you have 100MB switch then all traffic is limited to 100MB.

Hello,
So I don't see any issues and which icon are you talking about not looking correct? Your connected via wireless to a router that you don't want us to know the name of (no issue) and showing wired and uireless connections under network connections and it loooks like you are running vmware workstation on your system.

Hello,

What you are referencing is often called a pyramid structure. I have built a few in the past and they can be interesting to code. However that being said the best method I have found to track the items is that every element has an id and a parent id. The parent id references the next unit up in the list. In your exsample there would be the following records:

ID parentId reference_notes
1 0 top of tree
2 1 element
3 1 second element
4 1 element
5 2 sub element
6 2 tree limb
7 4 sub element
8 4 sub element
9 5 sub element
10 5 another sub element
11 7 next level
12 7 next level

then you can track the items back up by starting at 9 and referencing up to 5 that references up to 2 and then 1.
Hope that helps.

If you are just planning on your single web site another option is to get a virtual system through one of the hosting providers. You could purchase a basic virtual system from one of the hosting providers and get started for a very low cost. They will handle the costs of the hardware, electricity, and maintain internet connections 24/7 for a set monthly cost. You will also have support available for setting your site and installing the software on your server.

Some of the considerations for you to run your own server at the office or at home are:

Your ISP is going to charge you a lot more for a true network connection with a fixed IP address and you will be lucky to get a 100MB connection. Most providers give a lower upload rate than a down load rate and you will need a high upload rate for people to be able to view your web site.

The hardware cost is going to be higher for your initial purchase of a server and you have no idea how well your site is going to do.

You will want a system with redundancy so that if any of the parts fail you don't loose your site.

If your site does well and you need a bigger server and faster connection you are going to increase you cost.

You will also have to consider the additional power needed to run the system and keep it cool all year long.