Please I need an example INSERT INTO in ASP? I can make SELECT without problem but I
cannot insert a row

hadt <hdiaztorres@hotmail.com> wrote:

   
Please I need an example INSERT INTO in ASP? I can make SELECT without problem but I
cannot insert a row

I use this code and It does not work:

   Set Conn = Server.CreateObject("ADODB.Connection")
   Set RS = Server.CreateObject("ADODB.Recordset")
   Connstring = "DSN=SERVEXTEST;CatalogName=C:\Servex Web\Copy of
GROUPESDP\SERVEX\DATA;DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local"
   Conn.open Connstring
   query = "Insert into CALL_JOBS
(CJCallNumber,CJJobNumber,CJLabourDuration,CJWorkAction,CJTechnicianNumber) VALUES
(2312,4,1,'TRAVAIL',1)"    
   Set RS = Conn.Execute(query)

I found the solution. only I was to change the rights to the users with this file (Write)