I have developed asp application, but never worked with shopping
carts. I was wondering, when a user clicks on Add to Cart for a
product, is it done visa session variable, where item detail and price
is stored, and later on, fetched and added together to show total
price?
I am doing some research into the reporting capabilities provided by ..NET by itself and also integration with other programs such as Crystal Reports or thrid party tools. I don't have much experience with .NET technologies but most of the reports will be requested through the web and produced via VB components with a SQL 2k backend.
I am looking for reports either in xls or pdf format and mostly they will be data intensive i.e. no graphics such as bar or pie charts etc.
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
When using such objects as the one above, where is dbConn actually comming from?
How do I store session variables using the session("") in the code below? Everytime I try doing it, I get an error page.
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
<object RUNAT="Server" ID="spEssRtd_loginValidate" PROGID="adodb.command"></object>
<%@ LANGUAGE=vbscript enablesessionstate=false %> ......
I have customers that I designed a site for. I am almost complete with the site, and they are saying that the font is too small. However, on my computer it looks just like the font on devshed and everyother site. Are there any suggestions out there, as to maybe their settings are messed up or my scripting is bad .
View Replies View RelatedI have written a COM component who's purpose is to allow a user to change
his Windows (NT/AD) password via a web page. Now the component works fine
when I run it in VB 6, but not via the web page. The component also returns
an integer value that contains a return code from the Component (and the
appropriate Windows API). The result (using the ASP page) is Zero, which
indicates success. However the password doesn't change. (Zero = success, 100
= Invalid Domain, 101 = Invalid User, 102 = Invalid Password). Code:
I have two dates formatted as 'General Dates'....
21/08/2006 21:39:21 and 21/08/2006 21:58:48
How do I find the difference between them in seconds? I take it thats there's 2 ways of doing it: either with ASP or SQL. Anyway of doing it. how would I go about doing this?
I have a field called EndTime in a table called tblSessions. This field is a Date type, with a General Date format (DD/MM/YYYY HH/MM/SS). I want an SQL query which can return entities which are less than 30 minutes old.
View Replies View Relatedsometimes but not every time when i upload a fresh copy of my database to my webspace..
i receive this dreaded error..
Provider error '80004005'
Unspecified error
on the line that connects to my database..
Code:
I normally work with MS Access databases using ASP pages. I have been
given the opprotunity to work on some available SQL server space, and
wanted to ask a couple of questions. The following is a simple update
query that I use. It is an ASP page that connects to an MS Access Db:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN = myDSN & "DBQ=xxxxxxxxxxxxxxxdatabase003.mdb"
mySQL="UPDATE SKUList SET SKUList.Department='Furniture' WHERE
SKU='123456'"
Conn.Open(myDSN)
Conn.Execute(mySQL)
Conn.Close
Set Conn = Nothing
%>
I was wondering if someone could tell me (or better yet show me) how
this code would look in a SQL server enviroment. I have no information
on the server itself as the database will be setup for me, and I will
just need to create ASP pages to connect.
when i run the ip of my web site i get the following error:
HTTP 500 - Internal server error
the log file shows the following error:
The server failed to load application '/LM/W3SVC/1/ROOT'. The error was 'General access denied error '.
Periodically, our entire website will display the following error for all
users when requests are made to ASP pages:
DBMSSOCN General Network Error
HTML pages will load just fine, and I *believe* that ASP pages that don't
access SQL Server will also load. Someone suggested this problem has to do
with named pipes, but I don't have any clue when it comes to networking and
our network admin just resigned. This happens very sporadically (maybe once
a day) and never seemed to occur when he had DSN based connections. We also
have migrated our SQL Server to another machine (used to reside on the same
machine as our webserver).
Any ideas on what could be causing this?
What does a website need in order to send
text messaging to cell phones? Is this something the hosting company will
offer or does the website need servers from Micrsoft? Can you refer me to
where I can get more information on this?
can anyone tell me what i have to do with this error ...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xeb0 Thread 0x7a0 DBC 0x1110064 Jet'.
everything was ok until i Compact and Repaire the DataBase
i checked google everyone says it is security problem. i am admin on my computer but still i give all users Full Control Permission for both Temp and server folder "C:Inetpubwwwrootcareer" and i Add Everyone with Full Control but there is no use
any ideas ...
I have the following pages...
page1.asp
page2.asp
page3.asp
page4.asp
page5.asp
The following variables are given values on page1.asp:
FirstName
LastName
Address1
Address2
City
State
Zip
The values are not used in pages 2-4, but are used in page5.asp.
Should I put the values in session variables? Or should I put them in form
post data? Or does it really matter?
I'm trying to add a user to active directory using ASP and am receiving the
following error:-
Active Directory (0x80070005)
General Access Denied Error
Does anyone know how to get round this problem?
Why d I get this error?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x18c8 Thread 0x1478 DBC 0x2f56fa4 Jet'.
/wheelofgod/search/cat/showbook.asp, line 102
I am urgently finding a set of codes to write data into a form and the data will go to my database. However i have tried a lot of form but couldn't successfully process. Below is one of my problem...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9a8 Thread 0xa08 DBC 0x3041e1c Jet'.
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
Which is the best way (some links please) to write code for a cart in asp? Is there a way to write a cart that works also without cookies?
View Replies View Relatedi want to print some data in the menu list. first, i have to select (checkbox) several data in the different page and then after complete it, i hit the print button. it's a same like add cart but with no trolly.
View Replies View RelatedI need to build my own simple cart that writes to cookies only. I can write
and read cookies, but don't have a clue as to how I can add multiple
products, change quantites, etc. All I need is a cart that stores
information in cookies and the user prints their order. That's it. Where can
I find such information?
i was wondering if anyone could give me a few ideas on how to create a shopping cart using asp or even a good website asi have been searching and have not found any
View Replies View Relatedhow should i assign a unique id to a user ? i've used the sessionid in
the past but have found that the sessionid is not unique. is there a
better solution for assigning a unique id to each visitor ?
secondly, what's the best way to track visitors as they move about my
site ? i'll be recording items in the cart in a database but will
still need to track the user on each page ... session variables or a
cookie ?
what's the best ASP shopping-cart available? I have looked in Aspin and there seems to be a few good one's around. Anybody tried any of them? Ofcourse, it needs to be fully-featured with order-tracking, intranet product management, etc.
View Replies View RelatedI have made the following shopping cart. which displays data fine but when i hit the add to cart it is saying "No value given for one or more required parameters"
so i have not seen my cart working I would like to also add Images to this later but im taking one step at a time Code:
how i would go about creating an ASP/SQL Shopping Cart???
View Replies View RelatedIs it possible to remove just the session.sessionID, I have other session variables that I would like to keep?I use this for saving cart information but it needs to be different each time.
Im building a simple asp shopping cart for my college assignment, however im having trouble adding more items to my cart.
i can add one item, but when i add another the previous does not show. Here is my code so far for my cart. I figured i need to somehow create an array? so i can loop through the session array? Code:
I am working on shopping cart and stuck on this issue for a long time
this is what i am trying to do
user comes and adds a item in the cart so now the shopping cart looks like this
football_shirt_2
where 2 is the qty
the user then shops around and decides he needs to buy 3 more shirts
so what i want to do is when he adds 3 more shirts i want to update the qty in the earlier item and make it 5 because earlier it was 2 Code:
I 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.
my company is in need of a shoppingcart that has adavanced inventory management in the admin, i.e. calculates 'cost of goods sold' in reports and FIFO etc. Anyone know of any?
View Replies View RelatedI've built an website using a shopping cart feature from a third party that is hosting the site. It uses an ASP script that looks like this: <%=getAttribute("item",93,"addToCartHTML") My problem is that when they get to the page with the add to cart button it is automatically filled with a value of 1 of that item.
My client wants to be able to click this button and if they had previously added this item to their cart it wouldn't add it a second time. I think I need some sort of "if" statement but I don't know what it would be and where I would add it.
has anyone got experience of fixing problem in AOL browser? I've a shoping cart with few products works fine with IE firefox safari and everthing. But the AOL (home edition) of AOL users seems to get problem to buy the product.
View Replies View Related