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...
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...
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
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...
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.
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?
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...
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...
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...
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...
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
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...
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
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...
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...
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...
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..!!!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.