check record database in javascript

[cat5ive]

Hi,

I try to query to check if record exist. I copied the code that I used in vbscript and tried to modify in javascript. When I run my asp page, I got error message "missing ')'" and it pointed to the statement that I color in red.

Please help.

<script type="text/javascript" defer>
  <!--
function check_input()
{  

      var objconn = Server.CreateObject("ADODB.Connection")
[COLOR=red]
      objconn.Open(DSN=as400DSN, database=172.16.1.10, uid=NO, pwd=XXXX, " ")[/color]
       var rsMVAPH = Server.CreateObject("ADODB.Recordset")
           var sql = "SELECT phinv# FROM cisdtalib.$mvaph where phinv#='"&strinvnumber&"'"
       rsMVAPH.Open(sql, objconn,1,1)
       if (not rsMVAPH.eof)
	   {document.write ("found");
	    }
	else
           {document.write("no");
	   }
	   document.end 
}
  -->
	</script>

 

[BillyRayPreachersSon]

Try putting semicolon characters in to delimit the statements. You should also quote your string parameters.

Hope this helps,
Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]

 

[cat5ive]

Do you mean like this?

objconn.Open(DSN="as400DSN", database="172.16.1.10", uid="NO", pwd="XXXX", " ");

I still got the same error.

Thanks

 

[trollacious]

You'll have a problem with this statement:

var sql = "SELECT phinv# FROM cisdtalib.$mvaph where phinv#='"&strinvnumber&"'"

because Javascript uses the plus sign to concatenate strings, not the ampersand like VBScript.

And I think BRPS meant

objconn.Open("DSN=as400DSN", "database=172.16.1.10", "uid=NO", "pwd=XXXX", " ");

but figure he'll correct this if it's wrong.

Lee

 

[BillyRayPreachersSon]

No - ALL your strings must have quotes around them, not just half of them. If the "Open" call takes one big string parameter, then put quotes around the whole lot:

objconn.Open('DSN=as400DSN, database=172.16.1.10, uid=NO, pwd=XXXX, " "');

If it takes separate parameters, then put quotes around each:

objconn.Open('DSN=as400DSN', 'database=172.16.1.10', 'uid=NO', 'pwd=XXXX', " ");

Hope this helps,
Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]

 

[cat5ive]

Hi,

I tried both, still get same message (missing ')').

 objconn.Open('DSN=as400DSN', 'database=172.16.1.10', 'uid=NO', 'pwd=XXXX', " ");

or

objconn.Open('DSN=as400DSN, database=172.16.1.10, uid=NO, pwd=XXXX, " "');

Thanks

 

[trollacious]

Other variations maybe?

objconn.Open("'DSN=as400DSN', 'database=172.16.1.10', 'uid=NO', 'pwd=XXXX', ' '");

or

objconn.Open("DSN='as400DSN'", "database='172.16.1.10'", "uid='NO'", "pwd=XXXX'", " ");

Lee

 

[cat5ive]

No luck, same message.

Thanks

 

[theniteowl]

Are you guys missing this or is there a difference in server-side javascript I am not familiar with?

 if ([b][COLOR=red]not[/color][/b] rsMVAPH.eof)

It's hard to think outside the box when I'm trapped in a cubicle.

 

[BillyRayPreachersSon]

That's also an error, yes - along with this line, too:

 document.end

I suspect that that shold either not be present at all, or should have brackets after it:

 document.end)();

Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]