[thelist] ASP Database Problem. Any Ideas?

Melissa Phelps Firestone liss at frameshift.com
Mon Sep 25 11:55:49 CDT 2000


If you were to response.write your query, you'd find two problems: First,
you need to quote your variables, since they're strings and not integers
(apparently). Second, you need to pull your variables out of the string
quote or they won't be interpreted.

Your statement needs to look like
"INSERT INTO Links (LinkURL, LinkName, LinkBlurb,DateAdded)
VALUES ('" & LU & "', '" & LN & "', '" & LB & "', '" & LDA & "')"

on 9/25/00 12:03 PM, Tab Alleman <talleman at autobex.com> wrote:

> Okay, here's my code:
> 
> LU = Request.Form ("URL")
> LN = Request.Form ("prefix")
> LB = Request.Form ("blurb")
> LDA = Date
> 
> Set Connect = Server.CreateObject ("ADODB.Connection")
> Connect.Open "Fonto"
> 
> SequelFunction = "INSERT INTO Links (LinkURL, LinkName, LinkBlurb,
> DateAdded) VALUES (LU, LN, LB, LDA)"





More information about the thelist mailing list