i was wondering if there was a way to move a set of records from one database into another database??
Basically i want to archive a whole heap of records that i already have in on database.
Im using an access database as well
Even moving them into a nother table would probably do as well.
I've been writting small simple webpage for years using FrontPage and ASP.
I'm thinking it might be time to take a look at ASP.net but am not sure
where to start. Is there a suggested site that would help someone move from
just ASP to ASP.net? Things like in ASP you'd write the code like X and in
ASP.net you'd write like Y.
Is there a (Free is possible) application that I should use to develop
ASP.net code in? I assume that FrontPage isn't going to cut it.
I'm building a small CMS, and i've run into a "small" problem. I need a simple way to sort menu-items, have up/down arrows, to move menu-items. my table
id, item_name, item_order, stamp
1, Main, 1, 20060822
2, Contact, 2, 20060822
3, News, 3, 20060822
any clues?
I have been running asp for several years and want to know if I could, what would I need to do to run asp and dot net on the same server. In other words, what more would I need to install on my server.
View Replies View Relatedwhat do you think about moving to asp.net? All the code must be rewritten! asp.net a lot more faster than asp ? is it only advantage?
View Replies View Relatedi have a page that calls images from a database, that is 3 images a page but in my database i have more pictures for one record, so i want to have something like a link that will call the next field that has an image and i want it to replace the ones that i already have.
View Replies View RelatedI have asp pages running on IIS of XP prof.
I want to move to the apache web server
Can anyone explain how to do that?
i have a page that retrieve images from a database, but know the thing is i can only retrieve 3 images per page and i have a link that must call more images from the same record but replacing the ones that i already have!
View Replies View Relatedi have a text area for user to enter remarks. and their remarks can be very very long
my output page is a table which i underline the lower boundry of the table.
when i wan to output the remarks on this line,it will over shoot the line and page.how do i make it such tat it will move onto the next line?
I have a SSN Field which include 3 text boxes. How do I move the focus from one box to another as soon as user enter the max characters in the text box.
For example:when users enter 123 in the first text box of ssn control should move to next text box.
I have about 10 records within my database and would like each one to be on a featured page - I would like my SQL query to scroll through and display the next record with the database every 1 month.
As I only have 10 records, I would like the query to infinitely repeat this process. What should I add to my SQL query to allow me to do this?
I'm trying to figure out how I could move the first value in an array to the end of the array so that the second value would then be the new first. I can't really wrap my mind around how I would do this.
View Replies View RelatedI'm trying to use either one of these methods to position the cursor in a specific position inside a recordset, but neither one seems to work. For example, I have 10 records in my rsData recordset, and I issue this command
rsData.Move 5, 1 'move to #5 from beginning
I then retrieve rsData("field_name"), expecting that it'd return field_name of record #5, but it doesn't seem to work like that. What am I missing? Is there a restriction on what type of cursor a recordset must be opened in?
I'm using W2K/IIS5/ASP.
I want to move to next data in the data set, however i am not sure what is the syntax.
Can anyone who know please advise me?Code:
strsql = "select main_cat_id, cat_name from main_categories where main_cat_id in (26,27,28,29)"
set rs = connectdb(strsql,strconn)
for i=0 to rs.recordcount
response.write rs("main_cat_id")&"<BR>"
rs next
next
I am trying to make it where when the highlighted item from the pull down menu is selected then a small descripion will appear in the text box next to the pull down menu. Any ideas, I am sure it is simple, but I keep banging my head off the walls trying to get it. Code:
View Replies View RelatedIs there a function in ASP/VBScript that allows you to move/copy files from one folder to another. I have an application that run a script on some files and once this is done they need to be moved to a backup store.
View Replies View Relatedhow can i do an swapping of images by dragging an image into another image to swap their position.
View Replies View RelatedI have a database with a table containing user names and I want to be able to move to the last record and display the user name.....so the end result is that I can display on my main page:
"Welcome to our newest member: XXXXX"
For some reason I cant seem to do this, it says to me that objRst.MoveFrist is ok but objRst.MoveLast cannot be accepted. Here is my code:
I'm curious as I am in need of advice on how I can move a site from an old Win 2K server, to it's new home on a Win 2003 server, without having to mess around with downloading/uploading the file's (there's over 30,000 file's/folders, so it would take forever to do it manually).
I've heard of an ASP script thats capable of this, but can't seem to locate it.
i have written a small asp code with backend as oracle.i have created a small database which is accessed by asp. now suppose if i have to move the database to another system along with code what should i do.
View Replies View RelatedI am trying to put a buuton into my page which will take the user back to the previous page. The reason i am doing this is that the user may come to this page from more than one other page.
I am using this code for the button, which i have seen on many code examples, but when i click on the button, it results in an error as if the existing page is trying to load itself up again.
<form>
<td width = "325" align="left">
<input type="submit" name="back" value="Back" onClick="javascript: history.go(-1)">
</td>
</form>
have also tried using the javascript: history.go(-1) code in the form declaration as the onSubmit attribute, but this just makes the same page load up again.
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.
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
when i update a database from an asp page i get the error:
**filename**
Source: Microsoft JET Database Engine
Error: 80004005
Description: Record is too large.
Line: 435 Column: 0
Code: Connection.Execute(sSQL)
is there a limit to the maximum updatable fields that anyone knows? the fields are text but theres 62 to update, it seems to top out at about 18 fields?
I'm making a leaderbord in golf and i only want the top 3 leaders out from the database. My code is as follows.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Driver={MySql}; Server=myserver; uid=username; pwd=password; database=database; option=3; port=3306;"
Set rs = Conn.Execute ("Select TOP 3 FROM leaderboard ORDER BY points desc")
WHILE NOT rs.eof
%>
I'm getting this error message.
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '3 FROM rangliste ORDER BY Oakies desc' at line 1
I have a javascript function that sends table data to excel. One of the tables is 238 rows, not big but it doesn't send, i know the code works because i tested other scenerio's and they all went to excel. Does anybody know how many records you can bring to excel?
View Replies View Relatedtrying to make a DDL with records with only checkbox's that are checked in database
View Replies View RelatedI have a few fields in a table: ScoreA , ScoreB, ScoreC , TotalScore
how to i sum up the number value in the Score A ,B and C
and save too TotalScore field ?
Is it something like below
do until rs.EOF
for each x in rs.fields
totalScore = totalScore + x.value
end if
next
rs.MoveNext
loop
or maybe use this
SqlQuery = "SELECT SUM(ScoreA,ScoreB,ScoreC) AS TotalScore FROM Scores WHERE Member_ID = " & memberid & " "
and then do a sql update ?
How can I get the last two records of a RS,I use this code to get the LAST record,but I want the LAST TWO records.
Code:
Private Sub GetLatestRecord()
Dim SQL
SQL = "SELECT * FROM tblHouses WHERE DateAdded = (SELECT Max(DateAdded) FROM tblHouses)"
SET objRS = objConn.Execute(SQL)
End Sub
Im having some trouble displaying top 10 records.here is my sql in my asp
strSQL1 = "SELECT Top 10 * FROM tblFlashinfo ORDER BY Vote_Score DESC "
it orders them correctly but displays all of them not just the top 10 . How can i fix this?also i have another question, i need to make sure a user can only submit a form with the same hidden field value once in a 24 hour period. Is this possible and if so how may i do this? both problems can be seen in this little system im making.
i want to have a table like this
id
Gift_Id
id will be autonumber and gift_id will be alpha numeric field . i want to generate this table with a query. i want to have the alpha numeric field to be 12 digits long. so i want to have like 50,000 records for it. how can i do it.
is there a command so i can read the lastest record/column added to a specific table?
i'm trying to read IDKEY from table A & copy it into table B.
Code:
Surname = ChkString(Request.Form("Surname"))
SQL_CUSTID = "SELECT * FROM cust WHERE CUSTID= 'Surname'"
CUSTID = SQL_CUSTID
sql_insert2 = "INSERT INTO buy (CUSTID) " &_
"values(''"&CUSTID&"')"
objConn.Execute sql_insert2