Home | Advertising Info42 USERS CURRENTLY ONLINE   
   Site Search Contact Us Saturday, July 02, 2022  

  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 - 2022 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 search engine active server page asp application components tutorial CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com