I want to display a different message deppending on the amount of stock left. For example if there is no stock i would like to display "out of stock", if the item is in stock display "in stock". Code:
View RepliesI am developing a simple ASP-Access system for invoicing purpose, and the system is in 98% progress. What I want to do now is to add some sort of "control stock levels".
Let say I have set the quantity of an item/product (eg, pencil=100) in my database (in my database it refer to the table tblProducts with the field called PStockLevel) When one customer want to buy 10 pencil, the system will automatically set the PStockLevel to 90. All the calculation will be done in the page called tasks.asp.
I'm currently writing a custom financial app that tracks stock purchases and
values. however, I need help in retrieving stock quotes from the internet. A
20 minute delayed quote is fine. I do not want to revert to "page or screen
scraping".
Is it possible to grab stock quotes (with of course the 15min delay!!) and place within an ASP page?written in ASP.it is possible to read HTML content on webpages without outputting them and then using the values etc
View Replies View RelatedI have built a site with a cart which works fine but the client now wants stock to be deducted when the items is added to the cart. I have added 3 fields to the products table Stock, inBasket and Sold. The issue is that when they add to their Cart I deduct from Stock and add to inBasket.
If the user never completes the purchase then the stock level is always too low and inbasket too high.
If the users sales is completed in PayPal they are returned to the site and their Order is marked as paid or cancelled.
What I'd like if it is possible is a way set a timer on an order so that if it didn't complete the stock is reinstated.
I have made a type of system for stock where there is a page that displays all the stock on hand. This is pulling data from a table in the database. There is another page for taking stock.
So, you click on an item from the dropdown list and then type in the quantity you are taking. This info is inserted into a different table. How do I do an update so that if someone takes 20 of an item, it deducts 20 from the stock on hand column in the other table?
Does anyone know how to implement a stock quote using ASP on a website? Any sample code or components, etc.
View Replies View RelatedUsing classic ASP, are there any examples which I can use to show a stock price of a particular stock.The URL I am looking at is:
http://quote.yahoo.com/q?s=MSFT
Is there a way that the page will directly update the intranet page with the stock price of the indicated stock?
Anyone know of an ASP application that will provide me with stock data for a
specific ticker symbol? Of course, a free app would be nice, but I'd
consider something I have to pay for.
I'd prefer something that is not an installed component (not a DLL or COM).
Suppose I have a widget A that I would like to embed in several websites B,
C, and D.
Sites B and C are happy with the widget the way I've styled it but site D
isn't and wants to restyle it themselves.
What would be the best way of doing this in ASP? My thoughts are that I
have an ASP page that determines in a query string has been provided (issued
to site D) and returns XML otherwise returns my formatted HTML.
Is there a way to tell an asp file which set of commands to run depending on what file they just came from?
View Replies View RelatedI have an ASP page with ten checkboxes and depending on which checkbox is selected I need to send an email to a specific recipient.
Thus far, I am able to send the values from page one to page two, but using CDONTS email functionality isn't really working. Actually, I can't imagine where to begin.
Is there a way of having a cells bg color change depending on its content? And what would be the best way of doing it?
I am wanting to use a traffic light style system for coloring number content cells. 0-33 Red, 34-66 Amber, 67> Green
Currently, when I'm building dynamic pages I build a page (for example, default.asp?ID=2) to process one variable within the dynamic URL (ID), and find myself having to create a seperate page if I want to process 2 variables for the same content (i.e default.asp?ID=2&Dt=3).
Surely there's a way of loading different content on the page depending if the URL you to the page has either one or more URL variables - is there a way of doing this? I've been thinking about it, and would it be simplest just writing an IF statement (e.g : if the URL contains only one URL variable, load this content, if it contains 2 URL variables, load this other content.
Would someone please be able to give me an example of how this IF statement would be written?, as I've never had the need to write an IF statement before. If you are able to give me an example of the IF statement I'm after, would you be kind enough to comment it aswell so I can understand the methodology behind it?
I want to change the text color of the input box depending on the value entered by user.
View Replies View RelatedI want to have a user input a value (1 through 10) in a form. Then click submit. and right under that have text appear depending on what they input. This is what I have, but it doesn't work. I'm not understanding the flow of the script getting called. Code:
View Replies View RelatedI am having a drop down list and other text boxes in a form. I need to retrive and fill text boxes from database depending on the selected item in drop down list. I am using javascript as scripting language. Can any body give solution.
View Replies View RelatedI have my system set-up, where by when a user accesses the cms, a time stamp is added to the database. So we can keep check of when people accessed the system.
The added benefit of my addition, is that a session timeout is usable based on the inputted timestamp the user logged in. I added this functionaility because the system could be idle for some time and if so set the session to equal nothing or similar.
However what would be a nice feature of the cms is the display of the current user.
Below is code I have inputted to give some idea of what I am doing
Session("ADID") = objRS("adminID")
objConn.Execute("UPDATE tblAdmin SET adminLastLogged=now() WHERE adminID=" & Session("ADID"))
Session.Timeout = 30 ' 30 = Minutes
SO does anyone know how I can retireve the adminUsername based on the session used when loggin into the system.
It has been said that When attempting to load an XML file saved as UTF-7 (a transfer encoding format for Unicode), the XML parser in Internet Explorer generates the following error message: Invalid at the top level of the document. The same error also occurs when using the MSXML parser from server-side or client-side script.
I am getting this error when I use MSXML 3.0 as reference in a VB DLL function called by a ASP file.
I have a website that is running perfectly on windows 2000 server and IIS 5. However we are now moving it to server 2003 and IIS6. No problem there however after setting everything up a problem has occurred. My directory structure is websites then webroot within that which contains the site files. Within webroot is also a directory called connections, which contains the database connection asp file.
It is a mysql database. Ok the problem is that I am calling the connection in my asp pages as follows (<!--#include file="../Connections/connLUKTrading.asp" -->). but the server will not navigate up a directory level as the ../ indicates. The site works fine if I place the directory connections in at the same level the site works but then I will have to do this at each of wwwroot's sub directories I should not have to. I believe it is a permissions problem to do with IIS6 but not sure. I have spent hours trying to find it.
In our application, we have noticed on two rare occasion where the
data stored in application level arrays has disappeared. We have 3
application level arrays, and many other data types stored at
application scope as well. The other data types appear to have been
unharmed.
All session level data remained unharmed as well. The data
in the arrays seemed to have disappeared all of the sudden. No IIS
restarts, for example, were performed. Is there any known issues with
arrays being stored at application level.
On our IIS 5 windows 2000 web server we have many .asp's.most of which (When right clicked / security tab / edit authentication) are
using Integrated Windows Authentication.
Is there an easy way to check ALL of them? Some of the pages require a
higher level of security (Our password reset page for example) and I am just
auditing everything and want to make sure that only the few pages that
require it are using the elevated security level. (By the way this is
accomplished by using anonymous access with a domain account that is
'elevated'...
I hate right clicking on 1000 different .asps to see the file / directory
level authentication methods... is there an easy way to do this? Maybe
through resource kit command line tools or some meta edit type tool
I am creating a simple XML file via asp and want the XML to appear in the browser. Here is what I have tried: Code:
View Replies View RelatedI have to create a web base application program, I think to use ASP but I would like to see If it supports comparison Graph. Does it support different levels of access because I have different kind of users or i have to do it manual?
View Replies View RelatedI have made sufficent pages for our site and same have been in use in our LAN since long.
Now my company has asked me to put the same on web and we are buying a domain for the same.
However I am worried for a file level security. When the output comes in asp from cod below: Code:
Response.Write("<td><a href=Documents" & adorst("ProjectNo") & "/" & adorst("Client Drg No") & ".pdf target=NEW>" & adorst("Client Drg No") & "</a></td>")
We can simply open a file from our server's folder. Even if someone knows the full path, he can simply open file. Even someone expert can delete pdf file also.
I am using Request.ServerVariables("SCRIPT_NAME") to get the extention from the url and need to know if I am in the root or down a directory. i have two folders, one called 'local' and one called 'group'
View Replies View Relatedhow I can make a dhtml menu into a dynamic menu that pulls its links from an access database instead of the hardcoded html.
I would like to know because I'm working on a site that needs such a menu and most of my administrators using my site don't understand html and won't be able to update the menu unless I can give them a simple form that allows them to add links.
How do I create an array inside an array? This certainly doesnt work...
Dim TmpArray(0 to 10)(0 to 50)
I want to open the MS Access file with user-level Security. I know that if I do NOT setup user-level Security in the MS Access file, and create the table for login in the MS Access file (Put the MS Access file in the server), then it works.
I did that. But, I want to know whether or not we can use ASP code to open the MS Access (MS Access user-level Security setting). This way I can put the MS Access file in the public place.
Can we do it in ASP?
The following code cannot do that:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/try.mdb"
%>
give me a session level timer code? I'm trying to time a quiz.
View Replies View RelatedI need to know how to disable a button based on the username that logs onto the web application.
View Replies View RelatedI tried to make our menu differend for Users for example :
If user level = 2 than
show Menu (Add Contact)
I used this code:
i'm going to ask the way to use database to check user permission level in asp..
View Replies View Related