trouble in adding to dbase

minster · #1 08-25-2006, 11:47 AM

This code should recieve values from the submit page and then add them to my database:
Code:

<html>
<head><title>zeid</title></head>
<body>

<%
DIM URL,DESCRIPTION,KEYWORDS
URL = REQUEST.FORM("URL")
DESCRIPTION = REQUEST.FORM("DESCRIPTION")
KEYWORDS = REQUEST.FORM("KEYWORDS")

IF URL = "" THEN
RESPONSE.WRITE "NO URL"
ELSE IF DESCRIPTION = "" THEN
RESPONSE.WRITE "NO DESCRIPTION"
ELSE IF KEYWORDS = "" THEN
RESPONSE.WRITE "NO KEYWORDS"

ELSE

DIM ADDURL
SET ADDURL = SERVER.CREATEOBJECT("ADODB.RECORDSET")
ADDURL.OPEN "DATABASETABLE1", CONN, 3, 3
ADDURL.ADDNEW
ADDURL("URL") = URL
ADDURL("K -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

bizzare · #2 08-25-2006, 11:48 AM

Mate, you should change the ELSE IF to ELSEIF without spaces. Hope u got what u want. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --