|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET 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:04:03 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
