ASP and ADO: empty fields

Results 1 to 4 of 4

Thread: ASP and ADO: empty fields

  1. #1
    Ute Freimann Guest

    Default ASP and ADO: empty fields

    When I sent a database SELECT request to the server, sometimes I doesn&#039t get a correct result, some fields of the recordset remain empty, but there is no error message:<BR><BR>&#060;%<BR>db.Provider = db_driver<BR>db.Open connect_string<BR>.....<BR>set db = Server.CreateObject("ADODB.Connection")<BR>set rs = db.Execute(sql)<BR>%&#062;<BR><BR>When executing this querry sometimes one or several fields <BR>rs("xxx") are emtpy.<BR>The application is running with IIS 4.0, DB2 and ibmdadb2.dll.

  2. #2
    MG Guest

    Default What's the question

    You made some statement but no question. Have you checked the data in the database. Maybe there is not any data in those fields on that record.

  3. #3
    Join Date
    Dec 1969

    Default RE: ASP and ADO: empty fields

    Hi,<BR>Is the String field coming Blank ?<BR>If so , try using this VBscript Function<BR><BR>Abc = Format(rs.fields(XXX))<BR><BR>good luck<BR>

  4. #4
    Ute Freimann Guest

    Default RE: What's the question

    In the database there is data in these fields ! But sometimes the rs(xxx) don&#039t have the data. Othertimes they have.

Posting Permissions

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