Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 13th, 2004, 10:50 PM
Registered User
Join Date: Apr 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Populated dropdown and database

hi all,
I need help with my populated dropdown list.
ASP and VBscript:
<%Do Until adoRSNames.EOF %>'Populate drop-down
<option value="<%= adoRSNames.Fields("CategoryName").Value %>">
<%= adoRSNames.Fields("CategoryName").Value %></option>
1. How do i allow the category selected by user to be store in database?
2. How do i filter the category field?
3. How to make the system auto-create a folder with the respective category names stored in the database?

Thanks... sorry but its URGENT!

Old April 15th, 2004, 03:42 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

Your post seems to be very generic. Please post it in a little more specific way, so as to know what you are exactly looking for and understand your level better.

1) if you have the category a CategoryID, you can show the Category in the dropdown and have its value as its corresponding categoryId, and use this categoryId to be stored in database, when the user submits it.

2) I am not sure what you mean here. Can you explain with examples please?

3) You can use FileSystemObject in this case. Need more info on this too to help you better.


-Vijay G
Old April 16th, 2004, 10:24 PM
Registered User
Join Date: Apr 2004
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts

Hi Vijay,
I managed to solve my previous post problem...
But I need to know the followings:

1. Does this Function Property alike to ADO Property Method?

Public Property Get BLOB()
  BLOB = BinaryData
End Property

2. Is this the right way to AppendChunk using Stream Method?
Response.ContentType = "application/x-msexcel"

Const adTypeBinary = 1
Dim strFilePath

strFilePath = "C:\ExcelFiles\Excel1.xls" 'This is the path to the file on disk.

Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = adTypeBinary
objStream.LoadFromFile strFilePath

Response.BinaryWrite objStream.Read

Set objStream = Nothing
  • Qn:
  • how do i use the ".ContentType" method on the ADO Stream OBJECT?
  • can i use the getBlob method with ADO Stream Object
2. Why can't I use the Request Method after BinaryRead Method? How can I make it work?

Sorry for the trouble..

Thx ;)

Similar Threads
Thread Thread Starter Forum Replies Last Post
TWO DROPDOWNLISTS POPULATED FROM DATABASE hunzian78@yahoo.com ASP.NET 1.0 and 1.1 Basics 6 April 12th, 2006 02:38 AM
Combo Box Populated off Database Firehawk2006 Visual Basic 2005 Basics 1 November 28th, 2005 01:47 PM
Store Items from dropdown menu in mysql database scoobie PHP Databases 0 April 28th, 2005 08:17 AM
Value not being populated in Text Box ashu_gupta75 Classic ASP Basics 2 April 19th, 2004 11:21 PM
Two data items from a populated dropdown menu bear1138 Dreamweaver (all versions) 1 August 13th, 2003 09:52 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.