Recent content by RiazKhanmohamed

similar, i didn't use creatobject, the sql twigged me. i used: If IsNull(capture_id) Then Dim rs As ADODB.Recordset Set rs = pcnn.Execute("Select @@identity as NewID from Capture") capture_id = rs.Fields("NewID") End If

man i should have spotted that one! thanks a million. now onto images maps :s

Hi, I want to (in code) get my connection to insert a row into table 'capture', and then add rows into my many to many table 'capture_species' using the id created in capture just now. I've seen references to methods like dlast, but what i want to know is: within the session, is there no way...

You can't link both nameFrom and nameTo at the same time otherwise you end up with a circular reference which will probably fail. try this: select t.NameFrom, t.NameTo, t.ActionID from TableTransaction t, TableName n where (t.NameFrom = n.NameID and (t.ActionID = 1 or t.ActionID = 2...

I have a program with two functions for sending emails in different ways, but both use mapi. the difference is unimportant. Both appear to be coded correctly. Both match what most people have posted on this site. Both fill the fields correctly (on watch), and on send if i type .send true, the...

Thanks jemminger. I think i'll stick to 1.4.2 and use that casting method. ImpureNokio: I said it would have been my next question, but jemminger answered it. and yes, you did copy it exactly from jemminger, i could already see his answer. However the links may prove useful.

Thanks guys. Been away from a pc for a few days. All that sound great, though at the moment i think i'll stick with java v1.4.2. jemminger: i'll try that code, seems like what I want, though my next question would have been to ask how to cast objects. I'm still getting my head around it all...

Hi, guess i'm still a newbie in this field really. I've been recently introduced to collections from vb, so thought i'd give them a go in java. Perhaps I got the wrong end of the stick, but is this logic possible: I have a class called Holiday, storing holiday information from a database. I...

How are you running this script, or should I say where? It would only show if form2 is not called form2. in the form heading <form ...> specify the name and id as form2: <FORM id=form2 name=form2 ... > Otherwise paste the rest of the code and we/someone may be able to help further

ps i'd rather hard code it - my client doesn't wish to be tied to one vendor as they aren't sure if they wish to stay with the server kit they use at present. I'd rather keep the options open.

I always assumed it was once per creation of that instance. Guess that makes more sense really. I guess connection pooling is my only real practical solution here. Thanks.

Managed to close my connection. my current connectionmanager class looks like: ***CODE START*** import java.sql.*; public class ConnectionManager{ private static ConnectionManager conMan; private Connection con; private ConnectionManager(){ try { // Load the Oracle Driver...

Don't know if this would help, but i've got a similar system, although it's not as high level secure. What i do is on login store the loginid in a session variable. then on every page within the system, it checks if there is one, and if not returns to the login page. it's tedious but works. i...

Sorted thanks. thanks for your help sedj, but i worked it out. Weren't any of those. I was creating the connection on creation of the instance of the mapper, so when i went to close it, it knew there was no way of creating a new connection. all i did was move this connection creation to it's...

I have a 3 tier architecture on a booking system I am developing in jsp/java/oracle. my database layer has multiple database mapper classes per table type, and a single connectionmanager class which each connects through. However, I cannot kill a connection. my middle tier (problem domain) has...