inserted (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

sgreen0 ->   inserted (10/16/2005 16:39:40)

I've created a script that collects data from one table and inserts them into another.

When any of the fields are empty, I find a & n b s p ; (spaces added so you can see it) in the field. I tried using an If fieldname <> "" then, but the same thing happens.

Any ideas why this is happening or on how to avoid it?

Stephen



Spooky -> RE: inserted (10/16/2005 19:53:20)

If its just a space, then you may want to use :

If trim(fieldname) <> ""



sgreen0 -> RE: inserted (10/16/2005 21:01:51)

Well, I tried:

If trim(Session("WebSite")) <> "" Then
Rs("WebSite") = Session("WebSite")
End If

and

If trim(Session("WebSite")) <> "" Then
Rs("WebSite") = trim(Session("WebSite"))
End If

It still inserts & n b s p ; in the table.

It's not really serious, just annoying.

Stephen



Spooky -> RE: inserted (10/17/2005 0:32:38)

Where is the session created?
Using the DRW and "fp_fieldval()" inserts a physical &nbsp; whereas "fp_field()" does not.



sgreen0 -> RE: inserted (10/17/2005 0:56:57)

AHA!

I've been using FieldVal().

What are the differences/benefits of using Field(), or FieldVal(), or FieldHTML(), or...???

S.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875