Classic ASP Discussion

Print Page | Close Window

asp update?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3445
Printed Date: 29 March 2026 at 5:00pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: asp update?

Posted By: gice
Subject: asp update?
Date Posted: 11 June 2003 at 4:50am

I have a problem with updating text in a database

I have a asp page with text edit box, these let me see the text from the database. I wan't to change this text, but with the asp page which this text must change doesn't work it.

This is the code what's wrong ? Can somebody help me please

dim irrecordset

dim nextSQL

set irrecordset = server.createobject("ADODB.recordset")

nextSQL ="UPDATE indexconsument SET blok1 ='"&Request("blok1")&"' WHERE indexnr="&Request("indexnr")&""

call irrecordset.open (nextSQL, strCon)

-------------
gijs

Replies:

Posted By: stephen
Date Posted: 11 June 2003 at 9:38am

Why don't u try a de-bug. It probably b'cos the value/s are not been passed accross to the page. Try

dim irrecordset

dim nextSQL

set irrecordset = server.createobject("ADODB.recordset")

Response.Write "This is the block " & Request.QueryString("blok1")

Response.End

nextSQL ="UPDATE indexconsument SET blok1 ='"&Request("blok1")&"' WHERE indexnr="&Request("indexnr")&""

call irrecordset.open (nextSQL, strCon)