Retrieve Tables List From Db
I need to retrieve the tables list from a MS Access database.
View RepliesI need to retrieve the tables list from a MS Access database.
View Replieshow can i retrieve the list of username from an Active directory (exchange server) to my website forexample to a table or Gridview.
View Replies View RelatedI have coded 2 drop down lists. For ur info, currently my 2nd drop down list's content is being retrieved from one single table in database only. What if I would like to make the content of my 2nd drop down list to be populated with data from 2 different tables?
What i mean here is that, the selected value in 1st drop down list will determine data from which table to be loaded into the 2nd drop down list. Earlier I'ved coded my SQL statement as:
SQL = "SELECT x.language_ID, x.language_name, y.msg_category " &_
"FROM Language x INNER JOIN outMessageENContent y " &_
"ON x.language_ID = y.language_ID"
where data for 1st drop down list is loaded from table x and data for 2nd drop down list is loaded from table y.
My 1st drop down list only has 2 values., which are 'English' and 'Chinese'.Now I would like to make it as, if user select 'English', then my 2nd drop down list will refer to that particular 'English' table, while selecting 'Chinese' will allow 'Chinese' table's data to be loaded into my 2nd drop down list.
So what shall I change in order to filter the 2nd drop down list's content according to the selection from 1st drop down list? Shall I modify my SQL statements?
When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?
I know how to create dynamic tables in dreamweaver to display fields and records in a table of a database, but in my case I need to create a dynamic table that lists all the tables in the database, then to click on the one i want 2 edit the data in there.
View Replies View RelatedHow can i list out all the email address into my website from the hotmail caontact list? i am successful log in into the yahoo contact list by using serverxmlhttp and list out all the email address from the page source, but i could not access to hotmail by using the serverxmlhttp. Is any other methos can list out the email address from hotmail contact list?
View Replies View RelatedHow to value in drop down value from mysql database ..
Technical Languages:
Front ENd: XHTML
Validation: JavaScript
Server Scripting: ASP
Server:IIS
Database: MySQL
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 write the code as floowing to check the file nam before submit , but it show nothing when i click submit button. Code:
View Replies View Relatedif i have 08/21/2007 11:07:27 AM in the database..
what should i do to just show it out as 08/21/2007 ?
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>
I know that you can retrieve data from a form using
Request.Form("name"), but how do you retrieve a file?
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?
View Replies View Relatedhow to retrieve a data that has been selected using combo box with asp
View Replies View RelatedIf i have got a cookie which stores the username and password of a user, how do I retrieve the values, e.g. I want to retrieve the username.
My page so far is: ....
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.
View Replies View RelatedI want to take a string like this:Code:
string = "THE RED GIGANTIC AND HUMONGOUS"
and retrieve only the words over a certain length or longer (let's say 5 characters), maintaining spaces between them- result:Code:
string = "GIGANTIC HUMONGOUS"
How can I retrieve data from Ms Access Database which is located in another computer over the network.
View Replies View RelatedI 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.
how to retrieve the computer name using ASP?
View Replies View Relatedi have this code to retrieve the picture from the DB , it works but diplays the image like this :
^%&YGTHDS&&%@$&% ....
and what is the code to save images in the DB ?
any open source solutions around? I'd like to feed in a city name and have the X and Y coordinates returned.
View Replies View Relatedi'm passing in a parameter using session like this,
<a href ="hazard_action_formP1.asp?<%=session("harownrefpass")%>">
how am i to retrieve the parameter in hazard_action_formP1.asp?
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.
View Replies View RelatedI use a access database with asp and i insert one record. I want to know the Id of the record inserted.
View Replies View RelatedI 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"
%>
i've email stored in DB, i just wanna know the syntax of how to write it in "objCDOSYSMail.To" Code:
View Replies View RelatedI have several Virtual Directories pointing to the same code base and I want to be able to detect which one the user came through.
Is there a simple way to do this? (Currently we're parsing the URL, but I don't get a "warm and fuzzy" doing that.)
I am trying to get informaton off the URL to display in dropdown menu with asp. not from xml file but data from a URL.
View Replies View RelatedI searched this forum but couldn't find:
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 now need to do the following:
select * from shows where showDate >= today
Anyone know how I do this?