oft Docs
>>[INTO] Is an optional keyword that can be used between and the target
>>table.
>>
>>Kore Peterson
>>Database Development Specialist
>>SEH - Minneapolis
>>612.758.6739
>>
>>
>>
>>
>>
>>"
gt;>"Tony Weeg"
>
>>
>
>>net> cc:
>
>>
ailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 3:44 PM
To: CF-Talk
Subject: Re: OT: Need help with a SQL statement
Make sure you didn't lose the identity definition on your primary key
column
-- if so, the default value for that column would be null and then the
2nd
entry with n
>
> Subject: RE: Need help with a SQL
>statement
>09/27/2002
lk
Subject: RE: Need help with a SQL statement
What do you mean by NULL value, or rather where? I am inserting NULL to
be the value for approval_date_time.
-- Original Message --
From: "Tony Weeg" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECT
erensky-Greene [mailto:[EMAIL PROTECTED]]
>Sent: Friday, September 27, 2002 3:33 PM
>To: CF-Talk
>Subject: OT: Need help with a SQL statement
>
>
>Hello,
>
>Could anybody help me with a simple SQL statement?
>
>I am trying to insert a new row into a SQL Server 7.0 d
cc:
Subject: RE: Need help with a SQL
statement
09/27/2002
ms Group Inc.
>t. 250.920.8830
>e. [EMAIL PROTECTED]
>
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisl
Make sure you didn't lose the identity definition on your primary key column
-- if so, the default value for that column would be null and then the 2nd
entry with null in the primary key column would cause the conflict.
> Hello,
> Could anybody help me with a simple SQL statement?
> I am trying
, September 27, 2002 3:33 PM
To: CF-Talk
Subject: OT: Need help with a SQL statement
Hello,
Could anybody help me with a simple SQL statement?
I am trying to insert a new row into a SQL Server 7.0 database using the
Enterprise manager.
The statement is:
INSERT p_pha_plan
(state_code, pha_code
"CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 12:32 PM
Subject: OT: Need help with a SQL statement
> Hello,
>
> Could anybody help me with a simple SQL statement?
>
> I am trying to insert a new row into a SQL Server 7.0 database using the
Hello,
Could anybody help me with a simple SQL statement?
I am trying to insert a new row into a SQL Server 7.0 database using the Enterprise
manager.
The statement is:
INSERT p_pha_plan
(state_code, pha_code, fiscal_year, version_number,
status_code, pdf_file_name, submission_date_t
ging logdate to logid in the WHERE clause.
Brian
-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 4:54 PM
To: CF-Talk
Subject: RE: Help with a SQL statement
SELECT
teaserusers.userid,
teaseruser
teaserusers.userid = log_userstatus.userid
cami
- Original Message -
From: "Andres" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 03, 2001 8:44 AM
Subject: RE: Help with a SQL statement
> Heather,
> I will try this, and con
I haven't seen anyone answer this, so here goes - try adding the group by
statement. Also, indicate what you really want from the log_userstatus
table. If all you want is the date, just select that (and add it to the
group by clause).
SELECT
teaserusers.userid,
teaserusers.nickname,
teaserusers.f
Heather,
I will try this, and continue building upon it.
thanks for your help!
andres
-Original Message-
From: Heather Haindel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 7:35 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with a SQL statement
I am trying to figure this
ho ARE NOT listed in the
"log_userstatus" table.
Am i way off?
thanx!
andres
-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 4:54 PM
To: CF-Talk
Subject: Re: Help with a SQL statement
Can we see your current SQL statement?
-
Can we see your current SQL statement?
--Greg
- Original Message -
From: "Andres" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 4:42 PM
Subject: Help with a SQL statement
> I need some help with a sql stateme
I need some help with a sql statement:
I have two tables:
1 ---> *
teaserusers log_userstatus
--- --
userid (varchar)logid (varchar)
nickname (text) userid (varchar)
firstname (text)fieldchanged (varchar)
email (t
19 matches
Mail list logo