Please help : System.Data.OleDb.OleDbException: Syntax error i

Yep..that got me a few times. Also Joe, be careful of using Date as a colum
n name as well, I know you didn't use it here but I had to find out the hard
way. It will cause the same type of error. The Jet Provider is picky abou
t those kinds of words
"Marina" wrote:

> I believe 'password' is a keyword - but it is also your column name. Try
> putting [ and ] around the column name.
> Alsok you shouldn't just concatenate strings together given to you by the
> user. They could easily put in malicious SQL for one of those values. I
> would recommend using parameters.
> "Joe" <Joe@dotnet.itags.org.discussions.microsoft.com> wrote in message
> news:46E04C27-2E28-4AF8-B67B-B4492B7F2298@dotnet.itags.org.microsoft.com...
> cannot get rid of error message,
> as what could be wrong. The SQL string looks fine because I pasted the
> resulting SQL in to MS Access. When I ran the Insert query, it properly
> added the record in the Access DB.
> ResponseEncoding="iso-8859-1" %>
> "http://www.w3.org/TR/html4/loose.dtd">
> source='E:/Inetpub/databases/investors.mdb'")
> again.")
> = 0) Then
> address2, city, prov, country, postal, phone, mobilePhone, AddDate,Investo
r,
> RemoteIP
> company, street_address, address2, city, state, country, postal, phone,
> mobile, AddDate, Inv, RemoteIP)" & _
> last_name & "', '" & company & "', '" & street_address & "', '" & address2
&
> "', '" & city & "', '" & prov & "', '" & country & "', '" & postal & "', '
"
> & phone & "', '" & mobilePhone & "', '" & AddDate & "', '" & Investor & "'
,
> '" & RemoteIP & "')"
>
>Thanx guys after I put [] around password, AddDate and RemoteIP, the script
worked.
Joe
"Tampa .NET Koder" wrote:
> Yep..that got me a few times. Also Joe, be careful of using Date as a col
umn name as well, I know you didn't use it here but I had to find out the ha
rd way. It will cause the same type of error. The Jet Provider is picky ab
out those kinds of words
> "Marina" wrote:
>