User talk:Phydaux

From Wikipedia, the free encyclopedia

Hello Phydaux! Welcome to Wikipedia! Thank you for your contributions. If you decide that you need help, check out Getting Help below, ask me on my talk page, or place {{helpme}} on your talk page and someone will show up shortly to answer your questions. Please remember to sign your name on talk pages by clicking or using four tildes (~~~~); this will automatically produce your name and the date. Finally, please do your best to always fill in the edit summary field. Below are some useful links to facilitate your involvement. Happy Editing! Fuhghettaboutit 23:35, 2 November 2006 (UTC) Getting Started Wikipedia Tutorial • The five pillars of Wikipedia How to: edit a page • upload an image Getting Help Frequently Asked Questions Where to ask questions or make comments Request administrator attention Policies and Guidelines Neutral point of view • Reliable sources Verifiability • Citing sources • No original research What Wikipedia is not • Biographies of living persons Manual of Style • Three-revert rule • Sock puppetry Copyrights • Fair use • Image use policy External links • Spam • Vandalism Deletion policy • Conflict of interest • Notability The Community Build consensus • Resolving disputes Assume good faith • Civility • Etiquette No personal attacks • No legal threats Community Portal • Village pump Signpost • IRC channels • Mailing lists Things to do Be bold in editing • Help develop an article Pages needing attention • Peer review Join a WikiProject • Translating articles Cleaning up: General • Spam • Vandalism Miscellaneous Useful templates (Userpage Templates) • Categories • Stubs User pages • Talk pages Tools • User scripts

[edit] PC Gamer citations

I've created the text that you'll need to add a citation, just copy the contents of each box and paste it at the end of the appropriate text. The References section is already there so the rest will be automatic.
There are some citation templates here that are cut and paste. - X201 23:04, 7 November 2006 (UTC)

<ref>{{Harvard reference 
| Surname=
| Given=
| Authorlink=
| Title="Article originally shipped with a floppy disk" 
| Journal=PC Gamer 
| Volume=1 
| Issue=11
| Year=1994
| Page=5
| URL= }}</ref>

<ref>{{Harvard reference 
| Surname=
| Given=
| Authorlink=
| Title="First CD Gamer included content from previous floppies" 
| Journal=PC Gamer 
| Volume=1 
| Issue=11
| Year=1994
| Page=15
| URL= }}</ref>

[edit] Goths and emos

In the message you left on my improve me page, you claimed I attacked goths and emos, I did not, I merely analysed the situation, it wasn't flattering to htem, but then, if thats the way it is, thats the way it is. I didnt say one derogatory or bad word against them (bar unoriginal, but if you take offence from that you are somewhat touchy) so really, I think you should reviwe your comments. Philc _T^E_C^I 18:02, 12 November 2006 (UTC)

Calling groups of people incapable of original thought and unoriginal counts as an attack in my books, especially when they see that as one of their defining characteristics. It seemed that you waited for the smallest of opportunity to voice your views on two groups of people. You say you analysed a situation, but there was no situation being discussed until you added your comment. It is never the words that offend but the tone and situation they are used in. I believe you are smart enough to know what you were saying and how it would have been interpreted by others, that is why I added my comments to your improvement page. If you genuinely didn't mean to offend you should take this as an opportunity to think more about how your words could be interpreted by others. I'm sure there are many forums on the net where you can discuss your views on goths and emos with others, the wikipedia reference desk isn't the place, especially if they are just looking for a name for a band. --Phydaux 20:49, 12 November 2006 (UTC)

[edit] Database conversions

You recently replied to a question of mine at the Reference desk for computing:

In a SQL query you could use: SELECT "[[" & [Field1] & "]] by [[" & [Field2] & "]]" AS Expr1 FROM Table1; and then just export the query results as a text file. (I would assume Microsoft Database has the functionality to create a SQL query.) --Phydaux 14:35, 7 January 2007 (UTC)

I have tried to find an SQL querying program on my computer to use for my task, but was unable to find something to do so. I noticed that you have Windows XP (which is what I have) and might be able to tell me how to do this, if possible. Thanks for your help! --WillMak050389 23:59, 8 January 2007 (UTC)

I had a look at MS Works Database functionality and it doesn't look like it has SQL querys (I assumed it would).

If you are able to copy the data to a spreadsheet program you could use the formula ="[[" & A2 & "]] by [[" & B2 & "]]" in column C. This is assuming that A2 & B2 are the first row of data in the spreadsheet and you would copy the formula down to the last row. Then the formula result's would be the data you were after.

If you have more than 65536 rows of information (The most Excel/Calc can hold) it would be better to use a database program, like Base or Access, which is a bit more long-winded.

Let me know how you get on. --Phydaux 22:46, 9 January 2007 (UTC)

Thanks, I never thought to use a spreadsheet, but I'm pretty sure I know how to do it now. Thanks for your help again, I don't have time to do it now (big Chem paper due tomorrow), but I will notify you when I get finished (or get stuck). --WillMak050389 02:57, 10 January 2007 (UTC)

I figured it out, but it was kind of annoying to enter it in for each item, but the page should be up soon: http://www.lyricwiki.org/User:WillMak050389/My_Songs (Still not finished though). Thanks for your help! --WillMak050389 03:05, 11 January 2007 (UTC)