home *** CD-ROM | disk | FTP | other *** search
/ Internet Magazine 2002 December / INTERNET97.ISO / pc / software / windows / building / dbqwiksite / dbqwiksitepro.exe / %MAINDIR% / Projects / DBQwikSiteSample3.dbh < prev   
Encoding:
Text File  |  2002-09-09  |  11.1 KB  |  281 lines
  1. 2.0C:\Inetpub\wwwroot\DBQwikSite\Preview\Project1ImageshtmTRUE21FALSE"84.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\84.gif","2.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\2.gif","204.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\204.gif","3.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\3.gif","4.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\4.gif","612.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\612.gif","7.jpg=C:\Program Files\DBQwikSite 2\Data\DemoImages\7.jpg","70.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\70.gif","71.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\71.gif","72.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\72.gif","73.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\73.gif","76.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\76.gif","77.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\77.gif","78.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\78.gif","79.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\79.gif","80.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\80.gif","82.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\82.gif","83.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\83.gif","1.gif=C:\Program Files\DBQwikSite 2\Data\DemoImages\1.gif"DBQwikSite2Sample2Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\DBQwikSite 2\Data\DBSamples\Sample2.mdb;Persist Security Info=FalseVJoinCount=2
  2. VTableCount=3
  3. VSortCount=0
  4. VCalCount=0
  5. AllowDuplicateJoins=FALSE
  6. AutoSizeTable=TRUE
  7. TabOrder=2
  8. ADOConnectionStringProvider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Program Files\DBQwikSite 2\Data\DBSamples\Sample2.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
  9. DBTableListBox=lb_tables
  10. LogicalSQLNames=FALSE
  11. SelectDistinct=FALSE
  12. ShowJoinCaptions=TRUE
  13. ShowSystemTables=FALSE
  14. ShowJoinComment=FALSE
  15. SQLCommentEndChars=*/
  16. SQLCommentStartChars=/*
  17. SQLQuoteChars=`
  18. Table0.DBTableName=NEWPRODUCT
  19. Table0.TableCaption=NEWPRODUCT
  20. Table0.TableName=NEWPRODUCT
  21. Table0.OwnerName=
  22. Table0.TableAlias=NEWPRODUCT
  23. Table0.Top=19
  24. Table0.Left=29
  25. Table0.Height=189
  26. Table0.Width=166
  27. Table0.FieldCount=8
  28. Table0.PRODUCT_ID=PRODUCT_ID
  29. Table0.PRODUCT_ID.CHECKED=TRUE
  30. Table0.PRODUCT_ID.Sort=stNoSort
  31. Table0.TYPE_ID=TYPE_ID
  32. Table0.TYPE_ID.CHECKED=TRUE
  33. Table0.TYPE_ID.Sort=stNoSort
  34. Table0.BRAND_ID=BRAND_ID
  35. Table0.BRAND_ID.CHECKED=TRUE
  36. Table0.BRAND_ID.Sort=stNoSort
  37. Table0.BRAND_ID.CompareOperator==
  38. Table0.BRAND_ID.DestLiteral=1
  39. Table0.SPEC=SPEC
  40. Table0.SPEC.CHECKED=TRUE
  41. Table0.SPEC.Sort=stNoSort
  42. Table0.PRICE=PRICE
  43. Table0.PRICE.CHECKED=TRUE
  44. Table0.PRICE.Sort=stNoSort
  45. Table0.COMMENT=COMMENT
  46. Table0.COMMENT.CHECKED=TRUE
  47. Table0.COMMENT.Sort=stNoSort
  48. Table0.PICTURE=PICTURE
  49. Table0.PICTURE.CHECKED=TRUE
  50. Table0.PICTURE.Sort=stNoSort
  51. Table0.LINKURL=LINKURL
  52. Table0.LINKURL.CHECKED=TRUE
  53. Table0.LINKURL.Sort=stNoSort
  54. Table1.DBTableName=BRAND
  55. Table1.TableCaption=BRAND
  56. Table1.TableName=BRAND
  57. Table1.OwnerName=
  58. Table1.TableAlias=BRAND
  59. Table1.Top=14
  60. Table1.Left=406
  61. Table1.Height=115
  62. Table1.Width=132
  63. Table1.FieldCount=3
  64. Table1.BRAND_ID=BRAND_ID
  65. Table1.BRAND_ID.Sort=stNoSort
  66. Table1.BRAND=BRAND
  67. Table1.BRAND.CHECKED=TRUE
  68. Table1.BRAND.Sort=stNoSort
  69. Table1.COMMENT=COMMENT
  70. Table1.COMMENT.Sort=stNoSort
  71. Table2.DBTableName=TYPE
  72. Table2.TableCaption=TYPE
  73. Table2.TableName=TYPE
  74. Table2.OwnerName=
  75. Table2.TableAlias=TYPE
  76. Table2.Top=179
  77. Table2.Left=369
  78. Table2.Height=109
  79. Table2.Width=126
  80. Table2.FieldCount=3
  81. Table2.TYPE_ID=TYPE_ID
  82. Table2.TYPE_ID.Sort=stNoSort
  83. Table2.TYPE=TYPE
  84. Table2.TYPE.CHECKED=TRUE
  85. Table2.TYPE.Sort=stNoSort
  86. Table2.COMMENT=COMMENT
  87. Table2.COMMENT.Sort=stNoSort
  88. JoinCount=2
  89. Join0.SourceTableName=NEWPRODUCT
  90. Join0.SourceFieldName=BRAND_ID
  91. Join0.DestTableName=BRAND
  92. Join0.DestFieldName=BRAND_ID
  93. Join0.Caption=BRAND_ID = BRAND_ID
  94. Join0.Color=0
  95. Join0.JoinType=0
  96. Join0.CompareOperator==
  97. Join1.SourceTableName=NEWPRODUCT
  98. Join1.SourceFieldName=TYPE_ID
  99. Join1.DestTableName=TYPE
  100. Join1.DestFieldName=TYPE_ID
  101. Join1.Caption=TYPE_ID = TYPE_ID
  102. Join1.Color=0
  103. Join1.JoinType=0
  104. Join1.CompareOperator==
  105. Select
  106.     NEWPRODUCT.PRODUCT_ID,
  107.     NEWPRODUCT.TYPE_ID,
  108.     NEWPRODUCT.BRAND_ID,
  109.     NEWPRODUCT.SPEC,
  110.     NEWPRODUCT.PRICE,
  111.     NEWPRODUCT.COMMENT,
  112.     NEWPRODUCT.PICTURE,
  113.     NEWPRODUCT.LINKURL,
  114.     BRAND.BRAND,
  115.     TYPE.TYPE
  116. From
  117.     NEWPRODUCT   NEWPRODUCT,
  118.     BRAND   BRAND,
  119.     TYPE   TYPE
  120. Where (
  121.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  122.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  123. )
  124.  
  125. And (
  126.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  127.     )
  128. PRODUCT_ID=1,0,1,0,1
  129. TYPE_ID=1,0,1,0,1
  130. BRAND_ID=1,0,1,0,1
  131. SPEC=0,0,0,0,0
  132. PRICE=1,0,1,0,1
  133. COMMENT=0,0,0,0,0
  134. PICTURE=0,0,0,0,0
  135. LINKURL=0,0,0,0,0
  136. BRAND=0,0,0,0,0
  137. TYPE=0,0,0,0,0
  138. Data Page<Center>
  139. <H1><Font Color="199919">TDS Camera Shop</Font></H1>
  140. </Center>
  141. 311Arial9FALSEFALSE410TRUE3CustomCatalogsQuickSite Catalog1clWhiteclWhite$20000000$00994900$000000F0clPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack5ProductImage1DefaultTRUE[PICTURE]0ProductName0DefaultTRUE[BRAND] [SPEC]0Product ID0DefaultTRUE[PRODUCT_ID]0Price0DefaultTRUE[PRICE]0BuyNowButton1DefaultTRUE./images/buynow.gif0Select
  142.     NEWPRODUCT.PRODUCT_ID,
  143.     NEWPRODUCT.TYPE_ID,
  144.     NEWPRODUCT.BRAND_ID,
  145.     NEWPRODUCT.SPEC,
  146.     NEWPRODUCT.PRICE,
  147.     NEWPRODUCT.COMMENT,
  148.     NEWPRODUCT.PICTURE,
  149.     NEWPRODUCT.LINKURL,
  150.     BRAND.BRAND,
  151.     TYPE.TYPE
  152. From
  153.     NEWPRODUCT   NEWPRODUCT,
  154.     BRAND   BRAND,
  155.     TYPE   TYPE
  156. Where (
  157.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  158.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  159. )
  160.  
  161. And (
  162.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  163.     )
  164. PRODUCT_ID=1,0,1,0,1
  165. TYPE_ID=1,0,1,0,1
  166. BRAND_ID=1,0,1,0,1
  167. SPEC=0,0,0,0,0
  168. PRICE=1,0,1,0,1
  169. COMMENT=0,0,0,0,0
  170. PICTURE=0,0,0,0,0
  171. LINKURL=0,0,0,0,0
  172. BRAND=0,0,0,0,0
  173. TYPE=0,0,0,0,0
  174. Search Page<Center>
  175. </Center>
  176. 100Arial9TRUETRUE410TRUE20SimpleSearch PagesQuickSite Search1clWhite$00D4D4D4$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack10Brand Name2DefaultTRUE[BRAND]0Model2DefaultTRUE[SPEC]0Price2DefaultTRUE[PRICE]0BRAND_ID2DefaultTRUE[BRAND_ID]0COMMENT2DefaultTRUE[COMMENT]0LINKURL2DefaultTRUE[LINKURL]0PICTURE2DefaultTRUE[PICTURE]0PRODUCT_ID2DefaultTRUE[PRODUCT_ID]0TYPE_ID2DefaultTRUE[TYPE_ID]0TYPE2DefaultTRUE[TYPE]0Select
  177.     NEWPRODUCT.PRODUCT_ID,
  178.     NEWPRODUCT.TYPE_ID,
  179.     NEWPRODUCT.BRAND_ID,
  180.     NEWPRODUCT.SPEC,
  181.     NEWPRODUCT.PRICE,
  182.     NEWPRODUCT.COMMENT,
  183.     NEWPRODUCT.PICTURE,
  184.     NEWPRODUCT.LINKURL,
  185.     BRAND.BRAND,
  186.     TYPE.TYPE
  187. From
  188.     NEWPRODUCT   NEWPRODUCT,
  189.     BRAND   BRAND,
  190.     TYPE   TYPE
  191. Where (
  192.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  193.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  194. )
  195.  
  196. And (
  197.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  198.     )
  199. PRODUCT_ID=1,0,1,0,1
  200. TYPE_ID=1,0,1,0,1
  201. BRAND_ID=1,0,1,0,1
  202. SPEC=0,0,0,0,0
  203. PRICE=1,0,1,0,1
  204. COMMENT=0,0,0,0,0
  205. PICTURE=0,0,0,0,0
  206. LINKURL=0,0,0,0,0
  207. BRAND=0,0,0,0,0
  208. TYPE=0,0,0,0,0
  209. Add Page<Center>
  210. </Center>
  211. 400Arial9TRUETRUE410TRUE20SimpleAdd PagesQuickSite Add1clWhite$00D4D4D4$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack9Brand Name2DefaultTRUE[BRAND]0Model2DefaultTRUE[SPEC]0Price2DefaultTRUE[PRICE]0Picture2DefaultTRUE[PICTURE]0Link2DefaultTRUE[LINKURL]0Comment2DefaultTRUE[COMMENT]0BRAND_ID2DefaultTRUE[BRAND_ID]0TYPE_ID2DefaultTRUE[TYPE_ID]0TYPE2DefaultTRUE[TYPE]0Select
  212.     NEWPRODUCT.PRODUCT_ID,
  213.     NEWPRODUCT.TYPE_ID,
  214.     NEWPRODUCT.BRAND_ID,
  215.     NEWPRODUCT.SPEC,
  216.     NEWPRODUCT.PRICE,
  217.     NEWPRODUCT.COMMENT,
  218.     NEWPRODUCT.PICTURE,
  219.     NEWPRODUCT.LINKURL,
  220.     BRAND.BRAND,
  221.     TYPE.TYPE
  222. From
  223.     NEWPRODUCT   NEWPRODUCT,
  224.     BRAND   BRAND,
  225.     TYPE   TYPE
  226. Where (
  227.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  228.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  229. )
  230.  
  231. And (
  232.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  233.     )
  234. PRODUCT_ID=1,0,1,0,1
  235. TYPE_ID=1,0,1,0,1
  236. BRAND_ID=1,0,1,0,1
  237. SPEC=0,0,0,0,0
  238. PRICE=1,0,1,0,1
  239. COMMENT=0,0,0,0,0
  240. PICTURE=0,0,0,0,0
  241. LINKURL=0,0,0,0,0
  242. BRAND=0,0,0,0,0
  243. TYPE=0,0,0,0,0
  244. Edit Page<Center>
  245. </Center>
  246. 400Arial9TRUETRUE410TRUE20SimpleEdit PagesQuickSite Edit1clWhite$00D4D4D4$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack10Brand Name2DefaultTRUE[BRAND]0Model2DefaultTRUE[SPEC]0Price2DefaultTRUE[PRICE]0Picture2DefaultTRUE[PICTURE]0Link2DefaultTRUE[LINKURL]0Comment2DefaultTRUE[COMMENT]0BRAND_ID2DefaultTRUE[BRAND_ID]0PRODUCT_ID5DefaultTRUE[PRODUCT_ID]0TYPE_ID2DefaultTRUE[TYPE_ID]0TYPE2DefaultTRUE[TYPE]0Select
  247.     NEWPRODUCT.PRODUCT_ID,
  248.     NEWPRODUCT.TYPE_ID,
  249.     NEWPRODUCT.BRAND_ID,
  250.     NEWPRODUCT.SPEC,
  251.     NEWPRODUCT.PRICE,
  252.     NEWPRODUCT.COMMENT,
  253.     NEWPRODUCT.PICTURE,
  254.     NEWPRODUCT.LINKURL,
  255.     BRAND.BRAND,
  256.     TYPE.TYPE
  257. From
  258.     NEWPRODUCT   NEWPRODUCT,
  259.     BRAND   BRAND,
  260.     TYPE   TYPE
  261. Where (
  262.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  263.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  264. )
  265.  
  266. And (
  267.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  268.     )
  269. PRODUCT_ID=1,0,1,0,1
  270. TYPE_ID=1,0,1,0,1
  271. BRAND_ID=1,0,1,0,1
  272. SPEC=0,0,0,0,0
  273. PRICE=1,0,1,0,1
  274. COMMENT=0,0,0,0,0
  275. PICTURE=0,0,0,0,0
  276. LINKURL=0,0,0,0,0
  277. BRAND=0,0,0,0,0
  278. TYPE=0,0,0,0,0
  279. Delete Page<Center>
  280. </Center>
  281. 400Arial9TRUETRUE410TRUE20SimpleDelete PagesQuickSite Delete1clWhite$00D4D4D4$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack10Brand Name5DefaultTRUE[BRAND]-1Model5DefaultTRUE[SPEC]-1Price5DefaultTRUE[PRICE]-1BRAND_ID5DefaultTRUE[BRAND_ID]0COMMENT5DefaultTRUE[COMMENT]0LINKURL5DefaultTRUE[LINKURL]0PICTURE5DefaultTRUE[PICTURE]0PRODUCT_ID5DefaultTRUE[PRODUCT_ID]0TYPE_ID5DefaultTRUE[TYPE_ID]0TYPE5DefaultTRUE[TYPE]0