Default value to var from listbox

Results 1 to 2 of 2

Thread: Default value to var from listbox

  1. #1
    Tom Cowley Guest

    Default Default value to var from listbox

    Hi all,<BR><BR>I have the following dilemma.<BR><BR>I have a page that loads with an error . It cannot convert varchar to numeric.<BR>The problem as i see it - my sql statement requires default values as the page loads to run this query. On load this does not exist.<BR>I have two listboxes from which the user must do selections after the first load to run the report as they require it.<BR>How do i go and set the defaults so that the sql query can use it on the first page load?<BR><BR>Please HELP!!<BR><BR>Tom

  2. #2
    Join Date
    Dec 1969

    Default RE: Default value to var from listbox

    if var1="" then<BR>var1=defaultvalue<BR>end if<BR><BR>use var1 in ur sql can only be empty when the page initially loads.else u have the selected value for var1 from the listbox.

Posting Permissions

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