[thelist] MS Access to SQL Server: METAFILE Images (LONG!)

[darren]

On 28 September 2001 at 16:05:53, Janet Nabring-Stager <jnabring at yahoo.com> wrote:

JNS> You all are great :)
JNS> But sadly, it's still not working :(

JNS> I also tried:  <% Do While Not rs.EOF %> <option value="<%=
JNS> FormatDateTime(rs("Date_of_Issue"),vbLongDate) %>">

this should be the correct format...as long as you have the correct value
for vbLongDate (it should be = 1).

JNS> This threw MS VBScript runtime error '800a000d' Type
JNS> Mismatch:'FormatDateTime'/search.asp, line 177

hmmm...i can't remember the original post, but you're certain that all
the values coming back are valid dates??

and you might want to try:

   Do While Not rs.EOF
      Response.Write "<option value=""" & rs("Date_of_Issue") & """>" & _
         FormatDateTime(rs("Date_of_Issue"), vbLongDate) & "</option>"

or maybe you need to convert the value to a date....

      Response.Write "<option value=""" & rs("Date_of_Issue") & """>" & _
         FormatDateTime(CDate(rs("Date_of_Issue")), vbLongDate) & _
         "</option>"


to give you the formatted date in the dropdown and the unformatted
version it's value.  it could make things a lot easier if you use the
date to requery the db.

JNS> <!-- #INCLUDE file = "adovbs.inc" -->
JNS> <!-- METADATA TYPE="typelib"
JNS>                 FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->

both of these include the same constants hence the error.  use one or the
other, not both.

does anyone know if there is any advantage to using the metadata??
personally i use a severely chopped down adovbs.inc...

hth,

darren.