asked on

FP Issues

Dear EE experts,

In fact I have 3 demands which are so important at this stage in my project.

Problem number 1
My users fill a certain form to request some items. I want the store keeper to get notified when someone requests something. Is it possible to develope a form that sumbits to the database and to the store keeper's email at the same time?

Problem number 2
When I display an asp page that has full listing of our products I get it according to the item number. Is it possible to put links above the table to sort it according to other fields?

Problem number 3
In the purchasing list, I want the purchase date to be displayed in British format, i.e: day/Month/Year.

Thank you experts for your patience

Melvin

ASKER CERTIFIED SOLUTION

hhammash

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hhammash

Hi again,

To answer your last question I will give you and example which you can apply to suite your needs.

Let's say that the Database is called Staff and the Table is called StaffInfo. The table has the following fields. StaffName, Salary, DateJoined.

Now we want to create a DRW to display all these information, but with DateJoined as dd/mm/yyyy instead of mm/dd/yyyy. A British Date as you requested.

In frontpage
1- Select Insert>Database>Results
2- Select the Database Connection (in our example Staff)
3- Next Step click on Custom Query Button.
4- Insert the following SQL:
Select StaffName,Salary, Fomat(DateJoined,'dd/mm/yyyy') From StaffInfo
5- Continue the Database results till the end.

Try the page, it will display all date joined as dd/mm/yyy.
Of course you can use yyyy/mm/dd, mm/dd/yyyy, dddd dd,mmmm,yyyy

I hope that this solves your problems.

melvinob

ASKER

thks for you quick reply

I'll give it a try and let u know