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>
<%adoRSNames.MoveNext
  Loop%>
Qn:
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!
NUR

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.

Cheers!

-Vijay G

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.Open
objStream.Type = adTypeBinary
objStream.LoadFromFile strFilePath

Response.BinaryWrite objStream.Read

objStream.Close
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 ;)