|
 |
access_asp thread: comparison operators
Message #1 by topwebdesigns@h... on Wed, 19 Jun 2002 07:26:26
|
|
I need to make comparisons between two number fields where do i do it in
dreamweaver ultradev where it builds my sql stament or in acccess 02 in my
querybuilder I have book but just states the operaters and not how to use
them like does this need to be in single quotes, double quotes, spaces
comas or so on any help would greatly be appreciated
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 20 Jun 2002 11:06:33 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <topwebdesigns@h...>
Subject: [access_asp] comparison operators
: I need to make comparisons between two number fields
: where do i do it in dreamweaver ultradev where it builds my
: sql stament or in acccess 02 in my querybuilder I have book
: but just states the operaters and not how to use them like
: does this need to be in single quotes, double quotes, spaces
: comas or so on any help would greatly be appreciated
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi,
If you used some punctuation your post would probably be more
comprehensible.
If you want to compare two fields in your database, then you can do this in
your SQL statement. The SQL statement will be evaluated by the database. It
is not evaluated by ASP, or by UltraDev.
In terms of delimiters, check out:
http://www.adopenstatic.com/faq/80040e07.asp
Cheers
Ken
|
|
 |