Search results for query: *

Hi, I've been worrying at this one for a while without result. The person responsible for making it work resorted to a cursor but I feel that it should be possible to develop a set-based query. In essence: there are records recording periods worked, each with a start and end date. There may...

Hi, The web host I am using (not my choice) controls users and script execution options; in particular, the whole script fails if I try to drop a non-existent object (instead of just warning), and I cannot grant permissions on objects that I have created, they are just assumed. I could rewrite...

Hi, I have produced a masking process to anonymise personal data in a large database, for testing etc. The approach I have taken is a many-to-one mapping from source to masked values. I now want to apply a more realistic distribution of masked values, so that some of them appear only a few...

Hi, I know this has been asked and answered many times, but I wonder whether anything has changed in the last few years? We have locked-down PCs with no user permission to install anything at all, but MS Access is available. I need to create a front-end that connects to an Oracle database and...

Hi, I want to specify a DLL at run time, then load it and call its methods. The DLL will have been built as a VB6 ActiveX DLL (history). I was planning to use the Platform Invoke service but the DLLImport("x.dll") directive seems to need the DLL to be known at compile time. All the DLLs will...

Hi, Sorry if this is a trivial one - it seems a bit different from the FAQ on the subject. I want to call a VB6 DLL from a .net app. The .net part all seems OK, but it complains that it cannot find the entrypoint asked for. I have tried calling it from a VB6 app and get the same result, so...

Hi, I am trying to develop a data creation script using variables whose values aren't known until the script runs. In SQL Server the syntax would be something like this: declare @a integer; select @a = id from ref where code = 'A'; insert into tbl(col, ref) values ('fred', @a); go I know...

Hi, My stored procedure attempts to insert from a query, along these lines: insert into a (a, b, c) select 'a', b, c from b order by b; The insert runs correctly in a MySQL window but within the procedure it fails and I cannot get at the errorno and message (actually, that is probably...

Hi, I'm not sure whether this is the correct place to post this, but if not I'd be grateful for a pointer to a more appropriate forum. We have a web service client app which I developed in Java, running under WinXP. The web service is on the other side of a firewall (on the Internet). All...

Hi, I've moved this to here from the SQL Server forum. I'm submitting a complex series of updates as a T-SQL block from a PHP script. The return does not show an error but it also does not return a row as expected and has not updated the database. If I submit a simpler block it works as...

Hi, I'm submitting a complex series of updates as a T-SQL block from a PHP script. The return does not show an error but it also does not return a row as expected and has not updated the database. If I submit a simpler block it works as expected. If I catch the complex block text and paste...

Hi, I'm trying to use javamail to send an email to a local address from a logged-on PC running WinXP, but with no success. Do I need to connect to the local mail server, or can I use the MS Exchange object - which is already logged on to the mail server - perhaps with a Class.forName(xxx) to...

Hi, Sorry to post a trivial problem, but I can't work out the answer (well, it is Friday). I'm planning to develop a web service client (Win XP for both development and running) and have downloaded NetBeans 5.5.1 as it appears to do a fair bit of the work for you. [Is this a good choice?] On...

Hi, I've written a function that returns a user-defined type (a PL/SQL RECORD structure). It compiles OK (within a package that defines the type) and appears to work correctly. What syntax do I need to use the function in an UPDATE statement (again, within the package)? I'm trying this form...

Hi, I've developed a ksh script that does various database (Oracle) queries and updates, and runs ftp, zip and a few other utilities. It runs exactly as expected from the ksh command line when logged in as the owner. It also runs as expected (exactly as for the owner) from the ksh command...

Hi, Is there any way to alter the slashed-0 rendered by imagestring in the bundled GD library to a non-slashed version, without resorting to TrueType or Postscript fonts? If not, what font extension would be my best choice to avoid portability issues between PHP4 and 5 and hosting on unix and...

I'm encountering strange, but reproducible behaviour with a job comprising a chain with a number of steps. There are 5 steps in the chain, and they run sequentially. The last step is also intended to tidy up if there's a problem with an earlier step. The rules look like this: no condition...

Hi, Has anyone made this work? I'm struggling to get the external program to run. If I specify the entire pathname it manages to find the command, but if it tries to do anything useful it falls over with insufficient unix permissions to write anything anywhere (apparently). The only command...

Hi, I hope this is a suitable forum to post this one. Does the XP FileSystemObject (or any other object) support extracting the files from a compressed folder (which appears just to be a zip file) into uncompressed form? I can't see an obvious method in the object browser and I can't find a...

I need to run an SQL ALTER USER command (no recordset returned) on an Oracle 9i database, from an Access 2000 application. All the existing tables are ODBC-linked tabledefs using DAO and this works. I thought that the way to go would be to create an ODBC workspace, connect it to the Oracle db...