Please help in systax on access Sql Server database via function

[lligogogo]

Hi, I am new on java function. I created a FORM in asp page, the FORM have three switch. When user selects UPDATE, first thing have to validate is check if this user id is in the control table or not. I think the best way is to check it inside a FUNCTION. I spend two days try to figure out the systax. Now I even doubt if access Sql Server database could be done inside the function or not? Could you please help me? Thank you.

What I think the systax like this?

function Preview2()
{
var strLast = document.frmAdd User.selLast.va lue;
var strFirst = document.frmAdd User.selFirst.v alue;

var objCon = Server.CreateOb ject("ADODB.Con nection");
var connstring = ("Driver={SQ L Server}; Server=mfintraw eb; Database=HR; UID=query; PWD=query");
objCon.open (connstring);
var SQLCommand = ("SELECT count(*) FROM dbo.Inve_User_E quAssigned where lastname = '" + strLast + "' and firstname = '" + strFirst + "'");
var objRS = objCon.Execute( SQLCommand);
var objReturn = objRS(0);

if ( objReturn == 0 )
{
alert ("The user " + strLast + ", " + strFirst + " is not in inventory control list. Check the user name, or add new user first.");
return false;
}
else
{
document.frmAdd User.action = 'manage_user_eq u.asp?mode=Edit &last=' + strlast + '&first=' + strfirst ;
document.frmAdd User.target = '_self';
return true;
}
}

[r035198x]

Hi, I am new on java function. I created a FORM in asp page, the FORM have three switch. When user selects UPDATE, first thing have to validate is check if this user id is in the control table or not. I think the best way is to check it inside a FUNCTION. I spend two days try to figure out the systax. Now I even doubt if access Sql Server database could be done inside the function or not? Could you please help me? Thank you.

What I think the systax like this?

function Preview2()
{
var strLast = document.frmAdd User.selLast.va lue;
var strFirst = document.frmAdd User.selFirst.v alue;

var objCon = Server.CreateOb ject("ADODB.Con nection");
var connstring = ("Driver={SQ L Server}; Server=mfintraw eb; Database=HR; UID=query; PWD=query");
objCon.open (connstring);
var SQLCommand = ("SELECT count(*) FROM dbo.Inve_User_E quAssigned where lastname = '" + strLast + "' and firstname = '" + strFirst + "'");
var objRS = objCon.Execute( SQLCommand);
var objReturn = objRS(0);

if ( objReturn == 0 )
{
alert ("The user " + strLast + ", " + strFirst + " is not in inventory control list. Check the user name, or add new user first.");
return false;
}
else
{
document.frmAdd User.action = 'manage_user_eq u.asp?mode=Edit &last=' + strlast + '&first=' + strfirst ;
document.frmAdd User.target = '_self';
return true;
}
}

surely you are not trying to connect to a database using javascript?

[lligogogo]

surely you are not trying to connect to a database using javascript?

Hi r035198x,

Thank you for reply.

I am not sure what you mean? Does you said, I could not access to database via java function?

I did want to access to Sql Server inside function. Does java function not support it?

[r035198x]

Hi r035198x,

Thank you for reply.

I am not sure what you mean? Does you said, I could not access to database via java function?

I did want to access to Sql Server inside function. Does java function not support it?

What you are writting is javascript not java.
It is possible to connect to a database in java using jdbc.
javascript is client side and cannot access a database directly.

[lligogogo]

What you are writting is javascript not java.
It is possible to connect to a database in java using jdbc.
javascript is client side and cannot access a database directly.

Hi r035198x,

Thank you for your information. I will looking into the jdbc.