Hello Sir,
Thanks a lot for your suggestions.
Problem solved.
Thanks ...........:)...
giandeo
Last Activity: Dec 17 '08, 07:44 AM
Joined: Jan 24 '08
Location:
-
Hello Dr B
Thank you so much for your valuable suggestions. I have gone through the document you suggested for inserting data in a database.
I am getting the following errors when I run the script.
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
Could you please locate the...Leave a comment:
-
Sir
I am using classic/pure ASP. I am writing my scripts in Dreamweaver MX 2004. My file ends with .asp
Frankly speaking, I am not an expert in programming but I always struggle to learn and help students in my locality.
I heartfully thank all of you for your valuable help.
As stated earlier, I know how to import the excel file into SQL Server 2000 using the DTS import Export wizard.
...Leave a comment:
-
Hello Sir,
Thank you so so much for your intervention and suggestions
I have tried to import the Excel file using the DTS Import Export Wizard and it works.
But, I do not want to run the wizard times and again to import the Excel file. I wish to write a script using ASP codes to do the task.
Could anyone help me please....Leave a comment:
-
Could we import an Excel File into SQL Server 2000?
Hello everybody
I am trying to import an excel file for days into MS SQL Server 2000, unfortunately, I cannot see a ray of hope till now.
I have surfed the WEB for hours, but again no concrete solution.
CAN ANY ONE COME TO MY RESCURE PLEASE.....
Actually, I am solving a problem for a student who wants to import an Excel file called ExamResults into SQL Server 2000.
... -
Yes. The solution works fine. Thank you so much .........Leave a comment:
-
Hi
Yes.
Table 2 and table 3 contains the same fields but different data from different sources. In fact, they are watchlists through which data from table1 will be filtered.I have included a source (tablename) to differentiate between the tables.
If the surname of a passenger from table1 matches the surname in table2 and also matches the surname from table3 then, I wish to get two records with same surname.
...Leave a comment:
-
query two or more tables
Hello everybody. I am in a mess. I am unable to retrieve data from three tables. Please advise.
I have 3 tables in access. None of them has a primary key.
Table 1
Passenger surname
Passenger other name
flight number
Table 2
Passenger surname
Passenger Other name
Offence
tablename
Table 3
Passenger surname
Passenger... -
How to convert ASP page into PDF when user clicks a button?
Hello experts.
Could any one suggest me how I could convert an asp page into pdf (on-the-fly) when a user clicks a button on a web page.
Waiting impatiently for your reply.
Giandeo -
Thank you so much for your valuable suggestions. It works!!!!!...Leave a comment:
-
Hello Dr B
I have tried the IDENTITY setting and it works fine
Thank you so much.
Now, the problem I am facing is in retrieving the IDENTITY field once it has been saved in the table.
I am adding a record in one table and at the same time I am trying to keep a backup copy of all additions, deletions and modifications in another table. The record is successfully added in one table but it...Leave a comment:
-
SQL Server - Auto increment primary key column
Hello Dr. B
Your solution is amazing. It works.......... .Wowh. Thank you so much.
I still have one problem.
I am using the autonumber of the access database as primary key. When I imported the data in MS SQL Server, the autonumber got converted into integer.
I do not know how to go to the bottom of the database and increment that field while adding data.
Could you please give your valuable suggestions... -
Hello Dr. B
Sorry Sir, I could not reply for so long because I was ill.
I have tried the codes you suggested, but unfortunately, I could not create a connection to the MS SQL Server.
Here are my codes:
...Code:<% 'declare variables dim conn, rs, x 'set connection to database set conn=Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLOLEDB;Leave a comment:
-
Connecting ASP to MS SQL SERVER 2000
Frankly speaking, I got much help from Experts CrowCrew, DrBuchman and others when I was learning ASP with MS ACCESS as backend.
When I was using ASP With Access Database, I was using the following codes for connection with the Access Database which resides in the inetpub/wwwroot folder.
...Code:<% 'declare variables dim conn, rs, x 'set connection to database set conn=Server.CreateObject("ADODB.Connection") -
giandeo replied to Populate Pull down menu from access database on selection of previous pull down menuin JavascriptThank you so much for your suggestions Sir. I am going to have a look about how AJAX works and will soon report to you....Leave a comment:
-
giandeo replied to Populate Pull down menu from access database on selection of previous pull down menuin JavascriptNo sir, I do not know AJAX, I am new to programming. I am learning ASP and Javascript....Leave a comment:
-
giandeo started a topic Populate Pull down menu from access database on selection of previous pull down menuin JavascriptPopulate Pull down menu from access database on selection of previous pull down menu
Hello Experts.
Could you find a solution for this problem please!
I have the following tables in Access Database
Table Name: origin
Fields Names: country, countrycode
Table Name: make
Fields Names: countrycode, make
Table Name: toyota
Fields Name: model
Table Name: nissan
Fields Name: model
Table Name: mazda
... -
Hello Experts.
Thank you so much for your help.
I tried the code suggested by Shwetha. It works fine.
Thank you ........Leave a comment:
-
Hi !
Thank you for you suggestions.
I have tried the code but it does not work.
The date and time set on my server is different from that on the browser of the client.
Anyway, thanks a lot for your help. I will truggling to find out the solution and will definitely publish it here for any one to use in case of need....Leave a comment:
-
Could we display the server time on the client browser ?
Hello Experts.
I wish to set the date and time on my PC which actually i am using as a web server and want users see that date and time when they load my web page and not that is set on their browsers.
Could you help me out please!
No activity results to display
Leave a comment: