p2p.wrox.com: Archives - asp

asp_databases thread: Update date - syntax error

Message #1 by kwitcher@s... on Thu, 29 Nov 2001 21:35:34

I cannot get rid of a syntax error in my update script:



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request

("sFname")&"', StudID='"&Request("sIDnum")&"', Account='"&Request("sAcct")

&"', Amount="&Request("sAmnt")&", Date=#"&Date()&"#, Clerk='"&Session

("clerk")&"' where ID = "&Request("sItem")



If I remove the Date, it works as in script below:



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request

("sFname")&"', StudID='"&Request("sIDnum")&"', Account='"&Request("sAcct")

&"', Amount="&Request("sAmnt")&", Clerk='"&Session("clerk")&"' where ID 

= "&Request("sItem")



I cannot figure this one out.  Please help.



Ken W.

Message #2 by David Cameron <dcameron@i...> on Fri, 30 Nov 2001 09:38:48 +1100

This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C17926.9CE56222

Content-Type: text/plain



Use response.write to dump the generated SQL string to the screen. Post that

and the error message to the screen.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: kwitcher@s... [mailto:kwitcher@s...]

Sent: Friday, 30 November 2001 7:36 AM

To: ASP Databases

Subject: [asp_databases] Update date - syntax error





I cannot get rid of a syntax error in my update script:



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request

("sFname")&"', StudID='"&Request("sIDnum")&"', Account='"&Request("sAcct")

&"', Amount="&Request("sAmnt")&", Date=#"&Date()&"#, Clerk='"&Session

("clerk")&"' where ID = "&Request("sItem")



If I remove the Date, it works as in script below:



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request

("sFname")&"', StudID='"&Request("sIDnum")&"', Account='"&Request("sAcct")

&"', Amount="&Request("sAmnt")&", Clerk='"&Session("clerk")&"' where ID 

= "&Request("sItem")



I cannot figure this one out.  Please help.



Ken W.

 




$subst('Email.Unsub')



Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks

Message #3 by "Witcher, Ken" <Witcher@s...> on Fri, 30 Nov 2001 08:56:52 -0500

This is a multi-part message in MIME format.



------_=_NextPart_001_01C179A6.DD2457F5

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



The reponse.write for the script that gets a syntax error is:



Update PatronDebits set LName=3D'Bullock', FName=3D'Angela', 

StudID=3D'gnum',

Account=3D'47-VendCards', Amount=3D100, Date=3D#11/30/2001#, 

Clerk=3D'test'

where ID =3D 12



The error is:

Microsoft JET Database Engine (0x80040E14)

Syntax error in UPDATE statement.

/business/feeadmin.asp, line 164



The response.write for the script that does  not get a syntax error is:



Update PatronDebits set LName=3D'Bullock', FName=3D'Angela', 

StudID=3D'gnum',

Account=3D'47-VendCards', Amount=3D100, Clerk=3D'test' where ID =3D 12



Let me know if you need more info.



Ken W.



-----Original Message-----

From: David Cameron [mailto:dcameron@i...]

Sent: Thursday, November 29, 2001 5:39 PM

To: ASP Databases

Subject: [asp_databases] RE: Update date - syntax error







Use response.write to dump the generated SQL string to the screen. Post

that and the error message to the screen.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: kwitcher@s... [ mailto:kwitcher@s...]

Sent: Friday, 30 November 2001 7:36 AM

To: ASP Databases

Subject: [asp_databases] Update date - syntax error





I cannot get rid of a syntax error in my update script:



"Update PatronDebits set LName=3D'"&Request("sLname")&"', 

FName=3D'"&Request



("sFname")&"', StudID=3D'"&Request("sIDnum")&"',

Account=3D'"&Request("sAcct")

&"', Amount=3D"&Request("sAmnt")&", Date=3D#"&Date()&"#, 

Clerk=3D'"&Session

("clerk")&"' where ID =3D "&Request("sItem")



If I remove the Date, it works as in script below:



"Update PatronDebits set LName=3D'"&Request("sLname")&"', 

FName=3D'"&Request



("sFname")&"', StudID=3D'"&Request("sIDnum")&"',

Account=3D'"&Request("sAcct")

&"', Amount=3D"&Request("sAmnt")&", Clerk=3D'"&Session("clerk")&"' where 

ID

=3D "&Request("sItem")



I cannot figure this one out.  Please help.



Ken W.

 




$subst('Email.Unsub')



Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=3D2181

<http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&ca

teg

oryid=3Drn_ebooks> &sourceid=3D38934667&categoryid=3Drn_ebooks








$subst('Email.Unsub')

Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

ego

ryid=3Drn_ebooks

Message #4 by "Breidenbach, Beth" <Beth.Breidenbach@g...> on Fri, 30 Nov 2001 09:28:58 -0500


It's been a while since I coded to the JET database, but in SQLServer

you have to put single quotes around date field values.  I bet if you used 

    Date='#11/30/2001#'

it'd work.



Beth



-----Original Message-----

From: Witcher, Ken

To: ASP Databases

Sent: 11/30/2001 8:56 AM

Subject: [asp_databases] RE: Update date - syntax error



The reponse.write for the script that gets a syntax error is:

 

Update PatronDebits set LName='Bullock', FName='Angela', StudID='gnum',

Account='47-VendCards', Amount=100, Date=#11/30/2001#, Clerk='test'

where ID = 12

 

The error is:

Microsoft JET Database Engine (0x80040E14)

Syntax error in UPDATE statement.

/business/feeadmin.asp, line 164

 

The response.write for the script that does  not get a syntax error is:

 

Update PatronDebits set LName='Bullock', FName='Angela', StudID='gnum',

Account='47-VendCards', Amount=100, Clerk='test' where ID = 12

 

Let me know if you need more info.

 

Ken W.



-----Original Message-----

From: David Cameron [mailto:dcameron@i...]

Sent: Thursday, November 29, 2001 5:39 PM

To: ASP Databases

Subject: [asp_databases] RE: Update date - syntax error







Use response.write to dump the generated SQL string to the screen. Post

that and the error message to the screen. 



regards 

David Cameron 

nOw.b2b 

dcameron@i... 



-----Original Message----- 

From: kwitcher@s... [mailto:kwitcher@s...

<mailto:kwitcher@s...> ] 

Sent: Friday, 30 November 2001 7:36 AM 

To: ASP Databases 

Subject: [asp_databases] Update date - syntax error 





I cannot get rid of a syntax error in my update script: 



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request



("sFname")&"', StudID='"&Request("sIDnum")&"',

Account='"&Request("sAcct") 

&"', Amount="&Request("sAmnt")&", Date=#"&Date()&"#, Clerk='"&Session 

("clerk")&"' where ID = "&Request("sItem") 



If I remove the Date, it works as in script below: 



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request



("sFname")&"', StudID='"&Request("sIDnum")&"',

Account='"&Request("sAcct") 

&"', Amount="&Request("sAmnt")&", Clerk='"&Session("clerk")&"' where ID 

= "&Request("sItem") 



I cannot figure this one out.  Please help. 



Ken W.

Message #5 by "Breidenbach, Beth" <Beth.Breidenbach@g...> on Fri, 30 Nov 2001 09:59:40 -0500

Sorry, I was being dense.  



"Date" is a reserved word.  If you wish to use it as a column name you'll

need to enclose it in brackets



Example:  "update Table1 set [Date]=#5/15/01#"



Beth 



-----Original Message-----

From: Witcher, Ken

To: Breidenbach, Beth

Sent: 11/30/2001 9:28 AM

Subject: RE: [asp_databases] RE: Update date - syntax error



sorry. I tried the single quotes around the # signs.



It still doesn't work.



Ken W.



-----Original Message-----

From: Breidenbach, Beth [mailto:Beth.Breidenbach@g...]

Sent: Friday, November 30, 2001 9:26 AM

To: Witcher, Ken; 'ASP Databases '

Subject: RE: [asp_databases] RE: Update date - syntax error





It's been a while since I coded to the JET database, but in SQLServer

you

have to put single quotes around date field values.  I bet if you used 

    Date='#11/30/2001#'

it'd work.



Beth



-----Original Message-----

From: Witcher, Ken

To: ASP Databases

Sent: 11/30/2001 8:56 AM

Subject: [asp_databases] RE: Update date - syntax error



The reponse.write for the script that gets a syntax error is:

 

Update PatronDebits set LName='Bullock', FName='Angela', StudID='gnum',

Account='47-VendCards', Amount=100, Date=#11/30/2001#, Clerk='test'

where ID = 12

 

The error is:

Microsoft JET Database Engine (0x80040E14)

Syntax error in UPDATE statement.

/business/feeadmin.asp, line 164

 

The response.write for the script that does  not get a syntax error is:

 

Update PatronDebits set LName='Bullock', FName='Angela', StudID='gnum',

Account='47-VendCards', Amount=100, Clerk='test' where ID = 12

 

Let me know if you need more info.

 

Ken W.



-----Original Message-----

From: David Cameron [mailto:dcameron@i...]

Sent: Thursday, November 29, 2001 5:39 PM

To: ASP Databases

Subject: [asp_databases] RE: Update date - syntax error







Use response.write to dump the generated SQL string to the screen. Post

that and the error message to the screen. 



regards 

David Cameron 

nOw.b2b 

dcameron@i... 



-----Original Message----- 

From: kwitcher@s... [mailto:kwitcher@s...

<mailto:kwitcher@s...> ] 

Sent: Friday, 30 November 2001 7:36 AM 

To: ASP Databases 

Subject: [asp_databases] Update date - syntax error 





I cannot get rid of a syntax error in my update script: 



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request



("sFname")&"', StudID='"&Request("sIDnum")&"',

Account='"&Request("sAcct") 

&"', Amount="&Request("sAmnt")&", Date=#"&Date()&"#, Clerk='"&Session 

("clerk")&"' where ID = "&Request("sItem") 



If I remove the Date, it works as in script below: 



"Update PatronDebits set LName='"&Request("sLname")&"', FName='"&Request



("sFname")&"', StudID='"&Request("sIDnum")&"',

Account='"&Request("sAcct") 

&"', Amount="&Request("sAmnt")&", Clerk='"&Session("clerk")&"' where ID 

= "&Request("sItem") 



I cannot figure this one out.  Please help. 



Ken W.

Message #6 by "Reynolds, Josh" <Josh.Reynolds@e...> on Fri, 30 Nov 2001 10:04:42 -0500

I can't believe nobody's figured this one out yet :)  Date is a 

reserved word.  Try calling the field TDate, or maybe wrapping it in 

brackets.



josh



----- Original Message -----

From: "Breidenbach, Beth" <Beth.Breidenbach@g...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, November 30, 2001 9:28 AM

Subject: [asp_databases] RE: Update date - syntax error





>

> It's been a while since I coded to the JET database, but in SQLServer

> you have to put single quotes around date field values.  I bet if you 

used

>     Date=3D'#11/30/2001#'

> it'd work.

>

> Beth

>

> -----Original Message-----

> From: Witcher, Ken

> To: ASP Databases

> Sent: 11/30/2001 8:56 AM

> Subject: [asp_databases] RE: Update date - syntax error

>

> The reponse.write for the script that gets a syntax error is:

> 

> Update PatronDebits set LName=3D'Bullock', FName=3D'Angela', 

StudID=3D'gnum',

> Account=3D'47-VendCards', Amount=3D100, Date=3D#11/30/2001#, 

Clerk=3D'test'

> where ID =3D 12

> 

> The error is:

> Microsoft JET Database Engine (0x80040E14)

> Syntax error in UPDATE statement.

> /business/feeadmin.asp, line 164

> 

> The response.write for the script that does  not get a syntax error 

is:

> 

> Update PatronDebits set LName=3D'Bullock', FName=3D'Angela', 

StudID=3D'gnum',

> Account=3D'47-VendCards', Amount=3D100, Clerk=3D'test' where ID =3D 

12

> 

> Let me know if you need more info.

> 

> Ken W.

>

> -----Original Message-----

> From: David Cameron [mailto:dcameron@i...]

> Sent: Thursday, November 29, 2001 5:39 PM

> To: ASP Databases

> Subject: [asp_databases] RE: Update date - syntax error

>

>

>

> Use response.write to dump the generated SQL string to the screen. 

Post

> that and the error message to the screen.

>

> regards

> David Cameron

> nOw.b2b

> dcameron@i...

>

> -----Original Message-----

> From: kwitcher@s... [mailto:kwitcher@s...

> <mailto:kwitcher@s...> ]

> Sent: Friday, 30 November 2001 7:36 AM

> To: ASP Databases

> Subject: [asp_databases] Update date - syntax error

>

>

> I cannot get rid of a syntax error in my update script:

>

> "Update PatronDebits set LName=3D'"&Request("sLname")&"', 

FName=3D'"&Request

>

> ("sFname")&"', StudID=3D'"&Request("sIDnum")&"',

> Account=3D'"&Request("sAcct")

> &"', Amount=3D"&Request("sAmnt")&", Date=3D#"&Date()&"#, 

Clerk=3D'"&Session

> ("clerk")&"' where ID =3D "&Request("sItem")

>

> If I remove the Date, it works as in script below:

>

> "Update PatronDebits set LName=3D'"&Request("sLname")&"', 

FName=3D'"&Request

>

> ("sFname")&"', StudID=3D'"&Request("sIDnum")&"',

> Account=3D'"&Request("sAcct")

> &"', Amount=3D"&Request("sAmnt")&", Clerk=3D'"&Session("clerk")&"' 

where ID

> =3D "&Request("sItem")

>

> I cannot figure this one out.  Please help.

>

> Ken W.

>  

>

> 



josh.reynolds@e...


$subst('Email.Unsub')

>

> Read the future with ebooks at B&N

> 

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&ca

tegoryid=3Drn_ebooks

Message #7 by "Witcher, Ken" <Witcher@s...> on Fri, 30 Nov 2001 10:10:30 -0500

OK Great!  That fixed my syntax. 



Now I get a Type mismatch:



Microsoft JET Database Engine (0x80040E07)

Data type mismatch in criteria expression.

/business/feeadmin.asp, line 162



Any Ideas? I am using date/time-general date in this filed in access.



Ken W.



-----Original Message-----

From: Breidenbach, Beth [mailto:Beth.Breidenbach@g...]

Sent: Friday, November 30, 2001 10:00 AM

To: ASP Databases

Cc: 'asp_databases@p...'

Subject: [asp_databases] RE: Update date - syntax error





Sorry, I was being dense. 



"Date" is a reserved word.  If you wish to use it as a column name

you'll

need to enclose it in brackets



Example:  "update Table1 set [Date]=3D#5/15/01#"



Beth



-----Original Message-----

From: Witcher, Ken

To: Breidenbach, Beth

Sent: 11/30/2001 9:28 AM

Subject: RE: [asp_databases] RE: Update date - syntax error



sorry. I tried the single quotes around the # signs.



It still doesn't work.



Ken W.



-----Original Message-----

From: Breidenbach, Beth [mailto:Beth.Breidenbach@g...]

Sent: Friday, November 30, 2001 9:26 AM

To: Witcher, Ken; 'ASP Databases '

Subject: RE: [asp_databases] RE: Update date - syntax error





It's been a while since I coded to the JET database, but in SQLServer

you

have to put single quotes around date field values.  I bet if you used

    Date=3D'#11/30/2001#'

it'd work.



Beth



-----Original Message-----

From: Witcher, Ken

To: ASP Databases

Sent: 11/30/2001 8:56 AM

Subject: [asp_databases] RE: Update date - syntax error



The reponse.write for the script that gets a syntax error is:



Update PatronDebits set LName=3D'Bullock', FName=3D'Angela', 

StudID=3D'gnum',

Account=3D'47-VendCards', Amount=3D100, Date=3D#11/30/2001#, 

Clerk=3D'test'

where ID =3D 12



The error is:

Microsoft JET Database Engine (0x80040E14)

Syntax error in UPDATE statement.

/business/feeadmin.asp, line 164



The response.write for the script that does  not get a syntax error is:



Update PatronDebits set LName=3D'Bullock', FName=3D'Angela', 

StudID=3D'gnum',

Account=3D'47-VendCards', Amount=3D100, Clerk=3D'test' where ID =3D 12



Let me know if you need more info.



Ken W.



-----Original Message-----

From: David Cameron [mailto:dcameron@i...]

Sent: Thursday, November 29, 2001 5:39 PM

To: ASP Databases

Subject: [asp_databases] RE: Update date - syntax error







Use response.write to dump the generated SQL string to the screen. Post

that and the error message to the screen.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: kwitcher@s... [mailto:kwitcher@s...

<mailto:kwitcher@s...> ]

Sent: Friday, 30 November 2001 7:36 AM

To: ASP Databases

Subject: [asp_databases] Update date - syntax error





I cannot get rid of a syntax error in my update script:



"Update PatronDebits set LName=3D'"&Request("sLname")&"', 

FName=3D'"&Request



("sFname")&"', StudID=3D'"&Request("sIDnum")&"',

Account=3D'"&Request("sAcct")

&"', Amount=3D"&Request("sAmnt")&", Date=3D#"&Date()&"#, 

Clerk=3D'"&Session

("clerk")&"' where ID =3D "&Request("sItem")



If I remove the Date, it works as in script below:



"Update PatronDebits set LName=3D'"&Request("sLname")&"', 

FName=3D'"&Request



("sFname")&"', StudID=3D'"&Request("sIDnum")&"',

Account=3D'"&Request("sAcct")

&"', Amount=3D"&Request("sAmnt")&", Clerk=3D'"&Session("clerk")&"' where 

ID

=3D "&Request("sItem")



I cannot figure this one out.  Please help.



Ken W.

 








$subst('Email.Unsub')



Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat

ego

ryid=3Drn_ebooks

Return to Index

P2P Archives