Search results for query: *

Thanks for the tips. I am new to servlets, so how do i store the array in the session object? Is a new session object created every time a servlet is invoked by each user?

Oracle BC4J webserver... A friend told me that there is just one servlet instance unless you specifically invoke another one. So how do I do that?

I am developing a servlet that will be avilable to multiple users to create their own timetable. I store users classes in an array, then display the timetable array. My only problem is that when multiple users are using it at once, I need a new instance of the servlet to be created, so the users...

That looks right. Any idea on the VBA syntax? I gave up on the idea of trying to put it all into a table because the records are of different types and are quite long (ie >300 characters), and Access likes to chop off anything in a field that is longer than 256 characters when exporting.

I have used Access to create 3 separate text files. Now I want to append all the data from the 3 files into 1 file, bit like a union query in Access. Any ideas on how to go about it? Rory

The purpose of the "1" in the left(middle, 1) is to say that you want to look at the first 1 character on the left of the variable "middle". So say instead you wanted to look at the left 2 characters of a variable containing the word "hello", you would do a...

Try this query: select first_name & left(middle_name, 1) from table having count(first_name & left(middle_name, 1))>1 Then it is just a matter of running the query when you need to do the check. Rory

Thanks. I knew it was something simple, the Format() function was what I needed.

I am trying to get a date from a text box in a form, then use it in a query. Basically in the query I want to make the condition: <[Forms]![Main]![EndDate] . This gives me incorrect results. I realise that normaly if I knew the date I could put something like: <#01/01/02# , but what is the...

I can email you the full code (550 lines). send me an email at r.j.murray@curtin.edu.au . I know that it is storing the correct value in the attribute because I tried doing a system.out.println() of the attribute, and it came out witht the right value.

I am using a servlet to process information from an online survey. Basically the servlet receives parameters from different pages. With each page it stores the parameter values as session attributes, then forwards to the next page, which in turn posts more parameter values, the servlet stores...

Actually I just tried that and I don't think it will work, unless you manage to use that method to build the sql string, then execute the sql.

You could store the name you want to call it in a config table, then access it using a dlookup. So have a config table with config id and value, eg configID Value 1 &quot;Sum of Previous amount&quot; then in the query put: Sum(qrySource.PreviousAmount) as...

Thanks Ken. My only question is, for option 1, where do you enter that code? In the source object? Rory

I have a main form which has an area for a subform. I want to display one of two possible subforms in the main form's subform area based upon the result of a function. Eg, if functionx()=false, display subform 1, otherwise display subform 2. Is this possible? Thanks in advance, Rory

What happens when you try this: If DLookup(&quot;Page_Ln&quot;, &quot;tblPhysicalEnter&quot;, &quot;Page_Ln is null&quot;) Then....

I haven't tried this, but have you tried separating the objects using &quot;;&quot;? IE, object1; object2; object3?

I'm not quite an expert yet but try me if you have any problems, hopefully I'll be able to help. r.j.murray@curtin.edu.au Rory

Sorry, I have never tried to export a database so I am no help! Good luck...

Did you do the following before you attempted to connect? Class.forName(&quot;oracle.jdbc.driver.OracleDriver&quot;); You need to tell it which jdbc driver you want to use.