Skip to main content
I
iandobie
Known Participant
July 6, 2006
Question

How can I pass empty value in URL Parameter

  • July 6, 2006
  • 1 reply
  • 1267 views
Hi,
I am passing different URL parameters to one page, to filter the recordset on that page. How can I pass an empty value in the URL parameter so that the recordset in unfiltered?
The URL parameter is based on one field of the database: ContentType. So, the link would be to
default.asp?ContentType=Event
and then all records that have the ContentType field in the DB as Event are displayed. Is it possible to use this system to pass an empty parameter so that all records are displayed?
Thanks
Ian
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
July 6, 2006
?ContentType=All

<% if (ContentType == "All")
Build recordset w/o filtering

ASP is rusty, but those are the basics.
"iandobie" <webforumsuser@macromedia.com> wrote in message
news:e8im80$q7m$1@forums.macromedia.com...
> Hi,
> I am passing different URL parameters to one page, to filter the recordset
> on
> that page. How can I pass an empty value in the URL parameter so that the
> recordset in unfiltered?
> The URL parameter is based on one field of the database: ContentType. So,
> the
> link would be to
> default.asp?ContentType=Event
> and then all records that have the ContentType field in the DB as Event
> are
> displayed. Is it possible to use this system to pass an empty parameter so
> that
> all records are displayed?
> Thanks
> Ian
>


I
iandobieAuthor
Known Participant
July 6, 2006
Hi Crash,
thanks for that - but how/where would I specify the 'if URL Parameter 'ContentType' is passed as 'All' then build unfiltered recordset' statement? Is this something i can do through the dreaweaver interface, or would I put the code in by hand at some specific point?
The code is HERE
Thanks
Ian
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices