RE: Need help with a SQL statement

2002-09-27 Thread kpeterson
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 >> >> >> >> >> >>"

RE: Need help with a SQL statement

2002-09-27 Thread Mitko Gerensky-Greene
gt;>"Tony Weeg" > >> > >>net> cc: > >>

RE: OT: Need help with a SQL statement

2002-09-27 Thread Tony Weeg
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

RE: Need help with a SQL statement

2002-09-27 Thread Mitko Gerensky-Greene
> > Subject: RE: Need help with a SQL >statement >09/27/2002

RE: Need help with a SQL statement

2002-09-27 Thread Tony Weeg
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

RE: Need help with a SQL statement

2002-09-27 Thread Mitko Gerensky-Greene
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

RE: Need help with a SQL statement

2002-09-27 Thread kpeterson
cc: Subject: RE: Need help with a SQL statement 09/27/2002

Re: Need help with a SQL statement

2002-09-27 Thread Mitko Gerensky-Greene
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

Re: OT: Need help with a SQL statement

2002-09-27 Thread S . Isaac Dealey
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

RE: Need help with a SQL statement

2002-09-27 Thread Tony Weeg
, 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

Re: Need help with a SQL statement

2002-09-27 Thread Bryan Stevenson
"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

OT: Need help with a SQL statement

2002-09-27 Thread Mitko Gerensky-Greene
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

RE: Help with a SQL statement

2001-01-04 Thread bflynn
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

Re: Help with a SQL statement

2001-01-03 Thread Cami Lawson
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

Re: Help with a SQL statement

2001-01-03 Thread Deanna L. Schneider
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

RE: Help with a SQL statement

2001-01-03 Thread Andres
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

RE: Help with a SQL statement

2001-01-02 Thread Andres
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? -

Re: Help with a SQL statement

2001-01-02 Thread Greg Wolfinger
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

Help with a SQL statement

2001-01-02 Thread Andres
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