access thread: insert into fails
Message #1 by "niraj sharma" <nsharma@y...> on Wed, 25 Jul 2001 22:31:11
|
|
When I try to insert:
vDateCreated = NOW
sSQL = "INSERT INTO tblDirLinks (lnkName, lnkCategoryID,
lnkDescription, lnkURL, lnkLastUpdate, "
sSQL = sSQL & " lnkCoolSite, lnkFeatured, lnkBold,
lnkDateAdded, lnkValidated, lnkNotes, lnkTopics, lnkSize, lnkType,
lnkVersion) VALUES ( "
sSQL = sSQL & SQLStr(sLinkName) & ", "
sSQL = sSQL & SQLVal(iCatID) & ", "
sSQL = sSQL & SQLStr(sLinkDescription) & ", "
sSQL = sSQL & SQLStr(sLinkURL) & ", "
sSQL = sSQL & SQLDate(vDateCreated) & ", "
sSQL = sSQL & SQLStr("N") & ", "
sSQL = sSQL & SQLStr("N") & ", "
sSQL = sSQL & SQLStr("N") & ", "
sSQL = sSQL & SQLDate(NOW) & ", "
sSQL = sSQL & SQLStr("Y") & ") "
sSQL = sSQL & SQLStr(sLinkNotes) & ", "
sSQL = sSQL & SQLStr(sLinkTopics) & ", "
sSQL = sSQL & SQLStr(sLinkSize) & ", "
sSQL = sSQL & SQLStr(sLinkType) & ", "
sSQL = sSQL & SQLStr(sLinkVersion) & ", "
gobjConnect.Execute(sSQL)
I am receiving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Number of query values and
destination fields are not the same.
Thank You for your help!
Message #2 by "Yehuda Rosenblum" <Yehuda@I...> on Wed, 25 Jul 2001 17:35:14 -0400
|
|
Niraj,
The last line: sSQL =3D sSQL & SQLStr(sLinkVersion) & ", "
should be: sSQL =3D sSQL & SQLStr(sLinkVersion)
That last comma is making it think there is another entry.
Yehuda
-----Original Message-----
From: niraj sharma [mailto:nsharma@y...]
Sent: Wednesday, July 25, 2001 6:31 PM
To: Access
Subject: [access] insert into fails
When I try to insert:
vDateCreated =3D NOW
sSQL =3D "INSERT INTO tblDirLinks (lnkName, lnkCategoryID,
lnkDescription, lnkURL, lnkLastUpdate, "
sSQL =3D sSQL & " lnkCoolSite, lnkFeatured, lnkBold,
lnkDateAdded, lnkValidated, lnkNotes, lnkTopics, lnkSize, lnkType,
lnkVersion) VALUES ( "
sSQL =3D sSQL & SQLStr(sLinkName) & ", "
sSQL =3D sSQL & SQLVal(iCatID) & ", "
sSQL =3D sSQL & SQLStr(sLinkDescription) & ", "
sSQL =3D sSQL & SQLStr(sLinkURL) & ", "
sSQL =3D sSQL & SQLDate(vDateCreated) & ", "
sSQL =3D sSQL & SQLStr("N") & ", "
sSQL =3D sSQL & SQLStr("N") & ", "
sSQL =3D sSQL & SQLStr("N") & ", "
sSQL =3D sSQL & SQLDate(NOW) & ", "
sSQL =3D sSQL & SQLStr("Y") & ") "
sSQL =3D sSQL & SQLStr(sLinkNotes) & ", "
sSQL =3D sSQL & SQLStr(sLinkTopics) & ", "
sSQL =3D sSQL & SQLStr(sLinkSize) & ", "
sSQL =3D sSQL & SQLStr(sLinkType) & ", "
sSQL =3D sSQL & SQLStr(sLinkVersion) & ", "
gobjConnect.Execute(sSQL)
I am receiving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Number of query values and
destination fields are not the same.
Thank You for your help!
Message #3 by "niraj sharma" <nsharma@y...> on Wed, 25 Jul 2001 22:52:25
|
|
Thank You!
> Niraj,
>
> The last line: sSQL =3D sSQL & SQLStr(sLinkVersion) & ", "
> should be: sSQL =3D sSQL & SQLStr(sLinkVersion)
>
> That last comma is making it think there is another entry.
>
> Yehuda
>
> -----Original Message-----
> From: niraj sharma [mailto:nsharma@y...]
> Sent: Wednesday, July 25, 2001 6:31 PM
> To: Access
> Subject: [access] insert into fails
>
>
> When I try to insert:
>
> vDateCreated =3D NOW
> sSQL =3D "INSERT INTO tblDirLinks (lnkName, lnkCategoryID,
>
> lnkDescription, lnkURL, lnkLastUpdate, "
> sSQL =3D sSQL & " lnkCoolSite, lnkFeatured, lnkBold,
> lnkDateAdded, lnkValidated, lnkNotes, lnkTopics, lnkSize, lnkType,
> lnkVersion) VALUES ( "
> sSQL =3D sSQL & SQLStr(sLinkName) & ", "
> sSQL =3D sSQL & SQLVal(iCatID) & ", "
> sSQL =3D sSQL & SQLStr(sLinkDescription) & ", "
> sSQL =3D sSQL & SQLStr(sLinkURL) & ", "
> sSQL =3D sSQL & SQLDate(vDateCreated) & ", "
> sSQL =3D sSQL & SQLStr("N") & ", "
> sSQL =3D sSQL & SQLStr("N") & ", "
> sSQL =3D sSQL & SQLStr("N") & ", "
> sSQL =3D sSQL & SQLDate(NOW) & ", "
> sSQL =3D sSQL & SQLStr("Y") & ") "
> sSQL =3D sSQL & SQLStr(sLinkNotes) & ", "
> sSQL =3D sSQL & SQLStr(sLinkTopics) & ", "
> sSQL =3D sSQL & SQLStr(sLinkSize) & ", "
> sSQL =3D sSQL & SQLStr(sLinkType) & ", "
> sSQL =3D sSQL & SQLStr(sLinkVersion) & ", "
> gobjConnect.Execute(sSQL)
>
>
> I am receiving the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Number of query values and
> destination fields are not the same.
>
> Thank You for your help!
>
Message #4 by "Pardee, Roy E" <roy.e.pardee@l...> on Wed, 25 Jul 2001 14:44:02 -0700
|
|
It looks like you're not closing the parens around your VALUES & you've got
a trailing comma you don't need.
-Roy
-----Original Message-----
From: niraj sharma [mailto:nsharma@y...]
Sent: Wednesday, July 25, 2001 3:30 PM
To: Access
Subject: [access] insert into fails
When I try to insert:
vDateCreated = NOW
sSQL = "INSERT INTO tblDirLinks (lnkName, lnkCategoryID,
lnkDescription, lnkURL, lnkLastUpdate, "
sSQL = sSQL & " lnkCoolSite, lnkFeatured, lnkBold,
lnkDateAdded, lnkValidated, lnkNotes, lnkTopics, lnkSize, lnkType,
lnkVersion) VALUES ( "
sSQL = sSQL & SQLStr(sLinkName) & ", "
sSQL = sSQL & SQLVal(iCatID) & ", "
sSQL = sSQL & SQLStr(sLinkDescription) & ", "
sSQL = sSQL & SQLStr(sLinkURL) & ", "
sSQL = sSQL & SQLDate(vDateCreated) & ", "
sSQL = sSQL & SQLStr("N") & ", "
sSQL = sSQL & SQLStr("N") & ", "
sSQL = sSQL & SQLStr("N") & ", "
sSQL = sSQL & SQLDate(NOW) & ", "
sSQL = sSQL & SQLStr("Y") & ") "
sSQL = sSQL & SQLStr(sLinkNotes) & ", "
sSQL = sSQL & SQLStr(sLinkTopics) & ", "
sSQL = sSQL & SQLStr(sLinkSize) & ", "
sSQL = sSQL & SQLStr(sLinkType) & ", "
sSQL = sSQL & SQLStr(sLinkVersion) & ", "
gobjConnect.Execute(sSQL)
I am receiving the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Number of query values and
destination fields are not the same.
Thank You for your help!
|
View Cart
