asp_databases thread: Question Time
Message #1 by "Matt Besseling" <mattb@h...> on Thu, 20 Jul 2000 13:32:13|
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
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?
I'm sorry for the multitude of questions. If I get this done, I promise
never to pollute this message list again. Deal?
Soon to be EX asp aspirant
Message #2 by smartin@c... on Thu, 20 Jul 2000 11:42:52 -0400|
>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/No fields in Access are actually Boolean fields, so try "SELECT * FROM
Stamps WHERE InAuction = True" for "yes."
Message #3 by "Ken Schaefer" <ken.s@a...> on Fri, 21 Jul 2000 14:06:37 +1000|
> 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?
Have you ever seen the error:
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: