General discussion

Locked

TechFront

By Sawan Gupta ·
Tags: Off Topic
blog root

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Freelancing - Working Online and Making Money

by Sawan Gupta In reply to TechFront

<p>Being a Graduate student, I had
keen interest in development work. I always wanted to get involved in various
types of projects. And it is always nice if you can make some money out of the
projects you do.</p>


<p>Then I came across two such
websites through which I could get what I was looking for.</p>


<ul><li><a href="http://www.rentacoder.com">RentACoder</a></li><li><a href="http://www.scriptlance.com">Scriptlance</a></li></ul>


<p> <br />These websites provides
opportunities to developers worldwide to get their hands on various types of
projects that are of interest to them. Well that?s not as easy as it seems. To
get a project you need to make a bid (Yes, make a Bid). The buyer reviews the
bid by various people, sees their portfolios before accepting the bid. Now how
to get a good rating at such a site? Well, you can get a rating directly from
the buyer only after completing a project. A buyer may rate you from 1-10 (10
being best) after he accepts the complete project.</p>

<p> </p>

<p>But about payment, which is an
important factor that drives people there. These sites provides us with various
option such as a Wire Transfer, Direct cheque, Paypal Transfer, etc. (Check the
respective sites for details). Personally I prefer Paypal, since it is fast and
easy. After receiving the payment using Paypal, I can do online shopping also.
(Now that?s cool). Most of the sites accept payment through Paypal.</p>


<p> <br />What is the guaranty that I will
receive the payment from my Buyer? Well sometimes a dispute may occur, whether
a buyer may refuse to accept the deliverables or the coder may be unable to
complete the work on time. In such cases, RentACoder has an arbitration
mechanism in which the arbitrator looks into the details of the project and the
deliverables and makes a decision. And the person who looses the arbitration
gets a bad rating. So, it is generally advisable that people use Escrow as
payment option so that money is safe for both ? the buyer and developer.</p>

<p> </p>

<p>All this seems easy, but now I?ll
say about the most difficult part. How to get your bid accepted? Plenty of
people bidding for a project with different amount and time duration. Well, it
depends on your current rating, your existing work, bidding amount and of
course LUCK.</p>


<p> <br />What does these websites get by
providing this facility? Registration is generally free for the developers (I
don?t have any buyer account).  Well they
deduct a percent of the bidding amount to keep themselves going on.</p>

<p>These days there are many
different sites coming up with similar idea. A simple search leads to ? <a href="http://www.elance.com/">www.elance.com</a>, www.getafreelancer.com, <a href="http://www.getacoder.com/">www.getacoder.com</a>, <a href="http://www.indianlance.com/">www.indianlance.com</a>, etc</p>


<p>Happy Bidding !!!</p><p>(P.S. - I might be wrong, but thats just my opinion. This is my first blog post, will post soon more on current research areas - Grid Computing)</p>

Collapse -

SQL Lesson Learnt - Reserved Keywords

by Sawan Gupta In reply to TechFront

I ran into a petty trouble with SQL today which took me almost 3 hours to solve.<br /><br /><br />I was working on a Web Application for a client. Everything was going fine, except for two pages that were misbehaving in the SQL Query. (I am using MS Access 2003 as a test database)<br /><br /><br />Query was pretty straighforward:<br /> <br /><ul><li>select * from <strong>language</strong></li><li>select * from tutor where <strong>language</strong> like 'English'</li></ul><br />The ASP page gave me the message "<strong>Undefined error</strong>.". I kept scraching my head for nothing. At last I solved the issue by renaming the table name to "laguagetbl" and field name to "languagefld". That was the trick which solved the "Undefined error". I wish if there was some user friendly error message.<br /><br />It took me so much time find out that "language" was a reserved keyword.<br /><br />My Advise is be careful while keeping the table names and field names in your database. You never know when trouble is waiting.<br />

Collapse -

SQL Lesson Learnt - Reserved Keywords

by techrep In reply to SQL Lesson Learnt - Reser ...

<p>I use a system where I append a two-character extention on every column name such as</p>
<p>Tx - Text255</p>
<p>Tm - Text64k</p>
<p>Ni - Number Integer</p>
<p>On - Date/Time</p>
<p>Is - Boolean</p>
<p>For table names, I HATE this idea of tbl_tablename.  It is stupid like DD-MM-YY and MM-DD-YY is stupid.  99% of tables I tend to end with an "s".  What happened to you would never happen to me because my statements would be:</p>
<p>SELECT * FROM Languages;</p>
<p>SELECT * FROM Tutors WHERE LanguageTx='English';</p>
<p>Good luck!</p>

Collapse -

SQL Lesson Learnt - Reserved Keywords

by Sawan Gupta In reply to SQL Lesson Learnt - Reser ...

Ya, thats a nice way. Use of Prefix/Suffix seems to be an easy way to stay away from these petty troubles.

Collapse -

Changing Page across Frames through ASP

by Sawan Gupta In reply to TechFront

During the development of ApplyTeacher.com, I had a requirement to change the webpage in a different Frame. (After successful Login, the menu in top frame needs to be refreshed so as to change Login to Logoff). Also the login page needs to be redirected to the user page.<br /><br />The following code did the trick<br /><br />response.write(vbCrLf & "<script>" & vbCrLf)<br />response.write("parent.frames['<frame-name>'].location.href='<page-url>';" & vbCrLf)<br />response.write("</script>" & vbCrLf)<br /><br />Replace the <frame-name> with actual frame name and <page-url> with actual page url.<br /><br />This helped me to change the webpage in another frame and for the current frame (through which the user logged in), I simple used used response.redirect to send the user to his account page.<br /><br />This script works fine in Internet Explorer 6 and Firefox 1.5 but it should work on all browsers.<br /><br />

Collapse -

Displaying Records in Random Order using ASP

by Sawan Gupta In reply to TechFront

One of my client had a requirement of displaying a list of Products in a <strong>Random Order</strong>. He had around 50 products which he wanted to display on the same page but the products should appear in random order each time the page is refreshed.<br /><br /><br />Here is the code which I used, to do the work<br /><br /><%<br />Dim rs<br />Dim ctr<br />Dim cnnstr<br />Dim cnn<br />cnnstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("products.mdb") & ";"<br />set cnn = Server.CreateObject ("ADODB.Connection")<br />cnn.Open cnnstr<br /><br />set rs=Server.Createobject("Adodb.Recordset")<br />rs.open "SELECT * FROM Products",cnn,1,1<br />ctr=rs.RecordCount<br /><br /><br />Dim a1<br />ReDim a1(ctr)<br /><br />Do Until ctr = 0<br />    Randomize<br />    rnd_no = Int(Rnd*rs.RecordCount) +1<br />    ctr=ctr-1<br />    if rnd_no>rs.RecordCount then rnd_no=1<br />    rs.MoveFirst<br />    rs.move rnd_no<br />    if a1(rnd_no)=1 then<br />            while a1(rnd_no)=1<br />            rnd_no=rnd_no+1<br />            if not rs.eof then rs.MoveNext<br />            if rnd_no>rs.RecordCount then<br />                rnd_no=1<br />                rs.MoveFirst<br />            end if<br />            wend<br />    end if<br />    if not rs.eof and not rs.bof then<br />        a1(rnd_no)=1<br />    <br />%><br /> <br />// Display the recordset Here.<br /><br /><br /><%<br />end if<br />loop<br />rs.Close()<br />Set rs = Nothing<br />cnn.close<br />%><br /><br />This code works like a charm for around 50 records. Didnt tested it for more.<br /><br />Now in this code I am using a array 'a1' to mark the recordset which has been displayed. This is required since sometimes the Random funtion calculation gives the same number back, so the same record may get printed more than once. This was undesirable. So by using this array and marking each record after printing ensures that each record is printed once only.<br /><br />Do tell me your reviews on this code.<br />

Back to After Hours Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums