Limited number of instert records

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Limited number of instert records

    Hi - Using ASP/Access/Vbscript

    Is it possible to set a limit of for example 6 insert records of the same type
    in the DB?
    Have a product database where user can insert records. If selected producttype
    B - then max 6 records alowed in the DB.

    Possible? Any suggestions?

    Thanx!

    Bjorn.

    btn Guest

  2. Similar Questions and Discussions

    1. How to display limited number of rows of table indatabase
      I have built some CF pages to display my huge collection of DVDs and I would like to have a limited number of rows displayed at a time. Then there...
    2. Number of WebMethods limited in .asmx file?
      Hi, I'm working with a large webservice project. This project exposes many different WebMethods in the .asmx file. Recently, I've been having...
    3. is the number of variables limited?
      hi there, anybody out there, who reached the maximal number of variables in illustrator (10)? any help appreciated. michael.
    4. Limited the number of decimal places returned?
      I've moved on from functions for the time being, and was playing with do some maths and date/time manipulation. Lets say I wanted to show the...
    5. Access 97 listbox limited to 64k records.
      Andrew If you're stuffing that much data into a listbox, have you considered making a subform/continuous form? -- Rob ...
  3. #2

    Default Re: Limited number of instert records

    You could create a recordset with some SQL like

    select count(ProductID) as TheCount from Products where ProductID=5

    The test to see if the value is greater than 6 before the insertion.

    --
    Jules
    [url]http://www.charon.co.uk/charoncart[/url]
    Charon Cart 3
    Shopping Cart Extension for Dreamweaver MX/MX 2004


    Julian Roberts Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139