I want to change the existing code of our company e-commerce site so that the pull down menues are now checkboxes (will make life easier for sales to work with).
The pull down menu's must automatically submit, as the pricing changes with each selection.
Is there a way of auto submiting when a checkbox is ticked / unticked? Have tried using the "onChange=" that I nicked from the pull down... Code:
I have problem in updating checkbox (true-false) using SQL statement.
View Replies View RelatedI want to use a check box to update a field if it is checked. I have:
<input name="expr_date" type="checkbox" id="expr_date" value="<%=newExprDate%>" />
this doesnt work in either way - the record field stays the same if the box is checked or unchecked.
Is this possible - where am I going wrong?
i've encountered a problem.. which is that when i update the checkbox field, the previous checkbox updates are gone.. how can i go about editing it? Code:
View Replies View RelatedI'm trying to update a database and some of the answers are check boxes. If I don't change the value of the check box the database is not updated. That is, if I had the checkbox checked when I first submitted the survey it would show ON in the database, when I try to update if I leave the checkbox blank, it will not clear the result in the database.
View Replies View RelatedI have a form that if a user selects a certain option from a dropdown list a checkbox will appear. This checkbox references information from another table and then multiplies a figure before it is submitted (well, that's the theory anyway!)
I can't seem to get the multiplier to work. Can someone please give me some advice to this? I've included some simplified code that concentrates on the areas that I'm having difficulty. Code:
I've been asked to develop a made to measure online blinds store. The price of a blind depends on the WIDTH and the DROP. I have a price chart with numerous prices depending on the drop (from 600mm thru 2500mm) and the width (from 600mm thru 3000mm).
View Replies View RelatedWell my goal is simple. On my site we show "You save: $**.**" but I want that to say "You save: $**.** (**%)."
The database for our store stores the list price, and our price. The store calculates the you save price... so it should be easy to calculate the saved percentage as well. Here's the code that calculates up the "You save" currently on our website: Code:
I am doing a bmw tracking project for school using asp and access2000.
on my search.asp page, I can search for a particular bmw and order it if
i want. It works fine when i do select query to get data. But when I try
to order a bmw(using update query), it gives me this message error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bmw/search.asp, line 257
I have gone in to set IIS permission status to both read/write and
change everything that seemed obvious. but i still get this same error
message.
what changes do i have to make this query work in an SQL query? This is the access query:
UPDATE tblLocation SET tblLocation.fldLocationDesc = "DU" & Right([tblLocation]![fldLocationDesc],Len([tblLocation]![fldLocationDesc])-2)
WHERE (((tblLocation.fldLocationDesc) Like "EI*"));
what i have is a location that has a lenght of 5 like EI001 and I want to change the EI to DU.
How do I update a record if I want to loop through the records then update the current record in the loop. Flow :
rs.EXECUTE("Select * from Tbl Order By Ord;")
'update current recors in loop record
rs.movenext
loop .
I need help on this error that occured on one of the pages. fuunny thing that its happen in localhost and not in the web server. below is the code and the highlight of where error occured.The error mentioned in the page is :
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/shop/confirmation21.asp, line 245 . can anyone kind enuff to let me know whats it about?
Code:
wat are the different ways i could execute this update query. Code:
sql="Update Employee Set name='"& name&"', age="& age &" location='"& loc &"'
Conn.Execute sql
the sql statement shows evrythings correct. but when i execute the update query...it shows syntax error in UPDATE statment.
I'm using odbc and Classic ASP and I want to read the sql content of a query in an access database. ANyone have any clues?
View Replies View RelatedI am currently working on a small website which gives an up to date current count on how many people are available are certain time slots for different areas, this is run of a Microsoft Access Database Backend.
My index script will display all areas and times and then display a link to a form which deducts 1 from the current count. Code:
I have the following query:
Update properties set Last_Change=#8-Mar-2006# Where properties.fdref='h3c000';
which works fine when I run it on my desktop under MS Access, but when I run it as an ASP page, I get the following error message:
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
I am using the same database bot online and offline so field names etc are exactly the same.
I have developed this script that is meant to take in a value from a database record add one to it and post the new number in the record. It works ok but it always seems to read all database records as 0 never as thier true number (i have tried it set to 1,2,3 etc)
Code:
I am getting this error when trying to run an Update query, Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Can anyone explain to me what this means and where I'm going wrong.
View Replies View RelatedCan anyone give me advice concerning building an ecommerce siteusing ASP? It is the first ecommerce site that i build
What do i need to know?
What do I need to do?
has anyone used swartwin's ASP shopping cart software, www.smartwin.com.au/ . If so what are your opinion about it? does it actually provide features not seen in other products? How would it compare to a free open source product like oscommerce (this is PHP based, but looks pretty good).
View Replies View RelatedThe setup:
Access database of vendors. A vendor can offer one or more services.
ASP page provides user a checkbox of services. User clicks one or more options and submits. The database should return all vendors that match the services selected.
No dice. I can of course easily pull up vendors that match one service. But the multiple options are treated as an AND search. I don't want to find only vendors that provide all the services checked, but all the vendors that provide one or more of the services selected by the user.
I have tried stored procedures in Access and SQL statements. I either get data type errors or nothing found.
First of all, I'm not a programmer. I'm trying to locate a pre-written application (otherwise I already have a programmer lined up.)
I have a business that builds customized computers. I need an interface where the customer chooses the different hardware configurations and then the page displays the updated price. If you don't understand what I'm talking about Dell and just about every other pc manufacturer have an interface like this on their websites. I've looked at a lot of sites, nearly every one of them uses asp.
I need to know is if some sort of pre-programmed asp script exists to make my programmer's job quicker and easier.
there are any open source for ecommerce site like a one such for 'oscommerce' in php/mysql.
View Replies View RelatedIm starting to work on an e-commerce site. Its pretty small only 700 products and would like a bit of advice, Due to restrictions the site is likely to be based on an access database unless the client comes up with a bit more cash for hosting so when im building the order which would be the best way of storing items in the customers trolley.
Session variables or cookies, i havnt done much work with cookies but if thats the best way to go then dont mind spending some time on it. I would have thought storing the orders in the database its self is proberly the best way but using an access database i suppose its not really ideal.
To handle online transactions I need to be able to accept an incoming form from the the e-commerce server.
No problem there (I believe it will look the same as any other request?).
However I need to respond by sending a form back again.
How can I do that directly from the server in ASP without having a browser to load a page.
I believe in Perl one uses the LWP library and contructs the HTTP packet and then sends it back to the server.
I am developing a e commerce site. The user may become a member and therefore requires to log in. In the development of this site we have just exited out and re-entered the site without logging on however our details are still as we logged on.
If the user purchaser adds item to their cart a session id is also created and if the situation as above occurs the items are still in the bag . What is the best way of stopping this ie if they have exited the program by clicking the x if the return within the session the order id is cleared and we start again.
My client had someone modify their home page of their commerce site. Howerver when then did they removed the include for store/template/menu.asp and created a hard coded menu on the default.asp (home page). Now the client wants this static menu to replace all of the dynamic menu's throughout the site. I found the area in menu.asp that pulls the data from the commerce server and if i delete this section the old menu item go away. I need to know how to insert the static HTML menu items in its place.
View Replies View RelatedOkay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:
View Replies View RelatedMy 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.
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).
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?
is there a way of having a dropdownlist and a text field with a checkbox so that you can check a box and have the vaule assigned from a option selct list or check another box and have the value assigned from a textfield?
View Replies View RelatedI would like to make an interaction with a database using ADO and SQL. I would like to display some parts of the database using checkboxes to choose the different parts. But I don't know how to build the SQL command in fuction of which checkbox is checked.
View Replies View Related