BUG: simple email script not working?

BUG: simple email script not working?

Post by Jodi » Wed, 16 Dec 1998 04:00:00



hi -

i've done numerous email scripts in FM4 and i just wrote a one step script
in a new database but it refuses to compose a new message. it will switch
to eudora but it just stops at that. i've tried customizing the message,
etc. but it just won't make a new message. i've even copied a working
email script into this new database and still no go. i've also quit
everything and tried again but no luck.

this is weird. any hints?

jodin

--
...another nugget of joy from jodin at myself.com
...ICQ me at #10341457 if you have something important to say

 
 
 

BUG: simple email script not working?

Post by Pete » Wed, 30 Dec 1998 04:00:00


Hi Jodin,

Maybe Eudora (or it's MAPI functions) are corrupt. Try to reinstall
Eudora.

Peter


>hi -

>i've done numerous email scripts in FM4 and i just wrote a one step script
>in a new database but it refuses to compose a new message. it will switch
>to eudora but it just stops at that. i've tried customizing the message,
>etc. but it just won't make a new message. i've even copied a working
>email script into this new database and still no go. i've also quit
>everything and tried again but no luck.

>this is weird. any hints?

>jodin

>--
>...another nugget of joy from jodin at myself.com
>...ICQ me at #10341457 if you have something important to say


 
 
 

1. HELP - SIMPLE SUBQUERY NOT WORKING - BUG?

I am using MS SQL 2000.  I have 1 table that I am attempting to run a
query (that contains a subquery) that returns no records.  Here is an
example table:
Table1:
Key_Col(ident)   ID_Name(varchar(6))  ABC_Key(int)
------           --------              ------
1                '200000'               41
2                '200000'               43
3                '200001'               41
4                '200003'               43

I want to return the ID_Name(s) for ABC_Key 41 that do not exist with
both 41 and 43 as a ABC_Key.  I tried this query:

Select ID_Name from Table1 where (ABC_Key = 41) and ID_Name not in
(Select ID_Name from Table1 where ABC_Key = 43)

This returns nothing.  However - each independent select statement
works as expected.

I would have expected it to return '200001'.  What am I doing wrong?
I even tried aliasing the tables and prefixing the column names as
such, but no difference.  If I change the subquery to be a static list
it works, but that is not an acceptable solution.

This seems like an exteremly easy problem - am I missing something?

Thanks,

Brad Johnson

2. Event 10046

3. SQL script that works in 7.0 not working in 2000

4. Sql Server on ALPHA to INTEL

5. Simple Query works in Access but fails in ASP script

6. What is Rushmore indexing - FOXPRO?

7. SQL Mail- xp_sendmail works, but other SQL based email not

8. US-Access/FoxPro Programmer

9. email report to operator not working

10. SQL email not working

11. Simple trigger not working...?

12. simple select statement with case not working

13. Simple stored procedure not working right