Home | Advertising Info151 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Thursday, December 14, 2017  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
ASP.NET - Scripting VB
 PowerASP Code Help Area : ASP.NET - Scripting VB
Subject Info: how to add tw fields from MS-ACCESS A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
bobo
Newbie
Newbie
Avatar

Joined: June/13/2006
Location: Kuwait
Online Status: Offline
Info: 1
Added: June/13/2006 at 1:34am | IP Logged Quote bobo

this is my code...and i want the code to display two fields together concatenate them in the list box that is the code and description...when i run it with in the browser displays a Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'

<form name="frmSelect" method="Post" action="test2.asp">

<SELECT name=exmp LANGUAGE=javascript onchange="return dept_onchange(frmSelect)">
<%  
 Set oRs=Server.CreateObject("adodb.recordset")
 strSQL = "SELECT code ,description FROM projects"
 oRs.Open strSQL, conn  
  
 Do while not oRs.EOF
  if Request.Form("code") = oRs("Code") then
   Response.Write ("<option value=" & oRs.Fields("code") & ">" & oRs.Fields("description") & "</option> "
   oRs.MoveNext
  else

   Response.Write ("<option value=" & oRs.Fields("code") & ">" & oRs.Fields("description") & "</option> "
   oRs.MoveNext
  end if
 loop  
 %>


</SELECT>



__________________
BoBo
Back to Top View bobo's Profile Search for other info by bobo
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  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 - 2017 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 help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com