Blank Database Fields

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

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

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

Search Forums

Recent Posts

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

Blank Database Fields

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 >> Blank Database Fields

Page: [1]


Welby Posts: 59 Joined: 11/12/2002 Status: offline	Blank Database Fields - 5/5/2003 9:39:44 Is there a way to ONLY return data in a database (Using DRW) that have values? In looking at the DATABASE (SQL 2000) the field are <NULL>. Is there any way to only return the fields in a record that actually have data in them? I' ve played around with multiple Select Statements, but so far I havn' t had any luck hitting the combination (if there is one) to NOT return NULL values. After posting this - I did run across this tip: http://www.frontpagewebmaster.com/tm.asp?m=83377&appid=&p=&mpage=1&key=blank&language=single&tmode=&smode=&s=#83377 and that seems to be what I want to do (it' s a confirmation page - and I ONLY want to show NON <NULL> values. But I' m not sure where to put the information that is in the reply. My confirmation page IS a custom Query in the DRW to return the data. Ok - this is EDIT number 2. The problem with the confirmation page is this. When there is NO data in a field - then the fieldname itself is returned - with a blank spot next to it. I' m trying to get this so that there is NOT a field name at all. (just trying to make myself as clear as possible) Thanks in advance. Welby < Message edited by welby -- 5/5/2003 9:52 AM >


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Blank Database Fields - 5/5/2003 23:05:03 Im not sure if you have a display problem or a query problem? You may want to specify " COLUMN IS NOT NULL " in the SQL, or if its a display problem, use asp to weed out the blank values. To do that, youll need the diet and make sure you use FP_Field() and not FP_FieldVal() as it places a default space for blank records. _____________________________ 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 Welby)


Welby Posts: 59 Joined: 11/12/2002 Status: offline	RE: Blank Database Fields - 5/6/2003 9:19:10 Ok - sorry - Its not the confirmation page that' s the problem - it' s when I pull up a record from the database. It returns all fields. I think it is a SQL statement issue. I' ve (I think) attached a screenshot of the results. Is there a way in SQL to specify ONLY populated fields when returning records? < Message edited by welby -- 5/6/2003 9:23 AM > (in reply to Welby)