home *** CD-ROM | disk | FTP | other *** search
/ Internet Magazine 2002 December / INTERNET97.ISO / pc / software / windows / building / dbqwiksite / dbqwiksitepro.exe / %MAINDIR% / Projects / DBQwikSiteSample2.dbh < prev    next >
Encoding:
Text File  |  2002-09-09  |  11.1 KB  |  280 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=27
  24. Table0.Left=53
  25. Table0.Height=193
  26. Table0.Width=174
  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=15
  60. Table1.Left=463
  61. Table1.Height=200
  62. Table1.Width=120
  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=155
  77. Table2.Left=326
  78. Table2.Height=200
  79. Table2.Width=120
  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. </Center>
  140. 311Arial9FALSETRUE410TRUE3PlainCatalogsQuickSite Catalog2clWhiteclWhite$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00D9FFFFclWhiteclBlack6ProductName0DefaultTRUE[BRAND]0ProductImage1DefaultTRUE[PICTURE]1[LINKURL]Code0DefaultTRUE[PRODUCT_ID]0Model0DefaultTRUE[SPEC]0ProductDescription0DefaultTRUE[COMMENT]0Price0DefaultTRUE[PRICE]0Select
  141.     NEWPRODUCT.PRODUCT_ID,
  142.     NEWPRODUCT.TYPE_ID,
  143.     NEWPRODUCT.BRAND_ID,
  144.     NEWPRODUCT.SPEC,
  145.     NEWPRODUCT.PRICE,
  146.     NEWPRODUCT.COMMENT,
  147.     NEWPRODUCT.PICTURE,
  148.     NEWPRODUCT.LINKURL,
  149.     BRAND.BRAND,
  150.     TYPE.TYPE
  151. From
  152.     NEWPRODUCT   NEWPRODUCT,
  153.     BRAND   BRAND,
  154.     TYPE   TYPE
  155. Where (
  156.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  157.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  158. )
  159.  
  160. And (
  161.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  162.     )
  163. PRODUCT_ID=1,0,1,0,1
  164. TYPE_ID=1,0,1,0,1
  165. BRAND_ID=1,0,1,0,1
  166. SPEC=0,0,0,0,0
  167. PRICE=1,0,1,0,1
  168. COMMENT=0,0,0,0,0
  169. PICTURE=0,0,0,0,0
  170. LINKURL=0,0,0,0,0
  171. BRAND=0,0,0,0,0
  172. TYPE=0,0,0,0,0
  173. Search Page<Center>
  174. </Center>
  175. 100Arial9TRUETRUE410TRUE20SimpleSearch PagesQuickSite Search1clWhite$00D4D4D4$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack10Brand Name2DefaultTRUE[BRAND]0Code2DefaultTRUE[PRODUCT_ID]0Model2DefaultTRUE[SPEC]0Price2DefaultTRUE[PRICE]0BRAND_ID2DefaultTRUE[BRAND_ID]0COMMENT2DefaultTRUE[COMMENT]0LINKURL2DefaultTRUE[LINKURL]0PICTURE2DefaultTRUE[PICTURE]0TYPE_ID2DefaultTRUE[TYPE_ID]0TYPE2DefaultTRUE[TYPE]0Select
  176.     NEWPRODUCT.PRODUCT_ID,
  177.     NEWPRODUCT.TYPE_ID,
  178.     NEWPRODUCT.BRAND_ID,
  179.     NEWPRODUCT.SPEC,
  180.     NEWPRODUCT.PRICE,
  181.     NEWPRODUCT.COMMENT,
  182.     NEWPRODUCT.PICTURE,
  183.     NEWPRODUCT.LINKURL,
  184.     BRAND.BRAND,
  185.     TYPE.TYPE
  186. From
  187.     NEWPRODUCT   NEWPRODUCT,
  188.     BRAND   BRAND,
  189.     TYPE   TYPE
  190. Where (
  191.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  192.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  193. )
  194.  
  195. And (
  196.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  197.     )
  198. PRODUCT_ID=1,0,1,0,1
  199. TYPE_ID=1,0,1,0,1
  200. BRAND_ID=1,0,1,0,1
  201. SPEC=0,0,0,0,0
  202. PRICE=1,0,1,0,1
  203. COMMENT=0,0,0,0,0
  204. PICTURE=0,0,0,0,0
  205. LINKURL=0,0,0,0,0
  206. BRAND=0,0,0,0,0
  207. TYPE=0,0,0,0,0
  208. Add Page<Center>
  209. </Center>
  210. 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
  211.     NEWPRODUCT.PRODUCT_ID,
  212.     NEWPRODUCT.TYPE_ID,
  213.     NEWPRODUCT.BRAND_ID,
  214.     NEWPRODUCT.SPEC,
  215.     NEWPRODUCT.PRICE,
  216.     NEWPRODUCT.COMMENT,
  217.     NEWPRODUCT.PICTURE,
  218.     NEWPRODUCT.LINKURL,
  219.     BRAND.BRAND,
  220.     TYPE.TYPE
  221. From
  222.     NEWPRODUCT   NEWPRODUCT,
  223.     BRAND   BRAND,
  224.     TYPE   TYPE
  225. Where (
  226.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  227.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  228. )
  229.  
  230. And (
  231.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  232.     )
  233. PRODUCT_ID=1,0,1,0,1
  234. TYPE_ID=1,0,1,0,1
  235. BRAND_ID=1,0,1,0,1
  236. SPEC=0,0,0,0,0
  237. PRICE=1,0,1,0,1
  238. COMMENT=0,0,0,0,0
  239. PICTURE=0,0,0,0,0
  240. LINKURL=0,0,0,0,0
  241. BRAND=0,0,0,0,0
  242. TYPE=0,0,0,0,0
  243. Edit Page<Center>
  244. </Center>
  245. 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
  246.     NEWPRODUCT.PRODUCT_ID,
  247.     NEWPRODUCT.TYPE_ID,
  248.     NEWPRODUCT.BRAND_ID,
  249.     NEWPRODUCT.SPEC,
  250.     NEWPRODUCT.PRICE,
  251.     NEWPRODUCT.COMMENT,
  252.     NEWPRODUCT.PICTURE,
  253.     NEWPRODUCT.LINKURL,
  254.     BRAND.BRAND,
  255.     TYPE.TYPE
  256. From
  257.     NEWPRODUCT   NEWPRODUCT,
  258.     BRAND   BRAND,
  259.     TYPE   TYPE
  260. Where (
  261.             NEWPRODUCT.BRAND_ID = BRAND.BRAND_ID
  262.     And    NEWPRODUCT.TYPE_ID = TYPE.TYPE_ID
  263. )
  264.  
  265. And (
  266.      ( NEWPRODUCT.BRAND_ID = 1 ) 
  267.     )
  268. PRODUCT_ID=1,0,1,0,1
  269. TYPE_ID=1,0,1,0,1
  270. BRAND_ID=1,0,1,0,1
  271. SPEC=0,0,0,0,0
  272. PRICE=1,0,1,0,1
  273. COMMENT=0,0,0,0,0
  274. PICTURE=0,0,0,0,0
  275. LINKURL=0,0,0,0,0
  276. BRAND=0,0,0,0,0
  277. TYPE=0,0,0,0,0
  278. Delete Page<Center>
  279. </Center>
  280. 400Arial9TRUETRUE410TRUE20SimpleDelete PagesQuickSite Delete1clWhite$00D4D4D4$20000000clBlackclRedclPurpleclBlue$00BB7D40clWhite$00E1FFFFclWhiteclBlack10PRODUCT_ID5DefaultTRUE[PRODUCT_ID]0TYPE_ID5DefaultTRUE[TYPE_ID]0BRAND_ID5DefaultTRUE[BRAND_ID]0SPEC5DefaultTRUE[SPEC]0PRICE5DefaultTRUE[PRICE]0COMMENT5DefaultTRUE[COMMENT]0PICTURE5DefaultTRUE[PICTURE]0LINKURL5DefaultTRUE[LINKURL]0BRAND5DefaultTRUE[BRAND]0TYPE5DefaultTRUE[TYPE]0