Hello, can u help me to check what

hoog · Jan 15, 2002

Hello, can u help me to check what is wrong with it?

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'from'.

/mailpwd1.asp, line 28

<%

Dim DataConn, ConnString
Dim SQL, Email, oRs
Dim Email2, password2
Dim MyMail

Email=Request.Form ("text1&quot

Set DataConn = Server.CreateObject("ADODB.Connection&quot

ConnString="driver={sql server};server=CON7; database=user;DSN=localserver;PWD=sa;UID=sa;"
DataConn.Open ConnString

SQL="select * from password, email from user where email='" & Email & "'"

Set oRs= Server.CreateObject ("ADODB.recordset&quot

oRs.Open SQL, DataConn, 3

If oRs.EOF Then
response.write "<html><head><body bgcolor='#000000' text='#ffff00'><center>"
Response.Write "<font face='verdana' size='+2'><p>"
Response.Write "No records found:<p> Use the browser's back button to go back and try again"
Response.Write "</font></body></html>"
Response.End
end if

Email2=oRs("Email&quot

password2=oRs("password&quot

oRs.Close
Set oRs=nothing

Set MyMail = Server.CreateObject("CDONTS.NewMail&quot

MyMail.From="yourname@123.com"
MyMail.To = Email2
MyMail.Subject ="Your Password"
MyMail.Body= password2

MyMail.Send
Set MyMail= nothing
%>X-)

link9 · Jan 15, 2002

SQL="select * from password, email from user where email='" & Email & "'"

is malformed SQL syntax.

you have two from clauses there. Maybe this is what you're looking for?

SQL="select password, email from user where email='" & Email & "'"

hoog · Jan 15, 2002

It has the same error when i do the above statment SQL="select password, email from user where email='" & Email & "'" .So what could the problem lies? Or the problem lies in oRs.Open SQL, DataConn, 3 .

link9 · Jan 15, 2002

No, it's your SQL for sure.

Try surrounding the name of your table in brackets. user might be a reserved word:

SQL="select password, email from [user] where email='" & Email & "'"

krappleby025 · Jan 16, 2002

try

SQL="SELECT * FROM user where email='" & Email & "'"

may work easier

link9 · Jan 16, 2002

SELECT *

is not the best habit to get into... it's always better to only select just the columns you need. It will make your applications run faster, since you're passing less data around.

We're all guilty of it sometimes, but it won't "work easier" than selecting just the columns you want.

lobstah · Jan 16, 2002

i just tested this, and link9 is right, it is a problem with 'user' being a reserved word. surrounding it in brackets fixed the problem. 'password' is also a reserved word and could cause an error about 'invalid syntax in insert statement' when trying to update the table. to get around these problems, we always add a prefix to table field names so that we don't end up with reserved words, and changing the table name to 'users' instead of 'user' also solves this current problem without having to remember the brackets.... avoiding reserved words seems the best solution to me.

;-)

David75 · Jan 16, 2002

Here's a database tip I use in all my projects: Give each table a 3 or 4 character code, then prefix all field names in that table with the code.

For example, your "user" table might have a 3 letter code of "USR" so the fields would be named USR_Name, USR_Password, USR_ExpiryDate, etc.

It helps when joining tables too, since you won't need to use the table name and field name to reference a field. And even if you only know a field name, you always know what table it came from. I think this is called Nyulian notation.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Hello, can u help me to check what

hoog

Technical User

link9

Programmer

hoog

Technical User

link9

Programmer

krappleby025

Programmer

link9

Programmer

lobstah

Programmer

David75

Programmer

Similar threads

Part and Inventory Search

Sponsor