Error in cust_main.cgi

[Edward Shabotinsky]

Hi, all
Does any one had error like this before?
Looks like bad syntax.
[Thu Jan 31 19:16:26 2002] null: DBD::mysql::st execute failed: You have an
error in your SQL syntax near 'SELECT
 count(*) FROM pkg_svc
[Thu Jan 31 19:16:26 2002] null:           WHERE pkg_svc.pkgpart =
cust_pkg.pkgpart
[Thu Jan 31 19:16:26 2002] null: ' at line 3 at cust_pkg.cgi line 85.
[Thu Jan 31 19:16:26 2002] [error] [asp] [248] [error] Error executing
"SELECT COUNT(*) FROM cust_pkg  <-->     W
HERE 0 < <-->       ( SELECT count(*) FROM pkg_svc <-->           WHERE
pkg_svc.pkgpart = cust_pkg.pkgpart <-->
           AND pkg_svc.quantity > ( SELECT count(*) FROM cust_svc <-->
WHE
RE cust_svc.pkgnum = cust_pkg.pkgnum <-->
AND cust_svc.svcpart = pkg_svc
.svcpart <-->                                    ) <-->       ) <-->   ":
You have an error in your SQL syntax ne
ar 'SELECT count(*) FROM pkg_svc <-->           WHERE pkg_svc.pkgpart =
cust_pkg.pkgpart <--> ' at line 3 at cust
_pkg.cgi line 85. <--> , /usr/local/lib/perl5/site_perl/5.005/Apache/ASP.pm
line 1545

Thanks.
Edward Shabotinsky
System Engineer
BritesiteINet Inc.
---------------------------------
www.bsinet.net
lanshark at bsinet.net