Man I hate that, the servers at house of fusion seem to be multiplying our
post to the group, makes it hard to follow a thread.
Here is what I have come up with so far. In my bean I had set up a getData
method to handle all database access and then getApplications, getUsers and
so on to accept arguments for the connection strings and to determine if the
result should return all the entries or just a specific user from the
database. I think I messed up by not implementing the bean with properties,
instead I was just returning the resultset itself. What I am going to try to
do is make a property in the bean called Applications, users and so on then
use the getXXX methods to run the query and drop the results into a vector
or list and return that to the page context. Hopefully that will resolve my
issue. It seems like if the resultset is referred to in the page it does not
exist after that. I am pretty new to the jsp stuff, so I appreciate
everyone's comments.
Bryan
----- Original Message -----
From: "shawn harris" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 6:19 PM
Subject: Re: Rogue url
| Bryan
| have you tried taking out the ApplicationID param and seeing if it runs
| then, it might be a parsing problem if the rs is coming back as a number
| instead of a string. I would try taking that param out and seeing if it
| works then. Hope that helps but if not let me know. Shawn
|
| ----- Original Message -----
| From: "Bryan LaPlante" <[EMAIL PROTECTED]>
| To: "JRun-Talk" <[EMAIL PROTECTED]>
| Sent: Saturday, July 07, 2001 7:15 AM
| Subject: Rogue url
|
|
| > Hi,
| >
| > I need a second pair of eyes on this line of code. I am trying to create
| an
| > anchor tag with the following url.
| >
| > NewApp.cfm?name=<%= showdb.getString("Name"); %>&description=<%=
| > showdb.getString("Description") %>&appID=<%=
| > showdb.getString("ApplicationID") %>
| >
| > When this line is commented out the loop around it runs fine displaying
| all
| > of the ResultSet. When I run this line of code I get a
| > java.sql.SQLException. Can anybody see what I am doing wrong?
| >
| > NT4 sp6
| > JRun3.0
| > IIS4
| >
| > Bryan LaPlante
| > 816-347-8220
| > [EMAIL PROTECTED]
| > http://www.netwebapps.com
| > Web Development
| >
| >
| >
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
