I have a problem in my project to read backward start from the last record in my database. I need to display the graph using asp and SQL server as my database.
How can i set in asp coding to read from the last record then go to the previous record before i can display the graph... Code:
I have an ASP page that is reading records from a SQL database and passing them as a string to a DIV. I would like to do that using XML. SQL 2000 has this great XML, AUTO feature that I would like to utilize. My retrieval code goes something like this:
set objSQL = CreateObject("adodb.connection")
set objRS = CreateObject("adodb.recordset")
objSQL.Open "Provider=sqloledb; Data Source=MYDB; Initial Catalog=MYTABLE;"
objRS.Open "SELECT * FROM MYTABLE XML AUTO, ELEMENTS", objSQL
So, now I have a recordset with the XML code in there. How do I get at it? Let's say I want to Response.Write it.
I have four select options on my page. I want to display some text for each selection of my options. This display shoould be in the previous <td>. Here is the code:
View Replies View RelatedI have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
This seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?
I have a SQL database, which runs a basic search engine, it has about 3000
links at the moment. I am currently keeping track of the click through rate
and displaying in, below the link so it says HITS TODAY / HITS TOTAL.
What I would like to do now is to take it one start further and be able to
offer people the opportuntiy to have a small piece of code in their site,
that will be able to update another hits counter in my SQL server.
I obviously dont want to allow people to my SQL or open the 3306 port to the
public, I would just like to be able to load a small java / vbs or what
ever, to be able to write to my SQL..
I use http://www.counted.com/ at the moment, but I want to be able to do
just very basic hit counter, I think from looking at how other people seem
to do it, I might need to do this using Java Script
I have a Hello World app written in VS2003 C# it runs fine on my local
PC using IIS5 XP Pro Dotnet1.1 but when I up load it to my site I get the
following:
Server Error in '/' Application.
--------------------------------------------------------------------------------
Parser Error
Description: An error occurred during the parsing of a resource required to
service this request. Please review the following specific parse error
details and modify your source file appropriately.
Parser Error Message: Could not load type 'WebApplication1.WebForm1'.
Source Error: Code:
I know HTML and i want to start on somethign mroe advanced. Can anyone tell where do I start. I want to stat simple and learn the veyr basics first.
View Replies View RelatedRecently my IIS link in admin tools will not open the iis control panel. I have been doing asp development on the machine for some time so it seems odd this problem has all of a suden happened. I read somewhere a file (iis.mcs?)could be corrupt? Does anyone know how to fix it?I ask this place 'cos I am thinking that someone using ASP too also has had a similar problem or can point me in the right direction.
View Replies View RelatedI wan to start learning asp.net .is it going to be easy to first learn some asp and only then move to asp.net or can I start straight with asp.net.
View Replies View RelatedHow do i require ONLY 443 on one site and ONLY 80 on the other. The secure portion does not use Host headers. I have 2 websites on the same machine
SSL.MyMachine.com
Normal.MyMachine.com
I want the guy who hits SSL.MyMachine.com to only be able to use port 443 and never port 80. I want the guy who hits Normal.MyMachine.com to only be able to use port 80 and never port 443. How do i require ONLY 443 on one site and ONLY 80 on the other. Becuase the secure portion does not use Host headers.
Here is how it goes in simpliest terms.
We have a link to an ecommernce page, it uses sessions
(which we do not have access to change)
I want to create a popup window that will create a new
Internet Explorer browser to open (at a page i specify).
I dont mean like the javascript where it just opens a
window and contains all the info that u have (same as if
you hit ctl-n) I mean lauching Internet Explorer new
again, going to this specific site to aviod the session
that it is already in?
I know something about HTML and no more but recently i really like to learn ASP but unfortunatly no body know ASP here. How can start asp and what should i know before i start learning ASP.
View Replies View RelatedIs there a way to start the Primary Auto_Number at a specific number? Usually it starts at 1, but I would like to have it start at 5,000
View Replies View RelatedHere is the process on the site before I ask the question:
User logs in
session is created based on username and userid
user edits a record in the db
a hidden field with the userid session is inserted in the db to show
who edited the record
I had a user ( mike, id -1 ) edit a record today but the userid that
got inserted was 2 ( scott ). mike doenst know scotts credentials and
scott has never used the PC that mike is using, matter of fact scott
hasnt even logged into the site today.
The "Session_OnStart" event doesnot fire if the website has .htm file as the
startup document. If I change the extension of the default document from
..htm to .asp then I can see the event fires, But now I cant change the
default page to .asp.
How can I make the Session_OnStart fire in that situation?
my user table start off counting 1, 2, 3... (auto_number) and i would like to start it off at 100. how do i go about doing that?
View Replies View RelatedI've been using this installation of .NET for about 3 months without problems.After not using it for about ten days, I came back to my project and when I tried to run it with Debug>Start (F5), it comes up with this error.
"Error while trying to run project: Unable to start debugging ohn the web server. Could not start ASP.NET or ATL server debugging. Verify that ASP.NET or ATL server is correctly installed on the server."
Before I start de installing things,does anybody have any simple clues as to why this is happening?
I want to run a asp website in my webserver and I don't know how to setup a asp server.
View Replies View RelatedI have been running IIS on Windows 2000 for several years with no problem.
Today, when I clicked on the system tray icon and clicked start service, nothing happened - no error messages. IIS just ignored me completely and would not start.
I am about to try a computer restart - but has anyone else run into this problem?
i have a database that maintains all company policies and now i have a request to print out all policies, with one button click, sorted by department.
does anyone know of a way to start a "new" html page or create a printer line break? i'd like each policy to start on their own page.
I would like to make a database that contains Picture, Name Job description, gender and web address. The database should be able to hold at least 1000 profiles.
What program would you sugest? Where do I get it? Are there any online tutorials you would suggest?
I've installed Windows Server 2003...I created a
HelloWorld.aspx file and its associatied HelloWorld.vb
file and stored both files in the wwwroot directory.
When I put http://localhost/helloworld.aspx on the Address
line of my IE browser and press enter, I get the following
error msg:Access to..."C:WINDOWSMicrosoft.NETFrameworkv1.1.4322
Temporary ASP.NET Files oot2135a5088d69a834" is denied.
This works on my laptop which has XP Pro installed.
my understanding was when IIS restarts that time when the first session is requested application_on Start is called. My session time out is 1 minute. after every session time out happens when the session is requested then it goes to application_onStart first. Isn't application on start just happens only when IIS restarts and first session requested.
View Replies View RelatedI am trying to stop and start the ftp service from an asp page using the niuser account.
my code is simple: shell.run "net start msftpsvc",0,true. ASP page returns no errors but nothing happens. code works in .vbs but not from the webserver (IIS6).Can someone tell me how to do this? I would also like to edit the registry if i can.
Could anyone recommend a server provider that can handle asp for a site that will contain roughly 500 pages that won't cost me the earth. The site will be UK based mainly for UK customers. I have found so many but it's tough to tell who is and isn't worth the money.
View Replies View RelatedWhen I try run the project, I get an error as "unable to start debugging on the web server. the project is not configured to be debugged. " . I'm running it on Windows 2000. I've made sure that debug=true in the web.config file and the authentication mode = "Windows".
I also get an error when I try it on IE5 as :"Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS " .
If I know the week number and the year, how can I calc the beginning and ending dates of the week? For background I'm going to do some grouping by week but don't just want to call the weeks Week 25, Week 26, Week 27, etc. And the week number is to be calculated with:
DatePart("WW", [MyDateField])
I have an Active Server Page connected to an MS Access database. I use this page to submit information to the database. Among the form fields is a start time and stop time field.
By setting the value of start time to <%=Time()%>, I'm able to collect the start time automatically when the new form is opened. I would also like to collect the stop time by clicking the submit button. Code:
May I boldy suggest that a new advanced ASP forum is created (ideally within the "Advanced Development Center", but otherwise as a sub-forum of this forum) for ASP questions and discussions which are more challenging/complicated than the norm? Code:
View Replies View Relatedany attempt to access an asp page returns a 500 error. all other services work fine. tried uninstall/re-install iis.
View Replies View RelatedI installed PWS 4.0 on my Windows 95 computer. It installed and ran nicely
without any problems for several months. Then I stopped using it for a while.
Now that I need it again it won't start. The Personal Web Manager program runs
and when I click on Start to start the server running nothing happens now, not
even an error message. I see a message saying "Web Publishing is Off". This
should change to "Web Publishing is On" but it doesn't. Rebooting and turning
off Zonealarm didn't help. I'm using this to learn ASP.
Is there anything I can do to try to get it running again?
Should I uninstall it with Add/Remove Programs in Control Panel and try
reinstalling it?
I tried searching the Microsoft site, looked through the Support &
Troubleshooting area and could not find any help for this problem. I also tried
Google Groups without success.
I want to launch a client application from the server and send it some parameters. The application is written in PowerBuilder.
View Replies View Related