|
 |
asp_databases thread: I have this error
Message #1 by "Londani Tshikundamalema" <londani@h...> on Thu, 03 Oct 2002 07:06:20 +0000
|
|
I have the following problem can you please help me.
Microsoft VBScript compilation error '800a0408'
Invalid character
/lon/insert2_data.asp, line 17
^
below is my coding
Email = request.form("Email")
Phone = request.form("Phone")
set conn = server.createobject("adodb.connection")
conn.open "example"
sql="insert into example(Name,Email,Phone) values('" & Name & "','" &
Email & "','" & Phone & "')"
set rs = conn.execute(sql)
if err.number>0 then
response.write "VBScript Errors occured."&"<p>"
response.write "Error Number=" & err.number & "<p>"
End if
if conn.errors.count>0 then
response.write "Database Errors Occured" & "<p>"
response.write sqlstmt & "<P>"
for counter=0 to conn.errors.count
response.write "Error #" & conn.errors(counter).number & "<p>"
response.write "Error desc. ->" & conn.errors(counter).description
&"<p>"
Next
Else
End if
conn.close
%>
Information has been added successfully to the database.
<p>
</body>
</html>
_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Message #2 by "Londani Tshikundamalema" <londani@h...> on Thu, 03 Oct 2002 07:18:33 +0000
|
|
I have the following problem can you please help me.
Microsoft VBScript compilation error '800a0408'
Invalid character
/lon/insert2_data.asp, line 17
^
Below is my coding.
<% response.buffer = true %>
<html>
<head>
<title>Inserting data Scripts</title>
</head>
<body>
<% dim Name,Email,Phone,conn,sql,rs
Name = request.form("Name")
Email = request.form("Email")
Phone = request.form("Phone")
set conn = server.createobject("adodb.connection")
conn.open (example)
sql="insert into example(Name,Email,Phone) values('" & Name & "','" &
Email & "','" & Phone & "')"
set rs = conn.execute(sql)
if err.number>0 then
response.write "VBScript Errors occured."&"<p>"
response.write "Error Number=" & err.number & "<p>"
End if
if conn.errors.count>0 then
response.write "Database Errors Occured" & "<p>"
response.write sqlstmt & "<P>"
for counter=0 to conn.errors.count
response.write "Error #" & conn.errors(counter).number & "<p>"
response.write "Error desc. ->" & conn.errors(counter).description
&"<p>"
Next
Else
End if
conn.close
%>
Information has been added successfully to the database.
<p>
</body>
</html>
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
Message #3 by "Kim Iwan Hansen" <kimiwan@k...> on Thu, 3 Oct 2002 16:57:27 +0200
|
|
Running your code on my system, I got the same error.
Delete everything (spaces and characters) on the left side of the equal sign
(i.e. ""), then rewrite it - that solved the problem here.
-Kim
> -----Original Message-----
> From: Londani Tshikundamalema [mailto:londani@h...]
> Sent: 3. oktober 2002 09:19
> To: ASP Databases
> Subject: [asp_databases] I have this error
>
>
> I have the following problem can you please help me.
>
> Microsoft VBScript compilation error '800a0408'
>
> Invalid character
>
> /lon/insert2_data.asp, line 17
>
>
> ^
>
> Below is my coding.
>
> <% response.buffer = true %>
> <html>
> <head>
> <title>Inserting data Scripts</title>
> </head>
> <body>
> <% dim Name,Email,Phone,conn,sql,rs
>
> Name = request.form("Name")
> Email = request.form("Email")
> Phone = request.form("Phone")
>
> set conn = server.createobject("adodb.connection")
> conn.open (example)
>
> sql="insert into example(Name,Email,Phone) values('" & Name & "','" &
> Email & "','" & Phone & "')"
> set rs = conn.execute(sql)
>
> if err.number>0 then
> response.write "VBScript Errors occured."&"<p>"
> response.write "Error Number=" & err.number & "<p>"
> End if
> if conn.errors.count>0 then
> response.write "Database Errors Occured" & "<p>"
> response.write sqlstmt & "<P>"
> for counter=0 to conn.errors.count
> response.write "Error #" & conn.errors(counter).number & "<p>"
> response.write "Error desc. ->" & conn.errors(counter).description
> &"<p>"
> Next
> Else
> End if
> conn.close
> %>
> Information has been added successfully to the database.
> <p>
> </body>
> </html>
|
|
|
View Cart
