Re: Classes functions....help!

From: Ray Costanzo [MVP] (my)
Date: 09/20/04


Date: Sun, 19 Sep 2004 21:23:30 -0400

Not to take anything away from what Kevin said, but one possibility,
depending on your database type/design, you could construct a query as such:

SELECT LinkTitle,ISNULL(LinkHref,'Sorry, no link available.') FROM Links

Ray at home

"Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
news:OscOhGPnEHA.2612@TK2MSFTNGP15.phx.gbl...
> Hi All,
>
> I'm new to asp.net (Migrating from 'Classic' ASP)
>
> I'm having troubles working out classes, functions etc...
>
> Current situation is this:
>
> index.aspx displays datalist with links to sites - If no link found in DB,
> I want to display a message instead. I worked out I need a function to do
> this (No if statements based around DB values allowed in datalist)
>
> Questions are:
> - Where do i build the function? In a seperate class file? In the code
> behind for index.aspx?
>
> - How do I then call this function/class? I understand the syntax of
> actually calling the function, its more a case of how do I make the
> function/class available to index.aspx?
>
> - How do I return a value from the function/class? I want to input 2
> values - ID and Domain, if domain is empty, I want to return 'No Site
> Listed' if not, I want to return the domain.
>
>
> Sorry if this is all a bit vague - I may well be asking the wrong
> questions???!
>
> Thanks,
> Simon.
>



Relevant Pages

  • Re: Is there a better way?
    ... Kevin, based on what was written, there would be no nested loop on the page, ... second query to the Contact table using the same Company ID to retrieve the ... >> To assist you in getting the best answers for FrontPage support see: ...
    (microsoft.public.frontpage.client)
  • Re: Referincing Fields
    ... depending on the path and there are about 50 of these types of fields I am ... a query that will create a single units field in my query that will ... than going in and trying to edit a nested Iff statement(I currently have ...
    (microsoft.public.access.modulesdaovba)
  • Re: cant get more stupid then this..
    ... The name of the form field must exactly ... > match the value you type in in the Custom Query. ... > Kevin Spencer ...
    (microsoft.public.frontpage.programming)
  • Re: Multiply Query
    ... criteria field on the query back to the dialog form i've created. ... depending on what the other criteria ... If some of these controls are textboxes which may be ... I have found it useful to divide up the SQL string into substrings ...
    (microsoft.public.access.formscoding)
  • Re: different results of query from different workstations
    ... The query converts a txt-field into a date format with the following ... General Date will have variable appearance depending on the computer's ... if your intention is to find all values more recent than 26 hours ago. ...
    (microsoft.public.access.queries)