Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 13th, 2004, 10:50 PM
Registered User
 
Join Date: Apr 2004
Location: , , .
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>
<%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

Reply With Quote
  #2 (permalink)  
Old April 15th, 2004, 03:42 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #3 (permalink)  
Old April 16th, 2004, 10:24 PM
Registered User
 
Join Date: Apr 2004
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 ;)

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 10:51 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.