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.<br><br>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 !!<br><br>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.<br>
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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Beginners Trouble with Frontpage / SQL syntax ??
- Thread starter geocabs
- Start date
Dear geocabs,<br><br>First FrontPage is just your editor. It has nothing to do with connecting to your database at runtime.<br><br>Yes you should be able to do what you are describing up to the point where you say this:<br>> I then need the results of these selections to go directly to a database results region on another page.<br><br>I have no idea what that means.<br><br>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.<br><br>Good luck<br>-pete<br>
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.<br>Since you are on the .ASP forum, I suspect you want to make your own .asp page.<br>Then yes you can open a lots of Tables in SQL server.<br><br>This will open a connection to s SQL Server database then using an SQL statement return something.<br>------------------------------------------------------<br><%<br>Set Conn = server.CreateObject("ADODB.Connection"
<br>Conn.Open "driver=SQL Server;server=YOURSERVER;uid=USERID;pwd=PASSWORD;database=YOURDATABASE;"<br>Set RS1 = Conn.Execute("SELECT * From yourtable Where [somecolumn] ='" & somevalue & "'"<br>%><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
<br>Conn.Open "driver=SQL Server;server=YOURSERVER;uid=USERID;pwd=PASSWORD;database=YOURDATABASE;"<br>Set RS1 = Conn.Execute("SELECT * From yourtable Where [somecolumn] ='" & somevalue & "'"<br>%><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.- Thread starter
- #4
Hi<br><br>The following code generated by Frontpage works. It gives me a drop down list of countries from my SQL Country table.<br><br><html><br><br><head><br><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><br><meta name="GENERATOR" content="Microsoft FrontPage 4.0"><br><meta name="ProgId" content="FrontPage.Editor.Document"><br><title>New Page 1</title><br></head><br><br><body><br><br><p><nobr><!--webbot bot="DatabaseRegionStart" startspan<br>s-columnnames="Country,Continental_Region,Administrative_Capital,Financial_Capital,International_Direct_Dialing_Country_Code,Major_Currency,Minor_Currency,Constitutional_Status,State_Airline,State_Railway,Flag,Geocabs_Web_Page_Gennifo,upsize_ts"<br>s-columntypes="202,202,202,202,202,202,202,202,202,202,205,203,128"<br>s-dataconnection="GeocabsSQL" b-tableformat="FALSE" b-menuformat="TRUE"<br>s-menuchoice="Country" s-menuvalue="Country" b-tableborder="TRUE"<br>b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"<br>b-listseparator="TRUE" i-ListFormat="0" b-makeform="TRUE"<br>s-recordsource="Country_Data" s-displaycolumns="Country" s-criteria s-order<br>s-sql="SELECT * FROM Country_Data" b-procedure="FALSE" clientside<br>SuggestedExt="asp" s-DefaultFields s-NoRecordsFound="No records returned."<br>i-MaxRecords="256" i-GroupSize="0" BOTID="0" u-dblib="_fpclass/fpdblib.inc"<br>u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc"<br>local_preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> "<br>preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " --><!--#include file="_fpclass/fpdblib.inc"--><br><%<br>fp_sQry="SELECT * FROM Country_Data"<br>fp_sDefault=""<br>fp_sNoRecords="No records returned."<br>fp_sDataConn="GeocabsSQL"<br>fp_iMaxRecords=256<br>fp_iCommandType=1<br>fp_iPageSize=0<br>fp_fTableFormat=False<br>fp_fMenuFormat=True<br>fp_sMenuChoice="Country"<br>fp_sMenuValue="Country"<br>fp_iDisplayCols=1<br>fp_fCustomQuery=False<br>BOTID=0<br>fp_iRegion=BOTID<br>%><br><!--webbot bot="DatabaseRegionStart" I-CheckSum="51573" endspan --><br><select NAME="Country" SIZE="1"><br> <!--webbot bot="AspInclude" startspan CLIENTSIDE<br> U-INCFILE="_fpclass/fpdbrgn1.inc" --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot<br> bot="AspInclude" I-CheckSum="62210" endspan --><br> <option><%=FP_FieldHTML(fp_rs,"Country"%></option><br> <!--webbot bot="AspInclude" startspan CLIENTSIDE<br> U-INCFILE="_fpclass/fpdbrgn2.inc" --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot<br> bot="AspInclude" I-CheckSum="62218" endspan --><br></select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"<br>b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside<br>local_preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> "<br>preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " --><!--webbot<br>bot="DatabaseRegionEnd" endspan --><br></nobr></p><br><br></body><br><br></html><br><br><br><br>However I tried DougP's suggestion and I get an error - I think I may have an SQL configuration problem too.<br><br>Doug's code altered to suit my setup I think is as follows:-<br><br><html><br><br><head><br><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><br><meta name="GENERATOR" content="Microsoft FrontPage 4.0"><br><meta name="ProgId" content="FrontPage.Editor.Document"><br><title>New Page 2</title><br></head><br><br><body><br><br><%<br>Set Conn = server.CreateObject("ADODB.Connection"<br>Conn.Open "driver=SQL Server;server=Mercury;uid=dbo;pwd=superman;database=geocabssql;"<br>Set RS1 = Conn.Execute("SELECT * From Country_Data Where [Country] ='" & somevalue & "'"<br>%><br><br></body><br><br></html><br><br><br><br>The error I get in the browser is:-<br><br><br>Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' <br><br>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'dbo'. <br><br>/geocabs/test5.asp, line 14 <br><br><br><br>So now I have two problems !!! I dont know how to write the code and I got a failed login !!<br><br>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<br><br>Aaaarrrrggggghhhhh !!! Computers !!<br>
%></option><br> <!--webbot bot="AspInclude" startspan CLIENTSIDE<br> U-INCFILE="_fpclass/fpdbrgn2.inc" --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot<br> bot="AspInclude" I-CheckSum="62218" endspan --><br></select><!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"<br>b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside<br>local_preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> "<br>preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " --><!--webbot<br>bot="DatabaseRegionEnd" endspan --><br></nobr></p><br><br></body><br><br></html><br><br><br><br>However I tried DougP's suggestion and I get an error - I think I may have an SQL configuration problem too.<br><br>Doug's code altered to suit my setup I think is as follows:-<br><br><html><br><br><head><br><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><br><meta name="GENERATOR" content="Microsoft FrontPage 4.0"><br><meta name="ProgId" content="FrontPage.Editor.Document"><br><title>New Page 2</title><br></head><br><br><body><br><br><%<br>Set Conn = server.CreateObject("ADODB.Connection"<br>Conn.Open "driver=SQL Server;server=Mercury;uid=dbo;pwd=superman;database=geocabssql;"<br>Set RS1 = Conn.Execute("SELECT * From Country_Data Where [Country] ='" & somevalue & "'"<br>%><br><br></body><br><br></html><br><br><br><br>The error I get in the browser is:-<br><br><br>Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' <br><br>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'dbo'. <br><br>/geocabs/test5.asp, line 14 <br><br><br><br>So now I have two problems !!! I dont know how to write the code and I got a failed login !!<br><br>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<br><br>Aaaarrrrggggghhhhh !!! Computers !!<br>- Thread starter
- #5
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<br><br>Help still required tho I can see some books being purchased soon !
Dear geocabs,<br><br>> but the code from dougP just gives me a blank page<br><br>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.<br><br>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.<br><br><grumble><br>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><br><br>"But, that's just my opinion... I could be wrong".<br>-pete
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question