Hi,
I have a form with five Select Lists (say
SL1,SL2,SL3,SL4,SL5) that I use to build query. All of
them are populated from a database table. I want the
user to select one or more items from these Select
lists based on their requirements.
When I build query on these user selection, I get the
following error:
"Error resolving parameter Form.SL1" ...SL5
If I select an item from all 5 lists, my query works
fine. If I leave any list without selection then I get
the above error. Please let me know the correct SQL to
handle this situation.
Thanks,
Navaneethan
__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
