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
<td valign="top"><input name="professional_user" type="text" id="professional_user" style="width:120px" value="<%=professional_user%>" maxlength="50" class="content1"></td>
<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>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)