Pass id to stored procedure and if 0 rows ret'd, want to launch popup 1

[Coder7]

Here's where I need assistance, please:

I am passing a 'transaction id' value to an sql server stored procedure that will return all rows that have that transaction id.

If rows are returned, I display the data in an html table.

If no rows are returned, I need to display a data entry window (html table).

How do I get the data entry window to display using if/else logic in my vbscript?
-------------------
If NOT ( objRs.BOF And objRs.EOF ) Then
Call writeRecords(pPgNbr, objRs)
Else
=====>>>>>>>>>>HERE IS WHERE I WANT MAKE THE DATA ENTRY WINDOW POP UP
End If

Thanks for any assistance.

 

[jemminger]

hi Coder7,

here's how i usually do it:
[tt]
If NOT ( objRs.BOF And objRs.EOF ) Then
Call writeRecords(pPgNbr, objRs)
Else
response.write(&quot;<script language=javascript>window.open('dataEntryWindow.html','win','[window attrs go here]');</script>&quot
End If
[/tt]

hope this helps
=========================================================
if (!succeed) try();
-jeff

 

[Coder7]

That was great!! Thanks very much. Now I'm on the correct asp page, I just have to get my vbscript subs to fire to that the data entry form is loaded. Concatenating the languages is very confusing to neophytes like me.

I'll be back if I get stuck again.

Have a great day!!