Home | Advertising Info93 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Thursday, January 16, 2025  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - General
 PowerASP Code Help Area : Classic ASP - General
Subject Info: access to aditional data after an option A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Info: 27
Added: March/27/2005 at 6:31pm | IP Logged Quote mjunior
Hi guys, I have a new issue I'd like some help..
I have a form that I use a few option selections from DB table and a insert script at the end.
I'd like to have access to aditional info from the same table after choose an option.
Any clue?



__________________
mjunior(dumb)
Back to Top View mjunior's Profile Search for other info by mjunior
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: March/28/2005 at 1:24am | IP Logged Quote cwilliams

If I understand what you are asking about this is an article on how to do it

http://www.4guysfromrolla.com/webtech/101099-1.shtml



__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Info: 27
Added: March/29/2005 at 4:41pm | IP Logged Quote mjunior
Hi Chris,
sorry but that situation was quite diferent...what I need is only have access to the other corraleted variables from tab..
Seems prety simple in theory, just adding another sql statement after chosen the option value..but I have a no object error everytime..

Below you see the var "cliente" that I want to chose from tab_cliente db and after I need to have access to all the row data on the chosen "cliente" from the same tab..

<select name="cliente" style="{<font-family:Verdana; font-size:12}">
        <%
                Dim rscliente
                Set rscliente = Server.CreateObject("ADODB.Recordset")
                rscliente.Open "SELECT * FROM tab_cliente", conBD
                %>
                <% If cadastrado="" then %>
        <option value="" selected>Selecione o cliente</option>
          
           <% Else %>
           <option value="<%=cadastrado%>" selected><%=cadastrado%></option>
           <%
           End if%>
        <%
                Do While Not rscliente.Eof
                %>
        <option value="<%response.Write rscliente.Fields("cliente")%>">
        <%response.Write rscliente.Fields("cliente")%>
        </option>
        <%
                rscliente.MoveNext
                Loop
                rscliente.close
                Set rscliente = Nothing
                %>
      </select>

__________________
mjunior(dumb)
Back to Top View mjunior's Profile Search for other info by mjunior
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: March/29/2005 at 8:19pm | IP Logged Quote cwilliams

humm, well its more than I can get into
just do not have time

have you read through some of this

Forms

Populating a drop down menu with info from a database
Populating a check box with info from a database
Populating radio buttons with info from a database



__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Info: 27
Added: March/30/2005 at 7:49am | IP Logged Quote mjunior
Thanks Chris,

The links aren't corraleted to my doubt. I'll keep trying from scratch.

__________________
mjunior(dumb)
Back to Top View mjunior's Profile Search for other info by mjunior
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: March/30/2005 at 2:58pm | IP Logged Quote cwilliams

sorry, I just have zero clue what you are trying to do based on the things you have explained and the wording you are using..

"I need is only have access to the other corraleted variables from tab"  ??

"corraleted to my doubt"  ??

Perhaps someone else will chime in and try to help.  I just don't understand totally what you are asking.



__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 

Page of 2 Next >>
  A d d - P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
 Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2025 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
 STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com