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.
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
View Replies View Relatedhen 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
Is it poss to move records from one table to another using ms access db to arcive records and how would i do that.
View Replies View Relatedthis is the code I am using for MS Access
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,
I tried this one,: but no luck
Code:
mydb="driver={SQL Server};server=YOURSERVER; UID=YOURUSERID; PWD=YOURPASSWORD; database=YOURDATABASE"
set conn= server.createobject("adodb.connection")
conn.open mydb
Looking for the best resource (book, online article, etc) for moving from ASP 2.0 to ASP.NET. I'm ready to make the jump. What do you think?
View Replies View RelatedDoes 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?????
View Replies View Relatedi have this in the database section of devshed - but noone seems to know... so i'll put it in here now
View Replies View RelatedIs 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?
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 2 rows in the table... and i wan to do a response.write("REMARKS")
the remarks sumtimes can be longer then the width of the table...
how to i make it such tat when the max width in row 1 has been reached then it will carry on writing onto the second row of the table???
<table border="1" width="100%" id="table1">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
where to place the response.write or how to add in additional codes to achieve this function?
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.
View Replies View RelatedI 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.
View Replies View RelatedI 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?
View Replies View RelatedI 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).
View Replies View RelatedI 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?
View Replies View Relatedi try to move an entry to another table.
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/searchsrv/searchsrv.asp, line 315
Any ideas on how to solve this?
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:
View Replies View RelatedI 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()
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:
i have a formular using two text field. i want , when i finish writnig , moving to the next using " Enter " key.
View Replies View RelatedIm changing from Access to SQL Server and had a few questions:
What is the Equivalent in SQL:
Access: Memo Field
Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
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...
View Replies View RelatedI have a database with the columns:
id
name
phone
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.
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
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.
I am relatively new to ASP but am fairly familiar with PHP and ASP.NET and JavaScript.
My problem is this:
I have a drop down box which is populated from the database (Access), it sets the value to the ID of a hospital ward, and the text to the name of the ward.
I then use the ID to look up an email address for the manager of the ward from another table in the database. My un-optimised code is as follows: Code:
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.