p2p.wrox.com: Archives - asp

asp_databases thread: between min and max

Message #1 by "Oliver Dempsey" <odempsey@b...> on Mon, 11 Dec 2000 17:51:20 -0000

This is a multi-part message in MIME format.



------=_NextPart_000_0079_01C0639A.F845A0C0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Can anybody tell me what is wrong with this?



& "and Price between "& min &"and"& max





It's giving me this error

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing 

operator) in query expression 'Town =3D 'Alltowns' and County =3D 

'Laois'and Price between 0and10,000,000'.







Regards



Oliver Dempsey

Message #2 by "SOTOLONGO, Carlos" <CSOTOLON@m...> on Mon, 11 Dec 2000 15:47:12 -0400

Try



& "Price between " & min & " and " & max



HTH,

Carlos.





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

> From:	Oliver Dempsey [SMTP:odempsey@b...]

> Sent:	Monday, December 11, 2000 1:51 PM

> To:	ASP Databases

> Subject:	[asp_databases] between min and max

> 

> Can anybody tell me what is wrong with this?

>  

> & "and Price between "& min &"and"& max

>  

>  

> It's giving me this error

> [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)

> in query expression 'Town = 'Alltowns' and County = 'Laois'and Price

> between 0and10,000,000'. 

> 

>  

> 

> Regards

> 

> Oliver Dempsey

>

Message #3 by "Christiana, John" <JChrist@a...> on Mon, 11 Dec 2000 14:52:13 -0500

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_01C063AB.E1266A44

Content-Type: text/plain;

	charset="iso-8859-1"



Oliver,

 

First, I think you need to add some spaces between your reserved words and

values.  Second, remove the commas from 10,000,000.  Access does not like

commas in numbers.

 

-- John

 

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

From: Oliver Dempsey [mailto:odempsey@b...]

Sent: Monday, December 11, 2000 12:51 PM

To: ASP Databases

Subject: [asp_databases] between min and max





Can anybody tell me what is wrong with this?

 

& "and Price between "& min &"and"& max

 

 

It's giving me this error

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in

query expression 'Town = 'Alltowns' and County = 'Laois'and Price between

0and10,000,000'. 



 



Regards



Oliver Dempsey



--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips,

tools, and 

developments from the experts. Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today! 




$subst('Email.Unsub')

Message #4 by Imar Spaanjaars <Imar@S...> on Mon, 11 Dec 2000 21:29:00 +0100

Not really sure, but I think you need a space between the values and the and:



         & " and Price between " & min & " and " & max



HtH



Imar





At 05:51 PM 12/11/2000 +0000, you wrote:

>Can anybody tell me what is wrong with this?

>

>& "and Price between "& min &"and"& max

>

>

>It's giving me this error

>

>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) 

>in query expression 'Town = 'Alltowns' and County = 'Laois'and Price 

>between 0and10,000,000'.

>

>

>

>Regards

>

>Oliver Dempsey

Message #5 by "Oliver Dempsey" <odempsey@b...> on Mon, 11 Dec 2000 21:01:41 -0000

This is a multi-part message in MIME format.



------=_NextPart_000_00D2_01C063B5.8F840C00

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



I got it sorted.

I typed in

& "and Price between "& int(min) &" and "& int(max)



I don't know why but it seemed to be putting a comma into the large 

numbers and then it was getting confused





Oliver





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

  From: Oliver Dempsey

  To: ASP Databases

  Sent: Monday, December 11, 2000 5:51 PM

  Subject: [asp_databases] between min and max





  Can anybody tell me what is wrong with this?



  & "and Price between "& min &"and"& max





  It's giving me this error

  [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing 

operator) in query expression 'Town =3D 'Alltowns' and County =3D 

'Laois'and Price between 0and10,000,000'.







  Regards



  Oliver Dempsey



  ---

  FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

  INSIGHTS IN YOUR INBOX!

  Get the latest and best C++, Visual C++, Java, Visual Basic, and XML 

tips, tools, and

  developments from the experts. Sign up for one or more of EarthWeb?s

  FREE IT newsletters at http://www.earthweb.com today!



odempsey@b...


$subst('Email.Unsub')

Message #6 by "Harsh Nandu" <harsh_stgil@h...> on Tue, 12 Dec 2000 06:24:02 -0000

Add spaces.

Add spaces on both the sides of both the 'and' keywords.





>From: "Oliver Dempsey" <odempsey@b...>

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

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

>Subject: [asp_databases] between min and max

>Date: Mon, 11 Dec 2000 17:51:20 -0000

>

>Can anybody tell me what is wrong with this?

>

>& "and Price between "& min &"and"& max

>

>

>It's giving me this error

>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) 

>in query expression 'Town = 'Alltowns' and County = 'Laois'and Price 

>between 0and10,000,000'.

>

>

>

>Regards

>

>Oliver Dempsey

>

>

>

Message #7 by "Oliver Dempsey" <odempsey@b...> on Tue, 12 Dec 2000 13:43:16 -0000

You were all right, the spaces were what was causing the problem!





Regards

Oliver Dempsey









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

From: Harsh Nandu <harsh_stgil@h...>

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

Sent: Tuesday, December 12, 2000 6:24 AM

Subject: [asp_databases] Re: between min and max





> Add spaces.

> Add spaces on both the sides of both the 'and' keywords.

>

>

> >From: "Oliver Dempsey" <odempsey@b...>

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

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

> >Subject: [asp_databases] between min and max

> >Date: Mon, 11 Dec 2000 17:51:20 -0000

> >

> >Can anybody tell me what is wrong with this?

> >

> >& "and Price between "& min &"and"& max

> >

> >

> >It's giving me this error

> >[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)

> >in query expression 'Town = 'Alltowns' and County = 'Laois'and Price

> >between 0and10,000,000'.

> >

> >

> >

> >Regards

> >

> >Oliver Dempsey

> >

> >

> >

>







---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Return to Index

P2P Archives