Deleting A Product From Database
I 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
ADVERTISEMENT
Product Database
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 Replies View RelatedHow To Upload Product Image Into Database?
i 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 RelatedDeleting From Access Database
This is the code that I am using to delete from the database, but it doesnt seem to work any ideas people?
<%
SQL = "DELETE FROM jobs WHERE date = #" & personaldeletejobs & "#"
set Rs = Conn.Execute(SQL)
%>
the "personaldeletejobs" contains a date element.
Deleting Database Entry
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it
Sub Delete()
SET Conn = SERVER.CREATEOBJECT("ADODB.Connection")
Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb")
sqlWhere = ""
aSelected = request.form("Select")
sqlWhere = "ProspectId IN ('" & aSelected & "')"
sql = "Delete * from tblProspect where " & sqlWhere
Conn.Execute sql
Conn.Close
Set Conn = Nothing
RESPONSE.REDIRECT("prospects.asp")
End Sub
Deleting Entries From Database
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
View Replies View RelatedDeleting Records From A Database
If I have an access database with the fields Title, Artist, Description, DiscNo, TrackNo, Price and ID(Autonumber)
What would be a single-page script to remove only records where DiscNo= string entered into a text field in a form?
Example: I enter into the text field "SC8200" which relates to 18 records in the database. I click submit and all 18 records are deleted. Code:
Deleting Multiple Records In A Database
I get this message when trying to delete:
The column prefix 'username' does not match with a table name or alias name used in the query. I am not sure what this error is. I checked all over the place for the problem.
Problems When Adding,deleting,editing Data In The Database
actually, I have a problem while i want to add, delete, or edit a record to a database through a asp page, I can read well but when i want to submit changes using rds object , the data does not change on the source database,
I tried hard to get a solution but i think that the actual problem is only on one figure which is the server value of the data control when i use my own iis server, I do not know this value and microsoft is saying use an empty value but it does not work either.
Deleting Entries From A Database; Send E-Card Later; Other Scripts
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
*******************************************
Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date?
********************************************
Error Message When Deleting A File From Access Database
I get an error message when deleting an table from a Access database. The code is as follows and the error message is after it. Code:
View Replies View RelatedProduct Catagories
i 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.
Product Configuration
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.
Product Activation Code
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?
Product Review Software
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 RelatedProduct Catalogue System
anyone know wherei can find a free product catalogue system that has categorised products and administration of product data and images?
ASP Rating Product Software
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 RelatedProduct.ASP Page Error
ADODB.Connection error '800a0e78'
Operation is not allowed when the object is closed.
/Class/ClassOutall.asp, line 118
Any help?
Page / Product Clicks
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.
Client Downloaded My Product
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.
Categories In Product Catalog
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.
Use Array To Retrieve Product Details
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:
Online Ordering (different Product For Each Login User)
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?
Query To Return Minimal Product Of Two Fields
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?
ASP Application Online Ordering (different Product And Prices For Different User)
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?
ASP Application Online Ordering (different Product For Each Login User)
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?
Deleting
This code works fine, it deletes the record that already exist in the database and displays a message to the user the record has being deleted.... but it also it has a problem, if you enter a record to delete from the database and this record does not exist it displays the message that the record has being deleted, while instead it should display an error that this record does not exist in the database.
Code: ...
A Little Like Hotmail Deleting......
Ive run into a little trouble. I am sure all of you have used hotmail. Well you know when you select all items to delete, i would like to do something like that, however not delete, but update a field from no to yes.
I would like to add checkboxes to an asp table. So if the user selects say three items they then click on a button, say marked and for each item, it will go to the table and find each record in turn and update the corresponding field from a no to a yes.
Updating is no problem. The problem is, how do i add checkboxes to corresponding asp table. So that particular checkbox corresponds to that particular record. I don't know how to link them together.
Can someone help me out please?
Deleting A Page
I have a form that contains many pages. If someone clicks on delete, the application takes the user back to page 1 instead back on page in the breadcrumb trail. It is fine when the user is on page 2 but they could be on page 10 and click delete and then they are back to page one. I want to have the application go back on page at a time each time they click on delete. Here is what I have for code:
If LEN(page & " ")=0 Then
page = 1
End If
page = CInt(page)
If i = page Then
response.write "<font color=""#CC0000""><strong>[page " & cstr(i) & "]</strong></font> "
Deleting Folder
I have a script which allows a user to upload and delete files from the
server.Is it possible (and if so how) to do a check to see if the folder is empty
(ie if the last file in a particular folder is deleted by a user) and if it
is empty, delete the folder?
Deleting Record
I'm having trouble creating a one record recordset then deleting it. I've never done this before. The code below returns: "Type mismatch: objRS".
Code:
Deleting A File
On my webpage users can upload files and also delete those files. Everything seems to work, but when they upload a file that contains spaces, I am having problems getting the file deleted, for example: "This is my file.txt"
Is there a way I can delete this file. I have tried to take out the spaces, but the file still doesn't delete:
<%=Replace(Request("MyFile")," ","+")%>
Error In Deleting
this is my code but when i delete all the record there is error dispalyed ?
elseif (strType = "Delete") then
strSQLDelete= " Delete From events where id = " + ID
conn.execute strSQLDelete
response.redirect "eventform.asp"