i now know how to add, edit, delete and search for products (havent figured out categorisation out yet tho) - how do i upload an image and save the file name to the database as part of the admin? something dummies can follow that doesnt use a component (can i throw in a chunk of code and specify the table fieldname and directory the file needs to go into?)
View RepliesI have an online store with a database (windows 2003 small business server) and i want to delete a product or a dealer from my database via asp with a button or a link. how can i do this?
View Replies View Relatedi would like to ask isit can upload image into database(ms access 2003) from asp. if can, how the code can be written? then if after upload image into database. how we can retrieve it from database into asp page for viewing?
View Replies View Relatedi have a number of product each of which has a catagory. Currently a user can list the products using the catagory. However a product may have more than one catagory. for example in a vitamins section cod liver oil may be under fish oils and joint care.
the search currently works by selecting all from the type section of the ms access db where type = fish oils for example. if i were to add multiple types into the section how can i filter them out? for example is it best to just save all the different types in the products type field, seperate them with commas and then select all from the db filter each products field retrieving the relavent ones? this would seem extremely slow as the database is quite large.
I am trying to create a product configuration tool and I'm not sure where to start. I have made a database with 4 columns..ID, component, compdescription and compcode. There are 8 different componets to configure on the product and the compcode holds the letters and numbers that eventually make up the part number when you make all your selections.
I want to be able to select one thing from each component category and submit to the database which will return a part number. I thought the easiest way to do this would be with 8 different drop down menus filled with all the options for that component category.
I have an ASP provider and an Access Database.
I need to build a small webpage where the user can enter his "user id"
and a "hardware code", and if the "user id" is correct (will be checked
against the db which means the user id must exist) a function will
generate a product activation code from his/ her "hardware code" and
show it on the next page.
I think the database thing is not a problem, but I have not been able to
create a simple function that is hacksafe and cannot be "downloaded".
Could anybody give me a hint where I can find an example of such a
function so that I can understand how I have to encapsulate the
important parts so that nobody can see it?
Does anyone know of any product review software written in ASP or ASP.NET It would be for a website with nothing but reviews. I don't care how simple it is... I can modify it to do what I need, but I'd like at least a place. 5 years ago when I first started building websites I found one written in CGI and it worked great.. but I can't seem to find anything like this written for ASP.
View Replies View Relatedanyone know wherei can find a free product catalogue system that has categorised products and administration of product data and images?
I am creating a store and I'm looking for a ASP rating software. Something like Amazon where you write your comments, rate the product and see how many stars. I need it to have features where I can accept the comments or at least it gets reviewed. Is there such a forum like this? Anyone know of any?
View Replies View RelatedADODB.Connection error '800a0e78'
Operation is not allowed when the object is closed.
/Class/ClassOutall.asp, line 118
Any help?
I have list of products listed from a search criteria, Now I wanna show the client TOP VIEWED LIST OF PRODUCTS or number of hits for each product. So the page hits using the counter component will give me the hits for the entire which has all the products.
Perhaps I could catch it in the product DETAIL page, how do I list the number of hits for each product. Secondly I have IIS 4.0 make sure you recomend the right component.
i m working on an ecommerce project. as the user click on "buy" button , i charge that customer with the price of that product and then from asp page i redirect it to the page
response.redirect.(http://domainname/abc.zip)
now if due to some communication problem , download of this product did not complete successfully ,that customer should not charge for this.how i can know that product has been successfully completed so that i can charge the customer after that.
I have a default catalogue/product page (code shown below list_item.asp) which list all the products from the database. But since I have lots of category in the catalog/product page, i want to separate them according to their respective categories like writing instruments, desktops, pantry etc.
This will enable the user to go to a respective page and choose the individual product from the respective categories. If I adjust the SQL statement to be "SELECT * from Product " WHERE category LIKE 'DESKTOPS', this page will lists all the items from that category selection. But if i were to make another page such as pen.asp and adjust the SQL statement to category LIKE 'PEN'.
The first page lists the products from the pen category and the following page unfortunately shows category from Desktops. how to segragate these categories so that it will only show the products from the individual categories.
I am trying to develop a shopping cart using a dictionary object to represent the shopping basket. I have a products page which displays all the products for the user to click on to add products to the basket. This works fine.
The problem I am having is when I want to display the content of the shopping cart. The dictionary object can only contain the product id / quantity, so I have written a function which uses the product ID to retrieve the product details from the database.
Whilst I can output the values in the function which retrieves the data from table into the array, I can't output the values in the procedure which receives the array. Code:
I'm just wondering if there is ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? I really need that feature for one of my customer.
If it is not available could you please suggest a product that has this feature?
To return a minimal price of a bottle of vodka stored in field "price" I
can call MIN function .
However this price ignores the size of the bottle.
Bottle types and sizes are stored in a different table called "Bottles"
Suppose I wanted to get a product with the minimal price per litre.
Obviously I have to multiply the bottle price by the bottle size.
Can I do it in one query which will fetch the minimal per/liter price?
We’re just wondering if there is an ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? We really need that feature for one of our customer.
If it is not available could you please suggest a product that has this feature?
I'm just wondering if there is ordering online software which has a feature to create a customised user environment (different product and prices for different user) for each login user? I really need that feature for one of my customer.
If it is not available could you please suggest a product that has this feature?
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedProducts ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies View RelatedI have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.