I help me look at the compiler errors <% Db= "chanpin1/admin/data.mdb" Set conn = Server.CreateObject ( "ADODB.Connection") Connstr= "driver={Microsoft Access Driver (*.mdb) };dbq=" &Server.MapPath ( "" &db& "") Conn.Open connstr Set rec=server.CreateObject ( "adodb.recordset") Sql= "select bigclassname from bigclass" Rec.open sgl, conn,1,1 Text=trim (request ( "key")) Bigclassname=trim (request ( "bigclass")) Sql= "select * from chanping" If (trim (text) "" "") or (trim (bigclassname) "" "" and bigclassname<> "Please choose") then sgl = sgl & "where" end if If trim (bigclassname) "" "" and trim (text) "" "" and bigclassname<> "Please choose" then sgl = sql& "and" end if If trim (bigclassname) "" "" and bigclassname<> "Please choose" then sgl sgl & = "bigclassname like '*" &bigclassname& "*'" Set rec1=server.CreateObject ( "adodb.recordset") Rec1.open sgl, conn,1,1                   %> Microsoft VBScript compiler error mistake '800a03f6' Lack of 'End' /iisHelp/common/500-100.asp, 242 firms Microsoft OLE DB Provider for ODBC Drivers error '80040e21' ODBC driver does not support the necessary attributes. Prosou.asp, 93 firms

Sentence analyzers facie inquiry into the importation of sgl know

The sentence is correct input sgl

Pearl166 said in a message 93 trip profession?

Rec1.open sgl, conn,1,1 This is

If trim (bigclassname) "" "" and bigclassname<> "Please choose" then sgl sgl & = "bigclassname like '*" &bigclassname& "*'" After a few end if Suggested that if such is the general lack of end Wend mark the end of such blocks sentences.

Sgl = sgl & "bigclassname like '*" &bigclassname& "*'" Not sql= "select bigclassname from bigclass", also added a variable bigclassname behind you, if variables are bigclassname= "&bigclass&" trip

Sgl = sgl & "bigclassname like '*" &bigclassname& "*'" Not sql= "select bigclassname from bigclass", also added a variable bigclassname behind you, if variables are bigclassname= "&bigclass&" trip What is the relationship between this and not the

If trim (bigclassname) "" "" and bigclassname<> "Please choose" then sgl sgl & = "bigclassname like '*" &bigclassname& "*'" After a few end if Suggested that if such is the general lack of end Wend mark the end of such blocks sentences. Not such a problem among

If (trim (text) "" "") or (trim (bigclassname) "" "" and bigclassname<> "Please choose" then sgl = sgl & "where" end if If trim (bigclassname) "" "" and trim (text) "" "" and bigclassname<> "Please choose" then sgl = sql& "and" end if If trim (bigclassname) "" "" and bigclassname<> "Please choose" then sgl sgl & = "bigclassname like '*" &bigclassname& "*'" If not block the end of the last sentence keyword "sound IF."

Not the final

The same increase in the end if

I think you should integrate your sentence if the three pieces, written not logical structure

55555555 Here lies the problem should not bar

ODBC driver does not support the necessary attributes. Inquiries should be wrong, you make room

I suspect that the three OSS landlord (or there will not write) if there is the logic wrong body language, thus leading to a final (End implementation of the three IF) sgl variable value is not a legitimate Query Language (there are grammatical errors). Since the landlord has not provided a complete code database has the meaning and future data field types, I can not make a definite judgment.

[ Closed window ]