Would you look at this code, please

Results 1 to 2 of 2

Thread: Would you look at this code, please

  1. #1
    NewASPer Guest

    Default Would you look at this code, please

    &#060;%Option Explicit%&#062;<BR>&#060;!--include file="ADOVBS.inc"--&#062;<BR>&#060;!--#include virtual= "/skywebii/functions.asp"--&#062;<BR>&#060;%<BR>set dbcn=server.creatobject("adodb.connection")<BR>dbc n.open session ("dbconn")<BR>set dbrs=server.CreateObject("adodb.recordset")<BR>dbr s.activeconnection=dbcn<BR>dbrs.open "Select * from Skyweb_Contact where deparmentId=&#039 2&#039"<BR>Response.Write RecToTable (dbcn)<BR>dbrs.close<BR>dbcn.close<BR>set dbrs=nothing<BR>set dbcn=nothing<BR>%&#062;<BR>I am trying to create a contact list for every department in the company. I was thinking about creating a procedure, that would pick the correct department contact list to display. All advice and critisim is welcome. thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: Would you look at this code, please

    If my guess is correct then deparmentId is AutoNumber or Integer, and you don&#039t need "&#039" arround 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts