insert problems With Ultradev

[nkuk]

I would very much apreciate if some one could help me with this code.

It is an ASP page that is supposed to INSERT data in an ACCESS database.

The table is simple;

Usuario_ID
UsuarioUsername
UsuarioEmail

The code of this page is;


<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;../Connections/ConnbrainPowered.asp&quot; -->
<%

if(Request.QueryString(&quot;username&quot <> &quot;&quot then Command1__NKusername = Request.QueryString(&quot;username&quot

if(Request.QueryString(&quot;email&quot <> &quot;&quot then Command1__NKemail = Request.QueryString(&quot;email&quot

%>
<%

set Command1 = Server.CreateObject(&quot;ADODB.Command&quot
Command1.ActiveConnection = MM_ConnbrainPowered_STRING
Command1.CommandText = &quot;INSERT INTO usuario (UsuarioUsername, UsuarioEmail) VALUES (&quot; + Replace(Command1__NKusername, &quot;'&quot;, &quot;''&quot + &quot;, &quot; + Replace(Command1__NKemail, &quot;'&quot;, &quot;''&quot + &quot &quot;
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>


Would someone please tell me why it does not work?


Many, many, many thanks

Nicolas

 

[mlawson]

Hi there,

Have you tried replacing the + with & in your replace strings within the SQL code?

M &quot;There are 3 kinds of people; those that can count and those that can't&quot;

 

[Thanks]

I have decided to do it by hand.
So I got a book from my local library on SQL and done...

Ultradev helps but sometimes it is a pain!

Thanks for your attention Mlawson.

Nicolas