Iam Using SQL Server as Database.

I have function defined in a file called definedfuns.asp

--------------file code----------------------------------


<%


'--------------------- Function to add new users-----------------------

Function Add_user(Name, Email, Division, username, pwd)
dim dbConn,rs

     set dbConn = GetDataConnection

 set rs = server.createobject("adodb.recordset")

 rs.open "users_info", dbConn, 2, 2


'Use the addnew method of the recordset object to add a record
rs.addnew

 'Set the table column = to my input text box from my form

  rs("Name") = Name
  rs("Email") = Email
  rs("Division") = Division
  rs("username") = username
  rs("pwd") = pwd
rs.update

'I do a movelast here to get the ID that is automatically generated
'I also set the value to a local variable so I can write out to the database

rs.movelast
dim uno
uno = rs("user_no")
if uno <> " " then
Response.write "<b>User Added Sucessfully</b>"
else
Response.write "<b>Problem Encountered...</b>"
 end if

End Function

%>
---------------------------------------

I am calling this function in newuser.asp, iam pasting only the code which is giving error from newuser.asp.

-----------------File Code------------------------------------

<%

if Request("AddUser") <> "" then
   Dim Name,Email,Division,username,pwd
   Name = TRIM(Request("requiredname"))
   Email = TRIM(Request("requiredemail"))
   Division = TRIM(Request("requireddivision"))
   username = TRIM(Request("requiredusername"))
   pwd = TRIM(Request("requiredpwd"))

   Add_user(Name, Email, Division, username, pwd)
end if
%>

Error Message :Microsoft VBScript compilation (0x800A0414)
Cannot use parentheses when calling a Sub
/flash/HRResume/Newuser.asp, line 176, column 46
Add_user(Name, Email, Division, username, pwd)
---------------------------------------------^



Syed...

In VBScript, you can't use the parentheses around the parameter list when you call a Sub. So, change:

Add_user(Name, Email, Division, username, pwd)


to

Add_user Name, Email, Division, username, pwd

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Or you can include the Call keyword before calls to subroutines:

Call Add_user(Name, Email, Division, username, pwd)

Peter
------------------------------------------------------
Work smarter, not harder.