Click here to Skip to main content
15,913,685 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: Web Site is not Accessible by its IP? Pin
AliAmjad11-Nov-07 7:32
AliAmjad11-Nov-07 7:32 
GeneralRe: Web Site is not Accessible by its IP? Pin
Guffa11-Nov-07 8:56
Guffa11-Nov-07 8:56 
GeneralRe: Web Site is not Accessible by its IP? Pin
AliAmjad11-Nov-07 22:11
AliAmjad11-Nov-07 22:11 
AnswerRe: Web Site is not Accessible by its IP? Pin
Vasudevan Deepak Kumar11-Nov-07 23:38
Vasudevan Deepak Kumar11-Nov-07 23:38 
Questionupdate tables row with vbscript in asp Pin
idsanjeevjha9-Nov-07 16:59
idsanjeevjha9-Nov-07 16:59 
AnswerRe: update tables row with vbscript in asp Pin
Guffa10-Nov-07 3:54
Guffa10-Nov-07 3:54 
QuestionRe: update tables row with vbscript in asp Pin
idsanjeevjha11-Nov-07 16:08
idsanjeevjha11-Nov-07 16:08 
AnswerRe: update tables row with vbscript in asp Pin
Guffa11-Nov-07 19:51
Guffa11-Nov-07 19:51 
idsanjeevjha wrote:
vopenflg = Request.Form("vopenflg")


Do you have a field named "vopenflg"?

conn.close


You forgot to close the recordset before closing the connection. Why are you closing the connection at all?

conn.Mode = adModeReadWrite
conn.open


Do you really have to change the mode? Have you set a different mode before opening the connection the first time? I don't think that I have ever seen anything used but the default mode for the connection. What database are you using?

R.open "select top_id,open_flg from topmaster ",conn, adOpenStatic, adLockOptimistic, adCmdText


You should do the update before you loop out the rows. Closing and reopening the recordset in the middle of the loop really messes up things.

You have to specify what record you want to update, otherwise you will be updating the record that happens to be first in the result.

if request("vopenflg"&R("top_id"))<>"" then


Don't use the Request collection. Specify if the data comes from Request.Cookies, Request.ServerVariables, Request.Form or Request.QueryString.

As you have reopened the recordset, R("top_id") no longer contains the same id as you used in the select element above. You will be reading from the select element in the row that matches the record that happens to be first in the recordset. You will be using the correct data for the update, but you are not updating the record that you think that you are.


Experience is the sum of all the mistakes you have done.

GeneralRe: update tables row with vbscript in asp Pin
idsanjeevjha11-Nov-07 20:55
idsanjeevjha11-Nov-07 20:55 
AnswerRe: update tables row with vbscript in asp Pin
Guffa11-Nov-07 21:17
Guffa11-Nov-07 21:17 
GeneralRe: update tables row with vbscript in asp Pin
idsanjeevjha11-Nov-07 22:09
idsanjeevjha11-Nov-07 22:09 
AnswerRe: update tables row with vbscript in asp Pin
Guffa12-Nov-07 1:57
Guffa12-Nov-07 1:57 
GeneralRe: update tables row with vbscript in asp Pin
idsanjeevjha12-Nov-07 15:55
idsanjeevjha12-Nov-07 15:55 
AnswerRe: update tables row with vbscript in asp Pin
Guffa12-Nov-07 22:11
Guffa12-Nov-07 22:11 
QuestionRe: update tables row with vbscript in asp [modified] Pin
idsanjeevjha12-Nov-07 22:56
idsanjeevjha12-Nov-07 22:56 
AnswerRe: update tables row with vbscript in asp Pin
Guffa13-Nov-07 12:46
Guffa13-Nov-07 12:46 
GeneralRe: update tables row with vbscript in asp Pin
idsanjeevjha13-Nov-07 16:56
idsanjeevjha13-Nov-07 16:56 
AnswerRe: update tables row with vbscript in asp Pin
Guffa14-Nov-07 3:05
Guffa14-Nov-07 3:05 
QuestionASP Email Script Not Working Pin
MelDrop9-Nov-07 5:06
MelDrop9-Nov-07 5:06 
Questionhow to break a table into two tables with javascript? Pin
andylaw8-Nov-07 22:47
andylaw8-Nov-07 22:47 
AnswerRe: how to break a table into two tables with javascript? Pin
Guffa9-Nov-07 12:38
Guffa9-Nov-07 12:38 
GeneralRe: how to break a table into two tables with javascript? Pin
andylaw9-Nov-07 15:41
andylaw9-Nov-07 15:41 
GeneralRe: how to break a table into two tables with javascript? Pin
Michael Sync10-Nov-07 23:10
Michael Sync10-Nov-07 23:10 
Questionproblem with registration of new website on IIS Pin
0x49D18-Nov-07 20:01
0x49D18-Nov-07 20:01 
AnswerRe: problem with registration of new website on IIS Pin
Michael Sync8-Nov-07 20:30
Michael Sync8-Nov-07 20:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.