missing?
Shawn Regan
------_=_NextPart_001_01BFB542.15933410
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
OT: SQL! i'm losing it
I have checked and checked this but I cannot see =
anything wrong with this co
Your USERID field is a number, but you use the single quotesis it a
number field or a text field in the database?
'' = text field
-d
Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Gro
Shawn,
It may be parsing the field Group and confusing it with GROUP BY, a reserved
phrase. I'd try changing the name of the field.
>
> I have checked and checked this but I cannot see anything wrong with this
> code:
>
>
> insert into users
> (user_id,Group,firstname,lastname,Title,email,Pass
Shawn,
Group is an ODBC Reserved Word. Change it in the table to a different name.
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 3:57 PM
To: '[EMAIL PROTECTED]'
Subject: OT: SQL! i'm losing it
This message is in MIME for
Will your userid always be numeric?
if so..take off the single quotes.
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 3:57 PM
To: '[EMAIL PROTECTED]'
Subject: OT: SQL! i'm losing it
This message is in MIME format. Since y
lues
(2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)"
Anyone see what I am missing?
Shawn Regan
--_=_NextPart_001_01BFB542.15933410
Content-Type: text/html;
charset="iso-8859-1
>
insert into users
(user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID)
values
(#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#trim(a
ttributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.email)#',
'#trim(attributes.Password)#','#trim(attribut
Howie
- Original Message -
From: Shawn Regan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 03, 2000 4:56 PM
Subject: OT: SQL! i'm losing it
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of thi
es
>
(2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)"
>
> Anyone see what I am missing?
>
> Shawn Regan
>
> --_=_NextPart_001_01BFB542.15933410
> Content-Type: text/h
Shawn
What is the design of the DB table users?
Duane
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 4:57 PM
To: '[EMAIL PROTECTED]'
Subject: OT: SQL! i'm losing it
This message is in MIME format. Since your mail
a number i have it set
to text.
Shawn
-Original Message-
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 2:10 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL! i'm losing it
Your USERID field is a number, but you use the single quotesis it a
number
works fine. I knew it
was something easy but i couldn't see it thats why I love this list.
Shawn Regan
-Original Message-
From: WBB [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 2:10 PM
To: [EMAIL PROTECTED]
Subject: Re: SQL! i'm losing it
Shawn,
It may be parsing
12 matches
Mail list logo