Common Order Form

I am a new user so I hope I am doing this correctly. If not, please point me in the right direction.I created a web site in 1995 using exclusively HTML becuase it was the easiest for a novice. When I created the site, I had about 70 types of invitations and I created an order form for each invitation type. Now I have more than 250 invitations and I would like to create a common (one page)order form. I do not want to have a shopping cart. The website is www.partyinvitations.com. Currently when the user clicks the invitation image, the user is hyerlinked to the order page. I would to have it so that the use is linked to a common order form and have that common order form have some specific information such as:
1. image of invitation being ordered
2. size of invitation being ordered
to
I need know the coding that needs to be placed on the sending page and the target page and anything else I need to do to make this work.

View Replies


ADVERTISEMENT

Insert A Common Into A Value

I have some values, inside the database, that have to have a defined format: 0,00. But in some cases, they are: 000. How can I transform it?

View Replies View Related

Submit Order Form

I have online order form that consists of textarea, textbox, radio button, check buttons and etc.. after that, click to submit via email with order form details to someone..

so i need to know what codings to do this to email to someone with order form details only..no need for db so can u please kindly show me how to do it?

View Replies View Related

Business Order Form

I'm starting an ecommerce site from scratch and I want to have a fairly simple order form to support around 10 products. I'd like it to have a shipping calculator, have fields for credit cards, and be able to send customers a thank you email after their order. I do have some experience with the asp code and form building but not too much. Is there a script I can download or a fairly reasonable product I could purchase to help me with this?

View Replies View Related

Form Field Order

I know that the order of from fields from a form post are somewhat random. But, what about fields that have the same name -

<input type="text" name="something" value=""> First Choice
<input type="text" name="something" value=""> Second Choice
<input type="text" name="something" value=""> Third Choice
<input type="text" name="something" value=""> Fourth Choice

First = "bananna"
Second = "orange"
Third = ""
Fourth = "apple"

Will the values, in the delimited list contained in Request.Form("something"), always be in the order they are in the form? That is - bananna, orange, , apple

View Replies View Related

ID To Follow Through Onto Order Form

Basically when a customer sees the gift they want, they click order, which takes them to the order form....all i want to know is how i can get the gifts ID onto the order form. It may be better if you have a look at what im trying to do Example of this trying to work .

View Replies View Related

Creating Order Form Page

how to get started with this project. I want a page where a
user can manually enter an order. Our users know our order# system and it's
much easier to manually enter items as opposed to using a shopping cart and
flipping through multiple pages.
On the page would be the following....
1) Billing address
2) shipping address
3) fields for order numbers

Billing and shipping seem pretty straight forward.
Because I have no idea of how many products a customer will order, I'm
picturing a new order# field being created when one is filled out. How do I
do this?Then, assuming I get all these dynamically generated fields, how do I get
them into an OrderDetails table?

View Replies View Related

Form Field Submit Order

I have a form with stacks of fields. This is submitted to a formmail.asp script at my isp which emails the values in the form to me.

Is there anyway using dreamweaver that I can define the order of the form fields when they are submitted to me via email? I eventually add the values in the form to a bit of paper, it would be handy if the email could have them listed in the order they are printed on on the bit of paper.

View Replies View Related

CDONTS To Send Order Form To Emails

I know this question is stupid. But i need some advice for this. I
am trying to develop a website, which will allow the user send to order form
to the admin email. I am planning to use the CDONTS component method.
Can I just to localhost server to test, whether the form can be send
up to the admin's email. Or I must have the Hosting server to do that. Can
Anyone suggest me, how to I test my scripts can be successfully run (at
localhost), before I host it on the Web Servers.

View Replies View Related

Order Form Needs To Send Cust Receipt

I am learning more and more about asp but can't find and figure out where and what varialbles to add to this form. I want to be able to have this form email to me and to the person that filled it out as there receipt as well.

I don't have it set up to show the results after they fill it out that would be nice but not sure how to do that either. My main focus is getting the receipt sent to the person that filled it out. Code:

View Replies View Related

ASP Form - Order Amount Not Coming Through On Email

This is my first asp form so please be gentle with me It's a publications ordering form. I've got the form and the asp code setup, when the form is sent the name of the publication comes through but not the amount ordered - i'm sure i've made a simple mistake somewhere - can anyone spot why the order amount isn't coming through. Code:

View Replies View Related

Multiple Dropdowns To Create An Arrary To Form ORDER BY Statement

Creating a form that allows people to search a ticket database. One criteria I would like to add is to give the people the option to sort the results by selecting criteria for a dropdown.

My first thought was to create 3 dropdowns with the same name, get the data and add it to the SQL string. It worked great except for when someone decided to leave anything blank.
Here are my dropdowns here: Code:

View Replies View Related

How To Create SELECT QUERRY FOR "A CHANGE ORDER FORM" In ASP?

I've got a problem i would like you to help me out with. My company has got a client who sells meat and my senior tech lead has customized the cart to fit their needs and have created a despatch table with a "simple asp form" that allows them to scan their products in with a wi-fi scanner. Code:

View Replies View Related

SQL: How To Use WHERE And ORDER BY?

I have a code looking like this, but i can't seem to get it to work:

strSQL = "SELECT * FROM files WHERE Subject = 1 ORDER BY ID DESC"

What am i doing wrong?

View Replies View Related

Order By A-z

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:

Microsoft JET Database Engine error '80040e14'

Characters found after end of SQL statement.

/html/advanced_comic_search.asp, line 56

Can any one shed any light on this for me?

View Replies View Related

SQL Order

I have records which I want to display a certain way, i.e. the records are in the database like this:

24TR
9L
133JF

But I want to display them as:

9L
133JF
24TR

Is it possible?

View Replies View Related

SQL Order

I am using an sql inner join like below:

strSQL = "SELECT * FROM tblPage INNER JOIN tblNews ON tblNews.NewsID=tblPage.pageID ORDER BY newsDate DESC"

However this orders both by newsDate which causes problems with the ordering of the page, As I want the page not to be ordered just the news item.

View Replies View Related

ORDER BY By Id

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.

View Replies View Related

Going To The Next Order

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.

View Replies View Related

Not Considering 0 (zero) Using Order By!

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

View Replies View Related

SQL Order By

At the moment I have:

SQL = "SELECT sample.* FROM sample WHERE (id = " & teamid & ") ORDER by pos"

Which orders my players like:
ATT
DEF
GK
MID
in alphabetical order.

Is there anyway to specify this order so that it still orders the players by "pos"(position) but in this order:

GK
DEF
MID
ATT

View Replies View Related

Order By NUM

i want to order by NUMBERS:

BUS n 1
bus n 2
ect.
bus n 10 bus n 11

But the order goes like this:
bus n 1
bus n 10
bus n 11
bus n 2
how can i get right order:
bus n 1
bus n 2
bus n 10
bus n 11 ....

View Replies View Related

Order By Where....

I am performing a basic sql query. select * from tablename order by featured asc, id asc

BUT...I want all those listings with FEATURED as a Y to show up first.
All other listings should show up afterwards.

How do I do this? I may be thinking too hard about it.

View Replies View Related

SQL Order BY Question

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:

View Replies View Related

Changing Order

I have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.

MSSQL table names and types:

ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc

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.

View Replies View Related

Returning Order Id

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.

View Replies View Related

SQL Order By Statement

Does anyone know how to organise data in alphabetical order when using a select statement???

When i use mine, i have been using ASC and it justs put the newest record added!

View Replies View Related

Processing Out Of Order

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.

Any ideas? Code:

View Replies View Related

Alphabetical Order

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)

View Replies View Related

FOR/NEXT Loop In ORDER?

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:

View Replies View Related

Sort Order?

I have a form that is created dynamically, and all is working fine. But I want users to add an sort order to help list phrases in a certain order.

<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="10">
Phrase1

<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="20">
Phrase2

so on, so forth...

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.

View Replies View Related

Order By Two Fields

can i set a list of users to be ordered by two fields soo
This:
user 1
user 2 Admin
user 3
user 4 Admin

Becomes

User 2 Admin
User 4 Admin
User 1
User 3

orginal

Code:

strSQL = "SELECT [username], [ID], [email], [admin], [suspend], [Timestamp], [last_login] FROM tblUsers ORDER BY username"

View Replies View Related

ORDER BY A Column?

If I have several fields:
a | b | c | d | e

and the original SQL = SQL & " ORDER BY a ASC ".

I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).

do I need to place an "if/ end if" in the sql or do I put some statement in the paging?

example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v

to

a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w

View Replies View Related







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