Search results for query: *

Hmmm, I feel stupid now - Thanks for that!

Hi all, I haven't been able to find out how to improve this, but basically I've got my if statement, of which there are over 100 types, but I want to access a condition for everything but 2 or 3 things... ie if queueid <> 57 or queueid <> 83 or queueid <> 84 then do stuff else do other stuff...

Thanks - I just figured it out too - It helps to read the help files a bit - To be honest the answer is nearly always there - The hard part is finding it! Cheers, e.

Hi all, I have a continuous form, but I am having problems applying filters to it - I have a checkbox in the header of the form, which, when I tick it I want only values that match a condition to be displayed - I've tried the applyfilter command without any luck... DoCmd.ApplyFilter...

Thanks - works perfectly!

Hi all, Some of the data in my db table can be blank, but when that is the case I am having problems loading them in as values using the varRecords option. varRecords = rst.getRows(rst.RecordCount) For intJ = 0 to UBound(varRecords, 2) site = varRecords(0, intj) env = varRecords(1, intj) next...

I've got this piece of sql SELECT [My Query].* INTO ConfigFileAllSites FROM [My Query]; that runs this query SELECT [site].[sitename], configfile.*, [site].[envid] FROM site, configfile ORDER BY [site].[sitename], [ConfigFile].[Module], [ConfigFile].[ConfigFileName]; - which runs fine from...

Nice one - works a treat - was silly of me to try and build a relationship when I already have it in the JOIN! Thanks, e.

I'm struggling with this piece of sql - Basically I want to update a column called output in table A (fileid, output) based on what is set to true on a similar column in Table b.(fileid, outname, sitename) I've tried to do it with joins but no luck - any ideas on where I should be going with...

Hi all, I've set up a couple of scripts to update various password files on my windows 2000 server. These files are updated using new files from my unix box, and I've been trying to use secure putty (pscp.exe) to automate the transfer. The problem I've been having is that my script is supposed...

Greetings all, I'm trying to create a trigger to update a seperate table from multiple schemas. The trigger will loaded into my schema called 'global'. the problem I'm getting in my script is that I haven't been able to pass in the schema name of the table I want to update - Isn't this...

Greetings all, I'm trying to create a trigger to update a seperate table from multiple schemas. The trigger will loaded into my schema called 'global'. the problem I'm getting in my script is that I haven't been able to pass in the schema name of the table I want to update - Isn't this...

Hi all, I've two web servers, both with Apache 2.0.43, Mod_jk2.so for connecting with tomcat 4.1.24, and configured for SSL. It starts up fine on one web server, but on the other one, with exactly the same settings, returns the following error when I run apachectl sslstart.... [Tue Aug 05...

i have a problem connecting to a server using jproxy through apache and modjk/tomcat apache serves pages fine on port 443, when I run apachectl sslstart, and i can connect to the tomcat servlets examples page, so i know there is connectivity there. the problem appears when the machine is place...

Thanks for that - If you can find the link, then please let me know! Cheers, elpico.

Hi, I've been thinking about that also, but the maintenance of this will be another overhead - ie there will be at least 100 shortcuts, all pointing to different database schemas, and if I create a batch file for each one, the risk of exposure becomes greater ---- Do you know whether you can...

Hi all, This problem's really bugging me - I've created a Office 2k style shortcut for running a program on windows 2000 that automatically logs in to a database, with the information passed in the shortcut itself. The shortcut looks similar to the following - &quot;C:\Program...

Hi all, This problem's really bugging me - I've created a shortcut to running a program on windows 2000that autpmatically logs in to a database, with the information passed in the shortcut itself. The shortcut looks similar to the following - &quot;C:\Program...

Hi all, I'm getting problems accessing functions in ksh from other ksh files --- is there a way to do this? And does anyone have any suggestions to pass parameters from one script to another that has functions in it? Basically I'm trying to avoid having tons of the same functions in every...