1,073 Posted Topics
 | Hello You are using the syntax for an INSERT statement instead of an UPDATE statement. Update data in mytable1 with data from mytable2 looks like this UPDATE mytable1, mytable2 set mytable1.myfield1 = mytable2.myfield1, mytable1.myfield2 = mytable2.myfield2 where mytable1.item_number = mytable12.gigname If you are posting from php or some other input … |
| | Hello, Not exactly. If I understand you correctly you need to do a couple of things in a specific order to run your backups. Stop some service, then run your backup then restart the service. The easiest way is to create a shell script that does everything then call that …  |
| | Hello, Try a union statement and do two seperate queries : Select column_1 as mycolumn from table1 union select column_2 as mycolumn from table2 |
| | Well you basically have two choices: 1) Go to the Dell Support Web site and enter the service tag off of the computer and download the driver from them. 2) Go to the intel site and download the driver for the 82801FB Chip set and the AC97 audio controller.  |
| | Hello, I see a couple of things that are causing your problem. First of all you are only selecting fields from the child table to be displayed so the join servves no purpose. Try adding a field from the partent table to the output and get the first join providing …  |
| | Hello, Try a backslash in front of the # sign. qw(\#338833 \#33AAAA \#AA33AA \#AA3333 \#3333AA); or if that does not work you could add the # sign when you actually use the data and store just: qw(338833 33AAAA AA33AA AA3333 3333AA); |
| | Hello, This may help. You can save an excel file as a CSV (Comma Seperated values) and then use mysqlimport or the load command. Data files in CSV format contain values that are delimited by commas rather than tabs and that may be quoted with double-quote characters. For example, a … |
| | Hello, The first command you ran (fdisk -l) was perfect for showing the partitions and did give you the information about your drive. The tricky part is you are using some sort of virtual system and not seeing true disks. Your drive (/dev/sda) or device scsi disk a is a …  |
| | Hello, try something like this: #!/bin/bash echo "Input some numbers, separated by a space please:" read -a choice $result=0 for a in `echo $choice` do $result=$result + $a done echo "The result after adding all numbers is: $result " The echo $choice may be off a bit you may need …  |
| | Hello, The having command takes place after the inital query is complete and you need to referr to the fields by the name in the result. try HAVING Month = " & TextBox2.Text &" and it should work. If not post the erorr you are getting.  |
| | Re: Nested variables Hello, You need a backslash to tell the script to escape the normal use of the next character. Try this: `while read line; do echo -e "${"${line:21}"/\//-}"; done < Albums-linux.txt` |
| | In the group by just list the Detail.ProductID. Or if you want it broken down by date then list date and Detail.ProductID. Don't list the quantity. |
 | Did you give the user privileges to access the database projects? |
| | Hello, My first guess is that you have not installed the chipset drivers for your motherboard for Vista. Without them the wifi driver will not be able to communicate with the wifi device through the motherboard. |
| | Hello, It is really very simple but it took me a while to find it too. [CODE]create table newtable SELECT adp.adsPageId,adp.adsSpaceId, DATE_FORMAT(adp.dayClick, '%Y-%m-%d') AS dateReport, (SELECT COUNT(*) FROM ads_display att WHERE att.adsSpaceId = adp.adsSpaceId AND att.adsPageId = adp.adsPageId AND att.dayClick = adp.dayClick) as TotalView, (SELECT COUNT(*) FROM ads_click acc WHERE … |
| | Hello, There are several applications you can purchase that will do this and many of thenm have a free trial version. My suggestion is that you go to one of the sites like CNET downloads where they review the software and post customer reviews of the software and find one …  |
| | Hello, I tried that sshdfilter and found denyhosts to be a much easier application to install and configure. And it works. |
| | Hello, What you are looking for is something like this: [CODE]select artist, count(artist) from mytable group by artist [/CODE]  |
| | Hello, Depending on the version of Excel what you are looking for is normally under the main heading of Data. The option is called "Text to Columns". You need to have an empty column to the right of the current column for every additional column ( in your case 1 … |
| | Hello, Depends on what subnets you are using on each NIC and which NIC you want to be the connection to the internet. The GATEWAY IP is the address the system uses to reach computers not in your subnet (the internet). You can only have one gateway, just like you …  |
| | Hello, This should work provided you have access to the file and directory listed: [CODE]copy "\\ServerNameOrIP\c$\Program Files\Microsoft Sql server\backup\test.bak" C:\backup\[/CODE] |
 | Hello, Well you are running into a couple of things that you really need to think about. The security in the server is such that users from the internet should not be able to start and stop services on the server. If you can start and stop it anybody can. … |
| | Re: PXE Boot Linux Hello, Based on the apt-get entry I am going to direct you towards this site: [URL="http://www.howtoforge.com/ubuntu_pxe_install_server"]http://www.howtoforge.com/ubuntu_pxe_install_server[/URL] |
| | Check your router. They normally have an option for setting one of the systems as a DMZ host. This is the system that will receive all requests from the internet for things like HTTP and FTP. |
| | Hello, The address you are seeing is a default when any network card cannot find the DHCP server properly. I have seen this before with XP and the easy way to fix it is to give the card a fixed address (like 192.168.1.15) on the network, then once connected change …  |
| | You could use a sub-queries to generate the main query. My example is kind of an odd way to accomplish this but it should work. Basically to get this working you run a selection to generate a list of the db_emails that have more than one record. Strip out just … |
| | You need to add a user to mysql for outside access and give it privledges to access the database jqcalendar. I would suggest using a different user than root and only giving access to the database you need to update. In your case I suggest the user name should be … |
| | Hello, Your best bet is to run a HDMI or VGA Video cable (TV's usually have one or the other now a days) to a PC somewhere nearby (there are extender cable of up to 50ft) and run files from the computer. There is a free flash player from Adobe … |
| | Take a look at an application called spamdyke. It does a good job of breaking down how they block spam servers. The source code is there in PERL and you can get a good idea of how it works. It is an add on for qmail under Linux and is … |
 | Hello, On the ports you need available the one I can think of are: 21 ftp 22 ssh 25 smtp (email) 80 http 110 pop3 (email) 115 sftp 143 imap 220 imap2 (email) 443 https 465 smtp SMTP over SSL (TLS) 587 smtp (email - alternate as some ISP's block … |
| | Hello, It really depends on how secure your Apache and PHP installations are configured. There are many options to make PHP more secure and suggested practices for making a site secure. It is possible to lock the system down so that they cannot be read but it is not always … |
| | XP by it's self does not recognise the ext3 filesystem partition so you will need some sort of application that knows about ext3. Unix filesystem utilities for windows, Paragon HD manager, partition magic, etc. |
| | Try this sql statement instead: "SELECT group_id, rec_id FROM RandPtrack where type='R' order by group_id desc limit 1" This will select all records sort them in descending group_id order (with the largest group_id first) and them limit the output to one (the first) record. |
| | Hello, That would depend on what you mean by a new client. Are you referring to a client computer that can access the server as a file server, or a new user that can connect to the server via RDP, or a new client application that can be accessed from … |
| | Hello, Try starting it in safe mode and running your antivirus program from there. As the computer starts to boot start hitting the <F8> key and you will get options for starting windows. One of the options is Start Windows in Safe Mode. This will load the minimum drivers and … |
| | Hello, Can you provide a little more detail about what port you are trying to forward to what IP address inside your router? Port forwarding is normally used when you want the WAN IP address of the router to forward a port to a specific IP inside your local network. … |
| | Hello, Based on what you are trying to do I think you will find that there is a simpler way by using a left or right join. If you left join two tables the output will be every record matching your where statement in the first table and the fields … |
| | Re: Network Timeout Check your network card configuration and see what DNS or name servers you are querying for the information. You can always try adding a public name server (like the one at 4.2.2.2) to your DNS list as a third server to check with. |
 | Hello, Generally speaking a hard drive is a hard drive no matter what packaging it has. The main things you have to watch out for are the interface (SATA, PATA, SCSI, SAS, Fiber-SCSI, etc.) Most external storage systems sold for home or small office use now a days are simply … |
| | It is possible but there are limitations. You have to have directory listings turned on and you have to have a web server like IIS or Apache installed. You don't have to go that route if you share the directory inside windows and limit the users to those with accounts … |
| | Hello, Initialize basically re-formatted the hard. Don't panic. You can recover the partition. If you have another system you can connect the drive to then look for a free program developed for the US Air Force called testdisk (usually packaged with photorec). Testdisk will look at the raw drive and … |
| | Hello, What you are looking for is the fstab or file-system table which is found in /etc . Here is a link to the ubuntu reference page on setting it up: [URL="https://help.ubuntu.com/community/Fstab"]https://help.ubuntu.com/community/Fstab[/URL] |
 | A quick and dirty way to have the two local computers find the linux boxes would be to add entries in the hosts file on the windows systems. Windows uses a file normally located at [CODE]C:\windows\system32\drivers\etc\hosts [/CODE] This is the windows equivalent of the /etc/hosts file on Linux systems. On … |
| | Hello, The first thing I can see is the wait table does not have a field called chat_id so the join will fail there. |
| | Hello, It depends on what you mean by network card. If you are referring to the number of physical cards installed in the computer you would have to look in device manager for the device. This will only show devices that the system has detected to be network cards. If … |
| | I would check to see if the CPU Fan is working. You should feel air coming out the vent on the side or back. They are designed to shut off rather than burn out the CPU. Also try cleaning out any dust from the fan assembly. Normally I use a … |
 | Hello, Try changing the WHERE MAX(Votes) to [CODE]WHERE Votes = (select MAX(Votes) from $portfolio )[/CODE] |
| | Hello, Your problem is the way windows views the hard drive. 298GB is about correct for a 320GB drive. You have to multiply it out to see the correct number. 298.9 X 1024 X 1024 X 1024 = 320941431193.6 320,941,431,193 Bytes or 320 GigaBytes 298.9 times number of MB in … |
| | Hello, Did you add the XP system to the domain and is Server 2003 set up to be a domain controller for the domain? I think the second question is yes if you have set up active directory and added users. If you need to add the xp system to … |
| | Hello, Quick note in case you are not aware of this. The system root user and the MySQL root user are two entirely different accounts and passwords. Even though they are both called root the MySQL password is stored in the application and the system root password is stored in … |
The End.