Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

24 Apr, 2024: Testing a new version of the Overboard here. If you have an issue post about it to rocksolid.nodes.help (I know. Everyone on Usenet has issues)

devel / comp.databases.ms-access / SQL

SubjectAuthor
* SQLRay Pearson
`* Re: SQLRon Weiner
 `- Re: SQLRay Pearson

1
SQL

<dcfef93c-c0b5-4715-9ea9-11044073ec2fn@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=439&group=comp.databases.ms-access#439

  copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:ac8:58cc:: with SMTP id u12mr14341711qta.302.1621641554162;
Fri, 21 May 2021 16:59:14 -0700 (PDT)
X-Received: by 2002:a25:dfc5:: with SMTP id w188mr18725451ybg.465.1621641553949;
Fri, 21 May 2021 16:59:13 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Fri, 21 May 2021 16:59:13 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=103.96.86.31; posting-account=k3rk_AoAAAAuxfxRbypX36Qda6i2cQ1y
NNTP-Posting-Host: 103.96.86.31
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <dcfef93c-c0b5-4715-9ea9-11044073ec2fn@googlegroups.com>
Subject: SQL
From: rwpearso...@gmail.com (Ray Pearson)
Injection-Date: Fri, 21 May 2021 23:59:14 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Ray Pearson - Fri, 21 May 2021 23:59 UTC

I have used the sql statement in Access 97 but now I am using 2016 and I keep getting the old "not enough parameters". I have check everything and all seems well. can anyone throw any light on the problem. I'm new to SQL

TIA - Ray

strSql = "SELECT FarNorth.JPID, FarNorth.FirstName, FarNorth.Surname, FarNorth.Email, FarNorth.Status, Sub2.SubID, Sub2.Year, Sub2.AmountPaid" & _
"FROM FarNorth INNER JOIN Sub2 ON FarNorth.JPID = Sub2.SubID " & _
"WHERE (((FarNorth.Status)='Active') AND ((Sub2.Year)=2022) AND ((Sub2.AmountPaid) Is Null) AND ((Len([FarNorth].[Email]))>0));"

Re: SQL

<s89n1j$oud$1@dont-email.me>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=440&group=comp.databases.ms-access#440

  copy link   Newsgroups: comp.databases.ms-access
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rw...@domain.com (Ron Weiner)
Newsgroups: comp.databases.ms-access
Subject: Re: SQL
Date: Fri, 21 May 2021 21:33:37 -0400
Organization: WorksRite
Lines: 26
Message-ID: <s89n1j$oud$1@dont-email.me>
References: <dcfef93c-c0b5-4715-9ea9-11044073ec2fn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 22 May 2021 01:33:39 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="cec00aba01519b08251a0b692e65d72f";
logging-data="25549"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18gYxRDypW1y/yUfMCIzPem"
Cancel-Lock: sha1:LmJCNO4D0N8/U8KupcvdZIzezx8=
X-Antivirus-Status: Clean
X-Newsreader: MesNews/1.08.06.00-gb
X-Antivirus: AVG (VPS 210521-12, 05/21/2021), Outbound message
X-ICQ: 1701145376
 by: Ron Weiner - Sat, 22 May 2021 01:33 UTC

Ray Pearson presented the following explanation :
> I have used the sql statement in Access 97 but now I am using 2016 and I keep
> getting the old "not enough parameters". I have check everything and all
> seems well. can anyone throw any light on the problem. I'm new to SQL
>
> TIA - Ray
>
> strSql = "SELECT FarNorth.JPID, FarNorth.FirstName, FarNorth.Surname,
> FarNorth.Email, FarNorth.Status, Sub2.SubID, Sub2.Year, Sub2.AmountPaid" & _
> "FROM FarNorth INNER JOIN Sub2 ON FarNorth.JPID = Sub2.SubID " & _
> "WHERE (((FarNorth.Status)='Active') AND ((Sub2.Year)=2022) AND
> ((Sub2.AmountPaid) Is Null) AND ((Len([FarNorth].[Email]))>0));"

I do not see anything obviously wrong with the Sql you have listed, but
we cannot see what columns are in the tables FarNorth and Sub2.
Presumbly :
FarNotrh.Status is a Text type
Sub2.Year is a number
Sub2AmountPaid does not have a Default Value and
FarNorth.Email is also a text type.

I'd reccomend you taking the Sql and Paste it into the Sql view of a
new query, and see if Access gives you a hint as to where the problem
might be.

Ron W

Re: SQL

<a43501d1-f1c9-44c0-a370-1d3ca1992436n@googlegroups.com>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=441&group=comp.databases.ms-access#441

  copy link   Newsgroups: comp.databases.ms-access
X-Received: by 2002:a05:620a:11ba:: with SMTP id c26mr10151691qkk.497.1622330776879;
Sat, 29 May 2021 16:26:16 -0700 (PDT)
X-Received: by 2002:a5b:392:: with SMTP id k18mr22676531ybp.180.1622330776685;
Sat, 29 May 2021 16:26:16 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Sat, 29 May 2021 16:26:16 -0700 (PDT)
In-Reply-To: <s89n1j$oud$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=103.96.87.177; posting-account=k3rk_AoAAAAuxfxRbypX36Qda6i2cQ1y
NNTP-Posting-Host: 103.96.87.177
References: <dcfef93c-c0b5-4715-9ea9-11044073ec2fn@googlegroups.com> <s89n1j$oud$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a43501d1-f1c9-44c0-a370-1d3ca1992436n@googlegroups.com>
Subject: Re: SQL
From: rwpearso...@gmail.com (Ray Pearson)
Injection-Date: Sat, 29 May 2021 23:26:16 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Ray Pearson - Sat, 29 May 2021 23:26 UTC

On Saturday, May 22, 2021 at 1:33:44 PM UTC+12, Ron Weiner wrote:
> Ray Pearson presented the following explanation :
> > I have used the sql statement in Access 97 but now I am using 2016 and I keep
> > getting the old "not enough parameters". I have check everything and all
> > seems well. can anyone throw any light on the problem. I'm new to SQL
> >
> > TIA - Ray
> >
> > strSql = "SELECT FarNorth.JPID, FarNorth.FirstName, FarNorth.Surname,
> > FarNorth.Email, FarNorth.Status, Sub2.SubID, Sub2.Year, Sub2.AmountPaid" & _
> > "FROM FarNorth INNER JOIN Sub2 ON FarNorth.JPID = Sub2.SubID " & _
> > "WHERE (((FarNorth.Status)='Active') AND ((Sub2.Year)=2022) AND
> > ((Sub2.AmountPaid) Is Null) AND ((Len([FarNorth].[Email]))>0));"
> I do not see anything obviously wrong with the Sql you have listed, but
> we cannot see what columns are in the tables FarNorth and Sub2.
> Presumbly :
> FarNotrh.Status is a Text type
> Sub2.Year is a number
> Sub2AmountPaid does not have a Default Value and
> FarNorth.Email is also a text type.
>
> I'd reccomend you taking the Sql and Paste it into the Sql view of a
> new query, and see if Access gives you a hint as to where the problem
> might be.
>
> Ron W
Thank you Ron.....I followed-up on your advice to enter the sql in to a query and presto the error was staring me in the face. Thanks again - Ray

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor