Click here to Skip to main content
15,896,512 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Quote:


Hi,

I have created a form in classic ASP.
In that there are two textboxes (professional user & selfservicse user) and a button (license history).

The entered values of professional user & selfservicse user are stored in a table "csp_license_details" in database.

When the button "license history" is clicked, a popup should appear which contain the history of license details.This button will display only when the edit button is clicked.

For Ex:
If the user entered professional user as 12 and selfservice user as 15 at first time and click the submit button means that value should store in DB.

Next time if the user click the edit button and changed the license values into 10 and 20 means that value also stored in the DB.

when the user clicks the licensedetails button the a popup will display which shows like
professional user-12 and selfservice user-15 (i.e) the old values.

But the problem is , the license values are stored each and every time when the edit button is clicked.

Even i didn't change the license values , the same values are stored stored again and again as i click the edit button.

My Code :
csp-client.asp

Professional users* :
HTML
<td valign="top"><input name="professional_user" type="text" id="professional_user" style="width:120px" value="<%=professional_user%>" maxlength="50" class="content1"></td>


Selfservice users*
HTML
<td valign="top"><span style="font-weight: bold">:</span></td>
									<td valign="top"><input name="slf_svr_user" type="text" id="slf_svr_user" style="width:120px" value="<%=slf_svr_user%>" maxlength="50" onkeypress="Displaytotal()" class="content1"></td>
								</tr>

<%if rmode=2 and isnull(professional_user)= false and isnull(slf_svr_user)= false then %>
		<tr>									
	         <td align="center" colspan="3">
			<input type="submit" name="submit" value="license details" id="submit"		onclick="licensepopup()"></td>
		</tr>						
	<%end if%>   

csp-client-post.asp

		if request.Form("professional_user")<>"" then
		rmode=2
		DSQL="Insert into csp_license_details(lic_val,updated_on) values('" & request.Form("professional_user") & "','" & now & "')"
		execute_query(DSQL)
		'response.write(DSQL)
		end if
		
		if request.Form("slf_svr_user")<>"" then
		rmode=2
		DSQL="Insert into csp_license_details(lic_val,updated_on) values('" & request.Form("slf_svr_user") & "','" & now & "') & "')"
		execute_query(DSQL)
		'response.write(DSQL)
		end if</blockquote>

Plz help ASAP..:)

Thanks in advance
Posted
Updated 19-Feb-15 16:40pm
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900