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 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'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 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 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'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'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.
I'm getting this error message: Error Type:
Microsoft JET Database Engine (0x80004005)
You cannot add or change a record because a related record is required in table 'employees'. Code:
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
View Replies View RelatedI have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx
2: Data xxxxxxxxxxxxxxxxxxxxx
3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.
View Replies View Relatedhow to deal with multiple recordsets on the same page?
It's gotta be something small and clear so I could understand.
Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?
I am looking to
have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to
be automatic. I am using ASP/VBScript if this somehow matters.
I have a form on an asp page which is used to add additional users to
the DB, i.e. adding a UserID (PK on table), Password & Email.
The companies are allowed a max of 3 users. If the company only has
the default 1 user and wishes to add another 1 or 2, then the form
displays the current user details, not in text boxes as this is not an
adit data form. The additional user/s can be entered into 1/2 rows of
text boxes, user 2 & 3.
If they decide to add 2 new users, how do I add the additional 2
records to my db table on submit ? Code:
i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this
View Replies View RelatedIs there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:
if SecondLastRecord then
I don't know how many records there will be, so I can't count down from 7 or anything.
Code:
Every time I try to ADD a new record from my asp page to SQL table, I got this error:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'
Here is the Insert statement:
Sql="INSERT INTO Cancelled_Classes (yrtr, cou_id, cancell_date, Message)" sql=sql & " VALUES " sql=sql & "('" & Request.Form("yrtr") & "'," sql=sql & "'" & Request.Form("cou_id") & "'," sql=sql & "'" & Request.Form("cancell_date") & "'," sql=sql & "'" & Request.Form("note") & "')" '
conData.Execute sql
I had a problem that happen once only but i do not want it to repeat
again. It happen when i retrieve data from my database. The process
can't complete and show error 14, Out of string space. I suspect the
recordset object had reach it limit that why it generate that error
message but what can i do to prevent this from happening
I have a siple script where I add a new row in a table which has also a autonumber field. Adding the new row I am trying to get this value of the autonumber field and put it in session, but can not seem to figure out how. I tryed to open a new recordset and pull it out but does not find the record I just added.
View Replies View Related