The syntax is ok, but you're better off specifying the fields you want
the data inserted into. Also you don't need to use the set statement to
assign a string to a variable, and you need to surround it in double
quotes. Like so :-
sql = "insert into tablename (fieldname1, fieldname2) values ('" & a &
"', '" & b & "');"
Dan
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Jegatha
Sent: 14 July 2005 08:43
To: Asp; ASP group2
Subject: [AspClassicAnyQuestionIsOk] insert query
hi
i want to know the following query is right or not
set sql=insert into tablename values( ' "&a&" ',' "&b&" ')
connection.execute(sql)
if wrong plz tell me the correct coding
thanks in advance.
jegatha
---------------------------------
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com
[Non-text portions of this message have been removed]
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
