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 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 make a data display page, its showing all records, now i want user just press print button, and that print all data on screen, secondly user input 2 dats From ..... To......, so data in between that day will print,
View Replies View RelatedNo error or any feedback that I can work with.
Code:
set objShell = Server.CreateObject("WScript.Shell")
objShell.Run "%comspec% /c NET PRINT GarchiveISLaser[color=blue]
>c:WUTempPrinter_Status1.txt", 0, True[/color]
objShell.Run "%comspec% /c PRINT /d:GarchiveISLaser c:WUTemp est.txt",
0, True
Set objShell = nothing
I can run these commands successfully from the command-prompt on the server
but from an ASP page, I get nothing not even an error. The Text output for
NET PRINT is a blank text file.
I feel something is different on the permissions side because this
code/approach use to work fine.
When I use self.print the browser launches the print prompt, then I have to manually press print... DOes anyone know how to get around this.
View Replies View RelatedI'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 have ASP statements stored in SQL and want to run them on an ASP page. I am printing the data onto the page using ASP, but the ASP code that comes from SQL just appears as actual text. For example, it appears as:
<a href="<%request.redirect("http://www.yahoo.com")%>">Yahoo</a> Rocks
instead of just the link: Yahoo Rocks
Any idea of how to run the ASP scripts from SQL, yet still print out the text around it plainly?
I am developing an Intranet application for a business. I would like to be
able to print out certain bits of information just as regular applications
do. I realize that this is a little more difficult, and after doing
research it seems that the best way to print is to use JavaScript's
"window.print();" command.
The only problem I have with this is that
#1 - it prints the address and date at the bottom of the page
#2 - it prints the page numbers at the top of the page.
Is there any way around this (without having to alter IE's configuration)?
Or perhaps do I need to approach printing in another way? Perhaps VBScript?
Is there such a thing as putting some code on a page that makes it so noone could print out that page? Maybe something that disables the browsers print function or something?
View Replies View RelatedHow to print in asp or how to use Crystal report in visual Interdev or frontpage?
View Replies View RelatedI have a problem opening a file with ADODB.Stream when <HTML> exists on the same page
here is the code I use :....
i seem to have a problem printing my timesheet to make it fit into a a4 paper. is there a way to have it to print using ASP but force it to print in a4 landscape.I have tried using my printer settings and force it to landscape,but the whole table and font comes out really big and makes it continue to print to another page.
I have also tried to use the printer settings to print into A4 or even print to 60% of the size, but still cannot. Even though the data is not really long it goes to another page.