var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql, rst with no record.
I have these lines of sql code populating serveral recordsets.
sqlMastLine = (Nz("select * from Mast_Detail_Line, QuoteMast where cstr(Mast_Detail_Line.Quote_Detail_ID) =" + CStr(strDetail) + " AND Mast_Detail_Line.Mast_ID = QuoteMast.ID"))
several similar lines.
Then i have loops that will write the recordset data to a word document, but the loops through out errors if the resordset has no data in it!
How can i get around this, so it just misses the loop.
Im using "DO While not rstMachine.EOF" loops. i get an error telling me that the EOF or BOF condition is true and it request a current record. Is there another way i can perform this.
If Im not very clear just ask for more information. ALways keen to share.
Thanks for your help everyone.
To avoid the loop is no records exist place an if statement around your loop.
If not rstMachine.BOF or Not rstMachine.eof then
thats really obviouse......Duh