Professional Web Applications Themes

Limited number of instert records - Dreamweaver AppDev

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....

  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. #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

Similar Threads

  1. How to display limited number of rows of table indatabase
    By cgacfox in forum Coldfusion Database Access
    Replies: 12
    Last Post: March 10th, 08:54 PM
  2. Number of WebMethods limited in .asmx file?
    By Scott in forum ASP.NET Web Services
    Replies: 1
    Last Post: August 1st, 07:56 PM
  3. is the number of variables limited?
    By Michael_Stoll@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 4
    Last Post: June 8th, 07:36 PM
  4. Limited the number of decimal places returned?
    By Clive Sweeting in forum PHP Development
    Replies: 2
    Last Post: December 13th, 09:16 PM
  5. Access 97 listbox limited to 64k records.
    By RobFMS in forum Microsoft Access
    Replies: 14
    Last Post: July 15th, 04:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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