I have created a recordset with cursortype 'adOpenDynamic'. i have used "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
connectionString to open connection.
The problem is that ASP renders Operation is not allowed in this context' error when i call the moveprevious methord of that recordset. I have discovered that it doesnt move previous when i used a joined query. and it works perfectly when i use single table query. the recordset code is:
Set client = Server.CreateObject("ADODB.Recordset")
client.ActiveConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
client.Source = "SELECT * FROM customer c inner join business b on c.id=b.cid"
client.CursorType = 2
client.CursorLocation = 2
client.LockType = 3
client.Open()
...and a form with 2 text boxes containing 'Firstname1' and 'Lastname1' when the page is loaded - I need a button or link to load 'Firstname2' and 'Lastname2' into these boxes.
If possible, I'd like to be able to do this without refreshing the page....but if not it doesn't really matter too much....
What I want to do is have a recordset with all records in and display a list by title with a tick box next to them, then goto a new page which the recordset is all the records that the user selected on the previous page.
Code: mydb="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("database.mdb") & ";" set conn= server.createobject("adodb.connection") conn.open mydb I want to know what code I can use to connect via MS SQL,
Does anyone know how to code a button that when hovered over moves. Then maybe on the 3rd roll over it will not move and actually allow the user to select it?????
Is it possible to moves files to and from other servers in ASP? I'm in the process of incorporating a VBS script into ASP that used to do this job for me. However the VBS script was setup to run through Task Scheduler as a domain user, which allowed it to connect to remote hidden shares.Or alternatively, could I leave the VBS script as it is and have the ASP page execute it on demand somehow?
How would I go about reordering records in a database? Say for example, I wanted to change the output of something, and I could just click a link which would move the record up
I have to move a file(Excel file) to a folder that resides in a different server using asp. how do i that. I tried using move file method in file system object, it says file path not found.
I have a web site and database is on SQL server,now I need to move it from this server onto another one that is on a different location as well.This process is completely new to me,would somebody have an advice or a link where I could read some info about doing this, as I am not sure where to begin.
I have a freind who wants to convert his ASP site (with a HUGE MSAccess database) to MySQL etc. so he can move to a Linux server.What all would be involved in the conversion? I have redone an ASP site to .xhtml and .php but there was no database to deal with.
I don't know anything about the ASP language. One of my client's would like me to host their website, already created with ASP. Down the road, I need to re-design the site and convert the back-end to PHP. However, suggest the best method of moving the entire site to my Windows 2000 server?
I currently have the below working they are testimonials, displaying 1 every day and therefore i would like be able to page through them from clicking a next> or more> link also
if WeekDayName(weekday(now)) = "Monday" then Response.write("") else if WeekDayName(weekday(now)) = "Tuesday" then REsponse.write("")
I need to move some SQL tables from one unresponsive ISP to our new mo bettah one. Naturally the current host is not being quick about getting a cd of our tables to us. I was going to write code to move them from one place to another but it is not so easy. If it runs on the old server it can't access the SQL on the new server and vice versa.
The alternative that I see, is to download them into text files and rebuild them on the new server but that is a lot of work. Any quicker fixes out there that anyone knows about?
If I have a page. And I want to move this. What is the best way to do this while preserving the rankings in Google (and other search engines)? From what I've read, I want to send HTTP 301 (Moved Permanently) when the old URL is accessed. But I believe Response.Redirect sends HTTP 302 (Moved Temporarily).
I have an asp page that has 12 tables, 3 tables per row, . Im trying to get my query to fill each table with 6 records and then move to the next table with 6 records...etc then after the 3rd table start a new row. I know I have seen an example of this before, can someone point me in the right direction?
I'm trying to build a quiz site. The page would show 1 question at a time. Basically the questio and the 4 options are being shown in tabular format. Now I want to use the same table to fetch the next set of records.
how to reuse the existing table to wipe out the previous record and to display the next record without losing the page variables.
hen administrator logs into the system, they can view all of the members' details. So they search for a member by id/name and the members details are brought up. From THIS page I have a button "Get members records" which is to display the records in the system for that member.
The button at present calls the getRecords.asp file which shows the date and has a change date calender js function. (this works fine) What I want is for the administrator to choose a date from the calender and to see the users record for this date without having to go to another page.
It would be easy to have them choose the date on the previous page and then see that record, but is it possible to have them choose the date and then automatically get the figures displayed in the text boxes, all on the same page
I'm moving a ASP-site that my brother has done from a Linux server running ChiliASP to a Win2003 IIS server. Almost everything works fine, but one page doesn't load. Calls to the function datum_6_siffror doesn't work. Code:
I'm currently migrating an ASP/SQL 7.0 site that runs on Windows NT 4 server to an ASP/SQL 2000 platform running on Windows 2003. The current server resides in Orlando, FL. The new server will reside in Miami, FL. Here's a recap.
Old Location/Server: Orlando, Florida SQL 7/ASP/Windows NT 4
New Location/Server: Miami, Florida SQL 2000/ASP/Windows 2003
Along the way, many apps are breaking (which was expected). I've successfully recoded CDONTS to CDO and I'm slowly working my way through 1999 code.
I also found out the hard way that you need to explicitly tell Windows 2003 to run ASP pages or it will ignore all calls. I also performed the User migration steps from SQL 7 to SQL 2000 which was a breeze with the help of the Microsoft knowledge base. Code:
I want to do one of two things and I not sure which until I know the difficulty level (knowing a little asp but not alot) of each. I am helping in the office and we will have several small access dbs using the FrontPage forms methodology.
So, now that I have some data bases, I will want my users to be able to 1)copy the database to their own machine where they can massage and do whatever they need to with the data, or 2) perform a query against my data bases, and have that result sent in db form to their machines to do whatever.
I've seen somewhere that asp has some file system components but am not sure how that works. I am willing to read and figure it out if I can get a push in the right direction.
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
ok i have a number lets say its 36 and i want to divid it by 150.... 0.24 returns... i want to change 0.24 and make it a percent to it would be 24% how would i do that...
I have a web form with three textboxes and a button. How do I move through the records by clicking on the button. e.g, the page loads with the first record in the textboxes, if the button is clicked it displayes the second record, if it is pressed again it moves to the third record and so on.
Is there a way to force a sub or a function to be executed before the user to move to another ASP page?
In fact I want to update a basket (table) if the user wrote a quantity for a product in the page. I want to avoid them to click for every single product they add.