Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - asp update?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

asp update?

 Post Reply Post Reply
Author
gice View Drop Down
Newbie
Newbie


Joined: 11 June 2003
Location: Netherlands
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote gice Quote  Post ReplyReply Direct Link To This Post Topic: asp update?
    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)

%>

Back to Top
stephen View Drop Down
Newbie
Newbie


Joined: 23 August 2002
Location: United Kingdom
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote stephen Quote  Post ReplyReply Direct Link To This Post 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)

%>

 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.