SQL insert into statement

Article View: borland.public.interbase.sql

Article #829

Back to borland.public.interbase.sql Previous Next

#829

From: David
Date: Tue, 15 May 2007 16:48

7 lines
1342 bytes

Should this work or do I have something wrong:

insert into ORDER_IP ("IP") select DISTINCT SUBSTRING("IPAddress" from 1 for 
15) from "orders" where "IPAddress" is not NULL

It seems the SubString makes the Distinct not work and without the substring 
the target IP (20) field is smaller than IPAddress (20) field.

Technical Details

Message-ID: <Jvl2i.162733$nh4.13092@newsfe20.lga>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!69.28.186.77.MISMATCH!hwmnpeer03.lga!hwmnpeer01.lga!news.highwinds-media.com!hw-filter.lga!newsfe20.lga.POSTED!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,279f5b7c9aace22c,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!69.28.186.77.MISMATCH!hwmnpeer03.lga!hwmnpeer01.lga!news.highwinds-media.com!hw-filter.lga!newsfe20.lga.POSTED!53ab2750!not-for-mail
From: "David" <nonya@nowhere.com>
Newsgroups: borland.public.interbase.sql
Subject: SQL insert into statement
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
Message-ID: <Jvl2i.162733$nh4.13092@newsfe20.lga>
Date: Tue, 15 May 2007 09:48:40 -0700
NNTP-Posting-Host: 72.193.136.157
X-Complaints-To: admin@cox.net
X-Trace: newsfe20.lga 1179247721 72.193.136.157 (Tue, 15 May 2007 09:48:41 MST)
NNTP-Posting-Date: Tue, 15 May 2007 09:48:41 MST
Organization: Cox