Re: Display records even if 800a0bcd

No problem, I solved the issue by using LEFT JOIN queries.
Now the problem is that I cannot update a record :|
The db is an Access DB and this is the code into the page:

<%
Dim cnnDBEdit
Dim strSQL
DBPath = "C:\Inetpub\wwwroot\Riparazioni\db\mydb.mdb"
CONN_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath &
";"
strSQL = "UPDATE Users SET " _
& "Password = ""00001"" " _
& "WHERE (USer = ""00001"");"
Set cnnDBEdit = Server.CreateObject("ADODB.Connection")
cnnDBEdit.Open CONN_STRING
cnnDBEdit.Execute strSQL, adAffectAll, adCmdText Or adExecuteNoRecords
cnnDBEdit.Close
Set cnnDBEdit = Nothing
%>


*** Sent via Developersdex http://www.developersdex.com ***