Closed

form to update and add to a table

must be written in classic asp/vbscript & javascript/jquery

We have a table that people on our web site can enter product questions. the question is entered into a table where

sales reps can answer them. we need a back end for that allows us to administer the table.

the table has the following columns

here is the SQL to create a copy of the table

CREATE TABLE `qa` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`ItemID` int(11) DEFAULT NULL,

`Question` longtext,

`Answer` longtext,

`loginid` int(11) DEFAULT NULL,

`QName` varchar(255) DEFAULT NULL,

`AName` varchar(255) DEFAULT NULL,

`State` varchar(255) DEFAULT NULL,

`DateEntered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

`Active` int(11) DEFAULT '0',

`edited` int(1) DEFAULT '0',

`editor_remove` int(1) DEFAULT '0',

`edited_by_loginid` int(11) DEFAULT NULL,

`via_email` int(1) DEFAULT '0',

`via_chat` int(1) DEFAULT '0',

PRIMARY KEY (`ID`),

KEY `itemid` (`ItemID`)

)

when creating the program please allow for the table name to be a prameter that is set only once so we can change the table name in one place.

we need 3 pages.

1) to view a list of all the q&a with pagination

2) to add a q&a

3) to edit a q&a

1) to view a list of all the q&a with pagination

this is a page that has a table. each row is another q&a with the following columns contain the information of each field in the database. We also need on each row an "edit" button. that will bring us to page #3 above that will allow us to edit a specific q&a. (it can be a light box.)

pages 2) should a page (or pop up/light box) that allows the user to enter information for each field

page 3) should allow the user to find a q&a based on exact match to any field. and edit any information

the "Active" & "edited" & "editor_remove" should show up as a check box. checked = 1 unchecked = 0

the "loginid" should be set as a variable in one place and we will fill it when we install the page

also please be aware that in the "Question" & "Answer" fields the user may enter quotes please code accordingly

Skills: ASP, Javascript, jQuery / Prototype, MySQL

See more: where to find sales people, web pagination, q find, product sales reps, find reps, copy edited, javascript to edit page, where to find sales reps, web page product enter, update product page, timestamp, table, qa a, Q&A, find a name, fill form, edit 343, creating question, create a web page that allows, classic name, javascript table copy, asp jquery sql, add edit view, jquery web form, administer

About the Employer:
( 1 review ) Lakewood, United States

Project ID: #1152033

8 freelancers are bidding on average $161 for this job

lsweb

Hello. Please check your PM. Thanks.

$250 USD in 5 days
(126 Reviews)
7.3
shmai

have a glance at PM. regards,

$200 USD in 5 days
(181 Reviews)
6.9
ntiersolutions

Please check your pm.

$250 USD in 8 days
(76 Reviews)
6.0
Vikaskukki

Hi Very Interesting project for us as we have 10 + years in developing in Classic ASP , ASP.NET with MS SQL 2000,2005,2008,MSACCESS,XML,CSV,XLS Dhtml,Dhtmlx,AJAX/JAVASCRIPT/XML/CSV, ASP.NET C#, Ajax2.0 for Both ASP. More

$210 USD in 5 days
(22 Reviews)
5.6
vesel

I am completly free.

$250 USD in 7 days
(0 Reviews)
0.0
AndyES

I have 15 years experience developing with ASP/HTML/Javascript. This will take me approx two days to complete.

$150 USD in 2 days
(0 Reviews)
0.0
ahesanalimomin

please see you pmb sir

$50 USD in 2 days
(0 Reviews)
0.0
saady89

check your pm! =) thanks

$130 USD in 7 days
(0 Reviews)
1.8
ninomirza

I will do it quick and cheep try me :)

$50 USD in 2 days
(0 Reviews)
0.0