inserted

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

inserted

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> inserted

Page: [1]


sgreen0 Posts: 726 From: Long Beach, CA, USA Status: offline	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 Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: inserted - 10/16/2005 19:53:20 If its just a space, then you may want to use : If trim(fieldname) <> "" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem §þk¥ Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to sgreen0)


sgreen0 Posts: 726 From: Long Beach, CA, USA Status: offline	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 (in reply to Spooky)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: inserted - 10/17/2005 0:32:38 Where is the session created? Using the DRW and "fp_fieldval()" inserts a physical   whereas "fp_field()" does not. _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem §þk¥ Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to sgreen0)


sgreen0 Posts: 726 From: Long Beach, CA, USA Status: offline	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. (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP and Database >> inserted

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts