Search results for query: *

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...

I was stuck on this for ages - most tutorials don't make any sense to me. try this one: http://www.stardeveloper.com/articles/display.html?article=2001101101&page=1 make sure you change the smtp to be one you have access to. Should that be a problem you can download personal smtp servers so...

my concern is that you are using a union to join two different fields. I believe that they have to have the same name. perhaps if you try this: &quot;SELECT field1 as XX FROM table1 UNION SELECT field2 as XX FROM table2&quot; Hope it helps.

use the copy command to copy to a new location, then use the kill command to remove the original. Hope this helps

put the reference file required on the missing pc's? best i can think of. find the reference which it comes from, locate the .dll file, paste it in the same location on the pc's that can't run it, and add them in as references. Hope this helps.

are you just running the one macro, or are you meaning to amend the macro for each run? if the former, simply have a sub on a button click that does as follows: sub #button name#_click if #comboboxname#.value = &quot;2003&quot; then '(example year only) docmd.runmacro &quot;macro1&quot...