bja888 — Sat, 06 Mar 2004 03:42:20 +0000

thanks again

Mark Hensler — Fri, 05 Mar 2004 18:32:41 +0000

[code ] and [/code ]

without the space

bja888 — Fri, 05 Mar 2004 16:05:58 +0000

Wow! I feel stupid now! Thankx alot, it works now. Now how did you get it to show the code in those boxes.

Greg K — Fri, 05 Mar 2004 15:58:38 +0000

I haven't done much with ASP, but try the following:

strSQL = "INSERT INTO Book 
            (Name, Age, Email, Gender, Comments) 
          VALUES 
            ('" + nm + "','" + ag + "','" + em + "','" + gen +"','" + com + "')";

Another alternative might be:

strSQL = "INSERT INTO Book 
            (Name, Age, Email, Gender, Comments) 
          VALUES 
            (\"" + nm + "\",\"" + ag + "\",\"" + em + "\",\"" + gen +"\",\"" + com + "\")";

Mark Hensler — Fri, 05 Mar 2004 06:28:01 +0000

You probably need quotes around your strings in the VALUES() sql clause.