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?
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.
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).
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 Replies View RelatedI 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.
Well, my script consists in check if the typed code doesn't exist in the DATABASE, but thats not the problem... the problem is that the PAGE1.ASP (that check the code) redirects to the ADD.ASP that will add those codes to the database!
Response.Redirect("add.asp?cod_1=" + cod_1 + "&cod_2=" + cod_2 + "&cod_3=" + cod_3 + "&cod_4=" + cod_4 + "&cod_5=" + cod_5 + "&sexo1=" + sexo1 + "&sexo2=" + sexo2 + "&sexo3=" + sexo3 + "&sexo4=" + sexo4 + "&sexo5=" + sexo5)
That's the line in page1.asp that redirects to the add.asp. So, when the database is completed empty and, the page1.asp checks that there ins't any problem with it and redirect to the add.asp that doesn't update my database!! So, it continues without any record. But, if the database has, at least, one record, the script works normally without any problem!
Another thing that I noticed is that when I, manually, type the adress Http://127.0.0.1/add.asp?cod_1=176096, for example, and the the database is empty, the script does the UPDATE and adds the code to the table!
I have no idea that the problem is. Does any one have a clue?
The goes the add.asp script: ....
I'm not sure if this is an ASP thing, a IIS thing, or a GoDaddy (where my domain is registerd and forwarded from) thing...
First I'll start by saying I run my own Windows XP web server and do all the coding myself..
I've noticed in the past (and never really gave it much thought, because the site works fine), that when I switch pages within my site, that the URL line is not always updated.
For example, I go into the pictures section, view a few pictures, then select the "Home" tab... The URL will stay with the variables that were passed when I was viewing the pictures. Therefore, if I do a "refresh", the page goes back to the pictures I was previously looking at, not the home page.
I've tried this on multiple computers at multiple sites, and with multiple browsers... And seems to happen rather consistantly...
Anyone have any thoughts?
I am looking at updating a notes part of my data base. I am calling two fields (first name and last) from the data base and putting them into read only text box (as i dont want the details changing). All of this is contained within a form. I am also calling a feild from the database called notes which originally has been inserted using a <textarea> tag. The problem i face is that you cant put values into a <textarea> (ie. i can put data from the database into the value tag of a textbox but <textarea> doesn't have a value tag). Due to this i am putting existing notes onto the page as text. Under this i have do have a <textarea> to put the new notes in.
The problem i have is that i some how need to store the existing data in the notes field and then add it to the new notes that i will be adding. I just don't know how to put the data i am getting from the notes field in the database into a variable.
Having problems writing an update script because in one of my fields I'm adding a chunk of HTML that contains ' characters. Obviously this throws up an error. How do I get around this?
View Replies View RelatedI'm trying to create and assign variables with the values from my db but can't work out the code getting my " & ' mixed up.
i = 1
do until i = 6 or rsSet.EOF
rBlock(i) = rsSet("rBlock'" & (i) & "'")
i= i + 1
rsSet.MoveNext
loop
whats better ADO or SQL
for example, an INSERT statement or an objrecordset.update blah blah?
same with .net
should I C# to update or SQL
I have an XML file which i'm trying to append elements to using an html form and ASP with javascript scripting inside the ASP file. Code:
View Replies View RelatedI have a function below that works fine. It takes a XML dox parses it, etc.
What I need to do is after the update of a record, I need to query the same table again for another record. If it finds this second record, I need to update it.
The problem is I can't get it to work, mostly because I don't completely understand the .open() method. Can I requery and the test for the existance of a returned record - if so how? Code:
I placed a post a couple of weeks ago discussing how I was having trouble using ASP and the XMLDOM to differentiate between the text content of Parent and Child Nodes in an XML file.
ie:
IF PARENT.text > "" Then
'Do Something with PARENT.text
ElseIf CHILD.text > "" Then
'Do something with the CHILD.text
End If
The problem being that I couldn't differentiate between the text values of PARENT and CHILD.
I've managed to work around that problem in a fashion but I'm begining to think that I'm going about this with the entirely wrong approach.
All I want to do is edit the following XML file through ASP: * Note that there are attributes with values and some nodes and child nodes have text values as well Code:
I am trying to configure Visual Interdev 6 (running windows xp professional) for debugging. However, while I run a utility viddbg.exe, the debugstatus file shows the following error message.
ASP.DLL Version Information
--------------------------------------------------------
Location: C:WINDOWSSystem32inetsrvasp.dll
FileVersion query failed
File Size: 339456 bytes
VID Debugging requires 4.02.0622 (330448 bytes) or greater. What is the best way to handle this problem.
I was give a site that was created on vb/asp and the owner want the site to b. be a asp.net web site, how difficult is for the site to be updated with the new .net technology?
View Replies View RelatedI get this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Expected query name after EXECUTE.
I tried hard but nothing, I have a same example working, but when I changed just the field names...it didn't work!! Code:
i'm trying to add the data of such client, some of his data have been added already but if i'm going to add or update his data (additional info.) what happened is the data is being added into new row not on the specific client. Code:
View Replies View RelatedGot a cookie problem, specifically with persisting it when I write to it a
second time on another ASP page. Here's the scenario:
Page1.asp:
- I have a cookie with serveral keys
- I set all the key values
- I then set the overall cookie expiration (you don't do this for all
the keys right, just at the top level?)
- This works fine, the cookie persists, but if I then go to page2.asp...
Page2.asp
- I simply use the response.cookie("cookiename")("KeyName") to update
some of the prior values.
Once page2.asp gets called, the cookie becomes a session cookie and does not
persist.
Questions:
1. I wasn't then re-setting the expiration, do I need to? I tried but still
the cookie wouldn't persist.
2. What is the correct order of setting the expiration, before, after
setting all the key values? Does it matter?
3. Can you in-fact update a cookie's key values, or is this fundamentally
incorrect, do you need to re-write the whole cookie?
4. Any other ideas?
I want to let the user of my asp-page fill in a form, and with this data I want to update an existing XML-file The xml-file: Code:
View Replies View RelatedI have a script on my asp page which takes values entered from a form and inputs it into a database, in their appropriate fields. It's been working fine, but lately I'm noticing that I've been getting some blank records being entered in my DB table.
I know it's not my form becuase there is no way to leave it entirely blank, so even if you don't enter anything... their are hidden fields which already contains a value that get's passed and goes into the DB.
I am wondering if this is a result of many people entering data into the access db at the same time, and i'm wondering if i have the right locktype parameter.
I am using adLockPessimistic right now... should that be adLockOptimistic or adLockBatchOptimistic????
and should the cursor type be adOpenDynamic???
I have a stock control database, I want
first the item sold and recorded as sold in the sale table
secondly the item will be deleted from the stock table
third the item wil be automatically reordered in the order table.
is this possible please. I am using Dreamweaver/access and some of ASP that is generated,
I have a bit of ASP that gets data from the database and then displays it. This part works fine.
I then have anouther page to allow for changing this information, then i want to do two things, first show the updated info, and then update it in the database.
Neither of my updates will work and i can't figure out why.
I get this error: ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.
I have checked the record it displays the info just fine, it will not update however. Here is my code for updating the record: Code:
Here is a code for ASP inputs being updated in Excel. However, when I
click to submit the user, the excel does not get updated! Code:
I have the following code on my site that Updates certain fields in the table. When I check the Tables they are all updated perfectly but I keep on getting the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
This is the code involved:
if strAction = "submitted" then
'lngCount = Request.Form("lngCount")
i = 0
do until i = Request.Form("lngCount")
UpdateSQL = "Update Site_Info SET Site_Accepted = " & Request.Form("acceptance"&i) & ", Site_Date_Accepted = #" & Now() & "# where Site_Seq = " & Request.Form("lngSeq"&i)
oConn.Execute(UpdateSQL)
i = i+1
loop
end if
I can easily add a new recordset (addnew) but when it comes to updating a recordset, i haven't received much luck.
I usually get this error:
Query-based update failed because the row to update could not be found.
...
Set oRS = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM ICR_Item WHERE ItemKey=" &ItemKey &";"
oRS.Open sSQL, dbConnection, 2, 2
oRS("Stock") = Stock
oRS("StockCode") = StockCode
oRS.Update
oRS.Close
Set oRS = Nothing
...
I can't use the simple "UPDATE Table SET..." command. I need to use a recordset.
i'm trying to update my db when the user sessions expires..... So i put the codes below on the golbal.asa file... i tried it a few times but this code wont work... but when i tried in Sub session_on_start it is okay... i notice that we could not use server.mappath or any other objects/variable other than Session or Application variable on global.asa .... have any of u guyz trtied the same thing and works
<script language="vbscript" runat="server">
Sub Session_OnEnd
set adoConn = Server.CreateObject("ADODB.Connection")
adoConn.Open "Driver=MySQL ODBC 3.51 Driver; Database=dhl_21Feb; Uid=user;Pwd=user;"
set rssession = adoConn.execute("Update session set LogoutTime = '10.20',status = 'Log_'")
I'm trying to add a checkbox to a form which updates a DB (access). Dreamweaver generated this and then doesn't work.
<input <%If (CStr((RS_UpdateProfile.Fields.Item("fldReadTerms").Value)) = CStr("true")) Then Response.Write("checked=""checked""") : Response.Write("")%> name="fldReadTerms" type="checkbox" id="fldReadTerms" value="-1" />
This checkbox doesn't update the database nor does it display the value in the field in the table.
As I grow to hate dreamweaver by the day I still am not any closer to solving my little problem.
I am having trouble updating more than one column in my sql database. I have tried everything I can think of and I am pretty sure it is something simple that I am just missing. Code:
View Replies View Related