Thanks a lot Mycroft.

Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Hi everyone, this question may seem dumb, so sorry beforehand - I'm just starting to learn SQL :) I want users to be have the address book (set of name/e-mail pairs) in my web application. To do this, I've created a db with 2 tables:

/* User info: */

CREATE TABLE `users`
(
`id` integer (12) NOT NULL AUTO_INCREMENT,
`name` varchar (50) UNIQUE NOT NULL,
`email` varchar (100) NOT NULL,
`password` varchar (50) NOT NULL, /* md5 of password */
PRIMARY KEY (`id`)
)
CHARACTER SET utf8 COLLATE utf8_general_ci;

/* Table with address info: */

CREATE TABLE `addresses`
(
`name` varchar (50) NOT NULL,
`email` varchar (100) NOT NULL,
`userid` integer (12) NOT NULL /* id of user (from the 1st table) that stored this record */
)
CHARACTER SET utf8 COLLATE utf8_general_ci;

First question: is this a good db structure? Second question: what SQL query (join?) I must perform for user with name "name" to retrieve all his address records? Thank you in advance.

Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

i all, I want to create an item in the "text-selection" context menu (context = 0x10) of MS IE. I want the title of this new item to include the text selected: "MySearch " Standard menu extension procedure for MS IE: http://msdn.microsoft.com/en-us/library/aa753589(VS.85).aspx doesn't allow this. I have tried to find a working sample, but googling/searching through the forums for a whole day didn't help. Can you please provide me with an advice/sample? Thank you very much in advance.

Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

El Corazon wrote:

I can't even imagine those first two (last on your message) matching up with this statement

These were the numbers for a single project. At any given time, I have 2 or 3 jobs running. Got the point? :)

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Site is up, thanks everyone.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Paul Watson wrote:

1. Are you making a living off of it or is this part-time work?

Yes, I'm making my living with RaC jobs.

Paul Watson wrote:

2. 30 projects is a lot. How big and long is an average project? 1 month? 2 months?

Average first project - less that a week. Average next projects (after you're proven reliable to the buyer) - about 1 month.

Paul Watson wrote:

3. What, on average, do you get paid per hour for the work?

I'm paid per-project, not per-hour. First project (see above) - usually less than $100 ($70 on average). Next projects - $500+. I'm a C/C++/ASP.NET/Javascript developer.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

You're right... partially. 1st part is correct :)

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

thanks

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Great :)))

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Paul Watson wrote:

You have used it successfully?

Yes, I've made ~30 projects there, and got only 10/10 score from buyers :)

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Thanks anyway.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

:) The loss is that it is the biggest freelancer's refuge on the net.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Strange... can you please ping it? what ip?

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Hi everyone. Several hours ago the site RentACoder.com (the biggest freelancing site) disappeared for me - I mean that I can't enter the site. All browsers I try say that server drops the connection. Can please anyone try? (just try to load the www.rentacoder.com) Thanks in advance.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Oops! Thanks a lot. BTW, is there a server.HTMLDecode method?

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

server.htmlencode is a .NET method; is there a way to make it in a ordinary (non-.NET) VB and ASP?

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Hi everyone, In the ASP page, I store the output (in the form of html strings) from the rich-text editor in a database; when time comes, I retrieve the required HTML string (I use VB as a server-side language) (htmlCode variable.) The I wish to pass this htmlCode to some JavaScript function:

<body onload="populateWithHTML('<%=htmlCode%>')">

BUT! Here is the problem. This html string can contain " (quote) and ' (apostrophe) symbols, that break the resulting HTML. How should I fix this? Thank you much in advance!

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Ok, this variant does work :) But what to do with the original code? Does it work in the Safari 2?... Thanks anyway.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Hi everyone! I have a html page with an IFrame; and the following code:

var doc = document.getElementById("iframe_id").contentDocument;
doc.body.innerHTML = htmlCode;

This code is run in body's onload handler. 'htmlCode' contains some (very simple) html (it is a string, of course). I was able to test this code only in Safari 1.3 (Mac), and it didn't work :( BUT: I need to test it in a Safari 2.0.4. Unfortunatelly, I don't have access to it. Anyone (with Mac) can tell me if it will work? And why the above code didn't work with Safari 1.3? Is it possible to fix it? Thank you very much in advance! P.S. I understand it is a MS-centric forum, but... I do hope.

------------------------- Listen up! "Teamwork" means staying out of my way! (Seifer, Final Fantasy 8).

Rage wrote:

So you sometimes log out from CP ?!

My Firefox cleans all private data on exit. It's called "privacy" ;)

------------------------- Listen up! Teamwork means staying out of my way! (Seifer, Final Fantasy 8).