trouble with insert into db with jscript

[bigdude]

hello
using mysql server with asp and jscript
it looks like the jscript doesn't like "" around variables in the insert string....
can anyone help me on how to get the value of a variable into this?
here are some things i've tried:

var insertBird=Request.Form("txtBird");
result=conn.Execute("INSERT INTO birds VALUES('$insertBird$')");
// database gets "$insertBird$"
result=conn.Execute("INSERT INTO birds VALUES('$insertBird')");
// database gets "$insertBird"
result=conn.Execute("INSERT INTO birds VALUES('insertBird')");
// database error that there is no col "insertbird"
result=conn.Execute("INSERT INTO birds VALUES('"insertBird"')");
// jscript error that it expects ";" after "('"

anyone help on this?
thanks in advance

[glenngv]

haven't used jscript on server-side.
this is just an educated guess:

result=conn.Execute("INSERT INTO birds (FIELDNAME_HERE) VALUES('"+insertBird+"')");

[bigdude]

hi
thanks so much!
it works :)