var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: where is the record ?
I have a problem that I can't seem to figure out.
This statement gives me a recordset called rsValves
Select * From qryVentilerOchPlatser Where vDelnr LIKE 'DM%' And pId is not Null Order by vDelnr
and this line of could should give me the following printout, right ?
Response.Write rsValves("vID") & " | " & rsValves("vDelnr") & " | " & rsValves("vFabrikat")
Printout: 6070 | DM001 | NAF
but instead I get this
6070 | | NAF
why is the middle column missing ???
Please, help !!
I would suspect that your problem is caused by one of two things:
1) The value of the field is NULL
2) The field was previously reference in the recordset, and because of certain settings for your connection/recordset the value was cleared out.
Set myRS = myConn.Execute("SELECT f1, f2 FROM t1")
If myRS("f1") = "yes" Then
Response.Write("f1 = " & myRS("f1"))
Response.Write("f2 = " & myRS("f2"))
If f1 is "yes" then you will see the following on the page:
This happens because the value was cleared out of the recordset when it was reference in the If Expression.
Hope this helps...
Ahh, it's cleared out?!?!
Well, you live you learn...