Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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


  Return to Index