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?
How do you go about searching three tables at the same time? I'm using Dreamweaver MX, but I can also hand code it in if know one knows the dreamweaver method
View Replies View RelatedI wish to copy the contents of a table in one Access database to an identically-structured table in another Access database. Can anyone advise me of a simple way to do this in ASP (VBScript + ADO) ?
View Replies View RelatedI am writing an Active Server Page application that will get all of the databases that a user can access. Is there a way I can do this with Active Server Pages? I also will provide the users with the option to change records, table structure, etc with this application. I will also be developing an asp.net (C#) project that will do the same thing. If anyone can provide code snippets.
View Replies View RelatedI need to retrieve the tables list from a MS Access database.
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?
i have 2 tables;
table01:
fields are
field01,field02,field03,field04,field05
and another table
table02:
fields are
field01,field02
when someone submits the form, i want to add the infos supplied by the user to be added to these 2 tables.
field01 & field02 shall be added to tables 1 & 2;
&
field03,field04 & field05 to table01 only
i tried using this code:
myquery = "INSERT INTO table01 (field01,field02,field03,field04,field05) VALUES ('" & f1 & "','" & f2 & "','" & f3 & "','" & f4 & "','" & f5 & "')"
myquery2 = "INSERT INTO table02 (field01,field02) VALUES ('" & f1 & "','" & f2 & "')"
adocon.execute myquery,myquery2
but this one only adds to the first table.
can someone tell me how to fix the problem?
I'm trying to do a very simple code that converts the server time into a time zone of your choice.
<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>
but obvisouly i'm having trouble with the time zone convert.
I show information from a database in a table format. I will be showing more and more data and would like to show it one page at a time with a next page back page option.
Can I do this on a web page and does anyone know where I could look to find out how
Does ASP have a function to list all the server variable similar to PHP's phpinfo()?
View Replies View RelatedI am trying to build a site for a group which already has a hosting company.
I would like to try to find out which objects are available for use to me.
I do not have admin access to the NT box. Obviously I have permissions in
my area of the server.
I know I can test for specific objects but I'd like to know what is
available, not just what I can test against. Is this even possible? Code:
I'm porting an access to sql. In a few tables i have a Time field whic is set to Time() when the data was inserted. It doesn't get modified.
In sql the time now displays as 1/1/1900 23:45:03.
The Default value is set to (convert(datetime,convert(varchar,getdate(),14),14 )).
I have a time out error from my asp application thought my connection timeout is 6000 sec but when i execute my page it gives me error after 30 sec.Is there any mothod to fix it
View Replies View RelatedI am updating a value in DB by the following command.
strSQL3 = "Update Click_Count Set Click='1'"
objConn1.Execute(strSQL3)
The data type for click in DB is nvarchar. I've also tried int and numeric but none of them works. The web page processes for a while and then says "time out".
I have the date displaying at the top of a page using this code: Code:
<% Response.write(WeekDayName(DatePart("w", Date())) & " " & DatePart("d", Date()) & " " & MonthName(DatePart("m", Date())) & " " & DatePart("yyyy", Date())) %>
Unfortunately there is a big time difference (about 18 hours) between the server and the site and I need to make it display the local time.
i want to get the server time with asp code. i'm getting only the local machine time with
<%response.write time()%>
How can I get date and time on the server. I want to log the date and time on the server when the ASP page is accessed.
View Replies View RelatedI'm looking for a script that will call up the date and time on the server. The scripts I've gotten so far seem to use my computers time and date If I change them on my pc they will change allong.how to call up the servers time and date, if possible.
View Replies View RelatedI want to be able to redirect clients based on the server time. This is to direct clients from different parts of the world to different pages. Have seen a Javascript thta does this based on the clients time but can't find anything that does it using the server time.
View Replies View RelatedIn ASP, how can I quickly return the server time + 2 hours, using VBScript?
With TIME(), I've found functions for date arithmetic, but I can't find anything for
time arithmetic.
Does anybody know of a good way to get a list of emails from the corporate
exchange server from a corporate website?
I now know how to call up the server time and date, but can this also be done for just the hours, minutes, seconds, weekdays, year, month, days. Each of the individually.
I'm looking for the server numbers not the ones from the users pc.
suggest the correct way to store the date & time in SQL Server? I want to store the date and time a record was created. What should the field type be in SQL Server? How can I insert the current date/time into the table using SQL? I used to have date/time field type in access and use the following code
currTime = Now()
SQL="Insert into <table> (id, recDate) Values (" & sId & ", #" & currTime &
"#)"
conn.execute(SQL)
what the field type I should be using in SQL Server to store this date and also what should I replace the line currTime=Now() to?
I've been using SSIs for a while now. I'm now using them in a menu system. I'm trying to use multiple SSIs, that is SSIs within SSIs, but I'm just wondering if this will slow the pages down, and put too much strain on the server. I'll try to illustrate what I'm doing.
This is a dropdown menu system. Rolling over Link1 will reveal Link1-a, Link1-b and Link1-c, and likewise with Link2 and Link3: Code:
My server hangs for a really long time after I run the following code...
It is to serve up 3 types of files: a picture, a word document, and an mp3 file from a directory "/uploads" that is not accessible through the URL. The script works perfectly for the picture and doc file, but nothing loads when it is used for the audio files. The files are a few megs large, but after I run it I can't access ANYTHING on the site for quite some time.
What's wrong? Is it something wrong with M@rco's script? Did I impliment it wrong?
I don't mind if it simply takes a long time for it to load the audio file, but it is killing the entire server it seems like. Code:
Do you know any way to load a page, wait for 5 seconds IN SERVER PROCESS, and then redirect in the server side, - not using javascript?
What I pretend is to show a page that loads a .GIF file that appears to be loading something, and after 5 seconds redirect to results page, so users apparently think that a backend proccess has occoured.
I was wondering if anyone knew how to determine how to determine the
client's time zone from within an ASP page?
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 RelatedI have a chunk of code, where based on the user's selections, it goes through a database and selects all of the records from the database and writes them to a text file (the database contains nearly 600,000 records), currently, the file is written and the user would end up having to wait for it to be written, before continuing.
Is there a way that this file could be kind of.... tagged or something, so that the server creates it in the background, instead of while the user waits, so the user can continue doing other things, rather then having to wait for the text file to be created.
The files can be quite large, as they can end up being anywhere from 1 - about 600,000 records with between 4 - 10 fields each. Here is a sample of the code that creates the text file. Code:
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I am starting to build quite a few pages that will have
tables of data from an SQL database.
I have been building the table rows on the server side
in VBScript, but I have been thinking about having the
VBScript code just build array variables in the <head>
section (or as local variables), and then have JavaScript
functions on the client side actually populate the tables
when the page loads.
I do plan to do other things like being able to sort the
tables in JavaScript code on the client, limit the tables
height and be able to scroll the rows, and click on a row
in the table, and have the values populate a form. I will
also need to be able to export/download/? some tables into
Excel.
How 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 RelatedI'm learning ASP with a database in Access (new to Access also). I have created my tables and all but I'm stuck on how to query the table. I'm familiar with sql statements, so I was wondering if you can access the database the same way as with php and mysql. I.E.
Code:
Select * From Table Where id = 5.
Something like that, or will I need to use
Code:
objRS.Filter "ID = 5"
I guess the main question is does Access accept SQL statements and if so can you give me some examples as to querying the database.