syntax error 1

[rry2k]

I'm getting hung up on syntax for a statement and I need help. It's an error saying Missing end of statement. I'm sure it's something simple like a quote but I'm a newbie and not getting the answer real quick. This code is a one field test to update a database.

<!-- #include file = &quot;conn.inc&quot; -->
<%
sqlstr1 =&quot;INSERT INTO Userinfo(SSN) VALUES Request(&quot;fssn&quot&quot;
set rs=cn.Execute(sqlstr1)%>

Thanks for the help..Russ

 

[foxbox]

sqlstr1 =&quot;INSERT INTO Userinfo(SSN) VALUES('&quot; &_
Request(&quot;fssn&quot & &quot;')&quot;

(assuming fssn is char)
br
Gerard

 

[rry2k]

Thanks, that did the trick. Is there an article somewhere or rule that you use to determine when to use quotes(single or double) and when to use &.

Thanks again for the help.

 

[jmcpher]

Well I've gone and answered this on your HTML question... &quot;A computer scientist is a person who knows when it is time to hit the computer.&quot;

John

johnmc@mvmills.com