I have this login that i created. On the sign in process i need to make sure
that no one has already signed up using that certain email or that unique
cnumber.
Ive tried this line:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email &
"'") or ("', cnumber= '" & cnumber & "';")
than this:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email &
"'", "' & or & '", "' cnumber= '" & cnumber & "';")
I have a funtion that is supposed to add items in my shopping basket.
It's an array, and each time the user is adding an item, it adds the item to the array with its quantity and size.
I've never used arrays before, read about it, etc...
The only problem is that when it adds the new product, it's not keeping the ones which were there before :-(.
I have used REDIM PRESERVE. So can't find out what is wrong.
Below are the funtions that i use for testing and the coding where I implement them. Code:
I have set up a page specifically for printing, however, I would like to be able to choose certain items on the page that are to be ignored by the printer. For example, the web version of the page may have instructions on how to print, although the version that is printed off does not.
View Replies View RelatedHow can I get this to work?
<% if objRS2("System") <> "Scholastic" OR "Rolling Readers" OR "Reading Recovery" Then Response.Write "selected" End If%>
I have multiple list box added to the asp page using <select> tag
I have added items in the list box using recrdset from Education table
Education table={educationid, educationname}
User can choose more than items from the list box. These items gets
added in the user table in field
"edu" seprated by commas.
When User wants to edit his information ...i want that the items in the
list box should be automatically selected which are present in "edu"
field.
does anyone knows how i can layout items retrieved from db such as example from this online shop site . most items retrieeved from db such as Accesss are always in vertical layout.
View Replies View RelatedI am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new to asp and have no knowledge whatsoever on how to code what i need.
Could someone please provide me with help, or coding on how to add item details into a basket record, once the user clicks the add to basket link.
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new to asp and have no knowledge whatsoever on how to code what i need.provide me with help, or coding on how to add item details into a basket record, once the user clicks the add to basket link.
View Replies View Relatedcurrently i have an online shopping website that display 12 categories of different items of up to 12 types. well my boss wants related items to be displayed in each of the different items . i am not sure how to start this. is there any special code for it. please advise.you may visit www.mellon.com.sg/shop to view .
View Replies View RelatedResponse.Write "<TD>" & "<a href= objRS.Delete>Remove</a>" & "</TD></TR>"
I have a basket which people add stuff to that they want to buy. i want a code that allows them to delete the item too. how the basket works is. thy choose a item from stock page and then it adds to a basket table.
I have a multi-dimensional array that I want to delete items from. To do this I display a form and the user clicks some tick boxes. Then on the delete page I check which tick boxes were ticked, say 2,4,7 and 8 (or whatever) and then rebuild the array minus records 2,4,7 and 8 and so on.
Sounds simple enough, but I'm having a real nightmare getting it to work. So my questions is how are others doing this, as my way is obviously very shoddy! I've been
looking for examples on the internet, but I've not managed to find one.
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new toasp and have no knowledge whatsoever on how to code what i need.
how to add item details into a basket record, once the user clicks the add to basket link.
This is my scenario. On the left of the screen, I have a list of news items, which are updated by the user and inserted into a database, and then they are dynamically displayed on screen from the database.
Now what I want is that if a user clicks a hyperlink from the left of the screen on a news item, the relevant text is displayed on the right. What I did up till now was that if I point on a news Item to the left of the screen, I know which item in the recordset it is since I created a counter.
I would like to tap in to all the brilliant minds out there through the means of this question. Is it possible to have a function in asp that returns a collection of items?
If so could you please direct me to some code that may provide some insight to how its done. I've tried using my limited coding capacity but no success.
I'm trying to make a sorting feature for my site which will allow the user to click a drop down menu, click the item they only want displayed, click a button, and then the results will only display that particular item.
I also would like the drop down menu to auto-fill because there are about 20 different categories available. is there and easy way to do this?
I had previously posted this in inetserver.asp.components, I don't think that
was the right place... anyways, here is a repost:
We are currently using ASP.NET 2.0 to revamp one of our web applications. Let
me try to briefly explain how each page is laid out...
Usually within the page, there are 3 components... The header, the body, and
the footer. The header and footer are user controls created by one of our
developers, and contain things that all the pages in our web app should
contain. This is done to avoid inconsistencies (so you only change the header
once instead of changing it 20 times - once for each page).
The developer who created the header user control used Context.Items to
store some information. On my pages, I am trying to use PostbackUrl to post
form information from one page to another.
The problem I am having is this:
Both my pages call the header control. When I use PostbackUrl and
PreviousPage, I think the header control from the previous page gets "copied"
over to the page I am posting to. So in the second page, I get something like
a "dictionary keys have to be unique" exception. I think this is because the
Context.Items wasn't "cleared" from the PreviousPage since it was "copied"
over, so when the header user control tries to add the same key to
Context.Items in the second page, I get an exception.
I temporarily solved this problem by using Request.Form[...] rather than
PreviousPage.FindControl(...). I'm not sure if this is the right way to do
it, or if it will cause any problems.
So my question is: Can PostbackUrl and Context.Items work together? I guess
I could put some try/catch statements in the header control, but
unfortunately I don't have access to that file.
i want to fill a drop down box using data retrieved from access database.......
i alread know how to connect and retrieve data from the database but i am a lil unsure as to how i can populate the drop down list with the values retrieved.
I have a from with four elements a checkbox and a textfield and two which are hidden. Jobid and userid.
The jobid is written once and the userid is These are dynamic items from the database.
What i want to do is loop through the items and then insert the new values back into the database via an update statement. Code:
Does anyone know of a good script that already exists to do the following? Allow a user to enter a sort orderIf the order exists replace the existing one with the new and bump the old up or down accordinglyIf it doesn't exist add as newMake sure there are no gaps in numbering.
View Replies View RelatedI am trying to display records in the following way but i cant get it to work:
Table structure i am trying to achieve
User 1 User2 User3 User4
Car Model Carmodel Carmodel Carmodel
Car Spec Car Spec Car Spec Car spec
Once it has displayed 4 complete records with the data i want it to go to the next table row down and display the rest of the users ie... User 5 User6 User7
And eventuall i will display so many records per page but i will get to that later
Access db, one table, 12 or so fields (id, item_name, category, manufacture, price, description etc.)... (ecomm site).
When displaying the details of a particular item I want to display "related items" below it. All I do now is pull info depending on the item id then display the size, dimensions, description, photo etc.
Lets say the item is a Large Blue Widget, i want to display related items... say "Large Widget Covers" or/and "Large Widget Accessories"... you get the idea... cross selling
So, I am looking for ideas on how to simplify the display of related items.
i am having problems with my code here and i am trying to figure out what i am doing wrong
i am adding items in shopping cart also i have written code to check if the same item with the same attribute exists then add 1 to the qty Code:
how do i determine how many items are in an array? the following code creates an array of values each time a space is found in a name field. the problem is that sometimes names have middle initials and sometimes they do not. so i want to determine how many items exist in this array created bythe split BEFORE assigning values:
name_of_customer = Split(customer_name," ", -1, 1)
first_name = name_of_customer(0)
middle_initial = name_of_customer(1)
i have 5 textboxes and 2 radio buttons in my form and one submit button.after filling datas in my form if i click submit button all the details has to go to my client mail inbox in the same format
for example
name :timmy
age :25
sex :male
salary:20000
designation:developer
in this format i will fill datas in my form and in the same format has to be shown for my client after sending mail this to my client.if my client open this mail he has to able to see entered datas in the same way i entered before sending.
What is the best way to store the items and quantities that customers have chosen across a session without using cookies The customer does not need to login to do online shopping and users will be prompted to enter shipping information when they proceed to checkout.
View Replies View RelatedI have the following code that picks up data from a database, but I have no clue how I can make it list the items it picked as according to a "subid" value rather than the "pageid" value it uses now (from lesser to greater). In other words I'm satisfied with the items it picks, but I need to change the display order. Can anyone tell me how the code should be changed (I didn't make this code myself)? ....
View Replies View RelatedI have the following code in an .aspx web page and am receiving the error: "Compiler Error Message: CS1026: ) expected". I can't see where it is expecting an extra parenthesis. The line of code it fails on is the following:
<asp:Label id=lblName runat="server" Text='<%#
DataBinder.Eval(Container,"DataItem.FirstName") + " " +
DataBinder.Eval(Container,"DataItem.LastName"); %>'>
</asp:Label>
I'm simply trying to concatenate the first name and last name in a data list. Any ideas as to what I am doing wrong?
I have a list box that populates dynamically from a table. I want all items of the ListBox to be selected on page load as default options before user can highlight the items he wants...how would I do that?
View Replies View RelatedI have a string that reads like this:
[Group1][Group3][Group3]...[Group10]
How do I quantify how many[*] occurences there are in classic ASP? Do
i use the inStr function and if so, how???
Here's my thought process...
if groups > 1 then
do this
else 'more than 1 group present
do that
end if
But how do I loop through the string and quantify how many groups there are using the above string?
I have a catalog of books which need to be categorized into different
groups. Some of the books can be listed under more than one category.
I'm creating a page where I can assign a group of books to a category
by checking the checkbox next to their name (say I've looped out 100
of them, and check some, and not others) then submitting the form for
processing, so that those titles where the checkbox is checked will
get the categoryid number assigned to them on a one-to-many table
I need to know how to read the checkbox value as it comes in if it is
selected or not, if it is, I'll send the isbn in one direction, and if
not, I won't send it at all.
So, how would I read this on the sheet that grabs the values?
I have one table that has a course's ID number and the titles of the units for that course, with an ID for a set of units.
Then I have another table that has the units for all courses within it, this table also has the CourseID they belong to and the ID of the Unit header that they belong to. My problem is trying to get the header displayed first then all the units that belong to that header, so it looks like this: Code:
Here's my list:
required = "street_name, city, zip, country, email, phone, url,
username, password"
notrequired = "email, url"
So what I need to do is take email and url from the required list and make a new list. I've got a bad cold, and my brain doesn't seem to be functioning correctly. I just can't seem to make this work without either truncating the result incorrectly, or getting duplicate values.
i want to keep the lower number between my two numbers (nbelem(querystring) is user defined and nbElemTbl is number of elements in the table) in my test nbElemTbl return 6 and nbElem(querystring) return 10 but it will always enter the if statement and my resulting number is alway 10.
SQLQry = "SELECT COUNT(echBassinNo) as nbElemTbl FROM tblEchantillon HAVING echBassinNo = '" & Bassin & "';"
set rs = con1.Execute(SQLQry)
dim nbElem
if cint(Request.QueryString("nbElem")) > cint(rs.fields("nbElemTbl")) then
nbElem = rs.fields("nbElemTbl")
else
nbElem = Request.QueryString("nbElem")
end if