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?

View Replies


ADVERTISEMENT

Why Cant I Return Any Records From Query..?

When ever i try to search for a number in a form to bring back the customers info i get no result returned! However the customer exsist in the database. What could be the problem?? Code:

View Replies View Related

Query Number Of Fields Error

Please look over this code and tell me why I keep getting this 'Number of query values and destination fields are not the same.' error.

Set rowcreation=connectionToDatabase.Execute("INSERT INTO hotlines(user_ip,date_time_opened) VALUES('" & user_ip & "," & date_time_opened & "')")

View Replies View Related

Number Of Query Values And Destination Fields Are Not The Same.

[Number of query values and destination fields are not the same.]

This file has worked with another project of mine but can't understand why it doesn't work with my current project.
I've look at the fields being queried and the fields being inserted and they are exactly the same. I basically made a copy of the main table and called it an archive table. So this is just taking out of the main table and inserting into an archive table. Code:

View Replies View Related

Product 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.

View Replies View Related

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.

View Replies View Related

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 Related

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?

View Replies View Related

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 Related

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 View Related

Product Catalogue System

anyone know wherei can find a free product catalogue system that has categorised products and administration of product data and images?

View Replies View Related

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 Related

Product.ASP Page Error

ADODB.Connection error '800a0e78'

Operation is not allowed when the object is closed.

/Class/ClassOutall.asp, line 118

Any help?

View Replies View Related

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.

View Replies View Related

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.

View Replies View Related

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.

View Replies View Related

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:

View Replies View Related

How 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 Related

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?

View Replies View Related

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?

View Replies View Related

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?

View Replies View Related

Need To Convert This Sql Query For Access To Identical Sql Query For Sql 2005..

My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"

I have this code, working fine in access 2003

SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"

but get the following error when I run it against my sql 2005 database.

[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.

I don't know the corresponding t-sql for the query.

View Replies View Related

Query A DB - Pass The Query To Next Page

I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....

The trouble:

the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).

View Replies View Related

Query Access With Multiple Query

I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.

{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location

Currently,

strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1

Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?

View Replies View Related

Return From ASP.NET To ASP

I updated to aspx last three month,after developing serveral
applications,Idecided to downgraded to asp, following is my reasons:
1.in ASPX,the page format is hard to control,in ASP u can change every html
as u like ,but in aspx, a aspx control decide the page format,and its hard
to change the format.

2.ASPX is said to be faster that asp, but it is based on too-often
communication back to the server,for example,u click a radio a button,there
is new page request, but in reality,such a communication is
bandwidth-consuming and time-consuming. the user only need to submit the
form, and the exchange between IE and Server was minimazed.
the Speed of ASPX is not useful for most sites, for bigger sites, the speed
increase is singnificant,but for small sites with less traffic, the speed of
ASP is quite enough.

3.ASPX is based on Object Orinted Programming, but in most small sites,
Procedure orinted programming is used, we never build objects, and POP is
more efficient.ASPX is for three-tiered structure with a single layer of
business logic component, but in reality, most of us used two-tier
structure,that is Presetation layer and Datalayer, we can layout the page
and change the database in a single page, quite effienct too.

View Replies View Related

404 Return

I want to return a 404 response from an ASP script (IIS 5).

Response.Status lets me set the response string, but if I don't include any
HTML text myself, the result is an empty page.

Is there a way to 'redirect' it to the server's default 404 response, as if
the URI really doesn't exist, but without really redirecting it so the URL
isn't replaced in the browser's address bar?

View Replies View Related

Return Value

I am trying to replace a huge chunck of code that currently I incorporate
with an #Include directive. The program rarely has to flow through that
code, so I thought it would be better if I used Server.Execute.
I found I can pass data TO the called asp file by creating an HTML <input>
and erading it after I get there.
However, I also need to read back ONE variable that the called file must
set. I cannot figuer out how to do that. My backup positions are (1) I can
keep on using the #Include technique, and (2) I can use a database to bridge
the gap.Isn't there a way to carry data BACK TO the calling asp file FROM
THE CALLED asp file?

View Replies View Related

Return A Value

I am using a stored procedure to insert set of values to a table.I am generating or calculating the value of the primary key and inserting that record and i need that value to use in my application so is there any possibilty to return a value from storedprocedure to asp application.

what i am using to do is creating a #temp table and inserting that value in the sp and then opening that value in the asp application and droping that table, but i hope it is not a efficient method.

View Replies View Related

Log In Return

When a user logs in, I want to redirect them to the page that they were previously on. How do I do that? I already have the login page working. I just need to edit the redirect part.

View Replies View Related

Return Value

The code bellow functions well. However if I want to obtain a return
value using the code bellow, how is it done? Code:

View Replies View Related

Return Single Value In Asp/sql

I'm assuming this can be done, but I can't seem to get it to work... I'd
like to easily return a single value from a sql statement, something like:

"intNewItems = conn.execute "SELECT COUNT (ItemID) WHERE ItemDate = Date()",
where conn is the connection object, etc. What am I getting wrong?

View Replies View Related

Return Recordset

There is an access database and asp page .That asp page opens connection with that database,And opens a recordset online..

Is there any way that this opened recordset can be returned to Vb6 application which requested that Asp page to open connection and recordset and return some result.

View Replies View Related

Return Entire Row(s

I know there's a way to do this - well 99% sure anyway - and seem to remember reading an article or tutorial about how to do it but I'm not having any luck finding it.
What I need to do (using MySQL & ASP3) is to find all rows with "X" as a non-unique ID - there may be 30 or so total - and grab them to be archived in a CSV file before deleting the record from a DB.The reason I want to avoid hardcoding the field names is that they're going to change with moderate frequency.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved