Computing desk | ||
---|---|---|
< July 16 | << Jun | July | Aug >> | July 18 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
My flatbed scanner power supply (wall wart, 12VDC, 1A) went away. :-(
Any potential problems using a +12V line from my PC's power supply; ground loops, etc?
Thanks. Saintrain ( talk) 00:45, 17 July 2009 (UTC)
I have the font "Kristin ITC" installed on a computer at work but not at home. Work machine is XPH and the home is XPP. Can someone tell me what software app comes bundled with this font? There seem to be several like that but this is a good start I think. Zab Milenko How am I driving? 06:05, 17 July 2009 (UTC)
How can I have the value for a field be calculated automatically based on values in 2 other fields one of which is in the same table and the other in different table? -- 195.244.210.38 ( talk) 09:31, 17 July 2009 (UTC)
( talk) 15:21, 17 July 2009 (UTC)
SELECT a, b, a / b as c FROM Table1;
" and save it as Query1. (Although I've written this as a
SQL SELECT statement, you can do the same with the query designer.) You can then browse Query1 or write another query against it just as if Query1 were a table. You can even save data to columns a and b, and column c will be calculated automatically. --
Tcncv (
talk) 04:32, 18 July 2009 (UTC)
OK then, can someone help me out with a query to pull this off. This is basically what you need to know. Ive got the following tables with the relevent fields in brackets and a brief explanation in square brackets:
Basically, I want someone to be able to make/view any requests with the important feature being that they can select the currency being used (as stock may be coming from a company in a different country and therfore uses a different currency) enter the cost and then have the cost in pounds (GBP) calculated based on information in the Currencies table and entered in the CostInPounds field. Can this be done using queries and if so how as I'm quite new to queries/SQL --|||| —Preceding unsigned comment added by 195.244.210.38 ( talk) 08:25, 20 July 2009 (UTC)
If I have a directory (and I have one) and if I want to compare it to a zip file (and I want to) to know what is different and add or remove stuff from the zip file, what can I do it in Ubuntu? This would be like a simple backup, but it is also useful for other purposes (like packing a set of up-to-date docs).-- Quest09 ( talk) 10:54, 17 July 2009 (UTC)
rsync -av --dry-run /dir-from-zip/ /other-dir/
, it will give you a list of changed files.
Amoe (
talk) 09:18, 24 July 2009 (UTC)Hi everyone, I have another question about php, this time how to ban entire ip address ranges. This is the code I've got so far, but it only works on single ips:
<?php $blockip = array( '123.456.789.123'=> 'block reason', ); //'address'=> 'block reason', foreach($blockip as $key=>$val) {if ($_SERVER['REMOTE_ADDR'] == $key) { die("You are banned because: $val"); } } ?> |
How can I ban entire ranges in php? Thanks for your help! —Preceding unsigned comment added by 82.43.91.128 ( talk) 11:13, 17 July 2009 (UTC)
When restart Firefox 3.5, it restores the tabs from my previous session. It's a great feature and I love it. But one problem is if I have multiple YouTube tabs, it starts playing ALL of them and I have to step through each tab to stop the movie. I don't remember this problem in the past. Is there a way to prevent YouTube movies from auto playing unless it's the frontmost, active tab? -- 70.167.58.6 ( talk) 12:01, 17 July 2009 (UTC)
For years I was happily connected to the net via wired LAN or (olde-worlde) modem. But these days I have to be connected via wireless LAN and I'm acutely aware of not knowing what the pluck I'm doing. The wireless router has instructions in Japanese only, which doesn't help, but I can't make sense of the en:WP articles either.
First, the OS I'm using isn't among those for which the manufacturer (Corega) of the wireless router provides idiot-proof instructions. A sticky label on the router tells me that its SSID or ESSID is such and such and that the "network key" is a certain eight-digit number. The OS wants the SSID (unproblematic) and also either or both of "BSSID" (which it glosses as "Only connect to the station with this hardware address") and "MAC address" (which it glosses as "Override hardware address"). Specifying an address that one then overrides makes no sense to me, or perhaps I should say that it makes even less sense than anything else does. Should I then use "BSSID"? Whichever I choose, I'm to supply it in the format "__:__:__:__:__:__": a twelve-digit number; should I type this in from the left, leaving the rightmost digits blank, or to the right, leaving the leftmost digits blank?
Secondly, is a WPA2/WPA-PSK -protected connection to a given wireless router in any way vulnerable to an unprotected connection to the same wireless router? I really don't care if others are freeloading off my LAN as long as they can't sniff what I'm doing. I did once manage to set up one of these wireless routers, protected and all; but I never could figure out how to disable the bonus unprotected network "cg-guest".
Thank you. -- Hoary ( talk) 12:06, 17 July 2009 (UTC)
I'm unaable to guess the levels of resolution microsoft maps or similar websites possess. When making an image pyramid, How does one decide on the levels of resolution and even the size of an indvidual tile?. Can anybody throw some light please. —Preceding unsigned comment added by 131.220.46.25 ( talk) 13:21, 17 July 2009 (UTC)
My notebook is infected with a weird virus and so I wanted to do a clean format of the HDD and reinstall Windows. Compaq (which btw is now HP) did not give me a recovery disk (which I have used in the past) but instead has a recovery partition on the HDD. How then do I use the partition to reformat and reinstall Vista? Also, will I be able to backup my data before the reformatting is done? I do not want to connect a thumb drive or external HDD to my system to save my data because the external device may also get infected. Help needed. Thanks 116.71.75.2 ( talk) 21:04, 17 July 2009 (UTC)
http://h10025.www1.hp.com/ewfrf/wc/document?lc=en&dlc=en&cc=us&docname=bph07145#bph07145_xp
But this means there isn't an inbuilt option to backup my data. Can anyone give me an idea on how to do this without letting the virus spread to my other devices? Thanks. 116.71.75.2 ( talk) 21:14, 17 July 2009 (UTC)
I am looking for a popular freeware calendar application that I can use. I need one that allows me to create a schedule on one computer, then save it in a file that can be transferred to another computer (with the same app obviously) and then imported into the app on the second computer. Is there an application that will allow me to do this without distorting the original schedule of the second computer's app? 94.7.166.22 ( talk) 21:28, 17 July 2009 (UTC)
does it do everything i need? 94.7.166.22 ( talk) 21:37, 17 July 2009 (UTC)
I think he means that the second computer will have it's own user and they want to share appointments between the two. -- Cameron Scott ( talk) 17:27, 18 July 2009 (UTC)
Hey guys. I'm new with this whole FTP thing. I currently use BulletProof FTP Server v2.3.1. I followed many, many online tutorials and instructions on how to set it up, and I've almost got it... but ran into some problems. First of all, it seems that I'm able to connect to the server fine using PASV mode (I have a dynamic DNS name via No-IP), but for some reason I can't get the LIST working. I'm also a bit confused on some things concerning port forwarding. I think I've got everything forwarded correctly but I'm not too sure... Just to clarify, where do I need to forward ports 20 and 21 to? This question goes the same for the range (I'm using ports 50000-50100). If I need to forward them to the machine hosting BulletProof, how do I do that in my router firewall ( 2Wire 2071) and my software firewall ( PC Tools Firewall Plus)? If there are any questions then ask, and I appreciate as much help as possible! Thanks. Vic93 ( t/ c) 22:31, 17 July 2009 (UTC)
I'm considering buying a second-hand internet gateway or router, because its cheap. How can I find out the technical details of the kind of broadband I'm using please? Do different types of broadband need different types of gateway/router/modem? 89.240.61.156 ( talk) 23:31, 17 July 2009 (UTC)
Computing desk | ||
---|---|---|
< July 16 | << Jun | July | Aug >> | July 18 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
My flatbed scanner power supply (wall wart, 12VDC, 1A) went away. :-(
Any potential problems using a +12V line from my PC's power supply; ground loops, etc?
Thanks. Saintrain ( talk) 00:45, 17 July 2009 (UTC)
I have the font "Kristin ITC" installed on a computer at work but not at home. Work machine is XPH and the home is XPP. Can someone tell me what software app comes bundled with this font? There seem to be several like that but this is a good start I think. Zab Milenko How am I driving? 06:05, 17 July 2009 (UTC)
How can I have the value for a field be calculated automatically based on values in 2 other fields one of which is in the same table and the other in different table? -- 195.244.210.38 ( talk) 09:31, 17 July 2009 (UTC)
( talk) 15:21, 17 July 2009 (UTC)
SELECT a, b, a / b as c FROM Table1;
" and save it as Query1. (Although I've written this as a
SQL SELECT statement, you can do the same with the query designer.) You can then browse Query1 or write another query against it just as if Query1 were a table. You can even save data to columns a and b, and column c will be calculated automatically. --
Tcncv (
talk) 04:32, 18 July 2009 (UTC)
OK then, can someone help me out with a query to pull this off. This is basically what you need to know. Ive got the following tables with the relevent fields in brackets and a brief explanation in square brackets:
Basically, I want someone to be able to make/view any requests with the important feature being that they can select the currency being used (as stock may be coming from a company in a different country and therfore uses a different currency) enter the cost and then have the cost in pounds (GBP) calculated based on information in the Currencies table and entered in the CostInPounds field. Can this be done using queries and if so how as I'm quite new to queries/SQL --|||| —Preceding unsigned comment added by 195.244.210.38 ( talk) 08:25, 20 July 2009 (UTC)
If I have a directory (and I have one) and if I want to compare it to a zip file (and I want to) to know what is different and add or remove stuff from the zip file, what can I do it in Ubuntu? This would be like a simple backup, but it is also useful for other purposes (like packing a set of up-to-date docs).-- Quest09 ( talk) 10:54, 17 July 2009 (UTC)
rsync -av --dry-run /dir-from-zip/ /other-dir/
, it will give you a list of changed files.
Amoe (
talk) 09:18, 24 July 2009 (UTC)Hi everyone, I have another question about php, this time how to ban entire ip address ranges. This is the code I've got so far, but it only works on single ips:
<?php $blockip = array( '123.456.789.123'=> 'block reason', ); //'address'=> 'block reason', foreach($blockip as $key=>$val) {if ($_SERVER['REMOTE_ADDR'] == $key) { die("You are banned because: $val"); } } ?> |
How can I ban entire ranges in php? Thanks for your help! —Preceding unsigned comment added by 82.43.91.128 ( talk) 11:13, 17 July 2009 (UTC)
When restart Firefox 3.5, it restores the tabs from my previous session. It's a great feature and I love it. But one problem is if I have multiple YouTube tabs, it starts playing ALL of them and I have to step through each tab to stop the movie. I don't remember this problem in the past. Is there a way to prevent YouTube movies from auto playing unless it's the frontmost, active tab? -- 70.167.58.6 ( talk) 12:01, 17 July 2009 (UTC)
For years I was happily connected to the net via wired LAN or (olde-worlde) modem. But these days I have to be connected via wireless LAN and I'm acutely aware of not knowing what the pluck I'm doing. The wireless router has instructions in Japanese only, which doesn't help, but I can't make sense of the en:WP articles either.
First, the OS I'm using isn't among those for which the manufacturer (Corega) of the wireless router provides idiot-proof instructions. A sticky label on the router tells me that its SSID or ESSID is such and such and that the "network key" is a certain eight-digit number. The OS wants the SSID (unproblematic) and also either or both of "BSSID" (which it glosses as "Only connect to the station with this hardware address") and "MAC address" (which it glosses as "Override hardware address"). Specifying an address that one then overrides makes no sense to me, or perhaps I should say that it makes even less sense than anything else does. Should I then use "BSSID"? Whichever I choose, I'm to supply it in the format "__:__:__:__:__:__": a twelve-digit number; should I type this in from the left, leaving the rightmost digits blank, or to the right, leaving the leftmost digits blank?
Secondly, is a WPA2/WPA-PSK -protected connection to a given wireless router in any way vulnerable to an unprotected connection to the same wireless router? I really don't care if others are freeloading off my LAN as long as they can't sniff what I'm doing. I did once manage to set up one of these wireless routers, protected and all; but I never could figure out how to disable the bonus unprotected network "cg-guest".
Thank you. -- Hoary ( talk) 12:06, 17 July 2009 (UTC)
I'm unaable to guess the levels of resolution microsoft maps or similar websites possess. When making an image pyramid, How does one decide on the levels of resolution and even the size of an indvidual tile?. Can anybody throw some light please. —Preceding unsigned comment added by 131.220.46.25 ( talk) 13:21, 17 July 2009 (UTC)
My notebook is infected with a weird virus and so I wanted to do a clean format of the HDD and reinstall Windows. Compaq (which btw is now HP) did not give me a recovery disk (which I have used in the past) but instead has a recovery partition on the HDD. How then do I use the partition to reformat and reinstall Vista? Also, will I be able to backup my data before the reformatting is done? I do not want to connect a thumb drive or external HDD to my system to save my data because the external device may also get infected. Help needed. Thanks 116.71.75.2 ( talk) 21:04, 17 July 2009 (UTC)
http://h10025.www1.hp.com/ewfrf/wc/document?lc=en&dlc=en&cc=us&docname=bph07145#bph07145_xp
But this means there isn't an inbuilt option to backup my data. Can anyone give me an idea on how to do this without letting the virus spread to my other devices? Thanks. 116.71.75.2 ( talk) 21:14, 17 July 2009 (UTC)
I am looking for a popular freeware calendar application that I can use. I need one that allows me to create a schedule on one computer, then save it in a file that can be transferred to another computer (with the same app obviously) and then imported into the app on the second computer. Is there an application that will allow me to do this without distorting the original schedule of the second computer's app? 94.7.166.22 ( talk) 21:28, 17 July 2009 (UTC)
does it do everything i need? 94.7.166.22 ( talk) 21:37, 17 July 2009 (UTC)
I think he means that the second computer will have it's own user and they want to share appointments between the two. -- Cameron Scott ( talk) 17:27, 18 July 2009 (UTC)
Hey guys. I'm new with this whole FTP thing. I currently use BulletProof FTP Server v2.3.1. I followed many, many online tutorials and instructions on how to set it up, and I've almost got it... but ran into some problems. First of all, it seems that I'm able to connect to the server fine using PASV mode (I have a dynamic DNS name via No-IP), but for some reason I can't get the LIST working. I'm also a bit confused on some things concerning port forwarding. I think I've got everything forwarded correctly but I'm not too sure... Just to clarify, where do I need to forward ports 20 and 21 to? This question goes the same for the range (I'm using ports 50000-50100). If I need to forward them to the machine hosting BulletProof, how do I do that in my router firewall ( 2Wire 2071) and my software firewall ( PC Tools Firewall Plus)? If there are any questions then ask, and I appreciate as much help as possible! Thanks. Vic93 ( t/ c) 22:31, 17 July 2009 (UTC)
I'm considering buying a second-hand internet gateway or router, because its cheap. How can I find out the technical details of the kind of broadband I'm using please? Do different types of broadband need different types of gateway/router/modem? 89.240.61.156 ( talk) 23:31, 17 July 2009 (UTC)