how can i retrieve information on a form page that once previously submitted by the user so that when the user goes back to that form page it will remember what they inputted instead of having them to retype it again? do i have to use session? can somebody please help me... what would be the easiest and most efficient for a newbie to tackle this problem?
I stored information from a text area in an access database but when i show it in the asp page the text doesn't have the break line (line feed).... it's showed in one line.
I have a database page with a table. I am using ASP and MSSQL on a Windows 2003 machine.
When I get the database information displayed in the table, I have something like the following: <table> <tr><td>row1</td><td>row1</td><td>row1</td<td>row1</td> </tr> </table> The table has a total of 167 row that would be divided into five categories. How can i get the above table to show: <tr><td>row1</td><td>row2</td><td>row3</td><td>row4</td></tr>
I have two tables having similiar columns ( i had to do this to compare the values given to me, because both the table data came from different sources)
The tables named are OFFICERS token full_name division EMPLOYEE token full_name division
Now the table EMPLOYEE contains more than 5000 records and the table OFFICERS contains around 2400 records which are already present in the EMPLOYEE table.
Now I want to build a query that will return me all the records in the EMPLOYEE table that are not present in the OFFICERS table. The criteria for comparing 'full_name'. so the query should return me 2600 records that are not present in the OFFICERS TABLE.
I tried doing this " SELECT DISTINCT EMPLOYEE.full_name,EMPLOYEE.token,FROM EMPLOYEE,OFFICERS WHERE EMPLOYEE.full_name<> OFFICERS.full_name"
But this query returns me records that is not present in the OFFICERS table as well as some more 1000 records which are present in both tables. thanks a lot
I want to have a form where there is a textfield and a Browse... button to the right of it. I want the user to be able to press the Browse... button and select a file and then that filename be returned to the textfield.
I don't want it to upload it or anything like that...I just want to know the filename that the user has selected. Also, when the user presses the Browse... button, I want it to automatically go to a certain place.
I am trying to access the following site with an asp page. I am just starting out with XML URL
This is my stats page for battlefield Vietnam. I have managed to get a local verison to work if I save the source code of the page above as an xml file on my server, and I use the following code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Option Explicit %> <% Dim xmlDoc, root Dim success, player, strData, online ,rank, rp, score, kills, deaths, fttk, kdr Dim dpm, ftpm, mppr, medals, gold, silver, bronze, rounds Set xmlDoc = server.CreateObject("msxml2.DOMDocument") '
What I can't figure out is how to access the data from the external site.
This is my code can you fix it if it have an error
<select> <% set rs = Server.CreateObject("ADODB.Recordset") strSQL = "select cat from events" rs.ActiveConnection = conn rs.open strSQL if not (rs.eof or rs.bof) then for i = 0 to rs.eof response.write("<option>" + rs(i) + "</option>") next end if %> </select>
Doesn anyyone know the proper lines of ASP code to sucessfully retrieve a pdf file from SQL server. Everytime I run my code I get gibberish all over the screen. I would like it to prompt me to save the file to disk.
I have a question, is that any other way to retrieve data from another webpage besides using XML object? Because I am using XML object now but give me so much problems.
If I used MSXML2.ServerXMLHTTP object, it gives me time out error: msxml3.dll error '80072ee2' The operation timed out
If I used Microsoft.XMLHTTP object, it will hang IE. In both cases, I have to wait for half an hour or more in order for the XML object to be working again. Actually both webpages that's communicating are hosted at the same machine. The main site (ex. aa.domain.com) points to particular folder under it, while another one (ex. bb.domain.com) points to another folder which is two levels up to the first one.
What is the coding for a search form to retrieve from a database? Do I need one page or two: the second for the response? Do I search from tables or SQLs? I have both in the database though.
I am trying to access a remote email host via ASP to retrieve a list of messages for the mail account, I have tried the following code to no avail, any suggestions or pointers would be appreciated.
<% set popctrl = Server.CreateObject("adodb.connection") popctrl.Provider = "ExOLEDB.DataSource" popctrl.Open "mail.company.com",user@mail.com,"passwd"
How can I retrieve the complete URL of the current page? (by using ASP, not Javascript!)
What I mean is this - I have a long URL something like: https://www.zzzzzz.com:8080/zzzz/zzz.asp?aaa=1&bbb=2#a1
I know I can read parts of URL through server variables, such as PATH_INFO, QUERY_STRING etc. and then concate the string variable, but that is not enough! I need to request the COMPLETE URL like I mentioned in the example.
I am trying to create a facility which returns all records where the date is equal to or greater to the current date. I currently have the following which returns all records:
I have problem like that. page1 is sending some variable data to page2 Now page2 have to decide whether it has to redirect it to page10,page20 or page30 basing on the value of a variable1 which is in page1 variable data. I want know how i can access variable data of page1 in page10,page20 or page30.
i want to ask about how i need to do if i have many list of information. example i have anout 100 list where i can retrieve from database, by that how i need to do if i just want to display for 1 screen for about 10 list and second screen anothe 10 list and. what i need to do?
i'm trying to add the data of such client, some of his data have been added already but if i'm going to add or update his data (additional info.) what happened is the data is being added into new row not on the specific client. Code:
I would like to email detailed error information from my website when an error occurs. I tried to use "On Error Resume Next" and if an error occurs check the Err object and the AspError object returned by Server.GetLastError(), but I didn't get the same amount of details as I can see on the browser's window if I don't set "On Error Resume Next". Is there a way to get detailed information from IIS ?