Re: FN-FORUM ASP code help

date posted 12th September 2002 17:00

It's not blank, it's null!!

Not the same at all.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kathy
http://www.vendetta.co.uk
DNRC Minister for Useful but Irritating Information and Trivia
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
----- Original Message -----
From: "David McEwen" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, September 12, 2002 4:22 PM
Subject: Re: FN-FORUM ASP code help


> The content of that field is blank which is why I'm expecting "None" in
the
> output, and yes, the rest of the fields in the record set have data in
them.
>
> ----- Original Message -----
> From: "Andrew Yorkshades" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Thursday, September 12, 2002 3:53 PM
> Subject: RE: FN-FORUM ASP code help
>
>
> Are you sure that there's a value in fldAffiliateID, or that you've got a
> populated resultset?
>
> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] Behalf Of David McEwen
> Sent: 12 September 2002 15:38
> To: FN-FORUM
> Subject: FN-FORUM ASP code help
>
>
> HELP! Below is a piece of ASP/VBScript code that I've written, it's a
> pretty simple piece of code, but I'm not getting the output that I'd
expect.
> I've looked at it, looked at it again, gone away, come back and looked at
it
> some more, but either I've got a mental block or my computer is a mental
> block. Can anyone see where I'm going wrong?
>
> Program code:
>
> strAffiliateID = RecordSet.Fields("fldAffiliateID")
> Response.Write( "*" & len( trim( strAffiliateID)) & "*")
> Response.Write( "*" & strAffiliateID & "*")
>
> If len( trim( strAffiliateID)) = 0 Then
> Response.Write( "None")
> Else
> Response.Write( strAffiliateID & "hello")
> End If
> %>
>
>
> Output:
>
> ****hello
>
>
>
>
>
> ============================================================
> = Advanced web hosting solutions from Saffas. =
> = Unix, PHP, mySQL, SSL, Perl, Control Panel, 24/7 access. =
> = Why pay more for less? http://www.saffas.com =
> ============================================================
>
> Sponsor the forum for as little as £1 at:
>
> http://www.freelancers.net/cgi/sponsor.cgi?action=show
>
>
> Advertise with Freelancers.net +Additions+
>
> http://www.freelancers.net/advert.php
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
>
> ============================================================
> = Advanced web hosting solutions from Saffas. =
> = Unix, PHP, mySQL, SSL, Perl, Control Panel, 24/7 access. =
> = Why pay more for less? http://www.saffas.com =
> ============================================================
>
> Sponsor the forum for as little as £1 at:
>
> http://www.freelancers.net/cgi/sponsor.cgi?action=show
>
>
> Advertise with Freelancers.net +Additions+
>
> http://www.freelancers.net/advert.php
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
>
>
>
> ============================================================
> = Advanced web hosting solutions from Saffas. =
> = Unix, PHP, mySQL, SSL, Perl, Control Panel, 24/7 access. =
> = Why pay more for less? http://www.saffas.com =
> ============================================================
>
> Sponsor the forum for as little as £1 at:
>
> http://www.freelancers.net/cgi/sponsor.cgi?action=show
>
>
> Advertise with Freelancers.net +Additions+
>
> http://www.freelancers.net/advert.php
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>