Re: FN-FORUM ASP code help

date posted 12th September 2002 16:59

I can duplicate your results like this:





So RecordSet.Fields("fldAffiliateID") is null!!!

Not the same as vbnull, of course, which returns 1, oddly enough.

HTH

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kathy
http://www.vendetta.co.uk
DNRC Minister for Useful but Irritating Information and Trivia
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
----- Original Message -----
From: "David McEwen" [EMAIL REMOVED]
To: "FN-FORUM" [EMAIL REMOVED]
Sent: Thursday, September 12, 2002 3:37 PM
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]
>