On 10/26/21 1:17 PM, Rich Shepard wrote:
On Tue, 26 Oct 2021, Rob Sargent wrote:
Aren’t lines 3 and 6 duplicates?
Ah, shoot! The second was supposed to be 16 and that's how I saw it when I
scanned the list.
The second thing I deeply learned about computer programming: it's almost
certainly
On Tue, 26 Oct 2021, Rob Sargent wrote:
Aren’t lines 3 and 6 duplicates?
Ah, shoot! The second was supposed to be 16 and that's how I saw it when I
scanned the list.
Thanks!
Rich
On Tue, 26 Oct 2021, Rob Sargent wrote:
Are you doing a batch of updates,
Yes,
... and including/generating a duplicate in there?
No.
Rich
> On Oct 26, 2021, at 11:06 AM, Rich Shepard wrote:
>
> On Tue, 26 Oct 2021, Ron wrote:
>
>> Show us the actual UPDATE statement.
>
> Ron,
>
> insert into contacts
> (person_nbr,contact_date,contact_type,notes,next_contact) values
> (1,'2021-10-26','Email','message 3','2012-11-16'),
> (4,'
> On Oct 26, 2021, at 11:05 AM, Rich Shepard wrote:
>
> On Tue, 26 Oct 2021, Rob Sargent wrote:
>
>> What do you get when you select * where person_nbr = 6 and contact_date =
>> ‘2021-10-26’ and contact_type = ‘Email’ from activities; ?
>
> Rob,
>
> 'Email';
> person_nbr | contact_date | c
On Tue, 26 Oct 2021, Ron wrote:
Show us the actual UPDATE statement.
Ron,
insert into contacts (person_nbr,contact_date,contact_type,notes,next_contact)
values
(1,'2021-10-26','Email','message 3','2012-11-16'),
(4,'2021-10-26','Email','message 3','2012-11-16'),
(6,'2021-10-26','Email','messa
On Tue, 26 Oct 2021, Rob Sargent wrote:
What do you get when you select * where person_nbr = 6 and contact_date =
‘2021-10-26’ and contact_type = ‘Email’ from activities; ?
Rob,
person_nbr | contact_date | contact_type | notes | next_contact
+--+--+--
> On Oct 26, 2021, at 10:07 AM, Rob Sargent wrote:
>
>
>
>>
> What do you get when you select * where person_nbr = 6 and contact_date =
> ‘2021-10-26’ and contact_type = ‘Email’ from activities; ?
>
>
>
Whoa. Not sure why I put the “from” last but I’m sure you know it goes before
the
On 10/26/21 11:58 AM, Rich Shepard wrote:
In a database table I have these rows:
# select * from contacts where person_nbr=6;
person_nbr | contact_date | contact_type
| not
es | next_conta
> On Oct 26, 2021, at 9:58 AM, Rich Shepard wrote:
>
> In a database table I have these rows:
> # select * from contacts where person_nbr=6;
> person_nbr | contact_date | contact_type |
> not
> es
In a database table I have these rows:
# select * from contacts where person_nbr=6;
person_nbr | contact_date | contact_type |
not
es | next_contact
+--+---
11 matches
Mail list logo
