1,073 Posted Topics
 | 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. |
| | Hello, I agree with mjdodd about it being a physical memory issue. It could one of several things. 1. You have added an application that uses more memory than you used to use. 2. One of your memory chips has failed. 3. You have added memory to the computer and …  |
| | Hello, I would get a copy of testdisk and photorec which are drive recovery tools originally developed by the US Air Force to recover images from drives. They are free for the download and if anything can recover the partitions and files they can.  |
| | Excel will export to either a CSV (comma separated values) or tab delimited file. If you are trying to get data read by excel your best bet is to save it as tab delimited and with a .TXT extension. Excel will automatically import the file when opened with Excel. And …  |
| | 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. |
 | Hello, You were close: sudo apt-get install build-essential |
| | Re: Help with INSERT Make ID an auto-increment integer and a required key and it will fill the field in for you without having to insert it. |
| | In order to be able to see other windows systems from the XP systems you will need to make sure a protocol is loaded on the XP based system. Go to Control Panel, Network Connections the right click on Local Area Connection and then select properties. When the box comes … |
| | concat(table1.field1, table2.field2) as newname |
| | 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. |
| | This is a guess but I bet your problem is you cannot access the data on the drive now in the USB..You don't have permission. If so what you need to do is take owner ship of the folders and subfolders. Take a look at this Microsoft tech tip on …  |
| | What you want is a JOIN [CODE]SELECT `heads.head_name`, `subheads.subhead_name` FROM `heads` OUTER JOIN `subheads` ON `heads`.id = `subheads`.id where `heads.id` = '1' [/CODE] this selects records from heads where `heads.id` = '1'and joins them to subheads records where `heads`.id = `subheads`.id Is that what you were trying to do? |
| | try this: [CODE]update table1, table2 set table1.col1 = table2.col1, table1.col2 = table2.col2, table1.col3 = table2.col3 where table1.col1 = table2.somefield[/CODE] |
| | I am sure there is a module somewhere to do this however the easiest way I can think of is to output the file as a TAB delimited text file. Then either open it with excel and it will automatically load it to columns or right click the file and …  |
 | Smeagle13 is correct but also change your insert so it will ignore the error generated when the duplicate insert is refused: [CODE]INSERT IGNORE INTO TABLE1 WHERE VALUES('3');[/CODE] |
| | What you are looking for is a JOIN. [CODE]SELECT table1.ID, table1.field2, table1.field3, table2.field2, table2.field3, table2.field7 FROM table1 LEFT JOIN table2 on table1.ID = table2.table1_ID [/CODE] Something like this will give you all records in table1 and every matching record in table2 or NULL fields for the records with no match … |
| | Hello, This should help it is from O'Reily's Linix security Handbook. Recipe 5.10 Sharing Files Using Groups 5.10.1 Problem Two or more users want to share files, both with write privileges. 5.10.2 Solution Create a group containing only those users, say, smith, jones, and ling: /etc/group: friends:x:200:smith,jones,ling Create the shared … |
| | Hello, Depending on the BIOS version it is usually either the DEL, F1, F2 or F10 Keys to enter BIOS. Try this, when the system is booting watch the keyboard and the NUM Lock, CAPS Lock and Scroll Lock lights will flash.... as soon as that happens start hitting the …  |
| | Hello, Try this site: [URL="http://phpexcel.codeplex.com/"]http://phpexcel.codeplex.com/[/URL] The boast being able to convert between the two formats among other things/ |
| | There is a .pst file repair tool that comes with Outlook 2007. Don't remember the name but I found it by googleing [B]Outlook .pst repair[/B] and there was a Microsoft tech page on how to use it. |
| | Hello, A couple of things to try. Double check the cabling from where the internet connects to the house all of the way to the router making sure that all of the connections are tight and solid. Check the router and modem for heat and see if one of them …  |
 | 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? |
| | How about: [CODE]#!/bin/bash if [ $# -eq 0 ]; then echo "You must supply a base directory to seach." echo "usage: myscript <dir>" exit 0 fi ls -laR $1 [/CODE] or simply ls -laR /home |
 | In order for apache to access the files the directory and files must be readable by the apache user of group. Normally the owner is the domain login id and the group is apache. Your directory listing should look something like this: [CODE]ls -la /s101-2/home6/camosreptiles/ drwxr-xr-x camosreptiles apache 2048 18:44 … |
| | Wine is just an explorer emulator that simulates explorer.exe. If you want to run an install of the os try Oracle Virtual Box. It runs under XP, Vista, MAC, or Linux and lets you run virtual OS installations of any of the others. It is free. |
| | |
| | Hello, If I am reading the message correctly it is from your email service provider notifying you that the size of your mailbox on the email server is approaching the limit. Outlook allows you to save your email locally (on your computer as opposed to the server). Storing your email … |
| | Re: window 98 Windows versions since I started supporting computers but not including the server versions: Windows 286 Windows 386 Windows 3.0 Windows for Workgroups Windows 3.1 Windows 95 Windows 98 Windows NT Windows 2000 Windows ME Windows XP Windows Vista Windows 7 |
| | Hello, A couple of comments from someone who had created a couple hundred CD's over the years. 1. Use the CD-R's and fill them with photos based on a common date or theme. Do not attempt to write more than once to a CD. It may work but the chances … |
 | 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 … |
 | Check the speed of your network cards. I am willing to bet that PC1 has a 10MB card in it. |
| | Setting up your own email server for the first time can be pretty tricky. Personally I like to use a Linux server and qmail with the addition of SPAMDYKE. There are some excellent scripts to setup the server for you and include anti-spam and anti-relay settings at the following web … |
| | Re: File Systems Hello, No matter what you can always take ownership of a file as an administrator or member of the administrators group. Doing drive recoveries I work with files that were created on another computer and with users I do not have. As the administrator of my computer I can go … |
| | Re: IF... THEN ... Hello, Just curious what your notifications table looks like? It could be due to one of the fields being set for NOT NULL or something. If the first field is an auto-increment ID field then use '' instead of NULL for the value. |
| | Where are you trying to download the SP1 file from (URL)? What browser are you using to do the download with and what is the heading from the dialogue box that is giving you the error? Are you saving the file or opening it and have you tried saving it … |
 | Hello, This is quick and dirty since I don't know the real field names or table name but something like this should work: [CODE]select left(`date`,7) as 'Year-Month', sum(income) as Monthly_Income, sum(expenses) as Monthly Expenses from mytable group By 'Year-Month' [/CODE] You should get a monthly total on each line. |
| | Hello, You would need to boot from your installation disk. How to tell you what to do next will depend on the actual version of Windows you are running. Can you provide more information on what you mean by explorer crashes and what version of windows is it? The best …  |
| | There are several free utilities that will copy it for you. I suggest that you download and generate UBCD4WIN (Ultimate Boot CD For Windows). It uses your OS to create an image of a CD that you can burn to a CD and boot from. It gives you applications to … |
| | 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.  |
| | look at the apache logs and find out the location of the page being called. You test site needs to have an index.html or index.htm page and it will replace the default page. |
| | Ok first are we talking Linux or windows shell? |
| | Can you post the error message you get when you try to access the pages. Also review the httpd logs on the server. |
| | It is probably interference from something in your house. The cordless phones sold that run in the 900MHz range can cause interference and having the wireless card antenna to close to a floor can cause problems. Wireless systems use a very short frequency that can actually reflect and interfere with … |
| | I think what you are trying for is where r1 = standard and the status is either NTC or In Progress. If so try this: [CODE]SELECT * FROM installs WHERE r1 = 'Standard' AND (STATUS = 'NTC' OR STATUS = 'In Progress') ORDER BY building, appointment_date ASC[/CODE] |
 | Ok with a relational database you create a table to hold a specific piece of information. The link the information in the tables together with the record IDs for the information in the other tables. I would create 4 tables projects, users, skills, user_rating [CODE] Projects ID int 11 primary … |
| | 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. |
 | Re: SQL Date? MySQL uses the system time but makes adjustments for UTC. UTC (Coordinated Universal Time) is an atomic timescale that approximates UT1. It is the international standard on which civil time is based. Universal time is a timescale based on the rotation of the Earth. It is a modern continuation of … |
 | Re: Ethernet Cable You want cat5e if at all possible, especially if you plan on having gigabit Ethernet switches or NICs. And here is why: The Simple Answer: CAT-5 is rated to 100M CAT-5e is rated to 350M CAT-6 and CAT6e is rated to 550M or 1000M depending on your source CAT-7 is … |
| | The only thing I can think of is that the second SATA port is not enabled in CMOS setup. On some mother boards you have to tell the BIOS that there is now a drive conneted and then if will probe the cable. With SATA there is no primary-secondary like … |
The End.