if we can have a system in ASP with access 2000 as the database which would place orders in the shopping cart system after some hours regularly that would make sure that the shopping system is working fine.if we can do this surely would like to know how.
how can i get to send a reminder mail for some expiration date for an account to the account holder whose information would be stored in the database.
my project is an ordering system, which allows users to order multiple products by entering in the product quantities in a text box. The technologies I am using are Macromedia Dreamweaver MX, ASP VBscripting, and a MS Access database to hold all the products.
Could anyone please tell me how do I create and order list that allows me to specify multiple products at the one time and also to allow me to enter in the quantity of each product? The next page should then show a list of the products ordered. After this is confirmed the product numbers and quantities need to be stored in an order details Table within the database.
I want to grab some information into a recordset from the database ( can do this ) count how many there are of these records after i have applied some filters via if statements, like if they are within a date range, ( can apply the filters ), then i want to be able to dump the three columns and x amount of rows into a recordset and sort by the count, this bit i cant do.I am sure i have read somewhere about creating a dummy recordset for sorting but allas i cannot remember where.
is any on eone out there who can help me with my asp script. upto now i have managed create my database using MSaccess and connected my database to the web server. Code:
I found out a really nice way to keep things on the same page is for any processing page to add on a "?<something>=<something>"
and then just check to see what the something is equal to, and the number represents what you want the front page to show.
However, this <something> shows up on the url listing in a browser. Is there anyway to .. encode it so no one can see it? Like a encode/decode function?
How to place advertising banners on say 10 different sites? After clicking on these banner, the control should go to a particular web site. Here do we hv to do coding in 10 different web sites or is there any other procedure?
Set RS = Server.CreateObject("Adodb.Recordset") strsql= "SELECT Images from product where status = 1 ORDER BY [Supplier]" RS.Open strSql,Conn,3,3 If RS.RecordCount <> 0 then While not RS.EOF Images= RS("Images") RS.MoveNext WEND RS.Close
While using this code "Images" is an array..(a collection of imagesname from the table "Product" whose status is 1). Now I have to use first 4 images at a time among these collection of Images in the different specific locations in a page in the same time.
I am currently developing a final year project which is a web based tracking system tracking exam questions. I am using IIS as the server, MS access for the database, and ASP with VBScript for the scripting side of things.
One of the things I want to do would be to e-mail a user/moderator whenever a exam question is edited/completed/updated. does anyone have any previous expierence in this? i don't even know where to start.
What is the asp code variable for System Date and System Time? Are they built-in system variables, or is there some code involved to return the values?
This is a follow up to a question I asked two weeks ago which I thought was solved but on further inspection I realised it wasn't working fully. I have an ORDER BY on my search results page, the search uses two dropdown menus, the first one is start character (A-Z), and the other is grade.
The problem I have is that the ORDER BY work perfectly when I leave the start character dropdown blank, and when I use the grade selection dropdown, but when I select a start character I get this error message:
An ASP page outputs data from the query "Select ThisAndThat from comments WHERE pageURL='" & pageURL & "' ORDER BY threadID, datesent" (Access mdb) threadID is a string (OK, I know!), which means that 103 displays before 99. Is there a way to write the SQL query to order them numerically? This would be much easier for me than changing the data type and hunting down every page that INSERTS or UPDATES the db.
I am extremely confused about how i should go about doing this: I have puled out current orders and have displayed in a table .These orders have their own order numbers.
Once the person clicks on first order,the order is displayed in a form,where the user can edit the order details and hit submit.
Now when he hits submit ,I want his to go the previous page where the orders are displayed in table ,so that he can click on the next order and process it/OR may be whent he user hits submit ,i want the next order directly to be displayed in the form.
I have a table in my database with several numbers.(2, 5, 8, 0, 9, 0).Now i retrieve the numbers to my page using "order by numbers", and my page look like this.
0 0 2 5 8 9
I want the lowest number to be first, but if the number is 0 (zero) I want it to go to the bottom.Can that be done
I have one table wich has a unique ID feild for each record and other feilds, and another table that has one field that is a number that contains the an ID from the other table and another field that contains some text.
I want to open with sql the first table, but order its records alphabetically by the text in the second table. is it possible? Code:
When I have the recordset in the order as follows, all works well: (Recordset2.Fields.Item("ProductName").Value) (Recordset2.Fields.Item("ShortDescription").Value) (Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
I've got a site with PayPal and Google Checkout payment options. The checkout page formats two HTML forms, containing bespoke cart code - one posts to PayPal, the other to Google Checkout.When an order is placed, it needs to be updated back on my site, so that the order is marked as 'paid' in the database. When this is done with PayPal, I just provide a hidden field in the form called 'invoice' containing my id number for that transaction. This is returned in my IPN, and I update the database accordingly. However, I can't find a similar field in Google. Their example code all seems to be in XML and is WAAAAAAAAY more complicated than I need it to be. I just need to send a value with my cart code to Google Checkout, and have that value returned after the transaction has completed. I've set up Google Callback, and the page is being called and the order is being written to my google log txt file, I just need this to contain my order id number for the transaction so I can just add the logic to update the database based on this id number.
I've written the following piece of code which is embedded in HTML. For some reason when the script is processed the last response.write statment is displayed before the information in the while loop. I can't seem to figure out why this is happenming.
I'm working on a list of members.In my db I have two columns lastName and marriedName lastName is the member name before they got married and legLastName is their lastname after they got married.
Now I need to display theese two columns in alphabetical order in one list. If I for example have theese members: lastName, marriedName Anderson, Johnson Petersson, Svensson Nilsson, Persson Lindgren, Johnson
I want this result: Anderson Johnson (look for Andersson) Johnson(look for Lindgren) Nilsson Persson(look for Nilsson) Petersson Svensson(look for Petersson)
I am processing the variables from a form submission with a for/next loop. The problem is that the order of the variables are NOT written IN ORDER.
Form field 1 prints fine but then it jumps to Form field 9 and then back to Form field 4 then to Form field 2, etc. IS there a way to process the form variables in a loop in ORDER? field 1, field 2, field 3, etc? Code:
And one clicks on the form, and a SQL statement is executed. However, when I create the SQL statement,
INSERT INTO table1 (FormId,AdvantageId,SortOrder) VALUES (<call from form ID>,<advantages>,<advantsort>)
Then it loops to allow the next phrase to be entered. The statement also takes the value from every other sort order value including that ones that are in different lines. Which in result, gives me an error, saying the insert columns exceed that of the available columns in the table.