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!

  • Congratulations strongm 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. LGTOserv

    Running KSH script from CRON

    Sorry.. found the answer on another thread. :| solution: in crontab use * * * * * su - root -c /path/to/script works like a champ
  2. LGTOserv

    Running KSH script from CRON

    Hi All; I have an issue trying to get a script written in the KSH. The script does not run from the cron entry: 00 10 * * * /bin/ksh /test.ksh I think their is something to do with the environment... but most posts say something different. Can anyone help? I need to use KSH seeing that for...
  3. LGTOserv

    variable assignment and special chars problem

    i see, i am trying to run a command and pass it some values from an input file. The command takes these input values from the file and uses them as parameters. for instance input/parameter file: value1,Jim:(123)123-1234 (this is in an input file of parameters input is read into a var called...
  4. LGTOserv

    variable assignment and special chars problem

    It already has " " around it though, can i do this? eg: "location="${USERINFO}"" thanks.
  5. LGTOserv

    variable assignment and special chars problem

    Thanks for the quick response. Seems when i take the quotes off so it looks like this: Script: "location=${USERINFO}" I get a parse error: Resource parse error: unterminated value list name:phone ^ any suggestions? thanks
  6. LGTOserv

    variable assignment and special chars problem

    Hi All; I am having an issue figuring out how to input a value that has special chars and using that var as follows: input value(no quotes): name:phone Script: " location='${USERINFO}' " USERINFO doesnt seem to be formatted correctly due to the ":" in the input value. any ideas? thanks...
  7. LGTOserv

    cancelling database updates? "cancelupdate"?

    Hi All; new to vb2005... i want to cancel an update to a database and discard changes. Used to initiate the "CancelUpdate" method in VB6 but it doesn't work in vb2005. What is the equivalent in 2005 ? only thing i could find was dispose() thanks in advance.
  8. LGTOserv

    Exchange ISP port sending issue

    Sorry bro, that was a fictional domain i created... it just so happened to be real :) anways, still trying to figure this out. i guess the first question is do i require an SMTP CONNECTOR to do this? or is the default SMTP server settings enough for this?
  9. LGTOserv

    Exchange ISP port sending issue

    No, port 1025 is allowed through the firewall... interestingly enough, i get different messages in different scenarios such as: did not reach the following recipient(s): joret@tors.com on Thu, 24 Aug 2006 03:52:43 -0400 The e-mail account does not exist at the organization this message was...
  10. LGTOserv

    Exchange ISP port sending issue

    Hello all; I am having an issue getting my exchange to send email through my ISP. i have searched everywhere for a solution that seems to not that hard.. except or me. I have a domain registered say ETL.com My mx records point to mail.etl.com. My ISP stated that i must use Exchange and...
  11. LGTOserv

    relaying? forwarding?

    That is exactly what i need it to do... i cant seem to get the SMTP connector to forward mail out beyond my ISP for some reason. I did call them and they stated that i need to send from my mail client directly to the rogers SMTP server when sending but receive from my exchange server. This is...
  12. LGTOserv

    relaying? forwarding?

    any takers?
  13. LGTOserv

    relaying? forwarding?

    Hi All; hoping someone can help me with my dilemna. I have an Exchange2k3 server running with my own domain name.. i want to use my ISP to forward the email out of the exchange server... can this be done? if so where do i start looking? i have tried relaying, different smtp ports (26 and...
  14. LGTOserv

    Cluster Disk Configuration

    Hi All; I was hoping someone could offer some assistance on the Disk configuration of a 3 node cluster with 2 EVS's. Each EVS will host 1 storage group with multiple databases on each. How would i setup the disk? would each EVS have its own Database drive? etc.. thanks in advance
  15. LGTOserv

    group by problem

    sounds interesting.. but simply PHV's solution works just too perfect to alter... the query was generated by IBM's Clearquest software from *many* tables.. so i would assume that it is already the most efficient way to draw the data. The small alteration is all that i required from PHV...
  16. LGTOserv

    group by problem

    EXCELLENT..!!! Thank you very much.. i would never have done that as everytime i dont have all the fields from the select in the group by clause i get an error stating that.... hmm now i'm really confused.. thanks again.. worked great
  17. LGTOserv

    group by problem

    Hi All; I have an SQL Qeury that Groups a certain way and then takes the MAX() of a date and displays unique records.. this appears to work fine in one aspect. When i added another field from another table though, it no longer takes the oldest date and displays unique records but displays all...
  18. LGTOserv

    SQL Max() function to Oracle?

    Hi all; I previously posted an question relating to an MS SQL server query where i needed the Max() of a timestamp field. This was solved by one of the members here. I now have another db which is oracle that i need the same query to work on. For some reason a copy and paste of the query...
  19. LGTOserv

    SQL Max() function?

    Ahh yes.. everything worked with that.. thanks very much everyone for responding.. your all very helpfull final solution: select distinct T1.dbid, T1.id, T2.login_name, T3.callid, T4.login_name, T3.companyid, T1.headline, T1.severity, T1.priority, T1.submit_date, max(T5.action_timestamp) from...
  20. LGTOserv

    SQL Max() function?

    Wow, thanks for the swift reply; i tried this and get another error: Column 'T1.dbid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause any ideas? thanks again..!!!

Part and Inventory Search

Back
Top