<div>
Does the 1 in the follwing statement, equate to which row of the database you are reading from?<br />
<br />
stmt.setString( 1, param ) ;<br />
<br />

</div>


Does the 1 in the follwing statement, equate to which row of the database you are reading from?

stmt.setString( 1, param ) ;



<div>
No, it sets the first ? in the prepares statement :-)<br />
<br />
rslt.next() gets the next (first in this case) row of the resultset ready, then you can read the &quot;name&quot; field out of it
</div>


No, it sets the first ? in the prepares statement :-)

rslt.next() gets the next (first in this case) row of the resultset ready, then you can read the "name" field out of it

<div>
ahh, thanks. I'm a really newbie at Java stuff. I've been using JSTL, but I need to step it up a gear. I'll give that a go. Thanks
</div>


ahh, thanks. I'm a really newbie at Java stuff. I've been using JSTL, but I need to step it up a gear. I'll give that a go. Thanks

<div>
Hope it works :-)<br />
<br />
<a href="http://java.sun.com/developer/qow/archive/73/index.html" rel="ugc">http://java.sun.com/developer/qow/archive/73/index.html</a><br />
<br />
Should help too :-)<br />
<br />
Good Luck!<br />
<br />
Tim
</div>


Hope it works :-)

http://java.sun.com/developer/qow/archive/73/index.html [http://java.sun.com/developer/qow/archive/73/index.html]

Should help too :-)

Good Luck!

Tim

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
How would I go about getting the same result as PHP's:<br />
<br />
$query = mysql_query(&quot;SELECT * FROM RUNNINGINSTANCE WHERE UNITLINK = $param&quot;);<br />
$instancename1 = mysql_result($query,0,&quot;nam<wbr />e&quot;);<br />
<br />
would in JSP? <br />
<br />
Thanks
</div>
</div>


Hello,

How would I go about getting the same result as PHP's:

$query = mysql_query("SELECT * FROM RUNNINGINSTANCE WHERE UNITLINK = $param");
$instancename1 = mysql_result($query,0,"name");

would in JSP? 

Thanks

Achieiving the equivelent of PHPs mysql_result command in JSP

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.