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 March 12th, 2008, 03:41 AM
Registered User
 
Join Date: Mar 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default combo box problems

I'm using dreamweaver mx with asp pages.the problem i have is my combo box does not display the whole text when the user selects the value in the combo box:(.i'm using ms-access database to populate data to combo box.this fields have qoutes in in between.my combo box cuts the text after the combo box. heres my code for getting data out from the table called criticality.

<td>*New Criticality Code:</td>
      <td>
          <%Set newcritcode_data=db.Execute("Select * from tblcriticality order by description")%>
          <select name="cboNewcritCode">
          <option value="same"> Select new crit code</option>
          <%Do While Not newcritcode_data.EOF%>
          <option value="<%=newcritcode_data("name")%>"><%=newcritco de_data("description")&" - " &newcritcode_data("Name")%></option>
          <%newcritcode_data.MoveNext
          Loop
          Set newcritcode_data=nothing%>
          </select>
the code gets data from the table criticality.it cuts the text in description field after the quotes.

 
Old March 12th, 2008, 05:51 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

I dont understand this part:

;;;this fields have qoutes in in between.my combo box cuts the text after the combo box.

Wind is your friend
Matt
www.elitemarquees.com.au
 
Old March 21st, 2008, 05:05 AM
Authorized User
 
Join Date: Mar 2008
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi,

Might be your description field contains single quate and hope you know that in ASP single quate is using for comments so when single quate comes in the discription field it is making comment after single quate.

Check your code is it containing quate or not?

Hope this will help you.








Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate a text box from a combo box value dnf999 Access VBA 7 February 6th, 2012 02:24 PM
Combo box to display items from parent combo box Gini Visual Studio 2008 0 June 18th, 2008 12:30 AM
Count in combo box(display results in text box) mboyisis Access 4 April 4th, 2008 07:08 AM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
Populate List Box by Combo Box Selection mmcdonal Access 2 June 15th, 2004 12:08 PM





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