access_asp thread: Syntax error...
Message #1 by "Cathryn Bennett" <cbennett@f...> on Mon, 12 Aug 2002 11:56:20 -0400
|
|
I get a syntax error on the following script. Can someone tell me what I'm
missing...
sql = "Insert into survey (" &_
"service, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10) " &_
"values (" &_
"'" & ("varservice") & "', " &_
"'" & ("varQ1") & "', " &_
"'" & ("varQ2") & "', " &_
"'" & ("varQ3") & "', " &_
"'" & ("varQ4") & "', " &_
"'" & ("varQ5") & "', " &_
"'" & ("varQ6") & "', " &_
"'" & ("varQ7") & "', " &_
"'" & ("varQ8") & "', " &_
"'" & ("varQ9") & "', " &_
"'" & ("varQ10")
Thanks in advance.
Cathryn
Message #2 by "Daniel Groh" <daniel.groh@s...> on Mon, 12 Aug 2002 13:09:37 -0300
|
|
send us the syntax, I believe you forgot there in the end "'" & ("varQ10")"'"
and why did you put all vars into of () ???
look that:
sql = "insert into table(service,Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9,Q10)
values('"&varservice&"','"&varQ1&"','"&varQ1&"','"&varQ1&"','"&varQ1&"','"&varQ1&"',
'"&varQ1&"','"&varQ1&"','"&varQ1&"','"&varQ1&"')"
u just need to do the concatenation..
See ya
Daniel, Brazilian Guy
----- Original Message -----
From: Cathryn Bennett <cbennett@f...>
To: Access ASP <access_asp@p...>
Sent: Monday, August 12, 2002 12:56 PM
Subject: [access_asp] Syntax error...
> I get a syntax error on the following script. Can someone tell me what I'm
> missing...
>
>
>
> sql = "Insert into survey (" &_
> "service, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10) " &_
> "values (" &_
> "'" & ("varservice") & "', " &_
> "'" & ("varQ1") & "', " &_
> "'" & ("varQ2") & "', " &_
> "'" & ("varQ3") & "', " &_
> "'" & ("varQ4") & "', " &_
> "'" & ("varQ5") & "', " &_
> "'" & ("varQ6") & "', " &_
> "'" & ("varQ7") & "', " &_
> "'" & ("varQ8") & "', " &_
> "'" & ("varQ9") & "', " &_
> "'" & ("varQ10")
>
>
> Thanks in advance.
>
> Cathryn
>
>
>
Message #3 by "Chetan Kelkar" <chetan@c...> on Tue, 13 Aug 2002 09:04:28 +0530
|
|
Try this
sql = ("insert into survey(service, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10)
values ('"&varservice&"','"&varQ1&"', '"&varQ2&"', '"&varQ3&"', '"&varQ4&"',
'"&varQ5&"', '"&varQ6&"', '"&varQ7&"', '"&varQ8&"', '"&varQ9&"',
'"&varQ10&"')")
hope this helps,
Chetan
----- Original Message -----
From: "Cathryn Bennett" <cbennett@f...>
To: "Access ASP" <access_asp@p...>
Sent: Monday, August 12, 2002 9:26 PM
Subject: [access_asp] Syntax error...
> I get a syntax error on the following script. Can someone tell me what
I'm
> missing...
>
>
>
> sql = "Insert into survey (" &_
> "service, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10) " &_
> "values (" &_
> "'" & ("varservice") & "', " &_
> "'" & ("varQ1") & "', " &_
> "'" & ("varQ2") & "', " &_
> "'" & ("varQ3") & "', " &_
> "'" & ("varQ4") & "', " &_
> "'" & ("varQ5") & "', " &_
> "'" & ("varQ6") & "', " &_
> "'" & ("varQ7") & "', " &_
> "'" & ("varQ8") & "', " &_
> "'" & ("varQ9") & "', " &_
> "'" & ("varQ10")
>
>
> Thanks in advance.
>
> Cathryn
>
>
>
Message #4 by "Charles Mabbott" <aa8vs@m...> on Tue, 13 Aug 2002 06:03:26 -0400
|
|
One done, place the following after the definition to see
the results of your statement to be sure it is what you
expect.
response.write(sql)
response.end
>From: "Chetan Kelkar" <chetan@c...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Re: Syntax error...
>Date: Tue, 13 Aug 2002 09:04:28 +0530
>
>Try this
>
>sql = ("insert into survey(service, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9,
>Q10)
>values ('"&varservice&"','"&varQ1&"', '"&varQ2&"', '"&varQ3&"',
>'"&varQ4&"',
>'"&varQ5&"', '"&varQ6&"', '"&varQ7&"', '"&varQ8&"', '"&varQ9&"',
>'"&varQ10&"')")
>
response.write(sql)
response.end
See if it looks right!
>hope this helps,
>
>Chetan
>
>----- Original Message -----
>From: "Cathryn Bennett" <cbennett@f...>
>To: "Access ASP" <access_asp@p...>
>Sent: Monday, August 12, 2002 9:26 PM
>Subject: [access_asp] Syntax error...
>
>
> > I get a syntax error on the following script. Can someone tell me what
>I'm
> > missing...
> >
> >
> >
> > sql = "Insert into survey (" &_
> > "service, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10) " &_
> > "values (" &_
> > "'" & ("varservice") & "', " &_
> > "'" & ("varQ1") & "', " &_
> > "'" & ("varQ2") & "', " &_
> > "'" & ("varQ3") & "', " &_
> > "'" & ("varQ4") & "', " &_
> > "'" & ("varQ5") & "', " &_
> > "'" & ("varQ6") & "', " &_
> > "'" & ("varQ7") & "', " &_
> > "'" & ("varQ8") & "', " &_
> > "'" & ("varQ9") & "', " &_
> > "'" & ("varQ10")
> >
> >
> > Thanks in advance.
> >
> > Cathryn
> >
> >
> >
>
>
"If your not part of the solution,
there is good money to be made
prolonging the problem."
http://68.43.100.7:81/aa8vs
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
|
View Cart
