|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Problem with reading integer value from a FORM |
|
From: |
Ronny Scheffer |
|
Date: |
10/18/1999 4:33:00 PM |
|
IP: |
212.120.66.194 |
Hello,
I was wondering if someone could help me.
I’m having a problem with my database. I would like to remove a record from the database table “vraag_tabel”, but ik keep getting an ODBC error about a typemismatch.
I think it’s about the fact that “vraagid” is an integer an that “Request.Form("vraagid") only gets strings from the form. I don’t know how to solve this problem.
How do I convert the types?
“vraagid” is imported from the form (right_admin_removefaq.asp) and is a hidden inputtype. “vraagid” comes out of the database “help” and is a number that is automaticly generated.
The errorcode:
Microsoft OLE DB Provider for ODBC Drivers error 80040e07
Ik would like to remove all fields from the database that are owned by “vraagid”. “Vraagid” is the primary-key.
Greetings,
Ronny Scheffer
Down here the source code of my application.
----------------------------------------------
Right_admin_removefaq.asp
<HTML>
<HEAD>
<TITLE>COMPUHelp Vraag verwijderen</TITLE>
</HEAD>
<% Dim dbConn %>
<% Dim SQL1 %>
<% Dim result1 %>
<% Set dbConn=Server.CreateObject("ADODB.Connection") %>
<% dbConn.Open"help" %>
<% SQL1="SELECT * FROM vraag_tabel" %>
<% Set result1=dbConn.Execute(SQL1) %>
<FORM METHOD="post" ACTION="right_admin_faqremoved.asp" ><TABLE CELLSPACING="2" CELLPADDING="2" BORDER="0">˙LM/W3SVC/4/Root |
Follow Up - Re: Problem with reading integer value from a FORM - Tim 10/26/1999 8:05:23 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
