Computing desk | ||
---|---|---|
< February 19 | << Jan | February | Mar >> | February 21 > |
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. |
Hello. Whenever I print in colour using a refilled cartridge, the document has a green hue. How should I fix that if I do not want to buy a new colour ink cartridge? Thanks in advance. -- Mayfare ( talk) 00:52, 20 February 2008 (UTC)
If my cartridge cannot accept anymore magenta ink, then what should I do? -- Mayfare ( talk) 22:00, 20 February 2008 (UTC)
I'm looking at laptops, and I get this option:
Whats the difference, and which is better? 00:55, 20 February 2008 (UTC)
Thanks for the help on the previous question. I have one more. These processors come standard
These are $40 more:
Which should I get? HYENASTE 01:29, 20 February 2008 (UTC)
OK maybe Data transfer rate? surely, the L2 has a greater data transfer rate than the RAM? Kushal 22:01, 20 February 2008 (UTC)
The T8300 would be a better choice. It is based on the 45nm Penryn core, which has some minor performance improvements as well as running cooler. That last part will allow for increased battery life. The increased clock speed will also help, and although the cache size is smaller, there will be better battery life. The performance will probably be pretty close. --
Imperator3733 (
talk) 16:58, 21 February 2008 (UTC)
I'm writing a quick and dirty search engine for an in-house database. I'm trying to implement full-text searching with MySQL. I've got a function that will generate queries like this:
SELECT id FROM documents WHERE ((documents.title LIKE "%search terms%") OR (documents.pdf_notes LIKE "%search terms%") )
Which works great. Now I'd like to make it also search some other tables. In this case, "documents" has a primary key of "id"; another table, "authors" has a field of "name" and a field of "id"; the many-to-many relationship is maintained by a linking table called "link_documents_authors" that has a field "document_id" (primary key from the "documents" table) and a field for its corresponding "author_id" (primary key from the "authors" table). Make sense? Nothing too non-standard there.
How do I integrate searching of "author.name" into the sort of search above? Is it a good idea? I've learned to fear JOIN queries over the years but maybe this is a good time to get into them? -- 98.217.18.109 ( talk) 02:25, 20 February 2008 (UTC)
JOIN
clauses, you invest in a good introduction to SQL and start making more powerful queries.INNER JOIN
s seem perfectly appropriate - if you did a SELECT * FROM
with no WHERE
clause, you'd still get all your documents, along with their authors. If there is a chance that some documents have no authors, you'd simply use a LEFT JOIN
instead of each INNER JOIN
- meaning that the left-most table (documents
) always gets returned, but the "right" side of the join (link_documents_authors
in join 1, and authors
in join 2) may or may not. A SELECT * FROM
would show any author-less documents with a bunch of NULL
s for the author details.SELECT * FROM
will show you why: each document has to have a row with the details of each of its authors. The easiest way, in this case, is to use SELECT DISTINCT d.id
, which is a kind of short-hand for SELECT d.id ... GROUP BY d.id
.Following with my previous question, I tried what was instructed on Microsoft's homepage about creating sharing folders. I have followed all the steps, but on my Vista laptop, I cannot "see" my xp machine in the networks center. On my XP machine, I can see the Vista machine, and I can even access it, but when I try to access the folders in it, I says that "Access is Denied". I am an admin on both machines and took all the password protected file sharing setting off. What should I do? Acceptable ( talk) 02:50, 20 February 2008 (UTC)
I recently came across this symbol:
่
It looks very much like an apostrophe. However, when placed before a message in Windows Live Messenger, it makes the font super-big. Could anyone tell me what symbol it is and how I can get the alt + xxxx combination for it? Thanks. Acceptable ( talk) 03:00, 20 February 2008 (UTC)
how can i find census information or demographics for Summit, California? Boomgaylove ( talk) 04:01, 20 February 2008 (UTC)
how about the zip code? Boomgaylove ( talk) 05:35, 20 February 2008 (UTC)
this is my imei and i cant generate a new security code that works.its an 1110 nokia.what cud be the problem help?354572018159830 —Preceding unsigned comment added by 212.49.74.168 ( talk) 12:48, 20 February 2008 (UTC) country being-kenya network-safaricon —Preceding unsigned comment added by 212.49.74.168 ( talk) 13:05, 20 February 2008 (UTC)
yes, it's me again. i have another problem. Supposing right I had something on my computer that only played sounds saved as Whatever.wav, and I had something I wanted to listen to saved instead as Whatever.ASF, is there any way of converting from one form to the other,and how do I do that? HS7 ( talk) 17:27, 20 February 2008 (UTC)
Actually it seems likely that it will also play Whatever.wma, if that's easier to change it to. And maybe some other things like that. HS7 ( talk) 17:33, 20 February 2008 (UTC)
OK, I've downloaded that, like you said, and, well, now what do I do with it? Sorry, i can't seem to work out how to actually convert from one thing to the other. HS7 ( talk) 19:17, 20 February 2008 (UTC)
does anybody but me have this problem? I've never seen it mentioned anywhere. this has been happening to me with IE6 on XP with 500 meg membory, now same deal with IE7 on vista and 3 gig of memory, so i think there's something wrong. i'll be doing a lot of Internet Exploring, opening a lot of sites, (not all at the same time, I mean over a few hours), saving files, etc. after a while, IE starts not functioning correctly; right click menus won't open typically, first sign. then, "save as" starts to not save; then "save as" starts bringing up empty box. finally links, open menu, etc. don't work. only fix is to close out all IE windows and start over. at first i thought maybe it was the history was somehow being saved in memory and filling it up, but deleting the history doesn't help, i still have to close IE. so, what's filling up that's clogging IE? TIA. Gzuckier ( talk) 20:08, 20 February 2008 (UTC)
Yep, Mozilla Firefox is definitely the way to go. Rediscover the web, Gzuckier. Use Mozilla Firefox. Mozilla Firefox 2.0.0.12 is great and just as you sit to meditate about the free browser, you might discover what is in store with Firefox 3 (releasing in the first half of 2008)! (Please feel free to bring up any issue, although it is unlikely that there will be one, on the reference desk. If you have a good reason for sticking to MS Internet Explorer, just leave us a line, and please come back here for a better solution. ) Kushal 21:52, 20 February 2008 (UTC)
One question, Gzuckier. Do you have this problem when visiting a particular website or a set of particular websites? I know that at least some websites try to impose restrictions on right clicking so that might be a reason. If you were on Mozilla Firefox, I would suggest using NoScript on such websites. Oops ... the same sales pitch again =P Kushal 21:56, 20 February 2008 (UTC)
Computing desk | ||
---|---|---|
< February 19 | << Jan | February | Mar >> | February 21 > |
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. |
Hello. Whenever I print in colour using a refilled cartridge, the document has a green hue. How should I fix that if I do not want to buy a new colour ink cartridge? Thanks in advance. -- Mayfare ( talk) 00:52, 20 February 2008 (UTC)
If my cartridge cannot accept anymore magenta ink, then what should I do? -- Mayfare ( talk) 22:00, 20 February 2008 (UTC)
I'm looking at laptops, and I get this option:
Whats the difference, and which is better? 00:55, 20 February 2008 (UTC)
Thanks for the help on the previous question. I have one more. These processors come standard
These are $40 more:
Which should I get? HYENASTE 01:29, 20 February 2008 (UTC)
OK maybe Data transfer rate? surely, the L2 has a greater data transfer rate than the RAM? Kushal 22:01, 20 February 2008 (UTC)
The T8300 would be a better choice. It is based on the 45nm Penryn core, which has some minor performance improvements as well as running cooler. That last part will allow for increased battery life. The increased clock speed will also help, and although the cache size is smaller, there will be better battery life. The performance will probably be pretty close. --
Imperator3733 (
talk) 16:58, 21 February 2008 (UTC)
I'm writing a quick and dirty search engine for an in-house database. I'm trying to implement full-text searching with MySQL. I've got a function that will generate queries like this:
SELECT id FROM documents WHERE ((documents.title LIKE "%search terms%") OR (documents.pdf_notes LIKE "%search terms%") )
Which works great. Now I'd like to make it also search some other tables. In this case, "documents" has a primary key of "id"; another table, "authors" has a field of "name" and a field of "id"; the many-to-many relationship is maintained by a linking table called "link_documents_authors" that has a field "document_id" (primary key from the "documents" table) and a field for its corresponding "author_id" (primary key from the "authors" table). Make sense? Nothing too non-standard there.
How do I integrate searching of "author.name" into the sort of search above? Is it a good idea? I've learned to fear JOIN queries over the years but maybe this is a good time to get into them? -- 98.217.18.109 ( talk) 02:25, 20 February 2008 (UTC)
JOIN
clauses, you invest in a good introduction to SQL and start making more powerful queries.INNER JOIN
s seem perfectly appropriate - if you did a SELECT * FROM
with no WHERE
clause, you'd still get all your documents, along with their authors. If there is a chance that some documents have no authors, you'd simply use a LEFT JOIN
instead of each INNER JOIN
- meaning that the left-most table (documents
) always gets returned, but the "right" side of the join (link_documents_authors
in join 1, and authors
in join 2) may or may not. A SELECT * FROM
would show any author-less documents with a bunch of NULL
s for the author details.SELECT * FROM
will show you why: each document has to have a row with the details of each of its authors. The easiest way, in this case, is to use SELECT DISTINCT d.id
, which is a kind of short-hand for SELECT d.id ... GROUP BY d.id
.Following with my previous question, I tried what was instructed on Microsoft's homepage about creating sharing folders. I have followed all the steps, but on my Vista laptop, I cannot "see" my xp machine in the networks center. On my XP machine, I can see the Vista machine, and I can even access it, but when I try to access the folders in it, I says that "Access is Denied". I am an admin on both machines and took all the password protected file sharing setting off. What should I do? Acceptable ( talk) 02:50, 20 February 2008 (UTC)
I recently came across this symbol:
่
It looks very much like an apostrophe. However, when placed before a message in Windows Live Messenger, it makes the font super-big. Could anyone tell me what symbol it is and how I can get the alt + xxxx combination for it? Thanks. Acceptable ( talk) 03:00, 20 February 2008 (UTC)
how can i find census information or demographics for Summit, California? Boomgaylove ( talk) 04:01, 20 February 2008 (UTC)
how about the zip code? Boomgaylove ( talk) 05:35, 20 February 2008 (UTC)
this is my imei and i cant generate a new security code that works.its an 1110 nokia.what cud be the problem help?354572018159830 —Preceding unsigned comment added by 212.49.74.168 ( talk) 12:48, 20 February 2008 (UTC) country being-kenya network-safaricon —Preceding unsigned comment added by 212.49.74.168 ( talk) 13:05, 20 February 2008 (UTC)
yes, it's me again. i have another problem. Supposing right I had something on my computer that only played sounds saved as Whatever.wav, and I had something I wanted to listen to saved instead as Whatever.ASF, is there any way of converting from one form to the other,and how do I do that? HS7 ( talk) 17:27, 20 February 2008 (UTC)
Actually it seems likely that it will also play Whatever.wma, if that's easier to change it to. And maybe some other things like that. HS7 ( talk) 17:33, 20 February 2008 (UTC)
OK, I've downloaded that, like you said, and, well, now what do I do with it? Sorry, i can't seem to work out how to actually convert from one thing to the other. HS7 ( talk) 19:17, 20 February 2008 (UTC)
does anybody but me have this problem? I've never seen it mentioned anywhere. this has been happening to me with IE6 on XP with 500 meg membory, now same deal with IE7 on vista and 3 gig of memory, so i think there's something wrong. i'll be doing a lot of Internet Exploring, opening a lot of sites, (not all at the same time, I mean over a few hours), saving files, etc. after a while, IE starts not functioning correctly; right click menus won't open typically, first sign. then, "save as" starts to not save; then "save as" starts bringing up empty box. finally links, open menu, etc. don't work. only fix is to close out all IE windows and start over. at first i thought maybe it was the history was somehow being saved in memory and filling it up, but deleting the history doesn't help, i still have to close IE. so, what's filling up that's clogging IE? TIA. Gzuckier ( talk) 20:08, 20 February 2008 (UTC)
Yep, Mozilla Firefox is definitely the way to go. Rediscover the web, Gzuckier. Use Mozilla Firefox. Mozilla Firefox 2.0.0.12 is great and just as you sit to meditate about the free browser, you might discover what is in store with Firefox 3 (releasing in the first half of 2008)! (Please feel free to bring up any issue, although it is unlikely that there will be one, on the reference desk. If you have a good reason for sticking to MS Internet Explorer, just leave us a line, and please come back here for a better solution. ) Kushal 21:52, 20 February 2008 (UTC)
One question, Gzuckier. Do you have this problem when visiting a particular website or a set of particular websites? I know that at least some websites try to impose restrictions on right clicking so that might be a reason. If you were on Mozilla Firefox, I would suggest using NoScript on such websites. Oops ... the same sales pitch again =P Kushal 21:56, 20 February 2008 (UTC)