Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. elpico

    My if then else logic is unwieldy

    Hmmm, I feel stupid now - Thanks for that!
  2. elpico

    My if then else logic is unwieldy

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

    form filter problem with checkbox

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

    form filter problem with checkbox

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

    Pulling blank values using varRecords

    Thanks - works perfectly!
  6. elpico

    Pulling blank values using varRecords

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

    accessing a query from a sql string

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

    problem updating table based on results from another table

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

    problem updating table based on results from another table

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

    Problem automating pscp.exe on my server

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

    trigger to update multiple schemas!

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

    trigger to update tables from other schemas

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

    assertion &quot;rv == APR_SUCESS&quot; error

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

    dmz visibility - external name vs internal server name

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

    Minimal permissions for executing a link with a password in it

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

    Setting limited permissions on a file

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

    Setting limited permissions on a file

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

    Minimal permissions for executing a link with a password in it

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

    ksh: Trying to call function from another script

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

Part and Inventory Search

Back
Top