the problem is with the second code phase, from some reason the database is not idetify and its just showing an error on the page of un-idetify odbc
On 1 אוקטובר, 14:49, Andrew Badera <[email protected]> wrote: > 1. Post code like this onhttp://dotnetdevelopment.pastebin.com/so we > don't get headaches trying to help you. > 2. What exception are you receiving, and which line of your code does > it correspond to? We can't help you if you don't provide enough > detail. > 3. What's wrong? You're using Access. Use SQL Express instead. > > ∞ Andy Badera > ∞ +1 518-641-1280 > ∞ This email is: [ ] bloggable [x] ask first [ ] private > ∞ Google me:http://www.google.com/search?q=andrew%20badera > > > > On Thu, Oct 1, 2009 at 4:38 AM, thread <[email protected]> wrote: > > > hello > > i'm trying to get the recordset of access table but from some reason > > it doesnt work > > there are 2 files in use: > > 1.to place the search > > 2.giving the raw data > > > from some reason the second stage is not working > > this is the code > > > 1. > > <HTML> > > <BODY> > > <H1>Biblio DataBase Search</H1><HR> > > <FORM ACTION=DBSEARCH.ASP METHOD=POST> > > > Enter Author to search for: > > <INPUT TYPE=TEXT NAME=txtsearch size="20"> > > <INPUT TYPE=SUBMIT VALUE="Begin Search"> > > > </FORM> > > </BODY> > > </HTML> > > > 2. > > <HTML><BODY> > > <% > > Dim cn > > Dim rs > > Dim sSQL > > Dim sSearchString > > > 'GET THE SEARCH STRING FRPM THE FORM > > sSearchString = Request.Form("txtSearch") > > > If sSearchString = "" Then > > Response.Write("No search string entered!") > > Response.End > > End If > > > 'CONNET TO THE DATABASE AND PERFORM THE SEARCH > > Set cn = Server.CreateObject("ADODB.Connection") > > cn.Open "DSN=BIBLIO" > > > sSQL = "SELECT * FROM AUTHORS WHERE AUTHOR LIKE " > > sSQL = sSQL & "'" & sSearchString & "%' ORDER BY AUTHOR" > > > Set rs = cn.Execute(sSQL) > > %> > > <TABLE BORDER=1> > > <TR>Author's Name</TR> > > <% > > 'DISPLAY THE RESULTS IN A TABLE > > Do While Not rs.EOF > > Response.Write("<TR><TD>") > > Response.Write rs.Fields("Author") > > Response.Write("<TD></TR>") > > rs.MoveNext > > Loop > > rs.Close > > cn.Close > > Set rs = Nothing > > Set cn = Nothing > > %> > > </TABLE> > > </BODY> > > </HTML> > > > what is wrong?-הסתר טקסט מצוטט- > > -הראה טקסט מצוטט-
