Home | Advertising Info149 USERS CURRENTLY ONLINE   
   Site Search Contact Us Sunday, November 29, 2015  

User Management Application with web based screens that allow you to manage users.
Banner Rotation system. Advertisers can monitor online statistical reports via their web browsers.
ASP Photo Gallery
Upload an unlimited amount of albums. Set up categories.Image resizing thumbnail creation.
Classifieds system. Set up categories. Users can register themselves. Supports picture uploads.

Try a free httpZip trial now and compress for less!

We didn't realize
the site was so popular.

Other Stuff

Active Server Pages ASP control controls class classes module script Scripts applet 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



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.

Ronny Scheffer

Down here the source code of my application.
<TITLE>COMPUHelp Vraag verwijderen</TITLE>

<% 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


   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2015 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com