Is there any way to attain the names of the tables in a database from using
either ADO connection or ODBC or any other type of connection.
The reason I wish to do this is so that I can display all the information in
table (field names and values - this piece of code works) from a dynamic
SQL statement.
Our ASP web application uses connection object from global.asa. We hard coded Uid and pwd in global.asa.
Is there any way we can encrypt this Uid and Pwd in global.asa, or can we access them through environment variables, if so can some one give me a sample of code( to access environment variables through asp code.)
I have an access database residing on one server that contains necessary data for this application, have sql database that also contains necessary data and resides on another server.
For two access databases I would just "link" the tables and be done with it, but when attempting to do this with ODBC connection to the SQL server I get
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<% Dim conn Dim rs Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Set cmd = Server.CreateObject("ADODB.Recordset") conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa" conn.Open
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
I need to know where I can get information about learning how to code in ASP. This getting cide snippets and such doesn't work out real well if you don't know what to configure. Also I would like to have my own work not someone elses.
In different examples I've seen different ways to do the same thing, and I want to know what is best (fastest, easiest to remember, same command for all types of stuff, etc)
For example, to get data from a database, should I use:
[VBS]set rs = conn.execute sqlstmt[/VBS] or [VBS]rs.Open sqlstmt, conn[/VBS] or something else?
I have a form that I use a few option selections from DB table and a insert script at the end.I'd like to have access to aditional info from the same table after choose an option
I am trying to retrieve data from a dropdown listbox in asp using:
<%Response.Write + Request.Form("cboBox")%>
The problem is that I only retrieve the first value of the option. For example, if my first option was <option value=this that>, I only can retrieve "this". It won't get the second word.
Recently, I came across a site with information to my area of knowledge. The pages have been designed and consist of the .asp extension in the url. I'm not able to select the text on the web page, either click right mouse button or anything to copy the information. when I'm trying to print it is not perfect. So, I would like to know from ASP guru's whether there is any way of saving the information on the web pages, so that the same can be formatted in a word document for printing purpose.
My web site is windows authenticated. When someone connect to my site, I get his SID with a small active X object which uses OpenProcessToken and GetTokenInformation (token user etc ...
But now, I also need the SID list from AD user object SIDHistory. (when a user is moved across domain).
I've got a WYSIWYG editor, that runs off a template page (i.e. template.htm) that gets opened in an iFrame for editing. How can I get it setup so I cange the template at the click of a button? I've tried doing a form with radio buttons, but can't get it to work. For example, the iframe source has been set to "strTemplate". My form processing was along the lines of:
<% If request.form "template" = "template1" then strTemplate = "template1.htm" Else strTemplate = "template.htm"
If request.form "template" = "template2" then strTemplate = "template2.htm" Else strTemplate = "template.htm"
Basically I want to be able to send users (if they sign up to it) an SMS alert whenever someone leaves them a message on a webpage. Similar to Hotmail where you can get an SMS when you receive an email, or Ebay where you can get alerts if you are outbid.
I'm thinking maybe something very similar to CDO in terms of coding Code:
im running an asp page where by i can upload a xls file- which adds data to a database provided it passed validation. this then sends a success message to the user. what i need is a button where i can call the data which was recently added into the database- but dont know how to go about it or code.
<% FOR EACH field IN size_info.FIELDS Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>") NEXT%>
to loop the names of the fields in a DB, but I cannot get it so that is the value of the data in that field is lower than 5 it simply doesn't show, i thought i might be this
<% FOR EACH field IN size_info.FIELDS if size_info.fields.name.value > 0 then Response.write("<option value=''>" & replace(field.name, "asize", "") & "</option>") end if NEXT%>
Is this the right forum for this. Considering using this but not sure, specially considering the price and I would need to add a host. If you have any knowledge please let me know. Also if this the right forum, also let me know and I will give more details. It is an ASP program of course.
Currently I have one asp page which opens after the proper ID entered by user and it generate <A> tag with application software download link. When the user click on the link (which is pointed to the actual physical file.EXE of Size around 10 - 20 MB) it downloads file. But how do i change the logic so that the activity will get LOG in some text file. Like which user has downloaded which file. (it should log into text file).
I think I need to remove the <A> for direct download instead it shoudl call an asp page whcih should log the event and push the file to user.suggest with sample code if possible.
When you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
I am working on a users system for my site. I have the databases and most of the pages set up. But, I need to create a page called "My Info". This page would display only the information of the person that is logged in.
I am curious as to how I would retrieve only one entry in an access database and display it based on the person logged in.