Hi there, I got the sql to work on the last problem but now come up with the following when I try to update.

Microsoft JET Database Engineerror '80040e07'

Data type mismatch in criteria expression. /html/user-info-standard.asp, line 150

CODE
' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute <---------------------------
MM_editCmd.ActiveConnection.Close
If (MM_editRedirectUrl <> "") Then
Response.Redirect(MM_editRedirectUrl)
End If
End If
End If
%>

Any ideas on how to trouble shoot?

I just noticed that if I enter a number rather than text, it works....

Anyway around this by changing a little code?

Give us the line of code that defines " MM_editQuery"

Check the column in the database, its probably a numeric column. change it to text or varchar depending on what type of database you're using.

To find out what's wrong with the SQL statement, I usually add a dummy string variable to store the SQL statement and write it to a log file, or use msgbox to display that SQL statement. Then I copy and paste it to the query analyser of the MS access/MS SQL Server/MySQL to iron out the syntax problem of the SQL statement. This makes my life much easier, and don't need to run the whole program all over again each time.

Good Luck

Another trick you can use is to copy/paste the MM_editQuery onto a new line and edit the second one. That way, if you screw it up too badly, you can refer back to the first one.