Search results for query: *

Hi, I have 4 tables Table 1: institutions instID instName CityID (FK) Table 2: cities cityID cityName regionID (FK) countryID (FK) Table 3: regions regionID regionName countryID (FK) Table 4: countries countryID countryName I'm trying to list all the institution name, the city, the region...

Hi everyone, What would be the best way of representing this relation between Countries, States and Cities. 1- tblCountries countID(PK), countName tblCountries_States countID, stateID tblStates stateID(PK), stateName tblStates_Cities stateID, cityID tblCities cityID(PK), cityName OR is...

Hello everyone, I'm working with Dreamweaver CS3. Sometimes when I replace an image that is already being used in a webpage (for example I change the color of the image sky.jpg and re-upload it to the server using ws-ftp). When I start Dreamweaver (ftp connect) DW overwrites the new sky.jpg...

Hello everyone, I have a form generated by the database (PHP, Postgresql). It displays every client with a checkbox (either checked or unchecked) after the name. The client has to be approved by an admin. The admin approves or uncheck the approve checkbox. After submitting, the database must be...

Hello everyone, I have to work with someone else's Access database. On the form, there is a dropdown menu refering to a table with more than a 100,000 records (almost all the high schools and universities in the world). You can see that it is a bit heavy to work with. What would be the best way...

Hi Everyone, I have a form in which the user must enter in a textbox his preferred choice on a scale of 1 to 5. How do I loop through and validate that the user has entered is first 5 choice. Here is part of the form: <input type="textbox" name="s1q8_1">a. Planning <input type="textbox"...

Hi everyone, I am working on a access database and I have to separate a field that has been concatenated. For example the value of the field History is (for example) '10/23/2004Poster' (without the quotes) but it can also be 'View, 10/23/2004'. I want to separate the date from the word and put...

Hello everyone, I am calling on you to see how I can optimize these SQL queries (access and ASP). Base Query : tSql = "SELECT sectionID, detailSectionID, banID, judgeID, raceID, sectionURL, nbrIns, nbrExp FROM tblDetailSections WHERE detailExpoID = 111 Set Res = dbLink.Execute(tSql) Other...

Hello everyone, I have tried to implement this tutorial: http://www.tek-tips.com/faqs.cfm?fid=4502 It's not working for me. This is my code to loop through the resID (to test the tutorial). <% Function CleanInput(strReqName) CleanInput = Replace(Request.Form(strReqName),"'","''") End...

Hello everyone, I'm trying to populate a dropdown list using the GetRows: varSQL = &quot;SELECT * FROM dbTable&quot; Set dbReponse = Server.CreateObject(&quot;ADODB.Recordset&quot;) dbReponse.Open varSQL, dbLink lingAbTab = dbReponse.GetRows() <select size=&quot;1&quot...

Hello! I am using an include file (<!-- #INCLUDE VIRTUAL = &quot;includes/header.asp&quot; -->) and the header.asp contains images that are in another folder (<img src=&quot;../images/spacer.gif&quot;>) . the problem is that the file taht calls the include is in at another level. The images are...

Hello everyone, I'll try simplify my problem... Situation : I have a page in which there is a textbox (called &quot;grandTotal&quot;) and a button. When I click the button, a popup window opens(frameset - top and bottom frames). On the top frame there is a textbox (where the user enters a...

Hello everyone! I must create a online survey and I am wondering what would be the best way to approach this. The survey is simple i.e : Question 1. Evaluate your knowledge of ... a) MS Word b) MS Excel c) etc. The scale is from Excellent to Poor. Radio buttons (5) are being used to grade the...

Hello, Situation : My web page receive data from users (ie: name textbox in a .cfm form) this data is compiled and stored in a SQL table. How do I export these data to a specific Excel file on the server? w11z