Recent content by Rams_

  1. R

    Syntax error

    I can't see what's wrong with this.. error message in quote tags and line highlighted. Response.write: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <head> <title>Welcome to the Kennels Database System</title> <link...
  2. R

    Counting instances in a table

    The ISNull worked, thanks!
  3. R

    Counting instances in a table

    Thanks for that! Have since changed my query to include Vet IDs not present as FKs but it returns NULL rather than 0 as the result. Trying to convert to Null to "0" is proving problamatic. It seems to think every x.value=NULL and my table comes out with just 0's :P <!-- CONTENT OF...
  4. R

    Counting instances in a table

    I would like to know a method of looping through a recordset, and counting the number of times something occurs (in my case how many times a foriegn key occurs). I want to count each foriegn key though, not just one. My foriegn key is called "vet id", the table is tblanimals. So say I had...
See more
Back
Top Bottom