Exception error has me stumped

Results 1 to 2 of 2

Thread: Exception error has me stumped

  1. #1
    Join Date
    Dec 1969

    Default Exception error has me stumped

    Hello all,<BR><BR>When I execute the line of code:<BR><BR>While cstr(suite) = cstr(rs("suite#"))<BR><BR>Where “suite#” is treated as a string.<BR><BR>I get<BR><BR>error &#039 80020009&#039 <BR>Exception occurred. <BR><BR>I tried to use cint() but I have suite numbers with numeric values that are higher than the 32,767 that the cint() can handle.<BR><BR>If I use the cdbl() then I get the same error as with the cstr(). <BR><BR>Int() doesn’t work.<BR>Cdouble() doesn’t work.<BR><BR>I’ve reached the end of my rope of knowledge.<BR><BR>Thanks for any help that you all can provide.<BR><BR>Jessica

  2. #2
    Join Date
    Dec 1969

    Default RE: Exception error has me stumped

    How about writing out the values just before the WHILE?<BR><BR>Response.Write "[" & suite & "] [" & RS("suite#") & "]&lt;BR&#062;" & vbNewLine<BR><BR>I&#039ve got a sneaking suspicion that it doesn&#039t like RS("suite#"), but let&#039s find out.<BR><BR>

Posting Permissions

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