Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL query output !

Status
Not open for further replies.
da21

da21

Programmer
Dec 4, 2002
23
US
Looking for some kind help on this ! i am in puting Fluffy in the text field created in thw shopping cart.And the output resultis giving me: Fluffy Fluffy
Am I making some big mistake or is it sql query spaces ! Please help !

<html>
<body>

<%
Class.forName(&quot;org.gjt.mm.mysql.Driver&quot;).newInstance();
connection = DriverManager.getConnection(connectionURL, &quot;root&quot;, &quot;samans&quot;);
statement = connection.createStatement();
out.println(&quot;<b>&quot; + request.getParameter(&quot;tex&quot;) + &quot;</b>&quot;);
String nam = (request.getParameter(&quot;tex&quot;));
out.println(&quot;<b>&quot; + nam + &quot;</b>&quot;);
rs = statement.executeQuery(
&quot; select * &quot;
+ &quot; from pet &quot;
+ &quot; where name = ' &quot; + nam + &quot; ' &quot;);
while (rs.next()) {
out.println(rs.getString(&quot;nam&quot;));
}

rs.close();
%>

</body>
</html>
 
Sort by date Sort by votes
I just wanted to add that i am working with mysql where I am using a table pet where 'Fluffy' exists.the output is coming for the first two print statement.But the third is empty!!
 
Upvote 0 Downvote
the output is giving fluffy twice because u print it twice:
out.println(&quot;<b>&quot; + request.getParameter(&quot;tex&quot;) + &quot;</b>&quot;);
String nam = (request.getParameter(&quot;tex&quot;));
out.println(&quot;<b>&quot; + nam + &quot;</b>&quot;);


Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote

that's true! But i am unable to figure out the proble, in my third print out, why is that coming empty !
 
Upvote 0 Downvote
o.k try this:
String sql=&quot; select * from pet where name = ' &quot; + nam + &quot; ' &quot;;
out.println(sql);
try running the query in mysql. see if it does return a record...
rs = statement.executeQuery(sql);


Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
247
EdLentz
EdLentz
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
274
dylim
dylim
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
111
Chris Miller
Chris Miller
martinkaeser
  • Locked
  • Question
MySQL Query for incrementing field from duplicates in database
Replies
4
Views
109
martinkaeser
martinkaeser
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
86
madcelt
madcelt

Part and Inventory Search

Sponsor

Back
Top