I know its outside of the scope of the question but concatenating string objects annoys me! Use StringBuffer or StringBuilder!
Also - if you're calling these methods regularly, perhaps you should be using Stored Procs and calling them through CallableStatements?
It'll be quicker and safer :)
Wouldnt it be an instance of SQLClientInfoException thrown in this particular example?
Failing that, you could always capture SQLException, thus avoiding pitfalls of catching the general Exception case (not so good)
I'd say put it in your throws clause though - make sure your finally closes...
Probably the easiest way for me to explain (as I'm self taught on this...) is I access the Integrated Systems Console - press Enterprise Applications, Choose my application and then press session management under the web module properties section.
I'm then given the option (among others) of...
On my Websphere console, I'm setting the timeout for anyone hitting the site to 15 minutes.
Does this mean that the session is still alive for 15 mins even if they leave the site after 2?
Reason being, I allow 1000 concurrent sessions, and in peak times this does come close to the knuckle -...
Hi
I'm running a stored procedure through my C# code and when I run this locally, the stored procedure works correctly.
However, if I compile my C# application (builds successfully) and then run it remotely through its URL, the stored procedure doesnt run properly.
Its not the code, or...
Hi - I've got a VB6 program which runs with a database back-end.
I would like to implement a module that checks for the existence of fields in the database, and if they're not there, create them using a simple SQL query.
The creation of the fields is easy, however I'm struggling on how to...
Hi
My program opens Microsoft Word documents and allows the user to choose from a combobox in the program what codes to insert to the document.
However it only works correctly for the first opened document (ie works fine if no other word docs are open prior to running the program but if they...
Thanks for your reply but I can't seem 2 get it to work.
Below is an extract from my code where I've tried to use your suggestion.
$k=0;
while ($k < $numt) {
$description = mysql_result($resultt,$k,"WorkType");
$MOpened = mysql_result($resultt,$k,"Opened");
$MClosed =...
Hiya
I'm new to PHP and sorry if I'm asking a stupid question.
Right my problem...
I query a table and return a summary of each record as a row in a html table. Next to the summary I want the user to be able to select a link which loads a new page displaying the complete records details.
My...
I now have the following line - an error occurs when I'm trying to paste into a new document:
.selection.Fields.Add range:=.selection.range, Type:=wdFieldEmpty, Text:=frmDocTailAssistant.Label2.Caption, PreserveFormatting:=True
The error is "value out of range" - and I'm guessing its...
I am inserting text into my document via a vb6 program - it does this just fine (when I press the button, it inserts the text as required).
However, I'd like it to insert a mergefield (its a letter customisation program) - but I cant seem to do it.
Below is the slice of code that does it...
Ignore that, stupid error on my part - I was putting label3.caption in, and it was in a module rather than a form, everything works now I've put the form name in beforehand.
D'Oh!
Many thanks :)
If I use this code - it comes up with an error saying "Object Required" on the following line:
Clipboard.SetText Text1.Text, vbCFText 'Put text on Clipboard
Just wondering if theres a certain reference I need to enable to make it run?
Cheers
Thank you everyone :)
I've now learnt how to do this stuff pretty much.
For those who wanted to know, I'd stupidly closed the connection in a routine somewhere :( meaning it was only throwing errors when this routine had been activated - confusing me further!
But thanks for all the help :)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.