Home | Advertising Info33 USERS CURRENTLY ONLINE   
   Site Search Contact Us Tuesday, February 25, 2020  

  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
Message << Prev Info | Next Info >>

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> "

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


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 - 2020 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 programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com