Firstly, thanks to all those who have have answered my (probably 

irritating) questions over the last couple of months. I've almost finished 

this darned stamp database, but I just need a LITTLE more help. Please?



1) How do you retreive a yes/no field from an access database in  select 

statement? I'm trying something like "SELECT * FROM Stamps WHERE InAuction 

= 'Yes'"



2) I posted a question about spanning pages for a large search return. I 

got quite a nice page of code, but, although it worked fine on the site I 

got it from, it comes up with an error on my page. The error is something 

about conflicting values in the line rs.AbsolutePage = Current_Page

You can see the whole code at http://www.tfstamps.co.za/searchvalid.asp

The directing page is the search.asp page.



3) I am trying to insert values into a database, and it gets stuck on only 

one field. I've tried renaming the field, but deleting the field is the 

only way out. Why do some fields just not like being inserted, when they 

are exactly the same as all the others? 

https://www.tfstamps.co.za/secure/register_check.asp



I'm sorry for the multitude of questions. If I get this done, I promise 

never to pollute this message list again. Deal?



Thanks everyone!



Matt Besseling

Soon to be EX asp aspirant

>1) How do you retreive a yes/no field from an access database in  select 

>statement? I'm trying something like "SELECT * FROM Stamps WHERE InAuction 

>= 'Yes'"



Yes/No fields in Access are actually Boolean fields, so try "SELECT * FROM

Stamps WHERE InAuction = True" for "yes."

> 3) I am trying to insert values into a database, and it gets stuck on only

> one field. I've tried renaming the field, but deleting the field is the

> only way out. Why do some fields just not like being inserted, when they

> are exactly the same as all the others?

> https://www.tfstamps.co.za/secure/register_check.asp



Have you ever seen the error:



error '0xABCDEF00'

The relevant code is not found



?



(The URL above returns a 404 Page Not Found error)

Suggest you post some code.

If the error you are getting when you do an insert is 80040e14 - Syntax

Error in Update Statement (or Syntax Error in Insert Statement) then you

should look at:

http://www.adopenstatic.com/faq/80040e14.asp



Cheers

Ken