Beginners Trouble with Frontpage / SQL syntax ??

geocabs · Jul 6, 2000

I need to query a database (SQL Server). I need to look up a table which contains a list of countries (It needs to be a drop down list box). I then need another drop down list box, either on the same page or perhaps another page which will contain a town name. I then need the results of these selections to go directly to a database results region on another page. Im using Frontpage 2000. Can anyone tell me explicitly how to do this. I seem to be able to get all the elements to work individually but I cant link them!!!! AAaaarggghh !! I can get a drop down list of countries to work with a database results region on trhe same page but I cant get another drop down embedded in from another table. Can frontpage handle opening more than one table at a time ? Maybe this is the problem.

palbano · Jul 6, 2000

Dear geocabs, First FrontPage is just your editor. It has nothing to do with connecting to your database at runtime. Yes you should be able to do what you are describing up to the point where you say this: > I then need the results of these selections to go directly to a database results region on another page. I have no idea what that means. However, you can build two separate dropdown lists from two different tables in your database on the same .ASP page. You can either perform two different queries or if your database supports UNION querys you could handle it that way. If you are getting errors reported in the browser post the error message along with the ASP code related to the problem. Good luck -pete

DougP · Jul 6, 2000

I found that Front Page will do certain things just fine by itslef but when you want to combine items you have to create the page from scratch. Since you are on the .ASP forum, I suspect you want to make your own .asp page. Then yes you can open a lots of Tables in SQL server. This will open a connection to s SQL Server database then using an SQL statement return something. ------------------------------------------------------ <% Set Conn = server.CreateObject("ADODB.Connection&quot

Conn.Open "driver=SQL Server;server=YOURSERVER;uid=USERID;pwd=PASSWORD;database=YOURDATABASE;" Set RS1 = Conn.Execute("SELECT * From yourtable Where [somecolumn] ='" & somevalue & "'&quot

%> DougP <a href=mailto: dposton@universal1.com> dposton@universal1.com</a> <a href= > </a> Ask me how Bar-codes can help you be more productive.

geocabs · Jul 6, 2000

Hi The following code generated by Frontpage works. It gives me a drop down list of countries from my SQL Country table. <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 1</title> </head> <body>  <% fp_sQry="SELECT * FROM Country_Data" fp_sDefault="" fp_sNoRecords="No records returned." fp_sDataConn="GeocabsSQL" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=True fp_sMenuChoice="Country" fp_sMenuValue="Country" fp_iDisplayCols=1 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>  <select NAME="Country" SIZE="1">      <option><%=FP_FieldHTML(fp_rs,"Country&quot

%></option>    </select> </body> </html> However I tried DougP's suggestion and I get an error - I think I may have an SQL configuration problem too. Doug's code altered to suit my setup I think is as follows:- <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>New Page 2</title> </head> <body> <% Set Conn = server.CreateObject("ADODB.Connection&quot

Conn.Open "driver=SQL Server;server=Mercury;uid=dbo;pwd=superman;database=geocabssql;" Set RS1 = Conn.Execute("SELECT * From Country_Data Where [Country] ='" & somevalue & "'&quot

%> </body> </html> The error I get in the browser is:- Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'dbo'. /geocabs/test5.asp, line 14 So now I have two problems !!! I dont know how to write the code and I got a failed login !! To repeat or clarify my original problem I want to select a country from the country table and then on the same page select or type in a town and then a database search is done on these two fields. I can now get Frontpage 2000 to give me to input boxes where I have to type both the country and the town but I would like to select the country by querying the table instead - Anyone know the answer (maybe how to modify the form field) to this and the connectivity problem. Technet suggests a permissions problem but I can seem to resolve it Aaaarrrrggggghhhhh !!! Computers !!

geocabs · Jul 6, 2000

Now I got the SQL Login problem solved but the code from dougP just gives me a blank page. Im pretty sure Im supposed to do something else with it but not really sure what - I guess Im looking for a few pointers in how to write / build a query Help still required tho I can see some books being purchased soon !

palbano · Jul 7, 2000

Dear geocabs, > but the code from dougP just gives me a blank page Yes the code only shows how to obtain a recordset using a SQL query. After that you must output the page using the resultant rows and columns from the recordset object. There are plenty of code samples for interfacing with a database in ASP. msdn.microsoft.com is a great source there should also be sample ASP files installed under IIS on the server. <grumble> Many tools exist today that market themselves to be a miracle development tool. You don't need to know anything just point and click and presto you have a working application. In theory fine, in practice NOT! When the user doesn't understand the underlying technology it's just a matter of time before he/she is lost and cannot provide the solution required.</grumble> "But, that's just my opinion... I could be wrong". -pete

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!

Beginners Trouble with Frontpage / SQL syntax ??

geocabs

IS-IT--Management

palbano

Programmer

DougP

MIS

geocabs

IS-IT--Management

geocabs

IS-IT--Management

palbano

Programmer

Similar threads

Part and Inventory Search

Sponsor